Surface Water Information--Data Scripts

ratlist

Name:
ratlist - Admin utility to list all the ratings and rating dates with their data aging status for a given station or data descriptor.

Information:

This script is a useful utility to list all ratings and rating dates with their data aging status for a given station or data descriptor. It is useful for diagnosing potential problems with rating dates (overlaps, gaps, etc.) or finding lingering data aging issues.

Usage: ratlist [-a agency_cd] [-z db_no] -n site_no [-d dd_nu] [-l Oracle_time_zone]

Where:

: db_no if omitted defaults to 1; agency_cd if omitted defaults of 'USGS'; dd_nu if omitted all ratings for the site will be displayed; Oracle_timezone is US/EASTERN, US/CENTRAL, US/MOUNTAIN, or US/PACIFIC or -4:00, etc... (Defaults to GMT if omitted)

Sample Output:

The fields in the output are as follows:

agency:	agency code
station	station ID
dd_nu	data descriptor
rat_id	internal ADAPS rating ID
aging	rating data aging status (working, in-review, approved)
rating_cd	type of rating (see ADAPS manual section 3.6.1)
rating_no	rating number
dateaging	rating date data aging status
startdtm	rating date start time (in time zone as given via command line argument - default is GMT)
enddtm	rating date end time

agency  station          dd_nu          rat_id  aging  rat_cd  rat_no  dateaging  startdtm              enddtm
------  ---------------  -----  --------------  -----  ------  ------  ---------  --------------------  --------------------
USGS    01010000             1     -2147483645  A      STGQ     4.1    A          1966-05-21 06:00:00   1966-10-01 04:59:59 
USGS    01010000             1     -2147483644  A      STGQ     4.2    A          1966-10-01 05:00:00   1967-10-01 03:59:59 
USGS    01010000             1     -2147483644  A      STGQ     4.2    A          1967-10-01 04:00:00   1968-10-01 03:59:59 
USGS    01010000             1     -2147483644  A      STGQ     4.2    A          1968-10-01 04:00:00   1969-10-01 03:59:59 
USGS    01010000             1     -2147483644  A      STGQ     4.2    A          1969-10-01 04:00:00   1970-10-01 03:59:59 
USGS    01010000             1     -2147483644  A      STGQ     4.2    A          1970-10-01 04:00:00   1971-10-01 03:59:59 
USGS    01010000             1     -2147483644  A      STGQ     4.2    A          1971-10-01 04:00:00   1972-10-01 03:59:59 
USGS    01010000             1     -2147483644  A      STGQ     4.2    A          1972-10-01 04:00:00   1973-10-01 03:59:59 
USGS    01010000             1     -2147483644  A      STGQ     4.2    A          1973-10-01 04:00:00   1974-10-01 03:59:59 
USGS    01010000             1     -2147483644  A      STGQ     4.2    A          1974-10-01 04:00:00   1975-10-01 03:59:59 
USGS    01010000             1     -2147483644  A      STGQ     4.2    A          1975-10-01 04:00:00   1976-10-01 03:59:59

Script Language:
ksh, accessing the database through tsql statements

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).

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)

Back to Scripts

[an error occurred while processing this directive]