WOVOdat - Data on Volcanic Unrest

WOVOdat1.1 documentation

This page contains a full description of the database structure.

This description brings a technical insight of the database. People who wish to know more about the database structure may thus use this document as a reference. For each table of the database, the fields, indexes, links and constraints are described.

An offline version of this documentation is available here.

Updates

Latest updates to the database: to be added later

Tables by Field

Here is the list of tables used in the database, sorted by field:

Click on red bars with field names to see Descriptions.

cb - Bibliographic

Description

This table stores information about articles, papers, books, and web sites, with information that is related to the data in WOVOdat.

Field Type Attributes Null Default Extra Unit Comments
cb_id mediumint(8) UNSIGNED No auto_increment ID, bibliography identifier
cb_auth varchar(255) Yes NULL Authors/Editors
cb_year year(4) Yes NULL Publication year
cb_title varchar(255) Yes NULL Title
cb_journ varchar(255) Yes NULL Journal
cb_vol varchar(20) Yes NULL Volume
cb_pub varchar(50) Yes NULL Publisher
cb_page varchar(30) Yes NULL Pages
cb_doi varchar(20) Yes NULL Digital Object Identifier
cb_isbn varchar(13) Yes NULL International Standard Book Number
cb_url varchar(255) Yes NULL Info on the web
cb_labadr varchar(320) Yes NULL Email address of observatory
cb_keywords varchar(255) Yes NULL Keywords
cb_com varchar(255) Yes NULL Comments
cb_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY cb_id

Links

Field Link to
cc_id_load cc.cc_id

Restrictions

None

cc - Contact

Description

This table provides all of the contact information for a person, observatory, or institution.

Field Type Attributes Null Default Extra Unit Comments
cc_id smallint(5) UNSIGNED No auto_increment Contact ID
cc_code varchar(15) Yes NULL Contact Code
cc_code2 varchar(15) Yes NULL Contact Code alias
cc_fname varchar(30) Yes NULL First name
cc_lname varchar(30) Yes NULL Last name
cc_obs varchar(150) Yes NULL Observatory
cc_add1 varchar(60) Yes NULL Address 1
cc_add2 varchar(60) Yes NULL Address 2
cc_city varchar(50) Yes NULL City
cc_state varchar(30) Yes NULL State
cc_country varchar(50) Yes NULL Country
cc_post varchar(30) Yes NULL Postal code
cc_url varchar(255) Yes NULL Web address
cc_email varchar(320) Yes NULL Email
cc_phone varchar(50) Yes NULL Phone
cc_phone2 varchar(50) Yes NULL Phone 2
cc_fax varchar(60) Yes NULL Fax
cc_com varchar(255) Yes NULL Comments
cc_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY cc_id
CODE UNIQUE cc_code

Links

None

Restrictions

None

ch - Change

Description

This table stores information about any changes that have been made in the database.

Field Type Attributes Null Default Extra Unit Comments
ch_id smallint(5) UNSIGNED No auto_increment ID
ch_linkname enum('cb', 'cc', 'ch', 'cm', 'cn', 'co', 'cp', 'cr', 'cr_tmp', 'cs', 'cu', 'dd_ang', 'dd_edm', 'dd_gps', 'dd_gpv', 'dd_lev', 'dd_sar', 'dd_srd', 'dd_str', 'dd_tlt', 'dd_tlv', 'di_gen', 'di_tlt', 'ds', 'ed', 'ed_for', 'ed_phs', 'ed_vid', 'fd_ele', 'fd_gra', 'fd_mag', 'fd_mgv', 'fi', 'fs', 'gd', 'gd_plu', 'gd_sol', 'gi', 'gs', 'hd', 'hi', 'hs', 'ip_hyd', 'ip_mag', 'ip_pres', 'ip_sat', 'ip_tec', 'jj_concon', 'jj_imgx', 'jj_volcon', 'jj_volnet', 'j_sarsat', 'md', 'med', 'mi', 'ms', 'sd_evn', 'sd_evs', 'sd_int', 'sd_ivl', 'sd_rsm', 'sd_sam', 'sd_ssm', 'sd_trm', 'sd_wav', 'si', 'si_cmp', 'sn', 'ss', 'st_eqt', 'td', 'td_img', 'td_pix', 'ti', 'ts', 'vd', 'vd_inf', 'vd_mag', 'vd_tec') Yes NULL Table
ch_link_id mediumint(8) UNSIGNED Yes NULL ID in table
ch_atname varchar(30) Yes NULL Field/attribute name
ch_desc varchar(255) Yes NULL Description
ch_com varchar(255) Yes NULL Comments
ch_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY ch_id

Links

Field Link to
cc_id_load cc.cc_id

Restrictions

None

cm - Image

Description

This table stores images that support other WOVOdat data.

Field Type Attributes Null Default Extra Unit Comments
cm_id smallint(5) UNSIGNED No auto_increment Image ID
cm_code varchar(30) Yes NULL Image Code
vd_id mediumint(8) UNSIGNED Yes NULL Volcano Identifier
cm_lat double Yes NULL Latitude
cm_lon double Yes NULL Longitude
cm_location varchar(255) Yes NULL Location
cm_description varchar(255) Yes NULL Description (including the scale)
cm_format varchar(10) Yes NULL Image Format
cm_date datetime Yes NULL Date
cm_date_unc datetime Yes NULL Date uncertainty
cm_image varchar(255) Yes NULL Link/pat where the image stored
cm_usage varchar(255) Yes NULL Usage of image (copyright)
cm_keywords varchar(255) Yes NULL Keywords
cm_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
cm_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
cm_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
cm_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY cm_id
CODE UNIQUE cm_code
cc_id

Links

Field Link to
vd_id vd.vd_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

None

cn - Common network

Description

This table contains information about the network of stations that collect data at a particular site, in general at one volcano.

Field Type Attributes Null Default Extra Unit Comments
cn_id smallint(5) UNSIGNED No auto_increment ID, Common network Identifier
cn_code varchar(30) Yes NULL Common network Code
vd_id mediumint(8) UNSIGNED Yes NULL Volcano Identifier
cn_name varchar(255) Yes NULL Network Name
cn_type enum('Deformation','Fields','Gas','Hydrologic','Thermal','Meteo','Unknown') No Unknown common network Type
cn_area float Yes NULL km2 Network Area coverage
cn_map varchar(255) Yes NULL Link/path to the Map of the network (from Observatory)
cn_stime datetime Yes NULL Start time
cn_stime_unc datetime Yes NULL Start time uncertainty
cn_etime datetime Yes NULL End time
cn_etime_unc datetime Yes NULL End time uncertainty
cn_utc float Yes NULL Difference from UTC
cn_desc varchar(255) Yes NULL Description
cn_ori varchar(255) Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
cn_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
cn_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
cn_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY cn_id
CODE UNIQUE cn_code
cc_id
cn_stime

Links

Field Link to
vd_id vd.vd_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • cn_stime < cn_etime

co - Observation

Description

This table provides storage for observations about volcanic activity.

Field Type Attributes Null Default Extra Unit Comments
co_id mediumint(8) UNSIGNED No auto_increment Observation ID
co_code varchar(30) Yes NULL Observation Code
vd_id mediumint(8) UNSIGNED Yes NULL Volcano Identifier
co_observe text Yes NULL Description
co_stime datetime Yes NULL Start time
co_stime_unc datetime Yes NULL Start time uncertainty
co_etime datetime Yes NULL End time
co_etime_unc datetime Yes NULL End time uncertainty
co_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Observer ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
co_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
co_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY co_id
CODE UNIQUE co_code
cc_id

Links

Field Link to
vd_id vd.vd_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • co_stime < co_etime

cp - Permission

Description

This table provides the access information for each registered user.

Field Type Attributes Null Default Extra Unit Comments
cp_id tinyint(3) UNSIGNED No auto_increment ID
cr_id tinyint(3) UNSIGNED Yes NULL Registry ID
cp_access enum('0','1','2','3','4','5','6','7','8','9') No 9 Access level, for example: 0=Developer, 9=Minimum access
cp_com varchar(255) Yes NULL Comments
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY cp_id
REGISTERED USER UNIQUE cr_id

Links

Field Link to
cr_id cr.cr_id
cc_id_load cc.cc_id

Restrictions

None

cr - Registry

Description

This table provides username and password information for people who registered to WOVOdat.

Field Type Attributes Null Default Extra Unit Comments
cr_id tinyint(3) UNSIGNED No auto_increment ID
cc_id smallint(5) UNSIGNED Yes NULL User ID
cr_uname varchar(30) No Username
cr_pwd varchar(60) Yes NULL Password
cr_regdate datetime Yes NULL Registration date
cr_update datetime Yes NULL Last update
cr_com varchar(255) Yes NULL Comments

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY cr_id
USERNAME UNIQUE cr_uname

Links

Field Link to
cc_id cc.cc_id

Restrictions

None

cr_tmp - Temporary registry

Description

This table stores information about users who wish to register to WOVOdat while waiting for them to confirm registration by clicking the link provided in a confirmation email.

Field Type Attributes Null Default Extra Unit Comments
cr_tmp_id smallint(5) UNSIGNED No auto_increment ID
cr_tmp_time datetime No Time
cr_tmp_email varchar(320) No Email
cr_tmp_fname varchar(30) Yes NULL First name
cr_tmp_lname varchar(30) Yes NULL Last name
cr_tmp_obs varchar(150) Yes NULL Observatory
cr_tmp_add1 varchar(60) Yes NULL Address 1
cr_tmp_add2 varchar(60) Yes NULL Address 2
cr_tmp_city varchar(50) Yes NULL City
cr_tmp_state varchar(30) Yes NULL State/Province
cr_tmp_country varchar(50) Yes NULL Country
cr_tmp_post varchar(30) Yes NULL Postal code
cr_tmp_url varchar(255) Yes NULL Web address
cr_tmp_phone varchar(50) Yes NULL Phone
cr_tmp_phone2 varchar(50) Yes NULL Phone 2
cr_tmp_fax varchar(60) Yes NULL Fax
cr_tmp_com varchar(255) Yes NULL Comments
cr_tmp_uname varchar(30) No Username
cr_tmp_pwd varchar(60) Yes NULL Password

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY cr_tmp_id

Links

None

Restrictions

None

cs - Satellite/Airplane

Description

This table stores information about satellites and airplanes that are used for collecting data from above the surface of the earth.

Field Type Attributes Null Default Extra Unit Comments
cs_id smallint(5) UNSIGNED No auto_increment satellite/ airplane ID
cs_code varchar(30) Yes NULL satellite/ airplane Code
cs_type enum('S', 'A') Yes NULL Type (A=Airplane, S=Satellite)
cs_name varchar(50) Yes NULL satellite/ airplane Name
cs_stime datetime Yes NULL Start time
cs_stime_unc datetime Yes NULL Start time uncertainty
cs_etime datetime Yes NULL End time
cs_etime_unc datetime Yes NULL End time uncertainty
cs_desc varchar(255) Yes NULL Description
cs_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
cs_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
cs_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
cs_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY cs_id
CODE UNIQUE cs_code
cc_id
cs_stime

Links

Field Link to
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • cs_stime < cs_etime

cu - Upload history

Description

This table stores information about all uploads made to the database, including those which failed.

Field Type Attributes Null Default Extra Unit Comments
cu_id mediumint(8) UNSIGNED No auto_increment ID
cu_file varchar(255) No Original file name
cu_type enum('I', 'N', 'U', 'T', 'W', 'F') Yes NULL Type of upload: I=In database, N=Not in database (test), U=Undone, T=Temporary (to be treated later), W=translated to WOVOML , F=Failed
cu_com text Yes NULL Comments or error message
cu_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY cu_id

Links

Field Link to
cc_id_load cc.cc_id

Restrictions

None

dd_ang - Angle

Description

This table contains a few angles from early geodetic surveys where someone would stand on a high point (on top of a mountain) and measure the horizontal and vertical angles to prominent features in the area.

Field Type Attributes Null Default Extra Unit Comments
dd_ang_id mediumint(8) UNSIGNED No auto_increment Deformation angle ID
dd_ang_code varchar(30) Yes NULL Deformation angle Code
di_gen_id mediumint(8) UNSIGNED Yes NULL General deformation instrument ID
ds_id mediumint(8) UNSIGNED Yes NULL Theodolite/total station instrument identifier ID
ds_id1 mediumint(8) UNSIGNED Yes NULL Target station 1 ID
ds_id2 mediumint(8) UNSIGNED Yes NULL Target station 2 ID
dd_ang_time datetime Yes NULL Measurement time
dd_ang_time_unc datetime Yes NULL Measurement time uncertainty
dd_ang_hort1 float Yes NULL ° Horizontal angle to target 1
dd_ang_hort2 float Yes NULL ° Horizontal angle to target 2
dd_ang_vert1 float Yes NULL ° Vertical angle to target 1
dd_ang_vert2 float Yes NULL ° Vertical angle to target 2
dd_ang_herr1 float Yes NULL ° Horizontal error on angle 1
dd_ang_herr2 float Yes NULL ° Horizontal error on angle 2
dd_ang_verr1 float Yes NULL ° Vertical error on angle 1
dd_ang_verr2 float Yes NULL ° Vertical error on angle 2
dd_ang_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
dd_ang_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
dd_ang_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
dd_ang_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY dd_ang_id
CODE UNIQUE dd_ang_code
cc_id

Links

Field Link to
di_gen_id di_gen.di_gen_id
ds_id ds.ds_id
ds_id1 ds.ds_id
ds_id2 ds.ds_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • 0 ≤ dd_ang_hort1 ≤ 360
  • 0 ≤ dd_ang_hort2 ≤ 360
  • -90 ≤ dd_ang_vert1 ≤ 90
  • -90 ≤ dd_ang_vert2 ≤ 90
  • di_gen_id.di_gen_stime ≤ dd_ang_time ≤ di_gen_id.di_gen_etime
  • ds_id.ds_stime ≤ dd_ang_time ≤ ds_id.ds_etime
  • ds_id1.ds_stime ≤ dd_ang_time ≤ ds_id1.ds_etime
  • ds_id2.ds_stime ≤ dd_ang_time ≤ ds_id2.ds_etime
  • ds_id = di_gen_id.ds_id

dd_edm - EDM

Description

This table contains EDM data that were collected between two stations, an instrument station and a target or reflector station.

Field Type Attributes Null Default Extra Unit Comments
dd_edm_id mediumint(8) UNSIGNED No auto_increment ID
dd_edm_code varchar(30) Yes NULL Code
di_gen_id mediumint(8) UNSIGNED Yes NULL General deformation instrument ID
ds_id1 mediumint(8) UNSIGNED Yes NULL Instrument station ID
ds_id2 mediumint(8) UNSIGNED Yes NULL Target station ID
dd_edm_time datetime Yes NULL Measurement time
dd_edm_time_unc datetime Yes NULL Measurement time uncertainty
dd_edm_line double Yes NULL m Line length
dd_edm_cerr float Yes NULL m Constant error
dd_edm_serr float Yes NULL ppm Scale error
dd_edm_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
dd_edm_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
dd_edm_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
dd_edm_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY dd_edm_id
CODE UNIQUE dd_edm_code
cc_id

Links

Field Link to
di_gen_id di_gen.di_gen_id
ds_id1 ds.ds_id
ds_id2 ds.ds_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • di_gen_id.di_gen_stime ≤ dd_edm_time ≤ di_gen_id.di_gen_etime
  • ds_id1.ds_stime ≤ dd_edm_time ≤ ds_id1.ds_etime
  • ds_id2.ds_stime ≤ dd_edm_time ≤ ds_id2.ds_etime
  • ds_id1 = di_gen_id.ds_id

dd_gps - GPS

Description

This table contains continuous and periodic data collected at a single station and referenced to two reference stations.

Field Type Attributes Null Default Extra Unit Comments
dd_gps_id mediumint(8) UNSIGNED No auto_increment ID
dd_gps_code varchar(30) Yes NULL Code
di_gen_id mediumint(8) UNSIGNED Yes NULL General deformation instrument ID
ds_id mediumint(8) UNSIGNED Yes NULL GPS station ID
ds_id_ref1 mediumint(8) UNSIGNED Yes NULL Reference station 1 ID
ds_id_ref2 mediumint(8) UNSIGNED Yes NULL Reference station 2 ID
dd_gps_time datetime Yes NULL Measurement time
dd_gps_time_unc datetime Yes NULL Measurement time uncertainty
dd_gps_lat double Yes NULL ° Latitude
dd_gps_lon double Yes NULL ° Longitude
dd_gps_elev double Yes NULL m Elevation above sea level
dd_gps_nserr double Yes NULL ° N-S error
dd_gps_ewerr double Yes NULL ° E-W error
dd_gps_verr float Yes NULL m Vertical error
dd_gps_software varchar(50) Yes NULL Position-determining software
dd_gps_orbits varchar(255) Yes NULL Orbits used
dd_gps_dur varchar(255) Yes NULL min Duration of the solution
dd_gps_qual enum('E', 'G', 'P', 'U') Yes NULL Quality: E=Excellent, G=Good, P=Poor, U=Unknown
dd_gps_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
dd_gps_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
dd_gps_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
dd_gps_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY dd_gps_id
CODE UNIQUE dd_gps_code
cc_id

