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

Standard MagIC Data Format -- er_plots 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
P Inserted 1 Plot Name er_plot_name Text Required Name of plot Examples are: AnisoData.jpg
Inserted 2 Plot Name Alternatives er_plot_alternatives Text Optional Colon-delimited list of alternative names and abbreviations
R Inserted 3 Expedition Name er_expedition_name Text Optional Name for seagoing or land expedition Examples are: AVON02MV
R Inserted 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 Inserted 5 Formation Name er_formation_name Text Optional Name for formation Examples are: Bluebird Formation
R Inserted 6 Member Name er_member_name Text Optional Name for member Examples are: Glasshound Member
R Inserted 7 Site Name er_site_name Text Recommended Name for site Examples are: Bas123a
R Inserted 8 Sample Name er_sample_name Text Recommended Name for sample Examples are: Bas123a-01
R Inserted 9 Specimen Name er_specimen_name Text Recommended Name for specimen Examples are: Bas123a-01x
R Inserted 10 Fossil Name er_fossil_name Text Recommended Name for fossil Examples are: AMM43-03
R Inserted 11 Mineral Name er_mineral_name Text Recommended Name for mineral Examples are: San03-001
R Inserted 12 Synthetic Material Name er_synthetic_name Text Recommended Name for synthetic material Examples are: STD1546-A1
E Inserted 13 Plot Type plot_type Text Required Type of plot Examples are: Equal Area, Zijderveld, Demagnetization, Anisotropy Data, etc.
Inserted 14 Plot Title plot_title Text Required Short plot title Examples are: Anisotropy Confidence, Demagnetization in Specimen Coordinates, Equal Area in Tilt Corrected Coordinates
Inserted 15 Plot Keywords plot_keywords Text Recommended Colon delimited list of keywords associated with plot Examples are: Remanence, Zijderveld, PmagPy, Cryogenic Magnetometer
Inserted 16 Plot Description plot_description Text Recommended Detailed description
Inserted 17 Plot Date and Time plot_date Text Recommended Date and time of when the plot was made Examples are: Number in the "yyyy:mm:dd:hh:mm:ss.ss" format
Inserted 18 Plot Time Zone plot_time_zone Text Recommended Time zone Examples are: UTC, PDT, GMT
R Inserted 19 Analyst Names er_analyst_mail_names Text Recommended Colon-delimited list of names and emails for analysts Examples are: Jim R.D. Hart , Alexis Heard :Bob McIntire
R Inserted 20 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