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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2811 | 2811 | 115532 | Planning Code 138.1 required 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 100X Hayes St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007293.46404 | 2111265.83422 | 37.777545665835596 | -122.41830427922501 | (37.7775456658356, -122.418304279225) | ||
| 6140 | 6140 | 115534 | Planning Code 138.1 required 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 100X Hayes St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007259.83389 | 2111260.26588 | 37.777528483399294 | -122.418420222514 | (37.7775284833993, -122.418420222514) | ||
| 6989 | 6989 | 115533 | Planning Code 138.1 required 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 100X Hayes St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007275.38703 | 2111262.82601 | 37.7775363884346 | -122.418366600452 | (37.7775363884346, -122.418366600452) | ||
| 8241 | 8241 | 115531 | Planning Code 138.1 required 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 100X Hayes St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007312.7374599995 | 2111269.98589 | 37.777558150214404 | -122.41823790028 | (37.7775581502144, -122.41823790028) | ||
| 8494 | 8494 | 115535 | Planning Code 138.1 required 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 100X Hayes St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007237.56945 | 2111260.60051 | 37.777528148837796 | -122.41849726655899 | (37.7775281488378, -122.418497266559) | ||
| 16896 | 16896 | 100001 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 501X 01st St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Address is 100 1st Street | |||||||||
| 18492 | 18492 | 63236 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 3634 20th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 01/13/1987 12:00:00 AM | 12 | Permit Number 23784 | 6006063.67565171 | 2104362.69748074 | 37.7585219924343 | -122.422068008351 | (37.7585219924343, -122.422068008351) | |
| 23806 | 23806 | 232314 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 99 Elsie St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 6007320.806890001 | 2098778.15204 | 37.7432589210582 | -122.417324523624 | (37.7432589210582, -122.417324523624) | ||||
| 27555 | 27555 | 101445 | Permitted Site 1 | Prunus persica :: Peach 330 | 771 Stockton Tunl | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Permit Number 25247 | 6010467.187000001 | 2116750.7503 | 37.7927840821229 | -122.407712097586 | (37.7927840821229, -122.407712097586) | |||
| 31166 | 31166 | 125541 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 65 Heather Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | 5997339.5515 | 2114115.46943 | 37.7848046777406 | -122.45294375606501 | (37.7848046777406, -122.452943756065) | ||||
| 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) | ||||
| 34732 | 34732 | 100681 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 400 California St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | 6012316.03692 | 2116830.7554099998 | 37.793107081281 | -122.401320580594 | (37.793107081281, -122.401320580594) | ||||
| 35849 | 35849 | 197509 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | 6009753.46902 | 2109444.94334 | 37.7726840927246 | -122.40966570732999 | (37.7726840927246, -122.40966570733) | ||||
| 36736 | 36736 | 205507 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1518 05th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 24 | 5994641.653519999 | 2105137.30281 | 37.7599980266194 | -122.46162636506 | (37.7599980266194, -122.46162636506) | ||||
| 39376 | 39376 | 239418 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2106 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 6002637.419840001 | 2099337.55033 | 37.7445302890331 | -122.433558405315 | (37.7445302890331, -122.433558405315) | ||||
| 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) | ||||
| 41984 | 41984 | 135853 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 12 Filbert St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 26 | 6012286.0131 | 2120198.4327700003 | 37.8023522396158 | -122.40166127704799 | (37.8023522396158, -122.401661277048) | ||||
| 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) | ||||
| 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) | ||||
| 43845 | 43845 | 236752 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 420 Collingwood St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | 6002107.159440001 | 2103370.74755 | 37.755574390960604 | -122.435680430326 | (37.7555743909606, -122.435680430326) | ||||
| 45796 | 45796 | 233304 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 793 27th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | 6001400.58211 | 2099957.57673 | 37.746162481213496 | -122.437879532637 | (37.7461624812135, -122.437879532637) | ||||
| 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) | ||||
| 46989 | 46989 | 197759 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1275 Harrison St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 6009794.14273 | 2110264.73929 | 37.7749373405286 | -122.409582883362 | (37.7749373405286, -122.409582883362) | ||||
| 48400 | 48400 | 236754 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 456 Collingwood St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 6002114.12722 | 2103211.5772 | 37.755137743137496 | -122.435644946673 | (37.7551377431375, -122.435644946673) | ||||
| 48865 | 48865 | 197760 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1221 Harrison St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 6009984.84437 | 2109679.97053 | 37.773342385672 | -122.408881936452 | (37.773342385672, -122.408881936452) | ||||
| 50185 | 50185 | 238001 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 591 27th St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | 6002762.01889 | 2100032.1411900003 | 37.746444541887705 | -122.43317718719601 | (37.7464445418877, -122.433177187196) | ||||
| 50258 | 50258 | 205681 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 134 Lomita Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 5991402.87169 | 2104383.6674599997 | 37.7577417813829 | -122.472772688422 | (37.7577417813829, -122.472772688422) | ||||
| 52680 | 52680 | 96544 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100@ Front St Pine St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | 2 | Permit Number 767720 | 6013029.74558 | 2116576.80835 | 37.7924495959214 | -122.39883325906099 | (37.7924495959214, -122.398833259061) | ||
| 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) | ||||
| 54358 | 54358 | 219993 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 Prospect Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | 6006993.27252 | 2098944.7494 | 37.7436979269164 | -122.418468865069 | (37.7436979269164, -122.418468865069) | ||||
| 55028 | 55028 | 100685 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 400 California St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | 6012263.39214 | 2116825.45731 | 37.7930895966627 | -122.40150236324101 | (37.7930895966627, -122.401502363241) | ||||
| 55352 | 55352 | 244013 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 502 28th St | 10 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 46 | 6002533.73614 | 2099484.81655 | 37.7449287642466 | -122.43392744661001 | (37.7449287642466, -122.43392744661) | ||||
| 56310 | 56310 | 198008 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 280 Shipley St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | 6011263.84387 | 2111528.91648 | 37.778490722908 | -122.40458785715799 | (37.778490722908, -122.404587857158) | ||||
| 59110 | 59110 | 93913 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1233 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 04/26/2010 12:00:00 AM | 3 | Permit Number 53384 | 6006791.18319 | 2115201.26263 | 37.7883231061636 | -122.42032123196002 | (37.7883231061636, -122.42032123196) | ||
| 61307 | 61307 | 222987 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 502 28th St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 6002610.5339 | 2099487.4912400004 | 37.7449404662242 | -122.43366208545099 | (37.7449404662242, -122.433662085451) | ||||
| 61599 | 61599 | 227266 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 748 Duncan St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | 6001689.1464 | 2099734.32113 | 37.7455658790712 | -122.436865735875 | (37.7455658790712, -122.436865735875) | ||||
| 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) | ||||
| 64396 | 64396 | 98493 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1703 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 6006578.8967 | 2116733.3834 | 37.7925179651008 | -122.421164544764 | (37.7925179651008, -122.421164544764) | ||||
| 65915 | 65915 | 199602 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 628 Missouri St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | 6013530.55815 | 2104182.03337 | 37.7584442391246 | -122.396231328824 | (37.7584442391246, -122.396231328824) | ||||
| 66626 | 66626 | 196361 | Undocumented 2 | Prunus persica :: Peach 330 | 628 Missouri St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | 6013522.64846 | 2104174.29793 | 37.7584225591685 | -122.396258142101 | (37.7584225591685, -122.396258142101) | ||||
| 66714 | 66714 | 227264 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 748 Duncan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 6001689.2287 | 2099738.29729 | 37.7455768013454 | -122.436865735887 | (37.7455768013454, -122.436865735887) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 70160 | 70160 | 244009 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 4347 Cesar Chavez St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 46 | 6001613.39375 | 2100265.8497900004 | 37.7470210253004 | -122.43716572632799 | (37.7470210253004, -122.437165726328) | ||||
| 73424 | 73424 | 197511 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | 6009774.86658 | 2109479.2363299998 | 37.772779452333204 | -122.40959411137699 | (37.7727794523332, -122.409594111377) | ||||
| 74711 | 74711 | 197510 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | 6009757.95432 | 2109468.4994900003 | 37.7727490237764 | -122.409651855072 | (37.7727490237764, -122.409651855072) | ||||
| 75001 | 75001 | 222170 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 524 28th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | 6002478.0142 | 2099479.37016 | 37.7449106474076 | -122.434119733363 | (37.7449106474076, -122.434119733363) | ||||
| 76084 | 76084 | 245577 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2211 Castro St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 29 | 6002723.765319999 | 2099062.4015200003 | 37.743779693292204 | -122.43324018380301 | (37.7437796932922, -122.433240183803) | ||||
| 80863 | 80863 | 106175 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
| 81590 | 81590 | 114681 | Undocumented 2 | Ficus Spp. :: 253 | 235 GEARY ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6010571.0 | 2114715.0 | 37.7872002104764 | -122.407209329428 | (37.7872002104764, -122.407209329428) | |||||
| 82411 | 82411 | 107622 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 191 HAIGHT ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | 6005238.1 | 2109520.1 | 37.7726363924224 | -122.425290219951 | (37.7726363924224, -122.425290219951) | ||||
| 83678 | 83678 | 99998 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501X Mission St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/26/2012 12:00:00 AM | Permit Number 768978 | 6013420.0 | 2115433.0 | 37.7893307029327 | -122.397402707509 | (37.7893307029327, -122.397402707509) | |||
| 83806 | 83806 | 111767 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 4966 17th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5997580.2349427 | 2105651.04183436 | 37.761577335837295 | -122.45150033551 | (37.7615773358373, -122.45150033551) | |||||
| 86115 | 86115 | 205683 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 134 Lomita Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | 5991416.24805 | 2104429.61687 | 37.7578687206724 | -122.47272977815399 | (37.7578687206724, -122.472729778154) | ||||
| 87230 | 87230 | 106179 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
| 90332 | 90332 | 100684 | Undocumented 2 | Tree(s) :: 17 | 400 California St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6012367.0 | 2116823.0 | 37.7930886299645 | -122.40114369902099 | (37.7930886299645, -122.401143699021) | |||||
| 90472 | 90472 | 120871 | Undocumented 2 | Shrub :: Shrub 98 | 1387 08th Ave | 1 | Sidewalk: Curb side : Pot 10 | Landscaping 2 | Private 1 | 5993606.0 | 2106068.0 | 37.762493810072606 | -122.465275766733 | (37.7624938100726, -122.465275766733) | |||||
| 92565 | 92565 | 116410 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 600x GRANT AVE | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6011037.0 | 2116673.0 | 37.7926024798136 | -122.405735030164 | (37.7926024798136, -122.405735030164) | |||||
| 94785 | 94785 | 100008 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501X Mission St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/26/2012 12:00:00 AM | Permit Number 768978 | 6013380.8 | 2115570.5 | 37.789706063197606 | -122.39754798333901 | (37.7897060631976, -122.397547983339) | |||
| 95159 | 95159 | 96547 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100@ Front St Pine St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
| 96623 | 96623 | 106177 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
| 97394 | 97394 | 58598 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 4966 17th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 04/19/1979 12:00:00 AM | Permit Number 17804 | 5997580.2349427 | 2105651.04183436 | 37.761577335837295 | -122.45150033551 | (37.7615773358373, -122.45150033551) | |||
| 98016 | 98016 | 93915 | Permitted Site 1 | Tree(s) :: 17 | 1131 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 04/26/2010 12:00:00 AM | Permit Number 53385 | 6006791.4 | 2114889.1 | 37.7874659967155 | -122.42029831720501 | (37.7874659967155, -122.420298317205) | |||
| 98713 | 98713 | 100010 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 501X Mission St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 768978 | 6013380.8 | 2115570.5 | 37.789706063197606 | -122.39754798333901 | (37.7897060631976, -122.397547983339) | ||||
| 98842 | 98842 | 106181 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
| 99533 | 99533 | 100242 | Private 5 | Tree(s) :: 17 | 76 Linda St | Sidewalk: Curb side : Pot 10 | Landscaping 2 | Private 1 | 6005815.0 | 2105046.0 | 37.76038415245 | -122.422976606568 | (37.76038415245, -122.422976606568) | ||||||
| 101067 | 101067 | 106178 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
| 104278 | 104278 | 117387 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1601 POLK ST | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6006595.0 | 2116425.0 | 37.791672128860505 | -122.42108692021401 | (37.7916721288605, -122.421086920214) | |||||
| 104345 | 104345 | 106180 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
| 104559 | 104559 | 114737 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 455x LILY ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW for City Agency 10 | DPW 4 | 6004484.0 | 2109981.0 | 37.77385927942 | -122.427931581119 | (37.77385927942, -122.427931581119) | ||||
| 104672 | 104672 | 64402 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 777 Stockton St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 05/14/1988 12:00:00 AM | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.792705858273294 | -122.407682697096 | (37.7927058582733, -122.407682697096) | ||
| 104752 | 104752 | 116408 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 600x GRANT AVE | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6011037.0 | 2116673.0 | 37.7926024798136 | -122.405735030164 | (37.7926024798136, -122.405735030164) | |||||
| 106682 | 106682 | 96543 | Permitted Site 1 | Tree(s) :: 17 | 100 Pine St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
| 107020 | 107020 | 116412 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 600x GRANT AVE | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6011037.0 | 2116673.0 | 37.7926024798136 | -122.405735030164 | (37.7926024798136, -122.405735030164) | |||||
| 108949 | 108949 | 117383 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1601 POLK ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6006595.0 | 2116425.0 | 37.791672128860505 | -122.42108692021401 | (37.7916721288605, -122.421086920214) | |||||
| 110127 | 110127 | 96546 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100@ Front St Pine St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
| 110892 | 110892 | 96548 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100@ Front St Pine St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
| 111306 | 111306 | 52287 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 72 Valley St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 03/04/2011 12:00:00 AM | Permit Number 54678 | 6005433.61319764 | 2099357.0668783 | 37.7447421315969 | -122.42389111052499 | (37.7447421315969, -122.423891110525) | |||
| 113644 | 113644 | 117385 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1601 POLK ST | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6006595.0 | 2116425.0 | 37.791672128860505 | -122.42108692021401 | (37.7916721288605, -122.421086920214) | |||||
| 117100 | 117100 | 117384 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1601 POLK ST | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6006595.0 | 2116425.0 | 37.791672128860505 | -122.42108692021401 | (37.7916721288605, -122.421086920214) | |||||
| 119725 | 119725 | 117382 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1601 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6006595.0 | 2116425.0 | 37.791672128860505 | -122.42108692021401 | (37.7916721288605, -122.421086920214) | |||||
| 121082 | 121082 | 223287 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1847 Castro St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | 6002650.76741 | 2100087.2842900003 | 37.74658964030979 | -122.43356582202499 | (37.7465896403098, -122.433565822025) | ||||
| 121768 | 121768 | 93914 | Permitted Site 1 | Tree(s) :: 17 | 1131 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 04/26/2010 12:00:00 AM | Permit Number 53385 | 6006791.4 | 2114889.1 | 37.7874659967155 | -122.42029831720501 | (37.7874659967155, -122.420298317205) | |||
| 124131 | 124131 | 114682 | Undocumented 2 | Ficus Spp. :: 253 | 235 GEARY ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6010571.0 | 2114715.0 | 37.7872002104764 | -122.407209329428 | (37.7872002104764, -122.407209329428) | |||||
| 124691 | 124691 | 100003 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501X Mission St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/26/2012 12:00:00 AM | Permit Number 768978 | 6013380.8 | 2115570.5 | 37.789706063197606 | -122.39754798333901 | (37.7897060631976, -122.397547983339) | |||
| 125867 | 125867 | 106176 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
| 127048 | 127048 | 103773 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1288 Polk St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 6006856.2 | 2115250.5 | 37.7884619632914 | -122.420099779635 | (37.7884619632914, -122.420099779635) | |||
| 127063 | 127063 | 101446 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 777 Stockton St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.792705858273294 | -122.407682697096 | (37.7927058582733, -122.407682697096) | ||||
| 128024 | 128024 | 116409 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 600x GRANT AVE | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6011037.0 | 2116673.0 | 37.7926024798136 | -122.405735030164 | (37.7926024798136, -122.405735030164) | |||||
| 128958 | 128958 | 100007 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501X Mission St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/26/2012 12:00:00 AM | Permit Number 768978 | 6013380.8 | 2115570.5 | 37.789706063197606 | -122.39754798333901 | (37.7897060631976, -122.397547983339) | |||
| 129101 | 129101 | 106174 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
| 129253 | 129253 | 111768 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 4966 17th St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5997580.2349427 | 2105651.04183436 | 37.761577335837295 | -122.45150033551 | (37.7615773358373, -122.45150033551) | |||||
| 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) | ||||
| 130638 | 130638 | 222519 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 793 27th St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 6001410.303590001 | 2099959.16929 | 37.7461674068134 | -122.437846031097 | (37.7461674068134, -122.437846031097) | ||||
| 132434 | 132434 | 197513 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | 6009803.31754 | 2109510.05508 | 37.7728656676608 | -122.409497871353 | (37.7728656676608, -122.409497871353) | ||||
| 132666 | 132666 | 222988 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 502 28th St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | 6002598.0607 | 2099487.20989 | 37.7449389859493 | -122.433705195344 | (37.7449389859493, -122.433705195344) | ||||
| 133500 | 133500 | 222726 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 99 Elsie St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | 6007291.44171 | 2098736.64268 | 37.743143293435395 | -122.41742311988999 | (37.7431432934354, -122.41742311989) | ||||
| 133529 | 133529 | 222986 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 502 28th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 21 | 6002638.36895 | 2099488.8163799997 | 37.7449456841067 | -122.43356593172399 | (37.7449456841067, -122.433565931724) | ||||
| 135093 | 135093 | 222518 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 793 27th St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | 6001409.25224 | 2099957.5688 | 37.746162952463 | -122.43784955191201 | (37.746162952463, -122.437849551912) |
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");