StreamStatsDB: Characteristics Database for DataCollection Stations

1
StreamStatsDB Characteristics Database for
Data-Collection Stations
By Kernell Ries
2
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

3
Downloading StreamStatsDB

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

4
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

5
Help Facility

• Includes detailedhelp for allfunctions and a
  tutorial

6
Station Management Tab
7
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
8
Data Editing
Edit descriptive information or add a station in
the grid frame
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
9
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
10
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.
11
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.
12
Statistics Management Tab
13
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
14
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.

15
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

16
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

17
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