Versions Compared

Key

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

...

TERN data packages are downloaded to the local machine in the form of compressed zip files. Within Once it is uncompressed, the uncompressed folder structure will be contain a data folder containing with the CSV files (see below image).

...

Each CSV contains a common base set of data columns to fully identify each record. Brief definitions of each column have been given in the table below.

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.

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 fileThis is how they appear inside the CSV:

...

...

Observations data specific to a Feature of interest

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

...