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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 75037 | 75037 | 68955 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 790 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 4 | Permit Number 32944 | 5988860.14903 | 2109950.32052 | 37.7728787684605 | -122.481974145233 | (37.7728787684605, -122.481974145233) | |
| 75324 | 75324 | 122125 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 109 16th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990812.11385 | 2114674.53706 | 37.785963493705104 | -122.475567156694 | (37.7859634937051, -122.475567156694) | |||
| 76415 | 76415 | 185737 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2134 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986377.6988 | 2100714.0842 | 37.7473739221204 | -122.489881691592 | (37.7473739221204, -122.489881691592) | |||
| 79516 | 79516 | 45755 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 27 Liberty St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2001 12:00:00 AM | Permit Number 44402 | 6006135.85394887 | 2104023.0641993 | 37.757593509181206 | -122.421794258753 | (37.7575935091812, -122.421794258753) | |||
| 79842 | 79842 | 13239 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 2335X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001220.6637699995 | 2119285.5724400003 | 37.799222084037396 | -122.439887231455 | (37.7992220840374, -122.439887231455) | |||
| 81134 | 81134 | 34127 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1401 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37983 | 5995840.26429469 | 2093321.75315516 | 37.7276243745144 | -122.45662648597799 | (37.7276243745144, -122.456626485978) | ||
| 81300 | 81300 | 56269 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 27 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2001 12:00:00 AM | Permit Number 44402 | 6006135.85394887 | 2104023.0641993 | 37.757593509181206 | -122.421794258753 | (37.7575935091812, -122.421794258753) | |||
| 81355 | 81355 | 85264 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 3000 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2007 12:00:00 AM | Permit Number 49557 | 5989530.4 | 2095609.1 | 37.73354054474329 | -122.478606721292 | (37.7335405447433, -122.478606721292) | |||
| 82253 | 82253 | 64675 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 827 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1988 12:00:00 AM | Permit Number 25611 | 6005699.53822151 | 2104160.47613012 | 37.7579461954401 | -122.423312985478 | (37.7579461954401, -122.423312985478) | ||
| 83360 | 83360 | 51865 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 141 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2005 12:00:00 AM | Permit Number 48086 | 6001731.90100781 | 2108013.17914536 | 37.768300053668206 | -122.43731059058001 | (37.7683000536682, -122.43731059058) | |||
| 83673 | 83673 | 44322 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 3101 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2001 12:00:00 AM | Permit Number 43712 | 6007112.977014599 | 2100542.34949089 | 37.7480913155606 | -122.418168196056 | (37.7480913155606, -122.418168196056) | |||
| 84815 | 84815 | 51422 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 655 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52282 | 6013199.59186321 | 2110555.37408537 | 37.7759255920049 | -122.397823019146 | (37.7759255920049, -122.397823019146) | ||
| 85015 | 85015 | 63672 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 370 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2015 12:00:00 AM | 3 | Permit Number 24323 | 6004106.96627638 | 2100160.80457488 | 37.7468740249128 | -122.42853568027901 | (37.7468740249128, -122.428535680279) | ||
| 86250 | 86250 | 67526 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1301 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/1992 12:00:00 AM | Permit Number 31064 | 6013774.38377619 | 2105211.91246173 | 37.761285626876 | -122.395460215282 | (37.761285626876, -122.395460215282) | ||
| 89647 | 89647 | 424 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1901X Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5989549.9462 | 2114680.6916799997 | 37.7859071433722 | -122.479934312872 | (37.7859071433722, -122.479934312872) | |||
| 90800 | 90800 | 59573 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 964 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/1981 12:00:00 AM | Permit Number 18963 | 6003107.75578888 | 2102621.90086172 | 37.753575019284206 | -122.432166582864 | (37.7535750192842, -122.432166582864) | ||
| 91391 | 91391 | 63685 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1488 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1987 12:00:00 AM | Permit Number 24342 | 6003919.51862242 | 2099605.68059427 | 37.7453391734545 | -122.429144281616 | (37.7453391734545, -122.429144281616) | ||
| 91618 | 91618 | 44326 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 3101 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2001 12:00:00 AM | Permit Number 43712 | 6007112.977014599 | 2100542.34949089 | 37.7480913155606 | -122.418168196056 | (37.7480913155606, -122.418168196056) | |||
| 92265 | 92265 | 63662 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 3929 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1987 12:00:00 AM | Permit Number 24311 | 6004353.00566134 | 2100414.81780831 | 37.747585407013204 | -122.427702994 | (37.7475854070132, -122.427702994) | ||
| 92643 | 92643 | 246192 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 755 Buena Vista Ave West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999893.4495 | 2108060.1682 | 37.7683243897923 | -122.44367297370701 | (37.7683243897923, -122.443672973707) | |||
| 93396 | 93396 | 44237 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 415 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2001 12:00:00 AM | Permit Number 43676 | 6001527.40561887 | 2103403.09040324 | 37.755630249317 | -122.43768771219801 | (37.755630249317, -122.437687712198) | |||
| 93442 | 93442 | 60386 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1432 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1982 12:00:00 AM | Permit Number 19966 | 6015791.47503069 | 2094604.97930734 | 37.732273173852896 | -122.38774379220101 | (37.7322731738529, -122.387743792201) | ||
| 93684 | 93684 | 40825 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 695 05th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1999 12:00:00 AM | Permit Number 41762 | 6013368.81391754 | 2110378.20910645 | 37.7754485595516 | -122.39722520599 | (37.7754485595516, -122.39722520599) | |||
| 93729 | 93729 | 65661 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 76 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1990 12:00:00 AM | Permit Number 28581 | 5999609.85654862 | 2095526.3392082 | 37.733893364416794 | -122.44375332049101 | (37.7338933644168, -122.443753320491) | ||
| 94756 | 94756 | 64804 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1476 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1989 12:00:00 AM | Permit Number 25803 | 6003915.51476447 | 2099673.7745449 | 37.7455259170349 | -122.42916298071 | (37.7455259170349, -122.42916298071) | ||
| 95318 | 95318 | 64834 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 552 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/1989 12:00:00 AM | Permit Number 25843 | 6002326.41169322 | 2099472.15020661 | 37.74488221778179 | -122.434643430049 | (37.7448822177818, -122.434643430049) | ||
| 95540 | 95540 | 44069 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 45 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 43593 | 6002668.59972375 | 2105639.21740039 | 37.761834937896 | -122.433900935359 | (37.761834937896, -122.433900935359) | ||||
| 95757 | 95757 | 67744 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1460 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1992 12:00:00 AM | Permit Number 31363 | 5994310.57601305 | 2105578.84704093 | 37.7611913298083 | -122.462803426682 | (37.7611913298083, -122.462803426682) | ||
| 95806 | 95806 | 50189 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 350 Noriega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2003 12:00:00 AM | Permit Number 46896 | 5992966.98430504 | 2103249.49310039 | 37.7547180534592 | -122.467280921215 | (37.7547180534592, -122.467280921215) | |||
| 95884 | 95884 | 60515 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 255 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1989 12:00:00 AM | Permit Number 25818 | 6004877.54107387 | 2099860.14096955 | 37.7460920491494 | -122.42584970458401 | (37.7460920491494, -122.425849704584) | ||
| 96084 | 96084 | 65677 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 25 Sequoia Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1990 12:00:00 AM | Permit Number 28597 | 5998247.19530514 | 2097659.9759073 | 37.739674003576106 | -122.448618049723 | (37.7396740035761, -122.448618049723) | ||
| 96306 | 96306 | 63785 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 4007 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24470 | 6003796.64349499 | 2101262.51482532 | 37.7498814982247 | -122.42968731122 | (37.7498814982247, -122.42968731122) | ||
| 96568 | 96568 | 60791 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 276 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1983 12:00:00 AM | Permit Number 20465 | 5998453.93543616 | 2112227.70718861 | 37.779685173955706 | -122.44895233828001 | (37.7796851739557, -122.44895233828) | ||
| 97595 | 97595 | 39133 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 786 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1999 12:00:00 AM | Permit Number 40812 | 6007317.12360596 | 2102737.01571967 | 37.754128859482606 | -122.417617789975 | (37.7541288594826, -122.417617789975) | ||
| 97645 | 97645 | 98122 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 900 York St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774687 | 6009897.0 | 2103882.5 | 37.7574189360449 | -122.40877671518999 | (37.7574189360449, -122.40877671519) | |
| 97844 | 97844 | 64368 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 416 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1988 12:00:00 AM | Permit Number 25207 | 6010971.78233994 | 2119344.22600524 | 37.7999333725763 | -122.406148966564 | (37.7999333725763, -122.406148966564) | ||
| 98072 | 98072 | 46607 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1166 Noriega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2002 12:00:00 AM | Permit Number 44731 | 5990419.11281219 | 2103161.32215556 | 37.754328547559204 | -122.476085621892 | (37.7543285475592, -122.476085621892) | |||
| 98138 | 98138 | 60911 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 9 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1983 12:00:00 AM | Permit Number 20703 | 5995767.191933099 | 2107036.52457374 | 37.7652775252135 | -122.457871132491 | (37.7652775252135, -122.457871132491) | ||
| 98780 | 98780 | 65676 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 29 Sequoia Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1990 12:00:00 AM | Permit Number 28596 | 5998246.67335369 | 2097607.91153994 | 37.7395310174996 | -122.44861610559799 | (37.7395310174996, -122.448616105598) | ||
| 99388 | 99388 | 65675 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 35 Sequoia Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1990 12:00:00 AM | Permit Number 28595 | 5998245.89042686 | 2097529.81502266 | 37.7393165384712 | -122.448613189427 | (37.7393165384712, -122.448613189427) | ||
| 99633 | 99633 | 109267 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 900 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774687 | 6009897.0 | 2103882.5 | 37.7574189360449 | -122.40877671518999 | (37.7574189360449, -122.40877671519) | |
| 99805 | 99805 | 1641 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 859 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5995651.21865 | 2110512.9681 | 37.774816268938 | -122.45852392834499 | (37.774816268938, -122.458523928345) | |||
| 100096 | 100096 | 63655 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1374 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1987 12:00:00 AM | Permit Number 24302 | 6003882.00730683 | 2100268.96113166 | 37.747158264512 | -122.429321278666 | (37.747158264512, -122.429321278666) | ||
| 100493 | 100493 | 109293 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 370 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6004104.9 | 2100171.3 | 37.7469027259862 | -122.42854357326401 | (37.7469027259862, -122.428543573264) | |||||
| 100822 | 100822 | 46606 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1166 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2002 12:00:00 AM | Permit Number 44731 | 5990419.11281219 | 2103161.32215556 | 37.754328547559204 | -122.476085621892 | (37.7543285475592, -122.476085621892) | |||
| 101283 | 101283 | 65345 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 182 Lippard Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | Permit Number 28177 | 6001753.2001687 | 2095039.63295635 | 37.7326789990165 | -122.43630832371001 | (37.7326789990165, -122.43630832371) | ||
| 101995 | 101995 | 63684 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1477 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1987 12:00:00 AM | Permit Number 24341 | 6003967.42510642 | 2099676.82682244 | 37.7455372363545 | -122.428983700412 | (37.7455372363545, -122.428983700412) | ||
| 102402 | 102402 | 63680 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1290 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1987 12:00:00 AM | Permit Number 24335 | 6003854.79358898 | 2100760.12330994 | 37.7485053408812 | -122.42945040251001 | (37.7485053408812, -122.42945040251) | ||
| 102870 | 102870 | 30499 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 2468 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778856 | 6001812.59982079 | 2117366.46102333 | 37.793986382856104 | -122.437701414239 | (37.7939863828561, -122.437701414239) | |
| 103738 | 103738 | 49555 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 71REVISED Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2003 12:00:00 AM | Permit Number 46444 | 6009365.93611768 | 2097039.29774225 | 37.7385992569024 | -122.41013023532899 | (37.7385992569024, -122.410130235329) | |||
| 103842 | 103842 | 63666 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 4019 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1987 12:00:00 AM | Permit Number 24316 | 6003771.80904203 | 2100383.61201619 | 37.7474668298055 | -122.42971051138001 | (37.7474668298055, -122.42971051138) | ||
| 104280 | 104280 | 48404 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 229 States St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2002 12:00:00 AM | Permit Number 45785 | 6000714.62430191 | 2106535.28548397 | 37.764184241687204 | -122.440723221205 | (37.7641842416872, -122.440723221205) | |||
| 105469 | 105469 | 23662 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 311 Virginia Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 12 | 6006938.1768512 | 2098312.3803834 | 37.7419584813283 | -122.41861453896999 | (37.7419584813283, -122.41861453897) | |||
| 105662 | 105662 | 64408 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 80 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/02/1988 12:00:00 AM | Permit Number 25254 | 6010509.94669729 | 2100012.34807199 | 37.7468266663579 | -122.406384201378 | (37.7468266663579, -122.406384201378) | ||
| 105695 | 105695 | 98667 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 396 Townsend St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013391.9 | 2110381.0 | 37.7754575079339 | -122.397145540942 | (37.7754575079339, -122.397145540942) | ||||
| 106268 | 106268 | 45342 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 466 Ralston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/27/2001 12:00:00 AM | Permit Number 44172 | 5992247.31717609 | 2090977.05466926 | 37.720979464776896 | -122.46887668176001 | (37.7209794647769, -122.46887668176) | ||
| 107435 | 107435 | 85263 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 3000 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2007 12:00:00 AM | Permit Number 49557 | 5989530.4 | 2095609.1 | 37.73354054474329 | -122.478606721292 | (37.7335405447433, -122.478606721292) | |||
| 109435 | 109435 | 46605 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1166 Noriega St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2002 12:00:00 AM | Permit Number 44731 | 5990419.11281219 | 2103161.32215556 | 37.754328547559204 | -122.476085621892 | (37.7543285475592, -122.476085621892) | |||
| 109623 | 109623 | 63670 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1480 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1987 12:00:00 AM | Permit Number 24320 | 6003916.84938378 | 2099651.07656136 | 37.7454636691757 | -122.429156747668 | (37.7454636691757, -122.429156747668) | ||
| 109766 | 109766 | 39615 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 41 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41016 | 5998377.05402267 | 2106536.9754029 | 37.76405548388961 | -122.44880829126001 | (37.7640554838896, -122.44880829126) | ||
| 111350 | 111350 | 23667 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 315 Virginia Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 12 | 6006939.5968988 | 2098278.7889768 | 37.7418663267774 | -122.418607247372 | (37.7418663267774, -122.418607247372) | |||
| 112399 | 112399 | 40222 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 4387 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1999 12:00:00 AM | Permit Number 41401 | 6001391.00854692 | 2101128.86800083 | 37.7493780241405 | -122.437996521237 | (37.7493780241405, -122.437996521237) | ||
| 112706 | 112706 | 60907 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1491 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1983 12:00:00 AM | Permit Number 20697 | 5994575.4199228 | 2105392.22311625 | 37.7606941592004 | -122.461873918454 | (37.7606941592004, -122.461873918454) | ||
| 114389 | 114389 | 60381 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1350 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1982 12:00:00 AM | Permit Number 19961 | 6016233.53392592 | 2094275.31577425 | 37.7313924611256 | -122.386192505476 | (37.7313924611256, -122.386192505476) | ||
| 114406 | 114406 | 423 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1901X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5989520.14191 | 2114679.4353400003 | 37.785901962187 | -122.480037334344 | (37.785901962187, -122.480037334344) | |||
| 114537 | 114537 | 238563 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 552 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002357.1288 | 2099469.61588 | 37.744877002880294 | -122.434537034955 | (37.7448770028803, -122.434537034955) | |||
| 114736 | 114736 | 63743 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 330 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24415 | 6002754.42754095 | 2109677.07121909 | 37.7729267674736 | -122.433892719333 | (37.7729267674736, -122.433892719333) | ||
| 115204 | 115204 | 50190 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 350 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2003 12:00:00 AM | Permit Number 46896 | 5992966.98430504 | 2103249.49310039 | 37.7547180534592 | -122.467280921215 | (37.7547180534592, -122.467280921215) | |||
| 115702 | 115702 | 46266 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1461 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1987 12:00:00 AM | Permit Number 44550 | 6003962.08662823 | 2099767.6187722 | 37.7457862278615 | -122.42900863209199 | (37.7457862278615, -122.429008632092) | ||
| 116455 | 116455 | 63671 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 371 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1987 12:00:00 AM | Permit Number 24322 | 6004109.81981541 | 2100108.88292896 | 37.7467316215822 | -122.428522112668 | (37.7467316215822, -122.428522112668) | ||
| 118252 | 118252 | 34113 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1398 Plymouth Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37977 | 5995892.17100072 | 2093289.41859175 | 37.7275385716585 | -122.456444707829 | (37.7275385716585, -122.456444707829) | ||
| 118656 | 118656 | 83531 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1355x COLE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50899 | 5998199.0 | 2105694.0 | 37.7617307020229 | -122.44936338497801 | (37.7617307020229, -122.449363384978) | ||
| 119020 | 119020 | 85262 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 3000 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2007 12:00:00 AM | Permit Number 49557 | 5989530.4 | 2095609.1 | 37.73354054474329 | -122.478606721292 | (37.7335405447433, -122.478606721292) | |||
| 119418 | 119418 | 8778 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 3520 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5996129.70402 | 2112934.11169 | 37.7814915775121 | -122.457043925193 | (37.7814915775121, -122.457043925193) | |||
| 120141 | 120141 | 60370 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1439 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1982 12:00:00 AM | Permit Number 19948 | 6015729.73368672 | 2094586.16842125 | 37.7322181026296 | -122.38795593583599 | (37.7322181026296, -122.387955935836) | ||
| 121610 | 121610 | 65660 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 106 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1990 12:00:00 AM | Permit Number 28580 | 5999382.81726917 | 2095526.44780449 | 37.733880710231794 | -122.444538269179 | (37.7338807102318, -122.444538269179) | ||
| 122720 | 122720 | 64800 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 358 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1989 12:00:00 AM | 6 | Permit Number 25799 | 6004181.11096303 | 2100164.87946029 | 37.746889409239294 | -122.428279585184 | (37.7468894092393, -122.428279585184) | |
| 125108 | 125108 | 44821 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1608 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2001 12:00:00 AM | Permit Number 43913 | 5993106.95790851 | 2104515.64796333 | 37.7582026654605 | -122.466888899121 | (37.7582026654605, -122.466888899121) | |||
| 125587 | 125587 | 60906 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1443 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1983 12:00:00 AM | Permit Number 20696 | 5994564.62076665 | 2105704.92459357 | 37.7615521348608 | -122.46193394338499 | (37.7615521348608, -122.461933943385) | ||
| 125746 | 125746 | 39132 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 786 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40812 | 6007317.12360596 | 2102737.01571967 | 37.754128859482606 | -122.417617789975 | (37.7541288594826, -122.417617789975) | ||
| 125795 | 125795 | 54232 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1265 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1983 12:00:00 AM | Permit Number 9972 | 5995143.28929522 | 2106927.58636529 | 37.76494254532629 | -122.460021156774 | (37.7649425453263, -122.460021156774) | ||
| 126998 | 126998 | 63891 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 61 Brady St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1987 12:00:00 AM | Permit Number 24600 | 6006704.26059714 | 2109561.52554736 | 37.7728328593412 | -122.420221545678 | (37.7728328593412, -122.420221545678) | ||
| 127028 | 127028 | 65669 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 979 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1990 12:00:00 AM | Permit Number 28589 | 5998410.3805024 | 2095666.47034675 | 37.734209643166 | -122.447910340725 | (37.734209643166, -122.447910340725) | ||
| 127031 | 127031 | 47171 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 230 San Leandro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | Permit Number 45135 | 5992362.95598719 | 2095257.05561838 | 37.732737970382104 | -122.46878824157301 | (37.7327379703821, -122.468788241573) | ||
| 127112 | 127112 | 67421 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 511 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1992 12:00:00 AM | 5 | Permit Number 30922 | 5991237.50588 | 2111900.6795900003 | 37.7783718985889 | -122.473892988078 | (37.7783718985889, -122.473892988078) | |
| 127144 | 127144 | 64308 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1519 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/10/1988 12:00:00 AM | Permit Number 25119 | 6003981.51464704 | 2099431.34343854 | 37.74486399322979 | -122.428917482655 | (37.7448639932298, -122.428917482655) | ||
| 127483 | 127483 | 63667 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 4040 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1987 12:00:00 AM | Permit Number 24317 | 6003634.2199128 | 2100428.29946056 | 37.7475817391255 | -122.43018947300301 | (37.7475817391255, -122.430189473003) | ||
| 127832 | 127832 | 98123 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 900 York St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774687 | 6009897.0 | 2103882.5 | 37.7574189360449 | -122.40877671518999 | (37.7574189360449, -122.40877671519) | |
| 128295 | 128295 | 51866 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 141 Alpine Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2005 12:00:00 AM | Permit Number 48086 | 6001731.90100781 | 2108013.17914536 | 37.768300053668206 | -122.43731059058001 | (37.7683000536682, -122.43731059058) | |||
| 128313 | 128313 | 238543 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 3765 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6005249.86202 | 2104271.1782400003 | 37.758224768575296 | -122.4248760328 | (37.7582247685753, -122.4248760328) | |||
| 128375 | 128375 | 115782 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 437 MISSISSIPPI ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2016 12:00:00 AM | 3 | 3x3 | 6014121.0 | 2105062.0 | 37.7608932727115 | -122.39425091093901 | (37.7608932727115, -122.394250910939) | ||
| 129109 | 129109 | 46608 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1166 Noriega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2002 12:00:00 AM | Permit Number 44731 | 5990419.11281219 | 2103161.32215556 | 37.754328547559204 | -122.476085621892 | (37.7543285475592, -122.476085621892) | |||
| 129884 | 129884 | 61218 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 175 Elmira St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1983 12:00:00 AM | 8 | Permit Number 21087 | 6011233.7704300005 | 2095695.9733799999 | 37.7350152900164 | -122.40357763429701 | (37.7350152900164, -122.403577634297) | |
| 129915 | 129915 | 179169 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 7 Teddy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011399.30958 | 2087676.99992 | 37.713006084445205 | -122.402441626885 | (37.7130060844452, -122.402441626885) | |||
| 130330 | 130330 | 238558 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 29 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004887.16641 | 2101620.3826900003 | 37.7509258105963 | -122.42594170066201 | (37.7509258105963, -122.425941700662) | |||
| 130666 | 130666 | 124233 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1 Paramount Ter | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5996645.22941 | 2111016.06725 | 37.7762547237702 | -122.45512182152099 | (37.7762547237702, -122.455121821521) | |||
| 130833 | 130833 | 74773 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2650 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1993 12:00:00 AM | 4 | 5995110.10491 | 2110290.17085 | 37.774173413637904 | -122.46037959350201 | (37.7741734136379, -122.460379593502) | ||
| 130913 | 130913 | 34800 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 67 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | 6 | Permit Number 38436 | 5999719.34945 | 2088765.8828900002 | 37.7153369536092 | -122.44288946509701 | (37.7153369536092, -122.442889465097) | |
| 130999 | 130999 | 213708 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1330 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990694.19648 | 2105216.19153 | 37.7599866214079 | -122.475284333917 | (37.7599866214079, -122.475284333917) | |||
| 132214 | 132214 | 118270 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 775 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5984752.97057 | 2110594.13751 | 37.7744067825501 | -122.49622865437999 | (37.7744067825501, -122.49622865438) |
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");