Logo graphic for the WildLife Resources Division
Facebook Icon Twitter Icon Instagram Icon YouTube Icon WordPress Icon Email Icon
Help on Using Rare Element Location Data Using Table Relates with ArcGIS 9.3

Help on Using Rare Element Location Data Using Table Relates with ArcGIS 9.3

To do the analysis described below using ArcGIS 9.3 you will need to create a "relate" between data in the quarter quad index file qq.shp and the quarter quad csv table qq_eos.csv downloadable from our website.

For selections to be enabled between tables in a relate, the tables must all have an ObjectID column. There is not an ObjectID column in qq_eos.csv, so it must be converted to a data format with an ObjectID column such as a geodatabase or a dBase dbf file. Below we convert it to a dBase dbf file.

Converting the CSV file to a DBF file

  1. In ArcCatalog navigate to the CSV file, qq_eos.csv.
  2. Right click on the CSV file and select "Export" and then "To dBase (single)".
  3. For "Output Location" enter the complete path to the folder where you want the DBF file to reside.
  4. "Output Table" should be qq_eos.dbf
  5. Under "Field Map" make sure the "area code" field is listed as "(Text)". If not, right click, select properties and change type to text.

Making and saving the relate

  1. In ArcGIS desktop "Data View", click on the "Source" tab at the bottom of the Table of Contents.
  2. Using the "Add Data" button on the button bar, bring qq.shp and qq_eos.dbf into ArcGIS .
  3. Right click on "qq" and select "Joins and Relates" and select "Relate".
  4. In the "Relates" dialog, for field 1 select "area_code", for 2 select "qq_eos", for 3 "id_code". Then for 4 give the relate the name "qq eos" and select "OK".
  5. Save your project and the relate will be saved for future work.

Using quarter quads to select rare element records

  1. Right click on the "qq" layer and open the attribute table. Do the same for qq_eos.
  2. Select one or more quarter quad records either from the table or on the map.
  3. At the bottom of the qq attribute table select "Options" and then select "Relate Tables" and select the relation you made above.
  4. The records in qq_eos for the selected quarter quads will now be selected.
  5. To only show these records, click "Selected" at the bottom of the qq_eos table.

Create a range map for a Bald Eagles

  1. From "qq_eos" options at bottom of the table choose "Select by Attributes..." to open the Select by Attributes dialog.
  2. For method select "Make a new selection".
  3. For field select "SCOMNAME".
  4. Click the equals ("=") button.
  5. Type Bald Eagle between single quotes ( 'Bald Eagle' ) or alternately select "Get unique values" and select Bald Eagle from the list.
  6. From the qq_eos table options select "Related tables" and choose the relate to the quarter quad index table. This will select the quarter quads that have bald eagles in them.
  7. To show just the quarter quads that have bald eagles go to the table of contents on the map, right click on qq, chose "Selection" and then "Create layer from selected features."
  8. If you want to rename the new layer to "Bald Eagles" right click on the layer name and select "Properties". From the "General" tab, under "Layer Name" type in the new name and click "O.K".

Receive FREE, timely updates on topics of interest. Sign Up Here!

LICENSES - 3 Ways to Buy

1. Phone 1-800-366-2661
2. Online - here
3. Retail License Vendor listing - here

Ranger Hotline


Report poaching and wildlife violations. You can receive a cash reward if your tip leads to an arrest—even if you wish to remain anonymous.
More Info >