Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, PlantType, qCareAssistant
qCaretaker ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
86 | 86 | 119601 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 34 | 4357x Mission St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 774415 | |||||||||
272 | 272 | 251264 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
277 | 277 | 251265 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
293 | 293 | 251262 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
300 | 300 | 251263 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
363 | 363 | 119608 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 34 | 299x Avalon Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
595 | 595 | 119606 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 299x Avalon Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
2196 | 2196 | 119600 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 34 | 4357x Mission St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 774415 | |||||||||
4747 | 4747 | 253677 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 199X Kissling St | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 5x10 | |||||||||
7681 | 7681 | 103657 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 1 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
7809 | 7809 | 119599 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 34 | 4357x Mission St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 774415 | |||||||||
7810 | 7810 | 119607 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 299x Avalon Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
7834 | 7834 | 119605 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 299x Avalon Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
8197 | 8197 | 103668 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 6 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
9148 | 9148 | 85030 | Significant Tree 6 | Tree(s) :: 17 | 411 Panama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2007 12:00:00 AM | Permit Number 49384 | ||||||||
11212 | 11212 | 103658 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 2 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
12113 | 12113 | 103660 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 4 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
12885 | 12885 | 103661 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 5 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
15949 | 15949 | 103659 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 3 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
16097 | 16097 | 104813 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1601X Portola Dr | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
22866 | 22866 | 251139 | Significant Tree 6 | Tree(s) :: 17 | 621X Gough St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 03/10/2017 12:00:00 AM | 3 | Permit Number 779685 | |||||||
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) | ||||
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) | |||
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) | ||||
78769 | 78769 | 116833 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1750 Geneva Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849363998 | (37.710864341935, -122.42616849364) | |||||
81752 | 81752 | 116834 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1750 Geneva Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849363998 | (37.710864341935, -122.42616849364) | |||||
95921 | 95921 | 116835 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1750 Geneva Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849363998 | (37.710864341935, -122.42616849364) | |||||
110125 | 110125 | 116836 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1750 Geneva Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849363998 | (37.710864341935, -122.42616849364) | |||||
114433 | 114433 | 116837 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1750 Geneva Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849363998 | (37.710864341935, -122.42616849364) | |||||
89334 | 89334 | 116094 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | ||||
92450 | 92450 | 116095 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | ||||
106195 | 106195 | 116091 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | |||
114742 | 114742 | 116093 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | ||||
118020 | 118020 | 116097 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | ||||
119705 | 119705 | 116096 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | ||||
144536 | 144536 | 116092 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | ||||
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) | ||||
107838 | 107838 | 104193 | Significant Tree 6 | Calocedrus decurrens :: Incense Cedar 177 | 122 Arch St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992720.4 | 2088013.1 | 37.712868482575104 | -122.467026013031 | (37.7128684825751, -122.467026013031) | |||||
91767 | 91767 | 104749 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1X Junipero Serra Blvd Off Ramp | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770709 | 5991326.15861 | 2088181.65405 | 37.7132507161795 | -122.47185719553998 | (37.7132507161795, -122.47185719554) | ||||
113067 | 113067 | 104750 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1X Junipero Serra Blvd Off Ramp | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | Permit Number 770709 | 5991326.15861 | 2088181.65405 | 37.7132507161795 | -122.47185719553998 | (37.7132507161795, -122.47185719554) | ||
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) | |
125954 | 125954 | 114239 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 1300x JUNIPERO SERRA BLVD | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | 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) | |
145474 | 145474 | 114257 | Significant Tree 6 | Leptospermum quinquenervia :: Tea Tree 151 | 50x CHUMASERO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990913.0 | 2088468.0 | 37.714013037331 | -122.473306070941 | (37.714013037331, -122.473306070941) | |||||
10991 | 10991 | 116458 | Significant Tree 6 | Eucalyptus lehmanni :: Bushy Yate 267 | 777 Brotherhood Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 10x20 | 5989819.39068 | 2088633.8654 | 37.7144050769972 | -122.477098071327 | (37.7144050769972, -122.477098071327) | |||
11055 | 11055 | 116459 | Significant Tree 6 | Eucalyptus lehmanni :: Bushy Yate 267 | 777 Brotherhood Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 10x20 | Permit Number 777772 | 5989848.42836 | 2088633.8329099999 | 37.7144066723949 | -122.476997704287 | (37.7144066723949, -122.476997704287) | ||
49231 | 49231 | 114226 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
79797 | 79797 | 114240 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 99x FONT BLVD | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | |||||
80545 | 80545 | 114228 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
86013 | 86013 | 114235 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
105010 | 105010 | 114230 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
105245 | 105245 | 114225 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 99x FONT BLVD | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 48 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
105541 | 105541 | 114227 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
112189 | 112189 | 114231 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
117729 | 117729 | 114237 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
125709 | 125709 | 114234 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
128194 | 128194 | 114232 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
128290 | 128290 | 114229 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
138891 | 138891 | 114238 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
139193 | 139193 | 114233 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
139478 | 139478 | 114236 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
11071 | 11071 | 113042 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 500 Raymond Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/06/2015 12:00:00 AM | 30 | 3x3 | 6008233.879509999 | 2088473.9314700002 | 37.715017072864796 | -122.413438766187 | (37.7150170728648, -122.413438766187) | ||
4659 | 4659 | 253652 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 131 Font Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x10 | 5990844.0 | 2088883.0 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | ||||
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) | ||||
123839 | 123839 | 114250 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 131 FONT BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 5990844.0 | 2088883.0 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | ||||
113606 | 113606 | 111093 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 100x FONT BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2015 12:00:00 AM | 50 | 3x3 | Permit Number 775594 | 5990916.0 | 2088996.0 | 37.715462969911 | -122.473334188491 | (37.715462969911, -122.473334188491) | |
94747 | 94747 | 114034 | Significant Tree 6 | Ulmus pumila :: Siberian Elm 53 | 198x FONT BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3x3 | 5990818.0 | 2089012.0 | 37.7155012267577 | -122.473674083302 | (37.7155012267577, -122.473674083302) | |||
18835 | 18835 | 114526 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1 TIOGA AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6011351.0 | 2088602.0 | 37.715543251319204 | -122.402673611341 | (37.7155432513192, -122.402673611341) | |||||
88169 | 88169 | 114525 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1 TIOGA AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6011351.0 | 2088602.0 | 37.715543251319204 | -122.402673611341 | (37.7155432513192, -122.402673611341) | |||||
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) | |||
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) | ||||
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) | ||||
125242 | 125242 | 111094 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 150x FONT BLVD | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2015 12:00:00 AM | 30 | 3x3 | Permit Number 775594 | 5990976.0 | 2089133.0 | 37.715842612516106 | -122.473136789074 | (37.7158426125161, -122.473136789074) | ||
3843 | 3843 | 253568 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 301X Sargent St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5993018.0 | 2089140.0 | 37.7159798527116 | -122.46607925705901 | (37.7159798527116, -122.466079257059) | ||||
123361 | 123361 | 117295 | Significant Tree 6 | Tree(s) :: 17 | 130 CAMBON DR | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x3 | 5990450.0 | 2089482.0 | 37.7167704112637 | -122.47498033116501 | (37.7167704112637, -122.474980331165) | ||||
9641 | 9641 | 114157 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200x JUNIPERO SERRA BLVD | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
9643 | 9643 | 114152 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
9644 | 9644 | 114150 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
9647 | 9647 | 114149 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
9651 | 9651 | 114156 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200x JUNIPERO SERRA BLVD | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
9655 | 9655 | 114155 | Significant Tree 6 | Pittosporum spp :: Pittosporum spp 128 | 1200X JUNIPERO SERRA BLVD | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) |
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");