Goals and Objectives
This exercise was the culmination of the frac sand mining exercises we have been doing all semester, as well as an exercise in raster modeling. Using data we gathered in previous labs, we were to make a suitability model for frac sand mining in Trempeleau County by overlaying various raster data. We also found where high risk areas for mining were in the county.
Part 1
Methods
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPhU_c7atChgODbF7JlZ0lJ1SKgPn3XtDlzmmWw9gXDrafAhgYR0mu8O7LgVVPQ7KAsHqscQbETVdFANvYrN_KXi4c79s0ITYGhCwdVJ726VXeaGkpOd_FP69uMrnPQKZ90NqLWf9H1-ov/s320/workFlow1.JPG) |
Figure 1 - Work flow for part 1 |
It was necessary to use many different tools and data sets to compile the information needed to find suitable mining areas. The exercise was broken up into two parts: suitability and risk. For part one, we had to find suitable areas for mining using hill slope, geology, water table depth, land cover types, and proximity to railroad depots. We found these suitable areas separately, then used the tool 'raster calculator' to combine them into one suitability map. Figure 1 shows the work flow for this portion of the lab.
|
Figure 2 - Suitable geology for frac sand mining |
For each map, we ranked suitability from 1-3, 3 being highest and 1 being lowest (or 0 being unusable) by reclassifying the raster data. For consistency, I used green for rank 3, yellow for rank 2, and red for rank 1 on all the maps.
When deciding what areas are suitable and what areas are not, it can vary from person to person. Geology, however, does not. Wonewoc and Jordan sandstone formations are suitable, so I did only one rank for that map (figure 2).
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaAdm9b51MRGeT3yAXqzJ5PjoUug3KWlsl4ELh7xLQZ-5aSEc-nNvJwBt0bxsatr7Pqv1B4lCPAufTmc7e0kzaNhBHNJqUPnmccGVgJrwW5iwRlswG1zMWUx932bOUliw4-wTLD6kOejmK/s320/LandUse_suitable.JPG) |
Figure 3 - Suitable land cover sites |
For land cover, I ranked the suitable types by what areas were easiest to clear before mining can begin. This means that rank 3 included barren, shrub, and grass lands, Rank 2 was pasture and crop lands, and rank 1 was any type of forest land. I excluded any developed areas and wetlands entirely. Figure 3 shows the result.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEji3orOt_cyFDkaBxQJi3bpWLAQNQpaxZpAJ2CI0imABiHH5ZTOuWjnlNN58YO7DwZGtDQyPFQPR4q2jAzuqhE22bIbei2XpZ1fjV3YOGQ5kPVKZi2YpRB0d12l1itii9atsxIIyVb0JUb5/s320/railroad_suitable.JPG) |
Figure 4 - Suitable distance from rail depots |
Any sand mine will need a way of transporting the product, so we made a map showing suitable distance from rail depots. Rank 3 locations were any areas within 3 miles of a depot, rank 2 was between 3 and 10 miles away, and anything farther was rank 1. The map units were in meters, so I used the meter equivalent of these mile distances. To do this, I ran the 'euclidean distance' tool. Most of the maps I made only involved data that fell within our study area. However, I would think that frac mines in Trempeleau County would still be able to utilize rail depots in neighboring counties, so I included them when I ran the tool. It was only after I got the result that I used 'extract by mask' tool to show only suitable areas within our study area. I did have a mask set in the Environments menu, but it seemed to only work selectively, so I still had to run the tool occasionally. Figure 4 shows the result.
|
Figure 5 - Suitable slopes |
Hill slope is important when deciding an area to mine. Rank 3, the areas in green, are the most suitable areas with the lowest slope. The steepest areas in the study area are in red. Using a mosaiced DEM from a previous lab, I ran the slope tool and reclassified it to get the result in figure 5.
Once the sand has been mined, it must be washed to remove unwanted particles. For this reason, building a mine where the water table is close to the surface is preferable. Figure 6 shows where the water table is closest to the surface in green.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7ImjrADKlneYWlSvJ8iVMnYkh0eqYJ2soXS-icxxV2jonugq4CjLT8oUWjgoV_u9eZhXP_P5-5J8MyWvUKGgRkT44BhwQ0xzPmsLmes8secM6GY9UfXXgtmDm4LkF005uIyF70IhZrVHR/s320/watertable_suitable.JPG) |
Figure 6 - Suitable water table depth |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgavP0m_V7cC0uX_XBdTdobefWZwKxLFklRM13EWVQQlcRYsg5lp9rDuOak1QjC3cVNh6Nqfkzo6hT-V5uz6DUNIStNx1phzHhQgDblW9zJUQu0Rw9ZvRJIHi5m2B5ugvrx22077_dktif/s320/Total_suitable.JPG) |
Figure 7 - Part 1 suitable areas
|
Results
Once I had the five separate suitability maps created, it was time to combine them to make one overall suitability map. To do this, I used the tool 'raster calculator' to add the values of all the layers. Since we used a constant suitability scale (0-3), the raster could be added together to give a range of suitability. Figure 7 shows the most suitable areas for frac sand mining in Trempeleau County, factoring in hill slope, water table depth, geology, distance from rail depots, and land cover type. As you can see in figure 7, the Northwest portion of the study area contains the most suitable areas for mining.
Part 2
Methods
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUqIkE7TrEFsfoKM4IgpIgCpEqlUop75mvUP10fuCuea4kGoyMN_fRYxG-a3XbWSCN8lCoXubCBXSKZ7dkYewOfYqtmtoiCAFI_hYUEpVg8eXoQY16_tUA09v0De0knvYXwBGaj1UOvNcx/s320/workFlow2.JPG) |
Figure 8 - Work flow for part 2 |
Part two involved finding areas where mining would have the most impact, thus the most risk. This included proximity to streams, prime farmland, proximity to residential areas, and proximity to schools. I realized after creating the final risk map that I classified them backwards. The exercise called for ranking areas with highest risk at 3, and lowest risk at 1. I did all the maps in this section with low risk areas at rank 3 (thinking that low risk would be a more suitable area). Even with this mistake, risk can be clearly seen in the following maps. Figure 8 shows the work flow from Model Builder that I used.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3yR8lZqVbSd8VSkhWvNHHXst4W4zt5qOvjrpzUFK_haD3eBrz6T1jPcvDCv6rhqvMkULqGtkcJD4gVi78CKfmt0BLtHu7eLeJmTOsILixMhtRZU-nTjlhlzbxrumrY8gdYgyrrVWktzZo/s320/River_suitable.JPG) |
Figure 9 - Suitable distance from major rivers |
There are many streams in the study area, and including all of them in this analysis would mean that there is no suitable area. I chose only primary perennial streams, since risk to these streams would have a larger effect on the area. I again used the 'euclidean distance' tool to create a raster ranking distance from streams, then reclassified it to have only three classes. Figure 9 is the finished map. As you can see, Trempaleau County has a great deal of rivers, making it difficult to find suitable areas.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjrk91ORZ5NP-bAPnuVIKmfns6t0M3ZXYf1PjOoRzZ4SD-qR6Aikw7TiC2nRyepZblD9nvGBmWsrFwC0Xft2jWLxp1zR5KvgVyjM_F9RHmEupJjOOuS36i2UY7p7DoiuWbJemDVkmXRtT_S/s320/schools_suitable.JPG) |
Figure 10 - Risk index for area schools |
Because some people may not want a sand mine near schools for various reason, Figure 10 shows the risk model for schools within the study area. Rightfully so, schools are spread out evenly across the county, so in this case there is no specific region that stands out as more or less suitable. There is more than enough space between schools (shown in green), however, for mining. We also wanted to keep risk to prime farmland to a minimum. Figure 11 shows this risk map.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-yfZnoGVxYotcEYJxq4o7uHRRSlLEHBsx71fiJiBdpwC17Yoy-FyFibwNbpfkntIVoPXiG4ENAIhyoTj2hUeGLLKMxACatC5Sk3QpEjrqFip1pU1n7gbugKJC6jYbmZFHNBnD8AzYMeYH/s320/Farm_suitable.JPG) |
Figure 11 - Risk to prime farmland from frac sand mining. |
Results
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiklNWROj0poxrFH00vaxTQsXdAfKLj9IG_TfgFWx4Tq4r5PSFiS3eWAKhLP39BIdH4UgUwBvpqMM4zjrEGDxU4_c9GFV-2f7cZjeDV2BoXXjmXfXvEPMGHYtG9sfvMBTPb0qU3nQyvpQmA/s320/Suitable2.JPG) |
Figure 12 - High-low risk areas for mining. Red
represents areas of high risk, green is low risk. |
Figure 12 is the final product from part two. Again, the ranking is backwards from what we were supposed to use, but the map still does show areas where sand mining would put local areas at risk. This map was made by once again using the 'raster calculator' tool to combine the risk maps I had created by adding the pixel values.
We were also tasked with using the 'viewshed' tool to find if suitable mining locations would be visible from areas of our choice. I used the campground feature class to run the tool on. In figure 13, purple denotes what is visible from these campgrounds. This is overlaid on the final suitability map made by combining the products of parts one and two. Figure 14 is the finished product.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgu7mVuLZGTxJcMFHJ9XpkXFerCfP-1KXI_BKSWBZ3EPV-VT4Q90JSxss0tXn2z2Xf3DWT8Dsud8AEJCSn84OlubA8MyH9uKwevtN7uTHvDTwyfxScO2BWiW73JDLVpez47gA23obOpdoBf/s320/Viewshed.JPG) |
Figure 13 - Viewshed of Trempeleau County campgrounds |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgY9CNgNZZmIyefMiXHjXWvksv8JeY6R04FCZu-CkFYua5OJaKQGackoxrVx7zJPlMYpn1t7UeMIsMzllyXxKB5B9-Oksgnh8sDMeH8hEC4WW-LLOczChnfpnQqLOXGBzYTFZAUS2Z6ls86/s640/Final_Suitable.JPG) |
Figure 14 - This map is the final suitability map for
Trempeleau County including parts 1 and 2 |
Conclusion
I learned a great deal not only about using and interpreting GIS data, but also about frac sand mining during the course of this lab. Frac sand mining is a huge (and controversial) industry in Wisconsin. This was a lengthy exercise, but it tied everything we did this semester together very well. From my studies this semester, it seems that the northwestern portion of our study area would be the best place to scout new areas for frac sand mines.