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
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
R 3 Expedition Name er_expedition_name Text Optional Name for seagoing or land expedition Examples are: AVON02MV
R 5 Formation Name er_formation_name Text Optional Name for formation Examples are: Bluebird Formation
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 6 Member Name er_member_name Text Optional Name for member Examples are: Glasshound Member
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
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
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
E 8 Site Class site_class Text Required Site location class Examples are: Igneous, Sedimentary, Metamorphic, Archeological, Intrusive, Extrusive, Submarine, Subaerial
18 Site Composite Depth site_composite_depth Number in m Optional Site location, Composite depth in MBSF Examples are: Meters below seafloor
21 Site Cooling Rate Estimate site_cooling_rate Number in K/Ma Optional Estimated ancient in-situ cooling rate per Ma
17 Site Core Depth site_core_depth Number in m Optional Site location, Core depth in MBSF Examples are: Meters below seafloor
F 7 Site Definition site_definition Flag Required Single (s, the default) site or composite (c) site including various geological units
23 Site Description site_description Text Optional Detailed description
15 Site Elevation site_elevation Number in m Recommended Site location, Elevation relative to sealevel Examples are: Meters above sealevel
22 Site IGSN Number site_igsn Text Optional International Geological Sample Number (IGSN) Examples are: SIO0A0987, SIO001317
11 Site Latitude site_lat Number in Degrees Required Site location, Latitude Examples are: Decimal degrees between -90 and 90
E 9 Site Lithology site_lithology Text Required Site lithology or archeological classification Examples are: Basalt, Granite, Mudstone, Tuff, Granodiorite, Marl
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
13 Site Location Precision site_location_precision Number in Degrees Recommended Site location, Precision in latitude and longitude Examples are: Decimal degrees
12 Site Longitude site_lon Number in Degrees Required Site location, Longitude Examples are: Decimal degrees between 0 and 360
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
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
E 10 Site Type site_type Text Required Site type Examples are: Flow Top, Glassy Margin, Pot Rim, Pillow, Kiln, Sediment Layer
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