home / trees

Street_Tree_List

Data source: data.sfgov.org

191,550 rows sorted by qCaretaker

View and edit SQL

Suggested facets: qLegalStatus, qCaretaker, qCareAssistant

PlantType

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker ▼ qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
1 1 DPW Maintained 1 Pinus radiata :: Monterey Pine 1 10 10th Ave 1 Median : Cutout 1 Tree 1 DPW 1     3 16   5992719.40718 2114869.71245 37.7866097734767 -122.46898271049601 (37.7866097734767, -122.468982710496) 11 6 1 54 11
2 10 DPW Maintained 1 Palm (unknown Genus) :: Palm Spp 2 97 12th St 4 Median : Cutout 1 Tree 1 DPW 1     20 3X3   6007166.5822125 2109668.7679164 37.7731533608049 -122.418629924651 (37.7731533608049, -122.418629924651) 8 2 9 28853 19
3 1000 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 1726 Alemany Blvd 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     20 3X5PL   6001385.76767 2092068.0675700002 37.724498876108 -122.43736591900499 (37.724498876108, -122.437365919005) 9 7 6 28861 25
14 10001 DPW Maintained 1 Geijera parviflora :: Australian Willow 4 145 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 3X2   6005474.27283 2108090.23028 37.768723653813204 -122.42437155270201 (37.7687236538132, -122.424371552702) 8 4 5 28853 19
24 10002 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 145 Guerrero St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   09/19/2014 12:50:00 PM 3 3X2   6005473.70519 2108134.2356 37.768844449829395 -122.424376646466 (37.7688444498294, -122.424376646466) 8 4 5 28853 19
45 10004 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 150 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     28 3X3   6005403.33839 2108127.1988 37.768821154693896 -122.424619539876 (37.7688211546939, -122.424619539876) 8 4 5 28853 19
56 10005 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 5 156 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 3X3   6005408.68432 2108096.72474 37.7687377821415 -122.424598880629 (37.7687377821415, -122.424598880629) 8 4 5 28853 19
78 10007 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 6 170 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     20 3X3   6005407.88099 2108072.95104 37.7686724598889 -122.424599967939 (37.7686724598889, -122.424599967939) 8 4 5 28853 19
89 10008 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 6 170 Guerrero St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     22 3X3   6005410.95643 2108039.08035 37.7685796327732 -122.424586920555 (37.7685796327732, -122.424586920555) 8 4 5 28853 19
94 10009 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 6 170 Guerrero St 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     22 3X3   6005412.73113 2108018.3838400003 37.7685229053392 -122.42457930959999 (37.7685229053392, -122.4245793096) 8 4 5 28853 19
105 1001 DPW Maintained 1 Ulmus pumila :: Siberian Elm 31 1731 Alemany Blvd 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     27 3X3   6001471.07065 2092002.59485 37.724323951976 -122.437066353202 (37.724323951976, -122.437066353202) 9 7 6 28861 25
117 10011 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 198 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     25 2X3   6005417.15338 2107897.14895 37.76819027309789 -122.424555388522 (37.7681902730979, -122.424555388522) 8 4 5 28853 19
137 10013 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 215 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 3x2   6005495.275 2107715.11687 37.7676948680391 -122.42427222529899 (37.7676948680391, -122.424272225299) 8 4 5 28853 19
153 10015 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 232 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   10/24/2012 12:00:00 AM 1 2x3   6005430.70254 2107623.5907900003 37.7674399129618 -122.424489062615 (37.7674399129618, -122.424489062615) 8 4 5 28853 19
172 100169 DPW Maintained 1 Pinus radiata :: Monterey Pine 1 180X Manchester St   Back Yard : Yard 6 Tree 1 DPW 1         Adjacent to rear of property - DPW parcel 6008242.0 2099158.0 37.7443536844995 -122.414166136282 (37.7443536844995, -122.414166136282) 2 7 7 28859 2
173 10017 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 240 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   10/24/2012 12:00:00 AM 1 3x3   6005435.617430001 2107572.1515 37.7672989505107 -122.42446840339198 (37.7672989505107, -122.424468403392) 8 4 5 28853 19
187 100186 DPW Maintained 1 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 2445 HARRISON ST 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     8 3x3   6008897.0 2104213.0 37.758270352242796 -122.41225848424999 (37.7582703522428, -122.41225848425) 2 4 7 28859 19
201 1002 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 11 1731 Alemany Blvd 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     27 3X3   6001471.07065 2092002.59485 37.724323951976 -122.437066353202 (37.724323951976, -122.437066353202) 9 7 6 28861 25
213 10021 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 274 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     17 3x4   6005443.44254 2107417.66285 37.7668752034469 -122.424430347706 (37.7668752034469, -122.424430347706) 8 4 5 28853 19
222 10022 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 10 282 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   02/01/2003 12:00:00 AM 3 2x2   6005445.78054 2107378.48496 37.766767762334794 -122.42441947400499 (37.7667677623348, -122.424419474005) 8 4 5 28853 19
290 1003 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 11 1750 Alemany Blvd 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     30 3X3   6001350.47669 2091970.9547 37.7242302198351 -122.43748096390101 (37.7242302198351, -122.437480963901) 9 7 6 28861 25
291 10030 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 6 307 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     6 3X3PL   6005523.84407 2107170.8292099996 37.76620199705 -122.424134695569 (37.76620199705, -122.424134695569) 8 4 5 28853 19
301 10031 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 310 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     100 2x3   6005459.49344 2107143.4221799998 37.7661231103266 -122.42435532265301 (37.7661231103266, -122.424355322653) 8 4 5 28853 19
354 10038 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 360 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     30 3X3   6005474.31982 2106984.12162 37.7656865461171 -122.424292710045 (37.7656865461171, -122.424292710045) 8 4 5 28853 19
359 10039 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 360 Guerrero St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   01/25/1991 12:00:00 AM 20 3X3   6005477.1925800005 2106955.99773 37.765609486820004 -122.424280773358 (37.76560948682, -122.424280773358) 8 4 5 28853 19
370 10040 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 360 Guerrero St 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 3X3   6005476.568580001 2106925.6543400004 37.7655261358546 -122.424280773346 (37.7655261358546, -122.424280773346) 8 4 5 28853 19
377 10041 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 360 Guerrero St 4 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   02/02/1991 12:00:00 AM 20 3X3   6005475.31081 2106892.46038 37.765434922114295 -122.42428276264299 (37.7654349221143, -122.424282762643) 8 4 5 28853 19
386 10042 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 360 Guerrero St 5 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     20 3X3   6005475.5325 2106875.27322 37.7653877427782 -122.424280773365 (37.7653877427782, -122.424280773365) 8 4 5 28853 19
397 10043 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 360 Guerrero St 6 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     20 3X3   6005477.51423 2106859.7680900004 37.765345281278 -122.424272816157 (37.765345281278, -122.424272816157) 8 4 5 28853 19
404 10044 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 360 Guerrero St 7 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     30 3X3   6005474.87318 2106843.21233 37.7652996739685 -122.424280773353 (37.7652996739685, -122.424280773353) 8 4 5 28853 19
410 10046 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 380 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     20 3X3   6005478.637490001 2106816.50174 37.765226545592604 -122.424265853604 (37.7652265455926, -122.424265853604) 8 4 5 28853 19
417 10047 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 380 Guerrero St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   12/13/2009 12:00:00 AM 8 3X3   6005478.32549 2106801.33005 37.765184870121004 -122.424265853606 (37.765184870121, -122.424265853606) 8 4 5 28853 19
427 10048 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 388 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   05/12/2014 12:00:00 AM 3 3X3   6005479.4973627 2106724.9559124 37.7649752310589 -122.42425636806499 (37.7649752310589, -122.424256368065) 8 4 5 28853 19
448 10050 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 6 390 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     45 3X3   6005481.13253 2106756.02425 37.7650606296618 -122.424252922232 (37.7650606296618, -122.424252922232) 8 4 5 28853 19
459 10051 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 398 Guerrero St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   12/11/2009 12:00:00 AM 16 3X3   6005480.85974 2106714.7911 37.7649473978257 -122.42425093294399 (37.7649473978257, -122.424250932944) 8 4 5 28853 19
470 10052 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 394 Guerrero St 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   09/02/2005 12:00:00 AM 16 3X3   6005485.0846607005 2106684.1712003 37.7648635614138 -122.424234142103 (37.7648635614138, -122.424234142103) 8 4 5 28853 19
483 100535 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 83 2050X Market St 5 Median : Cutout 1 Tree 1 DPW 1     36 8   6004529.3 2108103.5 37.7687066827543 -122.427641088373 (37.7687066827543, -122.427641088373) 7 4 5 28862 3
484 100536 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 83 2050X Market St 6 Median : Cutout 1 Tree 1 DPW 1     36 8   6004529.3 2108103.5 37.7687066827543 -122.427641088373 (37.7687066827543, -122.427641088373) 7 4 5 28862 3
485 100537 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 83 2010X Market St 1 Median : Cutout 1 Tree 1 DPW 1     36 8   6004815.4 2108376.1 37.7694713555808 -122.426670904591 (37.7694713555808, -122.426670904591) 7 4 5 28862 3
486 100538 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 83 2010X Market St 2 Median : Cutout 1 Tree 1 DPW 1     36 8   6004815.4 2108376.1 37.7694713555808 -122.426670904591 (37.7694713555808, -122.426670904591) 7 4 5 28862 3
487 100539 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 83 2010X Market St 3 Median : Cutout 1 Tree 1 DPW 1     36 8   6004815.4 2108376.1 37.7694713555808 -122.426670904591 (37.7694713555808, -122.426670904591) 7 4 5 28862 3
488 10054 DPW Maintained 1 Geijera parviflora :: Australian Willow 4 426 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     80 3X2   6005501.955709999 2106458.62904 37.764245228771 -122.42415974799201 (37.764245228771, -122.424159747992) 8 4 5 28859 19
489 100540 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 83 2010X Market St 4 Median : Cutout 1 Tree 1 DPW 1     36 8   6004815.4 2108376.1 37.7694713555808 -122.426670904591 (37.7694713555808, -122.426670904591) 7 4 5 28862 3
497 10055 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 432 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     90 3X2   6005503.26278 2106415.24362 37.7641261764966 -122.424152141508 (37.7641261764966, -122.424152141508) 8 4 5 28859 19
515 100568 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 868 Folsom St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 3x3   6011788.1802 2112369.4793 37.780828003664 -122.40283310111 (37.780828003664, -122.40283310111) 6 2 9 28853 34
517 10057 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 439 Guerrero St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   06/09/2016 06:50:00 AM 3 3X3   6005566.67326 2106440.43668 37.7641989307536 -122.423934614407 (37.7641989307536, -122.423934614407) 8 4 5 28859 19
526 10058 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 451 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     18 3x5   6005573.3175800005 2106314.3851 37.763853198087 -122.4239026696 (37.763853198087, -122.4239026696) 8 4 5 28859 19
551 10061 DPW Maintained 1 Geijera parviflora :: Australian Willow 4 490 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     60 2X2   6005517.65207 2106131.14555 37.7633469229371 -122.424082167969 (37.7633469229371, -122.424082167969) 8 4 5 28859 19
599 100665 Permitted Site 2 Tree(s) :: 13 63 Walter St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1 FUF 2 09/04/2012 12:00:00 AM   3x3 Permit Number 769258 6003201.8 2107946.7 37.768200969529204 -122.432221606092 (37.7682009695292, -122.432221606092) 15 5 5 28862 3
600 10067 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 545 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   02/19/1992 12:00:00 AM 6 3x3   6005600.27416 2105821.7807400003 37.762502144780896 -122.423774406467 (37.7625021447809, -122.423774406467) 8 4 5 28859 19
605 10068 DPW Maintained 1 Geijera parviflora :: Australian Willow 4 549 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 4x4   6005603.73706 2105778.3330099997 37.762383043055 -122.423759340124 (37.762383043055, -122.423759340124) 8 4 5 28859 19
619 1007 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 1827 Alemany Blvd 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   03/06/2006 12:00:00 AM 10 3X3   6001335.27273 2091591.54514 37.723187582737395 -122.43750636433701 (37.7231875827374, -122.437506364337) 9 7 6 28861 25
631 10071 DPW Maintained 1 Geijera parviflora :: Australian Willow 4 563 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 2x3   6005607.25335 2105721.20389 37.7622263784702 -122.423743116346 (37.7622263784702, -122.423743116346) 8 4 5 28859 19
642 10072 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 573 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 3x3   6005609.84736 2105668.09746 37.7620807071743 -122.423730368485 (37.7620807071743, -122.423730368485) 8 4 5 28859 19
678 10076 DPW Maintained 1 Geijera parviflora :: Australian Willow 4 600 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     70 2x2   6005555.84644 2105437.30746 37.7614439637781 -122.423900725242 (37.7614439637781, -122.423900725242) 2 4 5 28859 19
686 10077 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 611 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 3x3   6005621.78486 2105416.8204099997 37.761391433480895 -122.423671214664 (37.7613914334809, -122.423671214664) 2 4 5 28859 19
707 10079 DPW Maintained 1 Geijera parviflora :: Australian Willow 4 614 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     50 3X3   6005561.0033 2105378.47551 37.7612827162343 -122.423878706238 (37.7612827162343, -122.423878706238) 2 4 5 28859 19
732 100816 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 11 261 06th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     7 3x3   6010798.79921 2111766.85068 37.779118033309395 -122.406213398837 (37.7791180333094, -122.406213398837) 14 2 9 28853 34
734 10082 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 635 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 2X2   6005631.678069999 2105272.5638099997 37.7609958972634 -122.42362674139 (37.7609958972634, -122.42362674139) 2 4 5 28859 19
779 10088 DPW Maintained 1 Ligustrum japonicum :: Japanese Privet 100 680 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     24 3X2   6005576.87933 2105026.12376 37.760316137501 -122.423798743025 (37.760316137501, -122.423798743025) 2 4 5 28859 19
789 10089 DPW Maintained 1 Geijera parviflora :: Australian Willow 4 700 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     80 3X3   6005586.51976 2104851.24563 37.7598365074586 -122.423752966647 (37.7598365074586, -122.423752966647) 2 4 5 28859 19
813 10092 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 708 Guerrero St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   01/27/2009 12:00:00 AM 6 3X3   6005588.909109999 2104804.48181 37.759708239868495 -122.423741377976 (37.7597082398685, -122.423741377976) 2 4 5 28859 19
818 10095 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 727 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   12/28/2016 05:21:00 AM 3 2X2   6005664.2360000005 2104708.85405 37.759449920391 -122.423474060781 (37.759449920391, -122.423474060781) 2 4 5 28859 19
824 100962 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 55 Hawthorne St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1 Private 1 04/03/2013 12:00:00 AM 18 3x3 Permit Number 768706 6013015.61085 2114021.6260599997 37.7854328757839 -122.39870276924 (37.7854328757839, -122.39870276924) 6 2 9 28855 6
832 10097 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 744 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     30 2X2   6005593.39843 2104652.72108 37.759291793936896 -122.423715061076 (37.7592917939369, -122.423715061076) 2 4 5 28859 19
858 1010 DPW Maintained 1 Ulmus pumila :: Siberian Elm 31 1840X Alemany Blvd 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     35 3X3   6001180.264280001 2091487.57144 37.722893280400704 -122.438034753125 (37.7228932804007, -122.438034753125) 9 7 6 28861 25
859 10100 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 750 Guerrero St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   05/22/1995 12:00:00 AM 40 2x2   6005607.26399 2104540.55602 37.758984597670896 -122.423659132264 (37.7589845976709, -122.423659132264) 2 4 5 28859 19
886 101027 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1010X Portola Dr 1 Front Yard : Yard 4 Tree 1 DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
887 101028 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1010X Portola Dr 2 Front Yard : Yard 4 Tree 1 DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
888 101029 DPW Maintained 1 Cordyline australis :: Dracena Palm 82 1010X Portola Dr 3 Front Yard : Yard 4 Tree 1 DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
890 101030 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1010X Portola Dr 4 Median : Yard 11 Tree 1 DPW 1     40     5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
891 101031 DPW Maintained 1 Sequoiadendron giganteum :: Sierra Redwood 107 1010X Portola Dr 5 Front Yard : Yard 4 Tree 1 DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
892 101032 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1010X Portola Dr 6 Front Yard : Yard 4 Tree 1 DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
893 101033 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 96 1010X Portola Dr 7 Front Yard : Yard 4 Tree 1 DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
894 101034 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 1010X Portola Dr 8 Front Yard : Yard 4 Tree 1 DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
895 101035 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1010X Portola Dr 9 Front Yard : Yard 4 Tree 1 DPW 1   09/03/2014 12:00:00 AM 3     5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
896 101036 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 1010X Portola Dr 10 Front Yard : Yard 4 Tree 1 DPW 1   04/11/2013 12:00:00 AM 3     5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
897 101037 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 1010X Portola Dr 11 Front Yard : Yard 4 Tree 1 DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
898 101038 DPW Maintained 1 Pinus radiata :: Monterey Pine 1 1010X Portola Dr 12 Front Yard : Yard 4 Tree 1 DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
899 101039 DPW Maintained 1 Pinus radiata :: Monterey Pine 1 1010X Portola Dr 13 Front Yard : Yard 4 Tree 1 DPW 1   08/23/2014 12:00:00 AM       5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
901 101040 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 1010X Portola Dr 14 Front Yard : Yard 4 Tree 1 DPW 1   04/11/2013 12:00:00 AM 3     5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
916 10106 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 785 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 2X2   6005679.329609999 2104414.6071 37.7586428391006 -122.42340094141399 (37.7586428391006, -122.423400941414) 2 4 5 28859 19
918 101064 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 380X Beacon St 2 Median : Cutout 1 Tree 1 DPW 1     3 3x3   6002433.0 2098186.8 37.7413589965156 -122.43418299753701 (37.7413589965156, -122.434182997537) 2 7 5 63 7
919 101065 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 380X Beacon St 1 Median : Cutout 1 Tree 1 DPW 1     3 3x3   6002433.0 2098186.8 37.7413589965156 -122.43418299753701 (37.7413589965156, -122.434182997537) 2 7 5 63 7
924 10107 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 799X Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   12/02/2014 06:59:00 AM 3 3x4   6005682.50344 2104371.2203900004 37.7585238884792 -122.423386880525 (37.7585238884792, -122.423386880525) 2 4 5 28859 19
929 10108 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 799X Guerrero St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   12/02/2014 06:48:00 AM 3 3x3   6005680.6141099995 2104397.9808 37.7585972596694 -122.42339531706699 (37.7585972596694, -122.423395317067) 2 4 5 28859 19
964 10112 DPW Maintained 1 Geijera parviflora :: Australian Willow 4 821 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     6 3x3   6005694.086069999 2104163.28117 37.7579535897166 -122.423332040744 (37.7579535897166, -122.423332040744) 2 4 5 28859 19
974 10113 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 827 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 3X3   6005696.52511 2104103.91625 37.757790725171 -122.423319385483 (37.757790725171, -122.423319385483) 2 4 5 28859 19
985 10114 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 827 Guerrero St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 3x3   6005696.25247 2104120.31934 37.7578357488369 -122.423321494416 (37.7578357488369, -122.423321494416) 2 4 5 28859 19
996 10115 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 827 Guerrero St 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 3x3   6005698.17392 2104144.57278 37.75790245155879 -122.42331657330901 (37.7579024515588, -122.423316573309) 2 4 5 28859 19
1018 10117 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 845 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 3X3   6005699.222580001 2104067.01691 37.757689560440795 -122.42330743349301 (37.7576895604408, -122.423307433493) 2 4 5 28859 19
1029 10118 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 845 Guerrero St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   02/01/1990 12:00:00 AM 3 3X3   6005704.2510557 2104056.9285895 37.7576621440613 -122.423289325813 (37.7576621440613, -122.423289325813) 2 4 5 28859 19
1040 10119 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 850 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   07/06/1992 12:00:00 AM 18 3X3   6005631.880167 2104012.3184419 37.757535570368 -122.423536442741 (37.757535570368, -122.423536442741) 2 4 5 28859 19
1051 1012 DPW Maintained 1 Ulmus americana :: American Elm 113 1845 Alemany Blvd 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     36 3X3   6001257.97709 2091441.7763099999 37.722771956545294 -122.437762838379 (37.7227719565453, -122.437762838379) 9 7 6 28861 25
1085 10124 DPW Maintained 1 Geijera parviflora :: Australian Willow 4 877 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 3X3   6005714.7162163 2103867.2939474997 37.7571420422058 -122.42323965318998 (37.7571420422058, -122.42323965319) 2 4 5 28859 19
1093 10125 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 876 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   06/11/2015 02:57:00 PM 3 3x3   6005640.441980001 2103866.83654 37.757136594295396 -122.423496489872 (37.7571365942954, -122.423496489872) 2 4 5 28859 19
1097 101254 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 73 3700X Cesar Chavez St 1 Front Yard : Yard 4 Tree 1 DPW 1           6005840.6 2100555.6 37.74805599841039 -122.422568977073 (37.7480559984104, -122.422568977073) 2 4 5 28859 19
1098 101255 DPW Maintained 1 x Chiranthofremontia lenzii :: Hybrid Monkey Hand Tree 120 3700X Cesar Chavez St 2 Front Yard : Yard 4 Tree 1 DPW 1           6005840.6 2100555.6 37.74805599841039 -122.422568977073 (37.7480559984104, -122.422568977073) 2 4 5 28859 19
1113 10127 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 892 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     45 3x3   6005646.424 2103793.6441599997 37.7569359627397 -122.42347059841002 (37.7569359627397, -122.42347059841) 2 4 5 28859 19
1133 10129 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 892 Guerrero St 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     40 3X3   6005646.9391641 2103763.6492254 37.7568536327232 -122.42346668441999 (37.7568536327232, -122.42346668442) 2 4 5 28859 19

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 328.091ms · Data source: data.sfgov.org