trees
7 rows where Neighborhoods (old) = 12 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
43478 | 32329 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1884 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/1996 12:00:00 AM | 5 | Permit Number 36893 | 5993786.54543 | 2102682.50055 | 37.7532085147622 | -122.464405513896 | (37.7532085147622, -122.464405513896) | 1 | 8 | 4 | 56 | 12 | ||
45243 | 115303 | Permitted Site 7 | Eriobotrya japonica :: Edible Loquat 119 | 916 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2016 12:00:00 AM | 4x4 | Permit Number 775645 | 5991143.3 | 2102523.7 | 37.7526197703983 | -122.473534716603 | (37.7526197703983, -122.473534716603) | 1 | 8 | 4 | 56 | 12 | ||
90998 | 207709 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 916 Ortega St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 1ft | 5991129.27817 | 2102510.74063 | 37.7525833753326 | -122.47358226082 | (37.7525833753326, -122.47358226082) | 1 | 8 | 4 | 56 | 12 | |||
107290 | 207710 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 641 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992286.81518 | 2103851.81856 | 37.7563325940936 | -122.46967695664 | (37.7563325940936, -122.46967695664) | 1 | 8 | 4 | 56 | 12 | |||
107348 | 121598 | Permitted Site 7 | Eriobotrya japonica :: Edible Loquat 119 | 916 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 5991143.3 | 2102523.7 | 37.7526197703983 | -122.473534716603 | (37.7526197703983, -122.473534716603) | 1 | 8 | 4 | 56 | 12 | ||||
132651 | 207707 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1254 18th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5990519.64263 | 2106849.66281 | 37.7644615768749 | -122.476007325895 | (37.7644615768749, -122.476007325895) | 11 | 8 | 3 | 56 | 12 | |||
155867 | 207708 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 916 Ortega St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 1ft | 5991151.90196 | 2102512.9309 | 37.7525906994144 | -122.473504184373 | (37.7525906994144, -122.473504184373) | 1 | 8 | 4 | 56 | 12 |
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) );