Import data#

Vector#

Preparing the data#

To import the data to DigiAgriApp server correctly the data need to have the right attribute table, we provide a template in GPKG format that you can download and fill with your data. The template can be found here

When you add new features please remember that some fields should be filled with the IDs of the relative value, and some other are required, let’s see more for each layer:

  • for field layer farm, soil, management, type need the relative IDs, required fields are farm and name

  • for subfield layer field, soil, management, type need the relative IDs, required fields are field and name

  • for row layer field, subfield need the relative IDs, required fields field and name

  • for plant layer field, subfield, row need the relative IDs, required field is only field but it could useful to fill the name or block and position (block is the progressive number of space between two poles, position is the progressive number of a plant in a block)

  • for pole layer farm, field, subfield, row need the relative IDs, required field is only farm but it could useful to fill the other fields. The typee field is the pole’s material; it is optional, and it need to be filled with M for metal, C for concrete, W for wood.

Once you have filled the template, it is possible to upload data from a vector layer to DigiAgriApp server using the Import vector tool from Web -> DigiAgriApp -> Import -> Vector.

⚠ WARNING

It is required to upload one layer per time, starting from field, after that (if you have compiled) subfield, row, plant and poles

In this windows you can find a table with all the layers loaded on your QGIS layer tree. For each row you can find the layer’s name (column 1), a checkbox to select if you want to upload that layer (column 2), which DigiAgriApp feature type are you uploading (column 3), and if you want to upload all the features or only the selected one (column 4).

Selected features option is really useful if you made few changes to you data and you are interested to upload only that few features.

Clicking on OK the data will be uploaded, result are shown in the QGIS messages bar.

Create plant from CSV file#

This feature is able to take a CSV file and distribute the plants along the different rows for that field or subfield or row.

You can find the CSV template here, to compile the template you need to know:

  • the row column is required and it needs be the name or the ID of the row to use

  • the material column is required and it should be populated with the ID of the choosen material (the material should already existing in the database), special characters are p, P used to mark a pole and f, F used for an empty space, it create the position but not assigning to any material.

  • the label is used when the plant is part of and experiment and you want to assign a code to that plant, it requires also thesys and experiment columns

  • the thesys column is the ID of the thesys assigned to that plant, remember that the thesys should be connected in the related experiment (optional)

  • the experiment column is the ID of the experiment (optional)

First of all you need to select the field and subfield, optionally the row if your CSV file contains just one row.

Select the compiled CSV files, the two checkbox in the lower part helps to maintain the structure a little bit more regular, so we suggest to keep them activate

Once all the plants received a position a map showing your plants and poles with a dialog to choose what to do, if the showed structure respect your idea you can click on Ok button and these data will be uploaded

Raster#

This feature is not yet implemented.