GEOG 487
Environmental Challenges in Spatial Data Science

Part III: Identify the Potential Suitable Sites for Sludge Disposal

PrintPrint

Part III: Identify the Potential Suitable Sites for Sludge Disposal

Now that the groundwater vulnerability layer has been produced, we can use this data to help find the areas in the watershed most suitable for sludge disposal. Along with this dataset, we also need to incorporate the stream buffer dataset. Remember from previous lessons that it is possible to reclassify grid cells to values of "NoData" to exclude them from your analysis. We will use this technique to remove portions of each dataset that do not meet the relevant criteria. For example, we will reclassify suitable areas within each dataset as "1" and unsuitable areas as "NoData."

You can also do the opposite of this by assigning existing values of "NoData" to more meaningful values. We will use this technique to create a grid of areas that are outside of steam buffers. Then, we will use the Raster Calculator to combine the individual suitability results into one grid. We will then use the "RegionGroup” command to create regions from adjacent cells with the same results. This process is illustrated in the graphic below.

Grids showing suitability criteria A and B. Also shows how Regions of suitability for A&B are where A and B overlapped.
Sludge Disposal Site Selection Criteria

For the purposes of this lesson, we assume that state regulations require the following for a site to be considered for sludge disposal:

  1. Areas that are very vulnerable to groundwater contamination must be avoided. Therefore, we will only consider areas with DRASTIC Index values less than 150.
  2. Sites must be at least 300 meters from surface water.
  3. Sites must have a contiguous area of at least 0.5 square km.
  1. Explore the DRASTIC Rating Output Grids

    1. In Part II Step 3, we talked about the potential pitfalls of using the reclassify tool when break values are important in your results. One way to avoid this issue is to use the Raster Calculator, which allows us to use mathematical sign of less than or greater than. Enter the expression shown below and name your grid "di150."
      screenshot "drasticindex" <150 Output raster: C:\GEOG487\L8Data\di150
      information icon

      The calculation performed in the previous step combines the results of two Boolean operations that are either evaluated as:

      TRUE (indicated by a value of 1) OR 
