trees
202 rows where qLegalStatus_id = 6 and qSiteInfo = "Sidewalk: Property side : Yard" sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17242 | 253971 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1401X Laguna St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6004485 | 2113711 | 37.784100995896 | -122.428194001884 | (37.784100995896, -122.428194001884) | 13 | 9 | 11 | 29490 | 41 | ||||
37092 | 254109 | Significant Tree 6 | Tree(s) :: 17 | 38X Starview Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 6x6 | Permit Number 781050 | 5997469 | 2101545 | 37.7502968010125 | -122.451588863361 | (37.7502968010125, -122.451588863361) | 1 | 5 | 4 | 63 | 38 | |
256 | 254254 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 45X Everglade Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
53875 | 254255 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 45X Everglade Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
139664 | 254256 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 45X Everglade Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
92424 | 254257 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 45X Everglade Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
144483 | 254258 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 45X Everglade Dr | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
19844 | 254259 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 45X Everglade Dr | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
151585 | 254728 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1940 Mission St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 0ft | 6006763.6807 | 2106952.0622 | 37.7656712394659 | -122.419830807079 | (37.7656712394659, -122.419830807079) | 8 | 4 | 7 | 28853 | 19 | ||||
33161 | 254729 | Significant Tree 6 | Cryptomeria japonica :: Japanese Cryptomeria 420 | 1940 Mission St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 0ft | 6006763.6807 | 2106952.0622 | 37.7656712394659 | -122.419830807079 | (37.7656712394659, -122.419830807079) | 8 | 4 | 7 | 28853 | 19 | ||||
139171 | 255246 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 209x Willow St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006475 | 2113325 | 37.7831535286214 | -122.421281886667 | (37.7831535286214, -122.421281886667) | 7 | 9 | 11 | 28858 | 41 | ||||
117546 | 255247 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 209x Willow St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006475 | 2113325 | 37.7831535286214 | -122.421281886667 | (37.7831535286214, -122.421281886667) | 7 | 9 | 11 | 28858 | 41 | ||||
36041 | 255248 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 209x Willow St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006475 | 2113325 | 37.7831535286214 | -122.421281886667 | (37.7831535286214, -122.421281886667) | 7 | 9 | 11 | 28858 | 41 | ||||
85142 | 255249 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 209x Willow St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006475 | 2113325 | 37.7831535286214 | -122.421281886667 | (37.7831535286214, -122.421281886667) | 7 | 9 | 11 | 28858 | 41 | ||||
177763 | 255250 | Significant Tree 6 | Dodonaea viscosa :: Hop Bush 43 | 209x Willow St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006475 | 2113325 | 37.7831535286214 | -122.421281886667 | (37.7831535286214, -122.421281886667) | 7 | 9 | 11 | 28858 | 41 | ||||
126646 | 255275 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 263 Willow St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 4ft | 6006404.75096 | 2113360.62408 | 37.7832473828943 | -122.421527451234 | (37.7832473828943, -122.421527451234) | 7 | 9 | 11 | 28858 | 41 | ||||
27012 | 255276 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 263 Willow St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 4ft | 6006404.75096 | 2113360.62408 | 37.7832473828943 | -122.421527451234 | (37.7832473828943, -122.421527451234) | 7 | 9 | 11 | 28858 | 41 | ||||
21449 | 255662 | Significant Tree 6 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 1626 Shrader St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x6 | Permit Number 782137 | 5998119 | 2105007 | 37.759839795982 | -122.44959056596 | (37.759839795982, -122.44959056596) | 15 | 5 | 11 | 29492 | 12 | |||
85388 | 255663 | Significant Tree 6 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 1626 Shrader St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x6 | Permit Number 782137 | 5998119 | 2105007 | 37.759839795982 | -122.44959056596 | (37.759839795982, -122.44959056596) | 15 | 5 | 11 | 29492 | 12 | |||
94582 | 256246 | Significant Tree 6 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 199x Clinton Park | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6005490 | 2108162 | 37.7689216043545 | -122.424322258789 | (37.7689216043545, -122.424322258789) | 8 | 4 | 5 | 28853 | 19 | ||||
48610 | 256247 | Significant Tree 6 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 199x Clinton Park | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6005490 | 2108162 | 37.7689216043545 | -122.424322258789 | (37.7689216043545, -122.424322258789) | 8 | 4 | 5 | 28853 | 19 | ||||
6691 | 256248 | Significant Tree 6 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 199x Clinton Park | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6005490 | 2108162 | 37.7689216043545 | -122.424322258789 | (37.7689216043545, -122.424322258789) | 8 | 4 | 5 | 28853 | 19 | ||||
37232 | 256765 | Significant Tree 6 | Tree(s) :: 17 | 355 Serrano Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/15/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782555 | 5988732 | 2090042 | 37.7182083166364 | -122.480959519123 | (37.7182083166364, -122.480959519123) | 1 | 8 | 4 | 64 | 14 | |
124269 | 256872 | Significant Tree 6 | Tree(s) :: 17 | 2401X Golden Gate Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/13/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782666 | 5997871 | 2111315 | 37.7771457625148 | -122.450903124986 | (37.7771457625148, -122.450903124986) | 15 | 6 | 2 | 29492 | 16 | |
101661 | 257928 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 101 Lombard St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 6ft | 6011760.21977 | 2120791.0173 | 37.8039499778675 | -122.403522505873 | (37.8039499778675, -122.403522505873) | 3 | 1 | 10 | 28860 | 6 | ||||
37143 | 257967 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499X Carl St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 5995946 | 2106884 | 37.7648690031923 | -122.457241646887 | (37.7648690031923, -122.457241646887) | 15 | 5 | 11 | 29492 | 12 | ||||
25777 | 257968 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499X Carl St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 5995946 | 2106884 | 37.7648690031923 | -122.457241646887 | (37.7648690031923, -122.457241646887) | 15 | 5 | 11 | 29492 | 12 | ||||
182332 | 258021 | Significant Tree 6 | Tree(s) :: 17 | 201x Gough St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006013 | 2110374 | 37.7750247439455 | -122.422670446803 | (37.7750247439455, -122.422670446803) | 7 | 9 | 11 | 28852 | 10 | ||||
135623 | 258062 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 567 Mississippi St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/02/2019 12:00:00 AM | 3 | 3x3 | 6014163 | 2104519 | 37.7594046471392 | -122.394067636073 | (37.7594046471392, -122.394067636073) | 10 | 3 | 8 | 28856 | 29 | ||
158154 | 258096 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 941 Mission St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/13/2019 12:00:00 AM | 3 | 3x3 | 6010493.2294 | 2112796.27211 | 37.7819274857178 | -122.407343084927 | (37.7819274857178, -122.407343084927) | 14 | 2 | 9 | 28853 | 34 | ||
124108 | 258218 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 1000 North Point St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6005937.91741 | 2121414.48699 | 37.8053349315385 | -122.423715341013 | (37.8053349315385, -122.423715341013) | 5 | 1 | 1 | 28858 | 32 | |||||
13663 | 258677 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 607 Congo St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 6000094 | 2095817 | 37.7347190533418 | -122.442100351643 | (37.7347190533418, -122.442100351643) | 9 | 7 | 4 | 63 | 40 | ||||
18957 | 259263 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
15055 | 259264 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3580X 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | ||||
6044 | 259265 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
17333 | 259266 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
11254 | 259267 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3580X 19th Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | ||||
1038 | 259268 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
9303 | 259269 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3580X 19th Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | ||||
748 | 259270 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
16309 | 259807 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
13096 | 259808 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
13753 | 259809 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
12030 | 259810 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
18707 | 259811 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
6612 | 259812 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
6413 | 259813 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
3287 | 259814 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
1467 | 259815 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
16536 | 259816 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
3205 | 259817 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
13203 | 259818 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
7698 | 259819 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
18661 | 259820 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
9200 | 259821 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
14819 | 259822 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
14961 | 259823 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
18171 | 260058 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 Larkin St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 3ft | 6007818.52804 | 2111871.98583 | 37.7792395550969 | -122.416530850318 | (37.7792395550969, -122.416530850318) | 7 | 9 | 9 | 28852 | 36 | ||||
8078 | 260059 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 Larkin St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 3ft | 6007818.52804 | 2111871.98583 | 37.7792395550969 | -122.416530850318 | (37.7792395550969, -122.416530850318) | 7 | 9 | 9 | 28852 | 36 | ||||
9215 | 260060 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 Larkin St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 3ft | 6007818.52804 | 2111871.98583 | 37.7792395550969 | -122.416530850318 | (37.7792395550969, -122.416530850318) | 7 | 9 | 9 | 28852 | 36 | ||||
4164 | 260061 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 Larkin St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 3ft | 6007818.52804 | 2111871.98583 | 37.7792395550969 | -122.416530850318 | (37.7792395550969, -122.416530850318) | 7 | 9 | 9 | 28852 | 36 | ||||
1002 | 260458 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 835 Darien Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/19/2019 12:00:00 AM | 3 | 6x10 | Permit Number 784514 | 5994066 | 2094094 | 37.7296427463027 | -122.462816092129 | (37.7296427463027, -122.462816092129) | 9 | 8 | 4 | 59 | 40 | |
9478 | 260514 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3025 22nd Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5989750.29916 | 2095052.76589 | 37.7320257582668 | -122.477805820702 | (37.7320257582668, -122.477805820702) | 1 | 8 | 4 | 64 | 35 | ||||
11391 | 260515 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 487 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | Permit Number 784711 | 5989595 | 2094714 | 37.7310865793073 | -122.478317956131 | (37.7310865793073, -122.478317956131) | 1 | 8 | 4 | 64 | 14 | |||
13972 | 260573 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 129 Edgehill Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5994858 | 2098970 | 37.7430766268484 | -122.460431252252 | (37.7430766268484, -122.460431252252) | 1 | 8 | 4 | 59 | 40 | ||||
4938 | 260583 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 397 05th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6012019 | 2111820 | 37.7793321462044 | -122.401995938922 | (37.7793321462044, -122.401995938922) | 6 | 2 | 9 | 28856 | 34 | ||||
6121 | 260584 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 397 05th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6012019 | 2111820 | 37.7793321462044 | -122.401995938922 | (37.7793321462044, -122.401995938922) | 6 | 2 | 9 | 28856 | 34 | ||||
684 | 260585 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 397 05th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6012019 | 2111820 | 37.7793321462044 | -122.401995938922 | (37.7793321462044, -122.401995938922) | 6 | 2 | 9 | 28856 | 34 | ||||
6111 | 260586 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 397 05th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6012019 | 2111820 | 37.7793321462044 | -122.401995938922 | (37.7793321462044, -122.401995938922) | 6 | 2 | 9 | 28856 | 34 | ||||
9510 | 260587 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 890x Harrison St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6012019 | 2111820 | 37.7793321462044 | -122.401995938922 | (37.7793321462044, -122.401995938922) | 6 | 2 | 9 | 28856 | 34 | ||||
1427 | 260648 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 3891 Sacramento St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 7ft | 5996301.11796 | 2114890.85877 | 37.7868741256738 | -122.456592467462 | (37.7868741256738, -122.456592467462) | 11 | 6 | 1 | 54 | 31 | ||||
4071 | 260649 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 3891 Sacramento St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 7ft | 5996301.11796 | 2114890.85877 | 37.7868741256738 | -122.456592467462 | (37.7868741256738, -122.456592467462) | 11 | 6 | 1 | 54 | 31 | ||||
13058 | 260903 | Significant Tree 6 | Taxus baccata :: Irish Yew 86 | 51 Shore View Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 4ft | 5984536 | 2112849 | 37.7805852728313 | -122.497145662996 | (37.7805852728313, -122.497145662996) | 11 | 6 | 2 | 55 | 26 | ||||
8974 | 260925 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 1900 Noriega St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5987961.4849 | 2103092.5821 | 37.7539969916819 | -122.484579575666 | (37.7539969916819, -122.484579575666) | 1 | 8 | 3 | 56 | 35 | ||||
5115 | 260959 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 400 Cherry St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 9ft | 5996243 | 2114742 | 37.7864620624436 | -122.456782770891 | (37.7864620624436, -122.456782770891) | 11 | 6 | 1 | 54 | 31 | ||||
6747 | 261157 | Significant Tree 6 | Tree(s) :: 17 | 1100X Moraga St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/22/2020 12:00:00 AM | 3 | 10x10 | Permit Number 784837 | 5990881 | 2103853 | 37.7562544846391 | -122.474538790377 | (37.7562544846391, -122.474538790377) | 1 | 8 | 4 | 56 | 12 | |
11981 | 261158 | Significant Tree 6 | Juniperus californica :: California juniper 295 | 1100X Moraga St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | Permit Number 784837 | 5990881 | 2103853 | 37.7562544846391 | -122.474538790377 | (37.7562544846391, -122.474538790377) | 1 | 8 | 4 | 56 | 12 | |||
4096 | 261159 | Significant Tree 6 | Tree(s) :: 17 | 1100X Moraga St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/22/2020 12:00:00 AM | 3 | 10x10 | Permit Number 784837 | 5990881 | 2103853 | 37.7562544846391 | -122.474538790377 | (37.7562544846391, -122.474538790377) | 1 | 8 | 4 | 56 | 12 | |
9381 | 261160 | Significant Tree 6 | Tree(s) :: 17 | 1100X Moraga St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/22/2020 12:00:00 AM | 3 | 10x10 | Permit Number 784837 | 5990881 | 2103853 | 37.7562544846391 | -122.474538790377 | (37.7562544846391, -122.474538790377) | 1 | 8 | 4 | 56 | 12 | |
17557 | 261982 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2403 Keith St | 3 | Sidewalk: Property side : Yard | Tree | DPW 1 | 6014456 | 2092405 | 37.7261584067484 | -122.392207065149 | (37.7261584067484, -122.392207065149) | 10 | 3 | 8 | 58 | 1 | |||||
17656 | 261984 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1557 Bancroft Ave | 4 | Sidewalk: Property side : Yard | Tree | DPW 1 | 6014517 | 2091967 | 37.7249591332222 | -122.391965574806 | (37.7249591332222, -122.391965574806) | 10 | 3 | 8 | 58 | 1 | |||||
12431 | 262225 | Significant Tree 6 | Cupressus spp :: Cypress species 337 | 2450 Golden Gate Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 7ft | 5997659.54255 | 2111324.05825 | 37.7771585265736 | -122.451635273045 | (37.7771585265736, -122.451635273045) | 15 | 6 | 2 | 54 | 16 | ||||
1901 | 262254 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 4210 Ocean Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |||
18983 | 262256 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4210 Ocean Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |||
19616 | 262407 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 300 Font Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x5 | 5990018 | 2089729 | 37.7174235665943 | -122.476491559856 | (37.7174235665943, -122.476491559856) | 1 | 8 | 4 | 64 | 14 | ||||
194276 | 262536 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 65 Ocean Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 785586 | 6001004.64572 | 2091720.9184 | 37.7235240092161 | -122.438658540667 | (37.7235240092161, -122.438658540667) | 9 | 7 | 6 | 28861 | 25 | ||||
194262 | 262537 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 65 Ocean Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 785586 | 6001004.64572 | 2091720.9184 | 37.7235240092161 | -122.438658540667 | (37.7235240092161, -122.438658540667) | 9 | 7 | 6 | 28861 | 25 | ||||
194330 | 265002 | Significant Tree 6 | :: Tree 573 | 1445 San Bruno Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5x5 | 6011217 | 2101257 | 37.7502837374969 | -122.404026841996 | (37.7502837374969, -122.404026841996) | 10 | 4 | 8 | 28859 | 19 | ||||
2321 | 48402 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 706 Wisconsin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/19/2010 12:00:00 AM | Permit Number 53935 | 6012689.64928807 | 2104214.1545054 | 37.7584856101735 | -122.399141839868 | (37.7584856101735, -122.399141839868) | 10 | 3 | 8 | 28856 | 29 | |||
71176 | 87239 | Significant Tree 6 | Tree(s) :: 17 | 233 Arbor St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/14/2008 12:00:00 AM | Permit Number 50269 | 6001330 | 2096776 | 37.7374226054152 | -122.437895752709 | (37.7374226054152, -122.437895752709) | 2 | 7 | 5 | 63 | 7 | |||
163821 | 87242 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 4131 Geary Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 50271 | 5994116.9 | 2112250.5 | 37.7794987690846 | -122.46395756624 | (37.7794987690846, -122.46395756624) | 11 | 6 | 2 | 54 | 11 | ||||
161427 | 92055 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1001 Potrero Ave | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | |||||
14736 | 92056 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1001 Potrero Ave | Sidewalk: Property side : Yard | Tree | Private 2 | 06/16/2009 12:00:00 AM | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
77181 | 95229 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1@Carl Irving St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/16/2010 12:00:00 AM | 15 | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256 | (37.7645027364821, -122.45767767256) | 15 | 5 | 11 | 56 | 12 | |||
122339 | 95231 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1@Carl Irving St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/16/2010 12:00:00 AM | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256 | (37.7645027364821, -122.45767767256) | 15 | 5 | 11 | 56 | 12 | ||||
16372 | 96327 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 296 Randall St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 767829 | 6003708 | 2097940 | 37.7407536226533 | -122.429756895294 | (37.7407536226533, -122.429756895294) | 2 | 7 | 5 | 63 | 7 | ||||
162530 | 96328 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 296 Randall St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 767829 | 6003708 | 2097940 | 37.7407536226533 | -122.429756895294 | (37.7407536226533, -122.429756895294) | 2 | 7 | 5 | 63 | 7 | ||||
75471 | 98104 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1@Carl Irving St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256 | (37.7645027364821, -122.45767767256) | 15 | 5 | 11 | 56 | 12 | ||||
165161 | 98288 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 300 Mangels Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/24/2012 12:00:00 AM | Permit Number 768637 | 5999381.8 | 2095276.6 | 37.7331946288913 | -122.444523835506 | (37.7331946288913, -122.444523835506) | 9 | 7 | 4 | 59 | 40 | |||
37139 | 98289 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 300 Mangels Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/24/2012 12:00:00 AM | Permit Number 768637 | 5999381.8 | 2095276.6 | 37.7331946288913 | -122.444523835506 | (37.7331946288913, -122.444523835506) | 9 | 7 | 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) );