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

Standard MagIC Data Format -- PMAG_Sites Table -- Version 2.0
All Tables
Click to expand the Data Model Diagram
MagIC Data Model
F Status N Database Field Variable Name Units Required Description
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 List er_sample_names Text Recommended Colon-delimited list of sample names Examples are: Bas123a-01, Bas123a-04, Bas123a-19
R 8 Specimen Name List er_specimen_names Text Recommended Colon-delimited list of specimen names Examples are: Bas123a-01x, Bas123a-01y
R 9 Fossil Name List er_fossil_names Text Recommended Colon-delimited list of fossil names Examples are: AMM43-03, AMM43-19
R 10 Mineral Name List er_mineral_names Text Recommended Colon-delimited list of mineral names
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 Site Magnetic Polarity site_polarity Flag Recommended Polarity of site Examples are: Polarity is normal (n), reversed (r), transitional (t), excursion (e) or intermediate (i)
F 17 Site NRM site_nrm Flag Recommended Origin of the NRM is primary (p) or secondary (s)
F 18 Site Direction Type site_direction_type Flag Recommended Direction determined from (l) or plane (p)
19 Site Component Number site_comp_nmb Integer Recommended Magnetic component number
20 Site Component N site_comp_n Integer Recommended Total number of magnetic components in specimen
21 Site Component Name site_comp_name Text Recommended Site component name Examples are: Characteristic, VRM, Overprint, A, B, C
22 Site Inferred Age site_inferred_age Custom Recommended Site inferred age
23 Site Inferred Age Sigma site_inferred_age_sigma Custom Recommended Site inferred age: uncertainty Examples are: Uncertainty = 1xSD
24 Site Inferred Age Low site_inferred_age_low Custom Recommended Site inferred age: low range
25 Site Inferred Age High site_inferred_age_high Custom Recommended Site inferred age: high range
26 Site Inferred Age Unit site_inferred_age_unit Text Recommended Site inferred age: unit Examples are: Ma, Ka, Ga, Years BP, Years AD (+/-), Years Cal BP, Years Cal AD (+/-)
27 Site Inclination site_inc Number in Degrees Recommended Directions in coordinates specified by tilt correction: inclination Examples are: Decimal degrees between -90 and 90
28 Site Declination site_dec Number in Degrees Recommended Directions in coordinates specified by tilt correction: declination Examples are: Decimal degrees between 0 and 360
29 Site Sigma site_sigma Number in Degrees Recommended Directions in coordinates specified by tilt correction: standard deviation Examples are: Uncertainty = 1xSD
30 Site Alpha 95% site_alpha95 Number in Degrees Recommended Fisher circle Examples are: Confidence Level = 95%
31 Site N site_n Integer Recommended Number of samples included in directional calculations
32 Site N Best-Fit Lines site_n_lines Integer Recommended Number of samples included based on best-fit lines
33 Site N Best-Fit Planes site_n_planes Integer Recommended Number of samples included based on best-fit planes
34 Site K site_k Dimensionless Recommended Fisher's dispersion parameter Kappa
35 Site R site_r Dimensionless Recommended Resultant Fisher vector
36 Site Tilt Correction site_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%)
37 Site Paleo Intensity site_int Number in T Recommended Average field strength
38 Site Paleo Intensity Sigma site_int_sigma Number in T Recommended Average field strength: uncertainty Examples are: Uncertainty = 1xSD
39 Site Paleo Intensity Sigma % site_int_sigma_perc Number in % Recommended Average field strength: uncertainty in percent Examples are: Uncertainty = 1xSD
40 Site Paleo Intensity Relative site_int_rel Dimensionless Recommended Relative field strength
41 Site Paleo Intensity Relative Sigma site_int_rel_sigma Dimensionless Recommended Relative field strength: uncertainty Examples are: Uncertainty = 1xSD
42 Site Paleo Intensity Relative Sigma % site_int_rel_sigma_perc Number in % Recommended Relative field strength: uncertainty in percent Examples are: Uncertainty = 1xSD
43 Site Paleo Intensity N site_int_n Integer Recommended Number of samples included in intensity calculations
44 Site NRM Moment site_moment Number in Am2 Optional Measured intensity: remanent moment
45 Site NRM Magnetization Volume site_magn_volume Number in A/m Optional Measured intensity: remanent magnetization that is volume normalized
46 Site NRM Magnetization Weight site_magn_weight Number in Am2/kg Optional Measured intensity: remanent magnetization that is weight normalized
47 Site Description site_description Text Optional Detailed description
R 48 Criteria Codes pmag_criteria_codes Text Recommended Colon-delimited list of criteria codes Examples are: MY-MAD, MY-APLHA95
R 49 Rotation Codes pmag_rotation_codes Text Optional Colon-delimited list of rotation codes Examples are: MY-TILT1, MY-TILT2, MY-TRANS1
R 50 Method Codes magic_method_codes Text Required Colon-delimited list of method codes Examples are: DE-DC0, FT-F1, LP-DCDMAG
R 51 Instrument Codes magic_instrument_codes Text Required Colon-delimited list of instrument codes Examples are: SIO-Bubba, IRM-OldBlue
R 52 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 53 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
Click to return to previous page