8 Formatting data tables

8.1 Darwin Core Term Checklist for OBIS

There are many Darwin Core terms listed in the TDWG quick reference guide. However, not all these terms are necessary for publishing data to OBIS.

For your convenience, we have created a checklist of all the Darwin Core terms relevant for OBIS data providers. You can reference this list to quickly see which terms are required by OBIS, which data table (Event, Occurrence, eMoF, DNA) they can be found in, and which Darwin Core class each term belongs to. These terms correlate with the IPT vocabulary mapping you will do when it comes time to publish your dataset. You may notice some terms are accepted in multiple data tables (e.g., Event and Occurrence) - this is because it depends on your dataset structure. If you have an Event Core, you will include some terms that would not be included if you had Occurrence Core. For guidance on specific class terms (e.g., location, taxonomy, etc.), see the Darwin Core section of the manual.

Note that when you publish your dataset on the IPT, if you use a term not listed below it will be an unmapped field and will not be published alongside your data. You may still wish to include such fields in your dataset if you are publishing to other repositories, just know that they will not be included in your OBIS dataset. You may include this information either by putting it in the dynamicProperties field in JSON format, or putting the information into the eMoF. Alternatively, you may have fields that you do not wish to be published and that do not correspond to one of these terms (e.g. personal notes). This is okay - if they are not mapped to one of the terms, that column in your dataset will not be published.

Table Legend:

  • Terms marked with 1 indicate that the specified term is accepted in the Event or Occurrence table, but preference is that they be recorded in the eMoF table in the measurementType column so they can be linked with controlled vocabulary
  • For the Occurrence table, distinction is made if the term could be used in the core or the extension table
