Lab 2: Downloading GIS Data

Introduction

The purpose of this lab was to practice downloading demographic data for the state of Wisconsin. After acquiring the data, our main objective was to create two aesthetically pleasing maps each showing its own demographic information. Another purpose in this lab was to learn how to use ArcOnline to create a webmap of our final product.

Methodology

The methods for each section of the lab vary depending on the goal of the objective. Before continuing onto objective one. I read through the definitions regarding census data that had been provided to us. This was done to gain a better understanding of the different types of census data and the information they provide.

Objective one: Download 2010 Census Data

Before downloading any information, I made a “Lab 2” folder in my personal Q drive. This was important because then I was able to have all of my downloaded information files in one folder making it easier to find and navigate.

Next I began downloading information. To do so, I went to the American Factfinder website provided by the U.S. Census Bureau. Navigating through the website, I chose to search for data of Wisconsin by county. Because of the reading I did prior to this objective, I knew to select the SF1 data because it is the most simplistic data with the sole purpose of providing an accurate count of people living in the U.S. for political reasons. It also provides other demographic information (household size, racial breakdowns, housing units, etc.) which will be of use later on in the lab. The information I downloaded showed the 2010 Total Population. The information downloaded was then saved to my “Lab 2” folder where I then unzipped/ extracted the information. This was so that I could get each individual file within the dataset. For this dataset there was a metadata folder and a file containing the tabular information of the data. The metadata file was quite simple with only two columns, but it contained very important id information to be used later. I then saved the tabular data as a MS excel file entitled “Excel Workbook”.

Objective two: Download the shapefile for the WI census data

For this objective, I returned to the American Factfinder website to download the shapefile for WI. This is needed to add the data to a map in ArcMap. After downloading the file to the “Lab 2” folder, I once again had to unzip the file to see all of the parts of the file. All of these individual files together make up the shapefile so they are all important.    

Objective three: Join the data together

To join the data together, I first opened up a blank map in ArcMap and saved it as Lab2. I renamed the data frame “Population” and added the shapefile I just downloaded to the map. From here, I add the MS excel file “Excel Workbook”. This file contained the data I want to map. I then open up both datasets’ attribute table to conduct a table join. A table join is needed to join the data itself and is done so by linking a common attribute. In this case, the common attribute was the GEO#id. To actually join the tables, you right click the shapefile and go to “joins and relates” from here you put in the common field and join the tables.

Objective four: Map the data

In order to map the data, we must change the data type to numeric so that it can be mapped quantitatively. To change it, we must create a new field and use the field calculator to use data from the original field. By doing this, we can create a graduated color map of the population data we acquired. We can then select our symbology and select the new field for the value to be mapped.

Objective five: Map a variable of your choice

For the next task, we were asked to select a variable to map and compare to the population data from the previous objectives. I returned to the census website, with my previous criteria of all counties within Wisconsin still present, I was able to look at other demographic variables that fit these parameters. Focusing on the 2010 SF1 100% data, I ended up choosing age groups by sex. However, I just wanted to map the percent women in each county. After downloading the data and saving it to the lab2 folder, I unzipped it and looked at the tabular data. Because I do not need all of the fields it gives me, I made note of the field that said the amount of total women in each county. I then had to delete the row that said the field names or else ArcMap would have thought it was data for the counties. After saving the data as an MS excel file, I added the file to ArcMap in a new data frame along with a shapefile of Wisconsin counties. I then joined the tables together and added a new field so that I could amp it as a quantity map. I then changed the symbology of the map and for this map, I had to normalize the data. I normalized the female population value with the total population data from map #1. I then changed the labeling to show percentage.

Objective six: Build a Layout

This task was all about making an aesthetically pleasing map. In the layout view, I changed the page orientation to landscape and made the two data frames equal size. I also set both data frames’ projection to NAD 1983 Wisconsin TM. I also set both the scales to be the same. I then went on to add a title, “ U.S. Census Data by County- Wisconsin 2010”. I added a scale bar, legend, and north arrow to both maps. I added a source, US census bureau 2010, and my name as the author. In the legend, I made sure that I used a good amount of significant digits and got rid of unnecessary zeros. I then added a light gray canvas basemap to each map. By doing all of this, I created a professional looking map document from which I could compare total population to the percent women in Wisconsin by county (Fig.1).

Fig 1. Wisconsin County Census Data

Objective seven: Create a Webmap

