Basin Customization - Adding Links Lab 4

Step 6 - Final Corrections to Streamlinks.

Objective: Ensure there is only one streamlink per basin, there are no duplicate Pfaf_id's and the streamlink and basin Pfaf_id's match.

During this step, final edits will be made to ensure there are no duplicate [Pfaf_id] values in the streamlink theme.

Procedure:

  1. Start ArcView and open project basins/cust/cust3.apr.
  2. Open View2.
  3. Make the slmerged2.shp streamlink theme active by clicking on its legend.
  4. Click on the "Open Theme Table" button to open the attribute table for the streamlink theme.
  5. From the Bsn-Tools menu, select "Check for Duplicates" and select the [Pfaf_id] field.
  6. Return to the View and click the "Zoom to Selected" button.
  7. Use the Identify tool on both the streamlink and basin themes to check the [Pfaf_id] of each of the selected stream segments and compare to the [Pfaf_orig] value in the basin theme.

  8. Make the streamlink theme the only active theme by clicking on its legend.
  9. Click on the "Select Feature" tool.
  10. Select the downstream segment ([Basin_id] = 890).
  11. Click on the "Open Theme Table" button.
  12. From the Table menu, select "Start Editing".
  13. Click on the "Promote" button.
  14. Reset the [Pfaf_id] of the selected record to 1066299900000.
  15. From the Table menu, select "Stop Editing" and save the edits.
  16. Repeat steps 3 through 5 to make sure there now are no duplicate [Pfaf_id] values in the streamlink theme.

Step 7 - Check final streamlink theme with Spatial Join

Objective: Ensure streamlink [Pfaf_id] maps to correct basins [Pfaf_orig].

The assignment of the [Pfaf_id] in the streamlink attribute table needs to be checked against the value in the basin attribute table using a spatial join to make sure each line segment will be mapped to the correct basin polygon.

Procedure:

  1. Make the slmerged2.shp streamlink theme active by clicking on its legend.
  2. Click on the "Open Theme Table" button to open the attribute table for the streamlink theme.
  3. Return to the view and from the View menu, select "Add Event Theme..."
    1. For the table, select the Attribute table for the streamlink theme.
    2. For the X and Y fields, choose "X_first" and "Y_first", then click the OK button. A point theme will be added to the view.
  4. Make the new point theme the active theme, and select "Properties" from the theme menu. Rename the theme to sl-pts (this is to avoid confusion with the streamlink polyline theme's attribute table).
  5. Make both the streamlink points theme and the basin polygon theme active:
    1. Make the sl-pts theme the active theme by clicking on its legend.
    2. Hold the shift key down and click on the legend for the basins theme.
  6. Click on the "Open Theme Table" button to open the attribute tables for both the streamlink points theme and the basin polygon theme.
  7. Select the [Shape] field in both tables.
  8. Make the streamlink points table active and click on the "Join" button. Since the shape field is the active field in each table, this will perform a spatial join and join the attributes of the polygons to each point that falls within it.
  9. Query for ([Pfaf_id] <> [Pfaf_orig]). This will select streamlink points where the Pfafstetter code currently assigned to the streamlink does not match the basin's Pfafstetter code.
    1. Click on the "Query" button.
    2. Build the query string: ([Pfaf_id] <> [Pfaf_orig]).
    3. Click on the "New Set" button.
    4. Close the Query window. There should not be any points selected. This ensures the [Pfaf_id] field in the streamlink theme is the correct Pfafstetter ID for the basin the streamlink line segment represents. If there were features selected, they would have to be examined and the [Pfaf-id] edited before proceeding with the next step.
  10. Delete the temporary point theme and clean up the project:
    1. Make the sl-pts point theme the active theme by clicking on its legend.
    2. From the Edit menu, select "Delete Themes".
    3. Open the Project window and click on "Tables".
    4. Select all tables in the list.
    5. From the Project menu, select the Delete entry and delete all tables from the project.
    6. Click on the "Save Project" button.
    7. Return to the View2 window.
  11. Update/create length in miles attribute:
    1. Make the streamlink theme the active theme.
    2. From the Bsn-Tools menu, select "Area/Length". Use the default projection.
At this point, the streamlink theme now has a one-to-one relationship of line features to basins in the basins theme. The [Pfaf_id] field also matches the [Pfaf_orig] field in the basins shapefile.