trees

29 rows where qSpecies_id = 203

✎ View and edit SQL

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)
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

CSV options: 

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)
);