To create a webmap, I first logged into ArcGIS Online through Arcmap. I then made a copy of the second map which showed the percent women in each Wisconsin County. I then had to create a feature service for the map and published it to the cloud. Afterward, I signed into my ArcGIS online account through the internet. Here, I could see my feature service I had just created under the “My Content” tab. For this service, there was a feature layer and a service definition which just provided information about the service. The feature layer was what we wanted to use to create the webmap. I added this layer to map and the data showed up on a topographic basemap within ArcGIS. From here, I went into the pop-up properties of the map to create proper labels for the interactive map. Under Configure Attributes, I selected the attribute I wanted to be shown; name, Female_Pop, and d001new. I then changed the field alias so that it would show up more professional to the users. County, Female Population, and Total Population were my aliases for the attributes. I made sure that there were 0 decimal places because it made the most sense (you cant have part of a person). After saving, I tested the pop-ups to be sure it came up properly. I then saved the map and shared it with the UWEC Geography and Anthropology organization. 

Female Population by Wisconsin County:

http://uwec.maps.arcgis.com/home/item.html?id=76d3db357bc94dc0b621d1b513db8ebb

Sources

  Factfinder2.census.gov. (2014). American factfinder - search. [online] Retrieved                                    from:http://factfinder2.census.gov/faces/nav/jsf/pages/searchresults.xhtmlrefresh=t

               [Accessed: 28 Oct 2015].

Lab 1: Base Data

GIS I Lab 1: Base Data

Background

I was told I was an intern for Clear Vision Eau Claire, a collaboration between citizens and the government to help improve the county of Eau Claire, working on the Confluence Project. The goal of this project was to build a new community arts center along with additional university student housing and commercial retail facilities. Two parcels have been purchased by UW- Eau Claire for this project and are located at 128 Graham Avenue, Hay Market parking lot and 202 Eau Claire Street. My first assignment as an intern is to develop a report which comprises of various significant information and maps regarding the Confluence Project.

Goal

The goal for this lab is to work with spatial data sets for the City and County of Eau Claire and integrate information about the Confluence Project to create 6 base maps.

Methodology

This lab had several objectives, each of which has a separate methodology.

Objective one: Explore various data sets for the City and County of Eau Claire

First, I began by creating a folder connection to the "lab1" folder in both ArcMap and ArcCatalog which contains two geodatabases for Eau Claire;
     2009_07_Eau Claire
     City of Eau Claire

By creating a folder connection, I was able to navigate the software more quickly. I was then asked to answer several questions about the City of Eau Claire geodatabase. I started by opening  "PARCEL_FEATURES"  feature dataset in the ArcCatalog. From here, I was able to determine how many feature classes and feature types were present in the dataset. By using tools learned in the previous MAG assignments, I was able to navigate/identify/preview various feature datasets and classes and their attributes/descriptions. Not all of the terms in this objective were clear. For example, I was unaware what each zoning codes meant and what their descriptions were. I looked at the "Zoning Districts and Maps" pdf provided to us to get a better understanding of Eau Claire's zoning codes and apply it to streets around town, such as water street and my own street.

Objective two: Digitize the site for the proposed Confluence Project

Once I created a blank geodatabase in ArcCatalog titled "EC_confluence" I began to digitize the proposed site for the project. I did this by first adding a blank feature class to the geodatabase with the name "pro_site" with a polygon feature type. I then added this feature class to a data frame a World Imagery base map in ArcMap. After locating the proposed site (128 Graham and 202 Eau Claire), I added the parcel area feature class and hollowed it to determine the perimeter of the two sites. To digitize the site I opened the editor toolbar and used the polygon construction tool. I used the end snapping and vertex snapping tool to create polygons around the two parcels creating a layer for the proposed site.

Objective Three: Learn about the Public Land Survey System

After reading and becoming familiar with the Public Land Survey System (PLSS) I inserted a new data frame in ArcMap with the world imagery as the base map. After finding the city of Eau Claire, I added two PLSS_townships feature classes from both the 2009-17-13 Eau Claire and the City of Eau Claire geodatabases. From here, I was able to determine what the difference was between a town and a township within the Civil Divisions feature class. During this objective, I learned that I could use the identify tool to describe locations within each township. Doing this allows for a more precise description of the location of the area at question whether it be a city, like Eau Claire, or a specific lot. There are specific ways to describe these locations in the township and range system. To help in this process, I turned to a website provided to me. This website helped in explaining the proper vocabulary and their meanings.

http://www.sco.wisc.edu/plss/legal-descriptions.html 

After dabbling with the identify tool, I made the townships hollow with a bright outline so that the underlying base map showed through. I added the PLSS_Sections feature class from both geodatabases and symbolized them by number and unique values based on Section Number. This allowed me to notice patterns within the map. Once again, I made this feature class hollow and added a new feature class, PLSS_Quarter_Quarter_sections from both geodatabases and moved them beneath the sections feature class. After making these feature classes hollow as well, I then used the identify tool again to create a description of the parcel through the given attributes.

Objective Four: Create a brief legal description of the proposed site

