Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28086 | 28086 | 97371 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1351X Broadway | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | 6007032.43934 | 2118047.0408099997 | 37.796150498593995 | -122.419688519305 | (37.796150498594, -122.419688519305) | ||||
30236 | 30236 | 97380 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1401X Broadway | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006631.8373300005 | 2118013.16955 | 37.7960349222286 | -122.421072279161 | (37.7960349222286, -122.421072279161) | ||||
30532 | 30532 | 119696 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
32402 | 32402 | 97365 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1263X Robert C Levy Tunl | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 6007465.63195 | 2118105.8226099997 | 37.7963362913309 | -122.418193751644 | (37.7963362913309, -122.418193751644) | ||||
35699 | 35699 | 117207 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1300x De Haro St | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 13 | 6012255.77341 | 2102253.00873 | 37.753076544652 | -122.40050462841002 | (37.753076544652, -122.40050462841) | ||||
35792 | 35792 | 97374 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1351X Broadway | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006998.02946 | 2118043.30969 | 37.7961383154753 | -122.419807319778 | (37.7961383154753, -122.419807319778) | ||||
36548 | 36548 | 97369 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1351X Broadway | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 6007107.08679 | 2118057.51485 | 37.7961834623584 | -122.41943096698601 | (37.7961834623584, -122.419430966986) | ||||
36608 | 36608 | 107488 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1306x Montgomery St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6011453.59321 | 2119920.31769 | 37.80154211772779 | -122.40452228489599 | (37.8015421177278, -122.404522284896) | ||||
36706 | 36706 | 112246 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | 5999047.56745 | 2088876.5109400002 | 37.715602390323 | -122.44521938006399 | (37.715602390323, -122.445219380064) | ||||
37436 | 37436 | 107492 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1306x Montgomery St | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 26 | 6011443.89272 | 2119983.46704 | 37.80171496831821 | -122.404560301033 | (37.8017149683182, -122.404560301033) | ||||
37825 | 37825 | 97384 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1401X Broadway | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006553.08454 | 2118002.88363 | 37.7960022399536 | -122.421344048901 | (37.7960022399536, -122.421344048901) | ||||
37952 | 37952 | 97382 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1401X Broadway | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006565.23555 | 2118004.957 | 37.7960086179662 | -122.42130215128 | (37.7960086179662, -122.42130215128) | ||||
41145 | 41145 | 97381 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1401X Broadway | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006582.71632 | 2118007.67098 | 37.796017055392205 | -122.421241857125 | (37.7960170553922, -122.421241857125) | ||||
44175 | 44175 | 99145 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 302X Pacheco St | 29 | Median : Cutout 11 | Tree 1 | Private 1 | 9 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
44570 | 44570 | 27941 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 699 The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.801444644335106 | -122.399901749617 | (37.8014446443351, -122.399901749617) | |||
48376 | 48376 | 91282 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1212x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 6005738.0 | 2101906.0 | 37.7517580978369 | -122.42301973133999 | (37.7517580978369, -122.42301973134) | |||
49664 | 49664 | 97385 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1401X Broadway | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006527.03038 | 2118000.68045 | 37.7959947216224 | -122.42143404497 | (37.7959947216224, -122.42143404497) | ||||
49955 | 49955 | 91244 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 852x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/20/2016 07:21:00 AM | 3 | 6005625.0 | 2104006.0 | 37.757517833055395 | -122.423559787953 | (37.7575178330554, -122.423559787953) | |||
51267 | 51267 | 95959 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5100 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 1 | 5991179.182440001 | 2112771.35122 | 37.780759144985 | -122.47415829445299 | (37.780759144985, -122.474158294453) | |||
51522 | 51522 | 4986 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5300 Diamond Heights Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | ||||
53247 | 53247 | 97256 | DPW Maintained 3 | Jubaea chilensis :: Chilean Wine Palm 425 | 198 Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/05/2011 12:00:00 AM | 6004815.0 | 2107196.0 | 37.766231062063206 | -122.426588243906 | (37.7662310620632, -122.426588243906) | ||||
55578 | 55578 | 107482 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1306x Montgomery St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 6011457.97806 | 2119852.64786 | 37.801356557918794 | -122.404502345126 | (37.8013565579188, -122.404502345126) | ||||
55643 | 55643 | 107485 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1306x Montgomery St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 6011457.45538 | 2119866.47345 | 37.8013944904094 | -122.40450512760401 | (37.8013944904094, -122.404505127604) | ||||
61501 | 61501 | 120626 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6004397.0 | 2113949.0 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | |||||
61692 | 61692 | 119780 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 204x Octavia St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
61932 | 61932 | 97360 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1351X Broadway | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | 6007166.97772 | 2118064.11604 | 37.796204960647 | -122.419224200263 | (37.796204960647, -122.419224200263) | ||||
62152 | 62152 | 107486 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1306x Montgomery St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 6011455.57226 | 2119886.9035799997 | 37.8014504813279 | -122.404513083014 | (37.8014504813279, -122.404513083014) | ||||
62832 | 62832 | 97364 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1351X Broadway | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | 6007127.58515 | 2118060.22624 | 37.7961920616707 | -122.41936023079398 | (37.7961920616707, -122.419360230794) | ||||
64701 | 64701 | 97378 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1401X Broadway | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006692.04041 | 2118019.16357 | 37.7960547738532 | -122.420864390096 | (37.7960547738532, -122.420864390096) | ||||
65587 | 65587 | 97363 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1263X Robert C Levy Tunl | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | 6007504.85482 | 2118111.0383 | 37.7963528199735 | -122.418058401889 | (37.7963528199735, -122.418058401889) | ||||
72222 | 72222 | 87818 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 85 Mendosa Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | Permit Number 50680 | 5993356.0 | 2100787.0 | 37.747979128324 | -122.46575670711701 | (37.747979128324, -122.465756707117) | |||
75755 | 75755 | 115513 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 11:41:00 AM | 3 | 6005415.2 | 2107753.5 | 37.767795737129205 | -122.424551925681 | (37.7677957371292, -122.424551925681) | |||
75779 | 75779 | 97379 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1401X Broadway | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006673.12303 | 2118017.2022 | 37.7960483221209 | -122.42092970874901 | (37.7960483221209, -122.420929708749) | ||||
77513 | 77513 | 27958 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 307X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 18 | 6013768.7522982005 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | |||
77566 | 77566 | 106463 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 3500X MISSION ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716001 | (37.7405398531137, -122.42332575716) | ||||
77657 | 77657 | 99736 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 900X Ocean Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5997264.7 | 2091625.4 | 37.7230482703916 | -122.45157991133101 | (37.7230482703916, -122.451579911331) | |||||
77875 | 77875 | 106884 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 180X SAN MARCOS AVE | 6 | Median : Cutout 11 | Tree 1 | Private 1 | DPW 4 | 4 | 5993452.8 | 2100406.9 | 37.746941053663505 | -122.46539437233801 | (37.7469410536635, -122.465394372338) | |||
78019 | 78019 | 4997 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5300X Diamond Heights Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | ||||
78112 | 78112 | 99445 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1601X 15th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5991576.7 | 2104258.5 | 37.7574081656565 | -122.472162400604 | (37.7574081656565, -122.472162400604) | |||||
78172 | 78172 | 442 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 700x 23rd Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5988814.32729 | 2110443.9038299997 | 37.7742313463884 | -122.482168813724 | (37.7742313463884, -122.482168813724) | ||||
78182 | 78182 | 16288 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 700X Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 18 | 5997448.036427 | 2094744.2173306 | 37.7316223027997 | -122.45117096626998 | (37.7316223027997, -122.45117096627) | |||
78288 | 78288 | 99129 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 302X Pacheco St | 12 | Median : Cutout 11 | Tree 1 | Private 1 | 18 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
78616 | 78616 | 106550 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 81 MINERVA ST | Median : Cutout 11 | Tree 1 | DPW 2 | 5996079.6 | 2088963.3 | 37.7156708325413 | -122.455484227095 | (37.7156708325413, -122.455484227095) | ||||||
78674 | 78674 | 99497 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 1400X Plymouth Ave | 4 | Median : Cutout 11 | Tree 1 | Private 1 | 5995903.0 | 2093347.3 | 37.7276981218086 | -122.45641145576 | (37.7276981218086, -122.45641145576) | |||||
78773 | 78773 | 97390 | DPW Maintained 3 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 1400X Broadway | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 6006851.0 | 2118099.6 | 37.7962845906619 | -122.420320069483 | (37.7962845906619, -122.420320069483) | |||||
78844 | 78844 | 24312 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 258X Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6000364.9354737 | 2094709.7194476002 | 37.7316941555853 | -122.441084223383 | (37.7316941555853, -122.441084223383) | ||||
79149 | 79149 | 91241 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 842x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2009 12:00:00 AM | 3 | 6005622.0 | 2104059.0 | 37.7576631893365 | -122.423573931211 | (37.7576631893365, -122.423573931211) | |||
79301 | 79301 | 120625 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6004349.0 | 2113949.0 | 37.784746788576705 | -122.428681484586 | (37.7847467885767, -122.428681484586) | |||||
79420 | 79420 | 114061 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X LAKE MERCED BLVD | 7 | Median : Cutout 11 | Tree 1 | Private 1 | 52 | 5987837.0 | 2092819.0 | 37.7257811856502 | -122.484256664993 | (37.7257811856502, -122.484256664993) | ||||
79479 | 79479 | 91245 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 870x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 6005631.0 | 2103898.0 | 37.7572216289442 | -122.423531359417 | (37.7572216289442, -122.423531359417) | |||
79566 | 79566 | 119689 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
79708 | 79708 | 27959 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 307X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 18 | 6013768.7522982005 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | |||
80134 | 80134 | 91278 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1170x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 6005728.0 | 2102148.0 | 37.752422009696005 | -122.42307151190799 | (37.752422009696, -122.423071511908) | |||
80247 | 80247 | 95980 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 6700 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 6 | 5986162.43558 | 2112587.6567 | 37.7799628795758 | -122.49149988415199 | (37.7799628795758, -122.491499884152) | |||
80319 | 80319 | 115517 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 12:52:00 PM | 3 | 6005415.2 | 2107753.5 | 37.767795737129205 | -122.424551925681 | (37.7677957371292, -122.424551925681) | |||
80509 | 80509 | 110645 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200x DRUMM ST | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6013666.0 | 2117675.0 | 37.7955004026749 | -122.396708806749 | (37.7955004026749, -122.396708806749) | |||||
80563 | 80563 | 107239 | DPW Maintained 3 | Salix babylonica :: Weeping Willow 182 | 300x Liberty St | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 27 | 6004353.0 | 2103966.0 | 37.7573361226439 | -122.42795602638 | (37.7573361226439, -122.42795602638) | ||||
80604 | 80604 | 109658 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X BROTHERHOOD WAY | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.47553203031799 | (37.7142908027957, -122.475532030318) | |||||
80683 | 80683 | 119723 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 104x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
81195 | 81195 | 115191 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5999393.52095 | 2089220.32873 | 37.7165661770546 | -122.444048302203 | (37.7165661770546, -122.444048302203) | ||||
81389 | 81389 | 120633 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1500 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6004538.0 | 2114050.0 | 37.7850348039721 | -122.428034806681 | (37.7850348039721, -122.428034806681) | |||||
81565 | 81565 | 443 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700x 23rd Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5988815.988030001 | 2110428.99683 | 37.774190512498706 | -122.482161976658 | (37.7741905124987, -122.482161976658) | ||||
81812 | 81812 | 91488 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 750x Brotherhood Way | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/15/2007 12:00:00 AM | 3 | 5991053.474444999 | 2088092.0369650002 | 37.7129888676025 | -122.472793145921 | (37.7129888676025, -122.472793145921) | |||
81983 | 81983 | 99149 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 302X Pacheco St | 33 | Median : Cutout 11 | Tree 1 | Private 1 | 24 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
82090 | 82090 | 27775 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 299X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 26 | 6013785.1217042 | 2118375.8431165 | 37.797431381421 | -122.39634576874799 | (37.797431381421, -122.396345768748) | |||
82614 | 82614 | 91242 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 842x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2009 12:00:00 AM | 3 | 6005622.0 | 2104059.0 | 37.7576631893365 | -122.423573931211 | (37.7576631893365, -122.423573931211) | |||
82803 | 82803 | 102580 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Drumm St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2013 12:00:00 AM | Permit Number 769964 | 6013786.1 | 2116863.1 | 37.7932777999137 | -122.396236306259 | (37.7932777999137, -122.396236306259) | |||
83208 | 83208 | 91248 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 888x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/20/2016 07:34:00 AM | 3 | 6005668.887935 | 2103795.421709 | 37.7569421113624 | -122.423393035961 | (37.7569421113624, -122.423393035961) | |||
83214 | 83214 | 448 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700x 23rd Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5988818.05287 | 2110350.21953 | 37.773974331987795 | -122.482149061597 | (37.7739743319878, -122.482149061597) | ||||
83274 | 83274 | 99496 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Plymouth Ave | 3 | Median : Cutout 11 | Tree 1 | Private 1 | 5995903.0 | 2093347.3 | 37.7276981218086 | -122.45641145576 | (37.7276981218086, -122.45641145576) | |||||
83372 | 83372 | 99155 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 302X Pacheco St | 38 | Median : Cutout 11 | Tree 1 | Private 1 | 3 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
83555 | 83555 | 458 | DPW Maintained 3 | Ficus rubiginosa :: Port Jackson Fig 188 | 760x 23rd Ave | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5988831.51293 | 2110000.66067 | 37.7730153231025 | -122.482076888223 | (37.7730153231025, -122.482076888223) | ||||
83574 | 83574 | 99156 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 302X Pacheco St | 39 | Median : Cutout 11 | Tree 1 | Private 1 | 6 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
83636 | 83636 | 99447 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1601X 15th Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 5991576.7 | 2104258.5 | 37.7574081656565 | -122.472162400604 | (37.7574081656565, -122.472162400604) | |||||
83870 | 83870 | 107512 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1528X ALEMANY BLVD | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6001955.0 | 2093277.9 | 37.727853146555 | -122.435484669091 | (37.727853146555, -122.435484669091) | |||||
83899 | 83899 | 119728 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 104x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
84036 | 84036 | 27864 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
84388 | 84388 | 20971 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2002X Sunset Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | ||||
84752 | 84752 | 106462 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 3500X MISSION ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716001 | (37.7405398531137, -122.42332575716) | ||||
84832 | 84832 | 119681 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x Octavia St Frontage East | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109501.0 | 6005733.0 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | |||||
84835 | 84835 | 86968 | Permitted Site 1 | Tree(s) :: 17 | 3250 Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 10/27/2007 12:00:00 AM | Permit Number 49934 | 6005499.7 | 2121504.7 | 37.8055578865418 | -122.42523827370701 | (37.8055578865418, -122.425238273707) | |||
84867 | 84867 | 119767 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 204x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
84876 | 84876 | 91279 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1170x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 6005728.0 | 2102148.0 | 37.752422009696005 | -122.42307151190799 | (37.752422009696, -122.423071511908) | |||
84934 | 84934 | 119788 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 202x Octavia St Frontage East | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110143.0 | 6005643.0 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | |||||
85011 | 85011 | 119690 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
85186 | 85186 | 91292 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1286x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 6005762.0 | 2101471.0 | 37.7505650422621 | -122.422905822788 | (37.7505650422621, -122.422905822788) | |||
85262 | 85262 | 115190 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5999393.52095 | 2089220.32873 | 37.7165661770546 | -122.444048302203 | (37.7165661770546, -122.444048302203) | ||||
85315 | 85315 | 119826 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
85707 | 85707 | 99130 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 302X Pacheco St | 13 | Median : Cutout 11 | Tree 1 | Private 1 | 18 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
85972 | 85972 | 119818 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
86069 | 86069 | 115193 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5999393.52095 | 2089220.32873 | 37.7165661770546 | -122.444048302203 | (37.7165661770546, -122.444048302203) | ||||
86095 | 86095 | 103414 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 1490X Plymouth Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 04/18/2013 12:00:00 AM | Permit Number 770026 | 5995919.3 | 2094026.5 | 37.7295639775589 | -122.456404198854 | (37.7295639775589, -122.456404198854) | |||
86411 | 86411 | 115186 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5999393.52095 | 2089220.32873 | 37.7165661770546 | -122.444048302203 | (37.7165661770546, -122.444048302203) | ||||
86483 | 86483 | 119684 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
86543 | 86543 | 119734 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 104x Octavia St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
86793 | 86793 | 115518 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 12:33:00 PM | 3 | 6005415.2 | 2107753.5 | 37.767795737129205 | -122.424551925681 | (37.7677957371292, -122.424551925681) | |||
87238 | 87238 | 99735 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 900X Ocean Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5997264.7 | 2091625.4 | 37.7230482703916 | -122.45157991133101 | (37.7230482703916, -122.451579911331) | |||||
87396 | 87396 | 91276 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1156x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2009 12:00:00 AM | 3 | 6005723.0 | 2102230.0 | 37.75264688060071 | -122.42309463069999 | (37.7526468806007, -122.4230946307) | |||
87404 | 87404 | 99494 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Plymouth Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 5995903.0 | 2093347.3 | 37.7276981218086 | -122.45641145576 | (37.7276981218086, -122.45641145576) | |||||
87539 | 87539 | 91285 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1212x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 6005738.0 | 2101906.0 | 37.7517580978369 | -122.42301973133999 | (37.7517580978369, -122.42301973134) |
JSON shape: default, array, newline-delimited
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");