Term OBIS Required Term’s DarwinCore Class Event core Occurrence core Occurrence extension eMoF Table DNA Table
eventDate required event x x
eventID required event x x x
decimalLatitude required location x x
decimalLongitude required location x x
occurrenceID required occurrence x x x x
occurrenceStatus required occurrence x x
basisOfRecord required record x x
scientificName required taxon x x
scientificNameID strongly recommended taxon x x
DNA_sequence strongly recommended dna x
env_broad_scale strongly recommended dna x
env_local scale recommended dna x
env_medium strongly recommended dna x
lib_layout recommended dna x
nucl_acid_amp recommended dna x
nucl_acid_ext recommended dna x
otu_class_appr recommended dna x
otu_db recommended dna x
otu_seq_comp_appr recommended dna x
pcr_primer_forward strongly recommended dna x
pcr_primer_name_forward strongly recommended dna x
pcr_primer_name_reverse strongly recommended dna x
pcr_primer_reference strongly recommended dna x
pcr_primer_reverse strongly recommended dna x
samp_name recommended dna x
samp_vol_we_dna_ext recommended dna x
seq_meth recommended dna x
sop recommended dna x
target_gene strongly recommended dna x
target_subfragment strongly recommended dna x
day recommended event x x
endDayOfYear recommended event x x
eventType strongly recommended event x
eventRemarks optional event x x
eventTime recommended event x x
fieldNotes optional event x x
fieldNumber optional event x x
habitat recommended event x x x
month strongly recommended event x x
parentEventID required (if exists) event x
sampleSizeUnit strongly recommended event x1 x1 x
sampleSizeValue strongly recommended event x1 x1 x
samplingEffort strongly recommended event x1 x1 x
samplingProtocol strongly recommended event x1 x1 x
startDayOfYear recommended event x x
verbatimEventDate recommended event x x
year strongly recommended event x x
bed optional geologicalContext x x x
earliestAgeOrLowestStage optional geologicalContext x x x
earliestEonOrLowestEonothem optional geologicalContext x x x
earliestEpochOrLowestSeries optional geologicalContext x x x
earliestEraOrLowestErathem optional geologicalContext x x x
earliestPeriodOrLowestSystem optional geologicalContext x x x
formation optional geologicalContext x x x
group optional geologicalContext x x x
highestBiostratigraphicZone optional geologicalContext x x x
latestAgeOrHighestStage optional geologicalContext x x x
latestEonOrHighestEonothem optional geologicalContext x x x
latestEpochOrHighestSeries optional geologicalContext x x x
latestEraOrHighestErathem optional geologicalContext x x x
latestPeriodOrHighestSystem optional geologicalContext x x x
lithostratigraphicTerms optional geologicalContext x x x
lowestBiostratigraphicZone optional geologicalContext x x x
member optional geologicalContext x x x
dateIdentified optional identification x x
identificationID optional identification x x
identificationQualifier recommended identification x x
identificationReferences optional (required for imaging data) identification x x
identificationRemarks recommended identification x x
identificationVerificationStatus optional (required for imaging data) identification x x
identifiedBy optional (required for imaging data) identification x x
identifiedByID optional identification x x
typeStatus optional identification x x
continent strongly recommended location x x
coordinatePrecision strongly recommended location x x
coordinateUncertaintyInMeters strongly recommended location x x
country recommended location x x
countryCode optional location x x
county optional location x x
footprintSpatialFit optional location x x
footprintSRS optional location x x
footprintWKT recommended location x x
geodeticDatum recommended location x x
georeferencedBy optional location x x
georeferencedDate optional location x x
georeferenceProtocol optional location x x
georeferenceSources optional location x x
higherGeography optional location x x
higherGeographyID optional location x x
island optional location x x
islandGroup optional location x x
locality recommended location x x
locationAccordingTo recommended location x x
locationID strongly recommended location x x
locationRemarks recommended location x x
maximumDepthInMeters strongly recommended location x x
maximumDistanceAboveSurfaceInMeters optional location x x
maximumElevationInMeters optional location x x
minimumDepthInMeters strongly recommended location x x
minimumDistanceAboveSurfaceInMeters optional location x x
minimumElevationInMeters optional location x x
municipality optional location x x
pointRadiusSpatialFit optional location x x
stateProvince optional location x x
verbatimCoordinates optional location x x
verbatimCoordinateSystem optional location x x
verbatimDepth optional location x x
verbatimElevation optional location x x
verbatimLatitude optional location x x
verbatimLocality optional location x x
verbatimLongitude optional location x x
verbatimSRS optional location x x
waterBody recommended location x x
materialSampleID recommended materialSample x x
measurementAccuracy recommended measurementOrFact x
measurementDeterminedBy optional measurementOrFact x
measurementDeterminedDate optional measurementOrFact x
measurementID recommended measurementOrFact x
measurementMethod recommended measurementOrFact x
measurementRemarks recommended measurementOrFact x
measurementType strongly recommended measurementOrFact x
measurementTypeID strongly recommended measurementOrFact x
measurementUnit strongly recommended measurementOrFact x
measurementUnitID strongly recommended measurementOrFact x
measurementValue strongly recommended measurementOrFact x
measurementValueID strongly recommended measurementOrFact x
associatedMedia recommended occurrence x x
associatedReferences optional occurrence x x
associatedSequences recommended occurrence x x
associatedTaxa optional occurrence x x
behavior optional occurrence x1 x1 x
catalogNumber recommended occurrence x x
disposition optional occurrence x x
establishmentMeans optional occurrence x x
georeferenceVerificationStatus recommended occurrence x x
organismQuantity (preferred over individualCount) strongly recommended occurrence x1 x1 x
organismQuantityType (preferred over individualCount) strongly recommended occurrence x1 x1 x
individualCount recommended occurrence x1 x1 x
lifeStage optional occurrence x1 x1 x
occurrenceRemarks recommended occurrence x x
otherCatalogNumbers optional occurrence x x
preparations optional occurrence x x
recordedBy recommended occurrence x x
recordedByID recommended occurrence x x
recordNumber recommended occurrence x x
reproductiveCondition optional occurrence x1 x1 x
sex optional occurrence x1 x1 x
associatedOccurrences optional organsim x x
associatedOrganisms optional organsim x x
organismID recommended organsim x x
organismName optional organsim x x
organismRemarks optional organsim x x
organismScope optional organsim x x
previousIdentifications recommended organsim x x
accessRights recommended record x x
bibliographicCitation recommended record x x
collectionCode optional record x x x
collectionID optional record x x x
dataGeneralizations optional record x x x
datasetID recommended record x x x
datasetName recommended record x x x
dynamicProperties recommended record x x x
informationWithheld optional record x x x
institutionCode optional record x x x
institutionID optional record x x x
language recommended record x x x
license strongly recommended record x x x
modified recommended record x x x
ownerInstitutionCode optional record x x x
references recommended record x x x
rightsHolder recommended record x x x
type strongly recommended record x x x x
acceptedNameUsage recommended taxon x x
acceptedNameUsageID recommended taxon x x
higherClassification recommended taxon x x
infraspecificEpithet recommended taxon x x
nameAccordingToID recommended taxon x x
namePublishedInID optional taxon x x
namePublishedInYear optional taxon x x
nomenclaturalCode optional taxon x x
nomenclaturalStatus optional taxon x x
verbatimIdentification recommended identification x x
originalNameUsage recommended taxon x x
originalNameUsageID recommended taxon x x
parentNameUsage recommended taxon x x
parentNameUsageID recommended taxon x x
phylum recommended taxon x x
scientificNameAuthorship recommended taxon x x
specificEpithet recommended taxon x x
subgenus recommended taxon x x
taxonConceptID optional taxon x x
taxonID optional taxon x x
taxonomicStatus optional taxon x x
taxonRank strongly recommended taxon x x
taxonRemarks recommended taxon x x
verbatimTaxonRank recommended taxon x x
vernacularName recommended taxon x x
class recommended taxon x x
family recommended taxon x x
genus strongly recommended taxon x x
kingdom strongly recommended taxon x x
order strongly recommended taxon x x