trees
7 rows where qSpecies_id = 294
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5707 | 208863 | DPW Maintained 1 | Magnolia x alba :: White Champaca 294 | 1445 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991778.12186 | 2105573.66455 | 37.761030915067 | -122.471561644254 | (37.761030915067, -122.471561644254) | 1 | 8 | 4 | 56 | 12 | |||
7580 | 208865 | DPW Maintained 1 | Magnolia x alba :: White Champaca 294 | 70 Lurline St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991847.54918 | 2105058.13282 | 37.7596194174321 | -122.471283965086 | (37.7596194174321, -122.471283965086) | 1 | 8 | 4 | 56 | 12 | |||
113021 | 208864 | DPW Maintained 1 | Magnolia x alba :: White Champaca 294 | 70 Lurline St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991866.69866 | 2105035.29692 | 37.7595578237552 | -122.471216073458 | (37.7595578237552, -122.471216073458) | 1 | 8 | 4 | 56 | 12 | |||
122539 | 98164 | Permitted Site 7 | Magnolia x alba :: White Champaca 294 | 90 Balceta Ave | 1 | Front Yard : Yard | Tree | Private 2 | 12/22/2011 12:00:00 AM | Permit Number 768312 | 5995830.5 | 2099880.5 | 37.7456325309111 | -122.457134479076 | (37.7456325309111, -122.457134479076) | 1 | 5 | 4 | 59 | 40 | |||
144192 | 230430 | DPW Maintained 1 | Magnolia x alba :: White Champaca 294 | 50 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6005187.34727 | 2107515.85944 | 37.7671303627055 | -122.425323128964 | (37.7671303627055, -122.425323128964) | 8 | 4 | 5 | 28853 | 19 | |||
161852 | 110577 | Permitted Site 7 | Magnolia x alba :: White Champaca 294 | 46 Sharon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/2015 12:00:00 AM | 3 | 3x3 | 6003818.3 | 2106879.6 | 37.7653059066507 | -122.430013064543 | (37.7653059066507, -122.430013064543) | 8 | 4 | 5 | 28862 | 3 | ||
162315 | 208866 | DPW Maintained 1 | Magnolia x alba :: White Champaca 294 | 70 Lurline St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991840.13273 | 2105072.71006 | 37.7596590136808 | -122.471310676752 | (37.7596590136808, -122.471310676752) | 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) );