The Fire Ecology Traits for Plants project is being developed by José R. Ferrer-Paris and David Keith in the Centre for Ecosystem Science, University of New South Wales
Please cite this work as:
Ferrer-Paris, J. R. and Keith, D. A. (2024) Fire Ecology Traits for Plants: A database for fire research and management. Version 1.10. Centre for Ecosystem Science, University of New South Wales, Sydney, Australia. Retrieved from https://osf.io/hu96w
This work has been supported by:
- University of New South Wales
- NSW Bushfire Research Hub
- NESP Threatened Species Recovery Hub
- NSW Department of Planning & Environment (now Department of Climate Change, Energy, the Environment and Water)
🎯 This repository contains sql commands for defining the basic structure of the tables in a PostgreSQL database.
Instructions to use this repository are in the doc/ folder. SQL code is in the psql/ folder. Some figures in folder figs/.
This repository is part of the OSF project component:
Ferrer-Paris, J. R., & Sánchez-Mercado, A. (2023, September 12). SQL structure of the fireveg database. Retrieved from osf.io/4csyz
This project consists of several linked components:
🔥 Fire Ecology Traits for Plants: A database for fire research and management OSF project osf.io/hu96w with following components:
- 🗄️ SQL structure of the fireveg database osf.io/4csyz
- ⚙️ Source code for defining the structure of the tables in a PostgreSQL database is available in this GitHub repository <-- 🎯 You are here! -->
- 💼 Code for populating the fireveg database osf.io/rj68t
- ⚙️ Source code for populating and managing the database is available in this GitHub repository
- 💻 Webapp for browsing the fireveg database osf.io/rj68t
- ⚙️ Source code for setting up and running the Flask webapp id available in the GitHub repository
- 💻 Acess to the Webapp (Register with a verified email address)
- 📊 Data coverage of Fire Ecology Traits for Plants database osf.io/h96q2
- ⚙️ Source code in GitHub repository
- 🏷️ A Database snapshot (SQL dump) is available as a Figshare dataset with DOI:10.6084/m9.figshare.23361002
- 🏷️ Database exports (summary tables, CSV/XLSX formats) available as Figshare dataset with DOI:10.6084/m9.figshare.24125088
- 🧑💻 Fire Ecology Traits for Plants: Data analysis and visualisation osf.io/kjevh
- ⚙️ Source code in GitHub repository
- ⚙️ Source code in BitBucket repository
- 💬 Presentation slides