Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 85018 | 85018 | 92970 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3506 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2009 12:00:00 AM | 3x3 | Permit Number 53127 | 6003465.3 | 2106607.7 | 37.764539336845004 | -122.43121459836901 | (37.764539336845, -122.431214598369) | ||
| 114123 | 114123 | 39607 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 425 Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41010 | 5998485.83180749 | 2106734.79631937 | 37.7646048701954 | -122.44844630961 | (37.7646048701954, -122.44844630961) | ||
| 117804 | 117804 | 39606 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 425 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41010 | 5998485.83180749 | 2106734.79631937 | 37.7646048701954 | -122.44844630961 | (37.7646048701954, -122.44844630961) | ||
| 160813 | 160813 | 35020 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1013 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1997 12:00:00 AM | 7 | Permit Number 38595 | 6012215.58628 | 2103654.42136 | 37.7569222759593 | -122.400742049433 | (37.7569222759593, -122.400742049433) | ||
| 38648 | 38648 | 68912 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 10 Florence St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 8 | Permit Number 32890 | 6008496.870730001 | 2118345.67653 | 37.797052862167604 | -122.41464241973 | (37.7970528621676, -122.41464241973) | |
| 43576 | 43576 | 68892 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 40 Exeter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 7 | Permit Number 32864 | 6012556.44634 | 2091062.56254 | 37.7223666905441 | -122.398679591909 | (37.7223666905441, -122.398679591909) | |
| 63648 | 63648 | 68925 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2124 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 8 | Permit Number 32909 | 5992060.17158 | 2112059.99244 | 37.77885694376779 | -122.471058716214 | (37.7788569437678, -122.471058716214) | |
| 74474 | 74474 | 68933 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 681 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 7 | Permit Number 32917 | 5992842.88545 | 2110833.13785 | 37.7755335724471 | -122.468261747786 | (37.7755335724471, -122.468261747786) | |
| 89941 | 89941 | 68891 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 36 Exeter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | Permit Number 32863 | 6012558.723351 | 2091084.70468571 | 37.722427615253295 | -122.398673273848 | (37.7224276152533, -122.398673273848) | ||
| 106651 | 106651 | 68879 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1741 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | Permit Number 32850 | 5993705.24231741 | 2103645.69057472 | 37.7558484998294 | -122.46475661409599 | (37.7558484998294, -122.464756614096) | ||
| 129852 | 129852 | 68895 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2 Wheat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 6 | Permit Number 32867 | 6012134.32764 | 2091434.42813 | 37.723364230264394 | -122.400164870833 | (37.7233642302644, -122.400164870833) | |
| 133820 | 133820 | 68940 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 454 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 6 | Permit Number 32926 | 5989392.15436 | 2112242.86267 | 37.7792043799748 | -122.480301726508 | (37.7792043799748, -122.480301726508) | |
| 164091 | 164091 | 67822 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 519 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1992 12:00:00 AM | 9 | Permit Number 31478 | 6011808.7605800005 | 2105938.99653 | 37.763172512922004 | -122.402309638787 | (37.763172512922, -122.402309638787) | ||
| 9798 | 9798 | 32469 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 124 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2016 12:00:00 AM | 3 | Permit Number 779287 | 6000593.0 | 2105649.0 | 37.7617437934708 | -122.441080293978 | (37.7617437934708, -122.441080293978) | |
| 25688 | 25688 | 95116 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 67 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 5 | 3x3 | Permit Number 54043 | 6002297.43224 | 2093241.3314 | 37.727772179934 | -122.43429826136999 | (37.727772179934, -122.43429826137) |
| 42021 | 42021 | 95125 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 91 Rotteck St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 5 | 3x3 | Permit Number 54053 | 6003379.33035 | 2094579.25553 | 37.731507167824 | -122.430653552813 | (37.731507167824, -122.430653552813) |
| 170211 | 170211 | 72979 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1451 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2010 12:00:00 AM | 2 | Permit Number 54060 | 5988344.3187 | 2105426.2097 | 37.7604267896985 | -122.483426724107 | (37.7604267896985, -122.483426724107) | ||
| 25402 | 25402 | 52514 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 145 Naglee Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.240201401 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | ||
| 45219 | 45219 | 52525 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 115 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | 5 | Permit Number 48625 | 6000708.298330001 | 2092511.5798799999 | 37.725678122036705 | -122.439739616589 | (37.7256781220367, -122.439739616589) | |
| 81604 | 81604 | 52515 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 145 Naglee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.240201401 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | ||
| 83381 | 83381 | 52518 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 145 Naglee Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.240201401 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | ||
| 85420 | 85420 | 52517 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 145 Naglee Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.240201401 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | ||
| 87318 | 87318 | 52495 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 599 Moultrie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2005 12:00:00 AM | Permit Number 48604 | 6007698.78842616 | 2096579.30794213 | 37.7372426398673 | -122.41586188802299 | (37.7372426398673, -122.415861888023) | |||
| 99955 | 99955 | 62924 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 599 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48604 | 6007698.78842616 | 2096579.30794213 | 37.7372426398673 | -122.41586188802299 | (37.7372426398673, -122.415861888023) | ||
| 111902 | 111902 | 52516 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 145 Naglee Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.240201401 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | ||
| 129207 | 129207 | 52499 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 206 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48608 | 6007090.91316375 | 2097005.21766224 | 37.7383779008303 | -122.41799378080201 | (37.7383779008303, -122.417993780802) | ||
| 78907 | 78907 | 46184 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 841 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | Permit Number 44511 | 5997623.38792866 | 2107669.89260679 | 37.767123058720706 | -122.451496709211 | (37.7671230587207, -122.451496709211) | ||
| 105611 | 105611 | 46170 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 22 Hillway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | Permit Number 44499 | 5996115.83466209 | 2106813.26166937 | 37.7646845265696 | -122.456649119677 | (37.7646845265696, -122.456649119677) | ||
| 109178 | 109178 | 46185 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 845 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | Permit Number 44512 | 5997625.24396619 | 2107656.90958664 | 37.767087516944706 | -122.451489352946 | (37.7670875169447, -122.451489352946) | ||
| 121280 | 121280 | 46172 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 34 Hillway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | Permit Number 44501 | 5996117.860294099 | 2106765.38589744 | 37.7645531883122 | -122.456638651029 | (37.7645531883122, -122.456638651029) | ||
| 84901 | 84901 | 39510 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 971 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40962 | 6003803.3913976 | 2102619.59957595 | 37.7536081166409 | -122.42976075902399 | (37.7536081166409, -122.429760759024) | ||
| 83996 | 83996 | 68854 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 296 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | Permit Number 32817 | 5998798.41525763 | 2094112.17808977 | 37.729964095359605 | -122.446457004656 | (37.7299640953596, -122.446457004656) | ||
| 14939 | 14939 | 6391 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 16 Espanola St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2007 12:00:00 AM | 6 | 3X3 | 6018056.47068 | 2094273.68663 | 37.7314887164161 | -122.379890092347 | (37.7314887164161, -122.379890092347) | ||
| 67570 | 67570 | 52458 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 557@ ANZA 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | Permit Number 48569 | 5992189.638752901 | 2111651.23752465 | 37.777742101383794 | -122.470581063094 | (37.7777421013838, -122.470581063094) | ||
| 140366 | 140366 | 52467 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 623@ BALBOA 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | Permit Number 48578 | 5993135.59943115 | 2111227.85704239 | 37.776634266775204 | -122.467277895236 | (37.7766342667752, -122.467277895236) | ||
| 12580 | 12580 | 108559 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 247 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773718 | 6001785.96966 | 2094072.85918 | 37.7300263216596 | -122.43612587350701 | (37.7300263216596, -122.436125873507) |
| 20643 | 20643 | 26635 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 359 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/24/1998 12:00:00 AM | 3 | 3X3 | 6005539.477000001 | 2106921.88393 | 37.7655193351826 | -122.42406291888001 | (37.7655193351826, -122.42406291888) | ||
| 43838 | 43838 | 52448 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 431 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | 4 | Permit Number 48560 | 5992472.90838 | 2112504.99178 | 37.780102654065 | -122.469663313675 | (37.780102654065, -122.469663313675) | |
| 45866 | 45866 | 35166 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 513 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/2015 12:00:00 AM | 6 | Permit Number 38699 | 6002123.1918 | 2110352.0553 | 37.7747442642137 | -122.43612454697399 | (37.7747442642137, -122.436124546974) | |
| 78092 | 78092 | 81703 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 728 20th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | ||
| 99712 | 99712 | 81708 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 728 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | ||
| 99872 | 99872 | 81707 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 728 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | ||
| 106020 | 106020 | 81706 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 728 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | ||
| 107902 | 107902 | 81705 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 728 20th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | ||
| 108129 | 108129 | 81709 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 728 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | ||
| 120717 | 120717 | 81704 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 728 20th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | ||
| 139651 | 139651 | 81702 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 728 20th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | ||
| 93897 | 93897 | 39347 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 342 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40909 | 6007174.26983946 | 2105316.44942149 | 37.761203350475995 | -122.41829468784799 | (37.761203350476, -122.418294687848) | ||
| 104181 | 104181 | 39348 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 342 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40909 | 6007174.26983946 | 2105316.44942149 | 37.761203350475995 | -122.41829468784799 | (37.761203350476, -122.418294687848) | |||
| 104423 | 104423 | 39360 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 411 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40915 | 6007248.60489953 | 2104914.77803867 | 37.760104638015896 | -122.41800911826799 | (37.7601046380159, -122.418009118268) | ||
| 107349 | 107349 | 34197 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 15 Woodward St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40888 | 6006506.82888523 | 2108404.56366519 | 37.76964499140821 | -122.42082233238001 | (37.7696449914082, -122.42082233238) | ||
| 73750 | 73750 | 81771 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 118 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 7 | 3x3 | Permit Number 50018 | 6009093.57763 | 2112998.11082 | 37.7824032504549 | -122.41219952198999 | (37.7824032504549, -122.41219952199) | |
| 101989 | 101989 | 53767 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 280 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 3x3 | Permit Number 50032 | 5992868.31748404 | 2094997.91347506 | 37.732055613263604 | -122.467022262159 | (37.7320556132636, -122.467022262159) | ||
| 120438 | 120438 | 81929 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 118 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 6 | 3x3 | Permit Number 50018 | 6009095.92555 | 2112986.0024900003 | 37.782370135616496 | -122.41219054315201 | (37.7823701356165, -122.412190543152) | |
| 35350 | 35350 | 60550 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 538 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 4 | Permit Number 20160 | 5985052.81447 | 2112190.6948599997 | 37.7788080303748 | -122.49530921969601 | (37.7788080303748, -122.495309219696) | |
| 124445 | 124445 | 60548 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 511 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | Permit Number 20158 | 5984997.83219607 | 2112387.91202298 | 37.7793463125181 | -122.495513971823 | (37.7793463125181, -122.495513971823) | ||
| 126052 | 126052 | 60556 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 642 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | Permit Number 20166 | 5985080.35984143 | 2111485.8092912 | 37.7768742299218 | -122.495161937272 | (37.7768742299218, -122.495161937272) | ||
| 127915 | 127915 | 60534 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 503 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | Permit Number 20144 | 5985302.93210533 | 2112455.93467677 | 37.7795509437581 | -122.494463534746 | (37.7795509437581, -122.494463534746) | ||
| 139173 | 139173 | 60546 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 500 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | Permit Number 20156 | 5985047.62508393 | 2112456.532077 | 37.7795376389344 | -122.495346781978 | (37.7795376389344, -122.495346781978) | ||
| 150768 | 150768 | 60565 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 695 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 6 | Permit Number 20175 | 5985042.36004 | 2111233.42242 | 37.7761790231769 | -122.49527477111299 | (37.7761790231769, -122.495274771113) | |
| 156545 | 156545 | 60545 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 670 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 5 | Permit Number 20155 | 5985392.87012 | 2111306.3977799998 | 37.776399908318 | -122.49406765904 | (37.776399908318, -122.49406765904) | |
| 172759 | 172759 | 60538 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 559 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 11 | Permit Number 20148 | 5985322.95349 | 2112076.73738 | 37.778510948720495 | -122.494366313855 | (37.7785109487205, -122.494366313855) | |
| 180738 | 180738 | 73681 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 659 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 7 | 5985344.08684 | 2111396.3012599996 | 37.7766439029573 | -122.494243039831 | (37.7766439029573, -122.494243039831) | ||
| 45278 | 45278 | 50677 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 320 Clementina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2009 12:00:00 AM | 6 | 3x3 | Permit Number 53102 | 6011972.4253 | 2112821.65689 | 37.782079864123205 | -122.40222750461001 | (37.7820798641232, -122.40222750461) | |
| 150953 | 150953 | 50678 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 320 Clementina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2009 12:00:00 AM | 3 | 3x3 | Permit Number 53102 | 6011917.0823 | 2112771.09085 | 37.7819379322194 | -122.402415410739 | (37.7819379322194, -122.402415410739) | |
| 8644 | 8644 | 34950 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1928 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1997 12:00:00 AM | 8 | 3x3 | Permit Number 38548 | 6001980.6841 | 2115210.0928 | 37.7880751079735 | -122.43696537665501 | (37.7880751079735, -122.436965376655) | |
| 118759 | 118759 | 67813 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 953 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31467 | 6003797.921467501 | 2102718.11025253 | 37.7538782940035 | -122.42978670111602 | (37.7538782940035, -122.429786701116) | ||
| 139416 | 139416 | 67786 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3848 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31426 | 6004111.64552263 | 2102500.04040508 | 37.7532972858438 | -122.42868622607 | (37.7532972858438, -122.42868622607) | ||
| 144428 | 144428 | 63962 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1612 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31450 | 6002562.26815811 | 2100884.70804782 | 37.748774156632706 | -122.43392883235799 | (37.7487741566327, -122.433928832358) | ||
| 45876 | 45876 | 61206 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 154 Elmira St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1983 12:00:00 AM | 18 | Permit Number 21074 | 6011186.84016 | 2095845.15313 | 37.735422284496 | -122.403750383288 | (37.735422284496, -122.403750383288) | |
| 125660 | 125660 | 61221 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 187 Elmira St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1983 12:00:00 AM | Permit Number 21090 | 6011249.15974517 | 2095578.53600395 | 37.7346936913888 | -122.40351616800301 | (37.7346936913888, -122.403516168003) | ||
| 127064 | 127064 | 61220 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 183 Elmira St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1983 12:00:00 AM | Permit Number 21089 | 6011247.61241309 | 2095606.91351198 | 37.7347715236074 | -122.403523513548 | (37.7347715236074, -122.403523513548) | ||
| 133928 | 133928 | 65226 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 524 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2009 12:00:00 AM | 4 | 3x3 | Permit Number 53097 | 6002680.19388 | 2090186.8701 | 37.7194070306774 | -122.432756942099 | (37.7194070306774, -122.432756942099) | |
| 98002 | 98002 | 49004 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 59 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/2002 12:00:00 AM | Permit Number 46191 | 6004739.88754644 | 2101606.27997382 | 37.750878763286295 | -122.426450001276 | (37.7508787632863, -122.426450001276) | ||
| 142576 | 142576 | 48999 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 357 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/2002 12:00:00 AM | Permit Number 46186 | 6003635.52467204 | 2098620.28167702 | 37.7426174152586 | -122.430056004219 | (37.7426174152586, -122.430056004219) | ||
| 27720 | 27720 | 72005 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1963 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 5 | 5987221.7723 | 2101915.2958 | 37.7507213765199 | -122.487051188188 | (37.7507213765199, -122.487051188188) | ||
| 46952 | 46952 | 72003 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1991 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 4 | 5987539.672 | 2101751.7111 | 37.75029074773129 | -122.48593987171101 | (37.7502907477313, -122.485939871711) | ||
| 137488 | 137488 | 71038 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1959 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 2 | 5987222.8629 | 2101938.1977 | 37.7507843225586 | -122.487049098627 | (37.7507843225586, -122.487049098627) | ||
| 159655 | 159655 | 72221 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1927 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 6 | 5987523.8589 | 2102155.7654 | 37.7513992507221 | -122.486024209623 | (37.7513992507221, -122.486024209623) | ||
| 184983 | 184983 | 72002 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1987 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 4 | 5987538.0362 | 2101772.9771 | 37.7503490431313 | -122.485947089116 | (37.7503490431313, -122.485947089116) | ||
| 110573 | 110573 | 52403 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 160@ MISSION Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/2005 12:00:00 AM | Permit Number 48523 | 6006410.44276828 | 2097411.16509747 | 37.7394542204511 | -122.420375325019 | (37.7394542204511, -122.420375325019) | ||
| 100626 | 100626 | 44180 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1465 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2000 12:00:00 AM | Permit Number 43641 | 6004574.82619665 | 2100363.91635319 | 37.7474581884779 | -122.426932326868 | (37.7474581884779, -122.426932326868) | |||
| 88271 | 88271 | 67773 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 133 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1992 12:00:00 AM | Permit Number 31406 | 6002889.81317956 | 2107494.60296812 | 37.7669419272981 | -122.43326842768299 | (37.7669419272981, -122.433268427683) | ||
| 114365 | 114365 | 61729 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 153 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | 3 | 3x3 | Permit Number 21734 | 6004172.42149498 | 2100988.9495248003 | 37.7491516227222 | -122.428368357492 | (37.7491516227222, -122.428368357492) |
| 86107 | 86107 | 52385 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 73TA MARINA Gladys St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | Permit Number 48510 | 6005658.37290111 | 2097277.16869925 | 37.739043887482 | -122.422966135276 | (37.739043887482, -122.422966135276) | ||
| 92691 | 92691 | 52391 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 99X Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.42409409520599 | (37.7368773658256, -122.424094095206) |
| 99103 | 99103 | 52390 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 99X Park St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.42409409520599 | (37.7368773658256, -122.424094095206) |
| 119408 | 119408 | 52392 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 99X Park St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.42409409520599 | (37.7368773658256, -122.424094095206) |
| 145547 | 145547 | 52389 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 99X Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.42409409520599 | (37.7368773658256, -122.424094095206) |
| 146915 | 146915 | 52370 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 975 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 5 | Permit Number 48502 | 6007928.79422 | 2115121.18963 | 37.788167283347796 | -122.416379598764 | (37.7881672833478, -122.416379598764) | |
| 165330 | 165330 | 32168 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 400 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1996 12:00:00 AM | 6 | Permit Number 35510 | 6004141.09622 | 2110159.63618 | 37.7743303655916 | -122.429130480813 | (37.7743303655916, -122.429130480813) | |
| 11218 | 11218 | 68392 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 240 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779249 | 6001623.41455 | 2093933.0441299998 | 37.7296331848184 | -122.43667784142099 | (37.7296331848184, -122.436677841421) |
| 31401 | 31401 | 68521 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 708 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/2015 12:00:00 AM | 7 | Permit Number 775425 | 5995373.47149 | 2110684.12761 | 37.775270261614104 | -122.45949710563801 | (37.7752702616141, -122.459497105638) | |
| 90303 | 90303 | 103621 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3982 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2013 12:00:00 AM | 12 | 3x3 | Permit Number 771038 | 5995737.809859999 | 2114868.57006 | 37.7867805691894 | -122.458539756662 | (37.7867805691894, -122.458539756662) | |
| 107860 | 107860 | 81964 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 455 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2007 12:00:00 AM | 3x3 | Permit Number 50002 | 5982191.84204192 | 2112715.55923715 | 37.780081229053 | -122.505245190233 | (37.780081229053, -122.505245190233) | ||
| 51673 | 51673 | 50623 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 157 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2003 12:00:00 AM | 4 | Permit Number 47220 | 5996524.0851 | 2113313.9678 | 37.7825572019426 | -122.455707030451 | (37.7825572019426, -122.455707030451) | ||
| 57160 | 57160 | 46089 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2001 12:00:00 AM | 3 | Permit Number 44465 | 5989928.0373599995 | 2114622.7859900002 | 37.7857701098965 | -122.478621999998 | (37.7857701098965, -122.478621999998) | ||
| 37861 | 37861 | 42156 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 544 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53993 | 5989414.7005900005 | 2111630.63553 | 37.777524684762795 | -122.480178910626 | (37.7775246847628, -122.480178910626) |
| 83451 | 83451 | 60527 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 476 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1982 12:00:00 AM | Permit Number 20137 | 6003459.70182743 | 2099831.84460129 | 37.745934126876 | -122.430750388322 | (37.745934126876, -122.430750388322) | ||
| 84098 | 84098 | 60512 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1424 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1982 12:00:00 AM | Permit Number 20113 | 6003898.21360812 | 2099976.46367153 | 37.746356051842106 | -122.429244385061 | (37.7463560518421, -122.429244385061) |
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");