knitr::opts_chunk$set(echo = TRUE, warning=FALSE, message=FALSE)In this assignment, the LMOP Database is used which is including landfills projects across in the United States. The databases contains some useful information about landfills name, state, latitude and longitude, and yearly acceptance amount of waste at the landfill.
You can see the summary of Statistics for West Coast of the U.S landfills
library(rgdal)
library(leaflet)
library(plyr)
library(dplyr)
library(mapview)
library(ggmap)
library(leafpop)
library(sf)
library(gdalUtils)
library(readxl)
library(expss)
landfill = read_xlsx(path ="C:\\R\\MAP\\landfilllmopdata.xlsx")
landfill1 = landfill[c(3,4,8,10,11,23,24,26)]
landfill1= as.data.frame(landfill1)
landfill2 = na.omit(landfill1)
data = apply_labels(landfill2,
State = "West Coast of the U.S",
LDC = "Landfill Design Capacity (tons)",
WiP = "Waste in Place Year" ,
AWAR = "Annual Waste Acceptance Rate (tons per year)"
)
###
(landfill3 <- data %>%
filter(`State` %in% c("CA", "WA","OR", "AK")))## Landfill Name State
## 1 Anchorage Regional Landfill AK
## 2 Capitol Disposal Landfill AK
## 3 Central Peninsula Landfill (CPL) AK
## 4 Merrill Field Landfill AK
## 5 Palmer Central Landfill AK
## 6 South Cushman Landfill AK
## 7 All Purpose Landfill CA
## 8 Allied Imperial Landfill CA
## 9 Altamont Landfill & Resource Recovery Facility CA
## 10 American Avenue Landfill CA
## 11 American Canyon SLF CA
## 12 Anderson Landfill CA
## 13 Antelope Valley Recycling and Disposal Facility CA
## 14 Arvin SLF CA
## 15 Austin Road Landfill CA
## 16 Avenal Regional Landfill CA
## 17 Azusa Land Reclamation Company, Inc. CA
## 18 Badlands SLF CA
## 19 Bakersfield Metropolitan SLF (BENA) CA
## 20 Barstow Sanitary Landfill CA
## 21 Big Bear Refuse Disposal Site CA
## 22 Billy Wright Landfill CA
## 23 BKK Landfill-Phases I & II CA
## 24 Blythe Disposal Site CA
## 25 Boron SLF CA
## 26 Buena Vista Drive SLF CA
## 27 Burbank LF Site No. 3 CA
## 28 Calabasas SLF CA
## 29 California Street LF CA
## 30 China Grade SLF CA
## 31 Chiquita Canyon SLF CA
## 32 City of Clovis LF CA
## 33 City of Lompoc SLF CA
## 34 City of Redding/Benton LF CA
## 35 City of Santa Cruz SLF CA
## 36 Coachella Valley Disposal Site CA
## 37 Cold Canyon LF Solid Waste Disposal Site CA
## 38 Colton Sanitary Landfill CA
## 39 Contra Costa SLF CA
## 40 Corona Disposal Site CA
## 41 Coyote Canyon SLF CA
## 42 Crazy Horse Landfill CA
## 43 Crescent City SLF CA
## 44 Cummings Road Landfill CA
## 45 CWMI - KHF (MSW Landfill B-19) CA
## 46 Davis Street LF CA
## 47 Double Butte Disposal Site CA
## 48 Edom Hill Disposal Site CA
## 49 El Sobrante SLF CA
## 50 Fairmead Solid Waste Disposal Site CA
## 51 Fink Road LF CA
## 52 Foothill Sanitary Landfill, Inc. CA
## 53 Forward Landfill CA
## 54 Frank R. Bowerman SLF CA
## 55 Geer Road SLF CA
## 56 Guadalupe Rubbish Disposal Facility CA
## 57 Hanford SLF CA
## 58 Hesperia Refuse Disposal Site CA
## 59 Highgrove SLF CA
## 60 Highway 59 Landfill CA
## 61 John Smith Road Class III Landfill CA
## 62 Johnson Canyon SLF CA
## 63 Keller Canyon LF CA
## 64 Kiefer LF CA
## 65 Kirby Canyon Recycling & Disposal Facility CA
## 66 L & D Landfill Company CA
## 67 Lamb Canyon Sanitary Landfill CA
## 68 Lancaster Landfill CA
## 69 Landers Sanitary Landfill CA
## 70 Las Pulgas LF CA
## 71 Lenwood-Hinkley Refuse Disposal Site CA
## 72 Lewis Road SLF CA
## 73 Lopez Canyon SLF CA
## 74 Lost Hills SLF CA
## 75 Lucerne Valley Disposal Site CA
## 76 McFarland-Delano SLF CA
## 77 Mead Valley Disposal Site CA
## 78 Mid-Valley Sanitary LF CA
## 79 Milliken SLF CA
## 80 Mission Canyon Landfill CA
## 81 Mojave-Rosamond SLF CA
## 82 Monterey Peninsula SLF CA
## 83 Morongo Disposal Site CA
## 84 Neal Road Recycling and Waste Facility CA
## 85 Needles Solid Waste Disposal Site CA
## 86 Newby Island SLF Phases I, II, & III CA
## 87 North County SLF CA
## 88 North Miramar SLF CA
## 89 Olinda Alpha SLF CA
## 90 Otay LF CA
## 91 Ox Mountain SLF CA
## 92 Oxnard Landfills CA
## 93 Palo Alto LF CA
## 94 Phelan Refuse Disposal Site CA
## 95 Prima Deshecha SLF CA
## 96 Puente Hills LF CA
## 97 Recology Hay Road LF CA
## 98 Recology Ostrom Road LF CA
## 99 Redwood SLF CA
## 100 Ridgecrest-Inyokern SLF CA
## 101 San Marcos LF CA
## 102 San Timoteo Solid Waste Disposal Site CA
## 103 Santa Maria Regional Landfill CA
## 104 Santiago Canyon SLF CA
## 105 Savage Canyon LF CA
## 106 Scholl Canyon SLF CA
## 107 Shafter-Wasco SLF CA
## 108 Shoreline LF at Mountain View CA
## 109 Simi Valley LF CA
## 110 Sonoma County Central Disposal Site CA
## 111 South Chollas SLF CA
## 112 Southeast Regional Solid Waste Disposal Site CA
## 113 Sunshine Canyon Landfill CA
## 114 Sycamore SLF CA
## 115 Taft SLF CA
## 116 Tajiguas SLF CA
## 117 Teapot Dome Landfill CA
## 118 Tehachapi SLF CA
## 119 Tehama County/Red Bluff Landfill CA
## 120 Toland Road SLF CA
## 121 Tri-Cities Landfill CA
## 122 Trona-Argus Refuse Disposal Site CA
## 123 Twentynine Palms Disposal Site CA
## 124 Vandenberg Air Force Base LF CA
## 125 Vasco Road SLF CA
## 126 Victorville Sanitary Landfill CA
## 127 Visalia Landfill CA
## 128 West Central LF CA
## 129 West Miramar SLF CA
## 130 Western Regional SLF CA
## 131 Woodville Landfill CA
## 132 Yermo Disposal Site CA
## 133 Yolo County Central LF CA
## 134 Coffin Butte LF OR
## 135 Columbia Ridge LF OR
## 136 Crook County Landfill OR
## 137 Dry Creek Landfill OR
## 138 Finley Buttes Regional Landfill OR
## 139 Knott Landfill OR
## 140 Roseburg LF OR
## 141 Rossman's Landfill OR
## 142 Short Mountain LF OR
## 143 South Stage Landfill OR
## 144 St. Johns LF OR
## 145 Wasco County Landfill OR
## 146 Cathcart LF WA
## 147 Cedar Hills Regional LF WA
## 148 Cheyne Road LF WA
## 149 Cowlitz County Headquarters Landfill WA
## 150 Cowlitz County Landfill WA
## 151 Delano LF WA
## 152 Fort Lewis LF #5 WA
## 153 Greater Wenatchee LF WA
## 154 Horn Rapids Landfill WA
## 155 Land Recovery Landfill WA
## 156 Olympic View Sanitary LF, Inc. (OVSL) WA
## 157 Port Angeles SLF WA
## 158 Roosevelt Regional MSW Landfill WA
## 159 Sudbury Road LF WA
## 160 Tacoma City Solid Waste Facility WA
## 161 Terrace Heights LF WA
## County Latitude Longitude LDC WiP AWAR
## 1 Anchorage 61.29328 -149.6021 27104639 9782936 350084.0
## 2 Juneau 58.35280 -134.4947 1762954 894521 29750.0
## 3 Kenai Peninsula 60.44714 -151.1037 2703698 1638604 41404.0
## 4 Anchorage 61.21266 -149.8401 3295353 3295353 205044.0
## 5 Matanuska-Susitna 61.59000 -149.2100 41974220 1864879 78207.0
## 6 Fairbanks North Star 64.80476 -147.7009 10291410 4284358 104771.0
## 7 Santa Clara 37.41639 -121.9706 5501512 5501512 18742.0
## 8 Imperial 32.85800 -115.5260 13952388 4686646 199631.0
## 9 Alameda 37.75000 -121.6567 131857568 62224563 1862167.0
## 10 Fresno 36.66171 -120.1457 26838800 14285248 604059.0
## 11 Napa 38.18056 -122.2756 4830052 4830026 154826.0
## 12 Shasta 40.45000 -122.2833 16367311 4190638 520244.0
## 13 Los Angeles 34.56768 -118.1499 23693955 9351507 632347.0
## 14 Kern 35.19050 -118.9145 4171392 4171392 71250.0
## 15 San Joaquin 37.77950 -121.1767 30624000 7354000 1232753.0
## 16 Kings 36.01195 -120.1154 20803561 15600000 237741.0
## 17 Los Angeles 34.11590 -117.9290 18420000 7900000 0.0
## 18 Riverside 33.95349 -117.1176 27562500 14495537 893168.0
## 19 Kern 35.34387 -118.7585 27204423 10362077 463584.0
## 20 San Bernardino 34.83389 -117.0200 48178434 2682424 71576.0
## 21 San Bernardino 34.29940 -116.8736 720000 540000 33928.0
## 22 Merced 37.03949 -120.9724 11842027 2068181 216447.0
## 23 Los Angeles 34.03530 -117.9130 49245368 49245368 2456370.0
## 24 Riverside 33.70478 -114.6267 2000000 732963 26040.0
## 25 Kern 34.99028 -117.6475 557000 458500 3000.0
## 26 Santa Cruz 36.91738 -121.8114 6026606 4111415 103041.0
## 27 Los Angeles 34.21018 -118.3119 5391225 2000000 40722.0
## 28 Los Angeles 34.14862 -118.7095 30930000 27174083 368387.0
## 29 San Bernardino 34.08861 -117.2210 4495166 2884020 46785.0
## 30 Kern 35.42499 -118.9293 3608940 3608940 318332.0
## 31 Los Angeles 34.42806 -118.6466 60715392 40308159 1530421.0
## 32 Fresno 36.94300 -119.6850 5117004 1854250 56921.0
## 33 Santa Barbara 34.65271 -120.4426 22079782 2286019 39338.0
## 34 Shasta 40.56890 -122.4112 1000000 982000 13552.0
## 35 Santa Cruz 36.97602 -122.1061 6290595 3024722 55880.0
## 36 Riverside 33.72500 -116.1420 3238000 3238000 48550.0
## 37 San Luis Obispo 35.18730 -120.5958 19123273 6317091 155829.0
## 38 San Bernardino 34.04556 -117.3386 9297897 9271115 23628.0
## 39 Contra Costa 37.98750 -121.8453 4578840 4153922 68449.0
## 40 Riverside 33.86740 -117.5395 4000000 4000000 0.0
## 41 Orange 33.62670 -117.8312 39000000 38999999 214093.0
## 42 Monterey 36.79460 -121.6151 2064000 1642549 209345.0
## 43 Del Norte 41.79083 -124.2186 482866 482866 22611.0
## 44 Humboldt 40.76167 -124.0883 1843516 1843516 11749.0
## 45 Kings 36.10040 -120.0203 18734615 4270993 171562.0
## 46 Alameda 37.71440 -122.1948 7801335 4200719 200034.0
## 47 Riverside 33.72000 -117.1083 2100000 2100000 42245.0
## 48 Riverside 33.88141 -116.4463 6800000 6100000 483228.0
## 49 Riverside 33.79923 -117.4679 212240372 47742989 3491193.0
## 50 Madera 37.06468 -120.1991 15926354 4584561 216421.0
## 51 Stanislaus 37.38816 -121.1363 9519129 4011163 233244.0
## 52 San Joaquin 38.03710 -120.9449 92061782 5599948 288415.0
## 53 San Joaquin 37.87462 -121.1833 32882079 27029334 985263.0
## 54 Orange 33.72053 -117.7095 112816902 54928377 2613246.0
## 55 Stanislaus 37.62609 -120.8500 4984513 4984513 51818.0
## 56 Santa Clara 37.21139 -121.9014 28243689 10012567 272631.0
## 57 Kings 36.30907 -119.5957 2250385 2250385 90015.0
## 58 San Bernardino 34.34600 -117.3490 852000 639000 49560.0
## 59 Riverside 34.00667 -117.2867 3493000 3493000 211690.0
## 60 Merced 37.39389 -120.4978 26160242 7177170 320210.0
## 61 San Benito 36.82500 -121.3240 3130537 666000 94647.0
## 62 Monterey 36.53167 -121.4067 13836696 3102622 221147.0
## 63 Contra Costa 38.00472 -121.9361 74562762 19935762 1170895.0
## 64 Sacramento 38.52099 -121.1989 117420098 30557161 987018.0
## 65 Santa Clara 37.18507 -121.6711 26717112 10792455 370845.0
## 66 Sacramento 38.52800 -121.3780 3618633 1453000 222671.0
## 67 Riverside 33.88389 -116.9972 27562500 11413469 596966.0
## 68 Los Angeles 34.74740 -118.1165 21777428 8087338 185712.0
## 69 San Bernardino 34.24048 -116.3815 11888024 2556768 54844.0
## 70 San Diego 33.36444 -117.4192 6378954 2076052 21703.0
## 71 San Bernardino 34.93550 -117.1183 540000 405000 5640.0
## 72 Monterey 36.88083 -121.6994 720460 443400 24370.0
## 73 Los Angeles 34.29028 -118.3911 19203287 19103296 570035.0
## 74 Kern 35.63110 -119.7573 830800 82140 1410.0
## 75 San Bernardino 34.43070 -116.8542 60000 60000 4580.0
## 76 Kern 35.74100 -119.2540 1117000 1117000 50900.0
## 77 Riverside 33.79570 -117.2832 2312837 2312837 184386.0
## 78 San Bernardino 34.14333 -117.4300 36006163 22531623 1259540.0
## 79 San Bernardino 34.03650 -117.5583 17400000 13973400 13000.0
## 80 Los Angeles 34.11020 -118.4824 5300000 5300000 1060000.0
## 81 Kern 34.99336 -118.1388 45000000 979470 11400.0
## 82 Monterey 36.71333 -121.7667 56541504 11823644 637178.0
## 83 San Bernardino 34.05570 -116.5580 43194 43194 6204.0
## 84 Butte 39.67425 -121.7293 11697222 6050515 174204.0
## 85 San Bernardino 34.85260 -114.6310 226944 226944 1139.0
## 86 Santa Clara 37.45897 -121.9411 55759544 30296412 1578580.0
## 87 San Joaquin 38.09700 -121.1019 30898996 4008823 193750.0
## 88 San Diego 32.85600 -117.1620 6901184 6901184 627380.0
## 89 Orange 33.93361 -117.8436 96736556 83988930 2378989.0
## 90 San Diego 32.60400 -117.0050 49177036 39827486 1770494.0
## 91 San Mateo 37.49900 -122.4120 41729278 34067875 1258026.0
## 92 Ventura 34.22857 -119.2244 10201738 9244631 295729.0
## 93 Santa Clara 37.45000 -122.1050 5825175 5825175 19286.0
## 94 San Bernardino 34.43430 -117.6075 594000 445500 20037.0
## 95 Orange 33.48654 -117.6249 119092732 22331121 576041.0
## 96 Los Angeles 34.02033 -118.0060 142400000 142250454 2135318.0
## 97 Solano 38.31497 -121.8316 20391489 6506130 739614.0
## 98 Yuba 39.07171 -121.3925 27629965 5083592 249252.0
## 99 Marin 38.16610 -122.5792 23913093 15768857 442967.0
## 100 Kern 35.60254 -117.7375 11167924 3013520 58615.0
## 101 San Diego 33.07833 -117.1650 12902208 12902208 679064.0
## 102 San Bernardino 34.01170 -117.2133 12239602 6844500 300375.0
## 103 Santa Barbara 34.95250 -120.3831 10010569 5817495 125236.0
## 104 Orange 33.77639 -117.7411 13524435 13524431 3314.0
## 105 Los Angeles 33.97990 -118.0171 9738383 4291008 90606.0
## 106 Los Angeles 34.15188 -118.1967 33305699 32886801 466000.0
## 107 Kern 35.51042 -119.4108 24139435 3164654 141456.0
## 108 Santa Clara 37.42360 -122.0903 12727051 12727050 267340.0
## 109 Ventura 34.29454 -118.7954 138635608 29022661 1943595.0
## 110 Sonoma 38.29694 -122.7422 19593354 15148749 937539.0
## 111 San Diego 32.73520 -117.0669 4750000 4750000 0.0
## 112 Fresno 36.59049 -119.5624 1850000 1850000 0.0
## 113 Los Angeles 34.32352 -118.5029 109393338 62900800 2211993.0
## 114 San Diego 32.84960 -117.0267 41611821 30161247 1060152.0
## 115 Kern 35.20377 -119.4531 5910000 1627135 34849.0
## 116 Santa Barbara 34.47694 -120.1242 14001750 11999911 262655.0
## 117 Tulare 36.02111 -119.1058 5911242 3347991 119058.0
## 118 Kern 35.12362 -118.3403 2078000 1649600 60150.0
## 119 Tehama 40.19600 -122.2974 3606399 1769548 55394.0
## 120 Ventura 34.40250 -118.9981 14278310 9263676 629527.0
## 121 Alameda 37.49227 -121.9923 17343900 16814600 87661.0
## 122 San Bernardino 35.76320 -117.3990 594000 445500 2485.0
## 123 San Bernardino 34.11920 -115.9652 738000 553500 18545.0
## 124 Santa Barbara 34.71970 -120.5242 1089724 896374 8482.0
## 125 Alameda 37.75333 -121.7233 29915008 27067777 684005.0
## 126 San Bernardino 34.59333 -117.2700 49928546 11468006 313998.0
## 127 Tulare 36.39222 -119.3919 13975392 6380373 325704.0
## 128 Shasta 40.48156 -122.5350 6810601 4444888 158831.0
## 129 San Diego 32.85600 -117.1620 52665014 43828172 918669.0
## 130 Placer 38.83583 -121.3447 24104176 7711744 293473.0
## 131 Tulare 36.15056 -119.2314 9841834 2976759 44538.0
## 132 San Bernardino 34.94002 -116.7660 12560 12560 1024.0
## 133 Yolo 38.59028 -121.6922 61456096 8362222 188679.0
## 134 Benton 44.69915 -123.2251 39154705 15783641 1010276.0
## 135 Gilliam 45.63923 -120.2172 391644390 55917366 2612031.0
## 136 Crook 44.30400 -120.9120 79128886 1530105 36945.0
## 137 Jackson 42.38200 -122.7730 76698382 7528106 640845.0
## 138 Morrow 45.74470 -119.6230 85014551 12506606 766024.0
## 139 Deschutes 44.01000 -121.2550 23274878 4037686 179113.0
## 140 Douglas 43.18590 -123.3790 5200890 3527882 88163.0
## 141 Clackamas 45.36517 -122.5888 3060523 3060522 80014.0
## 142 Lane 43.97920 -123.0088 43141052 9473001 257456.0
## 143 Jackson 42.30200 -122.9560 1550347 1550347 140017.5
## 144 Multnomah 45.60830 -122.7589 14001750 14000000 42096.0
## 145 Wasco 45.56129 -121.1409 18373145 9062938 790785.0
## 146 Snohomish 47.87068 -122.1219 3883214 3883214 297869.0
## 147 King 47.44200 -122.0600 66150000 41188861 888655.0
## 148 Yakima 46.47845 -120.2689 8202600 1960669 89716.0
## 149 Cowlitz 46.24873 -122.7781 53367110 8201829 699892.0
## 150 Cowlitz 46.10800 -122.9050 2946301 2100000 100000.0
## 151 Grant 47.94200 -118.9900 84830 83500 3300.0
## 152 Pierce 47.11800 -122.6310 860879 860873 10035.0
## 153 Douglas 47.40420 -120.1704 41957519 5675623 320981.0
## 154 Benton 46.34600 -119.3460 2460976 2346265 57522.0
## 155 Pierce 46.97100 -122.2905 32251058 17740624 1161395.0
## 156 Kitsap 47.50100 -122.7820 14612441 14612441 32526.0
## 157 Clallam 48.13162 -123.5177 1026000 1026000 53536.0
## 158 Klickitat 45.80500 -120.1740 218761117 55829544 2323266.0
## 159 Walla Walla 46.07500 -118.4100 2425098 1102317 60638.0
## 160 Pierce 47.23000 -122.4990 6014715 5588721 72740.0
## 161 Yakima 46.60617 -120.4052 7171348 6387874 189540.0landfill3 %>%
tab_cells(landfill3$LDC,WiP,AWAR) %>%
tab_cols(State, total()) %>%
tab_stat_mean_sd_n() %>%
tab_pivot() %>%
set_caption ("Statistics of West Coast of the U.S landfills")| Statistics of West Coast of the U.S landfills | ||||||
|  West Coast of the U.S |  #Total | |||||
|---|---|---|---|---|---|---|
| Â AKÂ | Â CAÂ | Â ORÂ | Â WAÂ | Â | ||
| Â Landfill Design Capacity (tons)Â | ||||||
|    Mean | 14522045.7 | 25004037.1 | 65020291.6 | 28885950.4 |  | 27981762.0 |
|    Std. dev. | 16482403.9 | 35138148.5 | 107252279.9 | 54733536.9 |  | 46575716.4 |
| Â Â Â Unw. valid NÂ | 6.0 | 127.0 | 12.0 | 16.0 | Â | 161.0 |
|  Waste in Place Year | ||||||
|    Mean | 3626775.2 | 12198840.1 | 11498183.3 | 10536772.2 |  | 11661986.9 |
|    Std. dev. | 3254624.0 | 18912984.2 | 14811540.7 | 15850787.9 |  | 17984327.7 |
| Â Â Â Unw. valid NÂ | 6.0 | 127.0 | 12.0 | 16.0 | Â | 161.0 |
| Â Annual Waste Acceptance Rate (tons per year)Â | ||||||
|    Mean | 134876.7 | 436655.0 | 553647.1 | 397600.7 |  | 430247.4 |
|    Std. dev. | 122592.2 | 640995.1 | 733804.5 | 619603.1 |  | 633717.2 |
| Â Â Â Unw. valid NÂ | 6.0 | 127.0 | 12.0 | 16.0 | Â | 161.0 |
You can see map of West Coast of the U.S landfills
leaflet(landfill3) %>%
addTiles() %>%
addAwesomeMarkers(landfill3$Longitude,landfill3$Latitude, icon= awesomeIcons(iconColor = "green"),
label = ~as.character(landfill3$`Landfill Name`)) %>% addLegend("topright", colors = c("red"), labels = c("West Coast"), title = " West Coast of the U.S landfills", opacity =2)You can see map of clustering West Coast of the U.S landfills
leaflet(data = landfill3) %>%
addTiles() %>%
addCircleMarkers(data = landfill3, radius = 4, color = "blue", weight = 2, opacity = 0.1, fill = TRUE, fillColor = "red", fillOpacity = 0.1, label = ~landfill3$`Landfill Name`) %>%
addMarkers(clusterOptions = markerClusterOptions()) %>%
addLegend("topright", colors = c("red"), labels = c("West Coast"), title = " West Coast of the U.S landfills based on clustering", opacity =2)You can see map of clustering of California,Alaska, Washington and Oregon counties
setwd("C:\\R\\MAP")
counties = readOGR(dsn = '.',layer="cb_2016_us_county_500k")## OGR data source with driver: ESRI Shapefile
## Source: "C:\R\MAP", layer: "cb_2016_us_county_500k"
## with 3233 features
## It has 9 fields
## Integer64 fields read as strings: ALAND AWATERcounti_AL = subset(counties,STATEFP=="02")
counti_CA = subset(counties,STATEFP=="06")
counti_OR = subset(counties,STATEFP=="41")
counti_WA = subset(counties,STATEFP=="53")
#leaflet(options =
# leafletOptions(minZoom = 14, dragging = FALSE)) %>%
leaflet(data = landfill3) %>%
addTiles() %>%
addPolygons(data = counti_AL, weight=2,color="yellow",fillOpacity = .4) %>%
addPolygons(data = counti_CA, weight=2,color="red",fillOpacity = .4) %>%
addPolygons(data = counti_OR, weight=2,color="blue",fillOpacity = .4) %>%
addPolygons(data = counti_WA, weight=2,color="orange",fillOpacity = .4) %>%
addCircleMarkers(data = landfill3, radius = 4, color = "blue", weight = 2, opacity = 0.1, fill = TRUE, fillColor = "red", fillOpacity = 0.1, label = ~landfill3$`Landfill Name`) %>%
addMarkers(clusterOptions = markerClusterOptions()) %>%
addLegend("topright", colors = c("red"), labels = c("West Coast"), title = " West Coast of the U.S landfills based on counties", opacity =2)You can see map of clustering of California, Washington and Oregon landfills when annual waste acceptance rate is larger than 2 millions tons
(landfill4 <- landfill3 %>%
filter(`State` %in% c("CA", "WA","OR")))## Landfill Name State County
## 1 All Purpose Landfill CA Santa Clara
## 2 Allied Imperial Landfill CA Imperial
## 3 Altamont Landfill & Resource Recovery Facility CA Alameda
## 4 American Avenue Landfill CA Fresno
## 5 American Canyon SLF CA Napa
## 6 Anderson Landfill CA Shasta
## 7 Antelope Valley Recycling and Disposal Facility CA Los Angeles
## 8 Arvin SLF CA Kern
## 9 Austin Road Landfill CA San Joaquin
## 10 Avenal Regional Landfill CA Kings
## 11 Azusa Land Reclamation Company, Inc. CA Los Angeles
## 12 Badlands SLF CA Riverside
## 13 Bakersfield Metropolitan SLF (BENA) CA Kern
## 14 Barstow Sanitary Landfill CA San Bernardino
## 15 Big Bear Refuse Disposal Site CA San Bernardino
## 16 Billy Wright Landfill CA Merced
## 17 BKK Landfill-Phases I & II CA Los Angeles
## 18 Blythe Disposal Site CA Riverside
## 19 Boron SLF CA Kern
## 20 Buena Vista Drive SLF CA Santa Cruz
## 21 Burbank LF Site No. 3 CA Los Angeles
## 22 Calabasas SLF CA Los Angeles
## 23 California Street LF CA San Bernardino
## 24 China Grade SLF CA Kern
## 25 Chiquita Canyon SLF CA Los Angeles
## 26 City of Clovis LF CA Fresno
## 27 City of Lompoc SLF CA Santa Barbara
## 28 City of Redding/Benton LF CA Shasta
## 29 City of Santa Cruz SLF CA Santa Cruz
## 30 Coachella Valley Disposal Site CA Riverside
## 31 Cold Canyon LF Solid Waste Disposal Site CA San Luis Obispo
## 32 Colton Sanitary Landfill CA San Bernardino
## 33 Contra Costa SLF CA Contra Costa
## 34 Corona Disposal Site CA Riverside
## 35 Coyote Canyon SLF CA Orange
## 36 Crazy Horse Landfill CA Monterey
## 37 Crescent City SLF CA Del Norte
## 38 Cummings Road Landfill CA Humboldt
## 39 CWMI - KHF (MSW Landfill B-19) CA Kings
## 40 Davis Street LF CA Alameda
## 41 Double Butte Disposal Site CA Riverside
## 42 Edom Hill Disposal Site CA Riverside
## 43 El Sobrante SLF CA Riverside
## 44 Fairmead Solid Waste Disposal Site CA Madera
## 45 Fink Road LF CA Stanislaus
## 46 Foothill Sanitary Landfill, Inc. CA San Joaquin
## 47 Forward Landfill CA San Joaquin
## 48 Frank R. Bowerman SLF CA Orange
## 49 Geer Road SLF CA Stanislaus
## 50 Guadalupe Rubbish Disposal Facility CA Santa Clara
## 51 Hanford SLF CA Kings
## 52 Hesperia Refuse Disposal Site CA San Bernardino
## 53 Highgrove SLF CA Riverside
## 54 Highway 59 Landfill CA Merced
## 55 John Smith Road Class III Landfill CA San Benito
## 56 Johnson Canyon SLF CA Monterey
## 57 Keller Canyon LF CA Contra Costa
## 58 Kiefer LF CA Sacramento
## 59 Kirby Canyon Recycling & Disposal Facility CA Santa Clara
## 60 L & D Landfill Company CA Sacramento
## 61 Lamb Canyon Sanitary Landfill CA Riverside
## 62 Lancaster Landfill CA Los Angeles
## 63 Landers Sanitary Landfill CA San Bernardino
## 64 Las Pulgas LF CA San Diego
## 65 Lenwood-Hinkley Refuse Disposal Site CA San Bernardino
## 66 Lewis Road SLF CA Monterey
## 67 Lopez Canyon SLF CA Los Angeles
## 68 Lost Hills SLF CA Kern
## 69 Lucerne Valley Disposal Site CA San Bernardino
## 70 McFarland-Delano SLF CA Kern
## 71 Mead Valley Disposal Site CA Riverside
## 72 Mid-Valley Sanitary LF CA San Bernardino
## 73 Milliken SLF CA San Bernardino
## 74 Mission Canyon Landfill CA Los Angeles
## 75 Mojave-Rosamond SLF CA Kern
## 76 Monterey Peninsula SLF CA Monterey
## 77 Morongo Disposal Site CA San Bernardino
## 78 Neal Road Recycling and Waste Facility CA Butte
## 79 Needles Solid Waste Disposal Site CA San Bernardino
## 80 Newby Island SLF Phases I, II, & III CA Santa Clara
## 81 North County SLF CA San Joaquin
## 82 North Miramar SLF CA San Diego
## 83 Olinda Alpha SLF CA Orange
## 84 Otay LF CA San Diego
## 85 Ox Mountain SLF CA San Mateo
## 86 Oxnard Landfills CA Ventura
## 87 Palo Alto LF CA Santa Clara
## 88 Phelan Refuse Disposal Site CA San Bernardino
## 89 Prima Deshecha SLF CA Orange
## 90 Puente Hills LF CA Los Angeles
## 91 Recology Hay Road LF CA Solano
## 92 Recology Ostrom Road LF CA Yuba
## 93 Redwood SLF CA Marin
## 94 Ridgecrest-Inyokern SLF CA Kern
## 95 San Marcos LF CA San Diego
## 96 San Timoteo Solid Waste Disposal Site CA San Bernardino
## 97 Santa Maria Regional Landfill CA Santa Barbara
## 98 Santiago Canyon SLF CA Orange
## 99 Savage Canyon LF CA Los Angeles
## 100 Scholl Canyon SLF CA Los Angeles
## 101 Shafter-Wasco SLF CA Kern
## 102 Shoreline LF at Mountain View CA Santa Clara
## 103 Simi Valley LF CA Ventura
## 104 Sonoma County Central Disposal Site CA Sonoma
## 105 South Chollas SLF CA San Diego
## 106 Southeast Regional Solid Waste Disposal Site CA Fresno
## 107 Sunshine Canyon Landfill CA Los Angeles
## 108 Sycamore SLF CA San Diego
## 109 Taft SLF CA Kern
## 110 Tajiguas SLF CA Santa Barbara
## 111 Teapot Dome Landfill CA Tulare
## 112 Tehachapi SLF CA Kern
## 113 Tehama County/Red Bluff Landfill CA Tehama
## 114 Toland Road SLF CA Ventura
## 115 Tri-Cities Landfill CA Alameda
## 116 Trona-Argus Refuse Disposal Site CA San Bernardino
## 117 Twentynine Palms Disposal Site CA San Bernardino
## 118 Vandenberg Air Force Base LF CA Santa Barbara
## 119 Vasco Road SLF CA Alameda
## 120 Victorville Sanitary Landfill CA San Bernardino
## 121 Visalia Landfill CA Tulare
## 122 West Central LF CA Shasta
## 123 West Miramar SLF CA San Diego
## 124 Western Regional SLF CA Placer
## 125 Woodville Landfill CA Tulare
## 126 Yermo Disposal Site CA San Bernardino
## 127 Yolo County Central LF CA Yolo
## 128 Coffin Butte LF OR Benton
## 129 Columbia Ridge LF OR Gilliam
## 130 Crook County Landfill OR Crook
## 131 Dry Creek Landfill OR Jackson
## 132 Finley Buttes Regional Landfill OR Morrow
## 133 Knott Landfill OR Deschutes
## 134 Roseburg LF OR Douglas
## 135 Rossman's Landfill OR Clackamas
## 136 Short Mountain LF OR Lane
## 137 South Stage Landfill OR Jackson
## 138 St. Johns LF OR Multnomah
## 139 Wasco County Landfill OR Wasco
## 140 Cathcart LF WA Snohomish
## 141 Cedar Hills Regional LF WA King
## 142 Cheyne Road LF WA Yakima
## 143 Cowlitz County Headquarters Landfill WA Cowlitz
## 144 Cowlitz County Landfill WA Cowlitz
## 145 Delano LF WA Grant
## 146 Fort Lewis LF #5 WA Pierce
## 147 Greater Wenatchee LF WA Douglas
## 148 Horn Rapids Landfill WA Benton
## 149 Land Recovery Landfill WA Pierce
## 150 Olympic View Sanitary LF, Inc. (OVSL) WA Kitsap
## 151 Port Angeles SLF WA Clallam
## 152 Roosevelt Regional MSW Landfill WA Klickitat
## 153 Sudbury Road LF WA Walla Walla
## 154 Tacoma City Solid Waste Facility WA Pierce
## 155 Terrace Heights LF WA Yakima
## Latitude Longitude LDC WiP AWAR
## 1 37.41639 -121.9706 5501512 5501512 18742.0
## 2 32.85800 -115.5260 13952388 4686646 199631.0
## 3 37.75000 -121.6567 131857568 62224563 1862167.0
## 4 36.66171 -120.1457 26838800 14285248 604059.0
## 5 38.18056 -122.2756 4830052 4830026 154826.0
## 6 40.45000 -122.2833 16367311 4190638 520244.0
## 7 34.56768 -118.1499 23693955 9351507 632347.0
## 8 35.19050 -118.9145 4171392 4171392 71250.0
## 9 37.77950 -121.1767 30624000 7354000 1232753.0
## 10 36.01195 -120.1154 20803561 15600000 237741.0
## 11 34.11590 -117.9290 18420000 7900000 0.0
## 12 33.95349 -117.1176 27562500 14495537 893168.0
## 13 35.34387 -118.7585 27204423 10362077 463584.0
## 14 34.83389 -117.0200 48178434 2682424 71576.0
## 15 34.29940 -116.8736 720000 540000 33928.0
## 16 37.03949 -120.9724 11842027 2068181 216447.0
## 17 34.03530 -117.9130 49245368 49245368 2456370.0
## 18 33.70478 -114.6267 2000000 732963 26040.0
## 19 34.99028 -117.6475 557000 458500 3000.0
## 20 36.91738 -121.8114 6026606 4111415 103041.0
## 21 34.21018 -118.3119 5391225 2000000 40722.0
## 22 34.14862 -118.7095 30930000 27174083 368387.0
## 23 34.08861 -117.2210 4495166 2884020 46785.0
## 24 35.42499 -118.9293 3608940 3608940 318332.0
## 25 34.42806 -118.6466 60715392 40308159 1530421.0
## 26 36.94300 -119.6850 5117004 1854250 56921.0
## 27 34.65271 -120.4426 22079782 2286019 39338.0
## 28 40.56890 -122.4112 1000000 982000 13552.0
## 29 36.97602 -122.1061 6290595 3024722 55880.0
## 30 33.72500 -116.1420 3238000 3238000 48550.0
## 31 35.18730 -120.5958 19123273 6317091 155829.0
## 32 34.04556 -117.3386 9297897 9271115 23628.0
## 33 37.98750 -121.8453 4578840 4153922 68449.0
## 34 33.86740 -117.5395 4000000 4000000 0.0
## 35 33.62670 -117.8312 39000000 38999999 214093.0
## 36 36.79460 -121.6151 2064000 1642549 209345.0
## 37 41.79083 -124.2186 482866 482866 22611.0
## 38 40.76167 -124.0883 1843516 1843516 11749.0
## 39 36.10040 -120.0203 18734615 4270993 171562.0
## 40 37.71440 -122.1948 7801335 4200719 200034.0
## 41 33.72000 -117.1083 2100000 2100000 42245.0
## 42 33.88141 -116.4463 6800000 6100000 483228.0
## 43 33.79923 -117.4679 212240372 47742989 3491193.0
## 44 37.06468 -120.1991 15926354 4584561 216421.0
## 45 37.38816 -121.1363 9519129 4011163 233244.0
## 46 38.03710 -120.9449 92061782 5599948 288415.0
## 47 37.87462 -121.1833 32882079 27029334 985263.0
## 48 33.72053 -117.7095 112816902 54928377 2613246.0
## 49 37.62609 -120.8500 4984513 4984513 51818.0
## 50 37.21139 -121.9014 28243689 10012567 272631.0
## 51 36.30907 -119.5957 2250385 2250385 90015.0
## 52 34.34600 -117.3490 852000 639000 49560.0
## 53 34.00667 -117.2867 3493000 3493000 211690.0
## 54 37.39389 -120.4978 26160242 7177170 320210.0
## 55 36.82500 -121.3240 3130537 666000 94647.0
## 56 36.53167 -121.4067 13836696 3102622 221147.0
## 57 38.00472 -121.9361 74562762 19935762 1170895.0
## 58 38.52099 -121.1989 117420098 30557161 987018.0
## 59 37.18507 -121.6711 26717112 10792455 370845.0
## 60 38.52800 -121.3780 3618633 1453000 222671.0
## 61 33.88389 -116.9972 27562500 11413469 596966.0
## 62 34.74740 -118.1165 21777428 8087338 185712.0
## 63 34.24048 -116.3815 11888024 2556768 54844.0
## 64 33.36444 -117.4192 6378954 2076052 21703.0
## 65 34.93550 -117.1183 540000 405000 5640.0
## 66 36.88083 -121.6994 720460 443400 24370.0
## 67 34.29028 -118.3911 19203287 19103296 570035.0
## 68 35.63110 -119.7573 830800 82140 1410.0
## 69 34.43070 -116.8542 60000 60000 4580.0
## 70 35.74100 -119.2540 1117000 1117000 50900.0
## 71 33.79570 -117.2832 2312837 2312837 184386.0
## 72 34.14333 -117.4300 36006163 22531623 1259540.0
## 73 34.03650 -117.5583 17400000 13973400 13000.0
## 74 34.11020 -118.4824 5300000 5300000 1060000.0
## 75 34.99336 -118.1388 45000000 979470 11400.0
## 76 36.71333 -121.7667 56541504 11823644 637178.0
## 77 34.05570 -116.5580 43194 43194 6204.0
## 78 39.67425 -121.7293 11697222 6050515 174204.0
## 79 34.85260 -114.6310 226944 226944 1139.0
## 80 37.45897 -121.9411 55759544 30296412 1578580.0
## 81 38.09700 -121.1019 30898996 4008823 193750.0
## 82 32.85600 -117.1620 6901184 6901184 627380.0
## 83 33.93361 -117.8436 96736556 83988930 2378989.0
## 84 32.60400 -117.0050 49177036 39827486 1770494.0
## 85 37.49900 -122.4120 41729278 34067875 1258026.0
## 86 34.22857 -119.2244 10201738 9244631 295729.0
## 87 37.45000 -122.1050 5825175 5825175 19286.0
## 88 34.43430 -117.6075 594000 445500 20037.0
## 89 33.48654 -117.6249 119092732 22331121 576041.0
## 90 34.02033 -118.0060 142400000 142250454 2135318.0
## 91 38.31497 -121.8316 20391489 6506130 739614.0
## 92 39.07171 -121.3925 27629965 5083592 249252.0
## 93 38.16610 -122.5792 23913093 15768857 442967.0
## 94 35.60254 -117.7375 11167924 3013520 58615.0
## 95 33.07833 -117.1650 12902208 12902208 679064.0
## 96 34.01170 -117.2133 12239602 6844500 300375.0
## 97 34.95250 -120.3831 10010569 5817495 125236.0
## 98 33.77639 -117.7411 13524435 13524431 3314.0
## 99 33.97990 -118.0171 9738383 4291008 90606.0
## 100 34.15188 -118.1967 33305699 32886801 466000.0
## 101 35.51042 -119.4108 24139435 3164654 141456.0
## 102 37.42360 -122.0903 12727051 12727050 267340.0
## 103 34.29454 -118.7954 138635608 29022661 1943595.0
## 104 38.29694 -122.7422 19593354 15148749 937539.0
## 105 32.73520 -117.0669 4750000 4750000 0.0
## 106 36.59049 -119.5624 1850000 1850000 0.0
## 107 34.32352 -118.5029 109393338 62900800 2211993.0
## 108 32.84960 -117.0267 41611821 30161247 1060152.0
## 109 35.20377 -119.4531 5910000 1627135 34849.0
## 110 34.47694 -120.1242 14001750 11999911 262655.0
## 111 36.02111 -119.1058 5911242 3347991 119058.0
## 112 35.12362 -118.3403 2078000 1649600 60150.0
## 113 40.19600 -122.2974 3606399 1769548 55394.0
## 114 34.40250 -118.9981 14278310 9263676 629527.0
## 115 37.49227 -121.9923 17343900 16814600 87661.0
## 116 35.76320 -117.3990 594000 445500 2485.0
## 117 34.11920 -115.9652 738000 553500 18545.0
## 118 34.71970 -120.5242 1089724 896374 8482.0
## 119 37.75333 -121.7233 29915008 27067777 684005.0
## 120 34.59333 -117.2700 49928546 11468006 313998.0
## 121 36.39222 -119.3919 13975392 6380373 325704.0
## 122 40.48156 -122.5350 6810601 4444888 158831.0
## 123 32.85600 -117.1620 52665014 43828172 918669.0
## 124 38.83583 -121.3447 24104176 7711744 293473.0
## 125 36.15056 -119.2314 9841834 2976759 44538.0
## 126 34.94002 -116.7660 12560 12560 1024.0
## 127 38.59028 -121.6922 61456096 8362222 188679.0
## 128 44.69915 -123.2251 39154705 15783641 1010276.0
## 129 45.63923 -120.2172 391644390 55917366 2612031.0
## 130 44.30400 -120.9120 79128886 1530105 36945.0
## 131 42.38200 -122.7730 76698382 7528106 640845.0
## 132 45.74470 -119.6230 85014551 12506606 766024.0
## 133 44.01000 -121.2550 23274878 4037686 179113.0
## 134 43.18590 -123.3790 5200890 3527882 88163.0
## 135 45.36517 -122.5888 3060523 3060522 80014.0
## 136 43.97920 -123.0088 43141052 9473001 257456.0
## 137 42.30200 -122.9560 1550347 1550347 140017.5
## 138 45.60830 -122.7589 14001750 14000000 42096.0
## 139 45.56129 -121.1409 18373145 9062938 790785.0
## 140 47.87068 -122.1219 3883214 3883214 297869.0
## 141 47.44200 -122.0600 66150000 41188861 888655.0
## 142 46.47845 -120.2689 8202600 1960669 89716.0
## 143 46.24873 -122.7781 53367110 8201829 699892.0
## 144 46.10800 -122.9050 2946301 2100000 100000.0
## 145 47.94200 -118.9900 84830 83500 3300.0
## 146 47.11800 -122.6310 860879 860873 10035.0
## 147 47.40420 -120.1704 41957519 5675623 320981.0
## 148 46.34600 -119.3460 2460976 2346265 57522.0
## 149 46.97100 -122.2905 32251058 17740624 1161395.0
## 150 47.50100 -122.7820 14612441 14612441 32526.0
## 151 48.13162 -123.5177 1026000 1026000 53536.0
## 152 45.80500 -120.1740 218761117 55829544 2323266.0
## 153 46.07500 -118.4100 2425098 1102317 60638.0
## 154 47.23000 -122.4990 6014715 5588721 72740.0
## 155 46.60617 -120.4052 7171348 6387874 189540.0landfill4 = landfill4 %>%
filter(`AWAR`>2000000)
leaflet(data = landfill4) %>%
addTiles() %>%
addRectangles(
lng1=-113, lat1=32,
lng2=-125, lat2=50,
fillColor = "transparent") %>%
addCircleMarkers(data = landfill4, radius = 5, color = "red", weight = 2, opacity = 0.1, fill = TRUE, fillColor = "blue", fillOpacity = 0.1, label = ~landfill4$`Landfill Name`) %>%
addMarkers(clusterOptions = markerClusterOptions()) %>%
addLegend("topright", colors = c("yellow"), labels = c("West Coast"), title = " Landfills with annual waste acceptance rate is larger than 2 millions tons", opacity =2)Landfill Methane Outreach Program (LMOP) (2020, March 05). Retrieved from https://www.epa.gov/sites/production/files/2019-12/landfilllmopdata.xlsx