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 | ||||
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
ddu - Download Data User Record
Description
This table stores the user info who downloads data from website
Field | Type | Attributes | Null | Default | Extra | Unit | Comments |
---|---|---|---|---|---|---|---|
ddu_id | smallint(5) | UNSIGNED | No | auto_increment | Download data user id | ||
cr_id | smallint(5) | UNSIGNED | Yes | Log in user id like download as a registered user | |||
ddu_name | varchar(30) | Yes | NULL | Download data user name like download as a guest user | |||
ddu_email | varchar(30) | Yes | NULL | ||||
ddu_obs | varchar(30) | Yes | NULL | Download data user obs | |||
ddu_ip | varchar(30) | Yes | NULL | Download data user's IP address | |||
ddu_time | datetime | Yes | NULL | The time user download data | |||
ddu_country | varchar(30) | Yes | NULL | Country where user download data | |||
ddu_city | varchar(30) | Yes | NULL | City where user download data | |||
vd_name | varchar(50) | Yes | NULL | User download data for this vol | |||
cc_id | varchar(30) | Yes | NULL | To keep data owner Id | |||
ddu_dataType | varchar(50) | Yes | NULL | User dowload data type | |||
ddu_dataStartTime | datetime | Yes | NULL | User download data start time | |||
ddu_dataEndTime | datetime | Yes | NULL | User download data end time |
Indexes
Keyname | Type | Field(s) |
---|---|---|
PRIMARY | PRIMARY | ddu_id |
Links
None
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_slat | double | Yes | NULL | latitude | |||
co_slat_err | float | Yes | NULL | Latitude Uncertainty | |||
co_slon | double | Yes | NULL | Longitude | |||
co_slon_err | float | Yes | NULL | Longtitude Uncertainty | |||
co_selev | double | Yes | NULL | Elevation | |||
co_selev_err | float | Yes | NULL | Elevation Uncertainty | |||
co_observe | varchar(1200) | Yes | NULL | Description | |||
co_observe_type | varchar(255) | Yes | NULL | Type of observation (incandescence, pyroclastic flow, rock fall, lava flow, eruption column, steaming, lake bubbling,crater glow, extrusion rate, lake color, etc.) | |||
co_obs_meas | varchar(30) | Yes | NULL | What quantifiable parameter that can be observed, or parameter that change during observation (PF runout distance, extrusion rate, explosion column height, etc.) | |||
co_obs_meas_unit | varchar(30) | Yes | NULL | The units reported for the measured parameter (m, km, m3/s, etc.) | |||
co_obs_meas_val | float | Yes | NULL | Measured value of the observable parameter | |||
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 | |||||
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_otype | enum('LEO','GSO') | Yes | NULL | Satellite orbital type: Low Earth Orbit (LEO) or Geostationary orbit (GSO) | |||
cs_oheight | float | Yes | NULL | Satellite orbital height (km) | |||
cs_spatres | varchar(30) | Yes | NULL | Spatial resolution(nadir)(Km) | |||
cs_ctsize | float | Yes | NULL | Cross track size (Km) | |||
cs_atsize | float | Yes | NULL | Along track size (Km) | |||
cs_swidth | float | Yes | NULL | Swath width (ground projection)(Km) | |||
cs_tempres | varchar(30) | Yes | NULL | Temporal resolution (repeatability, return back to the same spot) hours or days | |||
cs_rtime | float | Yes | NULL | Return time (repeatability, return back to the exact spot with the same viewing angle) hours or days | |||
cs_vangle | float | Yes | NULL | Angle of view from nadir (o) | |||
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_qual | double | Yes | NULL | Slope or baseline distance. Unit is m | |||
dd_gps_errslope | float | Yes | NULL | Error Slope or baseline distance error. Unit is mmr | |||
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_refFrame | varchar(30) | Yes | NULL | Ref Frame | |||
dd_gpv_projection | varchar(30) | Yes | NULL | Projection | |||
dd_gpv_ellipsoid | varchar(30) | Yes | NULL | Ellipsoid | |||
dd_gpv_datum | varchar(30) | Yes | NULL | Datum | |||
dd_gpv_refPosLat | decimal(2,2) | Yes | NULL | GPS Reference Position (Latitude) | |||
dd_gpv_refPosLon | decimal(2,2) | Yes | NULL | GPS Reference Position (Longitude) | |||
dd_gpv_refPosElev | decimal(2,2) | Yes | NULL | GPS Reference Position (Elevation) | |||
dd_gpv_staVelNorth | decimal(2,2) | Yes | NULL | GPS Station Velocity (North) | |||
dd_gpv_staVelNorthErr | decimal(2,2) | Yes | NULL | GPS Station Velocity (Error-North) | |||
dd_gpv_staVelEast | decimal(2,2) | Yes | NULL | GPS Station Velocity (East) | |||
dd_gpv_staVelEastErr | decimal(2,2) | Yes | NULL | GPS Station Velocity (Error-East) | |||
dd_gpv_staVelVert | decimal(2,2) | Yes | NULL | GPS Station Velocity (Vertical) | |||
dd_gpv_staVelVertErr | decimal(2,2) | Yes | NULL | GPS Station Velocity (Error-vertical) | |||
dd_gpv_dataType | varchar(255) | Yes | NULL | Date Type | |||
dd_gpv_arch | varchar(255) | Yes | NULL | Location of the solution (Processed data) archive | |||
dd_gpv_software | text | Yes | NULL | The software used to process data | |||
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_srp - InSAR Data point
Description
This table contains the data collected by two satellites to create an InSAR data point.
Field | Type | Attributes | Null | Default | Extra | Unit | Comments |
---|---|---|---|---|---|---|---|
dd_srp_id | mediumint(8) | UNSIGNED | No | auto_increment | ID | ||
dd_srp_code | varchar(30) | Yes | NULL | InSAR data point code | |||
vd_id | mediumint(8) | UNSIGNED | Yes | NULL | Volcano ID | ||
cs_id1 | mediumint(8) | UNSIGNED | Yes | NULL | Satellite ID | ||
cs_id2 | mediumint(8) | UNSIGNED | Yes | NULL | Satellite ID | ||
dd_sar_id | mediumint(8) | UNSIGNED | Yes | NULL | InSAR ID | ||
dd_srp_img1_time | datetime | Yes | NULL | Date-time of the image 1 was taken | |||
dd_srp_img1_time_unc | datetime | Yes | NULL | Date of image 1 uncertainty | |||
dd_srp_img2_time | datetime | Yes | NULL | Date-time of the image 2 was taken | |||
dd_srp_img2_time_unc | datetime | Yes | NULL | Date of image 2 uncertainty | |||
dd_srp_lat | double | Yes | NULL | Latitude coordinate | |||
dd_srp_lon | double | Yes | NULL | Longitude coordinate | |||
dd_srp_elev | double | Yes | NULL | Elevation (from DEM) | |||
dd_srp_dchange | float | Yes | NULL | Observed LOS displacement/ change of distance | |||
dd_srp_losVer | float | Yes | NULL | LOS Vertical Value | |||
dd_srp_losHor | float | Yes | NULL | LOS Horizontal Value | |||
dd_srp_losEast | float | Yes | NULL | LOS East Value | |||
dd_srp_losNorth | float | Yes | NULL | LOS North Value | |||
dd_srp_units | varchar(30) | Yes | NULL | Units | |||
dd_srp_ori | enum('D','O') | Yes | NULL | A flag for source of data: D=digitized/Bibliography, O=Original from observatory | |||
dd_srp_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_srp_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_srp_id |
CODE | UNIQUE | dd_srp_code |
cc_id |
Links
Field | Link to |
---|---|
vd_id | vd.vd_id |
cs_id1 | cs.cs_id |
cs_id2 | cs.cs_id |
dd_sar_id | dd_sar.dd_sar_id |
cc_id | cc.cc_id |
cc_id2 | cc.cc_id |
cc_id3 | cc.cc_id |
cc_id_load | cc.cc_id |
Restrictions
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_bpres | float | Yes | NULL | Barometric Pressure | |||
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 | |||
cs_id | smallint(5) | UNSIGNED | Yes | NULL | satellite/ airplane ID | ||
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 |
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
- 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 | |||
ed_num | mediumint(8) | Yes | NULL | Eruption Number | |||
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_vei | mediumint(9) | Yes | NULL | VEI | |||
ed_rtype | varchar(50) | Yes | NULL | Rock type (will be moved from 'volcano info' table to 'eruption' table) | |||
ed_magamoving | enum('Y', 'N') | Yes | NULL | Magma Moving: Y=Yes, N=No | |||
ed_com1 | varchar(255) | Yes | NULL | Comment field 1 | |||
ed_com2 | varchar(255) | Yes | NULL | Comment field 2 | |||
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 |
cb_ids | cb.cb_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_astime | datetime | Yes | NULL | Alert Start Time | |||
ed_for_aetime | datetime | Yes | NULL | Alert End Time | |||
ed_for_alevel | varchar(255) | Yes | NULL | Alert level | |||
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 |
cb_ids | cb.cb_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_for_col - Alert level color
Description
This table allows the system to visualize an alert level defined by each observatory in the standardized & pre-defined color code.
Field | Type | Attributes | Null | Default | Extra | Unit | Comments |
---|---|---|---|---|---|---|---|
ed_for_col_id | int(5) | UNSIGNED | No | auto_increment | ID | ||
ed_for_col_org | varchar(255) | Yes | NULL | Alert level defined by each observatory | |||
ed_for_col_color | varchar(255) | Yes | NULL | Standardized alert level color will be shown on visualization | |||
cc_id | smallint(5) | UNSIGNED | Yes | NULL | Contact ID | ||
ed_for_col_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 | ed_for_col_id |
Links
Field | Link to |
---|---|
cc_id | cc.cc_id |
cc_id_load | cc.cc_id |
Restrictions
None
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_type | enum(''Phreatic eruption','Magmatic extrusion','Explosion','Sector collapse','Climactic phase','Tectonic earthquake') | Yes | NULL | Eruptiion Phase type | |||
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_tot | float | Yes | NULL | m3 × 106 | DRE (Dense-Rock Equivalent) | ||
ed_phs_dre_lav | float | Yes | NULL | m3 × 106 | DRE (Dense-Rock Equivalent) | ||
ed_phs_dre_tep | 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 |
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 |
cb_ids | cb.cb_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 |
cb_ids | cb.cb_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 | ||
gd_plu_volc1 | varchar(50) | Yes | NULL | Associated/neighbouring volcano (the SO2 satellite data might represent emission from other volcanoes) | |||
gd_plu_volc2 | varchar(50) | Yes | NULL | Associated/neighbouring volcano (the SO2 satellite data might represent emission from other volcanoes) | |||
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_minboxlat | double | Yes | NULL | Minimum latitude of the area considered in the calculation | |||
gd_plu_maxboxlat | double | Yes | NULL | Maximum latitude of the area considered in the calculation | |||
gd_plu_minboxlon | double | Yes | NULL | Minimum longitude of the area considered in the calculation | |||
gd_plu_maxboxlon | double | Yes | NULL | Maximum longitude of the area considered in the calculation | |||
gd_plu_image | varchar(255) | Yes | NULL | Link to a file containing detail image about area of interest & brief synopsis | |||
gd_plu_image_path | varchar(255) | Yes | NULL | Satellite Image | |||
gd_plu_inter | varchar(255) | Yes | NULL | List of all possible interference sources of SO2 (pollution, other volcano eruption plume, copper smelter, cloud cover) | |||
gd_plu_height | float | Yes | NULL | km | Height | ||
gd_plu_hdet | varchar(255) | Yes | NULL | Height determination | |||
gd_plu_colheight | enum('TRL','TRM','STL') | Yes | NULL | Assumed SO2 column height | |||
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_mass | float | Yes | NULL | Gas mass (satellite) | |||
gd_plu_ventmass | float | Yes | NULL | Gas mass at pixel where volcanic vent located (satellite) | |||
gd_plu_maxmass | float | Yes | NULL | Gas mass at pixel where maximum SO2 detected (satellite) | |||
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_area | float | Yes | NULL | Gas plume coverage area | |||
gd_plu_dist | float | Yes | NULL | Distance of maximum gas plume from the volcanic vent | |||
gd_plu_dir | float | Yes | NULL | Direction of maximum gas plume from the volcanic vent | |||
gd_plu_minwave | float | Yes | NULL | Minimum wavelength range (satellite) | |||
gd_plu_maxwave | float | Yes | NULL | Maximum wavelength range (satellite) | |||
gd_plu_spect | float | Yes | NULL | Spectral resolution (satellite) | |||
gd_plu_tech | varchar(50) | Yes | NULL | The technique/algorithm used to calculate the gas plume emission/mass | |||
gd_plu_wind | float | Yes | NULL | 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_etot | float | Yes | NULL | Total amount of daily emission | |||
gd_plu_etot_err | float | Yes | NULL | Daily total amount uncertainty | |||
gd_plu_etot_units | varchar(30) | Yes | NULL | Units of Total daily emission | |||
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_spatres | varchar(30) | Yes | NULL | km | Spatial resolution (nadir) | ||
gi_ctsize | float | Yes | NULL | km | Cross track size | ||
gi_atsize | float | Yes | NULL | km | Along track size | ||
gi_swidth | float | Yes | NULL | km | Swath width (ground projection) | ||
gi_tempres | varchar(30) | Yes | NULL | Temporal resolution (repeatability, return back to the same spot) [hours or days] | |||
gi_rtime | varchar(30) | Yes | NULL | Return time (repeatability, return back to the exact spot with the same viewing angle) [hours or days] | |||
gi_vangle | double | Yes | NULL | Angle of view from nadir | |||
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_temp_err | float | Yes | NULL | Uncertainty of water tepmerature | |||
hd_welev_err | float | Yes | NULL | Uncertainty of the elevation of the water level | |||
hd_wdepth_err | float | Yes | NULL | Uncertainty of water depth | |||
hd_dwlev_err | float | Yes | NULL | Change in water level uncertainty | |||
hd_bp_err | float | Yes | NULL | Barometric pressure uncertainty | |||
hd_sdisc_err | float | Yes | NULL | Spring discharge rate uncertainty | |||
hd_prec_err | float | Yes | NULL | Measured precipitation uncertainty (daily) | |||
hd_dprec_err | float | Yes | NULL | Uncertainty of the daily precipitation of preceding day | |||
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 |
cb_ids | cb.cb_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 |
cb_ids | cb.cb_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 |
cb_ids | cb.cb_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 |
cb_ids | cb.cb_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 |
cb_ids | cb.cb_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_temp_unc | float | Yes | NULL | Air temperature uncertainty | |||
med_stemp_unc | float | Yes | NULL | Soil temperature uncertainty | |||
med_bp_unc | float | Yes | NULL | Barometric pressure uncertainty | |||
med_prec_unc | float | Yes | NULL | Daily precipitation uncertainty | |||
med_hd_unc | float | Yes | NULL | Humidity uncertainty | |||
med_wind_unc | float | Yes | NULL | Wind speed uncertainty | |||
med_wsmin_unc | float | Yes | NULL | Minimum wind speed uncertainty | |||
med_wsmax_unc | float | Yes | NULL | Maximum wind speed uncertainty | |||
med_wdir_unc | float | Yes | NULL | Wind direction uncertainty | |||
med_clc_unc | float | Yes | NULL | Cloud coverage uncertainty | |||
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','RF','E','U','O','X','G','PF','T','LP','HF','VH','VH_LC') | 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','RF','E','U','O','X','G','PF','T','LP','HF','VH','VH_LC') | Yes | NULL | The WOVOdat terminology for the earthquake type: U=Unknown Origin, O=Other non-volcanic, X=Undefined | |||
sd_evs_domFre | float | Yes | NULL | Hz | Dominant Frequency (Hz) | ||
sd_evs_firMotion | enum('Up','Down','Unknown') | Yes | NULL | First Motion (UP/DOWN/Unknown) | |||
sd_evs_mag | float | Yes | NULL | Magnitude | |||
sd_evs_energy | float | Yes | NULL | Seismic Energy. Unit is (erg) -0.5 | |||
sd_evs_Emaxam | float | Yes | NULL | Maximum Amplitude of E-component | |||
sd_evs_Nmaxam | float | Yes | NULL | Maximum Amplitude of N-component | |||
sd_evs_Zmaxam | float | Yes | NULL | Maximum Amplitude of Z-component | |||
sd_evs_Efreq | float | Yes | NULL | Frequency at max-amplitude of E-component | |||
sd_evs_Nfreq | float | Yes | NULL | Frequency at max-amplitude of N-component | |||
sd_evs_Zfreq | float | Yes | NULL | Frequency at max-amplitude of Z-component | |||
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','RF','E','U','O','X','G','PF','T','LP','HF','VH','VH_LC') | 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_dmin | float | Yes | NULL | km | Minimum duration (in s) | sd_ivl_dmax | float | Yes | NULL | km | Maximum duration (in s) |
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_minamp | float | Yes | NULL | Minimum amplitude | |||
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 | |||
vd_id | mediumint(8) | No | Volcano ID | ||||
ts_id | smallint(5) | UNSIGNED | Yes | NULL | Thermal station ID | ||
cs_id | mediumint(5) | No | Satellite ID | ||||
ti_id | smallint(5) | UNSIGNED | Yes | NULL | Thermal instrument ID | td_mtype | enum('Temperature','Temperature Above Background','Soil Temperature','Radiance','Radiance Power') | Yes | NULL | Measurement type |
td_units | varchar(30) | Yes | NULL | Units | |||
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_cond_err | float | Yes | NULL | Thermal conductivity uncertainty | |||
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_num | mediumint(6) | Yes | NULL | The new Smithsonia CAVW number for this volcano | |||
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 |
The new Smithsonia CAVW number for this volcano | UNIQUE | vd_num |
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_country | varchar(30) | Yes | NULL | m3 | Geographic location | ||
vd_inf_subreg | varchar(30) | Yes | NULL | m3 | Geographic location | ||
vd_inf_loc | varchar(30) | Yes | NULL | m3 | Geographic location | ||
vd_inf_rtype | enum('Andesite/Basaltic Andesite','Basalt','Basalt/Picro-Basalt','Dacite','Foidite','Phonolite','Phonotephrite','Tephra-phonolite','Trachybasalt/Tephrite Basanite','Trachyandesite/Basaltic trachy-andesite','Trachyandesite','Trachyte/Trachydacite','Rhyolite','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 |
cb_ids | cb.cb_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 |
cb_ids | cb.cb_id |
Restrictions
None