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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11105 | 11105 | 83902 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 451 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50518 | 5999574.303230001 | 2091368.33238 | 37.7224744158531 | -122.44357764611601 | (37.7224744158531, -122.443577646116) | |
| 11107 | 11107 | 34137 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37987 | |||||||||
| 11193 | 11193 | 25385 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1231 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2011 12:00:00 AM | 3 | 3x3 | 6001822.88806 | 2088260.8804099998 | 37.71407003188121 | -122.435582613755 | (37.7140700318812, -122.435582613755) | ||
| 11233 | 11233 | 108547 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 400 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773709 | 6002168.783340001 | 2093999.82608 | 37.7298475310412 | -122.43479722051799 | (37.7298475310412, -122.434797220518) |
| 11262 | 11262 | 34121 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37980 | |||||||||
| 11285 | 11285 | 83683 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 215 Dublin St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52308 | 6004110.69577 | 2089162.29942 | 37.716674810270206 | -122.42773926378 | (37.7166748102702, -122.42773926378) | |
| 11449 | 11449 | 35191 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 11473 | 11473 | 40673 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 119 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 9 | 3x3 | Permit Number 41658 | 6004193.53589 | 2093779.4786099999 | 37.7293572530177 | -122.427781722549 | (37.7293572530177, -122.427781722549) |
| 11627 | 11627 | 88529 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51479 | |||||||||
| 11640 | 11640 | 25776 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1927 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/1997 12:00:00 AM | 18 | 2X3 | 6005592.75122 | 2086370.79672 | 37.709093663004495 | -122.42241829446199 | (37.7090936630045, -122.422418294462) | ||
| 11658 | 11658 | 86163 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1351 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Health Dept 8 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988630.418 | 2106174.0062 | 37.7624966829905 | -122.482492045676 | (37.7624966829905, -122.482492045676) | ||
| 11660 | 11660 | 27047 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 880 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/2005 12:00:00 AM | 3 | 3x3 | 6007095.12349 | 2093540.35463 | 37.728864383186895 | -122.41773369987601 | (37.7288643831869, -122.417733699876) | ||
| 11667 | 11667 | 25357 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 826 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/1996 12:00:00 AM | 30 | 3X3 | 6000014.56048 | 2089501.0524099998 | 37.7173723892107 | -122.44192182424999 | (37.7173723892107, -122.44192182425) | ||
| 11728 | 11728 | 35200 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 11752 | 11752 | 25755 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1500X Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1997 12:00:00 AM | 12 | 5 | 6002973.26044 | 2087695.8045299998 | 37.7125837286265 | -122.431566173166 | (37.7125837286265, -122.431566173166) | ||
| 11762 | 11762 | 47040 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 771 Walter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2002 12:00:00 AM | Permit Number 45031 | ||||||||
| 11870 | 11870 | 25764 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1686 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1997 12:00:00 AM | 16 | 2X3 | 6004225.91042 | 2087173.5217 | 37.7112205731354 | -122.427199443002 | (37.7112205731354, -122.427199443002) | ||
| 11902 | 11902 | 86165 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1351 24th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Health Dept 8 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988632.0413 | 2106102.0394 | 37.762299176167495 | -122.482481157841 | (37.7622991761675, -122.482481157841) | ||
| 11948 | 11948 | 25355 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 600 Geneva Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2001 12:00:00 AM | 8 | 2X3 | 5999172.673169999 | 2090392.4667 | 37.7197719989595 | -122.44489586965099 | (37.7197719989595, -122.444895869651) | ||
| 11956 | 11956 | 25368 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1040 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1996 12:00:00 AM | 16 | 3X3 | 6000898.99381 | 2088714.73107 | 37.7152636858484 | -122.438808440557 | (37.7152636858484, -122.438808440557) | ||
| 12036 | 12036 | 58780 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 54 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1979 12:00:00 AM | 8 | 3x3 | Permit Number 18023 | 6001656.090559999 | 2087766.6362400001 | 37.712703471549396 | -122.43612378171001 | (37.7127034715494, -122.43612378171) | |
| 12079 | 12079 | 46714 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 12131 | 12131 | 25371 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1128 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1996 12:00:00 AM | 20 | 3X3 | 6001319.11795 | 2088467.3510200002 | 37.7146083282968 | -122.437338607489 | (37.7146083282968, -122.437338607489) | ||
| 12215 | 12215 | 25370 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1100 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1996 12:00:00 AM | 14 | 3X3 | 6001209.09194 | 2088530.7104900002 | 37.7147760437566 | -122.43772343639401 | (37.7147760437566, -122.437723436394) | ||
| 12275 | 12275 | 35186 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 12288 | 12288 | 97340 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1455 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774279 | 5988651.4823 | 2098958.5529 | 37.7426862015352 | -122.48189062450399 | (37.7426862015352, -122.481890624504) | |
| 12301 | 12301 | 15694 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4200 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/1995 12:00:00 AM | 10 | 3x3 | 6003454.34297 | 2093966.93362 | 37.7298301192653 | -122.430350548736 | (37.7298301192653, -122.430350548736) | ||
| 12401 | 12401 | 36861 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 12459 | 12459 | 25774 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2027 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/1997 12:00:00 AM | 16 | 2x3 | 6005967.118919999 | 2086230.6545099998 | 37.7087299735811 | -122.42111447716299 | (37.7087299735811, -122.421114477163) | ||
| 12519 | 12519 | 25762 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1676 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1997 12:00:00 AM | 18 | 2X3 | 6004168.351919999 | 2087205.26365 | 37.711304474489495 | -122.427400639338 | (37.7113044744895, -122.427400639338) | ||
| 12589 | 12589 | 34135 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37986 | |||||||||
| 12610 | 12610 | 25367 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1034 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1996 12:00:00 AM | 15 | 3x3 | 6000865.40343 | 2088735.44534 | 37.715318651499096 | -122.438926026914 | (37.7153186514991, -122.438926026914) | ||
| 12650 | 12650 | 25395 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1039 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/1996 12:00:00 AM | 15 | 3X3 | 6000907.995680001 | 2088802.01255 | 37.7155038534055 | -122.438783577018 | (37.7155038534055, -122.438783577018) | ||
| 12655 | 12655 | 25376 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1276 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/1998 12:00:00 AM | 18 | 3x3 | 6002007.30225 | 2088058.64573 | 37.713525212695295 | -122.43493075454701 | (37.7135252126953, -122.434930754547) | ||
| 12684 | 12684 | 86164 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1351 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Health Dept 8 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988630.418 | 2106137.2111 | 37.762395653655894 | -122.482489349436 | (37.7623956536559, -122.482489349436) | ||
| 12719 | 12719 | 25392 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1063 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1997 12:00:00 AM | 14 | 3X3 | 6001061.933019999 | 2088709.29333 | 37.7152580237143 | -122.438244863328 | (37.7152580237143, -122.438244863328) | ||
| 12729 | 12729 | 108568 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 225 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773759 | 6006239.22183 | 2092782.68354 | 37.7267357814247 | -122.420638852723 | (37.7267357814247, -122.420638852723) |
| 12761 | 12761 | 86173 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1439 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778355 | 5988651.1741 | 2105513.6858 | 37.7606848299416 | -122.482371875236 | (37.7606848299416, -122.482371875236) | |
| 12868 | 12868 | 31576 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1927 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767615 | 5989387.7672 | 2102208.476 | 37.751652427787704 | -122.47958252470501 | (37.7516524277877, -122.479582524705) |
| 12895 | 12895 | 25384 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1247 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1996 12:00:00 AM | 23 | 3X3 | 6001863.38565 | 2088237.0164599998 | 37.7140068068465 | -122.435440932771 | (37.7140068068465, -122.435440932771) | ||
| 12909 | 12909 | 56905 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1883 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/1974 12:00:00 AM | 5 | 3x3 | Permit Number 14146 | 5985651.8431 | 2102421.0695 | 37.7520184290652 | -122.49251730430201 | (37.7520184290652, -122.492517304302) | |
| 13016 | 13016 | 35189 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 13086 | 13086 | 34123 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37981 | |||||||||
| 13171 | 13171 | 28793 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1419 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2006 12:00:00 AM | 3 | 3X3 | 6009776.96073 | 2094487.8719 | 37.73161661799121 | -122.408529172889 | (37.7316166179912, -122.408529172889) | ||
| 13207 | 13207 | 13370 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900 Mansell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2003 12:00:00 AM | 10 | 3X50 | 6009179.45689 | 2090013.7342599998 | 37.719298099396894 | -122.410279089032 | (37.7192980993969, -122.410279089032) | ||
| 13308 | 13308 | 25759 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1536 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2017 12:00:00 AM | 3 | 3X3 | Permit Number 779613 | 6003087.54114 | 2087663.41758 | 37.712501277897296 | -122.431168873349 | (37.7125012778973, -122.431168873349) | |
| 13445 | 13445 | 36857 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 13457 | 13457 | 36874 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 14227 | 14227 | 35184 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 14304 | 14304 | 110654 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2015 12:00:00 AM | 3 | 3x3 | 6012037.262709999 | 2106026.3006599997 | 37.763424983208 | -122.40152545783 | (37.763424983208, -122.40152545783) | |
| 14437 | 14437 | 1877 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 16 Beatrice Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6017871.97913 | 2094078.77448 | 37.7309433468436 | -122.380514379235 | (37.7309433468436, -122.380514379235) | |||
| 14448 | 14448 | 34465 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1521 Ralston Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1997 12:00:00 AM | Permit Number 38201 | ||||||||
| 14687 | 14687 | 35195 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 14730 | 14730 | 34101 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37975 | |||||||||
| 14763 | 14763 | 50776 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47304 | ||||||||||
| 14818 | 14818 | 35190 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 14890 | 14890 | 36859 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 14897 | 14897 | 36862 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 15003 | 15003 | 34117 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37979 | |||||||||
| 15057 | 15057 | 34122 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37981 | |||||||||
| 15117 | 15117 | 36858 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 15124 | 15124 | 35187 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 15243 | 15243 | 109931 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2822 Moraga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775171 | |||||
| 15421 | 15421 | 11222 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1050X Ingalls St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2015 12:00:00 AM | 3 | 3X4 | 6018123.812969999 | 2094772.15079 | 37.7328611160499 | -122.379691892563 | (37.7328611160499, -122.379691892563) | ||
| 15510 | 15510 | 34461 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1521 Ralston Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1997 12:00:00 AM | Permit Number 38201 | ||||||||
| 15551 | 15551 | 34115 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37978 | |||||||||
| 15658 | 15658 | 30360 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 641 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2014 12:00:00 AM | 32 | 7x4 | Permit Number 772082 | 6013028.6517900005 | 2104089.94418 | 37.758163442004204 | -122.397960696334 | (37.7581634420042, -122.397960696334) | |
| 15732 | 15732 | 49838 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 630 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/2016 12:00:00 AM | 3 | Permit Number 46621 | 6010947.62469 | 2105199.0558700003 | 37.7610926949039 | -122.405235926615 | (37.7610926949039, -122.405235926615) | |
| 15779 | 15779 | 50775 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47304 | ||||||||||
| 15869 | 15869 | 46153 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44491 | |||||||||
| 15972 | 15972 | 34132 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37986 | |||||||||
| 16027 | 16027 | 35201 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 16469 | 16469 | 35182 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 16677 | 16677 | 36865 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 16730 | 16730 | 111884 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1415 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2015 12:00:00 AM | 3 | 3x3 | 6016650.17356 | 2096690.65464 | 37.738047550348 | -122.38492030003799 | (37.738047550348, -122.384920300038) | ||
| 16819 | 16819 | 34124 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37982 | |||||||||
| 16827 | 16827 | 26123 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1443 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/1988 12:00:00 AM | 12 | 3X3 | 6015874.9678 | 2094820.8647 | 37.7328705765106 | -122.387470191315 | (37.7328705765106, -122.387470191315) | ||
| 16829 | 16829 | 35194 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 16890 | 16890 | 34103 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37975 | |||||||||
| 17032 | 17032 | 94164 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 729 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53529 | 5991968.0 | 2104568.0 | 37.758280608436706 | -122.470831686794 | (37.7582806084367, -122.470831686794) | ||
| 17122 | 17122 | 35196 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 17310 | 17310 | 32157 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 219 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | 18 | 2x2 | Permit Number 35507 | 6005455.872 | 2110108.4059 | 37.7742640388488 | -122.42457877877199 | (37.7742640388488, -122.424578778772) |
| 17583 | 17583 | 18586 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 307 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 5993137.1732 | 2088487.6954 | 37.7141956555284 | -122.46561997911999 | (37.7141956555284, -122.46561997912) | |||
| 17800 | 17800 | 196 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 292X Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2011 12:00:00 AM | 3 | 3x3 | 6002892.1169 | 2106567.7025 | 37.764397014858 | -122.433194223505 | (37.764397014858, -122.433194223505) | ||
| 17905 | 17905 | 92094 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1300 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2007 12:00:00 AM | 3x3 | Permit Number 52201 | 6004216.0 | 2112914.0 | 37.7818974087405 | -122.42906780012501 | (37.7818974087405, -122.429067800125) | ||
| 17908 | 17908 | 45501 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3070 23rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2001 12:00:00 AM | Permit Number 44273 | 5989380.64559271 | 2094892.34202186 | 37.731563814981605 | -122.47907204836399 | (37.7315638149816, -122.479072048364) | ||
| 17914 | 17914 | 66442 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 263 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/01/2016 12:00:00 AM | 3 | Permit Number 772183 | 6006122.56808708 | 2096124.40877 | 37.73590484821929 | -122.421279320467 | (37.7359048482193, -122.421279320467) | |
| 17926 | 17926 | 85267 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1000 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2007 12:00:00 AM | Permit Number 49560 | ||||||||
| 18196 | 18196 | 108832 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 60 Ney St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774659 | 6003833.887 | 2093995.50335 | 37.7299300570357 | -122.429040457944 | (37.7299300570357, -122.429040457944) | |
| 18682 | 18682 | 87286 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1272 42nd Ave | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 03/18/2007 12:00:00 AM | Permit Number 50303 | 5983096.8 | 2106514.6 | 37.7631083916796 | -122.501655692289 | (37.7631083916796, -122.501655692289) | ||||
| 18855 | 18855 | 2108 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1027 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/2000 12:00:00 AM | 3 | 3X3 | 6001243.13078 | 2095612.35205 | 37.7342225583259 | -122.438112767284 | (37.7342225583259, -122.438112767284) | ||
| 18921 | 18921 | 32751 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 98X LOBOS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37130 | 5996424.0 | 2088680.0 | 37.71491271306979 | -122.45427337935101 | (37.7149127130698, -122.454273379351) | ||
| 19033 | 19033 | 2111 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1041 Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6001197.43418 | 2095624.8112700002 | 37.7342541694939 | -122.43827164693 | (37.7342541694939, -122.43827164693) | |||
| 19059 | 19059 | 43844 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2736 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/28/2003 12:00:00 AM | Permit Number 43466 | 5985584.65410627 | 2096702.64202879 | 37.7363132411039 | -122.492328600224 | (37.7363132411039, -122.492328600224) | ||
| 19106 | 19106 | 45210 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 600-698X Bowdoin St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/2001 12:00:00 AM | Permit Number 44051 | 6008935.27610714 | 2093040.15073148 | 37.7275943109827 | -122.41133681828501 | (37.7275943109827, -122.411336818285) | ||
| 19118 | 19118 | 85268 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1000 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2007 12:00:00 AM | Permit Number 49560 | ||||||||
| 19353 | 19353 | 49110 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1411 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46250 | 5995842.78355552 | 2093401.69932097 | 37.7278440321398 | -122.456623556012 | (37.7278440321398, -122.456623556012) | ||
| 19426 | 19426 | 82960 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4774 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50809 | 5999900.41105831 | 2104653.85391663 | 37.7589718947663 | -122.443404190452 | (37.7589718947663, -122.443404190452) | ||
| 19470 | 19470 | 31542 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 150 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35092 | 5998688.18134384 | 2112713.18488923 | 37.7810315633484 | -122.44817695027099 | (37.7810315633484, -122.448176950271) | ||
| 19638 | 19638 | 88554 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 579 16th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2008 12:00:00 AM | 3x3 | Permit Number 51499 | 5990911.3 | 2111462.4 | 37.777149603591496 | -122.474989443149 | (37.7771496035915, -122.474989443149) |
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");