home / trees

Street_Tree_List

Data source: data.sfgov.org

29 rows where qSpecies = 40

View and edit SQL

Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes, Neighborhoods

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
169 100166 Property Tree 5 Salix spp :: Willow 40 2340 Twin Peaks Blvd   Front Yard : Yard 4 Tree 1 Private 2         Permit Number 769026                    
1304 101470 Undocumented 3 Salix spp :: Willow 40 1230 Twin Peaks Blvd 2 Back Yard : Yard 6 Tree 1 Private 2           5997905.5 2100119.1 37.7464066170132 -122.449976668748 (37.7464066170132, -122.449976668748) 2 5 4 63 38
5298 106059 Significant Tree 4 Salix spp :: Willow 40 339 FILBERT ST 1 Front Yard : Yard 4 Tree 1 Private 2     6     6011263.6 2119947.8 37.801606957686 -122.40518168715599 (37.801606957686, -122.405181687156) 3 1 10 308 23
15126 116975 Undocumented 3 Salix spp :: Willow 40 100x CARGO WAY 6 Front Yard : Yard 4 Tree 1 PUC 12 DPW for City Agency 4         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394) 10 3 8 58 1
15127 116976 Undocumented 3 Salix spp :: Willow 40 100x CARGO WAY 7 Front Yard : Yard 4 Tree 1 PUC 12 DPW for City Agency 4         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394) 10 3 8 58 1
17957 120504 Undocumented 3 Salix spp :: Willow 40 2050 Turk Blvd 1 Back Yard : Yard 6 Tree 1 Private 2           6000175.0 2112136.0 37.779531646131204 -122.442991859062 (37.7795316461312, -122.442991859062) 15 5 1 29490 16
50727 179421 DPW Maintained 1 Salix spp :: Willow 40 700 John Muir Dr 1 : 14 Tree 1 Private 2     18 Width 0ft   5986275.223040001 2087885.25154 37.7121433180403 -122.489292946617 (37.7121433180403, -122.489292946617) 1 8 4 64 14
52807 181908 DPW Maintained 1 Salix spp :: Willow 40 2361 27th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 Width 0ft   5987931.3863 2099236.8053 37.743408304681104 -122.484400882071 (37.7434083046811, -122.484400882071) 1 8 3 29491 35
54645 183597 DPW Maintained 1 Salix spp :: Willow 40 2639 23rd Ave 2 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     1 Width 0ft   5989238.6658 2097359.0167 37.7383284221723 -122.479743320072 (37.7383284221723, -122.479743320072) 1 8 3 29491 35
69464 197463 DPW Maintained 1 Salix spp :: Willow 40 300 Tulare St 12 Front Yard : Yard 4 Tree 1 Private 2     11 Width 5ft   6015063.03435 2100312.52398 37.7479045390722 -122.39066089929199 (37.7479045390722, -122.390660899292)   3 8 58 1
69465 197464 DPW Maintained 1 Salix spp :: Willow 40 300 Tulare St 9 Front Yard : Yard 4 Tree 1 Private 2     3     6015091.2774 2100275.40552 37.747804186425704 -122.390560641961 (37.7478041864257, -122.390560641961)   3 8 58 1
69466 197465 DPW Maintained 1 Salix spp :: Willow 40 300 Tulare St 10 Front Yard : Yard 4 Tree 1 Private 2     2     6015074.429330001 2100286.5599 37.747833879328205 -122.39061968157101 (37.7478338793282, -122.390619681571)   3 8 58 1
69467 197466 DPW Maintained 1 Salix spp :: Willow 40 625 Bay Shore Blvd 4 Sidewalk: Property side : Yard 5 Tree 1 Private 2     6 Width 6ft   6010372.73357 2096324.48673 37.7366929195414 -122.40659883568199 (37.7366929195414, -122.406598835682) 10 3 8 58 1
86190 214151 DPW Maintained 1 Salix spp :: Willow 40 312 Ortega St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 4ft   5993037.76549 2102572.2822 37.7528626930695 -122.466986911741 (37.7528626930695, -122.466986911741) 1 8 4 56 12
121192 249796 DPW Maintained 1 Salix spp :: Willow 40 199 Chestnut St 4 Front Yard : Yard 4 Tree 1 Private 2     8 Width 0ft   6010844.62516 2121045.45639 37.80459742048421 -122.40670893787701 (37.8045974204842, -122.406708937877) 3 1 10 308 23
121195 249799 DPW Maintained 1 Salix spp :: Willow 40 199 Chestnut St 7 Front Yard : Yard 4 Tree 1 Private 2     5 Width 0ft   6010830.01398 2121049.58658 37.8046079434619 -122.406759792755 (37.8046079434619, -122.406759792755) 3 1 10 308 23
121199 249801 DPW Maintained 1 Salix spp :: Willow 40 199 Chestnut St 9 Front Yard : Yard 4 Tree 1 Private 2     11 Width 0ft   6010817.41818 2121032.42215 37.8045601094112 -122.40680217150101 (37.8045601094112, -122.406802171501) 3 1 10 308 23
121200 249802 DPW Maintained 1 Salix spp :: Willow 40 258 Chestnut St 1 Back Yard : Yard 6 Tree 1 Private 2     9 Width 0ft   6010800.51699 2121027.19165 37.804544802067795 -122.40686029106399 (37.8045448020678, -122.406860291064) 3 1 10 308 23
121201 249803 DPW Maintained 1 Salix spp :: Willow 40 258 Chestnut St 2 Back Yard : Yard 6 Tree 1 Private 2     5 Width 0ft   6010797.8681 2121034.56269 37.8045648929076 -122.406869977661 (37.8045648929076, -122.406869977661) 3 1 10 308 23
121202 249804 DPW Maintained 1 Salix spp :: Willow 40 258 Chestnut St 3 Back Yard : Yard 6 Tree 1 Private 2     9 Width 0ft   6010798.41124 2121026.88639 37.8045438460731 -122.406867556714 (37.8045438460731, -122.406867556714) 3 1 10 308 23
121203 249805 DPW Maintained 1 Salix spp :: Willow 40 258 Chestnut St 4 Back Yard : Yard 6 Tree 1 Private 2     14 Width 0ft   6010790.25874 2121038.89871 37.8045763727666 -122.40689661648099 (37.8045763727666, -122.406896616481) 3 1 10 308 23
121204 249806 DPW Maintained 1 Salix spp :: Willow 40 258 Chestnut St 5 Back Yard : Yard 6 Tree 1 Private 2     16 Width 0ft   6010784.31321 2121039.01987 37.804576372755605 -122.406917200191 (37.8045763727556, -122.406917200191) 3 1 10 308 23
121283 249879 DPW Maintained 1 Salix spp :: Willow 40 230 Greenwich St 15 Back Yard : Yard 6 Tree 1 Private 2     31 Width 0ft   6011548.40111 2120431.82846 37.8029518994613 -122.404230226458 (37.8029518994613, -122.404230226458) 3 1 10 308 23
123852 253567 DPW Maintained 1 Salix spp :: Willow 40 25 Raycliff Ter 1 Back Yard : Yard 6 Tree 1 Private 2           6000333.0 2116919.0 37.792673532262505 -122.44278881704399 (37.7926735322625, -122.442788817044) 13 6 1 29490 27
183782 91365 Permitted Site 2 Salix spp :: Willow 40 2850 22nd St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/27/2009 12:00:00 AM   3x3 Permit Number 52066 6009160.0 2103356.0 37.755931978245705 -122.411288371704 (37.7559319782457, -122.411288371704) 2 4 7 28859 19
183783 91366 Permitted Site 2 Salix spp :: Willow 40 2850 22nd St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/27/2009 12:00:00 AM   3x3 Permit Number 52066 6009160.0 2103356.0 37.755931978245705 -122.411288371704 (37.7559319782457, -122.411288371704) 2 4 7 28859 19
183784 91367 Permitted Site 2 Salix spp :: Willow 40 2850 22nd St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/27/2009 12:00:00 AM   3x3 Permit Number 52066 6009160.0 2103356.0 37.755931978245705 -122.411288371704 (37.7559319782457, -122.411288371704) 2 4 7 28859 19
189022 97302 Permitted Site 2 Salix spp :: Willow 40 1051 Portola Dr 5 Sidewalk: Property side : Yard 5 Tree 1 Private 2           5995688.7 2098126.6 37.7408086112536 -122.457497926865 (37.7408086112536, -122.457497926865) 9 7 4 59 40
191384 99821 Undocumented 3 Salix spp :: Willow 40 1230 Twin Peaks Blvd 1 Back Yard : Yard 6 Tree 1 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

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 107.062ms · Data source: data.sfgov.org