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

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	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), reversed (r), transitional (t), excursion (e) or intermediate (i) Examples are: Default = n
F		16	Specimen NRM	specimen_nrm	Flag	Recommended	Origin of the NRM is primary (p) or secondary (s) Examples are: Default = p
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
F		18	Specimen Direction Type	specimen_direction_type	Flag	Recommended	Direction determined from a line (l) or plane (p) Examples are: Default = l
F	Inserted	19	Specimen Flag	specimen_flag	Flag	Recommended	Indicating if good (g) or bad (b) data Examples are: Default = g
		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
E		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
	Inserted	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
		41	Specimen Paleo Intensity MAD	specimen_int_mad	Number in Degrees	Recommended	Maximum angle of deviation of the best fit line
		42	Specimen Paleo Intensity N	specimen_int_n	Integer	Recommended	Number of measurements included in intensity calculations
		43	Specimen Weighting Factor	specimen_w	Dimensionless	Optional	Weighting factor
		44	Specimen Q	specimen_q	Dimensionless	Optional	COE's quality factors, Overall quality
		45	Specimen f	specimen_f	Dimensionless	Optional	COE's quality factors, Amount of NRM in component
		46	Specimen f VDS	specimen_fvds	Dimensionless	Optional	COE's quality factors, Vector difference sum of NRM components
		47	Specimen b	specimen_b	Dimensionless	Optional	COE's quality factors, Slope of Arai diagram
		48	Specimen b Sigma	specimen_b_sigma	Dimensionless	Optional	COE's quality factors, Error on slope fit Examples are: Uncertainty = 1xSD
		49	Specimen Sigma over b	specimen_b_beta	Dimensionless	Optional	COE's quality factors, Relative error over slope Examples are: Uncertainty = 1xSD
		50	Specimen g	specimen_g	Dimensionless	Optional	COE's quality factors, The GAP factor
		51	Specimen DANG	specimen_dang	Number in Degrees	Optional	Deviation angle of direction of component with respect to origin
		52	Specimen Maximum MD	specimen_md	Number in %	Optional	Maximum difference between first and second zero field steps
		53	Specimen Maximum pTRM	specimen_ptrm	Number in %	Optional	Classical pTRM check
		54	Specimen Difference Ratio pTRM Checks	specimen_drat	Number in %	Optional	Difference in first and second pTRM measurements Examples are: Normalized by hypotenuse
		55	Specimen Difference Ratio Sum	specimen_drats	Number in %	Optional	Sum of difference in first and second pTRM measurements Examples are: Normalized by pTRM
		56	Specimen Maximum RSC	specimen_rsc	Number in %	Optional	Maximum relative susceptibility change
		57	Specimen Z	specimen_z	Dimensionless	Optional	Degree zigzag behavior in a paleointensity experiment Examples are: Real number between -1 and 100
		58	Specimen Viscosity Index	specimen_viscosity_index	Number in %	Optional	Viscosity index
		59	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
		60	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
		61	Specimen Magnetization Moment	specimen_magn_moment	Number in Am2	Optional	Measured magnetic moment
		62	Specimen Magnetization Volume	specimen_magn_volume	Number in A/m	Optional	Measured intensity of magnetization, Volume normalized
		63	Specimen Magnetization Mass	specimen_magn_mass	Number in Am2/kg	Optional	Measured intensity of magnetization, Mass normalized
		64	Specimen Number pTRM Checks	specimen_int_ptrm_n	Dimensionless	Optional	Number of pTRM checks used in experiment
		65	Specimen Correction Cooling Rate	specimen_int_corr_cooling_rate	Dimensionless	Optional	Cooling rate correction factor for intensity
		66	Specimen Correction Anisotropy	specimen_int_corr_anisotropy	Dimensionless	Optional	Anisotropy correction factor for intensity
	Inserted	67	Specimen Delta	specimen_delta	Number in Degrees	Recommended	Maximum angle of deviation between assumed NRM and measured NRM in perpendicular paleointensity method
	Inserted	68	Specimen Theta	specimen_theta	Number in Degrees	Recommended	Maximum angle of deviation between assumed NRM and measured NRM in perpendicular paleointensity method
	Inserted	69	Specimen Gamma	specimen_gamma	Number in Degrees	Recommended	Maximum angle of deviation between acquired pTRM direction and assumed applied field direction
		70	Specimen Description	specimen_description	Text	Optional	Detailed description
	Inserted	71	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	72	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	73	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		74	Criteria Codes	pmag_criteria_codes	Text	Recommended	Colon-delimited list of criteria codes Examples are: MY-MAD, MY-APLHA95
R		75	Rotation Codes	pmag_rotation_codes	Text	Optional	Colon-delimited list of rotation codes Examples are: MY-TILT1, MY-TILT2, MY-TRANS1
R		76	Method Codes	magic_method_codes	Text	Required	Colon-delimited list of method codes Examples are: DE-DC0, FT-F1, LP-DCDMAG
R		77	Instrument Codes	magic_instrument_codes	Text	Required	Colon-delimited list of instrument codes Examples are: SIO-Bubba, IRM-OldBlue
R		78	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		79	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