trees
11 rows where qSiteInfo = "Side Yard : Yard" and qSpecies_id = 77
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
246 | 136052 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1114 Greenwich St | 1 | Side Yard : Yard | Tree | Private 2 | 3 | 6007569.13805 | 2119905.68389 | 37.801284085155 | -122.417963252702 | (37.801284085155, -122.417963252702) | 5 | 1 | 1 | 28858 | 32 | ||||
22945 | 250158 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2500 Lyon St | 5 | Side Yard : Yard | Tree | Private 2 | 7 | 5999254.28786 | 2117464.37854 | 37.7941094422474 | -122.446560444632 | (37.7941094422474, -122.446560444632) | 13 | 9 | 1 | 57 | 27 | ||||
33567 | 249637 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2400 Lyon St | 3 | Side Yard : Yard | Tree | Private 2 | 7 | 5999297.09837 | 2117106.84322 | 37.7931301902456 | -122.4463865832 | (37.7931301902456, -122.4463865832) | 13 | 9 | 1 | 57 | 27 | ||||
38537 | 249640 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2400 Lyon St | 6 | Side Yard : Yard | Tree | Private 2 | 7 | 5999291.59314 | 2117167.12216 | 37.79329538582 | -122.446409970041 | (37.79329538582, -122.446409970041) | 13 | 9 | 1 | 57 | 27 | ||||
67698 | 249638 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2400 Lyon St | 5 | Side Yard : Yard | Tree | Private 2 | 11 | 5999293.71803 | 2117149.90797 | 37.7932482415769 | -122.446401378842 | (37.7932482415769, -122.446401378842) | 13 | 9 | 1 | 57 | 27 | ||||
84577 | 250155 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2500 Lyon St | 2 | Side Yard : Yard | Tree | Private 2 | 6 | 5999259.65981 | 2117410.03204 | 37.7939605280209 | -122.446537945371 | (37.7939605280209, -122.446537945371) | 13 | 9 | 1 | 57 | 27 | ||||
103407 | 250156 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2500 Lyon St | 3 | Side Yard : Yard | Tree | Private 2 | 5 | 5999256.55789 | 2117425.58205 | 37.7940030470443 | -122.446549797562 | (37.7940030470443, -122.446549797562) | 13 | 9 | 1 | 57 | 27 | ||||
123301 | 249636 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2400 Lyon St | 2 | Side Yard : Yard | Tree | Private 2 | 10 | 5999299.54264 | 2117085.08931 | 37.7930705993714 | -122.446376560233 | (37.7930705993714, -122.446376560233) | 13 | 9 | 1 | 57 | 27 | ||||
124228 | 250157 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2500 Lyon St | 4 | Side Yard : Yard | Tree | Private 2 | 7 | 5999256.81946 | 2117443.67812 | 37.7940527489909 | -122.446550195053 | (37.7940527489909, -122.446550195053) | 13 | 9 | 1 | 57 | 27 | ||||
146504 | 250159 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2500 Lyon St | 6 | Side Yard : Yard | Tree | Private 2 | 8 | 5999252.38937 | 2117479.90418 | 37.7941519630933 | -122.446568131123 | (37.7941519630933, -122.446568131123) | 13 | 9 | 1 | 57 | 27 | ||||
184216 | 250154 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2500 Lyon St | 1 | Side Yard : Yard | Tree | Private 2 | 9 | 5999263.26744 | 2117392.55411 | 37.7939127443244 | -122.446524204627 | (37.7939127443244, -122.446524204627) | 13 | 9 | 1 | 57 | 27 |
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) );