Welcome to TERN Knowledge Base
TERN Ontology output Description
The TERN Ontology output is the most specialised of the three available output formats available in Ecoplots. Whereas the file format is a common CSV, the structure of the data package (files) and the content is meant to represent a complete image of the TERN Ontology used to model the data internally in EcoPlots.
Multiple CSV files are provided in the package representing different entities from the TERN Ontology:
- 1 Files
- 1.1 Data dictionary
- 1.2 Data Source
- 1.2.1 Datasource attributes
- 1.3 Site
- 1.3.1 Site attributes
- 1.4 SiteVisit
- 1.4.1 SiteVisit attributes
- 1.5 Observations
- 1.6 Taxon
- 2 How to link all files
Files
Data dictionary
Along with the data CSVs, a “data_dictionary” is included in the package.
It shows all columns included in the package, their datatype, definitions, and where to find additional information.
Data Source
It contains the information of every Data source or Dataset contained in the data extraction. It represents the RDF class Dataset in the Ontology.
Fields provided in the file:
FieldName | DataType | Description |
|---|---|---|
dataset | Text | Name/label of the dataset (Label) |
datasetUri | Text | Unique identifier of the dataset (URI) |
parentDataset | Text | Name/label of the parent dataset (Label) |
parentDatasetUri | Text | Unique identifier of the parent dataset (URI) |
datasetType | Text | Type of the dataset (data source, dataset, project) |
description | Text | Description of the dataset |
abstract | Text | Abstract of the dataset |
version | Text | Version of the dataset |
created | Text | Date of dataset's creation |
creator | Text | Creator of the dataset (Label) |
creatorId | Text | Creator of the dataset (URI) |
publisher | Text | Publisher of the dataset (Label) |
publisherId | Text | Publisher of the dataset (URI) |
Datasource attributes
It contains, if any, a list of Attributes of the Datasets. An Attribute is a property-value pair to capture attributes of an individual entity.
FieldName | DataType | Description |
|---|---|---|
attributeId | Text | Unique identifier of the attribute (URI) |
datasetId | Text | Unique identifier of the dataset instance (URI) |
attributeName | Text | Attribute (URI) |
attributeConceptId | Text | Attribute (URI) |
value | Text | Value |
valueId | Any | Unique identifier of the categorical value, if apply (URI) |
valueUnit | Text | Unit of measure of the value (Label) |
valueUnitId | Text | Unit of measure of the value (URI) |
Site
It contains intances of the class Site, representing ecological monitoring sites where observations and samplings occur.
FieldName | DataType | Description |
|---|---|---|
dataset | Text | Name/label of the dataset (Label) |
datasetId | Text | Unique identifier of the dataset (URI) |
project | Text | Name/label of the project (Label) |
projectId | Text | Unique identifier of the project (URI) |
siteName | Text | Name/label of the site (Label) |
siteId | Text | Unique identifier of the site (URI) |
siteType | Text | Type of site (site, plot, transect, quadrat, etc.) (Label) |
siteTypeId | Text | Type of site (site, plot, transect, quadrat, etc.) (URI) |
parentSiteName | Name/label of the parent site (Label), if apply |
|
parentSiteId | Unique identifier of the parent site (URI), if apply |
|
topParentSiteName | Text | Name/label of the top parent site (Label), if apply |
topParentSiteId | Text | Unique identifier of the top parent site (URI), if apply |
dateCommissioned | Date | Date of establishment of the site |
description | Text | Description of the site |
polygonWkt | Text | Site polygon geometry in WKT representation |
pointWkt | Text | Site point geometry in WKT representation |
latitude | Number | Latitude |
longitude | Number | Longitude |
altitude | Number | Altitude |
pointPositionWithinPlot | Text | Position of the point within plot (south west, centroid, etc.) (Label) |
pointPositionWithinPlotId | Text | Position of the point within plot (south west, centroid, etc.) (URI) |
Site attributes
It contains, if any, a list of Attributes of Sites. An Attribute is a property-value pair to capture attributes of an individual entity.
FieldName | DataType | Description |
|---|---|---|
attributeId | Text | Unique identifier of the attribute (URI) |
siteId | Text | Unique identifier of the site instance (URI) |
attributeName | Text | Attribute (URI) |
attributeConceptId | Text | Attribute (URI) |
value | Text | Value |
valueId | Any | Unique identifier of the categorical value, if apply (URI) |
valueUnit | Text | Unit of measure of the value (Label) |
valueUnitId | Text | Unit of measure of the value (URI) |
SiteVisit
It contains intances of the class SiteVisit, representing visits (or surveys) ecological monitoring sites where observations and samplings occur.
FieldName | DataType | Description |
|---|---|---|
dataset | Text | Name/label of the dataset (Label) |
datasetId | Text | Unique identifier of the dataset (URI) |
project | Text | Name/label of the project (Label) |
projectId | Text | Unique identifier of the project (URI) |
siteName | Text | Name/label of the site (Label) |
siteId | Text | Unique identifier of the site (URI) |
siteVisitName | Text | Name/label of the site visit (Label) |
siteVisitId | Text | Unique identifier of the site visit (URI) |
siteVisitStartDate | Date | Start date of the visit to the site |
siteVisitEndDate | Date | End date of the visit to the site |
description | Text | Description of the site visit |
SiteVisit attributes
It contains, if any, a list of Attributes of SiteVisits. An Attribute is a property-value pair to capture attributes of an individual entity.
FieldName | DataType | Description |
|---|---|---|
attributeId | Text | Unique identifier of the attribute (URI) |
siteVisitId | Text | Unique identifier of the site visit instance (URI) |
attributeName | Text | Attribute (URI) |
attributeConceptId | Text | Attribute (URI) |
value | Text | Value |
valueId | Any | Unique identifier of the categorical value, if apply (URI) |
valueUnit | Text | Unit of measure of the value (Label) |
valueUnitId | Text | Unit of measure of the value (URI) |
Observations
It contains a list of Observations made from feature of interests (FoI). A unique file is provided by FoI type. This is the main class (hence file) of the ontology, and can be used as the starting point for connecting/linking the data from all files.
FieldName | DataType | Description |
|---|---|---|
dataset | Text | Name/label of the dataset (Label) |
datasetId | Text | Unique identifier of the dataset (URI) |
project | Text | Name/label of the dataset/project (Label), if apply |
projectId | Text | Unique identifier of the dataset/project (URI), if apply |
latitude | Number | Latitude |
longitude | Number | Longitude |
altitude | Number | Altitude |
siteName | Text | Name/label of the site (Label), if apply |
siteId | Text | Unique identifier of the site/plot/transect/quadrat where the observation was done (URI), if apply. This column should be used to join with the site/plot/trasenct/quadract csv |
topParentSiteName | Text | Name/label of the top parent site (Label), if apply |
topParentSiteId | Text | Unique identifier of the top parent site (URI), if apply |
siteVisitName | Text | Name/label of the site visit (Label), if apply |
siteVisitId | Text | Unique identifier of the site visit (URI), if apply |
observationId | Text | Unique identifier of the observation (URI) |
featureId | Text | Unique identifier of the feature of interest (URI) |
featureType | Text | Type of feature of interest (plant specimen, landform, etc.) (Label) |
featureTypeId | Text |