Friday, December 12, 2014

Lab 5: Final Project


Introduction

When I was still deciding on a major, I had considered choosing Environmental Public Health because I was very interested in how people’s environments could affect their health. Although I ultimately chose to pursue a degree in Biology, I still believe that Environmental Public Health is an incredibly interesting field, and one that can greatly benefit from the use of GIS.  In class, one of our assignments was to watch videos on the Geospatial revolution available through Penn State University.  In the second episode, there was a segment on food desert, and how maps could be used to make more compelling arguments to address areas of greatest need. This seemed was very interesting to me and gave me some of the inspiration for my own project.

Originally I had thought of trying to map potential food deserts within Wisconsin but then I had trouble finding free information on the location of grocery stores and super markets.  So I decided that I would instead focus my question on exercise, or access to publicly available resources that can help maintain an active lifestyle.  For the scope of the project, I simply wanted to map areas that would be of potential interest for people working in public health.  Areas, where limited access to certain resources may cause people to live less active lifestyles.

When generating my question for this project I had to consider the following:
 

What would my Area of Interest be?

Since I currently live in Wisconsin, I wanted to choose counties within Wisconsin to look at.  While doing research on Environmental Public Health I found articles that suggested correlations between poverty and obesity.  Links to a couple of these articles are listed below.


 
 
I decided that my area of interest would include 5 Wisconsin counties with the lowest per capita income.
 
What criteria will be used in determining a potential public health study area?
I wanted to find an area that is lacking in resources that might encourage healthy lifestyles.  I decided proximity to schools could be useful to consider because often schools will have tracks, pools and other facilities that are open to the public.  I chose to map hospitals for similar reasons, and also because they often offer programs that promote physical activity and healthy living.  I also decided to include parks and recreation areas because these seem like places where people could go and be active.  In the rest of my writing I will refer to these areas as potential wellness resources, because they are areas that have the potential to benefit people’s physical health and activity levels.  Obviously, not every single place that is included in these areas will offer the potential resources to the surrounding communities.  It is just likely that to some extent they do offer something that can benefit people’s wellness.  I also decided on an arbitrary distance (5 miles), away from any of these resources that would be my proposed study area, mainly because it is outside of a reasonable walking distance.
Question
In the five Wisconsin counties with the lowest income per capita, what areas are five or more miles away from any kind of potential wellness resource like a school, hospital, park, or recreation area?

Methods
The first step of my project was to find all of the data that I would need and to make my data flow model. 
The data that I needed are listed below, along with where I got the data from.
Economic information to determine Lowest per capita income counties in Wisconsin:
Downloaded comparative economic characteristics 2013 American Community Survey 1- Year estimates
Location of schools:  ESRI 2013 U.S. geodatabase
Location of hospitals:  ESRI 2013 U.S. geodatabase
Location of parks:  ESRI 2013 U.S. geodatabase
Location of other recreation areas:  ESRI 2013 U.S. geodatabase
All of the data that I used was from 2013, I believe that the data is timely and relevant.  For the data downloaded from the U.S. Census Bureau, I was relatively confident that the data was complete because it had information for every Wisconsin county, however for the ESRI data I was not as confident.  When I used one of the ESRI 2013 databases to map cities I realized that some of the cities within the counties I was looking at didn’t appear.  This presumably is because they were under a certain size.  I was somewhat worried criteria that I was looking at might not appear if they were too small.  I did not find the concern reasonable enough to not use the data because it was the highest quality that I could find.  Also, when I added all of the layers to my map, it did appear that the datasets were complete.
Once I had my data I made a rough draft of a data flow model that I would use for the project shown as Figure 1.
Figure 1.  Rough draft of data flow model
 
 
When I actually began working on the project however, I realized that the model I had currently set up would do a lot of unnecessary processing.  After applying a 5 mile buffer to hospitals, schools, parks and recreation areas I had planned to union them all together.  This would have wasted time working with data I was not going to look at in my final analysis.  In my revised data flow model I decided that after buffering the layers I would clip them using the 5 lowest income Wisconsin counties, and then union them together.  The revised data flow model can be seen in Figure 2.
Figure 2.  Revised data flow model
 
