|
VOLCANO DATA |
|
|
|
Attribute |
Attribute Name |
Description |
Format |
Units |
Volcano |
|
The information in this table should not change so all information can link here. |
|
|
vd_vol_id |
volcano id |
An identifier for linking with other tables |
autonumber |
|
vd_vol_name |
Volcano name |
The name of the volcano |
varchar(30) |
|
vd_vol_tzone |
Time zone |
Time zone relative to UTC - "s" = sign; read as GMT +- xx h. |
sxx.x |
h |
vd_vol_loaddate |
Load date |
The date this row was entered |
datetime |
|
cc_id_load |
Data loader ID |
The id linking to the person who entered this row of data |
mediumint |
|
|
|
|
|
|
|
|
|
|
|
Volcano Information |
|
The information in this volcano table can change. We have added two date markers to define when the data is valid. |
|
|
vd_vin_id |
volcano information id |
An identifier for linking with other tables |
autonumber |
|
vd_vol_id |
volcano id |
The identifier for linking to the volcano information |
mediumint |
|
vd_vin_cavw |
CAVW Number |
The CAVW number from the Smithsonian |
nn-nn-nnn |
|
vd_vin_desc |
Short narrative |
A short narrative about the volcano and its history |
varchar(255) |
|
vd_vin_slat |
Latitude, summit |
The summit latitude from the Smithsonian. "s" = sign; positive = N |
sxx.xxxxxxx |
deg lat |
vd_vin_slon |
Longitude, summit |
The summit longitude from the Smithsonian - "s" = sign; positive = E |
sxxx.xxxxxxx |
deg long |
vd_vin_datum |
Datum |
The datum used for the longitude and latitude. |
varchar(30) |
|
vd_vin_selev |
Elevation of summit |
The summit elevation from the Smithsonian - "s" = sign; positive=above sea level |
sxxxx |
m |
vd_vin_type |
Volcano type |
The type of volcano from the Smithsonian. This field will ist all types in the order of primary through secondary. |
varchar(255) |
|
vd_vin_evol |
Volume of edifice |
The volume of the edifice |
xx.x |
km3 |
vd_vin_numcald |
No. of calderas present? |
The number of calderas present |
float |
|
vd_vin_lcald_dia |
Diameter of largest caldera |
The diameter of the largest caldera or crater. |
xxx.x |
km |
vd_vin_ycald_lat |
Latitude of youngest caldera |
The latitude of youngest caldera |
sxx.xxxxxxx |
deg lat |
vd_vin_ycald_lon |
Longitude of youngest caldera |
The longitude of youngest caldera |
sxxx.xxxxxxx |
deg long |
vd_vin_stime |
Valid from time (start time) |
The time the data became valid or was measured in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). If the data needs to be updated then this field will help find information about the volcano for the time period requested. |
datetime |
|
vd_vin_etime |
Valid to time (end time) |
The time the data changed in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). This field will be null if the data is still valid. |
datetime |
|
vd_vin_loaddate |
Load date |
The date this row was entered |
datetime |
|
cc_id_load |
Data loader ID |
The id linking to the person who entered this row of data |
mediumint |
|
|
|
|
|
|
Magma Chamber |
|
|
|
|
vd_mag_id |
magma chamber id |
An identifier for linking with other tables |
autonumber |
|
vd_vol_id |
volcano id |
The identifier for linking to the volcano information |
mediumint |
|
vd_mag_lvz_dia |
Diameter of low velocity zone |
The diameter of low velocity zone |
xxx |
km |
vd_mag_lvz_vol |
Volume of low velocity zone |
The volume of low velocity zone |
xxxx |
km3 |
vd_mag_tlvz |
Top of l.v. zone |
Depth to top of low velocity zone |
xx |
km |
vd_mag_lerup_vol |
Vol of largest eruption |
The volume of the largest eruption (DRE) |
xxxx.xxx |
km3 |
vd_mag_drock_type |
Dominant rock type |
Dominant rock type |
varchar(60) |
|
vd_mag_orock_type |
Outlier rock type |
Outlier rock type |
varchar(60) |
|
vd_mag_orock_type2 |
Outlier rock type 2 |
Outlier rock type |
varchar(60) |
|
vd_mag_orock_type3 |
Outlier rock type 3 |
Outlier rock type |
varchar(60) |
|
vd_mag_minsio2 |
Minimum SiO2 |
Minimum SiO2 |
xx.xx |
wt % |
vd_mag_maxsio2 |
Maximum SiO2 |
Maximum SiO2 |
xx.xx |
wt % |
vd_mag_comm |
Comments |
Comments or a description of the magma chamber |
varchar(255) |
|
vd_mag_loaddate |
Load date |
The date this row was entered |
datetime |
|
cc_id_load |
Data loader ID |
The id linking to the person who entered this row of data |
mediumint |
|
|
|
|
|
|
Tectonic setting |
|
|
|
|
vd_tec_id |
tectonic setting id |
An identifier for linking with other tables |
autonumber |
|
vd_vol_id |
volcano id |
The identifier for linking to the volcano information |
mediumint |
|
vd_tec_desc |
Local tectonic setting |
Information about the local tectonic setting |
varchar(255) |
|
vd_tec_strslip |
Rate of strike-slip |
Rate of arc- or ridge- parallel strike-slip |
xx.x |
cm/y |
vd_tec_ext |
Rate of extension |
Rate of extension |
xx.x |
cm/y |
vd_tec_conv |
Rate of convergence |
Rate of convergence |
xx.x |
cm/y |
vd_tec_travhs |
Travel rate across hotspot |
Travel rate across hotspot |
xx.x |
cm/y |
vd_tec_comm |
Comments |
Comments about the tectonic setting |
varchar(255) |
|
vd_tec_loaddate |
Load date |
The date this row was entered |
datetime |
|
cc_id_load |
Data loader ID |
The id linking to the person who entered this row of data |
mediumint |
|
|
|
|
|
|
BASE MAPS |
|
|
|
|
md_map_id |
map id |
An identifier for linking with other tables |
mediumint |
|
md_map_name |
map name |
The name of the map |
text |
|
md_map_type |
map type |
The type of map (topo, DEM, etc.) |
text |
|
md_map_scale |
scale |
The scale of the map |
1:xxxxxxx |
|
md_map_date |
date |
The date the map was published |
yyyy |
|
md_map_proj |
projection |
The map projection |
text |
|
mp_map_datum |
Datum |
The datum used for the longitude and latitude. |
varchar(30) |
|
md_map_nwlat |
NW lat |
The latitude of the NW or upper left cnr |
sxx.xxxxxxx |
deg lat |
md_map_nwlon |
NW lon |
The longitude of the NW or upper left cnr |
sxxx.xxxxxxx |
deg long |
md_map_swlat |
SW lat |
The latitude of the SW or lower right cnr |
sxx.xxxxxxx |
deg lat |
md_map_swlon |
SW lon |
The longitude of SW or lower right cnr |
sxxx.xxxxxxx |
deg long |
md_map_nelat |
NE lat |
The latitude of the NE or upper right cnr |
sxx.xxxxxxx |
deg lat |
md_map_nelon |
NE lon |
The longitude of the NE or upper right cnr |
sxxx.xxxxxxx |
deg long |
md_map_selat |
SE lat |
The latitude of the SE or lower right cnr |
sxx.xxxxxxx |
deg lat |
md_map_selon |
SE lon |
The longitude of the SE or lower right cnr |
sxxx.xxxxxxx |
deg long |
md_map_pointer |
Pointer to map |
A pointer to the location of the map |
link or address |
|
md_map_desc |
description |
A description of the map |
varchar(255) |
|
cc_id |
Contact ID |
An identifier for linking to contact information. |
mediumint |
|
mp_map_loaddate |
Load date |
The date this row was entered |
datetime |
|
cc_id_load |
Data loader ID |
The id linking to the person who entered this row of data |
mediumint |
|
|
|
|
|
|
|
(Note: DEM's might or might not be stored on WOVOdat server; tbd)
|
|
|
|
|
|
|
|
|