Magnetics Information Consortium (MagIC) -- Standard MagIC Data Format -- PMAG

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

Standard MagIC Data Format -- PMAG_Specimens Table -- Version 2.0

F	Status	N	Database Field	Variable Name	Units	Required	Description
All Tables Click to expand the Data Model Diagram
R		1	Expedition Name	er_expedition_name	Text	Required	Name for seagoing or land expedition Examples are: AVON02MV
R		2	Location Name	er_location_name	Text	Required	Name for location or drill site Examples are: San Francisco Volcanic Province, Site 801
R		3	Formation Name	er_formation_name	Text	Required	Name for formation Examples are: Bluebird Formation
R		4	Member Name	er_member_name	Text	Required	Name for member Examples are: Glasshound Member
R	Deleted	5	Section Name	er_section_name	Text	Required	Name for section or core Examples are: Berkeley Lava Flows, 810C, 1129D
R		6	Site Name	er_site_name	Text	Required	Name for site Examples are: Bas123a
R		7	Sample Name	er_sample_name	Text	Required	Name for sample Examples are: Bas123a-01
R		8	Specimen Name	er_specimen_name	Text	Required	Name for specimen Examples are: Bas123a-01x
R	Reclassified	9	Fossil Name	er_fossil_name	Text	Recommended	Name for fossil Examples are: AMM43-03
R	Reclassified	10	Mineral Name	er_mineral_name	Text	Recommended	Name for mineral Examples are: San03-001
X		11	Experiment Name	magic_experiment_name	Text	Optional	Name for experiment Examples are: KOPA-299-1
M	Deleted	12	Measurement File Name	measurement_file_name	Text	Optional	Name for MagIC format text file containing measurement data Examples are: Hart.et.al.2000.data.txt
M		13	Measurement Step Minimum	measurement_step_min	Custom	Optional	Step included in calculation: lower bound
M		14	Measurement Step Maximum	measurement_step_max	Custom	Optional	Step included in calculation: higher bound
M		15	Measurement Step Unit	measurement_step_unit	Text	Optional	Step included in calculation: unit
F		16	Specimen Magnetic Polarity	specimen_polarity	Flag	Recommended	Polarity of specimen Examples are: Polarity is normal (n), reversed (r), transitional (t), excursion (e) or intermediate (i)
F		17	Specimen NRM	specimen_nrm	Flag	Recommended	Origin of the NRM is primary (p) or secondary (s)
F		18	Specimen Data Corrected	specimen_correction	Flag	Required	Indicating if an uncorrected (u) 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 (l) or plane (p)
		20	Specimen Component Number	specimen_comp_nmb	Integer	Recommended	Magnetic component number
		21	Specimen Component N	specimen_comp_n	Integer	Recommended	Total number of magnetic components in specimen
		22	Specimen Component Name	specimen_comp_name	Text	Recommended	Specimen component name Examples are: Characteristic, VRM, Overprint, A, B, C
		23	Specimen Inferred Age	specimen_inferred_age	Custom	Recommended	Specimen inferred age
		24	Specimen Inferred Age Sigma	specimen_inferred_age_sigma	Custom	Recommended	Specimen inferred age: uncertainty Examples are: Uncertainty = 1xSD
		25	Specimen Inferred Age Low	specimen_inferred_age_low	Custom	Recommended	Specimen inferred age: low range
		26	Specimen Inferred Age High	specimen_inferred_age_high	Custom	Recommended	Specimen inferred age: high range
		27	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 (+/-)
		28	Specimen Inclination	specimen_inc	Number in Degrees	Recommended	Directions in coordinates specified by tilt correction: inclination Examples are: Decimal degrees between -90 and 90
		29	Specimen Declination	specimen_dec	Number in Degrees	Recommended	Directions in coordinates specified by tilt correction: declination Examples are: Decimal degrees between 0 and 360
		30	Specimen MAD	specimen_mad	Number in Degrees	Recommended	Maximum angle of deviation of the best fit direction or plane
		31	Specimen Alpha 95%	specimen_alpha95	Number in Degrees	Recommended	Fisher circle Examples are: Confidence Level = 95%
		32	Specimen N	specimen_n	Integer	Recommended	Number of measurements included in directional calculations
		33	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%)
		34	Specimen Paleo Intensity	specimen_int	Number in T	Recommended	Average field strength
		35	Specimen Paleo Intensity Sigma	specimen_int_sigma	Number in T	Recommended	Average field strength: uncertainty Examples are: Uncertainty = 1xSD
		36	Specimen Paleo Intensity Sigma %	specimen_int_sigma_perc	Number in %	Recommended	Average field strength: uncertainty in percent Examples are: Uncertainty = 1xSD
		37	Specimen Paleo Intensity Relative	specimen_int_rel	Dimensionless	Recommended	Relative field strength
		38	Specimen Paleo Intensity Relative Sigma	specimen_int_rel_sigma	Dimensionless	Recommended	Relative field strength: uncertainty Examples are: Uncertainty = 1xSD
		39	Specimen Paleo Intensity Relative Sigma %	specimen_int_rel_sigma_perc	Number in %	Recommended	Relative field strength: uncertainty in percent Examples are: Uncertainty = 1xSD
		40	Specimen Paleo Intensity MAD	specimen_int_mad	Number in Degrees	Recommended	Maximum angle of deviation of the best fit line
		41	Specimen Paleo Intensity N	specimen_int_n	Integer	Recommended	Number of measurements included in intensity calculations
		42	Specimen Weighting Factor	specimen_w	Dimensionless	Optional	Weighting factor
		43	Specimen Q	specimen_q	Dimensionless	Optional	COE's quality factors: overall quality
		44	Specimen f	specimen_f	Dimensionless	Optional	COE's quality factors: amount of NRM in component
		45	Specimen f VDS	specimen_fvds	Dimensionless	Optional	COE's quality factors: vector difference sum of NRM components
		46	Specimen b	specimen_b	Dimensionless	Optional	COE's quality factors: slope of Arai diagram
		47	Specimen b Sigma	specimen_b_sigma	Dimensionless	Optional	COE's quality factors: error on slope fit Examples are: Uncertainty = 1xSD
		48	Specimen Sigma over b	specimen_b_beta	Dimensionless	Optional	COE's quality factors: relative error over slope Examples are: Uncertainty = 1xSD
		49	Specimen g	specimen_g	Dimensionless	Optional	COE's quality factors: the GAP factor
		50	Specimen DANG	specimen_dang	Number in Degrees	Optional	Deviation angle of direction of component with respect to origin
		51	Specimen Maximum MD	specimen_md	Number in %	Optional	Maximum difference between first and second zero field steps
		52	Specimen Maximum pTRM	specimen_ptrm	Number in %	Optional	Classical pTRM check
		53	Specimen Difference Ratio pTRM Checks	specimen_drat	Number in %	Optional	Difference in first and second pTRM measurements Examples are: Normalized by hypotenuse
		54	Specimen Difference Ratio Sum	specimen_drats	Number in %	Optional	Sum of difference in first and second pTRM measurements Examples are: Normalized by pTRM
		55	Specimen Maximum RSC	specimen_rsc	Number in %	Optional	Maximum relative susceptibility change
		56	Specimen Viscosity Index	specimen_viscosity_index	Number in %	Optional	Viscosity index
		57	Specimen Lab Field DC	specimen_lab_field_dc	Number in T	Optional	Applied DC field in laboratory Examples are: No field equals 0 and ambient field equals -1
		58	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
		59	Specimen NRM Moment	specimen_moment	Number in Am2	Optional	Measured intensity: remanent moment
		60	Specimen NRM Magnetization Volume	specimen_magn_volume	Number in A/m	Optional	Measured intensity: remanent magnetization that is volume normalized
		61	Specimen NRM Magnetization Weight	specimen_magn_weight	Number in Am2/kg	Optional	Measured intensity: remanent magnetization that is weight normalized
		62	Specimen Number pTRM Checks	specimen_int_ptrm_n	Dimensionless	Optional	Number of pTRM checks used in experiment
		63	Specimen Correction Cooling Rate	specimen_int_corr_cooling_rate	Dimensionless	Optional	Cooling rate correction factor for intensity
		64	Specimen Correction Anisotropy	specimen_int_corr_anisotropy	Dimensionless	Optional	Anisotropy correction factor for intensity
		65	Specimen Description	specimen_description	Text	Optional	Detailed description
R		66	Criteria Codes	pmag_criteria_codes	Text	Recommended	Colon-delimited list of criteria codes Examples are: MY-MAD, MY-APLHA95
R		67	Rotation Codes	pmag_rotation_codes	Text	Optional	Colon-delimited list of rotation codes Examples are: MY-TILT1, MY-TILT2, MY-TRANS1
R		68	Method Codes	magic_method_codes	Text	Required	Colon-delimited list of method codes Examples are: DE-DC0, FT-F1, LP-DCDMAG
R		69	Instrument Codes	magic_instrument_codes	Text	Required	Colon-delimited list of instrument codes Examples are: SIO-Bubba, IRM-OldBlue
R		70	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		71	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