Search

Latest News

Volcanic Activity Report

Random Picture

Volcano

  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)      
         

Last Updated on 1/12/2004
By chris newhall