Your data contribution is what makes GAZP a growing resource for dryland restoration ecologists. In order to facilitate rapid processing and database updates, we require that contributors format their data in a standardized structure for submission. Each step below describes the key components for data contribution.
There are two downloadable files: the first is the Excel workbook that should be filled out for your data submission. Each step below is represented in that workbook as one or more individual worksheets. Please go sheet by sheet and fill in all relevant data.
The second downloadable file is a PDF document that provides a legend for each of the worksheets. All columns are explained in detail. Please look at the legend in detail as you work through each sheet.
Fill the data contribution workbook out and submit it online using the Data Submission step at the bottom of this page. If this work is published, either in a scientific journal or other type report, please include that work in the Data Submission step at the bottom of the page.
If you have reference data (intact vegetation monitoring data), please include that data and treat it as a treatment in the data. Thus, it will be included in the same single data contribution workbook.
If processing in this way is a significant barrier to your involvement, please contact the project leadership team at email@example.com and discuss alternatives. Also please reach out with feedback or questions on this process.
GAZP Data Contribution Legend
This is the Excel file required for data contribution. Please download it and fill out all relevant sections. Please do NOT alter column headers (with one exception in “Monitoring results_opt2”). Please do NOT skip worksheets unless the instructions below explicitly say they are optional.
GAZP Data Contribution File
This is the PDF document providing a detailed legend for each worksheet in the data contribution workbook.
Step 1: Site details
This worksheet outlines the overarching site details, with each site as a single row in the data sheet.
Step 2: Treatment details
This worksheet outlines restoration treatments implemented, with each treatment as a single row in the data sheet.
Step 3: Species details
This step details all species added or found in the project. There are three worksheets within the workbook for this step: “Seeded species”; “Planted species”; and “Full species list”. Only the third is required for submission. If species were added in any form, the first and/or second sheets are also required.
The first details seeded species, including all information about seedmix design. The second sheet details similar information but for any species that were planted. The third sheet details all species found in the contributed data.
Step 4: Monitoring details
This step details key monitoring components and has two worksheets. Both worksheets are required for submission.
The first worksheet, “Monitoring details”, captures monitoring methods relevant to how we scale and process the contributed data.
The second worksheet, “Time point details”, captures monitoring times, split by treatment if the monitoring occurred at different time points by treatment or site. There are columns for day, month, and year. If day and/or month is unknown, please leave it blank.
Step 5: Monitoring results
This step is represented by two worksheets, only one of which is required depending on your original data format. This data includes the vegetation outcomes captured in the monitoring. There are two potential options, “long” and “wide” format (“Monitoring results_opt1” and “Monitoring results_opt2”, respectively).
Please note that this is designed for species-level measurements (total cover; total density). If you have individual-based measurements, please contact the organizers to finalize this stage of the submission process.
In each worksheet, there are two columns for spatial replicates (to capture, for example: block and plot within block). If there are more spatial levels (for example: block, transect within block, and plot within transect within block), please add columns as needed.
Option 1: Long format
Long format is when species are all included within one column. Final data looks similar to:
|Treatment name||Block||Plot||Timepoint||Species code||Value|
Option 2: Wide format
Wide format is when species are included as columns. Final data looks similar to:
If you are concerned about your submission once it has been sent, or have any questions at any time, please email firstname.lastname@example.org and we will respond as quickly as possible.
This is also a TRIAL process and we are looking for feedback on how we can make this easier on everyone! Please see below the submission section to provide suggestions and comments.