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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19071 | 19071 | 10185 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1125 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005788.9112599995 | 2102417.59249 | 37.7531656854677 | -122.422880028901 | (37.7531656854677, -122.422880028901) | |||
19433 | 19433 | 10011 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 198 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 2X3 | 6005417.15338 | 2107897.14895 | 37.76819027309789 | -122.424555388522 | (37.7681902730979, -122.424555388522) | |||
19488 | 19488 | 10031 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 310 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 2x3 | 6005459.49344 | 2107143.4221799998 | 37.7661231103266 | -122.42435532265301 | (37.7661231103266, -122.424355322653) | |||
19863 | 19863 | 27655 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1680 Mission St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006765.6884 | 2108667.1143 | 37.770380480168704 | -122.419945578015 | (37.7703804801687, -122.419945578015) | |||
19969 | 19969 | 10013 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 215 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x2 | 6005495.275 | 2107715.11687 | 37.7676948680391 | -122.42427222529899 | (37.7676948680391, -122.424272225299) | |||
20101 | 20101 | 10202 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1243 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005829.09689 | 2101725.42508 | 37.7512674207747 | -122.42269187452601 | (37.7512674207747, -122.422691874526) | |||
20132 | 20132 | 10004 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 150 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X3 | 6005403.33839 | 2108127.1988 | 37.768821154693896 | -122.424619539876 | (37.7688211546939, -122.424619539876) | |||
20212 | 20212 | 5507 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 800 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 2x2 | 6004984.13536 | 2103653.10654 | 37.756512676133 | -122.42575103988999 | (37.756512676133, -122.42575103989) | |||
20442 | 20442 | 19325 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 212 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X4 | 5993418.3820400005 | 2089852.67557 | 37.717959779598 | -122.464747082736 | (37.717959779598, -122.464747082736) | |||
20535 | 20535 | 10072 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 573 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005609.84736 | 2105668.09746 | 37.7620807071743 | -122.423730368485 | (37.7620807071743, -122.423730368485) | |||
20855 | 20855 | 17135 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2033 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5997261.7134 | 2109120.9259 | 37.771086505654104 | -122.45285242516701 | (37.7710865056541, -122.452852425167) | |||
21508 | 21508 | 16954 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 660 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003830.0479 | 2110098.0565 | 37.7741436701635 | -122.430202060124 | (37.7741436701635, -122.430202060124) | |||
21805 | 21805 | 10058 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 451 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x5 | 6005573.3175800005 | 2106314.3851 | 37.763853198087 | -122.4239026696 | (37.763853198087, -122.4239026696) | |||
21820 | 21820 | 10021 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 274 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3x4 | 6005443.44254 | 2107417.66285 | 37.7668752034469 | -122.424430347706 | (37.7668752034469, -122.424430347706) | |||
22091 | 22091 | 10162 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1013 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 6005758.27618 | 2103002.2349099996 | 37.7547692495131 | -122.42302752222099 | (37.7547692495131, -122.423027522221) | |||
22133 | 22133 | 10187 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1135 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005790.8424 | 2102360.27695 | 37.7530084192058 | -122.422869277503 | (37.7530084192058, -122.422869277503) | |||
22177 | 22177 | 10214 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1335 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X3 | 6005859.10485 | 2101158.22325 | 37.7497117078336 | -122.422547803155 | (37.7497117078336, -122.422547803155) | |||
22389 | 22389 | 23387 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1661 Pine St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006004.3296300005 | 2115544.61706 | 37.7892215019103 | -122.423068034874 | (37.7892215019103, -122.423068034874) | |||
22439 | 22439 | 17748 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1661 Pine St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005989.12058 | 2115543.08105 | 37.7892164261498 | -122.42312054718501 | (37.7892164261498, -122.423120547185) | |||
22641 | 22641 | 23386 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1661 Pine St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006045.46684 | 2115549.5575099997 | 37.789237388446296 | -122.422926056205 | (37.7892373884463, -122.422926056205) | |||
22642 | 22642 | 17747 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1661 Pine St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005995.8351300005 | 2115543.3505 | 37.7892175449029 | -122.423097334789 | (37.7892175449029, -122.423097334789) | |||
22764 | 22764 | 23385 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1661 Pine St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006030.41853 | 2115547.69719 | 37.7892314313446 | -122.42297798933599 | (37.7892314313446, -122.422977989336) | |||
23037 | 23037 | 25706 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 582 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6012130.73474 | 2110269.98363 | 37.7750823930813 | -122.401500433298 | (37.7750823930813, -122.401500433298) | |||
23120 | 23120 | 12201 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1485 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3X3 | 6016149.0568 | 2095651.2946 | 37.7351659473192 | -122.38658047187599 | (37.7351659473192, -122.386580471876) | |||
23202 | 23202 | 77640 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 13 | 0 | 6006980.92428 | 2093193.1114700001 | 37.7279045016753 | -122.418103887786 | (37.7279045016753, -122.418103887786) | |
23288 | 23288 | 15312 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1665 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/27/2001 12:00:00 AM | 4 | 3X3 | 6006906.5597 | 2108955.7422 | 37.771180919322 | -122.419478782903 | (37.771180919322, -122.419478782903) | ||
23320 | 23320 | 6751 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1215 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/1992 12:00:00 AM | 7 | 6017537.38126 | 2096718.5380000002 | 37.738173145164104 | -122.38185469014499 | (37.7381731451641, -122.381854690145) | |||
23365 | 23365 | 5074 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 5593 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/1992 12:00:00 AM | 3 | 6001579.88731 | 2097086.51396 | 37.73828941133 | -122.43705400175699 | (37.73828941133, -122.437054001757) | |||
47442 | 47442 | 11955 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1469 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6015772.6789286 | 2096311.6012512 | 37.7369581722856 | -122.387927819023 | (37.7369581722856, -122.387927819023) | |||
47682 | 47682 | 207809 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 200x Terrace Dr | 30 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 5993795.90954 | 2096545.0474900003 | 37.736357157655604 | -122.46392766184601 | (37.7363571576556, -122.463927661846) | ||||
52138 | 52138 | 177088 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 300x Winding Way | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6001504.621119999 | 2086478.58914 | 37.7091581713864 | -122.436555171203 | (37.7091581713864, -122.436555171203) | |||
53966 | 53966 | 191502 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 299x Cashmere St | 29 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6016510.31046 | 2096089.32701 | 37.736388688783705 | -122.38536198946899 | (37.7363886887837, -122.385361989469) | ||||
78058 | 78058 | 20276 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2291 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6009755.789969999 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | |||
78861 | 78861 | 6767 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1275 Fairfax Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/1992 12:00:00 AM | 12 | 3x3 | 6017284.4858800005 | 2096909.9197200001 | 37.738684672549205 | -122.38274239930401 | (37.7386846725492, -122.382742399304) | ||
78963 | 78963 | 12206 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1365X La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.38458793904199 | (37.7327261850679, -122.384587939042) | |||
79769 | 79769 | 113436 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 198x HIGHLAND AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 4x4 | 6006173.0 | 2096415.0 | 37.73670559026029 | -122.421125584355 | (37.7367055902603, -122.421125584355) | ||||
80698 | 80698 | 12309 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 949 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004806.2528800005 | 2112097.03189 | 37.7796876103034 | -122.426967593325 | (37.7796876103034, -122.426967593325) | |||
80701 | 80701 | 99678 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1250X Shrader St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 4x4 | Permit Number 770537 | 5997882.0 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | |
82533 | 82533 | 42985 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2X Yale St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/16/2000 12:00:00 AM | 12 | 9x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) |
82679 | 82679 | 9998 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 122 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2X2 | 6005390.2576582 | 2108319.0051408 | 37.7693470701553 | -122.424678431625 | (37.7693470701553, -122.424678431625) | |||
82904 | 82904 | 12198 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1485 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016165.701365701 | 2095622.0691082 | 37.7350866214264 | -122.38652088789301 | (37.7350866214264, -122.386520887893) | |||
83389 | 83389 | 422 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 685X Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005653.198434 | 2104994.6037312 | 37.7602338989595 | -122.423532549649 | (37.7602338989595, -122.423532549649) | |||
83552 | 83552 | 12331 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1045 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 4X4 | 6004735.877669999 | 2112555.20778 | 37.7809416686235 | -122.42724369777201 | (37.7809416686235, -122.427243697772) | |||
84373 | 84373 | 12120 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1325X La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016848.207852599 | 2094661.9057693002 | 37.732487962838604 | -122.38409435335 | (37.7324879628386, -122.38409435335) | |||
84836 | 84836 | 14761 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 971 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6004507.86758 | 2111873.23509 | 37.7790562429454 | -122.427983885875 | (37.7790562429454, -122.427983885875) | |||
85014 | 85014 | 20210 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1349 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002745.5181122 | 2112859.7826276002 | 37.781665193424104 | -122.43415110441099 | (37.7816651934241, -122.434151104411) | |||
85072 | 85072 | 1696 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 34 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017739.602575701 | 2093657.002741 | 37.72977793847971 | -122.380942720777 | (37.7297779384797, -122.380942720777) | |||
86245 | 86245 | 12329 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1035 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 4X4 | 6004738.4302199995 | 2112529.1477 | 37.7808702584368 | -122.427233010388 | (37.7808702584368, -122.427233010388) | |||
86417 | 86417 | 9946 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2145X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007159.165551 | 2119559.7591564 | 37.8003111812757 | -122.41935738709299 | (37.8003111812757, -122.419357387093) | |||
86964 | 86964 | 113437 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 198x HIGHLAND AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 4x4 | 6006173.0 | 2096415.0 | 37.73670559026029 | -122.421125584355 | (37.7367055902603, -122.421125584355) | ||||
88675 | 88675 | 77637 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2X Yale St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 14 | 4x4 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) | |
88966 | 88966 | 8120 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 850X Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6003699.00422 | 2111459.33104 | 37.777873970946295 | -122.43075252591801 | (37.7778739709463, -122.430752525918) | |||
89495 | 89495 | 14762 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 975 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6004490.14846 | 2111870.78512 | 37.779048513468105 | -122.42804500886601 | (37.7790485134681, -122.428045008866) | |||
89649 | 89649 | 27488 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2113 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005940.11472 | 2117615.5981 | 37.7949042735724 | -122.42343749988899 | (37.7949042735724, -122.423437499889) | |||
89660 | 89660 | 113434 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 198x HIGHLAND AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12 | 4x4 | 6006173.0 | 2096415.0 | 37.73670559026029 | -122.421125584355 | (37.7367055902603, -122.421125584355) | |||
90722 | 90722 | 12296 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 853 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004840.61204 | 2111776.51991 | 37.778809506036204 | -122.426825897852 | (37.7788095060362, -122.426825897852) | |||
91159 | 91159 | 20202 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1315 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002746.658969999 | 2112743.01466 | 37.781344642713 | -122.434138807658 | (37.781344642713, -122.434138807658) | |||
92018 | 92018 | 110190 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 625 Holly Park Cir | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6006167.62160945 | 2096413.49051844 | 37.736701142359294 | -122.421144072665 | (37.7367011423593, -122.421144072665) | |||||
93011 | 93011 | 113435 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 198x HIGHLAND AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 4x4 | 6006173.0 | 2096415.0 | 37.73670559026029 | -122.421125584355 | (37.7367055902603, -122.421125584355) | ||||
93778 | 93778 | 12323 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1005 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6004764.65332 | 2112355.43854 | 37.780394778918904 | -122.427129915227 | (37.7803947789189, -122.427129915227) | |||
94044 | 94044 | 9319 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 99X Gold Mine Dr | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 2x2 | 6001391.6487444 | 2098856.3848919 | 37.743138360608704 | -122.437831565564 | (37.7431383606087, -122.437831565564) | |||
94799 | 94799 | 7993 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2250 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005514.59005 | 2117689.16769 | 37.7950822509185 | -122.42491511428301 | (37.7950822509185, -122.424915114283) | |||
96817 | 96817 | 7985 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2111 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005519.50842 | 2117258.74677 | 37.7939007015449 | -122.42486745909201 | (37.7939007015449, -122.424867459092) | |||
96962 | 96962 | 12285 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 803X Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004627.99576 | 2111737.28964 | 37.7786897656705 | -122.427558625827 | (37.7786897656705, -122.427558625827) | |||
97255 | 97255 | 110187 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 625 Holly Park Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6006167.62160945 | 2096413.49051844 | 37.736701142359294 | -122.421144072665 | (37.7367011423593, -122.421144072665) | |||||
97647 | 97647 | 27658 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1698X Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006725.5802 | 2108585.93757 | 37.7701553284346 | -122.420078550817 | (37.7701553284346, -122.420078550817) | |||
98083 | 98083 | 10181 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1097X Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005777.346268901 | 2102574.3880576002 | 37.753595557271 | -122.422931166019 | (37.753595557271, -122.422931166019) | |||
98684 | 98684 | 9317 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 99X Gold Mine Dr | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.743138360608704 | -122.437831565564 | (37.7431383606087, -122.437831565564) | ||
99391 | 99391 | 17145 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1030 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1992 12:00:00 AM | 6 | 3X3 | 6018053.0176703 | 2093253.3980264 | 37.7286870123052 | -122.37983116682699 | (37.7286870123052, -122.379831166827) | ||
99786 | 99786 | 10163 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1013 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2x2 | 6005764.7450429 | 2102960.7456767 | 37.7546556947331 | -122.423002202394 | (37.7546556947331, -122.423002202394) | |||
100933 | 100933 | 42989 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2X Yale St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/05/2000 12:00:00 AM | 10 | 5x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) |
102821 | 102821 | 7209 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1225X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003292.04755 | 2111699.2584599997 | 37.7785096871687 | -122.43217746913601 | (37.7785096871687, -122.432177469136) | |||
103677 | 103677 | 25292 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 136 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000743.1124599995 | 2091772.81119 | 37.7236516133979 | -122.439566330441 | (37.7236516133979, -122.439566330441) | |||
103689 | 103689 | 42990 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2X Yale St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/05/2000 12:00:00 AM | 10 | 5x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) |
103760 | 103760 | 18030 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2987 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000614.945586401 | 2114797.0276148 | 37.7868632177605 | -122.44166092474701 | (37.7868632177605, -122.441660924747) | |||
103981 | 103981 | 17345 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 175X Otis St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.42011195674299 | (37.7705111956623, -122.420111956743) | |||
104152 | 104152 | 6715 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1200X Fairfax Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
105257 | 105257 | 26194 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 573 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | Permit Number 772904 | 6002390.549968 | 2104882.2284699 | 37.7597406467411 | -122.43480846230499 | (37.7597406467411, -122.434808462305) | ||
105819 | 105819 | 12118 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1325X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016848.207852599 | 2094661.9057693002 | 37.732487962838604 | -122.38409435335 | (37.7324879628386, -122.38409435335) | |||
105991 | 105991 | 109819 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 909X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4X4 | 6004814.1677377 | 2111967.1785845 | 37.779331512641896 | -122.42693096158101 | (37.7793315126419, -122.426930961581) | ||||
106256 | 106256 | 14757 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 955X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004579.18989 | 2111878.0493 | 37.7790734963365 | -122.42773749615101 | (37.7790734963365, -122.427737496151) | |||
106702 | 106702 | 10129 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 892 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6005646.9391641 | 2103763.6492254 | 37.7568536327232 | -122.42346668441999 | (37.7568536327232, -122.42346668442) | |||
107274 | 107274 | 12183 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1445 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016331.060111799 | 2095306.4617143 | 37.7342291794135 | -122.385927185653 | (37.7342291794135, -122.385927185653) | |||
107293 | 107293 | 27486 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2113 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6005940.11472 | 2117615.5981 | 37.7949042735724 | -122.42343749988899 | (37.7949042735724, -122.423437499889) | |||
107948 | 107948 | 8121 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 850X Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6003699.00422 | 2111459.33104 | 37.777873970946295 | -122.43075252591801 | (37.7778739709463, -122.430752525918) | |||
108812 | 108812 | 7212 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1225X McAllister St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003292.04755 | 2111699.2584599997 | 37.7785096871687 | -122.43217746913601 | (37.7785096871687, -122.432177469136) | |||
109074 | 109074 | 42988 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2X Yale St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/16/2000 12:00:00 AM | 10 | 4x5 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) |
109148 | 109148 | 12299 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 881 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6004832.93645 | 2111868.25149 | 37.7790609444122 | -122.426858985423 | (37.7790609444122, -122.426858985423) | |||
109337 | 109337 | 12172 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1419X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.38587626093799 | (37.7340798748876, -122.385876260938) | |||
110687 | 110687 | 12310 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 949 Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/1993 12:00:00 AM | 6 | 4X4 | 6004809.18722 | 2111991.6762900003 | 37.7793984956931 | -122.426949936516 | (37.7793984956931, -122.426949936516) | ||
111433 | 111433 | 77635 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2X Yale St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 4x4 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) | |
111795 | 111795 | 25294 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 150 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000635.349880001 | 2091747.8935900002 | 37.7235770614816 | -122.439937060329 | (37.7235770614816, -122.439937060329) | |||
111824 | 111824 | 12298 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 869 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004833.398019999 | 2111828.5317 | 37.778951909736 | -122.42685455914801 | (37.778951909736, -122.426854559148) | |||
112287 | 112287 | 12177 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1409X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.38587626093799 | (37.7340798748876, -122.385876260938) | |||
113185 | 113185 | 13031 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 462 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/21/2015 12:00:00 AM | 10 | 3X3 | 6010124.59861 | 2120694.43773 | 37.803593298513 | -122.409175884375 | (37.803593298513, -122.409175884375) | ||
113484 | 113484 | 27487 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2113 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005940.11472 | 2117615.5981 | 37.7949042735724 | -122.42343749988899 | (37.7949042735724, -122.423437499889) | |||
113966 | 113966 | 77633 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2X Yale St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 8 | 3x3 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) | |
114668 | 114668 | 14799 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1135 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003745.74789 | 2111758.98852 | 37.778699404291395 | -122.43061221122801 | (37.7786994042914, -122.430612211228) | |||
114969 | 114969 | 12284 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 803X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004627.99576 | 2111737.28964 | 37.7786897656705 | -122.427558625827 | (37.7786897656705, -122.427558625827) | |||
115266 | 115266 | 77636 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2X Yale St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 4x4 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) |
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");