Zuzlewski Stéphane | March 1998 |
Hardware
Tracking
Schema
Volume III | Version 1.2 |
1.- Introduction. .............................................................. 2
2.- Database structure. ................................................. 3
3.- Database relations. ................................................. 11
4.- Database attributes. ................................................ 17
5.- Example: YBIB. ....................................................... 20
1.- Introduction :
This paper is about the design of the NCEDC schema for the hardware tracking. This schema was designed to be able to track any station from the sensor to the datalogger by their serial numbers. It can also generate automatically the instrument responses schema.
There are 28 relations in the schema. The information stored in these relations includes:
The remainder of this volume consists of four chapters:
Chapter 2 Database structure
Each relation is defined.
Chapter 3 Database relations
Each relation is described to identify the key fields and the links among the relations.
Chapter 4 Database attributes
Each attribute is described.
Chapter 5 Example: YBIB
An example of implementation is given here.
2.- Database structure :
This chapter defines the physical structure of each table, as it exists within the DBMS data dictionary. The name of the relation appears in bold print at the top left and a description of the table at the top right. Bold attributes represent primary keys, italic attributes represent foreign keys, and underlined attributes stand for CSS attributes.
Response |
Summary information on a sequence of responses | |
Attribute |
Type |
Description |
seqresp_id |
int |
Sequence of responses identifier |
resp_nb |
int |
Response number |
resp_type |
char(1) |
Response type |
resp_id |
int |
Response identifier |
unit_in |
int |
Signal input units |
unit_out |
int |
Signal output units |
r_type |
char(1) |
SEED response type |
lddate |
date |
Load date |
Response_HP |
Summary information on a high-pass filter | |
Attribute |
Type |
Description |
hp_id |
int |
Filter identifier |
filter_type |
char(2) |
Filter type |
nb_pole |
int |
Number of poles |
corner_freq |
float |
Corner frequency of filter |
damping_value |
float |
Fraction of critical damping |
lddate |
date |
Load date |
Response_LP |
Summary information on a low-pass filter | |
Attribute |
Type |
Description |
lp_id |
int |
Filter identifier |
filter_type |
char(2) |
Filter type |
nb_pole |
int |
Number of poles |
corner_freq |
float |
Corner frequency of filter |
damping_value |
float |
Fraction of critical damping |
lddate |
date |
Load date |
Response_PZ |
Summary information on poles & zeros | |
Attribute |
Type |
Description |
pz_id |
int |
Poles & zeros identifier |
pz_nb |
char(2) |
Pole/zero number |
type |
int |
Pole/Zero |
r_value |
float |
Real pole/zero |
r_error |
float |
Real pole/zero error |
i_value |
float |
Imaginary pole/zero |
i_error |
float |
Imaginary pole/zero error |
lddate |
date |
Load date |
Response_PN |
Summary information on a polynomial | |
Attribute |
Type |
Description |
pn_id |
int |
Polynomial identifier |
poly_type |
char(1) |
Type of polynomial approximation |
lower_bound |
float |
Polynomial lower bound |
upper_bound |
float |
Polynomial upper bound |
max_error |
float |
Maximum error of polynomial approx. |
nb_coeff |
int |
Number of polynomial coefficients |
lddate |
date |
Load date |
Response_PN_Data |
Coefficients of a polynomial | |
Attribute |
Type |
Description |
pn_id |
int |
Polynomial identifier |
pn_nb |
int |
Coefficient number |
pn_value |
float |
Coefficient value |
Sensor |
Summary information on a sensor | |
Attribute |
Type |
Description |
sensor_id |
int |
Sensor identifier |
name |
char(80) |
Sensor name |
serial_nb |
char(80) |
Sensor serial number |
ondate |
date |
Start date |
offdate |
date |
Off date |
nb_component |
int |
Number of components |
lddate |
date |
Load date |
Sensor_Component |
Component of a sensor | |
Attribute |
Type |
Description |
sensor_id |
int |
Sensor identifier |
comp_nb |
int |
Component number |
channel |
char(1) |
Channel |
type |
char(1) |
Type |
sensitivity |
float |
Sensitivity |
frequency |
float |
Frequency |
seqresp_id |
int |
Sequence of responses identifier |
lddate |
date |
Load date |
Filamp |
Summary information on a filter-amplifier | |
Attribute |
Type |
Description |
filamp_id |
int |
Filter-amplifier identifier |
name |
char(80) |
Filter-amplifier name |
serial_nb |
char(80) |
Filter-amplifier serial number |
ondate |
date |
Start date |
offdate |
date |
Off date |
nb_pchannel |
int |
Number of physical channels |
lddate |
date |
Load date |
Filamp_PChannel |
Physical channel of a filter-amplifier | |
Attribute |
Type |
Description |
filamp_id |
int |
Filter-amplifier identifier |
pchannel_nb |
int |
Physical channel number |
gain |
float |
Gain |
seqresp_id |
int |
Sequence of responses identifier |
lddate |
date |
Load date |
Datalogger |
Summary information on a datalogger | |
Attribute |
Type |
Description |
data_id |
int |
Datalogger identifier |
data_type |
char(80) |
Datalogger type |
serial_nb |
char(80) |
Datalogger serial number |
firmware_nb |
char(80) |
Datalogger firmware number |
ondate |
date |
Start date |
offdate |
date |
Off date |
nb_board |
int |
Number of boards |
word_32 |
int |
32 bit word order |
word_16 |
int |
16 bit word order |
lddate |
date |
Load date |
Datalogger_Board |
Board of a datalogger | |
Attribute |
Type |
Description |
data_id |
int |
Datalogger identifier |
board_nb |
int |
Board number |
serial_nb |
char(80) |
Board serial number |
ondate |
date |
Start date |
offdate |
date |
Off date |
nb_module |
int |
Number of modules |
lddate |
date |
Load date |
Datalogger_Module |
Module of a datalogger's board | |
Attribute |
Type |
Description |
data_id |
int |
Datalogger identifier |
board_nb |
int |
Board number |
module_nb |
int |
Module number |
serial_nb |
char(80) |
Module serial number |
ondate |
date |
Start date |
offdate |
date |
Off date |
sensitivity |
float |
Sensitivity |
lddate |
date |
Load date |
Filter_FIR |
Summary information on a FIR filter | |
Attribute |
Type |
Description |
fir_id |
int |
FIR filter identifier |
name |
char(80) |
Filter name |
symmetry |
char(1) |
Filter symmetry |
lddate |
date |
Load date |
Filter_FIR_Data |
Coefficients of a FIR filter | |
Attribute |
Type |
Description |
fir_id |
int |
FIR filter identifier |
coeff_nb |
int |
Numerator/denominator number |
type |
char(1) |
Numerator/Denominator |
coeff |
float |
Numerator/denominator coefficient |
error |
float |
Numerator/denominator error |
Filter |
Summary information on a filter | |
Attribute |
Type |
Description |
filter_id |
int |
Filter identifier |
gain |
float |
Filter gain |
frequency |
float |
Frequency for filter gain |
in_sp_rate |
float |
Input sample rate |
out_sp_rate |
float |
Output sample rate |
offset |
int |
Decimation offset |
delay |
float |
Estimated delay |
correction |
float |
Correction applied |
seqresp_id |
int |
Sequence of responses identifier |
lddate |
date |
Load date |
Filter_Sequence |
Summary information on a sequence of filters | |
Attribute |
Type |
Description |
seqfil_id |
int |
Sequence of filters identifier |
nb_filter |
int |
Number of filters |
gain |
float |
Overall gain |
frequency |
float |
Frequency |
lddate |
date |
Load date |
Filter_Sequence_Data |
Filter of a sequence | |
Attribute |
Type |
Description |
seqfil_id |
int |
Sequence of filters identifier |
filter_nb |
int |
Filter number |
filter_id |
int |
Filter identifier |
Station |
Summary information on a station | |
Attribute |
Type |
Description |
sta |
char(6) |
Station code |
net |
char(8) |
Network code |
lat |
float |
Latitude |
lon |
float |
Longitude |
elev |
float |
Elevation |
staname |
char(80) |
Station description |
nb_sensor |
int |
Number of sensors |
nb_filamp |
int |
Number of filter-amplifiers |
nb_digi |
int |
Number of digitizers |
nb_data |
int |
Number of dataloggers |
datumhor |
char(8) |
Datum type for latitude and longitude |
datumver |
char(8) |
Datum type for vertical |
ondate |
date |
Start date |
offdate |
date |
Off date |
lddate |
date |
Load date |
Station_Sensor |
Data associating a station with a sensor | |
Attribute |
Type |
Description |
sta |
char(6) |
Station code |
net |
char(8) |
Network code |
sensor_nb |
int |
Sensor number |
sensor_id |
int |
Sensor identifier |
lat |
float |
Latitude |
lon |
float |
Longitude |
elev |
float |
Elevation |
edepth |
float |
Emplacement depth |
nb_component |
int |
Number of components |
datumhor |
char(8) |
Datum type for latitude and longitude |
datumver |
char(8) |
Datum type for vertical |
ondate |
date |
Start date |
offdate |
date |
Off date |
lddate |
date |
Load date |
Station_Sensor_Component |
Data associating physical channels | |
Attribute |
Type |
Description |
sta |
char(6) |
Station code |
net |
char(8) |
Network code |
sensor_nb |
int |
Sensor number |
component_nb |
int |
Component number |
next_hard_type |
char(1) |
Next hardware type |
next_hard_nb |
int |
Next hardware number |
next_hard_pchannel |
int |
Next hardware physical channel |
azimuth |
float |
Azimuth |
dip |
float |
Dip |
ondate |
date |
Start date |
offdate |
date |
Off date |
lddate |
date |
Load date |
Station_Filamp |
Data associating a station with a filter-amplifier | |
Attribute |
Type |
Description |
sta |
char(6) |
Station code |
net |
char(8) |
Network code |
filamp_nb |
int |
Filter-amplifier number |
filamp_id |
int |
Filter-amplifier identifier |
nb_pchannel |
int |
Number of physical channels |
ondate |
date |
Start date |
offdate |
date |
Off date |
lddate |
date |
Load date |
Station_Filamp_PChannel |
Data associating physical channels | |
Attribute |
Type |
Description |
sta |
char(6) |
Station code |
net |
char(8) |
Network code |
filamp_nb |
int |
Filter-amplifier number |
pchannel_nb |
int |
Physical channel number |
next_hard_type |
char(1) |
Next hardware type |
next_hard_nb |
int |
Next hardware number |
next_hard_pchannel |
int |
Next hardware physical channel |
ondate |
date |
Start date |
offdate |
date |
Off date |
lddate |
date |
Load date |
Station_Digitizer |
Data associating a station with a digitizer | |
Attribute |
Type |
Description |
sta |
char(6) |
Station code |
net |
char(8) |
Network code |
digi_nb |
int |
Digitizer number |
serial_nb |
char(80) |
Digitizer serial number |
nb_pri_pchannel |
int |
Number of primary physical channels |
nb_aux_pchannel |
int |
Number of auxiliary physical channels |
ondate |
date |
Start date |
offdate |
date |
Off date |
lddate |
date |
Load date |
Station_Digitizer_PChannel |
Data associating physical channels | |
Attribute |
Type |
Description |
sta |
char(6) |
Station code |
net |
char(8) |
Network code |
digi_nb |
int |
Digitizer number |
pchannel_nb |
int |
Physical channel number |
data_nb |
int |
Datalogger number |
data_pchannel |
int |
Datalogger physical channel |
digi_type |
char(3) |
Digitizer type |
digi_polarity |
char(1) |
Digitizer polarity |
ondate |
date |
Start date |
offdate |
date |
Off date |
lddate |
date |
Load date |
Station_Datalogger |
Data associating a station with a datalogger | |
Attribute |
Type |
Description |
sta |
char(6) |
Station code |
net |
char(8) |
Network code |
data_nb |
int |
Datalogger number |
data_id |
int |
Datalogger identifier |
nb_pchannel |
int |
Number of physical channels |
ondate |
date |
Start date |
offdate |
date |
Off date |
lddate |
date |
Load date |
Station_Datalogger_PChannel |
Data associating channels | |
Attribute |
Type |
Description |
sta |
char(6) |
Station code |
net |
char(8) |
Network code |
data_nb |
int |
Datalogger number |
pchannel_nb |
int |
Physical channel number |
seed_io |
char(2) |
SEED instrument and orientation |
nb_lchannel |
int |
Number of logical channels |
ondate |
date |
Start date |
offdate |
date |
Off date |
lddate |
date |
Load date |
Station_Datalogger_LChannel |
Summary information on a channel | |
Attribute |
Type |
Description |
sta |
char(6) |
Station code |
net |
char(8) |
Network code |
data_nb |
int |
Datalogger number |
pchannel_nb |
int |
Physical channel number |
lchannel_nb |
char(2) |
Logical channel number |
seqfil_id |
int |
Sequence of filters identifier |
seedchan |
char(3) |
SEED channel name |
channel |
char(3) |
Channel name |
channelsrc |
char(8) |
Domain of channel name |
location |
char(2) |
SEED location |
rgain |
float |
Gain at the response frequency |
rfrequency |
float |
Frequency for response |
samprate |
float |
Sampling rate |
clock_tolerance |
float |
Clock tolerance |
data_type |
char(26) |
Data type |
data_format |
char(80) |
Data format |
comp_type |
int |
Compression type |
unit_signal |
int |
Units of signal responses |
unit_calib |
int |
Units of calibration |
block_size |
int |
Block size |
ondate |
date |
Start date |
offdate |
date |
Off date |
comment |
char(30) |
Optional comment |
lddate |
date |
Load date |
3.- Database relations :
This chapter describes the DBMS relations that comprise the version 1.2 schema. The information given here, along with that in Chapter 4, Database attributes, constitutes the data dictionary. ThereÆs an entry for each relation. Within the entry, the relationÆs name appears first, followed by a list of its attributes. A brief description completes the entry.
Name: Response Keys: Primary: seqresp_id, resp_nb Foreign: resp_id, unit_in, unit_out Data: resp_type, r_type, lddate Description: This relation provides information about a sequence of responses. |
Name: Response_HP Keys: Primary: hp_id Foreign: Data: filter_type, nb_pole, corner_freq, damping_value, lddate Description: This relation describes a response defined by a high-pass filter. |
Name: Response_LP Keys: Primary: lp_id Foreign: Data: filter_type, nb_pole, corner_freq, damping_value, lddate Description: This relation describes a response defined by a low-pass filter. |
Name: Response_PZ Keys: Primary: pz_id, pz_nb, type Foreign: Data: r_value, r_error, i_value, i_error, lddate Description: This relation describes a response defined by poles and zeros. |
Name: Response_PN Keys: Primary: pn_id Foreign: Data: poly_type, lower_bound, upper_bound, max_error, nb_coeff, lddate Description: This relation describes a response defined by a polynomial. |
Name: Response_PN_Data Keys: Primary: pn_id, pn_nb Foreign: Data: pn_value Description: This relation provides information about the coefficients of a polynomial. |
Name: Sensor Keys: Primary: sensor_id, ondate Foreign: Data: name, serial_nb, offdate, nb_component, lddate Description: This relation describes a sensor. |
Name: Sensor_Component Keys: Primary: sensor_id, comp_nb Foreign: seqresp_id Data: channel, type, sensitivity, frequency, lddate Description: This relation describes a component of a sensor. |
Name: Filamp Keys: Primary: filamp_id, ondate Foreign: Data: name, serial_nb, offdate, nb_pchannel, lddate Description: This relation describes a filter-amplifier. |
Name: Filamp_PChannel Keys: Primary: filamp_id, pchannel_nb Foreign: seqresp_id Data: gain, lddate Description: This relation describes a physical channel of a filter-amplifier. |
Name: Datalogger Keys: Primary: data_id, ondate Foreign: Data: data_type, serial_nb, firmware_nb, offdate, nb_board, word_32, word_16, lddate Description: This relation describes a datalogger. |
Name: Datalogger_Board Keys: Primary: data_id, ondate Foreign: Data: data_type, serial_nb, firmware_nb, offdate, nb_board, word_32, word_16, lddate Description: This relation describes a board of a datalogger. |
Name: Datalogger_Module Keys: Primary: data_id, board_nb, module_nb, ondate Foreign: Data: serial_nb, offdate, sensitivity, lddate Description: This relation describes a module of a datalogger's board. |
Name: Filter_FIR Keys: Primary: fir_id Foreign: Data: name, symmetry, lddate Description: This relation describes a FIR filter. |
Name: Filter_FIR_Data Keys: Primary: fir_id, coeff_nb Foreign: Data: type, coeff, error Description: This relation provides information about the coefficients of a FIR filter. |
Name: Filter Keys: Primary: filter_id Foreign: seqresp_id Data: gain, frequency, in_sp_rate, out_sp_rate, offset, delay, correction, lddate Description: This relation describes a filter. |
Name: Filter_Sequence Keys: Primary: seqfil_id Foreign: Data: nb_filter, gain, frequency, lddate Description: This relation describes a sequence of filters. |
Name: Filter_Sequence_Data Keys: Primary: seqfil_id, filter_nb Foreign: filter_id Data: Description: This relation provides information about the filters of a sequence. |
Name: Station Keys: Primary: sta, net, ondate Foreign: Data: lat, lon, elev, staname, nb_sensor, nb_filamp, nb_digi, nb_data, datumhor, datumver, offdate, lddate Description: This relation describes and names a point of the earth where seismic measurements are made (e.g. the location of a seismic instrument or array). |
Name: Station_Sensor Keys: Primary: sta, net, sensor_nb, ondate Foreign: sensor_id Data: lat, lon, elev, edepth, nb_component, datumhor, datumver, offdate, lddate Description: This relation describes a sensor for a particular station. |
Name: Station_Sensor_Component Keys: Primary: sta, net, sensor_nb, component_nb, ondate Foreign: Data: next_hard_type, next_hard_nb, next_hard_pchannel, azimuth, dip, offdate, lddate Description: This relation describes a component of a sensor for a particular station. |
Name: Station_Filamp Keys: Primary: sta, net, filamp_nb, ondate Foreign: filamp_id Data: nb_pchannel, offdate, lddate Description: This relation describes a filter-amplifier for a particular station. |
Name: Station_Filamp_PChannel Keys: Primary: sta, net, filamp_nb, pchannel_nb, ondate Foreign: Data: next_hard_type, next_hard_nb, next_hard_pchannel, offdate, lddate Description: This relation describes a physical channel of a filter-amplifier for a particular station. |
Name: Station_Digitizer Keys: Primary: sta, net, digi_nb, ondate Foreign: Data: serial_nb, nb_pri_channel, nb_aux_channel, offdate, lddate Description: This relation describes a digitizer for a particular station. |
Name: Station_Digitizer_PChannel Keys: Primary: sta, net, digi_nb, pchannel_nb, ondate Foreign: Data: data_nb, data_pchannel, digi_type, digi_polarity, offdate, lddate Description: This relation describes a physical channel of a digitizer for a particular station. |
Name: Station_Datalogger Keys: Primary: sta, net, data_nb, ondate Foreign: data_id Data: nb_pchannel, offdate, lddate Description: This relation describes a datalogger for a particular station. |
Name: Station_Datalogger_PChannel Keys: Primary: sta, net, data_nb, pchannel_nb, ondate Foreign: Data: seed_io, nb_lchannel, offdate, lddate Description: This relation describes a physical channel of a datalogger for a particular station. |
Name: Station_Datalogger_LChannel Keys: Primary: sta, net, data_nb, pchannel_nb, lchannel_nb, ondate Foreign: seqfil_id, comp_type, unit_signal, unit_calib Data: seedchan, channel, channelsrc, location, rgain, rfrequency, samprate, clock_tolerance, data_type, data_format, block_size, offdate, comment, lddate Description: This relation describes and names a particular channel for a particular station. |
4.- Database attributes :
This chapter describes each of the attributes used in the version 1.2 schema. Descriptions of the relations are found in Chapter 3, Database relations.
Name: azimuth Relations: Station_Sensor_Component Description: The azimuth of the instrument from north, clockwise. Datatype: float NULL Value: Yes Range: 0.0 £ azimuth £ 360.0 Units: Degrees |
Name: block_size Relations: Station_Datalogger_LChannel Description: The record length of the data. Datatype: int NULL Value: No Range: 256 £ block_size £ 4096 |
Name: board_nb Relations: Datalogger_Board, Datalogger_Module Description: This attribute represents the board number of a datalogger. Datatype: int NULL Value: No Range: board_nb ³ 1 |
Name: channel Relations: Station_Datalogger_LChannel Description: Channel name. Datatype: char(3) NULL Value: Yes Range: Any valid channel name, which may be network-specific. Networks using SEED channel names should use the same value for channel and seedchan |
Name: channel_comp Relations: Sensor_Component Description: Component channel. Datatype: char(1) NULL Value: Yes |
Name: channelsrc Relations: Station_Datalogger_LChannel Description: Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, etc.). Datatype: char(8) NULL Value: Yes Range: Any free-format string up to 8 characters long |
Name: clock_drift Relations: Station_Datalogger_LChannel Description: 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. Datatype: float NULL Value: Yes Range: clock_drift ³ 0.0 Units: Seconds |
Name: coefficient Relations: Filter_FIR_Data Description: The numerator/denominator coefficient value. Datatype: float NULL Value: No |
Name: coeff_nb Relations: Filter_FIR_Data Description: The numerator/denominator number. Datatype: int NULL Value: No Range: coeff_nb ³ 1 |
Name: comment Relations: Station_Datalogger_LChannel Description: An optional comment given to the instrument. It can be anything, including a serial number or a notation of special modifications. Datatype: char(30) NULL Value: Yes Range: Any free-format string up to 30 characters long |
Name: comp_type Relations: Station_Datalogger_LChannel Description: Compression type. A lookup key that refers to the Generic Abbreviation Dictionary. Datatype: int NULL Value: No |
Name: component_nb Relations: Sensor_Component, Station_Sensor_Component Description: This attribute represents the component number. Datatype: int NULL Value: No Range: component_nb ³ 1 |
Name: component_type Relations: Sensor_Component Description: This attribute denotes the component type. Datatype: char(1) NULL Value: Yes |
Name: corner_freq Relations: Response_HP, Response_LP Description: This attribute represents the corner frequency of a high/low-pass filter. Datatype: float NULL Value: No Range: corner_freq > 0.0 Units: Hertz |
NULL Value: No
Name: damping_value Relations: Response_HP, Response_LP Description: This attribute represents the fraction of critical damping of a high/low-pass filter. Datatype: float NULL Value: No |
Name: data_format Relations: Station_Datalogger_LChannel Description: This attribute represents the data format. Datatype: char(80) NULL Value: No Range: data_format Î { SEED | à} SEED = SEED format |
Name: data_id Relations: Datalogger, Datalloger_Board, Datalogger_Module, Station_Datalogger Description: Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database. Datatype: int NULL Value: No |
Name: data_nb Relations: Station_Digitizer_PChannel, Station_Datalogger, Station_Datalogger_PChannel, Station_Datalogger_LChannel Description: This attribute represents the datalogger number. Datatype: int NULL Value: No Range: data_nb ³ 1 |
Name: data_pchannel Relations: Station_Digitizer_PChannel Description: This attribute represents a datalogger physical channel. Datatype: int NULL Value: No Range: data_pchannel ³ 1 |
Name: data_type Relations: Datalogger Description: This attribute represents a datalogger type. Datatype: char(80) NULL Value: Yes Range: Any free-format string up to 80 characters long |
Name: datumhor Relations: Station, Station_Sensor Description: Datum type for horizontal (latitude and longitude) coordinates. Datatype: char(8) NULL Value: Yes Range: datumhor Î { NAD27 | WGS84} |
Name: datumver Relations: Station, Station_Sensor Description: Datum type for depth or elevation. Datatype: char(8) NULL Value: Yes Range: datumver Î { NAD27 | WGS84 | AVERAGE } AVERAGE = average of stations |
Name: delay Relations: Filter Description: The estimated pure delay for the filter. Datatype: float NULL Value: Yes Units: Seconds |
Name: digi_nb Relations: Station_Digitizer, Station_Digitizer_PChannel Description: This attribute represents the digitizer number. Datatype: int NULL Value: No Range: digi_nb ³ 1 |
Name: digi_polarity Relations: Station_Digitizer_PChannel Description: This attribute represents the digitizer polarity. Datatype: char(1) Null Value: No Range: digi_polarity Î { N | à } |
Name: digi_type Relations: Station_Digitizer_PChannel Description: This attribute represents the digitizer type. Datatype: char(3) NULL Value: No Range: digi_type Î { DSP | AUX } |
Name: dip Relations: Station_Sensor_Component Description: The dip of the instrument, down from horizontal. Datatype: float NULL Value: Yes Range: -90.0 £ dip £ 90.0 Units: Degrees |
Name: edepth Relations: Station_Sensor Description: Emplacement depth. This attribute gives the depth at which the instrument is positioned, relative to the value of elev. Datatype: float NULL Value: Yes Range: edepth ³ 0.0 Units: Kilometers |
Name: elev Relations: Station, Station_Sensor Description: Elevation. This attribute is the elevation of a seismic station relative to mean sea level. Datatype: float NULL Value: Yes Range: -10.0 £ elev £ 10.0 Units: Kilometers |
Name: error Relations: Filter_FIR_Data Description: This attributes denotes the numerator/denominator error. Datatype: float NULL Value: Yes |
Name: filamp_id Relations: Filamp, Filamp_PChannel, Station_Filamp Description: Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database. Datatype: int NULL Value: No |
Name: filamp_nb Relations: Station_Filamp, Station_Filamp_PChannel Description: This attribute represents the filter-amplifier number. Datatype: int NULL Value: No Range: filamp_nb ³ 1 |
Name: filter_id Relations: Filter, Filter_Sequence_Data Description: Filter identifier. Each filter is assigned a unique integer which identifies it in a database. Datatype: int NULL Value: No |
Name: filter_nb Relations: Filter_Sequence_Data Description: This attribute represents the filter number in a sequence. Datatype: int NULL Value: No Range: filter_nb ³ 1 |
Name: filter_type Relations: Response_HP, Response_LP Description: This attribute denotes the type of a high/low-pass filter. Datatype: char(2) NULL Value: No Range: filter_type Î { BW | DG | ND } BW = butterworth DG = damping given ND = no damping |
Name: fir_id Relations: Filter_FIR, Filter_FIR_Data Description: FIR Filter identifier. Each FIR filter is assigned a unique integer which identifies it in a database. Datatype: int NULL Value: No |
Name: firmware_nb Relations: Datalogger Description: This attribute describes the firmware number of a datalogger. Datatype: char(80) NULL Value: Yes Range: Any free-format string up to 80 characters long |
Name: flags Relations: Station_Datalogger_LChannel Description: Channel flags. Datatype: char(27) NULL Value: Yes Range: Any combination of {T | C | H | G | W | F | S | I | E | M | B} T = channel is trigered C = channel is recorded continuously H = state of health data G = geophysical data W = weather or environmental data F = flag information (nominal, not ordinal) S = synthesized data I = channel is a calibration input E = channel is experimental or temporary M = maintenance tests are underway on channel; possible abnormal data B = data are a beam synthesis |
Name: frequency Relations: Sensor_Component , Filter, Filter_SequenceDescription: The frequency (fs) at which the value in sensitivity/gain is correct. Datatype: float NULL Value: Yes Range: frequency > 0.0 Units: Hertz |
Name: gain Relations: Filamp_PChannel, Filter, Filter_Sequence Description: This attribute denotes the gain. Datatype: float NULL Value: Yes |
Name: hp_id Relations: Response_HP Description: High-pass filter identifier. Each high-pass filter is assigned a unique integer which identifies it in a database. Datatype: int NULL Value: No |
Name: i_error Relations: Response_PZ Description: The error value for the imaginary portion of a complex pole/zero. Datatype: float NULL Value: Yes |
Name: i_value Relations: Response_PZ Description: The imaginary portion of a complex pole/zero. Datatype: float NULL Value: No |
Name: in_sp_rate Relations: Filter Description: Sampling rate. This attribute is the input sample rate in samples/second. Datatype: float NULL Value: No Range: in_sp_rate > 0.0 Units: 1/seconds |
Name: lat Relations: Station, Station_Sensor Description: Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes. Datatype: float NULL Value: Yes Range: -90.0 £ lat £ 90.0 Units: Degrees |
Name: lchannel_nb Relations: Station_Datalogger_LChannel Description: This attribute denotes a logical channel of a datalogger. Datatype: int NULL Value: No Range: lchannel_nb ³ 1 |
Units: YYYY/MM/DD HH24:MI:SS
Name: location Relations: Station_Datalogger_LChannel Description: Describes the individual sites on an array station, operated by the same network operator. Datatype: char(2) NULL Value: Yes Range: Any free-format string up to 2 characters long |
Name: lon Relations: Station, Station_Sensor Description: Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian. Datatype: float NULL Value: Yes Range: -180.0 £ lon £ 180.0 Units: Degrees |
Name: lower_bound Relations: Response_PN Description: This attribute denotes the polynomial lower bound Datatype: float NULL Value: Yes |
Name: lp_id Relations: Response_LP Description: Low-pass filter identifier. Each low-pass filter is assigned a unique integer which identifies it in a database. Datatype: int NULL Value: No |
Name: max_error Relations: Response_PN Description: This attribute represents the maximum error of polynomial approximation. Datatype: float NULL Value: Yes |
Name: module_nb Relations: Datalogger_Module Description: This attribute represents the module number of a dataloggerÆs board. Datatype: int NULL Value: No Range: module_nb ³ 1 |
Name: name Relations: Sensor, Filamp, Filter_FIR Description: This attribute denotes a descriptive name for a sensor, a filter-amplifier or a FIR filter. Datatype: char(80) NULL Value: Yes Range: Any free-format string up to 80 characters |
Name: nb_aux_pchannel Relations: Station_Digitizer Description: This attribute denotes the number of auxiliary physical channels of a digitizer. Datatype: int NULL Value: No Range: nb_aux_pchannel ³ 0 |
Name: nb_board Relations: Datalogger Description: This attribute denotes the number of boards of a datalogger. Datatype: int NULL Value: No Range: nb_board ³ 0 |
Name: nb_coeff Relations: Response_PN Description: This attribute denotes the number of polynomial coefficients. Datatype: int NULL Value: No Range: nb_coeff ³ 0 |
Name: nb_component Relations: Sensor, Station_Sensor Description: This attribute denotes the number of components of a sensor. Datatype: int NULL Value: No Range: nb_component ³ 0 |
Name: nb_data Relations: Station Description: This attribute denotes the number of dataloggers of a station. Datatype: int NULL Value: No Range: nb_data ³ 0 |
Name: nb_digi Relations: Station Description: This attribute denotes the number of digitizers of a station. Datatype: int NULL Value: No Range: nb_digi ³ 0 |
Name: nb_filamp Relations: Station Description: This attribute denotes the number of filter-amplifiers of a station. Datatype: int NULL Value: No Range: nb_filamp ³ 0 |
Name: nb_filter Relations: Filter_Sequence Description: This attribute denotes the number of filters of a sequence. Datatype: int NULL Value: No Range: nb_filter ³ 0 |
Name: nb_lchannel Relations: Station_Datalogger_PChannel Description: This attribute denotes the number of logical channels of a datalogger. Datatype: int NULL Value: No Range: nb_lchannel ³ 0 |
Name: nb_module Relations: Datalogger_Board Description: This attribute denotes the number of modules of a dataloggerÆs board. Datatype: int NULL Value: No Range: nb_module ³ 0 |
Name: nb_pchannel Relations: Filamp, Station_Filamp, Station_Datalogger Description: This attribute denotes the number of physical channels of a datalogger. Datatype: int NULL Value: No Range: nb_pchannel ³ 0 |
Name: nb_pole Relations: Response_HP, Response_LP Description: This attribute denotes the number of poles of a high/low-pass filter. Datatype: int NULL Value: No Range: nb_pole ³ 0 |
Name: nb_pri_pchannel Relations: Station_Digitizer Description: This attribute denotes the number of primary physical channels of a digitizer. Datatype: int NULL Value: No Range: nb_pri_pchannel ³ 0 |
Name: nb_sensor Relations: Station Description: This attribute denotes the number of sensors of a station. Datatype: int NULL Value: No Range: nb_sensor ³ 0 |
Name: net Relations: Station, Station_Sensor, Station_Sensor_Component, Station_Filamp, Station_Filamp_PChannel, Station_Digitizer, Station_Digitizer_PChannel, Station_Datalogger, Station_Datalogger_PChannel, Station_Datalogger_LChannel Description: Unique network identifier. This character string is the name of a seismic network. Datatype: char(8) NULL Value: No Range: Any free-format string up to 8 characters long |
Name: next_hard_nb Relations: Station_Sensor_Component, Station_Filamp_PChannel Description: This attribute denotes the next hardware number. Datatype: int NULL Value: No Range: next_hard_nb ³ 1 |
Name: next_hard_pchannel Relations: Station_Sensor_Component, Station_Filamp_PChannel Description: This attribute denotes the next hardware physical channel. Datatype: int NULL Value: No Range: next_hard_pchannel ³ 1 |
Name: next_hard_type Relations: Station_Sensor_Component, Station_Filamp_PChannel Description: This attribute denotes the next hardware type. Datatype: char(1) NULL Value: No Range: next_hard_type Î { F | D } F = filter-amplifier D = digitizer |
Name: offdate Relations: Sensor, Filamp, Datalogger, Datalogger_Board, Datalogger_Module, Station, Station_Sensor, Station_Sensor_Component, Station_Filamp, Station_Filamp_PChannel, Station_Digitizer, Station_Digitizer_PChannel, Station_Datalogger, Station_Datalogger_PChannel, Station_Datalogger_LChannel Description: This attribute denotes the end date. Datatype: date NULL Value: Yes Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS |
Name: offset Relations: Filter Description: This field determines which sample is chosen for use. The value of this field has to be greater than or equal to zero, but less than the decimation factor. Datatype: int NULL Value: Yes Range: offset ³ 0 |
Name: ondate Relations: Sensor, Filamp, Datalogger, Datalogger_Board, Datalogger_Module, Station, Station_Sensor, Station_Sensor_Component, Station_Filamp, Station_Filamp_PChannel, Station_Digitizer, Station_Digitizer_PChannel, Station_Datalogger, Station_Datalogger_PChannel, Station_Datalogger_LChannel Description: This attribute denotes the start date. Datatype: date NULL Value: Yes Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS |
Units: 1/seconds
Name: pchannel_nb Relations: Filamp_PChannel, Station_Filamp_PChannel, Station_Digitizer_PChannel, Station_Datalogger_PChannel, Station_Datalogger_LChannel Description: This attribute denotes a physical channel. Datatype: int NULL Value: No Range: pchannel_nb ³ 1 |
Name: pn_id Relations: Response_PN, Response_PN_Data Description: Polynomial identifier. Each polynomial is assigned a unique integer which identifies it in a database. Datatype: int NULL Value: No |
Name: pn_nb Relations: Response_PN_Data Description: This attribute denotes the coefficient number of a polynomial. Datatype: int NULL Value: No Range: pn_nb ³ 1 |
Name: pn_value Relations: Response_PN_Data Description: This attribute denotes the coefficient value of a polynomial. Datatype: float NULL Value: No |
Name: poly_type Relations: Response_PN Description: This attribute represents the type of polynomial approximation. Datatype: char(1) NULL Value: No Range: poly_type Î { C | L | M } C = Chebychev L = Legendre M = MacLaurin |
Name: pz_id Relations: Response_PZ Description: Poles & zeros set identifier. Each poles & zeros set is assigned a unique integer which identifies it in a database. Datatype: int NULL Value: No |
Name: pz_nb Relations: Response_PZ Description: This attribute denotes the pole/zero number of a response. Datatype: int NULL Value: No Range: pz_nb ³ 1 |
Name: r_error Relations: Response_PZ Description: The error value for the real portion of a complex pole/zero. Datatype: float NULL Value: Yes |
Name: r_type Relations: Response Description: A single character describing the type of response. Datatype: char(1) NULL Value: Yes Range: r_type Î { A | B | C | D} A = Analog (rad/sec) B = Analog (Hz) C = Composite D = Digital |
Name: r_value Relations: Response_PZ Description: The real portion of a complex pole/zero. Datatype: float NULL Value: No |
Name: resp_id Relations: Response Description: Response identifier. Each response is assigned a unique integer which identifies it in a database. Datatype: int NULL Value: No |
Name: resp_nb Relations: Response Description: This attribute denotes the response number of a sequence. Datatype: int NULL Value: No Range: resp_nb ³ 1 |
Name: resp_type Relations: Response Description: This attribute denotes the response type. Datatype: char(1) NULL Value: No Range: resp_type Î { H | L | P | Z | F } H = high-pass filter L = low-pass filter P = polynomial Z = poles and zeros F = FIR filter |
Name: rfrequency Relations: Station_Datalogger_LChannel Description: The frequency (fs) at which the value in rgain is correct. Datatype: float NULL Value: Yes Range: rfrequency > 0.0 Units: Hertz |
Name: rgain Relations: Station_Datalogger_LChannel Description: This attribute denotes the gain at the response frequency. Datatype: float NULL Value: Yes |
Name: samprate Relations: Station_Datalogger_LChannel Description: Sampling rate. This attribute is the sample rate in samples/second. Datatype: float NULL Value: No Range: samprate > 0.0 Units: 1/seconds |
Name: seedchan Relations: Station_Datalogger_LChannel Description: SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code. Datatype: char(3) NULL Value: No Range: seedchan Î {E | S | H | B | M | L | V | U | R} È {A | B | D | F | G | H | I | K | L | M | P | R | S | V | T | W} È {Z | N | E | A | B | C | T | R | 1 | 2 | 3 | U | V | W} Band code: Sample rate (Hz) Corner period (sec) E = extremely short period ³ 80 < 10 S = short period ³ 10 to < 80 < 10 H = high broad band ³ 80 ³ 10 B = broad band ³ 10 to < 80 ³ 10 M = mid period > 1 to < 10 L = long period ~ 1 V = very long period ~ 0.1 U = ultra long period ~ 0.01 R = extremely long period ~ 0.001 Instrument code: A = tiltmeter B = creepmeter D = pressure F = magnetometer G = gravimeter/accelerometer H = high gain seismometer I = humidity K = temperature L = low gain seismometer M = mass position seismometer P = geophone R = rainfall S = linear strainmeter V = volumetric strain T = tide meter W = wind Component code: N = north-south E = east-west T = transverse R = radial Z = vertical A, B, C = triaxial 1, 2, 3 = orthogonal components but non-traditional orientations U, V, W = optional components |
Name: seed_io Relations: Station_Datalogger_PChannel Description: This attribute represents the SEED instrument and orientation. Datatype: char(2) NULL Value: No Range: seed_io Î {A | B | D | F | G | H | I | K | L | M | P | R | S | V | T | W} È {Z | N | E | A | B | C | T | R | 1 | 2 | 3 | U | V | W} Instrument code: A = tiltmeter B = creepmeter D = pressure F = magnetometer G = gravimeter/accelerometer H = high gain seismometer I = humidity K = temperature L = low gain seismometer M = mass position seismometer P = geophone R = rainfall S = linear strainmeter V = volumetric strain T = tide meter W = wind Component code: N = north-south E = east-west T = transverse R = radial Z = vertical A, B, C = triaxial 1, 2, 3 = orthogonal components but non-traditional orientations U, V, W = optional components |
Name: sensitivity Relations: Sensor, Datalogger_Module Description: This attribute denotes the sensitivity (Sd) for a sensor or a digitizer. Datatype: float NULL Value: No Units: Counts/Volt |
Name: sensor_id Relations: Sensor, Sensor_Component, Station_Sensor Description: Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database. Datatype: int NULL Value: No |
Name: sensor_nb Relations: Station_Sensor, Station_Sensor_Component Description: This attribute represents the sensor number. Datatype: int NULL Value: No Range: sensor_nb ³ 1 |
Name: seqfil_id Relations: Filter_Sequence, Filter_Sequence_Data, Station_Datalogger_LChannel Description: Sequence of filters identifier. Each sequence of filters is assigned a unique integer which identifies it in a database. Datatype: int NULL Value: No |
Name: seqresp_id Relations: Response, Sensor_Component, Filamp_PChannel, Filter Description: Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database. Datatype: int NULL Value: No |
Name: serial_nb Relations: Sensor, Filamp, Datalogger, Datalogger_Board, Datalogger_Module, Station_Digitizer Description: This attribute denotes a serial number of a sensor, datalogger, filter-amplifier, board or module. Datatype: char(80) NULL Value: Yes Range: Any free-format string up to 80 characters long |
Range: Any free-format string up to 6 characters long
Name: staname Relations: Station Description: Station name/description. This is the full name of the station whose code-name is in sta. Datatype: char(50) NULL Value: Yes Range: Any free-format string up to 50 characters long |
Name: symmetry Relations: Filter_FIR Description: This attribute denotes the eventual symmetry of a response. Datatype: char(1) NULL Value: No Range: symmetry Î { E | O | N } E = even O = odd N = none |
Name: type Relations: Response_PZ, Filter_FIR_Data Description: This attribute denotes whether a value is associated with a pole/zero or a numerator/denominator. Datatype: char(1) NULL Value: No Range: type Î { P | Z | N | D } P = pole Z = zero N = numerator D = denominator |
Name: unit_calib Relations: Station_Datalogger_LChannel Description: A unit lookup key that refers to the Units Abbreviation Dictionary for the units of calibration input, usually volts or amps. Datatype: int NULL Value: Yes |
Name: unit_in Relations: Response Description: A unit lookup key that refers to the Units Abbreviation Dictionary for the units of the incoming to this stage of the filter. This signal will usually be ground motion, volts, or counts, depending on where it is in the filter system. Datatype: int NULL Value: No |
Name: unit_out Relations: Response Description: A unit lookup key that refers to the Units Abbreviation Dictionary for the stageÆs output signal. Analog filters usually emit volts, and digital filters usually emit counts. Datatype: int NULL Value: No |
Name: unit_signal Relations: Station_Datalogger_LChannel Description: 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. Datatype: int NULL Value: No |
Name: upper_bound Relations: Response_PN Description: This attribute denotes the polynomial upper bound Datatype: float NULL Value: Yes |
Name: word_16 Relations: Datalogger Description: 16-bit quantity byte swapping order, for the data headers only. Datatype: int NULL Value: No |
Name: word_32 Relations: Datalogger Description: The swap order in which 32-bit quantities are specified in the data headers. Datatype: int NULL Value: No |
5.- Example: YBIB :
Inventory:
Response
Field |
Row |
Row |
Row |
Row |
Row |
seqresp_id |
1 |
2 |
3 |
4 |
5 |
resp_nb |
1 |
1 |
1 |
1 |
1 |
resp_type |
H |
H |
L |
F |
F |
resp_id |
1 |
2 |
1 |
1 |
2 |
unit_in |
1 |
1 |
1 |
1 |
1 |
unit_out |
1 |
1 |
1 |
1 |
1 |
r_type |
A |
A |
A |
A |
A |
Response_HP
Field |
Row |
Row |
hp_id |
1 |
2 |
filter_type |
DG |
DG |
nb_pole |
2 |
1 |
corner_freq |
4.5 |
0.0796 |
damping_value |
0.62 |
1. |
Response_LP
Field |
Row |
lp_id |
1 |
filter_type |
DG |
nb_pole |
2 |
corner_freq |
600. |
damping_value |
0.7071 |
Sensor
Field |
Row |
sensor_id |
1 |
name |
WIL 13 |
serial_nb |
YBIB1 |
ondate |
1996/06/28 23:25:00 |
offdate |
NULL |
nb_component |
4 |
Sensor_Component
Field |
Row |
Row |
Row |
Row |
sensor_id |
1 |
1 |
1 |
1 |
component_nb |
1 |
2 |
3 |
4 |
channel_comp |
1 |
2 |
3 |
4 |
component_type |
A |
A |
A |
V |
sensitivity |
1.0204 |
1.0204 |
1.0204 |
50. |
frequency |
10. |
10. |
10. |
30. |
seqresp_id |
3 |
3 |
3 |
1 |
Filamp
Field |
Row |
filamp_id |
1 |
name |
Qpreamp |
serial_nb |
94sd05 |
ondate |
1996/06/28 23:25:00 |
offdate |
NULL |
nb_pchannel |
4 |
Filamp_PChannel
Field |
Row |
Row |
Row |
Row |
filamp_id |
1 |
1 |
1 |
1 |
pchannel_nb |
1 |
2 |
3 |
4 |
gain |
10. |
10. |
10. |
100. |
seqresp_id |
2 |
2 |
2 |
NULL |
Datalogger
Field |
Row |
data_id |
1 |
data_type |
Q4120 |
serial_nb |
941004 |
firmware_nb |
0 |
ondate |
1996/06/06 00:00:00 |
offdate |
NULL |
nb_board |
1 |
word_32 |
0123 |
word_16 |
01 |
Datalogger_Board
Field |
Row |
data_id |
1 |
board_nb |
1 |
serial_nb |
941004A |
ondate |
1996/06/06 00:00:00 |
offdate |
NULL |
nb_module |
4 |
Datalogger_Module
Field |
Row |
Row |
Row |
Row |
data_id |
1 |
1 |
1 |
1 |
board_nb |
1 |
1 |
1 |
1 |
module_nb |
1 |
2 |
3 |
4 |
serial_nb |
NULL |
NULL |
NULL |
NULL |
ondate |
NULL |
NULL |
NULL |
NULL |
offdate |
NULL |
NULL |
NULL |
NULL |
sensitivity |
428638. |
431261. |
425793. |
413133. |
Filter_Sequence
Field |
Row |
Row |
Row |
Row |
seqfil_id |
1 |
2 |
3 |
4 |
nb_filter |
3 |
4 |
5 |
7 |
gain |
0. |
0. |
0. |
0. |
frequency |
0. |
0. |
0. |
0. |
Filter_Sequence_Data
Only the first sequence of filters is described.
Field |
Row |
Row |
Row |
seqfil_id |
1 |
1 |
1 |
filter_nb |
1 |
2 |
3 |
filter_id |
1 |
2 |
3 |
Filter
Field |
Row |
Row |
Row |
filter_id |
1 |
2 |
3 |
gain |
0.999904 |
0.999904 |
0.999188 |
frequency |
0. |
0. |
0. |
in_sp_rate |
32000. |
2000. |
1000. |
out_sp_rate |
2000. |
1000. |
500. |
offset |
0 |
0 |
0 |
delay |
0. |
0. |
0. |
correction |
0. |
0. |
0. |
seqresp_id |
4 |
5 |
5 |
Filter_FIR
Field |
Row |
Row |
fir_id |
1 |
2 |
name |
FIR.AD32M |
FIR.F96CM |
symmetry |
N |
N |
Filter_FIR_Data
This table is not described due to the high amount of rows.
Tracking:
Station
Field |
Row |
sta |
YBIB |
net |
BK |
lat |
37.81472 |
lon |
-122.35815 |
elev |
4. |
staname |
Yerba Buena Island |
nb_sensor |
1 |
nb_filamp |
1 |
nb_digi |
1 |
nb_data |
1 |
datumhor |
NAD27 |
datumver |
NAD27 |
ondate |
1996/06/28 23:25:00 |
offdate |
NULL |
Station_Sensor
Field |
Row |
sta |
YBIB |
net |
BK |
sensor_nb |
1 |
sensor_id |
1 |
lat |
37.81472 |
lon |
-122.35815 |
elev |
4. |
edepth |
61. |
nb_component |
4 |
datumhor |
NAD27 |
datumver |
NAD27 |
ondate |
1996/06/28 23:25:00 |
offdate |
NULL |
Station_Sensor_Component
Field |
Row |
Row |
Row |
Row |
sta |
YBIB |
YBIB |
YBIB |
YBIB |
net |
BK |
BK |
BK |
BK |
sensor_nb |
1 |
1 |
1 |
1 |
component_nb |
1 |
2 |
3 |
4 |
next_hard_type |
F |
F |
F |
F |
next_hard_nb |
1 |
1 |
1 |
1 |
next_hard_pchannel |
1 |
2 |
3 |
4 |
azimuth |
0. |
257. |
347. |
0. |
dip |
-90. |
0. |
0. |
-90. |
ondate |
NULL |
NULL |
NULL |
NULL |
offdate |
NULL |
NULL |
NULL |
NULL |
Station_Filamp
Field |
Row |
sta |
YBIB |
net |
BK |
filamp_nb |
1 |
filamp_id |
1 |
nb_pchannel |
4 |
ondate |
1996/06/28 23:25:00 |
offdate |
NULL |
Station_Filamp_PChannel
Field |
Row |
Row |
Row |
Row |
sta |
YBIB |
YBIB |
YBIB |
YBIB |
net |
BK |
BK |
BK |
BK |
filamp_nb |
1 |
1 |
1 |
1 |
pchannel_nb |
1 |
2 |
3 |
4 |
next_hard_type |
D |
D |
D |
D |
next_hard_nb |
1 |
1 |
1 |
1 |
next_hard_pchannel |
4 |
3 |
2 |
1 |
ondate |
1996/06/28 23:25:00 |
1996/06/28 23:25:00 |
1996/06/28 23:25:00 |
1996/06/28 23:25:00 |
offdate |
NULL |
NULL |
NULL |
NULL |
Station_Digitizer
Field |
Row |
sta |
YBIB |
net |
BK |
digi_nb |
1 |
serial_nb |
941004A |
nb_pri_channel |
4 |
nb_aux_channel |
0 |
ondate |
1996/06/28 23:25:00 |
offdate |
NULL |
Station_Digitizer_PChannel
Field |
Row |
Row |
Row |
Row |
sta |
YBIB |
YBIB |
YBIB |
YBIB |
net |
BK |
BK |
BK |
BK |
digi_nb |
1 |
1 |
1 |
1 |
pchannel_nb |
1 |
2 |
3 |
4 |
data_nb |
1 |
1 |
1 |
1 |
data_pchannel |
1 |
2 |
3 |
4 |
digi_type |
DSP |
DSP |
DSP |
DSP |
digi_polarity |
N |
N |
N |
N |
ondate |
1996/06/28 23:25:00 |
1996/06/28 23:25:00 |
1996/06/28 23:25:00 |
1996/06/28 23:25:00 |
offdate |
NULL |
NULL |
NULL |
NULL |
Station_Datalogger
Field |
Row |
sta |
YBIB |
net |
BK |
data_nb |
1 |
data_id |
1 |
nb_pchannel |
4 |
ondate |
1996/06/28 23:25:00 |
offdate |
NULL |
Station_Datalogger_PChannel
Field |
Row |
Row |
Row |
Row |
sta |
YBIB |
YBIB |
YBIB |
YBIB |
net |
BK |
BK |
BK |
BK |
data_nb |
1 |
1 |
1 |
1 |
pchannel_nb |
1 |
2 |
3 |
4 |
seed_io |
L1 |
L2 |
L3 |
P1 |
nb_lchannel |
4 |
4 |
4 |
4 |
ondate |
1996/06/28 23:25:00 |
1996/06/28 23:25:00 |
1996/06/28 23:25:00 |
1996/06/28 23:25:00 |
offdate |
NULL |
NULL |
NULL |
NULL |
Station_Datalogger_LChannel
Only the first physical channel is described.
Field |
Row |
Row |
Row |
Row |
sta |
YBIB |
YBIB |
YBIB |
YBIB |
net |
BK |
BK |
BK |
BK |
data_nb |
1 |
1 |
1 |
1 |
pchannel_nb |
1 |
1 |
1 |
1 |
lchannel_nb |
1 |
2 |
3 |
4 |
seqfil_id |
1 |
2 |
3 |
4 |
seedchan |
CL1 |
HL1 |
BL1 |
LL1 |
channel |
NULL |
NULL |
NULL |
NULL |
channelsrc |
NULL |
NULL |
NULL |
NULL |
location |
NULL |
NULL |
NULL |
NULL |
rgain |
1. |
1. |
1. |
1. |
rfrequency |
0. |
0. |
0. |
0. |
samprate |
500. |
100. |
20. |
1. |
clock_drift |
0.05 |
0.01 |
0.002 |
0.0004 |
flags |
TG |
TG |
TG |
TG |
data_format |
SEED |
SEED |
SEED |
SEED |
comp_type |
1 |
1 |
1 |
1 |
unit_signal |
3 |
3 |
3 |
3 |
unit_calib |
4 |
4 |
4 |
4 |
block_size |
4096 |
4096 |
4096 |
4096 |
ondate |
1996/06/28 23:25:00 |
1996/06/28 23:25:00 |
1996/06/28 23:25:00 |
1996/06/28 23:25:00 |
offdate |
NULL |
NULL |
NULL |
NULL |