Saturday, December 16, 2017

11/22 Update

After reviewing my population density map and realizing that I actually just made a map showing the populations per county, I began to reevaluate my project.  I have decided that if I were to make the same map using the graduated colors, but based off of the ozone pollution that exceeded standards instead, I would  be able to more effectively be able to determine/show if there is a connection between the number of asthma cases and the amount of ozone pollution.  In order to get the ozone pollution data, I went to the "California Environment Health Tracking" website where I was able to enter the criteria that I was looking for.  My ozone data is based off of the most recent data that they had on the site (2015) which is also the data year that I now plan to use for my asthma data to keep everything consistent.  After downloading the data from the website, I entered it into an excel sheet based off of the county.  Then, I exported the data into GIS where I expressed the xy coordinates and then joined the table with my county data so that I could display it on the map.  Below is my map for the percentage of days that California exceeded the US standard for ozone pollution (0.070 ppm).  I also took Maggie's advice and went for a blue color! My next step will be to download my asthma data and import it into excel.

2 comments:

  1. I'm happy you found data and your map looks great

    ReplyDelete
  2. I'm glad you were able to find data! Good idea to work with what gets your point across best, the map looks wonderful!

    ReplyDelete

Final Poster & Reflection

My poster is finally complete and I am relieved to have completed all of the coursework for this semester!  In my previous course project, I...