trees

1,732 rows where qLegalStatus_id = 6 sorted by qAddress descending

✎ View and edit SQL

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)
83163 115737 Significant Tree 6 Acer rubrum :: Red Maple 75 9x Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776557 5993642.27748 2097056.19499 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033) 1 8 4 59 40
6519 251515 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99x Mountview Ct 1 Back Yard : Yard Tree Private 2       3x3   5997620 2100449 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073) 1 5 4 63 38
109594 251514 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99x Mountview Ct 2 Back Yard : Yard Tree Private 2       3x3   5997620 2100449 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073) 1 5 4 63 38
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
62177 99097 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 99X Santa Monica Way 1 Sidewalk: Curb side : Yard Tree Private 2           5994003.8 2097131.6 37.7379796635799 -122.463251452094 (37.7379796635799, -122.463251452094) 9 8 4 59 40
177 253253 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 99X Lopez Ave 4 Front Yard : Yard Tree Private 2       10x10   5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
6296 260461 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99X Lopez Ave 4 Front Yard : Yard Tree Private 2       10x10 Permit Number 784513 5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
19246 253252 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99X Lopez Ave 3 Front Yard : Yard Tree Private 2       10x10 Permit Number 784513 5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
66926 253251 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99X Lopez Ave 2 Front Yard : Yard Tree Private 2       10x10   5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
94784 253250 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 99X Lopez Ave 1 Front Yard : Yard Tree Private 2   01/09/2018 12:00:00 AM 3 10x10 Permit Number 780226 5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
6364 264920 Significant Tree 6 Tree(s) :: 17 99X Everglade Dr 2 Sidewalk: Property side : Cutout Tree Private 2   11/10/2020 12:00:00 AM 3 6x10 Permit Number 785453 5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
7796 264921 Significant Tree 6 Tree(s) :: 17 99X Everglade Dr 3 Sidewalk: Property side : Cutout Tree Private 2   11/10/2020 12:00:00 AM 3 6x10 Permit Number 785453 5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
101827 173631 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 99X Everglade Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5986361 2095495 37.7330427310611 -122.489555709533 (37.7330427310611, -122.489555709533) 1 8 4 64 35
51708 173779 Significant Tree 6 Ficus macrophylla :: Morton Bay Fig 322 99X Cleveland St 2 Side Yard : Yard Tree Private 2       3x6   6010549 2110746 37.7763010397716 -122.407005587048 (37.7763010397716, -122.407005587048) 14 2 9 28853 34
77590 173780 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 99X Cleveland St 3 Side Yard : Yard Tree Private 2       3x6   6010549 2110746 37.7763010397716 -122.407005587048 (37.7763010397716, -122.407005587048) 14 2 9 28853 34
145519 173778 Significant Tree 6 Tree(s) :: 17 99X Cleveland St 1 Side Yard : Cutout Tree Private 2       3x3   6010549 2110746 37.7763010397716 -122.407005587048 (37.7763010397716, -122.407005587048) 14 2 9 28853 34
81883 106311 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 99X Clearfield Dr 5 Sidewalk: Property side : Yard Tree Private 2   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.46484 37.7328958169551 -122.491498163849 (37.7328958169551, -122.491498163849) 1 8 4 64 35
181784 106310 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 99X Clearfield Dr 4 Sidewalk: Property side : Yard Tree Private 2   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.46484 37.7328958169551 -122.491498163849 (37.7328958169551, -122.491498163849) 1 8 4 64 35
159697 226945 Significant Tree 6 Juniperus chinensis :: Juniper 113 998 Chenery St 4 Sidewalk: Property side : Yard Tree Private 2     21 Width 1ft   6001140.61217 2096125.61153 37.7356260187109 -122.438503967885 (37.7356260187109, -122.438503967885) 2 7 5 63 7
63551 121177 Significant Tree 6 Acacia spp :: Acacia Spp 105 990x Duncan St 1 Front Yard : Yard Tree Private 2       3x3 Permit Number 775289 6000056 2099639 37.7452111944111 -122.442506045398 (37.7452111944111, -122.442506045398) 2 7 5 63 22
150739 121178 Significant Tree 6 Acacia spp :: Acacia Spp 105 990x Duncan St 2 Front Yard : Yard Tree Private 2       3x3 Permit Number 775289 6000056 2099639 37.7452111944111 -122.442506045398 (37.7452111944111, -122.442506045398) 2 7 5 63 22
188209 121179 Significant Tree 6 Acacia spp :: Acacia Spp 105 990x Duncan St 3 Front Yard : Yard Tree Private 2       3x3   6000056 2099639 37.7452111944111 -122.442506045398 (37.7452111944111, -122.442506045398) 2 7 5 63 22
189569 252838 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 99 Pond St 1 Sidewalk: Property side : Yard Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
23401 114142 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99 Divisadero St   Front Yard : Yard Tree Private 2           6001906.1 2108188.4 37.7687910682296 -122.436720598265 (37.7687910682296, -122.436720598265) 15 5 5 29492 3
14608 259056 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 99 Cedro Ave 1 Front Yard : Yard Tree Private 2   10/09/2019 12:00:00 AM 3 3x3 Permit Number 784357 5992279 2093128 37.7268872622364 -122.468923614031 (37.7268872622364, -122.468923614031) 9 8 4 59 40
33143 116090 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 98x WOODWARD ST 4 Sidewalk: Property side : Yard Tree Private 2       3x3   6006422 2107919 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108) 8 4 7 28853 19
54660 116089 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 98x WOODWARD ST 3 Sidewalk: Property side : Yard Tree Private 2       3x3   6006422 2107919 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108) 8 4 7 28853 19
96610 116088 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 98x WOODWARD ST 2 Sidewalk: Property side : Yard Tree Private 2       3x3   6006422 2107919 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108) 8 4 7 28853 19
122222 116087 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 98x WOODWARD ST 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6006422 2107919 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108) 8 4 7 28853 19
103685 248958 Significant Tree 6 Pinus Spp :: Pine Spp 100 98x Rosewood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   03/06/2017 12:00:00 AM 3 3x3   5994824 2095658 37.7339807377795 -122.460308897898 (37.7339807377795, -122.460308897898) 9 8 4 59 40
34790 105768 Significant Tree 6 Pinus radiata :: Monterey Pine 15 98X GOLD MINE DR 3 Front Yard : Yard Tree Private 2     16     6001350 2099153 37.7439504273559 -122.437996817375 (37.7439504273559, -122.437996817375) 2 7 5 63 22
126819 257966 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 98X Clearfield Dr 1 Side Yard : Yard Tree Private 2       3x3 Permit Number 782748 5986022 2095487 37.7330009680725 -122.490727117227 (37.7330009680725, -122.490727117227) 1 8 4 64 35
43399 117435 Significant Tree 6 Salix babylonica :: Weeping Willow 308 98X CLIPPER ST 1 Back Yard : Yard Tree Private 2           6004559 2101087 37.7494427139243 -122.427038546128 (37.7494427139243, -122.427038546128) 2 4 5 28862 22
67906 223957 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 98 Seward St 1 Sidewalk: Property side : Yard Tree Private 2     14 Width 3ft   6000715.72405 2104622.00656 37.7589309108477 -122.440582177927 (37.7589309108477, -122.440582177927) 2 4 5 28862 38
167295 223958 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 98 Seward St 2 Sidewalk: Property side : Yard Tree Private 2     13 Width 3ft   6000714.90104 2104629.88079 37.7589524846915 -122.440585589054 (37.7589524846915, -122.440585589054) 2 4 5 28862 38
52054 255462 Significant Tree 6 Tree(s) :: 17 98 Saint Francis Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   05/24/2018 12:00:00 AM 3 10x5 Permit Number 777805 5992112.53458 2095987.97644 37.7347304251367 -122.469707196177 (37.7347304251367, -122.469707196177) 9 8 4 59 40
73609 252836 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 98 Prosper St 4 Sidewalk: Property side : Cutout Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
78900 254971 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 972 Guerrero St 1 Front Yard : Yard Tree Private 2       3x3   6005650 2103315 37.7556219192197 -122.423424204919 (37.7556219192197, -122.423424204919) 2 4 5 28859 19
43597 78107 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 970 GUERRERO ST 1 Front Yard : Yard Tree Private 2     15     6005649.9 2103318.5 37.7556315237614 -122.423424799558 (37.7556315237614, -122.423424799558) 2 4 5 28859 19
8218 100711 Significant Tree 6 Tree(s) :: 17 966-968 Guerrero St 1 Front Yard : Yard Tree Private 2   09/27/2012 12:00:00 AM 14   Permit Number 769148 6005605.8 2103343.5 37.7556976788024 -122.423579088745 (37.7556976788024, -122.423579088745) 2 4 5 28859 19
139381 109706 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 96 CRESTA VISTA DR   Back Yard : Cutout Tree Private 2           5995602.1 2096103.5 37.7352487002973 -122.457651008037 (37.7352487002973, -122.457651008037) 9 7 4 59 40
182457 115738 Significant Tree 6 Acer rubrum :: Red Maple 75 95x Yerba Buena Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776553 5993642.27748 2097056.19499 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033) 1 8 4 59 40
194374 265048 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 959 Kirkham St 1 Front Yard : Yard Tree Private 2       20x20   5991956 2105209 37.7600399316741 -122.470919881603 (37.7600399316741, -122.470919881603) 1 8 4 56 12
3099 104652 Significant Tree 6 Ficus microcarpa :: Chinese Banyan 97 953 Indiana St 1 Front Yard : Cutout Tree Private 2           6015057.1 2104275.7 37.7587862506702 -122.390958369803 (37.7587862506702, -122.390958369803) 10 3 8 28856 29
20184 108109 Significant Tree 6 Tree(s) :: 17 952 CAPP ST 1 Front Yard : Yard Tree Private 2   01/06/2015 12:00:00 AM 3 3x3 Permit Number 774355 6007364.7 2101732.3 37.7513728159016 -122.417382061559 (37.7513728159016, -122.417382061559) 2 4 7 28859 19
115 121173 Significant Tree 6 Tree(s) :: 17 950 Duncan St 2 Front Yard : Yard Tree Private 2       3x3   6000333 2099683 37.7453477932295 -122.441551386161 (37.7453477932295, -122.441551386161) 2 7 5 63 22
87873 121174 Significant Tree 6 Tree(s) :: 17 950 Duncan St 3 Front Yard : Yard Tree Private 2       3x3   6000333 2099683 37.7453477932295 -122.441551386161 (37.7453477932295, -122.441551386161) 2 7 5 63 22
111801 121175 Significant Tree 6 Tree(s) :: 17 950 Duncan St 4 Front Yard : Yard Tree Private 2       3x3   6000333 2099683 37.7453477932295 -122.441551386161 (37.7453477932295, -122.441551386161) 2 7 5 63 22
135671 121172 Significant Tree 6 Tree(s) :: 17 950 Duncan St 1 Front Yard : Yard Tree Private 2       3x3   6000333 2099683 37.7453477932295 -122.441551386161 (37.7453477932295, -122.441551386161) 2 7 5 63 22
185684 121176 Significant Tree 6 Tree(s) :: 17 950 Duncan St 5 Front Yard : Yard Tree Private 2       3x3   6000333 2099683 37.7453477932295 -122.441551386161 (37.7453477932295, -122.441551386161) 2 7 5 63 22
50063 105765 Significant Tree 6 Pinus radiata :: Monterey Pine 15 95 ORA WAY 1 Front Yard : Yard Tree Private 2     18     6001454.9 2097857 37.7403978808149 -122.437541306682 (37.7403978808149, -122.437541306682) 2 7 5 63 7
3054 109568 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 95 Nordhoff St 1 Back Yard : Yard Tree Private 2         Permit Number 777169 6000348.8 2095645.6 37.7342629464917 -122.441207129815 (37.7342629464917, -122.441207129815) 9 7 5 63 40
44600 107186 Significant Tree 6 Pinus radiata :: Monterey Pine 15 945 Sacramento St 2 Front Yard : Yard Tree Private 2         Permit Number 773422 6010352.63458 2116759.0624 37.7928004918921 -122.408109042355 (37.7928004918921, -122.408109042355) 3 1 10 28857 4
150077 107187 Significant Tree 6 Pinus radiata :: Monterey Pine 15 945 Sacramento St 3 Front Yard : Yard Tree Private 2         Permit Number 773422 6010352.63458 2116759.0624 37.7928004918921 -122.408109042355 (37.7928004918921, -122.408109042355) 3 1 10 28857 4
191590 107016 Significant Tree 6 Tree(s) :: 17 945 SACRAMENTO ST 1 Front Yard : Yard Tree Private 2   01/24/2015 12:00:00 AM     Permit Number 773422 6010352.6 2116759.1 37.7928005931964 -122.408109164657 (37.7928005931964, -122.408109164657) 3 1 10 28857 4
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
48955 255537 Significant Tree 6 Melaleuca linariifolia :: Flaxleaf Paperbark 103 93X Monterey Blvd 1 Side Yard : Cutout Tree Private 2       10x10   6001470 2094575 37.7313871286154 -122.437254157834 (37.7313871286154, -122.437254157834) 9 7 4 63 40
74628 88281 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 935 Ulloa St 2 Front Yard : Yard Tree Private 2   07/09/2008 12:00:00 AM   3x3 Permit Number 51275 5993125 2098282 37.7410877064311 -122.466373457073 (37.7410877064311, -122.466373457073) 1 8 4 59 40
81588 113833 Significant Tree 6 Ficus nitida :: Laurel Fig 53 932 SHOTWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     30     6007966 2102301 37.7529681504442 -122.415342945464 (37.7529681504442, -122.415342945464) 2 4 7 28859 19
139989 100474 Significant Tree 6 Pinus halepensis :: Allepo Pine 330 930 Monterey Blvd 2 Front Yard : Yard Tree Private 2           5995794.4 2094643.4 37.7312506649165 -122.456880589247 (37.7312506649165, -122.456880589247) 9 7 4 59 40
189375 100473 Significant Tree 6 Pinus halepensis :: Allepo Pine 330 930 Monterey Blvd 1 Front Yard : Yard Tree Private 2           5995794.4 2094643.4 37.7312506649165 -122.456880589247 (37.7312506649165, -122.456880589247) 9 7 4 59 40
54607 108196 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 22 930 FLORIDA ST 1 Sidewalk: Curb side : Cutout Tree Private 2           6009368.6 2103733.3 37.7569796561067 -122.410593604092 (37.7569796561067, -122.410593604092) 2 4 7 28859 19
180439 108197 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 930 FLORIDA ST 2 Sidewalk: Curb side : Cutout Tree Private 2           6009368.6 2103733.3 37.7569796561067 -122.410593604092 (37.7569796561067, -122.410593604092) 2 4 7 28859 19
70399 121205 Significant Tree 6 Cotoneaster SPP :: Cotoneaster 96 930 Chestnut St 1 Front Yard : Yard Tree Private 2     20 3x3   6007386.5238 2120591.43483 37.8031567047665 -122.418643837145 (37.8031567047665, -122.418643837145) 5 1 1 28858 32
171699 121206 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 930 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2016 12:00:00 AM 3 3x3 Permit Number 778903 6007356.48577 2120579.52821 37.8031223210123 -122.418746939923 (37.8031223210123, -122.418746939923) 5 1 1 28858 32
8580 261010 Significant Tree 6 Tree(s) :: 17 91 Parkridge Dr 3 Sidewalk: Curb side : Cutout Tree Private 2   12/18/2019 12:00:00 AM 3 3x3 Permit Number 784979 5998980 2102204 37.7521926688144 -122.446411148664 (37.7521926688144, -122.446411148664) 2 5 5 63 38
194291 264997 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 909 Shields St 1 Sidewalk: Property side : Cutout Tree Private 2       3x9   5991621 2089826 37.7177827456648 -122.470957844969 (37.7177827456648, -122.470957844969) 9 8 6 64 24
111048 113744 Significant Tree 6 Cordyline australis :: Dracena Palm 64 909 ASHBURY ST 1 Front Yard : Cutout Tree Private 2       3x3   5999156 2107025 37.7654399906909 -122.44614926226 (37.7654399906909, -122.44614926226) 15 5 11 29492 9
110004 113695 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 907 FLORIDA ST 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6009441 2103786 37.7571284172194 -122.410346937481 (37.7571284172194, -122.410346937481) 2 4 7 28859 19
71235 98244 Significant Tree 6 Taxus baccata :: Irish Yew 86 901 Bay St 1 Front Yard : Yard Tree Private 2     5     6006420.63185 2121080.7781 37.8044458892203 -122.422021121489 (37.8044458892203, -122.422021121489) 5 1 1 28858 32
117949 254767 Significant Tree 6 Pinus radiata :: Monterey Pine 15 900x Moraga St 1 Back Yard : Yard Tree Private 2       10x10   5991390 2103897 37.7564047756354 -122.47278171886 (37.7564047756354, -122.47278171886) 1 8 4 56 12
5702 121171 Significant Tree 6 Tree(s) :: 17 900x Duncan St 4 Front Yard : Yard Tree Private 2       3x3   6000584 2099647 37.745263242779 -122.440680889831 (37.745263242779, -122.440680889831) 2 7 5 63 7
32555 121168 Significant Tree 6 Tree(s) :: 17 900x Duncan St 1 Front Yard : Yard Tree Private 2       3x3   6000584 2099647 37.745263242779 -122.440680889831 (37.745263242779, -122.440680889831) 2 7 5 63 7
95045 121170 Significant Tree 6 Tree(s) :: 17 900x Duncan St 3 Front Yard : Yard Tree Private 2       3x3   6000584 2099647 37.745263242779 -122.440680889831 (37.745263242779, -122.440680889831) 2 7 5 63 7
125742 121169 Significant Tree 6 Acacia spp :: Acacia Spp 105 900x Duncan St 2 Front Yard : Yard Tree Private 2       3x3 Permit Number 775289 6000584 2099647 37.745263242779 -122.440680889831 (37.745263242779, -122.440680889831) 2 7 5 63 7
51579 251199 Significant Tree 6 Pinus radiata :: Monterey Pine 15 900X 14th St 4 Front Yard : Yard Tree Private 2       3X3   6002515 2107976 37.768242455455 -122.434599270731 (37.768242455455, -122.434599270731) 15 5 5 28862 3
150406 251198 Significant Tree 6 Pinus radiata :: Monterey Pine 15 900X 14th St 3 Front Yard : Yard Tree Private 2           6002515 2107976 37.768242455455 -122.434599270731 (37.768242455455, -122.434599270731) 15 5 5 28862 3
173581 251197 Significant Tree 6 Pinus radiata :: Monterey Pine 15 900X 14th St 3 Front Yard : Yard Tree Private 2   03/22/2017 12:00:00 AM 3   Permit Number 779570 6002798.55883 2107703.57748 37.7675105430125 -122.433598998019 (37.7675105430125, -122.433598998019) 15 5 5 28862 3
180810 251196 Significant Tree 6 Pinus radiata :: Monterey Pine 15 900X 14th St 2 Front Yard : Cutout Tree Private 2   03/22/2017 12:00:00 AM 3     6002515 2107976 37.768242455455 -122.434599270731 (37.768242455455, -122.434599270731) 15 5 5 28862 3
42469 251630 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 8R Amethyst Way 2 Back Yard : Yard Tree Private 2           5999237 2100032 37.7462435599048 -122.445366249721 (37.7462435599048, -122.445366249721) 2 7 5 63 22
98838 251629 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 8R Amethyst Way 1 Back Yard : Yard Tree Private 2           5999237 2100032 37.7462435599048 -122.445366249721 (37.7462435599048, -122.445366249721) 2 7 5 63 22
102716 251631 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 8R Amethyst Way 3 Back Yard : Yard Tree Private 2           5999237 2100032 37.7462435599048 -122.445366249721 (37.7462435599048, -122.445366249721) 2 7 5 63 22
113829 101236 Significant Tree 6 Tree(s) :: 17 895X Church St 1 Back Yard : Yard Tree Private 2   10/05/2012 12:00:00 AM 13   Permit Number 769299 6004383.5 2103691.7 37.7565846850157 -122.427831000859 (37.7565846850157, -122.427831000859) 2 4 5 28862 3
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
22312 116999 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 880x MCALLISTER ST 2 Front Yard : Cutout Tree Private 2           6005306 2112177 37.779935428414 -122.425244441442 (37.779935428414, -122.425244441442) 7 9 11 28852 41
99950 117000 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 880x MCALLISTER ST 3 Front Yard : Cutout Tree Private 2           6005306 2112177 37.779935428414 -122.425244441442 (37.779935428414, -122.425244441442) 7 9 11 28852 41

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);