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

Standard MagIC Data Format -- pmag_results 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 1 Result Name pmag_result_name Text Required Name or number to identify results Examples are: MY-POLE-XX
R 2 Location Name List er_location_names Text Recommended Colon-delimited list of location, dredge or drill site names Examples are: Site 801, Site 1129, Dredge AMAT02-D15
R 3 Site Name List er_site_names Text Recommended Colon-delimited list of site names Examples are: Bas123a, Bas156z, Bas445c
R 4 Sample Name List er_sample_names Text Recommended Colon-delimited list of sample names Examples are: Bas123a-01, Bas123a-04, Bas123a-19
R 5 Specimen Name List er_specimen_names Text Recommended Colon-delimited list of specimen names Examples are: Bas123a-01x, Bas123a-01y
R 6 Fossil Name List er_fossil_names Text Recommended Colon-delimited list of fossil names Examples are: AMM43-03, AMM43-19
R 7 Mineral Name List er_mineral_names Text Recommended Colon-delimited list of mineral names Examples are: PLG33a, MAGN-MJ-034
R 8 Synthetic Material Name List er_synthetic_names Text Optional Colon-delimited list of synthetic material names Examples are: STD1546-A1, STD1546-X23
X 9 Experiment Name List magic_experiment_names Text Optional Colon-delimited list of experiments Examples are: KOPA-299-1, KOPA-299-2, KOPA-299-6
F 10 Data Type data_type Flag Required Individual (i, the default), average (a), model (m) or stacked (s) data
E 11 Fold Test fold_test Flag Recommended Classification and result of the folding test Examples are: F+, SF+, RF+, + (pos), Fo, SFo, RFo, o (indeterminate), F-, SF-, RF-, - (neg), ND (not done)
E 12 Conglomerate Test conglomerate_test Flag Recommended Classification and result of the (intra-formational) conglomerate test Examples are: G+, IG+, + (pos), Go, IGo, o (indeterminate), G-, IG-, - (neg), ND (not done)
E 13 Baked Contact Test contact_test Flag Recommended Classification and result of the (inverse) contact test Examples are: C+, IC+, + (pos), Co, ICo, o (indeterminate), C-, IC-, - (neg), ND (not done)
E 14 Reversal Test reversal_test Flag Recommended Classification and result of the reversal test Examples are: Ra, Rb, Rc, + (pos), Ro, o (indeterminate), R-, - (neg), ND (not done)
E 15 Rock Magnetic Test rock_magnetic_test Flag Recommended Classification and result of the various rock magnetic tests Examples are: M (done), ND (not done)
16 Pole Component Name pole_comp_name Text Recommended Name of magnetic component for which pole is calculated Examples are: Characteristic, VRM, Overprint, A, B, C
17 Average Latitude average_lat Number in Degrees Recommended Average location based on multiple sites, Latitude Examples are: Decimal degrees between -90 and 90
18 Average Latitude Sigma average_lat_sigma Number in Degrees Recommended Average location based on multiple sites, Latitude uncertainty Examples are: Uncertainty = 1xSD
19 Average Longitude average_lon Number in Degrees Recommended Average location based on multiple sites, Longitude Examples are: Decimal degrees between 0 and 360
20 Average Longitude Sigma average_lon_sigma Number in Degrees Recommended Average location based on multiple sites, Longitude uncertainty Examples are: Uncertainty = 1xSD
21 Average Height average_height Number in m Recommended Measurement stratigraphic height relative to reference height Examples are: Positive is up in section or core, negative is down
22 Average Age average_age Custom Recommended Average magnetization age based on multiple sites
23 Average Age Sigma average_age_sigma Custom Recommended Average magnetization age based on multiple sites, Uncertainty Examples are: Uncertainty = 1xSD
24 Average Age Low average_age_low Custom Recommended Average magnetization age based on multiple sites, Low range
25 Average Age High average_age_high Custom Recommended Average magnetization age based on multiple sites, High range
E 26 Average Age Unit average_age_unit Text Recommended Average magnetization age based on multiple sites, Unit Examples are: Ma, Ka, Ga, Years BP, Years AD (+/-), Years Cal BP, Years Cal AD (+/-)
27 Average Inclination average_inc Number in Degrees Recommended Average direction in stratigraphic coordinates, Inclination Examples are: Decimal degrees between -90 and 90
28 Average Declination average_dec Number in Degrees Recommended Average direction in stratigraphic coordinates, Declination Examples are: Decimal degrees between 0 and 360
29 Average Sigma average_sigma Number in Degrees Recommended Average direction in stratigraphic coordinates, Circular standard deviation Examples are: Uncertainty = 1xSD
30 Average Alpha 95% average_alpha95 Number in Degrees Recommended Average direction Fisher circle Examples are: Confidence Level = 95%
Redefined 31 Number of Independent Estimates average_n Integer Recommended Number of independent estimates included in directional calculations
32 Number of Samples average_nn Integer Recommended Number of samples included in directional calculations
33 Average K average_k Dimensionless Recommended Average direction Fisher's dispersion parameter Kappa
34 Average R average_r Dimensionless Recommended Average direction resultant Fisher vector
35 Average Intensity average_int Number in T Recommended Average field strength
36 Average Intensity Sigma average_int_sigma Number in T Recommended Average field strength, Uncertainty Examples are: Uncertainty = 1xSD
37 Average Intensity Sigma % average_int_sigma_perc Number in % Recommended Average field strength, Uncertainty in percent Examples are: Uncertainty = 1xSD
38 Average Intensity Relative average_int_rel Dimensionless Recommended Relative average field strength
39 Average Intensity Relative Sigma average_int_rel_sigma Dimensionless Recommended Relative average field strength, Uncertainty Examples are: Uncertainty = 1xSD
40 Average Intensity Relative Sigma % average_int_rel_sigma_perc Number in % Recommended Relative average field strength, Uncertainty in percent Examples are: Uncertainty = 1xSD
Redefined 41 Number of Independent Estimates average_int_n Integer Recommended Number of independent estimates included in intensity calculations
42 Number of Samples average_int_nn Integer Recommended Number of samples included in intensity calculations
43 Confidence Ellipse eta_inc Number in Degrees Recommended Definition of confidence ellipse, Inclination Examples are: Decimal degrees between -90 and 90
44 Confidence Ellipse eta_dec Number in Degrees Recommended Definition of confidence ellipse, Declination Examples are: Decimal degrees between 0 and 360
45 Confidence Ellipse eta_semi_angle Number in Degrees Recommended Definition of confidence ellipse, Semi angle Examples are: Confidence Level = 95%
46 Confidence Ellipse zeta_inc Number in Degrees Recommended Definition of confidence ellipse, Inclination Examples are: Decimal degrees between -90 and 90
47 Confidence Ellipse zeta_dec Number in Degrees Recommended Definition of confidence ellipse, Declination Examples are: Decimal degrees between 0 and 360
48 Confidence Ellipse zeta_semi_angle Number in Degrees Recommended Definition of confidence ellipse, Semi angle Examples are: Confidence Level = 95%
49 Model Latitude model_lat Number in Degrees Recommended Model latitude based on plate reconstruction Examples are: Decimal degrees between -90 and 90
50 Model Latitude Sigma model_lat_sigma Number in Degrees Recommended Model latitude based on plate reconstruction, Uncertainty Examples are: Uncertainty = 1xSD
51 Model Longitude model_lon Number in Degrees Recommended Model longitude based on plate reconstruction Examples are: Decimal degrees between -90 and 90
52 Model Longitude Sigma model_lon_sigma Number in Degrees Recommended Model longitude based on plate reconstruction, Uncertainty Examples are: Uncertainty = 1xSD
53 VGP Latitude vgp_lat Number in Degrees Recommended Virtual geomagnetic pole, Latitude Examples are: Decimal degrees between -90 and 90
54 VGP Longitude vgp_lon Number in Degrees Recommended Virtual geomagnetic pole, Longitude Examples are: Decimal degrees between 0 and 360
55 VGP DP vgp_dp Number in Degrees Recommended Virtual geomagnetic pole, Parallel latitude, Uncertainty Examples are: Uncertainty = 1xSD
56 VGP DM vgp_dm Number in Degrees Recommended Virtual geomagnetic pole, Meridian, Uncertainty Examples are: Uncertainty = 1xSD
57 VGP Sigma vgp_sigma Number in Degrees Recommended Virtual geomagnetic pole, Circular standard deviation Examples are: Uncertainty = 1xSD
58 VGP Alpha 95% vgp_alpha95 Number in Degrees Recommended Fisher circle Examples are: Confidence Level = 95%
59 VGP N vgp_n Integer Recommended Number of data points included in VGP calculations
60 VDM vdm Number in Am2 Recommended Virtual dipole moment
61 VDM Sigma vdm_sigma Number in Am2 Recommended Virtual dipole moment, Uncertainty Examples are: Uncertainty = 1xSD
62 VDM N vdm_n Integer Recommended Number of data points included in VDM calculations
63 VADM vadm Number in Am2 Recommended Virtual axial dipole moment
64 VADM Sigma vadm_sigma Number in Am2 Recommended Virtual axial dipole moment, Uncertainty Examples are: Uncertainty = 1xSD
65 VADM N vadm_n Integer Recommended Number of data points included in VADM calculations
66 Tilt Correction tilt_correction Number in % Optional Tilt correction applied to the data Examples are: Correction between geographic (0%) and stratigraphic (100%); unoriented (-1%); partially oriented to horizontal only (-2%)
67 Tilt K Ratio tilt_k_ratio Dimensionless Optional Comparison of Fisher dispersion K after and before tilt correction
68 Tilt N tilt_n Integer Optional Number of data points included in tilt correction
69 Tilt Corrected Inclination tilt_inc_corr Number in Degrees Optional Tilt corrected inclination Examples are: Decimal degrees between -90 and 90
70 Tilt Corrected Declination tilt_dec_corr Number in Degrees Optional Tilt corrected declination Examples are: Decimal degrees between 0 and 360
71 Tilt Corrected K tilt_k_corr Dimensionless Optional Average direction Fisher's dispersion parameter Kappa
72 Tilt Corrected Alpha 95% tilt_alpha95_corr Number in Degrees Optional Fisher circle Examples are: Confidence Level = 95%
73 Tilt Uncorrected Inclination tilt_inc_uncorr Number in Degrees Optional Tilt uncorrected inclination Examples are: Decimal degrees between -90 and 90
74 Tilt Uncorrected Declination tilt_dec_uncorr Number in Degrees Optional Tilt uncorrected declination Examples are: Decimal degrees between 0 and 360
75 Tilt Uncorrected K tilt_k_uncorr Dimensionless Optional Average direction Fisher's dispersion parameter Kappa
76 Tilt Uncorrected Alpha 95% tilt_alpha95_uncorr Number in Degrees Optional Fisher circle Examples are: Confidence Level = 95%
77 Fold Test Significance fold_test_significance Number in % Optional Significance level achieved in tilt correction calculations
78 Percentage Reversed Data percent_reversed Number in % Optional Percentage of sites and samples that is reversed Examples are: 200 indicates "mixed" polarity and negative numbers indicate "unknown" polarity
79 Antipodal Angle antipodal Number in Degrees Optional Great circle distance between normal and reversed poles Examples are: Decimal degrees between 0 and 180
80 Normal Pole Latitude normal_lat Number in Degrees Optional Normal pole, Latitude Examples are: Decimal degrees between -90 and 90
81 Normal Pole Longitude normal_lon Number in Degrees Optional Normal pole, Longitude Examples are: Decimal degrees between 0 and 360
82 Normal Inclination normal_inc Number in Degrees Optional Normal pole, Inclination Examples are: Decimal degrees between -90 and 90
83 Normal Declination normal_dec Number in Degrees Optional Normal pole, Declination Examples are: Decimal degrees between 0 and 360
84 Normal N normal_n Integer Optional Number of sites or samples included in normal pole calculation
85 Normal K normal_k Dimensionless Optional Average direction Fisher's dispersion parameter Kappa
86 Normal Alpha 95% normal_alpha95 Number in Degrees Optional Average direction Fisher circle Examples are: Confidence Level = 95%
87 Reversed Pole Latitude reversed_lat Number in Degrees Optional Reversed pole, Latitude Examples are: Decimal degrees between -90 and 90
88 Reversed Pole Longitude reversed_lon Number in Degrees Optional Reversed pole, Longitude Examples are: Decimal degrees between 0 and 360
89 Reversed Inclination reversed_inc Number in Degrees Optional Reversed pole, Inclination Examples are: Decimal degrees between -90 and 90
90 Reversed Declination reversed_dec Number in Degrees Optional Reversed pole, Declination Examples are: Decimal degrees between 0 and 360
91 Reversed N reversed_n Integer Optional Number of sites or samples included in reversed pole calculation
92 Reversed K reversed_k Dimensionless Optional Average direction Fisher's dispersion parameter Kappa
93 Reversed Alpha 95% reversed_alpha95 Number in Degrees Optional Average direction Fisher circle Examples are: Confidence Level = 95%
94 Result Description result_description Text Optional Detailed description of results
95 MagIC Software Packages magic_software_packages Text Recommended Colon-delimited list of software used for data reduction Examples are: PmagPy v1.67b, FORCinel v1.11
E 96 External Database Names external_database_names Text Optional Colon-delimited list of external databases where data are used Examples are: GEOMAGIA50, CALS7K.2, ARCHEO00
97 External Database ID Numbers external_database_ids Text Optional Colon-delimited list of ID numbers linking to external database records Examples are: 1435, 23, 2329
R 98 Criteria Codes pmag_criteria_codes Text Optional Colon-delimited list of criteria codes Examples are: MY-MAD, MY-APLHA95
R 99 Rotation Codes pmag_rotation_codes Text Optional Colon-delimited list of rotation codes Examples are: MY-TILT1, MY-TILT2, MY-TRANS1
R 100 Method Codes magic_method_codes Text Required Colon-delimited list of method codes Examples are: DE-DC0, FT-F1, LP-DCDMAG
R 101 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 102 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