I followed my data flow model closely during this project.  I started with U.S. counties and used select by attribute to select for Wisconsin Counties.  Then, I joined this with the data that I had downloaded from the U.S. census bureau. After the join, I went to the column that showed income per capita for each county and I sorted it by ascending and then selected the first five listed and made a layer from these.  I then added US hospitals, parks, recreation areas, and schools and put a 5 mile buffer around them.  Once they were buffered I clipped each of them using the 5 lowest income counties as a clip feature.  I then used the union tool to make all of these buffered and clipped features into one feature.  After this was done I used the erase tool to erase this area from the 5 WI counties.  What was left was a feature that contained the areas that are 5 or more miles away from the potential wellness resources.
After this was done, I worked on producing a map that was cartographically pleasing.  This included adding a base map, removing layers that made it too cluttered, producing a locator map, adding scale bars and north arrows, and choosing colors that were easy to distinguish apart.

Results

The results of my project can be seen in the map in Figure 3.  I decided that I would show 6 different frames with maps, and then have additional information about the map written to the side of these.  The individual frames within the map were kept as simple as possible to compensate for the fact that they are smaller in size.  Because of the smaller size, the individual frames are also shown in figure 4-8.  If it was meant to be portrayed in a different medium, for instance a poster I would have probably added additional details to the map. As it is now though, I chose to show the locations of the counties within Wisconsin, and then the location that I propose would make ideal public health study areas within these counties.  The proposed public health study area being places that are more than 5 miles away from potential wellness resources and located within the 5 lowest per capita income counties in Wisconsin.

 
 
Figure 3.  Maps with propose public health study areas


Evaluation
My overall impression of this project was that it was a great way to wrap up everything that we learned during the semester.  The individual things that we were required to learn in previous labs were helpful when working on our own spatial question.  If I had to do this project again, I think I would have started by developing a better question.  I would want to do more research into environmental public health and see if there are any characteristics of places that people have already expressed an interest in researching.  If I focused more on this while developing a question, I think I could have made a project that had more potential to be useful.  I also think that I might have considered using multiple buffers to show areas with differing levels of concern. 
Sources
US schools, parks, hospitals, and recreation areas:  ESRI 2013 US geodatabase
Comparative economic characteristics 2013 American Community Survey 1- Year estimates:  U.S. Census Bureau:  http://factfinder2.census.gov/faces/nav/jsf/pages/index.xhtml
Base map:  Esri, HERE, DeLorme, USGS, Intermap, increment P Corp., NRCAN, Esri Japan, METI, Esri China (Hong Kong), Esri (Thailand), TomTom, MapmyIndia, © OpenStreetMap contributors, and the GIS User Community
 

 

Thursday, December 4, 2014

Lab 4: Vector Analysis with ArcGIS

Goals and Backgrounds

The goal of this lab was to start using the geoprocessing tools that we have learned about, to create data flow models and maps.  The goal of the lab was top map out suitable ursus americanus (black bear) habitats in a study area in Marquette County, Michigan, based on certain specifications.  The end result of this lab is a map of these bear habitats as well as a data flow model showing how this map could be achieved.

Methods and Procedures

Acquiring the Data

All of the information was made available to use in a folder provided to us.  The folder contained bear location Excel files, and the geodatabase needed to complete the project.  I copied the folder into my personal folder so that I could use it.

Producing a Feature Class from an Excel File

The bear locations that we were going to used were stored as coordinates in an Excel file.  I added the coordinates as an event them, and then exported the data as a feature class that I stored in my Lab4 geodatabase. 

Determining top Habitat Types for Bears

I did a spatial join with Bears and Land cover, and then recorded the top three habitat types the bears were found in.


Suitable Habitat based on proximity to streams

To find areas that would be good bear habitats based on proximity to streams I used the buffer tool, set at 500 meters, and then I used the dissolve tool to remove the lines between adjacent polygons.

Suitable Habitat based on stream proximity and Land cover

I created a new layer that contained only the top three habitat types for bears, then I used dissolve to remove lines between adjacent polygons, and intersect to make a new layer where this and the stream buffered layer overlapped.

Find suitable habitat layers within DNR management land

I clipped the DNR management lands to the study area, and then I intersected this with the Stream and Land cover based suitable habitat layer.

