Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 692 | 692 | 176334 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 287 Hester Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 34 | 6012223.87562 | 2087782.5469900002 | 37.713341893097 | -122.399599040764 | (37.713341893097, -122.399599040764) | ||||
| 701 | 701 | 176335 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 287 Hester Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6012233.93602 | 2087774.2056900002 | 37.7133195503322 | -122.399563683027 | (37.7133195503322, -122.399563683027) | ||||
| 1320 | 1320 | 251503 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 800X Bosworth St | 15 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | |||||
| 1324 | 1324 | 251501 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 800X Bosworth St | 13 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | |||||
| 1326 | 1326 | 251502 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 800X Bosworth St | 14 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | |||||
| 1335 | 1335 | 251499 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 800X Bosworth St | 11 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | |||||
| 1341 | 1341 | 251498 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 800X Bosworth St | 10 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | |||||
| 1348 | 1348 | 251500 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 800X Bosworth St | 12 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | |||||
| 1524 | 1524 | 251544 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 863X Ocean Ave | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x3 | 5997430.0 | 2091537.0 | 37.722815009603295 | -122.451002133856 | (37.7228150096033, -122.451002133856) | |||||
| 1573 | 1573 | 251597 | Landmark tree 9 | Ficus macrophylla :: Morton Bay Fig 148 | 1650 Valencia St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6006336.0 | 2100501.0 | 37.747934015176504 | -122.42085202386299 | (37.7479340151765, -122.420852023863) | |||||
| 1620 | 1620 | 251543 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0X Bay Shore Blvd Off Ramp | Side Yard : Yard 17 | Tree 1 | Private 1 | |||||||||||
| 1817 | 1817 | 251719 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1301 Clayton St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5999055.0 | 2105304.0 | 37.7607087868046 | -122.446374778866 | (37.7607087868046, -122.446374778866) | |||||
| 1875 | 1875 | 251783 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 610 Clipper St | 5 | Side Yard : Yard 17 | Tree 1 | DPW 2 | Width 2ft | 6001275.75039 | 2100902.7174 | 37.7487505133321 | -122.438378885672 | (37.7487505133321, -122.438378885672) | ||||
| 1918 | 1918 | 251819 | DPW Maintained 3 | Acer macrophyllum :: Big Leaf Maple 159 | 298X Corbett Ave | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 3x3 | Permit Number 778898 | 5999572.0 | 2105342.0 | 37.7608426398345 | -122.444589445505 | (37.7608426398345, -122.444589445505) | |||
| 2610 | 2610 | 253145 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 801X Santiago St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5990274.0 | 2099728.0 | 37.7448931297685 | -122.47633667765699 | (37.7448931297685, -122.476336677657) | |||||
| 2768 | 2768 | 219151 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1500 16th Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 4ft | 5991179.47447 | 2105124.8493 | 37.759763935780704 | -122.47359934526101 | (37.7597639357807, -122.473599345261) | |||
| 2774 | 2774 | 219153 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1500 16th Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 6ft | 5991180.54312 | 2105148.28148 | 37.759828336219705 | -122.473597358645 | (37.7598283362197, -122.473597358645) | |||
| 2776 | 2776 | 219152 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1500 16th Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 6ft | 5991180.06905 | 2105137.8500200002 | 37.759799666743 | -122.473598237272 | (37.759799666743, -122.473598237272) | |||
| 3257 | 3257 | 253379 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 899 Waller St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6001282.0 | 2108613.0 | 37.76992142642111 | -122.438909742148 | (37.7699214264211, -122.438909742148) | |||||
| 3261 | 3261 | 253388 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 30 Grand View Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x3 | 6000475.0 | 2103841.0 | 37.756772747069604 | -122.44135867200701 | (37.7567727470696, -122.441358672007) | ||||
| 3262 | 3262 | 253382 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 899 Waller St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6001282.0 | 2108613.0 | 37.76992142642111 | -122.438909742148 | (37.7699214264211, -122.438909742148) | |||||
| 3270 | 3270 | 253380 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 899 Waller St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6001282.0 | 2108613.0 | 37.76992142642111 | -122.438909742148 | (37.7699214264211, -122.438909742148) | |||||
| 3271 | 3271 | 253381 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 899 Waller St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6001282.0 | 2108613.0 | 37.76992142642111 | -122.438909742148 | (37.7699214264211, -122.438909742148) | |||||
| 3279 | 3279 | 253383 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 899 Waller St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6001282.0 | 2108613.0 | 37.76992142642111 | -122.438909742148 | (37.7699214264211, -122.438909742148) | |||||
| 3280 | 3280 | 253389 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 30X Grand View Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x3 | 6000475.0 | 2103841.0 | 37.756772747069604 | -122.44135867200701 | (37.7567727470696, -122.441358672007) | ||||
| 3399 | 3399 | 251598 | Undocumented 2 | Tree(s) :: 17 | 900x Moraga St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 09/06/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780206 | 5991390.0 | 2103897.0 | 37.7564047756354 | -122.47278171886002 | (37.7564047756354, -122.47278171886) | |
| 3552 | 3552 | 253469 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 701 Stanyan St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5997178.0 | 2108423.0 | 37.7691653834469 | -122.45309160151399 | (37.7691653834469, -122.453091601514) | |||||
| 3586 | 3586 | 253468 | DPW Maintained 3 | Salix lasiolepis :: Arroyo willow 213 | 801X Alemany Blvd | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | ||||||||||
| 3610 | 3610 | 115725 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 250X Octavia St | 2 | Side Yard : Yard 17 | Tree 1 | Dept of Real Estate 5 | ||||||||||
| 3743 | 3743 | 175363 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 5ft | 5993226.79298 | 2087801.79474 | 37.71231750501779 | -122.465260429219 | (37.7123175050178, -122.465260429219) | |||
| 5112 | 5112 | 253808 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2 Garfield St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
| 5144 | 5144 | 253807 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Garfield St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x2 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
| 5161 | 5161 | 253809 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2 Garfield St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
| 9694 | 9694 | 173632 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 3300X Market St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | ||||||||||
| 9916 | 9916 | 173733 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 14 Richland Ave | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 3x3 | 6004601.0 | 2096122.0 | 37.7358123337564 | -122.426539816145 | (37.7358123337564, -122.426539816145) | ||||
| 9987 | 9987 | 173779 | Significant Tree 6 | Ficus macrophylla :: Morton Bay Fig 148 | 99X Cleveland St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x6 | 6010549.0 | 2110746.0 | 37.7763010397716 | -122.40700558704799 | (37.7763010397716, -122.407005587048) | ||||
| 10000 | 10000 | 173780 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 99X Cleveland St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x6 | 6010549.0 | 2110746.0 | 37.7763010397716 | -122.40700558704799 | (37.7763010397716, -122.407005587048) | ||||
| 10004 | 10004 | 114140 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 13271 | 13271 | 187638 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 875 El Camino Del Mar | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5985641.0 | 2114972.0 | 37.786479112006 | -122.493479464676 | (37.786479112006, -122.493479464676) | ||||
| 13275 | 13275 | 187637 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 875 El Camino Del Mar | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5985641.0 | 2114972.0 | 37.786479112006 | -122.493479464676 | (37.786479112006, -122.493479464676) | ||||
| 15743 | 15743 | 115724 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 250x Octavia St | 1 | Side Yard : Yard 17 | Tree 1 | Dept of Real Estate 5 | ||||||||||
| 23489 | 23489 | 247849 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 152 Chapman St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6009118.007540001 | 2098230.0964599997 | 37.74185503078979 | -122.41107154552401 | (37.7418550307898, -122.411071545524) | ||||
| 23842 | 23842 | 248194 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 216 Esmeralda Ave | 13 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6007325.73728 | 2098765.61768 | 37.7432247818956 | -122.41730658752199 | (37.7432247818956, -122.417306587522) | ||||
| 23934 | 23934 | 248050 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 38 Rutledge St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6010496.13368 | 2099436.61391 | 37.7452450531093 | -122.406391405264 | (37.7452450531093, -122.406391405264) | ||||
| 24297 | 24297 | 248119 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6010375.35501 | 2099399.67941 | 37.7451368817742 | -122.40680643699301 | (37.7451368817742, -122.406806436993) | ||||
| 24579 | 24579 | 247929 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 37 | 6010384.7561099995 | 2098766.60945 | 37.743399135274295 | -122.40672932282301 | (37.7433991352743, -122.406729322823) | ||||
| 24649 | 24649 | 194268 | Undocumented 2 | Persea americana :: Avocado 113 | 900 Quint St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 3ft | 6014100.1568599995 | 2097559.70841 | 37.7402924173605 | -122.393797854205 | (37.7402924173605, -122.393797854205) | |||
| 24680 | 24680 | 187543 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1400 Somerset St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6011384.82868 | 2088240.1087599997 | 37.714551459646394 | -122.402531250636 | (37.7145514596464, -122.402531250636) | ||||
| 24856 | 24856 | 248244 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 296 Esmeralda Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6006798.41265 | 2099004.72131 | 37.7438516246444 | -122.41914689812799 | (37.7438516246444, -122.419146898128) | ||||
| 25114 | 25114 | 249640 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2400 Lyon St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999291.5931400005 | 2117167.12216 | 37.79329538582 | -122.446409970041 | (37.79329538582, -122.446409970041) | ||||
| 25256 | 25256 | 238433 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 272 Corbett Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 3ft | 5999629.6727599995 | 2105348.1757099996 | 37.7608628875441 | -122.444390425487 | (37.7608628875441, -122.444390425487) | |||
| 25273 | 25273 | 237871 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 200 Corbin Pl | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 6000061.7105 | 2105723.34521 | 37.761917651093704 | -122.44292314469 | (37.7619176510937, -122.44292314469) | |||
| 25440 | 25440 | 237908 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 3911 21st St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6002345.78312 | 2103531.79558 | 37.7560301412935 | -122.43486671293002 | (37.7560301412935, -122.43486671293) | ||||
| 25566 | 25566 | 214228 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 714 Detroit St | 16 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5999467.5472800005 | 2095443.9032 | 37.733658896535 | -122.444239403229 | (37.733658896535, -122.444239403229) | ||||
| 25663 | 25663 | 188593 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 20th St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6010961.38996 | 2104652.9831 | 37.759594070921004 | -122.40514986509899 | (37.759594070921, -122.405149865099) | ||||
| 25720 | 25720 | 196053 | Undocumented 2 | Populus trichocarpa :: Black Cottonwood Poplar 258 | 2399 Lane St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6013983.40604 | 2092884.07422 | 37.727447595718395 | -122.393874328035 | (37.7274475957184, -122.393874328035) | ||||
| 25721 | 25721 | 190755 | Undocumented 2 | Juglans regia :: Walnut: English 348 | 1999 Revere Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 6012974.9721800005 | 2095942.04055 | 37.7357880468688 | -122.397574892566 | (37.7357880468688, -122.397574892566) | ||||
| 25897 | 25897 | 134510 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 4ft | 6008017.687530001 | 2112101.62184 | 37.7798812789472 | -122.415858138542 | (37.7798812789472, -122.415858138542) | |||
| 25968 | 25968 | 249846 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 289 Greenwich St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 0ft | 6011427.16735 | 2120382.55668 | 37.8028098362532 | -122.40464628970601 | (37.8028098362532, -122.404646289706) | |||
| 25982 | 25982 | 247919 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6010242.48982 | 2098715.3752200003 | 37.743250496220895 | -122.40721763491001 | (37.7432504962209, -122.40721763491) | ||||
| 26079 | 26079 | 134508 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 4ft | 6008055.00417 | 2112104.50717 | 37.7798912991906 | -122.41572924771499 | (37.7798912991906, -122.415729247715) | |||
| 26278 | 26278 | 249950 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 303 Filbert St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 0ft | 6011359.33086 | 2120056.95578 | 37.801912024192795 | -122.404858102512 | (37.8019120241928, -122.404858102512) | |||
| 26288 | 26288 | 247985 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 495 Peralta Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6009773.5395 | 2099699.6998799997 | 37.7459269802441 | -122.40890858338001 | (37.7459269802441, -122.40890858338) | ||||
| 26362 | 26362 | 196123 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2300 20th St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 4ft | 6011242.42693 | 2104654.95461 | 37.7596151915071 | -122.404178032517 | (37.7596151915071, -122.404178032517) | |||
| 26378 | 26378 | 118551 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 8140 Geary Blvd | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 5981667.59483 | 2112398.2493 | 37.7791791285325 | -122.50703522193999 | (37.7791791285325, -122.50703522194) | ||||
| 26546 | 26546 | 191706 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1499 Rankin St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | Width 3ft | 6012685.03055 | 2096691.5436200001 | 37.7378298766422 | -122.39862992054701 | (37.7378298766422, -122.398629920547) | |||
| 27269 | 27269 | 250005 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 232 Filbert St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 0ft | 6011493.8796 | 2120090.77159 | 37.802012393927 | -122.404394879735 | (37.802012393927, -122.404394879735) | |||
| 27802 | 27802 | 206466 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 747 Detroit St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999436.63595 | 2095454.0058900001 | 37.733684872551606 | -122.444346998137 | (37.7336848725516, -122.444346998137) | ||||
| 27912 | 27912 | 191009 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1350 Rankin St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 2ft | 6012766.95212 | 2096886.7999200001 | 37.7383705733355 | -122.398360372158 | (37.7383705733355, -122.398360372158) | |||
| 27927 | 27927 | 247528 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1101 Waller St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6000060.08033 | 2108486.82414 | 37.7695053822964 | -122.443127261125 | (37.7695053822964, -122.443127261125) | ||||
| 28120 | 28120 | 178856 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 121 Delta St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6009824.00265 | 2088991.8165400003 | 37.71652823335621 | -122.407979098955 | (37.7165282333562, -122.407979098955) | ||||
| 28127 | 28127 | 191847 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2101 Newcomb Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | Width 10ft | 6012411.60288 | 2097770.43241 | 37.7407770404189 | -122.39965102878901 | (37.7407770404189, -122.399651028789) | |||
| 28161 | 28161 | 249840 | Undocumented 2 | Magnolia x soulangiana :: Saucer Magnolia 92 | 305 Greenwich St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 0ft | 6011283.33525 | 2120383.34662 | 37.8028039654926 | -122.405144080631 | (37.8028039654926, -122.405144080631) | |||
| 28786 | 28786 | 214229 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 714 Detroit St | 17 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 5999467.99685 | 2095449.76583 | 37.7336750195872 | -122.444238270085 | (37.7336750195872, -122.444238270085) | ||||
| 28898 | 28898 | 250221 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 312 Filbert St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 0ft | 6011282.00764 | 2120080.85256 | 37.8019733165766 | -122.405127362244 | (37.8019733165766, -122.405127362244) | |||
| 28950 | 28950 | 132461 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1109 Chestnut St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6006461.025 | 2120401.5247299997 | 37.8025831108771 | -122.42183305885901 | (37.8025831108771, -122.421833058859) | ||||
| 29143 | 29143 | 248220 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 70 Fair Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6007112.652530001 | 2099342.90806 | 37.7447979012027 | -122.41808429785499 | (37.7447979012027, -122.418084297855) | ||||
| 29144 | 29144 | 205629 | Undocumented 2 | Betula pendula :: European White Birch 146 | 714 Detroit St | 18 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5999458.60233 | 2095454.85434 | 37.7336884554611 | -122.444271115125 | (37.7336884554611, -122.444271115125) | ||||
| 29239 | 29239 | 211277 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 232 Edna St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 43 | 5998792.56249 | 2095483.7387400002 | 37.7337297433315 | -122.44657587878599 | (37.7337297433315, -122.446575878786) | ||||
| 29301 | 29301 | 250202 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 203 Union St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | Width 0ft | 6011755.5651 | 2119757.15751 | 37.8011109908426 | -122.403465834184 | (37.8011109908426, -122.403465834184) | |||
| 29447 | 29447 | 206472 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 714 Detroit St | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999457.34155 | 2095426.0503099998 | 37.733609294436796 | -122.444273404802 | (37.7336092944368, -122.444273404802) | ||||
| 29484 | 29484 | 190646 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 230 Middle Point Rd | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 8ft | 6018218.4425 | 2096359.44868 | 37.7372247426365 | -122.379474956329 | (37.7372247426365, -122.379474956329) | |||
| 29637 | 29637 | 247866 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 398 Mayflower St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6009543.35492 | 2098406.93767 | 37.7423644418716 | -122.40961330563101 | (37.7423644418716, -122.409613305631) | ||||
| 29648 | 29648 | 196372 | Undocumented 2 | Prunus spp :: Cherry 84 | 1700 Armstrong Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6013890.9677099995 | 2092887.97335 | 37.7274531643304 | -122.394194162931 | (37.7274531643304, -122.394194162931) | ||||
| 29739 | 29739 | 187574 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 72 Bishop St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6010842.8913900005 | 2089488.5588 | 37.71794917929 | -122.404492242147 | (37.71794917929, -122.404492242147) | ||||
| 29793 | 29793 | 247852 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 80 Bradford St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6009577.25002 | 2098193.0016099997 | 37.741778919360705 | -122.409481010838 | (37.7417789193607, -122.409481010838) | ||||
| 29820 | 29820 | 187571 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 73 Bishop St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6010860.52073 | 2089475.11103 | 37.7179132396708 | -122.40443035886899 | (37.7179132396708, -122.404430358869) | ||||
| 30032 | 30032 | 247924 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6010297.695230001 | 2098727.78354 | 37.7432876562154 | -122.40702762254499 | (37.7432876562154, -122.407027622545) | ||||
| 30048 | 30048 | 132396 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2836 Larkin St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 40 | 6006504.32212 | 2120945.10898 | 37.804078096188704 | -122.421721861273 | (37.8040780961887, -122.421721861273) | ||||
| 30197 | 30197 | 196336 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 1750 22nd St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6012821.16046 | 2103795.98592 | 37.757344738798 | -122.398657667323 | (37.757344738798, -122.398657667323) | ||||
| 30408 | 30408 | 248049 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 38 Rutledge St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6010499.7614 | 2099438.0486 | 37.7452491953942 | -122.40637896223 | (37.7452491953942, -122.40637896223) | ||||
| 30472 | 30472 | 247853 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 80 Bradford St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6009574.28658 | 2098178.5899099996 | 37.7417391819242 | -122.40949024059401 | (37.7417391819242, -122.409490240594) | ||||
| 30481 | 30481 | 247913 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 399 Franconia St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6009968.0552900005 | 2098803.93583 | 37.743478301698296 | -122.40817280665001 | (37.7434783016983, -122.40817280665) | ||||
| 30657 | 30657 | 220393 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 20 Deming St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 3ft | 5999466.4358 | 2105239.81948 | 37.7605560532329 | -122.44494719845801 | (37.7605560532329, -122.444947198458) | |||
| 30719 | 30719 | 249951 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 303 Filbert St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 0ft | 6011370.2265099995 | 2120056.34585 | 37.8019109584873 | -122.40482035527799 | (37.8019109584873, -122.404820355278) | |||
| 30768 | 30768 | 223720 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Crescent Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6005295.72226 | 2095902.89747 | 37.7352499770995 | -122.424122309196 | (37.7352499770995, -122.424122309196) | |||
| 30996 | 30996 | 247856 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 80 Bradford St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 32 | 6009566.847130001 | 2098148.32022 | 37.7416556510973 | -122.409513828008 | (37.7416556510973, -122.409513828008) | ||||
| 31185 | 31185 | 247857 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 80 Bradford St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6009575.64001 | 2098128.64759 | 37.7416021270253 | -122.409482036966 | (37.7416021270253, -122.409482036966) | ||||
| 31230 | 31230 | 187779 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 230 Middle Point Rd | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 6ft | 6018271.33931 | 2096490.0449 | 37.737586251210104 | -122.379301134458 | (37.7375862512101, -122.379301134458) | |||
| 31259 | 31259 | 201730 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1411 Phelps St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6013762.45417 | 2095926.0507 | 37.7357879596321 | -122.39485111951001 | (37.7357879596321, -122.39485111951) |
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");