Street_Tree_List

Data source: data.sfgov.org

1,501 rows where qSpecies = 62

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
223 23789 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1100X Webster St 4 Median : Cutout 11 Tree 1 DPW 2     20 20   6003791.7059 2112684.1999 37.7812424081927 -122.43051925893299 (37.7812424081927, -122.430519258933)
327 191528 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 201 16th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/04/2017 12:00:00 AM 3 Width 5ft   6016052.47786 2107208.19392 37.76689343092 -122.38772046693501 (37.76689343092, -122.387720466935)
403 65940 Planning Code 138.1 required 4 Liquidambar styraciflua :: American Sweet Gum 62 620 Eddy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/1990 12:00:00 AM 8   Permit Number 28961 6007431.46715 2113367.23378 37.78332336932171 -122.41797588370702 (37.7833233693217, -122.417975883707)
551 1664 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1400X Fell St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6000454.8566 2109968.1462 37.7735952220186 -122.441868082855 (37.7735952220186, -122.441868082855)
890 23729 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 800X Webster St 4 Median : Cutout 11 Tree 1 DPW 2   04/21/2008 12:00:00 AM 3 6   6003943.6522 2111620.2321 37.7783296231018 -122.42991768322901 (37.7783296231018, -122.429917683229)
1144 38281 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 660 Mississippi St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/03/2017 12:00:00 AM 3   Permit Number 40367 6014095.62624 2104027.41968 37.7580511292617 -122.39426623192101 (37.7580511292617, -122.394266231921)
1457 248600 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 840 Stanyan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/10/1979 12:00:00 AM 12 Width 0ft Permit Number 17869 5997201.7532 2107543.996 37.7667532252023 -122.452945984051 (37.7667532252023, -122.452945984051)
1473 23922 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1700X Webster St 4 Median : Cutout 11 Tree 1 DPW 2   04/21/2008 12:00:00 AM 3 12x1   6003506.5026 2114704.4246 37.786773277055204 -122.431650198179 (37.7867732770552, -122.431650198179)
1513 251580 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 788 Harrison St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6012749.64869 2112405.5203400003 37.78098060211779 -122.39950942241998 (37.7809806021178, -122.39950942242)
1529 251578 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1000X Columbus Ave 6 Median : Cutout 11 Tree 1 DPW 2                    
1594 4731 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1175X Columbus Ave 2 Median : Cutout 11 Tree 1 DPW 2     14 3x3   6007886.219880001 2121257.05551 37.8050124513131 -122.416961809043 (37.8050124513131, -122.416961809043)
1597 4669 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 600X Columbus Ave 4 Median : Cutout 11 Tree 1 DPW 2   06/25/2014 12:00:00 AM 8 3 Permit Number 769286 6009537.0943 2119751.1708 37.8009703907309 -122.411142309711 (37.8009703907309, -122.411142309711)
1722 23787 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1100X Webster St 2 Median : Cutout 11 Tree 1 DPW 2   04/21/2008 12:00:00 AM 3 20   6003801.3315 2112607.883 37.781033406276705 -122.430480512141 (37.7810334062767, -122.430480512141)
1851 4718 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1000X Columbus Ave 5 Median : Cutout 11 Tree 1 DPW 2     80 3   6008205.1504 2120957.4944 37.804207866952204 -122.415836885075 (37.8042078669522, -122.415836885075)
1958 23757 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 900X Webster St 3 Median : Cutout 11 Tree 1 DPW 2     25 20   6003900.3372 2111922.0621 37.7791559204238 -122.43008906318701 (37.7791559204238, -122.430089063187)
2139 23790 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1100X Webster St 5 Median : Cutout 11 Tree 1 DPW 2     20 20   6003786.8931 2112715.8268 37.7813289751352 -122.43053816621901 (37.7813289751352, -122.430538166219)
2178 18161 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 1450 Post St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 4X4   6005286.1585 2114461.6714 37.7862074506483 -122.425475720608 (37.7862074506483, -122.425475720608)
2284 23758 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 900X Webster St 4 Median : Cutout 11 Tree 1 DPW 2     25 20   6003894.1493 2111953.6889 37.7792424093118 -122.43011272647199 (37.7792424093118, -122.430112726472)
2297 23709 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 700X Webster St 4 Median : Cutout 11 Tree 1 DPW 2     16 20   6003970.4427 2111382.6873 37.7776789009548 -122.429808057223 (37.7776789009548, -122.429808057223)
2568 227812 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 79 Piedmont St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 3x15   5999345.2069 2106945.6167 37.765232827359 -122.44548913263701 (37.765232827359, -122.445489132637)
2858 110567 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 201 08th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3 Permit Number 779053 6009356.33336 2110648.62955 37.77596687089571 -122.411124487731 (37.7759668708957, -122.411124487731)
2906 140272 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 2040 Hayes St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10   08/11/2017 12:00:00 AM 3 Width 0ft   5998087.0735 2109979.7192 37.7734917934815 -122.450059397698 (37.7734917934815, -122.450059397698)
2907 140271 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 2040 Hayes St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/11/2017 12:00:00 AM 3 Width 0ft   5998106.0231 2109982.4655 37.773500418432704 -122.44999404654301 (37.7735004184327, -122.449994046543)
2911 140276 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 2040 Hayes St 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10   08/11/2017 12:00:00 AM 3 Width 0ft   5998008.2541 2109969.0086 37.773457874403704 -122.450331271992 (37.7734578744037, -122.450331271992)
2912 140274 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 2040 Hayes St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10   08/11/2017 12:00:00 AM 3 Width 0ft   5998046.1533 2109973.9519 37.7734736163349 -122.45020053018699 (37.7734736163349, -122.450200530187)
2913 140273 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 2040 Hayes St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10   08/11/2017 12:00:00 AM 3 Width 0ft   5998068.9478 2109976.9729 37.773483215641 -122.450121898862 (37.773483215641, -122.450121898862)
2922 140275 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 2040 Hayes St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10   08/11/2017 12:00:00 AM 3 Width 0ft   5998028.0276 2109971.4803 37.773465792675 -122.450263051124 (37.773465792675, -122.450263051124)
2924 140269 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 2040 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6 08/11/2017 12:00:00 AM 3 Width 0ft   5998144.7463 2109987.1343 37.7735154534297 -122.449860434482 (37.7735154534297, -122.449860434482)
2926 140270 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 2040 Hayes St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10   08/11/2017 12:00:00 AM 3 Width 0ft   5998125.7967 2109984.6626 37.773507582533604 -122.44992580546001 (37.7735075825336, -122.44992580546)
3073 227974 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 200X 29th St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/02/2006 12:00:00 AM 5 Width 3ft Permit Number 49086 6005213.325 2099049.95145 37.7438864239343 -122.424630982854 (37.7438864239343, -122.424630982854)
3076 227975 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 200X 29th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/02/2006 12:00:00 AM 4 Width 3ft Permit Number 49086 6005200.1380900005 2099049.18147 37.7438835649874 -122.424676525409 (37.7438835649874, -122.424676525409)
3079 227980 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 200 29th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/02/2006 12:00:00 AM 7 Width 3ft Permit Number 49086 6005100.30377 2099043.7406 37.7438629866828 -122.425021342566 (37.7438629866828, -122.425021342566)
3085 227978 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 200 29th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/02/2006 12:00:00 AM 5 Width 3ft Permit Number 49086 6005155.75456 2099046.13918 37.7438727047738 -122.42482977709601 (37.7438727047738, -122.424829777096)
3086 227976 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 200 29th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/02/2006 12:00:00 AM 5 Width 3ft Permit Number 49086 6005186.74242 2099048.41612 37.7438807069453 -122.424722790133 (37.7438807069453, -122.424722790133)
3092 227977 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 200 29th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/02/2006 12:00:00 AM 4 Width 3ft Permit Number 49086 6005172.09288 2099047.67656 37.7438778488792 -122.424773392283 (37.7438778488792, -122.424773392283)
3098 227979 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 200 29th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/02/2006 12:00:00 AM 6 Width 3ft Permit Number 49086 6005126.89466 2099045.69197 37.7438698467248 -122.424929536192 (37.7438698467248, -122.424929536192)
3502 35369 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 628 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/16/2005 12:00:00 AM 8 5x9 Permit Number 780712 6010944.29074 2105222.09895 37.76115577964 -122.40524908009199 (37.76115577964, -122.405249080092)
3829 4634 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 500X Columbus Ave 1 Median : Cutout 11 Tree 1 DPW 2   08/19/2006 12:00:00 AM 8 3   6010031.5482 2119295.5915 37.799747198685004 -122.40939911161502 (37.799747198685, -122.409399111615)
3859 23825 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1200X Webster St 4 Median : Cutout 11 Tree 1 DPW 2     30 20   6003756.6414 2112968.1539 37.782020088596504 -122.43066083333599 (37.7820200885965, -122.430660833336)
3885 227809 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 930 Ashbury St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/21/1979 12:00:00 AM 9 Width 3ft Permit Number 17590 5999239.85444 2106888.20822 37.765069183133 -122.445849391156 (37.765069183133, -122.445849391156)
3886 227724 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 937 Ashbury St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/23/2001 12:00:00 AM 18 Width 4ft Permit Number 17591 5999190.5409699995 2106890.47379 37.7650725879622 -122.446020116632 (37.7650725879622, -122.446020116632)
3893 227810 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 974 Ashbury St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/1979 12:00:00 AM 11 Width 3ft Permit Number 18080 5999262.93769 2106710.24786 37.7645818665711 -122.44575675288401 (37.7645818665711, -122.445756752884)
4082 18163 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 1450 Post St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 4X4   6005210.3387 2114450.1336 37.7861714865556 -122.425737215933 (37.7861714865556, -122.425737215933)
5076 227766 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 65 Homestead St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4x4   6000997.83471 2101277.8848900003 37.749764821811 -122.439366802634 (37.749764821811, -122.439366802634)
5117 23827 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1200X Webster St 6 Median : Cutout 11 Tree 1 DPW 2     20 20   6003747.0158 2113043.0957 37.7822253147353 -122.430699482992 (37.7822253147353, -122.430699482992)
5279 23791 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1100X Webster St 6 Median : Cutout 11 Tree 1 DPW 2     3 20   6003783.4554 2112735.7654 37.7813835268154 -122.430551482109 (37.7813835268154, -122.430551482109)
5299 4716 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1000X Columbus Ave 3 Median : Cutout 11 Tree 1 DPW 2     70 3   6008306.8566 2120868.0824 37.803968081269204 -122.415478587922 (37.8039680812692, -122.415478587922)
5524 4635 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 500X Columbus Ave 2 Median : Cutout 11 Tree 1 DPW 2   01/05/1990 12:00:00 AM 35 3   6010009.8735 2119314.4873 37.7997978674726 -122.409475448708 (37.7997978674726, -122.409475448708)
5646 4679 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 700X Columbus Ave 6 Median : Cutout 11 Tree 1 DPW 2   08/19/2006 12:00:00 AM 6 3x3   6009212.7257 2120043.2180000003 37.801754083871295 -122.412285420728 (37.8017540838713, -122.412285420728)
5701 35451 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
5713 18162 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 1450 Post St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 4X4   6005249.8968 2114455.0784 37.7861872990315 -122.425600707285 (37.7861872990315, -122.425600707285)
5830 4674 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 700X Columbus Ave 1 Median : Cutout 11 Tree 1 DPW 2   09/05/1991 12:00:00 AM 15 3x4   6009400.8826 2119872.8379 37.8012968187356 -122.411622263241 (37.8012968187356, -122.411622263241)
5880 97919 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 333 Baker St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6000669.5517 2110132.6697 37.7740591934476 -122.44113722827299 (37.7740591934476, -122.441137228273)
5899 18165 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 1450 Post St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 4X4   6005168.5828 2114444.09 37.786152532687105 -122.42588125009199 (37.7861525326871, -122.425881250092)
5931 22784 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1880 Turk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6001016.5841 2112130.2222 37.7795637284835 -122.440080052813 (37.7795637284835, -122.440080052813)
5968 18166 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 1450 Post St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 4X4   6005153.199 2114441.8923 37.786145628959204 -122.42593431751101 (37.7861456289592, -122.425934317511)
6075 23828 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1200X Webster St 7 Median : Cutout 11 Tree 1 DPW 2     20 20   6003742.203 2113074.035 37.78230999365589 -122.430718341656 (37.7823099936559, -122.430718341656)
6099 4714 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1000X Columbus Ave 1 Median : Cutout 11 Tree 1 DPW 2     80 3   6008373.9156 2120808.2881 37.8038076701269 -122.415242289828 (37.8038076701269, -122.415242289828)
6262 23731 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 800X Webster St 6 Median : Cutout 11 Tree 1 DPW 2     6 20   6003929.9014 2111682.7982 37.7785006353915 -122.429969716521 (37.7785006353915, -122.429969716521)
6297 4668 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 600X Columbus Ave 3 Median : Cutout 11 Tree 1 DPW 2     60 3   6009590.6555 2119701.3035 37.8008364710267 -122.41095344028601 (37.8008364710267, -122.410953440286)
6310 35452 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
6323 18167 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 1450 Post St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6005136.7165 2114437.497 37.7861326290509 -122.425991029638 (37.7861326290509, -122.425991029638)
6383 4717 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1000X Columbus Ave 4 Median : Cutout 11 Tree 1 DPW 2   08/19/2006 12:00:00 AM 6 3   6008242.0329 2120925.0825 37.804120945419 -122.415706953629 (37.804120945419, -122.415706953629)
6398 23727 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 800X Webster St 2 Median : Cutout 11 Tree 1 DPW 2   04/21/2008 12:00:00 AM 3 6   6003949.8401 2111575.542 37.7782072655707 -122.429893088415 (37.7782072655707, -122.429893088415)
6547 1660 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1400X Fell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6000641.8596 2109991.603 37.7736702824704 -122.441222896356 (37.7736702824704, -122.441222896356)
6589 4667 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 600X Columbus Ave 2 Median : Cutout 11 Tree 1 DPW 2   10/03/2012 12:00:00 AM 12 3 Permit Number 769286 6009690.8519 2119608.7257 37.80058789320879 -122.410600176031 (37.8005878932088, -122.410600176031)
6800 23823 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1200X Webster St 2 Median : Cutout 11 Tree 1 DPW 2     20 20   6003765.5794 2112902.15 37.781839364726 -122.430625200646 (37.781839364726, -122.430625200646)
6803 19590 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 100 STAIRWAY4 13 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 60            
6949 23761 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 900X Webster St 7 Median : Cutout 11 Tree 1 DPW 2     25 20   6003883.1487 2112042.3815 37.7794853141392 -122.430157111124 (37.7794853141392, -122.430157111124)
7054 4734 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1100X Columbus Ave 5 Median : Cutout 11 Tree 1 DPW 2     60 3x3   6007950.0877 2121194.0464 37.80484303663339 -122.416736319981 (37.8048430366334, -122.416736319981)
7107 4638 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 500X Columbus Ave 5 Median : Cutout 11 Tree 1 DPW 2     60 3   6009905.4204 2119408.7236 37.8000507639755 -122.40984355245001 (37.8000507639755, -122.40984355245)
7156 13002 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 359 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/23/1995 12:00:00 AM 8 3X3   6010611.1408 2120633.1017 37.8034521300977 -122.40748784681101 (37.8034521300977, -122.407487846811)
7162 23924 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1700X Webster St 6 Median : Cutout 11 Tree 1 DPW 2     20 12x1   6003487.1069 2114786.6255 37.7869978805436 -122.43172317383998 (37.7869978805436, -122.43172317384)
7231 19588 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 100 STAIRWAY4 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 60            
7311 23920 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1700X Webster St 2 Median : Cutout 11 Tree 1 DPW 2     20 12x12   6003521.972999999 2114612.7568 37.786522457310205 -122.43159012740699 (37.7865224573102, -122.431590127407)
7325 23732 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 800X Webster St 7 Median : Cutout 11 Tree 1 DPW 2     12 20   6003928.5263 2111708.2372 37.7785704067109 -122.429976288631 (37.7785704067109, -122.429976288631)
7357 97916 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 333 Baker St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6000651.9591 2110235.6191 37.77434086442889 -122.441205471863 (37.7743408644289, -122.441205471863)
7386 23826 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1200X Webster St 5 Median : Cutout 11 Tree 1 DPW 2     20 20   6003751.8286 2113008.0312 37.78212930904171 -122.43068032991002 (37.7821293090417, -122.43068032991)
7407 19591 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 100 STAIRWAY4 14 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 60            
7438 23859 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1400X Webster St 4 Median : Cutout 11 Tree 1 DPW 2     25 3X3   6003649.3852 2113669.4444 37.783939579713504 -122.431081960003 (37.7839395797135, -122.431081960003)
7449 97915 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 333 Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6000647.534 2110270.503 37.7744363947481 -122.441223282456 (37.7744363947481, -122.441223282456)
7488 35443 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
7577 4636 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 500X Columbus Ave 3 Median : Cutout 11 Tree 1 DPW 2     45 3   6009974.2224 2119345.7236 37.7998816370329 -122.409601021151 (37.7998816370329, -122.409601021151)
7642 23788 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1100X Webster St 3 Median : Cutout 11 Tree 1 DPW 2     20 20   6003799.2688 2112646.3852 37.7811390068769 -122.43049039607 (37.7811390068769, -122.43049039607)
7649 4666 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 600X Columbus Ave 1 Median : Cutout 11 Tree 1 DPW 2   10/03/2012 12:00:00 AM 60 3 Permit Number 769286 6009738.4106 2119565.7843 37.8004726529456 -122.41043256902 (37.8004726529456, -122.41043256902)
7655 4730 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1175X Columbus Ave 1 Median : Cutout 11 Tree 1 DPW 2     100 3x3   6007911.57425 2121225.41132 37.8049269905411 -122.41687182377 (37.8049269905411, -122.41687182377)
7802 35460 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
7804 1666 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1400X Fell St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6000356.4682 2109956.4177 37.7735574116821 -122.44220758007401 (37.7735574116821, -122.442207580074)
7873 28650 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1600X Webster St 12 Median : Cutout 11 Tree 1 DPW 2     8 6   6003539.955 2114426.6147 37.786012377283896 -122.431514620567 (37.7860123772839, -122.431514620567)
7913 97918 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 333 Baker St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6000663.0359 2110165.9002 37.7741500648743 -122.44116215214198 (37.7741500648743, -122.441162152142)
7946 4639 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 500X Columbus Ave 6 Median : Cutout 11 Tree 1 DPW 2     75 3   6009873.723999999 2119435.9713 37.8001238030697 -122.40995515916201 (37.8001238030697, -122.409955159162)
8006 23900 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1600X Webster St 3 Median : Cutout 11 Tree 1 DPW 2     20 6   6003566.3311 2114312.7691 37.7857012808729 -122.43141523648701 (37.7857012808729, -122.431415236487)
8146 35450 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
8177 4676 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 700X Columbus Ave 3 Median : Cutout 11 Tree 1 DPW 2     24 3x4   6009334.3928 2119933.7869 37.8014604396574 -122.411856657471 (37.8014604396574, -122.411856657471)
8325 23708 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 700X Webster St 3 Median : Cutout 11 Tree 1 DPW 2     20     6003978.3577 2111349.4443 37.77758807209621 -122.429778304865 (37.7775880720962, -122.429778304865)
8339 37971 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 620 Peninsula Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/1998 12:00:00 AM     Permit Number 40201          
8454 4715 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1000X Columbus Ave 2 Median : Cutout 11 Tree 1 DPW 2   08/19/2006 12:00:00 AM 6 3   6008330.3273 2120843.4941 37.803901887177204 -122.415395624015 (37.8039018871772, -122.415395624015)
8468 18164 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 1450 Post St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6005185.0654 2114447.3865 37.78616251551679 -122.42582445934299 (37.7861625155168, -122.425824459343)
8475 23759 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 900X Webster St 5 Median : Cutout 11 Tree 1 DPW 2     25 20   6003889.3366 2111985.3157 37.7793289760816 -122.430131632423 (37.7793289760816, -122.430131632423)
8492 1663 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1400X Fell St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6000501.7702 2109972.7072 37.773610418483 -122.44170612948601 (37.773610418483, -122.441706129486)

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 450.782ms · Data source: data.sfgov.org