Research output per year
Research output per year
Description
Scope
This dataset provides the SQL version of the ShareTrait database, corresponding to ShareTrait version 1.2.0. It represents the structured database equivalent of the previously published dataset, ShareTrait: a data portal for making trait data interoperable and reusable, version 1.0.0 (Zenodo, July 12, 2023, DOI: 10.5281/zenodo.8138904). This version includes the database file, an SQL query, and the resulting output file generated from the SQL query.
Dataset content
The repository provides:
ShareTrait-database-v1.2.0.db : the database file.
master-query-all.sql : SQL query used for reconstructing the dataset.
master-query-output.csv : SQL query output file .
ShareTrait-dataset-database-mapping.csv : mapping of attribute fields from the SQL query output to the corresponding attributes in ShareTrait_MetaData_v1.0.0.csv, with relevant column name = "Column_name", version 1.0.0 (DOI: 10.5281/zenodo.8138904)
Access and usage
Files and documentation are available on GitHub: ShareTrait Project. Users can execute the SQL query by using either SQLiteStudio or SQLite3. Detailed instructions are provided in this repository README.
This dataset provides the SQL version of the ShareTrait database, corresponding to ShareTrait version 1.2.0. It represents the structured database equivalent of the previously published dataset, ShareTrait: a data portal for making trait data interoperable and reusable, version 1.0.0 (Zenodo, July 12, 2023, DOI: 10.5281/zenodo.8138904). This version includes the database file, an SQL query, and the resulting output file generated from the SQL query.
Dataset content
The repository provides:
ShareTrait-database-v1.2.0.db : the database file.
master-query-all.sql : SQL query used for reconstructing the dataset.
master-query-output.csv : SQL query output file .
ShareTrait-dataset-database-mapping.csv : mapping of attribute fields from the SQL query output to the corresponding attributes in ShareTrait_MetaData_v1.0.0.csv, with relevant column name = "Column_name", version 1.0.0 (DOI: 10.5281/zenodo.8138904)
Access and usage
Files and documentation are available on GitHub: ShareTrait Project. Users can execute the SQL query by using either SQLiteStudio or SQLite3. Detailed instructions are provided in this repository README.
| Date made available | 2025 |
|---|---|
| Publisher | Zenodo |
Research output
- 1 Article
-
ShareTrait: towards interoperable and reusable individual trait-based data in ectotherms
Leiva, F. P., Ellers, J., Berg, M. P., Cuxart-Erruz, R., Barneche, D. R., Blackburn, T. M., Castañeda, L. E., Chown, S. L., Gaitán-Espitia, J. D., Gebauer, P., Gomez Isaza, D. F., Hardy, I. C. W., Hermaniuk, A., Hirst, A. G., Jorissen, S., Keasar, T., Koene, J. M., Le Lann, C., Martorelli, I. & Molinet, C. & 17 others, , 1 Nov 2025, In: Functional Ecology. 39, 11, p. 3124-3138 15 p.Research output: Contribution to journal › Article › peer-review
Open AccessFile