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

Standard MagIC Data Format -- pmag_samples Table -- Version 2.4
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 List er_specimen_names Text Recommended Colon-delimited list of specimen names Examples are: Bas123a-01x, Bas123a-01y
R 8 Fossil Name List er_fossil_names Text Recommended Colon-delimited list of fossil names Examples are: AMM43-03, AMM43-19
R 9 Mineral Name List er_mineral_names Text Recommended Colon-delimited list of mineral names Examples are: PLG33a, MAGN-MJ-034
R 10 Synthetic Material Name List er_synthetic_names Text Optional Colon-delimited list of synthetic material names Examples are: STD1546-A1, STD1546-X23
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 Sample Magnetic Polarity sample_polarity Flag Recommended Polarity is normal (n), reversed (r), transitional (t), excursion (e) or intermediate (i) Examples are: Default = n
F 16 Sample NRM sample_nrm Flag Recommended Origin of the NRM is primary (p) or secondary (s) Examples are: Default = p
F 17 Sample Direction Type sample_direction_type Flag Recommended Direction determined from a line (l) or plane (p) Examples are: Default = l
F Inserted 18 Sample Flag sample_flag Flag Recommended Indicating if good (g) or bad (b) data Examples are: Default = g
19 Sample Component Number sample_comp_nmb Integer Recommended Magnetic component number
20 Sample Component N sample_comp_n Integer Recommended Total number of magnetic components in specimen
21 Sample Component Name sample_comp_name Text Recommended Sample component name Examples are: Characteristic, VRM, Overprint, A, B, C
22 Sample Inferred Age sample_inferred_age Custom Recommended Sample inferred age
23 Sample Inferred Age Sigma sample_inferred_age_sigma Custom Recommended Sample inferred age, Uncertainty Examples are: Uncertainty = 1xSD
24 Sample Inferred Age Low sample_inferred_age_low Custom Recommended Sample inferred age, Low range
25 Sample Inferred Age High sample_inferred_age_high Custom Recommended Sample inferred age, High range
E 26 Sample Inferred Age Unit sample_inferred_age_unit Text Recommended Sample inferred age, Age unit Examples are: Ma, Ka, Ga, Years BP, Years AD (+/-), Years Cal BP, Years Cal AD (+/-)
27 Sample Inclination sample_inc Number in Degrees Recommended Directions in coordinates specified by tilt correction, Inclination Examples are: Decimal degrees between -90 and 90
28 Sample Declination sample_dec Number in Degrees Recommended Directions in coordinates specified by tilt correction, Declination Examples are: Decimal degrees between 0 and 360
29 Sample Sigma sample_sigma Number in Degrees Recommended Directions in coordinates specified by tilt correction, Standard deviation Examples are: Uncertainty = 1xSD
30 Sample Alpha 95% sample_alpha95 Number in Degrees Recommended Fisher circle Examples are: Confidence Level = 95%
31 Sample N sample_n Integer Recommended Number of specimens included in directional calculations
32 Sample N Best-Fit Lines sample_n_lines Integer Recommended Number of specimens included based on best-fit lines
33 Sample N Best-Fit Planes sample_n_planes Integer Recommended Number of specimens included based on best-fit planes
Inserted 34 Sample N Total sample_n_total Integer Recommended Number of specimens total
35 Sample K sample_k Dimensionless Recommended Fisher's dispersion parameter Kappa
36 Sample R sample_r Dimensionless Recommended Resultant Fisher vector
37 Sample Tilt Correction sample_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%)
38 Sample Paleo Intensity sample_int Number in T Recommended Average field strength
39 Sample Paleo Intensity Sigma sample_int_sigma Number in T Recommended Average field strength, Uncertainty Examples are: Uncertainty = 1xSD
40 Sample Paleo Intensity Sigma % sample_int_sigma_perc Number in % Recommended Average field strength, Uncertainty in percent Examples are: Uncertainty = 1xSD
41 Sample Paleo Intensity Relative sample_int_rel Dimensionless Recommended Relative field strength
42 Sample Paleo Intensity Relative Sigma sample_int_rel_sigma Dimensionless Recommended Relative field strength, Uncertainty Examples are: Uncertainty = 1xSD
43 Sample Paleo Intensity Relative Sigma % sample_int_rel_sigma_perc Number in % Recommended Relative field strength, Uncertainty in percent Examples are: Uncertainty = 1xSD
44 Sample Paleo Intensity N sample_int_n Integer Recommended Number of specimens included in intensity calculations
45 Sample Magnetization Moment sample_magn_moment Number in Am2 Optional Measured magnetic moment
46 Sample Magnetization Volume sample_magn_volume Number in A/m Optional Measured intensity of magnetization, Volume normalized
47 Sample Magnetization Mass sample_magn_mass Number in Am2/kg Optional Measured intensity of magnetization, Mass normalized
48 Sample Description sample_description Text Optional Detailed description
Inserted 49 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 Renamed 50 External Database Names external_database_names Text Optional Colon-delimited list of external databases where data are used Examples are: GEOMAGIA50, CALS7K.2, ARCHEO00
Renamed 51 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 52 Criteria Codes pmag_criteria_codes Text Recommended Colon-delimited list of criteria codes Examples are: MY-MAD, MY-APLHA95
R 53 Rotation Codes pmag_rotation_codes Text Optional Colon-delimited list of rotation codes Examples are: MY-TILT1, MY-TILT2, MY-TRANS1
R 54 Method Codes magic_method_codes Text Required Colon-delimited list of method codes Examples are: DE-DC0, FT-F1, LP-DCDMAG
R 55 Instrument Codes magic_instrument_codes Text Required Colon-delimited list of instrument codes Examples are: SIO-Bubba, IRM-OldBlue
R 56 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 57 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