Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6613 | 6613 | 12417 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1691 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1989 12:00:00 AM | 6 | 4X4 | 6004447.0274 | 2114613.1852 | 37.786576022340604 | -122.428389697922 | (37.7865760223406, -122.428389697922) | ||
| 8265 | 8265 | 12418 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1691 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1989 12:00:00 AM | 6 | 4X4 | 6004450.1666 | 2114579.9986 | 37.7864850778881 | -122.42837647083799 | (37.7864850778881, -122.428376470838) | ||
| 17381 | 17381 | 10116 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 842 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 6005634.91055 | 2104075.87142 | 37.7577102430435 | -122.42353048064501 | (37.7577102430435, -122.423530480645) | |||
| 18064 | 18064 | 4209 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 3929 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004325.38397 | 2100415.60352 | 37.747586001896 | -122.427798564152 | (37.747586001896, -122.427798564152) | |||
| 20913 | 20913 | 34112 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1398 Plymouth Ave | 3 | 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) | ||
| 21869 | 21869 | 22856 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 140 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5999949.39722 | 2099144.09084 | 37.743846215245796 | -122.44283912645099 | (37.7438462152458, -122.442839126451) | |||
| 25106 | 25106 | 52648 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 542@ ANZA 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2010 12:00:00 AM | 2 | Permit Number 48732 | 5993472.644230001 | 2111791.25598 | 37.778200659528295 | -122.466152920318 | (37.7782006595283, -122.466152920318) | ||
| 25559 | 25559 | 60074 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1275 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1982 12:00:00 AM | 4 | Permit Number 19575 | 5988921.6846 | 2106672.1231 | 37.7638813163914 | -122.481521155686 | (37.7638813163914, -122.481521155686) | |
| 26847 | 26847 | 35161 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 515 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | 6 | Permit Number 38692 | 6002615.109 | 2110357.4935 | 37.7747871313025 | -122.434423295825 | (37.7747871313025, -122.434423295825) | |
| 27673 | 27673 | 65516 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 159 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/1990 12:00:00 AM | 5 | Permit Number 28402 | 5990823.47806 | 2114342.11962 | 37.7850514269176 | -122.47550355958299 | (37.7850514269176, -122.475503559583) | ||
| 32670 | 32670 | 60083 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1270 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1982 12:00:00 AM | 3 | Permit Number 19584 | 5988965.7237 | 2106688.207 | 37.763928038973106 | -122.481370017438 | (37.7639280389731, -122.481370017438) | |
| 33410 | 33410 | 50351 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 658 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/2003 12:00:00 AM | 3 | Permit Number 47029 | 5981670.87041 | 2111242.23948 | 37.776005259128794 | -122.50693811767201 | (37.7760052591288, -122.506938117672) | |
| 33550 | 33550 | 139117 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1501 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6004494.7186 | 2114242.7456 | 37.785561586454 | -122.42819828794501 | (37.785561586454, -122.428198287945) | |||
| 36853 | 36853 | 40939 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 2011 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2000 12:00:00 AM | 4 | Permit Number 42024 | 6003842.4279 | 2115465.9547 | 37.7888832815445 | -122.43054233468 | (37.7888832815445, -122.43054233468) | ||
| 37383 | 37383 | 41957 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 2638 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 4 | Permit Number 42313 | 5995143.69116 | 2110295.9103200003 | 37.7741911046961 | -122.460263829424 | (37.7741911046961, -122.460263829424) | |
| 53745 | 53745 | 35587 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 3600 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/1998 12:00:00 AM | 5 | Permit Number 38951 | 6002200.57544 | 2120594.56512 | 37.8028719650354 | -122.436590150328 | (37.8028719650354, -122.436590150328) | ||
| 55284 | 55284 | 63544 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1457 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1987 12:00:00 AM | 5 | Permit Number 24160 | 6000753.318 | 2110998.5304 | 37.776441399194 | -122.440909593922 | (37.776441399194, -122.440909593922) | |
| 57874 | 57874 | 53440 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 62 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/1969 12:00:00 AM | 5 | Permit Number 6341 | 5995913.45443 | 2114081.21839 | 37.784628805515794 | -122.45787507433701 | (37.7846288055158, -122.457875074337) | ||
| 60107 | 60107 | 60559 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 682 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 7 | Permit Number 20169 | 5985086.776269999 | 2111238.89557 | 37.7761966512901 | -122.495121529295 | (37.7761966512901, -122.495121529295) | |
| 62809 | 62809 | 61603 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 51 Temescal Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1984 12:00:00 AM | 5 | Permit Number 21576 | 5997451.8044 | 2111351.7774 | 37.777222737132 | -122.452355902086 | (37.777222737132, -122.452355902086) | |
| 65988 | 65988 | 57628 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 534 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/1990 12:00:00 AM | 7 | Permit Number 28866 | 5990653.097709999 | 2111727.01603 | 37.7778611992683 | -122.475901966903 | (37.7778611992683, -122.475901966903) | ||
| 71928 | 71928 | 32263 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1027 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1997 12:00:00 AM | 6 | Permit Number 38508 | 6001961.80669 | 2101044.74865 | 37.7491794962361 | -122.436016672442 | (37.7491794962361, -122.436016672442) | ||
| 73471 | 73471 | 67971 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 2643 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 2 | Permit Number 31692 | 5987328.75308 | 2111152.2075900002 | 37.7760896301586 | -122.48735965405001 | (37.7760896301586, -122.48735965405) | |
| 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) | |
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) |
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");