Magnetics Information Consortium (MagIC) -- Standard MagIC Data Format -- ER

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

Standard MagIC Data Format -- ER_Locations Table -- Version 2.5

F	N	Database Field	Variable Name	Units	Required	Description
All Tables Click to expand the Data Model Diagram
P	1	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
	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, Core, Land Section, Submarine Section, Stratigraphic Section, Archeological Site, Outcrop, Region
	4	Geographic Begin Latitude	location_begin_lat	Number in Degrees	Required	Beginning of section or core, Outcrop, Latitude Examples are: Decimal degrees between -90 and 90
	5	Geographic Begin Longitude	location_begin_lon	Number in Degrees	Required	Beginning of section or core, Outcrop, Longitude Examples are: Decimal degrees between 0 and 360
	6	Geographic Begin Elevation	location_begin_elevation	Number in m	Recommended	Beginning of section or core, Outcrop, Elevation relative to sealevel Examples are: Meters above sealevel
	7	Geographic End Latitude	location_end_lat	Number in Degrees	Required	End of section or core, Latitude Examples are: Decimal degrees between -90 and 90
	8	Geographic End Longitude	location_end_lon	Number in Degrees	Required	End of section or core, Longitude Examples are: Decimal degrees between 0 and 360
	9	Geographic End Elevation	location_end_elevation	Number in m	Recommended	End of section or core, Elevation relative to sealevel Examples are: Meters above sealevel
	10	Location Precision	location_precision	Number in Degrees	Recommended	Precision in latitude and longitude Examples are: Decimal degrees
E	11	Location Geoid	location_geoid	Text	Recommended	Geoid used in determination of latitude and longitude Examples are: WGS84, GEOID03, USGG2003, GEOID99, G99SSS , G99BM, DEFLEC99
E	12	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	13	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	14	Country Name	country	Text	Recommended	Country name Examples are: Mexico, Costa Rica, the Netherlands
N	15	Region Name	region	Text	Recommended	Region name Examples are: Baja California, Gulf of Mexico
N	16	Village or City Name	village_city	Text	Recommended	Village or city name Examples are: San Francisco, Aalsmeer, San Cristobal, Jumilla
E	17	Plate or Block Name	plate_block	Text	Recommended	Plate or tectonic block name Examples are: North American Plate, Xifon Block, Cocos Plate
N	18	Terrane Name	terrane	Text	Recommended	Terrane name Examples are: Colorado Plateau, Baltica, Grenville Province
N	19	Geological Province or Section Name	geological_province_section	Text	Recommended	Geological province or section name Examples are: Ljusdal Batholith, Storsjon-Edsbyn Sills, West Uusima Complex, Sierra Nevada
E	20	Tectonic Setting	tectonic_setting	Text	Recommended	Tectonic setting Examples are: Intra-Plate Volcanism, Subduction Zone, Mid-Oceanic Ridge
E	21	Location Class	location_class	Text	Recommended	Location class Examples are: Igneous, Sedimentary, Metamorphic, Archeological, Intrusive, Extrusive, Submarine, Subaerial
E	22	Location Lithology	location_lithology	Text	Recommended	Location lithology or archeological classification Examples are: Basalt, Granite, Mudstone, Tuff, Granodiorite, Marl
	23	Location Description	location_description	Text	Optional	Detailed description
	24	Location URL	location_url	Text	Optional	Website URL for the location Examples are: http://earthref.org
R	25	Research Scientist Names	er_scientist_mail_names	Text	Recommended	Colon-delimited list of names and emails for scientists who described location Examples are: Jim R.D. Hart , Alexis Heard :Bob McIntire
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
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