Thursday, May 14, 2015

Lab 4 - The Application of Geospatial Skills


Introduction:

The purpose of this lab was to propose my own spatial question, and then utilize the knowledge and skills that I have developed throughout the semester to answer my spatial question. More specifically, using geoprocessing skills (vector). The question that I proposed was, where are the best locations to camp in Minnesota? Attached to this spatial question is a certain set of criteria that I have selected. The criteria is as follows:

·         Must be further than 25 miles from an interstate.

·         Must be within a half mile of the Mississippi River.

·         Must be a recreation area.

·         Must be contained within a Minnesota State Park.

Following the steps in the geographic inquiry process and utilizing an assortment of geoprocessing tools will allow me to arrive at the best camping locations in the state of Minnesota. Hopefully, my analysis will provide avid campers and nature oriented people with the best camping locations in Minnesota based off my selected criteria, which is listed above.

 
Data Source:
Based off the parameters of my question, I did not have to do much searching to find the information that satisfied my criteria. I was able to access all the necessary feature classes within the ESRI database, which is a service provided in ArcGIS. More specifically I had to tap into the database connection, where I used the SQL server as the database platform. From this point I used the geogsql.uwec.edu as the instance and used the Esri2013 as the database. After accessing all these files I was able to go into the Esri2013.DBO.USAData and find a majority the feature classes that pertained to my spatial question. My main concern with this data is that every file is from 2013, which means that some of the information could potentially be two years old. For the case of the state parks, interstates, and rivers feature class the 2013 data should be sufficient. However, in terms of the recreation areas feature class this could be outdated. Within the past two years other recreation areas could have been built, which would mean that it would not be included in my analysis. Thus, it is important to address this issue as a potential limitation to my analysis.    

 
Methods:

To begin my lab I had to gather all the necessary data that was relevant to answering my spatial question. Most of my data came from the Esri2013.DBO.USAData, which I mentioned above. The states and counties feature classes I accessed through the mgisdata folder, then used the usa folder, and accessed the usdata.gdb to locate the states and counties. After collecting all my data I created a file geodatabase that would hold all the data for my analysis. By creating a personal file geodatabase it would allow me to remain organized and give me easy access to all my created feature classes.

With all my data being displayed on ArcMap it was time to prep the data and clip certain features to the state of Minnesota. First, I conducted a definition query on the states and counties feature class, in order to display only the counties within Minnesota. After the definition query, I changed the coordinate system to NAD 1983 HARN Stateplane MN_Central_FIPS2202 (Meters). Changing the coordinate system more accurately displays Minnesota and minimizes distortion. From here I began to clip the features classes from the Esri2013.DBO.USAData to the state of Minnesota. This was necessary because the interstates, rivers, recreation areas, and parks feature classes were for the whole United States. Thus, it was pertinent that I clip these feature classes to Minnesota, which was my area of interest. Figure 1 below, which is a display of my workflow, depicts all the clips that I conducted.

After clipping all the USAData to my area of interest, I wanted to select only recreation areas in Minnesota. Under the recreation area feature class it included amusement parks, park attractions, and beaches. I was only concerned about the locations that were titled ‘parks and recreation areas’. In order to disaggregate this information I had to conduct a query, the SQL for this operation was FEATTYPE = 'Park and Recreation Area'. From here I created a new feature class based on this query, I kept the name for this feature class as the default of MN_Rec_Selection. Then I clipped the MN_Rec_Selection to the parks_MN feature class. This step can be seen in Figure 1.

Next I had to focus on the Rivers_Clip feature class and establish a buffer for the Mississippi River. Based off my criteria illustrated above, I needed to establish a half mile buffer on the Mississippi River. After this task I created my new feature class as Miss_Riv_Buff.

Following the buffer on the Mississippi River I also had to use the buffer tool on the MN_Interstates feature class. I created a 25 mile buffer on MN_Interstates. This buffer would allow me to see which camping locations would need to be excluded, because remember that one of my criteria elements stipulated that the camping location needed to be further than 25 miles away from an interstate.

Illustrated in Figure 1 below you can see that my next step was to perform an intersect between the Miss_Riv_Buff and Rec_Parks feature classes. This step resulted in the creation of Rec_Miss_Riv_Int feature class. From here I took that feature class and erased it with the Int_25Buff to arrive at my final answer, which I titled as Ideal_camp. All the steps I mentioned within my methodology can be followed more closely in Figure 1 below.             



Figure 1 - This is my workflow which depicts the steps I took to arrive at the answers to my spatial question.
Results:

