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

Standard MagIC Data Format -- ER_Images 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 Image Name er_image_name Text Required Name of image Examples are: IMG_1429.jpg
2 Image Name Alternatives er_image_alternatives Text Optional Colon-delimited list of alternative names and abbreviations
R 3 Expedition Name er_expedition_name Text Optional Name for seagoing or land expedition Examples are: AVON02MV
R 4 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
R 5 Formation Name er_formation_name Text Optional Name for formation Examples are: Bluebird Formation
R 6 Member Name er_member_name Text Optional Name for member Examples are: Glasshound Member
R 7 Site Name er_site_name Text Recommended Name for site Examples are: Bas123a
R 8 Sample Name er_sample_name Text Recommended Name for sample Examples are: Bas123a-01
R 9 Specimen Name er_specimen_name Text Recommended Name for specimen Examples are: Bas123a-01x
R 10 Fossil Name er_fossil_name Text Recommended Name for fossil Examples are: AMM43-03
R 11 Mineral Name er_mineral_name Text Recommended Name for mineral Examples are: San03-001
R 12 Synthetic Material Name er_synthetic_name Text Recommended Name for synthetic material Examples are: STD1546-A1
E 13 Image Type image_type Text Required Type of image Examples are: Outcrop, thin section, MFM image, hologram, scanning squid, Bitter, Moke, etc.
14 Image Title image_title Text Required Short Image title Examples are: High tech solutions for being lonely at sea
15 Image Keywords image_keywords Text Required Colon delimited list of keywords associated with image Examples are: Simrad Computer, Multibeam, Seamounts
16 Image Description image_description Text Recommended Detailed description
17 Image Date and Time image_date Text Recommended Date and time of when image was taken Examples are: Number in the "yyyy:mm:dd:hh:mm:ss.ss" format
18 Image Time Zone image_time_zone Text Recommended Time zone Examples are: UTC, PDT, GMT
R 19 Photographer Names er_photographer_mail_names Text Recommended Colon-delimited list of names and emails for photographers Examples are: Jim R.D. Hart , Alexis Heard :Bob McIntire
R 20 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