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):
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.
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.
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.
2. Add the table to Arc just like with any dataset.
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).
4. Verify that the point is in the right place (add a basemap, compare with other data layers).
5. Change the temporary "Event" layer created to a permanent shapefile.
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).
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: