ColumnName |
Domain |
Datatype |
NULL |
Definition |
net |
|
VARCHAR2(8) |
NO |
Unique network identifier. This character string is the name of a seismic network |
sta |
|
VARCHAR2(6) |
NO |
Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used |
seedchan |
|
VARCHAR2(3) |
NO |
SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code |
location |
|
VARCHAR2(2) |
NO |
Describes the individual sites on an array station, operated by the same network operator |
ondate |
|
DATE |
NO |
This attribute denotes the start date |
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, etc.) |
inid |
|
NUMBER(8, 0) |
YES |
Instrument identifier. It refers to the Generic Abbreviation Dictionary, that contains a name for this instrument |
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 |
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 |
lat |
|
BINARY_FLOAT |
YES |
Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes |
lon |
|
BINARY_FLOAT |
YES |
Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian |
elev |
|
BINARY_FLOAT |
YES |
Elevation. This attribute is the elevation of a seismic station relative to mean sea level |
edepth |
|
BINARY_FLOAT |
YES |
Emplacement depth. This attribute gives the depth at which the instrument is positioned, relative to the value of elev |
azimuth |
|
BINARY_FLOAT |
YES |
The azimuth of the instrument from north, clockwise |
dip |
|
BINARY_FLOAT |
YES |
The dip of the instrument, down from horizontal |
format_id |
|
NUMBER(8, 0) |
NO |
A data format lookup key that refers to the Data Format Dictionary that describes the format of the data in the data section for this channel |
record_length |
|
NUMBER(8, 0) |
YES |
The exponent (as a power of two) of the record length for these data |
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 |
offdate |
|
DATE |
YES |
This attribute denotes the end date |
lddate |
|
DATE |
YES |
Load date. Date and time that the record was created or last modified, in Oracle date datatype |