(original) (raw)

# ################################################################################################ # Canonical Collection # ################################################################################################ MMI_CanonicalCollection_ArchivistEmail,"VARCHAR(4000)","Required","1","MMI","Manager Email" MMI_CanonicalCollection_ArchivistInstitution,"VARCHAR(4000)","Required","1","MMI","Manager Institution" MMI_CanonicalCollection_ArchivistName,"VARCHAR(4000)","Required","1","MMI","Manager Name" MMI_CanonicalCollection_ArchivistPhone,"VARCHAR(4000)","Required","1","MMI","Manager Phone" MMI_CanonicalCollection_CollectionIdentifier,"VARCHAR(4000)","Required","1","MMI","Collection Identifier" MMI_CanonicalCollection_ControlledVocabulary,"VARCHAR(4000)","Required","1","MMI","Controlled Vocabulary" MMI_CanonicalCollection_Creator,"VARCHAR(4000)","Required","1","MMI","Creator of collection" MMI_CanonicalCollection_Description,"VARCHAR(4000)","Required","1","MMI","Thorough Description of collection" MMI_CanonicalCollection_Language,"VARCHAR(4000)","Required","1","MMI","Language" MMI_CanonicalCollection_MTFVersion,"VARCHAR(4000)","Required","1","MMI","MTFVersion" MMI_CanonicalCollection_Ontology,"VARCHAR(4000)","Required","1","MMI","Ontology" MMI_CanonicalCollection_Publisher,"VARCHAR(4000)","Required","1","MMI","Publisher of collection" MMI_CanonicalCollection_Subject,"VARCHAR(4000)","Required","1","MMI","General Subject area of collection" MMI_CanonicalCollection_Title,"VARCHAR(4000)","Required","1","MMI","Specific Title of collection" # ################################################################################################ # Canonical ADO # ################################################################################################I MMI_CanonicalADO_ADOIdentifier,"VARCHAR(4000)","Required","1","MMI","ADO Identifier" MMI_CanonicalADO_ADOVersion,"VARCHAR(4000)","Required","1","MMI","ADO Version" MMI_CanonicalADO_AccessControl,"VARCHAR(4000)","Required","1","MMI","Access Control for this object" MMI_CanonicalADO_BlockTypes,"VARCHAR(4000)","Required","1","MMI","Major data block types" MMI_CanonicalADO_Children,"VARCHAR(4000)","Required","1","MMI","Children" MMI_CanonicalADO_CollectionIdentifier,"VARCHAR(4000)","Required","1","MMI","Collection Identifier" MMI_CanonicalADO_ContentFilenames,"VARCHAR(4000)","Required","1","MMI","Content Filenames" MMI_CanonicalADO_Contributor,"VARCHAR(4000)","Required","1","MMI","Contributor of this upload" MMI_CanonicalADO_ControlledVocabulary,"VARCHAR(4000)","Required","1","MMI","Controlled Vocabulary" MMI_CanonicalADO_Coverage,"VARCHAR(4000)","Required","1","MMI","Coverage min max lat lon" MMI_CanonicalADO_Creator,"VARCHAR(4000)","Required","1","MMI","Original creator of object" MMI_CanonicalADO_Date,"DATE","Required","1","MMI","Date of publication into collection" MMI_CanonicalADO_Description,"VARCHAR(4000)","Required","1","MMI","Description including importance" MMI_CanonicalADO_ExpertLevel,"VARCHAR(4000)","Required","1","MMI","Expert Level" MMI_CanonicalADO_Filesize,"NUMERIC","Required","1","MMI","Filesize" MMI_CanonicalADO_Format,"VARCHAR(4000)","Required","1","MMI","Format MIME type" MMI_CanonicalADO_Keywords,"VARCHAR(4000)","Required","1","MMI","Keywords" MMI_CanonicalADO_Language,"VARCHAR(4000)","Required","1","MMI","Language" MMI_CanonicalADO_LatitudeEnd,"REAL","Required","1","MMI","Latitude End" MMI_CanonicalADO_LatitudeNorth,"REAL","Required","1","MMI","Latitude Northernmost" MMI_CanonicalADO_LatitudeSouth,"REAL","Required","1","MMI","Latitude Southernmost" MMI_CanonicalADO_LatitudeStart,"REAL","Required","1","MMI","Latitude at Start of object" MMI_CanonicalADO_LongitudeEast,"REAL","Required","1","MMI","Longitude Easternmost" MMI_CanonicalADO_LongitudeEnd,"REAL","Required","1","MMI","Longitude at End of object" MMI_CanonicalADO_LongitudeStart,"REAL","Required","1","MMI","Longitude at Start of object" MMI_CanonicalADO_LongitudeWest,"REAL","Required","1","MMI","Longitude Westernmost" MMI_CanonicalADO_MIFVersion,"VARCHAR(4000)","Required","1","MMI","MetaData Content Version" MMI_CanonicalADO_MTFVersion,"VARCHAR(4000)","Required","1","MMI","MetaData Template File Version" MMI_CanonicalADO_Ontology,"VARCHAR(4000)","Required","1","MMI","Ontology" MMI_CanonicalADO_Parent,"VARCHAR(4000)","Required","1","MMI","Parent" MMI_CanonicalADO_PhysicalStorageLocation,"VARCHAR(4000)","Required","1","MMI","Physical storage location" MMI_CanonicalADO_Publisher,"VARCHAR(4000)","Required","1","MMI","Publisher" MMI_CanonicalADO_Relation,"VARCHAR(4000)","Required","1","MMI","Relation" MMI_CanonicalADO_Rights,"VARCHAR(4000)","Required","1","MMI","Link to rights statement" MMI_CanonicalADO_Siblings,"VARCHAR(4000)","Required","1","MMI","Siblings" MMI_CanonicalADO_Source,"VARCHAR(4000)","Required","1","MMI","Source of object for Dublin Core" MMI_CanonicalADO_SourceFileName,"VARCHAR(4000)","Required","1","MMI","Source File Name" MMI_CanonicalADO_Subject,"VARCHAR(4000)","Required","1","MMI","Subject area of object" MMI_CanonicalADO_TimeEnd,"TIMESTAMP","Required","1","MMI","End Date Time of object" MMI_CanonicalADO_TimeStart,"TIMESTAMP","Required","1","MMI","Start Date Time of object" MMI_CanonicalADO_Title,"VARCHAR(4000)","Required","1","MMI","Title to identify object in specific detail" MMI_CanonicalADO_Type,"VARCHAR(4000)","Required","1","MMI","Type of Dublin Core resource" # ######################################################################### # GDCADO # ######################################################################### SIOGDC_GDCADO_MTFVersion,"VARCHAR(4000)","Required","1","SIOGDC","MTFVersion" SIOGDC_GDCADO_ADOIdentifier,"VARCHAR(4000)","Required","1","SIOGDC","ADOIdentifier" SIOGDC_GDCADO_ControlledVocabulary,"VARCHAR(4000)","Required","1","SIOGDC","ControlledVocabulary" SIOGDC_GDCADO_Ontology,"VARCHAR(4000)","Required","1","SIOGDC","Ontology" SIOGDC_GDCADO_AccessContact,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Access Contact name and email" SIOGDC_GDCADO_GeoreferenceType,"VARCHAR(4000)","Required","1","SIOGDC","Georeference Type" SIOGDC_GDCADO_SubmissionDate,"VARCHAR(4000)","Required","1","SIOGDC","Date of submission to collection" # ######################################################################### # Cruise # ######################################################################### SIOGDC_Cruise_MTFVersion,"VARCHAR(4000)","Required","1","SIOGDC","MTFVersion" SIOGDC_Cruise_ADOIdentifier,"VARCHAR(4000)","Required","1","SIOGDC","ADOIdentifier" SIOGDC_Cruise_ControlledVocabulary,"VARCHAR(4000)","Required","1","SIOGDC","ControlledVocabulary" SIOGDC_Cruise_Ontology,"VARCHAR(4000)","Required","1","SIOGDC","Ontology" SIOGDC_Cruise_Client,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Cruise Client" SIOGDC_Cruise_CoPi,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Cruise Co PIs" SIOGDC_Cruise_CruiseID,"VARCHAR(4000)","Required","1","SIOGDC","Cruise ID" SIOGDC_Cruise_DataTypes,"VARCHAR(4000)","Required","1","SIOGDC","Data Types Collected" SIOGDC_Cruise_EndDate,"DATE","Required","1","SIOGDC","Cruise End Date" SIOGDC_Cruise_EndPort,"VARCHAR(4000)","Required","1","SIOGDC","Cruise End Port" SIOGDC_Cruise_GeographicLocation,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Geographic Location Name" SIOGDC_Cruise_GrantAgency,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Grant Agency" SIOGDC_Cruise_GrantNumber,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Grant Number" SIOGDC_Cruise_Institution,"VARCHAR(4000)","Required","1","SIOGDC","Ship Operating Institution" SIOGDC_Cruise_Name,"VARCHAR(4000)","Required","1","SIOGDC","Cruise Full Name" SIOGDC_Cruise_Narrative,"VARCHAR(4000)","Required","1","SIOGDC","Brief Cruise Narrative Description" SIOGDC_Cruise_NGDCNumber,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Cruise NGDC Number" SIOGDC_Cruise_PICity,"VARCHAR(4000)","Arbitrary","1","SIOGDC","PI City" SIOGDC_Cruise_PIFax,"VARCHAR(4000)","Arbitrary","1","SIOGDC","PI Fax" SIOGDC_Cruise_PIInstitution,"VARCHAR(4000)","Required","1","SIOGDC","PI Institution" SIOGDC_Cruise_PIName,"VARCHAR(4000)","Required","1","SIOGDC","PI Name" SIOGDC_Cruise_PIPhone,"VARCHAR(4000)","Arbitrary","1","SIOGDC","PI Phone" SIOGDC_Cruise_PIState,"VARCHAR(4000)","Arbitrary","1","SIOGDC","PI State" SIOGDC_Cruise_PIStreetAddress,"VARCHAR(4000)","Arbitrary","1","SIOGDC","PI Street Address" SIOGDC_Cruise_PITitle,"VARCHAR(4000)","Arbitrary","1","SIOGDC","PI Title" SIOGDC_Cruise_PIZipcode,"VARCHAR(4000)","Arbitrary","1","SIOGDC","PI Zipcode" SIOGDC_Cruise_PIEmail,"VARCHAR(4000)","Arbitrary","1","SIOGDC","PI Email" SIOGDC_Cruise_ProcessingNarrative,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Cruise Data Processing or Problem Narrative Summary" SIOGDC_Cruise_ProposalTitle,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Proposal Title" SIOGDC_Cruise_ScienceThemes,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Standard Science Themes" SIOGDC_Cruise_ScientificPartyEquipment,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Special major Scientific Party Equipment" SIOGDC_Cruise_Scientists,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Scientists names" SIOGDC_Cruise_StartDate,"DATE","Required","1","SIOGDC","Cruise Start Date" SIOGDC_Cruise_StartPort,"VARCHAR(4000)","Required","1","SIOGDC","Cruise Start Port" SIOGDC_Cruise_Subject,"VARCHAR(4000)","Arbitrary","1","SIOGDC","General cruise scientific Subject" SIOGDC_Cruise_SurveyAreaCode,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Standard Navy Survey Operations Area Code" SIOGDC_Cruise_Title,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Cruise Title" SIOGDC_Cruise_Vessel,"VARCHAR(4000)","Required","1","SIOGDC","Vessel Name" # ######################################################################### # Documentation # ######################################################################### SIOGDC_Documentation_MTFVersion,"VARCHAR(4000)","Required","1","SIOGDC","MTFVersion" SIOGDC_Documentation_ADOIdentifier,"VARCHAR(4000)","Required","1","SIOGDC","ADOIdentifier" SIOGDC_Documentation_ControlledVocabulary,"VARCHAR(4000)","Required","1","SIOGDC","ControlledVocabulary" SIOGDC_Documentation_Ontology,"VARCHAR(4000)","Required","1","SIOGDC","Ontology" SIOGDC_Documentation_Description,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Document Description or Title" SIOGDC_Documentation_Format,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Format" SIOGDC_Documentation_ObjectType,"VARCHAR(4000)","Required","1","SIOGDC","Data Object Type" SIOGDC_Documentation_Type,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Document Type" # ######################################################################### # Instrumentation # ######################################################################### SIOGDC_Instrumentation_MTFVersion,"VARCHAR(4000)","Required","1","SIOGDC","MTFVersion" SIOGDC_Instrumentation_ADOIdentifier,"VARCHAR(4000)","Required","1","SIOGDC","ADOIdentifier" SIOGDC_Instrumentation_ControlledVocabulary,"VARCHAR(4000)","Required","1","SIOGDC","ControlledVocabulary" SIOGDC_Instrumentation_Ontology,"VARCHAR(4000)","Required","1","SIOGDC","Ontology" SIOGDC_Instrumentation_Calibration,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Calibration parameters" SIOGDC_Instrumentation_Manufacturer,"VARCHAR(4000)","Required","1","SIOGDC","Manufacturer" SIOGDC_Instrumentation_Method,"VARCHAR(4000)","Required","1","SIOGDC","Deployment Method" SIOGDC_Instrumentation_Model,"VARCHAR(4000)","Required","1","SIOGDC","Model Name" SIOGDC_Instrumentation_ModelVersion,"VARCHAR(4000)","Required","1","SIOGDC","Model Version" SIOGDC_Instrumentation_ObjectType,"VARCHAR(4000)","Required","1","SIOGDC","Data Object Type" SIOGDC_Instrumentation_PercentGoodPoints,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Percent Good Points as Quality Index" SIOGDC_Instrumentation_ProcessingSteps,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Processing or editing steps" SIOGDC_Instrumentation_SensorMLprofile,"VARCHAR(4000)","Arbitrary","1","SIOGDC","SensorML metadata file for this instrument" SIOGDC_Instrumentation_Sensors,"VARCHAR(4000)","Required","1","SIOGDC","Sensors in this instrument" SIOGDC_Instrumentation_Units,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Value units" SIOGDC_Instrumentation_ValueMaximum,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Value Maximum" SIOGDC_Instrumentation_ValueMinimum,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Value Minimum" # ######################################################################### # Products # ######################################################################### SIOGDC_Products_MTFVersion,"VARCHAR(4000)","Required","1","SIOGDC","MTFVersion" SIOGDC_Products_ADOIdentifier,"VARCHAR(4000)","Required","1","SIOGDC","ADOIdentifier" SIOGDC_Products_ControlledVocabulary,"VARCHAR(4000)","Required","1","SIOGDC","ControlledVocabulary" SIOGDC_Products_Ontology,"VARCHAR(4000)","Required","1","SIOGDC","Ontology" SIOGDC_Products_Description,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Data Product Description" SIOGDC_Products_Format,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Format" SIOGDC_Products_Method,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Data Production Method" SIOGDC_Products_ObjectType,"VARCHAR(4000)","Required","1","SIOGDC","Data Object Type" SIOGDC_Products_Type,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Data Product Type" # ######################################################################### # Samples # ######################################################################### SIOGDC_Samples_MTFVersion,"VARCHAR(4000)","Required","1","SIOGDC","MTFVersion" SIOGDC_Samples_ADOIdentifier,"VARCHAR(4000)","Required","1","SIOGDC","ADOIdentifier" SIOGDC_Samples_ControlledVocabulary,"VARCHAR(4000)","Required","1","SIOGDC","ControlledVocabulary" SIOGDC_Samples_Ontology,"VARCHAR(4000)","Required","1","SIOGDC","Ontology" SIOGDC_Samples_CoreDiameter,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Core Diameter" SIOGDC_Samples_CoreLength,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Core Length" SIOGDC_Samples_CrustalAge,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Crustal Age at sample location" SIOGDC_Samples_Description,"VARCHAR(4000)","Required","1","SIOGDC","Sample Description" SIOGDC_Samples_Device,"VARCHAR(4000)","Required","1","SIOGDC","Sampling Device" SIOGDC_Samples_GeologicalAge,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Geological Age" SIOGDC_Samples_IGSNNumber,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Official IGSN Number" SIOGDC_Samples_NumberOfIntervals,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Number Of Intervals" SIOGDC_Samples_NumberOfSubSamples,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Number Of SubSamples" SIOGDC_Samples_ObjectType,"VARCHAR(4000)","Required","1","SIOGDC","Data Object Type" SIOGDC_Samples_Province,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Geological Province" SIOGDC_Samples_SampleId,"VARCHAR(4000)","Required","1","SIOGDC","Sample Id" SIOGDC_Samples_StorageMethod,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Storage Method" SIOGDC_Samples_WaterDepthEnd,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Water Depth at End" SIOGDC_Samples_WaterDepthStart,"VARCHAR(4000)","Arbitrary","1","SIOGDC","Water Depth at Start" # ######################################################################### # Submergence # ######################################################################### SIOGDC_Submergence_MTFVersion,"VARCHAR(4000)","Required","1","WHOIDLA","MTFVersion" SIOGDC_Submergence_ADOIdentifier,"VARCHAR(4000)","Required","1","WHOIDLA","ADOIdentifier" SIOGDC_Submergence_ControlledVocabulary,"VARCHAR(4000)","Required","1","WHOIDLA","ControlledVocabulary" SIOGDC_Submergence_Ontology,"VARCHAR(4000)","Required","1","WHOIDLA","Ontology" SIOGDC_Submergence_ChiefScientist,"VARCHAR(4000)","Arbitrary","1","WHOIDLA","Chief Scientist" SIOGDC_Submergence_CruiseID,"VARCHAR(4000)","Arbitrary","1","WHOIDLA","Cruise ID" SIOGDC_Submergence_DataTypes,"VARCHAR(4000)","Arbitrary","1","WHOIDLA","List of Data Types acquired in this submergence" SIOGDC_Submergence_DistanceCovered,"VARCHAR(4000)","Arbitrary","1","WHOIDLA","Distance covered along track, km" SIOGDC_Submergence_ElapsedTimeBottom,"VARCHAR(4000)","Arbitrary","1","WHOIDLA","Elapsed Time while on Bottom, hh:mm" SIOGDC_Submergence_ElapsedTimeData,"VARCHAR(4000)","Arbitrary","1","WHOIDLA","Elapsed Time acquiring digital data, hh:mm" SIOGDC_Submergence_ElapsedTimeSubmerged,"VARCHAR(4000)","Arbitrary","1","WHOIDLA","Elapsed Time Submerged, hh:mm" SIOGDC_Submergence_Latitude,"REAL","Required","1","WHOIDLA","Latitude at launch, decimal degrees" SIOGDC_Submergence_Longitude,"REAL","Required","1","WHOIDLA","Longitude at launch, decimal degrees" SIOGDC_Submergence_MaxDepth,"VARCHAR(4000)","Arbitrary","1","WHOIDLA","Maximum Depth, meters" SIOGDC_Submergence_MovingImageType,"VARCHAR(4000)","Arbitrary","1","WHOIDLA","List of Moving Image Types acquired" SIOGDC_Submergence_NavigationType,"VARCHAR(4000)","Arbitrary","1","WHOIDLA","List of Navigation Types used for vehicle" SIOGDC_Submergence_Observers,"VARCHAR(4000)","Arbitrary","1","WHOIDLA","Names of Observers" SIOGDC_Submergence_Pilot,"VARCHAR(4000)","Arbitrary","1","WHOIDLA","Name of Pilot" SIOGDC_Submergence_Purpose,"VARCHAR(4000)","Arbitrary","1","WHOIDLA","Scientific Purpose of this submergence" SIOGDC_Submergence_Remarks,"VARCHAR(4000)","Arbitrary","1","WHOIDLA","Remarks on achievements and problems" SIOGDC_Submergence_SampleTypes,"VARCHAR(4000)","Arbitrary","1","WHOIDLA","List of Sample Types acquired" SIOGDC_Submergence_StillImageType,"VARCHAR(4000)","Arbitrary","1","WHOIDLA","List of Still Image Types acquired" SIOGDC_Submergence_SubmergenceID,"VARCHAR(4000)","Arbitrary","1","WHOIDLA","Submergence ID, official Lowering ID or Dive Number" SIOGDC_Submergence_SubmergenceSite,"VARCHAR(4000)","Arbitrary","1","WHOIDLA","Specific Submergence Site or line name" SIOGDC_Submergence_TimeEndData,"DATE","Arbitrary","1","WHOIDLA","Time of End Data acquisition, ISO8601 date timestamp" SIOGDC_Submergence_TimeLaunch,"DATE","Arbitrary","1","WHOIDLA","Time of vehicle Launch, ISO8601 date timestamp" SIOGDC_Submergence_TimeRecovery,"DATE","Arbitrary","1","WHOIDLA","Time of vehicle Recovery, ISO8601 date timestamp" SIOGDC_Submergence_TimeStartData,"DATE","Arbitrary","1","WHOIDLA","Time of Start Data acquisition, ISO8601 date timestamp" SIOGDC_Submergence_Vehicle,"VARCHAR(4000)","Required","1","WHOIDLA","Name of Vehicle" SIOGDC_Submergence_WorkArea,"VARCHAR(4000)","Arbitrary","1","WHOIDLA","General Work Area of operations, not just this lowering"