trees
111 rows where qSpecies_id = 129
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 177275 | 234819 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 3400 Cesar Chavez St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006915.71417 | 2100607.47009 | 37.7482590167352 | -122.418854943117 | (37.7482590167352, -122.418854943117) | 2 | 4 | 7 | 28859 | 19 | |||
| 185204 | 28350 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 3150 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/01/2014 12:00:00 AM | 3 | 3x3 | 6008724.4514529 | 2100618.392641 | 37.7483906859464 | -122.412601130889 | (37.7483906859464, -122.412601130889) | 2 | 4 | 7 | 28859 | 19 | ||
| 186841 | 123653 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 340 Cornwall St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5994489.04448 | 2114234.67413 | 37.7849682162377 | -122.46281415459 | (37.7849682162377, -122.46281415459) | 11 | 6 | 2 | 54 | 11 | |||
| 189094 | 14060 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 1390 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/07/2017 12:00:00 AM | 3 | 4x4 | 6007755.5079 | 2111176.7984 | 37.7773271925581 | -122.41669960144 | (37.7773271925581, -122.41669960144) | 7 | 2 | 9 | 28852 | 36 | ||
| 190226 | 99074 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 561 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006267.52628 | 2106357.27284 | 37.764010124676 | -122.421504654052 | (37.764010124676, -122.421504654052) | 8 | 4 | 7 | 28859 | 19 | |||
| 191522 | 99073 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 567 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006238.66511 | 2106285.80349 | 37.7638122593075 | -122.421599400126 | (37.7638122593075, -122.421599400126) | 8 | 4 | 7 | 28859 | 19 | |||
| 194170 | 99057 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 538 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006091.16213 | 2106453.22967 | 37.7642636537255 | -122.422121463956 | (37.7642636537255, -122.422121463956) | 8 | 4 | 5 | 28859 | 19 | |||
| 194381 | 259007 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 44 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 4x4 | 5996586 | 2090578 | 37.720133466152 | -122.453850425827 | (37.720133466152, -122.453850425827) | 9 | 8 | 6 | 28861 | 24 | ||
| 194443 | 231199 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 3636 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2021 12:00:00 AM | 3 | 3x3 | Permit Number 785078 | 6005923.7545 | 2100590.88969 | 37.7481575867153 | -122.422283938475 | (37.7481575867153, -122.422283938475) | 2 | 4 | 5 | 28859 | 19 | |
| 194446 | 4132 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 3550 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2021 12:00:00 AM | 3 | 3x3 | Permit Number 785078 | 6006390.9849 | 2100603.33536 | 37.7482181038931 | -122.420669151754 | (37.7482181038931, -122.420669151754) | 2 | 4 | 5 | 28859 | 19 | |
| 194447 | 265091 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 3550 Cesar Chavez St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2021 12:00:00 AM | 3 | 3x3 | Permit Number 785078 | 6006085.39303 | 2100598.74488 | 37.7481882715663 | -122.421725554794 | (37.7481882715663, -122.421725554794) | 2 | 4 | 5 | 28859 | 19 |
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) );