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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) |
| 148399 | 148399 | 30516 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 375 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | 7 | Permit Number 42914 | 6008644.40916 | 2113485.04991 | 37.783715054661705 | -122.413787907302 | (37.7837150546617, -122.413787907302) | |
| 20152 | 20152 | 30589 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 530 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 24 | 6x12 | Permit Number 34559 | 6003171.8807 | 2110158.6701 | 37.7742727998886 | -122.43248310501801 | (37.7742727998886, -122.432483105018) |
| 17116 | 17116 | 30590 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 530 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/1995 12:00:00 AM | 12 | 6x9 | Permit Number 34559 | 6003172.5389 | 2110146.1627 | 37.77423849498221 | -122.43247993465401 | (37.7742384949822, -122.432479934654) |
| 65090 | 65090 | 30681 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 405 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 19 | 6x4 | Permit Number 34603 | 6004611.85495 | 2109916.0887 | 37.7736882811098 | -122.427484684578 | (37.7736882811098, -122.427484684578) |
| 52387 | 52387 | 30685 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 432 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 18 | Permit Number 34606 | 6004637.95796 | 2110084.33234 | 37.774151713473294 | -122.42740637791701 | (37.7741517134733, -122.427406377917) | |
| 71577 | 71577 | 30686 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 436 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 13 | Permit Number 34607 | 6004636.65186 | 2110109.9185 | 37.7742218929574 | -122.427412719037 | (37.7742218929574, -122.427412719037) | |
| 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) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 22259 | 22259 | 32095 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 8 Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/2016 12:00:00 AM | 3 | Permit Number 779125 | 6003421.63406 | 2105677.3546700003 | 37.761982358207796 | -122.431299212108 | (37.7619823582078, -122.431299212108) | |
| 58232 | 58232 | 32454 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 906X Page St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | 17 | Permit Number 38694 | 6002140.3718 | 2109505.7536 | 37.772421506399205 | -122.436004547249 | (37.7724215063992, -122.436004547249) | |
| 132866 | 132866 | 32609 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3200 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 7 | Permit Number 37075 | 5985785.2482 | 2106404.8747 | 37.762964658627 | -122.492349308745 | (37.762964658627, -122.492349308745) | |
| 65973 | 65973 | 32610 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3200 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 6 | Permit Number 37075 | 5985761.6347 | 2106405.465 | 37.762964898882295 | -122.49243102202699 | (37.7629648988823, -122.492431022027) | |
| 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) | |
| 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) | |
| 135465 | 135465 | 32767 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 921 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 10 | Permit Number 37273 | 6015272.11857 | 2104284.39215 | 37.758822046111 | -122.390215337371 | (37.758822046111, -122.390215337371) | |
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 91207 | 91207 | 32908 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 331 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37246 | 5994758.03281506 | 2107001.34896183 | 37.765122912865706 | -122.46135899992599 | (37.7651229128657, -122.461358999926) | ||
| 43913 | 43913 | 33138 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3018 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 10 | Permit Number 37365 | 6002001.0895 | 2118547.49342 | 37.797239905847505 | -122.437133821084 | (37.7972399058475, -122.437133821084) | |
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 51780 | 51780 | 35344 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 822 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 12 | Permit Number 39079 | 6013033.1221 | 2103220.47445 | 37.7557763166346 | -122.39788424585899 | (37.7557763166346, -122.397884245859) | |
| 112974 | 112974 | 35946 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 41 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | 14 | 3x3 | Permit Number 39108 | 6005372.49697946 | 2095946.00487356 | 37.735372674911794 | -122.423859934844 | (37.7353726749118, -122.423859934844) |
| 100641 | 100641 | 35962 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 719 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39119 | 6006179.07751464 | 2096674.29231523 | 37.7374178918343 | -122.421122977478 | (37.7374178918343, -122.421122977478) | ||
| 145847 | 145847 | 35963 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 725 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39120 | 6006183.36687276 | 2096689.94056482 | 37.737461100246 | -122.421109257926 | (37.737461100246, -122.421109257926) | ||
| 88650 | 88650 | 36681 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3440 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1998 12:00:00 AM | Permit Number 39482 | 6006586.56079834 | 2105563.12319804 | 37.7618475592216 | -122.42034483554701 | (37.7618475592216, -122.420344835547) | ||
| 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) | ||
| 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) | ||
| 110937 | 110937 | 36985 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4620 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39608 | 5993296.48645654 | 2114189.85752236 | 37.7847764030666 | -122.466936730196 | (37.7847764030666, -122.466936730196) | ||
| 36957 | 36957 | 37780 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 666 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | 11 | Permit Number 40115 | 6008939.41218 | 2093311.61708 | 37.72833993181921 | -122.411341689271 | (37.7283399318192, -122.411341689271) | |
| 60621 | 60621 | 37953 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 701 Minnesota St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 5 | Permit Number 40192 | 6015225.34484 | 2105197.25452 | 37.7613259754225 | -122.390440887348 | (37.7613259754225, -122.390440887348) | |
| 57944 | 57944 | 37954 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 701 Minnesota St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 9 | Permit Number 40192 | 6015220.22157 | 2105272.8031900004 | 37.761533131571 | -122.39046388570299 | (37.761533131571, -122.390463885703) | |
| 27621 | 27621 | 37955 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 701 Minnesota St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 6 | Permit Number 40192 | 6015222.376130001 | 2105229.81644 | 37.761415218749 | -122.390453430208 | (37.761415218749, -122.390453430208) | |
| 65453 | 65453 | 37956 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 701 Minnesota St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 7 | Permit Number 40192 | 6015227.23438 | 2105174.07156 | 37.761262424831 | -122.390432732284 | (37.761262424831, -122.390432732284) | |
| 174592 | 174592 | 37957 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 701 Minnesota St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 6 | Permit Number 40192 | 6015227.61132 | 2105153.8731400003 | 37.7612069852338 | -122.390430017258 | (37.7612069852338, -122.390430017258) | |
| 130760 | 130760 | 37958 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 701 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 7 | Permit Number 40528 | 6015227.3668599995 | 2105129.80279 | 37.7611408796801 | -122.39042918086399 | (37.7611408796801, -122.390429180864) | |
| 137073 | 137073 | 37959 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 701 Minnesota St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 8 | Permit Number 40192 | 6015221.8904099995 | 2105253.72993 | 37.7614808530901 | -122.390456781078 | (37.7614808530901, -122.390456781078) | |
| 169920 | 169920 | 37960 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 701 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 7 | Permit Number 40528 | 6015229.736819999 | 2105103.5126900002 | 37.7610688241989 | -122.39041914714501 | (37.7610688241989, -122.390419147145) | |
| 122264 | 122264 | 39273 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3001 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40884 | 6009003.87535313 | 2104948.94428491 | 37.7602970843939 | -122.411940867318 | (37.7602970843939, -122.411940867318) | ||
| 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) |
| 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) |
| 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) |
| 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) |
| 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) |
| 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) |
| 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) |
| 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) |
| 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) |
| 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) |
| 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) |
| 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) |
| 103260 | 103260 | 39309 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 399X Treat Ave | 16 | 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) |
| 120184 | 120184 | 39310 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 399X Treat Ave | 17 | 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) |
| 13596 | 13596 | 39526 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 88 Arkansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | 11 | 3x3 | Permit Number 41411 | 6012822.50354 | 2106773.24892 | 37.7655197209944 | -122.39886197172 | (37.7655197209944, -122.39886197172) |
| 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) | ||
| 15861 | 15861 | 39529 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 88x Arkansas St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 11 | 3x3 | Permit Number 40969 | 6012828.01164 | 2106692.90102 | 37.7652994104535 | -122.398837280819 | (37.7652994104535, -122.398837280819) |
| 38556 | 38556 | 39530 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 88x Arkansas St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 11 | Permit Number 40969 | 6012826.83044 | 2106709.20057 | 37.7653440995751 | -122.39884251038 | (37.7653440995751, -122.39884251038) | |
| 97003 | 97003 | 39531 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 76x ARKANSAS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 12 | Permit Number 40969 | 6012767.0 | 2106714.0 | 37.7653539438367 | -122.399049788163 | (37.7653539438367, -122.399049788163) | |
| 93913 | 93913 | 39532 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 76x ARKANSAS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 7 | Permit Number 40969 | 6012767.0 | 2106714.0 | 37.7653539438367 | -122.399049788163 | (37.7653539438367, -122.399049788163) | |
| 16448 | 16448 | 39533 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 88 Arkansas St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 12 | 3x3 | Permit Number 40969 | 6012825.73713 | 2106722.14345 | 37.7653795769245 | -122.398847200352 | (37.7653795769245, -122.398847200352) |
| 14517 | 14517 | 39534 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 88 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | 11 | 3x3 | Permit Number 41411 | 6012823.46447 | 2106790.35067 | 37.765566732135504 | -122.39885984841801 | (37.7655667321355, -122.398859848418) |
| 91162 | 91162 | 39535 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 76x ARKANSAS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40969 | 6012767.0 | 2106714.0 | 37.7653539438367 | -122.399049788163 | (37.7653539438367, -122.399049788163) |
| 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) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 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) | |
| 120768 | 120768 | 41659 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 328 Caselli Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42128 | 5999720.90250233 | 2104674.14058563 | 37.759017358484 | -122.44402647097999 | (37.759017358484, -122.44402647098) |
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");