ices-eg / WGJCDP-Cetaceans

Joint Cetaceans Data Portal (development)
Creative Commons Zero v1.0 Universal
4 stars 0 forks source link

Survey instance definition #240

Closed neil-ices-dk closed 2 years ago

neil-ices-dk commented 2 years ago

from Nikki:

Definition of a survey – attempt 1:

'Survey'

The term 'survey' may be applied differently between organisations, depending on how data are collected. In order to reduce the burden of data uploads and associated metadata, the data submitter may combine multiple 'survey events' into a single 'survey'. Therefore, for this purpose, a 'survey' is:

'Data collection within a single calendar year using a single methodology and/or within a pre-defined area or route'.

SurveyID now: year organisation location (previously date org location surveytype)_

neil-ices-dk commented 2 years ago

'Data collection within a single calendar year using a single methodology and/or within a pre-defined area or route'.

will there be a situation when a contiguous survey is conducted seasonally and therefore traversing a calendar year?

NikkiTaylorJNCC commented 2 years ago

'Data collection within a single calendar year using a single methodology and/or within a pre-defined area or route'.

will there be a situation when a contiguous survey is conducted seasonally and therefore traversing a calendar year?

There are seasonal surveys but I would expect them to upload annually ...assume this would therefore be counted as different surveys and that they aren't able to add data to an existing survey...

neil-ices-dk commented 2 years ago

Conclusion: SurveyID = year:organisation:location Description = Data collection within a single calendar year using a single methodology and/or within a pre-defined area or route


Whether to allow multiple surveyID's in one file submission? there are pro's and con's for either approach; for the 'big' submitters of multiple surveys, it could be an idea to have an R script that generates the XML output packaged into files. @NikkiTaylorJNCC will investigate if there are resources that can support this development

neil-ices-dk commented 2 years ago

@cmspinto to make changes to database to reflect new key @pcrjoana to make changes to Excel Template/format @NikkiTaylorJNCC to make changes to Data standard For primary and secondary platforms on same survey; add new field on sightings and effort records to identify which one is which

neil-ices-dk commented 2 years ago

@NikkiTaylorJNCC and @pcrjoana fieldname = PlatformInstance dropdown vocab; 'Primary', 'Secondary'

neil-ices-dk commented 2 years ago

@cmspinto agreed to have export to multiple files using Excel VBA functionality; agreed that this will need some heavy testing by ICES with real data, and by Lucy with real data

neil-ices-dk commented 2 years ago

image change text to 'Errors'