Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 167061 | 167061 | 41356 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Walnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/2000 12:00:00 AM | 15 | Permit Number 42006 | 5998501.11002 | 2116122.08079 | 37.7903807999818 | -122.44906976535201 | (37.7903807999818, -122.449069765352) | |
| 64869 | 64869 | 33267 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | Permit Number 37441 | 6009551.65503934 | 2116448.08509162 | 37.7919017434497 | -122.41085850563101 | (37.7919017434497, -122.410858505631) | ||
| 82376 | 82376 | 33268 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | Permit Number 37441 | 6009551.65503934 | 2116448.08509162 | 37.7919017434497 | -122.41085850563101 | (37.7919017434497, -122.410858505631) | ||
| 90043 | 90043 | 33272 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | Permit Number 37441 | 6009551.65503934 | 2116448.08509162 | 37.7919017434497 | -122.41085850563101 | (37.7919017434497, -122.410858505631) | ||
| 93520 | 93520 | 33271 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | Permit Number 37441 | 6009551.65503934 | 2116448.08509162 | 37.7919017434497 | -122.41085850563101 | (37.7919017434497, -122.410858505631) | ||
| 125379 | 125379 | 33269 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | Permit Number 37441 | 6009551.65503934 | 2116448.08509162 | 37.7919017434497 | -122.41085850563101 | (37.7919017434497, -122.410858505631) | ||
| 143952 | 143952 | 33270 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | Permit Number 37441 | 6009551.65503934 | 2116448.08509162 | 37.7919017434497 | -122.41085850563101 | (37.7919017434497, -122.410858505631) | ||
| 163627 | 163627 | 33266 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 California St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 16 | Permit Number 37441 | 6009282.50963 | 2116419.10375 | 37.791807072592604 | -122.411787704436 | (37.7918070725926, -122.411787704436) | |
| 184503 | 184503 | 40226 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 101 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 24 | Permit Number 41410 | 6014364.45427 | 2112502.79122 | 37.7813375610326 | -122.39392977934799 | (37.7813375610326, -122.393929779348) | |
| 98804 | 98804 | 51672 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1010 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/11/2005 12:00:00 AM | Permit Number 47951 | 6005673.1639935 | 2113141.53894822 | 37.782604551431206 | -122.42404286741501 | (37.7826045514312, -122.424042867415) | ||
| 160953 | 160953 | 31488 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1014 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 16 | Permit Number 35052 | 6003120.510980001 | 2102286.73127 | 37.7526554461029 | -122.43209853943 | (37.7526554461029, -122.43209853943) | |
| 65223 | 65223 | 61281 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1050 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/1983 12:00:00 AM | 11 | Permit Number 21173 | 6008008.8902 | 2118937.24196 | 37.7986497253514 | -122.416372878117 | (37.7986497253514, -122.416372878117) | |
| 69866 | 69866 | 66493 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1050 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 18 | Permit Number 29654 | 6010144.597630001 | 2111670.83243 | 37.7788177748451 | -122.40846978437901 | (37.7788177748451, -122.408469784379) | |
| 31598 | 31598 | 32719 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1059 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 15 | Permit Number 37112 | 6008120.91675 | 2116143.25856 | 37.7909844366445 | -122.415787285469 | (37.7909844366445, -122.415787285469) | |
| 187482 | 187482 | 32718 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1059 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 13 | Permit Number 37112 | 6008124.13541 | 2116125.0175900003 | 37.790934532354605 | -122.415774856832 | (37.7909345323546, -122.415774856832) | |
| 119189 | 119189 | 61852 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1111 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32348 | 6010289.45166146 | 2102742.39978594 | 37.7543104490633 | -122.407339083447 | (37.7543104490633, -122.407339083447) | ||
| 11773 | 11773 | 109059 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1126 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772776 | 6001371.73977 | 2087888.1678900002 | 37.7130210113759 | -122.437115282467 | (37.7130210113759, -122.437115282467) |
| 178404 | 178404 | 71238 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1215 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1982 12:00:00 AM | 4 | 6001314.2765 | 2112604.1281 | 37.7808818966461 | -122.439084183551 | (37.7808818966461, -122.439084183551) | ||
| 166283 | 166283 | 70678 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1237 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 8 | 6009493.1189 | 2110090.7425 | 37.7744427137413 | -122.410611903339 | (37.7744427137413, -122.410611903339) | ||
| 99100 | 99100 | 65903 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1252 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/1990 12:00:00 AM | Permit Number 28911 | 5993641.91878652 | 2106971.45186237 | 37.7649765235495 | -122.46521716349702 | (37.7649765235495, -122.465217163497) | ||
| 9951 | 9951 | 55414 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1291 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 28931 | 5994529.13136199 | 2106735.38069373 | 37.7643794565111 | -122.46213141846201 | (37.7643794565111, -122.462131418462) |
| 9954 | 9954 | 173752 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1291 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5994529.13136199 | 2106735.38069373 | 37.7643794565111 | -122.46213141846201 | (37.7643794565111, -122.462131418462) | |||
| 117805 | 117805 | 50199 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 137REVISED Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/2004 12:00:00 AM | Permit Number 46906 | 5999872.84856038 | 2108949.39506285 | 37.7707648080184 | -122.443808124031 | (37.7707648080184, -122.443808124031) | ||
| 28855 | 28855 | 31531 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1394 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 15 | Permit Number 35086 | 6011135.19156 | 2101876.96342 | 37.751981450105205 | -122.40435337421499 | (37.7519814501052, -122.404353374215) | |
| 80421 | 80421 | 31535 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1394 San Bruno Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35086 | 6011138.71993424 | 2101856.99163788 | 37.751926809144294 | -122.404339766926 | (37.7519268091443, -122.404339766926) | ||
| 80483 | 80483 | 31534 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1394 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35086 | 6011138.71993424 | 2101856.99163788 | 37.751926809144294 | -122.404339766926 | (37.7519268091443, -122.404339766926) | ||
| 104213 | 104213 | 31533 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1394 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35086 | 6011138.71993424 | 2101856.99163788 | 37.751926809144294 | -122.404339766926 | (37.7519268091443, -122.404339766926) | ||
| 109882 | 109882 | 31532 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1394 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35086 | 6011138.71993424 | 2101856.99163788 | 37.751926809144294 | -122.404339766926 | (37.7519268091443, -122.404339766926) | ||
| 31829 | 31829 | 41777 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1436 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | 7 | Permit Number 42190 | 6006741.3221 | 2115908.4236 | 37.7902619855897 | -122.42054396081001 | (37.7902619855897, -122.42054396081) | |
| 179039 | 179039 | 41776 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1436 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | 9 | Permit Number 42190 | 6006751.1479 | 2115848.4661 | 37.7900979108814 | -122.420505706434 | (37.7900979108814, -122.420505706434) | |
| 16729 | 16729 | 39527 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 6 | Permit Number 40969 | 6012771.09866 | 2106608.38258 | 37.765064170309 | -122.399028197904 | (37.765064170309, -122.399028197904) | |
| 125807 | 125807 | 39528 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 17th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40969 | 6012854.83375701 | 2106613.68395322 | 37.765083392480605 | -122.398738948997 | (37.7650833924806, -122.398738948997) | ||
| 114398 | 114398 | 46946 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 153 Vasquez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | Permit Number 44985 | 5994958.35938136 | 2099473.23283552 | 37.7444641515166 | -122.46012068892401 | (37.7444641515166, -122.460120688924) | ||
| 127994 | 127994 | 46947 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 153 Vasquez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | Permit Number 44985 | 5994958.35938136 | 2099473.23283552 | 37.7444641515166 | -122.46012068892401 | (37.7444641515166, -122.460120688924) | ||
| 103609 | 103609 | 39626 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 1550 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 775173 | 5997915.23661319 | 2105333.02481713 | 37.7607233191374 | -122.45031878213301 | (37.7607233191374, -122.450318782133) | ||
| 79207 | 79207 | 33520 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 156 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45090 | 6007339.22789751 | 2098166.57654537 | 37.741580707379796 | -122.417217500399 | (37.7415807073798, -122.417217500399) | ||
| 100124 | 100124 | 33521 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 158 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45091 | 6007330.47035939 | 2098150.25569742 | 37.7415354012679 | -122.417246624804 | (37.7415354012679, -122.417246624804) | ||
| 129508 | 129508 | 32801 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1640 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 7 | Permit Number 37163 | 5999986.448 | 2110250.0303 | 37.7743425023806 | -122.443508626239 | (37.7743425023806, -122.443508626239) | |
| 151972 | 151972 | 32802 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1640 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 10 | Permit Number 37163 | 5999966.1178 | 2110245.6106 | 37.7743292075557 | -122.443578634389 | (37.7743292075557, -122.443578634389) | |
| 59199 | 59199 | 42278 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1646 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/2003 12:00:00 AM | 5 | Permit Number 46652 | 5986569.425 | 2104035.4361 | 37.756504646339394 | -122.489462910282 | (37.7565046463394, -122.489462910282) | |
| 32729 | 32729 | 32786 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1659 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 7 | Permit Number 37153 | 5999840.0614 | 2110872.9364 | 37.7760444944885 | -122.444059770227 | (37.7760444944885, -122.444059770227) | |
| 135911 | 135911 | 70116 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1659 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 14 | 6006256.51205 | 2117265.43085 | 37.793960654804295 | -122.422317826729 | (37.7939606548043, -122.422317826729) | ||
| 79953 | 79953 | 32787 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1661 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37153 | 5999823.76126907 | 2110867.52212558 | 37.7760286983996 | -122.444115767373 | (37.7760286983996, -122.444115767373) | ||
| 20654 | 20654 | 49903 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1686 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | Permit Number 46673 | 6006217.29915575 | 2107312.14837083 | 37.7666291551697 | -122.42174620348499 | (37.7666291551697, -122.421746203485) | ||
| 118831 | 118831 | 49904 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1686 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | Permit Number 46673 | 6006217.29915575 | 2107312.14837083 | 37.7666291551697 | -122.42174620348499 | (37.7666291551697, -122.421746203485) | ||
| 123842 | 123842 | 49905 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1686 15th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | Permit Number 46673 | 6006217.29915575 | 2107312.14837083 | 37.7666291551697 | -122.42174620348499 | (37.7666291551697, -122.421746203485) | ||
| 139513 | 139513 | 49902 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1686 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | Permit Number 46673 | 6006217.29915575 | 2107312.14837083 | 37.7666291551697 | -122.42174620348499 | (37.7666291551697, -122.421746203485) | ||
| 86890 | 86890 | 32789 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1704 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37155 | 5999594.67382686 | 2110888.19372737 | 37.776072385759605 | -122.44490972486601 | (37.7760723857596, -122.444909724866) | ||
| 100875 | 100875 | 32792 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1704 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37155 | 5999594.67382686 | 2110888.19372737 | 37.776072385759605 | -122.44490972486601 | (37.7760723857596, -122.444909724866) | ||
| 113776 | 113776 | 32791 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1704 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37155 | 5999594.67382686 | 2110888.19372737 | 37.776072385759605 | -122.44490972486601 | (37.7760723857596, -122.444909724866) | ||
| 186673 | 186673 | 78599 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1721 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 6 | 6012838.148159999 | 2104697.96448 | 37.7598223206635 | -122.39866221248501 | (37.7598223206635, -122.398662212485) | ||
| 116752 | 116752 | 68518 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1722 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32398 | 5993753.19333564 | 2103765.68848708 | 37.756180747574 | -122.46459949821501 | (37.756180747574, -122.464599498215) | ||
| 78228 | 78228 | 40596 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1745 Alameda St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 81050 | 81050 | 40589 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1745 Alameda St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 106855 | 106855 | 40577 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1745 Alameda St | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 125811 | 125811 | 40580 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1745 Alameda St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 144875 | 144875 | 40597 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1745 Alameda St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 139207 | 139207 | 41135 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1790 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1999 12:00:00 AM | Permit Number 41874 | 5998011.03341214 | 2108932.61643319 | 37.770612366717 | -122.450246938029 | (37.770612366717, -122.450246938029) | ||
| 66925 | 66925 | 42593 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1800 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 18 | Permit Number 42666 | 6004942.09948 | 2117812.91349 | 37.7953896721531 | -122.42690483678601 | (37.7953896721531, -122.426904836786) | |
| 133520 | 133520 | 42594 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1800 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 12 | Permit Number 42666 | 6004954.56344 | 2117817.05919 | 37.795401759928104 | -122.42686200478799 | (37.7954017599281, -122.426862004788) | |
| 115443 | 115443 | 61147 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1917 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1983 12:00:00 AM | Permit Number 21003 | 5998690.60672318 | 2110015.33456804 | 37.7736241011269 | -122.4479742617 | (37.7736241011269, -122.4479742617) | ||
| 102047 | 102047 | 59315 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1946 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1995 12:00:00 AM | Permit Number 18657 | 6006124.32662698 | 2117096.5455304002 | 37.793489480872296 | -122.42276319431299 | (37.7934894808723, -122.422763194313) | ||
| 92292 | 92292 | 39627 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 6 | Permit Number 775173 | 5997915.23661319 | 2105333.02481713 | 37.7607233191374 | -122.45031878213301 | (37.7607233191374, -122.450318782133) | |
| 104147 | 104147 | 39629 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X Carmel St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 6 | Permit Number 775173 | 5997915.23661319 | 2105333.02481713 | 37.7607233191374 | -122.45031878213301 | (37.7607233191374, -122.450318782133) | |
| 122002 | 122002 | 39628 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X Carmel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 5 | Permit Number 775173 | 5997915.23661319 | 2105333.02481713 | 37.7607233191374 | -122.45031878213301 | (37.7607233191374, -122.450318782133) | |
| 32852 | 32852 | 76301 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 Townsend St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1996 12:00:00 AM | 13 | 6015739.497330001 | 2112628.79912 | 37.781759872771104 | -122.389181562198 | (37.7817598727711, -122.389181562198) | ||
| 55851 | 55851 | 41124 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2001 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1999 12:00:00 AM | 4 | Permit Number 41867 | 5998124.9728 | 2110290.0537 | 37.7743460607123 | -122.449950669655 | (37.7743460607123, -122.449950669655) | |
| 62618 | 62618 | 41126 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2001 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1999 12:00:00 AM | 8 | Permit Number 41867 | 5998172.4841 | 2110296.3702 | 37.7743661226249 | -122.449786775294 | (37.7743661226249, -122.449786775294) | |
| 181529 | 181529 | 41125 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2001 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1999 12:00:00 AM | 5 | Permit Number 41867 | 5998149.1404 | 2110293.0746 | 37.774355738139704 | -122.44986728758002 | (37.7743557381397, -122.44986728758) | |
| 118163 | 118163 | 32010 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2002 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1995 12:00:00 AM | Permit Number 35405 | 6003915.74450462 | 2115298.16977388 | 37.7884267396179 | -122.43027669406 | (37.7884267396179, -122.43027669406) | ||
| 94470 | 94470 | 36935 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 201 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39575 | 6000638.31499457 | 2102274.13435128 | 37.7524798164389 | -122.44068148430401 | (37.7524798164389, -122.440681484304) | ||
| 171578 | 171578 | 48783 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 201 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/2005 12:00:00 AM | 6 | Permit Number 46038 | 6008763.21846 | 2113151.61883 | 37.782806204271395 | -122.413353282927 | (37.7828062042714, -122.413353282927) | |
| 82880 | 82880 | 112265 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 201X WALNUT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5998535.0 | 2115724.0 | 37.7892897137264 | -122.448923821633 | (37.7892897137264, -122.448923821633) | |||
| 84597 | 84597 | 112264 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 201X WALNUT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5998535.0 | 2115724.0 | 37.7892897137264 | -122.448923821633 | (37.7892897137264, -122.448923821633) | |||
| 112337 | 112337 | 112261 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 201X WALNUT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5998535.0 | 2115724.0 | 37.7892897137264 | -122.448923821633 | (37.7892897137264, -122.448923821633) | |||
| 127809 | 127809 | 112263 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 201X WALNUT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5998535.0 | 2115724.0 | 37.7892897137264 | -122.448923821633 | (37.7892897137264, -122.448923821633) | |||
| 25406 | 25406 | 39287 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 80592 | 80592 | 39276 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 90944 | 90944 | 39285 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 93235 | 93235 | 39279 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 103088 | 103088 | 39281 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 103269 | 103269 | 39283 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 104913 | 104913 | 39282 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 111712 | 111712 | 39291 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 122352 | 122352 | 39280 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 127563 | 127563 | 39288 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 140371 | 140371 | 39307 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 142155 | 142155 | 39289 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 143495 | 143495 | 39290 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 10666 | 10666 | 108381 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 204 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773815 | 6001936.176109999 | 2090655.40431 | 37.7206512958141 | -122.435362229505 | (37.7206512958141, -122.435362229505) |
| 80185 | 80185 | 30706 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 21 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34616 | 6005672.1323567005 | 2109287.22209736 | 37.772021477067 | -122.423772292692 | (37.772021477067, -122.423772292692) | ||
| 69363 | 69363 | 43798 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 212 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 8 | Permit Number 43428 | 5988712.94158 | 2113878.39359 | 37.783655595659106 | -122.482771266201 | (37.7836555956591, -122.482771266201) | |
| 22289 | 22289 | 68675 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 225 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | 10 | Permit Number 32584 | 5992727.99284 | 2113946.56215 | 37.784075552459605 | -122.468885802919 | (37.7840755524596, -122.468885802919) | |
| 63267 | 63267 | 30983 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2351 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 6 | Permit Number 34770 | 6004127.32192 | 2116907.85743 | 37.792858515854704 | -122.42965952047199 | (37.7928585158547, -122.429659520472) | |
| 177495 | 177495 | 73449 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 238 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 5 | 6004263.46084 | 2092033.9823200002 | 37.724568462935295 | -122.427415688595 | (37.7245684629353, -122.427415688595) | ||
| 84151 | 84151 | 65357 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2390 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1989 12:00:00 AM | Permit Number 28192 | 6001831.05010454 | 2097061.25090734 | 37.738234317974 | -122.436183798503 | (37.738234317974, -122.436183798503) | ||
| 100738 | 100738 | 36733 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 25 Sycamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39512 | 6006708.40451425 | 2105838.69711633 | 37.7626110859988 | -122.419942981677 | (37.7626110859988, -122.419942981677) | ||
| 20639 | 20639 | 22907 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 250 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/2011 12:00:00 AM | 20 | 3x3 | Permit Number 767420 | 6006042.54291 | 2108252.09004 | 37.7692001550981 | -122.422417449121 | (37.7692001550981, -122.422417449121) |
| 83634 | 83634 | 64766 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 259 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1991 12:00:00 AM | Permit Number 29584 | 6006089.46258031 | 2096127.20012882 | 37.735910646189396 | -122.421393977694 | (37.7359106461894, -122.421393977694) | ||
| 38767 | 38767 | 52440 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2601 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | 10 | Permit Number 48551 | 6001622.27003 | 2116946.74485 | 37.792823127533296 | -122.43832988971201 | (37.7928231275333, -122.438329889712) |
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");