This document describes the DASSH dataset.

Table list:

survey
Survey Table
(each row represents a survey)

survey_att
Survey Attributes Table
(each row represents an attribute associated with a survey)

event
Event Table
(each row represents an event e.g. a sample or station)

event_att
Event Attributes Table
(each row represents an attribute associated with an event)

occ
Occurrence Table
(each row represents a species occurrence)

occ_att
Occurrence Attributes Table
(each row represents an attribute associated with a species occurrence)

Survey fields description:
survey_code - a unique code identifying this survey assigned by the originator or DASSH
project_code - the ID for the project, if survey is part of one
survey_name - the name of the survey
metadata_id - the ID for this dataset's metadata record on MEDIN
resource_id - the DASSH ID for this dataset (a dataset may consist of multiple surveys)
originator - the original creator of the dataset
start_date - the first day of the survey
end_date - the last day of the survey
abstract - a description of the survey

Event fields description:
survey_code -  a unique code identifying this survey assigned by the originator or DASSH
event_code -  a unique ID for this event
parent_event_id - if this event belongs to another event (e.g. a sample belonging to a station) then it will be linked here
latitude - the central latitude of the event in decimal degrees
longitude - the central longitude of the event in decimal degrees
date - the average date of the event
time - the average time of the event (optional)
source_table - original table/sheet in original format from which event was sourced

Occ fields description:
survey_code - a unique code identifying this survey assigned by the originator or DASSH
event_code - a unique ID for this event
occ_code - a unique ID for this species occurrence
taxon - the name of this taxon
aphia_id - the WoRMS aphiaID for this taxon
abundance - the abundance value of this occurrence
abundance_type - the abundance type of this occurrence
source_table - original table/sheet in original format from which occurrence was sourced

Attribute fields description:
att_type - the name of the attribute
att_type_id - link to vocab entry defining attribute type (optional)
att_value - the attribute's value
att_value_id - link to vocab entry defining value (optional)
att_units - the attribute's units
att_units_id - link to vocab entry defining the units (optional)
source_table - original table/sheet in original format from which attribute was sourced
group_id - if attribute was joined with others in the original dataset then they share this ID

Also included:

original_MEDIN_guideline.xlsx 
The source MEDIN Guideline that was read into our shared database.