Street_Tree_List

Data source: data.sfgov.org

1,501 rows where qSpecies = 62 sorted by qCaretaker

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
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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          
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          
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)
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          
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          
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)
8797 35455 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
9106 2321 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 2287 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/20/1996 12:00:00 AM 10 3X3   6009681.0 2104027.0 37.7578035997437 -122.409533930525 (37.7578035997437, -122.409533930525)
9539 35456 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
9554 35448 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
9566 95785 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 347 21st St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/19/2011 12:00:00 AM   3x3 Permit Number 767529          
9594 35445 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
9611 138137 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 1790 Laguna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 0ft   6004447.4756 2114919.1759 37.7874162214119 -122.42840996490801 (37.7874162214119, -122.428409964908)
9681 2312 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 2237 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/16/1997 12:00:00 AM 10 3X3   6009676.496040001 2104323.4439 37.7586173154622 -122.409570429529 (37.7586173154622, -122.409570429529)
9703 173646 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 380 Sanchez St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6003542.0 2106028.0 37.7629519666094 -122.43090793911999 (37.7629519666094, -122.43090793912)
9948 114067 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 62 6 Higuera Ave 1 Front Yard : Cutout 8 Tree 1 Private 1     20     5987898.0 2090420.0 37.719197693995795 -122.48386996767 (37.7191976939958, -122.48386996767)
10029 94465 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 4128 17th St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 5x6 Permit Number 779215 6001502.0 2105859.0 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108)
10262 35446 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
10483 35442 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
10753 35454 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
11071 113042 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 62 500 Raymond Ave 1 Front Yard : Cutout 8 Tree 1 Private 1   10/06/2015 12:00:00 AM 30 3x3   6008233.879509999 2088473.9314700002 37.715017072864796 -122.413438766187 (37.7150170728648, -122.413438766187)
11139 35047 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 700 Peninsula Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/22/1998 12:00:00 AM     Permit Number 38613          
11629 35449 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
11928 105246 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 2439 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 6x6   5989501.8448 2098751.2622 37.7421664525595 -122.478935190185 (37.7421664525595, -122.478935190185)
12085 35458 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
12173 37972 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 624 Peninsula Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/1998 12:00:00 AM     Permit Number 40202          
12206 65603 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 131 Maynard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/06/1990 12:00:00 AM 15 3x3 Permit Number 28506 6004245.84033 2093781.6134799998 37.7293660735617 -122.427601053271 (37.7293660735617, -122.427601053271)
13622 28926 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 275 08th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/06/2008 12:00:00 AM 3 3x3   6009566.071769999 2110427.96033 37.775372724794394 -122.41038336002501 (37.7753727247944, -122.410383360025)
13963 100835 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 642 Natoma St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6009411.19134 2111256.02049 37.777637699760795 -122.41097762931999 (37.7776376997608, -122.41097762932)
14038 28925 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 275 08th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/11/2006 12:00:00 AM 3 3x3   6009577.301419999 2110415.03402 37.7753378616805 -122.410343600988 (37.7753378616805, -122.410343600988)
14243 105849 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 1025 Tennessee St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3 Permit Number 19016 6015551.36754 2104359.7286799997 37.7590443891103 -122.389254817379 (37.7590443891103, -122.389254817379)
14341 35444 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 17 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
14595 35457 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
14627 115035 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 788 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x3   6012851.17431 2112502.5973400003 37.781252811600794 -122.39916500906601 (37.7812528116008, -122.399165009066)
14635 15136 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 766 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/04/2008 12:00:00 AM 3 3x3   6011623.78991 2113963.56505 37.7851958099766 -122.40351399557699 (37.7851958099766, -122.403513995577)
14838 35048 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 700 Peninsula Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/22/1998 12:00:00 AM     Permit Number 38613          
15497 28927 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 267 08th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/11/2006 12:00:00 AM 3 3x3   6009498.76471 2110500.15224 37.775567173522894 -122.41062129096201 (37.7755671735229, -122.410621290962)
15544 37973 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 630 Peninsula Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/1998 12:00:00 AM     Permit Number 40203          
15638 121717 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 880 Pennsylvania Ave 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/22/2016 12:00:00 AM 3   Permit Number 779222 6014431.9321099995 2103065.57675 37.755428803314295 -122.39303583615101 (37.7554288033143, -122.393035836151)
15784 121716 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 880 Pennsylvania Ave 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/22/2016 12:00:00 AM 3 3x3 Permit Number 779222 6014431.75751 2103081.25316 37.7554718376765 -122.39303753677 (37.7554718376765, -122.39303753677)
16105 35453 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
16221 35459 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
16371 59613 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 1025 Tennessee St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/26/1981 12:00:00 AM 10 3x3 Permit Number 19016 6015555.95429 2104293.41546 37.7588625614652 -122.389234323603 (37.7588625614652, -122.389234323603)
16387 111703 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 1006 Tennessee St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 6x12   6015488.19364 2104440.58048 37.7592628883951 -122.389478950919 (37.7592628883951, -122.389478950919)
16501 100834 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 642 Natoma St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6009421.99762 2111264.1253 37.7776605596195 -122.410940819169 (37.7776605596195, -122.410940819169)
16736 121715 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 880 Pennsylvania Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/22/2016 12:00:00 AM 3   Permit Number 779222 6014429.69222 2103112.88568 37.7555585790683 -122.39304689240299 (37.7555585790683, -122.393046892403)
17025 35447 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 19 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
17261 2372 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 2527 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x3   6009769.958330001 2102611.45041 37.753921802157706 -122.40912639109699 (37.7539218021577, -122.409126391097)
17537 2317 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 2266 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6009618.58082 2104167.6101900004 37.758186185862606 -122.409759727848 (37.7581861858626, -122.409759727848)
17558 2327 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 2301 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 5X5   6009698.3897 2103901.33897 37.757459537241395 -122.409464921063 (37.7574595372414, -122.409464921063)
17562 4250 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 4047 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6003586.97779 2100377.2494099997 37.747438891704505 -122.43034919167201 (37.7474388917045, -122.430349191672)
17564 4458 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 1420 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/28/1994 12:00:00 AM 3 3X3   6004503.18681 2100562.9723099996 37.7480006990827 -122.427194227854 (37.7480006990827, -122.427194227854)
17638 2318 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 2270 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 5X5   6009620.42845 2104139.7744 37.7581098586044 -122.40975137312999 (37.7581098586044, -122.40975137313)
18250 2427 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 2884 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4X4   6009813.095380001 2100671.03054 37.7485962562324 -122.408840321235 (37.7485962562324, -122.408840321235)
18406 51586 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 5REVISED Buena Vista Ter 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/28/2005 12:00:00 AM     Permit Number 47879 6001458.32672553 2108232.67146529 37.7688871692043 -122.43827258221 (37.7688871692043, -122.43827258221)
18504 2406 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 2729 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6009835.509980001 2101434.53387 37.7506939230859 -122.408816669975 (37.7506939230859, -122.408816669975)
18551 2379 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 2565 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4X4   6009779.24964 2102431.71295 37.753428803702 -122.40908157785101 (37.753428803702, -122.409081577851)
18632 37326 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 517 Liberty St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/15/1998 12:00:00 AM     Permit Number 39837 6002947.90722614 2103845.15191447 37.756924711117 -122.432806753551 (37.756924711117, -122.432806753551)
18793 114373 Property Tree 7 Liquidambar styraciflua :: American Sweet Gum 62 805 GONZALEZ DR 1 Front Yard : Yard 7 Tree 1 Private 1     18     5988302.0 2089566.0 37.7168763353695 -122.482410970247 (37.7168763353695, -122.482410970247)
19144 2409 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 2743 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/30/1996 12:00:00 AM 8 3X3   6009838.5674 2101356.55662 37.7504799860819 -122.40880059638901 (37.7504799860819, -122.408800596389)
19304 2308 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 2205 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/16/1990 12:00:00 AM 26 5x5   6009667.68521 2104459.2052 37.7589895916184 -122.40961048355 (37.7589895916184, -122.40961048355)
19343 28266 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 702 Haight St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/04/2002 12:00:00 AM 12 3x3   6002735.2568 2109243.2194 37.7717344296193 -122.43392801598301 (37.7717344296193, -122.433928015983)
19477 2420 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 2825 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/18/1996 12:00:00 AM 12 3X3   6009867.3992099995 2100896.25477 37.74921771384761 -122.40866842482201 (37.7492177138476, -122.408668424822)
19596 2329 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 2309 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6009696.95759 2103872.6762900003 37.7573807557313 -122.409467851061 (37.7573807557313, -122.409467851061)
20430 2398 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 2700 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6009763.2742 2101575.57486 37.7510771440053 -122.409076419352 (37.7510771440053, -122.409076419352)
20689 2421 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 2834 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 3x3   6009805.25518 2100829.83171 37.7490318500391 -122.408878635061 (37.7490318500391, -122.408878635061)
21051 2331 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 2311 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6009700.99321 2103848.9649799997 37.7573158759309 -122.409452220849 (37.7573158759309, -122.409452220849)
21122 2423 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 2840 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3X3   6009807.43229 2100804.44049 37.748962253304 -122.408869315378 (37.748962253304, -122.408869315378)
21566 2377 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 2553 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6009776.86013 2102474.30381 37.7535456148439 -122.409092846361 (37.7535456148439, -122.409092846361)

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