Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6 | 6 | 141566 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 501X Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6000587.8822 | 2110733.5952 | 37.7757045307049 | -122.441462866076 | (37.7757045307049, -122.441462866076) | |||
| 205 | 205 | 134566 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 14 | Width 4ft | 6007493.55732 | 2111589.9734900002 | 37.7784469358085 | -122.417635067622 | (37.7784469358085, -122.417635067622) | |||
| 547 | 547 | 224594 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3133 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/1981 12:00:00 AM | 14 | Width 3ft | Permit Number 18871 | 6005947.45622 | 2106648.2222599997 | 37.7647909508601 | -122.42263236011001 | (37.7647909508601, -122.42263236011) | |
| 568 | 568 | 222894 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 3080 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/1989 12:00:00 AM | 14 | Width 3ft | Permit Number 27054 | 6006296.82054 | 2106727.45524 | 37.765028210007 | -122.42142962480301 | (37.765028210007, -122.421429624803) | |
| 676 | 676 | 214191 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 363 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1972 12:00:00 AM | 14 | Width 3ft | Permit Number 10790 | 5992756.72765 | 2094187.53129 | 37.7298240632085 | -122.467349144256 | (37.7298240632085, -122.467349144256) | |
| 687 | 687 | 13252 | Permitted Site 1 | Tristania conferta :: 79 | 2395 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6001005.1632 | 2119265.163 | 37.7991537757264 | -122.440631471061 | (37.7991537757264, -122.440631471061) | |||
| 718 | 718 | 99173 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Webster St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | Permit Number 25928 | 6003311.25259 | 2116120.54401 | 37.790650512059 | -122.432426898975 | (37.790650512059, -122.432426898975) | ||
| 910 | 910 | 7954 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1756 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6005736.45543 | 2116153.36588 | 37.7908778543671 | -122.424038156058 | (37.7908778543671, -122.424038156058) | |||
| 1164 | 1164 | 246083 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1390 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5999078.2336 | 2108382.6812 | 37.7691633995354 | -122.446515923307 | (37.7691633995354, -122.446515923307) | |||
| 1465 | 1465 | 210473 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 855 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2016 12:00:00 AM | 14 | Width 3ft | Permit Number 41828 | 5993066.85825 | 2107284.5743400003 | 37.765803096458995 | -122.46722890580901 | (37.765803096459, -122.467228905809) | |
| 1476 | 1476 | 139882 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1585 TURK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1990 12:00:00 AM | 14 | Width 0ft | 6002483.27 | 2112280.1738 | 37.780058846079605 | -122.435016891621 | (37.7800588460796, -122.435016891621) | ||
| 1516 | 1516 | 243951 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 14 | Width 5ft | Permit Number 47529 | 6007014.66541 | 2110083.11128 | 37.774282494675795 | -122.419184822535 | (37.7742824946758, -122.419184822535) | |
| 1533 | 1533 | 243953 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 14 | Width 5ft | Permit Number 47529 | 6007037.92355 | 2109985.61989 | 37.7740161163944 | -122.41909745161301 | (37.7740161163944, -122.419097451613) | |
| 1991 | 1991 | 123758 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 201 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 5994989.32477 | 2110751.87532 | 37.7754341833406 | -122.46083085861 | (37.7754341833406, -122.46083085861) | |||
| 2177 | 2177 | 43088 | Permitted Site 1 | Grevillea 'Red Hooks' :: Silk Oak Tree 'Red Hooks' 171 | 240 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | 14 | Permit Number 42924 | 6009031.2139800005 | 2113438.72212 | 37.7836095641737 | -122.412446428164 | (37.7836095641737, -122.412446428164) | |
| 2428 | 2428 | 235022 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 571 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/1986 12:00:00 AM | 14 | Width 3ft | Permit Number 22679 | 6001215.76301 | 2102992.6268700003 | 37.7544854909317 | -122.43873605683399 | (37.7544854909317, -122.438736056834) | |
| 2429 | 2429 | 219807 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 522 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1998 12:00:00 AM | 14 | Width 3ft | Permit Number 39569 | 6001164.11598 | 2103211.29019 | 37.7550829492327 | -122.438930334693 | (37.7550829492327, -122.438930334693) | |
| 2450 | 2450 | 235023 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 559 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/1986 12:00:00 AM | 14 | Width 3ft | Permit Number 22677 | 6001213.00854 | 2103053.34864 | 37.7546520615499 | -122.438749933385 | (37.7546520615499, -122.438749933385) | |
| 2475 | 2475 | 213240 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 72 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 11/24/1982 12:00:00 AM | 14 | Width 3ft | Permit Number 20046 | 5997197.846969999 | 2089560.74227 | 37.7173753740534 | -122.451662146612 | (37.7173753740534, -122.451662146612) | |
| 2543 | 2543 | 141333 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1205 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/1992 12:00:00 AM | 14 | Width 0ft | 6002078.0816 | 2110492.0692 | 37.7751261444639 | -122.43629061453998 | (37.7751261444639, -122.43629061454) | ||
| 2624 | 2624 | 13174 | Permitted Site 1 | Tristania conferta :: 79 | 1950 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/1997 12:00:00 AM | 14 | 3X3 | 6003011.134 | 2119622.0359 | 37.80024768199421 | -122.43371565452 | (37.8002476819942, -122.43371565452) | ||
| 2649 | 2649 | 97548 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2812 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6003949.4047300005 | 2118518.5197799997 | 37.7972709063909 | -122.43039009285299 | (37.7972709063909, -122.430390092853) | |||
| 2694 | 2694 | 6083 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1981 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4X4 | 6000965.1944 | 2112415.458 | 37.780343987670996 | -122.44027829238199 | (37.780343987671, -122.440278292382) | |||
| 2724 | 2724 | 141999 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 818 WEBSTER ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003970.657000001 | 2111746.2039 | 37.778677039760794 | -122.429833251248 | (37.7786770397608, -122.429833251248) | |||
| 2771 | 2771 | 248515 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 170 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1979 12:00:00 AM | 14 | Width 0ft | Permit Number 17884 | 5998314.3472 | 2107764.7584 | 37.7674230792249 | -122.44911363069099 | (37.7674230792249, -122.449113630691) | |
| 2808 | 2808 | 232604 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 509 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1989 12:00:00 AM | 14 | Width 3ft | Permit Number 28219 | 6003467.96193 | 2095980.6299 | 37.7353600451305 | -122.430447088284 | (37.7353600451305, -122.430447088284) | |
| 2838 | 2838 | 229981 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 556 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1980 12:00:00 AM | 14 | Width 3ft | Permit Number 18746 | 6003219.85889 | 2095834.25264 | 37.7349440691062 | -122.431294426813 | (37.7349440691062, -122.431294426813) | |
| 2840 | 2840 | 229977 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 522 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1980 12:00:00 AM | 14 | Width 2ft | Permit Number 18744 | 6003363.64026 | 2095947.4621700002 | 37.7352630640274 | -122.43080540066099 | (37.7352630640274, -122.430805400661) | |
| 2938 | 2938 | 60590 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 601 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/1983 12:00:00 AM | 14 | 4x4 | Permit Number 20209 | 6000481.0 | 2111039.0 | 37.77653700517929 | -122.441854521628 | (37.7765370051793, -122.441854521628) |
| 2974 | 2974 | 68083 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 406 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | 14 | Permit Number 780238 | 6000946.91691 | 2092398.9049099998 | 37.725382321520705 | -122.438906661816 | (37.7253823215207, -122.438906661816) | |
| 2995 | 2995 | 245989 | Permitted Site 1 | Tristania conferta :: 79 | 1250 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2010 12:00:00 AM | 14 | Width 0ft | Permit Number 53135 | 5999854.6873 | 2108493.8194 | 37.7695128761205 | -122.443838207787 | (37.7695128761205, -122.443838207787) | |
| 3011 | 3011 | 142167 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1477 GROVE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6000740.7568 | 2110654.3455 | 37.775495639126795 | -122.440928349683 | (37.7754956391268, -122.440928349683) | |||
| 3024 | 3024 | 225099 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 109 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 14 | Width 3ft | Permit Number 37779 | 6003663.75485 | 2108815.27117 | 37.770612035853404 | -122.43068573955401 | (37.7706120358534, -122.430685739554) | |
| 3103 | 3103 | 238168 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1010 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1989 12:00:00 AM | 14 | Width 4ft | Permit Number 27196 | 6003119.41534 | 2102323.30502 | 37.7527558068522 | -122.432104939916 | (37.7527558068522, -122.432104939916) | |
| 3328 | 3328 | 140422 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 14 | Width 0ft | 6002931.6326 | 2112346.6107 | 37.7802667133087 | -122.43347055342699 | (37.7802667133087, -122.433470553427) | |||
| 3335 | 3335 | 140428 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 14 | Width 0ft | 6003076.6138 | 2112365.9894 | 37.7803281468599 | -122.43297038187401 | (37.7803281468599, -122.432970381874) | |||
| 3347 | 3347 | 140434 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 Turk St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 14 | Width 0ft | 6003279.731000001 | 2112394.6985 | 37.780418493723204 | -122.43226975660299 | (37.7804184937232, -122.432269756603) | |||
| 3349 | 3349 | 140427 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 14 | Width 0ft | 6003052.211 | 2112362.4007 | 37.7803169090148 | -122.43305454594 | (37.7803169090148, -122.43305454594) | |||
| 3351 | 3351 | 140431 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 14 | Width 0ft | 6003184.2731 | 2112381.0617 | 37.7803756375453 | -122.432599015585 | (37.7803756375453, -122.432599015585) | |||
| 3433 | 3433 | 233596 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 44 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6006549.902480001 | 2110330.3544400004 | 37.7749351803449 | -122.420810081832 | (37.7749351803449, -122.420810081832) | |||
| 3495 | 3495 | 82708 | Permitted Site 1 | Casuarina cunninghamiana :: Horsetail pine 123 | 728 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 14 | 3x3 | Permit Number 52492 | 6015291.25471 | 2088404.66417 | 37.7152206119305 | -122.38904043068399 | (37.7152206119305, -122.389040430684) | |
| 3559 | 3559 | 24319 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6006449.33086 | 2112523.89037 | 37.7809524299494 | -122.42131378399901 | (37.7809524299494, -122.421313783999) | |||
| 3720 | 3720 | 54865 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1845 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1972 12:00:00 AM | 14 | Permit Number 10724 | 5998997.2724 | 2110063.1394 | 37.77377288550579 | -122.44691690335199 | (37.7737728855058, -122.446916903352) | ||
| 3774 | 3774 | 99172 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Webster St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | Permit Number 25928 | 6003312.12208 | 2116110.60344 | 37.7906232670935 | -122.432423180296 | (37.7906232670935, -122.432423180296) | ||
| 3787 | 3787 | 65935 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1343 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1990 12:00:00 AM | 14 | Permit Number 28954 | 6006463.24964 | 2119706.38252 | 37.800674552539604 | -122.421775955514 | (37.8006745525396, -122.421775955514) | ||
| 3836 | 3836 | 3098 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3014 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5999901.41366 | 2115112.8463 | 37.7876896938595 | -122.444152274206 | (37.7876896938595, -122.444152274206) | |||
| 3872 | 3872 | 62953 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1439 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1986 12:00:00 AM | 14 | 3x3 | Permit Number 23336 | 6006137.63839 | 2118621.23272 | 37.797676639130295 | -122.42282554258101 | (37.7976766391303, -122.422825542581) | |
| 3914 | 3914 | 23457 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2249 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 5x5 | 6005866.883230001 | 2118164.3475 | 37.7964068674367 | -122.42372992781901 | (37.7964068674367, -122.423729927819) | |||
| 4243 | 4243 | 246126 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1546 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5998264.228999999 | 2108270.3316 | 37.768808388052605 | -122.449323411621 | (37.7688083880526, -122.449323411621) | |||
| 4418 | 4418 | 52886 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2833 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2010 12:00:00 AM | 14 | 3x3 | Permit Number 53458 | 6003898.28713 | 2118559.6074599996 | 37.797380826909 | -122.43056990597601 | (37.797380826909, -122.430569905976) | |
| 4842 | 4842 | 53619 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2635 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1969 12:00:00 AM | 14 | 6x9 | Permit Number 6550 | 6001139.602580001 | 2117434.01333 | 37.794133574667 | -122.44003489281 | (37.794133574667, -122.44003489281) | |
| 5196 | 5196 | 225446 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4633 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1979 12:00:00 AM | 14 | Width 3ft | Permit Number 18031 | 6000267.22366 | 2105166.93872 | 37.760401610855496 | -122.442172414947 | (37.7604016108555, -122.442172414947) | |
| 5381 | 5381 | 103000 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2440 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4x4 | Permit Number 19730 | 6002354.34125 | 2116771.6973599996 | 37.7923841036956 | -122.435784363176 | (37.7923841036956, -122.435784363176) | ||
| 5394 | 5394 | 2865 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1370 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6007816.79371 | 2116213.72438 | 37.7911608170581 | -122.41684453654699 | (37.7911608170581, -122.416844536547) | |||
| 5435 | 5435 | 33143 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2272 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 14 | 4x4 | Permit Number 37369 | 6002130.31107 | 2118463.23451 | 37.7970158973151 | -122.43668064819401 | (37.7970158973151, -122.436680648194) |
| 5739 | 5739 | 99171 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Webster St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | Permit Number 25928 | 6003316.34975 | 2116092.5427599996 | 37.7905739167998 | -122.432407262311 | (37.7905739167998, -122.432407262311) | ||
| 5741 | 5741 | 64939 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1904 Filbert St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/1989 12:00:00 AM | 14 | 4x9 | Permit Number 25968 | 6003770.598230001 | 2119034.75591 | 37.798678227572 | -122.431045672521 | (37.798678227572, -122.431045672521) | |
| 5771 | 5771 | 99170 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Webster St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | Permit Number 25928 | 6003318.49866 | 2116076.63924 | 37.790530371641296 | -122.43239869085899 | (37.7905303716413, -122.432398690859) | ||
| 5793 | 5793 | 99169 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | Permit Number 25928 | 6003320.5239 | 2116054.74736 | 37.790470376959796 | -122.432390119424 | (37.7904703769598, -122.432390119424) | ||
| 6183 | 6183 | 53961 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2456 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1972 12:00:00 AM | 14 | 3x3 | Permit Number 9676 | 6002263.92073 | 2116681.1159200002 | 37.7921302538612 | -122.436090735194 | (37.7921302538612, -122.436090735194) | |
| 6363 | 6363 | 99168 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | Permit Number 25928 | 6003328.674 | 2116003.83043 | 37.790331034186295 | -122.432358282529 | (37.7903310341863, -122.432358282529) | ||
| 6556 | 6556 | 3062 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2786 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6001055.54335 | 2115274.27531 | 37.7881987101484 | -122.44017079833701 | (37.7881987101484, -122.440170798337) | |||
| 6802 | 6802 | 94826 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2195 Green St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/09/2010 12:00:00 AM | 14 | Permit Number 53924 | 6002581.43638 | 2118129.72292 | 37.7961257879313 | -122.435095781947 | (37.7961257879313, -122.435095781947) | ||
| 6905 | 6905 | 18889 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2505 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/1991 12:00:00 AM | 14 | 3X3 | 6002719.33455 | 2115789.29201 | 37.789707396626895 | -122.434451206367 | (37.7897073966269, -122.434451206367) | ||
| 7343 | 7343 | 58834 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1864 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1979 12:00:00 AM | 14 | 3x3 | Permit Number 772490 | 6003989.96335 | 2119411.99542 | 37.7997264575584 | -122.430313528149 | (37.7997264575584, -122.430313528149) | |
| 7442 | 7442 | 1549 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 521 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 5995574.90365 | 2112668.93283 | 37.780731590921704 | -122.458944048869 | (37.7807315909217, -122.458944048869) | |||
| 7445 | 7445 | 99167 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | Permit Number 25928 | 6003331.11107 | 2115984.74946 | 37.7902787808939 | -122.432348487091 | (37.7902787808939, -122.432348487091) | ||
| 8425 | 8425 | 60186 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2440 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1982 12:00:00 AM | 14 | 4x4 | Permit Number 19730 | 6002369.68995 | 2116773.36894 | 37.7923895652649 | -122.435731376003 | (37.7923895652649, -122.435731376003) | |
| 9285 | 9285 | 4852 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1499X ALEMANY BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6x5 | 6002180.0 | 2093376.0 | 37.728135283202704 | -122.43471385212 | (37.7281352832027, -122.43471385212) | |||
| 10112 | 10112 | 5081 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2562 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6002249.017000001 | 2096934.71698 | 37.737910623162705 | -122.434729631968 | (37.7379106231627, -122.434729631968) | |||
| 10491 | 10491 | 1075 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2119 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6000135.00359 | 2089836.3366200002 | 37.7182998663217 | -122.44152955615299 | (37.7182998663217, -122.441529556153) | ||||
| 11168 | 11168 | 66002 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1242 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/1990 12:00:00 AM | 14 | 3x3 | Permit Number 29036 | 5985545.5711 | 2106756.716 | 37.7639167014529 | -122.493204178844 | (37.7639167014529, -122.493204178844) | |
| 11531 | 11531 | 43168 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 285 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 14 | 3x3 | Permit Number 42977 | 6005738.99154 | 2092366.96158 | 37.7255660943895 | -122.422338611837 | (37.7255660943895, -122.422338611837) |
| 11719 | 11719 | 54938 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 540 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1972 12:00:00 AM | 14 | 4x3 | Permit Number 10816 | 6013051.4266099995 | 2086907.8440900003 | 37.7109862260136 | -122.39667743572599 | (37.7109862260136, -122.396677435726) | |
| 11921 | 11921 | 61836 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 209 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1985 12:00:00 AM | 14 | 3x3 | Permit Number 21875 | 6001956.61236 | 2093885.6272599997 | 37.7295219188836 | -122.435522552544 | (37.7295219188836, -122.435522552544) | |
| 12148 | 12148 | 15777 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4826 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2013 12:00:00 AM | 14 | 3X3 | 6001241.8395 | 2090763.6886 | 37.7209091632567 | -122.43777008073401 | (37.7209091632567, -122.437770080734) | ||
| 12215 | 12215 | 25370 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1100 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1996 12:00:00 AM | 14 | 3X3 | 6001209.09194 | 2088530.7104900002 | 37.7147760437566 | -122.43772343639401 | (37.7147760437566, -122.437723436394) | ||
| 12453 | 12453 | 17491 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 33 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6001944.766 | 2091477.8994200001 | 37.722910170637896 | -122.435391342346 | (37.7229101706379, -122.435391342346) | |||
| 12719 | 12719 | 25392 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1063 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1997 12:00:00 AM | 14 | 3X3 | 6001061.933019999 | 2088709.29333 | 37.7152580237143 | -122.438244863328 | (37.7152580237143, -122.438244863328) | ||
| 12923 | 12923 | 111444 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 14 | 6x12 | 5999970.3074 | 2091024.03837 | 37.721551640364396 | -122.442184051271 | (37.7215516403644, -122.442184051271) | ||
| 13178 | 13178 | 15953 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5845 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/2013 12:00:00 AM | 14 | 4x4 | 5997237.66299 | 2086574.7541200002 | 37.7091788189244 | -122.451309288592 | (37.7091788189244, -122.451309288592) | ||
| 13194 | 13194 | 28543 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 5050 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 14 | 3X3 | 6000463.3087 | 2089534.8309 | 37.717490698541106 | -122.44037313550601 | (37.7174906985411, -122.440373135506) | ||
| 13735 | 13735 | 22066 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2955 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2000 12:00:00 AM | 14 | 3X3 | 6015999.04813 | 2101774.12278 | 37.751969669865396 | -122.387526128851 | (37.7519696698654, -122.387526128851) | ||
| 14224 | 14224 | 97609 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 347 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6009082.07861 | 2109308.71227 | 37.772272388486 | -122.41197849922399 | (37.772272388486, -122.411978499224) | |||
| 14548 | 14548 | 22294 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4925 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6014848.357000001 | 2095114.0522 | 37.7336186964108 | -122.391039961361 | (37.7336186964108, -122.391039961361) | |||
| 15065 | 15065 | 25926 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Oakdale Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/1997 12:00:00 AM | 14 | 3x3 | 6013312.92964 | 2096802.5667400002 | 37.7381696854804 | -122.396466732646 | (37.7381696854804, -122.396466732646) | ||
| 17255 | 17255 | 32525 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 864 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/15/1996 12:00:00 AM | 14 | 3x3 | Permit Number 37027 | 6007539.30835 | 2095267.7389900002 | 37.7336323917164 | -122.41632041617399 | (37.7336323917164, -122.416320416174) | |
| 17512 | 17512 | 19143 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 44 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6003455.42018 | 2108051.36795 | 37.7685027389345 | -122.43135183234101 | (37.7685027389345, -122.431351832341) | |||
| 17970 | 17970 | 10345 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 954 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6001545.3048 | 2109077.8189 | 37.7712126807777 | -122.43803227825 | (37.7712126807777, -122.43803227825) | |||
| 18011 | 18011 | 103601 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 100X Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6004868.5 | 2109011.4 | 37.771218737852294 | -122.426532477218 | (37.7712187378523, -122.426532477218) | |||
| 18258 | 18258 | 30562 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1074 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 14 | Permit Number 38411 | 6008011.79259 | 2101700.97642 | 37.7513231949327 | -122.41514211632798 | (37.7513231949327, -122.415142116328) | |
| 18276 | 18276 | 16647 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 178 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/04/2015 12:00:00 AM | 14 | 4x4 | 6002850.6051900005 | 2107244.6681 | 37.7662534427777 | -122.433386179722 | (37.7662534427777, -122.433386179722) | ||
| 18652 | 18652 | 10350 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 981 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6001468.92612 | 2109016.3918 | 37.771039673363205 | -122.43829207321899 | (37.7710396733632, -122.438292073219) | |||
| 18734 | 18734 | 94234 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Clearfield Sloat Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 14 | Permit Number 53611 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 18934 | 18934 | 5430 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 481 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 2x2 | 6004966.9264400005 | 2105556.94593 | 37.761739197733704 | -122.425946073151 | (37.7617391977337, -122.425946073151) | |||
| 19099 | 19099 | 34262 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3618 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | 14 | 3x3 | Permit Number 38067 | 6002793.22003166 | 2106527.80070587 | 37.7642818435653 | -122.433533428216 | (37.7642818435653, -122.433533428216) | |
| 19461 | 19461 | 22950 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 440 Valencia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6006112.688519999 | 2107050.90037 | 37.7659059303452 | -122.42208947267599 | (37.7659059303452, -122.422089472676) | |||
| 20431 | 20431 | 235 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2994 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/31/1994 12:00:00 AM | 14 | 3X3 | 5990616.42942 | 2095306.68002 | 37.7327731713422 | -122.474829978418 | (37.7327731713422, -122.474829978418) | ||
| 20458 | 20458 | 30563 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1074 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 14 | Permit Number 38411 | 6008014.076330001 | 2101681.3139299997 | 37.7512693345126 | -122.415132827214 | (37.7512693345126, -122.415132827214) | |
| 21365 | 21365 | 5815 | Permitted Site 1 | Aesculus x carnea :: Red Horse Chestnut 194 | 1466X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1998 12:00:00 AM | 14 | 3X3 | 6005195.194490001 | 2099842.5587299997 | 37.7460617184842 | -122.424750048586 | (37.7460617184842, -122.424750048586) |
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");