Lab Tasks

You have been tasked to immediately address the following issues:

County officials have received numerous reports of residents being overcome and sickened by fumes, but there are still a number of residents that are not aware of the incident. The city and county officials are requesting a series of detailed maps and accompanying ownership information for the affected area.

• Map the pipeline rupture, identify the stream reach affected, derive a 250-meter contamination buffer, and identify the parcels potentially impacted. 

• Develop an easy to read map book consisting of four maps (8.5 x 11 with page scale of 1:7500, in landscape format) and one reference page for EMS and hazmat teams to use in the field.  Make the map book downloadable as a PDF online (from your website).

• Display the critical data on a Google Map (online) for residents to view. Display the pipeline break, stream reach, and impacted parcels.

Task 2

Detailed Instructions

Task 1

You should begin by identifying the spatial location of the pipeline rupture and create a spatial dataset containing this information. First responders have sent back the GPS coordinates of the rupture location at (433321.82m, 4512098.776m). Note that the coordinates were collected in NAD83 UTM Zone 12N.

You can use the short cut "Go To XY" tool on the main menu in ArcGIS to find the rupture location.  Or if you want to create a shapefile (point feature class) of the rupture location follow the instructions below. 

Adding XY data:

1. Create a simple table with the northing and easting values

3.  In the table of contents, right click the table > Display XY Data

Inform ArcMap which fields describe the X and Y coordinates and use the Edit button to set the coordinate system for these coordinates (NAD 83 UTM Zone 12N).

Once you have identified the rupture location, you need to identify and select the impacted portion of Emigration Creek. The NHD high resolution data from the Utah AGRC should provide you with the necessary information to complete this task. Note that due to the winter season, the irrigation spur located at (431099.378m, 4511359.276m) was not impacted and you should disregard this stream data.

You may wish to "cut" the stream segment where the rupture occurred in order to capture the true length of impacted stream.  Select the segment, start editing, use the "Split Tool" on the editor tool bar to cut the line segment at the rupture location.  (Click on the highlighted line at the rupture point.)  Then test the cut by trying to select 

When you have identified and selected the stream features, you should save only those features to a new dataset (again, Data > Export Data) and then buffer that reach of the stream to 250-meters. The 250-meter zone is considered the critical fume impact area.  (When you run the Buffer tool, consider setting the Dissolve to "All" to avoid the Michelin man looking buffers around each reach segment.)

Use the buffer results to select the impacted parcels (using the Select by Location tool) (Main menu > Selection drop down > Select by Location). 

Responders are not interested in any parcels that have a “federal” OWN_TYPE attribute.  Remember when using the Select by Location tool, that the 'Spatial selection method' will greatly impact your selection results.  Experiment with this feature to get the results you feel are appropriate for this analysis.

When you have your parcels selected, you will create an EMS and hazmat team field map book. Make sure that your map book has four map pages (with page scale of roughly 1:7500, in landscape format) and a reference or index page for EMS and hazmat teams to use in the field.  Use the Map book grid shapefile as a guide for the 4 map page extents.

The maps should show only those parcels potentially impacted within 250-meters of Emigration Creek.  Be sure to include appropriate labels, legend, and basemap. The map should NOT include parcels designated as “federal” in the attribute table. See the What to Submit section for details.

Task 2

To complete the work, you need to open and join the EMS_CONTACT.XLSX file that you downloaded to the impacted parcel feature class. This join will allow you to export the table to Excel so that you can create a readable PDF that lists the contact name, parcel ID, address, and phone number of the impacted parcels.

You will  post this PDF online with your map books.

For tutorials walking through Tasks 1 and 2, click here.

What to Submit

Prepare a webpage for this lab on your personal website for the course and prepare the following:

Task 1:

•  On your webpage, provide a fully legible image of the reference page and an image of the first map page (furthest upstream reach). (If image can't be enlarged to see relevant details, provide link to high resolution PDF.)

• The reference (index) page should identify the pages of your map book and include:

• the total area of the impact buffer,
• the length of the impacted portion of Emigration Creek,
  
• your information (as the analyst),
  
• data source information,
  
• the date. 
• The Select by Location method you chose for isolating the parcels in the contamination zone.
• The upstream page should demonstrate that you "Split" the stream line at the rupture location.

• Also provide a link to the four map pages created with the Data Driven Pages tool. 

Task 2:

• Provide a legible image of the first page of your joined PDF.  Edit headers. 
  
• table should clearly show both the name and address with parcel ID to demonstrate join