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
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 or drill site names Examples are: Site 801, Site 1129
R Deleted 3 Section Name List er_section_names Text Recommended Colon-delimited list of section or core names Examples are: 810C, 810D
R 4 Site Name List er_site_names Text Recommended Colon-delimited list of site names Examples are: Bas123a, Bas156z, Bas445c
R 5 Sample Name List er_sample_names Text Recommended Colon-delimited list of sample names
R 6 Specimen Name List er_specimen_names Text Recommended Colon-delimited list of specimen 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 8 Mineral Name List er_mineral_names Text Recommended Colon-delimited list of mineral names
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)
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 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 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 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)
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
15 Average Latitude average_lat Number in Degrees Recommended Average location based on multiple sites: latitude Examples are: Decimal degrees between -90 and 90
16 Average Latitude Sigma average_lat_sigma Number in Degrees Recommended Average location based on multiple sites: latitude 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
18 Average Longitude Sigma average_lon_sigma Number in Degrees Recommended Average location based on multiple sites: longitude uncertainty Examples are: Uncertainty = 1xSD
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
20 Average Age average_age Custom Recommended Average magnetization age based on multiple sites
21 Average Age Sigma average_age_sigma Custom Recommended Average magnetization age based on multiple sites: uncertainty Examples are: Uncertainty = 1xSD
22 Average Age Low average_age_low Custom Recommended Average magnetization age based on multiple sites: low range
23 Average Age High average_age_high Custom Recommended Average magnetization age based on multiple sites: high range
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 (+/-)
25 Average Inclination average_inc Number in Degrees Recommended Average direction in stratigraphic coordinates: inclination Examples are: Decimal degrees between -90 and 90
26 Average Declination average_dec Number in Degrees Recommended Average direction in stratigraphic coordinates: declination Examples are: Decimal degrees between 0 and 360
27 Average Sigma average_sigma Number in Degrees Recommended Average direction in stratigraphic coordinates: standard deviation Examples are: Uncertainty = 1xSD
28 Average Alpha 95% average_alpha95 Number in Degrees Recommended Average direction Fisher circle Examples are: Confidence Level = 95%
29 Number of Sites average_n Integer Recommended Number of sites included in directional calculations
30 Number of Samples average_nn Integer Recommended Number of samples included in directional calculations
31 Average K average_k Dimensionless Recommended Average direction Fisher's dispersion parameter Kappa
32 Average R average_r Dimensionless Recommended Average direction resultant Fisher vector
33 Average Intensity average_int Number in T Recommended Average field strength
34 Average Intensity Sigma average_int_sigma Number in T Recommended Average field strength: uncertainty Examples are: Uncertainty = 1xSD
35 Average Intensity Relative average_int_rel Dimensionless Recommended Relative average field strength
36 Average Intensity Relative Sigma average_int_rel_sigma Dimensionless Recommended Relative average field strength: uncertainty Examples are: Uncertainty = 1xSD
37 Average Intensity Relative Sigma % average_int_rel_sigma_perc Number in % Recommended Relative average field strength: uncertainty in percent Examples are: Uncertainty = 1xSD
Inserted 38 Number of Sites average_int_n Integer Recommended Number of sites included in intensity calculations
Inserted 39 Number of Samples average_int_nn Integer Recommended Number of samples included in intensity calculations
40 Confidence Ellipse eta_inc Number in Degrees Recommended Definition of confidence ellipse: inclination Examples are: Decimal degrees between -90 and 90
41 Confidence Ellipse eta_dec Number in Degrees Recommended Definition of confidence ellipse: declination Examples are: Decimal degrees between 0 and 360
42 Confidence Ellipse eta_semi_angle Number in Degrees Recommended Definition of confidence ellipse: semi angle Examples are: Confidence Level = 95%
43 Confidence Ellipse zeta_inc Number in Degrees Recommended Definition of confidence ellipse: inclination Examples are: Decimal degrees between -90 and 90
44 Confidence Ellipse zeta_dec Number in Degrees Recommended Definition of confidence ellipse: declination Examples are: Decimal degrees between 0 and 360
45 Confidence Ellipse zeta_semi_angle Number in Degrees Recommended Definition of confidence ellipse: semi angle Examples are: Confidence Level = 95%
46 Model Latitude model_lat Number in Degrees Recommended Model latitude based on plate reconstruction 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
48 VGP Latitude vgp_lat Number in Degrees Recommended Virtual geomagnetic pole: latitude Examples are: Decimal degrees between -90 and 90
49 VGP Longitude vgp_lon Number in Degrees Recommended Virtual geomagnetic pole: longitude Examples are: Decimal degrees between 0 and 360
50 VGP DP vgp_dp Number in Degrees Recommended Virtual geomagnetic pole: parallel latitude uncertainty Examples are: Uncertainty = 1xSD
51 VGP DM vgp_dm Number in Degrees Recommended Virtual geomagnetic pole: meridian uncertainty Examples are: Uncertainty = 1xSD
52 VGP Sigma vgp_sigma Number in Degrees Recommended Virtual geomagnetic pole: standard deviation Examples are: Uncertainty = 1xSD
53 VGP Alpha 95% vgp_alpha95 Number in Degrees Recommended Fisher circle Examples are: Confidence Level = 95%
54 VGP N vgp_n Integer Recommended Number of data points included in VGP calculations
55 VDM vdm Number in Am2 Recommended Virtual dipole moment
56 VDM Sigma vdm_sigma Number in Am2 Recommended Virtual dipole moment: uncertainty Examples are: Uncertainty = 1xSD
57 VDM N vdm_n Integer Recommended Number of data points included in VDM calculations
58 VADM vadm Number in Am2 Recommended Virtual axial dipole moment
59 VADM Sigma vadm_sigma Number in Am2 Recommended Virtual axial dipole moment: uncertainty Examples are: Uncertainty = 1xSD
60 VADM N vadm_n Integer Recommended Number of data points included in VADM calculations
61 Tilt Correction tilt_correction Number in % Optional Tilt correction applied to the data
62 Tilt K Ratio tilt_k_ratio Dimensionless Optional Comparison of Fisher dispersion K after and before tilt correction
63 Tilt N tilt_n Integer Optional Number of data points included in tilt correction
64 Tilt Corrected Inclination tilt_inc_corr Number in Degrees Optional Tilt corrected inclination Examples are: Decimal degrees between -90 and 90
65 Tilt Corrected Declination tilt_dec_corr Number in Degrees Optional Tilt corrected declination Examples are: Decimal degrees between 0 and 360
66 Tilt Corrected K tilt_k_corr Dimensionless Optional Average direction Fisher's dispersion parameter Kappa
67 Tilt Corrected Alpha 95% tilt_alpha95_corr Number in Degrees Optional Fisher circle Examples are: Confidence Level = 95%
68 Tilt Uncorrected Inclination tilt_inc_uncorr Number in Degrees Optional Tilt uncorrected inclination Examples are: Decimal degrees between -90 and 90
69 Tilt Uncorrected Declination tilt_dec_uncorr Number in Degrees Optional Tilt uncorrected declination Examples are: Decimal degrees between 0 and 360
70 Tilt Uncorrected K tilt_k_uncorr Dimensionless Optional Average direction Fisher's dispersion parameter Kappa
71 Tilt Uncorrected Alpha 95% tilt_alpha95_uncorr Number in Degrees Optional Fisher circle Examples are: Confidence Level = 95%
72 Fold Test Significance fold_test_significance Number in % Optional Significance level achieved in tilt correction calculations
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
74 Antipodal Angle antipodal Number in Degrees Optional Great circle distance between normal and reversed poles Examples are: Decimal degrees between 0 and 180
75 Normal Pole Latitude normal_lat Number in Degrees Optional Normal pole: latitude 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
77 Normal Inclination normal_inc Number in Degrees Optional Normal pole: inclination Examples are: Decimal degrees between -90 and 90
78 Normal Declination normal_dec Number in Degrees Optional Normal pole: declination Examples are: Decimal degrees between 0 and 360
79 Normal N normal_n Integer Optional Number of sites or samples included in normal pole calculation
80 Normal K normal_k Dimensionless Optional Average direction Fisher's dispersion parameter Kappa
81 Normal Alpha 95% normal_alpha95 Number in Degrees Optional Average direction Fisher circle Examples are: Confidence Level = 95%
82 Reversed Pole Latitude reversed_lat Number in Degrees Optional Reversed pole: latitude 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
84 Reversed Inclination reversed_inc Number in Degrees Optional Reversed pole: inclination Examples are: Decimal degrees between -90 and 90
85 Reversed Declination reversed_dec Number in Degrees Optional Reversed pole: declination Examples are: Decimal degrees between 0 and 360
86 Reversed N reversed_n Integer Optional Number of sites or samples included in reversed pole calculation
87 Reversed K reversed_k Dimensionless Optional Average direction Fisher's dispersion parameter Kappa
88 Reversed Alpha 95% reversed_alpha95 Number in Degrees Optional Average direction Fisher circle Examples are: Confidence Level = 95%
89 IAGA Database Name iaga_database Text Optional IAGA7 database: name Examples are: ARCHEO, PGMDB, PINT, PSVRL, SECVR, TRANS
90 IAGA Database Result Number iaga_res_no Integer Optional IAGA7 database: internal record number of result
91 Result Description result_description Text Optional Detailed description of results
R 92 Criteria Codes pmag_criteria_codes Text Optional Colon-delimited list of criteria codes Examples are: MY-MAD, MY-APLHA95
R 93 Rotation Codes pmag_rotation_codes Text Optional Colon-delimited list of rotation codes Examples are: MY-TILT1, MY-TILT2, MY-TRANS1
R 94 Method Codes magic_method_codes Text Required Colon-delimited list of method codes Examples are: DE-DC0, FT-F1, LP-DCDMAG
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 96 Citation Names er_citation_names Text Required Colon-delimited list of citations Examples are: Smith et al. 2003, Hart & Heard 1967, 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
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