8,298 rows where qLegalStatus_id = 4 sorted by qSiteInfo descending

View and edit SQL

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)
23834 107210 Undocumented 4 Pinus radiata :: Monterey Pine 15 603 PERALTA AVE 1 unknown : Yard Tree Private 2     30     6009839.9 2098688.7 37.7431547125392 -122.408607810015 (37.7431547125392, -122.408607810015) 10 7 7 28859 2
50928 105667 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 301X DORADO TER 1 unknown : Yard Tree Private 2           5994306.4 2092922 37.7264385629619 -122.461900058607 (37.7264385629619, -122.461900058607) 9 8 4 28861 40
62684 106004 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 695X CAMPBELL AVE   unknown : Yard Tree Rec/Park 5           6009136.9 2088912.4 37.716271678506 -122.410348471622 (37.716271678506, -122.410348471622) 9 7 8 309 39
74819 105668 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 301X DORADO TER 2 unknown : Yard Tree Private 2     12     5994306.4 2092922 37.7264385629619 -122.461900058607 (37.7264385629619, -122.461900058607) 9 8 4 28861 40
125954 105666 Undocumented 4 Eucalyptus Spp :: Eucalyptus 52 317X DORADO TER 3 unknown : Yard Tree Private 2     22     5994307.4 2093021.4 37.7267115488018 -122.461903806308 (37.7267115488018, -122.461903806308) 9 8 4 28861 40
139334 105664 Undocumented 4 Tree(s) :: 17 317X DORADO TER 1 unknown : Yard Tree Private 2     10     5994307.4 2093021.4 37.7267115488018 -122.461903806308 (37.7267115488018, -122.461903806308) 9 8 4 28861 40
190393 105665 Undocumented 4 Eucalyptus Spp :: Eucalyptus 52 317X DORADO TER 2 unknown : Yard Tree Private 2     24     5994307.4 2093021.4 37.7267115488018 -122.461903806308 (37.7267115488018, -122.461903806308) 9 8 4 28861 40
129277 103959 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 460X Lily St 1 unknown : Pot Tree Private 2           6004484.08045 2109981.44374 37.773860502373 -122.427931334456 (37.773860502373, -122.427931334456) 7 9 11 28852 10
159 117627 Undocumented 4 Pinus radiata :: Monterey Pine 15 890x VERMONT ST 4 Unaccepted Street : Yard Tree Private 2           6011292 2104239 37.7584758425658 -122.403977311201 (37.7584758425658, -122.403977311201) 10 3 8 28856 29
1190 107158 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 101x Elsie St 1 Unaccepted Street : Yard Tree Private 2     20     6007300 2098759 37.7432051631731 -122.417395111614 (37.7432051631731, -122.417395111614) 2 7 7 28859 2
2335 262272 Undocumented 4 Tree(s) :: 17 99X Glendale St   Unaccepted Street : Yard Tree Private 2       3x3   5999984 2103563 37.7559814441149 -122.443036761048 (37.7559814441149, -122.443036761048) 2 5 5 28862 38
5279 258778 Undocumented 4 Pinus radiata :: Monterey Pine 15 701X Ortega Way 1 Unaccepted Street : Yard Tree Private 2       10x10   5991876 2102480 37.7525421857889 -122.470997752755 (37.7525421857889, -122.470997752755) 1 8 4 29491 12
8589 111310 Undocumented 4 Acacia spp :: Acacia Spp 105 99x GILROY ST 1 Unaccepted Street : Yard Tree Private 2       30x30   6015277 2088666 37.7159373992527 -122.389107938034 (37.7159373992527, -122.389107938034) 10 3 8 58 1
9075 121724 Undocumented 4 Prunus persica :: Peach 306 439X ARLINGTON ST 2 Unaccepted Street : Yard Tree Private 2           6003949.9 2096014.9 37.7354814316621 -122.42878329169 (37.7354814316621, -122.42878329169) 2 7 5 63 7
17203 107449 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1130x CHESTNUT ST 1 Unaccepted Street : Yard Tree Private 2     60     6006351.9 2120450.9 37.8027125282147 -122.422214196597 (37.8027125282147, -122.422214196597) 5 9 1 28858 32
19314 114270 Undocumented 4 Pinus radiata :: Monterey Pine 15 27x ESMERALDA AVE 2 Unaccepted Street : Yard Tree Private 2       3x3   6006799 2098981 37.743786524331 -122.41914318493 (37.743786524331, -122.41914318493) 2 7 7 28859 2
22968 115663 Undocumented 4 Myoporum laetum :: Myoporum 62 601x PERU AVE 1 Unaccepted Street : Yard Tree Private 2       3x3   6005068 2092670 37.7263602983163 -122.424679722884 (37.7263602983163, -122.424679722884) 9 7 6 28861 5
24450 111157 Undocumented 4 Myoporum laetum :: Myoporum 62 201x EUGENIA AVE 4 Unaccepted Street : Yard Tree Private 2       3x3   6006591 2098138 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536) 2 7 7 28859 2
24524 107157 Undocumented 4 Pinus radiata :: Monterey Pine 15 301X Esmeralda Ave 1 Unaccepted Street : Yard Tree Private 2     28     6007313 2098782 37.7432690474632 -122.417351790512 (37.7432690474632, -122.417351790512) 2 7 7 28859 2
28400 99274 Undocumented 4 Pinus radiata :: Monterey Pine 15 16 Joy St 1 Unaccepted Street : Yard Tree Private 2       3x3 Permit Number 768828 6010347.9 2098933.4 37.7438550437031 -122.406868515265 (37.7438550437031, -122.406868515265) 2 7 7 28859 2
30966 112739 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 444 Franconia St 3 Unaccepted Street : Yard Tree Private 2     30     6009949.70212209 2098546.33795552 37.7427699663381 -122.408218103257 (37.7427699663381, -122.408218103257) 10 7 7 28859 2
34078 106506 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3975 22nd St 2 Unaccepted Street : Yard Tree Private 2         Permit Number 773291 6002049 2102913 37.7543142223274 -122.435848813122 (37.7543142223274, -122.435848813122) 2 4 5 28862 22
35560 98376 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 199X Cragmont Ave 1 Unaccepted Street : Yard Tree Private 2           5992899 2101153 37.7489576989052 -122.467363590244 (37.7489576989052, -122.467363590244) 1 8 4 29491 40
41809 106281 Undocumented 4 Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 456 399X Elliot St 2 Unaccepted Street : Yard Tree Rec/Park 5         Permit Number 772905 6008798.75873 2088103.62049 37.7140319762934 -122.411460149363 (37.7140319762934, -122.411460149363) 9 7 8 309 39
42128 102522 Undocumented 4 Cedrus deodara :: Deodar Cedar 109 1X 31st St 2 Unaccepted Street : Yard Tree Private 2           5999966.2 2097547.4 37.7394630398899 -122.442666404233 (37.7394630398899, -122.442666404233) 9 7 4 59 40
42371 115664 Undocumented 4 Myoporum laetum :: Myoporum 62 601x PERU AVE 2 Unaccepted Street : Yard Tree Private 2       3x3   6005068 2092670 37.7263602983163 -122.424679722884 (37.7263602983163, -122.424679722884) 9 7 6 28861 5
45331 107372 Undocumented 4 Acer palmatum :: Japanese Maple 216 305x GREENWICH ST 1 Unaccepted Street : Yard Tree Private 2     20     6011370 2120243 37.8024234525216 -122.404834287898 (37.8024234525216, -122.404834287898) 3 1 10 308 23
46286 111319 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 200x PENINSULA AVE 2 Unaccepted Street : Yard Tree Private 2           6012569 2087626 37.7129312780718 -122.398395185538 (37.7129312780718, -122.398395185538) 10 3 8 309 1
49395 111159 Undocumented 4 Myoporum laetum :: Myoporum 62 201x EUGENIA AVE 6 Unaccepted Street : Yard Tree Private 2       3x3   6006591 2098138 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536) 2 7 7 28859 2
50112 109625 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 312x FILBERT ST 1 Unaccepted Street : Yard Tree Private 2     14     6011362.9 2120079.8 37.801974948341 -122.40484736081 (37.801974948341, -122.40484736081) 3 1 10 308 23
52679 105069 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 49X Esmeralda Ave 2 Unaccepted Street : Yard Tree Private 2         Permit Number 771039 6006861 2099026 37.7439135755866 -122.418931994103 (37.7439135755866, -122.418931994103) 2 7 7 28859 2
58486 111156 Undocumented 4 Myoporum laetum :: Myoporum 62 201x EUGENIA AVE 3 Unaccepted Street : Yard Tree Private 2       3x3   6006591 2098138 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536) 2 7 7 28859 2
67245 117626 Undocumented 4 Pinus radiata :: Monterey Pine 15 890x VERMONT ST 3 Unaccepted Street : Yard Tree Private 2           6011292 2104239 37.7584758425658 -122.403977311201 (37.7584758425658, -122.403977311201) 10 3 8 28856 29
71480 112615 Undocumented 4 Pinus radiata :: Monterey Pine 15 1798x 22ND ST 2 Unaccepted Street : Yard Tree Private 2   05/02/2016 12:00:00 AM 3     6012787 2103832 37.7574417223043 -122.398778335858 (37.7574417223043, -122.398778335858) 10 3 8 28856 29
73180 111309 Undocumented 4 Acacia spp :: Acacia Spp 105 100x GILROY ST 1 Unaccepted Street : Yard Tree Private 2       30x30   6015178 2088529 37.7155557353625 -122.389440569451 (37.7155557353625, -122.389440569451) 10 3 8 58 1
73281 111318 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 200x PENINSULA AVE 1 Unaccepted Street : Yard Tree Private 2           6012569 2087626 37.7129312780718 -122.398395185538 (37.7129312780718, -122.398395185538) 10 3 8 309 1
79539 95436 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 2675 25th Ave 3 Unaccepted Street : Yard Tree Private 2     16     5988610 2097126.3 37.7376529013161 -122.481899870051 (37.7376529013161, -122.481899870051) 1 8 3 29491 35
83802 115379 Undocumented 4 Tree(s) :: 17 4004 20TH ST   Unaccepted Street : Yard Tree Private 2       3x3   6003604 2104237 37.758037821948 -122.430565699194 (37.758037821948, -122.430565699194) 2 4 5 28862 3
85470 106280 Undocumented 4 Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 456 399X Elliot St 1 Unaccepted Street : Yard Tree Rec/Park 5         Permit Number 772905 6008798.75873 2088103.62049 37.7140319762934 -122.411460149363 (37.7140319762934, -122.411460149363) 9 7 8 309 39
86119 111312 Undocumented 4 Acacia spp :: Acacia Spp 105 99x GILROY ST 3 Unaccepted Street : Yard Tree Private 2       30x30   6015277 2088666 37.7159373992527 -122.389107938034 (37.7159373992527, -122.389107938034) 10 3 8 58 1
88123 101366 Undocumented 4 Quercus agrifolia :: Coast Live Oak 172 1348 Noe St   Unaccepted Street : Yard Tree Private 2     24   Owner: Brent Sommer 519-1119 nocmout@gmail.com 6003163.2 2100416 37.7475212781449 -122.43181735246 (37.7475212781449, -122.43181735246) 2 4 5 63 22
89451 115665 Undocumented 4 Myoporum laetum :: Myoporum 62 601x PERU AVE 3 Unaccepted Street : Yard Tree Private 2       3x3   6005068 2092670 37.7263602983163 -122.424679722884 (37.7263602983163, -122.424679722884) 9 7 6 28861 5
89537 111311 Undocumented 4 Acacia spp :: Acacia Spp 105 99x GILROY ST 2 Unaccepted Street : Yard Tree Private 2       30x30   6015277 2088666 37.7159373992527 -122.389107938034 (37.7159373992527, -122.389107938034) 10 3 8 58 1
90922 121630 Undocumented 4 Myoporum laetum :: Myoporum 62 96x Valmar Ter 1 Unaccepted Street : Yard Tree Private 2     12 3x3   6005224 2092573 37.7261027669422 -122.42413354236 (37.7261027669422, -122.42413354236) 9 7 6 28861 5
94771 110864 Undocumented 4 Aesculus spp :: Horsechestnut 528 1798x 22ND ST 1 Unaccepted Street : Yard Tree Private 2           6012787 2103832 37.7574417223043 -122.398778335858 (37.7574417223043, -122.398778335858) 10 3 8 28856 29
94940 111154 Undocumented 4 Myoporum laetum :: Myoporum 62 201x EUGENIA AVE 1 Unaccepted Street : Yard Tree Private 2       3x3   6006591 2098138 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536) 2 7 7 28859 2
98353 109309 Undocumented 4 Pinus radiata :: Monterey Pine 15 349x MAYFLOWER ST 1 Unaccepted Street : Yard Tree Private 2           6009941 2098430 37.7424500403346 -122.408239989358 (37.7424500403346, -122.408239989358) 10 7 7 28859 2
99208 112729 Undocumented 4 Pinus radiata :: Monterey Pine 15 444 Franconia St 2 Unaccepted Street : Yard Tree Private 2     24     6009949.70212209 2098546.33795552 37.7427699663381 -122.408218103257 (37.7427699663381, -122.408218103257) 10 7 7 28859 2
103178 107527 Undocumented 4 Populus alba :: White Poplar 184 2540x LYON ST 1 Unaccepted Street : Yard Tree Private 2     30   Permit Number 774117 5999227 2117510 37.7942331479636 -122.446658147156 (37.7942331479636, -122.446658147156) 13   1 57 30
103781 108605 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1140x CHESTNUT ST 2 Unaccepted Street : Yard Tree Private 2           6006369.1 2120452.7 37.8027184407042 -122.422154803739 (37.8027184407042, -122.422154803739) 5 9 1 28858 32
108041 111158 Undocumented 4 Myoporum laetum :: Myoporum 62 201x EUGENIA AVE 5 Unaccepted Street : Yard Tree Private 2       3x3   6006591 2098138 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536) 2 7 7 28859 2
109691 113439 Undocumented 4 Quercus agrifolia :: Coast Live Oak 172 401x POWHATTAN AVE 1 Unaccepted Street : Yard Tree Private 2     20 3x3   6008174 2098184 37.7416754763214 -122.414332364983 (37.7416754763214, -122.414332364983) 2 7 7 28859 2
112586 106503 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3974 22nd St 1 Unaccepted Street : Yard Tree Private 2         Permit Number 773286 6002049 2102947 37.754407578182 -122.435851245675 (37.754407578182, -122.435851245675) 2 4 5 28862 22
115276 122590 Undocumented 4 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 100 MacOndray Ln 1 Unaccepted Street : Yard Tree Private 2           6008161 2119143 37.7992232381339 -122.415861106147 (37.7992232381339, -122.415861106147) 5 1 10 308 32
123017 105651 Undocumented 4 Yucca elephantipes :: Giant Yucca 268 150 BRONTE ST 2 Unaccepted Street : Yard Tree Private 2     20     6009287.5 2096640.3 37.737499298819 -122.410373266073 (37.737499298819, -122.410373266073) 10 7 7 28859 2
124486 99112 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 80X Bradford St 1 Unaccepted Street : Yard Tree Private 2           6009564.7 2098208.3 37.7418202221976 -122.409525484318 (37.7418202221976, -122.409525484318) 10 7 7 28859 2
124765 99110 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 94 Bernal Heights Blvd 1 Unaccepted Street : Yard Tree Private 2           6009548.4 2098143.7 37.7416419313174 -122.409577286243 (37.7416419313174, -122.409577286243) 10 7 7 28859 2
125905 102521 Undocumented 4 Pinus radiata :: Monterey Pine 15 1X 31st St 1 Unaccepted Street : Yard Tree Private 2           5999966.2 2097547.4 37.7394630398899 -122.442666404233 (37.7394630398899, -122.442666404233) 9 7 4 59 40
130332 102729 Undocumented 4 Pinus radiata :: Monterey Pine 15 49X Esmeralda Ave 1 Unaccepted Street : Yard Tree Private 2     24     6006840.1 2099056.7 37.7439966940099 -122.419006438675 (37.7439966940099, -122.419006438675) 2 7 7 28859 2
130598 106504 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3974 22nd St 2 Unaccepted Street : Yard Tree Private 2         Permit Number 773286 6002049 2102947 37.754407578182 -122.435851245675 (37.754407578182, -122.435851245675) 2 4 5 28862 22
131481 106505 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3975 22nd St 1 Unaccepted Street : Yard Tree Private 2         Permit Number 773291 6002049 2102913 37.7543142223274 -122.435848813122 (37.7543142223274, -122.435848813122) 2 4 5 28862 22
137991 98379 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 199X Cragmont Ave 4 Unaccepted Street : Yard Tree Private 2           5992899 2101153 37.7489576989052 -122.467363590244 (37.7489576989052, -122.467363590244) 1 8 4 29491 40
139191 111155 Undocumented 4 Myoporum laetum :: Myoporum 62 201x EUGENIA AVE 2 Unaccepted Street : Yard Tree Private 2       3x3   6006591 2098138 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536) 2 7 7 28859 2
140063 95435 Undocumented 4 Sequoia sempervirens :: Coast Redwood 155 2675 25th Ave 2 Unaccepted Street : Yard Tree Private 2     12     5988610 2097126.3 37.7376529013161 -122.481899870051 (37.7376529013161, -122.481899870051) 1 8 3 29491 35
140615 96803 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 300X Melrose Ave 1 Unaccepted Street : Yard Tree Private 2     48     5998134.5 2095546.7 37.7338650092742 -122.448855518806 (37.7338650092742, -122.448855518806) 9 7 4 59 40
141297 105070 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 49X Esmeralda Ave 3 Unaccepted Street : Yard Tree Private 2         Permit Number 771039 6006861 2099026 37.7439135755866 -122.418931994103 (37.7439135755866, -122.418931994103) 2 7 7 28859 2
141724 98377 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 199X Cragmont Ave 2 Unaccepted Street : Yard Tree Private 2           5992899 2101153 37.7489576989052 -122.467363590244 (37.7489576989052, -122.467363590244) 1 8 4 29491 40
144056 109200 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 2401x CASTRO ST 7 Unaccepted Street : Yard Tree DPW 1           6002698 2098487 37.7421983129634 -122.433288166914 (37.7421983129634, -122.433288166914) 2 7 5 63 7
147160 99960 Undocumented 4 Ulmus americana :: American Elm 74 279 Filbert St 1 Unaccepted Street : Yard Tree Private 2         shared responsibility with 1400 Montgomery 6011546.2 2120046.5 37.8018937585678 -122.40421070766 (37.8018937585678, -122.40421070766) 3 1 10 308 23
149123 117545 Undocumented 4 Pinus halepensis :: Allepo Pine 330 3340x HARRISON ST 1 Unaccepted Street : Yard Tree Private 2     20 3x3   6008964 2099209 37.7445342470575 -122.411673205451 (37.7445342470575, -122.411673205451) 2 7 7 28859 2
149227 105652 Undocumented 4 Yucca elephantipes :: Giant Yucca 268 150 BRONTE ST 4 Unaccepted Street : Yard Tree Private 2     25     6009287.5 2096640.3 37.737499298819 -122.410373266073 (37.737499298819, -122.410373266073) 10 7 7 28859 2
150450 95432 Undocumented 4 Sequoia sempervirens :: Coast Redwood 155 2675 25th Ave 1 Unaccepted Street : Yard Tree Private 2     12     5988610 2097126.3 37.7376529013161 -122.481899870051 (37.7376529013161, -122.481899870051) 1 8 3 29491 35
158117 107675 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 98x LUNDYS LN 1 Unaccepted Street : Yard Tree Private 2     14 8x10   6006855 2099015 37.7438830341993 -122.418951960739 (37.7438830341993, -122.418951960739) 2 7 7 28859 2
162309 106282 Undocumented 4 Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 456 399X Elliot St 3 Unaccepted Street : Yard Tree Rec/Park 5         Permit Number 772905 6008798.75873 2088103.62049 37.7140319762934 -122.411460149363 (37.7140319762934, -122.411460149363) 9 7 8 309 39
164541 111320 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 200x PENINSULA AVE 3 Unaccepted Street : Yard Tree Private 2           6012569 2087626 37.7129312780718 -122.398395185538 (37.7129312780718, -122.398395185538) 10 3 8 309 1
165174 112379 Undocumented 4 Pinus radiata :: Monterey Pine 15 25x ESMERALDA AVE 1 Unaccepted Street : Yard Tree Private 2     20 3x3   6006716 2099027 37.7439081554699 -122.419433442615 (37.7439081554699, -122.419433442615) 2 7 7 28859 2
165277 115525 Undocumented 4 Quercus lobata :: Valley Oak 303 25 FRANCONIA ST 2 Unaccepted Street : Yard Tree Private 2       3x3   6010006 2099954 37.7466382512014 -122.408122694659 (37.7466382512014, -122.408122694659) 2 7 7 28859 2
168219 117624 Undocumented 4 Pinus coulteri :: Coulter pine 537 890x VERMONT ST 2 Unaccepted Street : Yard Tree Private 2           6011292 2104239 37.7584758425658 -122.403977311201 (37.7584758425658, -122.403977311201) 10 3 8 28856 29
172476 98706 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 353 UPPER TER   Unaccepted Street : Yard Tree Private 2           5999086.1 2105914.9 37.7623879420949 -122.446311165521 (37.7623879420949, -122.446311165521) 15 5 5 29492 9
176510 115666 Undocumented 4 Myoporum laetum :: Myoporum 62 601x PERU AVE 4 Unaccepted Street : Yard Tree Private 2       3x3   6005068 2092670 37.7263602983163 -122.424679722884 (37.7263602983163, -122.424679722884) 9 7 6 28861 5
192530 114586 Undocumented 4 Pinus radiata :: Monterey Pine 15 155x BRONTE ST 1 Unaccepted Street : Yard Tree Private 2     15 3x3 Permit Number 777226 6009330 2096609 37.7374157381662 -122.410224113722 (37.7374157381662, -122.410224113722) 10 7 7 28859 2
193436 105653 Undocumented 4 Pinus radiata :: Monterey Pine 15 150 BRONTE ST 3 Unaccepted Street : Yard Tree Private 2     16   Permit Number 770978 6009287.5 2096640.3 37.737499298819 -122.410373266073 (37.737499298819, -122.410373266073) 10 7 7 28859 2
6380 110632 Undocumented 4 Tree(s) :: 17 1051X Mandalay Ln 1 Unaccepted Street : Cutout Tree Private 2           5991736.20076 2101819.33429 37.7507200830769 -122.47143306251 (37.7507200830769, -122.47143306251) 1 8 4 29491 12
10855 262421 Undocumented 4 Myoporum laetum :: Myoporum 62 123 Moultrie St 1 Unaccepted Street : Cutout Tree Private 2       3x3   6007822 2098282 37.7419247830103 -122.415556403469 (37.7419247830103, -122.415556403469) 2 7 7 28859 2
20018 256139 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 888 Moultrie St 1 Unaccepted Street : Cutout Tree Private 2       3x3   6007515 2095179 37.7333873668614 -122.416398174089 (37.7333873668614, -122.416398174089) 2 7 7 28859 2
24272 117475 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 1200x MONTGOMERY ST 2 Unaccepted Street : Cutout Tree Private 2           6011580 2119440 37.800230345698 -122.404051036068 (37.800230345698, -122.404051036068) 3 1 10 308 23
34416 110631 Undocumented 4 Tree(s) :: 17 1001X Mandalay Ln   Unaccepted Street : Cutout Tree Private 2           5991736.20076 2101819.33429 37.7507200830769 -122.47143306251 (37.7507200830769, -122.47143306251) 1 8 4 29491 12
42959 117474 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 1200x MONTGOMERY ST 1 Unaccepted Street : Cutout Tree Private 2           6011580 2119440 37.800230345698 -122.404051036068 (37.800230345698, -122.404051036068) 3 1 10 308 23
69278 111914 Undocumented 4 Pinus radiata :: Monterey Pine 15 60 LOWER TER 1 Unaccepted Street : Cutout Tree Private 2     28 3x3   6000264 2106046 37.7628151124003 -122.442246670025 (37.7628151124003, -122.442246670025) 15 5 5 28862 3
94661 110323 Undocumented 4 Tree(s) :: 17 1501x SHOTWELL ST 2 Unaccepted Street : Cutout Tree Private 2   05/15/2015 12:00:00 AM 3 3x3 Permit Number 775301 6008079 2099374 37.7449376155386 -122.414745041111 (37.7449376155386, -122.414745041111) 2 7 7 28859 2
95955 117473 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 1201x MONTGOMERY ST 1 Unaccepted Street : Cutout Tree Private 2           6011733 2119731 37.8010379082809 -122.403542078239 (37.8010379082809, -122.403542078239) 3 1 10 308 23
104363 114768 Undocumented 4 Pinus radiata :: Monterey Pine 15 155X Bronte St 1 Unaccepted Street : Cutout Tree Private 2     12     6009330.8 2096609.5 37.737417155901 -122.410221383029 (37.737417155901, -122.410221383029) 10 7 7 28859 2
104364 114271 Undocumented 4 Pinus halepensis :: Allepo Pine 330 49x ESMERALDA AVE 1 Unaccepted Street : Cutout Tree Private 2     27 3x3   6006783 2099038 37.7439421324692 -122.419202551725 (37.7439421324692, -122.419202551725) 2 7 7 28859 2
104452 110629 Undocumented 4 Pinus radiata :: Monterey Pine 15 1000X MANDALAY LN 1 Unaccepted Street : Cutout Tree Private 2           5991616 2101838 37.7507643799851 -122.471850083311 (37.7507643799851, -122.471850083311) 1 8 4 29491 12
106132 110322 Undocumented 4 Tree(s) :: 17 1501x SHOTWELL ST 1 Unaccepted Street : Cutout Tree Private 2   05/15/2015 12:00:00 AM 3 3x3 Permit Number 775301 6008079 2099374 37.7449376155386 -122.414745041111 (37.7449376155386, -122.414745041111) 2 7 7 28859 2
106368 117063 Undocumented 4 Aesculus californica :: California Buckeye 168 229 MONTCALM ST 1 Unaccepted Street : Cutout Tree Private 2       3x3   6009811 2099554 37.7455290185947 -122.40876877231 (37.7455290185947, -122.40876877231) 2 7 7 28859 2
107173 117071 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 10 JOY ST 1 Unaccepted Street : Cutout Tree Private 2       3x3   6010420 2098909 37.7437920807055 -122.406617489968 (37.7437920807055, -122.406617489968) 2 7 7 28859 2
114094 117472 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 1201x MONTGOMERY ST 2 Unaccepted Street : Cutout Tree Private 2           6011733 2119731 37.8010379082809 -122.403542078239 (37.8010379082809, -122.403542078239) 3 1 10 308 23
116312 121792 Undocumented 4 Pinus radiata :: Monterey Pine 15 2556 Broderick St 1 Unaccepted Street : Cutout Tree Private 2       3x3   6000243 2117343 37.7938325936105 -122.443130684772 (37.7938325936105, -122.443130684772) 13 9 1 57 27
117991 120968 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 79x Bradford St 1 Unaccepted Street : Cutout Tree Private 2     30 3x3   6009615 2098188 37.7417673011584 -122.409350130422 (37.7417673011584, -122.409350130422) 10 7 7 28859 2

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