Street_Tree_List

Data source: data.sfgov.org

26,519 rows where qLegalStatus = 3

View and edit SQL

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
3 119263 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 495X Lakeshore Dr 1 Median : Yard 3 Tree 1 DPW 2       10x30            
5 188702 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1501 Evans Ave 2 : 4 Tree 1 DPW 2     17 Width 4ft   6015994.71985 2098219.31717 37.7422086702947 -122.387293152263 (37.7422086702947, -122.387293152263)
7 188697 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1301 Evans Ave 13 : 4 Tree 1 DPW 2     15 Width 3ft   6017236.81305 2097292.98379 37.7397338556296 -122.38293388291001 (37.7397338556296, -122.38293388291)
24 22346 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 5280 03rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/27/2014 12:00:00 AM 3 3x3   6014341.487000001 2093641.8617 37.7295482207565 -122.39268941982701 (37.7295482207565, -122.392689419827)
25 23567 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2975 Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/27/1992 12:00:00 AM 3 3X3   6005531.337230001 2120589.48411 37.803046726686894 -122.42506362870199 (37.8030467266869, -122.425063628702)
29 188686 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1300 Evans Ave 20 : 4 Tree 1 DPW 2     12 Width 3ft   6017760.57019 2097020.5910900002 37.739014844955705 -122.381104000867 (37.7390148449557, -122.381104000867)
32 10933 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 1359 Hudson Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X4   6016893.48466 2096461.5108299998 37.7374318223223 -122.384063092353 (37.7374318223223, -122.384063092353)
36 13434 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2X Market St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 4X4   6014136.36792 2117295.16476 37.7944836321678 -122.39505462349199 (37.7944836321678, -122.395054623492)
42 28375 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 3014 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/09/2003 12:00:00 AM 3 3x3 Permit Number 54020 6000248.590919999 2115494.6796 37.788757908594896 -122.442978542939 (37.7887579085949, -122.442978542939)
46 18228 DPW Maintained 3 Maytenus boaria :: Mayten 22 1737-1795 Post St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/09/2004 12:00:00 AM 12 3X3   6003682.1522 2114179.2812 37.785341320174396 -122.431004998109 (37.7853413201744, -122.431004998109)
47 17325 DPW Maintained 3 Fraxinus americana :: American Ash 23 150 Otis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/31/2016 12:00:00 AM 3 3x3   6006651.4447 2108878.4679400004 37.7709543699737 -122.420355751511 (37.7709543699737, -122.420355751511)
48 3528 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 201X Cargo Way 38 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/21/2017 04:23:00 PM 3 3X3   6018298.55272 2097894.94115 37.7414453176516 -122.37930460042801 (37.7414453176516, -122.379304600428)
69 19206 DPW Maintained 3 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 630 Sansome St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6012230.08543 2117977.14861 37.7962500076802 -122.40169859442699 (37.7962500076802, -122.401698594427)
72 25725 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 729 Grove St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6004286.7153 2111148.1106 37.777052715887706 -122.428697236196 (37.7770527158877, -122.428697236196)
74 188665 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 2175X Palou Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     37     6011669.71313 2097723.45025 37.740606653987705 -122.402212916691 (37.7406066539877, -122.402212916691)
92 98091 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 2X Frank Norris St 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   3 3x3   6007129.633230001 2115568.12393 37.789349482642606 -122.41917628075599 (37.7893494826426, -122.419176280756)
97 5266 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1245 Divisadero St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X4   6001289.7409 2112772.8314 37.781343716873 -122.43918115910401 (37.781343716873, -122.439181159104)
104 251210 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1170 Ingalls St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/02/1992 12:00:00 AM                
105 6251 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1315 Ellis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/06/2003 12:00:00 AM 24 3X3   6004480.8051 2113256.6545 37.7828532389184 -122.428176124144 (37.7828532389184, -122.428176124144)
106 10645 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 906 Hayes St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 4x4   6003455.1435 2110726.9996 37.775849351151706 -122.431543829861 (37.7758493511517, -122.431543829861)
109 9895 DPW Maintained 3 Eucalyptus Spp :: Eucalyptus 40 1800X Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6005051.0377 2115464.4068 37.7889474242075 -122.426360597873 (37.7889474242075, -122.426360597873)
112 9896 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 1800X Pine St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2007 12:00:00 AM 3 3X3   6004999.6173 2115457.4476 37.7889254092316 -122.426538009917 (37.7889254092316, -122.426538009917)
117 220007 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 929 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/12/2015 03:22:00 PM 1 Width 3ft Permit Number 24134 6006336.25046 2104153.4311599997 37.7579627654961 -122.421110461684 (37.7579627654961, -122.421110461684)
119 251215 DPW Maintained 3 Ficus nitida :: Laurel Fig 43 175X Otis St 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3X3   6006718.5849914 2108715.6870946 37.7705111956623 -122.42011195674299 (37.7705111956623, -122.420111956743)
123 18916 DPW Maintained 3 Olea europaea :: Olive Tree 41 2621 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     14 6x5   6002236.03231 2115724.70658 37.7895026155894 -122.4361187581 (37.7895026155894, -122.4361187581)
124 20281 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 20X Sunset Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60            
126 228560 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 700 Valencia St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     7 Width 3ft   6006200.30022 2105449.82338 37.761514690968596 -122.42167271244301 (37.7615146909686, -122.421672712443)
127 18052 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2840 Pine St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6000317.799 2114808.7133 37.7868783690408 -122.442689819484 (37.7868783690408, -122.442689819484)
129 20398 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 262X Sunset Blvd 43 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 60            
131 237033 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100 Octavia St 7 : 4 Tree 1 DPW 2     6 Width 4ft   6005718.98472 2109769.85153 37.7733493059578 -122.423644547079 (37.7733493059578, -122.423644547079)
135 237030 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100 Octavia St 4 : 4 Tree 1 DPW 2     5 Width 4ft   6005725.94025 2109733.85532 37.773250861665204 -122.423617927146 (37.7732508616652, -122.423617927146)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
198 103786 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 1221 Polk St 1 Sidewalk: Curb side : Pot 10 Tree 1 DPW 2   11/01/2009 12:00:00 AM 3 3x3   6006804.9894 2115120.2532 37.7881014522033 -122.420267712778 (37.7881014522033, -122.420267712778)
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)
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)
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)
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)
213 28640 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1300 Webster St 2 Median : Cutout 11 Tree 1 DPW 2   04/21/2008 12:00:00 AM 3 20   6003714.7015 2113244.5448 37.782776612799296 -122.430825656777 (37.7827766127993, -122.430825656777)
215 17196 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 2235X Octavia St 5 Median : Cutout 11 Tree 1 DPW 2     24 20   6004629.787409999 2116932.39582 37.792954330542 -122.42792271466601 (37.792954330542, -122.427922714666)
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)
223 23789 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1100X Webster St 4 Median : Cutout 11 Tree 1 DPW 2     20 20   6003791.7059 2112684.1999 37.7812424081927 -122.43051925893299 (37.7812424081927, -122.430519258933)
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)
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)
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)
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)
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)
238 251251 DPW Maintained 3 Prunus amygdalus :: Almond 63 321X Corbett Ave 2 Front Yard : Yard 7 Tree 1 DPW 2       10x10   5999565.0 2105069.0 37.7600926500434 -122.444594033425 (37.7600926500434, -122.444594033425)
239 251252 DPW Maintained 3 Prunus amygdalus :: Almond 63 321X Corbett Ave 3 Front Yard : Yard 7 Tree 1 DPW 2       10x10   5999565.0 2105069.0 37.7600926500434 -122.444594033425 (37.7600926500434, -122.444594033425)
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)
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)
247 251250 DPW Maintained 3 Prunus amygdalus :: Almond 63 321X Corbett Ave 1 Front Yard : Yard 7 Tree 1 DPW 2       10x10   5999565.0 2105069.0 37.7600926500434 -122.444594033425 (37.7600926500434, -122.444594033425)
248 23733 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 800X Webster St 8 Median : Cutout 11 Tree 1 DPW 2     35 20   6003923.026000001 2111743.9893 37.7786682616238 -122.429997867276 (37.7786682616238, -122.429997867276)
250 24634 DPW Maintained 3 Pyrus calleryana :: Ornamental Pear 9 507 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/29/2011 12:00:00 AM 3 3x3   6001641.187000001 2110229.9881 37.774381702191896 -122.437783152308 (37.7743817021919, -122.437783152308)
252 182864 DPW Maintained 3 Tree(s) :: 17 1674 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/02/2016 10:49:00 AM 1 Width 0ft   5987818.6474 2103915.1987 37.7562473553988 -122.485133888104 (37.7562473553988, -122.485133888104)
255 19810 DPW Maintained 3 Araucaria heterophylla :: Norfolk Island Pine 24 100 STAIRWAY24 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 100ST            
264 20199 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1300X Steiner St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/02/1991 12:00:00 AM 12 3X3   6002784.1975 2112923.5771 37.7818425521761 -122.434021853774 (37.7818425521761, -122.434021853774)
269 127441 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2101 Van Ness Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 Width 4ft   6005937.76794 2117668.55868 37.795049557533105 -122.423449386982 (37.7950495575331, -122.423449386982)
273 20166 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1155X Steiner St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 4X4   6002621.0 2112212.0 37.7798794773869 -122.43453554599199 (37.7798794773869, -122.434535545992)

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