USGS Home Contact USGS Search USGS

qmeas2rdb

Name:
qmeas2rdb - Retrieve discharge measurements from SiteVisit, including channel level data, in rdb format.

This script was retired from active support in July 2009 as it was replaced by new functionality in the ADAPS program nwts2rdb. This page is available for historical reference. Use of the script without extensive testing is not recommended and the consequences are your own. If you feel this script was retired prematurely and would like to see it restored send email to GS-W OSW Scripts@usgs.gov.

Information:
With the release of SiteVisit in NWIS 4.8 the old measurement file properties of width, area, and velocity were removed from NWISWeb. This has led to a rise in data requests for these data to Water Science Centers. The current retrieval program nwts2rdb does not support retrieval of width/area/velocity and other "channel level" data. The long form report from SiteVisit does include the data, but not in a format that can easily be imported into other applications.

This script retrieves measurements, including channel level data, from site visit. If the option to include channel level data is NOT used the output from this script is almost identical to that from nwts2rdb. If the option to include channel level data IS used, then the measurement fields on the left side of the output will be repeated for each measurement.

See the attached file for an example of output with channel level information and the duplication of the measurement level fields.

example.out

The columns in the output are as described in this file: column.desc.txt

The options in this script will be moved into nwts2rdb in a later NWIS release. This script was created as an interim measure.

USAGE:

qmeas2rdb [-z db_no] [-a agency_cd] -n site_no 
                 [-b yyyymmdd] [-e yyyymmdd]
                 [-o output_file_path] [-l ingres_timezone]
                 [-d]

 where: ingres_timezone is NA-EASTERN, NA-CENTRAL, NA-MOUNTAIN,
      or NA-PACIFIC.  (Defaults to Local Time if omitted)
     If -z is omitted it will default to database 1
     If -a is omitted it will default to "USGS"
     If -o is omitted output will go to stdout
     If -l is omitted, defaults to UTC
     -d (for Detail) will cause channel level information to be added

Script Language:
ksh

Requirements:

• The user must be in the nwis_select access group and have Adaps read access (see your DBA).

Original Author(s): Scott Bartholoma, NWIS

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 time datum (time zone) of the measurements is not shown
• Rounding of all data is fixed to the thousandths place rather than set to the stored precision of each value in SiteVisit. (both of these issues are limitations in the script language and will be fixed in the final nwts2rdb version.)

Installation:

• Download and unzip the file to your NWIS server
• Make executable (chmod +x qmeas2rdb)
• Run by typing 'qmeas2rdb' with valid arguments as described in the usage section above.

Latest Version and Release Notes:

Version 1.0: posted 11/12/08
- Initial release
 
qmeas2rdb download (Zip file = 3.9K )