Module 1.3: Data Quality - Assessment

For this week's lab assignment, we compared the total lengths of roads for two different road networks: TIGER Roads and Street Centerlines The TIGER Roads shapefile came from the US Census Bureau whereas the Street Centerlines shapefile came from Jackson county, Oregon. The objective was to determine the quality and completeness of the road networks. The total length was used as the simple measure of completeness, assuming that more roads means a more complete network.

The first step in the analysis was to determine the total lengths of the roads in each network for the entire county. I used the Project tool to project TIGER Roads into the same coordinate systems as the Street Centerlines shapefile. Then I used the Summarize tool  to determine the total length in each county. The TIGER Roads was found to be longer than the Street Centerlines, thus making it the more complete road network.

The second step of the analysis was to determine the total length of the roads within each grid for both networks. I performed the following steps in my workflow for this analysis: 

  1. I used the Clip tool to clip each road network to the grid. I did this because there were road segments that resided outside the outer boundaries of the grid polygons. To ensure these segments did not affect the length calculations, I clipped each to the actual study area: the Grid feature layer. 
  2. After each road network was clipped, I added a new field to the attribute table and used the Calculate Geometry tool for each road network. This step was necessary because the original geometry of the road networks was changed when clipped, thus changing the length of the networks. 
  3. I then used the Summarize Within tool with the Grid as the input and the length field for each road network. I used this tool because it broke each road network into segments and only calculated the lengths of the segments within each grid polygon. 
  4. I then used the Table to Excel tool to export each road network attribute table to Excel so that I could calculate the percent differences of the lengths of the segments within each grid polygon between the two road networks. For this step, I copied the length for each road network into a new Excel spreadsheet and created a new column where I used the equation provided in the lab to calculate the percent difference between the segments within each polygon of the two road networks. I used zero values for the calculations that had divisions by 0 (there were two). I saved the new Excel table and added it to the map. 
  5. I used the Add Join tool to join the new Excel table to the Grid feature layer. I used this toll so that I could use graduated symbology to visually represent the percent differences of the road segments within each grid polygon between the two road networks.
In this analysis, negative values mean the TIGER Roads had longer segments and positive values mean the Street Centerlines had longer segments.  
The map layout below is the result of the second analysis:



Comments

Post a Comment

Popular posts from this blog

Module 2: Coordinate Systems

Image
In this week's lab I explore different coordinate systems and projections in order to better understand the nature of distortions introduced by the systems. For the last part of the lab, I was tasked with selecting a state in the contiguous US and selecting an appropriate projection for the area. I selected the state of Wyoming as my area of interest. Wyoming has 4 State Plane zones and two UTM zones, so neither a single State Plane nor UTM system would work for this area without distorting the size or shape of the state. Therefore, the best coordinate system for this area is Custom Coordinate system. I chose NAD 1983 WyLam (Meters), a custom system specifically for the state of Wyoming, as the projected coordinate system. This coordinate system is a Lambert secant-case normal-aspect conic type projection which preserves shape and is appropriate for a general reference map. The standard parallels are placed at 41N and 45N, the boundaries of the state of Wyoming, which minimizes
Read more

Module 6: Proportional Symbol and Bivariate Choropleth Mapping

Image
The objectives of this week's lab was to explore proportional symbol and bivariate choropleth mapping techniques, as well as customizing legends for each technique. One of the data sets for this lab included positive and negative values. The final map utilizes proportional symbols to show both positive and negative values. This map is essentially two proportional symbol maps overlaid on each other, one for positive job growth and another for negative job growth, with the symbols for both variables sized the same. Utilizing proportional symbols to show both positive and negative values is an effective way to visualize areas that show the greatest and lowest values. These areas are easy to see quickly on the map and give the map reader a simple way to visualize the variable being mapped. Fig 1. Proportional symbol map using positive and negative values.  Another data set for this lab examined contained two data variables: percent of the US population in each state that is obe
Read more

Module 4: Color Concepts & Choropleth Mapping

Image
In this week's lab, I explored using color and selecting color ramps in ColorBrewer, as well as applying these concepts to create meaningful choropleth maps. I created a map of population change from 2010 to 2014 in Georgia counties. I normalized the data and produced a choropleth map of population change using a diverging color scheme with 6 classes divided around a midpoint of 0. Fig 1. Choropleth map of population change in Georgia counties using a diverging color scheme. For the Georgia population data set, I chose to divide the data set into 6 classes around a midpoint of 0: 3 showing a decrease in population and 3 showing an increase in the population. The classes were grouped based on a manual classification closely based on the Natural Break classification, where the midpoint was adjusted to 0 with the other groups unchanged. Natural Breaks classification creates classes based on similarities in values in the data, thereby revealing patterns in the data. By adjust
Read more