trees

33 rows where PlotSize = "Width 4ft" and qSpecies_id = 98

✎ View and edit SQL

This data as json, CSV (advanced)

PlotSize ✖

  • Width 4ft · 33 ✖
rowid ▼ TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
8147 215734 DPW Maintained 1 Ulmus spp :: Elm Spp 98 51 Sotelo Ave 11 Sidewalk: Curb side : Yard Tree Private 2     17 Width 4ft   5993894.07462 2101226.9551 37.7492181562944 -122.463928012569 (37.7492181562944, -122.463928012569) 1 8 4 29491 40
19487 215735 DPW Maintained 1 Ulmus spp :: Elm Spp 98 51 Sotelo Ave 10 Sidewalk: Curb side : Yard Tree Private 2     24 Width 4ft   5993894.80081 2101261.55452 37.749313199351 -122.463928012577 (37.749313199351, -122.463928012577) 1 8 4 29491 40
21668 215728 DPW Maintained 1 Ulmus spp :: Elm Spp 98 65 Marcela Ave 3 Sidewalk: Curb side : Yard Tree Private 2     15 Width 4ft   5994684.73982 2100649.30829 37.7476776176257 -122.461152033848 (37.7476776176257, -122.461152033848) 1 8 4 29491 40
36761 215661 DPW Maintained 1 Ulmus spp :: Elm Spp 98 571 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 4ft   5992826.04093 2099395.61373 37.7441281527051 -122.467488102117 (37.7441281527051, -122.467488102117) 1 8 4 29491 40
41015 123806 DPW Maintained 1 Ulmus spp :: Elm Spp 98 2201 Anza St 1 Sidewalk: Curb side : Yard Tree Private 2     33 Width 4ft   5991819.84372 2111992.27633 37.7786571107845 -122.471885160871 (37.7786571107845, -122.471885160871) 11 6 2 54 11
41089 215729 DPW Maintained 1 Ulmus spp :: Elm Spp 98 65 Marcela Ave 4 Sidewalk: Curb side : Yard Tree Private 2     14 Width 4ft   5994692.19949 2100656.92299 37.7476989549588 -122.461126790771 (37.7476989549588, -122.461126790771) 1 8 4 29491 40
58745 123328 DPW Maintained 1 Ulmus spp :: Elm Spp 98 767 04th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     11 Width 4ft   5994719.57081 2110383.41996 37.7744069778156 -122.461737273105 (37.7744069778156, -122.461737273105) 11 6 2 54 11
64659 123360 DPW Maintained 1 Ulmus spp :: Elm Spp 98 752 04th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     17 Width 4ft   5994762.63942 2110475.46435 37.7746621864627 -122.461594966486 (37.7746621864627, -122.461594966486) 11 6 2 54 11
69075 242800 DPW Maintained 1 Ulmus spp :: Elm Spp 98 3775 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 4ft   6005335.62293 2101352.55073 37.7502157400659 -122.424371845882 (37.7502157400659, -122.424371845882) 2 4 5 28859 19
73634 215662 DPW Maintained 1 Ulmus spp :: Elm Spp 98 555 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   5992890.83757 2099400.96676 37.7441465915065 -122.4672644407 (37.7441465915065, -122.4672644407) 1 8 4 29491 40
85046 215736 DPW Maintained 1 Ulmus spp :: Elm Spp 98 40 Sotelo Ave 1 Sidewalk: Curb side : Yard Tree Private 2     30 Width 4ft   5993926.04845 2101160.446 37.74903738179 -122.46381262058 (37.74903738179, -122.46381262058) 1 8 4 29491 40
92874 215731 DPW Maintained 1 Ulmus spp :: Elm Spp 98 314 Pacheco St 1 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 4ft   5994301.54352 2100886.45873 37.7483067132019 -122.462494294493 (37.7483067132019, -122.462494294493) 1 8 4 29491 40
94966 215722 DPW Maintained 1 Ulmus spp :: Elm Spp 98 345 Magellan Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5994125.85996 2099775.19806 37.7452453534832 -122.463021183903 (37.7452453534832, -122.463021183903) 1 8 4 29491 40
97864 215652 DPW Maintained 1 Ulmus spp :: Elm Spp 98 2398 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   5992666.59083 2099178.09213 37.7435216867765 -122.468023621394 (37.7435216867765, -122.468023621394) 1 8 4 29491 40
109609 215660 DPW Maintained 1 Ulmus spp :: Elm Spp 98 575 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   5992800.45502 2099393.57601 37.74412108044 -122.467576423625 (37.74412108044, -122.467576423625) 1 8 4 29491 40
129320 123330 DPW Maintained 1 Ulmus spp :: Elm Spp 98 753 04th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     12 Width 4ft   5994716.4753 2110476.43216 37.7746621864718 -122.461754726458 (37.7746621864718, -122.461754726458) 11 6 2 54 11
141418 215657 DPW Maintained 1 Ulmus spp :: Elm Spp 98 593 Magellan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   5992700.67645 2099384.40519 37.7440901383457 -122.467920765955 (37.7440901383457, -122.467920765955) 1 8 4 29491 40
150959 215653 DPW Maintained 1 Ulmus spp :: Elm Spp 98 2348 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   5992661.56559 2099277.36627 37.7437939781139 -122.468048216973 (37.7437939781139, -122.468048216973) 1 8 4 29491 40
151683 215726 DPW Maintained 1 Ulmus spp :: Elm Spp 98 65 Marcela Ave 1 Sidewalk: Curb side : Yard Tree Private 2     23 Width 4ft   5994671.05341 2100636.37069 37.7476413066028 -122.46119842269 (37.7476413066028, -122.46119842269) 1 8 4 29491 40
158123 122001 DPW Maintained 1 Ulmus spp :: Elm Spp 98 2250 Anza St 1 Sidewalk: Curb side : Yard Tree Private 2     18 Width 4ft   5991649.8791 2112044.77165 37.7787914125342 -122.472476956605 (37.7787914125342, -122.472476956605) 11 6 2 54 26
160556 123805 DPW Maintained 1 Ulmus spp :: Elm Spp 98 2201 Anza St 2 Sidewalk: Curb side : Yard Tree Private 2     32 Width 4ft   5991846.73407 2111993.54539 37.7786621511806 -122.471792230155 (37.7786621511806, -122.471792230155) 11 6 2 54 11
161092 123804 DPW Maintained 1 Ulmus spp :: Elm Spp 98 2200 Anza St 1 Sidewalk: Curb side : Yard Tree Private 2     22 Width 4ft   5991808.50618 2112055.95574 37.7788313010119 -122.471929023833 (37.7788313010119, -122.471929023833) 11 6 2 54 11
168928 122002 DPW Maintained 1 Ulmus spp :: Elm Spp 98 2250 Anza St 2 Sidewalk: Curb side : Yard Tree Private 2     20 Width 4ft   5991621.73453 2112044.32724 37.7787885632642 -122.472574286372 (37.7787885632642, -122.472574286372) 11 6 2 54 26
171001 215655 DPW Maintained 1 Ulmus spp :: Elm Spp 98 2348 12th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   5992658.55199 2099364.68475 37.7440335584079 -122.468064987503 (37.7440335584079, -122.468064987503) 1 8 4 29491 40
172378 123368 DPW Maintained 1 Ulmus spp :: Elm Spp 98 798 04th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     16 Width 4ft   5994767.22383 2110333.14495 37.7742716789712 -122.46156878779 (37.7742716789712, -122.46156878779) 11 6 2 54 11
176659 215721 DPW Maintained 1 Ulmus spp :: Elm Spp 98 345 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   5994111.22171 2099760.97057 37.7452054451668 -122.463070768016 (37.7452054451668, -122.463070768016) 1 8 4 29491 40
178179 215730 DPW Maintained 1 Ulmus spp :: Elm Spp 98 310 Pacheco St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 4ft   5994304.44088 2100856.56791 37.748224807423 -122.462482107774 (37.748224807423, -122.462482107774) 1 8 4 29491 40
180558 242801 DPW Maintained 1 Ulmus spp :: Elm Spp 98 3775 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 4ft   6005357.61324 2101353.89107 37.7502206620698 -122.424295897257 (37.7502206620698, -122.424295897257) 2 4 5 28859 19
181503 215656 DPW Maintained 1 Ulmus spp :: Elm Spp 98 593 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   5992672.51184 2099382.74346 37.7440839492114 -122.468018031212 (37.7440839492114, -122.468018031212) 1 8 4 29491 40
185123 215727 DPW Maintained 1 Ulmus spp :: Elm Spp 98 65 Marcela Ave 2 Sidewalk: Curb side : Yard Tree Private 2     10 Width 4ft   5994677.54204 2100642.18957 37.7476576571947 -122.461176407263 (37.7476576571947, -122.461176407263) 1 8 4 29491 40
185142 215658 DPW Maintained 1 Ulmus spp :: Elm Spp 98 585 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   5992725.64993 2099388.06552 37.7441016307792 -122.467834680137 (37.7441016307792, -122.467834680137) 1 8 4 29491 40
188986 215659 DPW Maintained 1 Ulmus spp :: Elm Spp 98 581 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   5992760.61494 2099390.2279 37.7441095870799 -122.467713937172 (37.7441095870799, -122.467713937172) 1 8 4 29491 40
194216 215654 DPW Maintained 1 Ulmus spp :: Elm Spp 98 2348 12th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   5992660.75686 2099331.15305 37.7439416162244 -122.468054925011 (37.7439416162244, -122.468054925011) 1 8 4 29491 40

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);