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.0

F	Status	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	Required	Name for seagoing or land expedition Examples are: AVON02MV
R		4	Location Name	er_location_name	Text	Required	Name for location or drill site Examples are: San Francisco Volcanic Province, Site 801
R		5	Formation Name	er_formation_name	Text	Required	Name for formation Examples are: Bluebird Formation
R		6	Member Name	er_member_name	Text	Required	Name for member Examples are: Glasshound Member
R	Deleted	7	Section Name	er_section_name	Text	Required	Name for section or core Examples are: Berkeley Lava Flows, 810C, 1129D
R		8	Site Name	er_site_name	Text	Required	Name for site Examples are: Bas123a
E		9	Sample Class	sample_class	Text	Required	General lithology type Examples are: Igneous, Sedimentary, Metamorphic, Archeological, Intrusive, Extrusive
E	Redefined	10	Sample Lithology	sample_lithology	Text	Required	Sample lithology or archeological classification Examples are: Basalt, Granite, Mudstone, Tuff, Granodiorite, Marl
N		11	Sample Type	sample_type	Text	Required	Sample type Examples are: Flow Top, Glassy Margin, Pot Rim, Pillow, Kiln, Dike
N		12	Sample Texture	sample_texture	Text	Optional	Sample texture Examples are: Holocrystalline, Hawaiitic, Homogeneous
E		13	Sample Alteration	sample_alteration	Text	Optional	Sample alteration grade Examples are: Severe, High, Mild, Trace, Unaltered
E		14	Sample Alteration Type	sample_alteration_type	Text	Optional	Sample alteration type Examples are: Hydrothermal, Diagenetic, Weathering, Oxidation, Metamorphic
		15	Sample Latitude	sample_lat	Number in Degrees	Required	Sample location: latitude Examples are: Decimal degrees between -90 and 90
		16	Sample Longitude	sample_lon	Number in Degrees	Required	Sample location: longitude Examples are: Decimal degrees between 0 and 360
		17	Sample Location Precision	sample_location_precision	Number in Degrees	Recommended	Sample location: precision in latitude and longitude Examples are: Decimal degrees
		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 Drill Depth	sample_drill_depth	Number in m	Optional	Sample location: depth in MBSF as used by ODP Examples are: Meters below seafloor
		21	Sample Composite Depth	sample_composite_depth	Number in m	Optional	Sample location: composite depth in MBSF as used by ODP 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
		24	Sample Azimuth	sample_azimuth	Number in Degrees	Recommended	Sample azimuth as measured clockwise from the north Examples are: Decimal degrees between 0 and 360
		25	Sample Dip	sample_dip	Number in Degrees	Recommended	Sample dip as measured into the outcrop Examples are: Decimal degrees between -90 and 90
		26	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
		27	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
		28	Sample Cooling Rate Estimate	sample_cooling_rate	Number in K/Ma	Optional	Estimated ancient in-situ cooling rate per Ma
		29	Sample Description	sample_description	Text	Optional	Detailed description
R		30	Method Codes	magic_method_codes	Text	Recommended	Colon-delimited list of method codes Examples are: DE-DC0, FT-F1, LP-DCDMAG
R		31	Research Scientist Names	er_scientist_mail_names	Text	Recommended	Colon-delimited list of names for scientists who took sample Examples are: Jim R.D. Hart, Alexis Heard, Bob McIntire
R		32	Citation Names	er_citation_names	Text	Required	Colon-delimited list of citations Examples are: Smith et al. 2003, Hart & Heard 1967, 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