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

Standard MagIC Data Format -- ER_Sites 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
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) site or composite (c) site including various geological units Examples are: Default = s
E 8 Site Class site_class Text Required Site location class Examples are: Igneous, Sedimentary, Metamorphic, Archeological, Intrusive, Extrusive, Submarine, Subaerial
N 9 Site Lithology site_lithology Text Required Site lithology or archeological classification Examples are: Basalt, Granite, Mudstone, Tuff, Granodiorite, Marl
N 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
N 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 IGSN Number site_igsn Text Optional International Geological Sample Number (IGSN) Examples are: SIO0A0987, SIO001317
20 Site Description site_description Text Optional Detailed description
R 21 Method Codes magic_method_codes Text Recommended Colon-delimited list of method codes Examples are: DE-DC0, FT-F1, LP-DCDMAG
R 22 Research Scientist Names er_scientist_mail_names Text Recommended Colon-delimited list of names for scientists who described site Examples are: Jim R.D. Hart, Alexis Heard, Bob McIntire
R 23 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