4.4 How to format Event tables

If your dataset uses an Event Core structure, data fields included in your dataset should include the following required terms:

eventDate
eventID
parentEventID (if applicable)
decimalLatitude
decimalLongitude

Other terms you should consider adding are grouped by their associated Darwin Core class in the table below. See the term checklist for a more complete list of DwC terms for the Event table.

Class Event | DwC:parentEventID
Class Event | DwC:eventRemarks
Class Event | DwC:eventType
Class Event | DwC:year
Class Event | DwC:month
Class Event | DwC:day
Class Event | DwC:type
Class Location | DwC:country
Class Location | DwC:island
Class Location | DwC:coordinateUncertaintyInMeters
Class Location | DwC:countryCode
Class Location | DwC:footprintWKT
Class Location | DwC:geodeticDatum
Class Location | DwC:islandGroup
Class Location | DwC:locality
Class Location | DwC:locationAccordingTo
Class Location | DwC:locationID
Class Location | DwC:locationRemarks
Class Location | DwC:maximumDepthInMeters
Class Location | DwC:minimumDepthInMeters
Class Location | DwC:stateProvince
Class Location | DwC:verbatimCoordinates
Class Location | DwC:verbatimDepth
Class Location | DwC:waterBody

Terms related to measurements, either biotic (e.g., sex, lifestage) or abiotic will be included in extendedMeasurementOrFact table not the Event Core or Occurrence extension table.

4.4.0.1 Stepwise Guidance to Format Event Table (with spreadsheets)

Before proceeding with the below, make sure each record already has an eventID.

Add and fill the parentEventID and eventRemarks fields as applicable
Identify the hierarchical event structure in your data, if present and create new records for parent Events, filling in any relevant fields
Identify all columns in your data that will match with Darwin Core Event fields
- Include any relevant abiotic measurements (ENV-DATA) related to sampling events (e.g. sampling protocols). We will add these to the eMoF table later
Copy these columns to a new sheet and name it Event
Delete duplicate data so only unique events are left
Ensure dates and time are formatted according to ISO 8601 standards in the eventDate field
Add any other relevant fields as indicated above
Map fields to Darwin Core

Watch the video tutorial of this process below.

After completing the formatting of your Event Core table, you can next format your extendedMeasurementOrFact table. To format the Occurrence extension table, see the Occurrence table section of this manual. Note that there is a difference between how OBIS and GBIF populate fields in parent and child events. In OBIS, child events inherit parent event information. However, if parentEvent contains latitude/longitude coordinates, and child events do not, occurrences associated with the child events will have blank latitude/longitude coordinates because these fields are not currently inherited by parent events by GBIF. If you intend for your dataset to be published to GBIF you may consider populating both parent and child events. A discussion of this and the implications can be found here.