trees
10 rows where Neighborhoods (old) = 25 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18236 | 176271 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 195 Rome St | 2 | Front Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 5998766.3474 | 2088951.76376 | 37.7157929611452 | -122.446196810045 | (37.7157929611452, -122.446196810045) | 9 | 7 | 6 | 28861 | 25 | |||
| 35709 | 176284 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 251 De Long St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 10ft | 5993742.60383 | 2086796.45358 | 37.7095868089467 | -122.463404735741 | (37.7095868089467, -122.463404735741) | 9 | 8 | 6 | 28861 | 25 | |||
| 46121 | 176270 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 195 Rome St | 1 | Front Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 5998756.35201 | 2088943.21744 | 37.7157689240671 | -122.44623074418 | (37.7157689240671, -122.44623074418) | 9 | 7 | 6 | 28861 | 25 | |||
| 87730 | 176277 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 190 Foote Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5998652.47444 | 2088356.09646 | 37.7141508908239 | -122.446547575323 | (37.7141508908239, -122.446547575323) | 9 | 7 | 6 | 28861 | 25 | |||
| 109212 | 176272 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 179 Niagara Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 5999311.03211 | 2089604.94508 | 37.7176175399043 | -122.444361048235 | (37.7176175399043, -122.444361048235) | 9 | 7 | 6 | 28861 | 25 | |||
| 132964 | 176278 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 87 Seneca Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 1ft | 6000216.84897 | 2089896.46956 | 37.7184696403425 | -122.441250964156 | (37.7184696403425, -122.441250964156) | 9 | 7 | 6 | 28861 | 25 | |||
| 135986 | 88782 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 166 Havelock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/2008 12:00:00 AM | 9 | 3x3 | Permit Number 51699 | 5999327.15741 | 2092949.02389 | 37.7268005308142 | -122.444545520761 | (37.7268005308142, -122.444545520761) | 9 | 7 | 6 | 28861 | 25 | |
| 146526 | 176286 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 901 Delano Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 5998666.60141 | 2089601.12997 | 37.7175702751322 | -122.446588269645 | (37.7175702751322, -122.446588269645) | 9 | 7 | 6 | 28861 | 25 | |||
| 151725 | 176273 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 179 Niagara Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 0ft | 5999314.98259 | 2089602.87456 | 37.7176120801242 | -122.444347244552 | (37.7176120801242, -122.444347244552) | 9 | 7 | 6 | 28861 | 25 | |||
| 175983 | 176285 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1 Santa Barbara Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5993431.64495 | 2086606.10767 | 37.7090462435678 | -122.464465643484 | (37.7090462435678, -122.464465643484) | 9 | 8 | 6 | 28861 | 25 |
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) );