Magnetics Information Consortium (MagIC) -- Standard MagIC Data Format -- ER

Magnetics Information Consortium (MagIC)
Development and Maintenance by the EarthRef.org Database Team

Standard MagIC Data Format -- ER_Specimens Table -- Version 2.5

F	N	Database Field	Variable Name	Units	Required	Description
All Tables Click to expand the Data Model Diagram
P	1	Specimen Name	er_specimen_name	Text	Required	Name for specimen Examples are: Bas123a-01x
	2	Specimen Name Alternatives	er_specimen_alternatives	Text	Optional	Colon-delimited list of alternative names and abbreviations
R	3	Expedition Name	er_expedition_name	Text	Optional	Name for seagoing or land expedition Examples are: AVON02MV
R	4	Location Name	er_location_name	Text	Required	Name for location, dredge or drill site Examples are: San Francisco Volcanic Province, Dredge AMAT02-D12, Site 801
R	5	Formation Name	er_formation_name	Text	Optional	Name for formation Examples are: Bluebird Formation
R	6	Member Name	er_member_name	Text	Optional	Name for member Examples are: Glasshound Member
R	7	Site Name	er_site_name	Text	Required	Name for site Examples are: Bas123a
R	8	Sample Name	er_sample_name	Text	Required	Name for sample Examples are: Bas123a-01
E	9	Specimen Class	specimen_class	Text	Required	Specimen location class Examples are: Igneous, Sedimentary, Metamorphic, Archeological, Intrusive, Extrusive, Submarine, Subaerial
E	10	Specimen Lithology	specimen_lithology	Text	Required	Specimen lithology or archeological classification Examples are: Basalt, Granite, Mudstone, Tuff, Granodiorite, Marl
E	11	Specimen Type	specimen_type	Text	Required	Specimen type Examples are: Flow Top, Glassy Margin, Pot Rim, Pillow, Kiln, Dike
E	12	Specimen Texture	specimen_texture	Text	Optional	Specimen texture Examples are: Holocrystalline, Hawaiitic, Homogeneous
E	13	Specimen Alteration	specimen_alteration	Text	Optional	Specimen alteration, Grade Examples are: Severe, High, Mild, Trace, Unaltered
E	14	Specimen Alteration Type	specimen_alteration_type	Text	Optional	Specimen alteration, Type Examples are: Hydrothermal, Diagenetic, Weathering, Oxidation, Metamorphic
	15	Specimen Elevation	specimen_elevation	Number in m	Recommended	Specimen location, Elevation relative to sealevel Examples are: Meters above sealevel
	16	Specimen Stratigraphic Height	specimen_height	Number in m	Recommended	Specimen location, Stratigraphic height Examples are: Positive is up in section or core, while negative is down relative to reference height
	17	Specimen Core Depth	specimen_core_depth	Number in m	Optional	Specimen location, Core depth in MBSF Examples are: Meters below seafloor
	18	Specimen Composite Depth	specimen_composite_depth	Number in m	Optional	Specimen location, Composite depth in MBSF Examples are: Meters below seafloor
	19	Specimen Azimuth	specimen_azimuth	Number in Degrees	Recommended	Specimen azimuth as measured clockwise from the north Examples are: Decimal degrees between 0 and 360
	20	Specimen Dip	specimen_dip	Number in Degrees	Recommended	Specimen dip as measured into the outcrop Examples are: Decimal degrees between -90 and 90
	21	Specimen Volume	specimen_volume	Number in m3	Recommended	Specimen volume
	22	Specimen Weight	specimen_weight	Number in kg	Recommended	Specimen weight
	23	Specimen Density	specimen_density	Number in kg/m3	Recommended	Specimen density
	24	Specimen Grain Size	specimen_size	Text	Recommended	Specimen grain size fraction Examples are: 25-125 ¿m, 250-500 ¿m
	25	Specimen Grain Shape	specimen_shape	Text	Recommended	Specimen shape Examples are: Cube, Cylinder, Single Crystal, Chip
	26	Specimen IGSN Number	specimen_igsn	Text	Optional	International Geological Sample Number (IGSN) Examples are: SIO0A0987, SIO001317
	27	Specimen Description	specimen_description	Text	Optional	Detailed description
R	28	Method Codes	magic_method_codes	Text	Recommended	Colon-delimited list of method codes Examples are: DE-DC0, FT-F1, LP-DCDMAG
R	29	Research Scientist Names	er_scientist_mail_names	Text	Recommended	Colon-delimited list of names and emails for scientists who prepared specimen Examples are: Jim R.D. Hart , Alexis Heard :Bob McIntire
R	30	Citation Names	er_citation_names	Text	Required	Colon-delimited list of citation DOIs Examples are: 10.1029/92JB01202, 10.1029/2003GC000635:This study, "10.1023/A:1015035228810":This study
Standard MagIC Data Format v2.0 Standard MagIC Data Format v2.1 Standard MagIC Data Format v2.2 Standard MagIC Data Format v2.3 Standard MagIC Data Format v2.4 Standard MagIC Data Format v2.5