Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 79586 | 79586 | 94645 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 30 Middle Point Rd | 34 | : 4 | Tree 1 | Private 1 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||||
| 113544 | 113544 | 94646 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 30 Middle Point Rd | 35 | : 4 | Tree 1 | Private 1 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||||
| 140036 | 140036 | 105148 | Permitted Site 1 | Tree(s) :: 17 | 185 Stratford Dr | : 4 | Tree 1 | Private 1 | 12/26/2013 12:00:00 AM | Permit Number 770387 | 5990916.9 | 2091282.3 | 37.7217406386467 | -122.473497746062 | (37.7217406386467, -122.473497746062) | ||||
| 145389 | 145389 | 94463 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 744 Carolina St | 1 | : 4 | Tree 1 | Private 1 | 06/10/2010 12:00:00 AM | Permit Number 53681 | 6012327.5 | 2104524.9 | 37.759318660176504 | -122.40041614875601 | (37.7593186601765, -122.400416148756) | |||
| 31579 | 31579 | 198708 | Undocumented 2 | Ulmus spp :: Elm Spp 215 | 1601 Bay Shore Blvd | 4 | : 4 | Tree 1 | Private 1 | 0 | Width 3ft | 6012024.53747 | 2091412.02554 | 37.723296594957 | -122.40054282438999 | (37.723296594957, -122.40054282439) | |||
| 33965 | 33965 | 196585 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1295 Harrison St | 2 | : 4 | Tree 1 | Private 1 | 0 | Width 3ft | 6009272.40874 | 2109874.5965 | 37.7738368509301 | -122.411360111888 | (37.7738368509301, -122.411360111888) | |||
| 72618 | 72618 | 199649 | Undocumented 2 | :: 54 | 1601 Evans Ave | 22 | : 4 | Tree 1 | Private 1 | 0 | Width 1ft | 6015107.35337 | 2098882.19142 | 37.7439796026678 | -122.390407721252 | (37.7439796026678, -122.390407721252) | |||
| 135877 | 135877 | 199650 | Undocumented 2 | :: 54 | 0 | 1 | : 4 | Tree 1 | Private 1 | 0 | Width 0ft | 6014963.58685 | 2093280.8179400002 | 37.728591398452394 | -122.390513521988 | (37.7285913984524, -122.390513521988) | |||
| 148375 | 148375 | 196586 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1295 Harrison St | 3 | : 4 | Tree 1 | Private 1 | 0 | Width 3ft | 6009287.47644 | 2109885.83253 | 37.7738685475242 | -122.411308783978 | (37.7738685475242, -122.411308783978) | |||
| 178220 | 178220 | 199651 | Undocumented 2 | :: 54 | 0 | 37 | : 4 | Tree 1 | Private 1 | 0 | Width 0ft | 6018297.01834 | 2097895.80454 | 37.7414476037323 | -122.37930996579901 | (37.7414476037323, -122.379309965799) | |||
| 1969 | 1969 | 198010 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 213 Clara St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | Permit Number 779305 | 6011863.46506 | 2111836.2655700003 | 37.7793681257663 | -122.40253514649099 | (37.7793681257663, -122.402535146491) | ||
| 24358 | 24358 | 211712 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 418 San Miguel St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5997865.28032 | 2089936.92549 | 37.7184464872957 | -122.449382239324 | (37.7184464872957, -122.449382239324) | |||
| 24374 | 24374 | 192945 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 238 11th St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6008246.27864 | 2109382.4071299997 | 37.7724278093356 | -122.41487483150401 | (37.7724278093356, -122.414874831504) | |||
| 24599 | 24599 | 225999 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 700 Duboce Ave | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6002335.19401 | 2108315.06979 | 37.7691632487104 | -122.435245457027 | (37.7691632487104, -122.435245457027) | |||
| 24622 | 24622 | 247221 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 187 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6001849.330080001 | 2108668.89946 | 37.770107174421796 | -122.436951364836 | (37.7701071744218, -122.436951364836) | |||
| 25659 | 25659 | 194764 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1101 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6014997.18752 | 2096468.24359 | 37.737345287747395 | -122.390620003515 | (37.7373452877474, -122.390620003515) | |||
| 25944 | 25944 | 233355 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 45 Clarendon Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5998067.992430001 | 2104637.9237599997 | 37.758823486839 | -122.449740378141 | (37.758823486839, -122.449740378141) | |||
| 26062 | 26062 | 247051 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 519 Valley St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6002519.90495 | 2099141.5459 | 37.743985438385295 | -122.43395073994499 | (37.7439854383853, -122.433950739945) | |||
| 26321 | 26321 | 247172 | Undocumented 2 | Malus :: Crab Apple 235 | 145 Buena Vista Ave East | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6001372.05344 | 2108496.3443400003 | 37.7696062421579 | -122.438589890015 | (37.7696062421579, -122.438589890015) | |||
| 27153 | 27153 | 197239 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 830 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6011827.26305 | 2104492.53285 | 37.7592018783746 | -122.40214394588999 | (37.7592018783746, -122.40214394589) | |||
| 27799 | 27799 | 208686 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 207 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5997054.6676199995 | 2089435.45045 | 37.7170231509855 | -122.45214801343201 | (37.7170231509855, -122.452148013432) | |||
| 28061 | 28061 | 250087 | Undocumented 2 | Acacia cognata :: River Wattle 249 | 1608 Bush St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 1ft | 6005770.74957 | 2115225.4613099997 | 37.7883319959812 | -122.423853491051 | (37.7883319959812, -122.423853491051) | |||
| 28080 | 28080 | 198006 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 238 Shipley St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011475.496280001 | 2111728.4985 | 37.7790505553711 | -122.403869715215 | (37.7790505553711, -122.403869715215) | |||
| 28254 | 28254 | 235714 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 575 Florida St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6009284.05083 | 2105508.94115 | 37.761850423188704 | -122.41101142226499 | (37.7618504231887, -122.411011422265) | |||
| 28441 | 28441 | 189265 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203 Newcomb Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011972.28331 | 2098093.92114 | 37.7416407727111 | -122.40119276536001 | (37.7416407727111, -122.40119276536) | |||
| 28661 | 28661 | 189257 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2231 Newcomb Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011833.55798 | 2098197.58892 | 37.7419176820557 | -122.40167971856 | (37.7419176820557, -122.40167971856) | |||
| 28700 | 28700 | 189264 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2207 Newcomb Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011951.89121 | 2098108.4509400004 | 37.741679530779294 | -122.401264295606 | (37.7416795307793, -122.401264295606) | |||
| 28877 | 28877 | 188060 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1241 Evans Ave | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6017512.496169999 | 2097088.9484700002 | 37.7391888439962 | -122.381966489387 | (37.7391888439962, -122.381966489387) | |||
| 29741 | 29741 | 196461 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 615 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6014144.28645 | 2104277.08263 | 37.7587393543665 | -122.39411542098999 | (37.7587393543665, -122.39411542099) | |||
| 29757 | 29757 | 198021 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 217 Clara St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011882.31824 | 2111817.0211 | 37.7793163374183 | -122.40246857147699 | (37.7793163374183, -122.402468571477) | |||
| 30043 | 30043 | 193801 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 776 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012701.04475 | 2103917.58098 | 37.7576719193319 | -122.39908161224899 | (37.7576719193319, -122.399081612249) | |||
| 30296 | 30296 | 202045 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 41 Exeter St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012584.35783 | 2091031.2434099999 | 37.7222822496095 | -122.39858091108201 | (37.7222822496095, -122.398580911082) | |||
| 30636 | 30636 | 193062 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1601 Evans Ave | 12 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6014912.025280001 | 2099027.7617599997 | 37.7443684713257 | -122.391093299634 | (37.7443684713257, -122.391093299634) | |||
| 31159 | 31159 | 242866 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 98 McCoppin St | 5 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6006095.439119999 | 2109158.70233 | 37.7716924795429 | -122.422298906788 | (37.7716924795429, -122.422298906788) | |||
| 31173 | 31173 | 225996 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 47 Octavia St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6005638.67194 | 2109514.80428 | 37.7726444739859 | -122.423904220905 | (37.7726444739859, -122.423904220905) | |||
| 31788 | 31788 | 241075 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 158 Tiffany Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 1ft | 6006085.09407 | 2099316.84572 | 37.74466845098979 | -122.421635555133 | (37.7446684509898, -122.421635555133) | |||
| 32400 | 32400 | 192428 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 480 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6014110.58587 | 2112833.82618 | 37.782232395453796 | -122.39483123728 | (37.7822323954538, -122.39483123728) | |||
| 32814 | 32814 | 214424 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 732 Shields St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992045.199469999 | 2089870.8873400001 | 37.7179305201634 | -122.469494855606 | (37.7179305201634, -122.469494855606) | |||
| 32988 | 32988 | 196389 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013924.26567 | 2112893.70041 | 37.7823864349182 | -122.395480022606 | (37.7823864349182, -122.395480022606) | |||
| 33587 | 33587 | 198007 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 274 Shipley St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6011297.08858 | 2111564.84003 | 37.7785912185545 | -122.404475379844 | (37.7785912185545, -122.404475379844) | |||
| 33767 | 33767 | 190391 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 571 Texas St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6013851.28196 | 2104449.17868 | 37.75919560292179 | -122.395140827087 | (37.7591956029218, -122.395140827087) | |||
| 33953 | 33953 | 247763 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 55 Alpine Ter | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6001651.1462 | 2108480.6901700003 | 37.769579132108205 | -122.43762339851101 | (37.7695791321082, -122.437623398511) | |||
| 34271 | 34271 | 196527 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 333 Texas St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013792.65149 | 2105531.32389 | 37.7621636768226 | -122.395419411895 | (37.7621636768226, -122.395419411895) | |||
| 35117 | 35117 | 190404 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 11 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012224.99422 | 2100912.98992 | 37.74939542707129 | -122.40051694820801 | (37.7493954270713, -122.400516948208) | |||
| 35195 | 35195 | 196310 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 928 Clara St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011726.41935 | 2111671.91567 | 37.778909207118204 | -122.402997684908 | (37.7789092071182, -122.402997684908) | |||
| 35416 | 35416 | 246955 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2101 15th St | 7 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6003442.97283 | 2107114.24236 | 37.765928914304794 | -122.43132798319401 | (37.7659289143048, -122.431327983194) | |||
| 35914 | 35914 | 196425 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 282 Shipley St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6011155.7597199995 | 2111427.64984 | 37.778206627062296 | -122.404954631245 | (37.7782066270623, -122.404954631245) | |||
| 36121 | 36121 | 189263 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2211 Newcomb Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011935.60653 | 2098120.24236 | 37.7417109989595 | -122.401321431357 | (37.7417109989595, -122.401321431357) | |||
| 36209 | 36209 | 190444 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1301 Evans Ave | 7 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017091.55638 | 2097401.29734 | 37.7400232358798 | -122.383443661803 | (37.7400232358798, -122.383443661803) | |||
| 36484 | 36484 | 207243 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 324 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5996808.75565 | 2089668.4523599998 | 37.7176488300194 | -122.453014817795 | (37.7176488300194, -122.453014817795) | |||
| 36521 | 36521 | 187478 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1888 Geneva Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6004785.02328 | 2086870.2631599999 | 37.710419493035104 | -122.425245442839 | (37.7104194930351, -122.425245442839) | |||
| 36650 | 36650 | 242863 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 98 McCoppin St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6006168.47171 | 2109163.73568 | 37.7717104192431 | -122.422046639762 | (37.7717104192431, -122.422046639762) | |||
| 36945 | 36945 | 250489 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 240 El Camino Del Mar | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5987807.77183 | 2115352.13466 | 37.7876493619664 | -122.48601098323499 | (37.7876493619664, -122.486010983235) | |||
| 37151 | 37151 | 208700 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 144 Eucalyptus Dr | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5990998.47136 | 2094705.0168400002 | 37.731143287718 | -122.473465306694 | (37.731143287718, -122.473465306694) | |||
| 37346 | 37346 | 190445 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1201 Evans Ave | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017686.12557 | 2096959.12409 | 37.738841959282205 | -122.381357125839 | (37.7388419592822, -122.381357125839) | |||
| 37647 | 37647 | 136662 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1307 Bay St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 1ft | 6004522.84241 | 2120815.90939 | 37.803611411885704 | -122.428569697738 | (37.8036114118857, -122.428569697738) | |||
| 37995 | 37995 | 228900 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Haight St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6006045.73511 | 2109652.55935 | 37.7730456885414 | -122.422505934299 | (37.7730456885414, -122.422505934299) | |||
| 38544 | 38544 | 189841 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017113.188630001 | 2098207.21128 | 37.742237308295294 | -122.38342495321899 | (37.7422373082953, -122.383424953219) | |||
| 38708 | 38708 | 228886 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 526 Hickory St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6004289.67474 | 2110317.5310299997 | 37.774772315811795 | -122.42862777776399 | (37.7747723158118, -122.428627777764) | |||
| 39264 | 39264 | 204069 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 161 Byxbee St | 8 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 5991925.79364 | 2089647.35065 | 37.7173098413624 | -122.469891319037 | (37.7173098413624, -122.469891319037) | |||
| 39356 | 39356 | 204071 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 161 Byxbee St | 10 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 5991926.528080001 | 2089611.9892799999 | 37.7172127901068 | -122.469886207299 | (37.7172127901068, -122.469886207299) | |||
| 39506 | 39506 | 198280 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 951 Phelps St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6014735.9327300005 | 2097232.0415 | 37.739428022289204 | -122.39157667443001 | (37.7394280222892, -122.39157667443) | |||
| 39757 | 39757 | 202047 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 55 Exeter St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012547.51313 | 2090916.47332 | 37.721965061416796 | -122.398700225048 | (37.7219650614168, -122.398700225048) | |||
| 39953 | 39953 | 246990 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 78 Clipper St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6004670.61163 | 2101066.74727 | 37.7493934152835 | -122.426651147943 | (37.7493934152835, -122.426651147943) | |||
| 40169 | 40169 | 211398 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 500 Junipero Serra Blvd | 57 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5991312.42459 | 2093316.55821 | 37.7273491037745 | -122.47227875018801 | (37.7273491037745, -122.472278750188) | |||
| 40355 | 40355 | 207621 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 259 Bright St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5993736.2843 | 2088924.46634 | 37.7154294623887 | -122.463580914754 | (37.7154294623887, -122.463580914754) | |||
| 40539 | 40539 | 189270 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 59 Robblee Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012477.87962 | 2095853.3507 | 37.735516831132 | -122.39928732315 | (37.735516831132, -122.39928732315) | |||
| 40590 | 40590 | 208699 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 144 Eucalyptus Dr | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5991017.2717699995 | 2094704.6203400001 | 37.731143287728706 | -122.473400282119 | (37.7311432877287, -122.473400282119) | |||
| 40809 | 40809 | 247807 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 500 30th St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6003285.4194 | 2098358.0891 | 37.7418776604327 | -122.431247854519 | (37.7418776604327, -122.431247854519) | |||
| 40822 | 40822 | 187972 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 75 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6013703.3858900005 | 2095554.5779799998 | 37.734764687625706 | -122.395029332752 | (37.7347646876257, -122.395029332752) | |||
| 40837 | 40837 | 220771 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 301 Webster St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6004135.7148 | 2109869.98632 | 37.7735347533659 | -122.429128439333 | (37.7735347533659, -122.429128439333) | |||
| 40843 | 40843 | 192425 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 187 Clara St | 6 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6011952.39777 | 2111919.37561 | 37.779601291212394 | -122.402233334018 | (37.7796012912124, -122.402233334018) | |||
| 41558 | 41558 | 205942 | Undocumented 2 | Cedrus atlantica :: Atlas Cedar 304 | 700 Junipero Serra Blvd | 41 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5991261.76371 | 2092534.5655 | 37.7251990144957 | -122.47239689950399 | (37.7251990144957, -122.472396899504) | |||
| 41885 | 41885 | 247192 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 98 Broderick St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6001382.446819999 | 2108930.15672 | 37.770797974263104 | -122.43858502738199 | (37.7707979742631, -122.438585027382) | |||
| 41931 | 41931 | 204135 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 114 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5991224.97526 | 2091857.93043 | 37.72333901327 | -122.47247476549299 | (37.72333901327, -122.472474765493) | |||
| 42115 | 42115 | 192437 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 106 Langton St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6010237.3697 | 2110691.53515 | 37.7761340485805 | -122.40807976548099 | (37.7761340485805, -122.408079765481) | |||
| 43246 | 43246 | 247776 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 228 30th St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6005091.07435 | 2098463.74529 | 37.7422699303121 | -122.425011997728 | (37.7422699303121, -122.425011997728) | |||
| 43525 | 43525 | 250638 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2609 Lake St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5987350.36914 | 2114602.8431 | 37.7855653557873 | -122.487538422371 | (37.7855653557873, -122.487538422371) | |||
| 43967 | 43967 | 221664 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 65 McCoppin St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6006280.59621 | 2109108.9089099998 | 37.771566201261294 | -122.421654898657 | (37.7715662012613, -122.421654898657) | |||
| 44312 | 44312 | 211400 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 500 Junipero Serra Blvd | 59 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5991311.81969 | 2093306.95297 | 37.727322695173605 | -122.472280141417 | (37.7273226951736, -122.472280141417) | |||
| 44650 | 44650 | 200395 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 460 Bryant St | 7 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6014040.62231 | 2112770.68821 | 37.782055142674 | -122.395068857958 | (37.782055142674, -122.395068857958) | |||
| 45125 | 45125 | 193342 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 401 Texas St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013812.69862 | 2105193.07398 | 37.7612360315304 | -122.39532637971901 | (37.7612360315304, -122.395326379719) | |||
| 45491 | 45491 | 198139 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 150 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013283.18276 | 2095780.0515 | 37.735360415658704 | -122.396497929253 | (37.7353604156587, -122.396497929253) | |||
| 45625 | 45625 | 211202 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 700 Junipero Serra Blvd | 146 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5991184.50895 | 2091529.2933900002 | 37.722434315083 | -122.472590699819 | (37.722434315083, -122.472590699819) | |||
| 47689 | 47689 | 189251 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 120 Loomis St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6010844.92077 | 2097998.29295 | 37.7413152397136 | -122.405084094075 | (37.7413152397136, -122.405084094075) | |||
| 47982 | 47982 | 212845 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 459 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5993232.298140001 | 2090226.8914 | 37.7189765558014 | -122.465417457153 | (37.7189765558014, -122.465417457153) | |||
| 48234 | 48234 | 196302 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 271 Shipley St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6011407.60626 | 2111629.45684 | 37.7787748169373 | -122.404097603449 | (37.7787748169373, -122.404097603449) | |||
| 48237 | 48237 | 205333 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 10 Caine Ave | 15 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5997549.343280001 | 2089570.2528799998 | 37.717421611803495 | -122.45044787838002 | (37.7174216118035, -122.45044787838) | |||
| 48713 | 48713 | 197355 | Undocumented 2 | Rhamnus californica :: Coffeeberry Tree 232 | 10 Cargo Way | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6018943.2735 | 2097519.21753 | 37.740449188069896 | -122.37704929319099 | (37.7404491880699, -122.377049293191) | |||
| 48966 | 48966 | 196545 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 938 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6011854.06587 | 2104027.62304 | 37.7579268348784 | -122.40201856510599 | (37.7579268348784, -122.402018565106) | |||
| 49055 | 49055 | 235713 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2828 18th St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6009324.87579 | 2105481.33415 | 37.7617769099015 | -122.410868274463 | (37.7617769099015, -122.410868274463) | |||
| 49434 | 49434 | 247805 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 488 30th St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6003450.91279 | 2098365.25645 | 37.741906717527705 | -122.43067614380199 | (37.7419067175277, -122.430676143802) | |||
| 50112 | 50112 | 250548 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 120 El Camino Del Mar | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 5988224.68514 | 2115371.29245 | 37.787726251325395 | -122.484569968025 | (37.7877262513254, -122.484569968025) | |||
| 50394 | 50394 | 190425 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 23 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017693.17965 | 2097070.35958 | 37.739147779140396 | -122.38134046861299 | (37.7391477791404, -122.381340468613) | |||
| 50519 | 50519 | 201808 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 247 Friedell St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6020927.8472 | 2093035.08257 | 37.7282457215548 | -122.369877496672 | (37.7282457215548, -122.369877496672) | |||
| 50600 | 50600 | 219079 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2674 Ocean Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5990725.25402 | 2095140.06488 | 37.7323219940584 | -122.474441593613 | (37.7323219940584, -122.474441593613) | |||
| 51469 | 51469 | 235709 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2800 18th St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6009468.56012 | 2105488.54947 | 37.7618047772022 | -122.41037183521601 | (37.7618047772022, -122.410371835216) | |||
| 51729 | 51729 | 176543 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 6 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992283.95996 | 2086838.07777 | 37.709616952417704 | -122.468449043003 | (37.7096169524177, -122.468449043003) | |||
| 52316 | 52316 | 190655 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 354 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012900.86657 | 2105367.98453 | 37.7616655423506 | -122.398492314369 | (37.7616655423506, -122.398492314369) | |||
| 53305 | 53305 | 208696 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 235 Bright St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5993735.7088 | 2088773.5229599997 | 37.7150149747485 | -122.46357195568399 | (37.7150149747485, -122.463571955684) |
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");