trees
11 rows where Neighborhoods (old) = 24 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9092 | 207725 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 380 Ralston St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 5992234.50872 | 2090438.58266 | 37.7195002121526 | -122.468881791362 | (37.7195002121526, -122.468881791362) | 9 | 8 | 6 | 64 | 24 | |||
| 58209 | 207718 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 315 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994723.84306 | 2090686.34608 | 37.7203240181088 | -122.46029507617 | (37.7203240181088, -122.46029507617) | 9 | 8 | 6 | 28861 | 24 | |||
| 95024 | 207726 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 416 Ralston St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 5992237.92359 | 2090619.01384 | 37.719995829436 | -122.468883110676 | (37.719995829436, -122.468883110676) | 9 | 8 | 6 | 64 | 24 | |||
| 107253 | 207717 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1180 Plymouth Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5995974.63238 | 2091762.70234 | 37.7233513070047 | -122.456049310222 | (37.7233513070047, -122.456049310222) | 9 | 8 | 4 | 28861 | 24 | |||
| 115439 | 207722 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 300 Louisburg St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5997412.90563 | 2090249.05124 | 37.7192776245304 | -122.450968397868 | (37.7192776245304, -122.450968397868) | 9 | 8 | 6 | 28861 | 24 | |||
| 116467 | 207721 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 228 Montana St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | 5994631.9391 | 2089350.3088 | 37.7166502911674 | -122.460515994629 | (37.7166502911674, -122.460515994629) | 9 | 8 | 6 | 28861 | 24 | ||||
| 116477 | 207719 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 126 Brighton Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 1ft | 5996251.42646 | 2090752.11635 | 37.7205923605284 | -122.455019501973 | (37.7205923605284, -122.455019501973) | 9 | 8 | 6 | 28861 | 24 | |||
| 122502 | 207720 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 750 Grafton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5994515.75563 | 2090598.91337 | 37.7200719768186 | -122.461008027219 | (37.7200719768186, -122.461008027219) | 9 | 8 | 6 | 28861 | 24 | |||
| 158858 | 207724 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 132 Ralston St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5992208.61623 | 2088772.74591 | 37.7149247331539 | -122.46885013342 | (37.7149247331539, -122.46885013342) | 9 | 8 | 6 | 64 | 24 | |||
| 165212 | 207723 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 301 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5991929.88427 | 2090544.15077 | 37.7197724720092 | -122.469942439216 | (37.7197724720092, -122.469942439216) | 9 | 8 | 6 | 64 | 24 | |||
| 180879 | 207727 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 378 Victoria St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5993265.77465 | 2089711.08498 | 37.717562206406 | -122.465264296326 | (37.717562206406, -122.465264296326) | 9 | 8 | 6 | 64 | 24 |
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) );