Wednesday, December 18, 2013

Suitability Modeling

Goal and Objectives

It is important to explore all the different types of geoprocessing tools in ArcGIS in order to build models to solve real life issues.  During this semester, we have been looking at sand mines in western Wisconsin more from the business side and how the companies can become more efficient.  It is also important to build models for how the surroundings of the sand mines are impacted from a suitability, environmental, and cultural standpoint in Trempealeau County.  This lab looks to answer those questions through the following objectives:
  1. Generate spatial data layer to meet geologic criteria
  2. Generate spatial data layer to meet land use land cover criteria
  3. Generate a spatial data layer to meet distance to railroads criteria
  4. Generate a spatial data layer to meet the slope criteria
  5. Generate a spatial data layer to meet the water-table depth criteria

Methods

Find suitable land for the geologic criteria
The two geologic units that are mined for frac sand are from the Jordan Formation and the Wonowac Formation.  For the first map, those desired areas of geologic formations are made into one color while the rest of the geologic units are made in another color.  This helps show where the mine able areas are.

Find suitable land for the land use criteria
By comparing the National Land Cover Data and the map the was created in the previous step, I noticed that the land cover in the areas common for frac sand mining is deciduous forest.  This type of land is dominated by trees that are generally greater than 5 meters tall, and greater than 20% of total vegetation cover.  More than 75% of the tree species shed foliage simultaneously in response to seasonal change.

Find suitable land for the proximity to railroads criteria
To see the distance away from each railroad terminal in every direction, the Euclidean distance tool can be used.  The result shows a nice radial map that gives a quick visual representation of distances to each railroad terminal.

Find suitable land for the slope criteria
It is important to find the slope in an area especially for a business like a sand mine.  The 3-D analyst tool "Slope" was used to find this factor.  A percent rise was used for the output measurement.

Find water table depth
The attribute that shows water depth in the coverage file is "wt_elev" which is the water table elevation.  The tool used to show the water table depth properly is the "Topo to Raster" tool.  The coverage file for the water table is originally imported into ArcGIS as a vector feature class.  This tool allows us to see continuous data for water table depth, which is probably more realistic than just a polyline.

Results

Find suitable land for the geologic criteria
The purple areas show where the Jordan and the Wonowac Formations are in western Wisconsin, which have proven to be the best units to find frac sand in.  All other geologic formation are shown in blue.

Find suitable land for the land use criteria
Based on National Land Cover Data, the yellow areas show land that possibly has go land cover for frac sand.  I have reclassed all other types of land cover in red.



Find suitable land for the proximity to railroads criteria
Red dots represent the railroad terminals and the colors represent the distance from each railroad termainal.
Find suitable land for the slope criteria
Slope that was calculated from elevation data.  The lighter colors represent lower elevations.  The numbers rank the elevation values; the higher the elevation, the higher the rank.

Find water table depth
This is a map of Trempealeau County that shows the depth of the water table.

Sources
 http://wisconsingeologicalsurvey.org/gis.htm

Network Analysis

Goals and Objectives

Network Analysis is a very useful tool that shoots to help transportation challenges.  With this tool, one can perform a point to point routing, calculate driving times, show traffic maps, etc.  With this lab, we wanted to calculate a route for sand mining trucks to take the frac sand from the mine to a railroad, seeing as the railroad is the most efficient way to transport the sand to desired areas.  To do this, it was essential to find the closest railroad stop to each sand mine.  For these large trucks to transport this sand, it costs a lot of money, not only in gas prices, but also in wear and tear on the roads.  This is another important reason to find the shortest driving distance necessary to transport the sand.  Another goal is to keep track of the work flow using a data flow model throughout the lab.

Methods

