home / trees

Street_Tree_List

Data source: data.sfgov.org

191,550 rows

View and edit SQL

Suggested facets: qLegalStatus, PlantType, qCareAssistant

qCaretaker

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
5 100000 Permitted Site 2 Corymbia ficifolia :: Red Flowering Gum 5 600@Washington St Montgomery St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
6 100001 Undocumented 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 6 501X 01st St 2 Sidewalk: Curb side : Pot 3 Tree 1 Private 2         Address is 100 1st Street                    
7 100003 Undocumented 3 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 7 501X Mission St 2 Sidewalk: Curb side : Pot 3 Tree 1 Private 2   06/26/2012 12:00:00 AM     Permit Number 768978 6013380.8 2115570.5 37.789706063197606 -122.39754798333901 (37.7897060631976, -122.397547983339) 12 2 9 28855 6
8 100004 Permitted Site 2 Corymbia ficifolia :: Red Flowering Gum 5 600@Washington St Montgomery St 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
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
11 100007 Undocumented 3 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 7 501X Mission St 3 Sidewalk: Curb side : Pot 3 Tree 1 Private 2   06/26/2012 12:00:00 AM     Permit Number 768978 6013380.8 2115570.5 37.789706063197606 -122.39754798333901 (37.7897060631976, -122.397547983339) 12 2 9 28855 6
12 100008 Undocumented 3 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 7 501X Mission St 4 Sidewalk: Curb side : Pot 3 Tree 1 Private 2   06/26/2012 12:00:00 AM     Permit Number 768978 6013380.8 2115570.5 37.789706063197606 -122.39754798333901 (37.7897060631976, -122.397547983339) 12 2 9 28855 6
13 100009 Permitted Site 2 Corymbia ficifolia :: Red Flowering Gum 5 600@Washington St Montgomery St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 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
15 100010 Undocumented 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 6 501X Mission St 5 Sidewalk: Curb side : Pot 3 Tree 1 Private 2         Permit Number 768978 6013380.8 2115570.5 37.789706063197606 -122.39754798333901 (37.7897060631976, -122.397547983339) 12 2 9 28855 6
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
23 100019 Permitted Site 2 Corymbia ficifolia :: Red Flowering Gum 5 600 Montgomery St 10 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 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
25 100020 Permitted Site 2 Corymbia ficifolia :: Red Flowering Gum 5 600 Montgomery St 9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
26 100021 Permitted Site 2 Corymbia ficifolia :: Red Flowering Gum 5 600 Montgomery St 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
27 100022 Permitted Site 2 Corymbia ficifolia :: Red Flowering Gum 5 600 Montgomery St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
28 100023 Permitted Site 2 Corymbia ficifolia :: Red Flowering Gum 5 600 Montgomery St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
29 100025 Permitted Site 2 Corymbia ficifolia :: Red Flowering Gum 5 600 Montgomery St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
30 100026 Permitted Site 2 Corymbia ficifolia :: Red Flowering Gum 5 600 Montgomery St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
31 100027 Permitted Site 2 Corymbia ficifolia :: Red Flowering Gum 5 600 Montgomery St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
32 100028 Permitted Site 2 Corymbia ficifolia :: Red Flowering Gum 5 600 Montgomery St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
33 100029 Permitted Site 2 Corymbia ficifolia :: Red Flowering Gum 5 600 Montgomery St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
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
49 100043 Significant Tree 4 Tree(s) :: 13 50 Bronte St 1 Front Yard : Yard 4 Tree 1 Private 2   07/12/2012 12:00:00 AM     Permit Number 769001 6009337.0 2097155.0 37.7389153282678 -122.41023844976401 (37.7389153282678, -122.410238449764) 10 7 7 28859 2
50 100044 Permitted Site 2 Olea europaea 'Fruitless' :: Fruitless Olive 14 1250 De Haro St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/27/2012 12:00:00 AM   3x3 Permit Number 768984 6012201.0 2102568.4 37.7539394855375 -122.400716201774 (37.7539394855375, -122.400716201774) 10 3 8 28856 29
51 100045 Property Tree 5 Acacia decurrens :: Acacia: Silver Wattle 15 556 28th St   Front Yard : Yard 4 Tree 1 Private 2         Not sure which property tree is located on. 6002301.0 2099461.0 37.7448501592716 -122.434730501666 (37.7448501592716, -122.434730501666) 2 7 5 63 22
52 100046 Property Tree 5 Tree(s) :: 13 562 28th St   Front Yard : Yard 4 Tree 1 Private 2   11/28/2012 12:00:00 AM 17   Permit Number 769057 6002262.0 2099459.0 37.7448424535299 -122.43486521318898 (37.7448424535299, -122.434865213189) 2 7 5 63 22
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
54 100048 Permitted Site 2 Melaleuca quinquenervia :: Cajeput 17 1445 Cabrillo St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/22/2012 12:00:00 AM   3x3 Permit Number 769137 5991161.0 2110614.0 37.7748345969519 -122.47406374416 (37.7748345969519, -122.47406374416) 11 6 2 54 26
55 100049 Permitted Site 2 Ficus nitida :: Laurel Fig 18 3233X Buchanan St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3 Permit Number 768990 6003300.0 2119605.0 37.800217292537106 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
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
57 100050 Undocumented 3 Ficus nitida :: Laurel Fig 18 3233X Buchanan St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6003300.0 2119605.0 37.800217292537106 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
58 100051 Undocumented 3 Ficus nitida :: Laurel Fig 18 3233X Buchanan St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6003300.0 2119605.0 37.800217292537106 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
59 100052 Undocumented 3 Ficus nitida :: Laurel Fig 18 3233X Buchanan St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6003300.0 2119605.0 37.800217292537106 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
60 100053 Undocumented 3 Ficus nitida :: Laurel Fig 18 3233X Buchanan St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6003300.0 2119605.0 37.800217292537106 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
61 100054 Significant Tree 4 Lophostemon confertus :: Brisbane Box 9 401X Tehama St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011330.4 2112435.9 37.78098480794971 -122.404421471201 (37.7809848079497, -122.404421471201) 14 2 9 28853 34
62 100055 Significant Tree 4 Lophostemon confertus :: Brisbane Box 9 401X Tehama St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011330.4 2112435.9 37.78098480794971 -122.404421471201 (37.7809848079497, -122.404421471201) 14 2 9 28853 34
63 100056 Significant Tree 4 Lophostemon confertus :: Brisbane Box 9 401X Tehama St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011330.4 2112435.9 37.78098480794971 -122.404421471201 (37.7809848079497, -122.404421471201) 14 2 9 28853 34
64 100057 Undocumented 3 Tree(s) :: 13 240 05th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/28/2012 12:00:00 AM 12 3x3 Permit Number 769058 6011351.0 2112431.0 37.780972504862596 -122.40434986022801 (37.7809725048626, -122.404349860228) 14 2 9 28853 34
65 100058 Undocumented 3 Tree(s) :: 13 240 05th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/28/2012 12:00:00 AM 12 3x3 Permit Number 769058 6011351.0 2112431.0 37.780972504862596 -122.40434986022801 (37.7809725048626, -122.404349860228) 14 2 9 28853 34
66 100059 Section 143 6 Lophostemon confertus :: Brisbane Box 9 260 05th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011435.0 2112345.0 37.7807410625565 -122.404053207068 (37.7807410625565, -122.404053207068) 14 2 9 28853 34
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
68 100060 Section 143 6 Lophostemon confertus :: Brisbane Box 9 260 05th St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011435.0 2112345.0 37.7807410625565 -122.404053207068 (37.7807410625565, -122.404053207068) 14 2 9 28853 34
69 100061 Undocumented 3 Tree(s) :: 13 430X Clementina St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/28/2012 12:00:00 AM   3x3 Permit Number 768595 6011459.0 2112320.0 37.780673759287204 -122.40396841919399 (37.7806737592872, -122.403968419194) 14 2 9 28853 34
70 100062 Undocumented 3 Tree(s) :: 13 430X Clementina St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/28/2012 12:00:00 AM   3x3 Permit Number 768595 6011459.0 2112320.0 37.780673759287204 -122.40396841919399 (37.7806737592872, -122.403968419194) 14 2 9 28853 34
71 100063 Undocumented 3 Tree(s) :: 13 430X Clementina St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/28/2012 12:00:00 AM   3x3 Permit Number 768595 6011459.0 2112320.0 37.780673759287204 -122.40396841919399 (37.7806737592872, -122.403968419194) 14 2 9 28853 34
72 100064 Undocumented 3 Tree(s) :: 13 430X Clementina St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/28/2012 12:00:00 AM   3x3 Permit Number 768595 6011459.0 2112320.0 37.780673759287204 -122.40396841919399 (37.7806737592872, -122.403968419194) 14 2 9 28853 34
73 100065 Permitted Site 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 20 322 Duncan St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/29/2012 12:00:00 AM   3x3 Permit Number 58746 6004276.4 2099889.0 37.7461372993162 -122.427930429145 (37.7461372993162, -122.427930429145) 2 7 5 63 22
74 100066 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 93 Buena Vista Ter 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/29/2012 12:00:00 AM   2x2 Permit Number 768610 6001505.1 2107681.4 37.76737617437121 -122.438071302911 (37.7673761743712, -122.438071302911) 15 5 5 29492 3
75 100067 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 93 Buena Vista Ter 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       2x2 On property line with 99 Buena Vista Ter 6001505.1 2107681.4 37.76737617437121 -122.438071302911 (37.7673761743712, -122.438071302911) 15 5 5 29492 3
76 100068 Permitted Site 2 Pinus canariensis :: Canary Island Pine 22 303 Serrano Dr 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/13/2012 12:00:00 AM     Permit Number 769006 5990392.0 2090762.0 37.720281613079 -122.47527420247 (37.720281613079, -122.47527420247) 1 8 4 64 40
77 100069 Permitted Site 2 Pinus radiata :: Monterey Pine 1 619 Gonzalez Dr 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/13/2012 12:00:00 AM     Permit Number 769006 5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722) 1 8 4 64 40
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
79 100070 Property Tree 5 Tree(s) :: 13 331 Serrano Dr 1 Front Yard : Yard 4 Tree 1 Private 2         Permit Number 777990 5990400.0 2090718.0 37.7201612636948 -122.47524333880699 (37.7201612636948, -122.475243338807) 1 8 4 64 40
80 100071 Undocumented 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 23 96X Douglass St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3 Address is 4200-4204 17th St 6001034.7 2105837.1 37.7622854187027 -122.439566119284 (37.7622854187027, -122.439566119284) 15 5 5 28862 3
81 100072 Undocumented 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 23 96X Douglass St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3 Address is 1200-1204 17th St 6001034.7 2105837.1 37.7622854187027 -122.439566119284 (37.7622854187027, -122.439566119284) 15 5 5 28862 3
82 100073 Permitted Site 2 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 24 930@ Lorraine Ct Anza St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/02/2012 12:00:00 AM   3x3 Permit Number 769060 5996162.0 2112255.0 37.7796287713947 -122.45688306406099 (37.7796287713947, -122.456883064061) 11 6 2 54 16
83 100074 Undocumented 3 Tree(s) :: 13 701 Noe St   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6003070.0 2104166.0 37.7578126071811 -122.43240742658399 (37.7578126071811, -122.432407426584) 2 4 5 28862 3
84 100075 Undocumented 3 Tree(s) :: 13 707-709 Noe St   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6003067.0 2104139.0 37.757738301523105 -122.43241587342699 (37.7577383015231, -122.432415873427) 2 4 5 28862 3
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
86 100077 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 260 Page St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6005310.0 2109942.0 37.7737988894613 -122.42507153447501 (37.7737988894613, -122.425071534475) 7 9 11 28852 10
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
91 100087 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 2028 Filbert St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6003216.8 2118972.8 37.798476716718895 -122.432957560795 (37.7984767167189, -122.432957560795) 13 9 1 57 17
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
95 100090 Undocumented 3 Corymbia ficifolia :: Red Flowering Gum 5 11X Shotwell St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6007856.7 2107724.0 37.7678523153445 -122.416104954993 (37.7678523153445, -122.416104954993) 8 4 7 28853 19
96 100091 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 11X Shotwell St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3x3   6007856.7 2107724.0 37.7678523153445 -122.416104954993 (37.7678523153445, -122.416104954993) 8 4 7 28853 19
97 100092 Undocumented 3 Tree(s) :: 13 11X Shotwell St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6007856.7 2107724.0 37.7678523153445 -122.416104954993 (37.7678523153445, -122.416104954993) 8 4 7 28853 19
98 100093 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 11X Shotwell St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6007856.7 2107724.0 37.7678523153445 -122.416104954993 (37.7678523153445, -122.416104954993) 8 4 7 28853 19
99 100094 Undocumented 3 Corymbia ficifolia :: Red Flowering Gum 5 11X Shotwell St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6007856.7 2107724.0 37.7678523153445 -122.416104954993 (37.7678523153445, -122.416104954993) 8 4 7 28853 19
100 100095 Permitted Site 2 Tree(s) :: 13 4372 26th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3 Private 1 07/03/2012 12:00:00 AM   3x3 Permit Number 769070 6001507.0 2100613.7 37.747970090970504 -122.43755853273001 (37.7479700909705, -122.43755853273) 2 4 5 28862 22

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