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_Criteria Table -- Version 2.3

F	N	Database Field	Variable Name	Units	Required	Description
All Tables Click to expand the Data Model Diagram
P	1	Criteria Code	pmag_criteria_code	Text	Required	Criteria type name or number Examples are: MY-MAD, MY-APLHA95
	2	Criteria Definition	criteria_definition	Text	Required	Definition of the criteria
X	3	Experiment Name List	magic_experiment_names	Text	Optional	Colon-delimited list of experiments Examples are: KOPA-299-1
M	4	Measurement Step Minimum	measurement_step_min	Custom	Optional	Step included in calculation, Lower bound
M	5	Measurement Step Maximum	measurement_step_max	Custom	Optional	Step included in calculation, Higher bound
M	6	Measurement Step Unit	measurement_step_unit	Text	Optional	Step included in calculation, Unit
F	7	Specimen Magnetic Polarity	specimen_polarity	Flag	Optional	Polarity is normal (n), reversed (r), transitional (t), excursion (e) or intermediate (i)
F	8	Specimen NRM	specimen_nrm	Flag	Optional	Origin of the NRM is primary (p) or secondary (s)
F	9	Specimen Direction Type	specimen_direction_type	Flag	Optional	Direction determined from a line (l) or plane (p)
	10	Specimen Component Number	specimen_comp_nmb	Integer	Optional	Magnetic component number
	11	Specimen MAD	specimen_mad	Number in Degrees	Optional	Maximum angle of deviation of the best fit direction or plane Examples are: Criterion = maximum
	12	Specimen Alpha 95%	specimen_alpha95	Number in Degrees	Optional	Fisher circle Examples are: Criterion = maximum; Confidence Level = 95%
	13	Specimen N	specimen_n	Integer	Optional	Number of measurements included in directional calculations Examples are: Criterion = minimum
	14	Specimen Paleo Intensity Sigma	specimen_int_sigma	Number in T	Optional	Average field strength, Uncertainty Examples are: Criterion = maximum; Uncertainty = 1xSD
	15	Specimen Paleo Intensity Sigma %	specimen_int_sigma_perc	Number in %	Optional	Average field strength, Uncertainty in percent Examples are: Criterion = maximum; Uncertainty = 1xSD
	16	Specimen Paleo Intensity Relative Sigma	specimen_int_rel_sigma	Dimensionless	Optional	Relative field strength, Uncertainty Examples are: Criterion = maximum; Uncertainty = 1xSD
	17	Specimen Paleo Intensity Relative Sigma %	specimen_int_rel_sigma_perc	Number in %	Optional	Relative field strength, Uncertainty in percent Examples are: Criterion = maximum; Uncertainty = 1xSD
	18	Specimen Paleo Intensity MAD	specimen_int_mad	Number in Degrees	Optional	Maximum angle of deviation of the best fit line Examples are: Criterion = maximum
	19	Specimen Paleo Intensity N	specimen_int_n	Integer	Optional	Number of measurements included in intensity calculations Examples are: Criterion = minimum
	20	Specimen Weighting Factor	specimen_w	Dimensionless	Optional	Weighting factor Examples are: Criterion = maximum
	21	Specimen Q	specimen_q	Dimensionless	Optional	COE's quality factors, Overall quality Examples are: Criterion = minimum
	22	Specimen f	specimen_f	Dimensionless	Optional	COE's quality factors, Amount of NRM in component Examples are: Criterion = minimum
	23	Specimen f VDS	specimen_fvds	Dimensionless	Optional	COE's quality factors, Vector difference sum of NRM components Examples are: Criterion = minimum
	24	Specimen b Sigma	specimen_b_sigma	Dimensionless	Optional	COE's quality factors, Error on slope fit Examples are: Criterion = maximum; Uncertainty = 1xSD
	25	Specimen Sigma over b	specimen_b_beta	Dimensionless	Optional	COE's quality factors, Relative error over slope Examples are: Criterion = maximum; Uncertainty = 1xSD
	26	Specimen g	specimen_g	Dimensionless	Optional	COE's quality factors, The GAP factor Examples are: Criterion = minimum
	27	Specimen DANG	specimen_dang	Number in Degrees	Optional	Deviation angle of direction of component with respect to origin Examples are: Criterion = maximum
	28	Specimen Maximum MD	specimen_md	Number in %	Optional	Maximum difference between first and second zero field steps Examples are: Criterion = maximum
	29	Specimen Maximum pTRM	specimen_ptrm	Number in %	Optional	Classical pTRM check Examples are: Criterion = maximum
	30	Specimen Difference Ratio pTRM Checks	specimen_drat	Number in %	Optional	Difference in first and second pTRM measurements Examples are: Criterion = maximum
	31	Specimen Difference Ratio Sum	specimen_drats	Number in %	Optional	Sum of difference in first and second pTRM measurements Examples are: Criterion = maximum
	32	Specimen Maximum RSC	specimen_rsc	Number in %	Optional	Maximum relative susceptibility change Examples are: Criterion = maximum
	33	Specimen Viscosity Index	specimen_viscosity_index	Number in %	Optional	Viscosity index Examples are: Criterion = maximum
	34	Specimen Magnetization Moment	specimen_magn_moment	Number in Am2	Optional	Measured magnetic moment Examples are: Criterion = minimum
	35	Specimen Magnetization Volume	specimen_magn_volume	Number in A/m	Optional	Measured intensity of magnetization, Volume normalized Examples are: Criterion = minimum
	36	Specimen Magnetization Mass	specimen_magn_mass	Number in Am2/kg	Optional	Measured intensity of magnetization, Mass normalized Examples are: Criterion = minimum
	37	Specimen Number pTRM Checks	specimen_int_ptrm_n	Dimensionless	Optional	Number of pTRM checks used in experiment Examples are: Criterion = minimum
