Street_Tree_List

Data source: data.sfgov.org

189,144 rows

View and edit SQL

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
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)
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)
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)
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)
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)
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)
240 251249 Private 5 Private shrub :: Private Shrub 64 161 Lundys Ln 1 Front Yard : Yard 7 Landscaping 2 Private 1       3x3   6006716.0 2098685.0 37.7429691002686 -122.41940918518 (37.7429691002686, -122.41940918518)
241 251257 Undocumented 2 Phoenix dactylifera :: Date Palm 65 1748x Eucalyptus Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   5986101.0 2094852.0 37.7312620395563 -122.490407299046 (37.7312620395563, -122.490407299046)
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)
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)
249 251254 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 330 09th Ave 1 unknown : Cutout 12 Tree 1 MTA 6       3x3   5993109.0 2113253.0 37.782193225103605 -122.467517213871 (37.7821932251036, -122.467517213871)
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)
251 251258 Undocumented 2 Phoenix dactylifera :: Date Palm 65 1748x Eucalyptus Dr 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   5986101.0 2094852.0 37.7312620395563 -122.490407299046 (37.7312620395563, -122.490407299046)
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)
253 251256 Undocumented 2 Gleditsia triacanthos :: Honey Locust 67 4091x Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5991686.0 2086783.0 37.70943116445179 -122.470511668938 (37.7094311644518, -122.470511668938)
254 98489 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 1813 Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/29/2016 12:00:00 AM 3 4.5x5 Permit Number 777656 5999969.69733 2115286.35323 37.7881699939074 -122.443928497714 (37.7881699939074, -122.443928497714)
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            
256 221894 Undocumented 2 Geijera parviflora :: Australian Willow 68 3164 25th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6008618.9330400005 2101573.97925 37.75100859049479 -122.41303356944799 (37.7510085904948, -122.413033569448)
257 251260 Undocumented 2 Pyrus calleryana :: Ornamental Pear 9 1163 South Van Ness Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 3ft   6007684.87734 2102881.8281400003 37.754547168222295 -122.41635626045701 (37.7545471682223, -122.416356260457)
258 251259 Undocumented 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 1050x Sacramento St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6009753.0 2116795.0 37.7928655753561 -122.410186352148 (37.7928655753561, -122.410186352148)
259 141361 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1499X Hayes St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   6000919.0 2110350.0 37.77467013322371 -122.44028993459101 (37.7746701332237, -122.440289934591)
260 221893 Undocumented 2 Geijera parviflora :: Australian Willow 68 3164 25th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6008601.79804 2101572.78068 37.751004337584796 -122.41309273944599 (37.7510043375848, -122.413092739446)
261 141359 Undocumented 2 Olea europaea :: Olive Tree 41 1499X Hayes St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   6000919.0 2110350.0 37.77467013322371 -122.44028993459101 (37.7746701332237, -122.440289934591)
262 141360 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1499X Hayes St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   6000919.0 2110350.0 37.77467013322371 -122.44028993459101 (37.7746701332237, -122.440289934591)
263 141358 Undocumented 2 Myoporum laetum :: Myoporum 1 1499X Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 0ft   6000919.0 2110350.0 37.77467013322371 -122.44028993459101 (37.7746701332237, -122.440289934591)
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)
265 109354 Undocumented 2 Juniperus chinensis :: Juniper 19 900x Chestnut St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     6 5x45   6007474.1784 2120601.5824599997 37.803189502164294 -122.418341225173 (37.8031895021643, -122.418341225173)
266 173827 Undocumented 2 Tree(s) :: 17 1200 04th St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
267 175151 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 285 Santa Rosa Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 Width 3ft Permit Number 779495 6000727.04119 2093604.3094 37.728679573387495 -122.43975313162399 (37.7286795733875, -122.439753131624)
268 46773 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 35 San Juan Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/03/2017 12:00:00 AM 3   Permit Number 779460 6001741.72526 2092006.08473 37.7243489150655 -122.43613098976101 (37.7243489150655, -122.436130989761)
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)
270 28098 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 639 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/28/2006 12:00:00 AM 3 3X3   6001577.9698 2110674.4978 37.7755986195101 -122.438033679217 (37.7755986195101, -122.438033679217)
271 175152 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 285 Santa Rosa Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 Width 3ft Permit Number 779495 6000750.8705 2093589.3929700002 37.728639972642604 -122.43966968351002 (37.7286399726426, -122.43966968351)
272 251264 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3630x 19th Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1         Permit Number 779147          
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)
274 173825 Undocumented 2 Tree(s) :: 17 1200 04th St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
275 818 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 1385 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4x4   5982124.8821 2105687.3873 37.7607799675436 -122.504955867812 (37.7607799675436, -122.504955867812)
276 173808 Undocumented 2 Tree(s) :: 17 1201 04th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779410 6015204.0 2109228.0 37.772392338117704 -122.390796408976 (37.7723923381177, -122.390796408976)
277 251265 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3630x 19th Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1         Permit Number 779147          
278 9598 DPW Maintained 3 Maytenus boaria :: Mayten 22 1350 Golden Gate Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6003113.217999999 2112071.7207 37.7795222347306 -122.43282272296999 (37.7795222347306, -122.43282272297)
279 48153 Permitted Site 1 Tree(s) :: 17   263 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
280 194427 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 905 Minna St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6008110.0 2110227.0 37.774739203286295 -122.415406037323 (37.7747392032863, -122.415406037323)
281 9686 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 300X Gough St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   6005996.09112 2110833.49174 37.7762854431535 -122.42276159987499 (37.7762854431535, -122.422761599875)
282 173829 Undocumented 2 Tree(s) :: 17 1200 04th St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
283 173821 Undocumented 2 Tree(s) :: 17 1200 04th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
284 137592 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 1125 Steiner St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/16/1990 12:00:00 AM 18 Width 0ft   6002857.6038 2112094.871 37.7795712988398 -122.433708655697 (37.7795712988398, -122.433708655697)
285 98003 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1904 Filbert St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 4x12   6003782.57859 2119037.12075 37.7986853996597 -122.431004385541 (37.7986853996597, -122.431004385541)
286 10157 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 995 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6005745.7610599995 2103227.37374 37.755386722241504 -122.42308680461201 (37.7553867222415, -122.423086804612)
287 173824 Undocumented 2 Tree(s) :: 17 1200 04th St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
288 226558 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 320 Dolores St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     22 Width 7ft   6004836.50691 2106380.98977 37.7639944545966 -122.42645581878 (37.7639944545966, -122.42645581878)
289 173826 Undocumented 2 Tree(s) :: 17 1200 04th St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
290 173809 Undocumented 2 Tree(s) :: 17 1201 04th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779410 6015204.0 2109228.0 37.772392338117704 -122.390796408976 (37.7723923381177, -122.390796408976)
291 129605 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 2101 Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     10 Width 4ft   6005928.19437 2117729.67294 37.79521682154579 -122.42348685993299 (37.7952168215458, -122.423486859933)
292 9421 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 701X Golden Gate Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/08/2011 12:00:00 AM 12 3x3 Permit Number 767203 6006076.0707 2112433.28351 37.7806825946662 -122.42259863641199 (37.7806825946662, -122.422598636412)
293 251262 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3630x 19th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1         Permit Number 779147          
294 251266 Private 5 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 10x Paloma Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
295 230413 DPW Maintained 3 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 310 Dolores St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/14/2016 08:33:00 AM 1 Width 7ft   6004826.22566 2106515.9879900003 37.7643645463025 -122.42650099174601 (37.7643645463025, -122.426500991746)
296 18021 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2725 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6000769.3896 2114817.5231 37.78692829139071 -122.44112805661501 (37.7869282913907, -122.441128056615)
297 32804 Permitted Site 1 Tree(s) :: 17 1683 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779644 5999817.40523345 2110171.54968226 37.774117372599896 -122.44408773423099 (37.7741173725999, -122.444087734231)
298 173822 Undocumented 2 Tree(s) :: 17 1200 04th St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
299 196427 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 25 McLea Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6010117.0 2109248.0 37.772163696411795 -122.408394314545 (37.7721636964118, -122.408394314545)
300 251263 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3630x 19th Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1         Permit Number 779147          

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