Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies ▲ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
71308 | 71308 | 197285 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 11 Bridgeview Way | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 6016108.43544 | 2108129.53724 | 37.769426339083 | -122.387591202882 | (37.769426339083, -122.387591202882) | |||
75587 | 75587 | 197320 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 16 Bridgeview Way | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 6016068.99433 | 2108270.10145 | 37.769810113065205 | -122.38773743803999 | (37.7698101130652, -122.38773743804) | |||
112301 | 112301 | 197325 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 14 Bridgeview Way | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6016079.09017 | 2108123.99167 | 37.7694094866965 | -122.38769232084199 | (37.7694094866965, -122.387692320842) | |||
130848 | 130848 | 197281 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 11 Bridgeview Way | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6016110.38845 | 2108078.71323 | 37.7692868955955 | -122.38758090114099 | (37.7692868955955, -122.387580901141) | |||
132422 | 132422 | 197277 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 11 Bridgeview Way | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 6ft | 6016113.5620800005 | 2108033.0539700002 | 37.7691617009916 | -122.387566737717 | (37.7691617009916, -122.387566737717) | |||
133998 | 133998 | 197329 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 14 Bridgeview Way | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6016083.653580001 | 2108026.91709 | 37.7691431938187 | -122.38766976225901 | (37.7691431938187, -122.387669762259) | |||
134407 | 134407 | 197275 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 11 Bridgeview Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 6ft | 6016114.884459999 | 2108006.33732 | 37.7690884161304 | -122.387560299479 | (37.7690884161304, -122.387560299479) | |||
135436 | 135436 | 197290 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 11 Bridgeview Way | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6016103.1804599995 | 2108201.18695 | 37.7696227825046 | -122.38761437932301 | (37.7696227825046, -122.387614379323) | |||
136221 | 136221 | 197316 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 16 Bridgeview Way | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 6016062.190280001 | 2108385.40465 | 37.7701263335922 | -122.387769019543 | (37.7701263335922, -122.387769019543) | |||
137704 | 137704 | 197317 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 16 Bridgeview Way | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 6016063.89172 | 2108361.99068 | 37.7700621381908 | -122.387761500319 | (37.7700621381908, -122.387761500319) | |||
149160 | 149160 | 197323 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 14 Bridgeview Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6016072.52647 | 2108208.1178 | 37.7696401151345 | -122.38772089502501 | (37.7696401151345, -122.387720895025) | |||
149586 | 149586 | 197322 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 14 Bridgeview Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 6016075.02245 | 2108224.08687 | 37.7696841009794 | -122.387713375778 | (37.7696841009794, -122.387713375778) | |||
154131 | 154131 | 197315 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 16 Bridgeview Way | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 6016060.47111 | 2108407.95267 | 37.770188150300605 | -122.387776539678 | (37.7701881503006, -122.387776539678) | |||
154929 | 154929 | 197287 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 11 Bridgeview Way | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6016106.643999999 | 2108151.44442 | 37.7694863922003 | -122.38759892806499 | (37.7694863922003, -122.387598928065) | |||
157001 | 157001 | 197304 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 13 Bridgeview Way | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 6016087.22721 | 2108480.63748 | 37.7703892090349 | -122.387689061714 | (37.7703892090349, -122.387689061714) | |||
161306 | 161306 | 197324 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 14 Bridgeview Way | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6016077.33631 | 2108144.80906 | 37.769466549563205 | -122.387699840069 | (37.7694665495632, -122.387699840069) | |||
161758 | 161758 | 197311 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 16 Bridgeview Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 6016051.6813900005 | 2108575.68217 | 37.77064821196279 | -122.387818648634 | (37.7706482119628, -122.387818648634) | |||
166999 | 166999 | 197301 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 13 Bridgeview Way | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 6016091.41098 | 2108411.23459 | 37.7701988755957 | -122.38766974696101 | (37.7701988755957, -122.387669746961) | |||
167518 | 167518 | 197326 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 14 Bridgeview Way | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 6016080.07973 | 2108108.38527 | 37.769366689735996 | -122.387687808951 | (37.769366689736, -122.387687808951) | |||
169780 | 169780 | 197289 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 11 Bridgeview Way | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6016104.5103 | 2108174.84091 | 37.7695505156795 | -122.387607941055 | (37.7695505156795, -122.387607941055) | |||
173169 | 173169 | 197318 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 16 Bridgeview Way | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 6016065.97558 | 2108335.97136 | 37.7699908102494 | -122.387752476503 | (37.7699908102494, -122.387752476503) | |||
177898 | 177898 | 197296 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 11 Bridgeview Way | 24 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 6016097.57551 | 2108273.95502 | 37.7698222773026 | -122.387638844473 | (37.7698222773026, -122.387638844473) | |||
180283 | 180283 | 197283 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 11 Bridgeview Way | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 6016109.01375 | 2108102.83593 | 37.769353055133294 | -122.38758733939501 | (37.7693530551333, -122.387587339395) | |||
185159 | 185159 | 197319 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 16 Bridgeview Way | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 6016066.8339 | 2108313.87338 | 37.7699301815631 | -122.387747965502 | (37.7699301815631, -122.387747965502) | |||
27722 | 27722 | 207753 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 601 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 8ft | 5993435.94824 | 2096116.49805 | 37.7351597166396 | -122.465141071201 | (37.7351597166396, -122.465141071201) | |||
43074 | 43074 | 217773 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 470 West Portal Ave | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | 5991489.41962 | 2096094.4403900001 | 37.7349867131592 | -122.471869253786 | (37.7349867131592, -122.471869253786) | ||||
167573 | 167573 | 207751 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 85 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 10ft | 5993313.21582 | 2096962.3759700002 | 37.73747520830071 | -122.46562683193599 | (37.7374752083007, -122.465626831936) | |||
168928 | 168928 | 207752 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 301 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 37 | Width 10ft | 5993138.90515 | 2095971.9598700001 | 37.7347457173476 | -122.466157547934 | (37.7347457173476, -122.466157547934) | |||
37421 | 37421 | 220545 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 527 Powhattan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6008718.64128 | 2098106.70395 | 37.7414938180831 | -122.41244370862199 | (37.7414938180831, -122.412443708622) | ||||
65979 | 65979 | 220544 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 527 Powhattan Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6008701.62523 | 2098105.03088 | 37.741488269265204 | -122.412502426255 | (37.7414882692652, -122.412502426255) | ||||
137975 | 137975 | 220547 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 533 Powhattan Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6008900.20831 | 2098091.37785 | 37.7414619236216 | -122.41181482710199 | (37.7414619236216, -122.411814827102) | ||||
146927 | 146927 | 203439 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 640 Quintara St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5991446.07862 | 2101158.0386200002 | 37.7488875493216 | -122.472388116728 | (37.7488875493216, -122.472388116728) | |||
165483 | 165483 | 220546 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 531 Powhattan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6008777.78042 | 2098098.94343 | 37.7414758280375 | -122.412238676667 | (37.7414758280375, -122.412238676667) | ||||
182509 | 182509 | 220543 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 511 Powhattan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6008222.42371 | 2098151.87623 | 37.741589991579104 | -122.41416265928301 | (37.7415899915791, -122.414162659283) | ||||
35895 | 35895 | 188437 | Undocumented 2 | Ceiba speciosa :: Silk floss 335 | 1465 Rhode Island St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6012048.22997 | 2101554.20026 | 37.7511461921502 | -122.40117325816001 | (37.7511461921502, -122.40117325816) | ||||
172728 | 172728 | 188441 | Undocumented 2 | Ceiba speciosa :: Silk floss 335 | 1075 Jamestown Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6013593.18256 | 2089903.25055 | 37.719241158825895 | -122.39501465042 | (37.7192411588259, -122.39501465042) | ||||
182638 | 182638 | 188438 | Undocumented 2 | Ceiba speciosa :: Silk floss 335 | 1745 20th St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 3ft | 6012749.716 | 2104689.9757 | 37.759795457900296 | -122.398967497246 | (37.7597954579003, -122.398967497246) | |||
69108 | 69108 | 241049 | Undocumented 2 | Taxodium mucronatum :: Montezuma Cypress 333 | 319 Virginia Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 6006911.4527900005 | 2098103.07787 | 37.7413822787691 | -122.418692102873 | (37.7413822787691, -122.418692102873) | |||
27604 | 27604 | 225893 | Undocumented 2 | Fremontodendron spp :: Flannel Bush Tree 331 | 319 Virginia Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6006908.26589 | 2098097.04233 | 37.7413655270935 | -122.41870269417 | (37.7413655270935, -122.41870269417) | |||
70177 | 70177 | 225891 | Undocumented 2 | Fremontodendron spp :: Flannel Bush Tree 331 | 511 Powhattan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6008206.7868099995 | 2098146.33269 | 37.741573891916 | -122.414216334442 | (37.741573891916, -122.414216334442) | ||||
70763 | 70763 | 218990 | Undocumented 2 | Fremontodendron spp :: Flannel Bush Tree 331 | 2 Miramar Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5995344.79527 | 2089998.93152 | 37.7184722402717 | -122.458098938021 | (37.7184722402717, -122.458098938021) | |||
137445 | 137445 | 183283 | Undocumented 2 | Fremontodendron spp :: Flannel Bush Tree 331 | 1267 42nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5983032.1982 | 2106431.7242 | 37.762877043639 | -122.50187299213499 | (37.762877043639, -122.501872992135) | |||
166275 | 166275 | 218994 | Undocumented 2 | Fremontodendron spp :: Flannel Bush Tree 331 | 2 Castenada Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994388.65472 | 2101822.2930799997 | 37.750881293236105 | -122.462260931212 | (37.7508812932361, -122.462260931212) | |||
170586 | 170586 | 192394 | Undocumented 2 | Fremontodendron spp :: Flannel Bush Tree 331 | 1421 Rhode Island St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6012026.37481 | 2101771.27559 | 37.7517410145355 | -122.401264088782 | (37.7517410145355, -122.401264088782) | ||||
25589 | 25589 | 178865 | Undocumented 2 | Prunus persica :: Peach 330 | 1260 Naples St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 8ft | 6000973.92591 | 2087218.6697900002 | 37.711160097322995 | -122.438442319358 | (37.711160097323, -122.438442319358) | |||
44855 | 44855 | 201335 | Undocumented 2 | Prunus persica :: Peach 330 | 55 Bitting Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 2ft | 6012667.25651 | 2092686.59474 | 37.7268321257865 | -122.398410441015 | (37.7268321257865, -122.398410441015) | |||
47471 | 47471 | 201334 | Undocumented 2 | Prunus persica :: Peach 330 | 55 Bitting Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 2ft | 6012664.46076 | 2092688.7247099997 | 37.7268378185048 | -122.398420255305 | (37.7268378185048, -122.398420255305) | |||
47999 | 47999 | 202087 | Undocumented 2 | Prunus persica :: Peach 330 | 1 Gould St | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6012840.7018099995 | 2091116.6294200001 | 37.7225309805051 | -122.397700770686 | (37.7225309805051, -122.397700770686) | ||||
129645 | 129645 | 196362 | Undocumented 2 | Prunus persica :: Peach 330 | 1800 Illinois St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 6016258.9741400005 | 2100621.98176 | 37.7488205237488 | -122.38654692990801 | (37.7488205237488, -122.386546929908) | |||
181983 | 181983 | 196358 | Undocumented 2 | Prunus persica :: Peach 330 | 1001 25th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 4ft | 6015624.21755 | 2102039.10579 | 37.752676489353796 | -122.388840855824 | (37.7526764893538, -122.388840855824) | |||
41321 | 41321 | 221280 | Undocumented 2 | Brachychiton populneus :: Bottle Tree 329 | 970 Elizabeth St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6000248.03946 | 2101990.02339 | 37.7516774837438 | -122.442010727629 | (37.7516774837438, -122.442010727629) | |||
22816 | 22816 | 208166 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 15 Santa Rita Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993909.69845 | 2100938.88006 | 37.7484280758139 | -122.463853078355 | (37.7484280758139, -122.463853078355) | |||
29993 | 29993 | 200316 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6015592.61729 | 2115325.41388 | 37.789156021370204 | -122.38987812219601 | (37.7891560213702, -122.389878122196) | ||||
30245 | 30245 | 200301 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015414.78725 | 2115487.52698 | 37.7895912833718 | -122.39050472932101 | (37.7895912833718, -122.390504729321) | ||||
34477 | 34477 | 200323 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 21 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015655.422040001 | 2115235.75043 | 37.7889133087555 | -122.389654558808 | (37.7889133087555, -122.389654558808) | ||||
39776 | 39776 | 200298 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6015397.853619999 | 2115526.63522 | 37.7896977262219 | -122.390566052287 | (37.7896977262219, -122.390566052287) | ||||
46644 | 46644 | 200322 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 20 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015652.04458 | 2115257.33734 | 37.7889723941954 | -122.38966775277399 | (37.7889723941954, -122.389667752774) | ||||
54088 | 54088 | 200313 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015568.89503 | 2115325.6820799997 | 37.7891554422096 | -122.38996021770399 | (37.7891554422096, -122.389960217704) | ||||
60949 | 60949 | 208164 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 2 Pacheco St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994775.46403 | 2099779.39502 | 37.745294274822704 | -122.460775282677 | (37.7452942748227, -122.460775282677) | |||
65844 | 65844 | 200304 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015501.05504 | 2115417.76769 | 37.7894045256485 | -122.39020137361601 | (37.7894045256485, -122.390201373616) | ||||
68865 | 68865 | 200299 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6015401.13425 | 2115501.03994 | 37.7896276294543 | -122.390552912297 | (37.7896276294543, -122.390552912297) | ||||
99610 | 99610 | 200315 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6015579.663980001 | 2115313.43932 | 37.789122423618394 | -122.389922102621 | (37.7891224236184, -122.389922102621) | ||||
131043 | 131043 | 200308 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015536.17066 | 2115383.7256400003 | 37.78931300162861 | -122.3900774974 | (37.7893130016286, -122.3900774974) | ||||
131129 | 131129 | 200320 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015639.26424 | 2115274.89459 | 37.7890198937097 | -122.389713198212 | (37.7890198937097, -122.389713198212) | ||||
133241 | 133241 | 200317 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015614.348069999 | 2115278.98424 | 37.7890297412845 | -122.389799691409 | (37.7890297412845, -122.389799691409) | ||||
136600 | 136600 | 200311 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015556.04211 | 2115339.6543799997 | 37.7891930941324 | -122.39000566403 | (37.7891930941324, -122.39000566403) | ||||
137199 | 137199 | 208165 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 15 Santa Rita Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993900.31439 | 2100928.13283 | 37.748398025869 | -122.463884747999 | (37.748398025869, -122.463884747999) | |||
150870 | 150870 | 200309 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015536.76088 | 2115360.50758 | 37.7892492828883 | -122.390073832651 | (37.7892492828883, -122.390073832651) | ||||
156936 | 156936 | 200306 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015519.43807 | 2115394.40113 | 37.7893413860396 | -122.390136136794 | (37.7893413860396, -122.390136136794) | ||||
157497 | 157497 | 200305 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015511.618480001 | 2115384.8547 | 37.7893147400224 | -122.39016252469601 | (37.7893147400224, -122.390162524696) | ||||
158899 | 158899 | 200310 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6015548.616830001 | 2115370.6056 | 37.7892776672864 | -122.390033517844 | (37.7892776672864, -122.390033517844) | ||||
159741 | 159741 | 200302 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015426.07027 | 2115497.69973 | 37.7896198413245 | -122.39046640201201 | (37.7896198413245, -122.390466402012) | ||||
160802 | 160802 | 200303 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6015490.914419999 | 2115408.69001 | 37.789379037957296 | -122.390235824847 | (37.7893790379573, -122.390235824847) | ||||
161880 | 161880 | 200307 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015523.86991 | 2115372.58197 | 37.7892817214302 | -122.39011927809901 | (37.7892817214302, -122.390119278099) | ||||
166149 | 166149 | 200324 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015668.05261 | 2115242.24608 | 37.7889318446789 | -122.389611312224 | (37.7889318446789, -122.389611312224) | ||||
167174 | 167174 | 200314 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6015580.5733 | 2115337.47114 | 37.7891884599245 | -122.389920635833 | (37.7891884599245, -122.389920635833) | ||||
170383 | 170383 | 208162 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 1665 08th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5993685.9274 | 2104152.49812 | 37.7572389488356 | -122.464860214753 | (37.7572389488356, -122.464860214753) | |||
170559 | 170559 | 200321 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015643.39927 | 2115248.8622 | 37.788948644011704 | -122.38969707247101 | (37.7889486440117, -122.389697072471) | ||||
170787 | 170787 | 200312 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6015567.699080001 | 2115350.3892200002 | 37.7892232160342 | -122.389966082183 | (37.7892232160342, -122.389966082183) | ||||
170899 | 170899 | 200300 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6015413.39185 | 2115512.45367 | 37.7896596489335 | -122.39051129976102 | (37.7896596489335, -122.390511299761) | ||||
173164 | 173164 | 208161 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 1665 08th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5993688.247880001 | 2104180.09485 | 37.7573148561081 | -122.46485419377599 | (37.7573148561081, -122.464854193776) | |||
175891 | 175891 | 200319 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6015626.37081 | 2115265.87245 | 37.7889944060092 | -122.389757177753 | (37.7889944060092, -122.389757177753) | ||||
179992 | 179992 | 200318 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015625.97497 | 2115288.24287 | 37.7890558081156 | -122.389760110454 | (37.7890558081156, -122.389760110454) | ||||
182804 | 182804 | 200297 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6015387.81046 | 2115515.1767599997 | 37.789665706757 | -122.39059999988999 | (37.789665706757, -122.39059999989) | ||||
46110 | 46110 | 120303 | Undocumented 2 | Cussonia spicata :: Cabbage tree 325 | 100 23rd Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5988688.03017 | 2114630.28331 | 37.7857186225503 | -122.482912572966 | (37.7857186225503, -122.482912572966) | |||
52078 | 52078 | 223868 | Undocumented 2 | Cussonia spicata :: Cabbage tree 325 | 2384 Bryant St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6009659.2481 | 2103464.0717599997 | 37.756256706598 | -122.409569427713 | (37.756256706598, -122.409569427713) | |||
33512 | 33512 | 228422 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 840 27th St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6001124.36874 | 2099998.4940400003 | 37.746259119672 | -122.438837573191 | (37.746259119672, -122.438837573191) | |||
41465 | 41465 | 228421 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 840 27th St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6001133.99652 | 2099998.61422 | 37.746259997407705 | -122.438804290182 | (37.7462599974077, -122.438804290182) | |||
51601 | 51601 | 228423 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 840 27th St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6001113.13112 | 2099998.08788 | 37.746257365103205 | -122.438876402327 | (37.7462573651032, -122.438876402327) | |||
68174 | 68174 | 190639 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 845 Vermont St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6011328.94664 | 2104371.38115 | 37.7588413959188 | -122.40385884782499 | (37.7588413959188, -122.403858847825) | ||||
155476 | 155476 | 190638 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 889 Vermont St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6011331.78056 | 2104200.20298 | 37.7583715370391 | -122.403837001476 | (37.7583715370391, -122.403837001476) | ||||
179817 | 179817 | 190643 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 2 Middle Point Rd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6018217.5284400005 | 2096361.1167799998 | 37.7372292724971 | -122.379478232531 | (37.7372292724971, -122.379478232531) | ||||
24582 | 24582 | 179929 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 325 Olmstead St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 6010709.09006 | 2090936.6373700001 | 37.7219178272384 | -122.405056643155 | (37.7219178272384, -122.405056643155) | |||
27487 | 27487 | 241134 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 310 Liberty St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6004249.708330001 | 2103949.39488 | 37.7572846847685 | -122.42831206626002 | (37.7572846847685, -122.42831206626) | |||
28687 | 28687 | 241133 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 310 Liberty St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6004250.70209 | 2103942.60073 | 37.7572660858697 | -122.428308145231 | (37.7572660858697, -122.428308145231) | |||
32345 | 32345 | 241140 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 310 Liberty St | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6004179.20836 | 2103939.18183 | 37.757252652710704 | -122.428555154801 | (37.7572526527107, -122.428555154801) | |||
34337 | 34337 | 241137 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 310 Liberty St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6004221.23047 | 2103942.83176 | 37.757265052554104 | -122.42841008608299 | (37.7572650525541, -122.428410086083) | |||
37579 | 37579 | 241132 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 310 Liberty St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6004255.00436 | 2103949.66207 | 37.7572857180794 | -122.428293769555 | (37.7572857180794, -122.428293769555) | |||
45613 | 45613 | 241135 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 310 Liberty St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6004244.03462 | 2103949.13547 | 37.757283651445896 | -122.42833166968501 | (37.7572836514459, -122.428331669685) | |||
48502 | 48502 | 179935 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 549 Lisbon St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6001950.5335800005 | 2090290.00363 | 37.71964880264 | -122.43528647690901 | (37.71964880264, -122.435286476909) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");