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

Standard MagIC Data Format -- pmag_specimens 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
R 1 Expedition Name er_expedition_name Text Optional Name for seagoing or land expedition Examples are: AVON02MV
R 2 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 3 Formation Name er_formation_name Text Optional Name for formation Examples are: Bluebird Formation
R 4 Member Name er_member_name Text Optional Name for member Examples are: Glasshound Member
R 5 Site Name er_site_name Text Required Name for site Examples are: Bas123a
R 6 Sample Name er_sample_name Text Required Name for sample Examples are: Bas123a-01
R 7 Specimen Name er_specimen_name Text Required Name for specimen Examples are: Bas123a-01x
R 8 Fossil Name er_fossil_name Text Recommended Name for fossil Examples are: AMM43-03
R 9 Mineral Name er_mineral_name Text Recommended Name for mineral Examples are: San03-001
R 10 Synthetic Material Name er_synthetic_name Text Optional Name for synthetic material Examples are: STD1546-A1
X 11 Experiment Name List magic_experiment_names Text Optional Colon-delimited list of experiments Examples are: KOPA-299-1, KOPA-299-2, KOPA-299-6
M 12 Measurement Step Minimum measurement_step_min Custom Optional Step included in calculation, Lower bound
M 13 Measurement Step Maximum measurement_step_max Custom Optional Step included in calculation, Higher bound
M 14 Measurement Step Unit measurement_step_unit Text Optional Step included in calculation, Unit
F 15 Specimen Magnetic Polarity specimen_polarity Flag Recommended Polarity is normal (n, the default), reversed (r), transitional (t), excursion (e) or intermediate (i)
F 16 Specimen NRM specimen_nrm Flag Recommended Origin of the NRM is primary (p, the default) or secondary (s)
Inserted 17 Specimen FRAC specimen_frac Dimensionless Optional NRM fraction used for the best-fit on an Arai plot determined entirely by vector difference sum calculation
F 18 Specimen Data Corrected specimen_correction Flag Required Indicating if an uncorrected (u, the default) or corrected (c) estimate with regard to possible anisotropy and cooling rate corrections
F 19 Specimen Direction Type specimen_direction_type Flag Recommended Direction determined from a line (l, the default) or plane (p)
F 20 Specimen Flag specimen_flag Flag Recommended Indicating if good (g, the default) or bad (b) data
21 Specimen Component Number specimen_comp_nmb Integer Recommended Magnetic component number
22 Specimen Component N specimen_comp_n Integer Recommended Total number of magnetic components in specimen
23 Specimen Component Name specimen_comp_name Text Recommended Specimen component name Examples are: Characteristic, VRM, Overprint, A, B, C
24 Specimen Inferred Age specimen_inferred_age Custom Recommended Specimen inferred age
25 Specimen Inferred Age Sigma specimen_inferred_age_sigma Custom Recommended Specimen inferred age, Uncertainty Examples are: Uncertainty = 1xSD
26 Specimen Inferred Age Low specimen_inferred_age_low Custom Recommended Specimen inferred age, Low range
27 Specimen Inferred Age High specimen_inferred_age_high Custom Recommended Specimen inferred age, High range
E 28 Specimen Inferred Age Unit specimen_inferred_age_unit Text Recommended Specimen inferred age, Age unit Examples are: Ma, Ka, Ga, Years BP, Years AD (+/-), Years Cal BP, Years Cal AD (+/-)
29 Specimen Inclination specimen_inc Number in Degrees Recommended Directions in coordinates specified by tilt correction, Inclination Examples are: Decimal degrees between -90 and 90
30 Specimen Declination specimen_dec Number in Degrees Recommended Directions in coordinates specified by tilt correction, Declination Examples are: Decimal degrees between 0 and 360
31 Specimen Alpha 95% specimen_alpha95 Number in Degrees Recommended Fisher circle Examples are: Confidence Level = 95%
Redefined 32 Number of Measurements specimen_n Integer Recommended Number of measurements included in directional calculations
33 Specimen N Total specimen_n_total Integer Recommended Number of measurements total
34 Specimen Tilt Correction specimen_tilt_correction Number in % Recommended Percentage tilt correction applied to the data Examples are: Correction between geographic (0%) and stratigraphic (100%); unoriented (-1%); partially oriented to horizontal only (-2%)
35 Specimen Paleo Intensity specimen_int Number in T Recommended Average field strength
36 Specimen Paleo Intensity Sigma specimen_int_sigma Number in T Recommended Average field strength, Uncertainty Examples are: Uncertainty = 1xSD
37 Specimen Paleo Intensity Sigma % specimen_int_sigma_perc Number in % Recommended Average field strength, Uncertainty in percent Examples are: Uncertainty = 1xSD
38 Specimen Paleo Intensity Relative specimen_int_rel Dimensionless Recommended Relative field strength
39 Specimen Paleo Intensity Relative Sigma specimen_int_rel_sigma Dimensionless Recommended Relative field strength, Uncertainty Examples are: Uncertainty = 1xSD
40 Specimen Paleo Intensity Relative Sigma % specimen_int_rel_sigma_perc Number in % Recommended Relative field strength, Uncertainty in percent Examples are: Uncertainty = 1xSD
Redefined 41 Number of Independent Estimates specimen_int_n Integer Recommended Number of measurements included in field strength calculations
Inserted 42 Specimen Alpha Prime specimen_alpha_prime Number in Degrees Optional Angular difference between the anchored best-fit direction from the paleointensity experiment and an independent measure of the paleomagnetic direction
43 Specimen Alpha specimen_alpha Number in Degrees Optional Angular difference between the anchored and free-floating best-fit directions on a vector component diagram
Inserted 44 Specimen Paleointensity Alpha specimen_int_alpha Number in Degrees Optional Angular difference between the anchored and free-floating best-fit directions on a vector component diagram from a paleointensity experiment
Redefined 45 Specimen MAD Free-Floating specimen_mad Number in Degrees Optional Maximum Angular Deviation (MAD) of the free-floating directional PCA fits to the paleomagnetic vector
Inserted 46 Specimen MAD Anchored specimen_mad_anc Number in Degrees Optional Maximum Angular Deviation (MAD) of the anchored directional PCA fits to the paleomagnetic vector
Redefined 47 Specimen Paleointensity MAD Free-Floating specimen_int_mad Number in Degrees Optional Maximum Angular Deviation (MAD) of the free-floating directional PCA fits to the paleomagnetic vector from a paleointensity experiment
Inserted 48 Specimen Paleointensity MAD Anchored specimen_int_mad_anc Number in Degrees Optional Maximum Angular Deviation (MAD) of the anchored directional PCA fits to the paleomagnetic vector from a paleointensity experiment
Redefined 49 Specimen Weighting Factor specimen_w Dimensionless Optional Weighting factor
Redefined 50 Specimen Q specimen_q Dimensionless Optional A measure of the overall quality of the paleointensity estimate and combines the relative scatter of the best-fit line, the NRM fraction and the gap factor
Redefined 51 Specimen f specimen_f Dimensionless Optional NRM fraction used for the best-fit on an Arai plot
Redefined 52 Specimen f VDS specimen_fvds Dimensionless Optional NRM fraction used for the best-fit on an Arai plot calculated as a vector difference sum
Redefined 53 Specimen b specimen_b Dimensionless Optional The slope of the best-fit line of the selected TRM and NRM points on an Arai plot
Redefined 54 Specimen b Sigma specimen_b_sigma Dimensionless Optional The standard error on the slope on an Arai plot
Redefined 55 Specimen Sigma over b specimen_b_beta Dimensionless Optional The ratio of the standard error of the slope to the absolute value of the slope on an Arai plot
Redefined 56 Specimen g specimen_g Dimensionless Optional The gap reflects the average spacing of the selected Arai plot points along the best-fit line
Inserted 57 Specimen Gap Max specimen_gmax Dimensionless Optional The maximum gap between two points in Arai plot determined by vector arithmetic
Inserted 58 Specimen Squared Correlation Coefficient specimen_r_sq Dimensionless Optional The squared correlation coefficient to estimate the strength of the linear relationship between the NRM and TRM over the best-fit Arai plot segment
Inserted 59 Specimen Squared Coefficient of Determination specimen_coeff_det_sq Dimensionless Optional The squared coefficient of determination to estimate variance accounted for by the linear model fit on an Arai plot
60 Specimen DANG specimen_dang Number in Degrees Optional Deviation angle of direction of component with respect to origin
Redefined 61 Specimen MD VDS specimen_md Number in % Optional Maximum absolute difference produced by a pTRM tail check, normalized by the vector difference sum of the NRM
Inserted 62 Specimen DRAT Tail Check specimen_tail_drat Number in % Optional Maximum absolute difference produced by a pTRM tail check, normalized by the length of the best-fit line
Inserted 63 Specimen delta TR specimen_dtr Number in % Optional Maximum absolute difference produced by a pTRM tail check, normalized by the NRM (obtained from the intersection of the best-fit line and the y-axis on an Arai plot)
Redefined 64 Specimen Maximum pTRM Check specimen_ptrm Number in % Optional Maximum absolute difference produced by a pTRM check, normalized by the TRM acquired at that heating step
Inserted 65 Specimen delta CK specimen_dck Number in % Optional Maximum absolute difference produced by a pTRM check, normalized by the total TRM (obtained from the intersection of the best-fit line and the x-axis on an Arai plot)
Inserted 66 Specimen maxDEV specimen_maxdev Number in % Optional Maximum absolute difference produced by a pTRM check, normalized by the length of the TRM segment of the best-fit line on an Arai plot
Redefined 67 Specimen Difference Ratio pTRM Check specimen_drat Number in % Optional Maximum absolute difference produced by a pTRM check, normalized by the length of the best-fit line
Inserted 68 Specimen Mean DRAT specimen_mdrat Number in % Optional The average difference produced by a pTRM check, normalized by the length of the best-fit line
Inserted 69 Specimen Cumulative DRAT specimen_cdrat Number in % Optional Cumulative difference ratio difference produced by a pTRM check
Redefined 70 Specimen Difference Ratio Sum specimen_drats Number in % Optional Cumulative pTRM check difference normalized by the pTRM gained at the maximum temperature used for the best-fit on the Arai plot
Inserted 71 Specimen Mean DEV specimen_mdev Number in % Optional Mean deviation of a pTRM check
Inserted 72 Specimen delta pal specimen_dpal Number in % Optional A measure of cumulative alteration determined by the difference of the alteration corrected intensity estimate (Valet et al., 1996) and the uncorrected estimate, normalized by the uncorrected estimate (Leonhardt et al., 2004a)
Inserted 73 Specimen delta T specimen_dt Dimensionless Optional The extent of a pTRM tail after correction for angular dependence
Inserted 74 Specimen delta AC specimen_dac Number in % Optional The maximum absolute additivity check difference normalized by the total TRM (obtained from the intersection of the best-fit line and the x-axis on an Arai plot
Inserted 75 Specimen Number Additivity Checks specimen_ac_n Integer Optional The number of additivity checks used to analyze the best-fit segment on an Arai plot
Inserted 76 Specimen Arai Curvatute specimen_k Dimensionless Optional The curvature of the Arai plot as determined by the best-fit circle to all of the data
Inserted 77 Specimen K SSE specimen_k_sse Dimensionless Optional The quality of the best-fit circle used to determine k
78 Specimen Maximum RSC specimen_rsc Number in % Optional Maximum relative susceptibility change
Redefined 79 Specimen Z specimen_z Dimensionless Optional Arai plot zigzag parameter calculated using the scatter around the best-fit slope on an Arai plot
Inserted 80 Specimen IZZI MD specimen_z_md Dimensionless Optional Arai plot zigzag parameter calculated by the area bounded by the curve that the ZI points make and the curve that the IZ points make
F Inserted 81 Specimen Scatter specimen_scat Flag Optional All pTRM checks, MD checks, IZ ZI data, etc. are in the box (g, the default, = good or b=bad)
82 Specimen Viscosity Index specimen_viscosity_index Number in % Optional Viscosity index
83 Specimen Lab Field DC specimen_lab_field_dc Number in T Optional Applied DC field in laboratory Examples are: 0 = no field and -1 = ambient field
84 Specimen Lab Field AC specimen_lab_field_ac Number in T Optional Applied maximum or peak AC field in laboratory Examples are: No field equals 0 and ambient field equals -1
85 Specimen Magnetization Moment specimen_magn_moment Number in Am2 Optional Measured magnetic moment
86 Specimen Magnetization Volume specimen_magn_volume Number in A/m Optional Measured intensity of magnetization, Volume normalized
87 Specimen Magnetization Mass specimen_magn_mass Number in Am2/kg Optional Measured intensity of magnetization, Mass normalized
Redefined 88 Specimen Number pTRM Checks specimen_int_ptrm_n Integer Optional Number of pTRM checks used in paleointensity experiment
89 Specimen Correction Cooling Rate specimen_int_corr_cooling_rate Dimensionless Optional Cooling rate correction factor for intensity
90 Specimen Correction Anisotropy specimen_int_corr_anisotropy Dimensionless Optional Anisotropy correction factor for intensity
Inserted 91 Specimen Correction Non-Linear TRM specimen_int_corr_nlt Dimensionless Optional Non-linear TRM correction factor for intensity
Inserted 92 Specimen Paleointensity DANG specimen_int_dang Number in Degrees Optional The angle between the free-floating best-fit direction and the vector connecting the center of mass and the origin of the vector component diagram
Inserted 93 Specimen CRM % specimen_int_crm Number in % Optional The cumulative deflection between the NRM vectors and the ChRM direction
Inserted 94 Specimen Number pTRM Tail Checks specimen_int_ptrm_tail_n Integer Optional Number of pTRM tail checks used in paleointensity experiment
95 Specimen Delta specimen_delta Number in Degrees Recommended Maximum angle of deviation between assumed NRM and measured NRM in perpendicular paleointensity method
Redefined 96 Specimen Theta specimen_theta Number in Degrees Optional The angle between the applied field direction and the ChRM direction of the NRM as determined from the free-floating PCA fit to the selected demagnetization steps of the paleointensity experiment
97 Specimen Gamma specimen_gamma Number in Degrees Recommended Maximum angle of deviation between acquired pTRM direction and assumed applied field direction
98 Specimen Description specimen_description Text Optional Detailed description
99 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 100 External Database Names external_database_names Text Optional Colon-delimited list of external databases where data are used Examples are: GEOMAGIA50, CALS7K.2, ARCHEO00
101 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 102 Criteria Codes pmag_criteria_codes Text Recommended Colon-delimited list of criteria codes Examples are: MY-MAD, MY-APLHA95
R 103 Rotation Codes pmag_rotation_codes Text Optional Colon-delimited list of rotation codes Examples are: MY-TILT1, MY-TILT2, MY-TRANS1
R 104 Method Codes magic_method_codes Text Required Colon-delimited list of method codes Examples are: DE-DC0, FT-F1, LP-DCDMAG
R 105 Instrument Codes magic_instrument_codes Text Required Colon-delimited list of instrument codes Examples are: SIO-Bubba, IRM-OldBlue
R 106 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 107 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
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