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

Standard MagIC Data Format -- er_fossils 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 28 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 3 Expedition Name er_expedition_name Text Optional Name for seagoing or land expedition Examples are: AVON02MV
R 5 Formation Name er_formation_name Text Optional Name for formation Examples are: Bluebird Formation
E 18 Fossil Alteration fossil_alteration Text Optional Fossil alteration, Grade Examples are: Severe, High, Mild, Trace, Unaltered
E 19 Fossil Alteration Type fossil_alteration_type Text Optional Fossil alteration, Type Examples are: Hydrothermal, Diagenetic, Weathering, Oxidation, Metamorphic
N 11 Fossil Class fossil_class Text Required Fossil classification, Class Examples are: Branchiopoda, Calcarea, Camptostromoidea
23 Fossil Density fossil_density Number in kg/m3 Optional Fossil density
25 Fossil Description fossil_description Text Optional Detailed description
N 13 Fossil Family fossil_family Text Required Fossil classification, Family Examples are: Aceraceae, Mucoraceae
N 14 Fossil Genus fossil_genus Text Required Fossil classification, Genus Examples are: Acer, Canis, Rhizopus
24 Fossil IGSN Number fossil_igsn Text Optional International Geological Sample Number (IGSN) Examples are: SIO0A0987, SIO001317
P 1 Fossil Name er_fossil_name Text Required Name for fossil Examples are: AMM43-03
2 Fossil Name Alternatives er_fossil_alternatives Text Optional Colon-delimited list of alternative names and abbreviations
N 12 Fossil Order fossil_order Text Required Fossil classification, Order Examples are: Alcyonida, Strophomenida, Thecideida
N 10 Fossil Phylum fossil_phylum Text Required Fossil classification, Phylum Examples are: Chordata, Magnoliophyta, Zygomycota, Firmicutes, Chlorophyta
N 16 Fossil Preservation fossil_preservation Text Optional Fossil preservation Examples are: Pristine, Altered
20 Fossil Shape fossil_shape Text Optional Fossil shape
N 15 Fossil Species fossil_species Text Required Fossil classification, Species Examples are: A. Saccharum, R. Stolonifer
E 17 Fossil Texture fossil_texture Text Optional Fossil texture Examples are: Crystalline, Porous, Homogeneous
21 Fossil Volume fossil_volume Number in m3 Optional Fossil volume
22 Fossil Weight fossil_weight Number in kg Optional Fossil weight
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 6 Member Name er_member_name Text Optional Name for member Examples are: Glasshound Member
R 26 Method Codes magic_method_codes Text Recommended Colon-delimited list of method codes Examples are: DE-DC0, FT-F1, LP-DCDMAG
R 27 Research Scientist Names er_scientist_mail_names Text Recommended Colon-delimited list of names and emails for scientists who prepared fossil sample Examples are: Jim R.D. Hart , Alexis Heard :Bob McIntire
R 8 Sample Name er_sample_name Text Required Name for sample Examples are: Bas123a-01
R 7 Site Name er_site_name Text Required Name for site Examples are: Bas123a
R 9 Specimen Name er_specimen_name Text Required Name for specimen Examples are: Bas123a-01x
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