Mandatory Field and Instructions – Essential data input requirements
Access and Preparation
Access the Database
- Navigate to the TREEPULLING database import page using the following link: TREEPULLING Data Import.
- Ensure you have the necessary credentials to log in. If you do not have a password or need to make amendments to the database schema, contact the database administrator at IEFC for further information.
Prepare Your Data File
✔ Create a data file that matches the structure of the example file which can be downloaded from the database import page. This ensures compatibility with the database’s expectations.
✔ Ensure your data file does not include columns named ‘Last_update’ or ‘owner’ as these are reserved for internal use
File Requirements:
Data File Format
Acceptable file formats include .ods, .xls, .xlsx, and .csv.
For spreadsheets (.ods, .xls, .xlsx), ensure that:
✔ The sheet names match the corresponding table names in the database.
✔ Column names are placed in the first row of each sheet.
For CSV files:
✔ Ensure the file uses ‘;’ as the column separator.
✔ Specify the character set if not the standard UTF-8.
Data Formatting
Dates must be formatted in YYYY-MM-DD format (e.g., 1999-02-27).
✔ Geographic coordinates (Latitude and Longitude) must be in decimal format with a dot as the decimal separator.
✔ Enumerated fields should have values separated by commas if multiple values are applicable (e.g., 1,5,25 for SET type fields).
Uploading Your Data
Upload Process
1.On the import page, locate the file upload section.
2.Select the purpose of the upload: whether to update existing rows, add new rows, or delete rows.
3.Choose your file and upload it.
4.Monitor the upload process for any errors or confirmation messages indicating successful data integration.
After uploading, it’s crucial to Use the ‘Download Your Data’ link provided on the import page to
ensure that all information has been correctly uploaded and formatted.
Mandatory Fields
| Field | Type | Description | Input Requirements |
|---|---|---|---|
| Data_Owner | varchar(40) | The person or organization to whom the data belongs. Include an email address if possible. | Enter up to 40 characters. |
| ID_Tree | varchar(50) | Unique identifier for each tree. | A unique identifier for each tree, up to 40 characters. CompositKey: DataOwner +ID_Tree - ID_Tree (4-digit species, 4-digit genus, country code, and tree number) Example: DataOwner1 -SpecGenu-XXX-001 |
| Tree_Species | varchar(50) | Taxonomic classification of the tree species, using the scientific (Latin) name. | Enter the scientific name of the tree species, up to 50 characters. |
| DBH (Diameter at Breast Height) | decimal(5,2) | Diameter of the tree's stem at 1.3 meters above the ground. | Enter the diameter in centimeters with two decimal places. |
| Tree_Height | decimal(5,2) | Vertical distance from the base to the top of the tree. | Enter the height in meters with two decimal places. |
| Latitude | decimal(9,5) | Geographic coordinate representing the tree's north-south position. | Enter the latitude as a decimal degree (e.g., 53.12345). |
| Longitude | decimal(9,5) | Geographic coordinate representing the tree's east-west position. | Enter the longitude as a decimal degree (e.g., -1.23456). |
| Total_Turning_Moment | float | Force required to uproot or break the tree, considering the pulling force and the tree’s own weight. | Enter the value as a floating-point number. This field cannot be null. |
| Mode_of_Damage | enum('Break', 'Overturn') | Indicates whether the tree failed by breaking or overturning. | Indicate the tree damage, either 'Break' or 'Overturn'. |
Troubleshooting and Support
In case of errors or data mismatches, review the format and content of your *ile. Make sure that all data *ields align correctly with the database schema and update the rows.
For additional support or speci*ic queries about the database, use the contact information provided on the database access page to reach out to the database administrator.