Search

Latest News

Volcanic Activity Report

Random Picture

Eruption

  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  
         

Last Updated on 1/12/2004
By chris newhall