Throughout my analysis I was trying to determine where the best camping locations are in Minnesota that matched my criteria. Depicted in Model 1 below you can see that my analysis provided me with two camping locations, Crow Wing State Park and Schoolcraft State Park. These two state parks in Minnesota are the best camping locations based off my parameters. Crow Wing State Park and Schoolcraft State Park would provide campers with the luxury of camping near the Mississippi River and offering great opportunities for fishing. Additionally, the further than 25 miles buffer from an interstate allows campers to have a more natural camping experience without the influence of high amounts of human traffic.

Model 1 - These maps show the ideal camping locations in the state of Minnesota based off my criteria.

Evaluation:
Performing this final lab was a great way to display the knowledge and skills that have learned throughout this course. Furthermore, this lab exposed me to the geographic inquiry process, where I was able to develop my own spatial question based off factors that are interesting to me. This lab was a fun project, but it came with a fair share of challenges. I originally wanted to do my analysis on crime data connected to commercial burglaries. I started to develop my question and found data oriented towards commercial burglaries. However, after struggling I decided to scrap that idea and focus on my interest in camping. Subsequently, I had difficulty managing my data and coming with the appropriate tools that would satisfy my criteria. After getting through these hoops and getting my data flow model (Figure 1) reviewed the rest of the lab was smooth sailing. If had an opportunity to redo this lab I would go back to focusing on my original interest in performing an analysis on commercial burglaries. I would need to develop an easier spatial question and have extra available time to complete that project to the fullest.      

 
Sources:
ESRI Software: Esri2013.DBO.USAData and usdata.gdb

Friday, May 8, 2015

Vector Analysis with ArcGIS


Goals

The goal of this lab was to utilize numerous geoprocessing tools for vector analysis, in order to determine suitable bear habitats in Marquette County, Michigan.

Background

Each point on the map represents a bear location, which was collected using a global positioning system (GPS). Based off these points the Michigan DNR would like to know which areas are suitable for them to study bear habitats.

Methods

To begin the lab I had gather all the necessary data. However, all the data had already been uploaded to our class folder, which made this process fairly simple. The landcover information came from the USGS NLCD and the DNR management units can be found here. After familiarizing myself with the data and information it can apparent to me that the bear locations were in an X Y coordinate format that was not from a spatial database. In order to correct this issue I had add the X Y coordinates as an ‘event theme’. An ‘event theme’ is a temporary display of X Y data in ArcMap. Once a created the ‘event theme’ the bear locations appeared as points in ArcMap. Since an ‘event theme’ is only temporary it was necessary to then export the points as a feature class.


After establishing the bear locations as a feature class, I then went ahead and added all the rest of the feature classes that would further assist me in the lab. Next I performed a spatial join between the bear_locations and landcover feature classes. As a result, I was able to determine which land cover type most of the bears were located in when the GPS points were collected. Based off this information I was able to conclude that the top three bear habitat types are within the landcover categories, Mixed Forest Land, Forested Wetlands, and Evergreen Forest Land.

Numerous streams are located within the study area, and based off biologist’s findings, it has been assumed that bears might be found within close proximity to streams. To test their assumption I performed a spatial query, using bear_cover as the target layer and streams as the source layer. When I examined the output table from the spatial query I found that approximately 72 percent of the bears were located within 500 meters of a stream. Since a majority of the bears are located within 500 meters of a stream, it confirms the biologist’s assumption about the relationship between bears and streams. Thus, the distance to streams is an important habitat characteristic.

Next, I wanted to find which areas within Marquette County, Michigan, are the most suitable areas for bear habitats. In order to accomplish this task I had to begin by exploring the various analysis tools within ArcToolbox. I determined that I would be a good idea to start by using the buffer tool from the overlay analysis tool category. I performed a 500 meter buffer on streams feature class, titling the output feature class as streams_buff500m. Then I executed an Intersect between suitable land cover and streams_buff500m. Following the intersect I decided to dissolve my newly created intersect feature class, which removed the internal boundaries.  

After prepping my data from the previous steps, I added the dnr_mgmt feature class for Marquette County, MI. At this point I decided to use the Clip tool from ArcToolbox and clip the study_area and dnr_mgmt feature classes together. Next I intersected my newly clipped feature class (Clip_DNR) with my Suit_Buff_Int_Dis feature class, which established Suit_DNR_Area feature class. Following that operation I decided it would be a good idea to dissolve the Suit_DNR_Area, which would eliminate the internal boundaries.

In order to provide the Michigan DNR with a more suitable habitat model for bears in Marquette County, I needed to provide them with bear management areas that are at least five kilometers from an Urban or Built up lands. I began this objective by taking the landcover feature class and performing a query on Urban or Built up lands. From this query I created a new feature class from the selected areas and titled the output feature class as Urban_Built. From this point I buffered the Urban_Built feature class by five kilometers. Following the buffer I then utilized the erase tool from the ArcToolbox, naming my output feature class DNR_Suit. As result of all these steps I finally arrived at my answer which can be further observed in Figure 1.
After arriving at my answer, which provides the Michigan DNR with a suitable habitat for bears within Marquette County, I went ahead and created a visually appealing map. I tried my best to create an acceptable Legend which would allow the intended audience to easily understand the data that is being depicted in my map. Furthermore, I provided a second map within my data frame of the state of Michigan with Marquette County being highlighted in yellow. Highlighting Marquette County within the state of Michigan will provide the intended audience with a perspective into the specific geographical location where the suitable bear habitats are positioned.