F	38	Sample Magnetic Polarity	sample_polarity	Flag	Optional	Polarity is normal (n), reversed (r), transitional (t), excursion (e) or intermediate (i)
F	39	Sample NRM	sample_nrm	Flag	Optional	Origin of the NRM is primary (p) or secondary (s)
F	40	Sample Direction Type	sample_direction_type	Flag	Optional	Direction determined from a line (l) or plane (p)
	41	Sample Component Number	sample_comp_nmb	Integer	Optional	Magnetic component number
	42	Sample Sigma	sample_sigma	Number in Degrees	Optional	Directions in sample coordinates, Standard deviation Examples are: Criterion = maximum; Uncertainty = 1xSD
	43	Sample Alpha 95%	sample_alpha95	Number in Degrees	Optional	Fisher circle Examples are: Criterion = maximum; Confidence Level = 95%
	44	Sample N	sample_n	Integer	Optional	Number of specimens included in directional calculations Examples are: Criterion = minimum
	45	Sample N Best-Fit Lines	sample_n_lines	Integer	Optional	Number of specimens included based on best-fit lines Examples are: Criterion = minimum
	46	Sample N Best-Fit Planes	sample_n_planes	Integer	Optional	Number of specimens included based on best-fit planes Examples are: Criterion = minimum
	47	Sample K	sample_k	Dimensionless	Optional	Fisher's dispersion parameter Kappa Examples are: Criterion = minimum
	48	Sample R	sample_r	Dimensionless	Optional	Resultant Fisher vector Examples are: Criterion = minimum
	49	Sample Tilt Correction	sample_tilt_correction	Number in %	Optional	Percentage tilt correction applied to the data Examples are: Criterion = minimum
	50	Sample Paleo Intensity Sigma	sample_int_sigma	Number in T	Optional	Average field strength, Uncertainty Examples are: Criterion = maximum; Uncertainty = 1xSD
	51	Sample Paleo Intensity Sigma %	sample_int_sigma_perc	Number in %	Optional	Average field strength, Uncertainty in percent Examples are: Criterion = maximum; Uncertainty = 1xSD
	52	Sample Paleo Intensity Relative Sigma	sample_int_rel_sigma	Dimensionless	Optional	Relative field strength, Uncertainty Examples are: Criterion = maximum; Uncertainty = 1xSD
	53	Sample Paleo Intensity Relative Sigma %	sample_int_rel_sigma_perc	Number in %	Optional	Relative field strength, Uncertainty in percent Examples are: Criterion = maximum; Uncertainty = 1xSD
	54	Sample Paleo Intensity N	sample_int_n	Integer	Optional	Number of specimens included in intensity calculations Examples are: Criterion = minimum
	55	Sample Magnetization Moment	sample_magn_moment	Number in Am2	Optional	Measured magnetic moment Examples are: Criterion = minimum
	56	Sample Magnetization Volume	sample_magn_volume	Number in A/m	Optional	Measured intensity of magnetization, Volume normalized Examples are: Criterion = minimum
	57	Sample Magnetization Mass	sample_magn_mass	Number in Am2/kg	Optional	Measured intensity of magnetization, Mass normalized Examples are: Criterion = minimum
