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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 145364 | 145364 | 109041 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1638 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773601 | 5985043.8 | 2104034.4 | 37.7564126199144 | -122.49473890921699 | (37.7564126199144, -122.494738909217) |
| 145365 | 145365 | 67446 | Permitted Site 1 | Tree(s) :: 17 | 219 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1992 12:00:00 AM | Permit Number 30949 | 6002727.65567116 | 2104618.95568967 | 37.759036896374 | -122.433623765747 | (37.759036896374, -122.433623765747) | |||
| 145366 | 145366 | 1004 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1810X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 6001283.16417 | 2091702.46996 | 37.7234891944335 | -122.43769443354799 | (37.7234891944335, -122.437694433548) | ||
| 145367 | 145367 | 57644 | Permitted Site 1 | Tree(s) :: 17 | 324 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/1976 12:00:00 AM | Permit Number 16543 | 6006515.12486553 | 2097306.51331035 | 37.73917276842371 | -122.420005954872 | (37.7391727684237, -122.420005954872) | |||
| 145368 | 145368 | 50116 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 1645 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46841 | 5990949.33787022 | 2098364.95753208 | 37.7411897083484 | -122.473902084012 | (37.7411897083484, -122.473902084012) | ||
| 145369 | 145369 | 6107 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 145370 | 145370 | 11340 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1279 Ingalls St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6017412.9471167 | 2093950.7223454 | 37.7305663998171 | -122.38209244081101 | (37.7305663998171, -122.382092440811) | |||
| 145371 | 145371 | 89654 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 3021 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/2008 12:00:00 AM | 3 | 3x3 | 5989260.15494 | 2111906.2632400002 | 37.778272500510894 | -122.480733712855 | (37.7782725005109, -122.480733712855) | ||
| 145372 | 145372 | 24804 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 7309 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5984322.46169 | 2112412.48531 | 37.7793742137236 | -122.49785214007099 | (37.7793742137236, -122.497852140071) | |||
| 145373 | 145373 | 118792 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 746 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 5982002.3368 | 2110652.98782 | 37.7744068613492 | -122.505747814892 | (37.7744068613492, -122.505747814892) | ||||
| 145374 | 145374 | 83520 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1488 La Playa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50200 | 5980958.16481146 | 2104928.49787253 | 37.758627564799795 | -122.508934600528 | (37.7586275647998, -122.508934600528) | ||
| 145375 | 145375 | 52376 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 25 Fair Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | Permit Number 48505 | 6006761.98937592 | 2099585.56782641 | 37.7454444472056 | -122.41931403787399 | (37.7454444472056, -122.419314037874) | ||
| 145376 | 145376 | 43074 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 378 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2002 12:00:00 AM | Permit Number 46009 | 6007759.3011441 | 2112719.71067496 | 37.781563872591704 | -122.416795815478 | (37.7815638725917, -122.416795815478) | ||
| 145377 | 145377 | 41313 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 3415 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2000 12:00:00 AM | Permit Number 41985 | 6007472.38945559 | 2104388.77771008 | 37.7586729549371 | -122.417197878908 | (37.7586729549371, -122.417197878908) | |||
| 145378 | 145378 | 42099 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 337 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42405 | 5999399.61952202 | 2094185.90721086 | 37.730200858866205 | -122.44438387280898 | (37.7302008588662, -122.444383872809) | ||
| 145379 | 145379 | 37266 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 910 Church St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39808 | 6004347.42466294 | 2103632.04316278 | 37.7564188405554 | -122.427951511444 | (37.7564188405554, -122.427951511444) | ||
| 145380 | 145380 | 3309 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4906 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5992353.70305 | 2114187.23257 | 37.784714735763 | -122.47019822996599 | (37.784714735763, -122.470198229966) | |||
| 145381 | 145381 | 62701 | Permitted Site 1 | Tree(s) :: 17 | 2233 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/1986 12:00:00 AM | Permit Number 23041 | 6007540.4 | 2120108.6 | 37.8018396242478 | -122.41807709285101 | (37.8018396242478, -122.418077092851) | |||
| 145382 | 145382 | 5859 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 940X Eddy St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005929.97927 | 2113157.1145599997 | 37.7826618143501 | -122.423155503238 | (37.7826618143501, -122.423155503238) | |||
| 145383 | 145383 | 37308 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 Hill St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39826 | 6003717.20570413 | 2103355.3114542 | 37.7556233268944 | -122.430111288531 | (37.7556233268944, -122.430111288531) | ||
| 145384 | 145384 | 116657 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 199x Esmeralda Ave | 11 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | |||||
| 145385 | 145385 | 102631 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 175 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769999 | 5987997.5 | 2114816.6 | 37.7861899917282 | -122.485315257259 | (37.7861899917282, -122.485315257259) | |||
| 145386 | 145386 | 95851 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 498X Minna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 3x3 | 6010279.2 | 2112410.7 | 37.7808568143498 | -122.408056331236 | (37.7808568143498, -122.408056331236) | |||
| 145387 | 145387 | 45139 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1267 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2001 12:00:00 AM | Permit Number 43996 | 6000511.08946601 | 2109229.61979704 | 37.771570618561604 | -122.44162055585 | (37.7715706185616, -122.44162055585) | ||
| 145388 | 145388 | 100987 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2190 Powell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | |||
| 145389 | 145389 | 94463 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 744 Carolina St | 1 | : 4 | Tree 1 | Private 1 | 06/10/2010 12:00:00 AM | Permit Number 53681 | 6012327.5 | 2104524.9 | 37.759318660176504 | -122.40041614875601 | (37.7593186601765, -122.400416148756) | |||
| 145390 | 145390 | 6278 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1475 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003892.9969 | 2113024.38483 | 37.7821822086902 | -122.43019311854601 | (37.7821822086902, -122.430193118546) | |||
| 145391 | 145391 | 98540 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 4736 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 5998512.0 | 2105692.0 | 37.7617431097225 | -122.448280704282 | (37.7617431097225, -122.448280704282) | ||||
| 145392 | 145392 | 55399 | Permitted Site 1 | Tree(s) :: 17 | 1457 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1972 12:00:00 AM | Permit Number 11336 | 5993329.33887881 | 2105571.36200051 | 37.7611142135138 | -122.46619653516599 | (37.7611142135138, -122.466196535166) | |||
| 145393 | 145393 | 98880 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 101 Lansdale Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 5994747.9 | 2097283.1 | 37.738438484278895 | -122.460689725403 | (37.7384384842789, -122.460689725403) | ||||
| 145394 | 145394 | 55988 | Permitted Site 1 | Tree(s) :: 17 | 227 Hoffman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1973 12:00:00 AM | Permit Number 12063 | 6000642.50231485 | 2102201.35293108 | 37.752280214695794 | -122.440661783879 | (37.7522802146958, -122.440661783879) | |||
| 145395 | 145395 | 51619 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 396(REVISED) Diamond St | 2 | 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) | ||
| 145396 | 145396 | 121735 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1301 Vermont St | 10 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 6011430.0 | 2102074.0 | 37.75253893927721 | -122.403347738299 | (37.7525389392772, -122.403347738299) | ||||
| 145397 | 145397 | 87614 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 800X Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991263.805475 | 2092171.0255200001 | 37.7242009421806 | -122.47236335156099 | (37.7242009421806, -122.472363351561) | ||
| 145398 | 145398 | 99440 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 990X Jamestown Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2012 12:00:00 AM | 3 | 3x10 | Permit Number 768748 | 6014145.42414 | 2089521.2651 | 37.7182229956809 | -122.39307903224501 | (37.7182229956809, -122.393079032245) | |
| 145399 | 145399 | 45277 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 530 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44120 | 6007988.96647408 | 2096402.04290031 | 37.736772218146 | -122.41484606418501 | (37.736772218146, -122.414846064185) | ||
| 145400 | 145400 | 116946 | Undocumented 2 | :: 54 | 3676 23RD ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005238.0 | 2102584.0 | 37.753591501312705 | -122.424797029407 | (37.7535915013127, -122.424797029407) | ||||
| 145401 | 145401 | 45272 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 635 Crescent Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2001 12:00:00 AM | Permit Number 44117 | 6007835.54663504 | 2095717.89639114 | 37.734885079654 | -122.415328087742 | (37.734885079654, -122.415328087742) | |||
| 145402 | 145402 | 19024 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 3170 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 5999571.77228 | 2115429.18678 | 37.7885394709311 | -122.445315519372 | (37.7885394709311, -122.445315519372) | |||
| 145403 | 145403 | 99528 | Permitted Site 1 | Tree(s) :: 17 | 120 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 4x9 | 6014737.1 | 2116083.2 | 37.7911892459774 | -122.392891167069 | (37.7911892459774, -122.392891167069) | ||||
| 145404 | 145404 | 1420 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 50 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3x3 | 5995529.5957 | 2115606.06371 | 37.7887935591586 | -122.45931355109501 | (37.7887935591586, -122.459313551095) | |||
| 145405 | 145405 | 709 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6710X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 5 | 5986789.82302 | 2113953.9673099997 | 37.783751021306 | -122.489429993159 | (37.783751021306, -122.489429993159) | |||
| 145406 | 145406 | 21101 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2201X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5985004.6737667 | 2100227.1692458 | 37.745956718592794 | -122.494593556276 | (37.7459567185928, -122.494593556276) | |||
| 145407 | 145407 | 27787 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 199X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 14 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | ||||
| 145408 | 145408 | 33530 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 173 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/2005 12:00:00 AM | Permit Number 48005 | 6007338.9559133 | 2098056.09080214 | 37.7412773227891 | -122.417210613498 | (37.7412773227891, -122.417210613498) | ||
| 145409 | 145409 | 60263 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2781 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/1984 12:00:00 AM | Permit Number 19819 | 6009497.44754454 | 2103916.17692673 | 37.757489017835496 | -122.410160909746 | (37.7574890178355, -122.410160909746) | ||
| 145410 | 145410 | 115404 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 355 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2016 12:00:00 AM | 3 | Permit Number 776433 | 6006990.5 | 2096060.3 | 37.7357777137995 | -122.418273984634 | (37.7357777137995, -122.418273984634) | ||
| 145411 | 145411 | 37045 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 135 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52533 | 6004283.5298939 | 2100995.32888166 | 37.749175425502 | -122.42798459765801 | (37.749175425502, -122.427984597658) | ||
| 145412 | 145412 | 69526 | Permitted Site 1 | Tree(s) :: 17 | 1375 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/1997 12:00:00 AM | Permit Number 37862 | 5983360.23759536 | 2105792.61802027 | 37.7611415034436 | -122.500691174314 | (37.7611415034436, -122.500691174314) | |||
| 145413 | 145413 | 96426 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2001 Market St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2011 12:00:00 AM | 3x3 | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | |||
| 145414 | 145414 | 36311 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Colon Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1998 12:00:00 AM | Permit Number 39290 | 5996171.57528841 | 2093770.15553217 | 37.72887459674929 | -122.455513542245 | (37.7288745967493, -122.455513542245) | ||
| 145415 | 145415 | 4973 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 5200X Diamond Heights Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6000724.3855206 | 2099633.2111664 | 37.7452333754909 | -122.440194472866 | (37.7452333754909, -122.440194472866) | |||
| 145416 | 145416 | 1496 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 325 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/1997 12:00:00 AM | 6 | 3X3 | 5995521.02545 | 2114091.27362 | 37.7846338611014 | -122.459233466285 | (37.7846338611014, -122.459233466285) | ||
| 145417 | 145417 | 115870 | Undocumented 2 | :: 54 | 84X Cordova St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | on Athens St. Frontage | 6001679.7 | 2087642.4 | 37.712363687575795 | -122.43603329568501 | (37.7123636875758, -122.436033295685) | ||||
| 145418 | 145418 | 53508 | Permitted Site 1 | Tree(s) :: 17 | 238 Ralston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/1969 12:00:00 AM | Permit Number 6418 | 5992226.59125592 | 2089458.03207637 | 37.716807401406705 | -122.468837842897 | (37.7168074014067, -122.468837842897) | |||
| 145419 | 145419 | 18113 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1102X PORTOLA DR | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 10 | 5995249.0 | 2098057.0 | 37.7405922403942 | -122.45901319608299 | (37.7405922403942, -122.459013196083) | |||
| 145420 | 145420 | 115837 | Permitted Site 1 | Tree(s) :: 17 | 20 Burlwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5996349.7575948 | 2095933.20555752 | 37.73482403404479 | -122.45505379547 | (37.7348240340448, -122.45505379547) | |||||
| 145421 | 145421 | 34528 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2856 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1997 12:00:00 AM | Permit Number 38237 | 6001046.30881699 | 2116265.48327203 | 37.7909197844571 | -122.440273859259 | (37.7909197844571, -122.440273859259) | ||
| 145422 | 145422 | 61359 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1234 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2016 12:00:00 AM | 3x3 | Permit Number 21268 | 6008775.22346441 | 2117343.22168335 | 37.7943160027564 | -122.413608310086 | (37.7943160027564, -122.413608310086) | ||
| 145423 | 145423 | 51610 | Permitted Site 1 | Tree(s) :: 17 | 3180 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2005 12:00:00 AM | Permit Number 47907 | 6007119.43532837 | 2103252.52426074 | 37.7555332017865 | -122.418337994685 | (37.7555332017865, -122.418337994685) | |||
| 145424 | 145424 | 809 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 600X 39th Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
| 145425 | 145425 | 88491 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Quesada Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51434 | 6015245.7 | 2094684.2 | 37.732460450023495 | -122.38963620788401 | (37.7324604500235, -122.389636207884) | ||
| 145426 | 145426 | 45252 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 568 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44099 | 6009813.67282905 | 2098883.83763279 | 37.7436890489958 | -122.40871226048701 | (37.7436890489958, -122.408712260487) | ||
| 145427 | 145427 | 19118 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 4 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6003441.17868 | 2108283.19965 | 37.7691384851489 | -122.431417644172 | (37.7691384851489, -122.431417644172) | |||
| 145428 | 145428 | 33475 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 194X COLERIDGE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/1996 12:00:00 AM | 40 | Permit Number 37572 | 6006432.0 | 2098629.0 | 37.742799336995795 | -122.420387207052 | (37.7427993369958, -122.420387207052) | ||
| 145429 | 145429 | 110147 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 90 WOODLAND AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 46 | 4x15 | 5997155.9 | 2105983.7 | 37.762466422316706 | -122.452991942132 | (37.7624664223167, -122.452991942132) | |||
| 145430 | 145430 | 82349 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 238 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50654 | 6002996.74050399 | 2092045.80464214 | 37.7245291995552 | -122.431795416268 | (37.7245291995552, -122.431795416268) | ||
| 145431 | 145431 | 35634 | Permitted Site 1 | Tree(s) :: 17 | 701 Hayes St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1998 12:00:00 AM | Permit Number 38975 | 6004496.45349332 | 2110824.80795168 | 37.7761768741411 | -122.42794864267401 | (37.7761768741411, -122.427948642674) | |||
| 145432 | 145432 | 95914 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1900 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 3x3 | Permit Number 767613 | 5988155.0 | 2102402.0 | 37.75211210611629 | -122.48385972943501 | (37.7521121061163, -122.483859729435) | |
| 145433 | 145433 | 94799 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2495@Ulloa 23rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | Permit Number 767295 | 5989187.3 | 2098380.9 | 37.741131264018 | -122.479995678002 | (37.741131264018, -122.479995678002) | ||
| 145434 | 145434 | 21726 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1942 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6003284.347 | 2114523.85502 | 37.7862648839776 | -122.43240590204701 | (37.7862648839776, -122.432405902047) | |||
| 145435 | 145435 | 66473 | Permitted Site 1 | Tree(s) :: 17 | 185 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/1991 12:00:00 AM | Permit Number 29628 | 6001747.1516664 | 2107731.62649646 | 37.76752784655871 | -122.43723767801 | (37.7675278465587, -122.43723767801) | |||
| 145436 | 145436 | 111852 | Permitted Site 1 | Tree(s) :: 17 | 187 States St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000958.85547421 | 2106373.84069392 | 37.7637548596233 | -122.439866921627 | (37.7637548596233, -122.439866921627) | |||||
| 145437 | 145437 | 49800 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 61@ WEBSTER Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | Permit Number 46592 | 6004436.15215025 | 2109254.48297957 | 37.7718617337201 | -122.42804531145201 | (37.7718617337201, -122.428045311452) | ||
| 145438 | 145438 | 53577 | Permitted Site 1 | Tree(s) :: 17 | 111 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1970 12:00:00 AM | Permit Number 6499 | 5993935.90496102 | 2114787.85768464 | 37.786455233332 | -122.46476801094101 | (37.786455233332, -122.464768010941) | |||
| 145439 | 145439 | 233449 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 3210 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008043.39989 | 2105643.53791 | 37.7621503452727 | -122.41531188402901 | (37.7621503452727, -122.415311884029) | |||
| 145440 | 145440 | 244151 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 403 Rose St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004595.5153 | 2109633.7909 | 37.772912235932004 | -122.427521090443 | (37.772912235932, -122.427521090443) | |||
| 145441 | 145441 | 91972 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1340 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993348.371695 | 2106356.020653 | 37.7632697788308 | -122.46618773317101 | (37.7632697788308, -122.466187733171) | ||
| 145442 | 145442 | 46672 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1440 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | Permit Number 44801 | 5991503.1814322 | 2105610.26517465 | 37.76111550068121 | -122.472515203044 | (37.7611155006812, -122.472515203044) | ||
| 145443 | 145443 | 41726 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 99X 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42172 | 6008031.27943269 | 2107943.20653569 | 37.7684640195804 | -122.415516624702 | (37.7684640195804, -122.415516624702) | ||
| 145444 | 145444 | 35651 | Permitted Site 1 | Tree(s) :: 17 | 634 Fell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1998 12:00:00 AM | Permit Number 38978 | 6004381.87189495 | 2110513.06412186 | 37.7753144191066 | -122.42832278779301 | (37.7753144191066, -122.428322787793) | |||
| 145445 | 145445 | 85742 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 816 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6012158.0 | 2112700.0 | 37.7817561793381 | -122.40157694342501 | (37.7817561793381, -122.401576943425) | ||
| 145446 | 145446 | 49411 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 199X Jarboe Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/25/2003 12:00:00 AM | Permit Number 46360 | 6007877.16091053 | 2097140.48461629 | 37.738793534125 | -122.415284884809 | (37.738793534125, -122.415284884809) | ||
| 145447 | 145447 | 44071 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 21 Willard North St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2000 12:00:00 AM | Permit Number 43594 | 5996093.99693327 | 2111662.09556838 | 37.777996907390104 | -122.45707541518 | (37.7779969073901, -122.45707541518) | |||
| 145448 | 145448 | 55845 | Permitted Site 1 | Tree(s) :: 17 | 1999 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/1973 12:00:00 AM | Permit Number 11894 | 6004781.81052564 | 2108207.79921695 | 37.7690073431478 | -122.42677510206 | (37.7690073431478, -122.42677510206) | |||
| 145449 | 145449 | 20228 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1699 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002579.480222 | 2114044.5496622 | 37.784908839203204 | -122.43481026677 | (37.7849088392032, -122.43481026677) | |||
| 145450 | 145450 | 108400 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1145 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772606 | 6010035.09265 | 2102537.48598 | 37.753733561918395 | -122.408204273916 | (37.7537335619184, -122.408204273916) |
| 145451 | 145451 | 99073 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 567 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006238.6651099995 | 2106285.8034900003 | 37.7638122593075 | -122.421599400126 | (37.7638122593075, -122.421599400126) | |||
| 145452 | 145452 | 92027 | Permitted Site 1 | Tree(s) :: 17 | 80 Crown Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2009 12:00:00 AM | 3x3 | Permit Number 52172 | 5998680.9 | 2104321.8 | 37.7579905367617 | -122.44759791278798 | (37.7579905367617, -122.447597912788) | ||
| 145453 | 145453 | 95270 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2245 Jones St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/23/2016 02:41:00 PM | 3 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | ||
| 145454 | 145454 | 33451 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 321 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37552 | 6006219.56929153 | 2098134.91814119 | 37.7414307262079 | -122.421086659248 | (37.7414307262079, -122.421086659248) | |||
| 145455 | 145455 | 101555 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 435X 11th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6009095.5 | 2108566.4 | 37.770234925082 | -122.411879608901 | (37.770234925082, -122.411879608901) | |||
| 145456 | 145456 | 61340 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 441 Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/17/1984 12:00:00 AM | Permit Number 21245 | 6004862.65889815 | 2110356.13037945 | 37.7749107106258 | -122.42664845598301 | (37.7749107106258, -122.426648455983) | ||
| 145457 | 145457 | 67397 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 615 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1992 12:00:00 AM | Permit Number 30894 | 5990626.25534689 | 2111189.00376145 | 37.776382409214705 | -122.47595552081499 | (37.7763824092147, -122.475955520815) | ||
| 145458 | 145458 | 108842 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 420 Woolsey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 772583 | 6010509.54502 | 2091864.19266 | 37.7244535448266 | -122.405811727659 | (37.7244535448266, -122.405811727659) | |
| 145459 | 145459 | 41362 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 78 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2000 12:00:00 AM | Permit Number 42009 | 6001390.89348952 | 2091809.60482018 | 37.7237894873823 | -122.437329701172 | (37.7237894873823, -122.437329701172) | |||
| 145460 | 145460 | 64479 | Permitted Site 1 | Tree(s) :: 17 | 1135 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1988 12:00:00 AM | Permit Number 25352 | 6017346.79859016 | 2093380.57453278 | 37.7289972322989 | -122.38228147810301 | (37.7289972322989, -122.382281478103) | |||
| 145461 | 145461 | 111714 | Planning Code 138.1 required 4 | Lagunaria patersonii :: Primrose Tree 48 | 3038 CLEMENT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | 1 | 3x3 | Permit Number 777015 | 5986051.0 | 2113265.0 | 37.7818161572934 | -122.491935266217 | (37.7818161572934, -122.491935266217) | |
| 145462 | 145462 | 32560 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 727 Florida St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | Permit Number 37045 | 6009321.36769465 | 2104857.59081295 | 37.7600640559522 | -122.410836353614 | (37.7600640559522, -122.410836353614) | |||
| 145463 | 145463 | 112675 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500x FILBERT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010481.0 | 2120003.0 | 37.8017147408613 | -122.407893747059 | (37.8017147408613, -122.407893747059) |
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");