Projet ECOSFIX : interrogation de la base de données d'observations permettant de déterminer comment un type de forêt affecte les traits physiques et fonctionnels des racines.

Version 3.3
Perez, Jerome, 2022, "Projet ECOSFIX : interrogation de la base de données d'observations permettant de déterminer comment un type de forêt affecte les traits physiques et fonctionnels des racines.", https://doi.org/10.23708/H7GYTB, DataSuds, V3, UNF:6:Rg4omgKiJ8nmN6yKTBKDlA== [fileUNF]
Learn about Data Citation Standards.
Dataset Metrics
90 Downloads
Description
Requêtes PostgreSQL développées dans le cadre du projet ECOSFIX pour créer la base de données et en extraire les échantillons, les mesures des rhizotrons, les sites, les caractéristiques de sols, les données météorologiques, les parcelles, les parcelles avec leurs sites et les fichiers textes tabulaires contenant les données associées.
PostgreSQL queries developed as part of the ECOSFIX project to create the database and extract samples, rhizotron measurements, sites, soil characteristics, meteorological data, plots, plots with their sites and tabular text files containing the associated data.
Subject Computer and Information Science
Related Publication Référentiel de la structure de la base de données au format pdf - Database structure repository in pdf format doi: 10.15454/wakhnf/vz7mh0
Notes Projet visant à structurer, homogénéiser, gérer et analyser des données permettant de déterminer comment un type de forêt affecte les traits physiques et fonctionnels des racines.
Project aimed at structuring, homogenizing, managing and analyzing data to determine how a type of forest affects the physical and functional traits of roots.
License/Data Use Agreement

Custom Dataset Terms

Table
Tree
Filter by
1 to 10 of 17 Files
 Request Access
ecosfix.sql
ecosfix/script/SQL Code - 2.8 KB
Published Apr 1, 2022
14 Downloads
MD5: f1dec5c789b796064669941c3b6b5f47
Scripts PostgreSQL d'exportation des échantillons, des données météorologiques, des parcelles, des parcelles avec leurs sites, des mesures rhizotrons, des sites et des caractéristiques de sols vers un fichier texte (TSV) dont les champs sont séparés par tabulation déposé dans le répertoire windows C:\\Temp\\ - PostgreSQL scripts for exporting samples, meteorological data, plots, plots with their sites, rhizotron measurements, sites and soil characteristics to a text file (TSV) whose fields are separated by tabulation deposited in the windows directory C : \\Temp\\
Code
ecosfixmeteo_datas.tab
ecosfix/data/Tabular Data - 5.1 MB
Published Apr 1, 2022
3 Downloads
4 Variables, 150493 Observations UNF:6:xaS0gCku4HmEkH0Wa+0Hjw==
Liste des données météorologiques recensées dans un fichier texte dont les champs sont séparés par tabulation - List of meteorological data recorded in a text file whose fields are separated by tabulation
Données
ecosfixplots.tab
ecosfix/data/Tabular Data - 3.9 KB
Published Apr 1, 2022
1 Download
9 Variables, 76 Observations UNF:6:bIGlshVmWO2K5HhrlVsBPQ==
Liste des parcelles recensées dans un fichier texte dont les champs sont séparés par tabulation - List of plots recorded in a text file whose fields are separated by tabulation
Données
ecosfixplotwithsite.tab
ecosfix/data/Tabular Data - 5.7 KB
Published Apr 1, 2022
1 Download
11 Variables, 76 Observations UNF:6:h8pjJYhREVdt8+aq84FCdg==
Liste des parcelles avec sites d'appartenance recensées dans un fichier texte dont les champs sont séparés par tabulation - List of plots with sites of belonging recorded in a text file whose fields are separated by tabulation
Données
ecosfixrhizotron_measures.tab
ecosfix/data/Tabular Data - 92.6 KB
Published Apr 1, 2022
1 Download
27 Variables, 773 Observations UNF:6:dcxARGCsaXFzpx8yVgb4gQ==
Liste des mesures de rhizotrons recensées dans un fichier texte dont les champs sont séparés par tabulation. - List of rhizotron measurements recorded in a text file whose fields are separated by tabulation
Données
ecosfixsamples.tab
ecosfix/data/Tabular Data - 275.2 KB
Published Apr 1, 2022
1 Download
12 Variables, 4210 Observations UNF:6:DA1K/EmovTSLx2LITproqA==
Liste des parcelles recensées dans un fichier texte dont les champs sont séparés par tabulation - List of plots identified in a text file whose fields are separated by tabulation
Données
ecosfixsites.tab
ecosfix/data/Tabular Data - 579 B
Published Apr 1, 2022
1 Download
6 Variables, 9 Observations UNF:6:JtG4rihQtmSgSnvJkI8asw==
Liste des sites recensés dans un fichier texte dont les champs sont séparés par tabulation - List of sites identified in a text file whose fields are separated by tabulation
Données
ecosfixsoil_characteristics.tab
ecosfix/data/Tabular Data - 18.7 KB
Published Apr 1, 2022
1 Download
18 Variables, 346 Observations UNF:6:WdMdvcalFyF2xywpdBq0Wg==
Liste des caractéristiques de sols recensées dans un fichier texte dont les champs sont séparés par tabulation - List of soil characteristics recorded in a text file whose fields are separated by tabulation
Données
ecosfix_create.sql
ecosfix/script/SQL Code - 45.8 KB
Published Mar 29, 2022
9 Downloads
MD5: 175b4b958678f62e970d9162688ec1ac
Script PostgreSQL de création de la base de données ecosfix du projet ECOSFIX - PostgreSQL script for creating the ecosfix database of the ECOSFIX project
Code
ecosfix_echantillons.sql
ecosfix/script/SQL Code - 311 B
Published Apr 1, 2022
9 Downloads
MD5: a92c07214d644b233e689f065f5e7e10
Script PostgreSQL d'exportation des échantillons vers un fichier texte (TSV) dont les champs sont séparés par tabulation déposé dans le répertoire windows C:\\Temp\\ - PostgreSQL script for exporting samples to a text file (TSV) whose fields are separated by tabulation placed in the windows directory C:\\Temp\\
Code
Edit File

