Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType ▲ | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 123910 | 123910 | 96598 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | tree 3 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 5154 | 5154 | 253212 | Permitted Site 1 | Tree(s) :: 17 | 15 Liberty St | 2 | Side Yard : Cutout 18 | tree 3 | Private 1 | 11/08/2017 12:00:00 AM | 3 | 5x5 | Permit Number 780777 | 6006173.0 | 2104008.0 | 37.75755424109929 | -122.421664722498 | (37.7575542410993, -122.421664722498) | |
| 4548 | 4548 | 253634 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 830 Oak St | 1 | Sidewalk: Property side : Cutout 5 | tree 3 | DPW 2 | 6003018.63904 | 2109969.70237 | 37.7737452502421 | -122.43299969185101 | (37.7737452502421, -122.432999691851) | |||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
| 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) | ||||||
| 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) | ||
| 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) | ||||
| 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) | ||||
| 144925 | 144925 | 93163 | Permitted Site 1 | Shrub :: Shrub 98 | 201 Upper Ter | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 12/22/2009 12:00:00 AM | 1x15 | 5999670.5 | 2106448.3 | 37.763885884820205 | -122.444328283325 | (37.7638858848202, -122.444328283325) | |||
| 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) | ||||
| 143915 | 143915 | 93160 | Permitted Site 1 | Tree(s) :: 17 | 201 Upper Ter | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 12/22/2009 12:00:00 AM | 1x1 | 5999670.5 | 2106448.3 | 37.763885884820205 | -122.444328283325 | (37.7638858848202, -122.444328283325) | |||
| 143838 | 143838 | 89015 | Permitted Site 1 | Shrub :: Shrub 98 | 4437 20th St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 09/30/2008 12:00:00 AM | 3x1 | Permit Number 51764 | 6001659.0 | 2104076.0 | 37.757485378077604 | -122.43728079846599 | (37.7574853780776, -122.437280798466) | |||
| 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) | ||
| 143386 | 143386 | 110614 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 200 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 12/31/2015 12:00:00 AM | 3 | 21.4x7.8 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | |
| 143329 | 143329 | 93161 | Permitted Site 1 | Tree(s) :: 17 | 201 Upper Ter | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 12/22/2009 12:00:00 AM | 1x1 | 5999670.5 | 2106448.3 | 37.763885884820205 | -122.444328283325 | (37.7638858848202, -122.444328283325) | |||
| 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) | ||||
| 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) | |||||
| 141475 | 141475 | 104153 | Permitted Site 1 | :: 54 | 525X Church St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 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) | ||
| 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) | ||||
| 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) | |||||
| 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) | ||
| 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) | ||
| 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) | ||||
| 138994 | 138994 | 99532 | Permitted Site 1 | Tree(s) :: 17 | 120 Howard St | 6 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 4x9 | 6014737.1 | 2116083.2 | 37.7911892459774 | -122.392891167069 | (37.7911892459774, -122.392891167069) | ||||
| 138642 | 138642 | 99534 | Permitted Site 1 | Tree(s) :: 17 | 188 Spear St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 5x9 | 6014774.7 | 2116168.9 | 37.791426646732894 | -122.39276706915899 | (37.7914266467329, -122.392767069159) | ||||
| 138621 | 138621 | 104565 | Private 5 | Private shrub :: Private Shrub 64 | 18 FLOOD AVE | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 6000327.0 | 2094154.0 | 37.730166118083794 | -122.44117551704201 | (37.7301661180838, -122.441175517042) | |||||
| 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) | ||||
| 129188 | 129188 | 105003 | Undocumented 2 | Shrub :: Shrub 98 | 607 CONGO ST | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 6000094.1 | 2095817.0 | 37.73471905904071 | -122.44210000591002 | (37.7347190590407, -122.44210000591) | ||||||
| 129064 | 129064 | 99535 | Permitted Site 1 | Tree(s) :: 17 | 188 Spear St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 5x9 | 6014774.7 | 2116168.9 | 37.791426646732894 | -122.39276706915899 | (37.7914266467329, -122.392767069159) | ||||
| 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) | |||
| 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) | |
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | |
| 125875 | 125875 | 89140 | Permitted Site 1 | Tree(s) :: 17 | 3170 23rd St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/06/2008 12:00:00 AM | Permit Number 770875 | 6007866.1 | 2102749.5 | 37.7541940143569 | -122.41572017373001 | (37.7541940143569, -122.41572017373) | ||||
| 125761 | 125761 | 108576 | Property Tree 7 | :: 54 | 2479 Diamond St | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 6002240.0 | 2097369.0 | 37.7391025518434 | -122.434791855338 | (37.7391025518434, -122.434791855338) | |||||
| 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) | ||
| 124767 | 124767 | 99530 | Permitted Site 1 | Tree(s) :: 17 | 120 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 4x9 | 6014737.1 | 2116083.2 | 37.7911892459774 | -122.392891167069 | (37.7911892459774, -122.392891167069) | ||||
| 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) | |
| 123904 | 123904 | 106641 | Private 5 | Private shrub :: Private Shrub 64 | 1323X CLAYTON ST | 1 | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999055.0 | 2105304.0 | 37.7607087868046 | -122.446374778866 | (37.7607087868046, -122.446374778866) | |||||
| 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) |
| 123231 | 123231 | 88829 | Permitted Site 1 | Shrub :: Shrub 98 | 4437 20th St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 09/30/2008 12:00:00 AM | 8x1 | Permit Number 51764 | 6001659.0 | 2104076.0 | 37.757485378077604 | -122.43728079846599 | (37.7574853780776, -122.437280798466) | |||
| 122806 | 122806 | 105040 | Permitted Site 1 | :: 54 | 2660 Harrison St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 2x7 | 6008868.4 | 2102978.1 | 37.7548779915591 | -122.412270115586 | (37.7548779915591, -122.412270115586) | ||||
| 122339 | 122339 | 104861 | Permitted Site 1 | :: 54 | 3458A 18th St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 6006508.0 | 2105569.9 | 37.7618617394874 | -122.42061702780899 | (37.7618617394874, -122.420617027809) | ||||||
| 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) | ||
| 121197 | 121197 | 109754 | Permitted Site 1 | :: 54 | 601 Steiner St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1x12 | 6003025.4 | 2110381.6 | 37.774876602731204 | -122.433005738531 | (37.7748766027312, -122.433005738531) | ||||
| 120634 | 120634 | 116580 | Significant Tree 6 | Shrub :: Shrub 98 | 3000x 19TH AVE | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | MTA 6 | DPW 4 | 3x3 | 5990602.0 | 2095184.0 | 37.7324354869182 | -122.47487091251001 | (37.7324354869182, -122.47487091251) | |||
| 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) | ||||
| 120169 | 120169 | 104564 | Private 5 | Private shrub :: Private Shrub 64 | 18 FLOOD AVE | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 6000327.0 | 2094154.0 | 37.730166118083794 | -122.44117551704201 | (37.7301661180838, -122.441175517042) | |||||
| 119638 | 119638 | 109607 | Private 5 | Shrub :: Shrub 98 | 775 Congo St | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 6000381.8 | 2095947.7 | 37.7350943222142 | -122.44111470541901 | (37.7350943222142, -122.441114705419) | |||||
| 119565 | 119565 | 99732 | Undocumented 2 | Shrub :: Shrub 98 | 4150 Ocean Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 5986619.2 | 2095203.6 | 37.7322576937009 | -122.48864164528798 | (37.7322576937009, -122.488641645288) | |||||
| 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) | |||
| 118218 | 118218 | 104635 | 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) | |||||
| 118010 | 118010 | 109755 | Permitted Site 1 | :: 54 | 601 Steiner St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1x12 | 6003025.4 | 2110381.6 | 37.774876602731204 | -122.433005738531 | (37.7748766027312, -122.433005738531) | ||||
| 117306 | 117306 | 104857 | Permitted Site 1 | :: 54 | 2555 46th Ave | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 5982069.8 | 2097707.6 | 37.7388664658919 | -122.504555139124 | (37.7388664658919, -122.504555139124) | ||||||
| 117077 | 117077 | 89137 | Permitted Site 1 | Tree(s) :: 17 | 3170 23rd St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 10/06/2008 12:00:00 AM | Permit Number 770875 | 6007866.1 | 2102749.5 | 37.7541940143569 | -122.41572017373001 | (37.7541940143569, -122.41572017373) | ||||
| 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) | |
| 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) | ||
| 115664 | 115664 | 85184 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 501 Bartlett St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 12/13/2006 12:00:00 AM | 3x25 | Permit Number 768657 | 6006822.0 | 2100867.0 | 37.748966349809606 | -122.419197411761 | (37.7489663498096, -122.419197411761) | |||
| 115357 | 115357 | 98501 | Property Tree 7 | Tree(s) :: 17 | 232 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998998.0 | 2100740.0 | 37.748173910048706 | -122.446243600021 | (37.7481739100487, -122.446243600021) | ||||||
| 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) | ||||
| 114798 | 114798 | 105147 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 52 Mirabel Ave | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 12/26/2013 12:00:00 AM | 3X3 | Permit Number 771012 | 6007663.7 | 2099931.8 | 37.7464458666696 | -122.41622057503099 | (37.7464458666696, -122.416220575031) | |||
| 114741 | 114741 | 104860 | Permitted Site 1 | :: 54 | 283 Randall St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 6003774.7 | 2097827.3 | 37.7404479510811 | -122.429518236565 | (37.7404479510811, -122.429518236565) | ||||||
| 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) | |
| 114285 | 114285 | 96183 | Permitted Site 1 | Tree(s) :: 17 | 330 South Van Ness Ave | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 6007366.0 | 2107749.1 | 37.7678936317448 | -122.417804012618 | (37.7678936317448, -122.417804012618) | ||||||
| 114228 | 114228 | 99531 | Permitted Site 1 | Tree(s) :: 17 | 120 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 4x9 | 6014737.1 | 2116083.2 | 37.7911892459774 | -122.392891167069 | (37.7911892459774, -122.392891167069) | ||||
| 113603 | 113603 | 104154 | Permitted Site 1 | :: 54 | 525X Church St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 113495 | 113495 | 92775 | Permitted Site 1 | Tree(s) :: 17 | 2701 Pacific Ave | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 10/15/2009 12:00:00 AM | Permit Number 52996 | 6001178.5 | 2116864.5 | 37.7925720539586 | -122.43985945141 | (37.7925720539586, -122.43985945141) | ||||
| 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) | ||
| 113148 | 113148 | 104375 | Undocumented 2 | Tree(s) :: 17 | 30 GARDENSIDE DR | 1 | Median : Yard 3 | Landscaping 2 | Private 1 | 50x50 | 5999465.0 | 2102094.0 | 37.7519183246276 | -122.444726043725 | (37.7519183246276, -122.444726043725) | ||||
| 112497 | 112497 | 104858 | Permitted Site 1 | :: 54 | 4205 24th St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 6001816.0 | 2101720.7 | 37.7510272133613 | -122.43656924920201 | (37.7510272133613, -122.436569249202) | ||||||
| 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) | |
| 111918 | 111918 | 109831 | Permitted Site 1 | :: 54 | 146 Staples Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 12x15.3 | 5999109.5 | 2093827.3 | 37.7291996500545 | -122.445361075989 | (37.7291996500545, -122.445361075989) | ||||
| 111744 | 111744 | 104636 | Permitted Site 1 | :: 54 | 217 Montcalm St | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 16x16 | 6010036.0 | 2099691.0 | 37.7459177905176 | -122.40800041337499 | (37.7459177905176, -122.408000413375) | |||||
| 111084 | 111084 | 89138 | Permitted Site 1 | Tree(s) :: 17 | 3170 23rd St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 10/06/2008 12:00:00 AM | Permit Number 770875 | 6007866.1 | 2102749.5 | 37.7541940143569 | -122.41572017373001 | (37.7541940143569, -122.41572017373) | ||||
| 110920 | 110920 | 85195 | Permitted Site 1 | Tree(s) :: 17 | 333 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 5990168.0 | 2094689.0 | 37.731051182582604 | -122.47633519175501 | (37.7310511825826, -122.476335191755) | ||||||
| 110904 | 110904 | 109242 | Property Tree 7 | Private shrub :: Private Shrub 64 | 2479 DIAMOND ST | Sidewalk: Curb side : Yard 2 | Landscaping 2 | Private 1 | 6002238.1 | 2097343.7 | 37.7390329760373 | -122.434796615916 | (37.7390329760373, -122.434796615916) | ||||||
| 110838 | 110838 | 107348 | Private 5 | Private shrub :: Private Shrub 64 | 260 LANSDALE AVE | 1 | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5995019.0 | 2096651.7 | 37.7367204092857 | -122.459706678853 | (37.7367204092857, -122.459706678853) | |||||
| 110489 | 110489 | 109322 | Undocumented 2 | Private shrub :: Private Shrub 64 | 191 24TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 3x3 | 5988309.1 | 2114757.6 | 37.7860461422813 | -122.484232887865 | (37.7860461422813, -122.484232887865) | ||||
| 110212 | 110212 | 110320 | Property Tree 7 | :: 54 | 9 Imperial Aly | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 6005040.9 | 2119421.8 | 37.7998128500526 | -122.426677597274 | (37.7998128500526, -122.426677597274) | ||||||
| 109480 | 109480 | 92778 | Permitted Site 1 | Ligustrum japonicum :: Japanese Privet 4 | 2701 Pacific Ave | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/15/2009 12:00:00 AM | Permit Number 52996 | 6001178.5 | 2116864.5 | 37.7925720539586 | -122.43985945141 | (37.7925720539586, -122.43985945141) | ||||
| 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) | ||
| 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) | ||
| 106864 | 106864 | 109768 | Permitted Site 1 | :: 54 | 2502X Bush St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1.5x13 | 6001313.62368 | 2114572.17699 | 37.786285618589204 | -122.43922754338101 | (37.7862856185892, -122.439227543381) | ||||
| 106819 | 106819 | 105042 | Permitted Site 1 | :: 54 | 2660 Harrison St | 4 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 2x10 | 6008868.4 | 2102978.1 | 37.7548779915591 | -122.412270115586 | (37.7548779915591, -122.412270115586) | ||||
| 105459 | 105459 | 96289 | Permitted Site 1 | Tree(s) :: 17 | 228 30th St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | Permit Number 767877 | 6005120.0 | 2098458.0 | 37.7422557889482 | -122.42491157296699 | (37.7422557889482, -122.424911572967) | |||||
| 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) | |||
| 105108 | 105108 | 104859 | Permitted Site 1 | :: 54 | 650 Fillmore St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 6003597.7 | 2110555.4 | 37.775386259915 | -122.43103844044701 | (37.775386259915, -122.431038440447) | ||||||
| 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) | ||
| 104353 | 104353 | 98250 | Permitted Site 1 | Tree(s) :: 17 | 650 Eddy St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | Sidewalk landscaping permit adjacent to building. | 6007271.2 | 2113371.6 | 37.783326336649 | -122.41853065554 | (37.783326336649, -122.41853065554) | |||||
| 103907 | 103907 | 106639 | Private 5 | Private shrub :: Private Shrub 64 | 1321X CLAYTON ST | 1 | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998910.0 | 2105100.0 | 37.7601403710114 | -122.44686158716699 | (37.7601403710114, -122.446861587167) | |||||
| 102839 | 102839 | 102414 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1301 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 6000345.0 | 2109213.0 | 37.77151552050871 | -122.44219387377399 | (37.7715155205087, -122.442193873774) |
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");