trees
29 rows where qSpecies_id = 203
This data as json, CSV (advanced)
Suggested facets: qLegalStatus_id, qAddress, SiteOrder, qCareAssistant, DBH, PermitNotes, YCoord, Longitude, Fire Prevention Districts, Supervisor Districts, Zip Codes
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1694 | 100166 | Property Tree 8 | Salix spp :: Willow 203 | 2340 Twin Peaks Blvd | Front Yard : Yard | Tree | Private 2 | Permit Number 769026 | |||||||||||||||
| 2008 | 106059 | Significant Tree 6 | Salix spp :: Willow 203 | 339 FILBERT ST | 1 | Front Yard : Yard | Tree | Private 2 | 6 | 6011263.6 | 2119947.8 | 37.801606957686 | -122.405181687156 | (37.801606957686, -122.405181687156) | 3 | 1 | 10 | 308 | 23 | ||||
| 7668 | 253567 | DPW Maintained 1 | Salix spp :: Willow 203 | 25 Raycliff Ter | 1 | Back Yard : Yard | Tree | Private 2 | 6000333 | 2116919 | 37.7926735322625 | -122.442788817044 | (37.7926735322625, -122.442788817044) | 13 | 6 | 1 | 29490 | 27 | |||||
| 8810 | 197465 | DPW Maintained 1 | Salix spp :: Willow 203 | 300 Tulare St | 10 | Front Yard : Yard | Tree | Private 2 | 2 | 6015074.42933 | 2100286.5599 | 37.7478338793282 | -122.390619681571 | (37.7478338793282, -122.390619681571) | 3 | 8 | 58 | 1 | |||||
| 16394 | 249803 | DPW Maintained 1 | Salix spp :: Willow 203 | 258 Chestnut St | 2 | Back Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6010797.8681 | 2121034.56269 | 37.8045648929076 | -122.406869977661 | (37.8045648929076, -122.406869977661) | 3 | 1 | 10 | 308 | 23 | |||
| 21851 | 249801 | DPW Maintained 1 | Salix spp :: Willow 203 | 199 Chestnut St | 9 | Front Yard : Yard | Tree | Private 2 | 11 | Width 0ft | 6010817.41818 | 2121032.42215 | 37.8045601094112 | -122.406802171501 | (37.8045601094112, -122.406802171501) | 3 | 1 | 10 | 308 | 23 | |||
| 26413 | 91366 | Permitted Site 7 | Salix spp :: Willow 203 | 2850 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2009 12:00:00 AM | 3x3 | Permit Number 52066 | 6009160 | 2103356 | 37.7559319782457 | -122.411288371704 | (37.7559319782457, -122.411288371704) | 2 | 4 | 7 | 28859 | 19 | ||
| 38711 | 116976 | Undocumented 4 | Salix spp :: Willow 203 | 100x CARGO WAY | 7 | Front Yard : Yard | Tree | PUC 8 | DPW for City Agency | 6019010 | 2097405 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | 10 | 3 | 8 | 58 | 1 | ||||
| 44424 | 91365 | Permitted Site 7 | Salix spp :: Willow 203 | 2850 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2009 12:00:00 AM | 3x3 | Permit Number 52066 | 6009160 | 2103356 | 37.7559319782457 | -122.411288371704 | (37.7559319782457, -122.411288371704) | 2 | 4 | 7 | 28859 | 19 | ||
| 45686 | 249805 | DPW Maintained 1 | Salix spp :: Willow 203 | 258 Chestnut St | 4 | Back Yard : Yard | Tree | Private 2 | 14 | Width 0ft | 6010790.25874 | 2121038.89871 | 37.8045763727666 | -122.406896616481 | (37.8045763727666, -122.406896616481) | 3 | 1 | 10 | 308 | 23 | |||
| 55823 | 120504 | Undocumented 4 | Salix spp :: Willow 203 | 2050 Turk Blvd | 1 | Back Yard : Yard | Tree | Private 2 | 6000175 | 2112136 | 37.7795316461312 | -122.442991859062 | (37.7795316461312, -122.442991859062) | 15 | 5 | 1 | 29490 | 16 | |||||
| 70143 | 214151 | DPW Maintained 1 | Salix spp :: Willow 203 | 312 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5993037.76549 | 2102572.2822 | 37.7528626930695 | -122.466986911741 | (37.7528626930695, -122.466986911741) | 1 | 8 | 4 | 56 | 12 | |||
| 72270 | 249796 | DPW Maintained 1 | Salix spp :: Willow 203 | 199 Chestnut St | 4 | Front Yard : Yard | Tree | Private 2 | 8 | Width 0ft | 6010844.62516 | 2121045.45639 | 37.8045974204842 | -122.406708937877 | (37.8045974204842, -122.406708937877) | 3 | 1 | 10 | 308 | 23 | |||
| 81460 | 99821 | Undocumented 4 | Salix spp :: Willow 203 | 1230 Twin Peaks Blvd | 1 | Back Yard : Yard | Tree | Private 2 | 11 | Tree closest to sidewalk and retaining wall | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
| 84822 | 249802 | DPW Maintained 1 | Salix spp :: Willow 203 | 258 Chestnut St | 1 | Back Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6010800.51699 | 2121027.19165 | 37.8045448020678 | -122.406860291064 | (37.8045448020678, -122.406860291064) | 3 | 1 | 10 | 308 | 23 | |||
| 86057 | 179421 | DPW Maintained 1 | Salix spp :: Willow 203 | 700 John Muir Dr | 1 | : | Tree | Private 2 | 18 | Width 0ft | 5986275.22304 | 2087885.25154 | 37.7121433180403 | -122.489292946617 | (37.7121433180403, -122.489292946617) | 1 | 8 | 4 | 64 | 14 | |||
| 87065 | 101470 | Undocumented 4 | Salix spp :: Willow 203 | 1230 Twin Peaks Blvd | 2 | Back Yard : Yard | Tree | Private 2 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||||
| 93429 | 197463 | DPW Maintained 1 | Salix spp :: Willow 203 | 300 Tulare St | 12 | Front Yard : Yard | Tree | Private 2 | 11 | Width 5ft | 6015063.03435 | 2100312.52398 | 37.7479045390722 | -122.390660899292 | (37.7479045390722, -122.390660899292) | 3 | 8 | 58 | 1 | ||||
| 98972 | 91367 | Permitted Site 7 | Salix spp :: Willow 203 | 2850 22nd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2009 12:00:00 AM | 3x3 | Permit Number 52066 | 6009160 | 2103356 | 37.7559319782457 | -122.411288371704 | (37.7559319782457, -122.411288371704) | 2 | 4 | 7 | 28859 | 19 | ||
| 100765 | 197464 | DPW Maintained 1 | Salix spp :: Willow 203 | 300 Tulare St | 9 | Front Yard : Yard | Tree | Private 2 | 3 | 6015091.2774 | 2100275.40552 | 37.7478041864257 | -122.390560641961 | (37.7478041864257, -122.390560641961) | 3 | 8 | 58 | 1 | |||||
| 107281 | 249804 | DPW Maintained 1 | Salix spp :: Willow 203 | 258 Chestnut St | 3 | Back Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6010798.41124 | 2121026.88639 | 37.8045438460731 | -122.406867556714 | (37.8045438460731, -122.406867556714) | 3 | 1 | 10 | 308 | 23 | |||
| 142373 | 197466 | DPW Maintained 1 | Salix spp :: Willow 203 | 625 Bay Shore Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6010372.73357 | 2096324.48673 | 37.7366929195414 | -122.406598835682 | (37.7366929195414, -122.406598835682) | 10 | 3 | 8 | 58 | 1 | |||
| 148253 | 249879 | DPW Maintained 1 | Salix spp :: Willow 203 | 230 Greenwich St | 15 | Back Yard : Yard | Tree | Private 2 | 31 | Width 0ft | 6011548.40111 | 2120431.82846 | 37.8029518994613 | -122.404230226458 | (37.8029518994613, -122.404230226458) | 3 | 1 | 10 | 308 | 23 | |||
| 158330 | 249799 | DPW Maintained 1 | Salix spp :: Willow 203 | 199 Chestnut St | 7 | Front Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6010830.01398 | 2121049.58658 | 37.8046079434619 | -122.406759792755 | (37.8046079434619, -122.406759792755) | 3 | 1 | 10 | 308 | 23 | |||
| 160127 | 249806 | DPW Maintained 1 | Salix spp :: Willow 203 | 258 Chestnut St | 5 | Back Yard : Yard | Tree | Private 2 | 16 | Width 0ft | 6010784.31321 | 2121039.01987 | 37.8045763727556 | -122.406917200191 | (37.8045763727556, -122.406917200191) | 3 | 1 | 10 | 308 | 23 | |||
| 168097 | 97302 | Permitted Site 7 | Salix spp :: Willow 203 | 1051 Portola Dr | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | 9 | 7 | 4 | 59 | 40 | |||||
| 171487 | 183597 | DPW Maintained 1 | Salix spp :: Willow 203 | 2639 23rd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5989238.6658 | 2097359.0167 | 37.7383284221723 | -122.479743320072 | (37.7383284221723, -122.479743320072) | 1 | 8 | 3 | 29491 | 35 | |||
| 173000 | 116975 | Undocumented 4 | Salix spp :: Willow 203 | 100x CARGO WAY | 6 | Front Yard : Yard | Tree | PUC 8 | DPW for City Agency | 6019010 | 2097405 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | 10 | 3 | 8 | 58 | 1 | ||||
| 177059 | 181908 | DPW Maintained 1 | Salix spp :: Willow 203 | 2361 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5987931.3863 | 2099236.8053 | 37.7434083046811 | -122.484400882071 | (37.7434083046811, -122.484400882071) | 1 | 8 | 3 | 29491 | 35 |
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) );