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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 141674 | 141674 | 104634 | Permitted Site 1 | :: 54 | 217 Montcalm St | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 16x16 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.40869248022899 | (37.7455621186719, -122.408692480229) | |||||
| 142588 | 142588 | 104374 | Undocumented 2 | Tree(s) :: 17 | 22 GARDENSIDE DR | 1 | Median : Yard 3 | Landscaping 2 | Private 1 | 50x50 | 5999468.0 | 2101996.0 | 37.7516494117124 | -122.444708626009 | (37.7516494117124, -122.444708626009) | ||||
| 143940 | 143940 | 106932 | Undocumented 2 | Shrub :: Shrub 98 | 358 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 8x10 | 6007793.2 | 2105846.4 | 37.7626932925098 | -122.416191600332 | (37.7626932925098, -122.416191600332) | ||||
| 145017 | 145017 | 99533 | Permitted Site 1 | Tree(s) :: 17 | 188 Spear St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 5x9 | 6014774.7 | 2116168.9 | 37.791426646732894 | -122.39276706915899 | (37.7914266467329, -122.392767069159) | ||||
| 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) | ||||
| 145716 | 145716 | 98878 | Property Tree 7 | Tree(s) :: 17 | 11 Panorama Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998029.0 | 2100213.0 | 37.7466715093679 | -122.449556386849 | (37.7466715093679, -122.449556386849) | ||||||
| 152708 | 152708 | 117679 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 7800 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 19 | Width 3ft | 5982700.570040001 | 2112440.0728599997 | 37.7793547453385 | -122.50346489390199 | (37.7793547453385, -122.503464893902) | |||
| 172552 | 172552 | 140265 | Undocumented 2 | Shrub :: Shrub 98 | 2100X Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 0 | Width 0ft | 5997671.17 | 2110272.3417 | 37.7742714515841 | -122.45151917218 | (37.7742714515841, -122.45151917218) | |||
| 178249 | 178249 | 227519 | Undocumented 2 | Ligustrum ovalifolium :: California privet 284 | 375 Alabama St | 1 | : 4 | Landscaping 2 | Private 1 | 8 | Width 3ft | 6008967.54586 | 2106408.18704 | 37.7643017925286 | -122.41216964832199 | (37.7643017925286, -122.412169648322) | |||
| 114314 | 114314 | 108701 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 478 30th St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774626 | 6003507.49152 | 2098366.3309400002 | 37.7419128730633 | -122.43048058961 | (37.7419128730633, -122.43048058961) | |
| 82393 | 82393 | 108910 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 129 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773054 | 6007361.2 | 2097016.9 | 37.7384251864379 | -122.417060086005 | (37.7384251864379, -122.417060086005) |
| 81307 | 81307 | 20137 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 898 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/11/2011 12:00:00 AM | 3 | 8x4 | Permit Number 54088 | 6003009.7075288 | 2111327.5412022998 | 37.777473032235704 | -122.433127623561 | (37.7774730322357, -122.433127623561) | |
| 102823 | 102823 | 20136 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 890 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/11/2011 12:00:00 AM | 3 | 8x4 | Permit Number 54087 | 6003007.0 | 2111306.0 | 37.777413731872 | -122.43313545029301 | (37.777413731872, -122.433135450293) | |
| 140914 | 140914 | 114321 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2118 47th Ave | 1 | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 01/14/2016 12:00:00 AM | 5x16 | Permit Number 777356 | 5981743.9 | 2100646.6 | 37.7469169691931 | -122.505899765145 | (37.7469169691931, -122.505899765145) | ||
| 128347 | 128347 | 104667 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 172 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 01/19/2016 12:00:00 AM | 6x12 | Permit Number 777366 | 6003998.6 | 2101043.1 | 37.749290469922705 | -122.42897329466999 | (37.7492904699227, -122.42897329467) | |
| 99206 | 99206 | 115258 | Permitted Site 1 | :: 54 | 2150 Jackson St | : Cutout 24 | Landscaping 2 | Private 1 | 01/21/2016 12:00:00 AM | 6x12 | 6003858.0 | 2116995.5 | 37.7930839063862 | -122.430597643601 | (37.7930839063862, -122.430597643601) | ||||
| 114892 | 114892 | 115259 | Permitted Site 1 | :: 54 | 2130 Jackson St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/21/2016 12:00:00 AM | 6x12 | 6003918.8 | 2117004.0 | 37.7931106894063 | -122.43038787884501 | (37.7931106894063, -122.430387878845) | ||||
| 101450 | 101450 | 109486 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1314 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Landscaping 2 | DPW 2 | 01/23/2016 04:50:00 AM | 3 | 3x3 | 6006825.7 | 2115468.8 | 37.7890596427133 | -122.420220804515 | (37.7890596427133, -122.420220804515) | ||
| 10092 | 10092 | 173852 | Permitted Site 1 | :: 54 | 450 Toland St | 7 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 8.5x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10093 | 10093 | 173849 | Permitted Site 1 | :: 54 | 450 Toland St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 17.6x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10096 | 10096 | 173850 | Permitted Site 1 | :: 54 | 450 Toland St | 5 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 13.9x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10097 | 10097 | 173851 | Permitted Site 1 | :: 54 | 450 Toland St | 6 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 27.75x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10098 | 10098 | 173848 | Permitted Site 1 | :: 54 | 450 Toland St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 19.5x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10101 | 10101 | 173846 | Permitted Site 1 | :: 54 | 450 Toland St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 15x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10104 | 10104 | 173847 | Permitted Site 1 | :: 54 | 450 Toland St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 11.85x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10106 | 10106 | 173853 | Permitted Site 1 | :: 54 | 450 Toland St | 8 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 26.75x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 96749 | 96749 | 93115 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 397 San Jose Ave | 1 | Sidewalk: Curb side : 21 | Landscaping 2 | Private 1 | 02/02/2009 12:00:00 AM | 26x6 | Permit Number 53167 | 6006259.6 | 2100887.6 | 37.7489912240508 | -122.42114365927 | (37.7489912240508, -122.42114365927) | ||
| 123584 | 123584 | 109253 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1355 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773041 | 5981790.7 | 2105864.5 | 37.7612466017789 | -122.50612476738199 | (37.7612466017789, -122.506124767382) |
| 42994 | 42994 | 109343 | Permitted Site 1 | :: 54 | 3211 Baker St | 2 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 4x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
| 83041 | 83041 | 109366 | Permitted Site 1 | :: 54 | 1205 Filbert St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 3.125x22 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 84402 | 84402 | 109353 | Private 5 | Ficus Spp. :: 253 | 2505 Pacific Ave | 6 | 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) | ||
| 91154 | 91154 | 109365 | Permitted Site 1 | :: 54 | 1205 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 4.5x16 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 97307 | 97307 | 109345 | Permitted Site 1 | :: 54 | 3211 Baker St | 4 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 8.75x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
| 99464 | 99464 | 109344 | Permitted Site 1 | :: 54 | 3211 Baker St | 3 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 4x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
| 101115 | 101115 | 109364 | Permitted Site 1 | :: 54 | 1205 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 4.5x6 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 104832 | 104832 | 109350 | Private 5 | Ficus Spp. :: 253 | 2505 Pacific Ave | 3 | 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) | ||
| 113379 | 113379 | 109349 | Private 5 | Ficus Spp. :: 253 | 2505 Pacific Ave | 2 | 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) | ||
| 116207 | 116207 | 109368 | Permitted Site 1 | :: 54 | 1205 Filbert St | 5 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 3x22 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 122284 | 122284 | 109352 | Private 5 | Ficus Spp. :: 253 | 2505 Pacific Ave | 5 | 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) | ||
| 124298 | 124298 | 109367 | Permitted Site 1 | :: 54 | 1205 Filbert St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 4.5x6.5 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 125736 | 125736 | 109351 | Private 5 | Ficus Spp. :: 253 | 2505 Pacific Ave | 4 | 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) | ||
| 125946 | 125946 | 109370 | Permitted Site 1 | :: 54 | 2061 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 13x6 | 6007159.6 | 2119443.7 | 37.799992536546505 | -122.41934764587201 | (37.7999925365465, -122.419347645872) | |
| 128427 | 128427 | 109369 | Permitted Site 1 | :: 54 | 2061 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 5x6 | 6007159.6 | 2119443.7 | 37.799992536546505 | -122.41934764587201 | (37.7999925365465, -122.419347645872) | |
| 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) | ||
| 140543 | 140543 | 109342 | Permitted Site 1 | :: 54 | 3211 Baker St | 1 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 1x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
| 81298 | 81298 | 104856 | Permitted Site 1 | :: 54 | 739 27th St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 02/12/2015 12:00:00 AM | 3 | 6001722.3 | 2099959.7 | 37.746186600460604 | -122.43676722664301 | (37.7461866004606, -122.436767226643) | ||||
| 79071 | 79071 | 95369 | Tree(s) :: 17 | 27 Hartford St | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 02/18/2011 12:00:00 AM | 6002651.0 | 2105744.0 | 37.7621216467866 | -122.433969295968 | (37.7621216467866, -122.433969295968) | ||||||
| 145744 | 145744 | 109499 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 99 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774984 | 6002392.9 | 2096233.9 | 37.7359945088656 | -122.43418207236999 | (37.7359945088656, -122.43418207237) |
| 101235 | 101235 | 109535 | Permitted Site 1 | :: 54 | 1234 Filbert St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 1.5x2.4 | 6007007.9 | 2119506.8 | 37.800157248198296 | -122.419877066677 | (37.8001572481983, -122.419877066677) | |
| 112218 | 112218 | 109536 | Permitted Site 1 | :: 54 | 1234 Filbert St | 4 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 1.5x2.4 | 6007007.9 | 2119506.8 | 37.800157248198296 | -122.419877066677 | (37.8001572481983, -122.419877066677) | |
| 126302 | 126302 | 109534 | Permitted Site 1 | :: 54 | 1234 Filbert St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 1.5x2.6 | 6007007.9 | 2119506.8 | 37.800157248198296 | -122.419877066677 | (37.8001572481983, -122.419877066677) | |
| 85124 | 85124 | 85121 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1403 11th Ave | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/27/2007 12:00:00 AM | 7 | 2x2 | Tree 2. Permit Number 49495. | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.46848481907499 | (37.7618848250494, -122.468484819075) | |
| 80534 | 80534 | 96292 | Permitted Site 1 | Tree(s) :: 17 | 1294 Union St | Sidewalk: Property side : Pot 6 | Landscaping 2 | Private 1 | 03/21/2011 12:00:00 AM | 6006773.0 | 2119090.0 | 37.7989995844362 | -122.420660308797 | (37.7989995844362, -122.420660308797) | |||||
| 100936 | 100936 | 96291 | Permitted Site 1 | Tree(s) :: 17 | 1294 Union St | Sidewalk: Property side : Pot 6 | Landscaping 2 | Private 1 | 03/21/2011 12:00:00 AM | 6006773.0 | 2119090.0 | 37.7989995844362 | -122.420660308797 | (37.7989995844362, -122.420660308797) | |||||
| 96541 | 96541 | 110246 | Permitted Site 1 | :: 54 | 1706 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/01/2015 12:00:00 AM | 3 | 1.5x12 | 5987540.7 | 2103643.4 | 37.755484875136204 | -122.486075162345 | (37.7554848751362, -122.486075162345) | ||
| 138475 | 138475 | 96182 | Permitted Site 1 | Tree(s) :: 17 | 330 South Van Ness Ave | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 04/04/2011 12:00:00 AM | Permit Number 767813 | 6007366.0 | 2107749.1 | 37.7678936317448 | -122.417804012618 | (37.7678936317448, -122.417804012618) | ||||
| 127072 | 127072 | 99201 | Permitted Site 1 | Tree(s) :: 17 | 4016 26th St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | DPW 2 | FUF 1 | 04/12/2012 12:00:00 AM | 6x10.5 | Permit Number 768835 | 6003752.7 | 2100736.7 | 37.7484352450997 | -122.429801769855 | (37.7484352450997, -122.429801769855) | ||
| 963 | 963 | 251419 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 39 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/14/2015 12:00:00 AM | 3x3 | 6009068.0 | 2112723.0 | 37.781646426577 | -122.412268559085 | (37.781646426577, -122.412268559085) | |||
| 970 | 970 | 251418 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 39 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/14/2015 12:00:00 AM | 3x3 | 6009068.0 | 2112723.0 | 37.781646426577 | -122.412268559085 | (37.781646426577, -122.412268559085) | |||
| 10638 | 10638 | 96234 | Permitted Site 1 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/15/2011 12:00:00 AM | Permit Number 767856 | ||||||||||
| 87250 | 87250 | 93936 | Permitted Site 1 | Tree(s) :: 17 | 230 Seacliff Ave | Sidewalk: Curb side : 21 | Landscaping 2 | Private 1 | 04/26/2010 12:00:00 AM | 37x6 | 5987086.7 | 2115743.7 | 37.7886824393648 | -122.488534508212 | (37.7886824393648, -122.488534508212) | ||||
| 101338 | 101338 | 110613 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 200 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/27/2015 12:00:00 AM | 3 | 12.8x7.8 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | |
| 79393 | 79393 | 106516 | Permitted Site 1 | Tree(s) :: 17 | 366 Hill St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 05/07/2014 12:00:00 AM | 3X3 | Permit Number 772751 | 6003996.2 | 2103381.7 | 37.755711581068795 | -122.42914832014 | (37.7557115810688, -122.42914832014) | |||
| 1389 | 1389 | 251532 | Permitted Site 1 | :: 54 | 2100X 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 05/15/2017 12:00:00 AM | 3 | 4x11 | |||||||
| 1391 | 1391 | 251531 | Permitted Site 1 | :: 54 | 2100X 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 05/15/2017 12:00:00 AM | 3 | 4x11 | |||||||
| 89308 | 89308 | 103623 | Permitted Site 1 | Taxus baccata :: Irish Yew 241 | 333 El Camino Del Mar | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 06/04/2013 12:00:00 AM | 13x2 | Permit Number 770205 | 5987603.5 | 2115303.5 | 37.787503918723395 | -122.48671414227199 | (37.7875039187234, -122.486714142272) | ||
| 1800 | 1800 | 251700 | Permitted Site 1 | :: 54 | 1560 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 06/05/2017 12:00:00 AM | 3 | 410x11 | Permit Number 780193 | 6003924.0 | 2099150.0 | 37.7440882334859 | -122.429096301435 | (37.7440882334859, -122.429096301435) | |
| 143440 | 143440 | 117372 | Permitted Site 1 | :: 54 | 1533 McAllister St | 5 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 06/08/2016 12:00:00 AM | 3 | 1x2.75 | 6001806.7 | 2111472.8 | 37.777803561930206 | -122.437299621265 | (37.7778035619302, -122.437299621265) | ||
| 101836 | 101836 | 92072 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 3001 Pacific Ave | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 06/18/2009 12:00:00 AM | Permit Number 52188 | 5999733.7 | 2116663.4 | 37.791937538515604 | -122.444844029888 | (37.7919375385156, -122.444844029888) | ||||
| 116050 | 116050 | 111759 | Permitted Site 1 | :: 54 | 1235 47th Ave | 2 | Sidewalk: Curb side : Yard 2 | Landscaping 2 | Private 1 | 06/23/2015 12:00:00 AM | 3 | 6x4 | 5981472.7 | 2106671.7 | 37.7634442160317 | -122.50728446314301 | (37.7634442160317, -122.507284463143) | ||
| 145543 | 145543 | 111758 | Permitted Site 1 | :: 54 | 1235 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 06/23/2015 12:00:00 AM | 3 | 6x6 | 5981472.7 | 2106671.7 | 37.7634442160317 | -122.50728446314301 | (37.7634442160317, -122.507284463143) | ||
| 105398 | 105398 | 117608 | Permitted Site 1 | :: 54 | 450 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 06/29/2016 12:00:00 AM | 3 | 6005708.4 | 2111040.6 | 37.776837876057 | -122.423771533631 | (37.776837876057, -122.423771533631) | |||
| 84066 | 84066 | 83339 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2233 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52332 | 5987590.2167451 | 2100087.03718588 | 37.7457229434205 | -122.485642930331 | (37.7457229434205, -122.485642930331) | ||
| 84751 | 84751 | 82096 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1363 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52338 | 6004802.97001971 | 2120513.88344233 | 37.802797975517294 | -122.42757877147899 | (37.8027979755173, -122.427578771479) | ||
| 97501 | 97501 | 82889 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1423 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52339 | 6004509.13864627 | 2120473.3950974997 | 37.8026701808582 | -122.42859269053001 | (37.8026701808582, -122.42859269053) | ||
| 99500 | 99500 | 83367 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3124-3128 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52345 | 6003823.24826281 | 2119450.20874415 | 37.7998219368855 | -122.43089315213301 | (37.7998219368855, -122.430893152133) | ||
| 102817 | 102817 | 80937 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3124-3128 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52345 | 6003823.24826281 | 2119450.20874415 | 37.7998219368855 | -122.43089315213301 | (37.7998219368855, -122.430893152133) | ||
| 127755 | 127755 | 83007 | Permitted Site 1 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 1058 De Haro St | 1 | Median : Cutout 11 | Landscaping 2 | Private 1 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52381 | 6012170.46860809 | 2103464.70975517 | 37.7563988530014 | -122.40088475581499 | (37.7563988530014, -122.400884755815) | ||
| 128027 | 128027 | 82995 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1412 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52364 | 6016260.71862294 | 2093905.81391215 | 37.730379387125204 | -122.38607277339099 | (37.7303793871252, -122.386072773391) | ||
| 96456 | 96456 | 5412 | Permitted Site 1 | Tree(s) :: 17 | 414 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/07/2008 12:00:00 AM | 3x3 | 6004849.3785887 | 2105949.0211321 | 37.7628090992038 | -122.426380541105 | (37.7628090992038, -122.426380541105) | |||
| 80289 | 80289 | 79468 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 606 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52423 | 6004042.90191121 | 2110875.50885644 | 37.7762904169609 | -122.42952121696301 | (37.7762904169609, -122.429521216963) | ||
| 107139 | 107139 | 82886 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 761 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52437 | 6009240.34446046 | 2110165.45314704 | 37.7746336766823 | -122.41149158097299 | (37.7746336766823, -122.411491580973) | ||
| 107768 | 107768 | 82751 | Permitted Site 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 52 Sheridan St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52446 | 6009256.89976445 | 2109417.42292722 | 37.772580689338 | -122.41138145626002 | (37.772580689338, -122.41138145626) | |
| 107476 | 107476 | 82512 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 52 Tulane St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52482 | 6007264.0 | 2093867.0 | 37.7297707824944 | -122.41717301728399 | (37.7297707824944, -122.417173017284) | ||
| 2270 | 2270 | 253008 | Permitted Site 1 | :: 54 | 1201 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 11x477 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | ||
| 91444 | 91444 | 107078 | Undocumented 2 | Tree(s) :: 17 | 92 Homestead St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 07/25/2014 12:00:00 AM | 3x3.5 | Permit Number 773562 | 6000948.33481 | 2101213.46128 | 37.7495851129185 | -122.439533357227 | (37.7495851129185, -122.439533357227) | |||
| 97405 | 97405 | 85294 | Permitted Site 1 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2255 Mariposa St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 07/27/2007 12:00:00 AM | 2x50 | Permit Number 49675 | 6010752.0 | 2105977.0 | 37.7632178155038 | -122.40596731591499 | (37.7632178155038, -122.405967315915) | |||
| 99380 | 99380 | 119616 | Private 5 | :: 54 | 400 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/28/2016 12:00:00 AM | 3 | 6005873.6969099995 | 2111410.5639299997 | 37.777863036884796 | -122.42322602570499 | (37.7778630368848, -122.423226025705) | |||
| 92510 | 92510 | 88654 | Permitted Site 1 | Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 461 | 94 Danton St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 08/05/2008 12:00:00 AM | Permit Number 51634 | 6002844.0 | 2094598.0 | 37.7315282931893 | -122.43250562955099 | (37.7315282931893, -122.432505629551) | ||||
| 120372 | 120372 | 88656 | Permitted Site 1 | Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 461 | 94 Danton St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 08/05/2008 12:00:00 AM | Permit Number 51634 | 6002844.0 | 2094598.0 | 37.7315282931893 | -122.43250562955099 | (37.7315282931893, -122.432505629551) | ||||
| 49594 | 49594 | 112605 | Permitted Site 1 | :: 54 | 1534 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 08/10/2015 12:00:00 AM | 5.6x12 | 6000465.0 | 2110329.2 | 37.7745871625182 | -122.441858914128 | (37.7745871625182, -122.441858914128) | |||
| 118241 | 118241 | 4313 | DPW Maintained 3 | Shrub :: Shrub 98 | 727 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | DPW 2 | 08/17/2013 12:00:00 AM | 3X3 | 6002321.2517800005 | 2095689.19659 | 37.7344948117373 | -122.434390856497 | (37.7344948117373, -122.434390856497) | |||
| 3170 | 3170 | 208471 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1175 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 08/23/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 780657 | 5991201.16474 | 2105172.16858 | 37.7598951180952 | -122.473527781682 | (37.7598951180952, -122.473527781682) | |
| 3287 | 3287 | 253411 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 4x12 | Permit Number 775218 | 6008256.52806819 | 2110680.03106396 | 37.775991353803896 | -122.414931236288 | (37.7759913538039, -122.414931236288) | |
| 3292 | 3292 | 253409 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 4x12 | Permit Number 775218 | 6008256.52806819 | 2110680.03106396 | 37.775991353803896 | -122.414931236288 | (37.7759913538039, -122.414931236288) | |
| 3295 | 3295 | 253410 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 4x12 | Permit Number 775218 | 6008256.52806819 | 2110680.03106396 | 37.775991353803896 | -122.414931236288 | (37.7759913538039, -122.414931236288) | |
| 3305 | 3305 | 253412 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 4x12 | Permit Number 775218 | 6008256.52806819 | 2110680.03106396 | 37.775991353803896 | -122.414931236288 | (37.7759913538039, -122.414931236288) | |
| 139298 | 139298 | 92611 | Permitted Site 1 | Shrub :: Shrub 98 | 3856 23rd St | Sidewalk: Property side : Pot 6 | Landscaping 2 | Private 1 | 08/31/2009 12:00:00 AM | Permit Number 52924 | 6004067.0 | 2102488.0 | 37.753261698893496 | -122.428839761175 | (37.7532616988935, -122.428839761175) | ||||
| 3639 | 3639 | 253517 | Permitted Site 1 | :: 54 | 559 24th Ave | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 2x4.5 | 5988391.0 | 2112180.0 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | ||
| 3643 | 3643 | 253515 | Permitted Site 1 | :: 54 | 559 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 7x9.5 | 5988391.0 | 2112180.0 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) |
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");