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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 142598 | 142598 | 121520 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 142597 | 142597 | 101575 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1200X Bryant St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 3x3 | 6009691.5 | 2108599.6 | 37.770359503346704 | -122.409820383511 | (37.7703595033467, -122.409820383511) | |||
| 142520 | 142520 | 108364 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 5290 DIAMOND HEIGHTS BLVD | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x10 | 6001137.6 | 2099182.7 | 37.7440198953745 | -122.43873337410601 | (37.7440198953745, -122.438733374106) | ||||
| 142453 | 142453 | 113641 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 545X Minna St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6010081.18772 | 2112137.85468 | 37.7800965567953 | -122.40872210131901 | (37.7800965567953, -122.408722101319) | |||||
| 142400 | 142400 | 97858 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 142369 | 142369 | 97035 | Property Tree 7 | Casurina stricta :: Beefwood: Drooping She-Oak 309 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 142340 | 142340 | 121660 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5998939.0 | 2095554.0 | 37.7339310276146 | -122.44607465500401 | (37.7339310276146, -122.446074655004) | ||||
| 142282 | 142282 | 96784 | Significant Tree 6 | Acer palmatum :: Japanese Maple 175 | 615 Rhode Island St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/19/2011 12:00:00 AM | Permit Number 767987 | 6011854.6 | 2105476.9 | 37.7619062576766 | -122.40211860576099 | (37.7619062576766, -122.402118605761) | ||||
| 142264 | 142264 | 96605 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 142238 | 142238 | 97863 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 142206 | 142206 | 116462 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 66 AERIAL WAY | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5992280.0 | 2102576.0 | 37.7528291346084 | -122.469607652393 | (37.7528291346084, -122.469607652393) | ||||
| 142088 | 142088 | 114593 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1 BRADFORD ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 15 | 6x9 | 6009441.0 | 2096050.0 | 37.735887066073104 | -122.409800886333 | (37.7358870660731, -122.409800886333) | |||
| 141993 | 141993 | 92657 | Permitted Site 1 | Azara microphylla :: Little-Leaf Azara 295 | 2201 Baker St | 23 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/25/2009 12:00:00 AM | Permit Number 52915 | 5999814.0 | 2116396.0 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | |||
| 141869 | 141869 | 21804 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2600X Taylor St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 01/22/2016 12:00:00 AM | 12 | 3X3 | 6008553.39113 | 2121935.04647 | 37.806911549800795 | -122.414700989571 | (37.8069115498008, -122.414700989571) | ||
| 141855 | 141855 | 10769 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1120X Hudson Ave | 41 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 8 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 141804 | 141804 | 96996 | Significant Tree 6 | Malus :: Crab Apple 235 | 2451X Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.38719408923599 | (37.7197277910807, -122.387194089236) | |||||
| 141795 | 141795 | 119629 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 715 Buena Vista Ave West | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/29/2016 12:00:00 AM | 3 | 5999876.8122 | 2107852.06726 | 37.7677520478965 | -122.443715568345 | (37.7677520478965, -122.443715568345) | |||
| 141792 | 141792 | 119265 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1317 Bosworth St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6000208.0 | 2096491.0 | 37.7365761953737 | -122.44175457190599 | (37.7365761953737, -122.441754571906) | |||||
| 141733 | 141733 | 10733 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1100 Hudson Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 01/28/2016 08:19:00 AM | 3 | 3x4 | 6018138.790397401 | 2094650.7890521 | 37.7325287066123 | -122.379631682873 | (37.7325287066123, -122.379631682873) | ||
| 141689 | 141689 | 75040 | DPW Maintained 3 | Tree(s) :: 17 | 499X Hearst Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 18 | 6x20 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 141673 | 141673 | 117508 | Undocumented 2 | Malus :: Crab Apple 235 | 21 MOUNTAIN SPRING AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 9 | 3x10 | Permit Number 778424 | 5997487.0 | 2104391.0 | 37.758112238825206 | -122.451731896555 | (37.7581122388252, -122.451731896555) | ||
| 141647 | 141647 | 122627 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 34 Country Club Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/15/2016 12:00:00 AM | 3 | 3x4 | Permit Number 775279 | 5984731.0 | 2094410.0 | 37.729968312905505 | -122.49511098534401 | (37.7299683129055, -122.495110985344) | |
| 141580 | 141580 | 109627 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 500 CIRCULAR AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5999334.0 | 2093430.0 | 37.728121569817 | -122.444556419888 | (37.728121569817, -122.444556419888) | ||||
| 141437 | 141437 | 92636 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1680 Eddy St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/22/2009 12:00:00 AM | 3x3 | Permit Number 52927 | 6002403.9 | 2112682.2 | 37.7811582017665 | -122.435320233246 | (37.7811582017665, -122.435320233246) | ||
| 141398 | 141398 | 106523 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2510 Jackson St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 772624 | 6002049.7 | 2116744.4 | 37.7922918429251 | -122.436836472971 | (37.7922918429251, -122.436836472971) | ||||
| 141396 | 141396 | 83256 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 606 40th Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/22/2009 12:00:00 AM | 3x3 | Permit Number 52675 | 5983524.4637113 | 2111665.45809924 | 37.7772762800291 | -122.500557454432 | (37.7772762800291, -122.500557454432) | ||
| 141354 | 141354 | 120533 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 951 Brannan St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 22 | 3x3 | 6010745.0 | 2108673.0 | 37.7706200263658 | -122.40618148078501 | (37.7706200263658, -122.406181480785) | |||
| 141261 | 141261 | 108283 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 141243 | 141243 | 98595 | Permitted Site 1 | Pyrus spp :: Pear Tree 291 | 400X Steiner St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/01/2012 12:00:00 AM | Permit Number 768529 | 6004639.0 | 2109849.0 | 37.7735056071657 | -122.42738600543899 | (37.7735056071657, -122.427386005439) | |||
| 141192 | 141192 | 108958 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 22ND AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5989329.4 | 2105769.6 | 37.7614269305246 | -122.48004495307501 | (37.7614269305246, -122.480044953075) | ||||
| 141150 | 141150 | 100513 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1X Treat Ave | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3 | 18x18 | 6009122.9 | 2107982.7 | 37.7686337575832 | -122.41174358203101 | (37.7686337575832, -122.411743582031) | |||
| 141087 | 141087 | 108363 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 5290 DIAMOND HEIGHTS BLVD | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x10 | 6001137.6 | 2099182.7 | 37.7440198953745 | -122.43873337410601 | (37.7440198953745, -122.438733374106) | ||||
| 141082 | 141082 | 106570 | Undocumented 2 | Yucca elephantipes :: Giant Yucca 211 | 580 York St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6009757.6 | 2105594.3 | 37.7621113428358 | -122.40937962036101 | (37.7621113428358, -122.409379620361) | |||||
| 141052 | 141052 | 116899 | Undocumented 2 | Auranticarpa rhombifolia :: Queensland Pittosporum 428 | 898 PACHECO ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5992167.0 | 2103065.0 | 37.754165269847 | -122.470034026433 | (37.754165269847, -122.470034026433) | ||||
| 140884 | 140884 | 104457 | DPW Maintained 3 | Tree(s) :: 17 | 1601X Kansas St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 4 | 3x6 | 6011789.30586 | 2100707.09327 | 37.748805772054 | -122.402009105448 | (37.748805772054, -122.402009105448) | |||
| 140837 | 140837 | 105857 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 1500X Valencia St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6006259.2 | 2100711.5 | 37.7485076710609 | -122.42113253995599 | (37.7485076710609, -122.421132539956) | ||||
| 140829 | 140829 | 105041 | Permitted Site 1 | :: 54 | 2660 Harrison St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 2x2 | 6008868.4 | 2102978.1 | 37.7548779915591 | -122.412270115586 | (37.7548779915591, -122.412270115586) | ||||
| 140792 | 140792 | 94868 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 31 | 51 Princeton St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 6007547.0 | 2093670.0 | 37.729245779959 | -122.416180705349 | (37.729245779959, -122.416180705349) | |||||
| 140674 | 140674 | 111747 | Permitted Site 1 | Tristania conferta :: 79 | 398X 03rd St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/22/2015 12:00:00 AM | 3 | 10x20 | Permit Number 775763 | 6013296.047180001 | 2113048.21405 | 37.7827757318295 | -122.397664238011 | (37.7827757318295, -122.397664238011) | |
| 140629 | 140629 | 97038 | Property Tree 7 | Hakea suaveolens :: Sweet Hakea Tree 14 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 140623 | 140623 | 117481 | Planning Code 138.1 required 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 601 PACHECO ST | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x9 | 5993107.0 | 2101833.0 | 37.7508368102529 | -122.46669375398199 | (37.7508368102529, -122.466693753982) | ||||
| 140586 | 140586 | 97044 | Property Tree 7 | Heteromeles arbutifolia :: Toyon 322 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 140567 | 140567 | 94962 | Permitted Site 1 | Tree(s) :: 17 | 3098@Lyon Pacific Ave | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/25/2010 12:00:00 AM | 5999362.0 | 2116697.3 | 37.7920093994348 | -122.44613254842899 | (37.7920093994348, -122.446132548429) | |||||
| 140493 | 140493 | 115828 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 65 CHUMASERO DR | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | 5991168.0 | 2088425.0 | 37.713909732222 | -122.472421570074 | (37.713909732222, -122.472421570074) | ||
| 140434 | 140434 | 103232 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1600X 29th Ave | 23 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 140389 | 140389 | 97037 | Property Tree 7 | Griselinia lucida :: Griselinia 477 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 140378 | 140378 | 107415 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 300 Seacliff Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/04/2014 12:00:00 AM | 3 | Permit Number 773970 | 5986804.62098 | 2115681.98254 | 37.788496517491104 | -122.489505906992 | (37.7884965174911, -122.489505906992) | ||
| 140362 | 140362 | 108359 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 5290 DIAMOND HEIGHTS BLVD | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 20 | 3x10 | 6001137.6 | 2099182.7 | 37.7440198953745 | -122.43873337410601 | (37.7440198953745, -122.438733374106) | |||
| 140281 | 140281 | 108494 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 734 11th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773785 | 5992601.40555 | 2110422.43493 | 37.7743919431152 | -122.469067180848 | (37.7743919431152, -122.469067180848) |
| 140252 | 140252 | 93987 | Permitted Site 1 | Prunus spp :: Cherry 84 | 200 Belgrave Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 53411 | 5997460.5 | 2104904.0 | 37.759519290122 | -122.45186055280199 | (37.759519290122, -122.451860552802) | |||
| 140157 | 140157 | 6099 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 500X 08th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 18 | 18 | 6010526.812454099 | 2109340.6023904 | 37.772440902057795 | -122.406983260044 | (37.7724409020578, -122.406983260044) | |||
| 140137 | 140137 | 106573 | Undocumented 2 | Yucca elephantipes :: Giant Yucca 211 | 580 York St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6009757.6 | 2105594.3 | 37.7621113428358 | -122.40937962036101 | (37.7621113428358, -122.409379620361) | |||||
| 140071 | 140071 | 2139 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 28 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 139898 | 139898 | 109348 | Private 5 | Ficus Spp. :: 253 | 2505 Pacific Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | .5x1 | 6002092.0 | 2116990.0 | 37.7929686009801 | -122.43670770268999 | (37.7929686009801, -122.43670770269) | ||
| 139322 | 139322 | 37829 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 16 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003752.0 | 2090699.0 | 37.720873955994 | -122.42908860130501 | (37.720873955994, -122.429088601305) |
| 139320 | 139320 | 94936 | Significant Tree 6 | Malus 'Gala' :: Apple Tree 'Gala' 498 | 2525 Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.719615759266205 | -122.38561332473999 | (37.7196157592662, -122.38561332474) | ||||
| 139234 | 139234 | 93020 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1403 11th Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 2x2 | Tree 3 | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.46848481907499 | (37.7618848250494, -122.468484819075) | ||
| 139211 | 139211 | 108277 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 139051 | 139051 | 112390 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 2201X LYON ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x12 | 5999307.0 | 2116423.0 | 37.7912531030346 | -122.446303107227 | (37.7912531030346, -122.446303107227) | ||||
| 139023 | 139023 | 37379 | Permitted Site 1 | Shrub :: Shrub 98 | 755 Morse St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 2 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 139002 | 139002 | 16934 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 534 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 24 | 3X3 | 6004202.212169999 | 2110156.57626 | 37.774325423266895 | -122.428918851232 | (37.7743254232669, -122.428918851232) | |||
| 138944 | 138944 | 122376 | Undocumented 2 | Cercis occidentalis :: Western Redbud 246 | 195x Ogden Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6007788.0 | 2096166.0 | 37.736112801819104 | -122.41552418854299 | (37.7361128018191, -122.415524188543) | |||||
| 138901 | 138901 | 2095 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Bosworth St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 15 | 3X3 | 6001184.3961352995 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | |||
| 138892 | 138892 | 120647 | Undocumented 2 | Arecastrum romanzoffianum :: Queen Palm 238 | 69x Dearborn St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/22/2016 12:00:00 AM | 3 | 3x3 | 6005880.0 | 2105692.0 | 37.762161584269705 | -122.422797712098 | (37.7621615842697, -122.422797712098) | ||
| 138791 | 138791 | 93974 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 59@ Golden Gate Ave Roselyn Ter | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Tree 2 on Golden Gate Ave | 5998204.2 | 2111419.4 | 37.777451486883294 | -122.449758011487 | (37.7774514868833, -122.449758011487) | ||||
| 138648 | 138648 | 122626 | Planning Code 138.1 required 4 | Cordyline australis :: Dracena Palm 141 | 330 Country Club Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/15/2016 12:00:00 AM | 3 | 3x5 | Permit Number 774975 | 5984613.0 | 2095517.0 | 37.73300093168071 | -122.495600537949 | (37.7330009316807, -122.495600537949) | |
| 138528 | 138528 | 94624 | Permitted Site 1 | Alnus rhombifolia :: White Alder 204 | 1728 Bancroft Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/13/2010 12:00:00 AM | 9 | Permit Number 53777 | 6014054.0 | 2092727.0 | 37.7270202245482 | -122.393619293726 | (37.7270202245482, -122.393619293726) | ||
| 138508 | 138508 | 96480 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
| 138503 | 138503 | 18401 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 999X Potrero Ave | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 18 | 4x4 | 6010520.259169 | 2103656.1388783003 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | |||
| 138328 | 138328 | 51618 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 396(REVISED) Diamond St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52286 | 6001775.40578603 | 2103546.80768569 | 37.756038960358296 | -122.436840338915 | (37.7560389603583, -122.436840338915) | ||
| 138317 | 138317 | 94634 | Permitted Site 1 | Tree(s) :: 17 | 3600 16th St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/18/2010 12:00:00 AM | 3x3 | Permit Number 53781 | 6002902.0 | 2106490.0 | 37.764184223284396 | -122.433154488347 | (37.7641842232844, -122.433154488347) | ||
| 137020 | 137020 | 113771 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 2550 Broadway | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 6001386.1067 | 2117311.2447 | 37.79381051388621 | -122.439173160634 | (37.7938105138862, -122.439173160634) | ||||
| 135250 | 135250 | 97444 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900@Gough Pacific Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 17 | 6004910.36816 | 2117456.9947 | 37.7944106153185 | -122.42698927054701 | (37.7944106153185, -122.426989270547) | ||||
| 131875 | 131875 | 95679 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 318 Holyoke St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767431 | 6009609.49645 | 2092896.87368 | 37.727238694008705 | -122.408995916549 | (37.7272386940087, -122.408995916549) |
| 129715 | 129715 | 98763 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 14 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 16 | 3x3 | 6003235.74698 | 2121049.71225 | 37.8041804507317 | -122.43304046507299 | (37.8041804507317, -122.433040465073) | |||
| 129432 | 129432 | 121684 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 208 Joost Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6000684.0 | 2094988.0 | 37.7324764179648 | -122.440001102333 | (37.7324764179648, -122.440001102333) | ||||
| 129250 | 129250 | 92650 | Permitted Site 1 | Azara microphylla :: Little-Leaf Azara 295 | 2201 Baker St | 16 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/25/2009 12:00:00 AM | Permit Number 52915 | 5999814.0 | 2116396.0 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | |||
| 129083 | 129083 | 103447 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 50X Bluxome St | 24 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | ||||
| 128784 | 128784 | 97039 | Property Tree 7 | Hakea suaveolens :: Sweet Hakea Tree 14 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 128760 | 128760 | 2115 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 128737 | 128737 | 18408 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 999X Potrero Ave | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 05/23/1997 12:00:00 AM | 18 | 2X4 | 6010520.259169 | 2103656.1388783003 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | ||
| 128725 | 128725 | 109380 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 725X BURNETT AVE | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5999257.1 | 2101645.9 | 37.7506760851616 | -122.44541277185499 | (37.7506760851616, -122.445412771855) | |||||
| 128722 | 128722 | 97723 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 7x57 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | ||
| 128721 | 128721 | 101578 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1200X Bryant St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 3x3 | 6009691.5 | 2108599.6 | 37.770359503346704 | -122.409820383511 | (37.7703595033467, -122.409820383511) | |||
| 128679 | 128679 | 115086 | Undocumented 2 | Thuja plicata :: Western Red Cedar 317 | 2784X JACKSON ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 7 | 3x3 | 6000894.0 | 2116629.0 | 37.791909233816206 | -122.44082692769199 | (37.7919092338162, -122.440826927692) | |||
| 128554 | 128554 | 93164 | Permitted Site 1 | Shrub :: Shrub 98 | 201 Upper Ter | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 12/22/2009 12:00:00 AM | 1x2 | 5999670.5 | 2106448.3 | 37.763885884820205 | -122.444328283325 | (37.7638858848202, -122.444328283325) | |||
| 128487 | 128487 | 94424 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 5800 03rd St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 128397 | 128397 | 118290 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 275 OLYMPIA WAY | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5996383.0 | 2101914.0 | 37.7512477308097 | -122.455370966371 | (37.7512477308097, -122.455370966371) | ||||
| 128373 | 128373 | 107595 | Undocumented 2 | Tree(s) :: 17 | 1846 POST ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 3x3 | 6003338.5 | 2114199.3 | 37.7853768084061 | -122.43219536019501 | (37.7853768084061, -122.432195360195) | |||
| 128363 | 128363 | 86709 | Permitted Site 1 | Albizia julibrissin :: Mimosa Silk Tree 126 | 3027 25th St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/06/2007 12:00:00 AM | Permit Number 49351 | 6009354.0 | 2101579.0 | 37.751063612674706 | -122.41049197906901 | (37.7510636126747, -122.410491979069) | |||
| 128042 | 128042 | 117483 | Planning Code 138.1 required 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 601 PACHECO ST | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x9 | 5993107.0 | 2101833.0 | 37.7508368102529 | -122.46669375398199 | (37.7508368102529, -122.466693753982) | ||||
| 128034 | 128034 | 96601 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 127931 | 127931 | 2101 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Bosworth St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 04/09/1990 12:00:00 AM | 14 | 6001184.3961352995 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | |||
| 127907 | 127907 | 109177 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 320 COLON AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 24 | 5995887.7 | 2094797.5 | 37.7316791433679 | -122.45656917602899 | (37.7316791433679, -122.456569176029) | ||||
| 127852 | 127852 | 92600 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2201 Baker St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/25/2009 12:00:00 AM | 3x3 | Permit Number 52915 | 5999814.0 | 2116396.0 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | ||
| 127737 | 127737 | 112972 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4099x ULLOA ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/20/2015 12:00:00 AM | 1 | 3x3 | Permit Number 773327 | 5983385.0 | 2098079.0 | 37.7399635032694 | -122.500035309652 | (37.7399635032694, -122.500035309652) | |
| 127734 | 127734 | 113338 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2X STANFORD ST | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 3x9 | Permit Number 770912 | 6014727.0 | 2112481.0 | 37.781297869167396 | -122.392674013487 | (37.7812978691674, -122.392674013487) | ||
| 127722 | 127722 | 101809 | Undocumented 2 | Tree(s) :: 17 | 370 Hermann St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6003497.0 | 2108649.0 | 37.7701460471638 | -122.43125067595 | (37.7701460471638, -122.43125067595) | ||||
| 127684 | 127684 | 101960 | Permitted Site 1 | Tree(s) :: 17 | 896 De Haro St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/11/2012 12:00:00 AM | Permit Number 769432 | 6012145.1 | 2104124.0 | 37.7582077038957 | -122.401018811941 | (37.7582077038957, -122.401018811941) | |||
| 127558 | 127558 | 121590 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1633 Diamond St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6002085.0 | 2099267.0 | 37.7443052155581 | -122.435463512838 | (37.7443052155581, -122.435463512838) |
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");