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_Samples Table -- Version 2.5

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 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, the default), reversed (r), transitional (t), excursion (e) or intermediate (i)
F		16	Sample NRM	sample_nrm	Flag	Recommended	Origin of the NRM is primary (p, the default) or secondary (s)
F		17	Sample Direction Type	sample_direction_type	Flag	Recommended	Direction determined from a line (l, the default) or plane (p)
F		18	Sample Flag	sample_flag	Flag	Recommended	Indicating if good (g, the default) or bad (b) data
		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, Circular standard deviation Examples are: Uncertainty = 1xSD
		30	Sample Alpha 95%	sample_alpha95	Number in Degrees	Recommended	Fisher circle Examples are: Confidence Level = 95%
	Redefined	31	Number of Specimens	sample_n	Integer	Recommended	Number of specimens included in directional calculations
		32	Number of Specimens from Best-Fit Lines	sample_n_lines	Integer	Recommended	Number of specimens included based on best-fit lines
		33	Number of Specimens from Best-Fit Planes	sample_n_planes	Integer	Recommended	Number of specimens included based on best-fit planes
		34	Number of Specimens 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
		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		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
		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	Recommended	Colon-delimited list of names and emails 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 citation DOIs Examples are: 10.1029/92JB01202, 10.1029/2003GC000635:This study, "10.1023/A:1015035228810":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