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

Standard MagIC Data Format -- er_minerals 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
2 Mineral Name Alternatives er_mineral_alternatives Text Optional Colon-delimited list of alternative names and abbreviations
R 25 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 23 Method Codes magic_method_codes Text Recommended Colon-delimited list of method codes Examples are: DE-DC0, FT-F1, LP-DCDMAG
R 24 Research Scientist Names er_scientist_mail_names Text Recommended Colon-delimited list of names and emails for scientists who prepared mineral sample Examples are: Jim R.D. Hart , Alexis Heard :Bob McIntire
22 Mineral Description mineral_description Text Optional Detailed description
21 Mineral IGSN Number mineral_igsn Text Optional International Geological Sample Number (IGSN) Examples are: SIO0A0987, SIO001317
E 14 Mineral Alteration mineral_alteration Text Optional Mineral alteration, Grade Examples are: Severe, High, Mild, Trace, Unaltered
E 15 Mineral Alteration Type mineral_alteration_type Text Optional Mineral alteration, Type Examples are: Hydrothermal, Diagenetic, Weathering, Oxidation, Metamorphic
E 13 Mineral Assemblage mineral_assemblage Text Optional Mineral assemblage Examples are: Single Crystal, Mineral Separate, Polycrystalline, In Situ
E 12 Mineral Classification Name mineral_class_name Text Required Mineral classification name Examples are: Magnetite, Plagioclase
20 Mineral Density mineral_density Number in kg/m3 Optional Mineral density
17 Mineral Size mineral_size Text Optional Mineral grain size fraction Examples are: 250-500 ¿m
16 Mineral Shape mineral_shape Text Optional Mineral shape Examples are: Euhedral, Orthorhombic
E 11 Mineral Type mineral_type Text Required Mineral type Examples are: Phenocryst, Microcryst, Groundmass, Biogenic, Detrital Clasts
18 Mineral Volume mineral_volume Number in m3 Optional Mineral volume
19 Mineral Weight mineral_weight Number in kg Optional Mineral weight
R 5 Formation Name er_formation_name Text Optional Name for formation Examples are: Bluebird Formation
R 10 Fossil Name er_fossil_name Text Required Name for fossil Examples are: AMM43-03
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
P 1 Mineral Name er_mineral_name Text Required Name for natural occurring mineral Examples are: San03-001
R 8 Sample Name er_sample_name Text Required Name for sample Examples are: Bas123a-01
R 3 Expedition Name er_expedition_name Text Optional Name for seagoing or land expedition Examples are: AVON02MV
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