trees
6 rows where Neighborhoods (old) = 5 and qSpecies_id = 119
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17475 | 176274 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 775 London St | 1 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 6 | 6000713.86512 | 2089358.37648 | 37.7170204575094 | -122.439494437135 | (37.7170204575094, -122.439494437135) | 9 | 7 | 6 | 28861 | 5 | ||||
78353 | 176289 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 140 South Hill Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6003155.69301 | 2086832.03957 | 37.710222356236 | -122.430874024341 | (37.710222356236, -122.430874024341) | 9 | 7 | 6 | 28861 | 5 | |||
84988 | 176279 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 671 London St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6001065.40936 | 2089903.80776 | 37.7185380904529 | -122.43831837391 | (37.7185380904529, -122.43831837391) | 9 | 7 | 6 | 28861 | 5 | ||||
107967 | 176290 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 324 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6002773.32683 | 2086530.28935 | 37.7093721434675 | -122.432174023131 | (37.7093721434675, -122.432174023131) | 9 | 7 | 6 | 28861 | 5 | |||
148176 | 176275 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 23 Byron Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5999165.78727 | 2086612.07538 | 37.7093915094837 | -122.444648098339 | (37.7093915094837, -122.444648098339) | 9 | 7 | 6 | 28861 | 5 | |||
169656 | 57922 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 539 Brunswick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1977 12:00:00 AM | 5 | Permit Number 16880 | 5999313.15008 | 2086900.51859 | 37.7101919177852 | -122.444159502961 | (37.7101919177852, -122.444159502961) | 9 | 7 | 6 | 28861 | 5 |
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) );