home / trees

Street_Tree_List

Data source: data.sfgov.org

140,857 rows where qLegalStatus = 1

View and edit SQL

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
1 1 DPW Maintained 1 Pinus radiata :: Monterey Pine 1 10 10th Ave 1 Median : Cutout 1 Tree 1 DPW 1     3 16   5992719.40718 2114869.71245 37.7866097734767 -122.46898271049601 (37.7866097734767, -122.468982710496) 11 6 1 54 11
2 10 DPW Maintained 1 Palm (unknown Genus) :: Palm Spp 2 97 12th St 4 Median : Cutout 1 Tree 1 DPW 1     20 3X3   6007166.5822125 2109668.7679164 37.7731533608049 -122.418629924651 (37.7731533608049, -122.418629924651) 8 2 9 28853 19
3 1000 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 1726 Alemany Blvd 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     20 3X5PL   6001385.76767 2092068.0675700002 37.724498876108 -122.43736591900499 (37.724498876108, -122.437365919005) 9 7 6 28861 25
4 10000 DPW Maintained 1 Geijera parviflora :: Australian Willow 4 136 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     90 2X2   6005403.547780001 2108183.22689 37.7689750062251 -122.424622801709 (37.7689750062251, -122.424622801709) 8 4 5 28853 19
9 100005 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 5 600@Washington St Montgomery St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14     6011805.4321099995 2117563.29295 37.795089953282705 -122.403138864979 (37.7950899532827, -122.403138864979) 3 1 10 28860 4
10 100006 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 5 600@Washington St Montgomery St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15     6011806.48185 2117548.03354 37.7950481132234 -122.403134158813 (37.7950481132234, -122.403134158813) 3 1 10 28860 4
14 10001 DPW Maintained 1 Geijera parviflora :: Australian Willow 4 145 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 3X2   6005474.27283 2108090.23028 37.768723653813204 -122.42437155270201 (37.7687236538132, -122.424371552702) 8 4 5 28853 19
16 100011 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 5 600@Washington St Montgomery St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15     6011807.60069 2117536.15907 37.7950155712566 -122.40312945177 (37.7950155712566, -122.40312945177) 3 1 10 28860 4
17 100012 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 5 600@Washington St Montgomery St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15     6011815.138830001 2117505.52997 37.794931892052105 -122.403101213045 (37.7949318920521, -122.403101213045) 3 1 10 28860 4
18 100014 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 5 600@Washington St Montgomery St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     16     6011819.70044 2117479.02475 37.794859369806396 -122.403083563865 (37.7948593698064, -122.403083563865) 3 1 10 28860 4
19 100015 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 5 600 Montgomery St 14 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     19     6011789.640790001 2117672.98825 37.795390268386 -122.403201225768 (37.795390268386, -122.403201225768) 3 1 10 28860 4
20 100016 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 5 600 Montgomery St 13 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14     6011790.6974 2117658.0677 37.7953493591435 -122.403196519624 (37.7953493591435, -122.403196519624) 3 1 10 28860 4
21 100017 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 5 600 Montgomery St 12 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15     6011791.69231 2117640.10072 37.7953000816886 -122.40319181257799 (37.7953000816886, -122.403191812578) 3 1 10 28860 4
22 100018 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 5 600 Montgomery St 11 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14     6011793.71356 2117622.4512099996 37.7952517332473 -122.40318357656099 (37.7952517332473, -122.403183576561) 3 1 10 28860 4
24 10002 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 145 Guerrero St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   09/19/2014 12:50:00 PM 3 3X2   6005473.70519 2108134.2356 37.768844449829395 -122.424376646466 (37.7688444498294, -122.424376646466) 8 4 5 28853 19
34 10003 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 145 Guerrero St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3X2   6005473.24802 2108147.80938 37.7688816943622 -122.424379193367 (37.7688816943622, -122.424379193367) 8 4 5 28853 19
35 100030 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 535@Clay Washington St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     19     6012036.249419999 2117732.6252099997 37.795567786487496 -122.40235210926201 (37.7955677864875, -122.402352109262) 3 1 10 28860 4
36 100031 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 10 1199 Mason St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3   08/02/2012 12:00:00 AM 4 3x3 Permit Number 769129 6009418.42249 2117262.251 37.7941297732341 -122.411377035334 (37.7941297732341, -122.411377035334) 3 1 10 28857 21
37 100032 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 10 1199 Mason St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3   08/02/2012 12:00:00 AM   3x3 Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869) 3 1 10 28857 21
38 100033 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 10 1199 Mason St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3   08/02/2012 12:00:00 AM     Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869) 3 1 10 28857 21
39 100034 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 10 1199@Washington Mason St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3   08/02/2012 12:00:00 AM     Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869) 3 1 10 28857 21
40 100035 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 10 1199@Washington Mason St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3   08/02/2012 12:00:00 AM     Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869) 3 1 10 28857 21
41 100036 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 10 1199@Washington Mason St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3   08/02/2012 12:00:00 AM     Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869) 3 1 10 28857 21
42 100037 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 10 1199@Washington Mason St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3   08/02/2012 12:00:00 AM     Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869) 3 1 10 28857 21
43 100038 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 11 1925 Gough St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6     6005164.06417 2116434.37592 37.791617104282395 -122.42603861878901 (37.7916171042824, -122.426038618789) 13 9 1 28858 27
44 100039 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 11 1925 Gough St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6     6005166.77799 2116408.4512099996 37.7915460749308 -122.426027382675 (37.7915460749308, -122.426027382675) 13 9 1 28858 27
45 10004 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 150 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     28 3X3   6005403.33839 2108127.1988 37.768821154693896 -122.424619539876 (37.7688211546939, -122.424619539876) 8 4 5 28853 19
46 100040 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 11 1925 Gough St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6     6005169.80466 2116390.62846 37.7914973092018 -122.426015641131 (37.7914973092018, -122.426015641131) 13 9 1 28858 27
47 100041 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 11 1925 Gough St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8     6005173.38835 2116375.3440799997 37.791455544677206 -122.426002153097 (37.7914555446772, -122.426002153097) 13 9 1 28858 27
48 100042 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 11 1925 Gough St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8     6005174.91003 2116356.5458 37.79140401532911 -122.42599554934799 (37.7914040153291, -122.425995549348) 13 9 1 28858 27
53 100047 DPW Maintained 1 Ceanothus Sps :: California lilac 16 191@ 23rd Ave 23rd Ave 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1     5988664.0 2114068.0 37.7841733536199 -122.48295448443399 (37.7841733536199, -122.482954484434) 11 6 2 55 26
56 10005 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 5 156 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 3X3   6005408.68432 2108096.72474 37.7687377821415 -122.424598880629 (37.7687377821415, -122.424598880629) 8 4 5 28853 19
67 10006 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 19 165 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   01/25/1991 12:00:00 AM 6 3X2   6005478.902319999 2108028.91066 37.76855554623621 -122.42435117768999 (37.7685555462362, -122.42435117769) 8 4 5 28853 19
78 10007 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 6 170 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     20 3X3   6005407.88099 2108072.95104 37.7686724598889 -122.424599967939 (37.7686724598889, -122.424599967939) 8 4 5 28853 19
85 100076 DPW Maintained 1 Quercus tomentella :: Island oak 25 262 17th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   01/26/2016 12:00:00 AM 3 4x4 Permit Number 776532 5990584.51145 2113652.92092 37.783145223942 -122.47627994024201 (37.783145223942, -122.476279940242) 11 6 2 54 26
87 100078 DPW Maintained 1 Quercus tomentella :: Island oak 25 266 17th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   01/26/2016 12:00:00 AM 3 4x4 Permit Number 776410 5990586.53381 2113609.7978 37.7830269371305 -122.47626979286501 (37.7830269371305, -122.476269792865) 11 6 2 54 26
88 100079 DPW Maintained 1 Myoporum laetum :: Myoporum 27 1451 44th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 3x6   5982451.9345 2105243.3429 37.759579983868605 -122.503791871245 (37.7595799838686, -122.503791871245) 1 8 3 56 35
89 10008 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 6 170 Guerrero St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     22 3X3   6005410.95643 2108039.08035 37.7685796327732 -122.424586920555 (37.7685796327732, -122.424586920555) 8 4 5 28853 19
90 100080 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 701X POLK ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/18/2015 12:00:00 AM 3 3x3 Permit Number 774752 6007001.0 2113322.0 37.7831749319814 -122.419461922492 (37.7831749319814, -122.419461922492) 7 9 9 28858 36
92 100088 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 29 2034 Filbert St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11 3x3   6003201.40964 2118956.6592900003 37.7984315255609 -122.43300966237301 (37.7984315255609, -122.433009662373) 13 9 1 57 17
93 100089 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 29 2034 Filbert St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6003188.20593 2118955.0281 37.7984262977915 -122.43305523462601 (37.7984262977915, -122.433055234626) 13 9 1 57 17
94 10009 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 6 170 Guerrero St 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     22 3X3   6005412.73113 2108018.3838400003 37.7685229053392 -122.42457930959999 (37.7685229053392, -122.4245793096) 8 4 5 28853 19
105 1001 DPW Maintained 1 Ulmus pumila :: Siberian Elm 31 1731 Alemany Blvd 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     27 3X3   6001471.07065 2092002.59485 37.724323951976 -122.437066353202 (37.724323951976, -122.437066353202) 9 7 6 28861 25
106 10010 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 174 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   01/16/2002 12:00:00 AM 6 3x3   6005413.242819999 2107997.40019 37.768465318158704 -122.42457604687401 (37.7684653181587, -122.424576046874) 8 4 5 28853 19
117 10011 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 198 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     25 2X3   6005417.15338 2107897.14895 37.76819027309789 -122.424555388522 (37.7681902730979, -122.424555388522) 8 4 5 28853 19
132 100125 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 11 1800 Washington St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11     6005967.88782 2116944.18436 37.793062307639204 -122.423293649581 (37.7930623076392, -122.423293649581) 13 9 1 28858 27
133 100126 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 11 1800 Washington St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14     6005948.98718 2116940.10629 37.7930500435754 -122.423358756926 (37.7930500435754, -122.423358756926) 13 9 1 28858 27
134 100127 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 11 1800 Washington St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     13     6005919.013280001 2116937.33835 37.793040751777895 -122.423462271584 (37.7930407517779, -122.423462271584) 13 9 1 28858 27
135 100128 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 11 1800 Washington St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12     6005897.30712 2116933.8296 37.7930298924771 -122.42353712664499 (37.7930298924771, -122.423537126645) 13 9 1 28858 27
136 100129 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 155 05th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/02/2012 12:00:00 AM 3 3x3 Permit Number 769024 6011082.10119 2112775.22352 37.7819026320456 -122.40530436681401 (37.7819026320456, -122.405304366814) 12 2 9 28853 34
137 10013 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 215 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 3x2   6005495.275 2107715.11687 37.7676948680391 -122.42427222529899 (37.7676948680391, -122.424272225299) 8 4 5 28853 19
138 100130 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 155 05th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/02/2012 12:00:00 AM 3 3x3 Permit Number 769024 6011065.09249 2112790.5825400003 37.7819438533601 -122.40536429132601 (37.7819438533601, -122.405364291326) 12 2 9 28853 34
139 100131 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 155 05th St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/02/2012 12:00:00 AM 3 3x3 Permit Number 769024 6011051.59118 2112804.91213 37.781982444176705 -122.405412009362 (37.7819824441767, -122.405412009362) 12 2 9 28853 34
140 100132 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 155 05th St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/02/2012 12:00:00 AM 3 3x3 Permit Number 769024 6011001.43438 2112862.15185 37.782136806515496 -122.405589562524 (37.7821368065155, -122.405589562524) 12 2 9 28853 34
141 100133 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 155 05th St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/02/2012 12:00:00 AM 3 3x3 Permit Number 769024 6010986.38868 2112879.38733 37.7821832897709 -122.405642828459 (37.7821832897709, -122.405642828459) 12 2 9 28853 34
142 100134 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 155 05th St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/02/2012 12:00:00 AM 3 3x3 Permit Number 769024 6010970.105930001 2112898.8843900003 37.782235913593 -122.40570053346902 (37.782235913593, -122.405700533469) 12 2 9 28853 34
144 100136 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 155 05th St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/02/2012 12:00:00 AM 3 3x3 Permit Number 769024 6010957.25903 2112913.8393900003 37.782276258096296 -122.405746031954 (37.7822762580963, -122.405746031954) 12 2 9 28853 34
153 10015 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 232 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   10/24/2012 12:00:00 AM 1 2x3   6005430.70254 2107623.5907900003 37.7674399129618 -122.424489062615 (37.7674399129618, -122.424489062615) 8 4 5 28853 19
157 100153 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 590 08th Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10   Permit Number 780398 5993481.43699 2111479.23814 37.7773444498569 -122.46609982361299 (37.7773444498569, -122.466099823613) 11 6 2 54 11
158 100154 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 39 421 Arguello Blvd 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/09/2012 12:00:00 AM 2 3x3 Permit Number 768665 5995548.20979 2113421.38615 37.7827960924124 -122.459090895565 (37.7827960924124, -122.459090895565) 11 6 2 54 11
159 100155 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 39 421 Arguello Blvd 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/09/2012 12:00:00 AM 1 3x3 Permit Number 768665 5995547.63901 2113410.0857599997 37.782765031751296 -122.459092051698 (37.7827650317513, -122.459092051698) 11 6 2 54 11
160 100156 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 39 421 Arguello Blvd 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/09/2012 12:00:00 AM 2 3x3 Permit Number 768665 5995549.3318 2113386.41255 37.782700128760794 -122.45908448070101 (37.7827001287608, -122.459084480701) 11 6 2 54 11
163 100160 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 6 1699 Vallejo St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11   Permit Number 28164 6005505.58523 2118187.22554 37.7964492830571 -122.424981725648 (37.7964492830571, -122.424981725648) 13 9 1 28858 27
164 100161 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 1699 Vallejo St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2   Permit Number 28164 6005519.03005 2118189.86695 37.7964572951359 -122.42493539165599 (37.7964572951359, -122.424935391656) 13 9 1 28858 27
165 100162 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 1699 Vallejo St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3   Permit Number 28164 6005532.34096 2118193.0872400003 37.7964668890905 -122.424889562218 (37.7964668890905, -122.424889562218) 13 9 1 28858 27
166 100163 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 6 1814 Union St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     18     6004278.90656 2118759.95598 37.797952487273605 -122.429267157958 (37.7979524872736, -122.429267157958) 13 9 1 57 17
167 100164 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 6 839 Leavenworth St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 3x3   6008231.9319 2115379.46118 37.7888934760005 -122.41534908182 (37.7888934760005, -122.41534908182) 13 1 10 28858 21
168 100165 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 6 839 Leavenworth St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 3x3   6008234.89338 2115366.55149 37.7888581955857 -122.415337921201 (37.7888581955857, -122.415337921201) 13 1 10 28858 21
172 100169 DPW Maintained 1 Pinus radiata :: Monterey Pine 1 180X Manchester St   Back Yard : Yard 6 Tree 1 DPW 1         Adjacent to rear of property - DPW parcel 6008242.0 2099158.0 37.7443536844995 -122.414166136282 (37.7443536844995, -122.414166136282) 2 7 7 28859 2
173 10017 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 240 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   10/24/2012 12:00:00 AM 1 3x3   6005435.617430001 2107572.1515 37.7672989505107 -122.42446840339198 (37.7672989505107, -122.424468403392) 8 4 5 28853 19
174 100170 DPW Maintained 1 Tree(s) :: 13 2149 Grove St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/11/2012 12:00:00 AM 4 3x3 Permit Number 769012 5997531.0 2110183.0 37.774018114579896 -122.451997596236 (37.7740181145799, -122.451997596236) 15 5 11 29492 16
177 100175 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 1140 Page St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/12/2012 12:00:00 AM   3x3 Permit Number 768230 6001099.0 2109378.2 37.772012061027006 -122.43959759817301 (37.772012061027, -122.439597598173) 15 5 11 29492 9
183 100181 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 6 230 Ritch St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15     6013794.16577 2112184.81721 37.7804327665865 -122.39588042503999 (37.7804327665865, -122.39588042504) 6 2 9 28856 34
184 100182 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 6 230 Ritch St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     20     6013808.29227 2112170.33848 37.7803937971776 -122.39583053966001 (37.7803937971776, -122.39583053966) 6 2 9 28856 34
186 100184 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 480 Oxford St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11 3x3   6006818.05082 2091764.69226 37.7239732025834 -122.418565697766 (37.7239732025834, -122.418565697766) 9 7 7 309 28
187 100186 DPW Maintained 1 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 2445 HARRISON ST 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     8 3x3   6008897.0 2104213.0 37.758270352242796 -122.41225848424999 (37.7582703522428, -122.41225848425) 2 4 7 28859 19
190 100189 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 160 Palm Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 3x3 Permit Number 772698 5995944.7835 2113256.71049 37.782366726791295 -122.457707006716 (37.7823667267913, -122.457707006716) 11 6 1 54 31
198 100197 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 81 05th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/18/2012 12:00:00 AM 21   Permit Number 769099 5994240.47669 2115083.18474 37.7872836759267 -122.46373572008301 (37.7872836759267, -122.463735720083) 11 6 1 54 11
199 100198 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 81 05th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/18/2012 12:00:00 AM 22   Permit Number 769099 5994239.2285400005 2115068.80691 37.7872441264014 -122.463738994433 (37.7872441264014, -122.463738994433) 11 6 1 54 11
201 1002 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 11 1731 Alemany Blvd 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     27 3X3   6001471.07065 2092002.59485 37.724323951976 -122.437066353202 (37.724323951976, -122.437066353202) 9 7 6 28861 25
202 10020 DPW Maintained 1 Geijera parviflora :: Australian Willow 4 250 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     32 2x2   6005442.42406 2107520.98643 37.767158847823 -122.42444122050101 (37.767158847823, -122.424441220501) 8 4 5 28853 19
204 100201 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 255 Golden Gate Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3 Permit Number 51875 6008346.927130001 2112747.04212 37.7816719523255 -122.414764839028 (37.7816719523255, -122.414764839028) 7 10 9 28852 36
206 100203 DPW Maintained 1 Shrub :: Shrub 47 2237 Sutter St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     0 4x4   6001906.0 2114287.0 37.785536286354606 -122.43715765220301 (37.7855362863546, -122.437157652203) 13 6 11 29490 13
207 100204 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 2237 Sutter St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     26 5x5   6001902.2596 2114280.466 37.7855181330415 -122.437170124873 (37.7855181330415, -122.437170124873) 13 6 11 29490 13
211 100208 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 39 634 10th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 6x10   5992873.6703699995 2111136.23263 37.7763675669424 -122.468177309737 (37.7763675669424, -122.468177309737) 11 6 2 54 11
213 10021 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 274 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     17 3x4   6005443.44254 2107417.66285 37.7668752034469 -122.424430347706 (37.7668752034469, -122.424430347706) 8 4 5 28853 19
215 100211 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 701 Rhode Island St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/23/2012 12:00:00 AM 1   Permit Number 769013 6011855.60136 2105068.89592 37.7607860251716 -122.40208645763799 (37.7607860251716, -122.402086457638) 10 3 8 28856 29
216 100212 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 701 Rhode Island St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1   Permit Number 769013 6011854.68115 2105077.88991 37.760810669307496 -122.40209027256901 (37.7608106693075, -122.402090272569) 10 3 8 28856 29
217 100213 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 39 120 03rd Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/23/2012 12:00:00 AM 3 3x3 Permit Number 768999 5994920.57635 2114719.03859 37.786322995296004 -122.461356328132 (37.786322995296, -122.461356328132) 11 6 1 54 11
218 100214 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 730 Broderick St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3   6001088.1 2111178.5 37.77695461161171 -122.439764396806 (37.7769546116117, -122.439764396806) 15 5 11 29492 41
222 10022 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 10 282 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   02/01/2003 12:00:00 AM 3 2x2   6005445.78054 2107378.48496 37.766767762334794 -122.42441947400499 (37.7667677623348, -122.424419474005) 8 4 5 28853 19
229 100229 DPW Maintained 1 Alnus cordata :: Italian Alder 52 701X 39th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/05/2016 12:00:00 AM 3 3x3 Permit Number 778265 5983807.975430001 2110975.7277599997 37.7753991192247 -122.49952572567801 (37.7753991192247, -122.499525725678) 11 6 2 55 26
230 100230 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 701X 39th Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3   5983807.86909 2110960.60417 37.7753575879766 -122.49952497559799 (37.7753575879766, -122.499524975598) 11 6 2 55 26
231 100231 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 20 701X 39th Ave 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   5983808.57379 2110941.00961 37.7753038283226 -122.499521089497 (37.7753038283226, -122.499521089497) 11 6 2 55 26
232 100232 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 701X 39th Ave 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3   5983809.619390001 2110917.38856 37.775239033091104 -122.499515726535 (37.7752390330911, -122.499515726535) 11 6 2 55 26
233 100233 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 20 701X 39th Ave 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   5983810.5742 2110902.6074099997 37.775198504344104 -122.499511331076 (37.7751985043441, -122.499511331076) 11 6 2 55 26
234 100234 DPW Maintained 1 Rhamnus alaternus :: Italian Buckthorn 53 701X 39th Ave 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   5983811.49615 2110876.46915 37.7751267903243 -122.499506209788 (37.7751267903243, -122.499506209788) 11 6 2 55 26
235 100235 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 20 701X 39th Ave 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   5983812.70051 2110831.28107 37.7750027875677 -122.499498703477 (37.7750027875677, -122.499498703477) 11 6 2 55 26
236 100236 DPW Maintained 1 Rhamnus alaternus :: Italian Buckthorn 53 701X 39th Ave 9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 3x3   5983814.22353 2110811.1524900002 37.7749476096575 -122.499491947241 (37.7749476096575, -122.499491947241) 11 6 2 55 26
237 100237 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 20 701X 39th Ave 10 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   5983813.85891 2110794.08938 37.77490073789 -122.49949194725001 (37.77490073789, -122.49949194725) 11 6 2 55 26

Next page

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 448.758ms · Data source: data.sfgov.org