Street_Tree_List

Data source: data.sfgov.org

6,952 rows where qSpecies = 26 sorted by qCaretaker

View and edit SQL

Suggested facets: qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker ▼ qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
54 121137 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 1388x Minna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/08/2016 12:00:00 AM 3 3x3            
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)
60 121139 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 1388x Minna St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/08/2016 12:00:00 AM 3 3x3            
70 121138 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 1388x Minna St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/08/2016 12:00:00 AM 3 3x3            
98 142074 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1384X GROVE ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6001183.1648 2110763.0502 37.7758193019084 -122.439405751925 (37.7758193019084, -122.439405751925)
102 98037 Private 5 Pittosporum undulatum :: Victorian Box 26 1384X Grove St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/23/2017 12:00:00 AM 3   Permit Number 767782 6001197.2582 2110764.9293 37.775825263482105 -122.439357134105 (37.7758252634821, -122.439357134105)
107 142075 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1384X GROVE ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   6001166.7226 2110758.8221 37.775806756879895 -122.439462326391 (37.7758067568799, -122.439462326391)
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 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)
347 250073 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 1599X Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083.0 2115238.0 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373)
373 250075 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 1599X Bush St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083.0 2115238.0 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373)
377 250072 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 1599X Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083.0 2115238.0 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373)
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 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)
415 250074 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 1599X Bush St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083.0 2115238.0 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373)
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)
452 221749 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 275 Grattan St 3 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1     24 Width 4ft   5997432.91763 2106413.5715 37.763662611962 -122.452064861225 (37.763662611962, -122.452064861225)
458 221750 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 275 Grattan St 2 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1     11 Width 4ft   5997409.41415 2106414.31665 37.7636633116224 -122.45214620578699 (37.7636633116224, -122.452146205787)
472 236059 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 601X 14th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6004719.95486 2107769.51353 37.7678004187701 -122.42695783742799 (37.7678004187701, -122.426957837428)
483 236058 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 601X 14th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6004683.7857099995 2107762.8709299997 37.767780134560205 -122.427082469082 (37.7677801345602, -122.427082469082)
491 236057 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 601X 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6004642.9908 2107763.18347 37.767778685763 -122.427223596101 (37.767778685763, -122.427223596101)
496 245474 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 275 Grattan St 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1     19 Width 4ft   5997377.53226 2106405.56262 37.7636374489232 -122.452255843041 (37.7636374489232, -122.452255843041)
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 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 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)
653 144739 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 510 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 3ft   5989096.969740001 2111833.32857 37.7780627562405 -122.481292881664 (37.7780627562405, -122.481292881664)
655 251353 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 510 22nd Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 3ft   5989096.969740001 2111833.32857 37.7780627562405 -122.481292881664 (37.7780627562405, -122.481292881664)
658 147406 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 515 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 6x10   5989054.53583 2111789.60329 37.7779402316839 -122.48143647103201 (37.7779402316839, -122.481436471032)
913 107355 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 2001 Grant Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 3x3   6010310.1611 2121354.7321 37.8054166971664 -122.40858034027201 (37.8054166971664, -122.408580340272)
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)
1000 133103 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 2401 Larkin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6006658.0 2119469.0 37.8000337406718 -122.42108517312599 (37.8000337406718, -122.421085173126)
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 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)
1096 211742 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 700 Junipero Serra Blvd 88 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   5991230.19236 2092152.91218 37.724149261961706 -122.472478226094 (37.7241492619617, -122.472478226094)
1159 112361 Significant Tree 6 Pittosporum undulatum :: Victorian Box 26 561X Folsom St 1 Front Yard : Yard 7 Tree 1 Private 1   11/16/2015 12:00:00 AM 3 10x30 Permit Number 775828 6013749.7362 2114198.9064599997 37.785960521430205 -122.396175324952 (37.7859605214302, -122.396175324952)
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 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 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 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 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 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 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 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 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 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 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 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 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)
1667 251648 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 2649 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6007031.0 2102934.0 37.7546536287073 -122.41862124555 (37.7546536287073, -122.41862124555)
1672 251649 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 2649 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6007031.0 2102934.0 37.7546536287073 -122.41862124555 (37.7546536287073, -122.41862124555)
1704 251429 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1345 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/30/2017 12:00:00 AM 3 3x3 Permit Number 779991 6003307.0 2100429.0 37.7475651236724 -122.43132102920099 (37.7475651236724, -122.431321029201)
1714 115408 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 889 North Point St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   6006526.39743 2121457.3012099997 37.8054856898732 -122.42168186931801 (37.8054856898732, -122.421681869318)
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 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 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 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)
2129 156905 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 3201x 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/2017 12:00:00 AM 3 3x6 Permit Number 777588 6007417.0 2106083.0 37.763321780718705 -122.417509514421 (37.7633217807187, -122.417509514421)
2133 252909 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 3201x 17th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/2017 12:00:00 AM 3 3x6 Permit Number 777588 6007417.0 2106083.0 37.763321780718705 -122.417509514421 (37.7633217807187, -122.417509514421)
2142 252906 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 600 South Van Ness Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/2017 12:00:00 AM 3 3x3 Permit Number 777588 6007451.05071 2106154.24093 37.7635193076139 -122.417396792879 (37.7635193076139, -122.417396792879)
2143 252905 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 600 South Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/2017 12:00:00 AM 3 3x3 Permit Number 777588 6007451.05071 2106154.24093 37.7635193076139 -122.417396792879 (37.7635193076139, -122.417396792879)
2147 252908 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 600 South Van Ness Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/2017 12:00:00 AM 3 3x3 Permit Number 777588 6007451.05071 2106154.24093 37.7635193076139 -122.417396792879 (37.7635193076139, -122.417396792879)
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 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 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 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 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 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)
2486 98136 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 3101 Scott St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 3x3   6000916.131030001 2119057.7300299997 37.798579149274 -122.440924663139 (37.798579149274, -122.440924663139)
2575 253126 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 182 London St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/19/2017 12:00:00 AM 3 3x3 Permit Number 779117 6002742.73008 2092646.2038099999 37.726163358663705 -122.432716365158 (37.7261633586637, -122.432716365158)
2584 178485 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 277 Edinburgh St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6003684.78158 2092034.78148 37.724537911193295 -122.429416163945 (37.7245379111933, -122.429416163945)
2600 143226 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1931 GRANT AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 0ft   6010322.1986 2121149.6678 37.804854315613 -122.408524208369 (37.804854315613, -122.408524208369)
2610 253145 Significant Tree 6 Pittosporum undulatum :: Victorian Box 26 801X Santiago St 1 Side Yard : Yard 17 Tree 1 Private 1           5990274.0 2099728.0 37.7448931297685 -122.47633667765699 (37.7448931297685, -122.476336677657)
2612 120193 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 400 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   5987807.29514 2113237.3235 37.7818426655183 -122.485857349295 (37.7818426655183, -122.485857349295)
2623 120194 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 400 26th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5987832.0 2113186.0 37.781703185313795 -122.485768115014 (37.7817031853138, -122.485768115014)
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 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 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 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 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 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)
2789 214105 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 252 Farallones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/05/2017 12:00:00 AM 3 3x3 Permit Number 779963 5994448.04607 2088422.67439 37.714092646244396 -122.46108441741801 (37.7140926462444, -122.461084417418)
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)
2812 206249 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 450 Irving St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5994303.087119999 2106698.53981 37.7642652836473 -122.46291056368601 (37.7642652836473, -122.462910563686)
2815 206250 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 450 Irving St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5994346.04433 2106700.69098 37.7642736644092 -122.462762144062 (37.7642736644092, -122.462762144062)
2889 102687 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 2155 Scott St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4x4   6001348.89021 2115903.63348 37.7899434614624 -122.43920099642901 (37.7899434614624, -122.439200996429)
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)
3003 139363 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1590 LYON ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/14/2017 12:00:00 AM 3 Width 0ft   5999671.8855 2114244.4195 37.7852921232377 -122.444883944489 (37.7852921232377, -122.444883944489)
3149 253338 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 324 Carl St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       6x10   5996595.0 2107026.0 37.7652961513923 -122.455007196131 (37.7652961513923, -122.455007196131)
3179 253343 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 200 Arguello Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x6 Permit Number 778434 5995550.1802199995 2114806.2223 37.786598594028504 -122.459184390305 (37.7865985940285, -122.459184390305)
3183 132950 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 2074 Jackson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 5ft   6004267.0 2117052.0 37.7932622027482 -122.42918651023999 (37.7932622027482, -122.42918651024)
3189 253342 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 200 Arguello Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x6 Permit Number 778434 5995550.1802199995 2114806.2223 37.786598594028504 -122.459184390305 (37.7865985940285, -122.459184390305)
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 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 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 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 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 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)
3367 102770 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1400 Filbert St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 4x4   6006139.52673 2119365.14566 37.799719342134296 -122.42287190623699 (37.7997193421343, -122.422871906237)
3377 194746 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 500 Hampshire St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6010050.23596 2105797.64874 37.7626860840206 -122.408381844163 (37.7626860840206, -122.408381844163)
3397 194745 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 500 Hampshire St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6010051.12155 2105827.11031 37.7627670283973 -122.40838085938499 (37.7627670283973, -122.408380859385)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 2853.838ms · Data source: data.sfgov.org