F	58	Site Magnetic Polarity	site_polarity	Flag	Optional	Polarity is normal (n), reversed (r), transitional (t), excursion (e) or intermediate (i)
F	59	Site NRM	site_nrm	Flag	Optional	Origin of the NRM is primary (p) or secondary (s)
F	60	Site Direction Type	site_direction_type	Flag	Optional	Direction determined from a line (l) or plane (p)
	61	Site Component Number	site_comp_nmb	Integer	Optional	Magnetic component number
	62	Site Sigma	site_sigma	Number in Degrees	Optional	Directions in stratigraphic coordinates, Standard deviation Examples are: Criterion = maximum; Uncertainty = 1xSD
	63	Site Alpha 95%	site_alpha95	Number in Degrees	Optional	Fisher circle Examples are: Criterion = maximum; Confidence Level = 95%
	64	Site N	site_n	Integer	Optional	Number of samples included in directional calculations Examples are: Criterion = minimum
	65	Site N Best-Fit Lines	site_n_lines	Integer	Optional	Number of samples included based on best-fit lines Examples are: Criterion = minimum
	66	Site N Best-Fit Planes	site_n_planes	Integer	Optional	Number of samples included based on best-fit planes Examples are: Criterion = minimum
	67	Site K	site_k	Dimensionless	Optional	Fisher's dispersion parameter Kappa Examples are: Criterion = minimum
	68	Site R	site_r	Dimensionless	Optional	Resultant Fisher vector Examples are: Criterion = minimum
	69	Site Tilt Correction	site_tilt_correction	Number in %	Optional	Percentage tilt correction applied to the data Examples are: Criterion = minimum
	70	Site Paleo Intensity Sigma	site_int_sigma	Number in T	Optional	Average field strength, Uncertainty Examples are: Criterion = maximum; Uncertainty = 1xSD
	71	Site Paleo Intensity Sigma %	site_int_sigma_perc	Number in %	Optional	Average field strength, Uncertainty in percent Examples are: Criterion = maximum; Uncertainty = 1xSD
	72	Site Paleo Intensity Relative Sigma	site_int_rel_sigma	Dimensionless	Optional	Relative field strength, Uncertainty Examples are: Criterion = maximum; Uncertainty = 1xSD
	73	Site Paleo Intensity Relative Sigma %	site_int_rel_sigma_perc	Number in %	Optional	Relative field strength, Uncertainty in percent Examples are: Criterion = maximum; Uncertainty = 1xSD
	74	Site Paleo Intensity N	site_int_n	Integer	Optional	Number of samples included in intensity calculations Examples are: Criterion = minimum
	75	Site Magnetization Moment	site_magn_moment	Number in Am2	Optional	Measured magnetic moment Examples are: Criterion = minimum
	76	Site Magnetization Volume	site_magn_volume	Number in A/m	Optional	Measured intensity of magnetization, Volume normalized Examples are: Criterion = minimum
	77	Site Magnetization Mass	site_magn_mass	Number in Am2/kg	Optional	Measured intensity of magnetization, Mass normalized Examples are: Criterion = minimum
	78	Average Age Minimum	average_age_min	Custom	Optional	Average age based on multiple sites or samples, Minimum Examples are: Criterion = minimum
	79	Average Age Maximum	average_age_max	Custom	Optional	Average age based on multiple sites or samples, Maximum Examples are: Criterion = maximum
	80	Average Age Sigma	average_age_sigma	Custom	Optional	Average age based on multiple sites or samples, Uncertainty Examples are: Criterion = maximum; Uncertainty = 1xSD
