# Presentation: 694722

## StreamStatsDB:  Characteristics Database for Data-Collection Stations

**By Kernell Ries**

## What is it?

**MS Access database with Visual Basic user interface developed by Aqua Terra Consultants**
**Linked to StreamStats map in user interface showing site locations**
**Contains fields for all streamflow and basin characteristics that are currently used, and allows new characteristics to be added**
**Replaces old Basin-Characteristics File**
**Expandable for use with other types of data**

## Downloading StreamStatsDB

**Download at http://water.usgs.gov/osw/programs/****StreamStatsDB.zip**
**Zip file contains program and database**
**NOTE:**** Latest version of StreamStatsDB is incompatible with current version of NFF**

## StreamStats User Interface

**Station Management Tab**** ****Add, edit, and delete ****data for individual or ****groups of stations**
**Statistic Management Tab**** ****Add edit, and delete types ****of statistics that can be ****entered in the Station ****Management Tab**
**Help, Exit**

## Help Facility

**Includes detailed****help for all****functions and a ****tutorial**

## Station Management Tab

## Data Selection

- Select State from scroll-down list

- List by State, Basin, County, MCD, HUC

- List by Name, Station ID, or both

- Select individual stations for editing

## Data Editing

- Click on station in grid to edit statistics or delete station. Click on Add button to add new line.

- Double-click on some items to select options

- Save, cancel, or clear actions in grid

- Import data in NWIS, BCF, Excel, and ROI formats

- Edit descriptive information or add a station in the grid frame

## Station Data Window

- Scroll-down menus allow selection of statistic type, name, code, and source

- Click on the Add button to add a new statistic in the bottom row of the grid

## Importing NWIS, BCF, Excel Data

- Click on the NWIS, BCF, or Excel button in the main window to open up a window to allow specifying a file for import.

## Importing Region-of-Influence Data

- Several files need to be imported and options need to be specified to implement ROI regression for a state. Help file gives detailed description of the process.

## Statistics Management Tab

## Statistic Selection

- Statistic types can be added, edited, or deleted

- Statistics types are selected from a scroll-down menu

- Individual statistics are highlighted for editing in the Statistics frame

## Adding and Editing Statistic Types

- Click on **Add** or **Edit** and type any changes in the frame that appears.
- Click on **Delete** to delete the statistic type shown in the Selection scroll-down menu. Confirmation is required.
- These functions will rarely be needed.

## Editing Statistics

- Click on a grid cell to edit it
- Click on the Add button at bottom to add a new row to the grid
- Double-click on the Type cell for a pull-down list of statistic types

## Words of Caution

**Statistics must be added in the Statistic Management area before they can be edited in the Station Management area**
**Be sure that editing, adding, or deleting statistic types is needed before making changes – suggest calling K. Ries (410-238-4317)**
**Before adding a new statistic, carefully review existing statistic definitions to be sure that the statistic is not already in the database under a different name – If it is, use the existing name**

## Finishing the Job

**Fill in the descriptive information – Useful for future regional analyses and selection of sites for drainage-area ratio estimates **
**Be sure to quality assure all data**
**Send completed files on CD or put in ftp depot**