In ArcGIS, ModelBuilder was utilized to run the closest facility tool for this network analysis.
Data flow model for running network analysis with the closest facilities tool.
First the streets were made the input on a "Make Closest Facility" tool with the "travel to" option.  This is because we want to travel by roads to the closest railroad terminal.  The next tool was "Add Location"  which is where we added the sand mines that were not close to railroad terminals.  Using the "Solve" tool at this point gives the railroad terminal that is closest to each sand mine that is not already on a railroad terminal.  The "Select Data" tool that comes next allows you to input that closest facilities layer and then calculate a route for how to get from each sand mine to a railroad terminal.  The "Copy Feature" allows you to make this route its own feature class.  From there you can view specific information about each route that a truck would take from each sand mine to the nearest railroad terminal.
This is part of the table that is created when making the route output as its own feature class.
Efficiency is everything with a business like this, and costs are very important.  The roads that these large trucks need to travel on to get to the railroad terminals start to wear down after awhile.  A cost of 2.2 cents per miles accounts for this wear.  Other costs to think about are gas prices.  According to http://www.gasbuddy.com/Gas_Prices/Wisconsin/index.aspx, the highest gas price in this general area is around $3.15 per gallon.  The website http://www.ehow.com/facts_5844120_fuel-mileage-information-semi-trucks.html says that the new designs of semi trucks get about 7 miles per gallon.

Results 

Map showing the fastest route from sand mines to a railroad terminal.
The total distance traveled by a single sand truck from each sand mine to the nearest railroad terminal was found to be 778.883 km.  The total amount spent in gas was $27,639.40 and the total amount accounted for the wear and tear on the road was calculated to be $1,064.75.  Adding these values together gives a grand total of $28,704.15 spent on getting one truck load of sand from each mine to its nearest railroad terminal.
Spreadsheet of costs for hauling the mined sand from the sand mines to the closest railroad terminal.














Conclusions

Network analysis can be a very important tool for any company that needs to deliver a product to its customers.  With just a few quick tools, I have shown the most efficient way for the sand mines in western Wisconsin to get their product from the mine to the closest railroad terminal, where it can then be transferred more directly and efficiently to the customer.  Not only can time be saved, but money too, as demonstrated in the last step of this lab.

Resources
http://www.gasbuddy.com/Gas_Prices/Wisconsin/index.aspx
http://www.ehow.com/facts_5844120_fuel-mileage-information-semi-trucks.html

Wednesday, December 11, 2013

Acquiring Data - An Essential First Step

Goals and Objectives

An important part of any project is obtaining the data.  If one is not getting data from credible places, any analysis may not be justified or worthwhile.  The main goal of this lab exercise was to become familiar with the process of downloading data from different sources on the internet, importing data to ArcGIS, joining data together, and projecting data from these different sources into a single coordinate system that makes sense while building and designing a geodatabase to store the data.

General Methods

The first site that data were acquired was the nationalatlas.gov, which is where the DEM data was downloaded.  DEM (digital elevation model) data can easily show high and low areas in the area of interest.  By default, the areas of high elevation are white and low elevations are shown in black.
Two DEM files that were mosaicked together to form a seamless image. 

One important site used to obtain data was the USGS National Map Viewer.  
This is the first view of the National Map Viewer from the United States Geological Survey page.

This is a very useful site for many different applications of data, such as man made structures (like public attractions, medical facilities, education, etc.), transportation information, governmental boundaries, hydrography data, land cover, elevation, and imagery.  We used land cover data in the Trempeleau County area.
This is a map showing the land cover data from the USGS.  Not all of the categories are broken down in the legend on the side, only the categories that had a distinct difference from one another in their color.

We also used the USDA NRCS Web Soil Survey to download SSURGO data, which just stands for soil survey geographical.
This is what the general soils map of Tremeleau County looks like.  I did not include a legend because the breakdown of the soils is too complex in this system.

This a more zoomed in view of an area in Trempeleau County (reference map) just to show how detailed the soil can be over a small area and how complex the patterns can be.

Results

In order for all the data to show up in its proper location, each piece of data needed to be in the same coordinate system.  To do this, the tool define projection must be run on all the data using the same coordinate system.  I decided to use the NAD_1983_HARN_WISCRS_Trempealeau_County_Meters because it is focused around the study area of Trempeleau County.  Once all the data have a defined projection, then the project tool must be run on all the data, so they all show up in the data frame in the same coordinate system, and so that everything appears to be in the correct location relative to each other.
Here are both maps of the land cover data and the soil survey data overlain by the main roads layer in bright red.

Conclusion

This lab opened up the door for endless future possibilities at retrieving data.  There are so many resources to be tapped, and that number is increasing as technology becomes more and more available to the average person.  While putting this data together, I also worked on building a geodatabase with many different file types.  A lot of files can be created once data needs to have a defined projection and needs to be projected, so it is important to keep organized for these projects.  Getting data from multiple sources means the data will probably not be in the same projection, so it is essential to pay attention to details like that when showing many kinds of data.