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

Standard MagIC Data Format -- PMAG_Results Table -- Version 2.0
All Tables
Click to expand the Data Model Diagram
MagIC Data Model
F Status N Database Field Variable Name Units Required Description
R 96 Citation Names er_citation_names Text Required Colon-delimited list of citations Examples are: Smith et al. 2003, Hart & Heard 1967, This study
R 95 Analyst Names er_analyst_mail_names Text Required Colon-delimited list of names for analysts Examples are: Jim R.D. Hart, Alexis Heard, Bob McIntire
R 94 Method Codes magic_method_codes Text Required Colon-delimited list of method codes Examples are: DE-DC0, FT-F1, LP-DCDMAG
R 93 Rotation Codes pmag_rotation_codes Text Optional Colon-delimited list of rotation codes Examples are: MY-TILT1, MY-TILT2, MY-TRANS1
R 92 Criteria Codes pmag_criteria_codes Text Optional Colon-delimited list of criteria codes Examples are: MY-MAD, MY-APLHA95
91 Result Description result_description Text Optional Detailed description of results
90 IAGA Database Result Number iaga_res_no Integer Optional IAGA7 database: internal record number of result
89 IAGA Database Name iaga_database Text Optional IAGA7 database: name Examples are: ARCHEO, PGMDB, PINT, PSVRL, SECVR, TRANS
88 Reversed Alpha 95% reversed_alpha95 Number in Degrees Optional Average direction Fisher circle Examples are: Confidence Level = 95%
87 Reversed K reversed_k Dimensionless Optional Average direction Fisher's dispersion parameter Kappa
86 Reversed N reversed_n Integer Optional Number of sites or samples included in reversed pole calculation
85 Reversed Declination reversed_dec Number in Degrees Optional Reversed pole: declination Examples are: Decimal degrees between 0 and 360
84 Reversed Inclination reversed_inc Number in Degrees Optional Reversed pole: inclination Examples are: Decimal degrees between -90 and 90
83 Reversed Pole Longitude reversed_lon Number in Degrees Optional Reversed pole: longitude Examples are: Decimal degrees between 0 and 360
82 Reversed Pole Latitude reversed_lat Number in Degrees Optional Reversed pole: latitude Examples are: Decimal degrees between -90 and 90
81 Normal Alpha 95% normal_alpha95 Number in Degrees Optional Average direction Fisher circle Examples are: Confidence Level = 95%
80 Normal K normal_k Dimensionless Optional Average direction Fisher's dispersion parameter Kappa
79 Normal N normal_n Integer Optional Number of sites or samples included in normal pole calculation
78 Normal Declination normal_dec Number in Degrees Optional Normal pole: declination Examples are: Decimal degrees between 0 and 360
77 Normal Inclination normal_inc Number in Degrees Optional Normal pole: inclination Examples are: Decimal degrees between -90 and 90
76 Normal Pole Longitude normal_lon Number in Degrees Optional Normal pole: longitude Examples are: Decimal degrees between 0 and 360
75 Normal Pole Latitude normal_lat Number in Degrees Optional Normal pole: latitude Examples are: Decimal degrees between -90 and 90
74 Antipodal Angle antipodal Number in Degrees Optional Great circle distance between normal and reversed poles Examples are: Decimal degrees between 0 and 180
73 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
72 Fold Test Significance fold_test_significance Number in % Optional Significance level achieved in tilt correction calculations
71 Tilt Uncorrected Alpha 95% tilt_alpha95_uncorr Number in Degrees Optional Fisher circle Examples are: Confidence Level = 95%
70 Tilt Uncorrected K tilt_k_uncorr Dimensionless Optional Average direction Fisher's dispersion parameter Kappa
69 Tilt Uncorrected Declination tilt_dec_uncorr Number in Degrees Optional Tilt uncorrected declination Examples are: Decimal degrees between 0 and 360
68 Tilt Uncorrected Inclination tilt_inc_uncorr Number in Degrees Optional Tilt uncorrected inclination Examples are: Decimal degrees between -90 and 90
67 Tilt Corrected Alpha 95% tilt_alpha95_corr Number in Degrees Optional Fisher circle Examples are: Confidence Level = 95%
66 Tilt Corrected K tilt_k_corr Dimensionless Optional Average direction Fisher's dispersion parameter Kappa
65 Tilt Corrected Declination tilt_dec_corr Number in Degrees Optional Tilt corrected declination Examples are: Decimal degrees between 0 and 360
64 Tilt Corrected Inclination tilt_inc_corr Number in Degrees Optional Tilt corrected inclination Examples are: Decimal degrees between -90 and 90
63 Tilt N tilt_n Integer Optional Number of data points included in tilt correction
62 Tilt K Ratio tilt_k_ratio Dimensionless Optional Comparison of Fisher dispersion K after and before tilt correction
61 Tilt Correction tilt_correction Number in % Optional Tilt correction applied to the data
60 VADM N vadm_n Integer Recommended Number of data points included in VADM calculations
59 VADM Sigma vadm_sigma Number in Am2 Recommended Virtual axial dipole moment: uncertainty Examples are: Uncertainty = 1xSD
58 VADM vadm Number in Am2 Recommended Virtual axial dipole moment
57 VDM N vdm_n Integer Recommended Number of data points included in VDM calculations
56 VDM Sigma vdm_sigma Number in Am2 Recommended Virtual dipole moment: uncertainty Examples are: Uncertainty = 1xSD
55 VDM vdm Number in Am2 Recommended Virtual dipole moment
54 VGP N vgp_n Integer Recommended Number of data points included in VGP calculations
53 VGP Alpha 95% vgp_alpha95 Number in Degrees Recommended Fisher circle Examples are: Confidence Level = 95%
52 VGP Sigma vgp_sigma Number in Degrees Recommended Virtual geomagnetic pole: standard deviation Examples are: Uncertainty = 1xSD
51 VGP DM vgp_dm Number in Degrees Recommended Virtual geomagnetic pole: meridian uncertainty Examples are: Uncertainty = 1xSD
50 VGP DP vgp_dp Number in Degrees Recommended Virtual geomagnetic pole: parallel latitude uncertainty Examples are: Uncertainty = 1xSD
49 VGP Longitude vgp_lon Number in Degrees Recommended Virtual geomagnetic pole: longitude Examples are: Decimal degrees between 0 and 360
48 VGP Latitude vgp_lat Number in Degrees Recommended Virtual geomagnetic pole: latitude Examples are: Decimal degrees between -90 and 90
47 Model Latitude Sigma model_lat_sigma Number in Degrees Recommended Model latitude based on plate reconstruction: uncertainty Examples are: Uncertainty = 1xSD
46 Model Latitude model_lat Number in Degrees Recommended Model latitude based on plate reconstruction Examples are: Decimal degrees between -90 and 90
45 Confidence Ellipse zeta_semi_angle Number in Degrees Recommended Definition of confidence ellipse: semi angle Examples are: Confidence Level = 95%
44 Confidence Ellipse zeta_dec Number in Degrees Recommended Definition of confidence ellipse: declination Examples are: Decimal degrees between 0 and 360
43 Confidence Ellipse zeta_inc Number in Degrees Recommended Definition of confidence ellipse: inclination Examples are: Decimal degrees between -90 and 90
42 Confidence Ellipse eta_semi_angle Number in Degrees Recommended Definition of confidence ellipse: semi angle Examples are: Confidence Level = 95%
41 Confidence Ellipse eta_dec Number in Degrees Recommended Definition of confidence ellipse: declination Examples are: Decimal degrees between 0 and 360
40 Confidence Ellipse eta_inc Number in Degrees Recommended Definition of confidence ellipse: inclination Examples are: Decimal degrees between -90 and 90
Inserted 39 Number of Samples average_int_nn Integer Recommended Number of samples included in intensity calculations
Inserted 38 Number of Sites average_int_n Integer Recommended Number of sites included in intensity calculations
37 Average Intensity Relative Sigma % average_int_rel_sigma_perc Number in % Recommended Relative average field strength: uncertainty in percent Examples are: Uncertainty = 1xSD
36 Average Intensity Relative Sigma average_int_rel_sigma Dimensionless Recommended Relative average field strength: uncertainty Examples are: Uncertainty = 1xSD
35 Average Intensity Relative average_int_rel Dimensionless Recommended Relative average field strength
34 Average Intensity Sigma average_int_sigma Number in T Recommended Average field strength: uncertainty Examples are: Uncertainty = 1xSD
33 Average Intensity average_int Number in T Recommended Average field strength
32 Average R average_r Dimensionless Recommended Average direction resultant Fisher vector
31 Average K average_k Dimensionless Recommended Average direction Fisher's dispersion parameter Kappa
30 Number of Samples average_nn Integer Recommended Number of samples included in directional calculations
29 Number of Sites average_n Integer Recommended Number of sites included in directional calculations
28 Average Alpha 95% average_alpha95 Number in Degrees Recommended Average direction Fisher circle Examples are: Confidence Level = 95%
27 Average Sigma average_sigma Number in Degrees Recommended Average direction in stratigraphic coordinates: standard deviation Examples are: Uncertainty = 1xSD
26 Average Declination average_dec Number in Degrees Recommended Average direction in stratigraphic coordinates: declination Examples are: Decimal degrees between 0 and 360
25 Average Inclination average_inc Number in Degrees Recommended Average direction in stratigraphic coordinates: inclination Examples are: Decimal degrees between -90 and 90
24 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 (+/-)
23 Average Age High average_age_high Custom Recommended Average magnetization age based on multiple sites: high range
22 Average Age Low average_age_low Custom Recommended Average magnetization age based on multiple sites: low range
21 Average Age Sigma average_age_sigma Custom Recommended Average magnetization age based on multiple sites: uncertainty Examples are: Uncertainty = 1xSD
20 Average Age average_age Custom Recommended Average magnetization age based on multiple sites
19 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
18 Average Longitude Sigma average_lon_sigma Number in Degrees Recommended Average location based on multiple sites: longitude uncertainty Examples are: Uncertainty = 1xSD
17 Average Longitude average_lon Number in Degrees Recommended Average location based on multiple sites: longitude Examples are: Decimal degrees between 0 and 360
16 Average Latitude Sigma average_lat_sigma Number in Degrees Recommended Average location based on multiple sites: latitude uncertainty Examples are: Uncertainty = 1xSD
15 Average Latitude average_lat Number in Degrees Recommended Average location based on multiple sites: latitude Examples are: Decimal degrees between -90 and 90
14 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
E 13 Rock Magnetic Test rock_magnetic_test Flag Required Classification and result of the various rock magnetic tests Examples are: M (done), ND (not done)
E 12 Reversal Test reversal_test Flag Required Classification and result of the reversal test Examples are: Ra, Rb, Rc, + (pos), Ro, o (indeterminate), R-, - (neg), ND (not done)
E 11 Baked Contact Test contact_test Flag Required Classification and result of the (inverse) contact test Examples are: C+, IC+, + (pos), Co, Ico, o (indeterminate), C-, IC-, - (neg), ND (not done)
E 10 Conglomerate Test conglomerate_test Flag Required 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 9 Fold Test fold_test Flag Required 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)
R 8 Mineral Name List er_mineral_names Text Recommended Colon-delimited list of mineral names
R 7 Fossil Name List er_fossil_names Text Recommended Colon-delimited list of fossil names included in calculation Examples are: AMM43-03, AMM43-19
R 6 Specimen Name List er_specimen_names Text Recommended Colon-delimited list of specimen names
R 5 Sample Name List er_sample_names Text Recommended Colon-delimited list of sample names
R 4 Site Name List er_site_names Text Recommended Colon-delimited list of site names Examples are: Bas123a, Bas156z, Bas445c
R Deleted 3 Section Name List er_section_names Text Recommended Colon-delimited list of section or core names Examples are: 810C, 810D
R 2 Location Name List er_location_names Text Recommended Colon-delimited list of location or drill site names Examples are: Site 801, Site 1129
P 1 Result Name pmag_result_name Text Required Name or number to identify results Examples are: MY-POLE-XX
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
Home  |  Databases  |  Events  |  Tools  |  Publications  |  Links  |  Google Site Search
Copyright Disclaimer  |  Who's Who  |  Database Team  |  Browsers and Plugins  |  Database Indices
Sponsored by NSF
EAR 1347288 & 1347297
Webservices and Database Support by the San Diego Supercomputer Center
Supported by Scripps Institution of Oceanography and the College of Earth, Ocean and Atmospheric Sciences