trees
1,732 rows where qLegalStatus_id = 6 sorted by YCoord
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
84 | 254457 | Significant Tree 6 | Dodonaea viscosa :: Hop Bush 43 | 1055X Duncan St | 2 | Side Yard : Yard | Tree | Private 2 | |||||||||||||||
394 | 119605 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 299x Avalon Ave | 1 | Front Yard : Yard | Tree | Private 2 | |||||||||||||||
1051 | 251262 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3630x 19th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 779147 | ||||||||||||||
2100 | 253677 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 35 | 199X Kissling St | 1 | Side Yard : Cutout | Tree | Private 2 | 5x10 | ||||||||||||||
3171 | 119608 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 299x Avalon Ave | 4 | Front Yard : Yard | Tree | Private 2 | |||||||||||||||
3182 | 261252 | Significant Tree 6 | Banksia integrifolia :: Coast Banksia 21 | 100 Collins St | 1 | Front Yard : Cutout | Tree | Private 2 | 12/18/2019 12:00:00 AM | 3 | |||||||||||||
4934 | 103659 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 3 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
5510 | 104813 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1601X Portola Dr | 5 | Front Yard : Yard | Tree | Private 2 | |||||||||||||||
5622 | 251139 | Significant Tree 6 | Tree(s) :: 17 | 621X Gough St | 1 | Back Yard : Yard | Tree | Private 2 | 03/10/2017 12:00:00 AM | 3 | Permit Number 779685 | ||||||||||||
6834 | 103660 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 4 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
7039 | 119606 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 299x Avalon Ave | 2 | Front Yard : Yard | Tree | Private 2 | |||||||||||||||
7389 | 119599 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 4357x Mission St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 774415 | ||||||||||||||
7411 | 103658 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 2 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
8509 | 103668 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 6 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
8535 | 251265 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3630x 19th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 779147 | ||||||||||||||
11338 | 85030 | Significant Tree 6 | Tree(s) :: 17 | 411 Panama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2007 12:00:00 AM | Permit Number 49384 | |||||||||||||
13434 | 260582 | Significant Tree 6 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 2101X Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2019 12:00:00 AM | 3 | 5x5 | Permit Number 782628 | |||||||||||
13805 | 119600 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 4357x Mission St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 774415 | ||||||||||||||
14241 | 251264 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3630x 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 779147 | ||||||||||||||
14456 | 103661 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 5 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
15093 | 119607 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 299x Avalon Ave | 3 | Front Yard : Yard | Tree | Private 2 | |||||||||||||||
15289 | 119601 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 4357x Mission St | 3 | Front Yard : Yard | Tree | Private 2 | Permit Number 774415 | ||||||||||||||
15795 | 251263 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3630x 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 779147 | ||||||||||||||
16207 | 254459 | Significant Tree 6 | Tree(s) :: 17 | 1055X Duncan St | 4 | Side Yard : Yard | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | Permit Number 780800 | ||||||||||||
18988 | 103657 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 1 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
19367 | 254458 | Significant Tree 6 | Tree(s) :: 17 | 1055X Duncan St | 3 | Side Yard : Yard | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | Permit Number 780800 | ||||||||||||
19573 | 254456 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 1055X Duncan St | 1 | Side Yard : Yard | Tree | Private 2 | |||||||||||||||
127144 | 258338 | Significant Tree 6 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 209 Spear St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | |||||||||||||||
194363 | 265042 | Significant Tree 6 | Tree(s) :: 17 | 1000X Mandalay Ln | 2 | Unaccepted Street : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 10x010 | Permit Number 787936 | |||||||||||
106382 | 116072 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 388 POLARIS WAY | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6000586 | 2086414 | 37.7089285790833 | -122.439725431133 | (37.7089285790833, -122.439725431133) | 9 | 7 | 6 | 28861 | 5 | ||||
1377 | 262327 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 10X Sickles Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5996833 | 2086575 | 37.709156314989 | -122.452707876493 | (37.709156314989, -122.452707876493) | 9 | 7 | 6 | 28861 | 25 | ||||
1679 | 262328 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 10X Sickles Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5996833 | 2086575 | 37.709156314989 | -122.452707876493 | (37.709156314989, -122.452707876493) | 9 | 7 | 6 | 28861 | 25 | ||||
14780 | 262330 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 10X Sickles Ave | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5996833 | 2086575 | 37.709156314989 | -122.452707876493 | (37.709156314989, -122.452707876493) | 9 | 7 | 6 | 28861 | 25 | ||||
18601 | 262329 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 10X Sickles Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5996833 | 2086575 | 37.709156314989 | -122.452707876493 | (37.709156314989, -122.452707876493) | 9 | 7 | 6 | 28861 | 25 | ||||
4724 | 262586 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2 Byron Ct | 1 | Front Yard : Yard | Tree | Private 2 | 08/19/2020 12:00:00 AM | 3 | 8x8 | Permit Number 781313 | 5999459.72778 | 2086749.57445 | 37.7097858201455 | -122.443642066205 | (37.7097858201455, -122.443642066205) | 9 | 7 | 6 | 28861 | 5 | |
73440 | 116094 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 | ||||
80147 | 116095 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 | ||||
118842 | 116091 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 | |||
145439 | 116093 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 | ||||
154885 | 116096 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 | ||||
170444 | 116097 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 | ||||
177168 | 116092 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 | ||||
39795 | 116833 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1750 Geneva Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849364 | (37.710864341935, -122.42616849364) | 9 | 7 | 6 | 309 | 5 | |||||
47565 | 116834 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1750 Geneva Ave | 2 | Front Yard : Yard | Tree | Private 2 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849364 | (37.710864341935, -122.42616849364) | 9 | 7 | 6 | 309 | 5 | |||||
93840 | 116835 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1750 Geneva Ave | 3 | Front Yard : Yard | Tree | Private 2 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849364 | (37.710864341935, -122.42616849364) | 9 | 7 | 6 | 309 | 5 | |||||
127835 | 116836 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1750 Geneva Ave | 4 | Front Yard : Yard | Tree | Private 2 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849364 | (37.710864341935, -122.42616849364) | 9 | 7 | 6 | 309 | 5 | |||||
142462 | 116837 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1750 Geneva Ave | 5 | Front Yard : Yard | Tree | Private 2 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849364 | (37.710864341935, -122.42616849364) | 9 | 7 | 6 | 309 | 5 | |||||
34238 | 1283 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 3995X Alemany Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | 10x10 | 5992081.50866 | 2087171.04221 | 37.7105194967412 | -122.469172961285 | (37.7105194967412, -122.469172961285) | 9 | 8 | 4 | 64 | 24 | |||
69574 | 1284 | Significant Tree 6 | Acer buergeranum :: Trident Maple 110 | 3995X Alemany Blvd | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12 | 3X10 | Permit Number 778829 | 5992111.48083 | 2087185.84409 | 37.7105618710011 | -122.469070448459 | (37.7105618710011, -122.469070448459) | 9 | 8 | 4 | 64 | 24 | ||
22688 | 120924 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
47402 | 120930 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 13 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
50856 | 1263 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/02/1998 12:00:00 AM | 10 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |
51080 | 120925 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
60656 | 120926 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
73917 | 120923 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
81897 | 120931 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 14 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
94421 | 120922 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
109715 | 120932 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 15 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
124817 | 120927 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 10 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
136239 | 120933 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 16 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
145282 | 120934 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 17 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
156900 | 120929 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 12 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
162123 | 120936 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 19 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
162461 | 120921 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
171046 | 120928 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 11 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
178015 | 120935 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 18 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
15657 | 259657 | Significant Tree 6 | Tree(s) :: 17 | 132 Sagamore St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5995545 | 2087474 | 37.7115508726991 | -122.457224363425 | (37.7115508726991, -122.457224363425) | 9 | 8 | 6 | 28861 | 24 | ||||
181560 | 256493 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 400 Rolph St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6002004 | 2087744 | 37.7126610773499 | -122.434919679914 | (37.7126610773499, -122.434919679914) | 9 | 7 | 6 | 28861 | 5 | ||||
9908 | 215094 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 218 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779008 | 5994821.63014 | 2087784.20309 | 37.7123610457095 | -122.459746958272 | (37.7123610457095, -122.459746958272) | 9 | 8 | 6 | 28861 | 24 | |
81780 | 206842 | Significant Tree 6 | Tree(s) :: 17 | 218 Sadowa St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/13/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779008 | 5994803.1874 | 2087784.4983 | 37.712360795684 | -122.45981072288 | (37.712360795684, -122.45981072288) | 9 | 8 | 6 | 28861 | 24 | |
137083 | 106962 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 218 SADOWA ST | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 22 | 5994814 | 2087793.9 | 37.7123872323548 | -122.459774032106 | (37.7123872323548, -122.459774032106) | 9 | 8 | 6 | 28861 | 24 | ||||
142556 | 256880 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2701 Alemany Blvd | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | 5997600 | 2087902 | 37.7128438731446 | -122.450152604107 | (37.7128438731446, -122.450152604107) | 9 | 7 | 6 | 28861 | 25 | ||||
127076 | 104193 | Significant Tree 6 | Calocedrus decurrens :: Incense Cedar 206 | 122 Arch St | 1 | Front Yard : Yard | Tree | Private 2 | 5992720.4 | 2088013.1 | 37.7128684825751 | -122.467026013031 | (37.7128684825751, -122.467026013031) | 9 | 8 | 6 | 64 | 24 | |||||
93552 | 104749 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1X Junipero Serra Blvd Off Ramp | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770709 | 5991326.15861 | 2088181.65405 | 37.7132507161795 | -122.47185719554 | (37.7132507161795, -122.47185719554) | 1 | 8 | 4 | 64 | 14 | ||||
142019 | 104750 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1X Junipero Serra Blvd Off Ramp | 2 | Front Yard : Yard | Tree | Private 2 | 08/30/2016 12:00:00 AM | 3 | Permit Number 770709 | 5991326.15861 | 2088181.65405 | 37.7132507161795 | -122.47185719554 | (37.7132507161795, -122.47185719554) | 1 | 8 | 4 | 64 | 14 | ||
703 | 262210 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 2011 Bay Shore Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6012422 | 2088364 | 37.7149494891568 | -122.398955034798 | (37.7149494891568, -122.398955034798) | 10 | 3 | 8 | 309 | 1 | ||||
38129 | 114239 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 1300x JUNIPERO SERRA BLVD | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | 5991168 | 2088425 | 37.713909732222 | -122.472421570074 | (37.713909732222, -122.472421570074) | 1 | 8 | 4 | 64 | 14 | ||||
188169 | 173629 | Significant Tree 6 | Tibochina urvilleana :: Princess Flower 154 | 10X Junipero Serra Blvd Off Ramp | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779383 | 5991168 | 2088425 | 37.713909732222 | -122.472421570074 | (37.713909732222, -122.472421570074) | 1 | 8 | 4 | 64 | 14 | |
92919 | 115827 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 60X CHUMASERO DR | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777531 | 5990913 | 2088468 | 37.714013037331 | -122.473306070941 | (37.714013037331, -122.473306070941) | 1 | 8 | 4 | 64 | 14 | |
177784 | 114257 | Significant Tree 6 | Leptospermum quinquenervia :: Tea Tree 470 | 50x CHUMASERO DR | 1 | Front Yard : Yard | Tree | Private 2 | 5990913 | 2088468 | 37.714013037331 | -122.473306070941 | (37.714013037331, -122.473306070941) | 1 | 8 | 4 | 64 | 14 | |||||
69512 | 113042 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 500 Raymond Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 10/06/2015 12:00:00 AM | 30 | 3x3 | 6008233.87951 | 2088473.93147 | 37.7150170728648 | -122.413438766187 | (37.7150170728648, -122.413438766187) | 9 | 7 | 8 | 309 | 18 | ||
9862 | 114526 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 TIOGA AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6011351 | 2088602 | 37.7155432513192 | -122.402673611341 | (37.7155432513192, -122.402673611341) | 9 | 7 | 8 | 309 | 39 | |||||
59395 | 114525 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 TIOGA AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6011351 | 2088602 | 37.7155432513192 | -122.402673611341 | (37.7155432513192, -122.402673611341) | 9 | 7 | 8 | 309 | 39 | |||||
63542 | 116459 | Significant Tree 6 | Eucalyptus lehmanni :: Bushy Yate 260 | 777 Brotherhood Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 10x20 | Permit Number 777772 | 5989848.42836 | 2088633.83291 | 37.7144066723949 | -122.476997704287 | (37.7144066723949, -122.476997704287) | 1 | 8 | 4 | 64 | 14 | ||
51737 | 116458 | Significant Tree 6 | Eucalyptus lehmanni :: Bushy Yate 260 | 777 Brotherhood Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 10x20 | 5989819.39068 | 2088633.8654 | 37.7144050769972 | -122.477098071327 | (37.7144050769972, -122.477098071327) | 1 | 8 | 4 | 64 | 14 | |||
19388 | 114226 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
21577 | 114229 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
27121 | 114234 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
30455 | 114232 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
44052 | 114240 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 99x FONT BLVD | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | |||||
44804 | 114228 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
62078 | 114235 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
109646 | 114230 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
126287 | 114225 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 99x FONT BLVD | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 48 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
128045 | 114227 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
141272 | 114231 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
154745 | 114237 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
173544 | 114236 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
179418 | 114233 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
185977 | 114238 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );