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

Standard MagIC Data Format -- MAGIC_Measurements 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 er_sample_name Text Required Name for sample Examples are: Bas123a-01
R 8 Specimen Name er_specimen_name Text Required Name for specimen Examples are: Bas123a-01x
R Reclassified 9 Fossil Name er_fossil_name Text Recommended Name for fossil Examples are: AMM43-03
R Reclassified 10 Mineral Name er_mineral_name Text Recommended Name for mineral Examples are: San03-001
R Reclassified 11 Synthetic Material Name er_synthetic_name Text Recommended Name for synthetic material Examples are: STD1546-A1
X 12 Experiment Name magic_experiment_name Text Required Name for experiment Examples are: KOPA-299-1
F 13 Measurement Flag measurement_flag Flag Required Indicating if good (g) or bad (b) measurement Examples are: Default = g
F 14 Measurement Standard Flag measurement_standard Flag Required Indicating if a standard (s) or an unknown (u) measurement Examples are: Default = u
15 Measurement Number measurement_number Text Required Measurement identifier or lab number Examples are: 03C3012
16 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
17 Measurement Time Zone measurement_time_zone Text Recommended Time zone
18 Measurement Hysteresis Loop Number measurement_loop_x Integer Recommended Hysteresis loop: counter
19 Measurement Hysteresis Loop Total measurement_loop_n Integer Recommended Hysteresis loop: total number of loops
20 Measurement X Position measurement_pos_x Number in m Optional Position of the measurement relative to the specimen: x
21 Measurement Y Position measurement_pos_y Number in m Optional Position of the measurement relative to the specimen: y
22 Measurement Z Position measurement_pos_z Number in m Optional Position of the measurement relative to the specimen: z
23 Measurement Number of Positions measurement_positions Integer Recommended Number of different positions in measurement
24 Measurement Elevation measurement_elevation Number in m Recommended Measurement location: elevation relative to sealevel Examples are: Meters above sealevel
25 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
26 Measurement Drill Depth measurement_drill_depth Number in m Optional Measurement location: depth in MBSF as used by ODP Examples are: Meters below seafloor
27 Measurement Composite Depth measurement_composite_depth Number in m Optional Measurement location: composite depth in MBSF as used by ODP Examples are: Meters below seafloor
28 Lab Treatment Temperature treatment_temp Number in K Recommended Demagnetization temperature
29 Lab Treatment Temperature Decay Rate treatment_temp_decay_rate Number in K/s Optional Decay rate of temperature on cooling
30 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
31 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
32 Lab Treatment AC Field treatment_ac_field Number in T Recommended Peak field in AC demagnetization experiment
33 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
34 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
35 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
36 Lab Treatment DC Field treatment_dc_field Number in T Recommended Applied DC field
37 Lab Treatment DC Field Decay Rate treatment_dc_field_decay_rate Number in T/s Optional Decay rate of DC field after switching off
38 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
39 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
40 Lab Treatment Orientation Phi treatment_dc_field_phi Number in Degrees Optional Orientation of sample in magnetometer
41 Lab Treatment Orientation Theta treatment_dc_field_theta Number in Degrees Optional Orientation of sample in magnetometer
42 Measurement Demagnetization Code measurement_demagn_code Text Optional Demagnitization code for legacy data
43 Measurement Temperature measurement_temp Number in K Recommended Temperature
44 Measurement Temperature Change measurement_temp_change Number in K Recommended Change in temperature during each measurement step
45 Measurement Frequency measurement_freq Number in Hz Recommended Frequency
46 Measurement Orientation Phi measurement_orient_phi Number in Degrees Recommended Orientation of sample in magnetometer
47 Measurement Orientation Theta measurement_orient_theta Number in Degrees Recommended Orientation of sample in magnetometer
48 Measurement Lab Field AC measurement_lab_field_ac Number in T Recommended Measured AC field in laboratory
49 Measurement Lab Field DC measurement_lab_field_dc Number in T Recommended Measured DC field in laboratory
50 Measurement Inclination measurement_inc Number in Degrees Recommended Directions in sample coordinates: inclination Examples are: Decimal degrees between -90 and 90
51 Measurement Declination measurement_dec Number in Degrees Recommended Directions in sample coordinates: declination Examples are: Decimal degrees between 0 and 360
52 Measurement Magnitude measurement_magnitude Dimensionless Recommended Uncalibrated magnitude measurement
53 Measurement Moment measurement_moment Number in Am2 Recommended Measured intensity: remanent moment
54 Measurement Magnetization Volume measurement_magn_volume Number in A/m Recommended Measured intensity: remanent magnetization that is volume normalized
55 Measurement Magnetization Weight measurement_magn_weight Number in Am2/kg Recommended Measured intensity: remanent magnetization that is weight normalized
56 Measurement Susceptibility K measurement_k Number in SI Recommended Magnetic susceptibility: volume normalized
57 Measurement Susceptibility X measurement_x Number in m3/kg Recommended Magnetic susceptibility: mass normalized
58 Measurement Susceptibility K Quadrature measurement_k_quadr Number in SI Optional Quadrature magnetic susceptibility: volume normalized
59 Measurement Susceptibility X Quadrature measurement_x_quadr Number in m3/kg Optional Quadrature magnetic susceptibility: mass normalized
60 Measurement Hysteresis Sweep Rate measurement_sweep_rate Number in T/s Recommended Rate of field sweep during a hysteresis loop measurement
61 Measurement Hysteresis Charging Mode measurement_charging_mode Text Recommended Measurement hysteresis charging mode Examples are: Hysteresis, Steady, No Overshoot
62 Measurement Goodness of Fit measurement_r2 Dimensionless Recommended Goodness of fit in regression Examples are: Number between 0 and 1
63 Measurement Circular Standard Deviation measurement_csd Number in Degrees Recommended Circular standard deviation in measurements Examples are: Uncertainty = 1xSD
64 Measurement Standard Deviation measurement_sd Number in Degrees Recommended Standard deviation in measurements Examples are: Uncertainty = 1xSD
65 Measurement Description measurement_description Text Optional Detailed description
R 66 Method Codes magic_method_codes Text Required Colon-delimited list of method codes Examples are: DE-DC0, FT-F1, LP-DCDMAG
R 67 Instrument Code magic_instrument_codes Text Required Colon-delimited list of instrument codes Examples are: SIO-Bubba, IRM-OldBlue
R 68 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 69 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