trees
6,714 rows where qSpecies_id = 7 sorted by PlantDate descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 61718 | 92970 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 3506 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2009 12:00:00 AM | 3x3 | Permit Number 53127 | 6003465.3 | 2106607.7 | 37.764539336845 | -122.431214598369 | (37.764539336845, -122.431214598369) | 15 | 4 | 5 | 28862 | 3 | ||
| 136681 | 39607 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 425 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41010 | 5998485.83180749 | 2106734.79631937 | 37.7646048701954 | -122.44844630961 | (37.7646048701954, -122.44844630961) | 15 | 5 | 11 | 29492 | 9 | ||
| 166580 | 39606 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 425 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41010 | 5998485.83180749 | 2106734.79631937 | 37.7646048701954 | -122.44844630961 | (37.7646048701954, -122.44844630961) | 15 | 5 | 11 | 29492 | 9 | ||
| 32215 | 35020 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1013 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1997 12:00:00 AM | 7 | Permit Number 38595 | 6012215.58628 | 2103654.42136 | 37.7569222759593 | -122.400742049433 | (37.7569222759593, -122.400742049433) | 10 | 3 | 8 | 28856 | 29 | ||
| 13977 | 68945 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 675 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 7 | Permit Number 32934 | 5989090.15811 | 2110735.87084 | 37.7750490464969 | -122.481236060656 | (37.7750490464969, -122.481236060656) | 11 | 6 | 2 | 55 | 26 | |
| 42754 | 68933 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 681 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 7 | Permit Number 32917 | 5992842.88545 | 2110833.13785 | 37.7755335724471 | -122.468261747786 | (37.7755335724471, -122.468261747786) | 11 | 6 | 2 | 54 | 11 | |
| 64834 | 68895 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2 Wheat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 6 | Permit Number 32867 | 6012134.32764 | 2091434.42813 | 37.7233642302644 | -122.400164870833 | (37.7233642302644, -122.400164870833) | 10 | 3 | 8 | 58 | 1 | |
| 64943 | 68892 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 40 Exeter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 7 | Permit Number 32864 | 6012556.44634 | 2091062.56254 | 37.7223666905441 | -122.398679591909 | (37.7223666905441, -122.398679591909) | 10 | 3 | 8 | 58 | 1 | |
| 74895 | 68891 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 36 Exeter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | Permit Number 32863 | 6012558.723351 | 2091084.70468571 | 37.7224276152533 | -122.398673273848 | (37.7224276152533, -122.398673273848) | 10 | 3 | 8 | 58 | 1 | ||
| 90013 | 68940 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 454 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 6 | Permit Number 32926 | 5989392.15436 | 2112242.86267 | 37.7792043799748 | -122.480301726508 | (37.7792043799748, -122.480301726508) | 11 | 6 | 2 | 55 | 26 | |
| 118825 | 68879 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1741 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | Permit Number 32850 | 5993705.24231741 | 2103645.69057472 | 37.7558484998294 | -122.464756614096 | (37.7558484998294, -122.464756614096) | 1 | 8 | 4 | 56 | 12 | ||
| 176240 | 68912 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Florence St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 8 | Permit Number 32890 | 6008496.87073 | 2118345.67653 | 37.7970528621676 | -122.41464241973 | (37.7970528621676, -122.41464241973) | 5 | 1 | 10 | 308 | 21 | |
| 184896 | 68925 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2124 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 8 | Permit Number 32909 | 5992060.17158 | 2112059.99244 | 37.7788569437678 | -122.471058716214 | (37.7788569437678, -122.471058716214) | 11 | 6 | 2 | 54 | 11 | |
| 109568 | 67822 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 519 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1992 12:00:00 AM | 9 | Permit Number 31478 | 6011808.76058 | 2105938.99653 | 37.763172512922 | -122.402309638787 | (37.763172512922, -122.402309638787) | 8 | 3 | 8 | 28856 | 29 | ||
| 11979 | 60584 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1531 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 8 | Permit Number 20201 | 6000391.1057 | 2110950.8694 | 37.7762898982244 | -122.442159163176 | (37.7762898982244, -122.442159163176) | 15 | 5 | 11 | 29492 | 16 | |
| 60401 | 196201 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Freelon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2017 12:00:00 AM | 3 | Width 2ft | 6013661.85599 | 2111812.39055 | 37.7794028063227 | -122.396312039369 | (37.7794028063227, -122.396312039369) | 6 | 2 | 9 | 28856 | 34 | ||
| 133096 | 100885 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 91 Welsh St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2017 12:00:00 AM | 3 | 3x3 | 6013481.27468 | 2111873.98359 | 37.7795618766263 | -122.396941070175 | (37.7795618766263, -122.396941070175) | 6 | 2 | 9 | 28856 | 34 | ||
| 157555 | 196195 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 36 Zoe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2017 12:00:00 AM | 3 | Width 2ft | 6013679.40848 | 2112034.51402 | 37.7800136834307 | -122.396266889798 | (37.7800136834307, -122.396266889798) | 6 | 2 | 9 | 28856 | 34 | ||
| 172527 | 196200 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Freelon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2017 12:00:00 AM | 3 | Width 2ft | 6013682.55541 | 2111829.59348 | 37.7794511934496 | -122.396241636866 | (37.7794511934496, -122.396241636866) | 6 | 2 | 9 | 28856 | 34 | ||
| 148191 | 32469 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 124 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2016 12:00:00 AM | 3 | Permit Number 779287 | 6000593 | 2105649 | 37.7617437934708 | -122.441080293978 | (37.7617437934708, -122.441080293978) | 15 | 5 | 5 | 28862 | 3 | |
| 129189 | 72979 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1451 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2010 12:00:00 AM | 2 | Permit Number 54060 | 5988344.3187 | 2105426.2097 | 37.7604267896985 | -122.483426724107 | (37.7604267896985, -122.483426724107) | 1 | 8 | 3 | 56 | 35 | ||
| 175093 | 95125 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 91 Rotteck St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 5 | 3x3 | Permit Number 54053 | 6003379.33035 | 2094579.25553 | 37.731507167824 | -122.430653552813 | (37.731507167824, -122.430653552813) | 9 | 7 | 5 | 28861 | 25 |
| 180940 | 95116 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 67 Cotter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 5 | 3x3 | Permit Number 54043 | 6002297.43224 | 2093241.3314 | 37.727772179934 | -122.43429826137 | (37.727772179934, -122.43429826137) | 9 | 7 | 6 | 28861 | 25 |
| 3097 | 52514 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 145 Naglee Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.2402014 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | 9 | 7 | 6 | 28861 | 25 | ||
| 34143 | 52499 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 206 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48608 | 6007090.91316375 | 2097005.21766224 | 37.7383779008303 | -122.417993780802 | (37.7383779008303, -122.417993780802) | 2 | 7 | 7 | 28859 | 2 | ||
| 50091 | 52525 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 115 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | 5 | Permit Number 48625 | 6000708.29833 | 2092511.57988 | 37.7256781220367 | -122.439739616589 | (37.7256781220367, -122.439739616589) | 9 | 7 | 6 | 28861 | 25 | |
| 55937 | 52515 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 145 Naglee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.2402014 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | 9 | 7 | 6 | 28861 | 25 | ||
| 56240 | 52518 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 145 Naglee Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.2402014 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | 9 | 7 | 6 | 28861 | 25 | ||
| 59918 | 52495 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 599 Moultrie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2005 12:00:00 AM | Permit Number 48604 | 6007698.78842616 | 2096579.30794213 | 37.7372426398673 | -122.415861888023 | (37.7372426398673, -122.415861888023) | 2 | 7 | 7 | 28859 | 2 | |||
| 67749 | 52517 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 145 Naglee Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.2402014 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | 9 | 7 | 6 | 28861 | 25 | ||
| 111018 | 62924 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 599 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48604 | 6007698.78842616 | 2096579.30794213 | 37.7372426398673 | -122.415861888023 | (37.7372426398673, -122.415861888023) | 2 | 7 | 7 | 28859 | 2 | ||
| 148271 | 52516 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 145 Naglee Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.2402014 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | 9 | 7 | 6 | 28861 | 25 | ||
| 38570 | 46184 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 841 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2001 12:00:00 AM | Permit Number 44511 | 5997623.38792866 | 2107669.89260679 | 37.7671230587207 | -122.451496709211 | (37.7671230587207, -122.451496709211) | 15 | 5 | 11 | 29492 | 9 | ||
| 125508 | 46170 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 22 Hillway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2001 12:00:00 AM | Permit Number 44499 | 5996115.83466209 | 2106813.26166937 | 37.7646845265696 | -122.456649119677 | (37.7646845265696, -122.456649119677) | 15 | 5 | 11 | 29492 | 12 | ||
| 129333 | 46185 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 845 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2001 12:00:00 AM | Permit Number 44512 | 5997625.24396619 | 2107656.90958664 | 37.7670875169447 | -122.451489352946 | (37.7670875169447, -122.451489352946) | 15 | 5 | 11 | 29492 | 9 | ||
| 152356 | 46172 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 34 Hillway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2001 12:00:00 AM | Permit Number 44501 | 5996117.8602941 | 2106765.38589744 | 37.7645531883122 | -122.456638651029 | (37.7645531883122, -122.456638651029) | 15 | 5 | 11 | 29492 | 12 | ||
| 5753 | 39480 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 890 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 7 | Permit Number 40940 | 6012732.47578 | 2103336.91838 | 37.7560792982424 | -122.3989321566 | (37.7560792982424, -122.3989321566) | 10 | 3 | 8 | 28856 | 29 | |
| 56088 | 39510 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 971 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40962 | 6003803.3913976 | 2102619.59957595 | 37.7536081166409 | -122.429760759024 | (37.7536081166409, -122.429760759024) | 2 | 4 | 5 | 28862 | 22 | ||
| 54879 | 68854 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 296 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32817 | 5998798.41525763 | 2094112.17808977 | 37.7299640953596 | -122.446457004656 | (37.7299640953596, -122.446457004656) | 9 | 7 | 4 | 28861 | 40 | ||
| 77245 | 6391 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 16 Espanola St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2007 12:00:00 AM | 6 | 3X3 | 6018056.47068 | 2094273.68663 | 37.7314887164161 | -122.379890092347 | (37.7314887164161, -122.379890092347) | 10 | 3 | 8 | 58 | 1 | ||
| 12492 | 52458 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 557@ ANZA 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2005 12:00:00 AM | Permit Number 48569 | 5992189.6387529 | 2111651.23752465 | 37.7777421013838 | -122.470581063094 | (37.7777421013838, -122.470581063094) | 11 | 6 | 2 | 54 | 11 | ||
| 173938 | 52467 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 623@ BALBOA 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2005 12:00:00 AM | Permit Number 48578 | 5993135.59943115 | 2111227.85704239 | 37.7766342667752 | -122.467277895236 | (37.7766342667752, -122.467277895236) | 11 | 6 | 2 | 54 | 11 | ||
| 47745 | 237505 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 932 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 781043 | 6003738.00119 | 2102839.48332 | 37.7542081624992 | -122.430002576781 | (37.7542081624992, -122.430002576781) | 2 | 4 | 5 | 28862 | 22 | |
| 33146 | 108559 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 247 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773718 | 6001785.96966 | 2094072.85918 | 37.7300263216596 | -122.436125873507 | (37.7300263216596, -122.436125873507) | 9 | 7 | 6 | 28861 | 25 |
| 118072 | 26635 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 359 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/24/1998 12:00:00 AM | 3 | 3X3 | 6005539.477 | 2106921.88393 | 37.7655193351826 | -122.42406291888 | (37.7655193351826, -122.42406291888) | 8 | 4 | 5 | 28853 | 19 | ||
| 50478 | 52448 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 431 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | 4 | Permit Number 48560 | 5992472.90838 | 2112504.99178 | 37.780102654065 | -122.469663313675 | (37.780102654065, -122.469663313675) | 11 | 6 | 2 | 54 | 11 | |
| 155707 | 35166 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 513 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/2015 12:00:00 AM | 6 | Permit Number 38699 | 6002123.1918 | 2110352.0553 | 37.7747442642137 | -122.436124546974 | (37.7747442642137, -122.436124546974) | 15 | 5 | 11 | 29492 | 10 | |
| 30048 | 81703 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 728 20th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | 10 | 3 | 8 | 28856 | 29 | ||
| 96209 | 81707 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 728 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | 10 | 3 | 8 | 28856 | 29 | ||
| 110110 | 81708 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 728 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | 10 | 3 | 8 | 28856 | 29 | ||
| 116918 | 81706 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 728 20th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | 10 | 3 | 8 | 28856 | 29 | ||
| 121847 | 81709 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 728 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | 10 | 3 | 8 | 28856 | 29 | ||
| 132299 | 81705 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 728 20th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | 10 | 3 | 8 | 28856 | 29 | ||
| 156589 | 81704 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 728 20th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | 10 | 3 | 8 | 28856 | 29 | ||
| 173350 | 81702 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 728 20th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | 10 | 3 | 8 | 28856 | 29 | ||
| 83275 | 39347 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 342 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/1998 12:00:00 AM | Permit Number 40909 | 6007174.26983946 | 2105316.44942149 | 37.761203350476 | -122.418294687848 | (37.761203350476, -122.418294687848) | 2 | 4 | 7 | 28859 | 19 | ||
| 119416 | 39348 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 342 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40909 | 6007174.26983946 | 2105316.44942149 | 37.761203350476 | -122.418294687848 | (37.761203350476, -122.418294687848) | 2 | 4 | 7 | 28859 | 19 | |||
| 126240 | 34197 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 15 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/1998 12:00:00 AM | Permit Number 40888 | 6006506.82888523 | 2108404.56366519 | 37.7696449914082 | -122.42082233238 | (37.7696449914082, -122.42082233238) | 8 | 4 | 7 | 28853 | 19 | ||
| 130259 | 39360 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 411 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/1998 12:00:00 AM | Permit Number 40915 | 6007248.60489953 | 2104914.77803867 | 37.7601046380159 | -122.418009118268 | (37.7601046380159, -122.418009118268) | 2 | 4 | 7 | 28859 | 19 | ||
| 12301 | 81771 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 118 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2007 12:00:00 AM | 7 | 3x3 | Permit Number 50018 | 6009093.57763 | 2112998.11082 | 37.7824032504549 | -122.41219952199 | (37.7824032504549, -122.41219952199) | 14 | 10 | 9 | 28852 | 36 | |
| 108231 | 53767 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 280 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2007 12:00:00 AM | 3x3 | Permit Number 50032 | 5992868.31748404 | 2094997.91347506 | 37.7320556132636 | -122.467022262159 | (37.7320556132636, -122.467022262159) | 9 | 8 | 4 | 59 | 40 | ||
| 109120 | 81929 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 118 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2007 12:00:00 AM | 6 | 3x3 | Permit Number 50018 | 6009095.92555 | 2112986.00249 | 37.7823701356165 | -122.412190543152 | (37.7823701356165, -122.412190543152) | 14 | 10 | 9 | 28852 | 36 | |
| 22241 | 60556 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 642 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1982 12:00:00 AM | Permit Number 20166 | 5985080.35984143 | 2111485.8092912 | 37.7768742299218 | -122.495161937272 | (37.7768742299218, -122.495161937272) | 11 | 6 | 2 | 55 | 26 | ||
| 23752 | 60534 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 503 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1982 12:00:00 AM | Permit Number 20144 | 5985302.93210533 | 2112455.93467677 | 37.7795509437581 | -122.494463534746 | (37.7795509437581, -122.494463534746) | 11 | 6 | 2 | 55 | 26 | ||
| 35322 | 60548 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 511 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1982 12:00:00 AM | Permit Number 20158 | 5984997.83219607 | 2112387.91202298 | 37.7793463125181 | -122.495513971823 | (37.7793463125181, -122.495513971823) | 11 | 6 | 2 | 55 | 26 | ||
| 188082 | 60546 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 500 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1982 12:00:00 AM | Permit Number 20156 | 5985047.62508393 | 2112456.532077 | 37.7795376389344 | -122.495346781978 | (37.7795376389344, -122.495346781978) | 11 | 6 | 2 | 55 | 26 | ||
| 45017 | 50678 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 320 Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2009 12:00:00 AM | 3 | 3x3 | Permit Number 53102 | 6011917.0823 | 2112771.09085 | 37.7819379322194 | -122.402415410739 | (37.7819379322194, -122.402415410739) | 6 | 2 | 9 | 28853 | 34 | |
| 83063 | 50677 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 320 Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2009 12:00:00 AM | 6 | 3x3 | Permit Number 53102 | 6011972.4253 | 2112821.65689 | 37.7820798641232 | -122.40222750461 | (37.7820798641232, -122.40222750461) | 6 | 2 | 9 | 28853 | 34 | |
| 27713 | 34950 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1928 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/1997 12:00:00 AM | 8 | 3x3 | Permit Number 38548 | 6001980.6841 | 2115210.0928 | 37.7880751079735 | -122.436965376655 | (37.7880751079735, -122.436965376655) | 13 | 6 | 1 | 29490 | 27 | |
| 151955 | 67813 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 953 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31467 | 6003797.9214675 | 2102718.11025253 | 37.7538782940035 | -122.429786701116 | (37.7538782940035, -122.429786701116) | 2 | 4 | 5 | 28862 | 22 | ||
| 177715 | 63962 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1612 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31450 | 6002562.26815811 | 2100884.70804782 | 37.7487741566327 | -122.433928832358 | (37.7487741566327, -122.433928832358) | 2 | 4 | 5 | 28862 | 22 | ||
| 180022 | 67786 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 3848 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31426 | 6004111.64552263 | 2102500.04040508 | 37.7532972858438 | -122.42868622607 | (37.7532972858438, -122.42868622607) | 2 | 4 | 5 | 28862 | 22 | ||
| 20946 | 61220 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 183 Elmira St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1983 12:00:00 AM | Permit Number 21089 | 6011247.61241309 | 2095606.91351198 | 37.7347715236074 | -122.403523513548 | (37.7347715236074, -122.403523513548) | 10 | 3 | 8 | 58 | 1 | ||
| 28872 | 61221 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 187 Elmira St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1983 12:00:00 AM | Permit Number 21090 | 6011249.15974517 | 2095578.53600395 | 37.7346936913888 | -122.403516168003 | (37.7346936913888, -122.403516168003) | 10 | 3 | 8 | 58 | 1 | ||
| 114497 | 65226 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 524 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2009 12:00:00 AM | 4 | 3x3 | Permit Number 53097 | 6002680.19388 | 2090186.8701 | 37.7194070306774 | -122.432756942099 | (37.7194070306774, -122.432756942099) | 9 | 7 | 6 | 28861 | 5 | |
| 105595 | 49004 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 59 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/2002 12:00:00 AM | Permit Number 46191 | 6004739.88754644 | 2101606.27997382 | 37.7508787632863 | -122.426450001276 | (37.7508787632863, -122.426450001276) | 2 | 4 | 5 | 28862 | 22 | ||
| 181490 | 48999 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 357 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/2002 12:00:00 AM | Permit Number 46186 | 6003635.52467204 | 2098620.28167702 | 37.7426174152586 | -122.430056004219 | (37.7426174152586, -122.430056004219) | 2 | 7 | 5 | 63 | 22 | ||
| 138516 | 52403 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 160@ MISSION Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/2005 12:00:00 AM | Permit Number 48523 | 6006410.44276828 | 2097411.16509747 | 37.7394542204511 | -122.420375325019 | (37.7394542204511, -122.420375325019) | 2 | 7 | 7 | 28859 | 2 | ||
| 100451 | 44180 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1465 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2000 12:00:00 AM | Permit Number 43641 | 6004574.82619665 | 2100363.91635319 | 37.7474581884779 | -122.426932326868 | (37.7474581884779, -122.426932326868) | 2 | 7 | 5 | 63 | 22 | |||
| 67859 | 67773 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 133 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1992 12:00:00 AM | Permit Number 31406 | 6002889.81317956 | 2107494.60296812 | 37.7669419272981 | -122.433268427683 | (37.7669419272981, -122.433268427683) | 15 | 5 | 5 | 28862 | 3 | ||
| 133377 | 61729 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 153 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | 3 | 3x3 | Permit Number 21734 | 6004172.42149498 | 2100988.9495248 | 37.7491516227222 | -122.428368357492 | (37.7491516227222, -122.428368357492) | 2 | 4 | 5 | 28862 | 22 |
| 63051 | 52385 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 73TA MARINA Gladys St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | Permit Number 48510 | 6005658.37290111 | 2097277.16869925 | 37.739043887482 | -122.422966135276 | (37.739043887482, -122.422966135276) | 2 | 7 | 7 | 28859 | 2 | ||
| 76518 | 52391 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 99X Park St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.424094095206 | (37.7368773658256, -122.424094095206) | 2 | 7 | 7 | 28859 | 2 |
| 96297 | 52390 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 99X Park St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.424094095206 | (37.7368773658256, -122.424094095206) | 2 | 7 | 7 | 28859 | 2 |
| 156134 | 52392 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 99X Park St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.424094095206 | (37.7368773658256, -122.424094095206) | 2 | 7 | 7 | 28859 | 2 |
| 178781 | 52370 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 975 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 5 | Permit Number 48502 | 6007928.79422 | 2115121.18963 | 37.7881672833478 | -122.416379598764 | (37.7881672833478, -122.416379598764) | 13 | 1 | 10 | 28858 | 21 | |
| 190179 | 52389 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 99X Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.424094095206 | (37.7368773658256, -122.424094095206) | 2 | 7 | 7 | 28859 | 2 |
| 67732 | 68521 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 708 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/2015 12:00:00 AM | 7 | Permit Number 775425 | 5995373.47149 | 2110684.12761 | 37.7752702616141 | -122.459497105638 | (37.7752702616141, -122.459497105638) | 11 | 6 | 2 | 54 | 11 | |
| 38736 | 103621 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3982 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2013 12:00:00 AM | 12 | 3x3 | Permit Number 771038 | 5995737.80986 | 2114868.57006 | 37.7867805691894 | -122.458539756662 | (37.7867805691894, -122.458539756662) | 11 | 6 | 1 | 54 | 31 | |
| 124506 | 81964 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 455 44th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2007 12:00:00 AM | 3x3 | Permit Number 50002 | 5982191.84204192 | 2112715.55923715 | 37.780081229053 | -122.505245190233 | (37.780081229053, -122.505245190233) | 11 | 6 | 2 | 55 | 26 | ||
| 80943 | 50623 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 157 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2003 12:00:00 AM | 4 | Permit Number 47220 | 5996524.0851 | 2113313.9678 | 37.7825572019426 | -122.455707030451 | (37.7825572019426, -122.455707030451) | 11 | 6 | 1 | 54 | 31 | ||
| 190876 | 46089 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2001 12:00:00 AM | 3 | Permit Number 44465 | 5989928.03736 | 2114622.78599 | 37.7857701098965 | -122.478621999998 | (37.7857701098965, -122.478621999998) | 11 | 6 | 2 | 55 | 26 | ||
| 147098 | 42156 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 544 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53993 | 5989414.70059 | 2111630.63553 | 37.7775246847628 | -122.480178910626 | (37.7775246847628, -122.480178910626) | 11 | 6 | 2 | 55 | 26 |
| 10011 | 60550 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 538 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/1982 12:00:00 AM | 4 | Permit Number 20160 | 5985052.81447 | 2112190.69486 | 37.7788080303748 | -122.495309219696 | (37.7788080303748, -122.495309219696) | 11 | 6 | 2 | 55 | 26 | |
| 10074 | 60538 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 559 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/1982 12:00:00 AM | 11 | Permit Number 20148 | 5985322.95349 | 2112076.73738 | 37.7785109487205 | -122.494366313855 | (37.7785109487205, -122.494366313855) | 11 | 6 | 2 | 55 | 26 | |
| 16887 | 60565 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 695 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/1982 12:00:00 AM | 6 | Permit Number 20175 | 5985042.36004 | 2111233.42242 | 37.7761790231769 | -122.495274771113 | (37.7761790231769, -122.495274771113) | 11 | 6 | 2 | 55 | 26 | |
| 19044 | 60545 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 670 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/1982 12:00:00 AM | 5 | Permit Number 20155 | 5985392.87012 | 2111306.39778 | 37.776399908318 | -122.49406765904 | (37.776399908318, -122.49406765904) | 11 | 6 | 2 | 55 | 26 | |
| 45984 | 60527 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 476 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1982 12:00:00 AM | Permit Number 20137 | 6003459.70182743 | 2099831.84460129 | 37.745934126876 | -122.430750388322 | (37.745934126876, -122.430750388322) | 2 | 7 | 5 | 63 | 22 | ||
| 56618 | 60512 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1424 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1982 12:00:00 AM | Permit Number 20113 | 6003898.21360812 | 2099976.46367153 | 37.7463560518421 | -122.429244385061 | (37.7463560518421, -122.429244385061) | 2 | 7 | 5 | 63 | 22 | ||
| 94991 | 60511 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1408 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1982 12:00:00 AM | Permit Number 20112 | 6003893.1313927 | 2100068.18986719 | 37.7466076229898 | -122.429268498366 | (37.7466076229898, -122.429268498366) | 2 | 7 | 5 | 63 | 22 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );