Street_Tree_List

Data source: data.sfgov.org

189,144 rows sorted by qSiteInfo

View and edit SQL

These facets timed out: qLegalStatus

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo ▼ PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
134 47510 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 54X Cayuga Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/27/2017 12:00:00 AM 3 3x3 Permit Number 45390 6003705.560409999 2094600.28554 37.731583388063 -122.42952721221901 (37.731583388063, -122.429527212219)
136 213016 Undocumented 2 Tree(s) :: 17 120 Ortega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/27/2017 12:00:00 AM 3 Width 2ft Permit Number 779661 5993626.83548 2102594.2327400004 37.7529569465285 -122.4649514087 (37.7529569465285, -122.4649514087)
137 228561 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 700 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     7 Width 3ft   6006199.77605 2105468.2728 37.7615653191939 -122.42167583577299 (37.7615653191939, -122.421675835773)
140 6337 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 1916 Ellis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6001700.9234 2112915.307 37.7817583075946 -122.437768878541 (37.7817583075946, -122.437768878541)
141 832 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1396 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/2017 12:18:00 PM 3 3X3   5981551.7086 2105613.8347 37.7605442750604 -122.50693272862101 (37.7605442750604, -122.506932728621)
142 251241 Undocumented 2 Cupressocyparis leylandii :: Leyland Cypress 34 2305 Golden Gate Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5998495.0 2111363.0 37.777313260379 -122.44874797929701 (37.777313260379, -122.448747979297)
143 18836 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2055 Sacramento St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6004953.14987 2116100.2629400003 37.7906877916676 -122.426744576702 (37.7906877916676, -122.426744576702)
144 11598 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 4134 Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/28/2017 11:51:00 AM 3 3X3   5981663.7126 2105589.2786 37.760483446414796 -122.506543543521 (37.7604834464148, -122.506543543521)
145 111561 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1498x Kansas St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/28/2017 12:00:00 AM 3 3x3 Permit Number 779654 6011715.78319 2101470.3886700002 37.7508975116216 -122.40231700873699 (37.7508975116216, -122.402317008737)
146 97319 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1038 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/28/2017 12:52:00 PM 3 3x3   5989945.5882 2099070.048 37.7430675136338 -122.477424174253 (37.7430675136338, -122.477424174253)
147 58021 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 4026 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/28/2017 12:07:00 PM 3   Permit Number 16988 5983218.6194 2106316.5419 37.7625717348083 -122.50121971656999 (37.7625717348083, -122.50121971657)
148 175046 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 80X Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     4 Width 3ft   5991566.54873 2087591.2585200001 37.7116435395983 -122.47098334961399 (37.7116435395983, -122.470983349614)
149 26071 DPW Maintained 3 Melaleuca quinquenervia :: Cajeput 50 247 Orizaba Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/2017 01:41:00 PM 3 3X3   5993990.1569314 2088190.8403771 37.7134297247264 -122.46265023824101 (37.7134297247264, -122.462650238241)
150 11606 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 4200x Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/2017 11:54:00 AM 3 3X3   5981492.2847 2105581.1189 37.76045094714279 -122.507135818078 (37.7604509471428, -122.507135818078)
151 36617 Permitted Site 1 Robinia x ambigua :: Locust 33   8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/20/1998 12:00:00 AM     Permit Number 39461          
152 24532 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1395 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/2017 12:21:00 PM 3 3X3   5981507.2257 2105680.0147 37.7607233666377 -122.50709148147499 (37.7607233666377, -122.507091481475)
153 5972 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1550 Eddy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/02/1990 12:00:00 AM 8 3X3   6003044.0843 2112751.363 37.7813844410266 -122.43311045884899 (37.7813844410266, -122.433110458849)
154 830 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1384 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/2017 12:15:00 PM 3 5.5x6.5   5981549.5887 2105676.5499 37.7607163481902 -122.506944712409 (37.7607163481902, -122.506944712409)
155 251225 Undocumented 2 Jacaranda mimosifolia :: Jacaranda 52 1 Yukon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       12x2.5   6000238.0 2104757.0 37.7592743544717 -122.442244057145 (37.7592743544717, -122.442244057145)
156 54712 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 4508 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/28/2017 11:58:00 AM 3 3x3 Permit Number 10547 5981730.2931 2106265.9364 37.762345274891 -122.506363455406 (37.762345274891, -122.506363455406)
157 3193 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 3698 California St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 3X3   5996969.37189 2114704.2549799997 37.7864001056199 -122.454266992435 (37.7864001056199, -122.454266992435)
158 21682 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1830 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/2017 12:00:00 AM 3 4x4   6003825.2217 2114604.0634 37.7865157709252 -122.43054034167 (37.7865157709252, -122.43054034167)
159 97322 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1055 Taraval St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/28/2017 12:42:00 PM 3 3x3   5989910.3078 2099001.0945 37.7428761380219 -122.477541124233 (37.7428761380219, -122.477541124233)
160 175377 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 80X Junipero Serra Blvd 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5991371.46907 2088876.77956 37.715161983326794 -122.471751215951 (37.7151619833268, -122.471751215951)
161 142720 Undocumented 2 :: 54 1170 COLUMBUS AVE 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 0ft   6007999.4825 2121188.7351 37.8048312311886 -122.416565007078 (37.8048312311886, -122.416565007078)
162 251231 Undocumented 2 Pinus radiata :: Monterey Pine 3 164 Serrano Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5989598.0 2090848.0 37.7204716934452 -122.478025052476 (37.7204716934452, -122.478025052476)
163 29943 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 242 Broad St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/2017 12:23:00 PM 3 3x3   5994593.32204167 2088106.90572275 37.7132339790874 -122.460559423837 (37.7132339790874, -122.460559423837)
164 97323 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1011 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/28/2017 12:25:00 PM 3 3x3   5990005.0659 2099005.494 37.7428937161431 -122.477213802134 (37.7428937161431, -122.477213802134)
165 11582 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 4000 Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/2017 11:49:00 AM 3 3X3   5982109.291 2105604.0369 37.760550193841404 -122.505003612665 (37.7605501938414, -122.505003612665)
166 251230 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 99x Ogden Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6007537.0 2096150.0 37.7360547576169 -122.416390866966 (37.7360547576169, -122.416390866966)
167 251232 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 99x Ogden Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6007537.0 2096150.0 37.7360547576169 -122.416390866966 (37.7360547576169, -122.416390866966)
169 251221 Permitted Site 1 Tree(s) :: 17 2401X Washington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/28/2017 12:00:00 AM 3 3x3 Permit Number 778039          
170 48827 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 435 Pacific Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/07/2002 12:00:00 AM 5 3x3 Permit Number 46051 6011929.23024 2118387.60951 37.79736024144329 -122.402768502565 (37.7973602414433, -122.402768502565)
172 48332 Permitted Site 1 Tree(s) :: 17   142 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
173 175044 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 80x Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     19 Width 3ft   5991568.948890001 2087568.2224599998 37.7115804269636 -122.470973377029 (37.7115804269636, -122.470973377029)
174 251226 Undocumented 2 Koelreuteria paniculata :: Golden Rain Tree 56 1 Yukon St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       13x2.5   6000262.0 2104839.0 37.7595008741196 -122.442166940047 (37.7595008741196, -122.442166940047)
175 17881 DPW Maintained 3 Olea europaea :: Olive Tree 41 2205 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6003346.6048 2115178.7939 37.7880667103656 -122.432237297056 (37.7880667103656, -122.432237297056)
176 24515 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 2030 Fell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/07/2016 07:40:00 AM 3 3X3   5997710.2902 2109583.0289 37.772381016672895 -122.45133412385 (37.7723810166729, -122.45133412385)
177 97317 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1000 Taraval St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/28/2017 12:59:00 PM 3 3x3   5990071.4812 2099073.5168 37.7430843422325 -122.476989128346 (37.7430843422325, -122.476989128346)
178 2985 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2253 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     65 3X3   6003588.0004 2115559.2302 37.789124975971106 -122.431429279776 (37.7891249759711, -122.431429279776)
179 182083 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1101 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/2017 12:33:00 PM 3 Width 0ft   5989775.2775 2098997.3719 37.742858080169505 -122.47800774412599 (37.7428580801695, -122.478007744126)
180 18700 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 100X Richardson Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   5999457.6873699995 2119517.78462 37.799759164102895 -122.44600442526199 (37.7997591641029, -122.446004425262)
181 9914 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1900 Gough St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     126 3X3   6005235.69262 2116267.9294 37.7911641319684 -122.42577893234899 (37.7911641319684, -122.425778932349)
182 93463 DPW Maintained 3 Prunus x 'Amanogawa' :: Flowering Cherry 57 1739 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/2017 01:05:00 PM 3 3x3   5987772.1588 2098929.0107 37.7425539090053 -122.48492886712098 (37.7425539090053, -122.484928867121)
183 15429 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2125 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/09/2015 12:00:00 AM 15 4X4   6006871.98757 2105962.63928 37.762960616913205 -122.41938599878401 (37.7629606169132, -122.419385998784)
184 138801 Permitted Site 1 Maytenus boaria :: Mayten 22 2375 PINE ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/09/1997 12:00:00 AM 2 Width 0ft   6002525.8905 2115062.7753 37.787701584977704 -122.43506851988899 (37.7877015849777, -122.435068519889)
185 251243 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 299x Chapman St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6008953.0 2098186.0 37.7417246968109 -122.411638974942 (37.7417246968109, -122.411638974942)
186 138359 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2060 SUTTER ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 Width 0ft   6002861.592 2114464.6761 37.7860784126894 -122.43386429175101 (37.7860784126894, -122.433864291751)
187 251248 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 829 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6001839.0 2095802.0 37.7347771581377 -122.436066227259 (37.7347771581377, -122.436066227259)
188 138368 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2060 SUTTER ST 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     13 Width 0ft   6002679.2262 2114443.3671 37.786009553218996 -122.434493703661 (37.786009553219, -122.434493703661)
189 138807 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2355 PINE ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     13 Width 0ft   6002661.6347 2115086.2451 37.7877737339769 -122.434600550462 (37.7877737339769, -122.434600550462)
190 57209 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 2898 Clay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/15/2014 12:00:00 AM 3   Permit Number 773671 6000999.92024 2115926.87738 37.7899874194288 -122.440410066565 (37.7899874194288, -122.440410066565)
191 210495 Undocumented 2 Myoporum laetum :: Myoporum 1 365 San Leandro Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 3ft Permit Number 779799 5992304.44524 2094447.3559700001 37.7305113566072 -122.468931622808 (37.7305113566072, -122.468931622808)
192 138369 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2060 SUTTER ST 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 Width 0ft   6002665.8461 2114439.4026 37.78599790817471 -122.434539711553 (37.7859979081747, -122.434539711553)
193 6069 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 1930 Eddy St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/2015 12:00:00 AM 3 3X3   6001175.3543 2112495.6639 37.7805761758993 -122.439557004629 (37.7805761758993, -122.439557004629)
194 138802 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2375 PINE ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 0ft   6002539.8455 2115065.9469 37.787711085766894 -122.435020465254 (37.7877110857669, -122.435020465254)
195 138365 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2060 SUTTER ST 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     19 Width 0ft   6002748.6045 2114451.296 37.78603526200121 -122.43425424087799 (37.7860352620012, -122.434254240878)
196 251246 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 722X Mendell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3X3   6016169.292972799 2097000.9113916 37.738872842648796 -122.38660458641 (37.7388728426488, -122.38660458641)
197 251245 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 701 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/04/1992 12:00:00 AM       6002463.96916 2095671.24377 37.73445361741221 -122.433896153002 (37.7344536174122, -122.433896153002)
199 138362 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2060 SUTTER ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 Width 0ft   6002806.585 2114457.2427 37.78605488083279 -122.434054069465 (37.7860548808328, -122.434054069465)
200 134567 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 99 Grove St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Dept of Real Estate 5   07/06/2011 12:00:00 AM 4 Width 4ft   6007561.6986 2111595.58464 37.778466176805296 -122.417399738421 (37.7784661768053, -122.417399738421)
201 138367 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2060 SUTTER ST 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 Width 0ft   6002691.6152 2114444.3582 37.7860129777854 -122.434450912019 (37.7860129777854, -122.434450912019)
202 138810 DPW Maintained 3 Maytenus boaria :: Mayten 22 2355 PINE ST 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     11 Width 0ft   6002718.089 2115091.954 37.787792613821004 -122.434405637805 (37.787792613821, -122.434405637805)
203 134565 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 99 Grove St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Dept of Real Estate 5     15 Width 4ft   6007431.26589 2111583.6583 37.7784260904314 -122.41785010990299 (37.7784260904314, -122.417850109903)
204 61453 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/22/1984 12:00:00 AM     Permit Number 21392          
205 134566 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 99 Grove St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Dept of Real Estate 5     14 Width 4ft   6007493.55732 2111589.9734900002 37.7784469358085 -122.417635067622 (37.7784469358085, -122.417635067622)
206 4750 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1201 Columbus Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     50 3X3   6007660.31382 2121409.3470799997 37.8054178953714 -122.417754386066 (37.8054178953714, -122.417754386066)
207 138805 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2355 PINE ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     11 Width 0ft   6002622.3069 2115079.2676 37.787752342886 -122.434736117903 (37.787752342886, -122.434736117903)
208 100305 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 3701 Buchanan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6003064.411830001 2121045.8637900003 37.804160163827206 -122.433633107497 (37.8041601638272, -122.433633107497)
209 134568 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 99 Grove St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Dept of Real Estate 5   12/17/2009 12:00:00 AM 5 Width 4ft   6007669.37768 2111613.23365 37.778520694605795 -122.41702848568501 (37.7785206946058, -122.417028485685)
210 13438 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2X Market St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/12/2002 12:00:00 AM 6 4x4   6014077.43398 2117238.82075 37.794325647358704 -122.395254594939 (37.7943256473587, -122.395254594939)
211 138370 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2060 SUTTER ST 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 Width 0ft   6002647.5104 2114436.9248 37.7859900638921 -122.434602970779 (37.7859900638921, -122.434602970779)
212 138800 DPW Maintained 3 Maytenus boaria :: Mayten 22 2375 PINE ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     7 Width 0ft   6002511.9355 2115060.8724 37.7876955676952 -122.435116665287 (37.7876955676952, -122.435116665287)
214 251244 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 99 Grove St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Dept of Real Estate 5   05/29/2013 12:00:00 AM       6007340.02606 2111591.01475 37.778441154342296 -122.41816626519301 (37.7784411543423, -122.418166265193)
216 138364 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2060 SUTTER ST 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 Width 0ft   6002783.7892 2114453.2783 37.7860427018539 -122.43413265320801 (37.7860427018539, -122.434132653208)
217 138366 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2060 SUTTER ST 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 Width 0ft   6002708.9598 2114445.3493 37.7860166836287 -122.43439097535801 (37.7860166836287, -122.434390975358)
218 11423 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 722X Mendell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     0 3X3   6016169.292972799 2097000.9113916 37.738872842648796 -122.38660458641 (37.7388728426488, -122.38660458641)
219 138804 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2375 PINE ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     1 Width 0ft   6002587.4194 2115073.5588 37.787734687268795 -122.43485641346001 (37.7877346872688, -122.43485641346)
220 138363 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2060 SUTTER ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 Width 0ft   6002798.656 2114455.2605 37.7860489882217 -122.434081359893 (37.7860489882217, -122.434081359893)
221 138361 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2060 SUTTER ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 Width 0ft   6002830.8674 2114461.7028 37.78606850519029 -122.433970377911 (37.7860685051903, -122.433970377911)
222 251247 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 722X Mendell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3X3   6016169.292972799 2097000.9113916 37.738872842648796 -122.38660458641 (37.7388728426488, -122.38660458641)
224 117019 Planning Code 138.1 required 4 Metrosideros excelsa :: New Zealand Xmas Tree 2 168 Hyde St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008121.68381 2113004.40875 37.782365960952 -122.41556230388201 (37.782365960952, -122.415562303882)
225 138808 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2355 PINE ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/06/2015 11:29:00 AM 5 Width 0ft   6002680.0299 2115089.4167 37.787783486631206 -122.434537133485 (37.7877834866312, -122.434537133485)
226 220498 Permitted Site 1 Acer rubrum :: Red Maple 6 217 Douglass St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/1972 12:00:00 AM 8 Width 3ft Permit Number 11470 6001117.07632 2105053.576 37.760138741716794 -122.43922504972001 (37.7601387417168, -122.43922504972)
227 13622 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 562 Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4x4   6012358.746590001 2115584.5782 37.789687756343604 -122.401085198325 (37.7896877563436, -122.401085198325)
228 246283 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2125 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     17 Width 0ft   6006872.377 2105970.5198 37.7629822769131 -122.419385210964 (37.7629822769131, -122.419385210964)
229 138803 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2375 PINE ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   6002563.9496 2115068.4842 37.787719421164496 -122.434937251329 (37.7877194211645, -122.434937251329)
230 138371 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2060 SUTTER ST 13 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     17 Width 0ft   6002611.3346 2114434.4469999997 37.785981206770394 -122.434727951803 (37.7859812067704, -122.434727951803)
231 138360 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2060 SUTTER ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     14 Width 0ft   6002847.7164 2114462.1983 37.7860708218731 -122.433912120385 (37.7860708218731, -122.433912120385)
232 2726 Permitted Site 1 Callistemon citrinus :: Lemon Bottlebrush 28 2211 Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6002817.4873 2114756.5606 37.7868773504916 -122.43403775447099 (37.7868773504916, -122.434037754471)
233 121240 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 91 Commonwealth Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/07/2016 12:00:00 AM 3 3x5 Permit Number 778926 5996501.4108 2113948.5087 37.7842981813685 -122.45583135787399 (37.7842981813685, -122.455831357874)
234 26932 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1570 Golden Gate Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/05/2000 12:00:00 AM 3 3X3   6002097.1307 2111930.5841 37.7790770280177 -122.43632769328998 (37.7790770280177, -122.43632769329)
235 45975 Permitted Site 1 Tree(s) :: 17   132 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
236 8118 Permitted Site 1 Acer rubrum :: Red Maple 6 841 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/15/2005 12:00:00 AM 3 3X3   6003718.373 2111409.0283 37.777736949412606 -122.430681932079 (37.7777369494126, -122.430681932079)
237 2654 DPW Maintained 3 Maytenus boaria :: Mayten 22 1988 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/30/2005 12:00:00 AM 12 3X3   6004003.2237 2114978.8425 37.7875549020514 -122.429951242636 (37.7875549020514, -122.429951242636)
242 194017 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 717 Mendell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     22 Width 4ft   6016141.23024 2096883.95841 37.7385501598741 -122.386693461838 (37.7385501598741, -122.386693461838)
243 2928 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1834 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X3   6005568.20527 2115901.70542 37.7901773571486 -122.42460238530501 (37.7901773571486, -122.424602385305)
244 9908 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 1809 Gough St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     14 6x6   6005225.98494 2115998.17525 37.79042290624211 -122.425793311632 (37.7904229062421, -122.425793311632)
245 251255 Undocumented 2 Tree(s) :: 17 4089x Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5991686.0 2086822.0 37.7095382490701 -122.47051450746099 (37.7095382490701, -122.470514507461)
246 251253 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 1350 Howard St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6008544.9526 2110145.4696299997 37.774539777213995 -122.413895673958 (37.774539777214, -122.413895673958)

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" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 219.767ms · Data source: data.sfgov.org