In an unprecedented series of events the dual 10-inch diameter Chevron oil pipelines transporting crude oil into the Salt Lake Valley for refinement has burst in Emigration Canyon. Emergency responders have identified the rupture location at (433321.82m, 4512098.776m). The pipeline break was not realized for 12 hours, allowing the 30,000 barrels of crude to flow downstream 7.5 kilometers to the above ground terminating point of Emigration Creek.
In this lab you will retrieve data from the Utah Automated Geographic Reference Center (AGRC). The AGRC is a warehouse for spatial data for the state of Utah. They provide a wide variety of vector data as well as orthophotographs and terrain datasets.
For this lab you will need to download the following data from the UT AGRC (link above):
Cadastre data:
Water data (Streams):
The rest of the data for Lab 05 can be found in this zipped folder (click to download).
There are times when you might want to make a quick map, or browse AGRC vector data without downloading and unzipping files. You can connect your ArcGIS suite directly to the AGRC SDE vector geodatabase. This connection allows you to access and visualize all of the AGRC vector data in ArcMap or ArcCatalog without downloading each shapefile or geodatabase via the web browser. However, accessing data via the AGRC server is not recommended if you plan on editing data, if you plan on saving your project and archiving the data, or if you are using/accessing large quantities of data and require fast processing speeds.
Instructions for accessing AGRC ArcSDE database server are posted here from the AGRC.
The overall lab objective is to build your confidence and proficiency with some of the basic vector analyses tools in ArcGIS. Specifically, you will learn how to:
Meets Course Learning Outcome 2.
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.
Join the
EMS_CONTACT.XLSX
file to the new parcel feature class. Build an easy to read PDF document that identifies contact name, parcel ID, address, and phone number. Provide a “notes” field that workers may use to take field notes. Post the document online as a PDF for download.
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:
Save and close Excel.
Add the table to Arc just like with any dataset.
In the table of contents, right click the table > Display XY Data
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.
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.
Prepare a webpage for this lab on your personal website for the course and prepare the following:
On your webpage, provide a fully legible** image of the reference page and an image of the first map pag**e (furthest upstream reach). (If image can’t be enlarged to see relevant details, provide link to high resolution PDF.)
Also provide a link to the four map pages created with the Data Driven Pages tool.
Provide a legible image of the first page of your joined PDF. Edit headers.
Make sure your lab conforms to the general lab submission guidelines. Submit a URL for this lab’s webpage
####
Subpages (1): Lab 5 Detailed Instructions