Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This output format is the most used in EcoPlots. The file contains all the information about the sites, visits and ecological observations that are applicable to that dataset. The data is organised into different CSV files in each CSV is grouped according to theFeature of interest selected with the filters during the search process. No further data filtering, cleaning or processing is necessary as data in each file is ready to be analysed using any tool or programming language as R or Python.

...

In addition, each CSV begins with a an common base set of data columns that are common to every TERN CSV fileto fully identify each record.

Column

Description

dataset
Datasource/Dataset to which this data row belongs to.
project
Project to which this data row belongs to.
siteName
Ecological site where data was collected.
latitude
Latitude geographic coordinate of ecological site.
longitude
Longitude geographic coordinate of ecological site.
topParentSiteName
Greater site to which this ecological site belongs to.
siteVisitName
Identificator of the visit to the site when data was collected.
siteVisitStartDate
Starting date of the visit to the site.
siteVisitEndDate
Ending date of the visit to the site.
featureId
Unique identifier of the feature, e.g. stem-1a, tree-1, bird-0123456, specimen-ABC123.
featureType
Feature of interest type, i.e. observed feature like plant individual, plant specimen, landform, weather, etc.).
parentFeatureId
Unique identifier of the greater feature to which the current feature is part of, e.g. tree-1 -> stem-1b.

Observations CSV (data)

Every “observations” Every “observation” file contains all the ecological observations recorded during sampling. The data inclusion is based on the filtering done in the EcoPlots before the package generation. The first set of columns are common to every file:

...

...

Observations data

The following columns in the image below are the ecological observations:specific ecological observations that can be found in the columns to the right of the base data columns. The specific data included in each file is based on the filtering done during the EcoPlots searching process before the package generation.

...

Each observation consist of three columns:

...