USGS Home Contact USGS Search USGS

get_sv_emeas

Name:
get_sv_emeas - Retrieve environmental air and water temperature measurements stored in Site Visit.

Information:
Get_sv_emeas provides a tab-delimited text file (rdb) output of the environmental air and water temperature readings stored for a station or stations in Site Visit. Historical air temperature and water temperature readings stored in the old ADAPS measurement file were transferred to these fields in the new Site Visit system and new readings are entered in this field. As of the launch of this script, those measurements are not included in any existing Site Visit Reports so this script was developed to more easily access and output those measurements. Note that the measurements retrieved usually are not the water temperature check measurements performed to check the accuracy of thermistors on Acoustic equipment (those measurements are not necessarily meant to accurately represent actual site conditions as these environmental measurements are - those checks are currently only stored in the xml of the associated site visit or in remarks fields at this time).

Usage:

Usage: get_sv_emeas [-a agency_cd] [-z db_no] [-p parm_cd ] [-o outfile] site_no site_no site_no . . .

if agency code (agency_cd) is missing will default to USGS
if database number (db_no) is missing will default to db01
if output file (outfile) is missing output will be sent to the terminal
-p if present will result in only the specified parameter code being retrieved

Sample Output:

The fields in the output are as follows:

agency:	agency code
site:	station ID
svdate	date/time of associated site visit
emdate	date/time of environmental measurement
parm	parameter code of measurement (00010=water temp, 00020=air temp)
meth	method code of measurement (won't be present for historical values-see Site Visit for available method codes)
value	Value of measurement (note that odd rounding may be present on historical transferred values)
agency	site	svdate	emdate	parm	meth	value
6S	15S	20D	20D	5S	5S	16N
USGS	07106500	2008-09-02 17:06:00	2008-09-02 17:06:00	00010		18
USGS	07106500	2008-09-09 17:13:00	2008-09-09 17:13:00	00010		18.70000076
USGS	07106500	2008-09-15 15:35:00	2008-09-15 15:35:00	00010		14.39999962
USGS	07106500	2008-09-30 18:28:00	2008-09-30 18:28:00	00010	THM01	21.5
USGS	07106500	2008-10-24 18:24:00	2008-10-24 18:24:00	00010		10.2
USGS	07106500	2011-03-29 19:15:00	2011-03-29 19:20:00	00010	THM01	13.6
USGS	07106300	2000-08-22 21:00:00	2000-08-22 21:00:00	00020		32
USGS	07106300	2002-02-06 18:50:00	2002-02-06 18:50:00	00010		3.000099897
USGS	07106300	2003-01-02 17:15:00	2003-01-02 17:15:00	00010		1.000100017
USGS	07106300	2003-05-06 17:30:00	2003-05-06 17:30:00	00010		18.50009918
USGS	07106300	2010-04-21 18:15:00	2010-04-21 19:15:00	00010	THM01	13.8
USGS	07106300	2010-12-13 18:14:00	2010-12-13 19:38:00	00010	THM01	7.2

Output can be opened up in an Excel spreadsheet (or quickly converted using rdb2excel) for easier viewer, plotting, or manipulation of data.

Installation:
The script can be installed by unzipping the file in any accessible Sun directory in the user's PATH and making sure the script is executable (chmod +x get_sv_emeas).

Script Language:
ksh

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

Scripts:

Version 5.0: posted (2/5/13)
get_sv_emeas download (Zip file = 2.1K)