For this assignment, first provide a summary of the dataset using expss and then create a series of 4 maps that analyze locations and characteristics of landfills in the United States. See the "dictionary" tab on the Excel worksheet for variable information. Use must use leaflet for this assignment. Combining or recoding variables may improve your analysis.
The data are available from the Environmental Protection Agency (EPA) here: https://www.epa.gov/lmop/landfill-technical-data See the link named "Landfill-level data only." (Links to an external site.)
In one or more maps you must use:points with labels;a map legend;maps using radius (proportion to size) by referencing another variable;a polygon layer that is merged with data of your choice; anda rectangle layer to emphasize an area (use the counties or districts shapefiles provided in the Files section of this course, or another shapefile of your choice)a count of points in a subset of polygons, for a geographic region you wish to focus oninclude a photograph of trash that you see in your neighborhoodBe sure you create maps with attention to the design principles presented in class, and that show a variety of methods and layers to create a rich perspective on your data.
Each map should have an accompanying description that is detailed and clearly written.USE Ralso include an introduction, methods of data processing, analysis results, and conclusion thanks
Summary Count of Unique Landfills in this File 2,632 The LMOP Database contains key information about MSW landfills and LFG energy projects in the United States. Information in the LMOP Database is compiled from a variety of sources. Data received for inclusion in the LMOP Database are reviewed for reasonableness and are corroborated via other data sources when possible. Not all data are updated each year. While the Program strives to keep the information as updated and accurate as possible, the database is not exhaustive. The LMOP Database does not include data for every MSW landfill in the United States. &"Arial,Bold"&12Summary for Current LMOP Landfill and LFG Energy Project Database - All Landfills &"Arial,Regular"&8&F&"Arial,Regular"&8 9/17/2021 LMOP Database GHGRP ID JAlvis: GHGRP ID corresponds to the 7-digit Facility Identifier assigned to facilities required to report under EPA's Greenhouse Gas Reporting Program Landfill ID JAlvis: Unique identifying number for each landfill Landfill Name JAlvis: Landfill name State JAlvis: State landfill is located in Landfill Alias JAlvis: Alternate landfill name Physical Address JAlvis: Physical address of landfill City JAlvis: City landfill is located in or near County JAlvis: County landfill is located in Zip Code JAlvis: Zip code for the landfill Latitude JAlvis: Latitude coordinate (decimal) for the landfillLongitude JAlvis: Longitude coordinate (decimal) for the landfillComposting? Jeanette Alvis: Yes indicates that composting operations exist near the landfill (within 1 mile). Composting facility may not be owned or operated by the same organization as the landfill.Ownership Type JAlvis: Indicates if landfill is publicly owned, privately owned, or co-owned by public and private entities Landfill Owner Organization(s) JAlvis: Organization that owns the landfill Landfill Operator Organization JAlvis: Organization that operates the landfill Year Landfill Opened JAlvis: Year landfill opened or began accepting waste (YYYY) Landfill Closure Year JAlvis: Year landfill stopped accepting waste or is expected to stop accepting waste or year landfill closed or is expected to close (YYYY) Current Landfill Status JAlvis: Open/Closed status of landfill Design Landfill Area (acres) JAlvis: Design waste mass area of landfill in acres Current Landfill Area (acres) JAlvis: Current waste mass area of landfill in acres Design Landfill Depth (feet) JAlvis: Design waste mass depth of landfill (maximum or average) in feet Current Landfill Depth (feet) JAlvis: Current waste mass depth of landfill (maximum or average) in feet Landfill Design Capacity (tons) JAlvis: Waste design capacity of landfill in short tons Waste in Place (tons) JAlvis: Waste-in-place at the landfill in short tons Waste in Place Year JAlvis: Year corresponding to the waste-in-place at the landfill (YYYY) Annual Waste Acceptance Rate (tons per year) Jeanette Alvis: Annual acceptance rate of waste at the landfill in short tons per year Annual Waste Acceptance Year Jeanette Alvis: Year corresponding to the annual waste acceptance rate at the landfill (YYYY) Does LF Recirculate Leachate? Jeanette Alvis: Does landfill currently recirculate leachate (during the past year)? Leachate Recirc Frequency (Past 10 Yrs) Jeanette Alvis: At what frequency does landfill recirculate leachate (over the past 10 years)? Permitted as RD&D LF? Jeanette Alvis: Is landfill permitted under the Research, Development and Demonstration (RD&D) Permits Rule for MSW landfills? LFG Generated (mmscfd) JAlvis: Estimated amount of landfill gas generated by landfill in million standard cubic feet per day LFG Collection System In Place? JAlvis: Is there a landfill gas collection system in place? 'Yes' for an active GCCS; 'No' if landfill has no gas collection system, is passively venting/flaring, or has perimeter gas wells. LFG Collected (mmscfd) JAlvis: Amount of landfill gas being collected in million standard cubic feet per day LFG Collected Year JAlvis: Year corresponding to the landfill gas collected at the landfill (YYYY)Percent Methane JAlvis: Percent of landfill gas that is methane (typically 40-50%) Flares in Place? JAlvis: Is there one or more flares in place at the landfill? Number of Flares JAlvis: Number of flares in place at the landfill LFG Flared (mmscfd) JAlvis: Amount of landfill gas flared (if project is operational, amount of landfill gas flared in back-up flare(s)) in million standard cubic feet per dayLFG Flared Year JAlvis: Year corresponding to the landfill gas flared at the landfill (YYYY) Gas Collection System Comments JAlvis: Comments regarding the flaring (and gas collection) system at the landfill 10073411994Anchorage Regional LandfillAK15500 E. Eagle River Loop RoadEagle RiverAnchorage9957761.293281-149.602138NoPublicMunicipality of Anchorage, AKMunicipality of Anchorage, AK19872043Open16511230015027,104,63910,097,2552019314,3192019NoNot usedYes7.33Yes3.383201951Yes14/10-GCCS in operation since Oct. 2006.; 2010-53 wells, system capacity=2000 acfm.; 9/13-36 vertical wells, 21 horizontal wells, and 8 interconnections with leachate system collect from 87 acres, enclosed flare from Parnell Industries. 101038911941Capitol Disposal LandfillAK5600 Tonsgard CourtJuneauJuneau9980158.3528-134.4947NoPrivateWaste Management, Inc.19652045Open35381,770,499923,523201929,0022019NoNot usedNoYes0.709201923.3Yes10.70920199/10-16 wells over 13 acres, system installed in 2009, 1 open flare. 100534912216Central Peninsula Landfill (CPL)AKSoldotna Landfill; Central Peninsula Baling Facility; Soldotna KPB Central Landfill46915 Sterling HighwaySoldotnaKenai Peninsula9966960.44714-151.10369NoPublicKenai Peninsula Borough, AKKenai Peninsula Borough, AK19692042Open24.82,703,6981,680,681201942,0772019YesSeveral times per yearYes0.657NoNo2010-Passive venting. 10960Kodiak Island Borough LandfillAK1203 Monashka Bay RoadKodiakKodiak Island9961557.80874-152.40761NoPublicKodiak Island Borough, AKKodiak Island Borough, AK2014Closed100228,688200714,6742007UnknownNot usedNoNoUnknown 100438011020Merrill Field LandfillAK800 Merrill Field DriveAnchorageAnchorage9950161.21266-149.84012NoPublicMunicipality of Anchorage, AK19601987Closed185.73,295,3533,295,3531987205,0441987NoNot usedNo0.59Yes0.148201933.4Yes10.14820192012-30 wells, system capacity=500 acfm. 101144810980Palmer Central LandfillAKCentral Landfill - MatSu Borough1201 N. 49th State Street Just off the Palmer-Wasilla HighwayPalmerMatanuska-Susitna9964561.59-149.21NoPublicMatanuska-Susitna Borough, AKMatanuska-Susitna Borough, AK19802168Open4541,974,2201,941,322201976,4432019NoNot usedYesNoUnknown 100680610961South Cushman LandfillAKFairbanks North Star Borough S. Cushman Landfill455 Sanduri StreetFairbanksFairbanks North Star9970164.80476-147.70085NoPublicFairbanks North Star Borough, AKFairbanks North Star Borough, AK19632067Open97.710,518,6224,388,5002019104,1422019YesSeveral times per yearYes0.858NoNo3/11-13 wells installed in 2010, not connected yet, will be low flow.; 2012-Passive vents/flares only. 11000Unalaska LandfillAK1181 Summer Bay RoadUnalaskaAleutians West9968553.88463-166.50657NoPublicCity of UnalaskaCity of Unalaska19702013Closed309002007UnknownNot usedNoUnknownUnknown 100129710860Arrowhead LandfillALPerry County Associates LandfillOn Cahaba Road Entrance at 626 Tayloe RoadUniontownPerry3678632.413-87.4685NoPrivateGreen Group Holdings, LLC20072099Open425.336,527,7584,583,042201952,1392019YesSeveral times per yearNo0.3NoNo 27Athens/Limestone County SLF MSWLFALStrain Road off Highway 31AthensLimestone3561134.7634-86.9399NoPublicCity of Athens, ALCity of Athens, AL19721996Closed65781,195,575UnknownNot usedNoNoNo 16Bishop Landfill CompanyAL379 Pleasant Grove Cutoff RoadAlbertvilleMarshall3595034.27823-86.33707NoPrivateBishop Landfill CompanyBishop Landfill Company19682002Closed4528187.52,700,00083,9502000UnknownNot usedNoNoNo 10042452005Black Warrior Solid Waste FacilityAL3301 Landfill DriveCokerTuscaloosa3545233.24314-87.66585NoPublicBlack Warrior Solid Waste Disposal Authority, ALBlack Warrior Solid Waste Disposal Authority, AL19972037Open22080.39,826,8727,330,0892019307,9712019NoNot usedNo5.2Yes0.557201965Yes10.55720194/07-Flares assumed to be passive (LFG Specialties indicated in 2004 that flare(s) was in place).; 7/08-Installing GCCS & flare.; 2012-55 wells, system capacity=1400 acfm.; 5/14-Currently flaring 600 scfm at 50% methane. 2006Blount County/Nectar/Hayden LF & TSAL2390 Armstrong LoopHaydenBlount3507933.8888-86.712NoPublicBlount County, ALBlount County, AL19801994Closed16022,880UnknownNot usedNoNoNo 10044152408Brundidge LandfillAL515 Cleanwater DriveBrundidgePike3601031.7041-85.8299NoPrivateBrundidge AcquisitionsBrundidge Acquisitions20012397Open23,947,035885,9332019632019NoNot usedNoNoUnknown 6Calhoun County SLFALAnniston SLF3625 Morrisville RoadAnnistonCalhoun3620133.675-85.92NoPublicCalhoun County Commission, ALCalhoun County Commission, AL19691993Closed4,350,0007,252UnknownNot usedNoNoNo 100163323Cedar Hill LandfillALHarmons SLF MSWLF, Urban Sanitation Corporation SLF1319 N. Business Creek RoadRaglandSt. Clair3513133.68345-86.25272NoPrivateWaste Management, Inc.Waste Management, Inc.19752353Open5010061,657,0705,156,2072019198,2782019YesSeveral times per yearNo1.81Yes0.751201946.6Yes10.75120199/10-19 vertical & 1 horizontal gas well, system installed ~1998, 1 candlestick flare.; 2012-51 wells, system capacity=1800 acfm. 10078138Chastang SLFALCity of Mobile SLF MSWLF17045 Highway 43Mt. VernonMobile3656031.06179-88.02503NoPublicCity of Mobile, ALWaste Management, Inc.19762153Open199102.611637,173,9347,585,3622019214,5912019NoOccasionally but not every yearNo3.92Yes1.177201937.5Yes11.17720199/10-100 wells over 87 acres, system installed in 2000, 1 open flare.; 2010-101 wells, system capacity=3000 scfm. 2409Chilton County LandfillAL300 Industrial DriveThorsbyChilton3517132.9285-86.7405NoPrivateRepublic Services, Inc.Republic Services, Inc.ClosedUnknownNot usedNoNoUnknown 10106612City of Decatur-Morgan County Regional MSW LandfillALDecatur SLF MSWLF; Morgan County Regional Landfill500 Landfill DriveTrinityMorgan3567334.6175-87.10163NoPublicCity of Decatur, AL; Morgan County, ALCity of Decatur, AL19802050Open223.472806011,360,1466,094,5282019211,2142019NoOccasionally but not every yearNoYes0.776201954.4Yes10/03-GCCS being installed now, 12 wells initially with an additional 55-60 wells later.; 1/05 - ~80 vertical wells installed.; 12/11-Most recent GCCS expansion in Spring 2011. 101095719City of Dothan SLF MSWLFAL1290 Burkett RoadDothanHouston3630331.238766-85.356721NoPublicCity of Dothan, ALCity of Dothan, AL19772030Open49.35,266,7413,819,306201910,4402019NoNot usedNoNoNo 10061869Coffee County Sanitary LandfillAL7733 Highway 125ElbaCoffee3632331.507053-86.000975NoPublicCoffee County Commission, ALCoffee County Sanitary Landfill19932048Open45061.6606,765,3403,972,8932019221,3152019NoNot usedNo2.01Yes0.72201954Yes0.72201912/06-4 passive candlestick flares; 1/07-Adding 5th passive flare in couple weeks.; 11/10-Active gas collection & destruction began in late 2009.; 2012-39 wells, system capacity=1400 acfm. 3Cullman County SLFALHighway 69 near Cold SpringsCullmanNoPublicCullman County Commission, ALCullman County Commission, AL19741993Closed7530912,793199373,255UnknownNot usedNoNoNo 10073824Cullman Environmental Waste Management CenterAL2805 AL Highway 69 SouthCullmanCullman3505734.02878-86.90069NoPrivateCullman Environmental, Inc.Cullman Environmental, Inc.19932040Open29602,937,0451,871,531201988,2532019YesSeveral times per yearNo0.603NoNo 100701815Eastern Area LandfillAL2787 Alton DriveBirminghamJefferson3521033.5978-86.6288NoPublicCity of Birmingham, ALCity of Birmingham, AL19742026Open72484,469,5154,394,83620198142019NoNot usedNo1.83NoNo 35Florence SLF MSWLFAL29485 Waterloo Road & Savannah Highway State Highway 20FlorenceLauderdale3563034.806005-87.714765NoPublicCity of Florence Public Works, ALCity of Florence Public Works, AL19882015Closed37171,361,816200964,0102007UnknownNot usedNoNoNo 34Florence SLF MSWLF (Old)ALIrvine AvenueFlorenceLauderdale3563034.803-87.7058NoPrivateHensley-Graves Holdings LLC19721988Closed391,461,912UnknownNot usedNoYes50No 100583911Huntsville MSWLFAL4100 Leeman Ferry Road SWHuntsvilleMadison3580434.6885-86.592NoPublicCity of Huntsville S.W. Disposal AuthorityCity of Huntsville S.W. Disposal Authority19462060Open2151914011,928,8232019378,7862019NoNot usedNo2.09NoNo2010-Passive venting only now. 10Irvington SLFAL7195 Half Mile RoadIrvingtonMobile3654430.490688-88.210629NoPublicMobile County CommissionMcCrory & Williams19741981Closed8030967,998UnknownNot usedNoYes50No 100401425Jefferson County LF No. 1ALMt. Olive SLF MSWLF101 Barber BoulevardGardendaleJefferson3507133.711-86.873NoPublicJefferson County, ALSantek Environmental, Inc.19822057Open163.770.419,347,8935,167,2552019420,2532019NoNot usedNo1.6NoNo 100568013Jefferson County LF No. 2ALTurkey Creek SLF MSWLF7035 Narrows RoadPinsonJefferson3512633.7077-86.7104NoPublicJefferson County, ALSantek Environmental, Inc.19822099Open65.93,483,9971,665,314201912019NoNot usedNo1.1NoNo 100787520Magnolia Subtitle D MSW LFAL15140 County Road 49SummerdaleBaldwin3658030.45727-87.7761NoPublicBaldwin County, ALBaldwin County, AL19972036Open9647.9106,408,2374,125,5652019196,8552019NoNot usedNo2.68Yes0.832201955Yes0.832201912/07-7 wells in, 1 flare going in Spring 08.; 2012-23 wells, system capacity=1200 acfm. 31Monroe County SLFALMonroevilleMonroe31.59573-87.33187NoPublicMonroe County Commission, AL19821998Closed69.51,205,385199875,3371998UnknownNot usedNoNoNo 10024642011Morris Farm LandfillALLawrence County Disposal, Inc.4 County Road 418HillsboroLawrence3564334.70381-87.22116NoPrivateRepublic Services, Inc.Republic Services, Inc.19972067Open5516,643,1636,323,8652019262,7442019NoNot usedNo2.38Yes1.429201947.9Yes1.42920192012-40 wells, system capacity=2500 acfm. 100602814New Georgia MSWLFALBirmingham SLF2800 47th Avenue NorthBirminghamJefferson3520733.585-86.815NoPublicCity of Birmingham, ALCity of Birmingham, AL19702030Open149609,644,7567,758,3712019130,7882019NoNot usedNoYes1.350Yes11.33/10-90 wells installed in 1990, 10 wells added in 2003, 100% coverage of LF. 100695718North Montgomery SLF MSWLFAL115 Division StreetMontgomeryMontgomery3610432.4131-86.3245NoPublicCity of Montgomery, ALCity of Montgomery, AL19692040Open34848.710,840,9302019113,5222019NoNot usedNo2.47Yes0.435201949Yes10.43520194/05-Flare is used 1-2 days/month on average for pressure regulation and when the end user is not running.; 10/11-Total of 64 wells installed as of 2008.; 2012-79 wells, system capacity=1500 acfm. 100264622Pine View SLF MSWLFALWalker County Disposal, Inc.2730 Bryan RoadDoraWalker3506233.71458-87.04981NoPrivateRepublic Services, Inc.Republic Services, Inc.19932025Open16687.27520,503,11610,653,8412019277,5662019NoNot usedNo4.78Yes1.732201953.1Yes11.73220195/03-Plan to install collection system in 2003.; 12/08-43 extraction wells, 3 condensate sumps, & a utility flare.; 9/10-81 wells over 70 acres, 1 candlestick flare.; 2012-84 wells, system capacity=4000 acfm. 100326517Salem LandfillALOpelika Sanitary LF; Salem Waste Disposal, Inc. MSWLF4210 Lee Road 183OpelikaLee3680432.65347-85.2636NoPrivateWaste Management, Inc.Waste Management, Inc.19852099Open22210735,878,84312,171,1552019317,6822019NoNot usedNo4.93Yes2.64201947.7Yes12.6420192012-81 wells, system capacity=2500 scfm. 10063042410Sand Valley LandfillALLebanon Landfill; GEK, Inc.3345 County Road 209CollinsvilleDeKalb3596134.342-85.862NoPrivateRepublic Services,