Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, PlantType, qCareAssistant, PlantDate, PlotSize, PermitNotes
qCaretaker ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1781 | 1781 | 214663 | Undocumented 2 | Tree(s) :: 17 | 427 Kirkham St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/01/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779947 | 5993526.84887 | 2105257.2946900004 | 37.7602632600539 | -122.46549062240601 | (37.7602632600539, -122.465490622406) | |
2811 | 2811 | 115532 | Planning Code 138.1 required 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 100X Hayes St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007293.46404 | 2111265.83422 | 37.777545665835596 | -122.41830427922501 | (37.7775456658356, -122.418304279225) | ||
4390 | 4390 | 175420 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 211 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6003926.56795 | 2092414.35505 | 37.7255938222743 | -122.428607384746 | (37.7255938222743, -122.428607384746) | |||
5221 | 5221 | 72132 | Undocumented 2 | Tree(s) :: 17 | 950 Wisconsin St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 12/01/2011 12:00:00 AM | 3 | 3x3 | Permit Number 780813 | 6012748.1522699995 | 2103075.8524599997 | 37.755363341648795 | -122.398859619973 | (37.7553633416488, -122.398859619973) |
6140 | 6140 | 115534 | Planning Code 138.1 required 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 100X Hayes St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007259.83389 | 2111260.26588 | 37.777528483399294 | -122.418420222514 | (37.7775284833993, -122.418420222514) | ||
6300 | 6300 | 103795 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1215 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006811.4062 | 2115079.7468 | 37.78799059318229 | -122.42024263571899 | (37.7879905931823, -122.420242635719) | ||
6989 | 6989 | 115533 | Planning Code 138.1 required 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 100X Hayes St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007275.38703 | 2111262.82601 | 37.7775363884346 | -122.418366600452 | (37.7775363884346, -122.418366600452) | ||
7553 | 7553 | 142835 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1515 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Width 0ft | 6006663.5874 | 2116129.9342 | 37.7908658176323 | -122.42082865045799 | (37.7908658176323, -122.420828650458) | ||||
8241 | 8241 | 115531 | Planning Code 138.1 required 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 100X Hayes St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007312.7374599995 | 2111269.98589 | 37.777558150214404 | -122.41823790028 | (37.7775581502144, -122.41823790028) | ||
8494 | 8494 | 115535 | Planning Code 138.1 required 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 100X Hayes St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007237.56945 | 2111260.60051 | 37.777528148837796 | -122.41849726655899 | (37.7775281488378, -122.418497266559) | ||
16896 | 16896 | 100001 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 501X 01st St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Address is 100 1st Street | |||||||||
18492 | 18492 | 63236 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 3634 20th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 01/13/1987 12:00:00 AM | 12 | Permit Number 23784 | 6006063.67565171 | 2104362.69748074 | 37.7585219924343 | -122.422068008351 | (37.7585219924343, -122.422068008351) | |
22812 | 22812 | 224471 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 627 Precita Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6009784.7997 | 2100421.88863 | 37.7479105825135 | -122.408920592022 | (37.7479105825135, -122.408920592022) | |||
22852 | 22852 | 138173 | Undocumented 2 | :: 54 | 1953 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 6000211.2401 | 2111613.6154 | 37.7780993776744 | -122.44282896766 | (37.7780993776744, -122.44282896766) | |||
22874 | 22874 | 179489 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 36 Goettingen St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6009813.802999999 | 2094277.0712700002 | 37.7310398674871 | -122.40838693792801 | (37.7310398674871, -122.408386937928) | |||
22907 | 22907 | 233756 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 138 Alpine Ter | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6001688.04868 | 2107994.1327400003 | 37.768245263926396 | -122.43746090722 | (37.7682452639264, -122.43746090722) | |||
23385 | 23385 | 225339 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3033 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 3ft | 6002890.27268 | 2096019.3333400001 | 37.73543357459229 | -122.43244713645001 | (37.7354335745923, -122.43244713645) | |||
23569 | 23569 | 211718 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 431 Arch St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 4ft | 5992705.448530001 | 2090061.4664900003 | 37.7184919399203 | -122.46722653339701 | (37.7184919399203, -122.467226533397) | |||
23670 | 23670 | 129807 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 901 Sacramento St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6010390.20829 | 2116866.53247 | 37.793097682469394 | -122.407986617304 | (37.7930976824694, -122.407986617304) | |||
23685 | 23685 | 131311 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3701 Jackson St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 5996479.01622 | 2115904.55519 | 37.7896676762649 | -122.45605029860201 | (37.7896676762649, -122.456050298602) | |||
23717 | 23717 | 190342 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014826.26604 | 2116061.6193 | 37.7911349426626 | -122.39258114252199 | (37.7911349426626, -122.392581142522) | |||
23754 | 23754 | 194580 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 598 Missouri St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6013513.20546 | 2104325.65158 | 37.758837617875294 | -122.39630140851001 | (37.7588376178753, -122.39630140851) | |||
23806 | 23806 | 232314 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 99 Elsie St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 6007320.806890001 | 2098778.15204 | 37.7432589210582 | -122.417324523624 | (37.7432589210582, -122.417324523624) | ||||
23836 | 23836 | 204823 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1331 09th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 5993302.77838 | 2106404.87542 | 37.7634012905668 | -122.466348974927 | (37.7634012905668, -122.466348974927) | |||
23903 | 23903 | 128508 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 415 Montgomery St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6011852.868919999 | 2116847.94752 | 37.7931284347821 | -122.40292438836 | (37.7931284347821, -122.40292438836) | |||
24173 | 24173 | 190232 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 536 Mission St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6013096.96075 | 2115369.31377 | 37.7891378442858 | -122.398515922465 | (37.7891378442858, -122.398515922465) | |||
24220 | 24220 | 188507 | Undocumented 2 | Abutilon hybridum :: Flowering maple 339 | 1525 18th St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6013039.99307 | 2105636.60333 | 37.7624108600086 | -122.398029973803 | (37.7624108600086, -122.398029973803) | |||
24538 | 24538 | 232518 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4518 25th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6000862.85333 | 2101145.4432599996 | 37.749393486316706 | -122.43982407823401 | (37.7493934863167, -122.439824078234) | |||
24563 | 24563 | 128713 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 555 Jackson St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6011289.01038 | 2117973.50016 | 37.7961874301503 | -122.404954668136 | (37.7961874301503, -122.404954668136) | |||
24580 | 24580 | 130549 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 341 Maple St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 2ft | 5996655.62034 | 2115093.6524799997 | 37.7874512898863 | -122.455380640001 | (37.7874512898863, -122.455380640001) | |||
24601 | 24601 | 138420 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1819 STEINER ST | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 0ft | 6002521.5979 | 2114452.899 | 37.786026776312596 | -122.435039736101 | (37.7860267763126, -122.435039736101) | |||
24608 | 24608 | 128760 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 145 Geary St | 12 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6010990.83089 | 2114854.39463 | 37.7876064418291 | -122.405766620129 | (37.7876064418291, -122.405766620129) | |||
24682 | 24682 | 203198 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 91 Market St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 10ft | 6013828.57328 | 2116873.69458 | 37.7933092533841 | -122.39609008760401 | (37.7933092533841, -122.396090087604) | |||
24709 | 24709 | 182142 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1418 25th Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 0ft | 5988379.3786 | 2105646.1459999997 | 37.761032715479395 | -122.483321592218 | (37.7610327154794, -122.483321592218) | |||
24727 | 24727 | 129157 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 175 Spruce St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 5997198.13027 | 2114418.3589 | 37.785628226512706 | -122.45345490104499 | (37.7856282265127, -122.453454901045) | |||
24769 | 24769 | 244936 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 294 Page St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 0ft | 6005165.6636 | 2109931.2421 | 37.7737611964044 | -122.425570051796 | (37.7737611964044, -122.425570051796) | |||
24801 | 24801 | 179172 | Undocumented 2 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 766 Brussels St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6011071.2158 | 2091212.4916599998 | 37.7226955033774 | -122.403824260795 | (37.7226955033774, -122.403824260795) | |||
24832 | 24832 | 246304 | Undocumented 2 | Brachychiton populneus :: Bottle Tree 329 | 3996 17th St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 6002336.3946 | 2105898.3028 | 37.7625274658745 | -122.435068430359 | (37.7625274658745, -122.435068430359) | |||
24865 | 24865 | 127538 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 170 O'Farrell St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6010539.53779 | 2114494.20954 | 37.7865922116181 | -122.40730261183701 | (37.7865922116181, -122.407302611837) | |||
25005 | 25005 | 177418 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 857 Dartmouth St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6009516.77243 | 2090302.7647799999 | 37.720110619797104 | -122.409133494811 | (37.7201106197971, -122.409133494811) | |||
25040 | 25040 | 210510 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 57 Agua Way | 13 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 6ft | 5997279.39992 | 2098558.56074 | 37.7420859128371 | -122.452029069086 | (37.7420859128371, -122.452029069086) | |||
25089 | 25089 | 224296 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 5 Powhattan Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 43 | Width 3ft | 6007487.03456 | 2098209.30712 | 37.7417063503734 | -122.416709460186 | (37.7417063503734, -122.416709460186) | |||
25116 | 25116 | 132137 | Undocumented 2 | Phoenix roebelenii :: Pigmy Date Palm 344 | 576 Sacramento St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6011959.93168 | 2117122.22989 | 37.7938875264289 | -122.40257323908999 | (37.7938875264289, -122.40257323909) | |||
25128 | 25128 | 143413 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 599 Kearny St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6011351.7699 | 2116964.7162 | 37.7934210599755 | -122.404666454604 | (37.7934210599755, -122.404666454604) | |||
25173 | 25173 | 140670 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 40 COLE ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 5997774.3514 | 2110415.6204 | 37.7746707659902 | -122.451172585534 | (37.7746707659902, -122.451172585534) | |||
25630 | 25630 | 194576 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 572 Missouri St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6013508.15849 | 2104424.13067 | 37.7591077391483 | -122.396325765734 | (37.7591077391483, -122.396325765734) | |||
25634 | 25634 | 128547 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 530 California St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6011621.44747 | 2116740.1603200003 | 37.792819551831 | -122.40371753735 | (37.792819551831, -122.40371753735) | |||
25652 | 25652 | 193862 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 90 Stevenson St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 4ft | 6012460.38897 | 2115317.66617 | 37.7889605483383 | -122.40071476487101 | (37.7889605483383, -122.400714764871) | |||
25730 | 25730 | 233142 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 62 Worth St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6000859.74729 | 2102942.63257 | 37.754327958491395 | -122.43996366469901 | (37.7543279584914, -122.439963664699) | |||
25825 | 25825 | 233757 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 138 Alpine Ter | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6001688.84947 | 2107982.08951 | 37.7682122417201 | -122.437457274854 | (37.7682122417201, -122.437457274854) | |||
25845 | 25845 | 237234 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 110 Carmel St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 5998175.72217 | 2105385.27781 | 37.7608816968555 | -122.449421648503 | (37.7608816968555, -122.449421648503) | |||
26021 | 26021 | 137509 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 85 Toledo Way | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6001461.48208 | 2119936.52079 | 37.801023121670106 | -122.439100597914 | (37.8010231216701, -122.439100597914) | |||
26027 | 26027 | 227311 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 405 Beacon St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6002323.66405 | 2098293.59277 | 37.7416460184529 | -122.434568676724 | (37.7416460184529, -122.434568676724) | |||
26132 | 26132 | 136381 | Undocumented 2 | Schinus molle :: California Pepper 138 | 1023 Broadway | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 3ft | 6008695.6423 | 2118278.0740799997 | 37.7968784080765 | -122.413949834731 | (37.7968784080765, -122.413949834731) | |||
26143 | 26143 | 245512 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 106 Chattanooga St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 4ft | 6004701.89686 | 2103004.13948 | 37.754714811762206 | -122.42668090920701 | (37.7547148117622, -122.426680909207) | |||
26283 | 26283 | 226595 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 880 Douglass St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6001269.3073 | 2101283.04072 | 37.749794423884794 | -122.438428410468 | (37.7497944238848, -122.438428410468) | |||
26581 | 26581 | 194044 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1542 20th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 3ft | 6013293.95823 | 2104770.11303 | 37.760045809374205 | -122.39709083697201 | (37.7600458093742, -122.397090836972) | |||
26617 | 26617 | 126477 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 614 Grant Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6010973.50945 | 2116764.5912 | 37.7928504165589 | -122.405961165984 | (37.7928504165589, -122.405961165984) | |||
26691 | 26691 | 222522 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 791 27th St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 5ft | 6001439.60059 | 2099957.7516 | 37.7461651800752 | -122.43774462443899 | (37.7461651800752, -122.437744624439) | |||
26807 | 26807 | 223746 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 591 27th St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6002725.9014 | 2100031.26808 | 37.7464400956267 | -122.43330201489599 | (37.7464400956267, -122.433302014896) | |||
26888 | 26888 | 128506 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 132 Bush St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012518.245680001 | 2116156.64354 | 37.791267409218705 | -122.400573546136 | (37.7912674092187, -122.400573546136) | |||
26967 | 26967 | 127517 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 330 Geary St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6010076.35722 | 2114778.73619 | 37.7873475198145 | -122.40892519296499 | (37.7873475198145, -122.408925192965) | |||
27067 | 27067 | 225239 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 3900 22nd St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6002410.772480001 | 2102995.6148099997 | 37.7545616068455 | -122.43460362076799 | (37.7545616068455, -122.434603620768) | |||
27091 | 27091 | 233553 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 916 Alvarado St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 3ft | 6000357.83918 | 2102588.4411 | 37.7533268502794 | -122.44167396838101 | (37.7533268502794, -122.441673968381) | |||
27120 | 27120 | 135723 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1910 Baker St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 4ft | 5999974.03757 | 2115574.89722 | 37.7889625079578 | -122.44393422098699 | (37.7889625079578, -122.443934220987) | |||
27204 | 27204 | 126614 | Undocumented 2 | Ficus Spp. :: 253 | 728 Washington St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6011128.855280001 | 2117659.08548 | 37.7953151696175 | -122.40548668546002 | (37.7953151696175, -122.40548668546) | |||
27211 | 27211 | 190009 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 499 Arkansas St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 6013000.6424 | 2104780.97852 | 37.7600593109036 | -122.39810604475099 | (37.7600593109036, -122.398106044751) | |||
27270 | 27270 | 126949 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3439 Sacramento St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 5998374.58367 | 2115190.1998 | 37.787814864221204 | -122.449440363388 | (37.7878148642212, -122.449440363388) | |||
27365 | 27365 | 128529 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 350 California St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6012461.93985 | 2116858.6183599997 | 37.79319172545561 | -122.400817703074 | (37.7931917254556, -122.400817703074) | |||
27368 | 27368 | 138258 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 GEARY BLVD | 26 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 0ft | 5999069.3554 | 2113186.3828 | 37.7823526251779 | -122.446892345537 | (37.7823526251779, -122.446892345537) | |||
27373 | 27373 | 127889 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1520 Mason St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6009298.57619 | 2118522.06879 | 37.797582201307705 | -122.411880784278 | (37.7975822013077, -122.411880784278) | |||
27555 | 27555 | 101445 | Permitted Site 1 | Prunus persica :: Peach 330 | 771 Stockton Tunl | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Permit Number 25247 | 6010467.187000001 | 2116750.7503 | 37.7927840821229 | -122.407712097586 | (37.7927840821229, -122.407712097586) | |||
27853 | 27853 | 128263 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2 Lombard St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6012051.14949 | 2120876.60895 | 37.80420123766179 | -122.402521741194 | (37.8042012376618, -122.402521741194) | |||
27892 | 27892 | 208144 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 40 Garcia Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 5995206.64176 | 2099494.55804 | 37.7445369826924 | -122.459263729149 | (37.7445369826924, -122.459263729149) | |||
27938 | 27938 | 128409 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 251 Sutter St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6011283.06953 | 2115589.6115900003 | 37.789641511384204 | -122.40480730793699 | (37.7896415113842, -122.404807307937) | |||
27957 | 27957 | 128525 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 300 California St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6012595.64796 | 2116876.01852 | 37.7932469591239 | -122.40035628434099 | (37.7932469591239, -122.400356284341) | |||
28116 | 28116 | 128527 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 350 California St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6012510.08821 | 2116864.88564 | 37.79321161938179 | -122.400651546131 | (37.7932116193818, -122.400651546131) | |||
28203 | 28203 | 122263 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400 Balboa St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 4ft | 5991199.98338 | 2111351.52204 | 37.7768618890602 | -122.473982714477 | (37.7768618890602, -122.473982714477) | |||
28250 | 28250 | 129809 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 901 Sacramento St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 6010417.7029 | 2116870.15869 | 37.7931091785103 | -122.40789173971399 | (37.7931091785103, -122.407891739714) | |||
28509 | 28509 | 234021 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 147 Nevada St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 3ft | 6009064.5456300005 | 2097789.7459400003 | 37.7406429263284 | -122.411225300822 | (37.7406429263284, -122.411225300822) | |||
28548 | 28548 | 223916 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 588 Ogden Ave | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 4ft | 6007765.411040001 | 2096148.4497200001 | 37.736063342858 | -122.415601045774 | (37.736063342858, -122.415601045774) | |||
28732 | 28732 | 127522 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 441 Mason St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6009737.67951 | 2114979.8254 | 37.7878806856047 | -122.410111154116 | (37.7878806856047, -122.410111154116) | |||
28738 | 28738 | 209878 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 649 Parnassus Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 5994950.47657 | 2106078.83176 | 37.7626009937499 | -122.460626532115 | (37.7626009937499, -122.460626532115) | |||
28810 | 28810 | 189783 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1712 20th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6012852.355219999 | 2104746.67943 | 37.759956872734705 | -122.39861649547501 | (37.7599568727347, -122.398616495475) | |||
28844 | 28844 | 128476 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 209 Front St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 5ft | 6013054.34541 | 2116659.1488799998 | 37.792677054245296 | -122.398753923573 | (37.7926770542453, -122.398753923573) | |||
28966 | 28966 | 242013 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3350 18th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6007139.614130001 | 2105587.52459 | 37.7619457090369 | -122.418433769026 | (37.7619457090369, -122.418433769026) | |||
28999 | 28999 | 222600 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 41 Roanoke St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 6ft | 6003358.58638 | 2096297.6712 | 37.736224371859606 | -122.430847858561 | (37.7362243718596, -122.430847858561) | |||
29025 | 29025 | 130878 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1160 Polk St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6006883.37994 | 2114899.5545099997 | 37.7874998847581 | -122.419980826847 | (37.7874998847581, -122.419980826847) | |||
29106 | 29106 | 229884 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 137 Bradford St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 5ft | 6009563.00843 | 2097787.4840700002 | 37.7406646584401 | -122.409501640412 | (37.7406646584401, -122.409501640412) | |||
29119 | 29119 | 220589 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 653 Duncan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6002332.20411 | 2099716.00641 | 37.7455521185496 | -122.43464083471301 | (37.7455521185496, -122.434640834713) | |||
29131 | 29131 | 194397 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 1797 Bancroft Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 1ft | 6013420.92243 | 2092796.80792 | 37.7271767046165 | -122.39581273756501 | (37.7271767046165, -122.395812737565) | |||
29149 | 29149 | 226660 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2 Dolores St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6004732.5122 | 2108095.82328 | 37.7686970968169 | -122.426937645858 | (37.7686970968169, -122.426937645858) | |||
29394 | 29394 | 228372 | Undocumented 2 | Grevillea spp :: Silkoak species 369 | 3784 20th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 1ft | 6005132.77553 | 2104314.58442 | 37.7583373376056 | -122.425284057905 | (37.7583373376056, -122.425284057905) | |||
29521 | 29521 | 231336 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4864 17th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 5997916.37939 | 2105662.1050400003 | 37.7616269560303 | -122.45033855228998 | (37.7616269560303, -122.45033855229) | |||
29639 | 29639 | 220335 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 523 Day St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6002527.73455 | 2098555.81183 | 37.7423775935402 | -122.433881808696 | (37.7423775935402, -122.433881808696) | |||
29646 | 29646 | 229482 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1557 Church St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6004608.55119 | 2099805.21218 | 37.745926022487104 | -122.426775926168 | (37.7459260224871, -122.426775926168) | |||
29706 | 29706 | 188799 | Undocumented 2 | Bambusa spp :: Bamboo Species 346 | 370 De Haro St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 2ft | 6011991.8145 | 2106659.3783299997 | 37.7651607368141 | -122.401727150587 | (37.7651607368141, -122.401727150587) | |||
29718 | 29718 | 130970 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2801 Webster St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6002945.56276 | 2118345.7946599997 | 37.796739734404 | -122.433851284829 | (37.796739734404, -122.433851284829) | |||
29825 | 29825 | 188590 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 762 De Haro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 2ft | 6012084.87947 | 2104884.86073 | 37.7602934997697 | -122.401280549067 | (37.7602934997697, -122.401280549067) | |||
29953 | 29953 | 128264 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2 Lombard St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6012036.74363 | 2120874.77061 | 37.8041953857812 | -122.40257146471201 | (37.8041953857812, -122.402571464712) |
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");