Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7811 | 7811 | 124731 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 198X Division St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010680.0 | 2108566.0 | 37.7703225929477 | -122.406398777104 | (37.7703225929477, -122.406398777104) | ||||
| 9043 | 9043 | 173595 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 75 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015060.0 | 2116254.0 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | ||||
| 27184 | 27184 | 117402 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 75x BEACH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009846.0 | 2122112.0 | 37.80746995952921 | -122.410240137563 | (37.8074699595292, -122.410240137563) | ||||
| 62742 | 62742 | 100053 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3233X Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003300.0 | 2119605.0 | 37.800217292537106 | -122.432714848025 | (37.8002172925371, -122.432714848025) | |||
| 77860 | 77860 | 102602 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 88 Spear St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6014255.3 | 2116583.4 | 37.7925359054466 | -122.394593235194 | (37.7925359054466, -122.394593235194) | |||
| 78720 | 78720 | 102621 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 190X Pfeiffer St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 18461 | 6009953.9 | 2121114.8 | 37.8047379445266 | -122.409796287705 | (37.8047379445266, -122.409796287705) | ||
| 78900 | 78900 | 9577 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1290X Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5x5 | 6003415.08005 | 2112113.96459 | 37.7796553418115 | -122.431781470984 | (37.7796553418115, -122.431781470984) | |||
| 79278 | 79278 | 7198 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 949 Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003395.6816300005 | 2111577.87165 | 37.778182264409295 | -122.431810290332 | (37.7781822644093, -122.431810290332) | |||
| 79382 | 79382 | 22281 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 4755X 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 18 | 3X3 | 6015037.5047362 | 2095657.5026115002 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | |||
| 79478 | 79478 | 22719 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401X Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | |||
| 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) | |||
| 80499 | 80499 | 108103 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2390X Green St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | |||||
| 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) | |||
| 80711 | 80711 | 120139 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 10X Grove St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007842.0 | 2111812.0 | 37.779076168386105 | -122.41644540073798 | (37.7790761683861, -122.416445400738) | ||||
| 81359 | 81359 | 112751 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 135X TRENTON ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | Private 3 | 3x3 | 6009947.0 | 2118097.0 | 37.796451422722605 | -122.409607037418 | (37.7964514227226, -122.409607037418) | |||
| 82122 | 82122 | 100107 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 461 Jefferson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007004.8 | 2122229.7 | 37.807633464576796 | -122.420081138169 | (37.8076334645768, -122.420081138169) | |||||
| 82860 | 82860 | 106525 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2510 Jackson St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 772624 | 6002049.7 | 2116744.4 | 37.7922918429251 | -122.436836472971 | (37.7922918429251, -122.436836472971) | ||||
| 83223 | 83223 | 113004 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 700x STANYAN ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997124.0 | 2108268.0 | 37.768736698354004 | -122.453267191941 | (37.768736698354, -122.453267191941) | ||||
| 83793 | 83793 | 95035 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | ||||
| 83805 | 83805 | 24453 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1384 Valencia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6006362.58284 | 2101545.07315 | 37.750802300176396 | -122.42083421458901 | (37.7508023001764, -122.420834214589) | |||
| 84356 | 84356 | 115059 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 499X BRANNAN ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013762.0 | 2111312.0 | 37.7780344196247 | -122.39593052209601 | (37.7780344196247, -122.395930522096) | ||||
| 86525 | 86525 | 105658 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 901X Lombard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 6007813.035080001 | 2120272.8882299997 | 37.8023060594642 | -122.417145293832 | (37.8023060594642, -122.417145293832) | ||||
| 87212 | 87212 | 111213 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3100x 19TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008781.0 | 2105093.0 | 37.7606801217813 | -122.412721875792 | (37.7606801217813, -122.412721875792) | |||
| 87430 | 87430 | 17324 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 99X Otis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006684.0755900005 | 2109163.0616900004 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | |||
| 88006 | 88006 | 100265 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 40 Federal St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 24 | 3x3 | 6014922.0 | 2113400.9 | 37.7838345339316 | -122.39206375347099 | (37.7838345339316, -122.392063753471) | |||
| 91993 | 91993 | 20162 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1150X Steiner St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4X4 | 6002889.1141449995 | 2112192.1807580004 | 37.779840274990796 | -122.433606604391 | (37.7798402749908, -122.433606604391) | |||
| 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) | |||
| 92991 | 92991 | 21583 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1499 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005557.61202 | 2114792.21407 | 37.7871303723087 | -122.42456008266599 | (37.7871303723087, -122.424560082666) | |||
| 93063 | 93063 | 51761 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 379 Tehama St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | 8 | Permit Number 48028 | 6011451.43524212 | 2112543.5849209 | 37.781287248695996 | -122.404010328515 | (37.781287248696, -122.404010328515) | ||
| 93474 | 93474 | 108328 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 86 11TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007396.0 | 2110315.0 | 37.77494067377889 | -122.417882154347 | (37.7749406737789, -122.417882154347) | ||||
| 94413 | 94413 | 6131 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 900X ELLIS ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4x4 | 6006542.0 | 2113585.0 | 37.7838712020833 | -122.42106856035299 | (37.7838712020833, -122.421068560353) | |||
| 94440 | 94440 | 96410 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3828 Jackson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 767718 | 5995910.0 | 2115869.0 | 37.7895373746493 | -122.458016450618 | (37.7895373746493, -122.458016450618) | ||||
| 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) | |||
| 94745 | 94745 | 649 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3244X 24th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007408.30918 | 2102098.45375 | 37.752380644434204 | -122.41725719966401 | (37.7523806444342, -122.417257199664) | |||
| 96816 | 96816 | 120943 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 485 Carolina St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012395.0 | 2105853.0 | 37.762969092752705 | -122.400275979648 | (37.7629690927527, -122.400275979648) | ||||
| 96843 | 96843 | 94302 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1150X Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Rec/Park 7 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | ||||
| 97704 | 97704 | 15109 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 110 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6014295.34515 | 2116528.26215 | 37.792386735981104 | -122.3944508141 | (37.7923867359811, -122.3944508141) | |||
| 99280 | 99280 | 101762 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 45X 11th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6007389.6 | 2110351.2 | 37.7750397101602 | -122.41790686002899 | (37.7750397101602, -122.417906860029) | |||
| 99845 | 99845 | 7272 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1761 Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003036.706730001 | 2114326.9794400004 | 37.78571026818 | -122.433248599687 | (37.78571026818, -122.433248599687) | |||
| 100271 | 100271 | 115747 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X POND ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | Rec/Park 7 | 16 | 3x3 | 6003250.0 | 2106477.0 | 37.764168263011996 | -122.43194992880301 | (37.764168263012, -122.431949928803) | ||
| 101271 | 101271 | 17294 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 5X Otis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6007138.45925 | 2109591.54151 | 37.7729397321212 | -122.41872172813801 | (37.7729397321212, -122.418721728138) | |||
| 104418 | 104418 | 117343 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 372 HAYES ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | 6006019.0 | 2111114.0 | 37.77705694338779 | -122.422702290381 | (37.7770569433878, -122.422702290381) | ||||
| 104562 | 104562 | 110727 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3514 25TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006378.0 | 2101471.0 | 37.7505997812246 | -122.42077564246901 | (37.7505997812246, -122.420775642469) | ||||
| 105416 | 105416 | 94220 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1X Tehama St | 5 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | Permit Number 53568 | 6013910.7 | 2114841.3 | 37.7877333404996 | -122.395663455814 | (37.7877333404996, -122.395663455814) | ||||
| 105575 | 105575 | 97938 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2133 Stockton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009831.3 | 2121360.2 | 37.8054048804892 | -122.41023789601299 | (37.8054048804892, -122.410237896013) | ||||
| 107557 | 107557 | 669 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3297X 24th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6007079.62061 | 2102029.84762 | 37.752173770171794 | -122.418388996947 | (37.7521737701718, -122.418388996947) | |||
| 107772 | 107772 | 120148 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X Hyde St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008026.0 | 2111839.0 | 37.77916064960021 | -122.41581078056299 | (37.7791606496002, -122.415810780563) | ||||
| 109566 | 109566 | 114285 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 200X STEUART ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015060.0 | 2116254.0 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | ||||
| 111519 | 111519 | 109004 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 525x BURNETT AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1x1 | 5999530.0 | 2102478.0 | 37.7529764040195 | -122.44452886107901 | (37.7529764040195, -122.444528861079) | ||||
| 112191 | 112191 | 25272 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1800 Ocean Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 5994503.82801 | 2092400.8361900002 | 37.725018937185 | -122.461179802839 | (37.725018937185, -122.461179802839) | |||
| 113942 | 113942 | 49294 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Spear St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371.0 | 2116872.0 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | |||
| 115513 | 115513 | 15253 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1450X Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007637.140459999 | 2110148.71 | 37.7744976489686 | -122.417036210851 | (37.7744976489686, -122.417036210851) | |||
| 116458 | 116458 | 22700 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1390 Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6003367.49805 | 2112454.4444 | 37.7805875170515 | -122.43197039694701 | (37.7805875170515, -122.431970396947) | |||
| 118018 | 118018 | 50375 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2727 Pierce St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47038 | 6001577.22511674 | 2117761.13132823 | 37.795056658547395 | -122.43854412401001 | (37.7950566585474, -122.43854412401) | ||||
| 118687 | 118687 | 116511 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1500x Waller St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998488.0 | 2108327.0 | 37.7689767823615 | -122.448553488995 | (37.7689767823615, -122.448553488995) | ||||
| 118761 | 118761 | 101719 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 560 Wisconsin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012536.0 | 2104936.0 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | |||||
| 119173 | 119173 | 21690 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1881 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6003627.3299403 | 2114521.0871369 | 37.7862767266181 | -122.43121907289499 | (37.7862767266181, -122.431219072895) | |||
| 119949 | 119949 | 103632 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1450X Stevenson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.768764440650294 | -122.42141735000799 | (37.7687644406503, -122.421417350008) | ||
| 119985 | 119985 | 120532 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1390 Waller St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999052.33988667 | 2108383.59508746 | 37.7691644298026 | -122.446605553634 | (37.7691644298026, -122.446605553634) | ||||
| 120064 | 120064 | 8766 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3360 Geary Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | |||
| 122646 | 122646 | 112407 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 300x 15TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011264.0 | 2107649.0 | 37.7678373720049 | -122.404314158491 | (37.7678373720049, -122.404314158491) | ||||
| 124798 | 124798 | 112110 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 699x COLUMBUS AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6009471.0 | 2119722.0 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | |||
| 124862 | 124862 | 15261 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1500 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6007445.07805 | 2110006.6589099998 | 37.7740968045009 | -122.417690522857 | (37.7740968045009, -122.417690522857) | |||
| 126619 | 126619 | 26946 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2040 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x6 | 6002793.58315 | 2114456.84816 | 37.78605305963129 | -122.434099024105 | (37.7860530596313, -122.434099024105) | |||
| 126912 | 126912 | 17368 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2308X Gough St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6005067.325209999 | 2117488.78546 | 37.794506778582 | -122.426448444628 | (37.794506778582, -122.426448444628) | |||
| 127624 | 127624 | 18698 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 251X Richardson Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 100 | 5999064.164064 | 2119841.396854 | 37.8006252370733 | -122.44738946108299 | (37.8006252370733, -122.447389461083) | |||
| 127950 | 127950 | 4729 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1075 Columbus Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6008196.257 | 2120907.2939400002 | 37.8040695291651 | -122.41586410452 | (37.8040695291651, -122.41586410452) | |||
| 128896 | 128896 | 115908 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 500x WALLER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2016 12:00:00 AM | 3 | 4x4 | 6003255.0 | 2109006.0 | 37.7711125644946 | -122.43211324892799 | (37.7711125644946, -122.432113248928) | ||
| 129076 | 129076 | 87146 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2405 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50131 | 6008226.0 | 2104427.0 | 37.7588202724984 | -122.414594246502 | (37.7588202724984, -122.414594246502) | ||
| 138959 | 138959 | 111211 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 601X 09TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010680.0 | 2108566.0 | 37.7703225929477 | -122.406398777104 | (37.7703225929477, -122.406398777104) | ||||
| 139052 | 139052 | 100710 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 220X 01st St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902.0 | 2115015.0 | 37.7882097965006 | -122.39570573165199 | (37.7882097965006, -122.395705731652) | ||
| 139920 | 139920 | 111392 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 298x CLINTON PARK | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004911.0 | 2108307.0 | 37.7692870280045 | -122.42633530742799 | (37.7692870280045, -122.426335307428) | ||||
| 140397 | 140397 | 111594 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 398X BRYANT ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014483.0 | 2113360.0 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | ||||
| 140600 | 140600 | 113574 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 901 LOMBARD ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6007968.0 | 2120121.0 | 37.8018977290678 | -122.41659827224701 | (37.8018977290678, -122.416598272247) | |||
| 141370 | 141370 | 110986 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 142235 | 142235 | 99616 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3233X Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003300.0 | 2119605.0 | 37.800217292537106 | -122.432714848025 | (37.8002172925371, -122.432714848025) | |||
| 144334 | 144334 | 111222 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3150x 19TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008324.0 | 2105048.0 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) |
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");