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. (2022) Fire Ecology Traits for Plants: A database for fire research and management. Version 1.00. Centre for Ecosystem Science, University of New South Wales, Sydney, Australia. Retrieved from 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

Components of the project

Project overview

SQL structure of the database

🎯 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

Database content

An export of the SQL structure and initial data is available in Figshare:

Ferrer-Paris, José R.; Keith, David A. (2023). Fire Ecology Traits for Plants: Database snapshot (SQL dump). figshare. Dataset. https://doi.org/10.6084/m9.figshare.23361002.v1

WebApp

Code for running a Flask webapp available in the fireveg-webapp repository.

Code for managing the database

Code and instruction to perform several tasks in the database is available in the fire-veg-aust repository.