 |
|
|
Name:
meas4meter - Admin utility to list all the discharge measurements that use a particular meter or meters
Information:
At times it can be very handy to find out exactly what discharge measurements in SiteVisit were done with a particular meter or meters. This script does the trick
Usage meas4meter [-z db_no] 'serial_no' 'serial_no' 'serial_no' .......
Notes:
- The database number (-z argument) is optional and defaults to 01
- As many meters as desired can be added to the command line.
- The use of quotation marks is only required if the serial number has spaces in it.
- Partial serial numbers are allowed and if used the script will find all meters that start with the given serial numbers
Sample Output:
> meas4meter ME_P9 ME_P6 agency site svdtm measno channu qmeth vmeth meter ------ --------------- -------------------- ------ ------ ------ ------ -------------------------------- USGS 01017290 2008-08-20 10:56:56 5 1 QSCMM VPAA ME_P675 mtr USGS 01018008 2009-07-01 15:01:55 18 0 QSCMM VPAA ME_P675 mtr USGS 01018011 2009-07-02 11:33:42 12 0 QSCMM VPAA ME_P675 mtr USGS 01029200 2009-09-10 18:08:47 115 1 QSCMM VPAA ME_P675 mtr USGS 01067950 2008-07-24 14:53:55 4 1 QSCMM VPAA ME_P675 mtr USGS 01067950 2008-07-28 14:10:55 7 1 QSCMM VPAA ME_P675 mtr USGS 01010070 2009-08-19 11:49:24 172 1 QSCMM VPYG ME_P97165 mtr USGS 01010070 2009-09-10 11:03:38 174 1 QSCMM VPYG ME_P97165 mtr USGS 01018009 2009-08-28 14:59:59 24 0 QSCMM VPYG ME_P97165 mtr USGS 01067950 2008-06-03 12:00:00 1 1 QSCMM VPYG ME_P97165 mtr
The fields in the output are as follows:
| agency_cd/site: | the agency code and site number of the site |
| measno: | the measurement number |
| svdtm: | the start date and time of the site visit |
| channu: | the channel number |
| qmeth: | the discharge method of the measurement |
| vmeth: | the velocity method of the measurement |
| meter: | the meter serial number |
Script Language:
ksh, accessing the database through tsql statements
Requirements:
Original Author(s): Scott Bartholoma, NWIS
Known Problems/Limitations/Need Improvements:
Installation:
Download to the Sun location of your choice and make sure it is executable (chmod +x meas4meter).
Latest Version and Release Notes: