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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 114230 | 114230 | 86759 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | |||||
| 115370 | 115370 | 107863 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 218 HOWTH ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3 | 5997350.1 | 2090721.9 | 37.720572361158105 | -122.451219574954 | (37.7205723611581, -122.451219574954) | ||||
| 116833 | 116833 | 107010 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 400 ALABAMA ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 6008836.3 | 2106230.4 | 37.763806265083296 | -122.412611023479 | (37.7638062650833, -122.412611023479) | ||||
| 116949 | 116949 | 41673 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 69 Deming St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 778874 | 5999228.79012001 | 2105180.00479751 | 37.7603782511364 | -122.445764801622 | (37.7603782511364, -122.445764801622) | ||
| 118818 | 118818 | 107004 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 400 ALABAMA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6008836.3 | 2106230.4 | 37.763806265083296 | -122.412611023479 | (37.7638062650833, -122.412611023479) | ||||
| 119584 | 119584 | 40760 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 125 De Soto St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2000 12:00:00 AM | Permit Number 41726 | 5993244.02089224 | 2091981.15429222 | 37.723794012147 | -122.46550430814301 | (37.723794012147, -122.465504308143) | ||
| 120349 | 120349 | 86760 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | |||||
| 120601 | 120601 | 40749 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 60 Cedro Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1999 12:00:00 AM | Permit Number 41720 | 5992465.74581598 | 2093166.10361938 | 37.7270026730351 | -122.46828081444599 | (37.7270026730351, -122.468280814446) | ||
| 120840 | 120840 | 68898 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 4672 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | Permit Number 32871 | 6000098.06906542 | 2105201.20506456 | 37.76048605607021 | -122.442759901067 | (37.7604860560702, -122.442759901067) | ||
| 122013 | 122013 | 73893 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1501 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1994 12:00:00 AM | 10 | 6007549.1868 | 2116472.92184 | 37.7918574535089 | -122.417788830994 | (37.7918574535089, -122.417788830994) | ||
| 122653 | 122653 | 68037 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1739 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1993 12:00:00 AM | Permit Number 31773 | 5993085.35051865 | 2103638.79960604 | 37.755793820585104 | -122.46689988213001 | (37.7557938205851, -122.46689988213) | ||
| 123269 | 123269 | 40459 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 256 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1999 12:00:00 AM | Permit Number 41544 | 6008229.9197421 | 2097395.17552334 | 37.739512678985896 | -122.414083219638 | (37.7395126789859, -122.414083219638) | ||
| 124326 | 124326 | 40743 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 40 Cedro Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1999 12:00:00 AM | Permit Number 41719 | 5992588.05334035 | 2093209.10678957 | 37.7271278125133 | -122.46786112953899 | (37.7271278125133, -122.467861129539) | ||
| 124418 | 124418 | 66421 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 311 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1991 12:00:00 AM | Permit Number 29561 | 6008662.43573018 | 2097263.932308 | 37.7391765974053 | -122.41257848719299 | (37.7391765974053, -122.412578487193) | ||
| 125822 | 125822 | 86761 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | |||||
| 126094 | 126094 | 51733 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 834 Toland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2005 12:00:00 AM | Permit Number 48014 | 6012117.32852637 | 2098230.03082929 | 37.7420225917964 | -122.40070080435301 | (37.7420225917964, -122.400700804353) | |||
| 127305 | 127305 | 45839 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 562 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2001 12:00:00 AM | Permit Number 44449 | 5984130.8408017 | 2112009.83198879 | 37.778257408954794 | -122.498485276772 | (37.7782574089548, -122.498485276772) | |||
| 128532 | 128532 | 34618 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2295 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/2002 12:00:00 AM | Permit Number 44529 | 6002289.17159211 | 2107042.12264547 | 37.7656654347214 | -122.435313579001 | (37.7656654347214, -122.435313579001) | ||
| 128871 | 128871 | 67798 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 4171 26TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1992 12:00:00 AM | Permit Number 31441 | 6002817.3 | 2100605.0 | 37.7480206136149 | -122.433026952996 | (37.7480206136149, -122.433026952996) | |||
| 128964 | 128964 | 34704 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 615 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 8 | Permit Number 38361 | 5981612.97325 | 2111540.52057 | 37.7768208414608 | -122.50716052883699 | (37.7768208414608, -122.507160528837) | |
| 129129 | 129129 | 55856 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 60 Sharon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2015 12:00:00 AM | Permit Number 776174 | 6003842.74750128 | 2106799.59707315 | 37.7650876224345 | -122.42992279922 | (37.7650876224345, -122.42992279922) | |||
| 129747 | 129747 | 33247 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2586 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 8 | Permit Number 37428 | 5987412.9749 | 2097696.9936 | 37.7391501881737 | -122.486080385609 | (37.7391501881737, -122.486080385609) | |
| 130136 | 130136 | 40664 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 37 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 11 | Permit Number 41655 | 6003638.4352 | 2093754.51209 | 37.7292572834764 | -122.429698976444 | (37.7292572834764, -122.429698976444) | |
| 130615 | 130615 | 71998 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1915 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 14 | 5987521.6777 | 2102219.5634 | 37.751574295748206 | -122.48603643497299 | (37.7515742957482, -122.486036434973) | ||
| 130671 | 130671 | 33159 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2443 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 9 | Permit Number 37382 | 5985780.7157 | 2098599.2186 | 37.741532194650794 | -122.491790321831 | (37.7415321946508, -122.491790321831) | |
| 133304 | 133304 | 125713 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 956 Vallejo St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6008845.05182 | 2118706.6905799997 | 37.7980636731514 | -122.41346316930799 | (37.7980636731514, -122.413463169308) | ||||
| 133846 | 133846 | 34647 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1587 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 7 | Permit Number 38326 | 5987753.3744 | 2104509.5361 | 37.7578754422043 | -122.485403233386 | (37.7578754422043, -122.485403233386) | |
| 135069 | 135069 | 71610 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 265 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 8 | 5994208.54554 | 2086740.2113599998 | 37.7094592149285 | -122.46179029709499 | (37.7094592149285, -122.461790297095) | ||
| 135115 | 135115 | 34652 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1921 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 6 | Permit Number 38331 | 5988873.4566 | 2105098.7324 | 37.7595584078301 | -122.481572717376 | (37.7595584078301, -122.481572717376) | |
| 136335 | 136335 | 31160 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 401 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 9 | Permit Number 34862 | 5992970.4282599995 | 2089958.37606 | 37.7182241712773 | -122.466303127503 | (37.7182241712773, -122.466303127503) | |
| 137249 | 137249 | 31161 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 401 Ramsell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 8 | Permit Number 34862 | 5992970.452219999 | 2089928.9593099998 | 37.7181434013758 | -122.466300907981 | (37.7181434013758, -122.466300907981) | |
| 137670 | 137670 | 70224 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 774 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 9 | 5991346.67049 | 2110134.70461 | 37.7735293356805 | -122.473386511602 | (37.7735293356805, -122.473386511602) | ||
| 139178 | 139178 | 68072 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 326 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1993 12:00:00 AM | Permit Number 31810 | 5993038.43231429 | 2103251.4751391 | 37.754727619886204 | -122.467033980749 | (37.7547276198862, -122.467033980749) | ||
| 139268 | 139268 | 40477 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 535 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1999 12:00:00 AM | Permit Number 41556 | 5996299.47149878 | 2089867.48348074 | 37.7181661228901 | -122.454789544621 | (37.7181661228901, -122.454789544621) | ||
| 140544 | 140544 | 52244 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1550 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2005 12:00:00 AM | Permit Number 48413 | 6013439.04799366 | 2103846.48755141 | 37.7575178110179 | -122.396524293417 | (37.7575178110179, -122.396524293417) | |||
| 140597 | 140597 | 40745 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 40 Cedro Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1999 12:00:00 AM | Permit Number 41719 | 5992588.05334035 | 2093209.10678957 | 37.7271278125133 | -122.46786112953899 | (37.7271278125133, -122.467861129539) | ||
| 140857 | 140857 | 40765 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 26 Entrada Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1999 12:00:00 AM | Permit Number 41729 | 5992399.49150569 | 2092389.70166559 | 37.7248670377879 | -122.46845338960199 | (37.7248670377879, -122.468453389602) | ||
| 143049 | 143049 | 68041 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1786 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1993 12:00:00 AM | Permit Number 31778 | 5993148.36779464 | 2103327.49581212 | 37.7549426978918 | -122.466659322623 | (37.7549426978918, -122.466659322623) | ||
| 143861 | 143861 | 40742 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 40 Cedro Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1999 12:00:00 AM | Permit Number 41719 | 5992588.05334035 | 2093209.10678957 | 37.7271278125133 | -122.46786112953899 | (37.7271278125133, -122.467861129539) | ||
| 144431 | 144431 | 68059 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1755 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | Permit Number 31796 | 5993398.60860505 | 2103544.1147165 | 37.7555519155036 | -122.465809664403 | (37.7555519155036, -122.465809664403) | ||
| 144740 | 144740 | 39817 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2101 46th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41148 | 5981978.01419846 | 2100783.80216684 | 37.7473074654157 | -122.505100399713 | (37.7473074654157, -122.505100399713) | ||
| 145150 | 145150 | 69512 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 472 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | Permit Number 33639 | 6008869.38717848 | 2096146.49207246 | 37.736119961903896 | -122.411784001618 | (37.7361199619039, -122.411784001618) | ||
| 145154 | 145154 | 40747 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 60 Cedro Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1999 12:00:00 AM | Permit Number 41720 | 5992465.74581598 | 2093166.10361938 | 37.7270026730351 | -122.46828081444599 | (37.7270026730351, -122.468280814446) | ||
| 145517 | 145517 | 39710 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 780 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41095 | 5996936.4012082005 | 2095030.50112432 | 37.7323790624539 | -122.45296043786999 | (37.7323790624539, -122.45296043787) | ||
| 145688 | 145688 | 68495 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1771 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32371 | 5993402.07949897 | 2103439.3729604 | 37.7552645219201 | -122.46579005124501 | (37.7552645219201, -122.465790051245) | ||
| 147647 | 147647 | 125711 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 954 Vallejo St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6008937.17158 | 2118714.51142 | 37.798090319168 | -122.413144960375 | (37.798090319168, -122.413144960375) | ||||
| 147813 | 147813 | 33323 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3115 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 7 | Permit Number 37465 | 6004629.84544 | 2120270.80512 | 37.802120751438295 | -122.428160537697 | (37.8021207514383, -122.428160537697) | |
| 147953 | 147953 | 33095 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1127 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 11 | Permit Number 37338 | 6011115.1734 | 2118807.4721 | 37.798467596260096 | -122.405614950876 | (37.7984675962601, -122.405614950876) | |
| 151192 | 151192 | 31864 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1734 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | 10 | Permit Number 35306 | 5992515.136390001 | 2103625.8443 | 37.75572532149229 | -122.468870905993 | (37.7557253214923, -122.468870905993) | ||
| 151895 | 151895 | 31374 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 618 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 17 | Permit Number 34976 | 5991223.6620000005 | 2099114.89273 | 37.7432647234805 | -122.47300825323799 | (37.7432647234805, -122.473008253238) | |
| 152340 | 152340 | 31373 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 616 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 17 | Permit Number 34975 | 5991252.30155 | 2099116.74406 | 37.743271464822705 | -122.47290936108801 | (37.7432714648227, -122.472909361088) | |
| 152875 | 152875 | 40214 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 483 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 13 | Permit Number 41394 | 5981888.55122 | 2112529.15759 | 37.7795515745255 | -122.506280566157 | (37.7795515745255, -122.506280566157) | |
| 153663 | 153663 | 33178 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3333 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 8 | Permit Number 37390 | 5985663.1141 | 2098179.7448 | 37.74037355789021 | -122.49216606308599 | (37.7403735578902, -122.492166063086) | |
| 154225 | 154225 | 52681 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3535 REVISED Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 6 | Permit Number 48754 | 5984542.32395 | 2111051.13386 | 37.7756492220711 | -122.49699104738 | (37.7756492220711, -122.49699104738) | ||
| 155622 | 155622 | 74125 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1501 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1994 12:00:00 AM | 9 | 6007522.57983 | 2116468.5162 | 37.7918438593627 | -122.417880578935 | (37.7918438593627, -122.417880578935) | ||
| 156056 | 156056 | 32640 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2663 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 9 | Permit Number 37085 | 6010083.06076 | 2103949.57384 | 37.7576135254646 | -122.408137970501 | (37.7576135254646, -122.408137970501) | |
| 156074 | 156074 | 51042 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2031 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | 4 | Permit Number 47515 | 5990334.5392 | 2101532.5464 | 37.749851453790605 | -122.476259131856 | (37.7498514537906, -122.476259131856) | ||
| 157132 | 157132 | 52677 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 700 REVISED 37th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 7 | Permit Number 48754 | 5984472.12802 | 2111009.36044 | 37.7755304106086 | -122.49723078434401 | (37.7755304106086, -122.497230784344) | ||
| 157325 | 157325 | 40205 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 531 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 10 | Permit Number 41387 | 5982523.74709 | 2112147.83586 | 37.7785419514891 | -122.50405493614099 | (37.7785419514891, -122.504054936141) | |
| 158194 | 158194 | 33163 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1900 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | 5 | Permit Number 37385 | 5986968.1646 | 2099642.2172 | 37.7444653222212 | -122.487761192729 | (37.7444653222212, -122.487761192729) | ||
| 158306 | 158306 | 125712 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 956 Vallejo St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6008850.76057 | 2118710.67422 | 37.798074931775396 | -122.413443697187 | (37.7980749317754, -122.413443697187) | ||||
| 158553 | 158553 | 47683 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 730 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | 8 | Permit Number 45474 | 5991337.42645 | 2110428.10245 | 37.7743343910633 | -122.473439892203 | (37.7743343910633, -122.473439892203) | |
| 158678 | 158678 | 52682 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3535 REVISED Balboa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 5 | Permit Number 48754 | 5984583.26235 | 2111053.32202 | 37.7756576289957 | -122.496849595053 | (37.7756576289957, -122.496849595053) | ||
| 159373 | 159373 | 38691 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 13904 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | 8 | Permit Number 40604 | 6001240.455 | 2110421.1619 | 37.7748838228637 | -122.439183061176 | (37.7748838228637, -122.439183061176) | |
| 159448 | 159448 | 52683 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 700 REVISED 37th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 5 | Permit Number 48754 | 5984474.1727 | 2110997.72398 | 37.7754985800658 | -122.49722285223801 | (37.7754985800658, -122.497222852238) | ||
| 160322 | 160322 | 33239 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2581 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1996 12:00:00 AM | 8 | Permit Number 37424 | 5988605.1751 | 2097786.0324 | 37.739464073986 | -122.481964866217 | (37.739464073986, -122.481964866217) | |
| 160448 | 160448 | 32341 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 120 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2005 12:00:00 AM | 6 | Permit Number 47986 | 6010882.28946 | 2093426.3819099998 | 37.728763829978796 | -122.404633115548 | (37.7287638299788, -122.404633115548) | ||
| 160980 | 160980 | 33263 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1422 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 7 | Permit Number 37438 | 5988495.8087 | 2097654.8706 | 37.7390975767362 | -122.48233339540701 | (37.7390975767362, -122.482333395407) | |
| 162353 | 162353 | 125714 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 941 Vallejo St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6008973.41059 | 2118698.11415 | 37.7980473306652 | -122.413018402384 | (37.7980473306652, -122.413018402384) | ||||
| 162405 | 162405 | 33264 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1424 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 8 | Permit Number 37439 | 5988466.7481 | 2097653.8327 | 37.7390930364544 | -122.48243379651501 | (37.7390930364544, -122.482433796515) | |
| 163553 | 163553 | 34707 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 678 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 8 | Permit Number 38364 | 5981677.4444 | 2111118.32695 | 37.7756654188698 | -122.506906183465 | (37.7756654188698, -122.506906183465) | |
| 168364 | 168364 | 38053 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2721 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 9 | Permit Number 40249 | 6000435.904 | 2114420.5238 | 37.785819233145205 | -122.442253327272 | (37.7858192331452, -122.442253327272) | |
| 169736 | 169736 | 40201 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 830 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 9 | Permit Number 41383 | 5983264.50092 | 2110118.09525 | 37.7730124061407 | -122.50134224763599 | (37.7730124061407, -122.501342247636) | |
| 170316 | 170316 | 34716 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 870 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 7 | Permit Number 38371 | 5981723.61752 | 2109806.49015 | 37.772066217995 | -122.506649145791 | (37.772066217995, -122.506649145791) | |
| 172627 | 172627 | 125709 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 944 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6009014.12735 | 2118712.39114 | 37.798088817308 | -122.412878520028 | (37.798088817308, -122.412878520028) | ||||
| 173112 | 173112 | 31244 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2530 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 5 | Permit Number 34927 | 5991119.10611 | 2098174.96045 | 37.740677856906 | -122.47330123797701 | (37.740677856906, -122.473301237977) | |
| 173118 | 173118 | 205604 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 426 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5999234.008330001 | 2095000.5896599998 | 37.732428335305 | -122.4450149543 | (37.732428335305, -122.4450149543) | ||||
| 174075 | 174075 | 52673 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 700 REVISED 37th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 7 | Permit Number 48754 | 5984474.785130001 | 2110952.04196 | 37.7753731862643 | -122.497217360825 | (37.7753731862643, -122.497217360825) | ||
| 174099 | 174099 | 33231 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2553 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1996 12:00:00 AM | 9 | Permit Number 37417 | 5989219.0688 | 2097970.1761 | 37.7400053687963 | -122.479855786116 | (37.7400053687963, -122.479855786116) | |
| 177639 | 177639 | 33154 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2326 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 11 | Permit Number 37377 | 5986110.8462 | 2099395.3559 | 37.7437374639566 | -122.490707423066 | (37.7437374639566, -122.490707423066) | |
| 180730 | 180730 | 52680 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3535 REVISED Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 6 | Permit Number 48754 | 5984555.73131 | 2111052.6848299997 | 37.7756542662383 | -122.496944783224 | (37.7756542662383, -122.496944783224) | ||
| 181814 | 181814 | 74235 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1069 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1996 12:00:00 AM | 8 | 6008785.22187 | 2115933.15302 | 37.79044486048821 | -122.413473942277 | (37.7904448604882, -122.413473942277) | ||
| 184170 | 184170 | 73750 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 638 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 4 | 5990680.77629 | 2111023.575 | 37.7759313483187 | -122.47575483630501 | (37.7759313483187, -122.475754836305) | ||
| 185444 | 185444 | 34477 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1818 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 11 | Permit Number 46532 | 6008722.614159999 | 2119125.18072 | 37.7992058679054 | -122.413916459984 | (37.7992058679054, -122.413916459984) | |
| 186023 | 186023 | 72370 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 638 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 3 | 5990680.359209999 | 2111038.5537900003 | 37.7759724517855 | -122.475757373153 | (37.7759724517855, -122.475757373153) | ||
| 186861 | 186861 | 41550 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2271 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2000 12:00:00 AM | 5 | Permit Number 42072 | 6003891.05094 | 2116280.93986 | 37.7911237785009 | -122.430432278226 | (37.7911237785009, -122.430432278226) | ||
| 187529 | 187529 | 38847 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1470 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 9 | Permit Number 40676 | 5989942.9457 | 2105353.4021 | 37.7603197919591 | -122.47789255007099 | (37.7603197919591, -122.477892550071) | |
| 85928 | 85928 | 87198 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3984 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2008 12:00:00 AM | 3 | 2.5x3 | Permit Number 50214 | 5995710.95001 | 2114863.89205 | 37.786766180939395 | -122.45863234603901 | (37.7867661809394, -122.458632346039) | |
| 85096 | 85096 | 107303 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2432 Diamond St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2014 12:00:00 AM | 2x3 | Permit Number 773619 | 6001987.23202 | 2097099.10599 | 37.738347131542895 | -122.43564650704599 | (37.7383471315429, -122.435646507046) | |||
| 6505 | 6505 | 20152 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1057 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/02/1997 12:00:00 AM | 12 | 3X3 | 6002876.4729 | 2111952.9425 | 37.7791826693541 | -122.433633233262 | (37.7791826693541, -122.433633233262) | ||
| 6578 | 6578 | 9618 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1400 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2000 12:00:00 AM | 7 | 3X3 | 6002831.8444 | 2112032.7875 | 37.7793993714118 | -122.43379332982599 | (37.7793993714118, -122.433793329826) | ||
| 15921 | 15921 | 29468 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1613 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/05/2015 07:24:00 AM | 3 | 3X3 | 6016802.5034 | 2093317.3698 | 37.7287936059494 | -122.384158766122 | (37.7287936059494, -122.384158766122) | ||
| 18354 | 18354 | 29366 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/25/2012 12:00:00 AM | 3 | 3X3 | 5992064.02141 | 2096527.0918599998 | 37.7362078962607 | -122.46991416090599 | (37.7362078962607, -122.469914160906) | ||
| 18576 | 18576 | 29362 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/04/2009 12:00:00 AM | 3 | 3X3 | 5991983.966469999 | 2096447.7248099998 | 37.7359853464519 | -122.470185163514 | (37.7359853464519, -122.470185163514) | ||
| 19218 | 19218 | 29363 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/04/2009 12:00:00 AM | 3 | 3X3 | 5992002.78104 | 2096471.37185 | 37.736051362971004 | -122.470121835975 | (37.736051362971, -122.470121835975) | ||
| 19222 | 19222 | 29357 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991847.829940001 | 2096308.81938 | 37.7355960757897 | -122.470645723443 | (37.7355960757897, -122.470645723443) | ||
| 19378 | 19378 | 27278 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 223X Duboce Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005367.959369999 | 2108416.37045 | 37.7696131525447 | -122.424762488 | (37.7696131525447, -122.424762488) | |||
| 19384 | 19384 | 27275 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 223X Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005306.02285 | 2108414.57657 | 37.7696047286145 | -122.424976596817 | (37.7696047286145, -122.424976596817) | |||
| 20563 | 20563 | 29361 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991939.73246 | 2096403.05712 | 37.735860142840096 | -122.470334844889 | (37.7358601428401, -122.470334844889) | ||
| 20784 | 20784 | 27276 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 223X Duboce Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005326.21516 | 2108415.83453 | 37.7696093232375 | -122.424906841772 | (37.7696093232375, -122.424906841772) |
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");