Links

Field Link to
di_gen_id di_gen.di_gen_id
ds_id ds.ds_id
ds_id_ref1 ds.ds_id
ds_id_ref2 ds.ds_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • di_gen_id.di_gen_stime ≤ dd_gps_time ≤ di_gen_id.di_gen_etime
  • ds_id.ds_stime ≤ dd_gps_time ≤ ds_id.ds_etime
  • ds_id_ref1.ds_stime ≤ dd_gps_time ≤ ds_id_ref1.ds_etime
  • ds_id_ref2.ds_stime ≤ dd_gps_time ≤ ds_id_ref2.ds_etime
  • ds_id = di_gen_id.ds_id
  • -90 ≤ dd_gps_lat ≤ 90
  • -180 ≤ dd_gps_lon ≤ 180

dd_gpv - GPS vector

Description

This table contains vectors that were computed from GPS data where the actual positions are not available.

Field Type Attributes Null Default Extra Unit Comments
dd_gpv_id mediumint(8) UNSIGNED No auto_increment ID
dd_gpv_code varchar(30) Yes NULL Code
di_gen_id mediumint(8) UNSIGNED Yes NULL General deformation instrument ID
ds_id mediumint(8) UNSIGNED Yes NULL Deformation station ID
dd_gpv_stime datetime Yes NULL Start time
dd_gpv_stime_unc datetime Yes NULL Start time uncertainty
dd_gpv_etime datetime Yes NULL End time
dd_gpv_etime_unc datetime Yes NULL End time uncertainty
dd_gpv_dmag float Yes NULL mm Displacement magnitude
dd_gpv_daz float Yes NULL ° Displacement azimuth
dd_gpv_vincl float Yes NULL ° Vector inclination
dd_gpv_N float Yes NULL mm North displacement
dd_gpv_E float Yes NULL mm East displacement
dd_gpv_vert float Yes NULL mm Vertical displacement
dd_gpv_dherr float Yes NULL mm Magnitude horizontal uncertainty
dd_gpv_dnerr float Yes NULL mm North displacement uncertainty
dd_gpv_deerr float Yes NULL mm East displacement uncertainty
dd_gpv_dverr float Yes NULL mm Magnitude vertical uncertainty
dd_gpv_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
dd_gpv_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
dd_gpv_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
dd_gpv_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY dd_gpv_id
CODE UNIQUE dd_gpv_code
cc_id

Links

Field Link to
di_gen_id di_gen.di_gen_id
ds_id ds.ds_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • di_gen_id.di_gen_stime ≤ dd_gpv_stime ≤ di_gen_id.di_gen_etime
  • ds_id.ds_stime ≤ dd_gpv_stime ≤ ds_id.ds_etime
  • di_gen_id.di_gen_stime ≤ dd_gpv_etime ≤ di_gen_id.di_gen_etime
  • ds_id.ds_stime ≤ dd_gpv_etime ≤ ds_id.ds_etime
  • dd_gpv_stime ≤ dd_gpv_etime
  • 0 ≤ dd_gpv_daz ≤ 360
  • 0 ≤ dd_gpv_vincl ≤ 90
  • ds_id = di_gen_id.ds_id

dd_lev - Leveling

Description

This table contains elevation changes between successive benchmarks of a leveling line.

Field Type Attributes Null Default Extra Unit Comments
dd_lev_id mediumint(8) UNSIGNED No auto_increment ID
dd_lev_code varchar(30) Yes NULL Code
di_gen_id mediumint(8) UNSIGNED Yes NULL General deformation instrument ID
ds_id_ref mediumint(8) UNSIGNED Yes NULL Reference benchmark ID
ds_id1 mediumint(8) UNSIGNED Yes NULL First benchmark (n) ID
ds_id2 mediumint(8) UNSIGNED Yes NULL Second benchmark (n+1) ID
dd_lev_ord mediumint(9) Yes NULL Order
dd_lev_class varchar(30) Yes NULL Class
dd_lev_time datetime Yes NULL Survey date
dd_lev_time_unc datetime Yes NULL Survey date uncertainty
dd_lev_delev float Yes NULL mm Elevation change
dd_lev_herr float Yes NULL mm Elevation change uncertainty
dd_lev_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
dd_lev_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
dd_lev_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
dd_lev_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY dd_lev_id
CODE UNIQUE dd_lev_code
cc_id

Links

Field Link to
di_gen_id di_gen.di_gen_id
ds_id_ref ds.ds_id
ds_id1 ds.ds_id
ds_id2 ds.ds_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • di_gen_id.di_gen_stime ≤ dd_lev_time ≤ di_gen_id.di_gen_etime
  • ds_id_ref.ds_stime ≤ dd_lev_time ≤ ds_id_ref.ds_etime
  • ds_id1.ds_stime ≤ dd_lev_time ≤ ds_id1.ds_etime
  • ds_id2.ds_stime ≤ dd_lev_time ≤ ds_id2.ds_etime
  • ds_id_ref = di_gen_id.ds_id

dd_sar - InSAR image

Description

This table contains information about radar interferograms that show deformation of volcanoes.

