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

Standard MagIC Data Format -- MAGIC_Measurements Table -- Version 2.3
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 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 Required Name for synthetic material Examples are: STD1546-A1
X 11 Experiment Name magic_experiment_name Text Required Name for experiment Examples are: KOPA-299-1, KOPA-299-2, KOPA-299-6
F 12 Measurement Flag measurement_flag Flag Required Indicating if good (g) or bad (b) measurement Examples are: Default = g
F 13 Measurement Standard Flag measurement_standard Flag Required Indicating if a standard (s) or an unknown (u) measurement Examples are: Default = u
14 Measurement Number measurement_number Text Required Measurement identifier or lab number Examples are: 03C3012
15 Measurement Date and Time measurement_date Text Recommended Date and time of the measurement Examples are: Number in the "yyyy:mm:dd:hh:mm:ss.ss" format
16 Measurement Time Zone measurement_time_zone Text Recommended Time zone Examples are: UTC, PDT, GMT
17 Measurement Hysteresis Loop Number measurement_loop_x Integer Recommended Hysteresis loop, Counter
18 Measurement Hysteresis Loop Total measurement_loop_n Integer Recommended Hysteresis loop, Total number of loops
19 Measurement X Position measurement_pos_x Number in m Optional Position of the measurement relative to the specimen, X
20 Measurement Y Position measurement_pos_y Number in m Optional Position of the measurement relative to the specimen, Y
21 Measurement Z Position measurement_pos_z Number in m Optional Position of the measurement relative to the specimen, Z
22 Measurement Number of Positions measurement_positions Integer Recommended Number of different positions in measurement
23 Measurement Elevation measurement_elevation Number in m Recommended Measurement location, Elevation relative to sealevel Examples are: Meters above sealevel
24 Measurement Stratigraphic Height measurement_height Number in m Recommended Measurement location, Stratigraphic height Examples are: Positive is up in section or core, while negative is down relative to reference height
25 Measurement Core Depth measurement_core_depth Number in m Optional Measurement location, Core depth in MBSF Examples are: Meters below seafloor
26 Measurement Composite Depth measurement_composite_depth Number in m Optional Measurement location, Composite depth in MBSF Examples are: Meters below seafloor
27 Lab Treatment Temperature treatment_temp Number in K Recommended Demagnetization temperature
28 Lab Treatment Temperature Decay Rate treatment_temp_decay_rate Number in K/s Optional Decay rate of temperature on cooling
29 Lab Treatment Temperature DC Field On treatment_temp_dc_on Number in K Optional Temperature in a pTRM experiment at which DC field is turned on
30 Lab Treatment Temperature DC Field Off treatment_temp_dc_off Number in K Optional Temperature in a pTRM experiment at which DC field is turned off
31 Lab Treatment AC Field treatment_ac_field Number in T Recommended Peak field in AC demagnetization experiment
32 Lab Treatment AC Field Decay Rate treatment_ac_field_decay_rate Number in T/s Optional Decay rate of AC field in AC field demagnetization experiment
33 Lab Treatment AC Field DC Field On treatment_ac_field_dc_on Number in T Optional AC field in a pARM experiment at which DC field is turned on
34 Lab Treatment AC Field DC Field Off treatment_ac_field_dc_off Number in T Optional AC field in a pARM experiment at which DC field is turned off
35 Lab Treatment DC Field treatment_dc_field Number in T Recommended Applied DC field
36 Lab Treatment DC Field Decay Rate treatment_dc_field_decay_rate Number in T/s Optional Decay rate of DC field after switching off
37 Lab Treatment DC Field AC Field On treatment_dc_field_ac_on Number in T Optional DC field in DC field experiment at which AC field is turned on
38 Lab Treatment DC Field AC Field Off treatment_dc_field_ac_off Number in T Optional DC field in DC field experiment at which AC field is turned off
39 Lab Treatment Orientation Phi treatment_dc_field_phi Number in Degrees Optional Orientation of sample in magnetometer
40 Lab Treatment Orientation Theta treatment_dc_field_theta Number in Degrees Optional Orientation of sample in magnetometer
41 Measurement Demagnetization Code measurement_demagn_code Text Optional Demagnetization code for legacy data
42 Measurement Temperature measurement_temp Number in K Recommended Temperature
43 Measurement Temperature Change measurement_temp_change Number in K Recommended Change in temperature during each measurement step
44 Measurement Frequency measurement_freq Number in Hz Recommended Frequency
45 Measurement Orientation Phi measurement_orient_phi Number in Degrees Recommended Orientation of sample in magnetometer
46 Measurement Orientation Theta measurement_orient_theta Number in Degrees Recommended Orientation of sample in magnetometer
47 Measurement Lab Field AC measurement_lab_field_ac Number in T Recommended Measured AC field in laboratory
48 Measurement Lab Field DC measurement_lab_field_dc Number in T Recommended Measured DC field in laboratory
49 Measurement Inclination measurement_inc Number in Degrees Recommended Directions in sample coordinates, Inclination Examples are: Decimal degrees between -90 and 90
50 Measurement Declination measurement_dec Number in Degrees Recommended Directions in sample coordinates, Declination Examples are: Decimal degrees between 0 and 360
51 Measurement Magnitude measurement_magnitude Dimensionless Recommended Uncalibrated magnitude measurement
52 Measurement Magnetization Moment measurement_magn_moment Number in Am2 Recommended Measured magnetic moment
53 Measurement Magnetization Volume measurement_magn_volume Number in A/m Recommended Measured intensity of magnetization, Volume normalized
54 Measurement Magnetization Mass measurement_magn_mass Number in Am2/kg Recommended Measured intensity of magnetization, Mass normalized
55 Measurement Susceptibility X Volume measurement_chi_volume Number in SI Recommended Magnetic susceptibility, Volume normalized
56 Measurement Susceptibility X Mass measurement_chi_mass Number in m3/kg Recommended Magnetic susceptibility, Mass normalized
57 Measurement Susceptibility Xqdr Volume measurement_chi_qdr_volume Number in SI Optional Quadrature magnetic susceptibility, Volume normalized
58 Measurement Susceptibility Xqdr Mass measurement_chi_qdr_mass Number in m3/kg Optional Quadrature magnetic susceptibility, Mass normalized
59 Measurement Hysteresis Sweep Rate measurement_sweep_rate Number in T/s Recommended Rate of field sweep during a hysteresis loop measurement
60 Measurement Hysteresis Charging Mode measurement_charging_mode Text Recommended Measurement hysteresis charging mode Examples are: Hysteresis, Steady, No Overshoot
61 Measurement Goodness of Fit measurement_r2 Dimensionless Recommended Goodness of fit in regression Examples are: Number between 0 and 1
62 Measurement Circular Standard Deviation measurement_csd Number in Degrees Recommended Circular standard deviation in measurements Examples are: Uncertainty = 1xSD
63 Measurement Standard Deviation measurement_sd Number in Degrees Recommended Standard deviation in measurements, Average X, Y and Z directions Examples are: Uncertainty = 1xSD
64 Measurement Standard Deviation X measurement_sd_x Number in Degrees Recommended Standard deviation in measurements, X Examples are: Uncertainty = 1xSD
65 Measurement Standard Deviation Y measurement_sd_y Number in Degrees Recommended Standard deviation in measurements, Y Examples are: Uncertainty = 1xSD
66 Measurement Standard Deviation Z measurement_sd_z Number in Degrees Recommended Standard deviation in measurements, Z Examples are: Uncertainty = 1xSD
67 Measurement Description measurement_description Text Optional Detailed description
R 68 Method Codes magic_method_codes Text Required Colon-delimited list of method codes Examples are: DE-DC0, FT-F1, LP-DCDMAG
R 69 Instrument Code magic_instrument_codes Text Required Colon-delimited list of instrument codes Examples are: SIO-Bubba, IRM-OldBlue
R 70 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 71 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