Channel_Data

Logical Entity Name | Channel_Data
Default Table Name | Channel_Data
Definition | Summary information on a channel

Channel_Data Columns

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

Channel_Data Primary and Unique Keys

Key Name | Key Type | Keys
ChD00 | PrimaryKey | net, sta, seedchan, location, ondate

Channel_Data Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred
D_Abbreviation | Non-Identifying | Zero or One to Zero or More | Cha_Dat_D_Abb |  |  | inid | NO | NO | NO
D_Format | Non-Identifying | One To Zero or More | Cha_Dat_D_For |  |  | format_id | NO | NO | NO
D_Unit | Non-Identifying | One To Zero or More | Cha_Dat_D_Uni |  |  | unit_signal | NO | NO | NO
D_Unit | Non-Identifying | One To Zero or More | Cha_Dat_D_Uni2 |  |  | unit_calib | NO | NO | NO
Station_Data | Identifying | One To Zero or More | Cha_Dat_Sta_Dat |  |  | net, sta, ondate | NO | NO | NO

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred
Channel_Comment | Identifying | One To Zero or More | Cha_Com_Cha_Dat |  |  |  | NO | NO | NO
Coefficients | Identifying | One To Zero or More | Coe_Cha_Dat |  |  |  | NO | NO | NO
Decimation | Identifying | One To Zero or More | Dec_Cha_Dat |  |  |  | NO | NO | NO
Polynomial | Identifying | One To Zero or More | Pol_Cha_Dat |  |  |  | NO | NO | NO
Poles_Zeros | Identifying | One To Zero or More | Pol_Zer_Cha_Dat |  |  |  | NO | NO | NO
Sensitivity | Identifying | One To Zero or More | Sen_Cha_Dat |  |  |  | NO | NO | NO
Simple_Response | Identifying | One To Zero or More | Sim_Res_Cha_Dat |  |  |  | NO | NO | NO

Channel_Data Check Constraints

Check Constraint Name | CheckConstraint
ChD01 | azimuth >= 0.0 AND azimuth <= 360.0
ChD02 | clock_drift >= 0.0
ChD03 | dip >= -90.0 AND dip <= 90.0
ChD04 | edepth >= 0.0
ChD06 | lat >= -90.0 AND lat <= 90.0
ChD07 | lon >= -180.0 AND lon <= 180.0
ChD08 | record_length >= 8 AND record_length <= 12
ChD09 | samprate >= 0.0