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

Standard MagIC Data Format -- ER_Ages Table -- Version 2.5
All Tables
Click to expand the Data Model Diagram
MagIC Data Model
F Status N Database Field Variable Name Units Required Description
R 1 Expedition Name er_expedition_name Text Optional Name for seagoing or land expedition Examples are: AVON02MV
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 3 Formation Name er_formation_name Text Optional Name for formation Examples are: Bluebird Formation
R 4 Member Name er_member_name Text Optional Name for member Examples are: Glasshound Member
R 5 Site Name er_site_name Text Recommended Name for site Examples are: Bas123a
R 6 Sample Name er_sample_name Text Recommended Name for sample Examples are: Bas123a-01
R 7 Specimen Name er_specimen_name Text Recommended Name for specimen Examples are: Bas123a-01x
R 8 Fossil Name er_fossil_name Text Recommended Name for fossil Examples are: AMM43-03
R 9 Mineral Name er_mineral_name Text Recommended Name for mineral Examples are: San03-001
10 Tiepoint Name tiepoint_name Text Recommended Name for tiepoint horizon Examples are: San Cristobal Red bed
11 Tiepoint Name Alternatives tiepoint_alternatives Text Optional Colon-delimited list of alternative names and abbreviations
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
14 Tiepoint Elevation tiepoint_elevation Number in m Recommended Tiepoint elevation relative to sealevel Examples are: Meters above sealevel
15 Tiepoint Type tiepoint_type Text Recommended Tiepoint type Examples are: Fossil Layer, Volcanic Tuff, Basalt Flow, Magnetic Anomaly
16 Age age Custom Recommended Age Examples are: Preferred age
17 Age Sigma age_sigma Custom Recommended Age, Uncertainty Examples are: Uncertainty = 1xSD
18 Age Low age_range_low Custom Optional Age, Low range
19 Age High age_range_high Custom Optional Age, High range
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 (+/-)
E 21 Timescale Eon timescale_eon Text Recommended Timescale Eon Examples are: Phanerozoic, Proterozoic, Archean
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 24 Timescale Epoch timescale_epoch Text Recommended Timescale Epoch Examples are: Late Triassic, Early Cretaceous, Eocene, Miocene, Pleistocene
E 25 Timescale Stage timescale_stage Text Recommended Timescale Stage Examples are: Maastrichtian, Oxfordian, Frasnian
N 26 Biostratigraphic Zone biostrat_zone Text Recommended Biostratigraphic zone Examples are: NN10, Wasatchian
N 27 Conodont Zone conodont_zone Text Recommended Conodont zone Examples are: B. Triangularis
N 28 Magnetic Reversal Chron magnetic_reversal_chron Text Recommended Magnetic reversal chron Examples are: C5n, C5n.2n
N 29 Astronomical Stage Name astronomical_stage Text Recommended Astronomical stage name Examples are: MIS 19
N 30 Oxygen Stage Name oxygen_stage Text Recommended Oxygen stage name Examples are: 5e, MIS 19, Younger Dryas
N 31 Age Culture Name age_culture_name Text Recommended Age culture name Examples are: Halaf culture
32 Age Description age_description Text Recommended Detailed description
R 33 Method Codes magic_method_codes Text Required Colon-delimited list of method codes Examples are: DE-DC0, FT-F1, LP-DCDMAG
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 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
Click to return to previous page