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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1042 | 1042 | 21994 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2585 03rd St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x6 | 6015909.89309 | 2103367.8988900003 | 37.756340904732596 | -122.387945645479 | (37.7563409047326, -122.387945645479) | |||
| 1055 | 1055 | 21993 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2585 03rd St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x6 | 6015910.4355 | 2103353.3332599998 | 37.756300940646604 | -122.387942753271 | (37.7563009406466, -122.387942753271) | |||
| 2748 | 2748 | 30802 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 109 Chilton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | 10 | 4x6 | Permit Number 34667 | 6001649.83524 | 2095450.8302099998 | 37.733802178321 | -122.43669510478998 | (37.733802178321, -122.43669510479) |
| 3160 | 3160 | 109437 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 940 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x6 | 6003136.3777 | 2111029.1486 | 37.7766609049 | -122.432668109569 | (37.7766609049, -122.432668109569) | |||
| 5246 | 5246 | 243453 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 73 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | 4x6 | 6007416.818030001 | 2098970.61704 | 37.74379278831079 | -122.41700617529699 | (37.7437927883108, -122.417006175297) | |||
| 5707 | 5707 | 23479 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2418 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 38 | 4x6 | 6005891.1574800005 | 2118710.22844 | 37.7979070885885 | -122.423684765642 | (37.7979070885885, -122.423684765642) | |||
| 5853 | 5853 | 105967 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 2878 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2016 12:00:00 AM | 3 | 4x6 | Permit Number 772750 | 5999833.56214 | 2117445.14774 | 37.7940897102319 | -122.44455471813 | (37.7940897102319, -122.44455471813) | |
| 6414 | 6414 | 4690 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 759 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/2016 12:00:00 AM | 3 | 4x6 | 6009199.5663 | 2120013.667 | 37.8016722057411 | -122.412328868611 | (37.8016722057411, -122.412328868611) | ||
| 6683 | 6683 | 7097 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1988 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x6 | 5997952.7475 | 2109617.0075 | 37.7724881931803 | -122.450497895204 | (37.7724881931803, -122.450497895204) | |||
| 7285 | 7285 | 113773 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1718 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 4x6 | 6000060.5464 | 2114943.4646 | 37.7872336928249 | -122.44358953494499 | (37.7872336928249, -122.443589534945) | |||
| 7416 | 7416 | 106674 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 399 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2014 12:00:00 AM | 3 | 4x6 | Permit Number 773354 | 5998100.3376400005 | 2115239.0542599997 | 37.787933313904 | -122.450392722053 | (37.787933313904, -122.450392722053) | |
| 7826 | 7826 | 109436 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 940 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x6 | 6003163.5185 | 2111033.5798 | 37.776674611042296 | -122.43257453823999 | (37.7766746110423, -122.43257453824) | |||
| 8624 | 8624 | 81836 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 400X Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2016 02:06:00 PM | 3 | 4x6 | 6008476.9544400005 | 2113910.80073 | 37.784874658471395 | -122.41439737423599 | (37.7848746584714, -122.414397374236) | ||
| 10211 | 10211 | 108902 | Permitted Site 1 | Ficus laurel :: 256 | 33 Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 4x6 | 6006450.1 | 2109317.2 | 37.772147675466705 | -122.421083366581 | (37.7721476754667, -122.421083366581) | |||
| 10557 | 10557 | 37839 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 4x6 | Permit Number 40134 | 6003658.0147400005 | 2090473.5929 | 37.720249717041504 | -122.42939741397 | (37.7202497170415, -122.42939741397) |
| 10912 | 10912 | 75399 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1350 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 12 | 4x6 | 5988689.6276 | 2099701.3205 | 37.7447278644639 | -122.48181312543501 | (37.7447278644639, -122.481813125435) | |
| 10987 | 10987 | 35857 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 28 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | 28 | 4x6 | Permit Number 39076 | 6002203.07861 | 2092639.23336 | 37.7261135989609 | -122.43458140929899 | (37.7261135989609, -122.434581409299) |
| 11528 | 11528 | 1866 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2555 Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x6 | 6010739.94904 | 2086417.1851299999 | 37.7095100554158 | -122.40463197610599 | (37.7095100554158, -122.404631976106) | |||
| 11731 | 11731 | 15952 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5845 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2016 12:00:00 AM | 15 | 4x6 | 5997201.68184 | 2086560.6022 | 37.7091379006634 | -122.451432624323 | (37.7091379006634, -122.451432624323) | ||
| 11797 | 11797 | 37838 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 4x6 | Permit Number 40134 | 6003644.26117 | 2090451.27602 | 37.720187661114295 | -122.429443364835 | (37.7201876611143, -122.429443364835) |
| 12447 | 12447 | 15954 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5845 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/2013 12:00:00 AM | 3 | 4x6 | 5997263.95979 | 2086584.52293 | 37.709207147548 | -122.451219107291 | (37.709207147548, -122.451219107291) | ||
| 13085 | 13085 | 37840 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/09/2007 12:00:00 AM | 3 | 4x6 | Permit Number 49480 | 6003672.4294 | 2090496.5417099998 | 37.7203135455184 | -122.42934922289801 | (37.7203135455184, -122.429349222898) |
| 13121 | 13121 | 96741 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1090 Quintara St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 4x6 | 5990138.4947 | 2101114.1148 | 37.7486911796305 | -122.476906485462 | (37.7486911796305, -122.476906485462) | |||
| 13397 | 13397 | 21932 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2347 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x6 | 6015827.11845 | 2104498.44752 | 37.7594405647419 | -122.388310813407 | (37.7594405647419, -122.388310813407) | |||
| 14383 | 14383 | 118374 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 4x6 | 6014693.17098 | 2114681.8097099997 | 37.787338911495 | -122.392945071183 | (37.787338911495, -122.392945071183) | |||
| 14911 | 14911 | 21988 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2585 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x6 | 6015920.52958 | 2103275.9123 | 37.756088918284604 | -122.38790244203899 | (37.7560889182846, -122.387902442039) | |||
| 14917 | 14917 | 21989 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2585 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x6 | 6015918.99863 | 2103291.42641 | 37.7561314319344 | -122.38790881913401 | (37.7561314319344, -122.387908819134) | |||
| 15919 | 15919 | 96192 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1634 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x6 | 6015129.8118 | 2097200.08447 | 37.739362129854605 | -122.390212570161 | (37.7393621298546, -122.390212570161) | |||
| 17117 | 17117 | 625 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3160 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4x6 | 6007920.1411 | 2102115.05717 | 37.7524550160009 | -122.415488371495 | (37.7524550160009, -122.415488371495) | |||
| 17302 | 17302 | 10349 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 978 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/14/2012 12:00:00 AM | 3 | 4x6 | 6001439.9402 | 2109063.1942 | 37.7711665324235 | -122.438395689895 | (37.7711665324235, -122.438395689895) | ||
| 18453 | 18453 | 63923 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1762 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1987 12:00:00 AM | 10 | 4x6 | Permit Number 24645 | 5981062.59870673 | 2103072.00706036 | 37.7535363264903 | -122.50843561578999 | (37.7535363264903, -122.50843561579) | |
| 19745 | 19745 | 105202 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 708 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4x6 | 5984164.05462 | 2110996.44068 | 37.7754768768809 | -122.49829551344999 | (37.7754768768809, -122.49829551345) | |||
| 26030 | 26030 | 118375 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 4x6 | 6014712.487269999 | 2114662.02755 | 37.7872856671566 | -122.392876855803 | (37.7872856671566, -122.392876855803) | |||
| 39304 | 39304 | 97751 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2478 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x6 | 5989249.1358 | 2098482.8133 | 37.741414683908 | -122.479789330113 | (37.741414683908, -122.479789330113) | |||
| 41792 | 41792 | 101405 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 699 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 4x6 | 6011850.96946 | 2105175.58933 | 37.7610787230206 | -122.40210997848801 | (37.7610787230206, -122.402109978488) | |||
| 46828 | 46828 | 84740 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 143 Alhambra St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 13 | 4x6 | Permit Number 49254 | 6001588.49283 | 2120281.76365 | 37.8019782934262 | -122.438685839601 | (37.8019782934262, -122.438685839601) | |
| 49477 | 49477 | 107593 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1801 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x6 | 5993030.37815 | 2112040.04561 | 37.7788582423825 | -122.467700965505 | (37.7788582423825, -122.467700965505) | |||
| 54278 | 54278 | 52209 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 940 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2010 12:00:00 AM | 18 | 4x6 | Permit Number 48393 | 6003183.4587 | 2111035.7953 | 37.776681825025705 | -122.432505717559 | (37.7766818250257, -122.432505717559) | |
| 60575 | 60575 | 97304 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 286 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 4x6 | 5988088.898709999 | 2114071.8675 | 37.7841504923954 | -122.484944388792 | (37.7841504923954, -122.484944388792) | |||
| 64454 | 64454 | 66017 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 275 Mallorca Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/1990 12:00:00 AM | 14 | 4x6 | Permit Number 29051 | 6001407.55172 | 2120880.78332 | 37.80361274738421 | -122.439354942382 | (37.8036127473842, -122.439354942382) | |
| 66023 | 66023 | 102260 | Undocumented 2 | Tree(s) :: 17 | 1350 46th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 24 | 4x6 | 5981875.8 | 2105892.8 | 37.761329314711105 | -122.505832545781 | (37.7613293147111, -122.505832545781) | |||
| 76409 | 76409 | 113646 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |
| 77524 | 77524 | 113650 | Planning Code 138.1 required 4 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 98X 10TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |||
| 78293 | 78293 | 118379 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 79096 | 79096 | 84742 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 147 Alhambra St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 4x6 | Permit Number 49255 | 6001618.0 | 2120311.0 | 37.8020602472718 | -122.438585827087 | (37.8020602472718, -122.438585827087) | ||
| 80525 | 80525 | 58658 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 156 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1979 12:00:00 AM | 5 | 4x6 | Permit Number 17880 | 5998305.93088846 | 2107861.15660547 | 37.7676872828481 | -122.449149686906 | (37.7676872828481, -122.449149686906) | |
| 83570 | 83570 | 118377 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 84179 | 84179 | 98330 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 147 Alhambra St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 4x6 | Permit Number 49255 | 6001593.9 | 2120254.3 | 37.801903193112004 | -122.438665159251 | (37.801903193112, -122.438665159251) | ||
| 84543 | 84543 | 24159 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 110X Whitney Young Cir | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x6 | 6016346.0952597 | 2096044.1423308998 | 37.736255534298 | -122.38592660691401 | (37.736255534298, -122.385926606914) | |||
| 85284 | 85284 | 54360 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1419 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1972 12:00:00 AM | 4x6 | Permit Number 10124 | 5994249.19374581 | 2105850.67288251 | 37.7619341574341 | -122.463035442996 | (37.7619341574341, -122.463035442996) | ||
| 85547 | 85547 | 105002 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 3418 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | Permit Number 768912 | 6006889.6 | 2100911.6 | 37.7490926180804 | -122.41896681303899 | (37.7490926180804, -122.418966813039) | |||
| 85808 | 85808 | 98327 | Permitted Site 1 | Acacia spp :: Acacia Spp 176 | 143 Alhambra St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 4x6 | Permit Number 49254 | 6001613.1 | 2120268.4 | 37.8019430002039 | -122.43859972925199 | (37.8019430002039, -122.438599729252) | ||
| 85873 | 85873 | 38252 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1556 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | 24 | 4x6 | Permit Number 40362 | 6007050.76125355 | 2107358.39166569 | 37.76680309330379 | -122.418866676369 | (37.7668030933038, -122.418866676369) | |
| 86177 | 86177 | 22953 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 460 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4x6 | 6006126.2342864005 | 2106915.2740853 | 37.7655342966506 | -122.422032984881 | (37.7655342966506, -122.422032984881) | |||
| 86944 | 86944 | 118378 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 87892 | 87892 | 54921 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 363 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1972 12:00:00 AM | 13 | 4x6 | Permit Number 10790 | 5992776.0461415 | 2094204.68994573 | 37.7298722918639 | -122.467283605749 | (37.7298722918639, -122.467283605749) | |
| 88866 | 88866 | 102110 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 925 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x6 | Permit Number 769970 | 6000481.0 | 2101964.0 | 37.751619302581794 | -122.441203254922 | (37.7516193025818, -122.441203254922) | ||
| 89450 | 89450 | 118380 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 89645 | 89645 | 59689 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 127 Seal Rock Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/1981 12:00:00 AM | 22 | 4x6 | Permit Number 19116 | 5981272.46613438 | 2112932.65624215 | 37.780623172919 | -122.508441791304 | (37.780623172919, -122.508441791304) | |
| 90021 | 90021 | 112020 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1819 ALABAMA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4x6 | 6009377.0 | 2099030.0 | 37.7440659114015 | -122.41023249342399 | (37.7440659114015, -122.410232493424) | |||
| 91065 | 91065 | 63004 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 368 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/1986 12:00:00 AM | 20 | 4x6 | Permit Number 23414 | 6007279.07639479 | 2096499.56656681 | 37.737000082845704 | -122.417307379598 | (37.7370000828457, -122.417307379598) |
| 91252 | 91252 | 121450 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 125 Seacliff Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 5987419.0 | 2115743.0 | 37.78869990173229 | -122.48738476247401 | (37.7886999017323, -122.487384762474) | ||||
| 91419 | 91419 | 64168 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 770 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1987 12:00:00 AM | 20 | 4x6 | Permit Number 24949 | 5991979.28943 | 2110202.2151 | 37.7737513136845 | -122.471203129362 | (37.7737513136845, -122.471203129362) |
| 91908 | 91908 | 51736 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 4x6 | Permit Number 48910 | 6000172.52130735 | 2092388.14283689 | 37.7253086814057 | -122.44158289611 | (37.7253086814057, -122.44158289611) | |
| 92646 | 92646 | 54369 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1444 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1972 12:00:00 AM | 4x6 | Permit Number 10135 | 5994306.99010384 | 2105683.08083554 | 37.761477322240005 | -122.462823390787 | (37.76147732224, -122.462823390787) | ||
| 93241 | 93241 | 115836 | Undocumented 2 | Yucca elephantipes :: Giant Yucca 211 | 463 LOS PALMOS DR | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 4x6 | 5997227.0 | 2095765.0 | 37.7344124695252 | -122.45200874852101 | (37.7344124695252, -122.452008748521) | |||
| 95552 | 95552 | 120997 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 360 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6010836.0 | 2115566.0 | 37.7895516808253 | -122.406352466288 | (37.7895516808253, -122.406352466288) | ||||
| 95753 | 95753 | 113653 | Planning Code 138.1 required 4 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 98X 10TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |||
| 100119 | 100119 | 24207 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80X Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2008 12:00:00 AM | 8 | 4x6 | 6016364.4746918 | 2096121.5533417999 | 37.736469106467 | -122.38586845516501 | (37.736469106467, -122.385868455165) | ||
| 100575 | 100575 | 110968 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2411 WASHINGTON ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x6 | 6003071.0 | 2116473.0 | 37.7916046396744 | -122.433283354559 | (37.7916046396744, -122.433283354559) | ||||
| 101113 | 101113 | 113643 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |
| 102981 | 102981 | 21991 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2585 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x6 | 6015885.54141 | 2103557.92781 | 37.7568613347581 | -122.38804312319799 | (37.7568613347581, -122.388043123198) | |||
| 104148 | 104148 | 113647 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |
| 104505 | 104505 | 11733 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/2008 12:00:00 AM | 3 | 4x6 | 5991216.9689233005 | 2091217.0890623 | 37.7215789580388 | -122.472455744827 | (37.7215789580388, -122.472455744827) | ||
| 106186 | 106186 | 108242 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201 SUSSEX ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6001706.4 | 2096365.4 | 37.736316590068895 | -122.436564983425 | (37.7363165900689, -122.436564983425) | ||||
| 106310 | 106310 | 115235 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 58 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2016 12:00:00 AM | 3 | 4x6 | Permit Number 777338 | 5989295.302490001 | 2114868.10873 | 37.7864069399285 | -122.480829025898 | (37.7864069399285, -122.480829025898) | |
| 106915 | 106915 | 113654 | Planning Code 138.1 required 4 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 98X 10TH ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |||
| 107442 | 107442 | 113644 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |
| 108427 | 108427 | 113652 | Planning Code 138.1 required 4 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 98X 10TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |||
| 109097 | 109097 | 115548 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 368 Highland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 20 | 4x6 | 6007279.07639479 | 2096499.56656681 | 37.737000082845704 | -122.417307379598 | (37.7370000828457, -122.417307379598) | ||
| 109208 | 109208 | 118376 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 109326 | 109326 | 54368 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1440 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1972 12:00:00 AM | 4x6 | Permit Number 10134 | 5994306.09362611 | 2105709.13929636 | 37.76154882037861 | -122.462828381839 | (37.7615488203786, -122.462828381839) | ||
| 109416 | 109416 | 21969 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2565 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x6 | 6015991.1899 | 2103495.5101900003 | 37.756695801845204 | -122.38767339341999 | (37.7566958018452, -122.38767339342) | |||
| 112221 | 112221 | 21975 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2565 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 4x6 | 6015991.1899 | 2103495.5101900003 | 37.756695801845204 | -122.38767339341999 | (37.7566958018452, -122.38767339342) | |||
| 112854 | 112854 | 113649 | Planning Code 138.1 required 4 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 98X 10TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |||
| 112935 | 112935 | 105001 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 3418 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6006889.6 | 2100911.6 | 37.7490926180804 | -122.41896681303899 | (37.7490926180804, -122.418966813039) | ||||
| 115824 | 115824 | 65254 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1031 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | 4x6 | Permit Number 28053. Expanded basin to 4x6 | 6009460.81528619 | 2103170.09802024 | 37.755438399754894 | -122.41023492456199 | (37.7554383997549, -122.410234924562) | |
| 116265 | 116265 | 107575 | Undocumented 2 | Tree(s) :: 17 | 501X 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 5993143.49055 | 2111731.21756 | 37.778016814477 | -122.46728720678301 | (37.778016814477, -122.467287206783) | ||||
| 116670 | 116670 | 24206 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80X Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x6 | 6016364.4746918 | 2096121.5533417999 | 37.736469106467 | -122.38586845516501 | (37.736469106467, -122.385868455165) | |||
| 117091 | 117091 | 121325 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 125 Seacliff Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 5987419.0 | 2115743.0 | 37.78869990173229 | -122.48738476247401 | (37.7886999017323, -122.487384762474) | ||||
| 117522 | 117522 | 94963 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3098 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2010 12:00:00 AM | 5 | 4x6 | 5999362.0 | 2116697.3 | 37.7920093994348 | -122.44613254842899 | (37.7920093994348, -122.446132548429) | ||
| 118039 | 118039 | 21959 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2525 03RD ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x6 | 6015860.3 | 2103824.9 | 37.7575929852339 | -122.388149048897 | (37.7575929852339, -122.388149048897) | |||
| 119721 | 119721 | 3353 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5700 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 4x6 | 5989856.36111 | 2114068.46595 | 37.7842439409077 | -122.47882942010901 | (37.7842439409077, -122.478829420109) | |||
| 119948 | 119948 | 113645 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |
| 120401 | 120401 | 47857 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1381 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | 4x6 | Permit Number 45615 | 5982740.72204483 | 2105732.34129465 | 37.7609396108407 | -122.502829315151 | (37.7609396108407, -122.502829315151) | ||
| 120517 | 120517 | 113648 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |
| 120591 | 120591 | 24208 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 80X Whitney Young Cir | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x6 | 6016364.4746918 | 2096121.5533417999 | 37.736469106467 | -122.38586845516501 | (37.736469106467, -122.385868455165) | |||
| 122978 | 122978 | 24169 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 95X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4x6 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | |||
| 123362 | 123362 | 76037 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/16/1996 12:00:00 AM | 6 | 4x6 | 6005804.42794414 | 2120704.37010887 | 37.8033775968655 | -122.42412676624 | (37.8033775968655, -122.42412676624) | |
| 123923 | 123923 | 7922 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1295X Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 32 | 4x6 | 6005919.56037 | 2114492.67616 | 37.786328349346 | -122.423286518029 | (37.786328349346, -122.423286518029) |
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");