Fire Ecology database (FEDB)

The Fire Ecology database 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. (2025) Fire Ecology database to inform fire ecology research and management. Version 1.1.1. 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

Source code for preparing data records

🎯 This repository contains R, Python and SQL code to export data records from the database and upload to data repositories.

The code is documented using Jupyter Notebooks.

This repository is part of the OSF project component:

Ferrer-Paris, J. R., Keith, D., & Sánchez-Mercado, A. (2024, August 14). Export data records from Fire Ecology Traits for Plants database. Retrieved from osf.io/h96q2

This code is intended for internal project management. 🛂 Only users contributing directly to the project have access to the credentials for database connection and write access to our repositories.

Instructions and documentation are provided for the sake of reproducibility, feel free to use them as inspiration for your project.

Project overview

This project consists of several linked components:

🔥 Fire Ecology database: A database for fire research and management OSF project osf.io/hu96w with following components:

• 🗄️ SQL structure of the database / OSF project component osf.io/4csyz
  • ⚙️ Source code for defining the structure of the tables in a PostgreSQL database is available in this GitHub repository
• 💼 Code for database imports and data curation / OSF project component osf.io/rj68t
  • ⚙️ Source code for populating and managing the database is available in this GitHub repository
• 💻 Webapp for browsing the Fire Ecology database / OSF project component 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 database / OSF project component osf.io/h96q2
  • ⚙️ Source code in GitHub repository <-- 🎯 You are here! -->
  • 🏷️ Data in Figshare DOI:10.6084/m9.figshare.23361002
  • 🏷️ Data in Figshare DOI:10.6084/m9.figshare.24125088
• 🧑‍💻 Data analysis and visualisation / OSF project component osf.io/kjevh
  • Notebooks with code and plots
    • ⚙️ Source code in GitHub repository
  • Presentations
    • ⚙️ Source code in BitBucket repository
    • 💬 Presentation slides