|
SEISMIC |
|
|
|
Attribute |
Attribute Name |
Description |
Format |
Units |
|
|
|
|
|
Event Data from Network |
|
|
|
|
sd_evn_id |
seismic data ID |
An identifier for linking with other tables |
autonumber |
|
sn_net_id |
network id |
An identifier for linking with the network information |
mediumint |
|
sd_evn_eventid |
Event identifier |
The event identifier used by observatory |
text |
|
sd_evn_arch |
seismogram archive |
Location of seismogram archive |
text |
|
sd_evn_stime_utc |
Event time UTC |
Event time (UTC) stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
sd_evn_elat |
Estimated latitude |
Estimated latitude of the seismic event (positive = N) |
sxx.xxxxxxx |
deg lat |
sd_evn_elon |
Estimated longitude |
Estimated longitude of the seismic event (Positive = E) |
sxxx.xxxxxxx |
deg long |
sd_evn_datum |
Datum |
The datum used for the longitude and latitude. |
varchar(30) |
|
sd_evn_edep |
Estimated depth |
Estimated depth of the seismic event |
xxx.x |
km |
sd_evn_totsta |
Total number of stations |
Total number of stations used for location |
mediumint |
|
sd_evn_numphas |
Number of phases |
Number of phases used for location |
mediumint |
|
sd_evn_azgap |
Azimuthal gap |
Azimuthal gap |
xxx |
deg 0-360 |
sd_evn_dcs |
Distance to closest station |
Distance to closest station (km) |
xx.x |
km |
sd_evn_rms |
Rms |
Rms (root mean square) time error (sec), which provides a measure of the location quality. |
xx.xx |
sec |
sd_evn_herr |
Horizontal error |
Horizontal error |
xx.xxx |
km |
sd_evn_derr |
Depth error |
Depth error |
xx.xxx |
km |
sd_evn_locqual |
Location quality |
The quality of the calculated location. The quality marker will be defined by WOVOdat. |
text |
|
sd_evn_pmag |
Primary Magnitude |
Primary Magnitude |
x.x |
M |
sd_evn_pmag_type |
Primary Magnitude type |
Primary Magnitude type |
text |
|
sd_evn_smag |
Secondary Magnitude |
secondary M, where given |
x.x |
M |
sd_evn_smag_type |
Secondary Magnitude type |
secondary Magnitude type |
text |
|
sd_evn_coda |
Coda duration |
Coda duration |
xxx |
sec |
sd_evn_eqtype |
Earthquake type (WOVOdat terminol) |
Earthquake type (WOVOdat terminol) |
text |
|
sd_evn_eqtype_org |
Earthquake type (original terminol) |
Earthquake type (original terminology - VT, LP, Ex; A,B,C; HF, LF; other) |
text |
|
sd_evn_wave_prox |
Proximal waveform |
Waveform recorded at stn <2 km from vent for representative events only. |
digital waveform |
|
sd_evn_wave_int |
Intermediate waveform |
Waveform recorded at stn 2-5 km from vent for representative events only. |
digital waveform |
|
sd_evn_wave_dis |
Distal waveform |
Waveform recorded at stn >5 km from vent for representative events only. |
digital waveform |
|
sd_evn_mten_mxx |
Moment tensor m_xx |
Moment tensor m_xx |
float |
|
sd_evn_mten_mxy |
Moment tensor m_xy |
Moment tensor m_xy |
float |
|
sd_evn_mten_mxz |
Moment tensor m_xz |
Moment tensor m_xz |
float |
|
sd_evn_mten_myy |
Moment tensor m_yy |
Moment tensor m_yy |
float |
|
sd_evn_mten_myz |
Moment tensor m_yz |
Moment tensor m_yz |
float |
|
sd_evn_mten_mzz |
Moment tensor m_zz |
Moment tensor m_zz |
float |
|
sd_evn_strk1 |
Strike 1 of best double couple |
Strike 1 of best double couple |
xxx |
deg 0-360 |
sd_evn_dip1 |
Dip 1 of best double couple |
Dip 1 of best double couple |
xx |
deg 0-90 |
sd_evn_rak1 |
Rake 1 of best double couple |
Rake 1 of best double couple |
xx |
deg 0-90 |
sd_evn_strk2 |
Strike 2 of best double couple |
Strike 2 of best double couple |
xxx |
deg 0-360 |
sd_evn_dip2 |
Dip 2 of best double couple |
Dip 2 of best double couple |
xx |
deg 0-90 |
sd_evn_rak2 |
Rake 2 of best double couple |
Rake 2 of best double couple |
xx |
deg 0-90 |
sd_evn_foc |
Focal plane solution |
Focal plane solution - beachball, w/ arrivals |
image |
|
cc_id2 |
Collector ID |
An identifier for linking to data collector information. |
mediumint |
|
sd_evn_loaddate |
Load date |
The date this row was entered |
datetime |
|
cc_id_load |
Data loader ID |
The id linking to the person who entered this row of data |
mediumint |
|
|
|
|
|
|
|
|
|
|
|
Intensity Table |
|
|
|
|
sd_int_id |
intensity id |
An identifier for linking with other tables |
mediumint |
|
vd_vol_id |
volcano id |
An identifier for linking to the volcano information. |
mediumint |
|
sd_int_time_utc |
time utc |
Approximate time of event (UTC) stored as YYYY-MM-DD hh:mm:ss. |
datetime |
|
sd_evn_eventid |
probable event ID |
This is the probable event identifier for linking with the event table. |
autonumber |
|
sd_int_city |
city |
The name of the city or town where the event was felt |
text |
|
sd_int_radfr |
Max distance, felt |
Max distance at which eq was felt, measured from epicenter |
xxx |
km |
sd_int_max_rint |
Maximum reported intensity |
Maximum reported intensity (modified mercalli intensity). |
x |
MMI |
sd_int_dist_max_rint |
Distance at max reported intensity |
Distance at max reported intensity |
xxx |
km |
cc_id2 |
Collector ID |
An identifier for linking to data collector information. |
mediumint |
|
sd_int_loaddate |
Load date |
The date this row was entered |
datetime |
|
cc_id_load |
Data loader ID |
The id linking to the person who entered this row of data |
mediumint |
|
|
|
|
|
|
|
|
|
|
|
Event data from single station |
|
|
|
|
sd_evs_id |
event data id |
An identifier for linking with other tables |
autonumber |
|
ss_id |
station id |
An identifier for linking with the station information |
mediumint |
|
sd_evs_stime_utc |
Event time utc |
Event start time (UTC) stored as datetime YYYY-MM-DD hh:mm:ss |
datetime |
|
sd_evs_dist_actven |
Distance from active vent |
The distance from where the event was felt to the active vent. Calculated from other data in database. |
xx.x |
km |
sd_evs_maxamptrac |
Max amplitude of trace |
Max amplitude of trace. Enter info only if whole system magnification is listed in station table. |
xx |
mm |
sd_evs_codur |
coda duration |
coda duration |
xxx |
sec |
sd_evs_fint |
felt intensity |
The reported intensity of the event. |
x |
MMI |
cc_id2 |
Collector ID |
An identifier for linking to data collector information. |
mediumint |
|
sd_evs_loaddate |
Load date |
The date this row was entered |
datetime |
|
cc_id_load |
Data loader ID |
The id linking to the person who entered this row of data |
mediumint |
|
|
|
|
|
|
Tremor Information |
|
|
|
|
sd_trm_id |
tremor data id |
An identifier for linking with other tables |
autonumber |
|
sn_net_id |
network id |
An identifier for linking with the network information |
mediumint |
|
ss_id |
Station ID |
An identifier for linking with the station information. Enter station only if reports are from a single station. |
mediumint |
|
sd_trm_stime_utc |
Start time of tremor envelope (UTC) |
Start time (UTC) stored as datetime YYYY-MM-DD hh:mm:ss for individual envelope. The start and stop times are defined by the observatories. |
datetime |
|
sd_trm_ftime_utc |
Stop time of tremor envelope (UTC) |
Stop time (UTC) stored as datetime YYYY-MM-DD hh:mm:ss for individual envelope. The start and stop times are defined by the observatories. |
datetime |
|
sd_trm_tremdur |
Duration of tremor |
Duration of tremor |
xxx.x |
min |
sd_trm_tremdur_day |
Tremor per day |
The duration of tremor for each day. |
xxxx |
min |
sd_trm_qdepth |
Qualitative depth |
Deep, intermediate, shallow (S=0-2 km; I=2-10 km; D >10 km) |
text |
|
sd_trm_wave |
waveform sample |
Representative tremor waveform |
digital waveform |
|
sd_trm_domfreq1 |
Dominant frequency 1 |
Dominant frequency 1 (in Hz) |
xx.xx |
Hz |
sd_trm_domfreq2 |
Dominant frequency 2 (if any) |
Dominant frequency 2 (if any, in Hz) |
xx.xx |
Hz |
sd_trm_maxamptrem |
Maximum amplitude of tremor |
Maximum amplitude of tremor (refer to the station table for gain information). |
xx |
mm |
sd_trm_minamptrem |
Minimum amplitude of tremor |
Minimum amplitude of tremor - the noise level. |
xx |
mm |
sd_trm_desc |
Description of tremor (banded, etc) |
Description of tremor (banded, etc) |
text |
|
sd_trm_visact |
Associated visible activity (desc) |
Associated visible activity (desc) |
text |
|
sd_trm_reddis |
RD |
Reduced displacement - >5km from source preferred, for geometrical spreading |
xx |
cm2 |
sd_trm_rderr |
RD Error |
The reduced displacement error |
xx |
cm2 |
cc_id2 |
Collector ID |
An identifier for linking to data collector information. |
mediumint |
|
sd_trm_loaddate |
Load date |
The date this row was entered |
datetime |
|
cc_id_load |
Data loader ID |
The id linking to the person who entered this row of data |
mediumint |
|
|
|
|
|
|
|
|
|
|
|
Interval data, including swarms |
|
|
|
|
sd_int_id |
interval data id |
An identifier for linking with other tables |
autonumber |
|
sn_net_id |
network id |
An identifier for linking with the network information |
mediumint |
|
ss_id |
Station ID |
The identifier for linking with the station table. Enter only if a single station was used for counts. |
mediumint |
|
sd_int_stime_utc |
interval start time UTC |
The start time (UTC) of this interval based on instrument recordings stored as datetime YYYY-MM-DD hh:mm:ss. |
datetime |
|
sd_int_ftime_utc |
interval stop time UTC |
The stop time (UTC) of this interval based on instrument recordings stored as datetime YYYY-MM-DD hh:mm:ss. |
datetime |
|
sd_int_nrec |
recorded number of earthquakes |
The recorded earthquake count during the specified time interval. |
xxxxxx |
|
sd_int_nfelt |
number of felt earthquakes |
Number of felt earthquakes for this interval. |
xxxx |
|
sd_int_felt_stime_utc |
Earthquake counts felt start time |
Felt arthquake counts measurement start time (UTC) stored as YYYY-MM-DD hh:mm:ss |
datetime |
|
sd_int_felt_ftime_utc |
Earthquake counts felt stop time |
Felt arthquake counts measurement stop time (UTC) stored as YYYY-MM-DD hh:mm:ss |
datetime |
|
sd_int_totale |
Total seismic E release (seismic moment) |
Total seismic E release (seismic moment) for this swarm interval |
|
erg^-0.5 |
sd_int_totale_open_utc |
Seismic E window opens |
Total seismic E release (seismic moment) measurement start time (UTC) stored as YYYY-MM-DD hh:mm:ss. Might not be the same time period as for felt earthquakes. |
datetime |
|
sd_int_totale_close_utc |
Seismic E window closes |
Total seismic E release (seismic moment) measurement stop time (UTC) stored as YYYY-MM-DD hh:mm:ss. Might not be the same time period as for felt earthquakes. |
datetime |
|
sd_int_vmigr_hyp |
Vertical Migration of hypocenters |
The vertical migration of hypocenters (in km use + for up, - for down) |
sxx.x |
km |
sd_int_hdist |
Horizontal Distance |
Horizontal Distance from summit to swarm center |
xx.x |
km |
sd_int_hmigr_hyp |
Horizontal migration of hypocenters |
Horizontal migration of hypocenters from/to the summit (positive = outward). |
sxx.x |
km |
sd_int_patt |
Temporal pattern of swarm |
Temporal pattern of swarm (using one of the WOVOdat defined patterns). |
A,B,C… |
|
cc_id2 |
Collector ID |
An identifier for linking to data collector information. |
mediumint |
|
sd_int_loaddate |
Load date |
The date this row was entered |
datetime |
|
cc_id_load |
Data loader ID |
The id linking to the person who entered this row of data |
mediumint |
|
|
|
|
|
|
RSAM Table |
|
|
|
|
sd_rsm_id |
RSAM id |
An identifier for linking with other tables |
autonumber |
|
ss_id |
Station ID |
An identifier for linking with the seismic station table |
mediumint |
|
sd_rsm_count |
RSAM count |
RSAM count during this interval. RSAM units from a single station can be compared for various intervals |
xxxxx |
RSAM units |
sd_rsm_stime_utc |
RSAM time UTC |
RSAM report time (UTC) stored as YYYY-MM-DD hh:mm:ss. |
datetime |
|
sd_rsm_intv |
RSAM interval time |
The RSAM interval time |
xxx.x |
min |
cc_id2 |
Collector ID |
An identifier for linking to data collector information. |
mediumint |
|
sd_rsm_loaddate |
Load date |
The date this row was entered |
datetime |
|
cc_id_load |
Data loader ID |
The id linking to the person who entered this row of data |
mediumint |
|
|
|
|
|
|
SSAM Table |
|
|
|
|
sd_ssm_id |
SSAM id |
An identifier for linking with other tables |
autonumber |
|
ss_id |
Station ID |
An identifier for linking with the seismic station table |
mediumint |
|
sd_ssm_02hz |
SSAM count, 0-2Hz |
SSAM counts in 0-2Hz spectral band. SSAM units from single station can be compared for various intervals. |
xxxxx |
SSAM units |
sd_ssm_510hz |
SSAM count, 5-10 Hz |
SSAM count in 5-10 Hz spectral band |
xxxxx |
SSAM units |
sd_ssm_stime_utc |
SSAM report time (UTC) |
The SSAM report time (UTC) stored as YYYY-MM-DD hh:mm:ss. |
datetime |
|
sd_ssm_intv |
SSAM interval time |
The SSAM interval time |
xxx.x |
min |
cc_id2 |
Collector ID |
An identifier for linking to data collector information. |
mediumint |
|
sd_ssm_loaddate |
Load date |
The date this row was entered |
datetime |
|
cc_id_load |
Data loader ID |
The id linking to the person who entered this row of data |
mediumint |
|
|
|
|
|
|
Network Table |
|
|
|
|
sn_net_id |
network id |
An identifier for linking with other tables |
autonumber |
|
sn_net_name |
network name |
The name of the network |
text |
|
vd_vol_id |
volcano id |
An identifier for linking to the volcano information. |
autonumber |
|
sn_net_vmodel |
Velocity model |
A cross section image of the velocity model for the network. Can be simple layered model or more complex variation in x-z space. |
image |
|
sn_net_desc |
description |
A description of the network |
varchar(255) |
|
sn_net_comm |
comments |
Comments on about the network |
varchar(255) |
|
sn_net_loaddate |
Load date |
The date this row was entered |
datetime |
|
cc_id_load |
Data loader ID |
The id linking to the person who entered this row of data |
mediumint |
|
|
|
|
|
|
Seismic Station Table |
|
|
|
|
ss_id |
station table ID |
An identifier for linking with other tables. |
autonumber |
|
sn_net_id |
Network ID |
An identifier for linking with the network table. |
mediumint |
|
ss_nam |
station name |
The name of the station |
text |
|
ss_nlat |
latitude |
The latitude of the station |
sxx.xxxxxxx |
deg lat |
ss_nlon |
longitude |
The longitude of the station |
sxxx.xxxxxxx |
deg long |
ss_datum |
Datum |
The datum used for the longitude and latitude. |
varchar(30) |
|
ss_nelev |
elevation |
The nominal elevation of the station ("s" = sign; positive, above sea level). |
sxxxx |
m |
ss_est_utc |
start date |
The date the station was set up and activated (UTC) stored as YYYY-MM-DD hh:mm:ss. |
datetime |
|
ss_dest_utc |
stop date |
The date the station was permanently decommissioned (UTC) stored as YYYY-MM-DD hh:mm:ss. See observatory for station operation history. |
datetime |
|
ss_utc |
difference from UTC |
Time zone relative to UTC - "s" = sign; read as GMT +- xx h. |
sxx.x |
|
ss_desc |
Station description |
A description of the station. |
varchar(255) |
|
ss_gain |
System gain |
Total gain from seismometer, telemetry, and recorder. Please refer to the observatory for information on gain updates. |
|
(times) |
sd_rsm_rscalib |
RSAM Calibration (if any) |
Reduced Displacement per 100 RSAM counts |
xxx.xx |
cm2 |
sd_rsm_sscalib_02hz |
SSAM Calibration, 0-2 Hz (if any) |
Reduced Displacement per 100 SSAM counts, 0-2 Hz |
xxx.xx |
cm2 |
sd_rsm_sscalib_510hz |
SSAM Calibration, 5-10 Hz (if any) |
Reduced Displacement per 100 SSAM counts, 5-10 Hz |
xxx.xx |
cm2 |
cc_id |
Contact ID |
An identifier for linking to contact information. |
mediumint |
|
ss_comm |
Comments |
Comments about the station including information about status. |
varchar(255) |
|
ss_loaddate |
Load date |
The date this row was entered |
datetime |
|
cc_id_load |
Data loader ID |
The id linking to the person who entered this row of data |
mediumint |
|
|
|
|
|
|
Earthquake Translation Table |
|
To translate from local eq terminology to WOVOdat terminology |
|
|
st_eqtr_id |
translation id |
An identifier for linking with other tables. |
autonumber |
|
st_eqtr_org |
original term |
The original terminology. |
text |
|
st_eqtr_wovo |
WOVOdat term |
WOVOdat terminology. |
text |
|
st_eqtr_desc |
description |
Description of terminology. |
text |
|
st_eqtr_loaddate |
Load date |
The date this row was entered |
datetime |
|
cc_id_load |
Data loader ID |
The id linking to the person who entered this row of data |
mediumint |
|
|
|
|
|
|