trees
12 rows where qSpecies_id = 420
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28507 | 206791 | DPW Maintained 1 | Cryptomeria japonica :: Japanese Cryptomeria 420 | 1895 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5991560.66963 | 2102558.42225 | 37.7527392701252 | -122.472093924199 | (37.7527392701252, -122.472093924199) | 1 | 8 | 4 | 56 | 12 | |||
| 33161 | 254729 | Significant Tree 6 | Cryptomeria japonica :: Japanese Cryptomeria 420 | 1940 Mission St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 0ft | 6006763.6807 | 2106952.0622 | 37.7656712394659 | -122.419830807079 | (37.7656712394659, -122.419830807079) | 8 | 4 | 7 | 28853 | 19 | ||||
| 75601 | 176080 | DPW Maintained 1 | Cryptomeria japonica :: Japanese Cryptomeria 420 | 288 Hester Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012165.46257 | 2087875.16154 | 37.7135929379414 | -122.399807437072 | (37.7135929379414, -122.399807437072) | 10 | 3 | 8 | 309 | 1 | |||
| 87576 | 190949 | DPW Maintained 1 | Cryptomeria japonica :: Japanese Cryptomeria 420 | 1765 Revere Ave | 1 | : | Tree | Private 2 | 18 | Width 3ft | 6014204.01506 | 2095028.34519 | 37.7333475863155 | -122.393261660419 | (37.7333475863155, -122.393261660419) | 10 | 3 | 8 | 58 | 1 | |||
| 94643 | 206790 | DPW Maintained 1 | Cryptomeria japonica :: Japanese Cryptomeria 420 | 232 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5995371.67235 | 2091512.60645 | 37.7226299760751 | -122.458115525137 | (37.7226299760751, -122.458115525137) | 9 | 8 | 4 | 28861 | 24 | |||
| 151824 | 246745 | DPW Maintained 1 | Cryptomeria japonica :: Japanese Cryptomeria 420 | 140 Ripley St | 3 | Front Yard : Yard | Tree | Private 2 | 4 | 6008948.04772 | 2099080.24577 | 37.7441798214393 | -122.411719269626 | (37.7441798214393, -122.411719269626) | 2 | 7 | 7 | 28859 | 2 | ||||
| 156741 | 206789 | DPW Maintained 1 | Cryptomeria japonica :: Japanese Cryptomeria 420 | 400 Hearst Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 5998668.86339 | 2094413.39273 | 37.7307837594476 | -122.446926546049 | (37.7307837594476, -122.446926546049) | 9 | 7 | 4 | 59 | 40 | |||
| 161256 | 120267 | DPW Maintained 1 | Cryptomeria japonica :: Japanese Cryptomeria 420 | 100 24th Ave | 1 | Side Yard : Yard | Tree | Private 2 | 5 | 5988369.51878 | 2115107.91648 | 37.7870115292654 | -122.484049556275 | (37.7870115292654, -122.484049556275) | 11 | 6 | 1 | 55 | 33 | ||||
| 167171 | 122062 | DPW Maintained 1 | Cryptomeria japonica :: Japanese Cryptomeria 420 | 5 17th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 5ft | 5990511.82638 | 2115005.39059 | 37.7868545124865 | -122.476630238278 | (37.7868545124865, -122.476630238278) | 11 | 6 | 1 | 61 | 30 | |||
| 174516 | 206788 | DPW Maintained 1 | Cryptomeria japonica :: Japanese Cryptomeria 420 | 1695 08th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 4ft | 5993693.37369 | 2103986.07893 | 37.7567824340901 | -122.464822377574 | (37.7567824340901, -122.464822377574) | 1 | 8 | 4 | 56 | 12 | |||
| 174525 | 184718 | DPW Maintained 1 | Cryptomeria japonica :: Japanese Cryptomeria 420 | 1635 37th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 0ft | 5984663.6565 | 2104045.9774 | 37.7564221499071 | -122.496054413144 | (37.7564221499071, -122.496054413144) | 1 | 8 | 3 | 56 | 35 | |||
| 178491 | 223268 | DPW Maintained 1 | Cryptomeria japonica :: Japanese Cryptomeria 420 | 3910 22nd St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6002358.80853 | 2102981.78525 | 37.7545206841088 | -122.434782336729 | (37.7545206841088, -122.434782336729) | 2 | 4 | 5 | 28862 | 22 |
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) );