home / trees

Street_Tree_List

Data source: data.sfgov.org

191,550 rows sorted by DBH

View and edit SQL

Suggested facets: qLegalStatus, qCaretaker, qCareAssistant

PlantType

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
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
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
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
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
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
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
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
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
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
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
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
145 100137 Undocumented 3 Tree(s) :: 13 155 05th St 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3 Permit Number 769024 6011029.6 2112857.4 37.782125333955705 -122.40549178692301 (37.7821253339557, -122.405491786923) 12 2 9 28853 34
146 100138 Undocumented 3 Tree(s) :: 13 155 05th St 9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3 Permit Number 769024 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
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
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
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
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
179 100178 Permitted Site 2 Olea europaea :: Olive Tree 42 1270 Sanchez St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/06/2012 12:00:00 AM   3x3   6003851.0 2100874.0 37.748817804949496 -122.42947164058 (37.7488178049495, -122.42947164058) 2 4 5 28862 22
180 100179 Permitted Site 2 Olea europaea :: Olive Tree 42 1270 Sanchez St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/06/2012 12:00:00 AM   3x3   6003851.0 2100874.0 37.748817804949496 -122.42947164058 (37.7488178049495, -122.42947164058) 2 4 5 28862 22
182 100180 Undocumented 3 Liquidambar styraciflua :: American Sweet Gum 44 100x BELVEDERE ST 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5997991.0 2108152.0 37.768467847026294 -122.450259955793 (37.7684678470263, -122.450259955793) 15 5 11 29492 9
185 100183 Permitted Site 2 Tree(s) :: 13 956 Noe St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6003075.2 2102641.9 37.7536280862965 -122.432280596021 (37.7536280862965, -122.432280596021) 2 4 5 28862 22
188 100187 Permitted Site 2 Callistemon citrinus :: Lemon Bottlebrush 45 217 Montcalm St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/18/2012 12:00:00 AM   3x3 Permit Number 768935 6009833.3 2099565.6 37.7455621186719 -122.40869248022899 (37.7455621186719, -122.408692480229) 2 7 7 28859 2
189 100188 Permitted Site 2 Callistemon citrinus :: Lemon Bottlebrush 45 217 Montcalm St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/18/2012 12:00:00 AM   3x3 Permit Number 768935 6009833.3 2099565.6 37.7455621186719 -122.40869248022899 (37.7455621186719, -122.408692480229) 2 7 7 28859 2
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
193 100191 Significant Tree 4 Pinus radiata :: Monterey Pine 1 1201 Holloway Ave 1 Front Yard : Yard 4 Tree 1 Private 2           5992431.5 2091178.1 37.721542125529396 -122.46825464021099 (37.7215421255294, -122.468254640211) 9 8 6 64 24
194 100192 Undocumented 3 Magnolia grandiflora :: Southern Magnolia 39 62 Nordhoff St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2       3x6   6000448.0 2095531.0 37.7339539318334 -122.440855946438 (37.7339539318334, -122.440855946438) 9 7 5 63 40
195 100193 Significant Tree 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 361 Dellbrook Ave 1 Front Yard : Yard 4 Tree 1 Private 2           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969) 1 5 4 63 38
196 100194 Significant Tree 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 361 Dellbrook Ave 2 Front Yard : Yard 4 Tree 1 Private 2           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969) 1 5 4 63 38

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