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_Samples Table -- Version 2.5

F	N	Database Field	Variable Name	Units	Required	Description
All Tables Click to expand the Data Model Diagram
P	1	Sample Name	er_sample_name	Text	Required	Name for sample Examples are: Bas123a-01
	2	Sample Name Alternatives	er_sample_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
E	8	Sample Class	sample_class	Text	Required	Sample location class Examples are: Igneous, Sedimentary, Metamorphic, Archeological, Intrusive, Extrusive, Submarine, Subaerial
E	9	Sample Lithology	sample_lithology	Text	Required	Sample lithology or archeological classification Examples are: Basalt, Granite, Mudstone, Tuff, Granodiorite, Marl
E	10	Sample Type	sample_type	Text	Required	Sample type Examples are: Flow Top, Glassy Margin, Pot Rim, Pillow, Kiln, Dike
E	11	Sample Texture	sample_texture	Text	Optional	Sample texture Examples are: Holocrystalline, Hawaiitic, Homogeneous
E	12	Sample Alteration	sample_alteration	Text	Optional	Sample alteration, Grade Examples are: Severe, High, Mild, Trace, Unaltered
E	13	Sample Alteration Type	sample_alteration_type	Text	Optional	Sample alteration, Type Examples are: Hydrothermal, Diagenetic, Weathering, Oxidation, Metamorphic
	14	Sample Latitude	sample_lat	Number in Degrees	Required	Sample location, Latitude Examples are: Decimal degrees between -90 and 90
	15	Sample Longitude	sample_lon	Number in Degrees	Required	Sample location, Longitude Examples are: Decimal degrees between 0 and 360
	16	Sample Location Precision	sample_location_precision	Number in Degrees	Recommended	Sample location, Precision in latitude and longitude Examples are: Decimal degrees
E	17	Sample Location Geoid	sample_location_geoid	Text	Recommended	Sample location, Geoid used in determination of latitude and longitude Examples are: WGS84, GEOID03, USGG2003, GEOID99, G99SSS , G99BM, DEFLEC99
	18	Sample Elevation	sample_elevation	Number in m	Recommended	Sample location, Elevation relative to sealevel Examples are: Meters above sealevel
	19	Sample Stratigraphic Height	sample_height	Number in m	Recommended	Sample location, Stratigraphic height Examples are: Positive is up in section or core, while negative is down relative to reference height
	20	Sample Core Depth	sample_core_depth	Number in m	Optional	Sample location, Core depth in MBSF Examples are: Meters below seafloor
	21	Sample Composite Depth	sample_composite_depth	Number in m	Optional	Sample location, Composite depth in MBSF Examples are: Meters below seafloor
	22	Sample Date	sample_date	Text	Recommended	Sampling date Examples are: Number in the "yyyy:mm:dd:hh:mm:ss.ss" format
	23	Sample Time Zone	sample_time_zone	Text	Recommended	Sampling time zone Examples are: UTC, PDT, GMT
F	24	Sample Orientation Flag	sample_orientation_flag	Flag	Recommended	Indicating if good (g, the default) or bad (b) orientation data
	25	Sample Declination Correction	sample_declination_correction	Number in Degrees	Recommended	Declination correction applied while determining sample azimuth Examples are: Decimal degrees
	26	Sample Azimuth	sample_azimuth	Number in Degrees	Recommended	Sample azimuth as measured clockwise from the north Examples are: Decimal degrees between 0 and 360
	27	Sample Dip	sample_dip	Number in Degrees	Recommended	Sample dip as measured into the outcrop Examples are: Decimal degrees between -90 and 90
	28	Sample Bedding Dip Direction	sample_bed_dip_direction	Number in Degrees	Recommended	Direction of the dip of a paleo-horizontal plane in the bedding Examples are: Decimal degrees between 0 and 360
	29	Sample Bedding Dip	sample_bed_dip	Number in Degrees	Recommended	Dip of the bedding as measured to the right of strike direction Examples are: Decimal degrees between -90 and 90
	30	Sample Cooling Rate Estimate	sample_cooling_rate	Number in K/Ma	Optional	Estimated ancient in-situ cooling rate per Ma
	31	Sample IGSN Number	sample_igsn	Text	Optional	International Geological Sample Number (IGSN) Examples are: SIO0A0987, SIO001317
	32	Sample Description	sample_description	Text	Optional	Detailed description
R	33	Method Codes	magic_method_codes	Text	Recommended	Colon-delimited list of method codes Examples are: DE-DC0, FT-F1, LP-DCDMAG
R	34	Research Scientist Names	er_scientist_mail_names	Text	Recommended	Colon-delimited list of names and emails for scientists who took sample Examples are: Jim R.D. Hart , Alexis Heard :Bob McIntire
R	35	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