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

Standard MagIC Data Format -- ER_Sites 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
P 1 Site Name er_site_name Text Required Name for site Examples are: Bas123a
2 Site Name Alternatives er_site_alternatives Text Optional Colon-delimited list of alternative names and abbreviations
R 3 Expedition Name er_expedition_name Text Optional Name for seagoing or land expedition Examples are: AVON02MV
R 4 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 5 Formation Name er_formation_name Text Optional Name for formation Examples are: Bluebird Formation
R 6 Member Name er_member_name Text Optional Name for member Examples are: Glasshound Member
F 7 Site Definition site_definition Flag Required Single (s, the default) site or composite (c) site including various geological units
E 8 Site Class site_class Text Required Site location class Examples are: Igneous, Sedimentary, Metamorphic, Archeological, Intrusive, Extrusive, Submarine, Subaerial
E 9 Site Lithology site_lithology Text Required Site lithology or archeological classification Examples are: Basalt, Granite, Mudstone, Tuff, Granodiorite, Marl
E 10 Site Type site_type Text Required Site type Examples are: Flow Top, Glassy Margin, Pot Rim, Pillow, Kiln, Sediment Layer
11 Site Latitude site_lat Number in Degrees Required Site location, Latitude Examples are: Decimal degrees between -90 and 90
12 Site Longitude site_lon Number in Degrees Required Site location, Longitude Examples are: Decimal degrees between 0 and 360
13 Site Location Precision site_location_precision Number in Degrees Recommended Site location, Precision in latitude and longitude Examples are: Decimal degrees
E 14 Site Location Geoid site_location_geoid Text Recommended Site location, Geoid used in determination of latitude and longitude Examples are: WGS84, GEOID03, USGG2003, GEOID99, G99SSS , G99BM, DEFLEC99
15 Site Elevation site_elevation Number in m Recommended Site location, Elevation relative to sealevel Examples are: Meters above sealevel
16 Site Stratigraphic Height site_height Number in m Recommended Site location, Stratigraphic height Examples are: Positive is up in section or core, while negative is down relative to reference height
17 Site Core Depth site_core_depth Number in m Optional Site location, Core depth in MBSF Examples are: Meters below seafloor
18 Site Composite Depth site_composite_depth Number in m Optional Site location, Composite depth in MBSF Examples are: Meters below seafloor
19 Site Bedding Dip Direction site_bed_dip_direction Number in Degrees Recommended Direction of the dip of a paleo-horizontal plane in the bedding Examples are: Decimal degrees between 0 and 360
20 Site Bedding Dip site_bed_dip Number in Degrees Recommended Dip of the bedding as measured to the right of strike direction Examples are: Decimal degrees between -90 and 90
21 Site Cooling Rate Estimate site_cooling_rate Number in K/Ma Optional Estimated ancient in-situ cooling rate per Ma
22 Site IGSN Number site_igsn Text Optional International Geological Sample Number (IGSN) Examples are: SIO0A0987, SIO001317
23 Site Description site_description Text Optional Detailed description
R 24 Method Codes magic_method_codes Text Recommended Colon-delimited list of method codes Examples are: DE-DC0, FT-F1, LP-DCDMAG
R 25 Research Scientist Names er_scientist_mail_names Text Recommended Colon-delimited list of names and emails for scientists who described site Examples are: Jim R.D. Hart , Alexis Heard :Bob McIntire
R 26 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