This is the simplest output format available in EcoPlots. It contains all basic information about datasets, sites, visits and ecological observations in a bunch of CSV files.
No further data filtering, cleaning or processing is necessary. Data is ready to be analysed using any tool or programming language as R or Python.
Data is organised in different CSV files according to the Feature of interest selected in the filters.
Every CSV file begins with a set of columns that are common to each file.
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” file contains all the ecological observations based on the filtering done in the EcoPlots before the package generation. The first set of columns are common to every file:
The following columns are the ecological observations:
Each observation consist of three columns:
Result of the observation: The column header shows the name of the ecological parameter, aka observable property. (e.g scientificName). Values for this column contain the actual results of the observations made, for instance, the species name of the feature.
Result time: When the observation was made.
Method: 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 (when available), some extra columns are included in the CSV. Those columns are the “attributes of the feature of interest” (e.g plant-individual or soil-sample):
Attributes are easily identifiable because they consist exclusively of 1 column (there is no result time nor method). These attributes are not ecological observations, but contains important information about the feature, e.g. the depth of the soil sample, or the x,y position of a plant inside the site.
Data dictionary
Along with the data (observations) CSVs, a “data_dictionary” is included in the package, showing all columns available in the package.
The “Additional information” column contains links to the controlled vocabularies of the specific attributes or parameter. Below is the definition of field species name in the TERN controlled vocabulary.
0 Comments