|
ERUPTION DATA |
|
|
|
Attribute |
Attribute Name |
Description |
Format |
Units |
|
|
|
|
|
Eruption Overview (summary) |
|
|
|
|
ed_sum_id |
Eruption data id |
An identifier for linking with other tables |
Autonumber |
|
vd_vol_id |
Volcano id |
Volcano id |
mediumint |
|
ed_sum_nar |
Narrative of eruption (if any) |
Narrative of eruption (if any) from the Smithsonian |
varchar(255) |
|
ed_sum_name |
Name of the eruption |
Name of the eruption |
varchar(60) |
|
ed_sum_stime |
Start time of eruption |
Start time of eruption in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
ed_sum_ftime |
End time of eruption |
End time of eruption in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
ed_sum_climax |
Onset of eruption climax |
Onset of eruption climax in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
ed_sum_comments |
Comments |
Comments on the eruption |
varchar(255) |
|
cc_id |
Contact ID |
An identifier for linking to contact information. |
mediumint |
|
ed_sum_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 |
|
|
|
|
|
|
Eruption Phase |
|
|
|
|
ed_phs_id |
Eruption phase id |
An identifier for linking with other tables |
autonumber |
|
vd_vol_id |
Volcano id |
An identifier for linking with information in the volcano table. |
mediumint |
|
ed_phs_phsnum |
Phase number |
The observatory defined phase number starting with number 1 for the first phase of the eruption. |
mediumint |
|
ed_phs_stime |
Start time |
The start time of this phase in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
ed_phs_ftime |
End time |
The end time of this phase in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
ed_phs_char |
Description |
A description of the eruption characteristics for this phase (use climax for the climax of the eruption for search purposes). |
varchar(255) |
|
ed_phs_vei |
VEI, this phase |
The volcano explosivity index (VEI) for this phase. |
mediumint |
|
ed_phs_max_lext |
Max lava extrusion rate |
Maximum lava extrusion rate |
xxxx.xx |
m3/s |
ed_phs_max_expdis |
Max explosive mass discharge rate |
Max explosive mass discharge rate |
xxxx.xx |
kg/s x 10^6 |
ed_phs_voldre |
DRE |
Volume of material erupted, DRE |
xxxxx.xx |
m3 x 10^6 |
ed_phs_mix |
Evidence of magma mixing? |
Evidence of magma mixing? Use the terms "Yes, No, no info". |
Y/N/- |
|
ed_phs_minsio2_mg |
Minimum SiO2 of matrix glass |
Minimum SiO2 of matrix glass as a weight percent with two decimal places |
xx.xx |
wt % |
ed_phs_maxsio2_mg |
Maximum SiO2 of matrix glass |
Maximum SiO2 of matrix glass |
xx.xx |
wt % |
ed_phs_minsio2_wr |
Minimum SiO2 of whole rock |
Minimum SiO2 of whole rock |
xx.xx |
wt % |
ed_phs_maxsio2_wr |
Maximum SiO2 of whole rock |
Maximum SiO2 of whole rock |
xx.xx |
wt % |
ed_phs_dr_phencnt |
Phenocryst content, dominant rock |
Phenocryst content, dominant rock |
xx |
vol % |
ed_phs_dr_totxtl |
Total crystallinity, dominant rock |
Total crystallinity, dominant rock |
xx |
vol % |
ed_phs_comments |
Comments |
Additional information on this eruptive phase. |
varchar(255) |
|
cc_id |
Contact ID |
An identifier for linking to contact information. |
mediumint |
|
ed_phs_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 |
|
|
|
|
|
|
Video Information |
|
|
|
|
ed_vid_id |
Video id |
An identifier for linking with other tables |
autonumber |
|
vd_vol_id |
Volcano id |
An identifier for linking with information in the volcano table. |
mediumint |
|
ed_phs_id |
eruption phase id |
The identifier for linking to eruption information |
mediumint |
|
ed_vid_video |
video clip |
Video clip of this phase (if avail.) or pointer |
media or pointer |
|
ed_vid_time |
Time of video clip start |
Time of video clip start in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
ed_vid_length |
Length of video clip |
Length of video clip |
xxx:xx |
min:sec |
ed_vid_comment |
comments |
Information about video including copyright information |
varchar(255) |
|
cc_id |
Contact ID |
An identifier for linking to contact information. |
mediumint |
|
ed_vid_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 |
|
|
|
|
|
|
Forecasts |
|
|
|
|
ed_for_id |
forecast id |
An identifier for linking with other tables |
autonumber |
|
vd_vol_id |
Volcano id |
Volcano id |
mediumint |
|
ed_phs_id |
eruption phase id |
The identifier for linking to eruption information |
mediumint |
|
ed_for_desc |
Forecast type, magnitude |
What was forecast of this phase? |
varchar(255) |
|
ed_for_open |
Forecast window opens |
Earliest start time in forecast in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
ed_for_close |
Forecast window closes |
Latest start time in forecast in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
ed_for_issue |
Forecast issue date |
When was the forecast issued in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
ed_for_comments |
Forecast comments |
Any comments or additional information about the forecast. |
varchar(255) |
|
cc_id |
Contact ID |
An identifier for linking to contact information. |
mediumint |
|
ed_for_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 |
|
|
|
|
|
|