142,615 rows where qLegalStatus_id = 1

View and edit SQL

rowid ▼ TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
154 119838 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 11 Median : Cutout Tree DPW 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
155 142339 DPW Maintained 1 :: 45 516 Central Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5999737.6235 2110265.9409 37.7743719952599 -122.444370497086 (37.7743719952599, -122.444370497086) 15 5 11 29492 16
156 222165 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 953 Elizabeth St 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   6000303.11526 2101951.8939 37.7515759277946 -122.441817532557 (37.7515759277946, -122.441817532557) 2 4 5 28862 22
160 107490 DPW Maintained 1 Prunus spp :: Cherry 68 1306x Montgomery St 19 Median : Cutout Tree DPW 1     12     6011447.18476 2119974.76336 37.8016912541172 -122.404548295963 (37.8016912541172, -122.404548295963) 3 1 10 308 23
161 194506 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 299x Cashmere St 26 Median : Yard Tree DPW 1     18     6016624.93937 2096021.78221 37.7362095654157 -122.384960961105 (37.7362095654157, -122.384960961105) 10 3 8 58 1
163 17253 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 15 Osceola Ln 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6017345.102761 2094248.0837329 37.7313791485056 -122.382347671583 (37.7313791485056, -122.382347671583) 10 3 8 58 1
166 8632 DPW Maintained 1 Myoporum laetum :: Myoporum 62 2600 Geary Blvd 20 Median : Cutout Tree DPW 1     12 20   5999387.1761445 2113256.6615953 37.7825637442266 -122.445797886011 (37.7825637442266, -122.445797886011) 15 5 1 29490 31
167 99668 DPW Maintained 1 Tree(s) :: 17 150X Alma St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   8 3x3   5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
168 222969 DPW Maintained 1 Corymbia maculata :: Spotted Gum 69 1300 San Jose Ave 47 Front Yard : Yard Tree Private 2     16     6003392.92926 2095549.99469 37.7341733681018 -122.430675784084 (37.7341733681018, -122.430675784084) 2 7 5 63 7
169 258020 DPW Maintained 1 Tree(s) :: 17 1001X San Jose Ave 1 Side Yard : Yard Tree Private 2       3x3   6004855 2096548 37.7369963898236 -122.425691948858 (37.7369963898236, -122.425691948858) 2 7 5 28859 2
172 176155 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 900X Brotherhood Way 9 Median : Cutout Tree DPW 1     25 10x10   5988860 2088745 37.7146545182747 -122.480422197946 (37.7146545182747, -122.480422197946) 1 8 4 64 14
173 27068 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 801 Silver Ave 10 Sidewalk: Curb side : Cutout Tree DPW 1     3 4   6006971.0744 2093616.11167 37.7290654140285 -122.418167915919 (37.7290654140285, -122.418167915919) 9 3 7 309 28
175 184150 DPW Maintained 1 :: 45 1585 44th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5982480.9001 2104357.3743 37.7571490682193 -122.503626084685 (37.7571490682193, -122.503626084685) 1 8 3 56 35
176 194490 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1501 22nd St 19 Front Yard : Yard Tree Private 2     29     6013346.63868 2103825.44695 37.7574548949481 -122.396842409144 (37.7574548949481, -122.396842409144) 10 3 8 28856 29
178 233603 DPW Maintained 1 Olea europaea :: Olive Tree 9 199 Franconia St 9 : Yard Tree Private 2     6 Width 3ft   6010152.72418 2099634.52308 37.7457692517475 -122.407592814071 (37.7457692517475, -122.407592814071) 2 7 7 28859 2
179 113995 DPW Maintained 1 :: 45 3221 Washington St 1 Sidewalk: Curb side : Cutout Landscaping Private 2   10/27/2015 12:00:00 AM   39x3   5999265.7 2115942.6 37.789931692457 -122.446411428366 (37.789931692457, -122.446411428366) 13 6 1 29490 31
181 14420 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2X Masonic Ave 8 Median : Cutout Tree DPW 1     35     5998841.5976 2113071.3194 37.7820236767836 -122.447671998063 (37.7820236767836, -122.447671998063) 15 5 2 54 16
182 20628 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1492X Sunset Blvd 11 Median : Cutout Tree DPW 1     36 60   5984803.7392562 2105036.6950477 37.7591505890295 -122.495643037613 (37.7591505890295, -122.495643037613) 1 8 3 56 35
183 253381 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 899 Waller St 3 Side Yard : Yard Tree Private 2           6001282 2108613 37.7699214264211 -122.438909742148 (37.7699214264211, -122.438909742148) 15 5 5 29492 9
184 204541 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 400x Marietta Dr 4 Median : Cutout Tree DPW 1     16 Width 3ft   5999538.51913 2097033.8732 37.7380286277303 -122.444108242518 (37.7380286277303, -122.444108242518) 9 7 4 59 40
185 184541 DPW Maintained 1 :: 45 1706 38th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5984416.199 2103539.5001 37.7550170068332 -122.496872815694 (37.7550170068332, -122.496872815694) 1 8 3 56 35
186 30163 DPW Maintained 1 Shrub :: Shrub 66 410X Mansell St 20 Median : Cutout Tree DPW 1     0 POT   6010678.994322 2090457.626596 37.7206008798567 -122.405126964413 (37.7206008798567, -122.405126964413) 10 3 7 309 28
187 112917 DPW Maintained 1 Shrub :: Shrub 66 480X BEACON ST 1 Sidewalk: Property side : Yard Tree DPW 1           6002571 2098077 37.7410653426557 -122.433697996676 (37.7410653426557, -122.433697996676) 2 7 5 63 7
189 178694 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 184 Mount Vernon Ave 7 Side Yard : Yard Tree Private 2     9     5998957.82756 2089383.479 37.7169892861082 -122.445565994978 (37.7169892861082, -122.445565994978) 9 7 6 28861 25
190 21328 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2501X Sunset Blvd 28 Sidewalk: Curb side : Cutout Tree DPW 1     70 60   5985074.8907349 2098188.1189419 37.740362147215 -122.494200494189 (37.740362147215, -122.494200494189) 1 8 3 29491 35
191 244985 DPW Maintained 1 Olea europaea :: Olive Tree 9 1250 Haight St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6000147.9035 2108881.2284 37.7705933244615 -122.442851810939 (37.7705933244615, -122.442851810939) 15 5 11 29492 9
192 137920 DPW Maintained 1 :: 45 2028 FILLMORE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6002940.7431 2115305.2702 37.7883909617368 -122.433650548643 (37.7883909617368, -122.433650548643) 13 9 1 29490 27
199 237529 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1197 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6003874.24561 2101347.66783 37.7501197023675 -122.429425031242 (37.7501197023675, -122.429425031242) 2 4 5 28862 22
200 10663 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 963 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/25/1992 12:00:00 AM 3 3x3   6003244.5235 2110652.1051 37.7756317694487 -122.432267067771 (37.7756317694487, -122.432267067771) 15 9 11 29492 10
201 229505 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 950 Church St 7 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6004360.58946 2103177.16015 37.7551705836636 -122.427873571204 (37.7551705836636, -122.427873571204) 2 4 5 28862 22
202 190636 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 1 01st St 30 : Yard Tree Private 2     8     6014391.99798 2105898.86804 37.7632061898228 -122.393372206868 (37.7632061898228, -122.393372206868) 14 3 8 28856 29
204 209769 DPW Maintained 1 Maytenus boaria :: Mayten 58 100x Pacheco St 2 Median : Cutout Tree DPW 1     2 Width 3ft   5994792.885 2099741.94773 37.7451924562767 -122.460712331024 (37.7451924562767, -122.460712331024) 1 8 4 59 40
206 119799 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 201x Octavia St 7 Median : Cutout Tree DPW 1           2110122 6005581 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)          
207 251656 DPW Maintained 1 Tree(s) :: 17 31x Malta Dr 1 unknown : Yard Tree Private 2       3x3   5999423 2096089 37.7354276387403 -122.44443976141 (37.7354276387403, -122.44443976141) 9 7 4 63 40
209 138219 DPW Maintained 1 Tristania conferta :: 61 101 Anza St 14 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5998675.4325 2112652.6916 37.7808647356786 -122.448216697429 (37.7808647356786, -122.448216697429) 15 6 2 54 16
210 1023 DPW Maintained 1 Ulmus americana :: American Elm 74 1925 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6000937.4135 2090832.4174 37.7210805620079 -122.438827310136 (37.7210805620079, -122.438827310136) 9 7 6 28861 25
211 196303 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 249 Shipley St 1 : Tree Private 2     1 Width 5ft   6011469.59111 2111688.37468 37.7789400547713 -122.403887319468 (37.7789400547713, -122.403887319468) 14 2 9 28856 34
212 138278 DPW Maintained 1 :: 45 2181 Post St 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6001737.3169 2113910.2795 37.7844923181381 -122.437714255164 (37.7844923181381, -122.437714255164) 13 6 11 29490 13
213 3891 DPW Maintained 1 Maytenus boaria :: Mayten 58 23 Castro St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6002162.16871 2108402.44463 37.7693933312702 -122.435850193556 (37.7693933312702, -122.435850193556) 15 5 5 29492 9
214 138888 DPW Maintained 1 :: 45 675 LINDEN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004166.2354 2110619.5066 37.7755944800015 -122.429076315191 (37.7755944800015, -122.429076315191) 7 9 11 28852 10
215 119692 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 10 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
216 114440 DPW Maintained 1 Acer rubrum :: Red Maple 75 2961 SAN BRUNO AVE 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6011605 2091859 37.724500488626 -122.402024501601 (37.724500488626, -122.402024501601) 10 3 7 309 28
218 181787 DPW Maintained 1 :: 45 2915 Ulloa St 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5986983.636 2098224.4165 37.740573320949 -122.487603561386 (37.740573320949, -122.487603561386) 1 8 3 29491 35
219 131064 DPW Maintained 1 Maytenus boaria :: Mayten 58 1877 Greenwich St 1 : Tree Private 2     3 Width 4ft   6003926.06281 2119346.70194 37.7995435588443 -122.430529985984 (37.7995435588443, -122.430529985984) 13 9 1 57 17
221 182334 DPW Maintained 1 :: 45 1507 35th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985257.4301 2104914.9526 37.758842875608 -122.494065007935 (37.758842875608, -122.494065007935) 1 8 3 56 35
224 183657 DPW Maintained 1 :: 45 1490 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981573.7378 2104946.7308 37.7587138957913 -122.506807059304 (37.7587138957913, -122.506807059304) 1 8 3 56 35
225 119839 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 12 Median : Cutout Tree DPW 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
232 228435 DPW Maintained 1 :: 45 178 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6004070 2107898 37.7681164387884 -122.429215116616 (37.7681164387884, -122.429215116616) 7 9 5 28862 3
234 183167 DPW Maintained 1 :: 45 2422 45th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5982411.0498 2098597.3573 37.7413295619026 -122.503441142831 (37.7413295619026, -122.503441142831) 1 8 3 29491 35
235 184469 DPW Maintained 1 :: 45 2182 48th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981423.7042 2100234.3036 37.7457660664858 -122.506976375045 (37.7457660664858, -122.506976375045) 1 8 3 29491 35
237 15807 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 4959 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/27/1995 12:00:00 AM 6 3X3   6000887.014 2090089.1979 37.7190369816005 -122.438948290663 (37.7190369816005, -122.438948290663) 9 7 6 28861 5
238 119796 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 201x Octavia St 4 Median : Cutout Tree DPW 1           2110122 6005581 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)          
239 205987 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1639 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5990866.8027 2104246.93654 37.7573353075836 -122.474616638541 (37.7573353075836, -122.474616638541) 1 8 4 56 12
240 26863 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 637 Buchanan St 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6004510.83387 2110645.31056 37.7756848318303 -122.427886103845 (37.7756848318303, -122.427886103845) 7 9 11 28852 10
242 184584 DPW Maintained 1 :: 45 1750 38th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5984424.998 2103256.5795 37.7542407008981 -122.496821507327 (37.7542407008981, -122.496821507327) 1 8 3 56 35
243 21365 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2592X Sunset Blvd 27 Sidewalk: Curb side : Cutout Tree DPW 1     48 60   5985018.1742183 2097562.094386 37.7386399329486 -122.494350460592 (37.7386399329486, -122.494350460592) 1 8 3 29491 35
244 200570 DPW Maintained 1 :: 45 1445 La Salle Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6016341.8296 2095299.657 37.7342110910182 -122.385889477594 (37.7342110910182, -122.385889477594) 10 3 8 58 1
245 251484 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 900 Bosworth St 7 Front Yard : Yard Tree DPW 1           6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
246 136052 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1114 Greenwich St 1 Side Yard : Yard Tree Private 2     3     6007569.13805 2119905.68389 37.801284085155 -122.417963252702 (37.801284085155, -122.417963252702) 5 1 1 28858 32
247 240348 DPW Maintained 1 Quercus suber :: Cork Oak 78 1201 San Jose Ave 26 Front Yard : Yard Tree Private 2     1     6004340.86769 2095971.00866 37.7353830362869 -122.427428442788 (37.7353830362869, -122.427428442788) 2 7 5 28861 2
248 119766 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 1 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
249 222839 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 3100x Cesar Chavez St 5 Median : Yard Tree DPW 1     5 Width 10ft   6008877.38377 2100577.11513 37.7482859289696 -122.412069375694 (37.7482859289696, -122.412069375694) 2 4 7 28859 2
250 248390 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 34 Downey St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5998825.2199 2108039.7272 37.7682072798204 -122.447366392326 (37.7682072798204, -122.447366392326) 15 5 11 29492 9
251 187669 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 554 Valley St 1 Median : Yard Tree Private 2           6002324 2099197 37.7441265828549 -122.434632098307 (37.7441265828549, -122.434632098307) 2 7 5 63 22
252 204152 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 900 Junipero Serra Blvd 37 : Tree Private 2     1 Width 0ft   5991169.92245 2090751.38969 37.7202975393725 -122.472584434247 (37.7202975393725, -122.472584434247) 9 8 4 64 40
253 200884 DPW Maintained 1 :: 45 1200 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6012817.0471 2107089.1245 37.7663867409086 -122.39890301604 (37.7663867409086, -122.39890301604) 14 3 8 28856 20
254 130309 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 95 Vallejo St 6 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6013009.60555 2119229.44522 37.7997319839043 -122.399089221411 (37.7997319839043, -122.399089221411) 3 1 10 28860 6
255 118456 DPW Maintained 1 Myoporum laetum :: Myoporum 62 490 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   5981010.56733 2112424.984 37.7792138173967 -122.509310094921 (37.7792138173967, -122.509310094921) 11 6 2 55 26
258 139105 DPW Maintained 1 :: 45 1310 Lyon St 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5999792.0294 2113376.32 37.7829154028675 -122.444405875371 (37.7829154028675, -122.444405875371) 15 6 1 29490 31
259 196282 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1 25th St 13 : Yard Tree Private 2     12     6015015.25562 2102205.64875 37.7531000097757 -122.390958410295 (37.7531000097757, -122.390958410295) 10 3 8 28856 29
262 141330 DPW Maintained 1 :: 45 1314 HAYES ST 2 Sidewalk: Curb side : Pot Tree Private 2     0 Width 0ft   6001510.5734 2110463.2514 37.7750147569158 -122.438251682494 (37.7750147569158, -122.438251682494) 15 5 11 29492 10
263 17585 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 801X Persia Ave 9 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6003724.8526 2090366.56287 37.71995962001 -122.429158750084 (37.71995962001, -122.429158750084) 9 7 6 28861 5
265 18017 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2713 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6000875.2767 2114835.3915 37.7869833841555 -122.440762994582 (37.7869833841555, -122.440762994582) 13 6 1 29490 27
266 219228 DPW Maintained 1 Ilex spp :: Holly Species 81 200x Terrace Dr 4 Median : Yard Tree DPW 1     10     5993785.97496 2096493.89011 37.736216119669 -122.463958297244 (37.736216119669, -122.463958297244) 1 8 4 59 40
267 178174 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 0 Gonzalez Dr 5 Sidewalk: Curb side : Yard Tree Private 2     2     5988358.3694 2089791.63303 37.717499145949 -122.482232652541 (37.717499145949, -122.482232652541) 1 8 4 64 14
268 247892 DPW Maintained 1 :: 45 1283 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6000447.0072 2109223.9761 37.7715514711219 -122.441841814274 (37.7715514711219, -122.441841814274) 15 5 11 29492 9
269 194187 DPW Maintained 1 Olea europaea :: Olive Tree 9 1100 19th St 7 Sidewalk: Curb side : Yard Tree Private 2     8 Width 4ft   6014241.14855 2105287.11165 37.7615180580268 -122.393851124637 (37.7615180580268, -122.393851124637) 10 3 8 28856 29
270 182815 DPW Maintained 1 :: 45 2111 Noriega St 2 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5987460.7639 2102999.1421 37.7537112584365 -122.486304306666 (37.7537112584365, -122.486304306666) 1 8 3 56 35
271 107116 DPW Maintained 1 Tree(s) :: 17 300X LIBERTY ST 18 Median : Cutout Tree DPW 1     12     6004270.1 2103982.4 37.7573764628527 -122.428243896062 (37.7573764628527, -122.428243896062) 2 4 5 28862 3
272 232035 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 39 Scott St 1 : Tree Private 2     5 Width 3ft   6002379.25876 2108512.04182 37.769706587622 -122.435107129612 (37.769706587622, -122.435107129612) 15 5 5 29492 9
274 232433 DPW Maintained 1 Olea europaea :: Olive Tree 9 100 Church St 2 : Tree Private 2     7 Width 3ft   6004078.25972 2108290.75217 37.7691953086514 -122.429214555715 (37.7691953086514, -122.429214555715) 7 9 5 28862 3
275 193456 DPW Maintained 1 Malus :: Crab Apple 82 185 Hampshire St 3 Sidewalk: Curb side : Pot Tree Private 2     4 Width 5ft   6010023.67884 2107445.71101 37.76720979983 -122.40858996078 (37.76720979983, -122.40858996078) 8 4 8 28853 19
276 182945 DPW Maintained 1 :: 45 2691 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981809.5051 2096798.8146 37.7363558765881 -122.50538776138 (37.7363558765881, -122.50538776138) 1 8 3 29491 35
278 247719 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 12 Broderick St 1 : Tree Private 2     2 Width 3ft   6001402.47389 2108783.95066 37.770397668046 -122.438505276404 (37.770397668046, -122.438505276404) 15 5 11 29492 9
279 182423 DPW Maintained 1 :: 45 1539 25th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5988365.4024 2104835.4768 37.7588060244513 -122.483310502266 (37.7588060244513, -122.483310502266) 1 8 3 56 35
280 8072 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 661 Octavia St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   6005345.6576 2111619.4154 37.7784066780298 -122.425067563729 (37.7784066780298, -122.425067563729) 7 9 11 28852 10
281 136194 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2914 Fillmore St 6 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6002528.73575 2118269.03723 37.7965053162169 -122.435288106477 (37.7965053162169, -122.435288106477) 13 9 1 57 17
282 119806 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 251X Octavia St Frontage West 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6005545 2110174 37.7744491774234 -122.424275134654 (37.7744491774234, -122.424275134654) 7 9 11 28852 10
283 78989 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2319 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     5988235.2891 2099507.8812 37.7441702991504 -122.483369943638 (37.7441702991504, -122.483369943638) 1 8 3 29491 35
284 142846 DPW Maintained 1 Syagrus romanzoffianum :: Queen Palm 85 1249 POLK ST 1 Sidewalk: Curb side : Pot Tree Private 2     8 Width 0ft   6006785.3377 2115265.4346 37.7884989771715 -122.420346012985 (37.7884989771715, -122.420346012985) 13 9 10 28858 21
285 260625 DPW Maintained 1 Laurus x 'Saratoga' :: Hybrid Laurel 4 1601x Thomas Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3                        
286 18512 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 626 Powell St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6010135.39241 2115955.1821 37.7905810646201 -122.408803973339 (37.7905810646201, -122.408803973339) 5 1 10 28857 21
287 39813 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2000 41st Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/12/2019 12:00:00 AM 3 3x10 Permit Number 41144 5983552 2101519 37.7494185989562 -122.499712087956 (37.7494185989562, -122.499712087956) 1 8 3 29491 35
288 125298 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 822 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6010056.95509 2118170.07703 37.7966582351325 -122.409231726859 (37.7966582351325, -122.409231726859) 3 1 10 308 4
289 211158 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 300x Marietta Dr 38 Median : Cutout Tree DPW 1     21 Width 5ft   5999457.51761 2097516.55077 37.7393493243992 -122.444422982731 (37.7393493243992, -122.444422982731) 9 7 4 59 40
290 72670 DPW Maintained 1 Taxus baccata :: Irish Yew 86 203 04th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     5994586.71732 2114106.61682 37.7846222306097 -122.462466948558 (37.7846222306097, -122.462466948558) 11 6 2 54 11
291 210733 DPW Maintained 1 Olea europaea :: Olive Tree 9 239 Ramsell St 1 : Tree Private 2     7 Width 3ft   5992956.15258 2088805.34296 37.7150573966491 -122.466268722147 (37.7150573966491, -122.466268722147) 9 8 6 64 24
292 141019 DPW Maintained 1 Myoporum laetum :: Myoporum 62 400 Anza St 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   5997825.3169 2112597.8673 37.7806655664219 -122.451153693978 (37.7806655664219, -122.451153693978) 15 6 2 54 16
295 200164 DPW Maintained 1 :: 45 1027 Ingerson Ave 1 unknown : Yard Tree Private 2     0 Width 0ft   6014014.4798 2089939.2839 37.7193635176037 -122.393560894555 (37.7193635176037, -122.393560894555) 10 3 8 58 1
296 185842 DPW Maintained 1 :: 45 2000 35th Ave 8 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985421.3197 2101412.6246 37.7492360339251 -122.493240190301 (37.7492360339251, -122.493240190301) 1 8 3 29491 35

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);