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

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