Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, PlantType, qCaretaker, qCareAssistant, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||||||
| 169260 | 169260 | 177163 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 189 Velasco Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 19 | Width 6ft | 6007991.7614400005 | 2086069.6109099998 | 37.70840170934729 | -122.41410563508002 | (37.7084017093473, -122.41410563508) | |||
| 134907 | 134907 | 176619 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 375 Hanover St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 3ft | 5999272.06122 | 2086368.18274 | 37.7087278988324 | -122.444263284724 | (37.7087278988324, -122.444263284724) | |||
| 151491 | 151491 | 176168 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 30 Kelloch Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 8ft | 6008416.5566300005 | 2086198.9199700002 | 37.7087806162127 | -122.412646622645 | (37.7087806162127, -122.412646622645) | |||
| 68299 | 68299 | 176169 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 30 Kelloch Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 8ft | 6008410.17529 | 2086203.98853 | 37.7087941752841 | -122.41266903556999 | (37.7087941752841, -122.41266903557) | |||
| 60233 | 60233 | 176171 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 46 Kelloch Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 6ft | 6008338.63627 | 2086231.2816700002 | 37.708865101208204 | -122.412918213412 | (37.7088651012082, -122.412918213412) | |||
| 50693 | 50693 | 176103 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 50 Kelloch Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 6ft | 6008313.99103 | 2086238.6229700001 | 37.7088838754685 | -122.413003909814 | (37.7088838754685, -122.413003909814) | |||
| 32945 | 32945 | 178518 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 62 Kelloch Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 6ft | 6008249.62715 | 2086262.35093 | 37.708945414261606 | -122.41322803793899 | (37.7089454142616, -122.413228037939) | |||
| 46024 | 46024 | 177585 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 51 Melra Ct | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 5ft | 6008966.99196 | 2086413.05326 | 37.7093994603862 | -122.410759348591 | (37.7093994603862, -122.410759348591) | |||
| 55445 | 55445 | 177587 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 48 Melra Ct | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 6ft | 6008913.30843 | 2086433.5443799999 | 37.709452714651796 | -122.410946334729 | (37.7094527146518, -122.410946334729) | |||
| 43641 | 43641 | 179373 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 670 Brunswick St | 17 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 5998557.70629 | 2086647.36142 | 37.709453678716706 | -122.446752254708 | (37.7094536787167, -122.446752254708) | ||||
| 171587 | 171587 | 179814 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 522 Sunnydale Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | 6010066.66697 | 2086413.12079 | 37.7094612429124 | -122.406958677794 | (37.7094612429124, -122.406958677794) | ||||
| 186143 | 186143 | 177480 | Undocumented 2 | Malus :: Crab Apple 235 | 289 Flournoy St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | 5993810.32054 | 2086750.1830099998 | 37.7094636621006 | -122.46316734172501 | (37.7094636621006, -122.463167341725) | ||||
| 157209 | 157209 | 179360 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 522 Sunnydale Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | 6010043.89457 | 2086419.58682 | 37.709477722997 | -122.40703783884399 | (37.709477722997, -122.407037838844) | ||||
| 42326 | 42326 | 179980 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 670 Brunswick St | 14 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 5998613.38234 | 2086668.65922 | 37.7095153380418 | -122.446561361025 | (37.7095153380418, -122.446561361025) | ||||
| 137512 | 137512 | 179979 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 670 Brunswick St | 13 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 5998643.39451 | 2086681.70368 | 37.709552869435896 | -122.44645857210399 | (37.7095528694359, -122.446458572104) | ||||
| 67095 | 67095 | 179978 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 670 Brunswick St | 12 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 5998663.42353 | 2086686.16888 | 37.709566273845894 | -122.446389669661 | (37.7095662738459, -122.446389669661) | ||||
| 131159 | 131159 | 177586 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 44 Melra Ct | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 6ft | 6008941.6423 | 2086478.6989900002 | 37.709578288772896 | -122.41085159474702 | (37.7095782887729, -122.410851594747) | |||
| 67547 | 67547 | 179977 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 670 Brunswick St | 11 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 5998676.25855 | 2086690.45816 | 37.7095787843051 | -122.446345618154 | (37.7095787843051, -122.446345618154) | ||||
| 53213 | 53213 | 179976 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 670 Brunswick St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 5998720.79345 | 2086710.36043 | 37.709635974902504 | -122.446193129116 | (37.7096359749025, -122.446193129116) | ||||
| 168632 | 168632 | 177803 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 670 Brunswick St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | 5998734.37003 | 2086718.8653400003 | 37.70966010280571 | -122.44614681761499 | (37.7096601028057, -122.446146817615) | ||||
| 167044 | 167044 | 177804 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 670 Brunswick St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | 5998746.52485 | 2086721.86687 | 37.709669038459 | -122.446105024329 | (37.709669038459, -122.446105024329) | ||||
| 130318 | 130318 | 179975 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 670 Brunswick St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | 5998755.4264 | 2086725.5872 | 37.7096797619799 | -122.446074526535 | (37.7096797619799, -122.446074526535) | ||||
| 68499 | 68499 | 175876 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 670 Brunswick St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 5998776.13579 | 2086731.33993 | 37.709696740283604 | -122.446003364979 | (37.7096967402836, -122.446003364979) | ||||
| 135146 | 135146 | 175875 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 670 Brunswick St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 5998788.01102 | 2086736.62559 | 37.709711931626394 | -122.445962702139 | (37.7097119316264, -122.445962702139) | ||||
| 37277 | 37277 | 177144 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 224 Naylor St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6002612.15992 | 2086733.11082 | 37.709919907953704 | -122.43274552071001 | (37.7099199079537, -122.43274552071) | |||
| 158841 | 158841 | 177143 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 224 Naylor St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6002598.76646 | 2086748.83961 | 37.7099623361716 | -122.432792933869 | (37.7099623361716, -122.432792933869) | |||
| 55385 | 55385 | 177580 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 765 Morse St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 5ft | 5998269.5566300005 | 2087006.2065299999 | 37.7104225210511 | -122.44777396011801 | (37.7104225210511, -122.447773960118) | |||
| 33930 | 33930 | 179988 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765 Morse St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 5ft | 5998318.043769999 | 2087022.65362 | 37.7104704522241 | -122.447607562158 | (37.7104704522241, -122.447607562158) | |||
| 40909 | 40909 | 175907 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 200 Nueva Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 3ft | 6012827.98154 | 2086955.6822799998 | 37.7111051415626 | -122.39745307312401 | (37.7111051415626, -122.397453073124) | |||
| 60570 | 60570 | 178506 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 228 Cordova St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 3ft | 6001829.54929 | 2087210.3401900001 | 37.7111858584149 | -122.43548448333 | (37.7111858584149, -122.43548448333) | |||
| 188415 | 188415 | 177476 | Undocumented 2 | Malus :: Crab Apple 235 | 87 Cora St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6009578.57754 | 2087278.8009400002 | 37.7118108998241 | -122.40870663432399 | (37.7118108998241, -122.408706634324) | |||
| 39243 | 39243 | 177477 | Undocumented 2 | Malus :: Crab Apple 235 | 87 Cora St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6009582.8430699995 | 2087291.35745 | 37.71184561634829 | -122.408692776665 | (37.7118456163483, -122.408692776665) | |||
| 177096 | 177096 | 177478 | Undocumented 2 | Malus :: Crab Apple 235 | 87 Cora St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6009587.04075 | 2087300.5880000002 | 37.711871196662706 | -122.408678919018 | (37.7118711966627, -122.408678919018) | |||
| 159985 | 159985 | 217535 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 385 Head St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 28 | Width 4ft | 5993463.79196 | 2088414.8734 | 37.714014537420795 | -122.464485782892 | (37.7140145374208, -122.464485782892) | |||
| 41547 | 41547 | 215416 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 286 Orizaba Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | 5994027.68196 | 2088444.22736 | 37.7141276262766 | -122.462538908049 | (37.7141276262766, -122.462538908049) | ||||
| 34503 | 34503 | 215417 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 286 Orizaba Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | 5994025.97554 | 2088461.57938 | 37.7141751725286 | -122.46254606394699 | (37.7141751725286, -122.462546063947) | ||||
| 188473 | 188473 | 215418 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 286 Orizaba Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | 5994025.68496 | 2088506.9373700002 | 37.7142996980529 | -122.462550356439 | (37.7142996980529, -122.462550356439) | ||||
| 60475 | 60475 | 179831 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 966 Randolph St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 5991499.58423 | 2088662.2150700002 | 37.7145802532566 | -122.47129277485399 | (37.7145802532566, -122.471292774854) | |||
| 76642 | 76642 | 179830 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 966 Randolph St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 5991498.1765 | 2088667.9539299998 | 37.7145959293389 | -122.471298058377 | (37.7145959293389, -122.471298058377) | |||
| 40613 | 40613 | 176175 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 89 Ottawa Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 5998972.727519999 | 2088619.88467 | 37.7148934808181 | -122.445459617764 | (37.7148934808181, -122.445459617764) | |||
| 167022 | 167022 | 176174 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 89 Ottawa Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 5998957.51819 | 2088637.0202 | 37.7149396628061 | -122.445513418834 | (37.7149396628061, -122.445513418834) | |||
| 164115 | 164115 | 176173 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 89 Ottawa Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 5998945.18552 | 2088649.14892 | 37.71497226143929 | -122.44555691723 | (37.7149722614393, -122.44555691723) | |||
| 171316 | 171316 | 176172 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 89 Ottawa Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 5998934.49429 | 2088660.58419 | 37.715003049713204 | -122.44559469233499 | (37.7150030497132, -122.445594692335) | |||
| 53053 | 53053 | 219245 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 16 Lobos St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 2ft | 5996729.7413 | 2088712.5742099998 | 37.7150196826824 | -122.45321896478501 | (37.7150196826824, -122.453218964785) | |||
| 171823 | 171823 | 205858 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4 Lobos St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 5996833.75095 | 2088711.6918099998 | 37.7150232206213 | -122.45285940144699 | (37.7150232206213, -122.452859401447) | |||
| 32493 | 32493 | 215383 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 270 Arch St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 5992739.059780001 | 2088994.50565 | 37.7155642635536 | -122.467032825702 | (37.7155642635536, -122.467032825702) | |||
| 175463 | 175463 | 179918 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 270 Rome St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 5998460.475459999 | 2088893.2905 | 37.7156149340708 | -122.447249834324 | (37.7156149340708, -122.447249834324) | |||
| 163824 | 163824 | 217523 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 208 Minerva St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 5994934.27382 | 2089035.0177799999 | 37.715801965169604 | -122.459448160326 | (37.7158019651696, -122.459448160326) | |||
| 132391 | 132391 | 179802 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 185 Rome St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 1ft | 5998783.71606 | 2088961.91688 | 37.715821831192 | -122.446137506065 | (37.715821831192, -122.446137506065) | |||
| 42892 | 42892 | 218825 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 295 Bright St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 5993731.49381 | 2089150.28883 | 37.716049240944706 | -122.463613852416 | (37.7160492409447, -122.463613852416) | |||
| 172743 | 172743 | 176828 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1581 Cayuga Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 1ft | 5998637.772919999 | 2089144.8759400002 | 37.7163158593728 | -122.446655107259 | (37.7163158593728, -122.446655107259) | |||
| 34597 | 34597 | 211298 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 401 Orizaba Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 5ft | 5993996.41913 | 2089243.4812200002 | 37.7163203865396 | -122.462704908526 | (37.7163203865396, -122.462704908526) | |||
| 129593 | 129593 | 176829 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1581 Cayuga Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 1ft | 5998649.34679 | 2089153.88395 | 37.7163412544316 | -122.446615750237 | (37.7163412544316, -122.446615750237) | |||
| 55295 | 55295 | 176830 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1581 Cayuga Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 1ft | 5998657.8361599995 | 2089162.37902 | 37.7163650648728 | -122.44658701780001 | (37.7163650648728, -122.4465870178) | |||
| 58150 | 58150 | 211299 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 212 Vernon St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 5992481.14355 | 2089300.95007 | 37.71639079536521 | -122.46794656929701 | (37.7163907953652, -122.467946569297) | |||
| 178346 | 178346 | 176831 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1567 Cayuga Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 8ft | 5998676.7168 | 2089183.1568 | 37.7164231943611 | -122.446523251341 | (37.7164231943611, -122.446523251341) | |||
| 155873 | 155873 | 218816 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 170 Margaret Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 5996666.019619999 | 2089250.8609200001 | 37.716494040240796 | -122.45347805498899 | (37.7164940402408, -122.453478054989) | |||
| 151196 | 151196 | 176832 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1555 Cayuga Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 1ft | 5998713.68097 | 2089214.6780599998 | 37.7165118558136 | -122.446397751868 | (37.7165118558136, -122.446397751868) | |||
| 160805 | 160805 | 176833 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1555 Cayuga Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 1ft | 5998716.673690001 | 2089217.8714599998 | 37.7165207950888 | -122.446387637188 | (37.7165207950888, -122.446387637188) | |||
| 151402 | 151402 | 178863 | Undocumented 2 | Prunus persica :: Peach 330 | 1555 Cayuga Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 1ft | 5998718.88038 | 2089220.60137 | 37.7165284168318 | -122.44638020607901 | (37.7165284168318, -122.446380206079) | |||
| 57091 | 57091 | 179247 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 353 Prague St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6003781.052759999 | 2089121.49913 | 37.7165441288874 | -122.42887576852199 | (37.7165441288874, -122.428875768522) | |||
| 174539 | 174539 | 207721 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 228 Montana St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 5994631.9391 | 2089350.3088 | 37.7166502911674 | -122.460515994629 | (37.7166502911674, -122.460515994629) | ||||
| 151061 | 151061 | 210933 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 154 Margaret Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 27 | Width 10ft | 5996718.73035 | 2089319.81928 | 37.716686405220706 | -122.45330083726299 | (37.7166864052207, -122.453300837263) | |||
| 183633 | 183633 | 219215 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 446 Orizaba Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 6ft | 5994049.54462 | 2089400.1465099999 | 37.7167536115793 | -122.462532639778 | (37.7167536115793, -122.462532639778) | |||
| 187991 | 187991 | 215375 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 450 Orizaba Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 6ft | 5994049.9247 | 2089421.0969200002 | 37.716811158290206 | -122.462532844839 | (37.7168111582902, -122.462532844839) | |||
| 156462 | 156462 | 215376 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 450 Orizaba Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 6ft | 5994050.06731 | 2089427.8960900002 | 37.7168298353999 | -122.462532844816 | (37.7168298353999, -122.462532844816) | |||
| 138130 | 138130 | 203340 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 458 Orizaba Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 6ft | 5994050.25067 | 2089476.7448099998 | 37.71696397287629 | -122.462535752332 | (37.7169639728763, -122.462535752332) | |||
| 31389 | 31389 | 211482 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 458 Orizaba Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 1ft | 5994045.41043 | 2089492.79513 | 37.7170077644759 | -122.46255364615699 | (37.7170077644759, -122.462553646157) | |||
| 61817 | 61817 | 211480 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 458 Orizaba Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 1ft | 5994051.74701 | 2089492.86038 | 37.71700830855371 | -122.462531748549 | (37.7170083085537, -122.462531748549) | |||
| 147856 | 147856 | 211481 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 458 Orizaba Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 1ft | 5994048.36412 | 2089493.0594 | 37.7170086601986 | -122.462543455909 | (37.7170086601986, -122.462543455909) | |||
| 169737 | 169737 | 176835 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 114 Niagara Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 5999510.24603 | 2089471.7936200001 | 37.717263300525396 | -122.443662898245 | (37.7172633005254, -122.443662898245) | |||
| 66603 | 66603 | 179809 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 114 Niagara Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 0ft | 5999497.59387 | 2089483.70241 | 37.717295277729505 | -122.443707485722 | (37.7172952777295, -122.443707485722) | |||
| 64348 | 64348 | 215243 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 284 Thrift St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | 5994231.73056 | 2089665.2528900001 | 37.7174920206045 | -122.461922130513 | (37.7174920206045, -122.461922130513) | ||||
| 46204 | 46204 | 213204 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 284 Thrift St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | 5994231.94544 | 2089668.7631299999 | 37.7175016712563 | -122.46192164217501 | (37.7175016712563, -122.461921642175) | ||||
| 173568 | 173568 | 207489 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 226 Thrift St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 6ft | 5994760.7353 | 2089660.3504700002 | 37.7175090007127 | -122.460093262 | (37.7175090007127, -122.460093262) | |||
| 54071 | 54071 | 207232 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 226 Thrift St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 6ft | 5994766.53745 | 2089660.64097 | 37.7175101320775 | -122.46007322780301 | (37.7175101320775, -122.460073227803) | |||
| 155390 | 155390 | 176273 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 179 Niagara Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 5999314.98259 | 2089602.87456 | 37.717612080124205 | -122.444347244552 | (37.7176120801242, -122.444347244552) | |||
| 155016 | 155016 | 176272 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 179 Niagara Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 5999311.03211 | 2089604.94508 | 37.717617539904296 | -122.444361048235 | (37.7176175399043, -122.444361048235) | |||
| 51153 | 51153 | 176836 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 182 Niagara Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 5999285.39372 | 2089701.94289 | 37.7178824109155 | -122.444456635388 | (37.7178824109155, -122.444456635388) | |||
| 69555 | 69555 | 176837 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 182 Niagara Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 5999279.6106900005 | 2089709.20322 | 37.717902016153204 | -122.444477146204 | (37.7179020161532, -122.444477146204) | |||
| 170662 | 170662 | 176838 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 182 Niagara Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 5999273.76628 | 2089713.5101700001 | 37.7179135085776 | -122.44449765705299 | (37.7179135085776, -122.444497657053) | |||
| 58589 | 58589 | 176839 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 182 Niagara Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 5999268.4674 | 2089720.26783 | 37.717931761216605 | -122.444516458293 | (37.7179317612166, -122.444516458293) | |||
| 135012 | 135012 | 176840 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 182 Niagara Ave | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 5999263.40536 | 2089726.5279700002 | 37.7179486612904 | -122.444534405156 | (37.7179486612904, -122.444534405156) | |||
| 157002 | 157002 | 176841 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 182 Niagara Ave | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 5999258.34845 | 2089733.03463 | 37.7179662385418 | -122.444552352003 | (37.7179662385418, -122.444552352003) | |||
| 56652 | 56652 | 176842 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 182 Niagara Ave | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 5999251.78306 | 2089738.34145 | 37.717980435227396 | -122.44457542680901 | (37.7179804352274, -122.444575426809) | |||
| 40241 | 40241 | 176843 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 182 Niagara Ave | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 5999252.47179 | 2089747.68303 | 37.718006124373105 | -122.444573717211 | (37.7180061243731, -122.444573717211) | |||
| 34911 | 34911 | 176616 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1373 Cayuga Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 5999306.08729 | 2089805.4122099997 | 37.7181676947695 | -122.44439253889601 | (37.7181676947695, -122.444392538896) | |||
| 56650 | 56650 | 179810 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1367 Cayuga Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 0ft | 5999324.75892 | 2089823.48937 | 37.71821839584229 | -122.444329297662 | (37.7182183958423, -122.444329297662) | |||
| 48635 | 48635 | 176617 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1367 Cayuga Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 0ft | 5999325.43091 | 2089826.3295 | 37.718226232531 | -122.444327178876 | (37.718226232531, -122.444327178876) | |||
| 156732 | 156732 | 179811 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1367 Cayuga Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 0ft | 5999338.1539900005 | 2089837.4910099998 | 37.7182576053899 | -122.444284002399 | (37.7182576053899, -122.444284002399) | |||
| 175433 | 175433 | 179812 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1349 Cayuga Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 5999375.14619 | 2089880.54718 | 37.71837793826 | -122.444159228684 | (37.71837793826, -122.444159228684) | |||
| 65234 | 65234 | 179813 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1349 Cayuga Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 5999385.00434 | 2089890.92911 | 37.71840700706821 | -122.444125898896 | (37.7184070070682, -122.444125898896) | |||
| 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) | |||
| 171576 | 171576 | 211717 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 431 Arch St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 4ft | 5992705.603080001 | 2090068.8173099998 | 37.7185121324114 | -122.46722653337099 | (37.7185121324114, -122.467226533371) | |||
| 123744 | 123744 | 208884 | Undocumented 2 | Malus :: Crab Apple 235 | 450 Bright St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 5993793.0659300005 | 2090164.68597 | 37.7188380799952 | -122.46347460498001 | (37.7188380799952, -122.46347460498) | |||
| 186557 | 186557 | 207266 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 450 Bright St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 5993794.13591 | 2090181.7036599999 | 37.7188848681307 | -122.463472140835 | (37.7188848681307, -122.463472140835) | |||
| 72591 | 72591 | 177042 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 123 Seneca Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 6000059.76293 | 2090063.89794 | 37.7189204111404 | -122.441805953806 | (37.7189204111404, -122.441805953806) | |||
| 176316 | 176316 | 210950 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 454 Bright St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 6ft | 5993793.8030900005 | 2090199.81591 | 37.718934580840504 | -122.46347460496901 | (37.7189345808405, -122.463474604969) | |||
| 150604 | 150604 | 177029 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 123 Seneca Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6000050.7624699995 | 2090072.63848 | 37.7189438978236 | -122.441837691751 | (37.7189438978236, -122.441837691751) |
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");