Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20491 | 20491 | 85214 | Jacaranda mimosifolia :: Jacaranda 52 | 2889 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 04/13/2007 12:00:00 AM | 3 | 3x3 | under 3yr maintenance agreement. ends on 4/13/2007 | 6009588.01504 | 2102148.81833 | 37.75264132339179 | -122.409722943913 | (37.7526413233918, -122.409722943913) | |
| 42741 | 42741 | 85379 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3390 Cesar Chavez St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6007302.06128 | 2100623.1120599997 | 37.7483237124677 | -122.417520070933 | (37.7483237124677, -122.417520070933) | ||||
| 61148 | 61148 | 85309 | Olea europaea :: Olive Tree 41 | 1250 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 07/26/2007 12:00:00 AM | 3 | 3x3 | Under 3 yr maintenance agreement. Ends 7/27/2010. | 6000155.2862 | 2108898.36192 | 37.77064078968729 | -122.442827504693 | (37.7706407896873, -122.442827504693) | |
| 80888 | 80888 | 87432 | Acer rubrum :: Red Maple 6 | 598X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006099.613365 | 2094764.868461 | 37.732170557364995 | -122.421262171784 | (37.732170557365, -122.421262171784) | |||
| 82777 | 82777 | 85446 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y12 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 83194 | 83194 | 87400 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Monterey Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5999413.960874 | 2094696.855647 | 37.7316046219852 | -122.44437099815 | (37.7316046219852, -122.44437099815) | |||
| 85180 | 85180 | 85312 | Lophostemon confertus :: Brisbane Box 11 | 1366 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3x3 | 6003535.852940001 | 2112477.60862 | 37.780660663043605 | -122.431389631549 | (37.7806606630436, -122.431389631549) | ||||
| 88231 | 88231 | 85433 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y1 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 89317 | 89317 | 85483 | Myoporum laetum :: Myoporum 1 | 2448 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6007028.643792 | 2120821.987554 | 37.8037695888063 | -122.419898663276 | (37.8037695888063, -122.419898663276) | ||||
| 91145 | 91145 | 87431 | Acer rubrum :: Red Maple 6 | 522X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006584.964111 | 2094794.1521 | 37.732278314780295 | -122.419586279513 | (37.7322783147803, -122.419586279513) | |||
| 91687 | 91687 | 85306 | Ligustrum lucidum :: Glossy Privet 55 | 1661 Pine St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6005989.138522 | 2115548.501173 | 37.789231309471795 | -122.423120870526 | (37.7892313094718, -122.423120870526) | ||||
| 95026 | 95026 | 85377 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3390 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6007302.06128 | 2100623.1120599997 | 37.7483237124677 | -122.417520070933 | (37.7483237124677, -122.417520070933) | ||||
| 95845 | 95845 | 85448 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y14 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 96265 | 96265 | 85437 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y4 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 96662 | 96662 | 87399 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Monterey Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5999413.960874 | 2094696.855647 | 37.7316046219852 | -122.44437099815 | (37.7316046219852, -122.44437099815) | |||
| 97533 | 97533 | 85444 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y10 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 98712 | 98712 | 85439 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y5 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 99579 | 99579 | 85445 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y11 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 102642 | 102642 | 85435 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y3 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/07/2006 12:00:00 AM | 3 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 103498 | 103498 | 85440 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y6 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 104112 | 104112 | 87433 | Acer rubrum :: Red Maple 6 | 598X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006099.613365 | 2094764.868461 | 37.732170557364995 | -122.421262171784 | (37.732170557365, -122.421262171784) | |||
| 105765 | 105765 | 87423 | Lophostemon confertus :: Brisbane Box 11 | 45X Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6009092.517833999 | 2112687.614007 | 37.7815506408215 | -122.412181237011 | (37.7815506408215, -122.412181237011) | |||
| 105788 | 105788 | 85443 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y9 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | ||||
| 107509 | 107509 | 87402 | Prunus cerasifera :: Cherry Plum 16 | 1300 Webster St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 6003725.160049 | 2113179.0694110002 | 37.7825974263114 | -122.430784800607 | (37.7825974263114, -122.430784800607) | |||
| 108522 | 108522 | 113066 | Cupressus macrocarpa :: Monterey Cypress 47 | 2X Cranleigh Dr | 7 | : 4 | Tree 1 | DPW 2 | 09/09/2015 01:08:00 PM | 3 | 5991370.3 | 2095943.7 | 37.734565924896394 | -122.472270103664 | (37.7345659248964, -122.472270103664) | ||||
| 110133 | 110133 | 87430 | Acer rubrum :: Red Maple 6 | 522X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006584.964111 | 2094794.1521 | 37.732278314780295 | -122.419586279513 | (37.7322783147803, -122.419586279513) | |||
| 117485 | 117485 | 87401 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Monterey Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5999413.960874 | 2094696.855647 | 37.7316046219852 | -122.44437099815 | (37.7316046219852, -122.44437099815) | |||
| 117918 | 117918 | 87429 | Acer rubrum :: Red Maple 6 | 500X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006724.46969 | 2094782.06277 | 37.7322529772765 | -122.419103118684 | (37.7322529772765, -122.419103118684) | |||
| 119480 | 119480 | 87425 | Tree(s) :: 17 | 25X Jones St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6009102.081359 | 2112621.9601169997 | 37.781370907497 | -122.41214351023399 | (37.781370907497, -122.412143510234) | ||||
| 119540 | 119540 | 85436 | Lophostemon confertus :: Brisbane Box 11 | 1397X Buchanan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/17/2007 12:00:00 AM | 3 | 3x3 | Maintenance agreement ends 8/17/2010 | 6004184.830731 | 2113056.513958 | 37.782286952179 | -122.429185796304 | (37.782286952179, -122.429185796304) | |
| 120951 | 120951 | 85249 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1335 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 07/19/2007 12:00:00 AM | 3 | 3x3 | under 3 yr maintenance agreement. expires 7/19/2010 | 6001350.124369999 | 2111060.02557 | 37.7766442216524 | -122.43884948393499 | (37.7766442216524, -122.438849483935) | |
| 122914 | 122914 | 85441 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y7 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 123072 | 123072 | 85434 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y2 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/23/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 123690 | 123690 | 85484 | Myoporum laetum :: Myoporum 1 | 2448 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6007028.643792 | 2120821.987554 | 37.8037695888063 | -122.419898663276 | (37.8037695888063, -122.419898663276) | ||||
| 126348 | 126348 | 85447 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y13 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 128811 | 128811 | 87422 | Lophostemon confertus :: Brisbane Box 11 | 45X Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 6009092.517833999 | 2112687.614007 | 37.7815506408215 | -122.412181237011 | (37.7815506408215, -122.412181237011) | |||||
| 129428 | 129428 | 85380 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3390 Cesar Chavez St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6007302.06128 | 2100623.1120599997 | 37.7483237124677 | -122.417520070933 | (37.7483237124677, -122.417520070933) | ||||
| 138815 | 138815 | 87410 | Lophostemon confertus :: Brisbane Box 11 | 898X Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006570.640875 | 2113589.260791 | 37.783884515657896 | -122.42096977598499 | (37.7838845156579, -122.420969775985) | |||
| 140895 | 140895 | 85310 | Olea europaea :: Olive Tree 41 | 1250 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 07/27/2007 12:00:00 AM | 3 | 3x3 | Under 3 yr maintenance agreement. Ends 7/27/2010. | 6000155.2862 | 2108898.36192 | 37.77064078968729 | -122.442827504693 | (37.7706407896873, -122.442827504693) | |
| 141531 | 141531 | 91166 | Cercis canadensis :: Eastern Redbud 299 | 1548x Quesada Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/31/2009 12:00:00 AM | 3 | 6015526.48125 | 2094420.051093 | 37.7317507154659 | -122.388647039673 | (37.7317507154659, -122.388647039673) | ||||
| 141737 | 141737 | 97434 | Ulmus parvifolia :: Chinese Elm 46 | 1380x Newcomb Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 6016360.63733 | 2094893.94179 | 37.7330981190079 | -122.38579618360501 | (37.7330981190079, -122.385796183605) | ||||
| 143542 | 143542 | 85442 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y8 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 145363 | 145363 | 85250 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1335 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 07/19/2007 12:00:00 AM | 15 | 3x3 | under 3yr maintenance agreement. Expires 7/19/2010. | 6001350.124369999 | 2111060.02557 | 37.7766442216524 | -122.43884948393499 | (37.7766442216524, -122.438849483935) | |
| 672 | 672 | 23002 | Permitted Site 1 | Platanus racemosa :: California Sycamore 81 | 742 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/1994 12:00:00 AM | 20 | 3X3 | 6006210.140269999 | 2105247.24413 | 37.7609590106658 | -122.421624291141 | (37.7609590106658, -122.421624291141) | ||
| 730 | 730 | 195047 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 06th St | 2 | : 4 | Tree 1 | DPW 2 | 03/26/2005 12:00:00 AM | 3 | Width 3ft | Permit Number 42039 | 6011214.59355 | 2111232.18316 | 37.777673209496605 | -122.404737337955 | (37.7776732094966, -122.404737337955) | |
| 899 | 899 | 23949 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 2400X Sacramento St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/15/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773408 | 6003202.444680001 | 2115904.93175 | 37.7900523252984 | -122.43278795880501 | (37.7900523252984, -122.432787958805) | |
| 1275 | 1275 | 4132 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3550 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/2017 12:00:00 AM | 3 | 3x3 | 6006390.9849 | 2100603.33536 | 37.7482181038931 | -122.420669151754 | (37.7482181038931, -122.420669151754) | ||
| 4915 | 4915 | 7094 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1944 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/05/2016 07:16:00 AM | 3 | 3X3 | 5998113.0 | 2109666.0 | 37.7726318847498 | -122.449947100062 | (37.7726318847498, -122.449947100062) | ||
| 6203 | 6203 | 23950 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 2400X Sacramento St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/15/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773408 | 6003173.29907 | 2115903.30394 | 37.7900462027047 | -122.432888683778 | (37.7900462027047, -122.432888683778) | |
| 6674 | 6674 | 5302 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1635 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6001111.6921 | 2113998.3714 | 37.7846986031206 | -122.439885016276 | (37.7846986031206, -122.439885016276) | |||
| 7359 | 7359 | 23947 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 2400X Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/15/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773408 | 6003237.41295 | 2115911.3949 | 37.7900720546314 | -122.432667433453 | (37.7900720546314, -122.432667433453) | |
| 7534 | 7534 | 5301 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1635 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001109.2323 | 2114011.9005 | 37.7847356105359 | -122.43989449671301 | (37.7847356105359, -122.439894496713) | |||
| 7630 | 7630 | 23948 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 2400X Sacramento St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/15/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773408 | 6003227.15919 | 2115908.88128 | 37.7900645713585 | -122.432702730963 | (37.7900645713585, -122.432702730963) | |
| 8191 | 8191 | 23946 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 2400X Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/15/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773408 | 6003257.60965 | 2115913.45554 | 37.7900788579916 | -122.43259770183201 | (37.7900788579916, -122.432597701832) | |
| 8361 | 8361 | 23951 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 2400X Sacramento St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/15/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773408 | 6003144.33072 | 2115898.20328 | 37.790030554519205 | -122.432988547211 | (37.7900305545192, -122.432988547211) | |
| 12923 | 12923 | 111444 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 14 | 6x12 | 5999970.3074 | 2091024.03837 | 37.721551640364396 | -122.442184051271 | (37.7215516403644, -122.442184051271) | ||
| 15418 | 15418 | 94801 | Permitted Site 1 | Tristania conferta :: 79 | 3950X 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6015629.3168 | 2097929.6865 | 37.7413931608426 | -122.388536401689 | (37.7413931608426, -122.388536401689) | |||
| 15516 | 15516 | 22411 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 5800 03rd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/2015 07:23:00 AM | 3 | 3X3 | 6013740.3857 | 2091977.5191 | 37.7249448697993 | -122.394650999472 | (37.7249448697993, -122.394650999472) | ||
| 18592 | 18592 | 5562 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 997 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/14/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768456 | 6005129.17531 | 2102577.9580200003 | 37.7535687642998 | -122.425172939503 | (37.7535687642998, -122.425172939503) | |
| 19194 | 19194 | 5349 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 200X Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/22/2010 12:00:00 AM | 12 | 3x3 | Permit Number 53640 | 6004790.705569999 | 2107143.57223 | 37.7660857344886 | -122.426668539926 | (37.7660857344886, -122.426668539926) | |
| 22403 | 22403 | 9158 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6000 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/01/1993 12:00:00 AM | 3 | 3X3 | 5988286.7863 | 2112649.5845 | 37.7802568294301 | -122.48415543808399 | (37.7802568294301, -122.484155438084) | ||
| 23389 | 23389 | 43452 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 10 | Permit Number 43162 | 5999577.25447 | 2091228.40825 | 37.7220903846374 | -122.44355739787599 | (37.7220903846374, -122.443557397876) | |
| 24577 | 24577 | 43433 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 16 | Permit Number 43162 | 5999846.51913 | 2091089.02473 | 37.7217230223792 | -122.442616616172 | (37.7217230223792, -122.442616616172) | |
| 26060 | 26060 | 43443 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 03/06/2004 12:00:00 AM | 6 | Permit Number 43162 | 5999469.30626 | 2091283.8759 | 37.722236528981206 | -122.44393453036999 | (37.7222365289812, -122.44393453037) | |
| 28704 | 28704 | 43445 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 5 | Permit Number 43162 | 5999858.82768 | 2091082.35027 | 37.7217053974709 | -122.44257358990299 | (37.7217053974709, -122.442573589903) | |
| 33677 | 33677 | 43434 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 7 | Permit Number 43162 | 5999832.90051 | 2091096.8327900001 | 37.7217436851966 | -122.44266425237 | (37.7217436851966, -122.44266425237) | |
| 39173 | 39173 | 43441 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 01/05/2016 12:00:00 AM | 7 | Permit Number 774294 | 5999448.10749 | 2091294.70392 | 37.7222650509726 | -122.444008586831 | (37.7222650509726, -122.444008586831) | |
| 39824 | 39824 | 43966 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 627 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 08/20/2005 12:00:00 AM | 9 | Permit Number 43534 | 6006884.39072 | 2112892.55093 | 37.781989200774206 | -122.41983486151199 | (37.7819892007742, -122.419834861512) | |
| 45283 | 45283 | 43435 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 14 | Permit Number 43162 | 5999819.49506 | 2091104.19362 | 37.7217631321556 | -122.44271111962699 | (37.7217631321556, -122.442711119627) | |
| 45429 | 45429 | 111443 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 17 | 5999927.23458 | 2091047.72982 | 37.7216142367899 | -122.442334641847 | (37.7216142367899, -122.442334641847) | |||
| 52424 | 52424 | 43437 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 03/06/2004 12:00:00 AM | 19 | Permit Number 43162 | 5999381.26407 | 2091328.9112200001 | 37.7223551630339 | -122.44424210479099 | (37.7223551630339, -122.444242104791) | |
| 54575 | 54575 | 111440 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 12 | 5999883.47669 | 2091070.55057 | 37.72167440322979 | -122.442487538293 | (37.7216744032298, -122.442487538293) | |||
| 63781 | 63781 | 43439 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 01/05/2016 12:00:00 AM | 12 | Permit Number 774294 | 5999436.71838 | 2091300.71882 | 37.72228091680579 | -122.44404838812099 | (37.7222809168058, -122.444048388121) | |
| 65476 | 65476 | 43457 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 3 | Permit Number 43162 | 5999502.576 | 2091265.96486 | 37.722189247127105 | -122.443818239036 | (37.7221892471271, -122.443818239036) | |
| 66622 | 66622 | 43448 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 9 | Permit Number 43162 | 5999710.3638 | 2091158.16281 | 37.721905097333 | -122.443092230725 | (37.721905097333, -122.443092230725) | |
| 68075 | 68075 | 43459 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 5 | Permit Number 43162 | 5999660.0285 | 2091185.4802700002 | 37.7219772346577 | -122.443268187573 | (37.7219772346577, -122.443268187573) | |
| 70842 | 70842 | 27231 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 319X Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6003407.79227 | 2093529.1013 | 37.7286252931888 | -122.430480251933 | (37.7286252931888, -122.430480251933) | |||
| 70864 | 70864 | 43453 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999638.45654 | 2091195.87208 | 37.7220045380552 | -122.443343502225 | (37.7220045380552, -122.443343502225) | |
| 71753 | 71753 | 43458 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 5 | Permit Number 43162 | 5999537.11613 | 2091248.65338 | 37.72214368387 | -122.443697599487 | (37.72214368387, -122.443697599487) | |
| 74074 | 74074 | 43442 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 01/05/2016 12:00:00 AM | 14 | Permit Number 774294 | 5999458.08811 | 2091290.64416 | 37.72225447314511 | -122.443973794765 | (37.7222544731451, -122.443973794765) | |
| 75670 | 75670 | 43444 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 2 | Permit Number 43162 | 5999490.75065 | 2091271.846 | 37.722204720867204 | -122.443859538611 | (37.7222047208672, -122.443859538611) | |
| 82264 | 82264 | 107888 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 941 Washington St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946771999 | (37.7944046419585, -122.40879946772) |
| 85417 | 85417 | 98474 | Permitted Site 1 | Casurina stricta :: Beefwood: Drooping She-Oak 309 | 531X Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6x6 | 6009973.6 | 2098264.6 | 37.7419977132603 | -122.408115605514 | (37.7419977132603, -122.408115605514) | |||
| 89282 | 89282 | 91179 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 Polk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.41829917319299 | (37.7785341058364, -122.418299173193) | ||
| 92062 | 92062 | 100665 | Permitted Site 1 | Tree(s) :: 17 | 63 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | FUF 1 | 09/04/2012 12:00:00 AM | 3x3 | Permit Number 769258 | 6003201.8 | 2107946.7 | 37.768200969529204 | -122.432221606092 | (37.7682009695292, -122.432221606092) | |
| 93570 | 93570 | 111448 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 6x7 | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | |||
| 94572 | 94572 | 98483 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 531X Franconia St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6009973.6 | 2098264.6 | 37.7419977132603 | -122.408115605514 | (37.7419977132603, -122.408115605514) | |||
| 94673 | 94673 | 85362 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1250 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/17/2007 12:00:00 AM | Permit Number 49639 | 6000155.2862 | 2108898.36192 | 37.77064078968729 | -122.442827504693 | (37.7706407896873, -122.442827504693) | |||
| 95056 | 95056 | 98485 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 531X Franconia St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6009973.6 | 2098264.6 | 37.7419977132603 | -122.408115605514 | (37.7419977132603, -122.408115605514) | |||
| 96833 | 96833 | 107891 | Permitted Site 1 | Tree(s) :: 17 | 941 Washington St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946771999 | (37.7944046419585, -122.40879946772) | ||||
| 96890 | 96890 | 111446 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | ||||
| 101787 | 101787 | 107890 | Permitted Site 1 | Tree(s) :: 17 | 941 Washington St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946771999 | (37.7944046419585, -122.40879946772) | ||||
| 104700 | 104700 | 98482 | Permitted Site 1 | Casurina stricta :: Beefwood: Drooping She-Oak 309 | 531X Franconia St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009973.6 | 2098264.6 | 37.7419977132603 | -122.408115605514 | (37.7419977132603, -122.408115605514) | |||
| 106253 | 106253 | 85363 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1250 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/17/2007 12:00:00 AM | Permit Number 49639 | 6000155.2862 | 2108898.36192 | 37.77064078968729 | -122.442827504693 | (37.7706407896873, -122.442827504693) | |||
| 107225 | 107225 | 41576 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200 Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/22/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53640 | 6004804.85382115 | 2107218.95663379 | 37.7662935218736 | -122.426624972491 | (37.7662935218736, -122.426624972491) | |
| 111981 | 111981 | 43455 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | Permit Number 43162 | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | ||
| 113461 | 113461 | 111447 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | ||||
| 114568 | 114568 | 91178 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 Polk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.41829917319299 | (37.7785341058364, -122.418299173193) | ||
| 117328 | 117328 | 12801 | Permitted Site 1 | Crateagus spp :: Hawthorn 160 | 2050 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/22/2001 12:00:00 AM | 3 | 4 | 5989040.29385 | 2114718.07128 | 37.7859801539539 | -122.481700287531 | (37.7859801539539, -122.481700287531) | ||
| 119022 | 119022 | 104960 | Permitted Site 1 | :: 54 | 2895 San Bruno Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6011715.1 | 2091289.8 | 37.7229437265236 | -122.401603910944 | (37.7229437265236, -122.401603910944) |
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");