Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qCaretaker, qCareAssistant, DBH, PlotSize
PlantType ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 104222 | 104222 | 88572 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 66 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187.0 | 2113215.0 | 37.782665577707796 | -122.43264916888701 | (37.7826655777078, -122.432649168887) | |||
| 93053 | 93053 | 88571 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 62 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187.0 | 2113215.0 | 37.782665577707796 | -122.43264916888701 | (37.7826655777078, -122.432649168887) | |||
| 109202 | 109202 | 88570 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 61 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187.0 | 2113215.0 | 37.782665577707796 | -122.43264916888701 | (37.7826655777078, -122.432649168887) | |||
| 81053 | 81053 | 88569 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 60 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187.0 | 2113215.0 | 37.782665577707796 | -122.43264916888701 | (37.7826655777078, -122.432649168887) | |||
| 115344 | 115344 | 88568 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 59 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187.0 | 2113215.0 | 37.782665577707796 | -122.43264916888701 | (37.7826655777078, -122.432649168887) | |||
| 112187 | 112187 | 88567 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 39 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187.0 | 2113215.0 | 37.782665577707796 | -122.43264916888701 | (37.7826655777078, -122.432649168887) | |||
| 78259 | 78259 | 111280 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 700X BOSWORTH ST | 18 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 48 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
| 100636 | 100636 | 114940 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 16 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 82056 | 82056 | 114939 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 15 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 36 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | |||
| 139185 | 139185 | 114938 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 14 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 106106 | 106106 | 114937 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 13 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 84743 | 84743 | 116631 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 12 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 141835 | 141835 | 114936 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 12 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 113089 | 113089 | 87675 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 770 Golden Gate Ave | 11 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50396 | 6005860.1 | 2112469.5 | 37.7807698496384 | -122.42334835915399 | (37.7807698496384, -122.423348359154) | ||
| 124339 | 124339 | 116630 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 11 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 141973 | 141973 | 114935 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 11 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 80436 | 80436 | 87674 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 770 Golden Gate Ave | 10 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50396 | 6005860.1 | 2112469.5 | 37.7807698496384 | -122.42334835915399 | (37.7807698496384, -122.423348359154) | ||
| 98906 | 98906 | 116629 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 10 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 103199 | 103199 | 114934 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 4400x OCEAN AVE | 10 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777127 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | |
| 91895 | 91895 | 114933 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 9 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 96632 | 96632 | 116628 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 9 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 78663 | 78663 | 114932 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 8 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 125790 | 125790 | 116627 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 8 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 1799 | 1799 | 251715 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 7 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 96445 | 96445 | 114266 | Undocumented 2 | Pittosporum spp :: Pittosporum spp 128 | 800x BROTHERHOOD WAY | 7 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 9 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 100601 | 100601 | 114931 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 7 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 111008 | 111008 | 116626 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 5732X GEARY BLVD | 7 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 1807 | 1807 | 251714 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 6 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 58682 | 58682 | 116625 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 6 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 106143 | 106143 | 87075 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 395 Byxbee St | 6 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
| 124433 | 124433 | 114265 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800x BROTHERHOOD WAY | 6 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 26 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 144669 | 144669 | 114930 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 6 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 901 | 901 | 224716 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 5 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 13 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 1793 | 1793 | 251713 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 5 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 85042 | 85042 | 106874 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 38 08th St | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 769156 | 6008506.93846 | 2111466.3623599997 | 37.7781645006636 | -122.41412064163201 | (37.7781645006636, -122.414120641632) | ||||
| 98792 | 98792 | 108275 | Significant Tree 6 | Arecastrum romanzoffianum :: Queen Palm 238 | 1800x ALAMEDA ST | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 15 | 6011533.0 | 2107928.0 | 37.7686184708296 | -122.40340334412501 | (37.7686184708296, -122.403403344125) | ||||
| 111849 | 111849 | 117150 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 TOLAND ST | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011950.0 | 2098029.0 | 37.7414612698949 | -122.401265252936 | (37.7414612698949, -122.401265252936) | |
| 111937 | 111937 | 87074 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 395 Byxbee St | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
| 113343 | 113343 | 116624 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 5 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 118309 | 118309 | 114264 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 800x BROTHERHOOD WAY | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 32 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 140796 | 140796 | 114929 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 905 | 905 | 224715 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 4 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 12 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 1795 | 1795 | 251712 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 4 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 54137 | 54137 | 106873 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 38 08th St | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 769156 | 6008506.93846 | 2111466.3623599997 | 37.7781645006636 | -122.41412064163201 | (37.7781645006636, -122.414120641632) | ||||
| 80776 | 80776 | 114263 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 800x BROTHERHOOD WAY | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 29 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 87119 | 87119 | 112572 | Significant Tree 6 | Cordyline australis :: Dracena Palm 141 | 162 GRAND VIEW AVE | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6000754.0 | 2103380.0 | 37.7555228430156 | -122.440360729392 | (37.7555228430156, -122.440360729392) | ||||
| 101280 | 101280 | 113045 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 500 RAYMOND AVE | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6008527.0 | 2088690.0 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | ||||
| 103256 | 103256 | 114928 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 104090 | 104090 | 87073 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 395 Byxbee St | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
| 111585 | 111585 | 88455 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2801 Oakdale Ave | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 51417 | 6011007.5 | 2098422.1 | 37.742488010089005 | -122.40455177544202 | (37.742488010089, -122.404551775442) | |||
| 117969 | 117969 | 105170 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 4755X 03RD ST | 4 | Front Yard : Cutout 8 | Tree 1 | Arts Commission 19 | 2 | 3x3 | 6015032.0 | 2095658.0 | 37.7351224553975 | -122.39044304267901 | (37.7351224553975, -122.390443042679) | |||
| 127767 | 127767 | 31647 | Permitted Site 1 | Tree(s) :: 17 | 4500 Ulloa St | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/13/2009 12:00:00 AM | 3x3 | Permit Number 52054 | 5982086.63822537 | 2098111.49533937 | 37.7399764418309 | -122.504526837106 | (37.7399764418309, -122.504526837106) | ||
| 142683 | 142683 | 116623 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 4 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 916 | 916 | 224714 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 3 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 11 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 1791 | 1791 | 251711 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 3 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 4182 | 4182 | 253620 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 142 | 1120 South Van Ness Ave | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | Width 3ft | 6007603.98274 | 2103104.1444200003 | 37.755153048679205 | -122.41665176419201 | (37.7551530486792, -122.416651764192) | ||||
| 9868 | 9868 | 173714 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 699x 29th St | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6002089.0 | 2098776.0 | 37.7429572717864 | -122.435414565427 | (37.7429572717864, -122.435414565427) | ||||
| 79308 | 79308 | 111069 | Significant Tree 6 | Ilex spp :: Holly Species 163 | 1836 08TH AVE | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x15 | 5993799.0 | 2102987.0 | 37.7540453100112 | -122.464384550175 | (37.7540453100112, -122.464384550175) | ||||
| 83931 | 83931 | 105169 | Property Tree 7 | Corymbia ficifolia :: Red Flowering Gum 60 | 4755X 03RD ST | 3 | Front Yard : Cutout 8 | Tree 1 | Arts Commission 19 | 23 | 4x4 | 6015032.0 | 2095658.0 | 37.7351224553975 | -122.39044304267901 | (37.7351224553975, -122.390443042679) | |||
| 86948 | 86948 | 106872 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 38 08th St | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/31/2014 12:00:00 AM | Permit Number 769156 | 6008506.93846 | 2111466.3623599997 | 37.7781645006636 | -122.41412064163201 | (37.7781645006636, -122.414120641632) | |||
| 89222 | 89222 | 89359 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 308 Tocoloma Ave | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50704 | 6012556.9 | 2087009.2 | 37.7112369933076 | -122.39839375585301 | (37.7112369933076, -122.398393755853) | ||
| 98327 | 98327 | 99832 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 198 | 2398@Steiner Broadway | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | |||||
| 98650 | 98650 | 113044 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 500 RAYMOND AVE | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6008527.0 | 2088690.0 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | ||||
| 101205 | 101205 | 114262 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 800x BROTHERHOOD WAY | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 36 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 102078 | 102078 | 117000 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 880x MCALLISTER ST | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005306.0 | 2112177.0 | 37.779935428414 | -122.42524444144199 | (37.779935428414, -122.425244441442) | |||||
| 102290 | 102290 | 31648 | Permitted Site 1 | Tree(s) :: 17 | 4500 Ulloa St | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/13/2009 12:00:00 AM | 3x3 | Permit Number 52054 | 5982086.63822537 | 2098111.49533937 | 37.7399764418309 | -122.504526837106 | (37.7399764418309, -122.504526837106) | ||
| 102481 | 102481 | 114925 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 4400x OCEAN AVE | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777127 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | |
| 102533 | 102533 | 112571 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 162 GRAND VIEW AVE | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6000754.0 | 2103380.0 | 37.7555228430156 | -122.440360729392 | (37.7555228430156, -122.440360729392) | ||||
| 105928 | 105928 | 109708 | Significant Tree 6 | Tree(s) :: 17 | 621 Laguna Honda Blvd | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 07/29/2015 12:00:00 AM | Permit Number 774799 | 5995723.9 | 2099907.4 | 37.745700269008296 | -122.457505029341 | (37.7457002690083, -122.457505029341) | ||
| 106407 | 106407 | 88454 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2801 Oakdale Ave | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 51417 | 6011007.5 | 2098422.1 | 37.742488010089005 | -122.40455177544202 | (37.742488010089, -122.404551775442) | |||
| 110241 | 110241 | 87072 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 395 Byxbee St | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
| 119427 | 119427 | 12711 | Significant Tree 6 | Tree(s) :: 17 | 1449 Lake St | 3 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 06/01/2000 12:00:00 AM | 3 | 5990998.3321714 | 2114735.5234974 | 37.7861417388427 | -122.474927352046 | (37.7861417388427, -122.474927352046) | |||
| 123257 | 123257 | 116622 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 3 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 129431 | 129431 | 110789 | Section 143 8 | Pinus radiata :: Monterey Pine 3 | 850x SANCHEZ ST | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6003717.0 | 2103349.0 | 37.7556059854845 | -122.430111549694 | (37.7556059854845, -122.430111549694) | ||||
| 96 | 96 | 251196 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 900X 14th St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/22/2017 12:00:00 AM | 3 | 6002515.0 | 2107976.0 | 37.768242455454995 | -122.43459927073098 | (37.768242455455, -122.434599270731) | |||
| 928 | 928 | 224422 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 2 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 16 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 1797 | 1797 | 251710 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 2 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 2436 | 2436 | 110026 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 2585 Pacific Ave | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/18/2015 12:00:00 AM | 3 | Permit Number 779691 | 6001774.18039 | 2116969.68651 | 37.7928947585324 | -122.437805917729 | (37.7928947585324, -122.437805917729) | ||
| 2712 | 2712 | 253178 | Significant Tree 6 | Washingtonia filifera :: California Fan Palm 189 | 4450 24th St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | Width 0ft | 6000289.52403 | 2101701.02913 | 37.7508863393389 | -122.441846529398 | (37.7508863393389, -122.441846529398) | ||||
| 2767 | 2767 | 252950 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 261x Winding Way | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 780594 | 6001774.0 | 2086449.0 | 37.7090922302752 | -122.435622042553 | (37.7090922302752, -122.435622042553) | |||
| 3272 | 3272 | 253387 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 726 El Camino Del Mar | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 5986306.0 | 2114851.0 | 37.7861857583172 | -122.491169854158 | (37.7861857583172, -122.491169854158) | |||||
| 10195 | 10195 | 173713 | Undocumented 2 | Tree(s) :: 17 | 699x 29th St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779391 | 6002089.0 | 2098776.0 | 37.7429572717864 | -122.435414565427 | (37.7429572717864, -122.435414565427) | |
| 13821 | 13821 | 105161 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1600X Oakdale Ave | 2 | Front Yard : Cutout 8 | Tree 1 | Arts Commission 19 | 13 | 3x3 | 6014869.34112 | 2095641.8363700002 | 37.735069048787 | -122.39100428831499 | (37.735069048787, -122.391004288315) | |||
| 42991 | 42991 | 105168 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 4755X 03RD ST | 2 | Front Yard : Cutout 8 | Tree 1 | Arts Commission 19 | 23 | 3x3 | Permit Number 770204 | 6015032.0 | 2095658.0 | 37.7351224553975 | -122.39044304267901 | (37.7351224553975, -122.390443042679) | ||
| 50075 | 50075 | 113043 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 500 RAYMOND AVE | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/06/2015 12:00:00 AM | 3x3 | 6008527.0 | 2088690.0 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | |||
| 82154 | 82154 | 114926 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 83219 | 83219 | 108097 | Significant Tree 6 | Tree(s) :: 17 | 3370 Washington St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 5998663.3699 | 2115944.3199400003 | 37.789901994506 | -122.44849555223101 | (37.789901994506, -122.448495552231) | |||||
| 85143 | 85143 | 115005 | Private 5 | Prunus cerasifera :: Cherry Plum 16 | 1050 MCALLISTER ST | 2 | Front Yard : Cutout 8 | Tree 1 | Office of Mayor 21 | DPW 4 | 3x3 | 6004148.0 | 2111858.0 | 37.778994045300706 | -122.42922772691401 | (37.7789940453007, -122.429227726914) | |||
| 85808 | 85808 | 98327 | Permitted Site 1 | Acacia spp :: Acacia Spp 176 | 143 Alhambra St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 4x6 | Permit Number 49254 | 6001613.1 | 2120268.4 | 37.8019430002039 | -122.43859972925199 | (37.8019430002039, -122.438599729252) | ||
| 86072 | 86072 | 54809 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 150 Carmel St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/12/2007 12:00:00 AM | 5 | 3x3 | Permit Number 773425 | 5998092.51354995 | 2105385.25255364 | 37.760876867329294 | -122.449709427273 | (37.7608768673293, -122.449709427273) | |
| 86717 | 86717 | 108022 | Significant Tree 6 | Grevillea robusta :: Silk Oak Tree 145 | 455X Ivy St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005179.30837 | 2111099.83336 | 37.776970634543 | -122.42560603936 | (37.776970634543, -122.42560603936) | |||||
| 86718 | 86718 | 114261 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 800x BROTHERHOOD WAY | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 36 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 87235 | 87235 | 117162 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1383X VERMONT ST | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | DPW 4 | 6011571.0 | 2102081.0 | 37.752566033842896 | -122.40286062573799 | (37.7525660338429, -122.402860625738) | ||||
| 88034 | 88034 | 111070 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 1836 08TH AVE | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 2 | 3x15 | 5993799.0 | 2102987.0 | 37.7540453100112 | -122.464384550175 | (37.7540453100112, -122.464384550175) | |||
| 91613 | 91613 | 88453 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2801 Oakdale Ave | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 51417 | 6011007.5 | 2098422.1 | 37.742488010089005 | -122.40455177544202 | (37.742488010089, -122.404551775442) | |||
| 99011 | 99011 | 115564 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 3524 Jackson St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 5x10 | 5997387.02929021 | 2116081.37513577 | 37.790205252620794 | -122.452921449726 | (37.7902052526208, -122.452921449726) | ||||
| 111788 | 111788 | 106871 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 38 08th St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/31/2014 12:00:00 AM | Permit Number 769156 | 6008506.93846 | 2111466.3623599997 | 37.7781645006636 | -122.41412064163201 | (37.7781645006636, -122.414120641632) | |||
| 113764 | 113764 | 31646 | Permitted Site 1 | Tree(s) :: 17 | 4500 Ulloa St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/13/2009 12:00:00 AM | 3x3 | Permit Number 52054 | 5982086.63822537 | 2098111.49533937 | 37.7399764418309 | -122.504526837106 | (37.7399764418309, -122.504526837106) | ||
| 117877 | 117877 | 112570 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 162 GRAND VIEW AVE | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6000754.0 | 2103380.0 | 37.7555228430156 | -122.440360729392 | (37.7555228430156, -122.440360729392) | ||||
| 117945 | 117945 | 104498 | Permitted Site 1 | Chionanthus retusa :: Chinese Fringe Tree 526 | 26 Allston Way | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/11/2013 12:00:00 AM | 3x3 | Permit Number 770732 | 5994373.7 | 2098352.0 | 37.741351881225704 | -122.46206101169201 | (37.7413518812257, -122.462061011692) |
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");