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.3

F	Status	N	Database Field	Variable Name	Units	Required	Description
All Tables Click to expand the Data Model Diagram
		67	Compilation ID Numbers	compilation_ids	Text	Optional	Colon-delimited list of ID numbers from compilations or databases Examples are: 1435, 23, 2329
		66	Compilation Names	compilation_names	Text	Optional	Colon-delimited list of compilation or databases where data are used Examples are: GEOMAGIA, CALS7, ARCHEO00
R		72	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		73	Citation Names	er_citation_names	Text	Required	Colon-delimited list of citations Examples are: Smith et al. 2003, Hart & Heard 1967, This study
R		1	Expedition Name	er_expedition_name	Text	Optional	Name for seagoing or land expedition Examples are: AVON02MV
R		3	Formation Name	er_formation_name	Text	Optional	Name for formation Examples are: Bluebird Formation
R		8	Fossil Name	er_fossil_name	Text	Recommended	Name for fossil Examples are: AMM43-03
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		4	Member Name	er_member_name	Text	Optional	Name for member Examples are: Glasshound Member
R		9	Mineral Name	er_mineral_name	Text	Recommended	Name for mineral Examples are: San03-001
R		6	Sample Name	er_sample_name	Text	Required	Name for sample Examples are: Bas123a-01
R		5	Site Name	er_site_name	Text	Required	Name for site Examples are: Bas123a
R		7	Specimen Name	er_specimen_name	Text	Required	Name for specimen Examples are: Bas123a-01x
R	Inserted	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
R		71	Instrument Codes	magic_instrument_codes	Text	Required	Colon-delimited list of instrument codes Examples are: SIO-Bubba, IRM-OldBlue
R		70	Method Codes	magic_method_codes	Text	Required	Colon-delimited list of method codes Examples are: DE-DC0, FT-F1, LP-DCDMAG
M		13	Measurement Step Maximum	measurement_step_max	Custom	Optional	Step included in calculation, Higher bound
M		12	Measurement Step Minimum	measurement_step_min	Custom	Optional	Step included in calculation, Lower bound
M		14	Measurement Step Unit	measurement_step_unit	Text	Optional	Step included in calculation, Unit
R		68	Criteria Codes	pmag_criteria_codes	Text	Recommended	Colon-delimited list of criteria codes Examples are: MY-MAD, MY-APLHA95
R		69	Rotation Codes	pmag_rotation_codes	Text	Optional	Colon-delimited list of rotation codes Examples are: MY-TILT1, MY-TILT2, MY-TRANS1
		30	Specimen Alpha 95%	specimen_alpha95	Number in Degrees	Recommended	Fisher circle Examples are: Confidence Level = 95%
		45	Specimen b	specimen_b	Dimensionless	Optional	COE's quality factors, Slope of Arai diagram
		47	Specimen Sigma over b	specimen_b_beta	Dimensionless	Optional	COE's quality factors, Relative error over slope Examples are: Uncertainty = 1xSD
		46	Specimen b Sigma	specimen_b_sigma	Dimensionless	Optional	COE's quality factors, Error on slope fit Examples are: Uncertainty = 1xSD
		20	Specimen Component N	specimen_comp_n	Integer	Recommended	Total number of magnetic components in specimen
		21	Specimen Component Name	specimen_comp_name	Text	Recommended	Specimen component name Examples are: Characteristic, VRM, Overprint, A, B, C
		19	Specimen Component Number	specimen_comp_nmb	Integer	Recommended	Magnetic component number
F		17	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 Examples are: Default = u
		49	Specimen DANG	specimen_dang	Number in Degrees	Optional	Deviation angle of direction of component with respect to origin
		28	Specimen Declination	specimen_dec	Number in Degrees	Recommended	Directions in coordinates specified by tilt correction, Declination Examples are: Decimal degrees between 0 and 360
		65	Specimen Description	specimen_description	Text	Optional	Detailed description