This file has already been deleted (or replaced) in the current version. It may not be edited.

Restrict Access

Restricting limits access to published files. People who want to use the restricted files can request access by default. If you disable request access, you must add information about access to the Terms of Access field.

Learn about restricting files and dataset access in the User Guide.

Enable access request
You must enable request access or add terms of access to restrict file access.
Save Changes
Edit Embargo

The selected file or files have already been published. Contact an administrator to change the embargo date or reason of the file or files.
Delete Files

The file will be deleted after you click on the Delete button.

Files will not be removed from previously published versions of the dataset.

Select File(s)

Please select one or more files.

Share Dataset

Share this dataset on your favorite social media networks.

Dataset Citations

Citations for this dataset are retrieved from Crossref via DataCite using Make Data Count standards. For more information about dataset metrics, please refer to the User Guide.

Sorry, no citations were found.
Restricted Files Selected

The selected file(s) may not be downloaded because you have not been granted access.

You may request access to the restricted file(s) by clicking the Request Access button.

Download Options

The files selected are too large to download as a ZIP.

You can select individual files that are below the 300.0 MB download limit from the files table, or use the Data Access API for programmatic access to the files.

Select File(s)

Please select a file or files to be downloaded.

Restricted Files Selected

The restricted file(s) selected may not be downloaded because you have not been granted access.

Click Continue to download the files you have access to download.

Delete Dataset

Are you sure you want to delete this dataset and all of its files? You cannot undelete this dataset.

Delete Draft Version

Are you sure you want to delete this draft version? Files will be reverted to the most recently published version. You cannot undelete this draft.

Unpublished Dataset Private URL

Private URL can only be used with unpublished versions of datasets.

Unpublished Dataset Private URL

Are you sure you want to disable the Private URL? If you have shared the Private URL with others they will no longer be able to use it to access your unpublished dataset.

Delete Files

The file(s) will be deleted after you click on the Delete button.

Files will not be removed from previously published versions of the dataset.

Compute

This dataset contains restricted files you may not compute on because you have not been granted access.

Deaccession Dataset

Are you sure you want to deaccession? The selected version(s) will no longer be viewable by the public.

Deaccession Dataset

Are you sure you want to deaccession this dataset? It will no longer be viewable by the public.

Version Differences Details

Please select two versions to view the differences.

Version Differences Details
 
Version:
Last Updated:
Version:
Last Updated:
Select File(s)

Please select a file or files for access request.

Select File(s)

Embargoed files cannot be accessed. Please select an unembargoed file or files for your access request.

Edit Tags

Select existing file tags or create new tags to describe your files. Each file can have more than one tag.

Request Access

  You need to Log In to request access.

Dataset Terms

This dataset is made available under the following terms. Please confirm and/or complete the information needed below in order to continue.

Our Community Norms as well as good scientific practices expect that proper credit is given via citation. Please use the data citation shown on the dataset page.

Custom Dataset Terms — the following Custom Dataset Terms have been defined for this dataset.


This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Preview Guestbook

Upon downloading files the guestbook asks for the following information.

Account Information

Package File Download

Use the Download URL in a Wget command or a download manager to download this package file. Download via web browser is not recommended. User Guide - Downloading a Dataverse Package via URL

https://dataverse.ird.fr/api/access/datafile/

Request Access

Please confirm and/or complete the information needed below in order to request access to files in this dataset.

Les fichiers contenant les données de la base ecosfix, ne sont rendus accessibles que sur demande.
The files containing the ecosfix database data are only made accessible on request.
Compute Batch
Clear Batch
Dataset Persistent Identifier Change Compute Batch
Compute Batch
Submit for Review

You will not be able to make changes to this dataset while it is in review.

Publish Dataset

Are you sure you want to republish this dataset?

Select if this is a minor or major version update.

Publish Dataset

This dataset cannot be published until AMAP BASES DE DONNEES is published by its administrator.

Publish Dataset

This dataset cannot be published until AMAP BASES DE DONNEES and UMR AMAP are published.

Return to Author

Return this dataset to contributor for modification.