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

Standard MagIC Data Format -- ER_Sections 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 Deleted 1 Section Name er_section_name Text Required Name for section or core Examples are: Berkeley Lava Flows, 810C, 1129D
Deleted 2 Section Name Alternatives er_section_alternatives Text Optional Colon-delimited list of alternative names and abbreviations
R Deleted 3 Expedition Name er_expedition_name Text Required Name for seagoing or land expedition Examples are: AVON02MV
R Deleted 4 Location Name er_location_name Text Required Name for location or drill site Examples are: San Francisco Volcanic Province, Site 801
R Deleted 5 Formation Name er_formation_name Text Required Name for formation Examples are: Bluebird Formation
R Deleted 6 Member Name er_member_name Text Required Name for member Examples are: Glasshound Member
F Deleted 7 Section Definition section_definition Text Required General definition of section in terms of its data collection Examples are: Either a single (s) section or the data is based on composite (c) or average (a) sections including various geological units
E Deleted 8 Section Class section_class Text Required General lithology type Examples are: Igneous, Sedimentary, Metamorphic, Archeological, Intrusive, Extrusive
E Deleted 9 Section Lithology section_lithology Text Required Section lithology or archeological classification Examples are: Basalt, Granite, Mudstone, Tuff, Granodiorite, Marl
E Deleted 10 Section Type section_type Text Recommended Section type Examples are: Subsection, Polarity Transition, Excursion
Deleted 11 Section N section_n Integer Recommended Number of subsections included composite (stacked) section
Deleted 12 Section Begin Latitude section_begin_lat Number in Degrees Required Beginning as defined by bottom of section or top of core: latitude Examples are: Decimal degrees between -90 and 90
Deleted 13 Section Begin Longitude section_begin_lon Number in Degrees Required Beginning as defined by bottom of section or top of core: longitude Examples are: Decimal degrees between 0 and 360
Deleted 14 Section Begin Elevation section_begin_elevation Number in m Recommended Beginning as defined by bottom of section or top of core: elevation relative to sealevel Examples are: Meters above sealevel
Deleted 15 Section Begin Stratigraphic Height section_begin_height Number in m Recommended Beginning as defined by bottom of section or top of core: stratigraphic height Examples are: Positive is up in section or core, negative is down
Deleted 16 Section Begin Drill Depth section_begin_drill_depth Number in m Optional Beginning as defined by bottom of section or top of core: depth in MBSF as used by ODP Examples are: Meters below seafloor
Deleted 17 Section Begin Composite Depth section_begin_composite_depth Number in m Optional Beginning as defined by bottom of section or top of core: composite depth in MBSF as used by ODP Examples are: Meters below seafloor
Deleted 18 Section End Latitude section_end_lat Number in Degrees Required End as defined by top of section or bottom of core: latitude Examples are: Decimal degrees between -90 and 90
Deleted 19 Section End Longitude section_end_lon Number in Degrees Required End as defined by top of section or bottom of core: longitude Examples are: Decimal degrees between 0 and 360
Deleted 20 Section End Elevation section_end_elevation Number in m Recommended End as defined by top of section or bottom of core: elevation relative to sealevel Examples are: Meters above sealevel
Deleted 21 Section End Stratigraphic Height section_end_height Number in m Recommended End as defined by top of section or bottom of core: stratigraphic height Examples are: Positive is up in section or core, negative is down
Deleted 22 Section End Drill Depth section_end_drill_depth Number in m Optional End as defined by top of section or bottom of core: depth in MBSF as used by ODP Examples are: Meters below seafloor
Deleted 23 Section End Composite Depth section_end_composite_depth Number in m Optional End as defined by top of section or bottom of core: composite depth in MBSF as used by ODP Examples are: Meters below seafloor
Deleted 24 Section Azimuth section_azimuth Number in Degrees Recommended Section azimuth as measured clockwise from the north Examples are: Decimal degrees between 0 and 360
Deleted 25 Section Dip section_dip Number in Degrees Recommended Section dip as measured into the outcrop Examples are: Decimal degrees between -90 and 90
Deleted 26 Section Description section_description Text Optional Detailed description
R Deleted 27 Research Scientist Names er_scientist_mail_names Text Recommended Colon-delimited list of names for scientists who described section Examples are: Jim R.D. Hart, Alexis Heard, Bob McIntire
R Deleted 28 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