Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2214 | 2214 | 4695 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 850X Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 4x8 | 6008940.69941 | 2120350.9777900004 | 37.802583847399 | -122.41324853649999 | (37.802583847399, -122.4132485365) | |||
| 102596 | 102596 | 13012 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 400 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 6010380.849090001 | 2120676.56867 | 37.8035585868989 | -122.408287852113 | (37.8035585868989, -122.408287852113) | |||
| 113541 | 113541 | 585 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3035 24TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 122 | 3x3 | 6008718.0 | 2102146.0 | 37.752584791835105 | -122.412731419953 | (37.7525847918351, -122.412731419953) | |||
| 78939 | 78939 | 8182 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1218 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6001778.22585 | 2111194.36963 | 37.7770374434445 | -122.437378180533 | (37.7770374434445, -122.437378180533) | |||
| 80014 | 80014 | 13200 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2130X Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6002179.06604 | 2119515.41872 | 37.7999076905723 | -122.43658729566201 | (37.7999076905723, -122.436587295662) | |||
| 85679 | 85679 | 12995 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 336 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6010700.99247 | 2120707.1444 | 37.803660461944105 | -122.407182132325 | (37.8036604619441, -122.407182132325) | |||
| 88637 | 88637 | 5386 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 325X Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6004919.4864142 | 2106495.5645768 | 37.7643137401636 | -122.426176974515 | (37.7643137401636, -122.426176974515) | |||
| 94445 | 94445 | 5387 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 325X Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6004919.4864142 | 2106495.5645768 | 37.7643137401636 | -122.426176974515 | (37.7643137401636, -122.426176974515) | |||
| 94766 | 94766 | 4593 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 100 Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6011460.12974 | 2118136.30046 | 37.7966440043551 | -122.40437402195299 | (37.7966440043551, -122.404374021953) | |||
| 104526 | 104526 | 5390 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 330X Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4X4 | 6004823.7091277 | 2106419.4754113997 | 37.7640994035261 | -122.426502823086 | (37.7640994035261, -122.426502823086) | |||
| 119613 | 119613 | 706 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1509X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6005302.4951599995 | 2099477.85942 | 37.745066397258604 | -122.424353081707 | (37.7450663972586, -122.424353081707) | |||
| 139587 | 139587 | 13199 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2130X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6002179.06604 | 2119515.41872 | 37.7999076905723 | -122.43658729566201 | (37.7999076905723, -122.436587295662) | |||
| 140339 | 140339 | 4631 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 430 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6010350.91598 | 2119042.6907900004 | 37.799070683936 | -122.408276129064 | (37.799070683936, -122.408276129064) | |||
| 142870 | 142870 | 5595 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1100 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3x3 | 6005095.523502599 | 2101950.1341989 | 37.75184300486389 | -122.425244643333 | (37.7518430048639, -122.425244643333) | |||
| 20379 | 20379 | 9943 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 601X Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 6x5 | 6010129.67767 | 2119173.05666 | 37.7994162456962 | -122.409050895178 | (37.7994162456962, -122.409050895178) | |||
| 83928 | 83928 | 4754 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1250 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 4X4 | 6007719.65165 | 2121534.5567900003 | 37.8057650284682 | -122.41755791876301 | (37.8057650284682, -122.417557918763) | |||
| 88029 | 88029 | 5481 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 700X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 80 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | |||
| 96497 | 96497 | 9942 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 601X Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 6x5 | 6010129.67767 | 2119173.05666 | 37.7994162456962 | -122.409050895178 | (37.7994162456962, -122.409050895178) | |||
| 102869 | 102869 | 9944 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 601X Green St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3X3 | 6010102.57699 | 2119179.9289599997 | 37.79943359716321 | -122.40914515871701 | (37.7994335971632, -122.409145158717) | |||
| 111276 | 111276 | 702 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1399X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005246.2674799 | 2100192.367786 | 37.747025098470004 | -122.42459832380699 | (37.74702509847, -122.424598323807) | |||
| 122662 | 122662 | 5728 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1688 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005263.116177299 | 2098508.6699422 | 37.742402999925 | -122.42442032403 | (37.742402999925, -122.42442032403) | |||
| 127680 | 127680 | 4753 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1250 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 4X4 | 6007719.65165 | 2121534.5567900003 | 37.8057650284682 | -122.41755791876301 | (37.8057650284682, -122.417557918763) | |||
| 93705 | 93705 | 4657 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 599X Columbus Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3x3 | 6009795.85928 | 2119479.51144 | 37.800238989308504 | -122.41022767808 | (37.8002389893085, -122.41022767808) | |||
| 102076 | 102076 | 4573 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 4 | 6011767.886 | 2117749.45401 | 37.7955990100454 | -122.403281883117 | (37.7955990100454, -122.403281883117) | |||
| 126681 | 126681 | 10586 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1050X Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 75 | 3X3 | 6011036.2882597 | 2110765.2479161 | 37.7763811461579 | -122.40532126913901 | (37.7763811461579, -122.405321269139) | |||
| 5440 | 5440 | 13266 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2460 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 70 | 3X3 | 6000592.3683 | 2119282.3787 | 37.7991775301158 | -122.44206111460501 | (37.7991775301158, -122.442061114605) | ||
| 19024 | 19024 | 4603 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 270 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6010933.33158 | 2118545.7793 | 37.7977388815556 | -122.406225735505 | (37.7977388815556, -122.406225735505) | |||
| 78965 | 78965 | 11046 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1560 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007462.427490001 | 2117742.7343900003 | 37.795339161156605 | -122.41817908492399 | (37.7953391611566, -122.418179084924) | |||
| 79589 | 79589 | 11091 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1906 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6007294.23278 | 2118880.01642 | 37.7984523847496 | -122.41884176477899 | (37.7984523847496, -122.418841764779) | |||
| 81633 | 81633 | 11103 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1995X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007217.8875 | 2119096.40041 | 37.7990422218557 | -122.419121300277 | (37.7990422218557, -122.419121300277) | |||
| 82546 | 82546 | 11100 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1960 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007273.5320198 | 2119093.4977666 | 37.7990373853425 | -122.41892854512699 | (37.7990373853425, -122.418928545127) | |||
| 83715 | 83715 | 11108 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2022 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007226.472709999 | 2119353.11491 | 37.799747578786004 | -122.419109811467 | (37.799747578786, -122.419109811467) | |||
| 92050 | 92050 | 13211 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2190 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6001897.52108 | 2119466.2299099998 | 37.7997566277665 | -122.437558020868 | (37.7997566277665, -122.437558020868) | |||
| 92314 | 92314 | 4755 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1250 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4X4 | 6007719.65165 | 2121534.5567900003 | 37.8057650284682 | -122.41755791876301 | (37.8057650284682, -122.417557918763) | |||
| 106854 | 106854 | 11053 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1603 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007388.39144 | 2117874.05515 | 37.795695567741 | -122.418444578472 | (37.795695567741, -122.418444578472) | |||
| 120738 | 120738 | 4455 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1404 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/13/2015 12:00:00 AM | 70 | 3X3 | 6004493.5375 | 2100668.30282 | 37.7482893665971 | -122.42723509655899 | (37.7482893665971, -122.427235096559) | ||
| 121105 | 121105 | 11034 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1509 HYDE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6007406.1 | 2117518.3 | 37.7947197495209 | -122.41835806668699 | (37.7947197495209, -122.418358066687) | |||
| 122066 | 122066 | 11087 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1896 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4x4 | 6007314.6733074 | 2118798.6130291 | 37.7982300223497 | -122.41876525798901 | (37.7982300223497, -122.418765257989) | |||
| 126343 | 126343 | 11033 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1503 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3x3 | 6007448.9758793 | 2117473.8836265 | 37.794600206664796 | -122.418206559463 | (37.7946002066648, -122.418206559463) | |||
| 128449 | 128449 | 11036 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1521 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3x3 | 6007446.95336 | 2117561.22726 | 37.79483991673 | -122.41821975316999 | (37.79483991673, -122.41821975317) | |||
| 142321 | 142321 | 11082 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1849 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007286.994308701 | 2118635.1241551996 | 37.79777956440321 | -122.418849434729 | (37.7977795644032, -122.418849434729) | |||
| 144207 | 144207 | 11086 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1896 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3x3 | 6007314.6733074 | 2118798.6130291 | 37.7982300223497 | -122.41876525798901 | (37.7982300223497, -122.418765257989) | |||
| 124303 | 124303 | 10573 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1000X Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 4x4 | 6011301.87316 | 2111047.97507 | 37.7771722946398 | -122.404422436991 | (37.7771722946398, -122.404422436991) | |||
| 92657 | 92657 | 14655 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 655X McAllister St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6006015.9359491 | 2112078.013352 | 37.779703716761496 | -122.422781416289 | (37.7797037167615, -122.422781416289) | |||
| 100389 | 100389 | 4672 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 659 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6009562.16476 | 2119705.53614 | 37.8008464951643 | -122.411052329729 | (37.8008464951643, -122.411052329729) | |||
| 106865 | 106865 | 17729 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1300X Pierce St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 60 | 3X3 | 6002290.5602400005 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | |||
| 110458 | 110458 | 11085 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1865 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6007279.7286506 | 2118687.2113849 | 37.7979221737821 | -122.41887827208599 | (37.7979221737821, -122.418878272086) | |||
| 80579 | 80579 | 20167 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1175 Steiner St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 4X4 | 6002828.6579039 | 2112263.6806979 | 37.7800331654734 | -122.433820860908 | (37.7800331654734, -122.433820860908) | |||
| 85130 | 85130 | 18366 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 601 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6010418.5901612 | 2105518.9759028 | 37.761941532131296 | -122.407088188566 | (37.7619415321313, -122.407088188566) | |||
| 112679 | 112679 | 17726 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1300X Pierce St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 50 | 3X3 | 6002290.5602400005 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | |||
| 118060 | 118060 | 9620 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1165X Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/16/1990 12:00:00 AM | 50 | 3X3 | 6002862.99505 | 2112096.1743 | 37.779575183286 | -122.433690098242 | (37.779575183286, -122.433690098242) | ||
| 80462 | 80462 | 13254 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2408 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 45 | 3X3 | 6000832.23006 | 2119380.36917 | 37.7994602521243 | -122.441238147567 | (37.7994602521243, -122.441238147567) | ||
| 80486 | 80486 | 4599 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 170 Columbus Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6011285.22621 | 2118219.63855 | 37.796863055188496 | -122.40498510136801 | (37.7968630551885, -122.404985101368) | |||
| 92883 | 92883 | 18465 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1176 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/05/2015 12:00:00 AM | 45 | 3X4 | 6010529.14326 | 2102401.59944 | 37.7533880992141 | -122.40648615219 | (37.7533880992141, -122.40648615219) | ||
| 95402 | 95402 | 18351 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 469 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 6010382.707326401 | 2106125.7302845 | 37.76360553422771 | -122.407255067708 | (37.7636055342277, -122.407255067708) | |||
| 96950 | 96950 | 18459 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1137 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6010601.42584 | 2102531.48836 | 37.7537487889396 | -122.406245333375 | (37.7537487889396, -122.406245333375) | |||
| 108226 | 108226 | 4883 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 87 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 2X2 | 6000657.525159299 | 2098217.505729 | 37.7413423773337 | -122.44032415487499 | (37.7413423773337, -122.440324154875) | |||
| 110135 | 110135 | 11088 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1896 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4x4 | 6007314.6733074 | 2118798.6130291 | 37.7982300223497 | -122.41876525798901 | (37.7982300223497, -122.418765257989) | |||
| 113997 | 113997 | 18453 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1101 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 6010571.1211098 | 2102712.3512406996 | 37.754243703128296 | -122.40636287730499 | (37.7542437031283, -122.406362877305) | |||
| 114377 | 114377 | 18462 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1170 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6010530.25012 | 2102443.0228 | 37.7535019005095 | -122.406485243092 | (37.7535019005095, -122.406485243092) | |||
| 124730 | 124730 | 18463 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1185X Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 6010590.614238201 | 2102338.4990144 | 37.7532182781408 | -122.40626912604701 | (37.7532182781408, -122.406269126047) | |||
| 143922 | 143922 | 18445 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1024 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4x4 | 6010473.6370906 | 2103261.6949103 | 37.7557466249525 | -122.406738715199 | (37.7557466249525, -122.406738715199) | |||
| 145347 | 145347 | 18454 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1106 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 6010521.188939299 | 2102709.7477141004 | 37.7542337610764 | -122.40653537262699 | (37.7542337610764, -122.406535372627) | |||
| 78647 | 78647 | 9661 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 112 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6006079.1393099995 | 2110176.8838400003 | 37.7744872417771 | -122.422427647286 | (37.7744872417771, -122.422427647286) | |||
| 79549 | 79549 | 18364 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 598 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6010361.2141646 | 2105516.7578044 | 37.7619322307219 | -122.40728647423201 | (37.7619322307219, -122.407286474232) | |||
| 85412 | 85412 | 18467 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1185X Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6010590.614238201 | 2102338.4990144 | 37.7532182781408 | -122.40626912604701 | (37.7532182781408, -122.406269126047) | |||
| 88132 | 88132 | 18444 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1020 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6010472.2950908 | 2103284.5044843 | 37.7558091798762 | -122.40674496371099 | (37.7558091798762, -122.406744963711) | |||
| 90758 | 90758 | 18316 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 199 POTRERO AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6010430.0 | 2107503.0 | 37.767389850144205 | -122.407188587519 | (37.7673898501442, -122.407188587519) | |||
| 92230 | 92230 | 18160 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401X Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6005423.38609 | 2114511.38367 | 37.7863517006932 | -122.42500448695 | (37.7863517006932, -122.42500448695) | |||
| 107059 | 107059 | 18365 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 598 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6010361.2141646 | 2105516.7578044 | 37.7619322307219 | -122.40728647423201 | (37.7619322307219, -122.407286474232) | |||
| 111103 | 111103 | 18327 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 259 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X2 | 6010329.0895487 | 2107117.8320658 | 37.7663266190773 | -122.407510465965 | (37.7663266190773, -122.407510465965) | |||
| 112638 | 112638 | 18329 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 269 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6010332.3440196 | 2107072.4168362 | 37.7662021013824 | -122.407496007113 | (37.7662021013824, -122.407496007113) | |||
| 113700 | 113700 | 18451 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1082 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6010493.0142586 | 2102932.3469158 | 37.7548433927728 | -122.40664849396002 | (37.7548433927728, -122.40664849396) | |||
| 118723 | 118723 | 18390 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 866 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6010418.2672605 | 2104189.3928818 | 37.7582907781506 | -122.406995587546 | (37.7582907781506, -122.406995587546) | |||
| 119954 | 119954 | 26666 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1015 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 5992306.14573 | 2114757.6166 | 37.78627810348571 | -122.47040431482401 | (37.7862781034857, -122.470404314824) | |||
| 120949 | 120949 | 12630 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 841 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 5992831.38337 | 2114795.44702 | 37.7864123300728 | -122.46858989794501 | (37.7864123300728, -122.468589897945) | |||
| 121281 | 121281 | 18380 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 756 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6010387.2722525 | 2104782.2318448997 | 37.7599168463595 | -122.40714457080601 | (37.7599168463595, -122.407144570806) | |||
| 123128 | 123128 | 18326 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 259 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6010329.0895487 | 2107117.8320658 | 37.7663266190773 | -122.407510465965 | (37.7663266190773, -122.407510465965) | |||
| 125024 | 125024 | 18320 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 206 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6010262.275043599 | 2107350.6845554 | 37.766962238724496 | -122.40775798639 | (37.7669622387245, -122.40775798639) | |||
| 125589 | 125589 | 14651 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 655X McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6006015.9359491 | 2112078.013352 | 37.779703716761496 | -122.422781416289 | (37.7797037167615, -122.422781416289) | |||
| 127221 | 127221 | 23821 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Webster St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6003795.894280001 | 2112830.35916 | 37.7816439623395 | -122.430515201234 | (37.7816439623395, -122.430515201234) | |||
| 127480 | 127480 | 18322 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 226 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6010268.7839855 | 2107259.8540962 | 37.7667132034185 | -122.40772906765699 | (37.7667132034185, -122.407729067657) | |||
| 138416 | 138416 | 4597 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 170 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6011285.22621 | 2118219.63855 | 37.796863055188496 | -122.40498510136801 | (37.7968630551885, -122.404985101368) | |||
| 139702 | 139702 | 18159 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401X Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3x3 | 6005423.15 | 2114537.67279 | 37.7864238707484 | -122.425007174907 | (37.7864238707484, -122.425007174907) | |||
| 141446 | 141446 | 18468 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6010533.61703 | 2102196.70237 | 37.7528257474783 | -122.40645624412201 | (37.7528257474783, -122.406456244122) | |||
| 143279 | 143279 | 18328 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 269 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6010332.3440196 | 2107072.4168362 | 37.7662021013824 | -122.407496007113 | (37.7662021013824, -122.407496007113) | |||
| 82278 | 82278 | 11175 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2740 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3X3 | Permit Number 769071 | 6006912.197631501 | 2121679.9811893995 | 37.8061188596167 | -122.420362567782 | (37.8061188596167, -122.420362567782) | ||
| 83569 | 83569 | 11177 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2740 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3X3 | Permit Number 769071 | 6006912.197631501 | 2121679.9811893995 | 37.8061188596167 | -122.420362567782 | (37.8061188596167, -122.420362567782) | ||
| 89128 | 89128 | 112051 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3748x 22ND ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3x3 | 6003448.0 | 2103060.0 | 37.7547972209553 | -122.431021210073 | (37.7547972209553, -122.431021210073) | |||
| 98732 | 98732 | 117124 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 766 NOE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3x3 | 6003023.0 | 2103770.0 | 37.7567226205836 | -122.43254168701401 | (37.7567226205836, -122.432541687014) | |||
| 104663 | 104663 | 53708 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 350 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/1970 12:00:00 AM | 36 | Permit Number 6655 | 6003550.85725641 | 2106242.74617004 | 37.7635421097395 | -122.430892631532 | (37.7635421097395, -122.430892631532) | ||
| 77740 | 77740 | 1442 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 144 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5995540.31731 | 2115189.6989 | 37.7876509503315 | -122.459246293031 | (37.7876509503315, -122.459246293031) | |||
| 77761 | 77761 | 22671 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1140X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6003752.72615 | 2112639.8215900003 | 37.7811183481869 | -122.43065094190099 | (37.7811183481869, -122.430650941901) | |||
| 79580 | 79580 | 19375 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 390X 06th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6011348.292859999 | 2111104.97037 | 37.7773313845055 | -122.404265868127 | (37.7773313845055, -122.404265868127) | |||
| 81143 | 81143 | 4596 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 170 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6011285.22621 | 2118219.63855 | 37.796863055188496 | -122.40498510136801 | (37.7968630551885, -122.404985101368) | |||
| 83726 | 83726 | 11117 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2054 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6007235.1189832 | 2119374.3616564 | 37.7998064039059 | -122.419081399975 | (37.7998064039059, -122.419081399975) | |||
| 99574 | 99574 | 18298 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 35X Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6010274.737783 | 2108072.9305947 | 37.7689460585554 | -122.407765812226 | (37.7689460585554, -122.407765812226) | |||
| 107588 | 107588 | 22672 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1115X Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6003756.1555 | 2112617.12958 | 37.781056235864796 | -122.430637458337 | (37.7810562358648, -122.430637458337) | |||
| 108208 | 108208 | 13204 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2150 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6001979.60867 | 2119494.8171 | 37.799839787435104 | -122.43727601604701 | (37.7998397874351, -122.437276016047) | |||
| 112890 | 112890 | 4595 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 170 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6011285.22621 | 2118219.63855 | 37.796863055188496 | -122.40498510136801 | (37.7968630551885, -122.404985101368) |
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");