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

Standard MagIC Data Format -- MAGIC_Measurements Table -- Version 2.5
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, the default) or bad (b) measurement
F 13 Measurement Standard Flag measurement_standard Flag Required Indicating if a standard (s) or an unknown (u, the default) measurement
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 Lab Treatment MW Power treatment_mw_power Number in W Optional Microwave power
42 Lab Treatment MW Time treatment_mw_time Number in s Optional Time (in seconds) of microwave power application
43 Lab Treatment MW Energy treatment_mw_energy Number in J Optional Applied microwave power integrated over total application time
44 Lab Treatment Power Integral treatment_mw_integral Number in J Optional Absorbed microwave energy, Applied microwave energy minus reflected microwave energy
45 Measurement Demagnetization Code measurement_demagn_code Text Optional Demagnetization code for legacy data
46 Measurement Temperature measurement_temp Number in K Recommended Temperature
47 Measurement Temperature Change measurement_temp_change Number in K Recommended Change in temperature during each measurement step
48 Measurement Frequency measurement_freq Number in Hz Recommended Frequency
49 Measurement Orientation Phi measurement_orient_phi Number in Degrees Recommended Orientation of sample in magnetometer
50 Measurement Orientation Theta measurement_orient_theta Number in Degrees Recommended Orientation of sample in magnetometer
51 Measurement Lab Field AC measurement_lab_field_ac Number in T Recommended Measured AC field in laboratory
52 Measurement Lab Field DC measurement_lab_field_dc Number in T Recommended Measured DC field in laboratory
53 Measurement Inclination measurement_inc Number in Degrees Recommended Directions in sample coordinates, Inclination Examples are: Decimal degrees between -90 and 90
54 Measurement Declination measurement_dec Number in Degrees Recommended Directions in sample coordinates, Declination Examples are: Decimal degrees between 0 and 360
55 Measurement Magnitude measurement_magnitude Dimensionless Recommended Uncalibrated magnitude measurement
56 Measurement Magnetization Moment measurement_magn_moment Number in Am2 Recommended Measured magnetic moment
57 Measurement Magnetization Volume measurement_magn_volume Number in A/m Recommended Measured intensity of magnetization, Volume normalized
58 Measurement Magnetization Mass measurement_magn_mass Number in Am2/kg Recommended Measured intensity of magnetization, Mass normalized
59 Measurement Susceptibility X Volume measurement_chi_volume Number in SI Recommended Magnetic susceptibility, Volume normalized
60 Measurement Susceptibility X Mass measurement_chi_mass Number in m3/kg Recommended Magnetic susceptibility, Mass normalized
61 Measurement Susceptibility Xqdr Volume measurement_chi_qdr_volume Number in SI Optional Quadrature magnetic susceptibility, Volume normalized
62 Measurement Susceptibility Xqdr Mass measurement_chi_qdr_mass Number in m3/kg Optional Quadrature magnetic susceptibility, Mass normalized
63 Measurement Hysteresis Sweep Rate measurement_sweep_rate Number in T/s Recommended Rate of field sweep during a hysteresis loop measurement
64 Measurement Hysteresis Charging Mode measurement_charging_mode Text Recommended Measurement hysteresis charging mode Examples are: Hysteresis, Steady, No Overshoot
65 Measurement Goodness of Fit measurement_r2 Dimensionless Recommended Goodness of fit in regression Examples are: Number between 0 and 1
66 Measurement Circular Standard Deviation measurement_csd Number in Degrees Recommended Circular standard deviation in measurements Examples are: Uncertainty = 1xSD
67 Measurement Standard Deviation measurement_sd Number in Degrees Recommended Standard deviation in measurements, Average X, Y and Z directions Examples are: Uncertainty = 1xSD
68 Measurement Standard Deviation X measurement_sd_x Number in Degrees Recommended Standard deviation in measurements, X Examples are: Uncertainty = 1xSD
69 Measurement Standard Deviation Y measurement_sd_y Number in Degrees Recommended Standard deviation in measurements, Y Examples are: Uncertainty = 1xSD
70 Measurement Standard Deviation Z measurement_sd_z Number in Degrees Recommended Standard deviation in measurements, Z Examples are: Uncertainty = 1xSD
71 Measurement Description measurement_description Text Optional Detailed description
72 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 73 External Database Names external_database_names Text Optional Colon-delimited list of external databases where data are used Examples are: GEOMAGIA50, CALS7K.2, ARCHEO00
74 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 75 Method Codes magic_method_codes Text Required Colon-delimited list of method codes Examples are: DE-DC0, FT-F1, LP-DCDMAG
R 76 Instrument Code magic_instrument_codes Text Required Colon-delimited list of instrument codes Examples are: SIO-Bubba, IRM-OldBlue
R 77 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 78 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
Click to return to previous page