Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker
qLegalStatus ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
327 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) |
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");