Implementation of the wildlife monitoring standard on excel

Enetwild consortium developed a data standard on wildlife monitoring data to aggregate raw data such as occurrences, drive hunt hunting bags, distance sampling data, or aggregated or estimated data such as density estimates, summarized hunting bags, probability of presence. This standard is based on the Darwin Core standard, using the Event core, the Occurrence extension, the extended measurement or fact extension. We proposed to extend the measurement or fact extension to allow them to be nested among themselves for recording confidence intervals and precision information. We offer the possibility to nest occurrences within each other as well. We propose controlled vocabularies in relation to statistical information, in both data and metadata. In addition to a single metadata sheet, this Excel file proposes two ways to enter a dataset. The first option is to record events, occurrences, and measurements in different sheets, which is similar to the option proposed by GBIF in its Integrated Publishing Toolkit. The second option is to record events, occurrences and measurements in a single sheet (data_AllInOne) with the help of conditional formatting, working on the most recent version of Excel.

This is in line with the EFSA data model harmonisation under the SIGMA project.