GIS Tools --

Event Tables

Event tables are tremendously useful to the aquatic biologist or hydrologist. These tables can be easily created in EXCEL and using a routed stream layer with a unique LLID for each stream, the information in the spreadsheet can be located on a stream as a line (segment, reach) or point (site). Event tables enable one to summarize stream temperature data, stream survey data, flow measurements, etc. in a data table linked a location in GIS . A tool has been enclosed which will tell the user the kilometer or mile point on the stream route and the unique LLID of that stream line in GIS. This file is included on the GIS Tools page as stream_route_tool_new.apr.

By clicking the "Back" and "Next" buttons, you can navigate through a series of 11 pages describing this process. To return directly to this page, use the text links at the bottom of each page.

Once you are familiar with the graphic figures and their descriptions, you can navigate directly to them with these links:

Figure 1-- view opened in ArcView
Figure 2-- subwatershed with the stream survey reaches
Figure 3-- a query for pools per mile
Figure 4-- pop up box that shows the kilometer location
Figure 5-- split screen of the EXCEL spreadsheet and the GIS view
Figure 6-- begin and end points are incorporated
Figure 7-- how to add a table to the view
Figure 8-- a typical screen when adding an event theme
Figure 9-- an event theme in place
Figure 10-- spreadsheet for the event table with pools and riffles
Figure 11-- maps individual pools and riffles

The entire series and text may be downloaded as a Word document from the GIS Tools page.

^^ Back to Top

USDA Forest Service
Pacific Northwest Region Fisheries Program
Fish Habitat Relationships, Stream Inventory and Data Analysis
333 SW First Avenue, P.O. Box 3623, Portland, Oregon, 97208

Rogue River National Forest
333 West 8th Street, P.O. Box 520, Medford, Oregon, 97501

Home • Contact Us • Application • GIS Tools • SMART • NRIS • FHR Home Page

Send email to webmaster