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

F	N	Database Field	Variable Name	Units	Required	Description
All Tables Click to expand the Data Model Diagram
	16	Age	age	Custom	Recommended	Age Examples are: Preferred age
N	31	Age Culture Name	age_culture_name	Text	Recommended	Age culture name Examples are: Halaf culture
	19	Age High	age_range_high	Custom	Optional	Age, High range
	18	Age Low	age_range_low	Custom	Optional	Age, Low range
	17	Age Sigma	age_sigma	Custom	Recommended	Age, Uncertainty Examples are: Uncertainty = 1xSD
E	20	Age Unit	age_unit	Text	Recommended	Age, Unit Examples are: Ma, Ka, Ga, Years BP, Years AD (+/-), Years Cal BP, Years Cal AD (+/-)
N	29	Astronomical Stage Name	astronomical_stage	Text	Recommended	Astronomical stage name Examples are: MIS 19
N	26	Biostratigraphic Zone	biostrat_zone	Text	Recommended	Biostratigraphic zone Examples are: NN10, Wasatchian
	11	Tiepoint Name Alternatives	tiepoint_alternatives	Text	Optional	Colon-delimited list of alternative names and abbreviations
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
R	34	Citation Names Timescale Definition	er_timescale_citation_names	Text	Recommended	Colon-delimited list of citation DOIs Examples are: 10.1029/92JB01202, 10.1029/2003GC000635:This study, "10.1023/A:1015035228810":This study
R	33	Method Codes	magic_method_codes	Text	Required	Colon-delimited list of method codes Examples are: DE-DC0, FT-F1, LP-DCDMAG
N	27	Conodont Zone	conodont_zone	Text	Recommended	Conodont zone Examples are: B. Triangularis
	32	Age Description	age_description	Text	Recommended	Detailed description
N	28	Magnetic Reversal Chron	magnetic_reversal_chron	Text	Recommended	Magnetic reversal chron Examples are: C5n, C5n.2n
R	3	Formation Name	er_formation_name	Text	Optional	Name for formation Examples are: Bluebird Formation
R	8	Fossil Name	er_fossil_name	Text	Recommended	Name for fossil Examples are: AMM43-03
R	2	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	4	Member Name	er_member_name	Text	Optional	Name for member Examples are: Glasshound Member
R	9	Mineral Name	er_mineral_name	Text	Recommended	Name for mineral Examples are: San03-001
R	6	Sample Name	er_sample_name	Text	Recommended	Name for sample Examples are: Bas123a-01
R	1	Expedition Name	er_expedition_name	Text	Optional	Name for seagoing or land expedition Examples are: AVON02MV
R	5	Site Name	er_site_name	Text	Recommended	Name for site Examples are: Bas123a
R	7	Specimen Name	er_specimen_name	Text	Recommended	Name for specimen Examples are: Bas123a-01x
	10	Tiepoint Name	tiepoint_name	Text	Recommended	Name for tiepoint horizon Examples are: San Cristobal Red bed
N	30	Oxygen Stage Name	oxygen_stage	Text	Recommended	Oxygen stage name Examples are: 5e, MIS 19, Younger Dryas
	14	Tiepoint Elevation	tiepoint_elevation	Number in m	Recommended	Tiepoint elevation relative to sealevel Examples are: Meters above sealevel
	12	Tiepoint Stratigraphic Height	tiepoint_height	Number in m	Recommended	Tiepoint stratigraphic height relative to reference tiepoint Examples are: Positive is up in section or core, while negative is down relative to reference height
	13	Tiepoint Stratigraphic Height Sigma	tiepoint_height_sigma	Number in m	Recommended	Tiepoint stratigraphic height uncertainty Examples are: Uncertainty = 1xSD
	15	Tiepoint Type	tiepoint_type	Text	Recommended	Tiepoint type Examples are: Fossil Layer, Volcanic Tuff, Basalt Flow, Magnetic Anomaly
E	21	Timescale Eon	timescale_eon	Text	Recommended	Timescale Eon Examples are: Phanerozoic, Proterozoic, Archean
E	24	Timescale Epoch	timescale_epoch	Text	Recommended	Timescale Epoch Examples are: Late Triassic, Early Cretaceous, Eocene, Miocene, Pleistocene
E	22	Timescale Era	timescale_era	Text	Recommended	Timescale Era Examples are: Neoproterozoic, Paleozoic, Mesozoic, Cenozoic
E	23	Timescale Period	timescale_period	Text	Recommended	Timescale Period Examples are: Devonian, Permian, Cretaceous, Paleocene
E	25	Timescale Stage	timescale_stage	Text	Recommended	Timescale Stage Examples are: Maastrichtian, Oxfordian, Frasnian
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