35 Chapter 5 Assignment 5-1: Compare heating fuel types by US counties According to a recent study by researchers at Columbia University's Mailman School of Public Health, housing heating fuel types can inuence health conditions such as asthma, obesity, developmental delays and other health conditions. According to their research, residual fuel oil #6 is amongst the dirtiest type of heating lels. [1] Cost and availability of various heating fuel types contributes to the decision of what fuel types houses use. [2] The US Census Bureau collects data about the fuel used to heat houses in the United States. In this problem, you explore what different fuel types are used throughout the country. To do so, you download the American Community Survey data from 5-year estimates at the county level, clean and join two data tables together, and create six choropleth maps comparing fuel heating types by county. While there may be newer estimates, this assignment uses 5year estimates for years 20112015. Get set up I Rename the AssignmentS-l folder to AssignmentS-lYourName. I Open the AssignmentS-laprx, insert a new map, and rename it US Home Heating Fuel by County (2011-2015). I Set the spatial reference coordinate system for your map to the projected coordinate system USA Contiguous Albers Equal Area Conic. Download and process tabular data Download American Community Survey data for US Counties I From the US Census website data.census. gov click Advanced Search. I Under Browse Filters click Topics > Housing > Physical Characteristics > Heating and Air Conditioning. I Under Browse Filters click Geography > County > All counties in the United States > Search. I Select and download the table B25040 (House Heating Fuel) for 2015 5year estimates and save it to your AssignmentS- lYourNarne folder. 36 " In Excel, open the comma separated file to clean up this data. Note that the file name will change based on the date you download the file. The only attributes that you need are a GEOID field for joining and the heating fuel type estimate fields. Rename these with logical names (for example, TOTAL, UTIL_GAS, TANK_LP_GAS, ELECTRICITY, OIL KEROSENE, COAL_COKE, WOOD, SOLAR, OTHER, NO_FUEL). Delete the margin of error fields and any unnecessary rows. Save a comma-separated file called HeatingFuel.csv and import it into file geodatabase Assignment5-1.gdb as a table called HeatingFuel and delete all originally downloaded files. Add data to the map Add Assignment5-1 YourName\\Assignment5-1.gdb\\USCounties to your map, which includes attribute: GEOID 10 = county ANSI number From the same location, add USStates, rename as STATES, and symbolize it using no color, a dark gray outline width 1.5, and labeled with the state abbreviation as a white halo. Remove overlapping labels. Add the HeatingFuel table. Join data and add fields " Clean as necessary and join the HeatingFuel table to USCounties. Export the joined features/table as Counties HeatingFuel in Assignment5-1.gdb. Create new fields called GAS (that adds fields UTIL_GAS and TANK_LP_GAS), OIL_COAL_COKE (that adds fields OIL_KEROSENE and COAL_COKE), and OTHER_NO (that adds fields OTHER and NO_FUEL). Symbolize your map " Use the Light Gray Canvas basemap. . Zoom to the contiguous lower 48 states, and create a spatial bookmark for this zoom. " Add the exported CountiesHeatingFuel layer six times and symbolize counties using each heating type normalized using TOTAL for the normalization field.. Use graduated colors with quantile classifications, 4 breaks, with labels shown as percentages with 1, 2, or 3 decimal places, depending on the data (some layers have percentage values so37 low they must be 3 decimal places). NOTE: the focus of this assignment is data joins and exploration of data and scientic so quantile classications are a good choice. I Use the following color schemes for heating fuel types: D bluepurple (4 classes) for GAS (all types) D blues (4 classes) for ELECTRICITY D grays (4 classes) for OIL_COAL_COKE D reds (4 classes) for WOOD D yelloworangebrown (4 classes) for SOLAR D greens(4 classes) for OTHERiNO I Rename each layer according to the fuel type. I Save the project with all layers on. Create a swipe Story Map I Click the link below to create a story map that uses a swipe function. https://storymaps.arcgis.com/enfapplist/swipespyglass/ I Click the BUILD A SWIPE/SPYGLASS STORY button. I In the \"Welcome to the Swipe/Spyglass Builder\" window, click the search button Q , your published map, and click Next. I Click the vertical bar layout and click Next. I Click Gas as the layer in a web map and click Next twice. I Click Open the app and check to be sure both layers can be swiped. I Type your name and today's date in the upper left corner box. I Save your story map and share it with the public and everyone in your organization. I Click Share and copy the URL to a Word document called AssignmentS- lstoryMapYourName.docx. What to turn in Turn in your AssignmentS-lYourName folder for grading, according to instructions provided by your instructor. [1] https:ffwwwmailman.columbia.edu/publiChealthn0wews/usedirtyheatingoilnycConcentrateduptoum [2] https://Www.farmersalmanaccom/Which-home-heating-lel-is-best-16760