home / trees

Street_Tree_List

Data source: data.sfgov.org

191,550 rows sorted by PlotSize

View and edit SQL

Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant

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
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
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
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
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
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
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
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
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
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
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
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
101 100096 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11 495 Jefferson St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6006848.2 2122207.6 37.807563959210206 -122.42062152066002 (37.8075639592102, -122.42062152066) 5 1 1 28858 32
102 100097 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11 495 Jefferson St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6006848.2 2122207.6 37.807563959210206 -122.42062152066002 (37.8075639592102, -122.42062152066) 5 1 1 28858 32
103 100098 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11 495 Jefferson St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6006848.2 2122207.6 37.807563959210206 -122.42062152066002 (37.8075639592102, -122.42062152066) 5 1 1 28858 32
104 100099 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11 495 Jefferson St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6006848.2 2122207.6 37.807563959210206 -122.42062152066002 (37.8075639592102, -122.42062152066) 5 1 1 28858 32
107 100100 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11 495 Jefferson St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6006848.2 2122207.6 37.807563959210206 -122.42062152066002 (37.8075639592102, -122.42062152066) 5 1 1 28858 32
108 100101 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11 495 Jefferson St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6006848.2 2122207.6 37.807563959210206 -122.42062152066002 (37.8075639592102, -122.42062152066) 5 1 1 28858 32
109 100102 Undocumented 3 Ficus carica :: Edible Fig 32 495@ Beach Jefferson St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6006848.2 2122207.6 37.807563959210206 -122.42062152066002 (37.8075639592102, -122.42062152066) 5 1 1 28858 32
110 100103 Undocumented 3 Pittosporum crassifolium :: Karo Tree 33 461 Jefferson St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007004.8 2122229.7 37.807633464576796 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
111 100104 Undocumented 3 Pittosporum crassifolium :: Karo Tree 33 461 Jefferson St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007004.8 2122229.7 37.807633464576796 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
112 100105 Undocumented 3 Pittosporum crassifolium :: Karo Tree 33 461 Jefferson St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007004.8 2122229.7 37.807633464576796 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
113 100106 Undocumented 3 Ficus nitida :: Laurel Fig 18 461 Jefferson St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007004.8 2122229.7 37.807633464576796 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
114 100107 Undocumented 3 Ficus nitida :: Laurel Fig 18 461 Jefferson St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007004.8 2122229.7 37.807633464576796 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
115 100108 Undocumented 3 Ficus nitida :: Laurel Fig 18 461 Jefferson St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007004.8 2122229.7 37.807633464576796 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
116 100109 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
118 100110 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
119 100111 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
120 100112 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
121 100113 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
122 100114 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
123 100115 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
124 100116 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
125 100117 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
126 100118 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 10 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
127 100119 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 11 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
128 100120 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 12 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
129 100121 Significant Tree 4 Myoporum laetum :: Myoporum 27 690 Miramar Ave 1 Front Yard : Yard 4 Tree 1 Private 2           5995444.4 2093941.6 37.729303587844704 -122.45803982404199 (37.7293035878447, -122.458039824042) 9 7 4 28861 40
130 100123 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 690 Miramar Ave 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2           5995444.4 2093941.6 37.729303587844704 -122.45803982404199 (37.7293035878447, -122.458039824042) 9 7 4 28861 40
131 100124 Significant Tree 4 Radermachera sinica :: China Doll Tree 34 40@ San Ramon Eastwood Dr 1 Front Yard : Yard 4 Tree 1 Private 2           5995635.0 2092781.0 37.7261278087338 -122.457296979484 (37.7261278087338, -122.457296979484) 9 7 4 28861 40
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
143 100135 Undocumented 3 Tree(s) :: 13 155 05th St 1 Front Yard : Yard 4 Tree 1 Private 2   11/27/2012 12:00:00 AM 9   Permit Number 769351 6011029.6 2112857.4 37.782125333955705 -122.40549178692301 (37.7821253339557, -122.405491786923) 12 2 9 28853 34
147 100139 Property Tree 5 Tree(s) :: 13 155 05th St 2 Front Yard : Yard 4 Tree 1 Private 2         Permit Number 769024 6011029.6 2112857.4 37.782125333955705 -122.40549178692301 (37.7821253339557, -122.405491786923) 12 2 9 28853 34
148 100145 Undocumented 3 Liriodendron tulipifera :: Tulip Tree 35 222X Cumberland St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6004147.2 2104574.7 37.75899582353679 -122.428711154895 (37.7589958235368, -122.428711154895) 2 4 5 28862 3
149 100146 Undocumented 3 Liriodendron tulipifera :: Tulip Tree 35 222X Cumberland St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6004147.2 2104574.7 37.75899582353679 -122.428711154895 (37.7589958235368, -122.428711154895) 2 4 5 28862 3
151 100148 Property Tree 5 Tree(s) :: 13 209 Vicksburg St   Back Yard : Yard 6 Tree 1 Private 2           6004141.0 2102142.0 37.7523158521071 -122.428559192815 (37.7523158521071, -122.428559192815) 2 4 5 28862 22
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
161 100157 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11 14 Broderick St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6001430.1 2108737.2 37.7702708737839 -122.438406367889 (37.7702708737839, -122.438406367889) 15 5 11 29492 9
162 100158 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11 14 Broderick St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/09/2012 12:00:00 AM     Permit Number 769008 6001430.1 2108737.2 37.7702708737839 -122.438406367889 (37.7702708737839, -122.438406367889) 15 5 11 29492 9
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
169 100166 Property Tree 5 Salix spp :: Willow 40 2340 Twin Peaks Blvd   Front Yard : Yard 4 Tree 1 Private 2         Permit Number 769026                    
170 100167 Permitted Site 2 Corymbia ficifolia :: Red Flowering Gum 5 710 El Camino Del Mar 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           5986405.6 2114870.0 37.7862437457696 -122.49082666767099 (37.7862437457696, -122.490826667671) 11 6 1 55 33
171 100168 Permitted Site 2 Metrosideros excelsa :: New Zealand Xmas Tree 3 710 El Camino Del Mar 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           5986405.6 2114870.0 37.7862437457696 -122.49082666767099 (37.7862437457696, -122.490826667671) 11 6 1 55 33
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
175 100171 Significant Tree 4 Quercus suber :: Cork Oak 41 109 Edgewood Ave 1 Front Yard : Yard 4 Tree 1 Private 2           5996563.8 2106359.1 37.763463224843996 -122.455066914463 (37.763463224844, -122.455066914463) 15 5 11 29492 12
178 100177 Permitted Site 2 Pinus radiata :: Monterey Pine 1 252 States St 3 Front Yard : Yard 4 Tree 1 Private 2         Permit Number 768965 6000636.0 2106677.4 37.764569975148895 -122.44100535545 (37.7645699751489, -122.44100535545) 15 5 5 28862 3
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
192 100190 Undocumented 3 Tree(s) :: 13 404 Noriega St 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2   01/07/2016 12:00:00 AM     Permit Number 776979 5992802.0 2103239.0 37.754679716601 -122.467850713731 (37.754679716601, -122.467850713731) 1 8 4 56 12

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