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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24061 | 24061 | 190934 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 1101 25th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 9ft | 6015168.60212 | 2102024.17667 | 37.752610233591206 | -122.390415424833 | (37.7526102335912, -122.390415424833) | |||
24308 | 24308 | 190929 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 1101 25th St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 9ft | 6015301.73602 | 2102030.54675 | 37.752635108841 | -122.389955465678 | (37.752635108841, -122.389955465678) | |||
33605 | 33605 | 227093 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 31 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 9ft | 6009184.481319999 | 2095791.0539799999 | 37.7351616771725 | -122.41066949551201 | (37.7351616771725, -122.410669495512) | |||
42737 | 42737 | 239675 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 689 Dolores St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 9ft | 6005030.3991 | 2104342.90235 | 37.7584093076526 | -122.425640136401 | (37.7584093076526, -122.425640136401) | |||
46155 | 46155 | 189816 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 15th St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 9ft | 6010379.86715 | 2107373.23208 | 37.767030731308104 | -122.40735284165702 | (37.7670307313081, -122.407352841657) | |||
46834 | 46834 | 189823 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 15th St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 9ft | 6010524.410519999 | 2107382.85181 | 37.767065233807 | -122.40685356416 | (37.767065233807, -122.40685356416) | |||
47117 | 47117 | 191814 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1301 Iowa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 9ft | 6014800.46205 | 2101999.0803099996 | 37.752520895829704 | -122.391686773025 | (37.7525208958297, -122.391686773025) | |||
49610 | 49610 | 131039 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 3001 Divisadero St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 9ft | 6000465.59076 | 2118697.11067 | 37.79756331373971 | -122.442457765333 | (37.7975633137397, -122.442457765333) | |||
51904 | 51904 | 125891 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 3001 Divisadero St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 33 | Width 9ft | 6000478.83017 | 2118614.89434 | 37.7973383240724 | -122.442406047996 | (37.7973383240724, -122.442406047996) | |||
56393 | 56393 | 232297 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 301 Putnam St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | Width 9ft | 6009073.4894199995 | 2095823.27697 | 37.73524393096471 | -122.411055511504 | (37.7352439309647, -122.411055511504) | |||
57651 | 57651 | 189821 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 15th St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 9ft | 6010484.40346 | 2107380.66629 | 37.7670569942101 | -122.406991789056 | (37.7670569942101, -122.406991789056) | |||
58167 | 58167 | 201927 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 118 Elmira St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 9ft | 6011149.33758 | 2096046.2397099999 | 37.735972330566 | -122.403894190267 | (37.735972330566, -122.403894190267) | |||
59728 | 59728 | 244843 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Bartlett St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 9ft | 6006632.98295 | 2103729.04135 | 37.7568142125173 | -122.4200541162 | (37.7568142125173, -122.4200541162) | |||
61235 | 61235 | 232868 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 301 Putnam St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 9ft | 6009077.45417 | 2095862.97856 | 37.735353165298 | -122.41104460722401 | (37.735353165298, -122.411044607224) | |||
61472 | 61472 | 189819 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 15th St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 9ft | 6010449.36204 | 2107378.3567 | 37.7670486916722 | -122.407112829708 | (37.7670486916722, -122.407112829708) | |||
65963 | 65963 | 232871 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 301 Putnam St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 9ft | 6009080.3789099995 | 2095903.22512 | 37.7354638376772 | -122.411037337111 | (37.7354638376772, -122.411037337111) | |||
68988 | 68988 | 190930 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 1101 25th St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 9ft | 6015277.62058 | 2102029.1535 | 37.752629945825795 | -122.39003876447799 | (37.7526299458258, -122.390038764478) | |||
74607 | 74607 | 189822 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 15th St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 9ft | 6010499.44736 | 2107381.21521 | 37.767059343243105 | -122.40693979295901 | (37.7670593432431, -122.406939792959) | |||
146834 | 146834 | 190932 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 1101 25th St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 9ft | 6015229.59957 | 2102026.97334 | 37.7526212961411 | -122.390204678629 | (37.7526212961411, -122.390204678629) | |||
147673 | 147673 | 194031 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1101 25th St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 9ft | 6015324.74216 | 2102030.33526 | 37.7526358040022 | -122.38987589096901 | (37.7526358040022, -122.389875890969) | |||
151482 | 151482 | 189815 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 15th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 9ft | 6010361.40821 | 2107373.60835 | 37.7670307313104 | -122.407416715103 | (37.7670307313104, -122.407416715103) | |||
152760 | 152760 | 232869 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 301 Putnam St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 9ft | 6009077.71064 | 2095875.53633 | 37.7353876606063 | -122.411044607225 | (37.7353876606063, -122.411044607225) | |||
157732 | 157732 | 189820 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 15th St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 9ft | 6010468.25457 | 2107379.34073 | 37.7670524508424 | -122.40704755241 | (37.7670524508424, -122.40704755241) | |||
160876 | 160876 | 131042 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 3001 Divisadero St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 9ft | 6000473.91869 | 2118638.90202 | 37.797403962867996 | -122.442424767404 | (37.797403962868, -122.442424767404) | |||
162022 | 162022 | 131041 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 3001 Divisadero St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 9ft | 6000469.3004 | 2118677.0449099997 | 37.7975084299175 | -122.44244348768 | (37.7975084299175, -122.44244348768) | |||
165512 | 165512 | 131040 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 3001 Divisadero St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 9ft | 6000467.64422 | 2118686.84374 | 37.797535240511706 | -122.442449922347 | (37.7975352405117, -122.442449922347) | |||
165827 | 165827 | 201926 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 118 Elmira St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 9ft | 6011142.54954 | 2096046.89892 | 37.7359737613804 | -122.403917705737 | (37.7359737613804, -122.403917705737) | |||
169841 | 169841 | 190933 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 1101 25th St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 9ft | 6015201.2247 | 2102025.49065 | 37.7526156511008 | -122.390302701123 | (37.7526156511008, -122.390302701123) | |||
169978 | 169978 | 189818 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 15th St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 9ft | 6010426.403390001 | 2107376.26761 | 37.767041670665996 | -122.407192093242 | (37.767041670666, -122.407192093242) | |||
171469 | 171469 | 227092 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 30 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 9ft | 6009197.49082 | 2095788.0482299998 | 37.7351541534232 | -122.410624304588 | (37.7351541534232, -122.410624304588) | |||
175528 | 175528 | 189817 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 15th St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 9ft | 6010416.08165 | 2107377.1962599996 | 37.767043642870796 | -122.407227860188 | (37.7670436428708, -122.407227860188) | |||
176086 | 176086 | 190931 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 1101 25th St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 9ft | 6015254.41614 | 2102028.26395 | 37.752626216333 | -122.390118948029 | (37.752626216333, -122.390118948029) | |||
176854 | 176854 | 191389 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 43 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 9ft | 6011309.9548 | 2104119.65272 | 37.758149144577104 | -122.403906816767 | (37.7581491445771, -122.403906816767) | |||
176864 | 176864 | 135666 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 3001 Divisadero St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 42 | Width 9ft | 6000472.49775 | 2118651.8946700003 | 37.797439556256705 | -122.442430617479 | (37.7974395562567, -122.442430617479) | |||
177965 | 177965 | 125892 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 3001 Divisadero St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 9ft | 6000476.92366 | 2118604.49605 | 37.7973096644524 | -122.442411898085 | (37.7973096644524, -122.442411898085) | |||
182048 | 182048 | 194267 | Undocumented 2 | Persea americana :: Avocado 113 | 91 Charter Oak Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 9ft | 6010928.668190001 | 2096415.01821 | 37.7369725871245 | -122.404683089975 | (37.7369725871245, -122.404683089975) | |||
184392 | 184392 | 232870 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 301 Putnam St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 9ft | 6009078.53533 | 2095890.1763799998 | 37.73542790527029 | -122.411042789701 | (37.7354279052703, -122.411042789701) | |||
455 | 455 | 234501 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2423 Market St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 12 | Width 8ft | 6002117.5892 | 2105782.84009 | 37.7621980066439 | -122.435816935712 | (37.7621980066439, -122.435816935712) | |||
608 | 608 | 233928 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 8 Octavia St Frontage East | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | Width 8ft | 6005775.18179 | 2109348.30824 | 37.77219502161479 | -122.423420179704 | (37.7721950216148, -122.423420179704) | |||
2611 | 2611 | 248770 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Cuesta Ct | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 8ft | 5999726.1375 | 2101744.56242 | 37.7509737525388 | -122.44379789365499 | (37.7509737525388, -122.443797893655) | |||
2614 | 2614 | 248773 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Cuesta Ct | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 8ft | 5999776.82694 | 2101824.96428 | 37.751197407653706 | -122.44362838043999 | (37.7511974076537, -122.44362838044) | |||
2625 | 2625 | 248771 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Cuesta Ct | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 8ft | 5999742.36883 | 2101773.9828 | 37.751055459558394 | -122.4437438777 | (37.7510554595584, -122.4437438777) | |||
2626 | 2626 | 248769 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Cuesta Ct | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 8ft | 5999705.100819999 | 2101709.8291 | 37.7508771833507 | -122.443868145114 | (37.7508771833507, -122.443868145114) | |||
2629 | 2629 | 248772 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Cuesta Ct | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | Width 8ft | 5999759.8487 | 2101799.49731 | 37.7511265131926 | -122.443685263491 | (37.7511265131926, -122.443685263491) | |||
4183 | 4183 | 180766 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1206 Naples St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 09:29:00 AM | 3 | Width 8ft | 6001093.57723 | 2087421.33847 | 37.7117233858917 | -122.438043283865 | (37.7117233858917, -122.438043283865) | ||
23600 | 23600 | 135193 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 35 Bay St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 8ft | 6010885.4927900005 | 2121705.9799599997 | 37.806413341469 | -122.40661408636801 | (37.806413341469, -122.406614086368) | |||
23761 | 23761 | 123510 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2714 Fulton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 8ft | 5994935.84099 | 2110268.0504400004 | 37.774102650784 | -122.460980795496 | (37.774102650784, -122.460980795496) | |||
24044 | 24044 | 219480 | Undocumented 2 | Ulmus americana :: American Elm 119 | 40 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 8ft | 5992573.35664 | 2096580.23843 | 37.736383252376704 | -122.468157060102 | (37.7363832523767, -122.468157060102) | |||
24218 | 24218 | 208954 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 600 Saint Francis Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 8ft | 5993495.97502 | 2095994.9515900002 | 37.7348294415148 | -122.464924714122 | (37.7348294415148, -122.464924714122) | |||
25022 | 25022 | 231947 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 1101 San Jose Ave | 64 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 6005025.65555 | 2096592.3987 | 37.73712794050989 | -122.42510507394199 | (37.7371279405099, -122.425105073942) | |||
25266 | 25266 | 215207 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 160 San Buenaventura Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 8ft | 5993414.72395 | 2095618.6966 | 37.7337916535606 | -122.465178304956 | (37.7337916535606, -122.465178304956) | |||
25285 | 25285 | 123524 | Undocumented 2 | Ulmus spp :: Elm Spp 215 | 2828 Fulton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 8ft | 5994582.70338 | 2110216.80029 | 37.7739416046925 | -122.46219863345199 | (37.7739416046925, -122.462198633452) | |||
25481 | 25481 | 198281 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 8ft | 6017868.75025 | 2099595.89007 | 37.7460920687928 | -122.380908946009 | (37.7460920687928, -122.380908946009) | |||
25589 | 25589 | 178865 | Undocumented 2 | Prunus persica :: Peach 330 | 1260 Naples St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 8ft | 6000973.92591 | 2087218.6697900002 | 37.711160097322995 | -122.438442319358 | (37.711160097323, -122.438442319358) | |||
25591 | 25591 | 211573 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 38 San Fernando Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 8ft | 5992093.28359 | 2096279.5496599998 | 37.735529899171794 | -122.469794973768 | (37.7355298991718, -122.469794973768) | |||
25629 | 25629 | 123514 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2744 Fulton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 8ft | 5994834.09227 | 2110246.18844 | 37.7740367681104 | -122.461331174398 | (37.7740367681104, -122.461331174398) | |||
25890 | 25890 | 211894 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 42 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 8ft | 5992633.05576 | 2096891.53005 | 37.73724142864779 | -122.467973292645 | (37.7372414286478, -122.467973292645) | |||
26209 | 26209 | 212049 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 11 San Leandro Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 8ft | 5992308.89069 | 2096641.7463200002 | 37.736536860193404 | -122.469075896562 | (37.7365368601934, -122.469075896562) | |||
26712 | 26712 | 219482 | Undocumented 2 | Ulmus americana :: American Elm 119 | 50 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5992576.61335 | 2096511.16113 | 37.736193771533706 | -122.46814077699601 | (37.7361937715337, -122.468140776996) | |||
27536 | 27536 | 219486 | Undocumented 2 | Ulmus americana :: American Elm 119 | 60 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 8ft | 5992579.41042 | 2096404.2389200001 | 37.7359003515064 | -122.468123331026 | (37.7359003515064, -122.468123331026) | |||
27722 | 27722 | 207753 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 601 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 8ft | 5993435.94824 | 2096116.49805 | 37.7351597166396 | -122.465141071201 | (37.7351597166396, -122.465141071201) | |||
27812 | 27812 | 219489 | Undocumented 2 | Ulmus americana :: American Elm 119 | 72 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5992583.968309999 | 2096317.0443099998 | 37.735661200197605 | -122.468101231991 | (37.7356612001976, -122.468101231991) | |||
28355 | 28355 | 209122 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 90 Terrace Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 8ft | 5993231.35441 | 2096936.94625 | 37.7374006626082 | -122.465908015739 | (37.7374006626082, -122.465908015739) | |||
28401 | 28401 | 212048 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 11 San Leandro Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 8ft | 5992319.55717 | 2096621.0874299998 | 37.7364807523878 | -122.469037515296 | (37.7364807523878, -122.469037515296) | |||
28487 | 28487 | 212010 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 302 San Fernando Way | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 8ft | 5992076.0582 | 2094714.7951200001 | 37.7312324797943 | -122.46974064571998 | (37.7312324797943, -122.46974064572) | |||
28552 | 28552 | 208205 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 50 San Benito Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5992824.24376 | 2096416.8452299999 | 37.7359491019705 | -122.467277768674 | (37.7359491019705, -122.467277768674) | |||
28602 | 28602 | 208207 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 75 San Benito Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 8ft | 5992862.536169999 | 2096286.0615700001 | 37.7355922132098 | -122.46713587181999 | (37.7355922132098, -122.46713587182) | |||
28708 | 28708 | 212033 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 77 San Leandro Way | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 42 | Width 8ft | 5992382.09631 | 2096171.88188 | 37.7352509600559 | -122.468788615307 | (37.7352509600559, -122.468788615307) | |||
29003 | 29003 | 211592 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 San Fernando Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 8ft | 5992116.4659 | 2096423.88969 | 37.7359275605095 | -122.46972532938801 | (37.7359275605095, -122.469725329388) | |||
29776 | 29776 | 209070 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 San Benito Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 8ft | 5992811.17187 | 2096755.1283099998 | 37.7368771879369 | -122.467347553363 | (37.7368771879369, -122.467347553363) | |||
30550 | 30550 | 219479 | Undocumented 2 | Ulmus americana :: American Elm 119 | 40 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5992572.274130001 | 2096608.73557 | 37.7364614358501 | -122.468162875133 | (37.7364614358501, -122.468162875133) | |||
30557 | 30557 | 215212 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 165 San Buenaventura Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 8ft | 5993408.7609 | 2095708.9649099999 | 37.7340391640776 | -122.465205475246 | (37.7340391640776, -122.465205475246) | |||
30590 | 30590 | 118002 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 7 Shore View Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5984637.38492 | 2112844.95185 | 37.780580098776795 | -122.49679463074699 | (37.7805800987768, -122.496794630747) | |||
30849 | 30849 | 198285 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 6017793.32679 | 2099592.23757 | 37.7460778765941 | -122.381169499371 | (37.7460778765941, -122.381169499371) | |||
30873 | 30873 | 211922 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 155 San Anselmo Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5993428.13683 | 2096525.45183 | 37.736282151484296 | -122.465197772566 | (37.7362821514843, -122.465197772566) | |||
30878 | 30878 | 211892 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 15 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5992677.8722 | 2096919.75593 | 37.7373215177838 | -122.46782039530399 | (37.7373215177838, -122.467820395304) | |||
30913 | 30913 | 211344 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 302 San Fernando Way | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 8ft | 5992079.24363 | 2094788.2155099998 | 37.731434257968104 | -122.46973497639999 | (37.7314342579681, -122.4697349764) | |||
31258 | 31258 | 118000 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 7 Shore View Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 8ft | 5984651.74201 | 2112846.53753 | 37.7805852938125 | -122.49674508055 | (37.7805852938125, -122.49674508055) | |||
31603 | 31603 | 211912 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 160 San Anselmo Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5993474.36419 | 2096435.15771 | 37.73603689198271 | -122.465031390792 | (37.7360368919827, -122.465031390792) | |||
31735 | 31735 | 198284 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 6017813.21777 | 2099593.44192 | 37.74608228148 | -122.381100801954 | (37.74608228148, -122.381100801954) | |||
31790 | 31790 | 215217 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 133 San Buenaventura Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5993392.21356 | 2095932.78503 | 37.7346527642991 | -122.465278936386 | (37.7346527642991, -122.465278936386) | |||
31846 | 31846 | 211571 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2 San Fernando Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 8ft | 5992089.09767 | 2096348.6420200001 | 37.73571936744779 | -122.46981447465099 | (37.7357193674478, -122.469814474651) | |||
32324 | 32324 | 199585 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 875 Vermont St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 8ft | 6011335.71651 | 2104267.18906 | 37.7585556858141 | -122.4038281027 | (37.7585556858141, -122.4038281027) | |||
32948 | 32948 | 212023 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 60 San Leandro Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 8ft | 5992352.18308 | 2096253.2392099998 | 37.7354726186689 | -122.46889795397699 | (37.7354726186689, -122.468897953977) | |||
33840 | 33840 | 208206 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 50 San Benito Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5992824.47991 | 2096396.07045 | 37.735892073256394 | -122.46727544212 | (37.7358920732564, -122.46727544212) | |||
33873 | 33873 | 208955 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 630 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 35 | Width 8ft | 5993530.979180001 | 2095998.56422 | 37.7348413791301 | -122.464803955838 | (37.7348413791301, -122.464803955838) | |||
33893 | 33893 | 209510 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 60 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 8ft | 5992578.93525 | 2096413.6287900002 | 37.735926106292204 | -122.46812565669701 | (37.7359261062922, -122.468125656697) | |||
34858 | 34858 | 209121 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 90 Terrace Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 8ft | 5993204.42935 | 2096950.74721 | 37.7374370033165 | -122.466002110005 | (37.7374370033165, -122.466002110005) | |||
34872 | 34872 | 211905 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 8ft | 5993202.216519999 | 2096632.8865099999 | 37.7365641096345 | -122.465986670445 | (37.7365641096345, -122.465986670445) | |||
35317 | 35317 | 123509 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2636 Fulton St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 8ft | 5995163.8038800005 | 2110297.4884900004 | 37.77419659482779 | -122.46019437077899 | (37.7741965948278, -122.460194370779) | |||
35345 | 35345 | 212007 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 302 San Fernando Way | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 8ft | 5992022.6744800005 | 2094535.4646599998 | 37.7307369974034 | -122.469912149146 | (37.7307369974034, -122.469912149146) | |||
35447 | 35447 | 215218 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 133 San Buenaventura Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 8ft | 5993390.45214 | 2095959.7776 | 37.734726777609296 | -122.465286986206 | (37.7347267776093, -122.465286986206) | |||
35875 | 35875 | 211898 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 50 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 8ft | 5992872.84504 | 2096808.4352799999 | 37.7370271156957 | -122.46713819838001 | (37.7370271156957, -122.46713819838) | |||
36107 | 36107 | 215203 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 120 San Buenaventura Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 8ft | 5993362.10241 | 2095871.1002099998 | 37.7344816565847 | -122.465378560574 | (37.7344816565847, -122.465378560574) | |||
36313 | 36313 | 219185 | Undocumented 2 | Ilex altaclarensis 'Wilsonii' :: Wilson Holly Tree 310 | 2195 12th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 8ft | 5992566.72507 | 2100523.27724 | 37.747209453947 | -122.468466778538 | (37.747209453947, -122.468466778538) | |||
36702 | 36702 | 212005 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 302 San Fernando Way | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 49 | Width 8ft | 5991983.8699 | 2094464.4262700002 | 37.73053970054001 | -122.470041130814 | (37.73053970054, -122.470041130814) | |||
36856 | 36856 | 219485 | Undocumented 2 | Ulmus americana :: American Elm 119 | 60 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 8ft | 5992578.713380001 | 2096435.07341 | 37.7359849750264 | -122.468127983245 | (37.7359849750264, -122.468127983245) | |||
37002 | 37002 | 245722 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2423 Market St | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 6002219.32806 | 2105848.6190400003 | 37.7623843983365 | -122.435469765918 | (37.7623843983365, -122.435469765918) | |||
37072 | 37072 | 219517 | Undocumented 2 | Ulmus americana :: American Elm 119 | 25 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 8ft | 5992610.84668 | 2096683.2976799998 | 37.7366683923157 | -122.468034936661 | (37.7366683923157, -122.468034936661) | |||
37147 | 37147 | 219498 | Undocumented 2 | Ulmus americana :: American Elm 119 | 89 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 8ft | 5992626.79103 | 2096177.7893599998 | 37.7352813139843 | -122.467943052944 | (37.7352813139843, -122.467943052944) |
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");