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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 171922 | 171922 | 199909 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1335 Shafter Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 0ft | 6016305.1286 | 2093102.5016 | 37.7281761084423 | -122.385863268846 | (37.7281761084423, -122.385863268846) | |||
| 37713 | 37713 | 192997 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1856 Illinois St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 6ft | 6016261.5851 | 2100510.3314 | 37.748514099551 | -122.38653011709499 | (37.748514099551, -122.386530117095) | |||
| 131227 | 131227 | 199694 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1350 Underwood Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 0ft | 6015915.704 | 2092772.4292 | 37.727248236967704 | -122.38718652280701 | (37.7272482369677, -122.387186522807) | |||
| 173265 | 173265 | 196276 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1514 Innes Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6015988.30327 | 2096906.1918 | 37.738602740517294 | -122.38722376507499 | (37.7386027405173, -122.387223765075) | |||
| 160816 | 160816 | 199695 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 1350 Underwood Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 6015882.1777 | 2092801.0091 | 37.7273248550401 | -122.387304416847 | (37.7273248550401, -122.387304416847) | |||
| 179611 | 179611 | 199418 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 600 Illinois St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6015946.150769999 | 2106178.35791 | 37.7640598335051 | -122.388016366372 | (37.7640598335051, -122.388016366372) | |||
| 73445 | 73445 | 187968 | Undocumented 2 | Ailanthus altissima :: Tree Of Heaven 401 | 600 Illinois St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 6015942.9159 | 2106228.0728700003 | 37.764196160851796 | -122.388031024433 | (37.7641961608518, -122.388031024433) | |||
| 170492 | 170492 | 192800 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 600 Illinois St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6015940.7807599995 | 2106258.15422 | 37.7642786394618 | -122.388040508659 | (37.7642786394618, -122.388040508659) | |||
| 49342 | 49342 | 188108 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 211 Terry A Francois Blvd | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 6015796.42981 | 2110627.97034 | 37.77626919959339 | -122.388844874016 | (37.7762691995934, -122.388844874016) | |||
| 165208 | 165208 | 188107 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 211 Terry A Francois Blvd | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 6015791.03065 | 2110625.94515 | 37.7762633396153 | -122.38886340994101 | (37.7762633396153, -122.388863409941) | |||
| 179333 | 179333 | 199803 | Undocumented 2 | Acer macrophyllum :: Big Leaf Maple 159 | 1330 Donner Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 6015357.8938 | 2090741.5774 | 37.72164101353 | -122.38897315707199 | (37.72164101353, -122.388973157072) | |||
| 70236 | 70236 | 187966 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 211 Terry A Francois Blvd | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 6015666.2407 | 2110622.1949 | 37.7762461247865 | -122.38929483449499 | (37.7762461247865, -122.389294834495) | |||
| 134131 | 134131 | 187965 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 211 Terry A Francois Blvd | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 5ft | 6015662.09524 | 2110622.5452099997 | 37.776246856837794 | -122.38930919937 | (37.7762468568378, -122.38930919937) | |||
| 67352 | 67352 | 187964 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 211 Terry A Francois Blvd | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 6015658.44742 | 2110621.01823 | 37.776242461855205 | -122.38932171163401 | (37.7762424618552, -122.389321711634) | |||
| 153812 | 153812 | 199521 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1112 Tennessee St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 58 | Width 6ft | 6015518.58105 | 2103812.19357 | 37.7575391569355 | -122.389329974622 | (37.7575391569355, -122.389329974622) | |||
| 186559 | 186559 | 197486 | Undocumented 2 | Schinus molle :: California Pepper 138 | 1112 Tennessee St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 19 | Width 6ft | 6015516.35006 | 2103817.5314599997 | 37.757553689956104 | -122.389338063096 | (37.7575536899561, -122.389338063096) | |||
| 176309 | 176309 | 190907 | Undocumented 2 | Cotinus coggygria 'Royal Purple' :: Smoke tree 298 | 901 24th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 5ft | 6015410.61611 | 2102532.4645 | 37.754019306672 | -122.38961398771299 | (37.754019306672, -122.389613987713) | |||
| 180410 | 180410 | 199528 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 695 Minnesota St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 2ft | 6015204.40478 | 2105547.51975 | 37.7622865664905 | -122.390537786585 | (37.7622865664905, -122.390537786585) | |||
| 179677 | 179677 | 189662 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1177 Indiana St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 4ft | 6015057.63998 | 2103157.3463 | 37.7557155206704 | -122.390878342778 | (37.7557155206704, -122.390878342778) | |||
| 171505 | 171505 | 189663 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1177 Indiana St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 4ft | 6015055.47575 | 2103171.59722 | 37.7557545305733 | -122.39088682336799 | (37.7557545305733, -122.390886823368) | |||
| 35731 | 35731 | 200325 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 301 Main St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 6ft | 6015214.59398 | 2115265.69066 | 37.788971064105795 | -122.391181870273 | (37.7889710641058, -122.391181870273) | |||
| 60170 | 60170 | 200326 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 301 Main St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 6ft | 6015205.462169999 | 2115275.8226400004 | 37.7889983774274 | -122.39121417389799 | (37.7889983774274, -122.391214173898) | |||
| 174721 | 174721 | 200327 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 301 Main St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 6ft | 6015192.2800199995 | 2115287.61911 | 37.78903003626721 | -122.391260607709 | (37.7890300362672, -122.391260607709) | |||
| 175864 | 175864 | 200451 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1000 Indiana St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 8ft | 6014956.18254 | 2103836.3549900004 | 37.757574303320204 | -122.391276680392 | (37.7575743033202, -122.391276680392) | |||
| 182544 | 182544 | 200450 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1000 Indiana St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 8ft | 6014955.45065 | 2103853.5745099997 | 37.7576215438129 | -122.391280415259 | (37.7576215438129, -122.391280415259) | |||
| 133816 | 133816 | 200328 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 301 Main St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 6ft | 6015179.92906 | 2115301.4953 | 37.789067451651604 | -122.39130431116502 | (37.7890674516516, -122.391304311165) | |||
| 179530 | 179530 | 200329 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 301 Main St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 6ft | 6015119.86302 | 2115363.24254 | 37.789233661647394 | -122.391516452246 | (37.7892336616474, -122.391516452246) | |||
| 154889 | 154889 | 199527 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 601 18th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 2ft | 6014914.45801 | 2105734.69881 | 37.76278443028121 | -122.391553698568 | (37.7627844302812, -122.391553698568) | |||
| 158144 | 158144 | 200330 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 301 Main St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 6ft | 6015108.79029 | 2115375.2587599996 | 37.7892660408344 | -122.391555603302 | (37.7892660408344, -122.391555603302) | |||
| 176832 | 176832 | 200331 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 301 Main St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 6ft | 6015095.90294 | 2115388.62146 | 37.7893020164091 | -122.391601126991 | (37.7893020164091, -122.391601126991) | |||
| 71337 | 71337 | 190343 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014833.65153 | 2116067.9736900004 | 37.7911528005014 | -122.39255603344499 | (37.7911528005014, -122.392556033445) | |||
| 23717 | 23717 | 190342 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014826.26604 | 2116061.6193 | 37.7911349426626 | -122.39258114252199 | (37.7911349426626, -122.392581142522) | |||
| 147364 | 147364 | 190341 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014814.94374 | 2116051.9719599998 | 37.7911078245033 | -122.39261964247801 | (37.7911078245033, -122.392619642478) | |||
| 186228 | 186228 | 190340 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014805.5019 | 2116039.63688 | 37.791073430855796 | -122.392651447929 | (37.7910734308558, -122.392651447929) | |||
| 158095 | 158095 | 190339 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014796.07981 | 2116028.26498 | 37.791041682965606 | -122.39268325242399 | (37.7910416829656, -122.392683252424) | |||
| 158248 | 158248 | 190338 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014779.60174 | 2116014.8679 | 37.7910039825033 | -122.39273932876999 | (37.7910039825033, -122.39273932877) | |||
| 120061 | 120061 | 190337 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014767.49042 | 2116002.10502 | 37.790968265916796 | -122.392780340547 | (37.7909682659168, -122.392780340547) | |||
| 167512 | 167512 | 190336 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014755.210530001 | 2115992.9592 | 37.7909424715624 | -122.392822188693 | (37.7909424715624, -122.392822188693) | |||
| 51822 | 51822 | 195451 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 400 The Embarcadero | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 5ft | 6014767.70739 | 2117048.87622 | 37.793842468603 | -122.392852854701 | (37.793842468603, -122.392852854701) | |||
| 169534 | 169534 | 190335 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014743.61218 | 2115981.63102 | 37.790910722793 | -122.392861525945 | (37.790910722793, -122.392861525945) | |||
| 59798 | 59798 | 195450 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 400 The Embarcadero | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 5ft | 6014751.24936 | 2117067.54594 | 37.793892817153704 | -122.392911108287 | (37.7938928171537, -122.392911108287) | |||
| 136809 | 136809 | 190334 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 103 Howard St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014720.686319999 | 2115960.41525 | 37.7908511957851 | -122.392939364079 | (37.7908511957851, -122.392939364079) | |||
| 31275 | 31275 | 195449 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 400 The Embarcadero | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 5ft | 6014736.842019999 | 2117083.55492 | 37.7939359738125 | -122.392962080059 | (37.7939359738125, -122.392962080059) | |||
| 60722 | 60722 | 190333 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 103 Howard St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014709.52276 | 2115946.6699599996 | 37.790812834303004 | -122.39297702767999 | (37.790812834303, -122.39297702768) | |||
| 175023 | 175023 | 190332 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 103 Howard St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014699.62681 | 2115935.78915 | 37.790782408421 | -122.393010505845 | (37.790782408421, -122.393010505845) | |||
| 74677 | 74677 | 195448 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 400 The Embarcadero | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 5ft | 6014719.29527 | 2117100.4128400004 | 37.793981287051295 | -122.393023974076 | (37.7939812870513, -122.393023974076) | |||
| 66053 | 66053 | 190331 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 103 Howard St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014689.7306 | 2115924.90869 | 37.790751983476 | -122.393043984906 | (37.790751983476, -122.393043984906) | |||
| 40643 | 40643 | 195447 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 400 The Embarcadero | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 6014706.202819999 | 2117116.39491 | 37.794024442814106 | -122.393070394401 | (37.7940244428141, -122.393070394401) | |||
| 163098 | 163098 | 190330 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 103 Howard St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014677.9098 | 2115914.54896 | 37.7907228814138 | -122.39308415942499 | (37.7907228814138, -122.393084159425) | |||
| 70352 | 70352 | 190329 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 103 Howard St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014667.05629 | 2115904.1696599997 | 37.7906937793375 | -122.39312098574301 | (37.7906937793375, -122.393120985743) | |||
| 58740 | 58740 | 195446 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 400 The Embarcadero | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 5ft | 6014688.3614 | 2117131.68733 | 37.794065441128 | -122.393133198563 | (37.794065441128, -122.393133198563) | |||
| 121089 | 121089 | 190328 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 103 Howard St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014652.968859999 | 2115892.30233 | 37.7906604118109 | -122.393168897143 | (37.7906604118109, -122.393168897143) | |||
| 53520 | 53520 | 196107 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 559 Pennsylvania Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6014419.73249 | 2104517.48217 | 37.759414745219296 | -122.39317961614799 | (37.7594147452193, -122.393179616148) | |||
| 40900 | 40900 | 196108 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 553 Pennsylvania Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6014419.65969 | 2104542.9303 | 37.759484616234104 | -122.393181648629 | (37.7594846162341, -122.393181648629) | |||
| 186167 | 186167 | 195445 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 400 The Embarcadero | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 5ft | 6014671.32996 | 2117148.01113 | 37.79410931633421 | -122.393193272358 | (37.7941093163342, -122.393193272358) | |||
| 130860 | 130860 | 190785 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 566 Pennsylvania Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6014353.501540001 | 2104489.0568 | 37.7593330157277 | -122.393406687779 | (37.7593330157277, -122.393406687779) | |||
| 61274 | 61274 | 197334 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1098 Mississippi St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 5ft | 6014199.99182 | 2102083.0983599997 | 37.7527182412529 | -122.39376919728501 | (37.7527182412529, -122.393769197285) | |||
| 48645 | 48645 | 196360 | Undocumented 2 | Prunus persica :: Peach 330 | 1098 Mississippi St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 6014197.98434 | 2102073.23717 | 37.7526910529733 | -122.39377544938499 | (37.7526910529733, -122.393775449385) | |||
| 44046 | 44046 | 197976 | Undocumented 2 | Torreya californica :: California nutmeg 409 | 1098 Mississippi St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 5ft | 6014198.12012 | 2102094.83849 | 37.7527503731308 | -122.393776491693 | (37.7527503731308, -122.393776491693) | |||
| 82217 | 82217 | 93894 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 88742 | 88742 | 93897 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 11 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 98599 | 98599 | 93896 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 10 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 99800 | 99800 | 93888 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 99815 | 99815 | 93895 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 107198 | 107198 | 93898 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 12 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 107881 | 107881 | 93889 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 109802 | 109802 | 93893 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 122175 | 122175 | 93892 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 127599 | 127599 | 93891 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 138268 | 138268 | 93890 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 72956 | 72956 | 194740 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 407 Mississippi St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6014090.52172 | 2105188.8947400004 | 37.761240003849394 | -122.39436520770201 | (37.7612400038494, -122.394365207702) | |||
| 55795 | 55795 | 189170 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 360 Texas St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 6013732.7365 | 2105419.1930299997 | 37.761852457439495 | -122.395618779897 | (37.7618524574395, -122.395618779897) | |||
| 68990 | 68990 | 190712 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 204 Texas St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 3ft | 6013703.78505 | 2106091.36578 | 37.763696485831204 | -122.395766012395 | (37.7636964858312, -122.395766012395) | |||
| 161934 | 161934 | 196371 | Undocumented 2 | Prunus spp :: Cherry 84 | 1797 Bancroft Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 1ft | 6013429.501019999 | 2092789.94242 | 37.7271583305791 | -122.395782600389 | (37.7271583305791, -122.395782600389) | |||
| 30394 | 30394 | 196366 | Undocumented 2 | Prunus persica :: Peach 330 | 1797 Bancroft Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 1ft | 6013425.402509999 | 2092793.8234599999 | 37.7271687591255 | -122.395797040827 | (37.7271687591255, -122.395797040827) | |||
| 29131 | 29131 | 194397 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 1797 Bancroft Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 1ft | 6013420.92243 | 2092796.80792 | 37.7271767046165 | -122.39581273756501 | (37.7271767046165, -122.395812737565) | |||
| 24682 | 24682 | 203198 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 91 Market St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 10ft | 6013828.57328 | 2116873.69458 | 37.7933092533841 | -122.39609008760401 | (37.7933092533841, -122.396090087604) | |||
| 161827 | 161827 | 203197 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 91 Market St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 10ft | 6013808.49559 | 2116854.49545 | 37.7932554199655 | -122.39615821213499 | (37.7932554199655, -122.396158212135) | |||
| 165364 | 165364 | 203196 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 91 Market St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 10ft | 6013792.252169999 | 2116838.17263 | 37.7932096975269 | -122.39621327133301 | (37.7932096975269, -122.396213271333) | |||
| 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) | ||||
| 178442 | 178442 | 199604 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 630 Missouri St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | 6013529.78506 | 2104152.57114 | 37.758363299237104 | -122.39623193765699 | (37.7583632992371, -122.396231937657) | ||||
| 148175 | 148175 | 199603 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 628 Missouri St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 24 | 6013523.6449 | 2104171.29494 | 37.7584143690574 | -122.39625448547501 | (37.7584143690574, -122.396254485475) | ||||
| 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) | ||||
| 167574 | 167574 | 196603 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 618 Missouri St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6013523.1670699995 | 2104217.2762 | 37.7585405969979 | -122.39625936070101 | (37.7585405969979, -122.396259360701) | |||
| 69150 | 69150 | 194582 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 618 Missouri St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6013519.11255 | 2104217.1828099997 | 37.7585401149596 | -122.39627337661001 | (37.7585401149596, -122.39627337661) | |||
| 31988 | 31988 | 194601 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 560 Missouri St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 22 | Width 2ft | 6013524.119940001 | 2104470.94675 | 37.7592371740688 | -122.396273844275 | (37.7592371740688, -122.396273844275) | |||
| 33874 | 33874 | 196602 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 608 Missouri St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6013520.1448 | 2104276.81958 | 37.758703921979794 | -122.396273986373 | (37.7587039219798, -122.396273986373) | |||
| 47775 | 47775 | 194581 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 608 Missouri St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6013516.07962 | 2104276.2000599997 | 37.758701994708204 | -122.396288002304 | (37.7587019947082, -122.396288002304) | |||
| 71563 | 71563 | 196601 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 598 Missouri St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 6013516.47989 | 2104326.37457 | 37.7588397852535 | -122.39629013460501 | (37.7588397852535, -122.396290134605) | |||
| 65406 | 65406 | 194579 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 588 Missouri St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6013514.83137 | 2104327.6362099997 | 37.7588431577105 | -122.396295924418 | (37.7588431577105, -122.396295924418) | |||
| 23754 | 23754 | 194580 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 598 Missouri St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6013513.20546 | 2104325.65158 | 37.758837617875294 | -122.39630140851001 | (37.7588376178753, -122.39630140851) | |||
| 150668 | 150668 | 197019 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 586 Missouri St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6013514.03834 | 2104373.90914 | 37.7589701689629 | -122.39630191030399 | (37.7589701689629, -122.396301910304) | |||
| 154086 | 154086 | 194600 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 560 Missouri St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 2ft | 6013514.76966 | 2104470.05867 | 37.7592342153015 | -122.396306120039 | (37.7592342153015, -122.396306120039) | |||
| 168962 | 168962 | 194577 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 580 Missouri St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 4ft | 6013511.640380001 | 2104375.7087 | 37.7589749767275 | -122.396310329764 | (37.7589749767275, -122.396310329764) | |||
| 48737 | 48737 | 194578 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 586 Missouri St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6013510.77458 | 2104373.03233 | 37.7589675798212 | -122.39631313654499 | (37.7589675798212, -122.396313136545) | |||
| 134493 | 134493 | 194575 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 568 Missouri St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6013510.83994 | 2104426.47875 | 37.759114335674894 | -122.396316656512 | (37.7591143356749, -122.396316656512) | |||
| 25630 | 25630 | 194576 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 572 Missouri St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6013508.15849 | 2104424.13067 | 37.7591077391483 | -122.396325765734 | (37.7591077391483, -122.396325765734) | |||
| 59662 | 59662 | 194599 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 560 Missouri St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 2ft | 6013504.76514 | 2104470.26142 | 37.7592342153007 | -122.396340734951 | (37.7592342153007, -122.396340734951) | |||
| 163958 | 163958 | 187986 | Undocumented 2 | Alnus rhombifolia :: White Alder 204 | 170 Hawthorne St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 6ft | 6013571.47207 | 2113396.1937599997 | 37.7837465372026 | -122.39673578012699 | (37.7837465372026, -122.396735780127) | |||
| 164452 | 164452 | 187985 | Undocumented 2 | Alnus rhombifolia :: White Alder 204 | 170 Hawthorne St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 6ft | 6013558.69971 | 2113403.3796 | 37.783765556978395 | -122.396780471936 | (37.7837655569784, -122.396780471936) |
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");