Fire Ecology Traits for Plants

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)

Components of the project

SQL structure of the database

🎯 This repository contains several Jupyter notebooks with code and instruction to populate and manage the database.

Visualisation of the notebooks is possible in GitHub, or in the Jupyter Notebook Viewer.

Instructions to use this repository are in the Instructions and workflow Notebook.

This repository is part of the OSF project component:

Ferrer-Paris, J. R. (2024, August 16). Code for populating and managing the fireveg database. Retrieved from osf.io/znuge

Project overview

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
• 💼 Code for populating the fireveg database osf.io/rj68t
  • ⚙️ Source code for populating and managing the database is available in this GitHub repository <-- 🎯 You are here! -->
• 💻 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)
• 📊 Export data records from 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