Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: PlantType, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 102548 | 102548 | 101898 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 99X MacOndray Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6008233.5 | 2119097.7 | 37.7991029311983 | -122.415607021356 | (37.7991029311983, -122.415607021356) | |||||
| 105468 | 105468 | 101899 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 99X MacOndray Ln | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6008233.5 | 2119097.7 | 37.7991029311983 | -122.415607021356 | (37.7991029311983, -122.415607021356) | |||||
| 96595 | 96595 | 106311 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 99X Clearfield Dr | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 04/15/2014 12:00:00 AM | Permit Number 772542 | 5985798.26078 | 2095453.4648400003 | 37.73289581695511 | -122.49149816384899 | (37.7328958169551, -122.491498163849) | |||
| 142007 | 142007 | 106310 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 99X Clearfield Dr | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 04/15/2014 12:00:00 AM | Permit Number 772542 | 5985798.26078 | 2095453.4648400003 | 37.73289581695511 | -122.49149816384899 | (37.7328958169551, -122.491498163849) | |||
| 188844 | 188844 | 132293 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 999 North Point St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 6005925.58045 | 2121359.44598 | 37.805183106669 | -122.42375411867799 | (37.805183106669, -122.423754118678) | |||
| 33408 | 33408 | 206428 | Undocumented 2 | Cotinus coggygria 'Royal Purple' :: Smoke tree 298 | 999 Chenery St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6000994.535540001 | 2096137.9809700001 | 37.7356516718869 | -122.43900989591499 | (37.7356516718869, -122.439009895915) | |||
| 181423 | 181423 | 228419 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 998 York St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6009935.93265 | 2103433.9763599997 | 37.7561895713205 | -122.408610430245 | (37.7561895713205, -122.408610430245) | |||
| 188722 | 188722 | 224463 | Undocumented 2 | Ficus Spp. :: 253 | 998 York St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6009934.61987 | 2103458.53933 | 37.7562569422093 | -122.408616703004 | (37.7562569422093, -122.408616703004) | |||
| 63265 | 63265 | 190633 | Undocumented 2 | Grevillea robusta :: Silk Oak Tree 145 | 998 Kansas St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 10ft | 6011587.55607 | 2103749.45298 | 37.75714816318521 | -122.402920709219 | (37.7571481631852, -122.402920709219) | |||
| 134660 | 134660 | 194485 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 998 Kansas St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 40 | Width 10ft | 6011603.18064 | 2103745.73679 | 37.7571388318007 | -122.40286641177299 | (37.7571388318007, -122.402866411773) | |||
| 175051 | 175051 | 129722 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 998 Chestnut St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6007108.76695 | 2120556.6740099997 | 37.8030456187175 | -122.419602556719 | (37.8030456187175, -122.419602556719) | |||
| 4549 | 4549 | 226945 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 998 Chenery St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 1ft | 6001140.61217 | 2096125.6115299999 | 37.735626018710896 | -122.438503967885 | (37.7356260187109, -122.438503967885) | |||
| 65449 | 65449 | 226944 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 998 Chenery St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 1ft | 6001147.55227 | 2096122.75745 | 37.735618576845205 | -122.43847976892401 | (37.7356185768452, -122.438479768924) | |||
| 53262 | 53262 | 238586 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 991 San Bruno Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 6ft | 6011096.081069999 | 2103736.7001400003 | 37.7570856908704 | -122.40461953036501 | (37.7570856908704, -122.404619530365) | |||
| 4028 | 4028 | 216741 | Undocumented 2 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 990 Plymouth Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/05/2017 07:49:00 AM | 3 | Width 4ft | 5995950.8772 | 2090428.1380900003 | 37.719685546243895 | -122.456034989421 | (37.7196855462439, -122.456034989421) | ||
| 4068 | 4068 | 216743 | Undocumented 2 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 990 Plymouth Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/05/2017 07:52:00 AM | 3 | Width 4ft | 5995950.66479 | 2090454.56836 | 37.7197581053329 | -122.45603763343901 | (37.7197581053329, -122.456037633439) | ||
| 70460 | 70460 | 129566 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 99 Toledo Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6001391.4418 | 2119925.56535 | 37.800989055367 | -122.439342181017 | (37.800989055367, -122.439342181017) | |||
| 1945 | 1945 | 252839 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 99 Pond St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1956 | 1956 | 252838 | Significant Tree 6 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 99 Pond St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 35648 | 35648 | 132345 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 99 North Point St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 4ft | 6010293.68664 | 2121970.09812 | 37.807105416557995 | -122.408680791404 | (37.807105416558, -122.408680791404) | |||
| 44231 | 44231 | 132352 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 99 North Point St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 6010400.48539 | 2121983.74228 | 37.8071488610029 | -122.408312153001 | (37.8071488610029, -122.408312153001) | |||
| 48856 | 48856 | 132353 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 99 North Point St | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6010444.3802 | 2121991.1202599998 | 37.8071715769765 | -122.408160765609 | (37.8071715769765, -122.408160765609) | |||
| 53010 | 53010 | 132343 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 99 North Point St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6010257.55272 | 2121964.32975 | 37.8070875542059 | -122.40880543381901 | (37.8070875542059, -122.408805433819) | |||
| 57489 | 57489 | 132349 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 99 North Point St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6010357.97788 | 2121979.4044 | 37.8071345698829 | -122.408458953812 | (37.8071345698829, -122.408458953812) | |||
| 60541 | 60541 | 132340 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 99 North Point St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6010250.3347 | 2121963.67978 | 37.807085365256206 | -122.408830367525 | (37.8070853652562, -122.408830367525) | |||
| 61903 | 61903 | 132347 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 99 North Point St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6010337.00106 | 2121976.0282799997 | 37.8071241251481 | -122.40853131058998 | (37.8071241251481, -122.40853131059) | |||
| 61929 | 61929 | 132346 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 99 North Point St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 4ft | 6010313.38408 | 2121972.38767 | 37.8071128062815 | -122.408612785551 | (37.8071128062815, -122.408612785551) | |||
| 62390 | 62390 | 133156 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 99 North Point St | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6010460.75882 | 2121992.28603 | 37.8071756949569 | -122.408104165883 | (37.8071756949569, -122.408104165883) | |||
| 68687 | 68687 | 132348 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 99 North Point St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6010354.50875 | 2121976.8725799997 | 37.8071274238595 | -122.40847078082399 | (37.8071274238595, -122.408470780824) | |||
| 77253 | 77253 | 132344 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 99 North Point St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6010271.51992 | 2121966.31562 | 37.807093789222705 | -122.408757237352 | (37.8070937892227, -122.408757237352) | |||
| 135225 | 135225 | 132341 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 99 North Point St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6010253.820780001 | 2121967.79388 | 37.807096856811704 | -122.408818593599 | (37.8070968568117, -122.408818593599) | |||
| 149725 | 149725 | 136320 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 99 North Point St | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6010568.43745 | 2122006.8054400003 | 37.8072215900736 | -122.40773254351801 | (37.8072215900736, -122.407732543518) | |||
| 150939 | 150939 | 133155 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 99 North Point St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6010424.25918 | 2121988.2428099997 | 37.8071625495686 | -122.408230195965 | (37.8071625495686, -122.408230195965) | |||
| 161485 | 161485 | 132350 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 99 North Point St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 4ft | 6010382.56388 | 2121982.30602 | 37.8071439138247 | -122.40837407312901 | (37.8071439138247, -122.408374073129) | |||
| 165341 | 165341 | 136319 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 99 North Point St | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6010537.589980001 | 2122003.14861 | 37.8072098224406 | -122.40783904035901 | (37.8072098224406, -122.407839040359) | |||
| 166935 | 166935 | 132351 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 99 North Point St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6010391.05696 | 2121984.73538 | 37.807151059840606 | -122.40834485234 | (37.8071510598406, -122.40834485234) | |||
| 174669 | 174669 | 132342 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 99 North Point St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6010256.82175 | 2121967.7326599997 | 37.807096856806105 | -122.408808203739 | (37.8070968568061, -122.408808203739) | |||
| 183440 | 183440 | 126366 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 99 MacOndray Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 56 | 6008010.57204 | 2119080.4393700003 | 37.799043004282204 | -122.41637720656401 | (37.7990430042822, -122.416377206564) | ||||
| 82365 | 82365 | 122756 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 99 Fernwood Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 40 | 3x3 | 5994769.0 | 2095318.0 | 37.7330440171503 | -122.46047442029699 | (37.7330440171503, -122.460474420297) | |||
| 23847 | 23847 | 226860 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 99 Elk St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 6000812.22961 | 2096323.57705 | 37.7361509008315 | -122.43965349751801 | (37.7361509008315, -122.439653497518) | |||
| 50650 | 50650 | 226858 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 99 Elk St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 2ft | 6000811.86786 | 2096313.4540400002 | 37.736123084819496 | -122.43965402273001 | (37.7361230848195, -122.43965402273) | |||
| 70212 | 70212 | 226857 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 99 Elk St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 2ft | 6000811.73315 | 2096306.95535 | 37.7361052332666 | -122.439654022723 | (37.7361052332666, -122.439654022723) | |||
| 158588 | 158588 | 226859 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 99 Elk St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 2ft | 6000812.12935 | 2096318.74052 | 37.7361376151427 | -122.439653497529 | (37.7361376151427, -122.439653497529) | |||
| 168169 | 168169 | 226862 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 99 Elk St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6000812.75868 | 2096333.6910299999 | 37.7361787015724 | -122.439652393167 | (37.7361787015724, -122.439652393167) | |||
| 169062 | 169062 | 226863 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 99 Elk St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 2ft | 6000813.02064 | 2096338.5481200002 | 37.7361920529176 | -122.43965183556699 | (37.7361920529176, -122.439651835567) | |||
| 182231 | 182231 | 226861 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 99 Elk St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6000812.78199 | 2096328.25256 | 37.7361637701303 | -122.439651922807 | (37.7361637701303, -122.439651922807) | |||
| 54439 | 54439 | 120440 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 99 22nd Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | 5988935.73102 | 2114756.99709 | 37.7860809522857 | -122.48206489481599 | (37.7860809522857, -122.482064894816) | ||||
| 79584 | 79584 | 116089 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 98x WOODWARD ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6006422.0 | 2107919.0 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | ||||
| 103243 | 103243 | 116088 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 98x WOODWARD ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6006422.0 | 2107919.0 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | ||||
| 107871 | 107871 | 116087 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 98x WOODWARD ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6006422.0 | 2107919.0 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | ||||
| 125535 | 125535 | 116090 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 98x WOODWARD ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6006422.0 | 2107919.0 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | ||||
| 3544 | 3544 | 253465 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
| 3561 | 3561 | 253462 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
| 3567 | 3567 | 253463 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
| 3577 | 3577 | 253466 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98X Marston Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
| 3585 | 3585 | 253464 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
| 32538 | 32538 | 221670 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 985 San Bruno Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6011091.323 | 2103767.31713 | 37.7571694924002 | -122.40463814095699 | (37.7571694924002, -122.404638140957) | |||
| 75189 | 75189 | 176701 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 985 Avalon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6005395.13627 | 2092229.7099400002 | 37.7251698288036 | -122.42351753851601 | (37.7251698288036, -122.423517538516) | |||
| 183316 | 183316 | 179867 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 985 Avalon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6005404.976009999 | 2092232.7341599998 | 37.7251786880381 | -122.423483738408 | (37.7251786880381, -122.423483738408) | |||
| 70006 | 70006 | 175852 | Undocumented 2 | Citrus aurantifolia 'Bearss' :: Seedless Lime 268 | 981 Delano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 9ft | 5998486.05845 | 2089261.9262299999 | 37.7166285851125 | -122.447187923197 | (37.7166285851125, -122.447187923197) | |||
| 170444 | 170444 | 175916 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98 Teddy Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 6010863.76059 | 2087996.01367 | 37.7138521198643 | -122.404315111648 | (37.7138521198643, -122.404315111648) | ||||
| 53451 | 53451 | 132632 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 98 Spruce St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5997056.52317 | 2116093.53652 | 37.7902196990203 | -122.45406584826999 | (37.7902196990203, -122.45406584827) | |||
| 148068 | 148068 | 223958 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 98 Seward St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6000714.90104 | 2104629.8807900003 | 37.7589524846915 | -122.440585589054 | (37.7589524846915, -122.440585589054) | |||
| 154740 | 154740 | 223957 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 98 Seward St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 6000715.72405 | 2104622.0065599997 | 37.7589309108477 | -122.440582177927 | (37.7589309108477, -122.440582177927) | |||
| 31524 | 31524 | 175845 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 98 Newton St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 10ft | 6000912.9484 | 2087984.8955700002 | 37.7132605143345 | -122.43870794134399 | (37.7132605143345, -122.438707941344) | |||
| 26776 | 26776 | 213745 | Undocumented 2 | Psidium guajava :: Guava tree 252 | 98 Lurline St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5991840.41055 | 2105148.54995 | 37.7598672660797 | -122.471315241723 | (37.7598672660797, -122.471315241723) | |||
| 187368 | 187368 | 219226 | Undocumented 2 | Ilex spp :: Holly Species 163 | 98 Lurline St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5991838.5673400005 | 2105160.13567 | 37.759898970787 | -122.47132246058399 | (37.759898970787, -122.471322460584) | |||
| 23443 | 23443 | 248249 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 98 Lundy's Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 6006859.99776 | 2099020.88579 | 37.743899476678706 | -122.418935096973 | (37.7438994766787, -122.418935096973) | |||
| 27398 | 27398 | 205475 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98 Judson Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 5999461.68909 | 2093522.86386 | 37.7283838376284 | -122.444121665807 | (37.7283838376284, -122.444121665807) | ||||
| 32592 | 32592 | 205476 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98 Judson Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5999461.7393 | 2093534.4829400002 | 37.7284157437829 | -122.444122326784 | (37.7284157437829, -122.444122326784) | ||||
| 41451 | 41451 | 205472 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98 Judson Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 5999475.13727 | 2093536.5919400002 | 37.7284222989294 | -122.444076160988 | (37.7284222989294, -122.444076160988) | ||||
| 43713 | 43713 | 205474 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98 Judson Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5999468.48436 | 2093527.67559 | 37.728397437176106 | -122.444098519924 | (37.7283974371761, -122.444098519924) | ||||
| 59313 | 59313 | 205473 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98 Judson Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5999475.64233 | 2093531.5269999998 | 37.728408420594704 | -122.44407405119 | (37.7284084205947, -122.44407405119) | ||||
| 130171 | 130171 | 205471 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98 Judson Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5999482.0353 | 2093535.39464 | 37.7284194049318 | -122.44405222824899 | (37.7284194049318, -122.444052228249) | ||||
| 157652 | 157652 | 205477 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98 Judson Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5999454.95195 | 2093530.0519599998 | 37.7284031901334 | -122.444145472637 | (37.7284031901334, -122.444145472637) | ||||
| 158480 | 158480 | 207525 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 98 Judson Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5999467.57051 | 2093538.93345 | 37.728428296507104 | -122.444102487738 | (37.7284282965071, -122.444102487738) | ||||
| 171748 | 171748 | 207363 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 98 Judson Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5999482.34141 | 2093540.9124 | 37.7284345728794 | -122.444051566321 | (37.7284345728794, -122.444051566321) | ||||
| 35353 | 35353 | 234848 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 98 Hill St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 6005792.82845 | 2103474.22766 | 37.7560671816819 | -122.42294157491999 | (37.7560671816819, -122.42294157492) | |||
| 40541 | 40541 | 234849 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 98 Hill St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 6005763.2044 | 2103470.66995 | 37.756055741406996 | -122.423043772075 | (37.756055741407, -122.423043772075) | |||
| 123303 | 123303 | 234847 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 98 Hill St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 6005800.09169 | 2103473.84487 | 37.756066540467295 | -122.422916428967 | (37.7560665404673, -122.422916428967) | |||
| 136495 | 136495 | 234840 | Undocumented 2 | Podocarpus henkelii :: Long-Leafed Yellow-Wood 314 | 98 Hill St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6005749.451780001 | 2103470.6109700003 | 37.756054803396296 | -122.42309132910101 | (37.7560548033963, -122.423091329101) | |||
| 153225 | 153225 | 234846 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 98 Hill St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 6005812.3026 | 2103474.52838 | 37.7560691062312 | -122.422874248071 | (37.7560691062312, -122.422874248071) | |||
| 134667 | 134667 | 220737 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 98 Crescent Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 2ft | 6005788.78972 | 2095836.9730000002 | 37.7350967901794 | -122.422412909327 | (37.7350967901794, -122.422412909327) | |||
| 176554 | 176554 | 136638 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 98 Blake St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5997852.8228 | 2113221.0345799997 | 37.7823781953411 | -122.451103490434 | (37.7823781953411, -122.451103490434) | |||
| 47001 | 47001 | 122962 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 98 09th Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 5993057.14542 | 2114935.59748 | 37.786810183441204 | -122.46781902207898 | (37.7868101834412, -122.467819022079) | |||
| 43834 | 43834 | 205429 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 979 Teresita Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 5998328.88078 | 2095661.5706 | 37.7341915308101 | -122.448191757267 | (37.7341915308101, -122.448191757267) | |||
| 72917 | 72917 | 219419 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 979 Teresita Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 5998332.28309 | 2095661.19123 | 37.734190683652 | -122.44817996714599 | (37.734190683652, -122.448179967146) | |||
| 146396 | 146396 | 206912 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 979 Teresita Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 2ft | 5998337.2254099995 | 2095660.3163400001 | 37.734188563950205 | -122.448162817076 | (37.7341885639502, -122.448162817076) | |||
| 27786 | 27786 | 243964 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 979 San Bruno Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6011092.59342 | 2103787.62329 | 37.7572253196086 | -122.40463517678002 | (37.7572253196086, -122.40463517678) | |||
| 44469 | 44469 | 215242 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 978 Capitol Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 1ft | 5995069.34707 | 2090438.49633 | 37.71966335006721 | -122.459082852985 | (37.7196633500672, -122.459082852985) | |||
| 170108 | 170108 | 215241 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 978 Capitol Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 5995069.40558 | 2090424.4905400001 | 37.719624896864204 | -122.459081637134 | (37.7196248968642, -122.459081637134) | |||
| 182044 | 182044 | 129244 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 977 Pacific Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6009468.5777900005 | 2118046.06464 | 37.796284746692294 | -122.41125888781201 | (37.7962847466923, -122.411258887812) | |||
| 62406 | 62406 | 179179 | Undocumented 2 | Pseudotsuga menziesii :: Douglas Fir 231 | 976 Avalon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6005365.19598 | 2092163.67204 | 37.7249868131864 | -122.423616346115 | (37.7249868131864, -122.423616346115) | |||
| 68443 | 68443 | 179178 | Undocumented 2 | Pseudotsuga menziesii :: Douglas Fir 231 | 976 Avalon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6005358.471390001 | 2092159.7928099998 | 37.72497578208579 | -122.423639316619 | (37.7249757820858, -122.423639316619) | |||
| 64887 | 64887 | 124159 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 970 Anza St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 5995776.57441 | 2112223.28537 | 37.7795195518878 | -122.45821411290599 | (37.7795195518878, -122.458214112906) | |||
| 147870 | 147870 | 124158 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 970 Anza St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 5995788.03534 | 2112225.31952 | 37.7795257956775 | -122.458174612179 | (37.7795257956775, -122.458174612179) | |||
| 50740 | 50740 | 129892 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 97 Parker Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5996812.70207 | 2113910.24255 | 37.7842109731914 | -122.454751639797 | (37.7842109731914, -122.454751639797) | |||
| 137996 | 137996 | 211078 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 97 Ashton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 8ft | 5994121.912690001 | 2090532.8785299999 | 37.7198679898921 | -122.46236461134599 | (37.7198679898921, -122.462364611346) | |||
| 60198 | 60198 | 205431 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 965 Teresita Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 4ft | 5998412.37074 | 2095666.00705 | 37.7342084848239 | -122.447903426526 | (37.7342084848239, -122.447903426526) | |||
| 149415 | 149415 | 205430 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 965 Teresita Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 4ft | 5998406.65668 | 2095666.5963400002 | 37.7342097762612 | -122.44792322417601 | (37.7342097762612, -122.447923224176) |
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");