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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 96 | 96 | 251196 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 900X 14th St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/22/2017 12:00:00 AM | 3 | 6002515.0 | 2107976.0 | 37.768242455454995 | -122.43459927073098 | (37.768242455455, -122.434599270731) | |||
| 23162 | 23162 | 251173 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 367 Jersey St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Width 3ft | 6002770.52649 | 2101500.0126900002 | 37.7504754543841 | -122.43325263672399 | (37.7504754543841, -122.433252636724) | ||||
| 23001 | 23001 | 251172 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 363 Jersey St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002784.74363 | 2101501.25508 | 37.750479672211 | -122.433203561601 | (37.750479672211, -122.433203561601) | |||||
| 22896 | 22896 | 251145 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 200X Clarendon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996559.0 | 2104265.0 | 37.7577130831875 | -122.454932197022 | (37.7577130831875, -122.454932197022) | ||||
| 22892 | 22892 | 251144 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 200X Clarendon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996559.0 | 2104265.0 | 37.7577130831875 | -122.454932197022 | (37.7577130831875, -122.454932197022) | ||||
| 22866 | 22866 | 251139 | Significant Tree 6 | Tree(s) :: 17 | 621X Gough St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 03/10/2017 12:00:00 AM | 3 | Permit Number 779685 | |||||||
| 22303 | 22303 | 248958 | Significant Tree 6 | Pinus Spp :: Pine Spp 105 | 98x Rosewood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2017 12:00:00 AM | 3 | 3x3 | 5994824.0 | 2095658.0 | 37.7339807377795 | -122.460308897898 | (37.7339807377795, -122.460308897898) | ||
| 22304 | 22304 | 248911 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 1633 Oakdale Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6014844.92913 | 2095599.8976 | 37.7349525388235 | -122.39108575959101 | (37.7349525388235, -122.391085759591) | |||||
| 4549 | 4549 | 226945 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 998 Chenery St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 1ft | 6001140.61217 | 2096125.6115299999 | 37.735626018710896 | -122.438503967885 | (37.7356260187109, -122.438503967885) | |||
| 22897 | 22897 | 215094 | Significant Tree 6 | Tree(s) :: 17 | 218 Sadowa St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/13/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779008 | 5994821.63014 | 2087784.2030900002 | 37.7123610457095 | -122.45974695827199 | (37.7123610457095, -122.459746958272) | |
| 22894 | 22894 | 206842 | Significant Tree 6 | Tree(s) :: 17 | 218 Sadowa St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/13/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779008 | 5994803.1874 | 2087784.4983 | 37.712360795684 | -122.45981072288001 | (37.712360795684, -122.45981072288) | |
| 484 | 484 | 205880 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 44 Mendosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 43 | Width 3ft | 5993348.04769 | 2101170.42115 | 37.7490314462559 | -122.46581205990499 | (37.7490314462559, -122.465812059905) | |||
| 13315 | 13315 | 187668 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 49 | 100x OGDEN AVE | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6007659.0 | 2096105.0 | 37.7359380573488 | -122.41596587682 | (37.7359380573488, -122.41596587682) | |||||
| 13306 | 13306 | 187657 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2072 15th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3x3 | 5991666.0 | 2101424.0 | 37.7496305363998 | -122.47164701446 | (37.7496305363998, -122.47164701446) | ||||
| 13307 | 13307 | 187654 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 375 Woodside Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3x3 | 5997267.0 | 2099886.0 | 37.7457300260474 | -122.452167701039 | (37.7457300260474, -122.452167701039) | ||||
| 13301 | 13301 | 187651 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 175 Raccoon Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5998689.0 | 2104063.0 | 37.7572803991188 | -122.447551270828 | (37.7572803991188, -122.447551270828) | |||||
| 13290 | 13290 | 187642 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 13 | 2526 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006264.0 | 2119500.0 | 37.8000966404513 | -122.42245076966002 | (37.8000966404513, -122.42245076966) | ||||
| 13271 | 13271 | 187638 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 875 El Camino Del Mar | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5985641.0 | 2114972.0 | 37.786479112006 | -122.493479464676 | (37.786479112006, -122.493479464676) | ||||
| 13275 | 13275 | 187637 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 875 El Camino Del Mar | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5985641.0 | 2114972.0 | 37.786479112006 | -122.493479464676 | (37.786479112006, -122.493479464676) | ||||
| 13267 | 13267 | 187629 | Significant Tree 6 | Acer japonicum :: Japanese Maple 183 | 4283 23rd St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6001353.0 | 2102279.0 | 37.7525338497288 | -122.43821033719401 | (37.7525338497288, -122.438210337194) | ||||
| 3818 | 3818 | 178337 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 401 Ocean Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 29 | 5998676.28102 | 2091524.0079700002 | 37.7228506076618 | -122.44669308741301 | (37.7228506076618, -122.446693087413) | ||||
| 3799 | 3799 | 178336 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 401 Ocean Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 29 | Width 8ft | 5998664.9682 | 2091522.93582 | 37.722847017548204 | -122.44673211618999 | (37.7228470175482, -122.44673211619) | |||
| 3803 | 3803 | 178335 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 401 Ocean Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 33 | Width 8ft | 5998656.04486 | 2091523.1214700001 | 37.72284701755029 | -122.44676297552601 | (37.7228470175503, -122.446762975526) | |||
| 3811 | 3811 | 177743 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 401 Ocean Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 37 | 5998700.41574 | 2091522.98281 | 37.722849171448395 | -122.446609585371 | (37.7228491714484, -122.446609585371) | ||||
| 3806 | 3806 | 177110 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 6 | Width 5ft | 5998978.57855 | 2091518.5364400002 | 37.722852847868 | -122.445647719081 | (37.722852847868, -122.445647719081) | |||
| 3801 | 3801 | 177109 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 6 | Width 5ft | 5998958.08532 | 2091518.52367 | 37.72285164275971 | -122.445718558684 | (37.7228516427597, -122.445718558684) | |||
| 3808 | 3808 | 177108 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 5 | Width 5ft | 5998950.80755 | 2091518.23612 | 37.7228504376851 | -122.44574369563999 | (37.7228504376851, -122.44574369564) | |||
| 3827 | 3827 | 177106 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 7 | Width 5ft | 5998933.177730001 | 2091518.16383 | 37.7228492325857 | -122.44580463279199 | (37.7228492325857, -122.445804632792) | |||
| 3805 | 3805 | 177105 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 4 | Width 5ft | 5998924.5969 | 2091518.7811599998 | 37.7228504376811 | -122.445834339179 | (37.7228504376811, -122.445834339179) | |||
| 3826 | 3826 | 177104 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 4 | Width 5ft | 5998921.0818300005 | 2091519.29315 | 37.722851642780796 | -122.44584652679501 | (37.7228516427808, -122.445846526795) | |||
| 11570 | 11570 | 174950 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 309 Crestlake Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5987294.0 | 2096147.0 | 37.7348873783654 | -122.486377975564 | (37.7348873783654, -122.486377975564) | ||||
| 563 | 563 | 173951 | Significant Tree 6 | Tree(s) :: 17 | 2646 Union St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 04/11/2017 12:00:00 AM | 3 | 10x10 | Permit Number 779549 | 6000338.0 | 2118225.0 | 37.796259749404605 | -122.442865342513 | (37.7962597494046, -122.442865342513) | |
| 10256 | 10256 | 173933 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 190 Beacon St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003193.0 | 2097540.0 | 37.739626138558705 | -122.43150902083299 | (37.7396261385587, -122.431509020833) | |||||
| 10223 | 10223 | 173927 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 240 States St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001213.0 | 2106258.0 | 37.7634512529938 | -122.438979613423 | (37.7634512529938, -122.438979613423) | |||||
| 10208 | 10208 | 173903 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 675 Corbett Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999984.0 | 2103563.0 | 37.7559814441149 | -122.44303676104799 | (37.7559814441149, -122.443036761048) | |||||
| 10151 | 10151 | 173889 | Significant Tree 6 | Gleditsia triacanthos :: Honey Locust 67 | 190 Holladay Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010824.0 | 2099939.0 | 37.746642831954496 | -122.405293064953 | (37.7466428319545, -122.405293064953) | ||||
| 10190 | 10190 | 173887 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 2931 20th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6009454.0 | 2104482.0 | 37.759040204703496 | -122.41035112011801 | (37.7590402047035, -122.410351120118) | |||||
| 10174 | 10174 | 173886 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 2931 20th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6009454.0 | 2104482.0 | 37.759040204703496 | -122.41035112011801 | (37.7590402047035, -122.410351120118) | |||||
| 10000 | 10000 | 173780 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 99X Cleveland St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x6 | 6010549.0 | 2110746.0 | 37.7763010397716 | -122.40700558704799 | (37.7763010397716, -122.407005587048) | ||||
| 9987 | 9987 | 173779 | Significant Tree 6 | Ficus macrophylla :: Morton Bay Fig 148 | 99X Cleveland St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x6 | 6010549.0 | 2110746.0 | 37.7763010397716 | -122.40700558704799 | (37.7763010397716, -122.407005587048) | ||||
| 10010 | 10010 | 173778 | Significant Tree 6 | Tree(s) :: 17 | 99X Cleveland St | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 3x3 | 6010549.0 | 2110746.0 | 37.7763010397716 | -122.40700558704799 | (37.7763010397716, -122.407005587048) | ||||
| 9912 | 9912 | 173731 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 484 Chenery St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003566.0 | 2096120.0 | 37.7357482768139 | -122.43011807363199 | (37.7357482768139, -122.430118073632) | |||||
| 9883 | 9883 | 173726 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1101 Connecticut St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6013424.0 | 2101939.0 | 37.752279425117294 | -122.396442635345 | (37.7522794251173, -122.396442635345) | |||||
| 9862 | 9862 | 173716 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 1652 Fell St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 5999516.0 | 2109850.0 | 37.7732172801378 | -122.445107222354 | (37.7732172801378, -122.445107222354) | |||||
| 9752 | 9752 | 173678 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 299x Beale St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
| 9749 | 9749 | 173677 | Significant Tree 6 | Populus trichocarpa :: Black Cottonwood Poplar 258 | 299x Beale St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
| 9741 | 9741 | 173676 | Significant Tree 6 | Populus trichocarpa :: Black Cottonwood Poplar 258 | 299x Beale St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
| 9738 | 9738 | 173675 | Significant Tree 6 | Populus trichocarpa :: Black Cottonwood Poplar 258 | 299x Beale St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
| 9743 | 9743 | 173674 | Significant Tree 6 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 299x Beale St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
| 9744 | 9744 | 173673 | Significant Tree 6 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 299x Beale St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
| 9750 | 9750 | 173672 | Significant Tree 6 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 299x Beale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
| 9740 | 9740 | 173671 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 299x Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
| 9726 | 9726 | 173663 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 3878 17th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6003109.0 | 2105964.0 | 37.7627516946294 | -122.432400964417 | (37.7627516946294, -122.432400964417) | ||||
| 1357 | 1357 | 173636 | Significant Tree 6 | Tree(s) :: 17 | 2590 Pacific Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779167 | 6001760.0 | 2117029.0 | 37.7930568116395 | -122.43785923271999 | (37.7930568116395, -122.43785923272) | |
| 1358 | 1358 | 173635 | Significant Tree 6 | Tree(s) :: 17 | 2590 Pacific Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 05/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779167 | 6001760.0 | 2117029.0 | 37.7930568116395 | -122.43785923271999 | (37.7930568116395, -122.43785923272) | |
| 9683 | 9683 | 173631 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 99X Everglade Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5986361.0 | 2095495.0 | 37.733042731061104 | -122.48955570953301 | (37.7330427310611, -122.489555709533) | ||||
| 9684 | 9684 | 173630 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2699x OCEAN AVE | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5990602.0 | 2095184.0 | 37.7324354869182 | -122.47487091251001 | (37.7324354869182, -122.47487091251) | |||
| 10019 | 10019 | 173629 | Significant Tree 6 | Tibochina urvilleana :: Princess Flower 260 | 10X Junipero Serra Blvd Off Ramp | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779383 | 5991168.0 | 2088425.0 | 37.713909732222 | -122.472421570074 | (37.713909732222, -122.472421570074) | |
| 10011 | 10011 | 173616 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1200X JUNIPERO SERRA BLVD | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 9996 | 9996 | 173615 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X JUNIPERO SERRA BLVD | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 9444 | 9444 | 173598 | Significant Tree 6 | Casuarina cunninghamiana :: Horsetail pine 123 | 1771 11th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 3x3 | 5992768.0 | 2103420.0 | 37.7551747322674 | -122.467981458634 | (37.7551747322674, -122.467981458634) | |||
| 2059 | 2059 | 173596 | Significant Tree 6 | Tree(s) :: 17 | 200 Howard St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | Permit Number 779179 | 6014439.0 | 2115766.0 | 37.790301726009204 | -122.393900378517 | (37.7903017260092, -122.393900378517) | |||
| 2003 | 2003 | 127110 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3201 Laguna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 6ft | 6003718.35126 | 2119752.0994 | 37.8006449063974 | -122.431277695812 | (37.8006449063974, -122.431277695812) | |||
| 3059 | 3059 | 126695 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2829 Divisadero St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 10x10 | Permit Number 779774 | 6000551.43021 | 2118023.61416 | 37.7957189625051 | -122.44211236900601 | (37.7957189625051, -122.442112369006) | ||
| 104664 | 104664 | 122689 | Significant Tree 6 | Aesculus hippocastanum :: White Horsechestnut 364 | 2590 Pacific Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 3x8 | 6001760.0 | 2117029.0 | 37.7930568116395 | -122.43785923271999 | (37.7930568116395, -122.43785923272) | |||
| 125113 | 125113 | 122688 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 2590 Pacific Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 3x8 | 6001760.0 | 2117029.0 | 37.7930568116395 | -122.43785923271999 | (37.7930568116395, -122.43785923272) | |||
| 9848 | 9848 | 122687 | Significant Tree 6 | Tree(s) :: 17 | 1462 Funston Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 01/04/2017 12:00:00 AM | 3 | 3x8 | Permit Number 779171 | 5992142.99696903 | 2105491.66018597 | 37.7608268551195 | -122.470293739312 | (37.7608268551195, -122.470293739312) | |
| 86774 | 86774 | 122640 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630X 19th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x8 | 5990614.0 | 2091411.0 | 37.7220764711857 | -122.47455416918999 | (37.7220764711857, -122.47455416919) | ||||
| 120114 | 120114 | 122639 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630X 19th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x8 | 5990614.0 | 2091411.0 | 37.7220764711857 | -122.47455416918999 | (37.7220764711857, -122.47455416919) | ||||
| 91819 | 91819 | 122638 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630X 19th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x8 | 5990614.0 | 2091411.0 | 37.7220764711857 | -122.47455416918999 | (37.7220764711857, -122.47455416919) | ||||
| 88391 | 88391 | 122637 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630X 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x8 | 5990614.0 | 2091411.0 | 37.7220764711857 | -122.47455416918999 | (37.7220764711857, -122.47455416919) | ||||
| 111731 | 111731 | 122636 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 3698X 19th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5990586.0 | 2091171.0 | 37.7214158684235 | -122.474633449984 | (37.7214158684235, -122.474633449984) | ||||
| 88445 | 88445 | 122634 | Significant Tree 6 | Tree(s) :: 17 | 3680X 19th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/05/2016 12:00:00 AM | 3 | 3x10 | Permit Number 779220 | 5990592.0 | 2091224.0 | 37.7215617409212 | -122.474616575991 | (37.7215617409212, -122.474616575991) | |
| 99827 | 99827 | 122418 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
| 112319 | 112319 | 122417 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
| 112873 | 112873 | 122416 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
| 116737 | 116737 | 122415 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
| 110638 | 110638 | 122414 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
| 109913 | 109913 | 122413 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
| 122326 | 122326 | 122412 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
| 91870 | 91870 | 122411 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
| 91855 | 91855 | 122410 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
| 7743 | 7743 | 121449 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1274 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 10x6 | 6006927.94593 | 2119481.89109 | 37.800084349978 | -122.420151970562 | (37.800084349978, -122.420151970562) | |||
| 84297 | 84297 | 121446 | Significant Tree 6 | Tree(s) :: 17 | 500 Terry A Francois Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6016102.0 | 2110410.0 | 37.775687633053 | -122.38777260103399 | (37.775687633053, -122.387772601034) | ||||
| 104153 | 104153 | 121416 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 366 San Carlos St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006692.0 | 2103986.0 | 37.757523086513096 | -122.419868246156 | (37.7575230865131, -122.419868246156) | ||||
| 102666 | 102666 | 121415 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 366 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6006692.0 | 2103986.0 | 37.757523086513096 | -122.419868246156 | (37.7575230865131, -122.419868246156) | |||
| 128022 | 128022 | 121414 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 150 Raccoon Dr | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 36 | 3x3 | 5998776.0 | 2103987.0 | 37.7570766935068 | -122.44724492231701 | (37.7570766935068, -122.447244922317) | |||
| 114328 | 114328 | 121377 | Significant Tree 6 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 2701 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001200.0 | 2116539.0 | 37.79167953949779 | -122.439761713662 | (37.7916795394978, -122.439761713662) | ||||
| 20387 | 20387 | 121368 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 142 | 245 Mallorca Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 778992 | 6001431.0 | 2120732.0 | 37.8032055622797 | -122.439263127997 | (37.8032055622797, -122.439263127997) | ||
| 105499 | 105499 | 121242 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 701 16th Ave | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 36 | 5990933.0 | 2110561.0 | 37.7746758635803 | -122.474848566269 | (37.7746758635803, -122.474848566269) | ||||
| 8728 | 8728 | 121206 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 930 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778903 | 6007356.48577 | 2120579.5282099997 | 37.803122321012296 | -122.418746939923 | (37.8031223210123, -122.418746939923) | |
| 5478 | 5478 | 121205 | Significant Tree 6 | Cotoneaster SPP :: Cotoneaster 234 | 930 Chestnut St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 3x3 | 6007386.5238 | 2120591.4348299997 | 37.8031567047665 | -122.418643837145 | (37.8031567047665, -122.418643837145) | |||
| 142656 | 142656 | 121196 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 255x Red Rock Way | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999917.0 | 2099808.0 | 37.7456673038035 | -122.442998816589 | (37.7456673038035, -122.442998816589) | |||
| 106634 | 106634 | 121195 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 255x Red Rock Way | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999917.0 | 2099808.0 | 37.7456673038035 | -122.442998816589 | (37.7456673038035, -122.442998816589) | |||
| 83443 | 83443 | 121194 | Significant Tree 6 | Dodonaea viscosa :: Hop Bush 132 | 255x Red Rock Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999917.0 | 2099808.0 | 37.7456673038035 | -122.442998816589 | (37.7456673038035, -122.442998816589) | |||
| 91506 | 91506 | 121193 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 100978 | 100978 | 121192 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 90930 | 90930 | 121191 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 79242 | 79242 | 121190 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 50101 | 50101 | 121189 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1000x Duncan St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) |
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");