Monday, April 29, 2013

GIS II Project ~ Phase 4


Introduction:


Lab 5’s goal is to familiarize myself with raster analysis while developing a faux model for terrain suitability and environmental risk of sand mining in Trempealeau County, WI. I will use Elevation, Land Use-Land Cover, Slope, Water Table, and Railroad rasters to determine optimal locations for a sand mine in the county; then DNR hydro, prime farmland, county schools, recreational, and existing mine data will be used to determine locations within the county where a silica sand mine is not desirable. These two indices will then be compared to find the optimal locations for construction of a new mine.



Methods:

   Part I

Fig 1: Suitability Index

The first section, the suitability index (fig 1), begins with the consideration of geologic bedrock data gathered from the MRLC. The Wowenoc and Jordan formations are given as significant locations of silica sands, however the data provided is only a raster base map. There are two options for how to proceed to get this information into a format that can be analyzed: digitization (with which we are familiar) or elevation can be, in this case, used to interpolate the location of these formations because of a relationship between surface elevation and the formation of these bedrock layers. This process consisted of developing contours from the Digital Elevation Model retrieved from the Trempealeau county geodatabase, then comparing them against the geologic formations given in the base map.

Once the elevation range for these layers was determined, a ranking of the county’s territory was developed by reclassifying the original DEM into three regions delineated by elevational proximity to the aforementioned elevation ranges correlating with the Jordan and Wowenoc formations.  The regions that best fit the geologic layers were given “high” ranks of three, and the most distant received ranks of one.

With the DEM, the slope tool was also used to find %rise/%run in the county. From this data, Trempealeau was also divided into three regions based on the suitability of an area’s slope for construction (smaller slope=better).  Again, this coefficient was ranked one to three, as are the rest of the interpolated values.

The land use raster that was downloaded for Lab 3 was also used in the terrain analysis for this Lab: the county was reclassified based on the suitability of each area for constructing a mine. For example, an open field or barren land would be ranked highly whereas a forest would rank low because of the differential in ease of construction between the two parcels.  

The last factor considered in land suitability for the sand mines was the water table level. Silica sand mines use water in the process of extracting sand, therefore a higher water table (closer to the ground surface) merited a higher suitability coefficient.  The exact cutoffs for these factors were determined by examining the histograms of the final rasters produced, that values can be found in the table appended to the end of the methods section.

Finally, Raster Calculator was run to add the three coefficients together, piecing together the final Trempealeau Silica Sand Mining Suitability Index. Five coefficients ranked 1 to 3 means a range of 5 to 15.  Areas of urbanization and open water were also removed from the index, because it would be entirely impractical to construct a mine in those locations if not impossible.  The final mapped index can be found in the results section below.


   Part II

Fig 2: Unsuitability Index


The second portion of this exercise is to find areas in which a silica mine would be unsuitable for its surroundings, in particular the environment and local residents (Data Flow model in fig 2). This begins with an examination of potential impact of a silica sand mine on Trempealeau streams. To determine the risk of impact, a Euclidean Distance tool was used to find the distance of each cell within Trempealeau County from the nearest stream. From this distance, the county was divided into three regions of contamination risk determined by that distance. After viewing the stream-distance data that was generated, the region was ranked into three areas representing proximity to major streams.  This method is similar to the method for part I, however where in part I areas of high desirability were ranked highly, the opposite is true here and areas most suitable are ranked at a lowly one.

Schools, residential zones, and existing mines are similar to streams in that proximity to them is undesirable, and as such they both used a similar method to divide the county into zones of proximity. The difference with these two features was that they weren’t discrete features in the data provided by Trempealeau County; however they could be derived from the parcel and zoning data that was provided. The features were first selected out, then had the Euclidean Distance tool applied to them before finally being reclassified. Also, because of the intense noise produced by mining operations, it has been determined that 640 meters is the minimum distance that they should be located from hoses or schools, therefore those regions were excluded from the final analysis by using the Boolean “And” in raster calculator.  As for the distance from preexisting mines, obviously it is detrimental to compete for sparse local resources in addition to extra taxing on the local atmosphere to place mines too nearby.  Therefore a distance tool was run similar to above.

Agriculture is integral to the economy of Wisconsin, and Trempealeau County is absolutely an example of this. As such, in the Trempealeau County geodatabase that had been downloaded is data for “prime farmland,” agricultural land which is important not just to the local farmers but to the state as a whole.  This prime agro land is what received the highest value in this section of the exercise, and lands that were designated as never good for farmland received the highest.

The last coefficient to be determined was the effect of potential mines on recreational tourism in the area, in particular on the hiking trails.  The factors for both models are given in Fig 3 below.

The Suitability Factors used for Trempealeau County

Fig 3: Suitability Indices



Sources:


Trempealeau County Geodatabase, downloaded from the official Trempealeau County Land Records Division http://www.tremplocounty.com/landrecords/.

National Land Cover Database from the Multi-Resolution Land Characteristics Consortium. http://www.mrlc.gov/nlcd01_leg.php

Wisconsin Geological and Natural History Survey’s digital dataset of Trempealeau County: http://wisconsingeologicalsurvey.org/gis.htm



Results:

Fig 4: Suitability Index

Fig 5: Unsuitailibty Index


The results of the analysis (indices 4 and 5) speak for themselves.  Urban areas are clearly to be avoided in developing a new sand mine, especially particular to this was the exclusion of 640 meters around residential and developed land in the Unsuitability Index, with large swathes cut out around the relatively quite small urban areas in the county.  For comparison, I have included a model without the exclusion of these areas as to view the (un)suitability of the area excluded by this single factor (fig 6).  These indices could be subtracted from one another in order to derive a general suitability model for Sand Mining in the county.
Fig 6: Unsuitailibty Index, with urban areas included.

No comments:

Post a Comment