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
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
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_otype | varchar(255) | Yes | NULL | Satellite orbital type: Low Earth Orbit (LEO) or Geostationary orbit (GSO) | |||
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 | |||
cs_mission | varchar(1200) | Yes | NULL | Operators (agency operating the satellite) | |||
cs_intr_list | varchar(255) | Yes | NULL | Applications/Mission type | |||
co_cospar | varchar(15) | Yes | NULL | list of instruments | |||
co_cospar | varchar(15) | Yes | NULL | COSPAR ID. The International Designator, also known as COSPAR ID, and NSSDCA ID, is an international identifier assigned to artificial objects in space. E.g. 2014-029A for ALOS-2 | |||
cs_satcat | smallint(5) | UNSIGNED | Yes | NULL | SATCAT no. The Satellite Catalog Number (also known as NORAD (North American Aerospace Defense) Catalog Number, NORAD ID, NASA catalog number, USSPACECOM object number or simply catalog number and similar variants) is a sequential five-digit number assigned by United States Space Command in order of discovery to all artificial objects in Earth. e.g. 39766 for ALOS-2 |
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
csi_gen - Satellite/Airplane-Instrument Junction
Description
This table is to store every instruments info directly attached to Satellite/Airplane.
Field | Type | Attributes | Null | Default | Extra | Unit | Comments |
---|---|---|---|---|---|---|---|
csi_gen_id | smallint(5) | UNSIGNED | No | auto_increment | Satellite/Airplane-Instrument ID | ||
csi_gen_code | varchar(30) | Yes | NULL | Satellite/Airplane-Instrument Code | |||
cs_vol_id | smallint(5) | UNSIGNED | Yes | NULL | Satellite/Airplane-Volcano ID | ||
csi_gen_type | enum('D','G','F','H','T','M') | Yes | NULL | Type (D=Deformation,G=Gas,F=Fields,H=Hydrologic,T=Thermal,M=Meteo) | |||
csi_gen_stime | datetime | Yes | NULL | Start time | |||
csi_gen_stime_unc | datetime | Yes | NULL | Start time uncertainty | |||
csi_gen_etime | datetime | Yes | NULL | End time | |||
csi_gen_etime_unc | datetime | Yes | NULL | End time uncertainty | |||
csi_gen_desc | varchar(1500) | Yes | NULL | Instrument technical description | |||
csi_gen_spatres | varchar(30) | Yes | NULL | IFOV (Instantaneous Field of View), the area on the ground that is viewed by the instrument from a given altitude at any time. | |||
csi_gen_swidth | varchar(30) | Yes | NULL | Swath width (ground projection) (Km) | |||
csi_gen_pixel | varchar(30) | Yes | NULL | pixel size at nadir (along x across track) | |||
csi_gen_cycle | varchar(30) | Yes | NULL | Time repeatability/cycle when the satellite repeats the same ground track (hours or days) | |||
csi_gen_operator | varchar(30) | Yes | NULL | Instrument operator | |||
csi_gen_ori | enum('D','O') | Yes | NULL | A flag for source of data: D=digitized/Bibliography, O=Original from observatory | |||
csi_gen_com | varchar(1500) | 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 | ||
csi_gen_loaddate | datetime | Yes | NULL | Load date, the date the data was entered (in UTC) | |||
csi_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 | csi_gen_id |
CODE | UNIQUE | cs_vol_id |
Links
Field | Link to |
---|---|
cs_vol_id | cs_vol.cs_vol_id |
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
cs_vol - Satellite/Airplane-Volcano junction
Description
This table was created for the many-to-many relationship between the volcano and the Satellite/Airplane that monitor the volcano.
Field | Type | Attributes | Null | Default | Extra | Unit | Comments |
---|---|---|---|---|---|---|---|
cs_vol_id | smallint(5) | UNSIGNED | No | auto_increment | ID | ||
cs_id | smallint(8) | UNSIGNED | Yes | NULL | Airplane/Satellite Id | ||
vd_id | mediumint(8) | UNSIGNED | Yes | NULL | Volcano ID | ||
cs_vol_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 | cs_vol_id |
LINK | UNIQUE | cs_id |
vd_id |
Links
Field | Link to |
---|---|
vd_id | vd.vd_id |
cs_id | cs_id |
cc_id_load | cc.cc_id |
Restrictions
None
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_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 | |||
di_gen_type_enum | 'GPS Receiver','GPS Antenna','EDM base station','cGPS/cGNSS Receiver','cGPS/cGNSS Antenna','EDM reflector','Levelling benchmark','Synthetic Aperture Radar (SAR)','Angle benchmark','Surface laser strain','Extensometer','Dilatometer','Light detection and Ranging (LIDAR)','Terestrial Laser Scanning (TLS)','Airborn Laser Scanning (ALS)','Satellite radar interferometry (InSAR)','Very Long Baseline Interferometry (VLBI)','Pore-pressure sensor','Tiltmeter','Strainmeter','Others' | Yes | NULL | Instrument Types | |||
di_gen_type_abbre | 'GPS Receiver','GPS Antenna','EDM base','cGPS/cGNSS Receiver','cGPS/cGNSS Antenna','EDM refl.','Levelling','SAR','Angle','Laser','Extenso.','Dilato.','LIDAR','TLS','ALS','InSAR','VLBI','Pore-pressure','Tilt','Strain','Others' | Yes | NULL | Instrument Types Abbreviation | |||
di_gen_desc | varchar(255) | Yes | NULL | Description | |||
di_gen_install_place | 'In situ ground-based','Remote ground-based','Airborne/Satellite' | Yes | NULL | Installation Types |
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 | |||
di_tlt_type_enum | 'Tiltmeter','Strainmeter','Surface Laser Strain' | Yes | NULL | Instrument Types | |||
di_tlt_type_abbre | 'Tilt','Strain','Surface Laser Strain' | Yes | NULL | Instrument Types Abbreviation | |||
di_tlt_desc | varchar(255) | Yes | NULL | Description | |||
di_tlt_install_place | 'In situ ground-based','Remote ground-based','Airborne/Satellite' | Yes | NULL | Installation Types |
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 | |||
ds_install_type | 'Permanent','Non-permanent' | Yes | NULL | Station Installation Types |
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
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_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 | |||
fi_type_enum | 'Magnetometer','Gravimeter','Magneto Telluric (MT)','Control Source MT (CSAMT)','Electrical Resistivity (ER)','Electromagnetic','Ground Penetrating Radar (GPR)','Self Potential','Induced Polarization (IP)','Very Low Frequency (VLF)','Others' | Yes | NULL | Instrument Types | |||
fi_type_abbre | 'Magnetometer','Gravimeter','MT','CSAMT','ER','Electromagnetic','GPR','Self Potential','IP','VLF','Others' | Yes | NULL | Instrument Types Abbreviation | |||
fi_desc | varchar(255) | Yes | NULL | Description | |||
fi_install_place | 'In situ ground-based','Remote ground-based','Airborne/Satellite' | Yes | NULL | Installation Types |
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 | |||
fs_install_type | 'Permanent','Non-permanent' | Yes | NULL | Station Installation Types |
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
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_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 | |||
gi_type_enum | 'CO2','SO2','HCI','Spectrometer (DOAS/COSPEC/FLYSPEC)','Direct Gas Sample location','FTIR (Airborne Infrared Spectrometer)','MultiGas Analyzer','UV camera','Soil-efflux/fluxmeter','Continuous Soil-CO2 fluxmeter','Geochemistry probe','Electrochemical Sensor','Telescope','Others' | Yes | NULL | Instrument Types | |||
gi_type_abbre | 'CO2','SO2','HCI','Spectrometer','Gas sample loc','FTIR','MultiGas','UV camera','Soil-efflux/fluxmeter','Cont. Soil-CO2 fluxmeter','Geochemistry probe','Electrochemical Sensor','Telescope','Others' | Yes | NULL | Instrument Types Abbreviation | |||
gi_desc | varchar(255) | Yes | NULL | Description | |||
gi_install_place | 'In situ ground-based','Remote ground-based','Airborne/Satellite' | Yes | NULL | Installation Types |
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 | |||
gs_install_type | 'Permanent','Non-permanent' | Yes | NULL | Station Installation Types |
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
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_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 | |||
hi_type_enum | 'Water Thermometer','Air Thermometer','Water Level Sensor','Barometer','Discharge Sensor','Streamflow Sensor','Rain Gage','pH Meter','Conductivity Meter','Fields Sample','Lab Analysis','Acoustic Flow Monitor (AFM)','Pressure Transducer','Piezometer','Anemometer','Weather Radar' | Yes | NULL | Instrument Types | |||
hi_type_abbre | 'Water Therm.','Air Therm.','Level Sensor','Barometer','Discharge Sensor','Streamflow Sensor','Rain Gage','pH Meter','Conductivity Meter','Fields Sample','Lab Analysis','AFM','Press. Transducer','Piezometer','Anemometer','Weather Radar' | Yes | NULL | Instrument Types Abbreviation | |||
hi_install_place | 'In situ ground-based','Remote ground-based','Airborne/Satellite' | Yes | NULL | Installation Types |
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 | |||
hs_install_type | 'Permanent','Non-permanent' | Yes | NULL | Station Installation Types |
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
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
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_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 | |||
mi_type_enum | 'Thermal Sensor','Thermocouple','Thermostat','Wind Speed and Direction (Anemometer)','Precipitation Gauge (Pluviometer)','Barometer Pressure','Hygrometer','Humidity Sensor','Weather Radar (DOPPLER/NEXRAD)','Water Vapor Radiometer','Visual Camera (CCTV, WebCam, DSLR)','Others' | Yes | NULL | Instrument Types | |||
mi_type_abbre | 'Thermal Sensor','Thermocouple','Thermostat','Anemometer','Pluviometer','Barometer Pressure','Hygrometer','Humidity Sensor','Weather Radar','Water Vapor Radiometer','Visual Camera','Others' | Yes | NULL | Instrument Types Abbreviation | |||
mi_install_place | 'In situ ground-based','Remote ground-based','Airborne/Satellite' | Yes | NULL | Installation Types |
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 | |||
ms_install_type | 'Permanent','Non-permanent' | Yes | NULL | Station Installation Types |
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
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_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 | |||
si_type_enum | 'Short period seismometer','Broadband seismometer','Barometric sensor','Speaker sensor','Dilatometer','Accelerometer','Infrasound','Digitizer','Geophone','Hydrophone','Barometer','Acoustic sensor','Ocean bottom seismometer','Fiber Optic','Others' | Yes | NULL | Instrument Types | |||
si_type_abbre | 'Short period seismo','Broadband','Barometric','Speaker','Dilatometer','Accelerometer','Infrasound','Digitizer','Geophone','Hydrophone','Barometer','Acoustic','OBS','Fiber','Others' | Yes | NULL | Instrument Types Abbreviation | |||
si_tech_desc | varchar(255) | Yes | NULL | Description | |||
si_install_place | 'In situ ground-based','Remote ground-based','Airborne/Satellite' | Yes | NULL | Installation Types |
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 | |||
ss_install_type | 'Permanent','Non-permanent' | Yes | NULL | Station Installation Types |
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
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_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 | |||
ti_type_enum | 'Thermal Sensor','Thermostat','Thermocouple','Thermal camera','Thermal Infra-red (TIR)','Forward Looking Infra-Red (FLIR)','Radiometer','Doppler Radar system','Lightning detection system','Others' | Yes | NULL | Instrument Types | |||
ti_type_abbre | 'Thermal Sensor','Thermostat','Thermocouple','Camera','Infra-red','FLIR','Radiometer','Doppler Radar system','Lightning detection system','Others' | Yes | NULL | Instrument Types Abbreviation | |||
ti_desc | varchar(255) | Yes | NULL | Description | |||
ti_install_place | 'In situ ground-based','Remote ground-based','Airborne/Satellite' | Yes | NULL | Installation Types |
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 | |||
ts_install_type | 'Permanent','Non-permanent' | Yes | NULL | Station Installation Types |
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