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

Standard MagIC Data Format -- ER_Sites 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
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 Required Name for seagoing or land expedition Examples are: AVON02MV
R 4 Location Name er_location_name Text Required Name for location or drill site Examples are: San Francisco Volcanic Province, Site 801
R 5 Formation Name er_formation_name Text Required Name for formation Examples are: Bluebird Formation
R 6 Member Name er_member_name Text Required Name for member Examples are: Glasshound Member
R Deleted 7 Section Name er_section_name Text Required Name for section or core Examples are: Berkeley Lava Flows, 810C, 1129D
F 8 Site Definition site_definition Text Required General definition of site Examples are: Single (s) site or composite (c) site including various geological units
E 9 Site Class site_class Text Required General lithology type Examples are: Igneous, Sedimentary, Metamorphic, Archeological, Intrusive, Extrusive
E Redefined 10 Site Lithology site_lithology Text Required Site lithology or archeological classification Examples are: Basalt, Granite, Mudstone, Tuff, Granodiorite, Marl
N 11 Site Type site_type Text Required Site type Examples are: Flow Top, Glassy Margin, Pot Rim, Pillow, Kiln, Sediment Layer
12 Site Latitude site_lat Number in Degrees Required Site location: latitude Examples are: Decimal degrees between -90 and 90
13 Site Longitude site_lon Number in Degrees Required Site location: longitude Examples are: Decimal degrees between 0 and 360
14 Site Location Precision site_location_precision Number in Degrees Recommended Site location: precision in latitude and longitude Examples are: Decimal degrees
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 Drill Depth site_drill_depth Number in m Optional Site location: depth in MBSF as used by ODP Examples are: Meters below seafloor
18 Site Composite Depth site_composite_depth Number in m Optional Site location: composite depth in MBSF as used by ODP Examples are: Meters below seafloor
19 Site Description site_description Text Optional Detailed description
R 20 Method Codes magic_method_codes Text Recommended Colon-delimited list of method codes Examples are: DE-DC0, FT-F1, LP-DCDMAG
R 21 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 22 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