NCEDC

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.

Station_Data Summary information on a station
Attribute	Type	Description
net	char(8)	Network code
sta	char(6)	Station code
lat	float	Latitude
lon	float	Longitude
elev	float	Elevation
staname	char(50)	Station description
net_id	int	Network identifier code
word_32	int	32 bit word order
word_16	int	16 bit word order
ondate	date	Start date
offdate	date	Off date
lddate	date	Load date

Station_Comment Comments for a station
Attribute	Type	Description
net	char(8)	Network code
sta	char(6)	Station code
ondate	date	Start date
offdate	date	Off date
comment_id	int	Comment code key
comment_level	int	Comment level
lddate	date	Load date

Channel_Data Summary information on a channel
Attribute	Type	Description
net	char(8)	Network code
sta	char(6)	Station code
seedchan	char(3)	SEED channel name
channel	char(3)	Channel name
channelsrc	char(8)	Domain of channel name
location	char(2)	SEED location
inid	int	Instrument identifier
remark	char(30)	Optional comment
unit_signal	int	Units of signal responses
unit_calib	int	Units of calibration input
lat	float	Latitude
lon	float	Longitude
elev	float	Elevation
edepth	float	Emplacement depth
azimuth	float	Azimuth
dip	float	Dip
format_id	int	Data format identifier code
record_length	int	Data record length
samprate	float	Sampling rate
clock_drift	float	Maximum clock drift
flags	char(27)	SEED channel flags
ondate	date	Start date
offdate	date	Off date
lddate	date	Load date

Channel_Comment Comments for a channel
Attribute	Type	Description
net	char(8)	Network code
sta	char(6)	Station code
seedchan	char(3)	SEED channel name
channel	char(3)	Channel name
channelsrc	char(8)	Domain of channel name
location	char(2)	SEED location
ondate	date	Start date
offdate	date	Off date
comment_id	int	Comment code key
comment_level	float	Comment level
lddate	date	Load date

Polynomial Data associating a channel with a polynomial
Attribute	Type	Description
net	char(8)	Network code
sta	char(6)	Station code
seedchan	char(3)	SEED channel name
channel	char(3)	Channel name
channelsrc	char(8)	Domain of channel name
location	char(2)	SEED location
ondate	date	Start date
offdate	date	Off date
stage_seq	int	Stage sequence
pn_key	int	Response (Polynomial) key
unit_in	int	Signal input units
unit_out	int	Signal output units
tf_type	char(1)	Response type
lddate	date	Load date

PN Summary information on a response (Polynomial)
Attribute	Type	Description
key	int	Response (coefficients) key
name	char(80)	Response (Coefficients) name
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.
lddate	date	Load date

PN_Data Coefficients of a polynomial
Attribute	Type	Description
key	int	Response (Coefficients) key
row_key	int	Row key
pn_value	float	Coefficient value

Coefficients Data associating a channel with a response
Attribute	Type	Description
net	char(8)	Network code
sta	char(6)	Station code
seedchan	char(3)	SEED channel name
channel	char(3)	Channel name
channelsrc	char(8)	Domain of channel name
location	char(2)	SEED location
ondate	date	Start date
offdate	date	Off date
stage_seq	int	Stage sequence
dc_key	int	Response (Coefficients) key
unit_in	int	Signal input units
unit_out	int	Signal output units
tf_type	char(1)	Response type
lddate	date	Load date

DC Summary information on a response (Coefficients)
Attribute	Type	Description
key	int	Response (coefficients) key
name	char(80)	Response (Coefficients) name
symmetry	char(1)	Symmetry code
storage	char(1)	Storage flag (Half/Full)
lddate	date	Load date

DC_Data Coefficients of a response
Attribute	Type	Description
key	int	Response (Coefficients) key
row_key	int	Row key
type	char(1)	Numerator/Denominator
coefficient	float	Numerator/denominator coefficient
error	float	Numerator/denominator error

Decimation Data associating a channel with a decimation
Attribute	Type	Description
net	char(8)	Network code
sta	char(6)	Station code
seedchan	char(3)	SEED channel name
channel	char(3)	Channel name
channelsrc	char(8)	Domain of channel name
location	char(2)	SEED location
ondate	date	Start date
offdate	date	Off date
stage_seq	int	Stage sequence
dm_key	int	Decimation key
lddate	date	Load date

DM Summary information on a decimation
Attribute	Type	Description
key	int	Decimation key
name	char(80)	Decimation name
samprate	float	Input sampling rate
factor	int	Decimation factor
offset	int	Decimation offset
delay	float	Estimated delay
correction	float	Correction applied
lddate	date	Load date

Poles_Zeros Data associating a channel with poles & zeros
Attribute	Type	Description
net	char(8)	Network code
sta	char(6)	Station code
seedchan	char(3)	SEED channel name
channel	char(3)	Channel name
channelsrc	char(8)	Domain of channel name
location	char(2)	SEED location
ondate	date	Start date
offdate	date	Off date
stage_seq	int	Stage sequence
pz_key	int	Poles & zeros key
tf_type	char(1)	Transfer function type
unit_in	int	Stage signal input units
unit_out	int	Stage signal output units
AO	float	AO normalization factor (1.0 if none)
AF	float	Normalization frequency
lddate	date	Load date

PZ Summary information on a response (Poles & Zeros)
Attribute	Type	Description
key	int	Poles & zeros key
name	char(80)	Poles & zeros name
lddate	date	Load date

PZ_Data Poles & zeros of a response
Attribute	Type	Description
key	int	Poles & zeros key
row_key	int	Row key
type	char(1)	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

Sensitivity Data associating a channel with a sensitivity
Attribute	Type	Description
net	char(8)	Network code
sta	char(6)	Station code
seedchan	char(3)	SEED channel name
channel	char(3)	Channel name
channelsrc	char(8)	Domain of channel name
location	char(2)	SEED location
ondate	date	Start date
offdate	date	Off date
stage_seq	int	Stage sequence
sensitivity	float	Sensitivity/gain (S_d)
frequency	float	Frequency (F_s)
lddate	date	Load date

D_Abbreviation Abbreviation dictionary
Attribute	Type	Description
id	int	Abbreviation lookup code
description	char(70)	Abbreviation description

D_Unit Unit dictionary
Attribute	Type	Description
id	int	Unit lookup code
name	char(80)	Unit name
description	char(70)	Unit description

D_Comment Comment dictionary
Attribute	Type	Description
id	int	Comment code key
class	char(1)	Comment class code
description	char(70)	Description of comment
unit	int	Units of comment level

D_Format Format dictionary
Attribute	Type	Description
id	int	Data format identifier code
ms_id	int	MiniSEED identifier
name	char(80)	descriptive name
family	int	Unit family type

D_Format_Data Format data
Attribute	Type	Description
id	int	Data format identifier code
row_id	int	Row identifier
key_d	char(80)	Decoder key

Simple_Response Summary information on a simplified response
Attribute	Type	Description
net	char(8)	Network code
sta	char(6)	Station code
seedchan	char(3)	SEED channel name
channel	char(3)	Channel name
channelsrc	char(8)	Domain of channel name
location	char(2)	SEED location
inid	int	Instrument identifier
frequency	float	Frequency (F_s)
damping_value	float	Damping value
gen_const	float	Generator constant
dig_const	float	Digitizer constant
gain	float	Gain
pz_key	int	Poles & Zeros key
ml_corr	float	Correction for local magnitude
me_corr	float	Correction for energy magnitude
ondate	date	Start date
offdate	date	Off date
lddate	date	Load date