trees
13 rows where qSiteInfo = "Median : Yard" 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17076 | 126371 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1306x Montgomery St | 37 | Median : Yard | Tree | DPW 1 | 4 | Width 8ft | 6011427.3089 | 2120158.66 | 37.8021950785935 | -122.404630029046 | (37.8021950785935, -122.404630029046) | 3 | 1 | 10 | 308 | 23 | |||
| 41713 | 206477 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 200x Terrace Dr | 20 | Median : Yard | Tree | DPW 1 | 5 | 5993822.05067 | 2096524.01563 | 37.7363009158535 | -122.463835755623 | (37.7363009158535, -122.463835755623) | 1 | 8 | 4 | 59 | 40 | ||||
| 47071 | 206479 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 200x Terrace Dr | 23 | Median : Yard | Tree | DPW 1 | 13 | 5993821.59658 | 2096532.53346 | 37.7363242775317 | -122.463837943662 | (37.7363242775317, -122.463837943662) | 1 | 8 | 4 | 59 | 40 | ||||
| 52277 | 126370 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1306x Montgomery St | 31 | Median : Yard | Tree | DPW 1 | 10 | Width 8ft | 6011433.37611 | 2120083.33032 | 37.801988580771 | -122.404603727506 | (37.801988580771, -122.404603727506) | 3 | 1 | 10 | 308 | 23 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 129949 | 206476 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 200x Terrace Dr | 19 | Median : Yard | Tree | DPW 1 | 16 | 5993821.62847 | 2096518.98246 | 37.7362870716885 | -122.463836850114 | (37.7362870716885, -122.463836850114) | 1 | 8 | 4 | 59 | 40 | ||||
| 133342 | 206478 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 200x Terrace Dr | 21 | Median : Yard | Tree | DPW 1 | 6 | 5993823.40178 | 2096528.08405 | 37.7363121645844 | -122.463831379524 | (37.7363121645844, -122.463831379524) | 1 | 8 | 4 | 59 | 40 | ||||
| 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 | ||||
| 192482 | 126369 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1306x Montgomery St | 30 | Median : Yard | Tree | DPW 1 | 8 | Width 8ft | 6011435.17205 | 2120070.79941 | 37.8019542743222 | -122.404596630044 | (37.8019542743222, -122.404596630044) | 3 | 1 | 10 | 308 | 23 |
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) );