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

Standard MagIC Data Format -- ER_Locations 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 Location Name er_location_name Text Required Name for location or drill site Examples are: San Francisco Volcanic Province, Site 801
2 Location Name Alternatives er_location_alternatives Text Optional Colon-delimited list of alternative names and abbreviations
E 3 Location Type location_type Text Required Location type Examples are: Drill Site, Land Section, Submarine Section, Stratigraphic Section, Archeological Site, Outcrop
4 Geographic Begin Latitude location_begin_lat Number in Degrees Required Begin of section or core or outcrop: latitude Examples are: Decimal degrees between -90 and 90
5 Geographic Begin Longitude location_begin_lon Number in Degrees Required Begin of section or core or outcrop: longitude Examples are: Decimal degrees between 0 and 360
6 Geographic Begin Elevation location_begin_elevation Number in m Recommended Begin of section or core or outcrop: elevation relative to sealevel Examples are: Meters above sealevel
7 Geographic End Latitude location_end_lat Number in Degrees Required Ending of section or core: latitude Examples are: Decimal degrees between -90 and 90
8 Geographic End Longitude location_end_lon Number in Degrees Required Ending of section or core: longitude Examples are: Decimal degrees between 0 and 360
9 Geographic End Elevation location_end_elevation Number in m Recommended Ending of section or core: elevation relative to sealevel Examples are: Meters above sealevel
E 10 Continent or Ocean Island Region continent_ocean Text Recommended Name for continent or ocean island region Examples are: North America, Australia, Europe, Asia, Artic Ocean, Indian Ocean
E 11 Ocean or Sea Name ocean_sea Text Recommended Name for location in an ocean or sea Examples are: Pacific Ocean, North Sea, Gulf of Mexico
E 12 Country Name country Text Recommended Country name Examples are: Mexico, Costa Rica, the Netherlands
N 13 Region Name region Text Recommended Region name Examples are: Baja California, Gulf of Mexico
N 14 Plate or Block Name plate_block Text Recommended Plate or tectonic block name Examples are: North American Plate, Xifon Block, Cocos Plate
N 15 Terrane Name terrane Text Recommended Terrane name Examples are: Colorado Plateau, Baltica, Grenville Province
E 16 Tectonic Setting tectonic_setting Text Recommended Tectonic setting Examples are: Intra-Plate Volcanism, Subduction Zone, Mid-Oceanic Ridge
17 Location Description location_description Text Optional Detailed description
18 Location URL location_url Text Optional Website URL for the location explicitly Examples are: http://earthref.org
R 19 Research Scientist Names er_scientist_mail_names Text Recommended Colon-delimited list of names for scientists who described location Examples are: Jim R.D. Hart, Alexis Heard, Bob McIntire
R 20 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