To become more familiar with Python, I was requested to write a few simple commands to perform a couple of the geoprocessing operations that I conducted in the lab. I began loading ArcGIS python window and docking it to the bottom of screen. From here I ran a buffer on the streams feature class, but this time I used a one kilometer buffer instead of the 500 meter buffer that I used in the lab. After the buffer, I wrote a code that would perform an intersect operation between the results from my new buffer and the suitable land use. Finally, I wrote a command within the python window which would erase the buffer of the urban areas that were utilized in my lab. The results from my commands in python can be seen below in figure 4.

Results: 

Figure 1 depicts the Marquette County Suitable Bear Habitats. Figures 2 and 3 shows my data flow model which I used in objectives two through six. Figure 4 is the command codes that I wrote to perform the steps in the last objective of the lab.  

Figure 1
 
Figure 2


Figure 3
Figure 4

 
Sources:

Landcover is from USGS NLCD
 
 
Streams from
 
 
 
 
 
 



Tuesday, April 7, 2015

Downloading GIS Data

Introduction:
The goal of this lab was to learn how to access, download, and map data from the U.S. Census Bureau. I was responsible for understanding the U.S. Census data and then picking a variable of my choice to download and map on ArcMap.


Methods:
I began this lab by familiarizing myself with the 2010 results published by the US Census Bureau. I also explored the different topics, geographies, and datasets that one could use within the websites search menu.

Objective One - I had to download the total population for all counties within the state of Wisconsin. Once I downloaded and unzipped that information then I had to save the csv files as an Excel Workbook. After that task was accomplished the files that I downloaded only contained tabular data, which means that the information is not associated to the geography or spatial representation for the Wisconsin counties.

Objective Two - At this step I ran into some terrible maneuvering through the US Census information. I had to switch the year in the search menu because the map tab under geography would not recognize the 2014 dataset. When I went to download the information the website was having trouble processing my request. After getting through that issue I finally was able to download the data. Then Internet Explore did not recognize the websites information so I had to change the computers settings so it would recognize the files that were being processed on the US Census Bureau’s website. Finally, I was able to download the files without any kinks.

Objective Three – I started a new blank map in ArcMap and uploaded the 050_00 shapefile and the P1 table onto the map. Next I examined the attribute tables for both the shapefile and the P1 table. In order to join the two tables I had to determine which attribute field the two tables had in common. I found the both the 050_00 shapefile and the P1 table had the GEO_ID field in common. You cannot join two tables together without determining a common attribute field to base the join off of. After that I conducted a table join between the 050_00 shapefile and the P1 table. I this point I had successfully uploaded an MS Excel file directly into ArcMap and performed a table join.

Objective Four – Once I completed joining the tables I was able to proceed and map the specific information that I was interested in. When I went into the symbology tab to map the total population for Wisconsin counties I ran into an error. The field type that I was interested in mapping could not be mapped quantitatively. In order to correct this problem I had to go ahead and add a field to the 050_00 shapefile attribute table. I renamed the new field as D001new. Then I had to use the field calculator tool to populate my newly created field. Once the D001new field was calculated then I could move forward and map Wisconsin’s total population by county quantitatively.   

Objective Five – For this objective I was responsible for selecting a variable of my choice from the U.S. Census Bureau and mapping it. Originally I wanted to map the characteristics of veterans who either have served or are currently serving in the United States Armed Forces. However, when I looked at the dataset none of the statistics were produced in the 2010 SF1 100% data, which forced me to pick another variable. I decided to download data by Sex and Age from the Census website. Specifically I chose the 21-year-old sample for males because my brother just turned 21, and I was curious what the male 21-year-old demographic looked like across Wisconsin. Throughout this objective I followed the same steps that I did in objectives one through four. I will admit that after already producing a map in this fashion it was easy to replicate another map.    


Results:
The results from the total population map shows that mostly counties that are highly urbanized have a higher concentration of inhabitants. For example, Dane County and Milwaukee County appear to have the highest population concentration when compared to the rest of Wisconsin. As for the map depicting 21-year-old males in Wisconsin, the results are similar to the total population map but a few differences are apparent. For example, Douglas County, Eau Claire County, and La Crosse County now are comparable to that of Dane County and Milwaukee County. This makes sense because these five counties are home to some of the biggest private and public educational institutions throughout Wisconsin. Which makes these five counties highly populated with 21-year-old male students.       

