Data source: data.sfgov.org
This data as json, CSV (advanced)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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 | ||||||||
| 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 | ||||||||
| 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) | ||||
| 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 | ||||||||
| 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 | ||||||||
| 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) | ||
| 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 | ||||||||
| 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 | ||||||||
| 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) | |
| 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) | ||
| 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) | |||
| 21572 | 21572 | 2411 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2759 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1999 12:00:00 AM | 6 | 4X4 | 6009845.01424 | 2101254.8528 | 37.7502010910033 | -122.408771128311 | (37.7502010910033, -122.408771128311) | ||
| 21741 | 21741 | 2404 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2724 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6009770.26673 | 2101463.3127900003 | 37.750769288979605 | -122.409044318046 | (37.7507692889796, -122.409044318046) | |||
| 22993 | 22993 | 67532 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 209 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/1992 12:00:00 AM | 12 | Permit Number 31070 | 6014045.342569999 | 2106049.86131 | 37.7636015183281 | -122.39458175543899 | (37.7636015183281, -122.394581755439) | |
| 23901 | 23901 | 55472 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1265 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | 2 | Permit Number 24549 | 6001757.1677 | 2110793.9605 | 37.7759368233505 | -122.437422347525 | (37.7759368233505, -122.437422347525) | |
| 24480 | 24480 | 33644 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 491 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/1996 12:00:00 AM | 15 | Permit Number 37738 | 6005071.3427 | 2110746.7678 | 37.7759951015754 | -122.425954387251 | (37.7759951015754, -122.425954387251) | |
| 25396 | 25396 | 38266 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 660X Mississippi St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | 10 | Permit Number 40367 | 6014098.11933 | 2104009.06988 | 37.7580008832593 | -122.394256324976 | (37.7580008832593, -122.394256324976) | ||
| 29061 | 29061 | 95316 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2870@Divisadero Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2011 12:00:00 AM | 4 | 3x3 | Permit Number 54638 | 6000971.60034 | 2116251.73043 | 37.7908777689321 | -122.44053135994899 | (37.7908777689321, -122.440531359949) | |
| 29235 | 29235 | 33862 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 281 Clara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/1997 12:00:00 AM | 7 | Permit Number 37859 | 6011395.19215 | 2111355.67015 | 37.778022368579 | -122.404121275373 | (37.778022368579, -122.404121275373) | ||
| 30462 | 30462 | 58671 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 624 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1998 12:00:00 AM | 5 | Permit Number 17896 | 6014367.3263 | 2104224.98671 | 37.7586087044554 | -122.39334039516199 | (37.7586087044554, -122.393340395162) | |
| 31015 | 31015 | 59108 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 616 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 12 | Permit Number 18411 | 5993182.92211 | 2111277.08736 | 37.7767721716598 | -122.46711777381901 | (37.7767721716598, -122.467117773819) | ||
| 31143 | 31143 | 41824 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1540 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 3 | Permit Number 42210 | 6001764.9422 | 2111535.9598 | 37.7779746089121 | -122.43744859967501 | (37.7779746089121, -122.437448599675) | |
| 31533 | 31533 | 43679 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 540 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 6 | Permit Number 43322 | 5994712.920030001 | 2111843.24303 | 37.7784148808037 | -122.461866155284 | (37.7784148808037, -122.461866155284) | |
| 31555 | 31555 | 67316 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 746 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1992 12:00:00 AM | 6 | Permit Number 30797 | 5992906.05892 | 2110364.3272599997 | 37.7742499931706 | -122.468009109205 | (37.7742499931706, -122.468009109205) | |
| 31816 | 31816 | 37984 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 528 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 5 | Permit Number 40206 | 6013786.428309999 | 2104612.00312 | 37.759639076609396 | -122.39537653041401 | (37.7596390766094, -122.395376530414) | |
| 35374 | 35374 | 32812 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 421 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 10 | 5x5 | Permit Number 37171 | 6000142.4606 | 2110508.5779 | 37.7750613046635 | -122.442987522526 | (37.7750613046635, -122.442987522526) |
| 40292 | 40292 | 95320 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2870 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2011 12:00:00 AM | 4 | 3x3 | Permit Number 54638 | 6000942.23432 | 2116247.30101 | 37.790863934682 | -122.440632646973 | (37.790863934682, -122.440632646973) | |
| 41045 | 41045 | 48885 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 239 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | 3 | 3x3 | Permit Number 46091 | 6009414.4878 | 2110585.56643 | 37.7757969754933 | -122.410918860444 | (37.7757969754933, -122.410918860444) | |
| 41889 | 41889 | 101220 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 444 De Haro St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6012016.9208 | 2106179.0839 | 37.763843356795995 | -122.40160655331199 | (37.763843356796, -122.401606553312) | |||
| 42285 | 42285 | 33829 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1121 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1997 12:00:00 AM | 15 | Permit Number 37844 | 6015587.6013400005 | 2103776.1855900004 | 37.7574441129692 | -122.38908875844601 | (37.7574441129692, -122.389088758446) | ||
| 42659 | 42659 | 31690 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 720 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 6 | Permit Number 35194 | 5997967.7593 | 2107982.3411 | 37.7680006769011 | -122.45032811149599 | (37.7680006769011, -122.450328111496) | |
| 43341 | 43341 | 95321 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2870 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2011 12:00:00 AM | 4 | 3x3 | Permit Number 54638 | 6000921.95955 | 2116245.56207 | 37.7908580054302 | -122.44070267179899 | (37.7908580054302, -122.440702671799) | |
| 43843 | 43843 | 55312 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 392 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1972 12:00:00 AM | 6 | Permit Number 11241 | 6012672.97117 | 2112433.28595 | 37.7810525658564 | -122.399776639786 | (37.7810525658564, -122.399776639786) | ||
| 44079 | 44079 | 41678 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4 Mars St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42133 | 5999656.32726227 | 2105735.31763117 | 37.761927403993 | -122.444326061687 | (37.761927403993, -122.444326061687) |
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");