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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 81710 | 81710 | 104892 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 Gonzalez Dr | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | ||||||
| 93582 | 93582 | 93724 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 415 Belvedere St | Front Yard : Yard 7 | Tree 1 | Private 1 | 5998488.0 | 2106798.0 | 37.7647785355325 | -122.44844336243601 | (37.7647785355325, -122.448443362436) | ||||||
| 104879 | 104879 | 94466 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4128 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 110021 | 110021 | 88360 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4969 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51338 | 5997573.8 | 2105584.6 | 37.761394534839894 | -122.451517798676 | (37.7613945348399, -122.451517798676) | |||
| 127747 | 127747 | 92232 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 654 Minnesota St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2007 12:00:00 AM | 3x3 | Permit Number 49975 | 6015152.0 | 2105524.0 | 37.762219079001795 | -122.390717392856 | (37.7622190790018, -122.390717392856) | |||
| 144608 | 144608 | 94467 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4128 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 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) | |
| 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) | |||
| 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) | ||
| 2924 | 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) | |
| 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) | |
| 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) |
| 3829 | 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) | ||
| 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) | |
| 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) | |||
| 5830 | 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) | ||
| 5931 | 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) | |||
| 6099 | 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) | |||
| 6547 | 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) | |||
| 7156 | 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) | ||
| 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) | |||
| 7649 | 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 | 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) | |||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||
| 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) | ||
| 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) | ||||
| 10217 | 10217 | 2412 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2770 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/18/1996 12:00:00 AM | 6 | 3X3 | 6009783.25197 | 2101219.12721 | 37.7500995368852 | -122.40898218658998 | (37.7500995368852, -122.40898218659) | ||
| 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) | ||
| 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) | |||
| 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) |
| 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) | ||
| 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 | ||||||||
| 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) | |||
| 16521 | 16521 | 19806 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 100 STAIRWAY23 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60ST | ||||||||
| 17242 | 17242 | 4298 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 4350 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001589.80492 | 2100313.4171 | 37.7471502929454 | -122.437250699681 | (37.7471502929454, -122.437250699681) | |||
| 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) | |||
| 17278 | 17278 | 2375 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2547 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009774.35605 | 2102523.0562 | 37.753679337750604 | -122.409104945855 | (37.7536793377506, -122.409104945855) | |||
| 17306 | 17306 | 2392 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2655 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009810.34614 | 2101884.53168 | 37.751928107698 | -122.408935435327 | (37.751928107698, -122.408935435327) | |||
| 17519 | 17519 | 2314 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2253 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009680.74998 | 2104241.2199 | 37.7583917852794 | -122.409549914219 | (37.7583917852794, -122.409549914219) | |||
| 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) | |||
| 17542 | 17542 | 2343 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2385 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 3X3 | 6009722.48016 | 2103476.08894 | 37.7562932460395 | -122.40935159661501 | (37.7562932460395, -122.409351596615) | |||
| 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) | |||
| 18300 | 18300 | 2394 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2661 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 7X6 | 6009814.716440001 | 2101845.61428 | 37.7518214939686 | -122.408917576591 | (37.7518214939686, -122.408917576591) | |||
| 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) | ||
| 18776 | 18776 | 2310 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2227 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009672.2386 | 2104377.81978 | 37.758766380788 | -122.409588991562 | (37.758766380788, -122.409588991562) | |||
| 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) | ||||
| 18937 | 18937 | 2410 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2753 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/04/2003 12:00:00 AM | 3 | 3x3 | 6009844.62689 | 2101286.4895200003 | 37.7502879367387 | -122.40877469949 | (37.7502879367387, -122.40877469949) | ||
| 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) | ||
| 19206 | 19206 | 2364 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2483 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009753.556480001 | 2102901.70574 | 37.754717859559996 | -122.40920359338499 | (37.75471785956, -122.409203593385) | |||
| 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) | |||
| 20167 | 20167 | 2332 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2318 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6X6 | 6009643.236190001 | 2103731.69198 | 37.7569906343237 | -122.409643691024 | (37.7569906343237, -122.409643691024) | |||
| 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) | |||
| 20543 | 20543 | 2353 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2413 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/03/2013 12:00:00 AM | 3 | 4X4 | 6009731.35926 | 2103287.7886799998 | 37.7557767132463 | -122.409307601761 | (37.7557767132463, -122.409307601761) | ||
| 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) | |||
| 20799 | 20799 | 2336 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2350 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6009647.84885 | 2103642.0545799998 | 37.7567447686625 | -122.40962141212201 | (37.7567447686625, -122.409621412122) | |||
| 20957 | 20957 | 4302 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 4378 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001457.95867 | 2100305.5079 | 37.747121080269295 | -122.437706046203 | (37.7471210802693, -122.437706046203) | |||
| 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) | |||
| 21060 | 21060 | 2380 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2566 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6009717.08187 | 2102390.53262 | 37.7533122488659 | -122.409293662278 | (37.7533122488659, -122.409293662278) | |||
| 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) | |||
| 21126 | 21126 | 2414 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2786 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009786.496590001 | 2101143.3199400003 | 37.749891568653496 | -122.408965618395 | (37.7498915686535, -122.408965618395) | |||
| 21137 | 21137 | 2330 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2312 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6009640.84961 | 2103785.73358 | 37.7571388866594 | -122.409655759023 | (37.7571388866594, -122.409655759023) | |||
| 21155 | 21155 | 2419 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2822 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009803.315230001 | 2100866.84766 | 37.7491333789981 | -122.408887954717 | (37.7491333789981, -122.408887954717) | |||
| 21192 | 21192 | 3896 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 60 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5X5 | 6002168.7084800005 | 2107927.71258 | 37.7680902055206 | -122.435793601904 | (37.7680902055206, -122.435793601904) | |||
| 21374 | 21374 | 2362 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2473 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009749.23862 | 2102948.41566 | 37.7548458726476 | -122.40922182173 | (37.7548458726476, -122.40922182173) | |||
| 21487 | 21487 | 2309 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2213 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009668.22468 | 2104416.43849 | 37.7588721941234 | -122.409605599315 | (37.7588721941234, -122.409605599315) | |||
| 21559 | 21559 | 19144 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 45 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6003508.29583 | 2108036.92775 | 37.768466086156394 | -122.431167909289 | (37.7684660861564, -122.431167909289) | |||
| 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) | |||
| 22571 | 22571 | 26752 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005515.49515 | 2114435.63395 | 37.7861489132884 | -122.424680422175 | (37.7861489132884, -122.424680422175) | |||
| 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) | |
| 23897 | 23897 | 248466 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 144 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5998292.5435 | 2107918.5956 | 37.7678442300261 | -122.449200130602 | (37.7678442300261, -122.449200130602) | |||
| 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) | |
| 24508 | 24508 | 138147 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1855 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000229.7014 | 2111271.7391 | 37.777161724967996 | -122.442740548891 | (37.777161724968, -122.442740548891) |
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");