Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10201 | 10201 | 173901 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 4201x Lincoln Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5x5 | |||||||||
| 14347 | 14347 | 87020 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 10 Osceola Dr | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49949 | ||||||||
| 99448 | 99448 | 116072 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 388 POLARIS WAY | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6000586.0 | 2086414.0 | 37.70892857908329 | -122.439725431133 | (37.7089285790833, -122.439725431133) | ||||
| 101229 | 101229 | 85273 | Permitted Site 1 | Tree(s) :: 17 | 36 Santa Cruz Ave | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 5993017.1 | 2086630.8 | 37.709090137513 | -122.465900153218 | (37.709090137513, -122.465900153218) | ||||||
| 77951 | 77951 | 99580 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 650X Brunswick St | 20 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.44669908653499 | (37.710155688278, -122.446699086535) | |||
| 101382 | 101382 | 108685 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 301X CHESTER AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 5991720.0 | 2087146.0 | 37.7104298409998 | -122.47042057923099 | (37.7104298409998, -122.470420579231) | ||||
| 10627 | 10627 | 1283 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 3995X Alemany Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 10x10 | 5992081.50866 | 2087171.0422099999 | 37.710519496741206 | -122.469172961285 | (37.7105194967412, -122.469172961285) | |||
| 79808 | 79808 | 37377 | Permitted Site 1 | Shrub :: Shrub 98 | 755 Morse St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 2 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 84241 | 84241 | 37371 | Permitted Site 1 | Shrub :: Shrub 98 | 755 Morse St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 2 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 84675 | 84675 | 37375 | Permitted Site 1 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 755 Morse St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 3 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 101108 | 101108 | 37381 | Permitted Site 1 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 755 Morse St | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 3 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 102673 | 102673 | 37386 | Permitted Site 1 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 755 Morse St | 20 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 3 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 107719 | 107719 | 37383 | Permitted Site 1 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 755 Morse St | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 3 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 111807 | 111807 | 37385 | Permitted Site 1 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 755 Morse St | 19 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 3 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 125659 | 125659 | 37373 | Permitted Site 1 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 755 Morse St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 3 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 139023 | 139023 | 37379 | Permitted Site 1 | Shrub :: Shrub 98 | 755 Morse St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 2 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 11052 | 11052 | 1284 | Significant Tree 6 | Acer buergeranum :: Trident Maple 120 | 3995X Alemany Blvd | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 3X10 | Permit Number 778829 | 5992111.480830001 | 2087185.8440900003 | 37.7105618710011 | -122.469070448459 | (37.7105618710011, -122.469070448459) | ||
| 9985 | 9985 | 120925 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 9986 | 9986 | 1263 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/02/1998 12:00:00 AM | 10 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |
| 9994 | 9994 | 120923 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 9998 | 9998 | 120931 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 14 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 9999 | 9999 | 120922 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 10006 | 10006 | 120927 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 10015 | 10015 | 120928 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 10021 | 10021 | 120935 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 18 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 74397 | 74397 | 120924 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 3995X Alemany Blvd | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | ||||
| 79421 | 79421 | 120930 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | ||||
| 84748 | 84748 | 120926 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 3995X Alemany Blvd | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | ||||
| 100341 | 100341 | 120932 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 3995X Alemany Blvd | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | ||||
| 115407 | 115407 | 120934 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 3995X Alemany Blvd | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | ||||
| 116287 | 116287 | 120933 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 3995X Alemany Blvd | 16 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | ||||
| 118149 | 118149 | 120936 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 3995X Alemany Blvd | 19 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | ||||
| 119867 | 119867 | 120929 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 3995X Alemany Blvd | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | ||||
| 120789 | 120789 | 120921 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 3995X Alemany Blvd | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | ||||
| 22894 | 22894 | 206842 | Significant Tree 6 | Tree(s) :: 17 | 218 Sadowa St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/13/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779008 | 5994803.1874 | 2087784.4983 | 37.712360795684 | -122.45981072288001 | (37.712360795684, -122.45981072288) | |
| 22897 | 22897 | 215094 | Significant Tree 6 | Tree(s) :: 17 | 218 Sadowa St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/13/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779008 | 5994821.63014 | 2087784.2030900002 | 37.7123610457095 | -122.45974695827199 | (37.7123610457095, -122.459746958272) | |
| 110973 | 110973 | 106962 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 218 SADOWA ST | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 22 | 5994814.0 | 2087793.9 | 37.7123872323548 | -122.459774032106 | (37.7123872323548, -122.459774032106) | ||||
| 10019 | 10019 | 173629 | Significant Tree 6 | Tibochina urvilleana :: Princess Flower 260 | 10X Junipero Serra Blvd Off Ramp | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779383 | 5991168.0 | 2088425.0 | 37.713909732222 | -122.472421570074 | (37.713909732222, -122.472421570074) | |
| 140493 | 140493 | 115828 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 65 CHUMASERO DR | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | 5991168.0 | 2088425.0 | 37.713909732222 | -122.472421570074 | (37.713909732222, -122.472421570074) | ||
| 93028 | 93028 | 115827 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 60X CHUMASERO DR | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777531 | 5990913.0 | 2088468.0 | 37.714013037331 | -122.473306070941 | (37.714013037331, -122.473306070941) | |
| 4673 | 4673 | 253651 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 131 Font Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5990844.0 | 2088883.0 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | ||||
| 10089 | 10089 | 173834 | Undocumented 2 | Privet :: 262 | 37 Tucker Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6010894.0 | 2088503.0 | 37.7152458914151 | -122.404246253618 | (37.7152458914151, -122.404246253618) | |||||
| 62736 | 62736 | 92146 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 728 Jamestown Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52458 | 6015302.1 | 2088427.9 | 37.715285014192204 | -122.389004565667 | (37.7152850141922, -122.389004565667) | ||
| 11285 | 11285 | 83683 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 215 Dublin St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52308 | 6004110.69577 | 2089162.29942 | 37.716674810270206 | -122.42773926378 | (37.7166748102702, -122.42773926378) | |
| 10590 | 10590 | 82568 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 215 Dublin St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52308 | 6004119.416680001 | 2089176.12127 | 37.7167132553824 | -122.427710104164 | (37.7167132553824, -122.427710104164) | |
| 10128 | 10128 | 173868 | Permitted Site 1 | :: 54 | 808 Capitol Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/31/2017 12:00:00 AM | 3 | 5995075.959430001 | 2089664.9067799998 | 37.717539636984206 | -122.45900401383601 | (37.7175396369842, -122.459004013836) | |||
| 10139 | 10139 | 173867 | Permitted Site 1 | :: 54 | 808 Capitol Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/31/2017 12:00:00 AM | 3 | 5995075.959430001 | 2089664.9067799998 | 37.717539636984206 | -122.45900401383601 | (37.7175396369842, -122.459004013836) | |||
| 97877 | 97877 | 121418 | Private 5 | Juniperus californica :: California juniper 226 | 521 Lakeview Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 3x3 | 5996348.0 | 2089857.0 | 37.718140121256106 | -122.45462104638399 | (37.7181401212561, -122.454621046384) | ||||
| 90554 | 90554 | 114400 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1X HIGUERA AVE | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 22 | 3x3 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | |||
| 36317 | 36317 | 108395 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 311 Ordway St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 2 | 3x3 | 6011028.372719999 | 2090050.89786 | 37.7195036115824 | -122.403890660433 | (37.7195036115824, -122.403890660433) | ||
| 78524 | 78524 | 47338 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 399X Vernon St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45267 | 5992467.59204583 | 2090467.76074352 | 37.7195937916744 | -122.468078236027 | (37.7195937916744, -122.468078236027) | ||
| 80317 | 80317 | 47339 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 399 Vernon St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45267 | 5992467.59204583 | 2090467.76074352 | 37.7195937916744 | -122.468078236027 | (37.7195937916744, -122.468078236027) | ||
| 92211 | 92211 | 47340 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 399X Vernon St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45267 | 5992467.59204583 | 2090467.76074352 | 37.7195937916744 | -122.468078236027 | (37.7195937916744, -122.468078236027) | ||
| 50102 | 50102 | 94943 | Significant Tree 6 | Pyrus pyrifolia '20th Century' :: Asian Pear '20th Century' 417 | 2525 Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.719615759266205 | -122.38561332473999 | (37.7196157592662, -122.38561332474) | ||||
| 88058 | 88058 | 94937 | Significant Tree 6 | Malus 'Gala' :: Apple Tree 'Gala' 498 | 2525 Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.719615759266205 | -122.38561332473999 | (37.7196157592662, -122.38561332474) | ||||
| 96189 | 96189 | 94940 | Significant Tree 6 | Morus alba :: White Mulberry 112 | 2525 Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.719615759266205 | -122.38561332473999 | (37.7196157592662, -122.38561332474) | ||||
| 111560 | 111560 | 94941 | Significant Tree 6 | Morus alba :: White Mulberry 112 | 2525 Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.719615759266205 | -122.38561332473999 | (37.7196157592662, -122.38561332474) | ||||
| 111884 | 111884 | 94939 | Significant Tree 6 | Morus alba :: White Mulberry 112 | 2525 Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.719615759266205 | -122.38561332473999 | (37.7196157592662, -122.38561332474) | ||||
| 112975 | 112975 | 94938 | Significant Tree 6 | Malus 'Gala' :: Apple Tree 'Gala' 498 | 2525 Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.719615759266205 | -122.38561332473999 | (37.7196157592662, -122.38561332474) | ||||
| 139320 | 139320 | 94936 | Significant Tree 6 | Malus 'Gala' :: Apple Tree 'Gala' 498 | 2525 Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.719615759266205 | -122.38561332473999 | (37.7196157592662, -122.38561332474) | ||||
| 144144 | 144144 | 94944 | Significant Tree 6 | Pyrus pyrifolia 'Sainseiki' :: Asian Pear 'Sainseiki' 540 | 2525 Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.719615759266205 | -122.38561332473999 | (37.7196157592662, -122.38561332474) | ||||
| 144883 | 144883 | 94942 | Significant Tree 6 | Pyrus pyrifolia '20th Century' :: Asian Pear '20th Century' 417 | 2525 Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.719615759266205 | -122.38561332473999 | (37.7196157592662, -122.38561332474) | ||||
| 19054 | 19054 | 94934 | Significant Tree 6 | Ficus carica 'Black Mission' :: Black Mission Fig 311 | 2451X Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.38719408923599 | (37.7197277910807, -122.387194089236) | ||||
| 81078 | 81078 | 94935 | Significant Tree 6 | Ficus carica 'Brown Turkey' :: Brown Turkey Fig 469 | 2451X Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.38719408923599 | (37.7197277910807, -122.387194089236) | ||||
| 141804 | 141804 | 96996 | Significant Tree 6 | Malus :: Crab Apple 235 | 2451X Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.38719408923599 | (37.7197277910807, -122.387194089236) | |||||
| 143629 | 143629 | 96998 | Significant Tree 6 | Prunus spp :: Cherry 84 | 2451X Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.38719408923599 | (37.7197277910807, -122.387194089236) | |||||
| 12769 | 12769 | 17578 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3x3 | 6003799.63122 | 2090323.6743700001 | 37.7198460905006 | -122.428897210135 | (37.7198460905006, -122.428897210135) | |||
| 10957 | 10957 | 17580 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3x3 | 6003780.63082 | 2090335.5596900003 | 37.719877649504205 | -122.428963734788 | (37.7198776495042, -122.428963734788) | |||
| 2661 | 2661 | 37833 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 20 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003832.66245 | 2090342.4611400003 | 37.719899544415604 | -122.428784371324 | (37.7198995444156, -122.428784371324) |
| 11152 | 11152 | 17582 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3x3 | 6003762.13068 | 2090345.22062 | 37.7199031291015 | -122.42902837176202 | (37.7199031291015, -122.429028371762) | |||
| 83253 | 83253 | 98082 | Significant Tree 6 | Pinus Spp :: Pine Spp 105 | 525 Grafton Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5995193.7 | 2090526.9 | 37.7199132334677 | -122.45865940878001 | (37.7199132334677, -122.45865940878) | |||||
| 12305 | 12305 | 17584 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3x3 | 6003740.32149 | 2090358.06458 | 37.7199371612464 | -122.42910467385201 | (37.7199371612464, -122.429104673852) | |||
| 12852 | 12852 | 17587 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 35 | 3X3 | 6003703.481380001 | 2090378.19842 | 37.7199903588363 | -122.42923345225901 | (37.7199903588363, -122.429233452259) | |||
| 2638 | 2638 | 37832 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 19 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/22/2006 12:00:00 AM | 3 | 3x3 | Permit Number 48867 | 6003860.1558 | 2090386.44981 | 37.7200218836872 | -122.42869247048 | (37.7200218836872, -122.42869247048) |
| 11319 | 11319 | 17589 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3x3 | 6003683.23846 | 2090394.91559 | 37.720035114503006 | -122.42930461652 | (37.720035114503, -122.42930461652) | |||
| 11996 | 11996 | 17591 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 30 | 3x3 | 6003659.63671 | 2090407.2266799998 | 37.7200675818369 | -122.42938707716299 | (37.7200675818369, -122.429387077163) | |||
| 2660 | 2660 | 37827 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 450X Moscow St | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003888.33038 | 2090432.03853 | 37.7201486548235 | -122.428598328547 | (37.7201486548235, -122.428598328547) |
| 4355 | 4355 | 37822 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 450X Moscow St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/11/2017 09:46:00 AM | 3 | 3x3 | Permit Number 40134 | 6003933.77466 | 2090481.79158 | 37.7202878374987 | -122.428444787301 | (37.7202878374987, -122.428444787301) |
| 2652 | 2652 | 37819 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 450X Moscow St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003953.55423 | 2090513.34715 | 37.7203756014419 | -122.428378663762 | (37.7203756014419, -122.428378663762) |
| 2643 | 2643 | 37817 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 450X Moscow St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003961.27408 | 2090526.1025099999 | 37.7204110616965 | -122.428352887393 | (37.7204110616965, -122.428352887393) |
| 4367 | 4367 | 253150 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 450X Moscow St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/11/2017 09:41:00 AM | 3 | 3x3 | 6003965.721940001 | 2090553.1315400002 | 37.7204855291627 | -122.42833943800899 | (37.7204855291627, -122.428339438009) | |
| 12958 | 12958 | 37815 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003965.721940001 | 2090553.1315400002 | 37.7204855291627 | -122.42833943800899 | (37.7204855291627, -122.428339438009) |
| 102637 | 102637 | 107643 | DPW Maintained 3 | Tree(s) :: 17 | 455 ATHENS ST | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 4x4 | 6003769.0 | 2090659.8 | 37.720767283734105 | -122.429027043999 | (37.7207672837341, -122.429027043999) | ||||
| 93136 | 93136 | 37837 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 23 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003752.0 | 2090699.0 | 37.720873955994 | -122.42908860130501 | (37.720873955994, -122.429088601305) |
| 96417 | 96417 | 37825 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003752.0 | 2090699.0 | 37.720873955994 | -122.42908860130501 | (37.720873955994, -122.429088601305) |
| 139322 | 139322 | 37829 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 16 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003752.0 | 2090699.0 | 37.720873955994 | -122.42908860130501 | (37.720873955994, -122.429088601305) |
| 142748 | 142748 | 37835 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 21 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003752.0 | 2090699.0 | 37.720873955994 | -122.42908860130501 | (37.720873955994, -122.429088601305) |
| 111731 | 111731 | 122636 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 3698X 19th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5990586.0 | 2091171.0 | 37.7214158684235 | -122.474633449984 | (37.7214158684235, -122.474633449984) | ||||
| 88445 | 88445 | 122634 | Significant Tree 6 | Tree(s) :: 17 | 3680X 19th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/05/2016 12:00:00 AM | 3 | 3x10 | Permit Number 779220 | 5990592.0 | 2091224.0 | 37.7215617409212 | -122.474616575991 | (37.7215617409212, -122.474616575991) | |
| 125075 | 125075 | 53133 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 925 Holloway Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 08/19/2015 12:00:00 AM | Permit Number 774158 | 5994000.81776041 | 2091173.40830125 | 37.7216197566197 | -122.46282963525199 | (37.7216197566197, -122.462829635252) | ||
| 80965 | 80965 | 96878 | Permitted Site 1 | Tree(s) :: 17 | 2200X San Jose Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/30/2014 12:00:00 AM | Permit Number 773235 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | |||
| 82276 | 82276 | 96882 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2200X San Jose Ave | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | |||||
| 84624 | 84624 | 96883 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2200X San Jose Ave | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | |||||
| 86463 | 86463 | 96884 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2200X San Jose Ave | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | |||||
| 92219 | 92219 | 96879 | Permitted Site 1 | Tree(s) :: 17 | 2200X San Jose Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/30/2014 12:00:00 AM | Permit Number 773235 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | |||
| 96525 | 96525 | 96881 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2200X San Jose Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | |||||
| 102293 | 102293 | 96885 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2200X San Jose Ave | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | |||||
| 116057 | 116057 | 96347 | Permitted Site 1 | Tree(s) :: 17 | 2200X San Jose Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/30/2014 12:00:00 AM | Permit Number 773235 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | |||
| 84318 | 84318 | 114974 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 23 Holloway Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | Permit Number 775981 | 5996745.4 | 2091181.1 | 37.7217985747524 | -122.45334295571999 | (37.7217985747524, -122.45334295572) | |||
| 43480 | 43480 | 111380 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 301x OCEAN AVE | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW for City Agency 10 | MTA 10 | 24 | 3x3 | 5999454.0 | 2091552.0 | 37.7229718629586 | -122.44400669588998 | (37.7229718629586, -122.44400669589) |
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");