| ColumnName |
Domain |
Datatype |
NULL |
Definition |
sta |
|
VARCHAR2(6) |
NO |
Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used |
| net |
|
VARCHAR2(8) |
NO |
Unique network identifier. This character string is the name of a seismic network |
| data_nb |
|
NUMBER(8, 0) |
NO |
This attribute represents the datalogger number |
| pchannel_nb |
|
NUMBER(8, 0) |
NO |
This attribute denotes a physical channel |
lchannel_nb |
|
NUMBER(8, 0) |
NO |
This attribute denotes a logical channel of a datalogger |
| ondate |
|
DATE |
NO |
This attribute denotes the start date |
seqfil_id |
|
NUMBER(8, 0) |
YES |
Sequence of filters identifier. Each sequence of filters is assigned a unique integer which identifies it in a database |
| seedchan |
|
VARCHAR2(3) |
YES |
SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code |
| channel |
|
VARCHAR2(8) |
YES |
Channel name |
| channelsrc |
|
VARCHAR2(8) |
YES |
Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, ...) |
| location |
|
VARCHAR2(2) |
YES |
Describes the individual sites on an array station, operated by the same network operator |
| rgain |
|
BINARY_FLOAT |
YES |
This attribute denotes the gain at the response frequency |
| rfrequency |
|
BINARY_FLOAT |
YES |
The frequency (fs) at which the value in rgain is correct |
| samprate |
|
BINARY_FLOAT |
NO |
Sampling rate. This attribute is the sample rate in samples/second |
| clock_drift |
|
BINARY_FLOAT |
YES |
A tolerance value, measured in seconds per sample, used as a thresold for time error detection in the data. The number of samples in a record are multiplied by this value to calculate a maximum drift allowed for the time in the next record. If the difference in time is less than this drift, consider them in the same time series |
| flags |
|
VARCHAR2(27) |
YES |
Channel flags |
| data_format |
|
VARCHAR2(80) |
NO |
This attribute represents the data format |
| comp_type |
|
NUMBER(8, 0) |
NO |
Compression type. A lookup key that refers to the Format Dictionary |
| unit_signal |
|
NUMBER(8, 0) |
NO |
A unit lookup key that refers to the Units Abbreviation Dictionary for the signal response of the instrument – usually the ground motion response, or something else for non-seismic devices |
| unit_calib |
|
NUMBER(8, 0) |
NO |
A unit lookup key that refers to the Units Abbreviation Dictionary for the units of calibration input, usually volts or amps |
| block_size |
|
NUMBER(8, 0) |
NO |
The record length of the data |
| offdate |
|
DATE |
YES |
This attribute denotes the end date |
| remark |
|
VARCHAR2(30) |
YES |
An optional comment given to the instrument. It can be anything, including a serial number or a notation of special modifications |
| lddate |
|
DATE |
YES |
Load date. Date and time that the record was created or last modified, in Oracle date datatype |