trees
688 rows where qLegalStatus_id = 6 and qSiteInfo = "Front Yard : Yard" sorted by Latitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
394 | 119605 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 299x Avalon Ave | 1 | Front Yard : Yard | Tree | Private 2 | |||||||||||||||
3171 | 119608 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 299x Avalon Ave | 4 | Front Yard : Yard | Tree | Private 2 | |||||||||||||||
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 | |||||||||||||||
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 | ||||||||||||
13805 | 119600 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 4357x Mission St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 774415 | ||||||||||||||
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 | ||||||||||||||
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 | ||||||||||||
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 | |
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 | |||||
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 | ||||
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 | ||
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 | |||||
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 | ||||
10661 | 114250 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 131 FONT BLVD | 1 | Front Yard : Yard | Tree | Private 2 | 36 | 5990844 | 2088883 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | 1 | 8 | 4 | 64 | 14 | ||||
28176 | 114157 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1200x JUNIPERO SERRA BLVD | 18 | Front Yard : Yard | Tree | Private 2 | 32 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
31451 | 114152 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 11 | Front Yard : Yard | Tree | Private 2 | 8 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
38864 | 114149 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 8 | Front Yard : Yard | Tree | Private 2 | 12 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
51852 | 114156 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1200x JUNIPERO SERRA BLVD | 17 | Front Yard : Yard | Tree | Private 2 | 32 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
54493 | 114150 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 9 | Front Yard : Yard | Tree | Private 2 | 12 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
64792 | 114144 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 1200x JUNIPERO SERRA BLVD | 1 | Front Yard : Yard | Tree | Private 2 | 10 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
69364 | 114151 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 10 | Front Yard : Yard | Tree | Private 2 | 8 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
72430 | 114147 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1200x JUNIPERO SERRA BLVD | 4 | Front Yard : Yard | Tree | Private 2 | 7 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
72767 | 114153 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1200x JUNIPERO SERRA BLVD | 12 | Front Yard : Yard | Tree | Private 2 | 40 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
74024 | 114155 | Significant Tree 6 | Pittosporum spp :: Pittosporum spp 170 | 1200X JUNIPERO SERRA BLVD | 16 | Front Yard : Yard | Tree | Private 2 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | |||||
91798 | 173615 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X JUNIPERO SERRA BLVD | 14 | Front Yard : Yard | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | |||
95053 | 114148 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 7 | Front Yard : Yard | Tree | Private 2 | 19 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
105349 | 114158 | Significant Tree 6 | Prunus armeniaca :: Apricot 296 | 1200X JUNIPERO SERRA BLVD | 6 | Front Yard : Yard | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | |||
145813 | 173616 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1200X JUNIPERO SERRA BLVD | 15 | Front Yard : Yard | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | |||
165218 | 114145 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 1200x JUNIPERO SERRA BLVD | 2 | Front Yard : Yard | Tree | Private 2 | 6 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
180735 | 114146 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 1200x JUNIPERO SERRA BLVD | 3 | Front Yard : Yard | Tree | Private 2 | 12 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
181284 | 114154 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200x JUNIPERO SERRA BLVD | 13 | Front Yard : Yard | Tree | Private 2 | 20 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
125248 | 106038 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 230 Lakeview Ave | Front Yard : Yard | Tree | Private 2 | Permit Number 772456 | 5997013.1 | 2089546.6 | 37.7173259605404 | -122.452299707743 | (37.7173259605404, -122.452299707743) | 9 | 8 | 6 | 28861 | 24 | |||||
105921 | 102569 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 0 Diaz Ave | 1 | Front Yard : Yard | Tree | Private 2 | 02/04/2013 12:00:00 AM | 2 | Permit Number 769785 | 5990053.95839 | 2089992.81974 | 37.7181500356804 | -122.476386530439 | (37.7181500356804, -122.476386530439) | 1 | 8 | 4 | 64 | 14 | ||
69013 | 254092 | Significant Tree 6 | Tree(s) :: 17 | 716 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 01/24/2018 12:00:00 AM | 3 | 10x10 | Permit Number 781051 | 5988732 | 2090042 | 37.7182083166364 | -122.480959519123 | (37.7182083166364, -122.480959519123) | 1 | 8 | 4 | 64 | 14 | |
114129 | 254093 | Significant Tree 6 | Tree(s) :: 17 | 716 Gonzalez Dr | 2 | Front Yard : Yard | Tree | Private 2 | 01/24/2018 12:00:00 AM | 3 | 10x10 | Permit Number 781051 | 5988732 | 2090042 | 37.7182083166364 | -122.480959519123 | (37.7182083166364, -122.480959519123) | 1 | 8 | 4 | 64 | 14 | |
115084 | 104751 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 13X JUAN BAUTISTA CIR | 2 | Front Yard : Yard | Tree | Private 2 | 5989494 | 2090180 | 37.7186314952818 | -122.47833572412 | (37.7186314952818, -122.47833572412) | 1 | 8 | 4 | 64 | 14 | |||||
71845 | 114379 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 443X ARBALLO DR | 1 | Front Yard : Yard | Tree | Private 2 | 36 | 5988110 | 2090275 | 37.7188118998372 | -122.483126550771 | (37.7188118998372, -122.483126550771) | 1 | 8 | 4 | 64 | 14 | ||||
124365 | 116951 | Significant Tree 6 | Araucaria heterophylla :: Norfolk Island Pine 238 | 299 Tara St | 1 | Front Yard : Yard | Tree | Private 2 | 5997754 | 2090179.6 | 37.7191064490611 | -122.449784366221 | (37.7191064490611, -122.449784366221) | 9 | 8 | 6 | 28861 | 24 | |||||
3313 | 262482 | Significant Tree 6 | Tree(s) :: 17 | 45 Delta St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6010254 | 2089941 | 37.7191585615903 | -122.406559656354 | (37.7191585615903, -122.406559656354) | 10 | 7 | 8 | 309 | 39 | ||||
149040 | 114068 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 8 HIGUERA AVE | 1 | Front Yard : Yard | Tree | Private 2 | 20 | 5987898 | 2090420 | 37.7191976939958 | -122.48386996767 | (37.7191976939958, -122.48386996767) | 1 | 8 | 4 | 64 | 14 | ||||
66594 | 114103 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 5 ACEVEDO AVE | 2 | Front Yard : Yard | Tree | Private 2 | 15 | 5987903 | 2090420 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | 1 | 8 | 4 | 64 | 14 | ||||
109420 | 114102 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 7 ACEVEDO AVE | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 5987903 | 2090420 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | 1 | 8 | 4 | 64 | 14 | ||||
58321 | 114094 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 239x VIDAL DR | 1 | Front Yard : Yard | Tree | Private 2 | 24 | 5987668 | 2090475 | 37.7193353179991 | -122.484669012602 | (37.7193353179991, -122.484669012602) | 1 | 8 | 4 | 64 | 14 | ||||
81276 | 114097 | Significant Tree 6 | Pinus thunbergii :: Japanese Black Pine 207 | 221x VIDAL DR | 1 | Front Yard : Yard | Tree | Private 2 | 14 | 5987664 | 2090556 | 37.7195574904968 | -122.484688777519 | (37.7195574904968, -122.484688777519) | 1 | 8 | 4 | 64 | 14 | ||||
127778 | 114100 | Significant Tree 6 | Betula pendula :: European White Birch 253 | 21x ACEVEDO AVE | 1 | Front Yard : Yard | Tree | Private 2 | 10 | 5988027 | 2090598 | 37.7196939458216 | -122.48343711114 | (37.7196939458216, -122.48343711114) | 1 | 8 | 4 | 64 | 14 | ||||
156777 | 114101 | Significant Tree 6 | Betula pendula :: European White Birch 253 | 21x ACEVEDO AVE | 2 | Front Yard : Yard | Tree | Private 2 | 7 | 5988027 | 2090598 | 37.7196939458216 | -122.48343711114 | (37.7196939458216, -122.48343711114) | 1 | 8 | 4 | 64 | 14 | ||||
76411 | 104900 | Significant Tree 6 | Betula pendula :: European White Birch 253 | 317 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
99854 | 104898 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 310 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
104010 | 104913 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 67 | 608 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
159155 | 104908 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 500 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
160583 | 104899 | Significant Tree 6 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 314 Gonzalez Dr | 2 | Front Yard : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
173819 | 104916 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 700 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
173820 | 104912 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 606 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
188942 | 104888 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 146 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
13301 | 114388 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 361x ARBALLO DR | 1 | Front Yard : Yard | Tree | Private 2 | 7 | 5988379 | 2090615 | 37.7197611043299 | -122.482221632222 | (37.7197611043299, -122.482221632222) | 1 | 8 | 4 | 64 | 14 | ||||
96414 | 114394 | Significant Tree 6 | Ficus Spp. :: 101 | 134x TAPIA DR | 1 | Front Yard : Yard | Tree | Private 2 | 28 | 5988379 | 2090615 | 37.7197611043299 | -122.482221632222 | (37.7197611043299, -122.482221632222) | 1 | 8 | 4 | 64 | 14 | ||||
152541 | 114384 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 418X SERRANO DR | 2 | Front Yard : Yard | Tree | Private 2 | 6 | 5988379 | 2090615 | 37.7197611043299 | -122.482221632222 | (37.7197611043299, -122.482221632222) | 1 | 8 | 4 | 64 | 14 | ||||
173894 | 114104 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 400x ARBALLO DR | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 3x3 | 5988116 | 2090625 | 37.7197732605649 | -122.48313145165 | (37.7197732605649, -122.48313145165) | 1 | 8 | 4 | 64 | 14 | |||
30556 | 104909 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 533 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
39757 | 104892 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 201 Gonzalez Dr | Front Yard : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | ||||||
55614 | 104904 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 417 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
26401 | 114389 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 345x ARBALLO DR | 1 | Front Yard : Yard | Tree | Private 2 | 8 | 5988176 | 2090635 | 37.7198042094326 | -122.48292478788 | (37.7198042094326, -122.48292478788) | 1 | 8 | 4 | 64 | 14 | ||||
125330 | 104932 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 717 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990427 | 2090598 | 37.7198333383806 | -122.475141254145 | (37.7198333383806, -122.475141254145) | 1 | 8 | 4 | 64 | 40 | |||||
181383 | 104933 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 755 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990427 | 2090598 | 37.7198333383806 | -122.475141254145 | (37.7198333383806, -122.475141254145) | 1 | 8 | 4 | 64 | 40 | |||||
9997 | 104935 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 835 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990419 | 2090610 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | 1 | 8 | 4 | 64 | 40 | |||||
113390 | 104936 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 837 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990419 | 2090610 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | 1 | 8 | 4 | 64 | 40 | |||||
126137 | 104937 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 839 Gonzalez Dr | 2 | Front Yard : Yard | Tree | Private 2 | 5990419 | 2090610 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | 1 | 8 | 4 | 64 | 40 | |||||
138477 | 104934 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 805 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990419 | 2090610 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | 1 | 8 | 4 | 64 | 40 | |||||
98635 | 105649 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990274.6 | 2090665.2 | 37.7200090188364 | -122.475672946469 | (37.7200090188364, -122.475672946469) | 1 | 8 | 4 | 64 | 14 | |||||
39382 | 114391 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 23x PINTO AVE | 2 | Front Yard : Yard | Tree | Private 2 | 7 | 5988521 | 2090808 | 37.7202992922588 | -122.481744923362 | (37.7202992922588, -122.481744923362) | 1 | 8 | 4 | 64 | 14 | ||||
78664 | 114390 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 23x PINTO AVE | 1 | Front Yard : Yard | Tree | Private 2 | 7 | 5988521 | 2090808 | 37.7202992922588 | -122.481744923362 | (37.7202992922588, -122.481744923362) | 1 | 8 | 4 | 64 | 14 | ||||
184580 | 114393 | Significant Tree 6 | Ficus Spp. :: 101 | 118x TAPIA DR | 1 | Front Yard : Yard | Tree | Private 2 | 36 | 5988638 | 2090878 | 37.7204982977387 | -122.481345621141 | (37.7204982977387, -122.481345621141) | 1 | 8 | 4 | 64 | 14 | ||||
50522 | 93931 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | Front Yard : Yard | Tree | Private 2 | 04/28/2010 12:00:00 AM | Permit Number 53387 | 5990375.96797 | 2090932.55284 | 37.7207489795508 | -122.475342064841 | (37.7207489795508, -122.475342064841) | 1 | 8 | 4 | 64 | 14 | |||||
105498 | 93932 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | Front Yard : Yard | Tree | Private 2 | 04/28/2010 12:00:00 AM | Permit Number 53387 | 5990375.96797 | 2090932.55284 | 37.7207489795508 | -122.475342064841 | (37.7207489795508, -122.475342064841) | 1 | 8 | 4 | 64 | 14 | |||||
58651 | 100191 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1201 Holloway Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5992431.5 | 2091178.1 | 37.7215421255294 | -122.468254640211 | (37.7215421255294, -122.468254640211) | 9 | 8 | 6 | 64 | 24 | |||||
157806 | 95777 | Significant Tree 6 | Acer palmatum 'Sango Kaku' :: Coral Bark Maple 550 | 30 Onondaga Ave | Front Yard : Yard | Tree | Private 2 | 03/11/2011 12:00:00 AM | Permit Number 767524 | 6001190.6 | 2091111.6 | 37.7218615356817 | -122.437972107548 | (37.7218615356817, -122.437972107548) | 9 | 7 | 6 | 28861 | 25 | ||||
10947 | 94850 | Significant Tree 6 | Tree(s) :: 17 | 1107 Bowdoin St | 1 | Front Yard : Yard | Tree | Private 2 | 11/17/2010 12:00:00 AM | Permit Number 53929 | 6009593 | 2091048 | 37.7221611506882 | -122.408922553301 | (37.7221611506882, -122.408922553301) | 10 | 3 | 7 | 309 | 28 | |||
107957 | 94851 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1107 Bowdoin St | 2 | Front Yard : Yard | Tree | Private 2 | 11/17/2010 12:00:00 AM | 12 | Permit Number 774691 | 6009593 | 2091048 | 37.7221611506882 | -122.408922553301 | (37.7221611506882, -122.408922553301) | 10 | 3 | 7 | 309 | 28 | ||
75453 | 100529 | Significant Tree 6 | Tree(s) :: 17 | 720 Victoria St | 1 | Front Yard : Yard | Tree | Private 2 | 09/24/2012 12:00:00 AM | Permit Number 769203 | 5993611.6 | 2091925.6 | 37.723662667106 | -122.464229627127 | (37.723662667106, -122.464229627127) | 9 | 8 | 4 | 59 | 40 | |||
154838 | 102479 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 760 Victoria St | 5 | Front Yard : Yard | Tree | Private 2 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | 9 | 8 | 4 | 59 | 40 | |||||
155948 | 102478 | Significant Tree 6 | Afrocarpus gracilior :: Fern Pine 89 | 760 Victoria St | 4 | Front Yard : Yard | Tree | Private 2 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | 9 | 8 | 4 | 59 | 40 | |||||
3682 | 261986 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1500 Bancroft Ave | 3 | Front Yard : Yard | Tree | Private 2 | 6014696 | 2091834 | 37.7246038778524 | -122.391337493735 | (37.7246038778524, -122.391337493735) | 10 | 3 | 8 | 58 | 1 | |||||
12244 | 261985 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1500x Bancroft Ave | Front Yard : Yard | Tree | Private 2 | 6014696 | 2091834 | 37.7246038778524 | -122.391337493735 | (37.7246038778524, -122.391337493735) | 10 | 3 | 8 | 58 | 1 | ||||||
28198 | 106364 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 155 BORICA ST | 1 | Front Yard : Yard | Tree | Private 2 | 5992696 | 2092292.5 | 37.7246172684066 | -122.467421338179 | (37.7246172684066, -122.467421338179) | 9 | 8 | 4 | 59 | 40 | |||||
821 | 261708 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 20 Entrada Ct | 1 | Front Yard : Yard | Tree | Private 2 | 02/21/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783258 | 5992481.8221 | 2092418.55282 | 37.724951011222 | -122.468170882637 | (37.724951011222, -122.468170882637) | 9 | 8 | 4 | 59 | 40 | |
12273 | 261709 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 20 Entrada Ct | 2 | Front Yard : Yard | Tree | Private 2 | 02/21/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783258 | 5992481.8221 | 2092418.55282 | 37.724951011222 | -122.468170882637 | (37.724951011222, -122.468170882637) | 9 | 8 | 4 | 59 | 40 |
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) );