Field Type Attributes Null Default Extra Unit Comments
dd_sar_id mediumint(8) UNSIGNED No auto_increment ID
dd_sar_code varchar(30) Yes NULL Code
vd_id mediumint(8) UNSIGNED Yes NULL Volcano Identifier
di_gen_id mediumint(8) UNSIGNED Yes NULL General deformation instrument ID
cs_id mediumint(8) UNSIGNED Yes NULL Satellite ID
dd_sar_slat double Yes NULL ° Starting latitude
dd_sar_slon double Yes NULL ° Starting longitude
dd_sar_spos enum('BLC', 'TLC') Yes NULL Starting position: BLC=Bottom Left Corner, TLC=Top Left Corner
dd_sar_rord varchar(30) Yes NULL Row order
dd_sar_nrows smallint(5) UNSIGNED Yes NULL Number of rows
dd_sar_ncols smallint(5) UNSIGNED Yes NULL Number of columns
dd_sar_units varchar(30) Yes NULL Units
dd_sar_ndata varchar(30) Yes NULL Null data value
dd_sar_loc varchar(255) Yes NULL Location
dd_sar_pair enum('P', 'S', 'U') Yes NULL Flag: P=Pair, S=Stacked, U=Unknown
dd_sar_desc varchar(255) Yes NULL Description
dd_sar_dem varchar(50) Yes NULL DEM
dd_sar_dord varchar(30) Yes NULL Data order
dd_sar_img1_time datetime Yes NULL Date of image 1
dd_sar_img1_time_unc datetime Yes NULL Date of image 1 uncertainty
dd_sar_img2_time datetime Yes NULL Date of image 2
dd_sar_img2_time_unc datetime Yes NULL Date of image 2 uncertainty
dd_sar_pixsiz float Yes NULL m Pixel size
dd_sar_spacing float Yes NULL ° Spacing of rows and columns
dd_sar_lookang float Yes NULL ° Look angle
dd_sar_limb enum('ASC', 'DES') Yes NULL Limb: ASC=Ascending, DES=Descending
dd_sar_img_path varchar(255) Yes NULL Image Path
dd_sar_geotiff varchar(255) Yes NULL GEOTIFF of interferogram
dd_sar_prometh varchar(255) Yes NULL Processing method
dd_sar_softwr varchar(255) Yes NULL Software
dd_sar_dem_qual enum('E', 'G', 'F', 'U') Yes NULL DEM quality: E=Excellent, G=Good, F=Fair, U=Unknown
dd_sar_ori enum('D', 'O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
dd_sar_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
dd_sar_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
dd_sar_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY dd_sar_id
CODE UNIQUE dd_sar_code
cc_id

Links

Field Link to
vd_id vd.vd_id
di_gen_id di_gen.di_gen_id
cs_id cs.cs_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • -90 ≤ dd_sar_slat ≤ 90
  • -180 ≤ dd_sar_slon ≤ 180
  • dd_sar_nrows × dd_sar_ncols = COUNT (dd_srd WHERE dd_srd.dd_sar_id=dd_sar_id)
  • dd_sar_img1_time ≤ dd_sar_img2_time
  • di_gen_id.di_gen_stime ≤ dd_sar_img1_time ≤ di_gen_id.di_gen_etime
  • di_gen_id.di_gen_stime ≤ dd_sar_img2_time ≤ di_gen_id.di_gen_etime
  • vd_id = di_gen_id.ds_id.cn_id.vd_id OR jj_volnet.vd_id WHERE jj_net_id=di_gen_id.ds_id.cn_id.vd_id AND jj_net_flag=C

dd_srd - InSAR image pixel

Description

This table contains the data collected by two satellites to create an InSAR image.

Field Type Attributes Null Default Extra Unit Comments
dd_srd_id mediumint(8) UNSIGNED No auto_increment ID
dd_sar_id mediumint(8) UNSIGNED Yes NULL InSAR image ID
dd_srd_numb int(10) Yes NULL Number
dd_srd_dchange float Yes NULL mm Range of change
dd_srd_com varchar(255) Yes NULL Comments
dd_srd_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY dd_srd_id
PIXEL NUMBER UNIQUE dd_sar_id
dd_srd_numb

Links

Field Link to
dd_sar_id dd_sar.dd_sar_id
cc_id_load cc.cc_id

Restrictions

  • dd_srd_numb = 1, 2, 3 ... X (where X = dd_sar_id.dd_sar_nrows × dd_sar_id.dd_sar_ncols)
  • pixel at starting position of InSAR image (dd_sar.dd_sar_spos) = dd_srd WHERE dd_srb_numb = 1

dd_str - Strain

Description

This table stores both raw and processed strainmeter data.

Field Type Attributes Null Default Extra Unit Comments
dd_str_id mediumint(8) UNSIGNED No auto_increment ID
dd_str_code varchar(30) Yes NULL Code
ds_id mediumint(8) UNSIGNED Yes NULL Deformation station ID
di_tlt_id smallint(5) UNSIGNED Yes NULL Strainmeter ID
dd_str_time datetime Yes NULL Survey date
dd_str_time_unc datetime Yes NULL Survey date uncertainty
dd_str_comp1 double Yes NULL μstrain Component 1
dd_str_comp2 double Yes NULL μstrain Component 2
dd_str_comp3 double Yes NULL μstrain Component 3
dd_str_comp4 double Yes NULL μstrain Component 4
dd_str_err1 double Yes NULL μstrain Component 1 error
dd_str_err2 double Yes NULL μstrain Component 2 error
dd_str_err3 double Yes NULL μstrain Component 3 error
dd_str_err4 double Yes NULL μstrain Component 4 error
dd_str_vdstr double Yes NULL μstrain Volumetric strain change
dd_str_vdstr_err double Yes NULL μstrain Volumetric strain change error
dd_str_sstr_ax1 double Yes NULL μstrain Shear strain of axis 1
dd_str_azi_ax1 float Yes NULL ° Azimuth of axis 1
dd_str_sstr_ax2 double Yes NULL μstrain Shear strain of axis 2
dd_str_azi_ax2 float Yes NULL ° Azimuth of axis 2
dd_str_sstr_ax3 double Yes NULL μstrain Shear strain of axis 3
dd_str_azi_ax3 float Yes NULL ° Azimuth of axis 3
dd_str_stderr1 double Yes NULL μstrain Strain for axis 1 uncertainty
dd_str_stderr2 double Yes NULL μstrain Strain for axis 2 uncertainty
dd_str_stderr3 double Yes NULL μstrain Strain for axis 3 uncertainty
dd_str_pmax double Yes NULL μstrain Maximum principal strain
dd_str_pmaxerr double Yes NULL μstrain Maximum principal strain uncertainty
dd_str_pmin double Yes NULL μstrain Minimum principal strain
dd_str_pminerr double Yes NULL μstrain Minimum principal strain uncertainty
dd_str_pmax_dir float Yes NULL ° Maximum principal strain direction
dd_str_pmax_direrr float Yes NULL ° Maximum principal strain direction uncertainty
dd_str_pmin_dir float Yes NULL ° Minimum principal strain direction
dd_str_pmin_direrr float Yes NULL ° Minimum principal strain direction uncertainty
dd_str_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
dd_str_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
dd_str_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
dd_str_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY dd_str_id
CODE UNIQUE dd_str_code
cc_id

Links

Field Link to
ds_id ds.ds_id
di_tlt_id di_tlt.di_tlt_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • di_tlt_id.di_tlt_stime ≤ dd_str_time ≤ di_tlt_id.di_tlt_etime
  • ds_id.ds_stime ≤ dd_str_time ≤ ds_id.ds_etime
  • 0 ≤ dd_str_azi_ax1 ≤ 360
  • 0 ≤ dd_str_azi_ax2 ≤ 360
  • 0 ≤ dd_str_azi_ax3 ≤ 360
  • 0 ≤ dd_str_pmax_dir ≤ 360
  • 0 ≤ dd_str_pmin_dir ≤ 360
  • dd_str_pmin ≤ dd_str_pmax
  • ds_id = di_tlt_id.ds_id

dd_tlt - Electronic tilt

Description

This table contains tilt data that are either raw or processed.

Field Type Attributes Null Default Extra Unit Comments
dd_tlt_id mediumint(8) UNSIGNED No auto_increment ID
dd_tlt_code varchar(30) Yes NULL Code
ds_id mediumint(8) UNSIGNED Yes NULL Deformation station ID
di_tlt_id smallint(5) UNSIGNED Yes NULL Tiltmeter ID
dd_tlt_time datetime Yes NULL Measurement time
dd_tlt_timecsec decimal(2,2) Yes NULL Centisecond precision for measurement time
dd_tlt_time_unc datetime Yes NULL Measurement time uncertainty
dd_tlt_timecsec_unc decimal(2,2) Yes NULL Centisecond precision for measurement time uncertainty
dd_tlt_srate double Yes NULL sec Sampling rate
dd_tlt1 double Yes NULL Tilt measurement 1
dd_tlt2 double Yes NULL Tilt measurement 2
dd_tlt_err1 double Yes NULL Tilt 1 error
dd_tlt_err2 double Yes NULL Tilt 2 error
dd_tlt_proc_flg enum('P', 'R') Yes NULL Flag: P=Processed, R=Raw
dd_tlt_temp double Yes NULL Temperature
dd_tlt_bat double Yes NULL Battery Level
dd_tlt_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
dd_tlt_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
dd_tlt_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
dd_tlt_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY dd_tlt_id
CODE UNIQUE dd_tlt_code
cc_id

Links

Field Link to
ds_id ds.ds_id
di_tlt_id di_tlt.di_tlt_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • di_tlt_id.di_tlt_stime ≤ dd_tlt_time ≤ di_tlt_id.di_tlt_etime
  • ds_id.ds_stime ≤ dd_tlt_time ≤ ds_id.ds_etime
  • ds_id = di_tlt_id.ds_id

dd_tlv - Tilt vector

Description

This table stores tilt information from sources where we do not have the raw or semi-processed data and only have access to tilt vectors.

Field Type Attributes Null Default Extra Unit Comments
dd_tlv_id mediumint(8) UNSIGNED No auto_increment ID
dd_tlv_code varchar(30) Yes NULL Code
ds_id mediumint(8) UNSIGNED Yes NULL Deformation station ID
di_tlt_id smallint(5) UNSIGNED Yes NULL Tiltmeter ID
dd_tlv_stime datetime Yes NULL Start time
dd_tlv_stime_unc datetime Yes NULL Start time uncertainty
dd_tlv_etime datetime Yes NULL End time
dd_tlv_etime_unc datetime Yes NULL End time uncertainty
dd_tlv_mag float Yes NULL μrad Magnitude
dd_tlv_azi float Yes NULL ° Azimuth
dd_tlv_magerr float Yes NULL μrad Magnitude error
dd_tlv_azierr float Yes NULL ° Azimuth error
dd_tlv_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
dd_tlv_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
dd_tlv_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
dd_tlv_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY dd_tlv_id
CODE UNIQUE dd_tlv_code
cc_id

Links

Field Link to
ds_id ds.ds_id
di_tlt_id di_tlt.di_tlt_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • di_tlt_id.di_tlt_stime ≤ dd_tlv_stime ≤ di_tlt_id.di_tlt_etime
  • ds_id.ds_stime ≤ dd_tlv_stime ≤ ds_id.ds_etime
  • di_tlt_id.di_tlt_stime ≤ dd_tlv_etime ≤ di_tlt_id.di_tlt_etime
  • ds_id.ds_stime ≤ dd_tlv_etime ≤ ds_id.ds_etime
  • dd_tlv_stime ≤ dd_tlv_etime
  • 0 ≤ dd_tlv_azi ≤ 360
  • ds_id = di_tlt_id.ds_id

di_gen - General deformation instrument

Description

This table stores information about each individual instrument.

Field Type Attributes Null Default Extra Unit Comments
di_gen_id mediumint(8) UNSIGNED No auto_increment ID
di_gen_code varchar(30) Yes NULL Code
ds_id mediumint(8) UNSIGNED Yes NULL Deformation station ID
di_gen_name varchar(255) Yes NULL Name
di_gen_type enum('Angle','CGPS','EDM','EDM_Reflector','GPS','Total_Station','OtherTypes') Yes NULL Type
di_gen_units varchar(30) Yes NULL Units measured
di_gen_res float Yes NULL Resolution
di_gen_stn float Yes NULL Signal to noise
di_gen_stime datetime Yes NULL Start time
di_gen_stime_unc datetime Yes NULL Start time uncertainty
di_gen_etime datetime Yes NULL End time
di_gen_etime_unc datetime Yes NULL End time uncertainty
di_gen_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
di_gen_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
di_gen_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
di_gen_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY di_gen_id
CODE UNIQUE di_gen_code
cc_id
di_gen_stime

Links

Field Link to
ds_id ds.ds_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • ds_id.ds_stime ≤ di_gen_stime ≤ ds_id.ds_etime
  • ds_id.ds_stime ≤ di_gen_etime ≤ ds_id.ds_etime
  • di_gen_stime ≤ di_gen_etime

di_tlt - Tilt/Strain instrument

Description

This table stores information about each individual instrument and provides the necessary data to process raw data from the tilt and strain data tables.

Field Type Attributes Null Default Extra Unit Comments
di_tlt_id smallint(5) UNSIGNED No auto_increment ID
di_tlt_code varchar(30) Yes NULL Code
ds_id mediumint(8) UNSIGNED Yes NULL Deformation station ID
di_tlt_name varchar(255) Yes NULL Name
di_tlt_type enum('Tilt','Strain') Yes NULL Type
di_tlt_depth float Yes NULL m Depth
di_tlt_units varchar(30) Yes NULL Units measured
di_tlt_res float Yes NULL Resolution
di_tlt_dir1 float Yes NULL ° Azimuth of direction 1
di_tlt_dir2 float Yes NULL ° Azimuth of direction 2
di_tlt_dir3 float Yes NULL ° Azimuth of direction 3
di_tlt_dir4 float Yes NULL ° Azimuth of direction 4
di_tlt_econv1 float Yes NULL μrad/mV or μstrain/mV Electronic conversion for component 1
di_tlt_econv2 float Yes NULL μrad/mV or μstrain/mV Electronic conversion for component 2
di_tlt_econv3 float Yes NULL μrad/mV or μstrain/mV Electronic conversion for component 3
di_tlt_econv4 float Yes NULL μrad/mV or μstrain/mV Electronic conversion for component 4
di_tlt_stime datetime Yes NULL Start time
di_tlt_stime_unc datetime Yes NULL Start time uncertainty
di_tlt_etime datetime Yes NULL End time
di_tlt_etime_unc datetime Yes NULL End time uncertainty
di_tlt_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
di_tlt_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
di_tlt_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
di_tlt_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY di_tlt_id
CODE UNIQUE di_tlt_code
cc_id
di_tlt_stime

Links

Field Link to
ds_id ds.ds_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • ds_id.ds_stime ≤ di_tlt_stime ≤ ds_id.ds_etime
  • ds_id.ds_stime ≤ di_tlt_etime ≤ ds_id.ds_etime
  • di_tlt_stime ≤ di_tlt_etime
  • 0 ≤ di_tlt_dir1 ≤ 360
  • 0 ≤ di_tlt_dir2 ≤ 360
  • 0 ≤ di_tlt_dir3 ≤ 360
  • 0 ≤ di_tlt_dir4 ≤ 360

ds - Deformation station

Description

This table stores information such as a location, name, and description for stations where deformation or geodetic data are collected.

Field Type Attributes Null Default Extra Unit Comments
ds_id mediumint(8) UNSIGNED No auto_increment ID
ds_code varchar(30) Yes NULL Code
ds_name varchar(255) Yes NULL Name
cn_id smallint(5) UNSIGNED Yes NULL Deformation network ID
ds_perm varchar(255) Yes NULL List of permanent instruments
ds_nlat double Yes NULL ° Nominal latitude
ds_nlon double Yes NULL ° Nominal longitude
ds_nelev float Yes NULL m Nominal elevation
ds_herr_loc float Yes NULL Horizontal precision of nominal location
ds_stime datetime Yes NULL Start time
ds_stime_unc datetime Yes NULL Start time uncertainty
ds_etime datetime Yes NULL End time
ds_etime_unc datetime Yes NULL End time uncertainty
ds_utc float Yes NULL Difference from UTC
ds_rflag enum('Y', 'N') Yes NULL Reference station: Y=Yes, N=No
ds_desc varchar(255) Yes NULL Description
ds_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
ds_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
ds_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
ds_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY ds_id
CODE UNIQUE ds_code
cc_id
ds_stime

Links

Field Link to
cn_id cn.cn_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • cn_id.cn_stime ≤ ds_stime ≤ cn_id.cn_etime
  • cn_id.cn_stime ≤ ds_etime ≤ cn_id.cn_etime
  • ds_stime ≤ ds_etime

ed - Eruption

Description

This table stores general information about an eruption such as a narrative and time span.

Field Type Attributes Null Default Extra Unit Comments
ed_id mediumint(8) UNSIGNED No auto_increment ID, eruption identifier (index)
ed_code varchar(30) Yes NULL EruptionCode
vd_id mediumint(8) UNSIGNED Yes NULL Volcano Identifier
ed_name varchar(60) Yes NULL EruptionName
ed_nar varchar(255) Yes NULL Narrative
ed_stime datetime Yes NULL Start time
ed_stime_bc smallint(6) Yes NULL Year of start time before Christ
ed_stime_unc datetime Yes NULL Start time uncertainty
ed_etime datetime Yes NULL End time
ed_etime_bc smallint(6) Yes NULL Year of end time before Christ
ed_etime_unc datetime Yes NULL End time uncertainty
ed_climax datetime Yes NULL Onset of climax
ed_climax_bc smallint(6) Yes NULL Year of climax time before Christ
ed_climax_unc datetime Yes NULL Onset of climax uncertainty
ed_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL First Collector ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Collector ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Collector ID
ed_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
ed_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY ed_id
CODE UNIQUE ed_code
cc_id

Links

Field Link to
vd_id vd.vd_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • ed_stime ≤ ed_climax ≤ ed_etime

ed_for - Eruption forecast

Description

This table stores information about forecasts made for a phase of the eruption, such as an overview of the forecast and the times forecasted.

Field Type Attributes Null Default Extra Unit Comments
ed_for_id mediumint(8) UNSIGNED No auto_increment ID
ed_for_code varchar(30) Yes NULL Code
vd_id mediumint(8) UNSIGNED Yes NULL Volcano Identifier
ed_phs_id mediumint(8) UNSIGNED Yes NULL Eruption phase ID
ed_for_desc varchar(255) Yes NULL Description
ed_for_open datetime Yes NULL Earliest expected start time of eruption
ed_for_open_unc datetime Yes NULL Earliest expected start time of eruption uncertainty
ed_for_close datetime Yes NULL Latest expected start time of eruption
ed_for_close_unc datetime Yes NULL Latest expected start time of eruption uncertainty
ed_for_time datetime Yes NULL Issue date
ed_for_time_unc datetime Yes NULL Issue date uncertainty
ed_for_tsucc enum('Y', 'N', 'P') Yes NULL Success on time: Y=Yes, N=No, P=Partly
ed_for_msucc enum('Y', 'N', 'P') Yes NULL Success on magnitude: Y=Yes, N=No, P=Partly
ed_for_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
ed_for_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
ed_for_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY ed_for_id
CODE UNIQUE ed_for_code
cc_id

Links

Field Link to
vd_id vd.vd_id
ed_phs_id ed_phs.ed_phs_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • ed_for_time ≤ ed_for_open ≤ ed_for_close
  • ed_for_time ≤ ed_phs_id.ed_phs_stime
  • vd_id = ed_phs_id.ed_id.vd_id

ed_phs - Eruption phase

Description

This table stores specific information about the eruption such as the size of the phase and composition of magma.

Field Type Attributes Null Default Extra Unit Comments
ed_phs_id mediumint(8) UNSIGNED No auto_increment ID
ed_phs_code varchar(30) Yes NULL Code
ed_id mediumint(8) UNSIGNED Yes NULL Eruption ID
ed_phs_phsnum float Yes NULL Phase number
ed_phs_stime datetime Yes NULL Start time
ed_phs_stime_bc smallint(6) Yes NULL Year of start time before Christ
ed_phs_stime_unc datetime Yes NULL Start time uncertainty
ed_phs_etime datetime Yes NULL End time
ed_phs_etime_bc smallint(6) Yes NULL Year of end time before Christ
ed_phs_etime_unc datetime Yes NULL End time uncertainty
ed_phs_desc varchar(255) Yes NULL Description
ed_phs_vei mediumint(9) Yes NULL VEI (Volcanic Explosivity Index)
ed_phs_max_lext float Yes NULL m3/s Maximum lava extrusion rate
ed_phs_max_expdis float Yes NULL kg/s × 106 Maximum explosive mass discharge rate
ed_phs_dre float Yes NULL m3 × 106 DRE (Dense-Rock Equivalent)
ed_phs_mix enum('Y', 'N', 'U') Yes NULL Evidence of magma mixing: Y=Yes, N=No, U=Unknown
ed_phs_col float Yes NULL km Column height
ed_phs_coldet varchar(255) Yes NULL Column height determination
ed_phs_minsio2_mg float Yes NULL % Minimum SiO2 of matrix glass
ed_phs_maxsio2_mg float Yes NULL % Maximum SiO2 of matrix glass
ed_phs_minsio2_wr float Yes NULL % Minimum SiO2 of whole rock
ed_phs_maxsio2_wr float Yes NULL % Maximum SiO2 of whole rock
ed_phs_totxtl float Yes NULL % Total crystallinity
ed_phs_phenc float Yes NULL % Phenocryst content
ed_phs_phena varchar(255) Yes NULL Phenocryst assemblage
ed_phs_h2o float Yes NULL Pre-eruption water content
ed_phs_h2o_xtl varchar(255) Yes NULL Description of phenocryst and melt inclusion
ed_phs_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner /Collector ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner/Collector ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner/Collector ID
ed_phs_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
ed_phs_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY ed_phs_id
CODE UNIQUE ed_phs_code
cc_id

Links

Field Link to
ed_id ed.ed_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • ed_phs_stime ≤ ed_phs_etime
  • ed_id.ed_stime ≤ ed_phs_stime ≤ ed_id.ed_etime
  • ed_id.ed_stime ≤ ed_phs_etime ≤ ed_id.ed_etime

ed_vid - Eruption video

Description

This table stores information about a video clip of the eruption.

Field Type Attributes Null Default Extra Unit Comments
ed_vid_id mediumint(8) UNSIGNED No auto_increment ID
ed_vid_code varchar(30) Yes NULL Code
vd_id mediumint(8) UNSIGNED Yes NULL Volcano Identifier
ed_id mediumint(8) UNSIGNED Yes NULL Eruption ID
ed_phs_id mediumint(8) UNSIGNED Yes NULL Eruption phase ID
ed_vid_link varchar(255) Yes NULL Link
ed_vid_stime datetime Yes NULL Start time
ed_vid_stime_unc datetime Yes NULL Start time uncertainty
ed_vid_length time Yes NULL Length
ed_vid_desc varchar(255) Yes NULL Description
ed_vid_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
ed_vid_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
ed_vid_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY ed_vid_id
CODE UNIQUE ed_vid_code
cc_id

Links

Field Link to
vd_id vd.vd_id
ed_id ed.ed_id
ed_phs_id ed_phs.ed_phs_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • ed_id = ed_phs_id.ed_id
  • vd_id = ed_phs_id.ed_id.vd_id

fd_ele - Electric fields

Description

This table contains electric data in digital form.

Field Type Attributes Null Default Extra Unit Comments
fd_ele_id mediumint(8) UNSIGNED No auto_increment ID
fd_ele_code varchar(30) Yes NULL Code
fs_id1 mediumint(8) UNSIGNED Yes NULL ID of fields station from which the electrode is subtracted
fs_id2 mediumint(8) UNSIGNED Yes NULL ID of fields station for the electrode that's being subtracted
fi_id mediumint(8) UNSIGNED Yes NULL Fields instrument ID
fd_ele_time datetime Yes NULL Measurement time
fd_ele_time_unc datetime Yes NULL Measurement time uncertainty
fd_ele_field float Yes NULL mV Field
fd_ele_ferr float Yes NULL mV Field uncertainty
fd_ele_dir float Yes NULL ° Direction
fd_ele_hpass float Yes NULL Hz High pass filter frequency
fd_ele_lpass float Yes NULL Hz Low pass filter frequency
fd_ele_spot float Yes NULL mV Self potential
fd_ele_spot_err float Yes NULL mV Self potential uncertainty
fd_ele_ares float Yes NULL Ω m Apparent resistivity
fd_ele_ares_err float Yes NULL Ω m Apparent resistivity uncertainty
fd_ele_dres float Yes NULL Ω m Direct resistivity
fd_ele_dres_err float Yes NULL Ω m Direct resistivity uncertainty
fd_ele_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
fd_ele_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
fd_ele_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
fd_ele_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY fd_ele_id
CODE UNIQUE fd_ele_code
cc_id

Links

Field Link to
fs_id1 fs.fs_id
fs_id2 fs.fs_id
fi_id fi.fi_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • fs_id1.fs_stime ≤ fd_ele_time ≤ fs_id1.fs_etime
  • fs_id2.fs_stime ≤ fd_ele_time ≤ fs_id2.fs_etime
  • fi_id.fi_stime ≤ fd_ele_time ≤ fi_id.fi_etime

fd_gra - Gravity

Description

This table contains gravity data such as field strength and associated vertical displacement.

Field Type Attributes Null Default Extra Unit Comments
fd_gra_id mediumint(8) UNSIGNED No auto_increment ID
fd_gra_code varchar(30) Yes NULL Code
fs_id mediumint(8) UNSIGNED Yes NULL Fields station ID
fs_id_ref mediumint(8) UNSIGNED Yes NULL Reference station ID
fi_id mediumint(8) UNSIGNED Yes NULL Fields instrument ID
fd_gra_time datetime Yes NULL Measurement time
fd_gra_time_unc datetime Yes NULL Measurement time uncertainty
fd_gra_fstr double Yes NULL Gal Strength
fd_gra_ferr double Yes NULL Gal Strength uncertainty
fd_gra_vdisp varchar(255) Yes NULL Associated vertical displacement: Y=Yes, N=No, U=Unknown
fd_gra_gwater varchar(255) Yes NULL Associated change in groundwater level: Y=Yes, N=No, U=Unknown
fd_gra_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
fd_gra_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
fd_gra_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
fd_gra_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY fd_gra_id
CODE UNIQUE fd_gra_code
cc_id

Links

Field Link to
fs_id fs.fs_id
fs_id_ref fs.fs_id
fi_id fi.fi_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • fs_id.fs_stime ≤ fd_gra_time ≤ fs_id.fs_etime
  • fs_id_ref.fs_stime ≤ fd_gra_time ≤ fs_id_ref.fs_etime
  • fi_id.fi_stime ≤ fd_gra_time ≤ fi_id.fi_etime
  • fs_id = fi_id.fs_id

fd_mag - Magnetic fields

Description

This table contains magnetic data that were collected digitally.

Field Type Attributes Null Default Extra Unit Comments
fd_mag_id mediumint(8) UNSIGNED No auto_increment ID
fd_mag_code varchar(30) Yes NULL Code
fs_id mediumint(8) UNSIGNED Yes NULL Fields station ID
fs_id_ref mediumint(8) UNSIGNED Yes NULL Reference station ID
fi_id mediumint(8) UNSIGNED Yes NULL Fields instrument ID
fd_mag_time datetime Yes NULL Measurement time
fd_mag_time_unc datetime Yes NULL Measurement time uncertainty
fd_mag_f double Yes NULL nT F
fd_mag_compx double Yes NULL nT X
fd_mag_compy double Yes NULL nT Y
fd_mag_compz double Yes NULL nT Z
fd_mag_ferr float Yes NULL nT Total field strength uncertainty
fd_mag_errx float Yes NULL nT Component X uncertainty
fd_mag_erry float Yes NULL nT Component Y uncertainty
fd_mag_errz float Yes NULL nT Component Z uncertainty
fd_mag_highpass float Yes NULL Hz High pass
fd_mag_lowpass float Yes NULL Hz Low pass
fd_mag_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
fd_mag_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
fd_mag_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
fd_mag_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY fd_mag_id
CODE UNIQUE fd_mag_code
cc_id

Links

Field Link to
fs_id fs.fs_id
fs_id_ref fs.fs_id
fi_id fi.fi_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • fs_id.fs_stime ≤ fd_mag_time ≤ fs_id.fs_etime
  • fs_id_ref.fs_stime ≤ fd_mag_time ≤ fs_id_ref.fs_etime
  • fi_id.fi_stime ≤ fd_mag_time ≤ fi_id.fi_etime
  • fs_id = fi_id.fs_id

fd_mgv - Magnetic vector

Description

This table contains magnetic vector data for which the data for the individual components is unavailable.

Field Type Attributes Null Default Extra Unit Comments
fd_mgv_id mediumint(8) UNSIGNED No auto_increment ID
fd_mgv_code varchar(30) Yes NULL Code
fs_id mediumint(8) UNSIGNED Yes NULL Fields station ID
fi_id mediumint(8) UNSIGNED Yes NULL Fields instrument ID
fd_mgv_time datetime Yes NULL Measurement time
fd_mgv_time_unc datetime Yes NULL Measurement time uncertainty
fd_mgv_dec float Yes NULL ° Declination
fd_mgv_incl float Yes NULL ° Inclination
fd_mgv_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
fd_mgv_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
fd_mgv_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
fd_mgv_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY fd_mgv_id
CODE UNIQUE fd_mgv_code
cc_id

Links

Field Link to
fs_id fs.fs_id
fi_id fi.fi_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • 0 ≤ fd_mgv_dec ≤ 360
  • 0 ≤ fd_mgv_incl ≤ 90
  • fs_id.fs_stime ≤ fd_mgv_time ≤ fs_id.fs_etime
  • fi_id.fi_stime ≤ fd_mgv_time ≤ fi_id.fi_etime
  • fs_id = fi_id.fs_id

fi - Fields instrument

Description

This table stores information about the instruments used to collect magnetic, electric, and gravity data.

Field Type Attributes Null Default Extra Unit Comments
fi_id mediumint(8) UNSIGNED No auto_increment ID
fi_code varchar(30) Yes NULL Code
fs_id mediumint(8) UNSIGNED Yes NULL Fields station ID
fi_name varchar(255) Yes NULL Name
fi_type varchar(255) Yes NULL Type
fi_res float Yes NULL Resolution
fi_units varchar(255) Yes NULL Units measured
fi_rate float Yes NULL Sampling rate
fi_filter varchar(255) Yes NULL Filter type
fi_orient varchar(255) Yes NULL Orientation
fi_calc varchar(255) Yes NULL Calculation
fi_stime datetime Yes NULL Start time
fi_stime_unc datetime Yes NULL Start time uncertainty
fi_etime datetime Yes NULL End time
fi_etime_unc datetime Yes NULL End time uncertainty
fi_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
fi_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
fi_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
fi_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY fi_id
CODE UNIQUE fi_code
cc_id
fi_stime

Links

Field Link to
fs_id fs.fs_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • fs_id.fs_stime ≤ fi_stime ≤ fs_id.fs_etime
  • fs_id.fs_stime ≤ fi_etime ≤ fs_id.fs_etime
  • fi_stime ≤ fi_etime

fs - Fields station

Description

This table stores information such as a location, conversion from local time to UTC, and a description of the stations where fields data are collected.

Field Type Attributes Null Default Extra Unit Comments
fs_id mediumint(8) UNSIGNED No auto_increment ID
fs_code varchar(30) Yes NULL Code
cn_id smallint(5) UNSIGNED Yes NULL Fields network ID
fs_name varchar(50) Yes NULL Name
fs_lat double Yes NULL ° Latitude
fs_lon double Yes NULL ° Longitude
fs_elev float Yes NULL m Elevation
fs_inst varchar(255) Yes NULL List of instruments
fs_utc float Yes NULL Difference from UTC
fs_stime datetime Yes NULL Start date
fs_stime_unc datetime Yes NULL Start date uncertainty
fs_etime datetime Yes NULL End date
fs_etime_unc datetime Yes NULL End date uncertainty
fs_desc varchar(255) Yes NULL Description
fs_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
fs_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
fs_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
fs_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY fs_id
CODE UNIQUE fs_code
cc_id
fs_stime

Links

Field Link to
cn_id cn.cn_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • fs_stime ≤ fs_etime
  • cn_id.cn_stime ≤ fs_stime ≤ cn_id.cn_etime
  • cn_id.cn_stime ≤ fs_etime ≤ cn_id.cn_etime

gd - Directly sampled gas

Description

This table stores gas data collected at ground sites. Data include the gas temperature, concentrations, and environmental factors.

Field Type Attributes Null Default Extra Unit Comments
gd_id mediumint(8) UNSIGNED No auto_increment ID
gd_code varchar(30) Yes NULL Code
gs_id smallint(5) UNSIGNED Yes NULL Gas station ID
gi_id smallint(5) UNSIGNED Yes NULL Gas instrument ID
gd_time datetime Yes NULL Sampling/Measurement time
gd_time_unc datetime Yes NULL Sampling/Measurement time uncertainty
gd_gtemp float Yes NULL °C Gas temperature
gd_bp float Yes NULL mbar Barometric pressure
gd_flow float Yes NULL Gas emission rate
gd_species enum('CO2', 'SO2', 'H2S', 'HCl', 'HF', 'CH4', 'H2', 'CO', '3He4He', 'd13C', 'd34S', 'd18O', 'dD') Yes NULL Species or ratio of gas reported
gd_waterfree_flag enum('Y', 'N') Yes NULL Water free gas: Y=Yes, N=No
gd_units varchar(30) Yes NULL Reported units
gd_concentration float Yes NULL Gas concentration
gd_concentration_err float Yes NULL Gas concentration uncertainty
gd_recalc enum('O', 'R') Yes NULL Recalculated value: O=Original, R=Recalculated
gd_envir varchar(255) Yes NULL Environmental factors
gd_submin varchar(255) Yes NULL Sublimate minerals
gd_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
gd_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
gd_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
gd_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY gd_id
CODE UNIQUE gd_code
cc_id

Links

Field Link to
gs_id gs.gs_id
gi_id gi.gi_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • gs_id.gs_stime ≤ gd_time ≤ gs_id.gs_etime
  • gi_id.gi_stime ≤ gd_time ≤ gi_id.gi_etime
  • gs_id = gi_id.gs_id

gd_plu - Plume

Description

This table stores gas data collected from a plume including the location of the vent, the height of the plume, and the gas emission rates.

Field Type Attributes Null Default Extra Unit Comments
gd_plu_id mediumint(8) UNSIGNED No auto_increment ID
gd_plu_code varchar(30) Yes NULL Code
vd_id smallint(8) UNSIGNED Yes NULL Volcano ID
cs_id smallint(5) UNSIGNED Yes NULL Satellite ID
gs_id smallint(5) UNSIGNED Yes NULL Gas station ID
gi_id smallint(5) UNSIGNED Yes NULL Gas instrument ID
gd_plu_lat double Yes NULL Latitude
gd_plu_lon double Yes NULL Longitude
gd_plu_height float Yes NULL km Height
gd_plu_hdet varchar(255) Yes NULL Height determination
gd_plu_time datetime Yes NULL Measurement time
gd_plu_time_unc datetime Yes NULL Measurement time uncertainty
gd_plu_species enum('CO2', 'SO2', 'H2S', 'HCl', 'HF', 'CO') Yes NULL Species of gas reported
gd_plu_units varchar(30) Yes NULL Reported units
gd_plu_emit float Yes NULL Emission rate
gd_plu_emit_err float Yes NULL Emission rate uncertainty
gd_plu_recalc enum('O', 'R') Yes NULL Recalculated value: O=Original, R=Recalculated
gd_plu_wind float Yes NULL m/s Wind speed
gd_plu_wsmin float Yes NULL m/s Minimum Wind speed
gd_plu_wsmax float Yes NULL m/s Maximum Wind speed
gd_plu_wdir varchar(30) Yes NULL Wind Direction
gd_plu_weth varchar(255) Yes NULL Weather notes
gd_plu_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
gd_plu_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
gd_plu_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
gd_plu_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY gd_plu_id
CODE UNIQUE gd_plu_code
cc_id

Links

Field Link to
vd_id vd.vd_id
cs_id cs.cs_id
gs_id gs.gs_id
gi_id gi.gi_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • gs_id.gs_stime ≤ gd_plu_time ≤ gs_id.gs_etime
  • gi_id.gi_stime ≤ gd_plu_time ≤ gi_id.gi_etime
  • gs_id = gi_id.gs_id
  • vd_id = gs_id.cn_id.vd_id OR jj_volnet.vd_id WHERE jj_volnet.jj_net_id=gs_id.cn_id AND jj_volnet.jj_net_flag=C

gd_sol - Soil efflux

Description

This table stores a daily total flux value for an individual gas species.

Field Type Attributes Null Default Extra Unit Comments
gd_sol_id mediumint(8) UNSIGNED No auto_increment ID
gd_sol_code varchar(30) Yes NULL Code
gs_id smallint(5) UNSIGNED Yes NULL Gas station ID
gi_id smallint(5) UNSIGNED Yes NULL Gas instrument ID
gd_sol_time datetime Yes NULL Measurement time
gd_sol_time_unc datetime Yes NULL Measurement time uncertainty
gd_sol_species varchar(30) Yes NULL Mesured species
gd_sol_tflux float Yes NULL t/d Total flux
gd_sol_flux_err float Yes NULL t/d Total flux uncertainty
gd_sol_pts smallint(5) Yes NULL Number of points
gd_sol_area float Yes NULL m2 Area
gd_sol_high float Yes NULL g/m2/d Highest individual flux
gd_sol_htemp float Yes NULL °C Highest temperature
gd_sol_units varchar(30) Yes NULL Reported Units
gd_sol_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
gd_sol_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Collector ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
gd_sol_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
gd_sol_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY gd_sol_id
CODE UNIQUE gd_sol_code
cc_id

Links

Field Link to
gs_id gs.gs_id
gi_id gi.gi_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • gs_id.gs_stime ≤ gd_sol_time ≤ gs_id.gs_etime
  • gi_id.gi_stime ≤ gd_sol_time ≤ gi_id.gi_etime
  • gs_id = gi_id.gs_id

gi - Gas instrument

Description

This table stores information about the instruments used to collect ground-based and remote gas data.

Field Type Attributes Null Default Extra Unit Comments
gi_id smallint(5) UNSIGNED No auto_increment ID
gi_code varchar(30) Yes NULL Code
cs_id smallint(5) UNSIGNED Yes NULL Satellite ID
gs_id smallint(5) UNSIGNED Yes NULL Gas station ID
gi_type varchar(255) Yes NULL Type
gi_name varchar(255) Yes NULL Name
gi_units varchar(50) Yes NULL Measured units
gi_pres float Yes NULL Resolution
gi_stn float Yes NULL Signal to noise
gi_calib varchar(255) Yes NULL Calibration
gi_stime datetime Yes NULL Start date
gi_stime_unc datetime Yes NULL Start date uncertainty
gi_etime datetime Yes NULL End date
gi_etime_unc datetime Yes NULL End date uncertainty
gi_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
gi_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
gi_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
gi_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type gield(s)
PRIMARY PRIMARY gi_id
CODE UNIQUE gi_code
cc_id
gi_stime

Links

Field Link to
cs_id cs.cs_id
gs_id gs.gs_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • gi_stime ≤ gi_etime
  • gs_id.gs_stime ≤ gi_stime ≤ gs_id.gs_etime
  • gs_id.gs_stime ≤ gi_etime ≤ gs_id.gs_etime
  • cs_id.cs_stime ≤ gi_stime ≤ cs_id.cs_etime
  • cs_id.cs_stime ≤ gi_etime ≤ cs_id.cs_etime

gs - Gas station

Description

This table stores information such as a location, type of gas body monitored, and a description of the stations where gas data are collected.

Field Type Attributes Null Default Extra Unit Comments
gs_id smallint(8) UNSIGNED No auto_increment ID
gs_code varchar(30) Yes NULL Code
gs_name varchar(50) Yes NULL Station Name
cn_id smallint(5) UNSIGNED Yes NULL Gas network ID
gs_lat double Yes NULL ° Latitude
gs_lon double Yes NULL ° Longitude
gs_elev float Yes NULL m Elevation
gs_inst varchar(255) Yes NULL List of permanent instruments
gs_type varchar(255) Yes NULL Type of gas body
gs_utc float Yes NULL Difference from UTC
gs_stime datetime Yes NULL Start date
gs_stime_unc datetime Yes NULL Start date uncertainty
gs_etime datetime Yes NULL End date
gs_etime_unc datetime Yes NULL End date uncertainty
gs_desc varchar(255) Yes NULL Description
gs_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
gs_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
gs_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
gs_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY gs_id
CODE UNIQUE gs_code
cc_id
gs_stime

Links

Field Link to
cn_id cn.cn_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • gs_stime ≤ gs_etime
  • cn_id.cn_stime ≤ gs_stime ≤ cn_id.cn_etime
  • cn_id.cn_stime ≤ gs_etime ≤ cn_id.cn_etime

hd - Hydrologic data

Description

This table stores all of the water data including temperature, water depth, and concentrations.

Field Type Attributes Null Default Extra Unit Comments
hd_id mediumint(8) UNSIGNED No auto_increment ID
hd_code varchar(30) Yes NULL Code
hs_id smallint(5) UNSIGNED Yes NULL Hydrologic station ID
hi_id smallint(5) UNSIGNED Yes NULL Hydrologic instrument ID
hd_time datetime Yes NULL Measurement time
hd_time_unc datetime Yes NULL Measurement time uncertainty
hd_temp float Yes NULL °C Water temperature
hd_welev double Yes NULL m Water elevation
hd_wdepth double Yes NULL m Water depth
hd_dwlev double Yes NULL m Change in water level
hd_bp float Yes NULL mbar Barometric pressure
hd_sdisc double Yes NULL L/s Water discharge rate
hd_prec float Yes NULL mm Precipitation
hd_dprec float Yes NULL Precipitation of preceding day
hd_tprec enum('R', 'FR', 'S', 'H', 'R-FR', 'R-S', 'R-H', 'FR-R', 'FR-S', 'FR-H', 'S-R', 'S-FR', 'S-H', 'H-R', 'H-FR', 'H-S') Yes NULL Type of precipitation: R=Rain, FR=Freezing Rain, S=Snow, H=Hail, and combinations
hd_ph float Yes NULL pH
hd_ph_err float Yes NULL pH standard error
hd_cond float Yes NULL μmhos/cm, μS/cm Conductivity
hd_cond_err float Yes NULL μmhos/cm, μS/cm Conductivity standard error
hd_comp_species enum('SO4', 'H2S', 'Cl', 'F', 'HCO3', 'Mg', 'Fe', 'Ca', 'Na', 'K', '3He4He', 'c3He4He', 'd13C', 'd34S', 'dD', 'd18O') Yes NULL Type of compound, kation, anion or ratio
hd_comp_units varchar(30) Yes NULL Reported units
hd_comp_content float Yes NULL Content of compound, kation, anion or ratio
hd_comp_content_err float Yes NULL Content of compound, kation, anion or ratio error
hd_atemp float Yes NULL Air temperature
hd_tds float Yes NULL Total disolved solid
hd_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
hd_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
hd_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
hd_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY hd_id
CODE UNIQUE hd_code
cc_id

Links

Field Link to
hs_id hs.hs_id
hi_id hi.hi_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • hs_id.hs_stime ≤ hd_time ≤ hs_id.hs_etime
  • hi_id.hi_stime ≤ hd_time ≤ hi_id.hi_etime
  • hs_id = hi_id.hs_id

hi - Hydrologic instrument

Description

This table stores information about each individual hydrologic instrument.

Field Type Attributes Null Default Extra Unit Comments
hi_id smallint(5) UNSIGNED No auto_increment ID
hi_code varchar(30) Yes NULL Code
hs_id smallint(5) UNSIGNED Yes NULL Hydrologic station ID
hi_name varchar(255) Yes NULL Name
hi_type varchar(50) Yes NULL Type
hi_meas enum('A', 'V') Yes NULL Pressure measurement type: A=Absolute, V=Vented
hi_units varchar(50) Yes NULL Measured units
hi_res float Yes NULL Resolution
hi_stime datetime Yes NULL Start date
hi_stime_unc datetime Yes NULL Start date uncertainty
hi_etime datetime Yes NULL End date
hi_etime_unc datetime Yes NULL End date uncertainty
hi_desc varchar(255) Yes NULL Description
hi_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
hi_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
hi_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
hi_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type hield(s)
PRIMARY PRIMARY hi_id
CODE UNIQUE hi_code
cc_id
hi_stime

Links

Field Link to
hs_id hs.hs_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • hi_stime ≤ hi_etime
  • hs_id.hs_stime ≤ hi_stime ≤ hs_id.hs_etime
  • hs_id.hs_stime ≤ hi_etime ≤ hs_id.hs_etime

hs - Hydrologic station

Description

This table stores information such as location, type of water body, and descriptions for stations where hydrologic data are collected.

Field Type Attributes Null Default Extra Unit Comments
hs_id smallint(5) UNSIGNED No auto_increment ID
hs_code varchar(30) Yes NULL Code
cn_id smallint(5) UNSIGNED Yes NULL Hydrologic network ID
hs_lat double Yes NULL ° Latitude
hs_lon double Yes NULL ° Longitude
hs_elev float Yes NULL m Elevation
hs_perm varchar(255) Yes NULL List of permanent instruments
hs_name varchar(30) Yes NULL Station name
hs_type varchar(255) Yes NULL Type of water body
hs_utc float Yes NULL Difference from UTC
hs_tscr float Yes NULL m Top of screen
hs_bscr float Yes NULL m Bottom of screen
hs_tdepth double Yes NULL m Total depth of well
hs_stime datetime Yes NULL Start date
hs_stime_unc datetime Yes NULL Start date uncertainty
hs_etime datetime Yes NULL End date
hs_etime_unc datetime Yes NULL End date uncertainty
hs_desc varchar(255) Yes NULL Description
hs_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
hs_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
hs_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
hs_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY hs_id
CODE UNIQUE hs_code
cc_id
hs_stime

Links

Field Link to
cn_id cn.cn_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • hs_stime ≤ hs_etime
  • cn_id.cn_stime ≤ hs_stime ≤ cn_id.cn_etime
  • cn_id.cn_stime ≤ hs_etime ≤ cn_id.cn_etime

ip_hyd - Hydrothermal system interaction

Description

This table stores information about magmatic interactions with the hydrothermal system.

Field Type Attributes Null Default Extra Unit Comments
ip_hyd_id smallint(5) UNSIGNED No auto_increment ID
ip_hyd_code varchar(30) Yes NULL Code
vd_id mediumint(8) UNSIGNED Yes NULL Volcano Identifier
ip_hyd_time datetime Yes NULL Inference time
ip_hyd_time_unc datetime Yes NULL Inference time uncertainty
ip_hyd_start datetime Yes NULL Start time
ip_hyd_start_unc datetime Yes NULL Start time uncertainty
ip_hyd_end datetime Yes NULL End time
ip_hyd_end_unc datetime Yes NULL End time uncertainty
ip_hyd_gwater enum('Y', 'N', 'M', 'U') Yes NULL Heated groundwater: Y=Yes, N=No, M=Maybe, U=Unknown
ip_hyd_ipor enum('Y', 'N', 'M', 'U') Yes NULL Pore destabilization: Y=Yes, N=No, M=Maybe, U=Unknown
ip_hyd_edef enum('Y', 'N', 'M', 'U') Yes NULL Pore deformation: Y=Yes, N=No, M=Maybe, U=Unknown
ip_hyd_hfrac enum('Y', 'N', 'M', 'U') Yes NULL Hydrofracturing: Y=Yes, N=No, M=Maybe, U=Unknown
ip_hyd_btrem enum('Y', 'N', 'M', 'U') Yes NULL Boiling induced tremor: Y=Yes, N=No, M=Maybe, U=Unknown
ip_hyd_abgas enum('Y', 'N', 'M', 'U') Yes NULL Absorption of soluble gases: Y=Yes, N=No, M=Maybe, U=Unknown
ip_hyd_species enum('Y', 'N', 'M', 'U') Yes NULL Change in equilibrium species: Y=Yes, N=No, M=Maybe, U=Unknown
ip_hyd_chim enum('Y', 'N', 'M', 'U') Yes NULL Boiling until dry chimneys are formed: Y=Yes, N=No, M=Maybe, U=Unknown
ip_hyd_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
ip_hyd_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
ip_hyd_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
ip_hyd_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY ip_hyd_id
CODE UNIQUE ip_hyd_code
cc_id

Links

Field Link to
vd_id vd.vd_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • ip_hyd_start ≤ ip_hyd_end
  • ip_hyd_start ≤ ip_hyd_time

ip_mag - Magma movement

Description

This table stores information about processes related to the movement of magma.

Field Type Attributes Null Default Extra Unit Comments
ip_mag_id smallint(5) UNSIGNED No auto_increment ID
ip_mag_code varchar(30) Yes NULL Code
vd_id mediumint(8) UNSIGNED Yes NULL Volcano Identifier
ip_mag_time datetime Yes NULL Inference time
ip_mag_time_unc datetime Yes NULL Inference time uncertainty
ip_mag_start datetime Yes NULL Start time
ip_mag_start_unc datetime Yes NULL Start time uncertainty
ip_mag_end datetime Yes NULL End time
ip_mag_end_unc datetime Yes NULL End time uncertainty
ip_mag_deepsupp enum('Y', 'N', 'M', 'U') Yes NULL Supply of magma from depth: Y=Yes, N=No, M=Maybe, U=Unknown
ip_mag_asc enum('Y', 'N', 'M', 'U') Yes NULL Ascent: Y=Yes, N=No, M=Maybe, U=Unknown
ip_mag_convb enum('Y', 'N', 'M', 'U') Yes NULL Convection below: Y=Yes, N=No, M=Maybe, U=Unknown
ip_mag_conva enum('Y', 'N', 'M', 'U') Yes NULL Convection above: Y=Yes, N=No, M=Maybe, U=Unknown
ip_mag_mix enum('Y', 'N', 'M', 'U') Yes NULL Magma mixing: Y=Yes, N=No, M=Maybe, U=Unknown
ip_mag_dike enum('Y', 'N', 'M', 'U') Yes NULL Dike intrusion: Y=Yes, N=No, M=Maybe, U=Unknown
ip_mag_pipe enum('Y', 'N', 'M', 'U') Yes NULL Pipe intrusion: Y=Yes, N=No, M=Maybe, U=Unknown
ip_mag_sill enum('Y', 'N', 'M', 'U') Yes NULL Sill intrusion: Y=Yes, N=No, M=Maybe, U=Unknown
ip_mag_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
ip_mag_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
ip_mag_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
ip_mag_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY ip_mag_id
CODE UNIQUE ip_mag_code
cc_id

Links

Field Link to
vd_id vd.vd_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • ip_mag_start ≤ ip_mag_end
  • ip_mag_start ≤ ip_mag_time

ip_pres - Buildup of magma pressure

Description

This table stores information about processes related to an increase in magmatic pressure.

Field Type Attributes Null Default Extra Unit Comments
ip_pres_id smallint(5) UNSIGNED No auto_increment ID
ip_pres_code varchar(30) Yes NULL Code
vd_id mediumint(8) UNSIGNED Yes NULL Volcano Identifier
ip_pres_time datetime Yes NULL Inference time
ip_pres_time_unc datetime Yes NULL Inference time uncertainty
ip_pres_start datetime Yes NULL Start time
ip_pres_start_unc datetime Yes NULL Start time uncertainty
ip_pres_end datetime Yes NULL End time
ip_pres_end_unc datetime Yes NULL End time uncertainty
ip_pres_gas enum('Y', 'N', 'M', 'U') Yes NULL Gas-induced overpressure: Y=Yes, N=No, M=Maybe, U=Unknown
ip_pres_tec enum('Y', 'N', 'M', 'U') Yes NULL Tectonic overpressure: Y=Yes, N=No, M=Maybe, U=Unknown
ip_pres_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
ip_pres_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
ip_pres_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
ip_pres_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY ip_pres_id
CODE UNIQUE ip_pres_code
cc_id

Links

Field Link to
vd_id vd.vd_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • ip_pres_start ≤ ip_pres_end
  • ip_pres_start ≤ ip_pres_time

ip_sat - Volatile saturation

Description

This table stores information about processes related to volatiles in the magma.

Field Type Attributes Null Default Extra Unit Comments
ip_sat_id smallint(5) UNSIGNED No auto_increment ID
ip_sat_code varchar(30) Yes NULL Code
vd_id mediumint(8) UNSIGNED Yes NULL Volcano Identifier
ip_sat_time datetime Yes NULL Inference time
ip_sat_time_unc datetime Yes NULL Inference time uncertainty
ip_sat_start datetime Yes NULL Start time
ip_sat_start_unc datetime Yes NULL Start time uncertainty
ip_sat_end datetime Yes NULL End time
ip_sat_end_unc datetime Yes NULL End time uncertainty
ip_sat_co2 enum('Y', 'N', 'M', 'U') Yes NULL CO2 saturation: Y=Yes, N=No, M=Maybe, U=Unknown
ip_sat_h2o enum('Y', 'N', 'M', 'U') Yes NULL H2O saturation: Y=Yes, N=No, M=Maybe, U=Unknown
ip_sat_decomp enum('Y', 'N', 'M', 'U') Yes NULL Decompression: Y=Yes, N=No, M=Maybe, U=Unknown
ip_sat_dfo2 enum('Y', 'N', 'M', 'U') Yes NULL Fugacity: Y=Yes, N=No, M=Maybe, U=Unknown
ip_sat_add enum('Y', 'N', 'M', 'U') Yes NULL Volatile addition: Y=Yes, N=No, M=Maybe, U=Unknown
ip_sat_xtl enum('Y', 'N', 'M', 'U') Yes NULL Crystallization or 2nd boiling: Y=Yes, N=No, M=Maybe, U=Unknown
ip_sat_ves enum('Y', 'N', 'M', 'U') Yes NULL Vesiculation: Y=Yes, N=No, M=Maybe, U=Unknown
ip_sat_deves enum('Y', 'N', 'M', 'U') Yes NULL Devesiculation: Y=Yes, N=No, M=Maybe, U=Unknown
ip_sat_degas enum('Y', 'N', 'M', 'U') Yes NULL Degassing: Y=Yes, N=No, M=Maybe, U=Unknown
ip_sat_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
ip_sat_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
ip_sat_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
ip_sat_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY ip_sat_id
CODE UNIQUE ip_sat_code
cc_id

Links

Field Link to
vd_id vd.vd_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • ip_sat_start ≤ ip_sat_end
  • ip_sat_start ≤ ip_sat_time

ip_tec - Regional tectonics interaction

Description

This table stores information about processes related to regional tectonic events.

Field Type Attributes Null Default Extra Unit Comments
ip_tec_id smallint(5) UNSIGNED No auto_increment ID
ip_tec_code varchar(30) Yes NULL Code
vd_id mediumint(8) UNSIGNED Yes NULL Volcano Identifier
ip_tec_time datetime Yes NULL Inference time
ip_tec_time_unc datetime Yes NULL Inference time uncertainty
ip_tec_start datetime Yes NULL Start time
ip_tec_start_unc datetime Yes NULL Start time uncertainty
ip_tec_end datetime Yes NULL End time
ip_tec_end_unc datetime Yes NULL End time uncertainty
ip_tec_change enum('Y', 'N', 'M', 'U') Yes NULL Tectonic changes: Y=Yes, N=No, M=Maybe, U=Unknown
ip_tec_sstress enum('Y', 'N', 'M', 'U') Yes NULL Static stress: Y=Yes, N=No, M=Maybe, U=Unknown
ip_tec_dstrain enum('Y', 'N', 'M', 'U') Yes NULL Dynamic strain: Y=Yes, N=No, M=Maybe, U=Unknown
ip_tec_fault enum('Y', 'N', 'M', 'U') Yes NULL Local shear: Y=Yes, N=No, M=Maybe, U=Unknown
ip_tec_seq enum('Y', 'N', 'M', 'U') Yes NULL Slow earthquake: Y=Yes, N=No, M=Maybe, U=Unknown
ip_tec_press enum('Y', 'N', 'M', 'U') Yes NULL Distal pressurization: Y=Yes, N=No, M=Maybe, U=Unknown
ip_tec_depress enum('Y', 'N', 'M', 'U') Yes NULL Distal depressurization: Y=Yes, N=No, M=Maybe, U=Unknown
ip_tec_hppress enum('Y', 'N', 'M', 'U') Yes NULL Hydrothermal lubrication: Y=Yes, N=No, M=Maybe, U=Unknown
ip_tec_etide enum('Y', 'N', 'M', 'U') Yes NULL Earth-tide: Y=Yes, N=No, M=Maybe, U=Unknown
ip_tec_atmp enum('Y', 'N', 'M', 'U') Yes NULL Atmospheric influence: Y=Yes, N=No, M=Maybe, U=Unknown
ip_tec_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
ip_tec_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
ip_tec_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
ip_tec_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY ip_tec_id
CODE UNIQUE ip_tec_code
cc_id

Links

Field Link to
vd_id vd.vd_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • ip_tec_start ≤ ip_tec_end
  • ip_tec_start ≤ ip_tec_time

jj_concon - User to user permissions

Description

This table stores information about the permissions (upload, update, view their data or manage their account) given by a user to another.

Field Type Attributes Null Default Extra Unit Comments
jj_concon_id mediumint(8) UNSIGNED No auto_increment ID
cc_id smallint(5) UNSIGNED Yes NULL Granting user ID
cc_id_granted smallint(5) UNSIGNED Yes NULL Granted user ID
jj_concon_view tinyint(1) No 0 Permission to view unpublished data: 0=No, 1=Yes
jj_concon_upload tinyint(1) No 0 Permission to upload data: 0=No, 1=Yes
jj_concon_update tinyint(1) No 0 Permission to update data: 0=No, 1=Yes
jj_concon_admin tinyint(1) No 0 Permission to manage account: 0=No, 1=Yes
jj_concon_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY jj_concon_id
GRANT UNIQUE cc_id
cc_id_granted

Links

Field Link to
cc_id cc.cc_id
cc_id_granted cc.cc_id
cc_id_load cc.cc_id

Restrictions

None

jj_imgx - Image junction

Description

This table was created to link images to other known data.

Field Type Attributes Null Default Extra Unit Comments
jj_imgx_id smallint(5) UNSIGNED No auto_increment ID
cm_id smallint(5) UNSIGNED No Image ID
jj_idname enum('cb','cc','ch','cm','cn','co','cp','cr','cr_tmp','cs','cu','dd_ang','dd_edm','dd_gps','dd_gpv','dd_lev','dd_sar','dd_srd','dd_str','dd_tlt','dd_tlv','di_gen','di_tlt','ds','ed','ed_for','ed_phs','ed_vid','fd_ele','fd_gra','fd_mag','fd_mgv','fi','fs','gd','gd_plu','gd_sol','gi','gs','hd','hi','hs','ip_hyd','ip_mag','ip_pres','ip_sat','ip_tec','jj_concon','jj_imgx','jj_volcon','jj_volnet','j_sarsat','md','med','mi','ms','sd_evn','sd_evs','sd_int','sd_ivl','sd_rsm','sd_sam','sd_ssm','sd_trm','sd_wav','si','si_cmp','sn','ss','st_eqt','td','td_img','td_pix','ti','ts','vd','vd_inf','vd_mag','vd_tec') UNSIGNED Yes NULL Table name
jj_x_id mediumint(8) UNSIGNED Yes NULL Data ID
jj_imgx_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY jj_imgx_id
LINK UNIQUE cm_id
jj_idname
jj_x_id

Links

Field Link to
cm_id cm.cm_id
jj_x_id jj_idname.jj_idname_id
cc_id_load cc.cc_id

Restrictions

None

jj_volcon - Volcano-contact junction

Description

This table was created for the many-to-many relationship between the volcano and the observatories that monitor the volcano.

Field Type Attributes Null Default Extra Unit Comments
jj_volcon_id smallint(5) UNSIGNED No auto_increment ID
vd_id mediumint(8) UNSIGNED Yes NULL Volcano Identifier
cc_id smallint(5) UNSIGNED No Contact ID
jj_volcon_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY jj_volcon_id
LINK UNIQUE vd_id
cc_id

Links

Field Link to
vd_id vd.vd_id
cc_id cc.cc_id
cc_id_load cc.cc_id

Restrictions

None

jj_volnet - Volcano-network junction

Description

This table was created for the many-to-many relationship between the volcano and the observatories that monitor the volcano.

Field Type Attributes Null Default Extra Unit Comments
jj_volnet_id smallint(5) UNSIGNED No auto_increment ID
vd_id mediumint(8) UNSIGNED Yes NULL Volcano Identifier
jj_net_id smallint(5) UNSIGNED Yes NULL Network ID
jj_net_flag enum('C', 'S') UNSIGNED Yes NULL Network type: C=Common, S=Seismic
jj_volnet_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY jj_volnet_id
LINK UNIQUE vd_id
jj_net_id
jj_net_flag

Links

Field Link to
vd_id vd.vd_id
jj_net_id jj_net_flagn.jj_net_flagn_id
cc_id_load cc.cc_id

Restrictions

None

j_sarsat - InSAR-satellite junction

Description

This table was created for the many-to-many relationship between the satellite data and the InSAR data.

Field Type Attributes Null Default Extra Unit Comments
j_sarsat_id smallint(5) UNSIGNED No auto_increment ID
dd_sar_id mediumint(8) UNSIGNED Yes NULL InSAR image ID
cs_id smallint(5) UNSIGNED Yes NULL Satellite ID
j_sarsat_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY j_sarsat_id
LINK UNIQUE dd_sar_id
cs_id

Links

Field Link to
dd_sar_id dd_sar.dd_sar_id
cs_id cs.cs_id
cc_id_load cc.cc_id

Restrictions

None

md - Map

Description

This table stores information about maps that cover areas where WOVOdat data is collected.

Field Type Attributes Null Default Extra Unit Comments
md_id smallint(5) UNSIGNED No auto_increment ID
md_code varchar(30) Yes NULL Code
vd_id mediumint(8) UNSIGNED Yes NULL Volcano Identifier
md_name varchar(255) Yes NULL Name
md_type varchar(30) Yes NULL Type
md_srtm varchar(255) Yes NULL Link to SRTM
md_scale varchar(30) Yes NULL Scale
md_contour float Yes NULL m Contour interval
md_date date Yes NULL Publication date
md_date_unc date Yes NULL Publication date uncertainty
md_proj varchar(255) Yes NULL Projection
md_map_datum varchar(255) Yes NULL Datum
md_west float Yes NULL ° West bounding coordinate
md_east float Yes NULL ° East bounding coordinate
md_north float Yes NULL ° North bounding coordinate
md_south float Yes NULL ° South bounding coordinate
md_elev_max float Yes NULL m Maximum elevation
md_elev_min float Yes NULL m Minimum elevation
md_use varchar(255) Yes NULL Intended use
md_restrictions varchar(255) Yes NULL Restrictions on the use
md_quality varchar(255) Yes NULL Quality
md_image varchar(255) Yes NULL Link to image
md_desc varchar(255) Yes NULL Description
md_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
md_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
md_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
md_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY md_id
CODE UNIQUE md_code
cc_id

Links

Field Link to
vd_id vd.vd_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • md_elev_min ≤ md_elev_max

med - Meteo data

Description

This table stores all of the meteo data including temperature, wind speed, and Cloud coverage.

Field Type Attributes Null Default Extra Unit Comments
med_id mediumint(8) UNSIGNED No auto_increment ID
med_code varchar(30) Yes NULL Code
ms_id smallint(5) UNSIGNED Yes NULL Meteo station ID
mi_id smallint(5) UNSIGNED Yes NULL Meteo instrument ID
med_time datetime Yes NULL Measurement time
med_time_unc datetime Yes NULL Measurement time uncertainty
med_temp float Yes NULL Air temperature
med_stemp float Yes NULL Soil temperature
med_bp float Yes NULL Barometric pressure at the time of measurement
med_prec float Yes NULL m Measured precipitation (daily)
med_tprec enum('R','FR','S','H','R-FR','R-S','R-H','FR-R','FR-S','FR-H','S-R','S-FR','S-H','H-R','H-FR','H-S') Yes NULL Type of precipitation: R=Rain, FR=Freezing Rain, S=Snow, H=Hail, and combinations
med_hd float Yes NULL Humidity
med_wind float Yes NULL Wind speed
med_wsmin float Yes NULL Minimum Wind speed
med_wsmax float Yes NULL Maximum Wind speed
med_wdir varchar(30) Yes NULL Wind direction
med_clc float Yes NULL Cloud coverage
med_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
med_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
med_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
med_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY med_id
CODE UNIQUE med_code
cc_id

Links

Field Link to
ms_id ms.ms_id
mi_id mi.mi_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • ms_id.ms_stime ≤ med_time ≤ ms_id.ms_etime
  • mi_id.mi_stime ≤ med_time ≤ mi_id.mi_etime
  • ms_id = mi_id.ms_id

mi - Meteo instrument

Description

This table stores information about each individual meteo instrument.

Field Type Attributes Null Default Extra Unit Comments
mi_id smallint(5) UNSIGNED No auto_increment ID
mi_code varchar(30) Yes NULL Code
ms_id smallint(5) UNSIGNED Yes NULL Meteo station ID
mi_name varchar(255) Yes NULL Name
mi_type varchar(50) Yes NULL Type
mi_units varchar(50) Yes NULL Measured units
mi_res float Yes NULL Resolution
mi_stime datetime Yes NULL Start date
mi_stime_unc datetime Yes NULL Start date uncertainty
mi_etime datetime Yes NULL End date
mi_etime_unc datetime Yes NULL End date uncertainty
mi_desc varchar(255) Yes NULL Description
mi_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
mi_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
mi_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
mi_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type hield(s)
PRIMARY PRIMARY mi_id
CODE UNIQUE mi_code
cc_id
mi_stime

Links

Field Link to
ms_id ms.ms_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • mi_stime ≤ mi_etime
  • ms_id.ms_stime ≤ mi_stime ≤ ms_id.ms_etime
  • ms_id.ms_stime ≤ mi_etime ≤ ms_id.ms_etime

ms - Meteo station

Description

This table stores information such as location, name, and descriptions for stations where meteo data are collected.

Field Type Attributes Null Default Extra Unit Comments
ms_id smallint(5) UNSIGNED No auto_increment ID
ms_code varchar(30) Yes NULL Code
cn_id smallint(5) UNSIGNED Yes NULL Meteo network ID
ms_name varchar(30) Yes NULL Station Name
ms_lat double Yes NULL ° Latitude
ms_lon double Yes NULL ° Longitude
ms_elev float Yes NULL m Elevation
ms_perm varchar(255) Yes NULL List of permanent instruments
ms_type varchar(255) Yes NULL Type
ms_stime datetime Yes NULL Start date
ms_stime_unc datetime Yes NULL Start date uncertainty
ms_etime datetime Yes NULL End date
ms_etime_unc datetime Yes NULL End date uncertainty
ms_utc float Yes NULL Difference from UTC
ms_desc varchar(255) Yes NULL Description
ms_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
ms_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
ms_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
ms_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY ms_id
CODE UNIQUE ms_code
cc_id
ms_stime

Links

Field Link to
cn_id cn.cn_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • ms_stime ≤ ms_etime
  • cn_id.cn_stime ≤ ms_stime ≤ cn_id.cn_etime
  • cn_id.cn_stime ≤ ms_etime ≤ cn_id.cn_etime

sd_evn - Seismic event data from a network

Description

This table contains seismic data that were collected from several stations in a network and then processed to give a location.

Field Type Attributes Null Default Extra Unit Comments
sd_evn_id mediumint(8) UNSIGNED No auto_increment ID
sd_evn_code varchar(30) Yes NULL Code
sn_id smallint(5) UNSIGNED Yes NULL Seismic network ID
sd_evn_arch varchar(255) Yes NULL Location of the seismogram archive
sd_evn_time datetime Yes NULL Origin time
sd_evn_timecsec decimal(2,2) Yes NULL Centisecond precision for origin time
sd_evn_time_unc datetime Yes NULL Origin time uncertainty
sd_evn_timecsec_unc decimal(2,2) Yes NULL Centisecond precision for origin time uncertainty
sd_evn_dur float Yes NULL s Average duration of the earthquake as recorded at stations <15 km from the volcano
sd_evn_dur_unc float Yes NULL s Uncertainty in average duration of the earthquake
sd_evn_tech varchar(255) Yes NULL The technique used to locate the event
sd_evn_picks enum('A', 'R', 'H', 'U') Yes NULL Determination of picks: A=Automatic picker, R=Ruler, H=Human using a computer-based picker, U=Unknown
sd_evn_elat double Yes NULL ° Estimated latitude
sd_evn_elon double Yes NULL ° Estimated longitude
sd_evn_edepth float Yes NULL km Estimated depth
sd_evn_fixdep enum('Y', 'N', 'U') Yes NULL Fixed depth: Y=Yes, N=No, U=Unknown
sd_evn_nst tinyint(3) UNSIGNED Yes NULL The total number of seismic stations that reported arrival times for this earthquake
sd_evn_nph tinyint(3) UNSIGNED Yes NULL The total number of P and S arrival-time observations used to compute the hypocenter location
sd_evn_gp float Yes NULL ° The largest azimuthal gap between azimuthally adjacent stations
sd_evn_dcs float Yes NULL km Horizontal distance from the epicenter to the nearest station
sd_evn_rms float Yes NULL s RMS travel time residual
sd_evn_herr float Yes NULL km The horizontal location error defined as the length of the largest projection of the three principal errors on a horizontal plane
sd_evn_xerr float Yes NULL km The maximum x (longitude) error for cases where the horizontal error is not given
sd_evn_yerr float Yes NULL km The maximum y (latitude) error for cases where the horizontal error is not given
sd_evn_derr float Yes NULL km The depth error defined as the largest projection of the three principal errors on a vertical line
sd_evn_locqual varchar(255) Yes NULL The quality of the calculated location
sd_evn_pmag float Yes NULL The primary magnitude
sd_evn_pmag_type varchar(30) Yes NULL The primary magnitude type, e.g., Ms, Mb, Mw, Md (the last, duration or "coda" magnitude)
sd_evn_smag float Yes NULL A secondary magnitude
sd_evn_smag_type varchar(30) Yes NULL Secondary magnitude type
sd_evn_eqtype enum('R','Q','V','VT','VT_D','VT_S','H','H_HLF','H_LHF','LF','LF_LP','LF_T','LF_ILF','VLP','E','U','O','X') Yes NULL The WOVOdat terminology for the earthquake type: U=Unknown Origin, O=Other non-volcanic, X=Undefined
sd_evn_mtscale float Yes NULL The scale of the following moment tensor data. Please store as a multiplier for the moment tensor data
sd_evn_mxx float Yes NULL Moment tensor m_xx stored as +/- x.xx
sd_evn_mxy float Yes NULL Moment tensor m_xy stored as +/- x.xx
sd_evn_mxz float Yes NULL Moment tensor m_xz stored as +/- x.xx
sd_evn_myy float Yes NULL Moment tensor m_yy
sd_evn_myz float Yes NULL Moment tensor m_yz
sd_evn_mzz float Yes NULL Moment tensor m_zz
sd_evn_strk1 float Yes NULL ° Strike 1 of best double couple
sd_evn_strk1_err float Yes NULL ° The uncertainty in the value of strike 1
sd_evn_dip1 float Yes NULL ° Dip 1 of best double couple
sd_evn_dip1_err float Yes NULL ° The uncertainty in the value of dip 1
sd_evn_rak1 float Yes NULL ° Rake 1 of best double couple
sd_evn_rak1_err float Yes NULL ° The uncertainty in the value of rake 1
sd_evn_strk2 float Yes NULL ° Strike 2 of best double couple
sd_evn_strk2_err float Yes NULL ° The uncertainty in the value of strike 2
sd_evn_dip2 float Yes NULL ° Dip 2 of best double couple
sd_evn_dip2_err float Yes NULL ° The uncertainty in the value of dip 2
sd_evn_rak2 float Yes NULL ° Rake 2 of best double couple
sd_evn_rak2_err float Yes NULL ° The uncertainty in the value of rake 2
sd_evn_foc varchar(255) Yes NULL The focal plane solution (beachball, w/ arrivals) stored as a .gif for well defined events
sd_evn_samp float Yes NULL Hz The sampling rate
sd_evn_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
sd_evn_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Collector ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
sd_evn_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
sd_evn_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY sd_evn_id
CODE UNIQUE sd_evn_code
cc_id
sn_id
sd_evn_tech

Links

Field Link to
sn_id sn.sn_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • sn_id.sn_stime ≤ sd_evn_time ≤ sn_id.sn_etime
  • 0 ≤ sd_evn_gp ≤ 360
  • 0 ≤ sd_evn_strk1 ≤ 360
  • 0 ≤ sd_evn_dip1 ≤ 90
  • 0 ≤ sd_evn_rak1 ≤ 90

sd_evs - Seismic event data from a single station

Description

This table contains seismic data that were collected from a single station and therefore no location can be calculated.

Field Type Attributes Null Default Extra Unit Comments
sd_evs_id mediumint(8) UNSIGNED No auto_increment ID
sd_evs_code varchar(30) Yes NULL Code
ss_id mediumint(8) UNSIGNED Yes NULL Seismic station ID
sd_evs_time datetime Yes NULL Start time
sd_evs_time_ms decimal(2,2) Yes NULL Centisecond precision for start time
sd_evs_time_unc datetime Yes NULL Start time uncertainty
sd_evs_time_unc_ms decimal(2,2) Yes NULL Centisecond precision for start time uncertainty
sd_evs_picks enum('A', 'R', 'H', 'U') Yes NULL Determination of picks: A=Automatic picker, R=Ruler, H=Human using a computer-based picker, U=Unknown
sd_evs_spint float Yes NULL s S-P interval
sd_evs_dur float Yes NULL s Duration
sd_evs_dur_unc float Yes NULL s Duration uncertainty
sd_evs_dist_actven float Yes NULL km Distance from active vent
sd_evs_maxamptrac float Yes NULL Maximum amplitude of trace
sd_evs_samp float Yes NULL Hz Sampling rate
sd_evs_eqtype enum('R','Q','V','VT','VT_D','VT_S','H','H_HLF','H_LHF','LF','LF_LP','LF_T','LF_ILF','VLP','E','U','O','X') Yes NULL The WOVOdat terminology for the earthquake type: U=Unknown Origin, O=Other non-volcanic, X=Undefined
sd_evs_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
sd_evs_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
sd_evs_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
sd_evs_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY sd_evs_id
CODE UNIQUE sd_evs_code
cc_id

Links

Field Link to
ss_id ss.ss_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • ss_id.ss_stime ≤ sd_evs_time ≤ ss_id.ss_etime

sd_int - Intensity

Description

This table was created to store information about the intensities of events that may or may not have been recorded by a station.

Field Type Attributes Null Default Extra Unit Comments
sd_int_id mediumint(8) UNSIGNED No auto_increment ID
sd_int_code varchar(30) Yes NULL Code
vd_id mediumint(8) UNSIGNED Yes NULL Volcano Identifier
sd_evn_id mediumint(8) UNSIGNED Yes NULL Probable network event ID
sd_evs_id mediumint(8) UNSIGNED Yes NULL Probable single station event ID
sd_int_time datetime Yes NULL Time
sd_int_time_unc datetime Yes NULL Time uncertainty
sd_int_city varchar(30) Yes NULL City
sd_int_maxdist float Yes NULL km Maximum distance felt
sd_int_maxrint float Yes NULL Maximum reported intensity
sd_int_maxrint_dist float Yes NULL km Distance at maximum reported intensity
sd_int_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
sd_int_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
sd_int_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
sd_int_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY sd_int_id
CODE UNIQUE sd_int_code
cc_id

Links

Field Link to
vd_id vd.vd_id
sd_evn_id sd_evn.sd_evn_id
sd_evs_id sd_evs.sd_evs_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

None

sd_ivl - Interval (swarm)

Description

This table contains data about earthquakes that occur in specified time intervals, e.g., as seismic swarms.

Field Type Attributes Null Default Extra Unit Comments
sd_ivl_id mediumint(8) UNSIGNED No auto_increment ID
sd_ivl_code varchar(30) Yes NULL Code
sn_id smallint(5) UNSIGNED Yes NULL Seismic network ID
ss_id mediumint(8) UNSIGNED Yes NULL Seismic station ID
sd_ivl_eqtype enum('R','Q','V','VT','VT_D','VT_S','H','H_HLF','H_LHF','LF','LF_LP','LF_T','LF_ILF','VLP','E','U','O','X') Yes NULL The WOVOdat terminology for the earthquake type: U=Unknown Origin, O=Other non-volcanic, X=Undefined
sd_ivl_stime datetime Yes NULL Start time
sd_ivl_stime_unc datetime Yes NULL Start time uncertainty
sd_ivl_etime datetime Yes NULL End time
sd_ivl_etime_unc datetime Yes NULL End time uncertainty
sd_ivl_hdist float Yes NULL km Horizontal distance from summit to swarm center
sd_ivl_avgdepth float Yes NULL m Mean depth
sd_ivl_vdispers float Yes NULL km Vertical dispersion
sd_ivl_hmigr_hyp float Yes NULL km Horizontal migration of hypocenters
sd_ivl_vmigr_hyp float Yes NULL km Vertical migration of hypocenters
sd_ivl_patt varchar(30) Yes NULL Temporal pattern
sd_ivl_data enum('L', 'C', 'H', 'U') Yes NULL Data type: L=Located earthquakes, C=Detected by computer trigger algorithm, H=Hand counted, U=Unknown
sd_ivl_picks enum('A', 'R', 'H', 'U') Yes NULL Determination of picks: A=Automatic picker, R=Ruler, H=Human using a computer-based picker, U=Unknown
sd_ivl_felt_stime datetime Yes NULL Earthquake counts felt start time
sd_ivl_felt_stime_unc datetime Yes NULL Earthquake counts felt start time uncertainty
sd_ivl_felt_etime datetime Yes NULL Earthquake counts felt end time
sd_ivl_felt_etime_unc datetime Yes NULL Earthquake counts felt end time uncertainty
sd_ivl_nrec mediumint(6) UNSIGNED Yes NULL Number of recorded earthquakes
sd_ivl_nfelt smallint(4) UNSIGNED Yes NULL Number of felt earthquakes
sd_ivl_etot_stime datetime Yes NULL Total seismic energy release measurement start time
sd_ivl_etot_stime_unc datetime Yes NULL Total seismic energy release measurement start time uncertainty
sd_ivl_etot_etime datetime Yes NULL Total seismic energy release measurement end time
sd_ivl_etot_etime_unc datetime Yes NULL Total seismic energy release measurement end time uncertainty
sd_ivl_etot float Yes NULL erg-0.5 Total seismic energy release
sd_ivl_fmin float Yes NULL Minimum frequency
sd_ivl_fmax float Yes NULL Maximum frequency
sd_ivl_amin float Yes NULL Minimum amplitude
sd_ivl_amax float Yes NULL Maximum amplitude
sd_ivl_desc varchar(255) Yes NULL Description
sd_ivl_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
sd_ivl_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
sd_ivl_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
sd_ivl_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY sd_ivl_id
CODE UNIQUE sd_ivl_code
cc_id

Links

Field Link to
sn_id sn.sn_id
ss_id ss.ss_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • sd_ivl_stime ≤ sd_ivl_etime
  • sd_ivl_felt_stime ≤ sd_ivl_felt_etime
  • sd_ivl_etot_stime ≤ sd_ivl_etot_etime
  • sn_id.sn_stime ≤ sd_ivl_stime ≤ sn_id.sn_etime
  • sn_id.sn_stime ≤ sd_ivl_etime ≤ sn_id.sn_etime
  • ss_id.ss_stime ≤ sd_ivl_stime ≤ ss_id.ss_etime
  • ss_id.ss_stime ≤ sd_ivl_etime ≤ ss_id.ss_etime

sd_rsm - RSAM data

Description

This table stores the data needed to create an RSAM image.

Field Type Attributes Null Default Extra Unit Comments
sd_rsm_id mediumint(8) UNSIGNED No auto_increment ID
sd_sam_id mediumint(8) UNSIGNED Yes NULL RSAM-SSAM ID
sd_rsm_stime datetime Yes NULL Start time
sd_rsm_stime_unc datetime Yes NULL Start time uncertainty
sd_rsm_count float Yes NULL Count
sd_rsm_calib float Yes NULL Reduced displacement per 100 RSAM counts
sd_rsm_com varchar(255) Yes NULL Comments
sd_rsm_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY sd_rsm_id
TIME UNIQUE sd_sam_id
sd_rsm_stime

Links

Field Link to
sd_sam_id sd_sam.sd_sam_id
cc_id_load cc.cc_id

Restrictions

For all RSAM data of the same RSAM-SSAM data:

  • start time (sd_rsm_stime) must be unique and continuous
    i.e. sd_rsm_stime (n+1) = sd_rsm_stime (n) + sd_sam_int

sd_sam - RSAM-SSAM

Description

This table stores information needed to create RSAM and SSAM images.

Field Type Attributes Null Default Extra Unit Comments
sd_sam_id mediumint(8) UNSIGNED No auto_increment ID
sd_sam_code varchar(30) Yes NULL Code
ss_id mediumint(8) UNSIGNED Yes NULL Seismic station ID
sd_sam_stime datetime Yes NULL Start time
sd_sam_stime_unc datetime Yes NULL Start time uncertainty
sd_sam_etime datetime Yes NULL End time
sd_sam_etime_unc datetime Yes NULL End time uncertainty
sd_sam_int float Yes NULL s Counting interval
sd_sam_int_unc float Yes NULL s Counting interval uncertainty
sd_sam_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
sd_sam_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
sd_sam_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
sd_sam_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY sd_sam_id
CODE UNIQUE sd_sam_code
cc_id

Links

Field Link to
ss_id ss.ss_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • sd_sam_stime ≤ sd_sam_etime
  • ss_id.ss_stime ≤ sd_sam_stime ≤ ss_id.ss_etime
  • ss_id.ss_stime ≤ sd_sam_etime ≤ ss_id.ss_etime

sd_ssm - SSAM data

Description

This table stores the data needed to create an SSAM image.

Field Type Attributes Null Default Extra Unit Comments
sd_ssm_id mediumint(8) UNSIGNED No auto_increment ID
sd_sam_id mediumint(8) UNSIGNED Yes NULL RSAM-SSAM ID
sd_ssm_stime datetime Yes NULL Start time
sd_ssm_stime_unc datetime Yes NULL Start time uncertainty
sd_ssm_lowf float Yes NULL Hz Low frequency limit
sd_ssm_highf float Yes NULL Hz High frequency limit
sd_ssm_count float Yes NULL Count
sd_ssm_calib float Yes NULL Reduced displacement per 100 SSAM counts
sd_ssm_com varchar(255) Yes NULL Comments
sd_ssm_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY sd_ssm_id
TIME UNIQUE sd_sam_id
sd_ssm_stime

Links

Field Link to
sd_sam_id sd_sam.sd_sam_id
cc_id_load cc.cc_id

Restrictions

For all SSAM data of the same RSAM-SSAM data:

  • combination of low frequency limit (sd_ssm_lowf) and start time (sd_ssm_stime) must be unique and continuous:
    i.e. sd_ssm_lowf (n+1) = sd_ssm_highf (n) AND sd_ssm_stime (n+1) = sd_ssm_stime (n)
    OR sd_ssm_lowf (n+1) = MINIMUM (sd_ssm_lowf) AND sd_ssm_stime (n+1) = sd_ssm_stime (n) + sd_sam_int

sd_trm - Tremor

Description

This table contains information about tremor such as the time interval, qualitative depth, dominant frequency, amplitude range, and reduced displacement.

Field Type Attributes Null Default Extra Unit Comments
sd_trm_id mediumint(8) UNSIGNED No auto_increment ID
sd_trm_code varchar(30) Yes NULL Code
sn_id smallint(5) UNSIGNED Yes NULL Seismic network ID
ss_id mediumint(8) UNSIGNED Yes NULL Seismic station ID
sd_trm_stime datetime Yes NULL Start time
sd_trm_stime_unc datetime Yes NULL Start time uncertainty
sd_trm_etime datetime Yes NULL End time
sd_trm_etime_unc datetime Yes NULL End time uncertainty
sd_trm_dur_day float Yes NULL min Duration per day
sd_trm_dur_day_unc float Yes NULL min Duration per day uncertainty
sd_trm_type enum('G', 'M', 'H', 'C') Yes NULL Type: G=General, M=Monochromatic, H=Harmonic, C=Close-events
sd_trm_qdepth enum('D', 'I', 'S', 'U') Yes NULL Qualitative depth: D=Deep (>10 km), I=Intermediate (4-10 km), S=Shallow (0-4 km), U =Unknown
sd_trm_domfreq1 float Yes NULL Hz Dominant frequency
sd_trm_domfreq2 float Yes NULL Hz Second dominant frequency
sd_trm_maxamp float Yes NULL Maximum amplitude
sd_trm_noise float Yes NULL Background noise level
sd_trm_reddis float Yes NULL Reduced displacement (as estimated using a station >5km from source)
sd_trm_rderr float Yes NULL Reduced displacement error
sd_trm_visact varchar(255) Yes NULL Description of associated visible activity
sd_trm_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
sd_trm_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Collector ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
sd_trm_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
sd_trm_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY sd_trm_id
CODE UNIQUE sd_trm_code
cc_id

Links

Field Link to
sn_id sn.sn_id
ss_id ss.ss_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • sd_trm_stime ≤ sd_trm_etime
  • sn_id.sn_stime ≤ sd_trm_stime ≤ sn_id.sn_etime
  • sn_id.sn_stime ≤ sd_trm_etime ≤ sn_id.sn_etime
  • ss_id.ss_stime ≤ sd_trm_stime ≤ ss_id.ss_etime
  • ss_id.ss_stime ≤ sd_trm_etime ≤ ss_id.ss_etime

sd_wav - Waveform

Description

This table contains sample waveforms to highlight common and uncommon events at different volcanoes and links to the event information.

Field Type Attributes Null Default Extra Unit Comments
sd_wav_id mediumint(8) UNSIGNED No auto_increment ID
sd_wav_code varchar(30) Yes NULL Code
ss_id mediumint(8) UNSIGNED Yes NULL Seismic station ID
sd_evn_id mediumint(8) UNSIGNED Yes NULL Seismic event ID
sd_evs_id mediumint(8) UNSIGNED Yes NULL Single Station Event ID
sd_trm_id mediumint(8) UNSIGNED Yes NULL Tremor ID
sd_wav_arch varchar(255) Yes NULL Location of seismogram archive
sd_wav_link varchar(255) Yes NULL Link to archive
sd_wav_dist enum('P', 'I', 'D', 'U') Yes NULL Distance from summit: P=Proximal (< 2 km), I=Intermediate (2-5 km), D=Distal (> 5 km), U=Unknown
sd_wav_img varchar(255) Yes NULL Image
sd_wav_info varchar(255) Yes NULL Information
sd_wav_desc varchar(255) Yes NULL Description
sd_wav_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
sd_wav_com varchar(255) Yes NULL Description
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
sd_wav_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
sd_wav_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY sd_wav_id
CODE UNIQUE sd_wav_code
cc_id

Links

Field Link to
ss_id ss.ss_id
sd_evn_id sd_evn.sd_evn_id
sd_evs_id sd_evs.sd_evs_id
sd_trm_id sd_trm.sd_trm_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

None

si - Seismic instrument

Description

This table stores information such as the instrument name, model, number of components and response time.

Field Type Attributes Null Default Extra Unit Comments
si_id mediumint(8) UNSIGNED No auto_increment ID
si_code varchar(30) Yes NULL Code
ss_id mediumint(8) UNSIGNED Yes NULL Seismic station ID
si_name varchar(255) Yes NULL Name
si_type varchar(255) Yes NULL Type
si_range varchar(255) Yes NULL Dynamic range
si_igain float Yes NULL Gain
si_filter varchar(255) Yes NULL Filters
si_ncomp tinyint(3) UNSIGNED Yes NULL Number of components
si_resp varchar(255) Yes NULL Response overview
si_resp_file varchar(255) Yes NULL File containing response
si_stime datetime Yes NULL Start date
si_stime_unc datetime Yes NULL Start date uncertainty
si_etime datetime Yes NULL End date
si_etime_unc datetime Yes NULL End date uncertainty
si_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
si_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
si_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
si_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type sield(s)
PRIMARY PRIMARY si_id
CODE UNIQUE si_code
cc_id
si_stime

Links

Field Link to
ss_id ss.ss_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • si_stime ≤ si_etime
  • ss_id.ss_stime ≤ si_stime ≤ ss_id.ss_etime
  • ss_id.ss_stime ≤ si_etime ≤ ss_id.ss_etime

si_cmp - Seismic component

Description

This table stores information about an individual component (geophone) that sends data to the instrument or recorder such as the component name, model, orientation, band type, and sampling rate.

Field Type Attributes Null Default Extra Unit Comments
si_cmp_id smallint(5) UNSIGNED No auto_increment ID
si_cmp_code varchar(30) Yes NULL Code
si_id mediumint(8) UNSIGNED Yes NULL Seismic instrument ID
si_cmp_name varchar(255) Yes NULL Name
si_cmp_type varchar(255) Yes NULL Type
si_cmp_resp varchar(255) Yes NULL Description of response
si_cmp_band varchar(30) Yes NULL Band type (SEED convention)
si_cmp_samp float Yes NULL Hz Sampling rate
si_cmp_icode varchar(30) Yes NULL Instrument code (SEED convention)
si_cmp_orient varchar(30) Yes NULL Orientation code (SEED convention)
si_cmp_sens varchar(255) Yes NULL Sensitivity
si_cmp_depth float Yes NULL m Depth
si_cmp_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
si_cmp_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
si_cmp_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
si_cmp_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNsi_cmpGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type si_cmpeld(s)
PRIMARY PRIMARY si_cmp_id
CODE UNIQUE si_cmp_code
cc_id

Links

Field Link to
si_id si.si_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

None

sn - Seismic network

Description

This table contains information about the seismic network such as the velocity model used for computing the event locations and a general overview of the types of instruments used.

Field Type Attributes Null Default Extra Unit Comments
sn_id smallint(5) UNSIGNED No auto_increment ID
sn_code varchar(30) Yes NULL Code
vd_id mediumint(8) UNSIGNED Yes NULL Volcano Identifier
sn_name varchar(30) Yes NULL Name
sn_vmodel varchar(255) Yes NULL Description of velocity model
sn_vmodel_detail varchar(255) Yes NULL Link to a file containing additional details about velocity model
sn_zerokm varchar(255) Yes NULL m Elevation of zero km "depth"
sn_fdepth_flag enum('Y', 'N', 'U') Yes NULL Depth is fixed: Y=Yes, N=No, U=Unknown
sn_fdepth varchar(255) Yes NULL Fixed depth description
sn_stime datetime Yes NULL Start date
sn_stime_unc datetime Yes NULL Start date uncertainty
sn_etime datetime Yes NULL End date
sn_etime_unc datetime Yes NULL End date uncertainty
sn_tot tinyint(3) UNSIGNED Yes NULL Total number of seismometers
sn_bb tinyint(3) UNSIGNED Yes NULL Number of broadband seismometers
sn_smp tinyint(3) UNSIGNED Yes NULL Number of short- and mid-period seismometers
sn_digital tinyint(3) UNSIGNED Yes NULL Number of digital seismometers
sn_analog tinyint(3) UNSIGNED Yes NULL Number of analog seismometers
sn_tcomp tinyint(3) UNSIGNED Yes NULL Number of 3 component seismometers
sn_micro tinyint(3) UNSIGNED Yes NULL Number of microphones
sn_desc varchar(255) Yes NULL Description
sn_utc float Yes NULL Difference from UTC
sn_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
sn_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
sn_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
sn_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNsnGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type sneld(s)
PRIMARY PRIMARY sn_id
CODE UNIQUE sn_code
cc_id
sn_stime
sn_vmodel

Links

Field Link to
vd_id vd.vd_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • sn_bb ≤ sn_tot
  • sn_smp ≤ sn_tot
  • sn_digital ≤ sn_tot
  • sn_analog ≤ sn_tot
  • sn_tcomp ≤ sn_tot
  • sn_micro ≤ sn_tot

ss - Seismic station

Description

This table stores information such as a location, name, system gain, and comments about the stations where the data are collected.

Field Type Attributes Null Default Extra Unit Comments
ss_id mediumint(8) UNSIGNED No auto_increment ID
ss_code varchar(30) Yes NULL Code
sn_id smallint(5) UNSIGNED Yes NULL Seismic network ID
ss_name varchar(30) Yes NULL Name
ss_lat double Yes NULL ° Latitude
ss_lon double Yes NULL ° Lonsitude
ss_elev float Yes NULL m Elevation
ss_depth varchar(255) Yes NULL m Depth of instruments
ss_stime datetime Yes NULL Start date
ss_stime_unc datetime Yes NULL Start date uncertainty
ss_etime datetime Yes NULL End date
ss_etime_unc datetime Yes NULL End date uncertainty
ss_utc float Yes NULL Difference from UTC
ss_instr_type varchar(255) Yes NULL Instrument types
ss_sgain float Yes NULL System gain
ss_desc varchar(255) Yes NULL Description
ss_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
ss_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
ss_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
ss_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY ss_id
CODE UNIQUE ss_code
cc_id
ss_stime

Links

Field Link to
sn_id sn.sn_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • ss_stime ≤ ss_etime
  • sn_id.sn_stime ≤ ss_stime ≤ sn_id.sn_etime
  • sn_id.sn_stime ≤ ss_etime ≤ sn_id.sn_etime

st_eqt - Earthquake translation

Description

This table allows users to translate an earthquake type defined by one observatory to the WOVOdat earthquake type.

Field Type Attributes Null Default Extra Unit Comments
st_eqt_id smallint(5) UNSIGNED No auto_increment ID
st_eqt_org varchar(255) Yes NULL Original terminology
st_eqt_wovo varchar(255) Yes NULL WOVOdat terminology
cc_id smallint(5) UNSIGNED Yes NULL Contact ID
st_eqt_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY st_eqt_id
USER TRANSLATION UNIQUE st_eqt_wovo
cc_id

Links

Field Link to
cc_id cc.cc_id
cc_id_load cc.cc_id

Restrictions

None

td - Ground-based thermal data

Description

This table stores all of the thermal data collected on the ground.

Field Type Attributes Null Default Extra Unit Comments
td_id mediumint(8) UNSIGNED No auto_increment ID
td_code varchar(30) Yes NULL Code
ts_id smallint(5) UNSIGNED Yes NULL Thermal station ID
ti_id smallint(5) UNSIGNED Yes NULL Thermal instrument ID
td_mtype varchar(255) Yes NULL Measurement type
td_time datetime Yes NULL Measurement time
td_time_unc datetime Yes NULL Measurement time uncertainty
td_depth float Yes NULL m Depth of measurement
td_distance float Yes NULL m Distance from instrument to the measured object
td_calc_flag enum('O', 'R') Yes NULL Recalculated value: O=Original, R=Recalculated
td_temp float Yes NULL °C Temperature
td_terr float Yes NULL °C Temperature standard error
td_aarea float Yes NULL m2 Approximate area of body measured
td_flux float Yes NULL W/m2 Heat flux
td_ferr float Yes NULL W/m2 Heat flux standard error
td_bkgg float Yes NULL °C/km Background geothermal gradient
td_tcond float Yes NULL W/(m2 °C) Thermal conductivity
td_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
td_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
td_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
td_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY td_id
CODE UNIQUE td_code
cc_id

Links

Field Link to
ts_id ts.ts_id
ti_id ti.ti_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • ts_id.ts_stime ≤ td_time ≤ ts_id.ts_etime
  • ti_id.ti_stime ≤ td_time ≤ ti_id.ti_etime
  • ts_id = ti_id.ts_id

td_img - Thermal image

Description

This table contains data collected from space, the air, or the ground that are used to create thermal images.

Field Type Attributes Null Default Extra Unit Comments
td_img_id smallint(5) UNSIGNED No auto_increment ID
td_img_code varchar(30) Yes NULL Code
vd_id mediumint(8) UNSIGNED Yes NULL Volcano Identifier
cs_id smallint(5) UNSIGNED Yes NULL Satellite ID
ts_id smallint(5) UNSIGNED Yes NULL Thermal station ID
ti_id smallint(5) UNSIGNED Yes NULL Thermal instrument ID
td_img_iplat varchar(255) Yes NULL Description of instrument platform
td_img_ialt float Yes NULL m Instrument altitude
td_img_ilat float Yes NULL ° Instrument latitude
td_img_ilon float Yes NULL ° Instrument longitude
td_img_idatum varchar(30) Yes NULL Datum
td_img_desc varchar(255) Yes NULL Description
td_img_time datetime Yes NULL Time
td_img_time_unc datetime Yes NULL Time uncertainty
td_img_bname varchar(255) Yes NULL Band name
td_img_hbwave float Yes NULL μm High band wavelength
td_img_lbwave float Yes NULL μm Low band wavelength
td_img_path varchar(255) Yes NULL Image Path
td_img_psize float Yes NULL m Pixel size
td_img_maxrad float Yes NULL W/(m2-m) × 107 Maximum radiance
td_img_maxrrad float Yes NULL W/(m2-m × sr) × 107 Maximum relative radiance
td_img_maxtemp float Yes NULL °C Maximum temperature
td_img_totrad float Yes NULL W/(m2-m) × 107 Total radiance
td_img_maxflux float Yes NULL W/m2 Maximum heat flux
td_img_ntres float Yes NULL °C Nominal temperature resolution
td_img_atmcorr varchar(255) Yes NULL Atmospheric correction
td_img_thmcorr varchar(255) Yes NULL Thermal correction
td_img_ortho varchar(255) Yes NULL Orthorectification procedure
td_img_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
td_img_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
td_img_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
td_img_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY td_img_id
CODE UNIQUE td_img_code
cc_id

Links

Field Link to
vd_id vd.vd_id
cs_id cs.cs_id
ts_id ts.ts_id
ti_id ti.ti_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • cs_id.cs_stime ≤ td_img_time ≤ cs_id.cs_etime
  • ts_id.ts_stime ≤ td_img_time ≤ ts_id.ts_etime
  • ti_id.ti_stime ≤ td_img_time ≤ ti_id.ti_etime
  • ts_id = ti_id.ts_id
  • cs_id = ti_id.cs_id
  • vd_id = ts_id.cn_id.vd_id OR jj_volnet.vd_id WHERE jj_volnet.jj_net_id=ts_id.cn_id AND jj_volnet.jj_net_flag=C

td_pix - Thermal pixel

Description

This table contains data for each pixel of a thermal image.

Field Type Attributes Null Default Extra Unit Comments
td_pix_id smallint(5) UNSIGNED No auto_increment ID
td_img_id smallint(5) UNSIGNED Yes NULL Thermal image ID
td_pix_elev float Yes NULL m Elevation
td_pix_lat float Yes NULL ° Latitude
td_pix_lon float Yes NULL ° Longitude
td_pix_rad float Yes NULL W/(m2-m) × 107 Radiance
td_pix_flux float Yes NULL W/m2 Heat flux
td_pix_temp float Yes NULL °C Temperature
td_pix_com varchar(255) Yes NULL Comments
td_pix_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY td_pix_id
LAT/LON UNIQUE td_img_id
td_pix_lat
td_pix_lon

Links

Field Link to
td_img_id td_img.td_img_id
cc_id_load cc.cc_id

Restrictions

None

ti - Thermal instrument

Description

This table was created to store information about the instruments used to collect ground-based and remote thermal data.

Field Type Attributes Null Default Extra Unit Comments
ti_id smallint(5) UNSIGNED No auto_increment ID
ti_code varchar(30) Yes NULL Code
cs_id smallint(5) UNSIGNED Yes NULL Satellite ID
ts_id smallint(5) UNSIGNED Yes NULL Thermal station ID
ti_type varchar(255) Yes NULL Type
ti_name varchar(255) Yes NULL Name
ti_units varchar(50) Yes NULL Measured units
ti_pres float Yes NULL Resolution
ti_stn float Yes NULL Signal to noise
ti_stime datetime Yes NULL Start date
ti_stime_unc datetime Yes NULL Start date uncertainty
ti_etime datetime Yes NULL End date
ti_etime_unc datetime Yes NULL End date uncertainty
ti_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
ti_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
ti_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
ti_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type tield(s)
PRIMARY PRIMARY ti_id
CODE UNIQUE ti_code
cc_id
ti_stime

Links

Field Link to
cs_id cs.cs_id
ts_id ts.ts_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • ti_stime ≤ ti_etime
  • ts_id.ts_stime ≤ ti_stime ≤ ts_id.ts_etime
  • ts_id.ts_stime ≤ ti_etime ≤ ts_id.ts_etime
  • cs_id.cs_stime ≤ ti_stime ≤ cs_id.cs_etime
  • cs_id.cs_stime ≤ ti_etime ≤ cs_id.cs_etime

ts - Thermal station

Description

This table stores information such as a location, name, and a description for stations where thermal data are collected.

Field Type Attributes Null Default Extra Unit Comments
ts_id smallint(5) UNSIGNED No auto_increment ID
ts_code varchar(30) Yes NULL Code
cn_id smallint(5) UNSIGNED Yes NULL Thermal network ID
ts_name varchar(30) Yes NULL Name
ts_type varchar(255) Yes NULL Type of thermal feature
ts_ground varchar(255) Yes NULL Soil or ground type
ts_lat double Yes NULL ° Latitude
ts_lon double Yes NULL ° Lontitude
ts_elev float Yes NULL m Elevation
ts_perm varchar(255) Yes NULL List of permanent instruments
ts_utc float Yes NULL Difference from UTC
ts_stime datetime Yes NULL Start date
ts_stime_unc datetime Yes NULL Start date uncertainty
ts_etime datetime Yes NULL End date
ts_etime_unc datetime Yes NULL End date uncertainty
ts_desc varchar(255) Yes NULL Description
ts_ori enum('D','O') Yes NULL A flag for source of data: D=digitized/Bibliography, O=Original from observatory
ts_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Owner ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Owner ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Owner ID
ts_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
ts_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY ts_id
CODE UNIQUE ts_code
cc_id
ts_stime

Links

Field Link to
cn_id cn.cn_id
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id_load cc.cc_id

Restrictions

  • ts_stime ≤ ts_etime
  • cn_id.cn_stime ≤ ts_stime ≤ cn_id.cn_etime
  • cn_id.cn_stime ≤ ts_etime ≤ cn_id.cn_etime

vd - Volcano

Description

This table stores two pieces of data that are unlikely to change, the volcano name and the time zone.

Field Type Attributes Null Default Extra Unit Comments
vd_id mediumint(8) UNSIGNED No auto_increment ID, Volcano Identifier (Index)
vd_cavw varchar(15) Yes NULL The current CAVW number
vd_name varchar(255) Yes NULL Volcano Name (first)
vd_name2 varchar(255) Yes NULL Volcano Name (second)
vd_tzone float Yes NULL Time zone (relative to UTC)
vd_mcont char(1) Yes NULL M=Multiple contacts for this volcano
vd_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL First Contact ID
cc_id2 smallint(5) UNSIGNED Yes NULL Second Contact ID
cc_id3 smallint(5) UNSIGNED Yes NULL Third Contact ID
cc_id4 smallint(5) UNSIGNED Yes NULL Fourth Contact ID
cc_id5 smallint(5) UNSIGNED Yes NULL Fifth Contact ID
vd_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
vd_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY vd_id
CAVW NUMBER UNIQUE vd_cavw

Links

Field Link to
cc_id cc.cc_id
cc_id2 cc.cc_id
cc_id3 cc.cc_id
cc_id4 cc.cc_id
cc_id5 cc.cc_id
cc_id_load cc.cc_id

Restrictions

None

vd_inf - Volcano information

Description

This table contains information about the volcano that could possibly change over the life of the database, such as the CAVW number, the location of the summit, and other descriptive information.

Field Type Attributes Null Default Extra Unit Comments
vd_inf_id smallint(5) UNSIGNED No auto_increment ID, volcano information identifier (index)/td>
vd_id mediumint(8) UNSIGNED Yes NULL Volcano Identifier
vd_inf_cavw varchar(15) Yes NULL CAVW number, the current CAVW number
vd_inf_status enum('Anthropology','Ar/Ar','Dendrochronology','Fumarolic','Historical','Holocene','Holocene?','Hot Springs','Hydration Rind','Hydrophonic','Ice Core','Lichenometry','Magnetism','Pleistocene','Potassium-Argon','Radiocarbon','Seismicity','Surface Exposure','Tephrochronology','Thermoluminescence','Uncertain','Uranium-series','Varve Count','Unknown') Yes Unknown Status
vd_inf_desc varchar(255) Yes NULL Short narrative
vd_inf_slat double Yes NULL ° Summit latitude
vd_inf_slon double Yes NULL ° Summit longitude
vd_inf_selev float Yes NULL m Summit elevation
vd_inf_type enum('Caldera','Cinder cone','Complex volcano','Compound volcano','Cone','Crater rows','Explosion craters','Fissure vent','Hydrothermal field','Lava cone','Lava dome','Maar','Pumice cone','Pyroclastic cone','Pyroclastic shield','Scoria cone','Shield volcano','Somma volcano','Stratovolcano','Subglacial volcano','Submarine volcano','Tuff cone','Tuff ring','Unknown','Volcanic complex','Volcanic field') Yes NULL Type
vd_inf_loc varchar(30) Yes NULL m3 Geographic location
vd_inf_rtype enum('Basalt','Tephrit/Trachybasalt','Andesite/Basaltic-andesite','Trachyandesite','Dacite','Rhyolite','Trachyte','Phonolite','Phonotephrite','Foidite','Unknown') Yes NULL m3 Dominant Rock Type
vd_inf_evol float Yes NULL m3 Volume of edifice
vd_inf_numcald tinyint(4) UNSIGNED Yes NULL Number of calderas
vd_inf_lcald_dia float Yes NULL km Diameter of largest caldera
vd_inf_ycald_lat double Yes NULL ° Latitude of youngest caldera
vd_inf_ycald_lon double Yes NULL ° Longitude of youngest caldera
vd_inf_stime datetime Yes NULL Start time
vd_inf_stime_unc datetime Yes NULL Start time uncertainty
vd_inf_etime datetime Yes NULL End time
vd_inf_etime_unc datetime Yes NULL End time uncertainty
vd_inf_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Contact ID
vd_inf_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
vd_inf_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY vd_inf_id
INFORMATION AT A CERTAIN TIME UNIQUE vd_id
vd_inf_stime

Links

Field Link to
vd_id vd.vd_id
cc_id cc.cc_id
cc_id_load cc.cc_id

Restrictions

None

vd_mag - Magma chamber

Description

This table contains information about the magma chamber such as its composition(s) and minimum size (based on the largest eruption volume).

Field Type Attributes Null Default Extra Unit Comments
vd_mag_id smallint(5) UNSIGNED No auto_increment Volcano magma chamber identifier (index)
vd_id mediumint(8) UNSIGNED Yes NULL Volcano Identifier
vd_mag_lvz_dia float Yes NULL km Diameter of low velocity zone
vd_mag_lvz_vol float Yes NULL km3 Volume of low velocity zone
vd_mag_tlvz float Yes NULL km Depth to top of low velocity zone
vd_mag_lerup_vol double Yes NULL km3 Volume of largest eruption, DRE
vd_mag_drock varchar(60) Yes NULL Dominant rock type
vd_mag_orock varchar(60) Yes NULL Outlier rock type
vd_mag_orock2 varchar(60) Yes NULL Second outlier rock type
vd_mag_orock3 varchar(60) Yes NULL Third outlier rock type
vd_mag_minsio2 float Yes NULL Minimum SiO2 content of whole rocks erupted
vd_mag_maxsio2 float Yes NULL Maximum SiO2 content of whole rocks erupted
vd_mag_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Data Owner ID
vd_mag_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
vd_mag_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY vd_mag_id

Links

Field Link to
vd_id vd.vd_id
cc_id cc.cc_id
cc_id_load cc.cc_id

Restrictions

None

vd_tec - Tectonic setting

Description

This table contains information about the local tectonic setting such as rates of movement either along a plate or over a hotspot.

Field Type Attributes Null Default Extra Unit Comments
vd_tec_id smallint(5) UNSIGNED No auto_increment ID, tectonic setting identifier
vd_id mediumint(8) UNSIGNED Yes NULL Volcano Identifier
vd_tec_desc varchar(255) Yes NULL Description
vd_tec_strslip float Yes NULL cm/a Rate of strike-slip
vd_tec_ext float Yes NULL cm/a Rate of extension
vd_tec_conv float Yes NULL cm/a Rate of convergence
vd_tec_travhs float Yes NULL cm/a Travel rate across hotspot
vd_tec_com varchar(255) Yes NULL Comments
cc_id smallint(5) UNSIGNED Yes NULL Contact ID
vd_tec_loaddate datetime Yes NULL Load date, the date the data was entered (in UTC)
vd_tec_pubdate datetime Yes NULL Publish date, the date the data become public
cc_id_load smallint(5) UNSIGNED Yes NULL Loader ID, contact ID for the person who entered the data
cb_ids varchar(255) Yes NULL Link to bibliography table

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY vd_tec_id

Links

Field Link to
vd_id vd.vd_id
cc_id cc.cc_id
cc_id_load cc.cc_id

Restrictions

None