trees
26 rows where DBH = 18 and qSpecies_id = 65 sorted by PlotSize
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9419 | 70579 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 212 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 18 | 5989642.97264 | 2113940.99798 | 37.7838815566968 | -122.479558331084 | (37.7838815566968, -122.479558331084) | 11 | 6 | 2 | 55 | 26 | |||
13672 | 70491 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 26 Ina Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 18 | 6005035.04728 | 2091735.87999 | 37.7237935486115 | -122.424727215697 | (37.7237935486115, -122.424727215697) | 9 | 7 | 6 | 28861 | 5 | |||
126786 | 248223 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 70 Fair Ave | 5 | Side Yard : Yard | Tree | Private 2 | 18 | 6007150.20605 | 2099339.87769 | 37.744791694087 | -122.417954229812 | (37.744791694087, -122.417954229812) | 2 | 7 | 7 | 28859 | 2 | ||||
154146 | 40163 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 39201 Dashiell Hammett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Permit Number 41356 | 6010358.38502 | 2116055.23844 | 37.7908682829043 | -122.40803948753 | (37.7908682829043, -122.40803948753) | 5 | 1 | 10 | 28857 | 21 | |||
59853 | 1275 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3995X Alemany Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5992427.65168 | 2087335.55006 | 37.710991191174 | -122.467988584733 | (37.710991191174, -122.467988584733) | 9 | 8 | 4 | 64 | 24 | |||
151383 | 1266 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3995X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5992143.83128 | 2087204.78999 | 37.7106157610663 | -122.46896001711 | (37.7106157610663, -122.46896001711) | 9 | 8 | 4 | 64 | 24 | |||
105309 | 35840 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 621 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1998 12:00:00 AM | 18 | 6x7 | Permit Number 39067 | 6002271.78016 | 2090299.14404 | 37.7196921382746 | -122.434176697315 | (37.7196921382746, -122.434176697315) | 9 | 7 | 6 | 28861 | 5 |
26119 | 125558 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 39 Dashiell Hammett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 1ft | 6010359.2219 | 2116035.15877 | 37.7908131958158 | -122.408035175278 | (37.7908131958158, -122.408035175278) | 5 | 1 | 10 | 28857 | 21 | |||
20543 | 203531 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 355 Granada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 5995610.31086 | 2092357.07195 | 37.7249623857941 | -122.457351672459 | (37.7249623857941, -122.457351672459) | 9 | 7 | 4 | 28861 | 40 | |||
66471 | 221841 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 5 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 6004259.60988 | 2095362.69857 | 37.7337081577855 | -122.42766605444 | (37.7337081577855, -122.42766605444) | 2 | 7 | 5 | 28861 | 25 | |||
124027 | 124414 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 111 Cherry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 5996072.31903 | 2115814.16927 | 37.7893961490256 | -122.457450879091 | (37.7893961490256, -122.457450879091) | 11 | 6 | 1 | 54 | 31 | |||
1033 | 221901 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Marsily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6004253.74444 | 2095482.9703 | 37.7340380650904 | -122.427694899296 | (37.7340380650904, -122.427694899296) | 2 | 7 | 5 | 28861 | 25 | |||
16252 | 203564 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 202 Elmwood Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 5994856.42725 | 2092686.28381 | 37.7258229929193 | -122.459981583277 | (37.7258229929193, -122.459981583277) | 9 | 8 | 4 | 28861 | 40 | |||
93237 | 203567 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 209 Colon Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 5996068.02094 | 2094221.27645 | 37.7301073235953 | -122.455904133578 | (37.7301073235953, -122.455904133578) | 9 | 7 | 4 | 28861 | 40 | |||
95845 | 221899 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Marsily St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6004290.71623 | 2095557.06224 | 37.7342435961597 | -122.427572353179 | (37.7342435961597, -122.427572353179) | 2 | 7 | 5 | 28861 | 25 | |||
107710 | 175194 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 522 Avalon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6004004.48398 | 2092477.2158 | 37.7257708331541 | -122.428342513702 | (37.7257708331541, -122.428342513702) | 9 | 7 | 6 | 28861 | 5 | |||
121593 | 221917 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1033 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6003826.31981 | 2102255.52555 | 37.7526097533439 | -122.429655503209 | (37.7526097533439, -122.429655503209) | 2 | 4 | 5 | 28862 | 22 | |||
143450 | 221902 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6004251.61559 | 2095453.80279 | 37.7339578572562 | -122.427700181935 | (37.7339578572562, -122.427700181935) | 2 | 7 | 5 | 28861 | 25 | |||
144494 | 221905 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 572 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6002660.0308 | 2103294.31011 | 37.7553958998276 | -122.433762967812 | (37.7553958998276, -122.433762967812) | 2 | 4 | 5 | 28862 | 22 | |||
152125 | 221834 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 581 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6007293.84054 | 2103959.34746 | 37.7574837919732 | -122.417784945026 | (37.7574837919732, -122.417784945026) | 2 | 4 | 7 | 28859 | 19 | |||
169633 | 203549 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 181 Flood Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5999506.56732 | 2094057.55855 | 37.7298545448296 | -122.444004922987 | (37.7298545448296, -122.444004922987) | 9 | 7 | 4 | 63 | 40 | |||
183461 | 221802 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 325 Day St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 18 | Width 3ft | 6003816.24882 | 2098634.77002 | 37.7426674306639 | -122.42943214577 | (37.7426674306639, -122.42943214577) | 2 | 7 | 5 | 63 | 22 | |||
15498 | 221829 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2451 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6008243.92561 | 2104140.04763 | 37.7580333739666 | -122.414511946088 | (37.7580333739666, -122.414511946088) | 2 | 4 | 7 | 28859 | 19 | |||
31089 | 124539 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1001 Balboa St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 5992452.39614 | 2111338.25505 | 37.7768979266396 | -122.46964931253 | (37.7768979266396, -122.46964931253) | 11 | 6 | 2 | 54 | 11 | |||
99091 | 203574 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 32 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6001891.78226 | 2094951.97424 | 37.7324461814313 | -122.435822942293 | (37.7324461814313, -122.435822942293) | 9 | 7 | 5 | 63 | 40 | |||
105355 | 203573 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 22 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6001918.41123 | 2094952.28541 | 37.7324485484508 | -122.435730902059 | (37.7324485484508, -122.435730902059) | 9 | 7 | 5 | 63 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );