Eyasco Format

The Eyasco format file is a normalized data format that can be used to import any number of sensors with measurements and quality codes – but you must know the Type ID of each record. The figure below shows the Type ID of a Water Temperature measurement displayed in the Data Library.

This Type ID is included in the Eyasco format in separate columns between the date/time field and measured value field as shown in Table 5 below.

MM/DD/YYYY hh:mm:ss AM/PM	252	501	50	1	1	##.##	Corrected
MM/DD/YYYY hh:mm:ss AM/PM	252	501	50	1	1	##.##	Corrected
MM/DD/YYYY hh:mm:ss AM/PM	252	501	50	1	1	##.##	Gap Filled
MM/DD/YYYY hh:mm:ss AM/PM	252	501	50	1	1	##.##	Gap Filled
…	…	…	…	…	…	…	…

· The 1^st column is datetime with date in MM/DD/YY (or YYYY) and time in AM/PM or 24 hour.

· Column 2 to 6 are the consecutive parts of the Type ID of the data series (Project, Station, ArrayID, SensorID, Measurement No.).

· Column 7 is the corrected data values or gap filled data values.

· Finally, Column 8 is the Data Quality Code to be included with the measurement value .

Data Quality Codes are assigned by station type (USGS, USBR, CDEC, Watercourse, etc.). A listing of codes with their descriptions can be obtained in the Reports section of the Grabdata2 website. A brief description is included in the section below.