Description

__Introduction__ This repository provides the code and documentation used to generate the structure of Canada’s Forest Soil Database, developed by the Canadian Forest Service. The database structure was designed to support the organization, integration, and long-term management of forest soil data collected across Canada. By defining a standardized and flexible data model, this repository helps address the diversity and fragmentation of existing soil datasets and provides a foundation for compiling legacy data, supporting future data collection, improving data accessibility in alignment with FAIR data principles and supporting data integration with related databases and data compilations efforts. __Repository content and related tools__ This repository contains the SQL code and Docker configuration required to generate and deploy the database structure. More technical documentation available soon. __Data model origin__ The database structure is built on a flexible data model adapted from the [ISO 28258](https://iso28258.isric.org/) and [OGC Observations and Measurements](https://www.ogc.org/standards/om/) conceptual model. It is organized around three core categories: ___Features of Interest___, ___Observations___, and ___Results___. This approach provides a consistent framework for representing the objects being described, the measurements or descriptions associated with them, and the resulting values or information produced by those observations. __Model adaptations__ Several adaptations were made to better support the needs of Canada’s Forest Soil Database. ___Features of Interest___ derived from ___ ISO 28258___ are represented as separate elements. The data model created for Canada’s Forest Soil Database provides a unified way to manage these elements within a single table. Similarly, specific ___Observations___ made on specialized ___Features of Interest ___ are handled within a unified ___Observations___ table. In addition, the ___Feature of Interest context___ and ___Observation context ___ concepts from the ___OGC Observations and Measurements___ conceptual model are implemented through a many-to-many relationship, allowing the database to capture complex links between features and their observational context. __Design rationale__ These design choices were made to streamline data processing and improve the long-term flexibility of the database. By using a common structure for different types of Features of Interest, Observations, and Results, the database is not limited to soil and can accommodate a wider variety of above and below-ground forest data without requiring changes to the underlying database schema each time new data types are introduced. This makes the model better suited for integrating legacy datasets, supporting future data collection, and maintaining consistency across diverse sources of information. __Related Resources__ > [Canada’s forest soils: the establishment of a nationwide network of long-term sites to examine soil carbon persistence and soil indicators](https://cdnsciencepub.com/doi/10.1139/cjss-2026-0052) > [Post-Disturbance Soil Monitoring in Forests using Remote Sensing: An Evidence Map](https://egusphere.copernicus.org/preprints/2026/egusphere-2026-1722/) > [Collecting, analysing and storing forest soil data and samples in the age of big data: A guide for Researchers and Filed Practitioners.](https://ostrnrcan-dostrncan.canada.ca/entities/publication/321002fa-1d57-4892-8f0f-9d64cbb65c6a) > [A guide to collecting forest soil samples](https://ostrnrcan-dostrncan.canada.ca/entities/publication/e499b9f7-742c-4927-ac7e-1d30851883f9) > [A guide to soil preparation for bulk density and chemical analysis](https://ostrnrcan-dostrncan.canada.ca/entities/publication/a30ddf23-1c59-4d4b-94e1-3bad48ecc7d0) __Citation__ Please cite this code repository as: > Natural Resources of Canada – Canadian Forest Service, Norris, C., Paré, D., Laganière, J., Webster, K., Malet, X., & Dallaire, C. (2026). « Canada’s Forest Soil Database Schema and Structure » (Version 1.0.0) [Database]

Resources

Name	Format	Description	Link
Docker Deployment of the Canada’s Forest Soil Database	ZIP		https://open.canada.ca/data/dataset/8faaebad-c5a6-4189-93eb-843d229ff942/resource/5671f3aa-ee93-4eb0-9297-52eef30e1abd/download/docker_compose_deployment.zip
Data Dictionary of the Canada’s Forest Soil Database (French Version)	Unknown		https://open.canada.ca/data/dataset/8faaebad-c5a6-4189-93eb-843d229ff942/resource/a84be78d-6b3c-40ab-9adf-3b5488267174/download/data_dictionnary_fr.md
SQL Code to create the Canada’s Forest Soil Database	ZIP		https://open.canada.ca/data/dataset/8faaebad-c5a6-4189-93eb-843d229ff942/resource/bcb9ed44-5f7c-44c4-be90-9b20112447ec/download/database_schema.zip
Data Dictionary of the Canada’s Forest Soil Database (English Version)	Unknown		https://open.canada.ca/data/dataset/8faaebad-c5a6-4189-93eb-843d229ff942/resource/eb7fdb3e-bf4b-47d1-8956-ea5d862d4258/download/data_dictionnary.md

Tags

Topics

Categories