Headed Format
The Headed format is simply a pivot table with date/time in the first one or two columns and data columns for individual measurements to the right. It can be used for any number of data series as long as they are on the same time base.
The table below shows Column 1 with the label “C” is for combined datetime, and the rest columns are data values with the column header being the TypID of the data.
|
C
|
231.5.145.1.1
|
231.5.165.1.1
|
|
MM/DD/YYYY hh:mm:ss
|
##.##
|
##.##
|
|
MM/DD/YYYY hh:mm:ss
|
##.##
|
##.##
|
|
MM/DD/YYYY hh:mm:ss
|
##.##
|
##.##
|
|
MM/DD/YYYY hh:mm:ss
|
##.##
|
##.##
|
|
…
|
…
|
…
|
The Type ID (or TypID) is a unique identification number for a measurement that reflects the Project, Station, Sensor Type, and Sensor ID to which it is attached. The basic format for a type ID is: Project.Station.ArrayType.SensorID.MeasurementID.
If the Type ID of the data series is unknown at the time the data is submitted then common sense column headers that describe the fields are adequate. This is a good option for new data series that are not currently in the database. The table below shows a Headed table in this format.
|
Datetime
|
Trinity Stage (ft)
|
Trinity Storage (Acre-ft)
|
|
MM/DD/YYYY hh:mm:ss
|
##.##
|
##.##
|
|
MM/DD/YYYY hh:mm:ss
|
##.##
|
##.##
|
|
MM/DD/YYYY hh:mm:ss
|
##.##
|
##.##
|
|
MM/DD/YYYY hh:mm:ss
|
##.##
|
##.##
|
|
…
|
…
|
…
|
T