trees
18 rows where Supervisor Districts = 8 and qSpecies_id = 96
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3273 | 190919 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 999 Kansas St | 5 | Side Yard : Yard | Tree | Private 2 | 20 | 6011651.17755 | 2103795.8209 | 37.7572790316179 | -122.40270394113 | (37.7572790316179, -122.40270394113) | 10 | 3 | 8 | 28856 | 29 | ||||
| 21176 | 190910 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1802 Shoup Ave | 1 | Front Yard : Yard | Tree | Private 2 | 25 | 6013180.92489 | 2093690.47467 | 37.7296171768863 | -122.396705035035 | (37.7296171768863, -122.396705035035) | 10 | 3 | 8 | 58 | 1 | ||||
| 40608 | 190911 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1980 Revere Ave | 1 | Front Yard : Yard | Tree | Private 2 | 9 | 6013087.19308 | 2095914.17172 | 37.7357177729638 | -122.397184944736 | (37.7357177729638, -122.397184944736) | 10 | 3 | 8 | 58 | 1 | ||||
| 67912 | 176067 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 700x Mansell St | 1 | Median : Cutout | Tree | DPW 1 | 22 | Width 0ft | 6009780.98423 | 2090145.56651 | 37.719693784023 | -122.408209118574 | (37.719693784023, -122.408209118574) | 9 | 3 | 8 | 309 | 18 | |||
| 68061 | 190918 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 900x Carolina St | 70 | Median : Yard | Tree | DPW 1 | 21 | 6012519.44645 | 2102822.43937 | 37.7546547784053 | -122.399632767143 | (37.7546547784053, -122.399632767143) | 10 | 3 | 8 | 28856 | 29 | ||||
| 79562 | 190920 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 895 Vermont St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6011337.392 | 2104186.31719 | 37.7583337232325 | -122.403816617445 | (37.7583337232325, -122.403816617445) | 10 | 3 | 8 | 28856 | 29 | ||||
| 90916 | 190913 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 10x Cashmere St | 4 | Median : Yard | Tree | DPW 1 | 16 | 6017428.5626 | 2095806.26069 | 37.7356622038522 | -122.38216748876 | (37.7356622038522, -122.38216748876) | 10 | 3 | 8 | 58 | 1 | ||||
| 91353 | 190917 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 900x Carolina St | 68 | Median : Yard | Tree | DPW 1 | 8 | 6012519.74637 | 2102837.21301 | 37.7546953603194 | -122.399632767155 | (37.7546953603194, -122.399632767155) | 10 | 3 | 8 | 28856 | 29 | ||||
| 97051 | 190914 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 900x Carolina St | 8 | Median : Yard | Tree | DPW 1 | 12 | 6012455.86408 | 2103644.27268 | 37.7569078085518 | -122.399910360878 | (37.7569078085518, -122.399910360878) | 10 | 3 | 8 | 28856 | 29 | ||||
| 105606 | 176066 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 500x Mansell St | 6 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6010525.86554 | 2090356.25733 | 37.7203139789786 | -122.40564914889 | (37.7203139789786, -122.40564914889) | 10 | 7 | 8 | 309 | 28 | |||
| 108052 | 190921 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 875 Vermont St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 2ft | 6011349.18047 | 2104266.91512 | 37.7585556858022 | -122.403781518727 | (37.7585556858022, -122.403781518727) | 10 | 3 | 8 | 28856 | 29 | |||
| 127398 | 190915 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 900x Carolina St | 48 | Median : Yard | Tree | DPW 1 | 10 | 6012505.66859 | 2103014.14021 | 37.7551803790787 | -122.399693874288 | (37.7551803790787, -122.399693874288) | 10 | 3 | 8 | 28856 | 29 | ||||
| 129392 | 187578 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 211 Elliot St | 1 | Side Yard : Yard | Tree | Private 2 | 38 | 6009088.83114 | 2088896.19011 | 37.7162244747635 | -122.410513477532 | (37.7162244747635, -122.410513477532) | 9 | 7 | 8 | 309 | 39 | ||||
| 141205 | 176071 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1x Tioga Ave | 1 | Median : Cutout | Tree | DPW 1 | 30 | Width 0ft | 6011377.48313 | 2088627.04086 | 37.7156134870441 | -122.402583833071 | (37.7156134870441, -122.402583833071) | 9 | 7 | 8 | 309 | 39 | |||
| 149617 | 176069 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 700x Mansell St | 27 | Median : Cutout | Tree | DPW 1 | 28 | Width 0ft | 6009294.57289 | 2089991.02465 | 37.7192421957421 | -122.409879572386 | (37.7192421957421, -122.409879572386) | 9 | 3 | 8 | 309 | 18 | |||
| 159085 | 176068 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 700x Mansell St | 14 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6009458.20535 | 2090043.50806 | 37.7193954735114 | -122.409317656201 | (37.7193954735114, -122.409317656201) | 9 | 3 | 8 | 309 | 18 | |||
| 177603 | 190916 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 900x Carolina St | 61 | Median : Yard | Tree | DPW 1 | 12 | 6012503.64813 | 2102901.04205 | 37.7548697235729 | -122.399692921016 | (37.7548697235729, -122.399692921016) | 10 | 3 | 8 | 28856 | 29 | ||||
| 184063 | 176070 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 700x Mansell St | 34 | Median : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6009191.21918 | 2089961.56598 | 37.7191555154919 | -122.410234749751 | (37.7191555154919, -122.410234749751) | 9 | 3 | 8 | 309 | 18 |
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) );