University of Manchester CS 235 Assignment 6

A study by researchers at Columbia University’s Mailman School of Public Health found
that housing heating fuel types can influence 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 fuels [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 assignment, 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 is newer data available, this assignment uses 5-year estimates for years 2011-2015.
Get set up
 Log in to Gravitas via Canvas and save the Assignment6 folder to your GISTforProAssignments folder.
 Rename the Assignment6 folder to Assignment6YourName. This folder contains the
resources that you will use to complete Assignment 6. You’ll notice that the contents are
typically called “Assignment5-1” which, in this case, correspond to the first homework
assignment in Chapter 5.
 Open the Assignment5-1.aprx, insert a new map, and rename it US Home Heating Fuel by
County (2011-2015).
 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