To begin this task, you need to find out the Parcel NO/ID for each of the two parcels of the proposed site for the Confluence Project. Determining the ID of each parcel is rather simple. Using the identify tool, I simply clicked on the parcel and the table of attributes has it right there for you. Parcel 1 (the 128 Graham) had a parcel number of 02-0365. Parcel 2 had a parcel number of 02-0363. I then went to the City of Eau Claire's Property and Assessment Search Website.

http://www.eauclairewi.gov/departments/public-works/engineering/mapping-services

From here, I was able to input each parcel number and a full report of the property. From here, I was able to put together the legal description for both parcel 1 and parcel 2. These legal descriptions contain information regarding the building (if any), the location, property class (commercial, residential, etc.), school district, and the value and sale history of the parcel.

Objective Five: Build a map of all the relevant base data for the Confluence Project

For this objective I created six maps in ArcMap, each of which contained different datasets regarding the Confluence Project. I started by creating 5 new data frames. From here, I changed the size and layout of the paper. I changed the size to 11x17 and the layout to landscape. I then resized and moved the 6 data frames so they were all the same size and evenly spaced. I put the world imagery as every base map of each data frame. To freshen up on how to create an appealing map, I watched the LAB1 demo video provided to me by Professor Hupy.

This video can be found here: http://youtu.be/p5UZYebNqJU


The first map was to consist of data of the Civil Divisions. The purpose of this map was to be a locator map of the proposed site. I added the civil divisions feature class and the pro_site feature class that I created in objective 2. I then added a title, legend, scale bar. When returning to the layout view of my 6 data frames, I realized that the scale of the map was so large that you could not see the proposed site on the map. To solve for this problem, I added a callout label indicating its location.

The next map was comprised of data referencing the Census Boundaries. Here, I added the BlockGroups and TractsGroup feature classes. In the Blockgroups feature class I chose to symbolize the variable of median age to show the average age of those located around the proposed site. This may help in determining what type of commercial places should be put into the project. This variable did not need to be normalized. I chose to symbolize median age as “unique values”. Because the median age was no more than 2 digits, I chose to use 3 significant figures in the labels to make it more eye pleasing when placed in the legend. Like in the previous map, I added a title, a legend, and a scale bar.

The next map was the PLSS features from objective three. This map just needed a scale, legend, and title.

The fourth map contains information regarding parcels for the city of Eau Claire. I added several feature classes; Parcel_area, centerlines, water, and pro_site. I made the parcel_area feature class hollow with bright outlines and changed the symbology of the other feature classes so that they were distinct from the imagery background. I then proceeded to make the map cartographically pleasing by adding a title, legend, and scale bar.

I then was asked to create a Zoning map. In a new data frame, after adding the world imagery basemap, I inserted the zoning_cla feature class. After looking at the attribute table, I pulled up the zoning codes for the city of Eau Claire so that I could better understand what each code stood for. I then went into the properties of this feature class and in the symbology tab I grouped the different zones based on the first letter of the code and created a unique symbol map. I also added the pro_site feature class along with the centerlines feature class. Just like the other maps, I added a title, legend, and scale bar.

For the final map, I was instructed to create a representation of Eau Claire’s Voting Districts. In the final data frame, I added the voting districts feature class and labeled each one by their designated ward number. I then changed the scale range of the labels and added a mask so that they were more legible upon the world imagery background. I added the pro_site feature class. This map did not need a legend, however, I did add a callout label to the proposed site because it was a larger scale map. I added a title and a scale bar to this map as well.  

Results

This lab provided me with a great deal of practice with map making. I was able to test my strengths in making an appealing map while also grasping a better understanding of my weaker areas to focus on for future assignments. Figure 1 shows the final product. As you can see, the compilation of the maps give a very general outlook on the Confluence Project. This is an advantage because then every citizen of Eau Claire should be able to look at them and understand their meanings. These maps also do a really good job of showing the location of the project and is a good representation of the area of Eau Claire surrounding the proposed site.

Fig1: This image is the final result from GIS I Lab1: Base Data

Sources

Hemstead, B. (2014). Plss - legal descriptions | plss. [online] Retrieved from:http://www.sco.wisc.edu/plss/legal-descriptions.html [Accessed: 01 Oct 2015].

Impressions, F. (2014). Eau claire confluence project | community involvment collaboration. [online] Retrieved from: http://www.eauclairearts.com/confluence/ [Accessed: 01 Oct 2015].

Legal Description and Permitted Encumbrances. (2014). [e-book] pp. B-1, B-2. Available through: Christina Hupy, Geog 335, UWEC [Accessed: 01 Oct 2015].

Lippelt, I. (2002). Understanding wisconsin township, range, and section land descriptions. [e-book] Madison, WI: pp. 1-4. Available through: Wisconsin Geological and Natural History Survey [Accessed: 01 Oct 2015].

ZONING DISTRICTS AND MAPS. (2011). [e-book] Eau Claire: p. 510. Available through: Christina Hupy, Geog 335, UWEC [Accessed: 01 Oct 2015].