Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 56 | 56 | 27602 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 988 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4X4 | 6003218.3377 | 2111393.5053 | 37.7776659856505 | -122.432410615738 | (37.7776659856505, -122.432410615738) | |||
| 115 | 115 | 6964 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 700 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 6003997.6735 | 2110460.7643 | 37.7751490695403 | -122.42964808764499 | (37.7751490695403, -122.429648087645) | |||
| 322 | 322 | 7968 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1901 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/2007 12:00:00 AM | 3 | 3X3 | 6005627.24821 | 2116610.0246200003 | 37.7921255585096 | -122.42444850412 | (37.7921255585096, -122.42444850412) | ||
| 386 | 386 | 2602 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1760 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6005112.3923 | 2115130.7833 | 37.7880348455319 | -122.42612455857201 | (37.7880348455319, -122.426124558572) | |||
| 414 | 414 | 17191 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1804X Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4X4 | 6004806.1465 | 2115088.0891 | 37.7879003042654 | -122.427181073064 | (37.7879003042654, -122.427181073064) | |||
| 442 | 442 | 9602 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1355 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6003083.4108 | 2112017.0963 | 37.779370559175206 | -122.432921935155 | (37.7793705591752, -122.432921935155) | |||
| 510 | 510 | 7848 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 885 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6006120.7355 | 2113033.04101 | 37.7823319018231 | -122.422486748168 | (37.7823319018231, -122.422486748168) | |||
| 577 | 577 | 15499 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2704 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006991.0 | 2102555.0 | 37.7536107294676 | -122.41873270043001 | (37.7536107294676, -122.41873270043) | |||
| 615 | 615 | 2703 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2123 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/1987 12:00:00 AM | 12 | 3X3 | 6003147.2203 | 2114799.0941 | 37.7870128441602 | -122.432899995096 | (37.7870128441602, -122.432899995096) | ||
| 630 | 630 | 20157 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1100X Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 4X4 | 6002895.0285 | 2112125.5503 | 37.7796576600117 | -122.433581380876 | (37.7796576600117, -122.433581380876) | |||
| 992 | 992 | 7205 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 926 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2001 12:00:00 AM | 3 | 4X4 | 6003464.8493 | 2111545.8007 | 37.778098126187295 | -122.431568724094 | (37.7780981261873, -122.431568724094) | ||
| 1019 | 1019 | 5195 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 625 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2007 12:00:00 AM | 3 | 3X3 | 6001591.0229 | 2110593.2492 | 37.7753762735578 | -122.437982704394 | (37.7753762735578, -122.437982704394) | ||
| 1089 | 1089 | 9603 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1355 Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6003102.1679 | 2112019.7759 | 37.7793789805584 | -122.43285723801 | (37.7793789805584, -122.43285723801) | |||
| 1229 | 1229 | 235065 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2400 Diamond St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/1997 12:00:00 AM | 6 | Width 2ft | Permit Number 38465 | 6001951.69941 | 2097144.86437 | 37.7384707551305 | -122.43577263420299 | (37.7384707551305, -122.435772634203) | |
| 1255 | 1255 | 65778 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3101 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1990 12:00:00 AM | 5 | Permit Number 28743 | 6000913.14979 | 2119077.92932 | 37.7986344413927 | -122.440936428972 | (37.7986344413927, -122.440936428972) | |
| 1300 | 1300 | 14826 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1269 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6003119.6747 | 2111677.9775 | 37.7784414803533 | -122.432772251133 | (37.7784414803533, -122.432772251133) | |||
| 1314 | 1314 | 92967 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3022 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | 4x4 | Permit Number 779165 | 6000091.47375 | 2115801.73595 | 37.7895920459934 | -122.443544210206 | (37.7895920459934, -122.443544210206) | |
| 1328 | 1328 | 236115 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 410 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/1992 12:00:00 AM | 6 | Width 3ft | Permit Number 780066 | 6003708.0 | 2109045.0 | 37.771245321662896 | -122.4305490898 | (37.7712453216629, -122.4305490898) | |
| 1339 | 1339 | 66377 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 621 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | 12 | Permit Number 29502 | 6003558.1677 | 2110522.6128 | 37.775293994216 | -122.431172851087 | (37.775293994216, -122.431172851087) | |
| 1446 | 1446 | 139885 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1575 TURK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1990 12:00:00 AM | 6 | Width 0ft | 6002581.4123 | 2112293.0339 | 37.7800997287845 | -122.434678293337 | (37.7800997287845, -122.434678293337) | ||
| 1456 | 1456 | 139884 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1585 TURK ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1990 12:00:00 AM | 4 | Width 0ft | 6002525.5727 | 2112285.5886 | 37.7800761156462 | -122.43487093500299 | (37.7800761156462, -122.434870935003) | ||
| 1474 | 1474 | 139883 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1585 TURK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6002506.9595 | 2112283.5581 | 37.780069483595 | -122.434935181147 | (37.780069483595, -122.434935181147) | |||
| 1476 | 1476 | 139882 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1585 TURK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1990 12:00:00 AM | 14 | Width 0ft | 6002483.27 | 2112280.1738 | 37.780058846079605 | -122.435016891621 | (37.7800588460796, -122.435016891621) | ||
| 1481 | 1481 | 51149 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1600X North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47562 | 6003023.69355 | 2121013.0550700002 | 37.804067769267704 | -122.433771669621 | (37.8040677692677, -122.433771669621) | |
| 1572 | 1572 | 9622 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1404 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002793.2644 | 2112026.6959 | 37.7793804561129 | -122.433926358604 | (37.7793804561129, -122.433926358604) | |||
| 1589 | 1589 | 45715 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 475 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2017 12:00:00 AM | 3 | Permit Number 44386 | 6010097.78481 | 2106045.52558 | 37.7633693601423 | -122.40823487245301 | (37.7633693601423, -122.408234872453) | ||
| 1816 | 1816 | 20201 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1300X Steiner St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6002775.658 | 2112980.5073 | 37.7819983835402 | -122.43405546728 | (37.7819983835402, -122.43405546728) | ||
| 1910 | 1910 | 18873 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2299 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003870.98343 | 2115955.49438 | 37.790229051088 | -122.430478480014 | (37.790229051088, -122.430478480014) | |||
| 1931 | 1931 | 135812 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1147 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779607 | 6007418.27175 | 2119501.50723 | 37.800165825864205 | -122.418456642358 | (37.8001658258642, -122.418456642358) | |
| 1968 | 1968 | 251132 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 354 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 02/11/2006 12:00:00 AM | 3x3 | Permit Number 779305 | 6011875.0 | 2111882.0 | 37.779494345884295 | -122.402498458881 | (37.7794943458843, -122.402498458881) | |
| 2368 | 2368 | 68207 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2048 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 10 | Permit Number 31989 | 6009891.7858 | 2121179.0457 | 37.80491086613029 | -122.41001577934601 | (37.8049108661303, -122.410015779346) | |
| 2418 | 2418 | 235026 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 541 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/1991 12:00:00 AM | 7 | Width 3ft | Permit Number 29690 | 6001207.084969999 | 2103119.58489 | 37.7548335932981 | -122.43877516473499 | (37.7548335932981, -122.438775164735) | |
| 2428 | 2428 | 235022 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 571 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/1986 12:00:00 AM | 14 | Width 3ft | Permit Number 22679 | 6001215.76301 | 2102992.6268700003 | 37.7544854909317 | -122.43873605683399 | (37.7544854909317, -122.438736056834) | |
| 2432 | 2432 | 235024 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 553 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/1986 12:00:00 AM | 12 | Width 3ft | Permit Number 22676 | 6001208.88522 | 2103083.2214200003 | 37.754733850411 | -122.4387663334 | (37.754733850411, -122.4387663334) | |
| 2443 | 2443 | 235025 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 547 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/1986 12:00:00 AM | 12 | Width 3ft | Permit Number 22675 | 6001207.505890001 | 2103104.6823400003 | 37.754792698442294 | -122.43877264125099 | (37.7547926984423, -122.438772641251) | |
| 2450 | 2450 | 235023 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 559 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/1986 12:00:00 AM | 14 | Width 3ft | Permit Number 22677 | 6001213.00854 | 2103053.34864 | 37.7546520615499 | -122.438749933385 | (37.7546520615499, -122.438749933385) | |
| 2649 | 2649 | 97548 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2812 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6003949.4047300005 | 2118518.5197799997 | 37.7972709063909 | -122.43039009285299 | (37.7972709063909, -122.430390092853) | |||
| 2650 | 2650 | 253148 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 375 Naples St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2000 12:00:00 AM | 3x3 | Permit Number 43092 | 6003622.0 | 2091383.0 | 37.722744709081205 | -122.42958672889 | (37.7227447090812, -122.42958672889) | |||
| 2662 | 2662 | 22725 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1525 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1992 12:00:00 AM | 12 | 3X3 | 6002739.4553 | 2112318.0771 | 37.780177462084495 | -122.434133342281 | (37.7801774620845, -122.434133342281) | ||
| 2694 | 2694 | 6083 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1981 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4X4 | 6000965.1944 | 2112415.458 | 37.780343987670996 | -122.44027829238199 | (37.780343987671, -122.440278292382) | |||
| 2723 | 2723 | 18890 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2509 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/1990 12:00:00 AM | 12 | 3X3 | 6002664.991880001 | 2115784.46882 | 37.7896910685235 | -122.434638881376 | (37.7896910685235, -122.434638881376) | ||
| 2787 | 2787 | 247283 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 521 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/1999 12:00:00 AM | 5 | Width 0ft | Permit Number 41847 | 5998913.4577 | 2108893.2022 | 37.7705557475505 | -122.44712261725799 | (37.7705557475505, -122.447122617258) | |
| 2804 | 2804 | 5964 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1521X Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/1995 12:00:00 AM | 6 | 3X3 | 6003157.2632 | 2112724.1229 | 37.7813160659364 | -122.432716968768 | (37.7813160659364, -122.432716968768) | ||
| 2930 | 2930 | 246112 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1261 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1979 12:00:00 AM | 10 | Width 0ft | Permit Number 17674 | 5999700.0931 | 2108425.5315 | 37.7693165555408 | -122.44436803302901 | (37.7693165555408, -122.444368033029) | |
| 3192 | 3192 | 5265 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1245 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1992 12:00:00 AM | 6 | 3X3 | 6001286.0183 | 2112790.7677 | 37.781392753559 | -122.439195323402 | (37.781392753559, -122.439195323402) | ||
| 3210 | 3210 | 194747 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1580 Burke Ave | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6016181.61808 | 2099214.241 | 37.74495087589921 | -122.386716274933 | (37.7449508758992, -122.386716274933) | |||
| 3220 | 3220 | 5325 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2880X Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6001005.78593 | 2115601.06101 | 37.7890931461666 | -122.44036639549 | (37.7890931461666, -122.44036639549) | |||
| 3223 | 3223 | 8124 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 875 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/2005 12:00:00 AM | 3 | 3X3 | 6003614.3663 | 2111395.0391 | 37.777692645638794 | -122.431040728139 | (37.7776926456388, -122.431040728139) | ||
| 3304 | 3304 | 2735 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2261 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/2003 12:00:00 AM | 3 | 3x3 | 6002669.315 | 2114735.7471 | 37.786811791741 | -122.434548907064 | (37.786811791741, -122.434548907064) | ||
| 3340 | 3340 | 140461 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1410 TURK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/1991 12:00:00 AM | 7 | Width 0ft | 6003069.601 | 2112407.5024 | 37.780441733392 | -122.432997609121 | (37.780441733392, -122.432997609121) | ||
| 3417 | 3417 | 236135 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 44 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6006548.03614 | 2110351.8359 | 37.7749940580768 | -122.42081806330799 | (37.7749940580768, -122.420818063308) | |||
| 3429 | 3429 | 236137 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 44 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6006540.30314 | 2110387.22291 | 37.775090786432294 | -122.42084732634 | (37.7750907864323, -122.42084732634) | |||
| 3438 | 3438 | 2733 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2256 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002707.4731 | 2114797.1964 | 37.786982681927796 | -122.43442128422 | (37.7869826819278, -122.43442128422) | |||
| 3482 | 3482 | 19260 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1320 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4X4 | 6001795.5969 | 2113030.7934 | 37.7820807867545 | -122.43744962568 | (37.7820807867545, -122.43744962568) | |||
| 3509 | 3509 | 235175 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 410 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2000 12:00:00 AM | 7 | Width 3ft | Permit Number 43122 | 6001776.62521 | 2103418.64193 | 37.7556871173699 | -122.436826947206 | (37.7556871173699, -122.436826947206) | |
| 3522 | 3522 | 7953 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1745 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2008 12:00:00 AM | 6 | 3X3 | 6005687.08424 | 2116140.5409 | 37.790839852634605 | -122.424208065867 | (37.7908398526346, -122.424208065867) | ||
| 3558 | 3558 | 7824 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 807 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1992 12:00:00 AM | 3 | 4x4 | 6006129.00475 | 2112968.14036 | 37.7821541670221 | -122.42245352721001 | (37.7821541670221, -122.42245352721) | ||
| 3580 | 3580 | 7849 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 885 Franklin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1997 12:00:00 AM | 3 | 4X4 | 6006124.86369 | 2113018.24445 | 37.7822915069765 | -122.422471414725 | (37.7822915069765, -122.422471414725) | ||
| 3664 | 3664 | 18949 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2838 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001202.00999 | 2115627.7019 | 37.7891774657247 | -122.43968939755699 | (37.7891774657247, -122.439689397557) | |||
| 3720 | 3720 | 54865 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1845 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1972 12:00:00 AM | 14 | Permit Number 10724 | 5998997.2724 | 2110063.1394 | 37.77377288550579 | -122.44691690335199 | (37.7737728855058, -122.446916903352) | ||
| 3731 | 3731 | 15515 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2763 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007078.6273 | 2102287.5862 | 37.7528814055888 | -122.41841070542401 | (37.7528814055888, -122.418410705424) | |||
| 3746 | 3746 | 253553 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2763 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6007078.6273 | 2102287.5862 | 37.7528814055888 | -122.41841070542401 | (37.7528814055888, -122.418410705424) | ||||
| 3908 | 3908 | 5846 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 909X Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6006100.84256 | 2113204.14293 | 37.7828005835141 | -122.422567731241 | (37.7828005835141, -122.422567731241) | |||
| 4176 | 4176 | 9422 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 701X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/1999 12:00:00 AM | 3 | 3X3 | 6006084.9503 | 2112434.4577 | 37.7806863196559 | -122.422568001024 | (37.7806863196559, -122.422568001024) | ||
| 4360 | 4360 | 8196 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1310X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6001489.6126 | 2111152.0859 | 37.7769049310776 | -122.438373551392 | (37.7769049310776, -122.438373551392) | |||
| 4395 | 4395 | 7977 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2007 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6005570.41069 | 2117004.7305400004 | 37.793206111926395 | -122.424673253679 | (37.7932061119264, -122.424673253679) | |||
| 4544 | 4544 | 253638 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 859 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2017 12:00:00 AM | 3 | 3x3 | 6009440.103999999 | 2118743.01656 | 37.7981968084542 | -122.411406675592 | (37.7981968084542, -122.411406675592) | ||
| 4550 | 4550 | 236150 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 78 Harper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/1980 12:00:00 AM | 12 | Width 3ft | Permit Number 18226 | 6003583.9574 | 2097837.09588 | 37.7404640466695 | -122.430178448188 | (37.7404640466695, -122.430178448188) | |
| 4625 | 4625 | 19259 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1320 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4X4 | 6001796.9506 | 2113006.0886 | 37.782013030605995 | -122.437443172865 | (37.782013030606, -122.437443172865) | |||
| 4660 | 4660 | 49888 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1400 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52632 | 6006190.8899300005 | 2119372.26772 | 37.7997417954962 | -122.422694676831 | (37.7997417954962, -122.422694676831) | |
| 4689 | 4689 | 95648 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1681 Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6004869.27424 | 2119488.56695 | 37.799986470461 | -122.42727624513 | (37.799986470461, -122.42727624513) | |||
| 4794 | 4794 | 51151 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1600X North Point St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2004 12:00:00 AM | 10 | 3x3 | Permit Number 47562 | 6002985.024130001 | 2121008.8321700003 | 37.8040539799632 | -122.43390518569599 | (37.8040539799632, -122.433905185696) | |
| 4860 | 4860 | 14685 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 772 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4x4 | 6005444.6106 | 2112052.626 | 37.779601757581396 | -122.42475607462099 | (37.7796017575814, -122.424756074621) | |||
| 4908 | 4908 | 9754 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 725 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6005755.7491 | 2112191.3137 | 37.7800001281921 | -122.423689574884 | (37.7800001281921, -122.423689574884) | |||
| 4927 | 4927 | 5213 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 824 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2006 12:00:00 AM | 5 | 3x3 | 6001558.6916 | 2111280.8681 | 37.77726246348279 | -122.438143814078 | (37.7772624634828, -122.438143814078) | ||
| 5056 | 5056 | 14820 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1234 McAllister St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6003198.6113 | 2111732.1009 | 37.778594566288795 | -122.43250304678301 | (37.7785945662888, -122.432503046783) | |||
| 5173 | 5173 | 27601 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 988 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/09/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780706 | 6003246.4786 | 2111399.6963 | 37.7776845802664 | -122.432313709128 | (37.7776845802664, -122.432313709128) | |
| 5235 | 5235 | 18964 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2900X Sacramento St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000852.4357199995 | 2115585.85435 | 37.789042660041204 | -122.440895874969 | (37.7890426600412, -122.440895874969) | |||
| 5303 | 5303 | 22747 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1585 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1990 12:00:00 AM | 12 | 3X3 | 6002436.9062 | 2112273.4054 | 37.780037629076794 | -122.43517680048402 | (37.7800376290768, -122.435176800484) | ||
| 5337 | 5337 | 14719 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 871 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 5x5 | 6005011.2646 | 2111934.1612 | 37.779251997589 | -122.426246769427 | (37.779251997589, -122.426246769427) | |||
| 5390 | 5390 | 18848 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2171 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004428.43086 | 2116034.00345 | 37.7904761793675 | -122.428555351759 | (37.7904761793675, -122.428555351759) | |||
| 5403 | 5403 | 6081 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1973 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/1991 12:00:00 AM | 12 | 4x4 | 6000989.2223 | 2112419.519 | 37.780356506143704 | -122.440195460208 | (37.7803565061437, -122.440195460208) | ||
| 5477 | 5477 | 9600 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1355 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6003043.6637 | 2112009.9508 | 37.7793486849117 | -122.433058926269 | (37.7793486849117, -122.433058926269) | |||
| 5498 | 5498 | 9513 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1019 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004741.0809 | 2112246.9075 | 37.7800954464336 | -122.427203730317 | (37.7800954464336, -122.427203730317) | |||
| 5547 | 5547 | 94317 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 849 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2010 12:00:00 AM | 18 | 4x4 | Permit Number 53624 | 6008219.05473 | 2115433.26244 | 37.7890404773826 | -122.415397445557 | (37.7890404773826, -122.415397445557) | |
| 5563 | 5563 | 97055 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2209 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 769445 | 6002327.80211 | 2115857.41291 | 37.7898722063959 | -122.43581074387501 | (37.7898722063959, -122.435810743875) | ||
| 5620 | 5620 | 2650 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1950 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004171.8211 | 2114999.0511 | 37.7876199363476 | -122.429369370882 | (37.7876199363476, -122.429369370882) | |||
| 5655 | 5655 | 94548 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 240X Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5998348.9517 | 2109772.9137 | 37.7729389404069 | -122.44913862538999 | (37.7729389404069, -122.44913862539) | |||
| 5695 | 5695 | 7846 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 885 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1997 12:00:00 AM | 3 | 4X4 | 6006112.07352 | 2113078.8245099997 | 37.7824571234444 | -122.42251996911399 | (37.7824571234444, -122.422519969114) | ||
| 5708 | 5708 | 18895 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2540 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2015 12:00:00 AM | 3 | 4X4 | 6002597.10991 | 2115822.79128 | 37.789792438322394 | -122.434876487663 | (37.7897924383224, -122.434876487663) | ||
| 5729 | 5729 | 8055 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 612 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/1990 12:00:00 AM | 8 | 3X3 | 6004743.4186 | 2111609.3148 | 37.77834490608821 | -122.427150215382 | (37.7783449060882, -122.427150215382) | ||
| 5757 | 5757 | 19256 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1310 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6001797.9658 | 2112980.0301 | 37.7819415382953 | -122.437437794147 | (37.7819415382953, -122.437437794147) | |||
| 5764 | 5764 | 14639 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 600X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x4 | 6006195.22204 | 2112154.3058700003 | 37.7799233114376 | -122.42216660840799 | (37.7799233114376, -122.422166608408) | |||
| 5777 | 5777 | 18935 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2720 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2001 12:00:00 AM | 3 | 3x3 | 6001787.24752 | 2115709.65036 | 37.7894357680807 | -122.437670423159 | (37.7894357680807, -122.437670423159) | ||
| 5812 | 5812 | 95647 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1681 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004854.41136 | 2119486.713 | 37.7999805394326 | -122.427327544224 | (37.7999805394326, -122.427327544224) | |||
| 5840 | 5840 | 6055 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1901 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6001309.0309 | 2112458.7759 | 37.7804824979769 | -122.43909191015699 | (37.7804824979769, -122.439091910157) | |||
| 5876 | 5876 | 22641 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1232 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/1991 12:00:00 AM | 6 | 3X3 | 6004096.6073 | 2112557.2154 | 37.780911007880796 | -122.429455392073 | (37.7809110078808, -122.429455392073) | ||
| 5903 | 5903 | 2675 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2059 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6003660.5178 | 2114875.7424 | 37.787252401142794 | -122.43112957460501 | (37.7872524011428, -122.431129574605) | |||
| 5951 | 5951 | 9605 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1355 Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003143.7014 | 2112024.2419 | 37.7793935986621 | -122.432713875415 | (37.7793935986621, -122.432713875415) | |||
| 5988 | 5988 | 18962 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2900X Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6000861.89454 | 2115580.57647 | 37.789028707056495 | -122.44086277000099 | (37.7890287070565, -122.440862770001) |
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");