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

Standard MagIC Data Format -- ER_Expeditions Table -- Version 2.5
All Tables
Click to expand the Data Model Diagram
MagIC Data Model
F Status N Database Field Variable Name Units Required Description
P 1 Expedition Name er_expedition_name Text Required Name for seagoing or land expedition Examples are: AVON02MV
2 Expedition Name Alternatives er_expedition_alternatives Text Optional Colon-delimited list of alternative names and abbreviations
3 Expedition Ship expedition_ship Text Optional Expedition research vessel name Examples are: R/V Melville
4 Expedition Leg expedition_leg Text Optional Leg number of a seagoing expedition Examples are: Leg 2
5 Expedition NGDC Number expedition_ngdc_numb Text Optional NGDC cruise identifier Examples are: ARIA01WT, AVON02MV, AMAT02RR
6 Expedition Sponsor expedition_sponsor Text Recommended Name(s) of sponsors Examples are: NSF-OCE, NASA
7 Expedition Location expedition_location Text Recommended Colon-delimited list of locations
8 Expedition Science Themes expedition_themes Text Optional Specific science themes and questions
9 Expedition Standard Equipment expedition_std_equipment Text Optional Equipment available on vessel
10 Expedition Science Equipment expedition_sci_equipment Text Optional Equipment brought on ship by scientists
11 Expedition Start Latitude expedition_start_lat Number in Degrees Recommended Start location, Latitude Examples are: Decimal degrees between -90 and 90
12 Expedition Start Longitude expedition_start_lon Number in Degrees Recommended Start location, Longitude Examples are: Decimal degrees between 0 and 360
13 Expedition Start Date expedition_start_date Text Recommended Start location, Date Examples are: Number in the "yyyy:mm:dd:hh:mm:ss.ss" format
14 Expedition Start Time Zone expedition_start_time_zone Text Recommended Start location, Time zone Examples are: UTC, PDT, GMT
15 Expedition Start Location expedition_start_loc Text Recommended Start location, Name Examples are: Majuro, Pago Pago, Guam
16 Expedition End Latitude expedition_end_lat Number in Degrees Recommended Ending location, Latitude Examples are: Decimal degrees between -90 and 90
17 Expedition End Longitude expedition_end_lon Number in Degrees Recommended Ending location, Longitude Examples are: Decimal degrees between 0 and 360
18 Expedition End Date expedition_end_date Text Recommended Ending location, Date Examples are: Number in the "yyyy:mm:dd:hh:mm:ss.ss" format
19 Expedition End Time Zone expedition_end_time_zone Text Recommended Ending location, Time zone Examples are: UTC, PDT, GMT
20 Expedition End Location expedition_end_loc Text Recommended Ending location, Name Examples are: Majuro, Pago Pago, Guam
21 Expedition Box Latitude expedition_box_lat_min Number in Degrees Optional Encompassing latitude and longitude box, Latitude minimum Examples are: Decimal degrees between -90 and 90
22 Expedition Box Latitude expedition_box_lat_max Number in Degrees Optional Encompassing latitude and longitude box, Latitude maximum Examples are: Decimal degrees between -90 and 90
23 Expedition Box Longitude expedition_box_lon_min Number in Degrees Optional Encompassing latitude and longitude box, Longitude minimum Examples are: Decimal degrees between 0 and 360
24 Expedition Box Longitude expedition_box_lon_max Number in Degrees Optional Encompassing latitude and longitude box, Longitude maximum Examples are: Decimal degrees between 0 and 360
25 Vessel Sonar Type expedition_mb_sonar Text Optional Ship sensors, Sonar
26 Vessel NAV Sensor expedition_nav_sensor Text Optional Ship sensors, NAV
27 Vessel VRU Sensor expedition_vru_sensor Text Optional Ship sensors, VRU
28 Vessel SSV Sensor expedition_ssv_sensor Text Optional Ship sensors, SSV
29 Vessel MDG Sensor expedition_mdg_sensor Text Optional Ship sensors, MDG
30 Expedition Description expedition_description Text Recommended Detailed description
31 Expedition URL expedition_url Text Recommended Website URL for the expedition Examples are: http://earthref.org
R 32 Principal Investigator Names er_pi_mail_names Text Recommended Colon-delimited list of names and emails for PI's of expedition Examples are: Jim R.D. Hart , Alexis Heard :Bob McIntire
R 33 Research Scientist Names er_scientist_mail_names Text Recommended Colon-delimited list of names and emails for scientists participating in expedition Examples are: Jim R.D. Hart , Alexis Heard :Bob McIntire
R 34 Crew Names er_crew_mail_names Text Recommended Colon-delimited list of names and emails for marine technicians and other crew Examples are: Jim R.D. Hart , Alexis Heard :Bob McIntire
R 35 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
Click to return to previous page