Figure 1:

Figure 1 Shows population statistics by counties in Wisconsin. The map on the left depicts Wisconsin’s total population by county. The map on the right depicts the male population that falls within the 21-year-old age bracket. 



Source: U.S. Census Bureau Website
http://factfinder2.census.gov/faces/nav/jsf/pages/searchresults.xhtml?refresh=t



Thursday, February 19, 2015

Lab 1 - Eau Claire Confluence Project

Background

For this lab I had to assume the role as an intern for Clear Vision Eau Claire. While interning at Clear Vision Eau Claire they announced that they were establishing a public-private partnership between local developers, University of Wisconsin-Eau Claire, and the Eau Claire Regional Arts Center to construct a new development. This new development earned the title as the Eau Claire Confluence Project. In collaboration with the other partners, Clear Vision Eau Claire has asked the interns to apply their knowledge and skills with GIS to create base maps that feature several components relating to the confluence project. These components include maps with voting districts, land use, civil divisions, census boundaries, and more.    

Goals

The goal of this lab was to become familiar with various spatial data sets for a variety of uses. Some of these uses included land use, public land management, and administrative use. Another goal of this lab was to prepare base maps for the Eau Claire Confluence Project.

Methods

I began by focusing my attention on studying the 2009_07_13_EauClaire Geodatabase and the City of Eau Claire Geodatabase. Within these geodatabases I became familiar with the feature datasets, in order to understand the topology and location for which I would be directing my attention too.

Next, I established a new geodatabase for the proposed site of the confluence project. Once the EC_Confluence geadatabase was created I used that information, as well as parcel areas from both the City of Eau Claire and Eau Claire County. From the parcel areas I was able to locate the two buildings using the Identification tool. Then I went ahead and digitized the two buildings that are located at the proposed site of the confluence project. This task was made easy due to the functionality of the Snapping tool and the formation of the polygon features that represent the two buildings.

Objective number three called for understanding the Public Land Survey System (PLSS), as well as representing this information in a data frame at the proposed site of the confluence project. In this objective I used PLSS feature from the geodatabases and then using the Identification tool I was able to read about the PLSS features, which contained numerous information including the legal descriptions. This information was valuable, but to further understand the legal descriptions I read a section from the link of the Wisconsin State Cartographer's Office.

In the next objective I created a brief legal description for the two parcels of the proposed site of the confluence project. To gather the parcel ID and the parcel number I had to use the Identification tool. Once I gathered the necessary values I went the City of Eau Claire's Property and Assessment Search Website. At this website I entered in the parcel ID for each property and read through the legal descriptions.

In the final objective I was asked to create six separate data frames, or base maps, that contained relevant information concerning issues related to the Eau Claire Confluence Project. During this final objective I built a date frame of the Civil Divisions that make up the demographic of Eau Claire County. Since this data frame is zoomed out I used the Drawing tool to create a callout label for the proposed site, in order to give the audience an appreciation for the civil divisions.  The callout label indicates the location of the proposed site and makes it easier for the audience to see the spatial data represented. In a new data frame I mapped the Census Boundaries. In this data frame I used the POP2007 as my value field and then I normalized the data by SQMI. Next I created the PLSS map by utilizing the PLSS features from the geaodatabases. This data frame was fairly easy to construct because I had become familiar with the datasets in an earlier objective. Somewhere during this last objective I got a sidetracked and ended up needing to rely on Dr. Hupy’s YouTube video display. I was glad I could apply the lessons learned in this informative video to all my data frames. The City of Eau Claire parcel data was the next frame I created. In this frame you can see that I relied a certain features, like water and centerlines, to emphasize the spatial information being portrayed. Next, I made a Zoning map to illustrate the different types of land use in and around the area of the proposed site for the confluence project. Also, in the Zoning map I placed a centerline feature for a reference and to emphasize the spatial patterns. Last, I created a data frame that contains information of the voting districts of the City of Eau Claire. After all the base maps were created I conducted edits to each frame to make it cartographically pleasing, in order to be easily understand by the intended audience.   

Results


After much work and research about the proposed site for the Eau Claire Confluence Project you can examine the results by studying Figure 1 below.


Citations

Hemstead, Brenda. "PLSS - Legal Descriptions | PLSS." PLSS - Legal Descriptions | PLSS. Wisconsin State Cartographer's Office, 20 Mar. 2014. Web. 19 Feb. 2015.

"Eau Claire, WI - Online Property Assessment Database - Search." Eau Claire, WI - Online Property Assessment Database - Search. Eau Claire Wisconsin, n.d. Web. 19 Feb. 2015. 2014.

Hupy, Christina. "Lab 1 Example." YouTube. UWEC, 17 June 2013. Web. 19 Feb. 2015.

Source: City of Eau Claire and Eau Claire County 2013