Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies ▲ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 91632 | 91632 | 87216 | Significant Tree 6 | Robinia x ambigua 'Idahoensis' :: Idaho Pink Locust 502 | 500 Cortland Ave | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50224 | 6007640.7 | 2097187.4 | 37.7389090609704 | -122.416105779709 | (37.7389090609704, -122.416105779709) | ||
| 101276 | 101276 | 62912 | Significant Tree 6 | Robinia x ambigua 'Idahoensis' :: Idaho Pink Locust 502 | 500 Cortland Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50224 | 6007523.90359428 | 2097218.90762974 | 37.7389890062486 | -122.416511839888 | (37.7389890062486, -122.416511839888) | ||
| 90919 | 90919 | 112420 | Significant Tree 6 | Picea Spp :: Spruce Spp 357 | 268 Lily St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/29/2015 12:00:00 AM | 3 | 6005334.87738 | 2110100.0463 | 37.7742342515583 | -122.42499672664302 | (37.7742342515583, -122.424996726643) | |||
| 119661 | 119661 | 112419 | Significant Tree 6 | Picea Spp :: Spruce Spp 357 | 268 Lily St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/29/2015 12:00:00 AM | 3 | 6005334.87738 | 2110100.0463 | 37.7742342515583 | -122.42499672664302 | (37.7742342515583, -122.424996726643) | |||
| 180684 | 180684 | 226835 | Undocumented 2 | Juglans regia :: Walnut: English 348 | 27 Poppy Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002073.33297 | 2096755.10087 | 37.7374074632877 | -122.43532421245199 | (37.7374074632877, -122.435324212452) | |||
| 68761 | 68761 | 220550 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 37 Poppy Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002449.94428 | 2096771.92833 | 37.737475048229705 | -122.43402329543801 | (37.7374750482297, -122.434023295438) | |||
| 72621 | 72621 | 220551 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 11 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 21 | Width 5ft | 6002176.285680001 | 2096385.2225400002 | 37.736397708979794 | -122.434941812622 | (37.7363977089798, -122.434941812622) | |||
| 81929 | 81929 | 98694 | Significant Tree 6 | Aesculus californica :: California Buckeye 338 | 191@Clarendon Forest Knolls Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 05/01/2012 12:00:00 AM | Permit Number 768674 | 5996330.9 | 2103059.9 | 37.754391095173794 | -122.455633951336 | (37.7543910951738, -122.455633951336) | |||
| 90443 | 90443 | 111748 | Landmark tree 9 | Aesculus californica :: California Buckeye 338 | 730 28th Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5987294.2 | 2110946.4 | 37.7755225253955 | -122.48746405921301 | (37.7755225253955, -122.487464059213) | |||||
| 140306 | 140306 | 98695 | Significant Tree 6 | Aesculus californica :: California Buckeye 338 | 191@Clarendon Forest Knolls Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 05/01/2012 12:00:00 AM | Permit Number 768674 | 5996330.9 | 2103059.9 | 37.754391095173794 | -122.455633951336 | (37.7543910951738, -122.455633951336) | |||
| 144229 | 144229 | 98696 | Significant Tree 6 | Aesculus californica :: California Buckeye 338 | 191@Clarendon Forest Knolls Dr | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 05/01/2012 12:00:00 AM | Permit Number 768674 | 5996330.9 | 2103059.9 | 37.754391095173794 | -122.455633951336 | (37.7543910951738, -122.455633951336) | |||
| 163239 | 163239 | 220552 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 13 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6002169.64489 | 2096371.31931 | 37.736359156858704 | -122.434963778568 | (37.7363591568587, -122.434963778568) | |||
| 32977 | 32977 | 219173 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 47 Ralston St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | 5992177.27741 | 2088252.3205900001 | 37.71349396036 | -122.46892060252199 | (37.71349396036, -122.468920602522) | ||||
| 172487 | 172487 | 219172 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 47 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | 5992175.93719 | 2088256.51499 | 37.7135053997375 | -122.46892553980601 | (37.7135053997375, -122.468925539806) | ||||
| 42552 | 42552 | 241129 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 163 Corwin St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6000604.9463 | 2104285.57219 | 37.758000835587396 | -122.440941163018 | (37.7580008355874, -122.440941163018) | |||
| 163775 | 163775 | 233337 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 251 Coso Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 6007732.48322 | 2099500.473 | 37.7452654065818 | -122.415952190562 | (37.7452654065818, -122.415952190562) | ||||
| 35110 | 35110 | 176590 | Undocumented 2 | Juglans nigra :: Eastern black walnut 288 | 4103 Alemany Blvd | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | Width 10ft | 5991596.71486 | 2086796.0596 | 37.7094618598487 | -122.470821200944 | (37.7094618598487, -122.470821200944) | |||
| 31427 | 31427 | 223996 | Undocumented 2 | Eucalyptus rudis :: Swamp Gum: Flooded Gum 287 | 100 Hwy 101 Southbound | 23 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | 6005945.0032 | 2108837.4935 | 37.770802030213105 | -122.42279644320699 | (37.7708020302131, -122.422796443207) | ||||
| 163352 | 163352 | 223998 | Undocumented 2 | Eucalyptus rudis :: Swamp Gum: Flooded Gum 287 | 100 Hwy 101 Southbound | 15 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | 6005894.41752 | 2108909.3321599998 | 37.770996427668 | -122.422976527055 | (37.770996427668, -122.422976527055) | ||||
| 163778 | 163778 | 223997 | Undocumented 2 | Eucalyptus rudis :: Swamp Gum: Flooded Gum 287 | 100 Hwy 101 Southbound | 16 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | 6005905.0919699995 | 2108895.1603 | 37.770958117464396 | -122.42293859636601 | (37.7709581174644, -122.422938596366) | ||||
| 50796 | 50796 | 225251 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 20 Ohlone Way | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 1 | Width 2ft | 6002182.75585 | 2096407.15248 | 37.736458290902796 | -122.43492101042 | (37.7364582909028, -122.43492101042) | |||
| 158375 | 158375 | 241152 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 3 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 3ft | 6002150.14382 | 2096511.4000799998 | 37.736742679035004 | -122.435041217385 | (37.736742679035, -122.435041217385) | |||
| 114652 | 114652 | 97162 | Property Tree 7 | Malus :: Crab Apple 235 | 478 10th Ave | Back Yard : Yard 13 | Tree 1 | Private 1 | Tree in backyard on private property; not significant. | 5992861.5 | 2112216.7 | 37.7793335349967 | -122.468298031686 | (37.7793335349967, -122.468298031686) | |||||
| 150424 | 150424 | 206446 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 53 Ralston St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 25 | 5992168.00552 | 2088268.19461 | 37.7135370108901 | -122.468953803676 | (37.7135370108901, -122.468953803676) | ||||
| 167246 | 167246 | 206445 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 53 Ralston St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 5992171.9093 | 2088272.93373 | 37.7135502489179 | -122.46894065561001 | (37.7135502489179, -122.46894065561) | ||||
| 186880 | 186880 | 206444 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 75 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | 5992169.96835 | 2088350.8654599998 | 37.71376411849379 | -122.46895303206301 | (37.7137641184938, -122.468953032063) | ||||
| 100775 | 100775 | 107342 | Significant Tree 6 | Prunus laurocerasus :: English laurel 227 | 110 JULIAN AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 100 | 6006340.8 | 2107214.1 | 37.7663669011591 | -122.421312071366 | (37.7663669011591, -122.421312071366) | ||||
| 25761 | 25761 | 217537 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 89 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | 5992163.635980001 | 2088434.33055 | 37.713992927605204 | -122.468980989298 | (37.7139929276052, -122.468980989298) | ||||
| 3835 | 3835 | 253567 | Private 5 | Salix spp :: Willow 218 | 25 Raycliff Ter | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6000333.0 | 2116919.0 | 37.792673532262505 | -122.44278881704399 | (37.7926735322625, -122.442788817044) | |||||
| 24893 | 24893 | 249803 | Undocumented 2 | Salix spp :: Willow 218 | 258 Chestnut St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 0ft | 6010797.8681 | 2121034.56269 | 37.8045648929076 | -122.406869977661 | (37.8045648929076, -122.406869977661) | |||
| 41112 | 41112 | 249802 | Undocumented 2 | Salix spp :: Willow 218 | 258 Chestnut St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6010800.51699 | 2121027.19165 | 37.804544802067795 | -122.40686029106399 | (37.8045448020678, -122.406860291064) | |||
| 46915 | 46915 | 249805 | Undocumented 2 | Salix spp :: Willow 218 | 258 Chestnut St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | Width 0ft | 6010790.25874 | 2121038.89871 | 37.8045763727666 | -122.40689661648099 | (37.8045763727666, -122.406896616481) | |||
| 59239 | 59239 | 249804 | Undocumented 2 | Salix spp :: Willow 218 | 258 Chestnut St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6010798.41124 | 2121026.88639 | 37.8045438460731 | -122.406867556714 | (37.8045438460731, -122.406867556714) | |||
| 74282 | 74282 | 249879 | Undocumented 2 | Salix spp :: Willow 218 | 230 Greenwich St | 15 | Back Yard : Yard 13 | Tree 1 | Private 1 | 31 | Width 0ft | 6011548.40111 | 2120431.82846 | 37.8029518994613 | -122.404230226458 | (37.8029518994613, -122.404230226458) | |||
| 83368 | 83368 | 120504 | Undocumented 2 | Salix spp :: Willow 218 | 2050 Turk Blvd | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6000175.0 | 2112136.0 | 37.779531646131204 | -122.442991859062 | (37.7795316461312, -122.442991859062) | |||||
| 92869 | 92869 | 99821 | Undocumented 2 | Salix spp :: Willow 218 | 1230 Twin Peaks Blvd | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | Tree closest to sidewalk and retaining wall | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 95481 | 95481 | 101470 | Undocumented 2 | Salix spp :: Willow 218 | 1230 Twin Peaks Blvd | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||||
| 180980 | 180980 | 249806 | Undocumented 2 | Salix spp :: Willow 218 | 258 Chestnut St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 16 | Width 0ft | 6010784.31321 | 2121039.01987 | 37.804576372755605 | -122.406917200191 | (37.8045763727556, -122.406917200191) | |||
| 164865 | 164865 | 239558 | Undocumented 2 | Salix lasiolepis :: Arroyo willow 213 | 26 Ohlone Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 2ft | 6002169.792830001 | 2096347.5297 | 37.7362938444778 | -122.434961566227 | (37.7362938444778, -122.434961566227) | |||
| 22826 | 22826 | 251117 | Property Tree 7 | Sequoiadendron giganteum :: Sierra Redwood 212 | 2024 Castro St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6002622.0 | 2099601.0 | 37.7452527853239 | -122.43363054854099 | (37.7452527853239, -122.433630548541) | |||||
| 46775 | 46775 | 224477 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 23 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 2ft | 6002584.32363 | 2096230.7970099999 | 37.735996851473296 | -122.43352002314501 | (37.7359968514733, -122.433520023145) | |||
| 130010 | 130010 | 249997 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 39 Darrell Pl | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | Width 0ft | 6011507.582230001 | 2120247.7373900004 | 37.802444149427 | -122.40435851653 | (37.802444149427, -122.40435851653) | |||
| 156890 | 156890 | 249999 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 39 Darrell Pl | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 121 | Width 0ft | 6011509.9435 | 2120224.2158 | 37.8023796968334 | -122.404348688764 | (37.8023796968334, -122.404348688764) | |||
| 160585 | 160585 | 249998 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 39 Darrell Pl | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | Width 0ft | 6011504.54206 | 2120237.90093 | 37.8024169710215 | -122.40436834431699 | (37.8024169710215, -122.404368344317) | |||
| 70496 | 70496 | 249782 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 115 Pfeiffer St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 0ft | 6010481.39254 | 2121146.06325 | 37.804853332490296 | -122.40797304381701 | (37.8048533324903, -122.407973043817) | |||
| 129840 | 129840 | 249783 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 115 Pfeiffer St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 0ft | 6010478.38783 | 2121144.55662 | 37.804849027432105 | -122.407983335672 | (37.8048490274321, -122.407983335672) | |||
| 23859 | 23859 | 223337 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 21 Poppy Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 2ft | 6002002.72042 | 2096679.5859400001 | 37.737196106421706 | -122.435562951888 | (37.7371961064217, -122.435562951888) | |||
| 171592 | 171592 | 223338 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 17 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002542.32415 | 2096276.52832 | 37.736120036118706 | -122.433668499417 | (37.7361200361187, -122.433668499417) | |||
| 43436 | 43436 | 132413 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 8 Codman Pl | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | Width 10ft | 6009827.38182 | 2117300.98565 | 37.7942590579634 | -122.409964721995 | (37.7942590579634, -122.409964721995) | |||
| 161916 | 161916 | 132415 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 8 Codman Pl | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | Width 10ft | 6009831.3064 | 2117286.6196 | 37.7942198322406 | -122.409950127822 | (37.7942198322406, -122.409950127822) | |||
| 164588 | 164588 | 132414 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 8 Codman Pl | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 10ft | 6009830.1634599995 | 2117290.7141400003 | 37.794231010794704 | -122.409954371722 | (37.7942310107947, -122.409954371722) | |||
| 168653 | 168653 | 132412 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 8 Codman Pl | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | Width 10ft | 6009828.26061 | 2117303.30498 | 37.7942654755313 | -122.40996184507601 | (37.7942654755313, -122.409961845076) | |||
| 34978 | 34978 | 249883 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 230 Greenwich St | 19 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | Width 0ft | 6011507.08304 | 2120427.1107900003 | 37.802936637067496 | -122.40437287690901 | (37.8029366370675, -122.404372876909) | |||
| 45069 | 45069 | 126561 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 8 Codman Pl | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | 6009832.93804 | 2117260.0663900003 | 37.7941470150322 | -122.40994260678998 | (37.7941470150322, -122.40994260679) | ||||
| 133186 | 133186 | 249880 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 230 Greenwich St | 16 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | Width 0ft | 6011523.78476 | 2120446.01272 | 37.8029894704488 | -122.404316411196 | (37.8029894704488, -122.404316411196) | |||
| 158045 | 158045 | 249890 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 230 Greenwich St | 26 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | Width 0ft | 6011458.55673 | 2120431.8571900004 | 37.8029469576839 | -122.40454113827101 | (37.8029469576839, -122.404541138271) | |||
| 184764 | 184764 | 126562 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 8 Codman Pl | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | 6009829.32931 | 2117256.5326099996 | 37.7941371098806 | -122.40995484385901 | (37.7941371098806, -122.409954843859) | ||||
| 78751 | 78751 | 117435 | Significant Tree 6 | Salix babylonica :: Weeping Willow 182 | 98X CLIPPER ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6004559.0 | 2101087.0 | 37.749442713924296 | -122.427038546128 | (37.7494427139243, -122.427038546128) | |||||
| 27098 | 27098 | 249881 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 230 Greenwich St | 17 | Back Yard : Yard 13 | Tree 1 | Private 1 | 16 | Width 0ft | 6011514.20842 | 2120460.74576 | 37.803029388647104 | -122.404350588107 | (37.8030293886471, -122.404350588107) | |||
| 65300 | 65300 | 111749 | Landmark tree 9 | Quercus agrifolia :: Coast Live Oak 180 | 4124 23rd St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6002319.4 | 2102413.2 | 37.752957247271 | -122.434877962118 | (37.752957247271, -122.434877962118) | |||||
| 112387 | 112387 | 109194 | Property Tree 7 | Quercus agrifolia :: Coast Live Oak 180 | 4705 03rd St | Back Yard : Yard 13 | Tree 1 | Arts Commission 19 | 45 | 6015121.6 | 2095617.0 | 37.7350148477359 | -122.39013039721901 | (37.7350148477359, -122.390130397219) | |||||
| 126137 | 126137 | 105444 | Landmark tree 9 | Quercus agrifolia :: Coast Live Oak 180 | 20-28 ROSEMONT PL | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6005075.5 | 2108088.5 | 37.768696376708895 | -122.425750755404 | (37.7686963767089, -122.425750755404) | |||||
| 47640 | 47640 | 249876 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 230 Greenwich St | 12 | Back Yard : Yard 13 | Tree 1 | Private 1 | 29 | Width 0ft | 6011590.626680001 | 2120460.04582 | 37.8030317367952 | -122.40408609031 | (37.8030317367952, -122.40408609031) | |||
| 56133 | 56133 | 249888 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 230 Greenwich St | 24 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 0ft | 6011477.22379 | 2120439.43792 | 37.80296881573079 | -122.404477074154 | (37.8029688157308, -122.404477074154) | |||
| 53610 | 53610 | 104278 | Significant Tree 6 | Acacia spp :: Acacia Spp 176 | 2 Allston Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5994445.1 | 2098202.2 | 37.7409446783355 | -122.461803277974 | (37.7409446783355, -122.461803277974) | |||||
| 29592 | 29592 | 249968 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 213 Filbert St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | Width 0ft | 6011722.66122 | 2120088.35569 | 37.8020185425825 | -122.403603012281 | (37.8020185425825, -122.403603012281) | |||
| 96761 | 96761 | 87388 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 201 Topeka Ave | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 04/24/2008 12:00:00 AM | Permit Number 50366 | 6012955.9 | 2095077.8 | 37.7334139596128 | -122.39758023766399 | (37.7334139596128, -122.397580237664) | |||
| 99282 | 99282 | 87387 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 201 Topeka Ave | Back Yard : Yard 13 | Tree 1 | Private 1 | 04/24/2008 12:00:00 AM | Permit Number 50366 | 6012955.9 | 2095077.8 | 37.7334139596128 | -122.39758023766399 | (37.7334139596128, -122.397580237664) | ||||
| 110484 | 110484 | 87389 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 201 Topeka Ave | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 04/24/2008 12:00:00 AM | Permit Number 50366 | 6012955.9 | 2095077.8 | 37.7334139596128 | -122.39758023766399 | (37.7334139596128, -122.397580237664) | |||
| 147898 | 147898 | 249995 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 41 Darrell Pl | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 0ft | 6011498.48414 | 2120303.0710299998 | 37.802595573674104 | -122.404393897677 | (37.8025955736741, -122.404393897677) | |||
| 51612 | 51612 | 234910 | Undocumented 2 | Populus tremuloides :: Quaking aspen 166 | 1 Penny Ln | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | Width 2ft | 6002382.22186 | 2096459.02703 | 37.73661204979621 | -122.43423508039301 | (37.7366120497962, -122.434235080393) | |||
| 136411 | 136411 | 234911 | Undocumented 2 | Populus tremuloides :: Quaking aspen 166 | 3 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | Width 2ft | 6002388.89555 | 2096450.4938299998 | 37.736588998379105 | -122.434211396756 | (37.7365889983791, -122.434211396756) | |||
| 1996 | 1996 | 252848 | Property Tree 7 | Pinus halepensis :: Allepo Pine 164 | 99 Reposa Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5998022.0 | 2098104.0 | 37.7408803073177 | -122.44942865965 | (37.7408803073177, -122.44942865965) | ||||
| 27650 | 27650 | 239211 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 11 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 6005882.93751 | 2108938.64172 | 37.7710762568972 | -122.42301832034501 | (37.7710762568972, -122.423018320345) | ||||
| 31969 | 31969 | 239194 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 101 Hwy 101 Northbound | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 6005943.751730001 | 2109019.81978 | 37.7713025838749 | -122.422813731768 | (37.7713025838749, -122.422813731768) | ||||
| 32290 | 32290 | 239198 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 101 Hwy 101 Northbound | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 6005918.91365 | 2109064.99496 | 37.771425222619705 | -122.42290285910299 | (37.7714252226197, -122.422902859103) | ||||
| 34830 | 34830 | 239214 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 6005859.14445 | 2108978.35649 | 37.771183961488106 | -122.423103444792 | (37.7711839614881, -122.423103444792) | ||||
| 35375 | 35375 | 239209 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 14 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | 6005896.875990001 | 2108918.25042 | 37.7710210537973 | -122.42296865708299 | (37.7710210537973, -122.422968657083) | ||||
| 38350 | 38350 | 239199 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 27 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | 6005974.4493 | 2108807.19348 | 37.770720494984495 | -122.422692434815 | (37.7707204949845, -122.422692434815) | ||||
| 44635 | 44635 | 239192 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 101 Hwy 101 Northbound | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 6005960.3562900005 | 2108991.91912 | 37.771226912211795 | -122.422754312663 | (37.7712269122118, -122.422754312663) | ||||
| 45307 | 45307 | 239204 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 21 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | 6005940.87649 | 2108850.7859900002 | 37.7708382953675 | -122.422811662426 | (37.7708382953675, -122.422811662426) | ||||
| 59769 | 59769 | 239203 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 22 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 6005946.44181 | 2108844.1649 | 37.7708204294492 | -122.42279194121402 | (37.7708204294492, -122.422791941214) | ||||
| 60490 | 60490 | 239208 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 17 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 6005920.35776 | 2108877.05935 | 37.7709092779754 | -122.42288450484 | (37.7709092779754, -122.42288450484) | ||||
| 61226 | 61226 | 239216 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 6005843.543219999 | 2109006.7344400003 | 37.771261000120504 | -122.42315942758499 | (37.7712610001205, -122.423159427585) | ||||
| 63852 | 63852 | 239189 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 101 Hwy 101 Northbound | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 6005983.85034 | 2108958.2836700003 | 37.7711358828561 | -122.422670655046 | (37.7711358828561, -122.422670655046) | ||||
| 73553 | 73553 | 239217 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | 6005837.81281 | 2109017.0594 | 37.7712890265976 | -122.423179983379 | (37.7712890265976, -122.423179983379) | ||||
| 75553 | 75553 | 239196 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 101 Hwy 101 Northbound | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 6005930.84591 | 2109041.9421200003 | 37.771362598325 | -122.42285994612499 | (37.771362598325, -122.422859946125) | ||||
| 130200 | 130200 | 239200 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 26 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | 6005967.71166 | 2108818.2564 | 37.7707504909794 | -122.422716526767 | (37.7707504909794, -122.422716526767) | ||||
| 131357 | 131357 | 239215 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | 6005849.76837 | 2108994.2700400003 | 37.77122712717 | -122.423137008381 | (37.77122712717, -122.423137008381) | ||||
| 133557 | 133557 | 239195 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 101 Hwy 101 Northbound | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 6005938.2626 | 2109031.33623 | 37.77133389557179 | -122.422833537536 | (37.7713338955718, -122.422833537536) | ||||
| 133851 | 133851 | 239201 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 25 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 6005958.49088 | 2108828.3343599997 | 37.7707776424043 | -122.422749137971 | (37.7707776424043, -122.422749137971) | ||||
| 149080 | 149080 | 239213 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 6005865.35862 | 2108965.54677 | 37.771149139741 | -122.423081039068 | (37.771149139741, -122.423081039068) | ||||
| 152126 | 152126 | 239212 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 6005873.5433 | 2108954.58543 | 37.7711195043932 | -122.42305194869301 | (37.7711195043932, -122.423051948693) | ||||
| 158664 | 158664 | 239205 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 20 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | 6005934.94283 | 2108857.8407799997 | 37.7708573313359 | -122.422832688574 | (37.7708573313359, -122.422832688574) | ||||
| 160902 | 160902 | 239191 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 101 Hwy 101 Northbound | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 6005967.76325 | 2108980.83852 | 37.7711969054453 | -122.422727904078 | (37.7711969054453, -122.422727904078) | ||||
| 163838 | 163838 | 239218 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 10ft | 6005833.18575 | 2109028.0269 | 37.771318879598105 | -122.423196768328 | (37.7713188795981, -122.423196768328) | |||
| 166869 | 166869 | 239197 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 101 Hwy 101 Northbound | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | 6005924.85036 | 2109052.04357 | 37.7713899961886 | -122.42288140308001 | (37.7713899961886, -122.42288140308) | ||||
| 168811 | 168811 | 239193 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 101 Hwy 101 Northbound | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 6005953.87409 | 2109001.5556400004 | 37.771253006051296 | -122.42277741983801 | (37.7712530060513, -122.422777419838) | ||||
| 170487 | 170487 | 239210 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 13 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 6005891.00584 | 2108925.69957 | 37.771041176138795 | -122.422989491673 | (37.7710411761388, -122.422989491673) | ||||
| 180826 | 180826 | 239202 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 24 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | 6005953.73874 | 2108834.81297 | 37.7707951629947 | -122.422766036225 | (37.7707951629947, -122.422766036225) |
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");