FALSE (indicated by a value of 0)

      We are only interested in cells that meet the criteria (values of 1).

    2. Reclassify the "di150" grid using the settings below. Name the output grid "OK_Drastic.tif" and confirm the tool Environments.
       
      Input raster: di150, Reclass field: VALUE, Reclassification table. Value 0, New NODATA, Value 1, New 1. Output raster: OK_Drastic.tif,
      Square yellow sign with hand and the word stop

      Make sure you have the correct answer before moving on to the next step.

      The "OK_DRASTIC.tif" attribute table should have all of the attributes shown below. If your data does not match this, go back and redo the previous step.

           OK_Drastic.tif data. OID: 0, Value: 1, Count: 2455259
       
  2. Create a Grid of Suitable Surface Water

    1. Convert the "steams_buffer" shapefile to a raster using the "Id" field. Name the output "streambuffgrd.tif" and save it in your L8 folder and confirm the tool Environments.
    2. Reclassify "streambuffgrd.tif" as shown below. Name the output "OK_Streams.tif" and confirm the tool Environments.
      Input raster: streambuffgrd.tif, Reclass field: Value Output raster: OK_streams.tif,
      Square yellow sign with hand and the word stop

      Make sure you have the correct answer before moving on to the next step.

      The "OK_Streams" attribute table should have all of the attributes shown below. If your data does not match this, go back and redo the previous step.

      OK_Streams.tif data. OID = 0, Value = 1, Count = 1440214  
    3. Compare the "OK_Streams.tif" layer to the "steambuffgrd." Notice how we have essentially flipped the areas of NoData. It is important that you choose an appropriate mask and extent settings when using this technique.
  3. Combine the Suitability Grids Using the Raster Calculator

    1. Use the raster calculator to multiply the "OK_Drastic.tif" and "OK_Streams.tif" rasters together. Cells that meet both of the criteria will be assigned a value of "1" in the output raster. Cells that do not meet either one or both of the criteria will be assigned a value of "NoData" in the output raster. Name the new grid "OK2criteria."
      Square yellow sign with hand and the word stop

      Make sure you have the correct answer before moving on to the next step.

      The "OK2criteria.tif" attribute table should have all of the attributes shown below. If your data does not match this, go back and redo the previous step.

      OK2criteria.tif data. OID = 0, Value = 1, Count = 1306435
    2. Examine the attribute table. Notice there is only 1 row. We need a way to lump together cells that make up contiguous units. To accomplish this, we will use the Region Group tool like we did in Lesson 7.
    3. Go to Toolboxes > Spatial Analyst Tools > Generalization > Region Group, select " OK2criteria.tif" as the input raster, name the output raster " OK_Regions ", leave the number of neighbors to use as "FOUR", the zone grouping method as "WITHIN", uncheck the "Add link field to output", leave the excluded value setting , and click OK.
      Square yellow sign with hand and the word stop

      Make sure you have the correct answer before moving on to the next step.

      The "OK_Regions" statistics for the "COUNT" field should match the example below. If your data does not match this, go back and redo the previous step.


           Dataset: Mean: 2184.6739130435, Median: 10.5, Std. Dev.: 8,938.0396748111, Count: 598, Min: 1, Max: 126,602, Sum: 1306435, Nulls: 0
  4. Create Grid of Suitable Regions Greater than 0.5 sq km

    1. The last criteria we need to incorporate is - Area (sites greater than 0.5 sq km). We learned in Lesson 5 that you can calculate the area of a raster by multiplying the number of cells by the area of each cell. To calculate the area of regions within a raster, we can use this same method.

    2. Add a new float field to the "OK_Regions" attribute table named "AREA_SQM." Use the field calculator to populate the field.
      Screenshot Area_SQM= !Count! * 30 * 30
      lightbulb icon

      Why did we use the number "30" to calculate the area?



       

    3. We will use Extract by Attributes to perform a query on sites > 0.5 sq km. Extract by Attributes is similar to the Raster Calculator, except that it makes entering specific field expressions much easier.
    4. Go to Toolboxes > Spatial Analyst Tools > Extraction > ExtractByAttributes. Select "OK_Regions.tif" as the input raster and name the output raster "OK_Area". To populate the "Where clause" with the expression given below, click the "Query Builder" button. The "Query Builder" dialog will appear. Click on "AREA_SQM", and then on "greater than or equal to", and type 500000 at the end of the expression (0.5 sq km = 500,000 sq m). Confirm the tool Environments. Click Run to automatically input the expression into the "Where clause."
      screenshot extract by attribuites. Use settings described above
      stop icon

      Make sure you have the correct answer before moving on to the next step.

      The "OK_Area" statistics for the "COUNT" field should match the example below. If your data does not match this, go back and redo the previous step.

           Dataset: Mean:9727.1590909091 , Median: 3696 , Std. Dev.: 17043.1813102182, Count: 132, Min: 598 , Max:126602 , Sum: 1283985, Nulls: 0
       
    5. Reclassify "OK_Area.tif". Change the number of classes to "1," since all of the start and end values match all of the site selection criteria. Name the grid "FinalSites.tif" and confirm the tool Environments. These are your potential sludge disposal sites.

         Screenshot: Reclassify. Change the settings as described in text above 
      This is all for the required portion of the Lesson 8 Step-by-Step Activity. Please consult the Lesson Checklist for instructions on what to do next.

Try This!

Try one or more of the optional activities listed below.

  • Redo Part III of the lesson using the value of "0" to denote unsuitable areas instead of "NoData." Compare your results with the "FinalSites.tif" grid.
  • Redo Part III of the lesson, except add the suitable grids together instead of multiplying them. How do you need to alter the reclassification values to find suitable sites using this methodology?

Note: Try This! Activities are voluntary and are not graded, though I encourage you to complete the activity and share comments about your experience on the lesson discussion board.