Lab 3: Databases and Attribute Data Purpose: After successful completion of this assignment, you will be able to: retrieve information about feature attributes Use the join and relate functions when

working with attribute tables Materials: ArcGIS 10, Getting to Know ArcGIS Desktop text, Exercise 9b dataset. Requirement: Having done the required exercises (Exercise 11 - Building Geodatabases); Exercise 17 - Joining and Relating Data), it is expected you understand the following: the advantages geodatabases have over other spatial data format the differences between personal and multiuser geodatabases the relationship that is used to determine whether you join or relate tables in ArcGIS If you are not familiar with these concepts yet, it is strongly recommended that you review the exercises and the lecture on Attribute Data and Database Management before you proceed with this assignment. Scenario: Between 1993 and 1998, abandoned oil extraction sites (called pits) in coastal Louisiana were evaluated for their risk to the environment. The pits, dating back to 1906, include wells, storage tanks, and other equipment and structures that may leak oil and possibly contaminate nearby waterways. If these structures are exposed by erosion, as often happens, they may be struck by boats, risking an oil spill. Each pit was assessed and given a hazard rating. Most pits were assigned specific recommendations for cleanup. As a GIS analyst for the state of Louisiana, you need to make a map that symbolizes the most hazardous pits according to the type of cleanup that has been recommended for them. The map will show how many sites need each kind of cleanup and which parishes (counties) have the most serious problems. The map will help policy makers decide which sites to clean up first, and how much money needs to be spent in each parish to do the job. Before you produce the maps, it is necessary to retrieve attribute from different attribute tables. Task: Find out what cleanup options have been recommended for the sites that contain chromium (Cr). Produce a table of the selected wells with their ID Number, Pit Type, Parish and Cleanup option. [6 marks] Now find the remedial action to be taken for any pit/s that has a ranking of 85 or more for which metal samples have been taken. [6 marks] Explain the steps you took by producing a flow chart showing the joins or relates you used, indicating the fields you used. [3 marks] Produce a table of the following items for the selected pit/s from question 2: ID Number, Pit Type, Parish, Metal and Cleanup option. [10 marks]