trees
8,298 rows where qLegalStatus_id = 4 sorted by qSiteInfo descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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) );