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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 106575 | 106575 | 32837 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1200-1204 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1996 12:00:00 AM | Permit Number 37192 | 6002497.0 | 2102089.0 | 37.7520771531238 | -122.434240612887 | (37.7520771531238, -122.434240612887) | |||
| 107572 | 107572 | 31365 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2327 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 4 | Permit Number 34970 | 5991025.17306 | 2099558.33269 | 37.7444708015922 | -122.47372691139499 | (37.7444708015922, -122.473726911395) | |
| 107876 | 107876 | 68864 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 176 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | Permit Number 32827 | 5998915.73830056 | 2093521.71368194 | 37.7283495188017 | -122.446008953409 | (37.7283495188017, -122.446008953409) | ||
| 108527 | 108527 | 40769 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 90 Entrada Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/1999 12:00:00 AM | Permit Number 41731 | 5992535.95232782 | 2092083.0060810002 | 37.7240328083641 | -122.46795936676901 | (37.7240328083641, -122.467959366769) | ||
| 108890 | 108890 | 68067 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 124 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | 11 | Permit Number 31804 | 5993663.47634058 | 2103268.81441412 | 37.754811287000706 | -122.464873684633 | (37.7548112870007, -122.464873684633) | |
| 108912 | 108912 | 53551 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 116 Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2007 12:00:00 AM | 3x3 | Permit Number 49757 | 5997037.05674347 | 2089332.93754069 | 37.7167406655365 | -122.452201492855 | (37.7167406655365, -122.452201492855) | ||
| 110052 | 110052 | 40479 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 543 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1999 12:00:00 AM | Permit Number 41557 | 5996251.58042917 | 2089868.37749114 | 37.718165830416005 | -122.45495514714099 | (37.718165830416, -122.454955147141) | ||
| 110504 | 110504 | 63153 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1135 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1996 12:00:00 AM | Permit Number 23689 | 6001346.37062481 | 2112270.98254885 | 37.7799689896828 | -122.438949272681 | (37.7799689896828, -122.438949272681) | ||
| 110888 | 110888 | 51881 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 438 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/18/2005 12:00:00 AM | Permit Number 48097 | 5989393.54128853 | 2112360.26063999 | 37.7795268026551 | -122.48030552365499 | (37.7795268026551, -122.480305523655) | ||
| 110952 | 110952 | 69510 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 456 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | Permit Number 33637 | 6008875.40021357 | 2096212.24839146 | 37.7363008518361 | -122.411767856956 | (37.7363008518361, -122.411767856956) | ||
| 110975 | 110975 | 68068 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 128 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | 10 | Permit Number 31805 | 5993651.58024335 | 2103268.48440829 | 37.754809694989795 | -122.46491480033 | (37.7548096949898, -122.46491480033) | |
| 111075 | 111075 | 96908 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 390X 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2011 12:00:00 AM | 4x4 | Permit Number 767974 | 6003983.7 | 2100148.0 | 37.746831890001104 | -122.428961010832 | (37.7468318900011, -122.428961010832) | ||
| 111162 | 111162 | 42427 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 620 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42577 | 5997972.86705556 | 2095014.83999466 | 37.7323954036406 | -122.449376022575 | (37.7323954036406, -122.449376022575) | ||
| 111221 | 111221 | 68066 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 121 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | Permit Number 31803 | 5993676.81439849 | 2103217.1644166 | 37.7546702384285 | -122.464823807653 | (37.7546702384285, -122.464823807653) | ||
| 111437 | 111437 | 94133 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 315 Seneca Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53516 | 5999195.3 | 2090879.5 | 37.7211105719006 | -122.44485264784599 | (37.7211105719006, -122.444852647846) | ||
| 111989 | 111989 | 40758 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 60 De Soto St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1999 12:00:00 AM | Permit Number 41725 | 5993077.65625848 | 2091558.66043318 | 37.722624350413795 | -122.46604871174499 | (37.7226243504138, -122.466048711745) | ||
| 112091 | 112091 | 40756 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 60 De Soto St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1999 12:00:00 AM | Permit Number 41725 | 5993077.65625848 | 2091558.66043318 | 37.722624350413795 | -122.46604871174499 | (37.7226243504138, -122.466048711745) | ||
| 112462 | 112462 | 42266 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1771 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42507 | 5987792.97769873 | 2103248.83655487 | 37.754416209778206 | -122.48517377049801 | (37.7544162097782, -122.485173770498) | ||
| 112815 | 112815 | 34708 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 678 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38364 | 5981680.40522934 | 2111119.17303473 | 37.7756679163326 | -122.506896004177 | (37.7756679163326, -122.506896004177) | ||
| 113438 | 113438 | 68023 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1755 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1993 12:00:00 AM | Permit Number 31754 | 5993089.03372499 | 2103534.42042559 | 37.7555074349875 | -122.466879556812 | (37.7555074349875, -122.466879556812) | ||
| 113972 | 113972 | 51581 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1639 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2005 12:00:00 AM | 3 | Permit Number 47874 | 6006611.817858701 | 2116483.82002415 | 37.791834582054896 | -122.421032908654 | (37.7918345820549, -122.421032908654) | ||
| 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) | |||||
| 114945 | 114945 | 115618 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1400 16th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | ||
| 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) | ||||
| 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) | ||
| 117650 | 117650 | 86774 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 573 Connecticut St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2007 12:00:00 AM | 3x3 | Permit Number 49746 | 6013291.0 | 2104402.0 | 37.7590348868282 | -122.39707525671601 | (37.7590348868282, -122.397075256716) | |||
| 118647 | 118647 | 66423 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 326 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1991 12:00:00 AM | 4x9 | Permit Number 29563 | 6008605.51305314 | 2097210.95195553 | 37.7390279301146 | -122.412771556258 | (37.7390279301146, -122.412771556258) | |
| 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) | ||
| 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) | ||
| 124171 | 124171 | 34457 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 999x UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 3x3 | Permit Number 38200 | 6008246.0 | 2119227.0 | 37.7994586593975 | -122.415572926479 | (37.7994586593975, -122.415572926479) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 139835 | 139835 | 88996 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2924 Steiner St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2008 12:00:00 AM | 3x3 | Permit Number 51745 | 6002052.0 | 2118164.0 | 37.7961898267193 | -122.436930189765 | (37.7961898267193, -122.436930189765) | |||
| 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) | ||
| 144090 | 144090 | 46425 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 500x LAIDLEY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/2002 12:00:00 AM | 3x3 | Permit Number 44647 | 6003128.0 | 2096056.0 | 37.7355477305103 | -122.43162784146999 | (37.7355477305103, -122.43162784147) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 159103 | 159103 | 79179 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1859 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 1 | 3x3 | Permit Number 50037 | 5983166.9149 | 2102491.0694 | 37.7520650271804 | -122.50111558741199 | (37.7520650271804, -122.501115587412) | |
| 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) | |
| 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) | |
| 171572 | 171572 | 32717 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 930 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 10 | 3x3 | Permit Number 37111 | 6008227.34815 | 2115705.62066 | 37.7897887726751 | -122.415388040436 | (37.7897887726751, -122.415388040436) |
| 172175 | 172175 | 95903 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1986 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767605 | 5989131.1765 | 2101822.5426 | 37.7505778487932 | -122.480441591554 | (37.7505778487932, -122.480441591554) |
| 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) | |
| 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) | |
| 174350 | 174350 | 93937 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 427 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53392 | 5990582.69863 | 2112452.2597 | 37.7798484361675 | -122.476198485506 | (37.7798484361675, -122.476198485506) | |
| 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) | ||
| 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) |
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");