# QGIS: Yield Data Manipulations

OVERVIEW

<br>

Manual with step-by-step description to resolve the following troubles with data from yield monitor:

1. &#x20;Missed projection file (.prj) in shapefile
2. &#x20;Apply conversion rules for every attribute in shapefile (based on kb/ha to bu/ac sample)

<br>

The software to utilize is QGIS ([LINK](https://qgis.org/en/site/forusers/download.html)).&#x20;

Downloading and installation are mandatory.

### &#x20;MISSED PROJECTION FILE

1. Open shapefile with yield data. Move the file inside the QGIS window.
2. The shapefile becomes available for further manipulations in the Layers block.&#x20;

![](https://lh5.googleusercontent.com/c4jakjBa8tCN9ZSxVnh6W6DDE24qYFGewLdjTwPi7i0yg7-Zp6JmeXE4yiq3JqhaIFhFE8mHxyKzR9avluJzJpsaUxXSxzCI_RSV0GjJyPoAp7sNj_UdMyEBRNs38siTdV9Ue2VY75Prqu57rKtj)

3. Start saving process
4. 1. Do the right mouse button and click at the shapefile
   2. Choose Export -> Save Feature As ...

![](https://lh5.googleusercontent.com/4p2FP0E4GEnN0KTcCgRvXro6oam-GCTGgc_s4yjkuujdXxbnjyPT5a1Z1Dr_o9_W3rw2AhtUMSQ7-RXHx3Xeca2vtMjCGTRIS_BTifbKCXhthfrWy9z5Ti3Ve6kCPFnatunJJ_jGy8gBWOa85CZg)

<br>

4. Choose&#x20;
5. 1. Format -> ESRI Shapefile,&#x20;
   2. Filename -> click … and select the preferred directory and filename,
   3. CRS -> EPSG:4326
   4. Encoding -> UTF8
   5. Add saved file to map (optional if you want to see it directly in QGIS)
   6. Geometry type -> Point

![](https://lh4.googleusercontent.com/GUoerdddlqqyW1xQAGXkAc8txhiCnTrhL6B6HeM3gUsWgV9NatvqrjWtEQAHGsGzkS27fnsOM-QFuYuiafCUYdOOoy9AdKXJhp213uceDJuOxzfp01rMQnt4ruYoHjqhkE0iMl977pE_xfcwzaj9)

5. Click Ok
6. An additional shapefile with the same yield data is created. The projection file (.prj) was added.

\ <br>

### BU/AC CONVERSION

<br>

1. Do the right mouse button click on the shapefile and choose Open Attribute Table

![](https://lh6.googleusercontent.com/NdfMyO0879Gfs3hNy65xG-dS4Ny3LtNn89F6yhVTwHZ4NqbjM1YMaJ7EWje5ySzgJkcGXexg6BE0mQorWsTej_90QXtLN7uHUds-eLmSN2wJltszg4YWk63Cm0kpiJUcAvFi3K6rily96QzjCNRW)

2. Click Open field calculator

![](https://lh4.googleusercontent.com/CfXuEr0pNJFpTvu-Z4-p2Dhu91MNhhTvzIsf_S0xft59X7MQfqnDlwQSQmgnAa6InPROgBWY-yPyviS31PzhMhlySfuC4AWpYrchxUr_XS9P29MxHg8m1_cKuLm5DzBvkboeNuCynf1gTaJQX3ox)

3. Create a new field
4. 1. Mark Create a new field
   2. Enter Output field name -> DryYieldBu
   3. Choose Output field type -> Decimal number (real)
   4. Change Precision -> 4
   5. Put rule to convert kg/ha to bu/ac -> "Dry\_Yield" \* 0.0149

![](https://lh6.googleusercontent.com/nE9n9fiD0geaw5ebrp1R1KtJgqnCQQz8AC9ulpvQvvtgQzxZed6n9Cs7zRBlGH0gK-fSDTu--LvBXw4_i7hWmw3k9dVzLdU24j9JVuCcdol9AGx3Byi38CRsNFWSRI3MN_I6fd71NGjcABMn7ENs)

4. Click Ok&#x20;
5. Additional DryYieldBu attribute has appeared in the table

![](https://lh6.googleusercontent.com/S2PYA5-ZAkomBfAOe4g6AnTmu39STpYt3Bea4duzaNSIwODXOaY8m0h7hkj2SsnjlrDLCwuU94Bs9CNl_7SsZfDgBERfZ1RYSUvsrJBo-Wd8Tj4k_R6PkoELYfk2_XJfu3hcx0C43z0JTQuUbsYB)

6. Save the changes
7. 1. Do the right mouse button click on the interested shapefile&#x20;
   2. Choose Toggle Editing

\
\
\ <br>

![](https://lh4.googleusercontent.com/Clwm4XcTG0N49JqJLZV9zJWpg0LPKeevU05w0d30F-PobS23vlVXcLp8MMPZif9rZs7ojl5SdymHz_FHQDdS1Pyz2y2dfhoL49au6C6y5A3huz_yFAcqvDcpKgB5XRh96oS97JBnxKSXWttWibVV)

7. Confirm saving the changes

![](https://lh5.googleusercontent.com/RYEl5WkYMsX2aNA-zO6hUEXO6OGnFD2JO0XfNmJ6tqirz5Bw2udMa2ZUGTA8ZuZZb__mv5AtvmC-fZouyMUwUTzNdIn8ahzJhFXwW2M9PPgHDfuc8Qqq6UpC-MkU-xgPv0yCzoOoZjy-kpPn7xBP)

The interested shapefile is not marked with Pencil anymore. The data in the shapefile was updated.