E	81	Average Age Unit	average_age_unit	Text	Optional	Average age based on multiple sites or samples, Age unit Examples are: Ma, Ka, Ga, Years BP, Years AD (+/-), Years Cal BP, Years Cal AD (+/-)
	82	Average Sigma	average_sigma	Number in Degrees	Optional	Directions in stratigraphic coordinates, Standard deviation Examples are: Criterion = maximum; Uncertainty = 1xSD
	83	Average Alpha 95%	average_alpha95	Number in Degrees	Optional	Fisher circle Examples are: Criterion = maximum; Confidence Level = 95%
	84	Average N Sites	average_n	Integer	Optional	Number of sites included in directional calculations Examples are: Criterion = minimum
	85	Average N Samples	average_nn	Integer	Optional	Number of samples included in directional calculations Examples are: Criterion = minimum
	86	Average K	average_k	Dimensionless	Optional	Fisher's dispersion parameter Kappa Examples are: Criterion = minimum
	87	Average R	average_r	Dimensionless	Optional	Resultant Fisher vector Examples are: Criterion = minimum
	88	Average Intensity Sigma	average_int_sigma	Number in T	Optional	VGP field strength, Uncertainty Examples are: Criterion = maximum; Uncertainty = 1xSD
	89	Average Intensity Relative Sigma	average_int_rel_sigma	Dimensionless	Optional	Relative VGP field strength, Uncertainty Examples are: Criterion = maximum; Uncertainty = 1xSD
	90	Average Intensity Relative Sigma %	average_int_rel_sigma_perc	Number in %	Optional	Relative VGP field strength, Uncertainty in percent Examples are: Criterion = maximum; Uncertainty = 1xSD
	91	Number of Sites	average_int_n	Integer	Recommended	Number of sites included in intensity calculations
	92	Number of Samples	average_int_nn	Integer	Recommended	Number of samples included in intensity calculations
	93	VGP DP	vgp_dp	Number in Degrees	Optional	Parallel latitude, Uncertainty Examples are: Criterion = maximum; Uncertainty = 1xSD
	94	VGP DM	vgp_dm	Number in Degrees	Optional	Meridian, Uncertainty Examples are: Criterion = maximum; Uncertainty = 1xSD
	95	VGP Sigma	vgp_sigma	Number in Degrees	Optional	Virtual geomagnetic pole, Standard deviation Examples are: Criterion = maximum; Uncertainty = 1xSD
	96	VGP Alpha 95%	vgp_alpha95	Number in Degrees	Optional	Fisher circle Examples are: Criterion = maximum; Confidence Level = 95%
	97	VGP N	vgp_n	Integer	Optional	Number of data points included in VGP calculations Examples are: Criterion = minimum
	98	VDM Sigma	vdm_sigma	Number in Am2	Optional	Virtual dipole moment, Uncertainty Examples are: Criterion = maximum; Uncertainty = 1xSD
	99	VDM N	vdm_n	Integer	Optional	Number of data points included in VDM calculations Examples are: Criterion = minimum
	100	VADM Sigma	vadm_sigma	Number in Am2	Optional	Virtual axial dipole moment, Uncertainty Examples are: Criterion = maximum; Uncertainty = 1xSD
	101	VADM N	vadm_n	Integer	Optional	Number of data points included in VADM calculations Examples are: Criterion = minimum
	102	Criteria Description	criteria_description	Text	Optional	Detailed description
R	103	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