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 datasetrelated to features of interest. The data in each CSV is grouped according to the Feature of interest selected selected with the filters during during the search process. No further data filtering, cleaning or processing is necessary as data in each file is ready to can be analysed using any tool or programming language such as R or Python.
There are two Two types of CSV files are included in each dataset package.
| Table of Contents | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
Data Packages
TERN data packages are can be downloaded to the local machine in the form of as compressed zip files. Once it is uncompressed, the folder structure contain contains a data folder with the CSV files containing the data dictionary and observations (see below image). The data dictionary file is represented by the naming convention “data_dictionary_packagerID”; observation files are represented by “feature-of-interest-name_observations_packagerID”. Observations related to each feature of interest are stored in individual CSV files.
...
Each CSV contains a common base set of data columns to fully identify each record. Brief The table below gives brief definitions of each column have been given in the table below..
...
Observations data specific to a Feature of Interest
The observation CSV files contain all the information related to the observation. The common set of attributes in the CSV files are as follows:
Column | Description |
|---|
datasetTitle | Datasource/Dataset to which this data row belongs to. |
projectTitle | Project to which this data row belongs to. |
siteName | Ecological site where data was collected. |
parentSiteName | Ecological site name, which is the parent of the site where data was collected |
latitude_Degree | Latitude geographic coordinate of ecological site. |
longitude_Degree | Longitude geographic coordinate of ecological site. |
plotWidth_Metre | plot dimension width |
plotLength_Metre | plot dimension length |
topParentSiteName |
The larger site to which this ecological site belongs to. |
siteVisitName |
unique identifier of the |
site visit instance |
siteVisitStartDate |
Start date of the site visit |
siteVisitEndDate |
End date of the site visit |
featureType | The feature of interest type related to the observation (e.g., a plant individual, plant specimen, landform, weather, etc.). |
featureId | Unique identifier of the feature, e.g. stem-1a, tree-1, bird-0123456, specimen-ABC123 |
featureType
. | |
parentFeatureId | Unique identifier of the greater feature to which the current feature is part of, e.g. tree-1 -> stem-1b. |
This is how they appear inside the CSV:
...
...
The sample CSV file is shown below:
...
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.
...
Each observation consist of three columns:
Result of the observation: The column header shows the name of the ecological parameter (i.e. scientificName). Values for this column contain the actual results of the observations made, for instance, the species name of that feature.
Result time: When the observation was made.
Method: Link This is a link to the vocabulary of the Method/Procedure. Opening the link on any Internet browser will show all the information about the protocol following for collecting the data.
In very specific cases, there may be some extra columns that are may be included in the CSV. Those columns are the “attributes of the feature of interest” (i.e. plant-individual or soil-sample):
...
Attributes are easily identifiable because they consist exclusively of 1 column (there is no result time or method). These attributes are not ecological observations , but contains contain important information about the feature, i.e. the depth of , the soil sample, or the 's depth or a plant's relative position of a plant within the site.
...
Data dictionary
Along with the data CSVs, a “data_dictionary” is included in the package. It shows all columns included in the package, as well as their definitions, and where to find additional information.
...
| Info |
|---|
The “Additional information” column contains links to the controlled vocabularies of the specific attributes or parameterparameters. Below is the definition of field species name in the TERN-controlled vocabulary. |