Habitat away from Urban or Built up lands

Selected Urban/Built up lands from Land cover, and created a layer out of this, I buffered it by 5 kilometers, and then I erased the habitat that intersected with that.

Results and Reflections

As a result of this Lab, I was able to produce a Map of the suitable habitat areas, as well as a data flow model of how I was able to produce this.  I think this Lab was a great way to start thinking about data flow models.  While going through the lab, it was possible at points to become overwhelmed by the number of different tools being used and the number of new features that were created.  A data flow model allows some of this confusing to be mitigated, and can help increase the effectiveness and thee efficiency of work in GIS.

Data Flow Model
Lab 4 Map

 
Sources

  Land cover:
  http://www.mcgi.state.mi.us/mgdl/nlcd/metadata/nlcdshp.html
DNR management units:
   http://www.dnr.state.mi.us/spatialdatalibrary/metadata/wildlife_mgmt_units.htm
Streams:
http://www.mcgi.state.mi.us/mgdl/framework/metadata/Marquette.html

Saturday, October 25, 2014

Lab 3: Downloading GIS Data

Goals and Background

The general purpose of this lab was to become more familiar downloading and using data.  In this lab we focused on primarily population data from the US Census Bureau.  Another goal of this lab was to learn how to join attribute data to a shapefile so that the information could be visually displayed.  Also, there was a general goal of producing a cartographically pleasing map by the end of the exercise.

Methods and procedures

The first step was to download data from the US Census Bureau, the website link was given: http://factfinder2.census.gov/faces/nav/jsf/pages/index.xhtml 
from there, it was relatively straightforward.  You could use either the advanced or guided search options to look for the specific data that you wanted, and you could additionally download the shapefile of Wisconsin Counties in the same location.

Homepage of American Fact Finder

The data was downloadable as a Zip file, which could then be extracted for you to use.  Once you had the information in ArcMap, the next step was to join the tables.  This was done by right clicking on the shapefile of Wisconsin counties and then clicking on the option "join" and connecting it to your downloaded data.

One problem that I ran into was that the population data was not stored in a number format.  This made it difficult when I was trying to map certain qualities different colors.  To solve this problem, I added a new field to the attribute data, made sure that it was listed as numeric.  Then I was able to copy the list of numbers and then produce the map that I wanted.

I used basically the same steps when I was following the specific data that the lab asked for, as when I got to choose my own data, and because of this the data frames looked very similar.

Results and Reflections

When I completed downloading the data and joining them to the shapefile, I took a few steps to try and make the map look more cartographically pleasing, the result is below.
 
 
As far as the goals of the lab went, I believe that I became much more familiar with the process of downloading data from the internet, as well as how to join together data and ways to visually portray that. 

Sources
US Census Bureau:  http://factfinder2.census.gov/faces/nav/jsf/pages/index.xhtml



Monday, October 13, 2014

Experience with esri Virtual Campus

Introduction

For this lab, we used a course offered on esri virtual campus.  There were several differences between the lab that we did as a course through esri, and our last lab which was not.  Overall I had a very positive experience using esri virtual campus and thought that it worked well for teaching both information and practical skills on geodatabases. 

Advantages to esri

There were several advantages to using esri virtual campus, mainly the fact that it was very intuitive and user friendly.  The layout was straightforward and made it easy to go through.



Screenshot of the basic layout for the course














            Also, during the exercises there were several places where you check to see what it was supposed to look like, so you could know if you had followed the directions right.



An example of a window that appears that shows what the result should look like



 
Finally, esri also had videos that could demonstrate how to do things while having someone narrate it.  The MAG book also has a DVD with it, which can be used when stuck on a problem.  I generally just tend not to use it because I forget about it as a resource.   Overall I found that esri was good way to learn about managing geodatabases.

Disadvantages to esri

I had very few problems when working with esri, aside from the fact that sometimes my screen would look slightly different then what it looked like when I clicked the "view result" links.  Others I found everything offered on esri very useful.

Comparisons and Conclusions