F		18	Specimen Direction Type	specimen_direction_type	Flag	Recommended	Direction determined from a line (l) or plane (p) Examples are: Default = l
		52	Specimen Difference Ratio pTRM Checks	specimen_drat	Number in %	Optional	Difference in first and second pTRM measurements Examples are: Normalized by hypotenuse
		53	Specimen Difference Ratio Sum	specimen_drats	Number in %	Optional	Sum of difference in first and second pTRM measurements Examples are: Normalized by pTRM
		43	Specimen f	specimen_f	Dimensionless	Optional	COE's quality factors, Amount of NRM in component
		44	Specimen f VDS	specimen_fvds	Dimensionless	Optional	COE's quality factors, Vector difference sum of NRM components
		48	Specimen g	specimen_g	Dimensionless	Optional	COE's quality factors, The GAP factor
		27	Specimen Inclination	specimen_inc	Number in Degrees	Recommended	Directions in coordinates specified by tilt correction, Inclination Examples are: Decimal degrees between -90 and 90
		22	Specimen Inferred Age	specimen_inferred_age	Custom	Recommended	Specimen inferred age
		25	Specimen Inferred Age High	specimen_inferred_age_high	Custom	Recommended	Specimen inferred age, High range
		24	Specimen Inferred Age Low	specimen_inferred_age_low	Custom	Recommended	Specimen inferred age, Low range
		23	Specimen Inferred Age Sigma	specimen_inferred_age_sigma	Custom	Recommended	Specimen inferred age, Uncertainty Examples are: Uncertainty = 1xSD
E		26	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 (+/-)
		33	Specimen Paleo Intensity	specimen_int	Number in T	Recommended	Average field strength
		64	Specimen Correction Anisotropy	specimen_int_corr_anisotropy	Dimensionless	Optional	Anisotropy correction factor for intensity
		63	Specimen Correction Cooling Rate	specimen_int_corr_cooling_rate	Dimensionless	Optional	Cooling rate correction factor for intensity
		39	Specimen Paleo Intensity MAD	specimen_int_mad	Number in Degrees	Recommended	Maximum angle of deviation of the best fit line
		40	Specimen Paleo Intensity N	specimen_int_n	Integer	Recommended	Number of measurements included in intensity calculations
		62	Specimen Number pTRM Checks	specimen_int_ptrm_n	Dimensionless	Optional	Number of pTRM checks used in experiment
		36	Specimen Paleo Intensity Relative	specimen_int_rel	Dimensionless	Recommended	Relative field strength
		37	Specimen Paleo Intensity Relative Sigma	specimen_int_rel_sigma	Dimensionless	Recommended	Relative field strength, Uncertainty Examples are: Uncertainty = 1xSD
		38	Specimen Paleo Intensity Relative Sigma %	specimen_int_rel_sigma_perc	Number in %	Recommended	Relative field strength, Uncertainty in percent Examples are: Uncertainty = 1xSD
		34	Specimen Paleo Intensity Sigma	specimen_int_sigma	Number in T	Recommended	Average field strength, Uncertainty Examples are: Uncertainty = 1xSD
		35	Specimen Paleo Intensity Sigma %	specimen_int_sigma_perc	Number in %	Recommended	Average field strength, Uncertainty in percent Examples are: Uncertainty = 1xSD
		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
		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
		29	Specimen MAD	specimen_mad	Number in Degrees	Recommended	Maximum angle of deviation of the best fit direction or plane
		61	Specimen Magnetization Mass	specimen_magn_mass	Number in Am2/kg	Optional	Measured intensity of magnetization, Mass normalized
		59	Specimen Magnetization Moment	specimen_magn_moment	Number in Am2	Optional	Measured magnetic moment
		60	Specimen Magnetization Volume	specimen_magn_volume	Number in A/m	Optional	Measured intensity of magnetization, Volume normalized
		50	Specimen Maximum MD	specimen_md	Number in %	Optional	Maximum difference between first and second zero field steps
		31	Specimen N	specimen_n	Integer	Recommended	Number of measurements included in directional calculations
F		16	Specimen NRM	specimen_nrm	Flag	Recommended	Origin of the NRM is primary (p) or secondary (s) Examples are: Default = p
F		15	Specimen Magnetic Polarity	specimen_polarity	Flag	Recommended	Polarity is normal (n), reversed (r), transitional (t), excursion (e) or intermediate (i) Examples are: Default = n
		51	Specimen Maximum pTRM	specimen_ptrm	Number in %	Optional	Classical pTRM check
		42	Specimen Q	specimen_q	Dimensionless	Optional	COE's quality factors, Overall quality
		54	Specimen Maximum RSC	specimen_rsc	Number in %	Optional	Maximum relative susceptibility change
		32	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%)
		56	Specimen Viscosity Index	specimen_viscosity_index	Number in %	Optional	Viscosity index
		41	Specimen Weighting Factor	specimen_w	Dimensionless	Optional	Weighting factor
	Inserted	55	Specimen Z	specimen_z	Dimensionless	Optional	Degree zigzag behavior in a paleointensity experiment Examples are: Real number between -1 and 100
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