WOVOdat - GVMID

WOVOdat2.0 documentation

This page contains a full description of the database structure.

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

An offline version of this documentation is available here.

Updates

Latest updates to the database: to be added later

Click on red bars with field names to see Descriptions.

cb - Bibliographic

Description

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

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

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY cb_id

Links

Field Link to
cc_id_load cc.cc_id

Restrictions

None

cc - Contact

Description

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

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

Indexes

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

Links

None

Restrictions

None

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 Email
cr_tmp_fname varchar(30) Yes NULL First name
cr_tmp_lname varchar(30) Yes NULL Last name
cr_tmp_obs varchar(150) Yes NULL Observatory
cr_tmp_add1 varchar(60) Yes NULL Address 1
cr_tmp_add2 varchar(60) Yes NULL Address 2
cr_tmp_city varchar(50) Yes NULL City
cr_tmp_state varchar(30) Yes NULL State/Province
cr_tmp_country varchar(50) Yes NULL Country
cr_tmp_post varchar(30) Yes NULL Postal code
cr_tmp_url varchar(255) Yes NULL Web address
cr_tmp_phone varchar(50) Yes NULL Phone
cr_tmp_phone2 varchar(50) Yes NULL Phone 2
cr_tmp_fax varchar(60) Yes NULL Fax
cr_tmp_com varchar(255) Yes NULL Comments
cr_tmp_uname varchar(30) No Username
cr_tmp_pwd varchar(60) Yes NULL Password

Indexes

Keyname Type Field(s)
PRIMARY PRIMARY cr_tmp_id

Links

None

Restrictions

None

cs - Satellite/Airplane

Description

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

Field Type Attributes Null Default Extra Unit Comments
cs_id smallint(5) UNSIGNED No auto_increment satellite/ airplane ID
cs_code varchar(30) Yes NULL satellite/ airplane Code
cs_type enum('S', 'A') Yes NULL Type (A=Airplane, S=Satellite)
cs_name varchar(50) Yes NULL satellite/ airplane Name
cs_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