Personally I found the esri lab easier and more understandable than the other labs that we have done so far.  In terms of comparing it to the MAG labs, there were a lot of similarities in that I felt both gave good instructions during the exercises, and also could refer to places with more information (different places in the MAG book or links to information on esri) but esri was better in respect to actually showing you what the screen should look like.  It also had the advantage of being able to show a video which was also very helpful and just not possible with the MAG labs. I would recommend using esri in the future and keeping it as part of the Intro to GIS course.

Sources:

All screenshots from esri.com

Friday, September 26, 2014

GIS Lab 1: The Confluence Project

Goals and Background

The purpose of this lab is to learn how to map data for administrative and land use purposes.  The data used for this lab pertains to the Confluence Project. The Confluence Project is a collaborative project between UW Eau Claire and the Eau Claire Regional Arts Center.  The intent of this development is to be a mixed use facility containing University/student housing, commercial retailers and three performance spaces and a variety of other uses.

The specific goals of the lab were to:

-  Explore various datasets for Eau Claire and Eau Claire County
-  Digitize the proposed site of the Confluence Project
-  Create a brief legal description of the proposed site
-  Build a map with data frames relevant to the confluence project.


Methods and Procedure

To begin, my first step was to read information provided in the lab about the confluence project.  The readings provided are in the three links below
http://volumeone.org/news/1/posts/2014/01/21/6112_county_board_will_pledge_3_5m_to_confluence_if 

Along with other information, the location of the site was described in these readings.  This was helpful when it came time to digitize the area of the proposed site.

Digitization
For the digitization of the confluence project I completed the following steps

  1.  Created a blank geodatabase in ArcCatalog
  2.  Added the feature class pro_site (Polygon features)
  3.  Set the coordinate system from the Census Features class
  4.  Inserted an image basemap, and the parcels area feature class

After I had these steps completed, I looked at LegalOutline.jpg (In lab 1 folder) and drew polygons covering the areas of the proposed site.  Using snapping tools, I was able to snap edges and vertices to the already existing parcel layer.  Once this was done, the site was digitized, and the pro_site feature class was ready to be used.
 
Brief Legal Description
For the brief legal description I completed the following steps
 
  1.  Looked up the Parcel ID number using the identify tool while in the parcel_area layer
  2.  Went to Eau Claire's Property and Assesment Search Website and typed in the parcel ID numbers for the properties
  3.  Compiled information into a brief legal description.

Using Eau Claire's Property and Assessment Search Website and the information from the parcel layer, I was able to produce these two descriptions shown below.  A map with the parcel highlighted is shown for clarity to the side.

 
Confluence Project Data Frames
For this map I made the following Data Frames

  1.  Civil Divisions
  2.  Census Boundaries
  3.  Public Land Survey System
  4.  Zoning
  5.  Voting Districs
  6.  EC City Parcel Data

In all of the data frames I put an aerial image basemap and the proposed site of the confluence project.  Each data frame had different data portrayed so adjustments needed to be made in scale, color choices, and transparency.  All of the data came from the City of Eau Claire geodatabase.  The decisions for how to portray data usually came from decided what would best portray the most usable information, and what would be intuitive for the reader.  The completed map is shown below



Results and Reflection



The results of the lab can most effectively be seen by the above map entitled "Relevant Maps for the Confluence Project.  Patterns between the maps may be hard to discern because of the variability of the data portrayed, but a general conclusion reached by viewing some of the graphs is that the proposed location might be a good place based on the goals of the confluence project, the residential and commercial areas that already exist in the area prove that it is a location that people live and work. In reflection of what I have learned from creating this map, I have improved in skills related to formatting different values, for instance making certain values different colors or making layers transparent.  Additionally, working with a variety of types of data has shown me how to adjust the map based on what I need to show.

Sources

Data for maps:  City of Eau Claire and Eau Claire County 2013

General Information:  Eau Claire Regional Arts Center. (n.d.). Confluence. Retrieved from http://www.eauclairearts.com/confluence/ University of Wisconsin-Eau Claire. (n.d.). News @ uw-eau claire. Retrieved from http://www.uwec.edu/News/more/confluenceprojectFAQs.htm
Information for Legal Description:  Hemstead, Brenda. PLSS – Legal Descriptions. Retrieved from http://www.sco.wisc.edu/plss/legal-descriptions.html