USGS Home Contact USGS Search USGS

uvinv/dvinv/station_inv

Name:
uvinv/dvinv/station_inv - Admin utilities to inventory unit and/or daily values for a station or list of stations

Information:

This scripts retrieve an inventory of unit or daily values for a station or list of stations. For unit values, the resulting table includes the DDs with data, the parameter code, the transport code, the amount of data, and the date range of the data. For daily values, the resulting table includes the DDs with data, the statistic code, the parameter code, the date range of the data, and the value range of the data. Either script can be restricted to only primary DDs if desired. The unit-value script can also be restricted to computed UVs only (otherwise it returns ALL UVs including correction, shift, etc.).

Usage:

uvinv [-p] [-c] [-h] [-m parameter_cd] [-a agency_cd] [-z db_no] site_no site_no site_no . . .

dvinv [-p] [-m parameter_cd] [-a agency_cd] [-z db_no] site_no site_no site_no . . .

-p if present will result in only primary DDs being inventoried.

-c if present will result in only computed UVs being inventoried.

-h if present will result i all zero values place holder UV records (empty UVs) being included.

If parameter code (parameter_cd) is missing will inventory all parameters.

If agency code (agency_cd) is missing will default to USGS.

If database number (db_no) is missing will default to db01.

If no site numbers are provided to dvinv, the entire database will be inventoried.

Sites should be separated by a space, not a comma.

After these scripts were first released, Lucky Sultz in Montana wrote a simple script to combine the two into one report. This script (station_inv) prompts the user for a station number, runs both uvinv and dvinv, and puts the results in one file. This combo script does not allow you to specify some of the options that you can when running each inventory separately.

Script Language:
ksh, accessing the database through tsql statements

Original Author(s): Scott Barthaolma, NWIS, Lucky Sultz, Montana District

Note the original author is noted on this page for the purposes of giving credit only. Please address questions/comments to OSW (GS-W OSW Scripts@usgs.gov).

Known Problems/Limitations/Need Improvements:

• The uvinv output also includes a column labeled "Sensor." This database field is not currently used and can be ignored.

Installation:
This script is part of the OSW Scripts Installation package and should be installed as part of that package. Users needing the script outside of the package should send email to GS-W OSW Scripts@usgs.gov.

NWIS 5.00 OSW Scripts package installation instructions:
http://water.usgs.gov/usgs/osw/adaps/OSW_scripts_pkg.5.00.html

Latest Version Release Notes:

Version 5.00: Included as part of OSW Scripts package for NWIS 5.00+
—updated for NWIS 5.00+ releases (not compatible with NWIS 4.11 or prior)