Let's have a look at how to view the test results once you have exported them in either an excel or GeoJSON file.
First of all, if you need support on how to export test results from the portal, this tutorial is a great place to start.
When to Use an Excel vs. a GeoJSON data export?
GeoJSON: Best for geospatial analysis, such as tests involving reference layers or geospatial properties.
Excel: Ideal for reviewing detailed numerical results and risk assessments.
Viewing Results in Excel
You can either watch the short video walkthrough below, or if you prefer to read you can find the step-by-step written guide below.
Let’s take a look at an example in Excel:
In Excel, you’ll see various tabs displaying the results of the tests you ran.
The first fields will show how the general attribute data as per your dataset export from the portal.
To see test results scroll to the right. Let's look at two examples of how to read test results in the excel export.
Example 1: Test GEC01, checks for farm plots overlapping with other farm plots. In this case, low-risk results show "0", for score and results. There are also no details because in GEC01_detail column because there is no additional information here due to the risk level being, low-risk.
• Example 2: Test GET05, highlights when farm boundaries have spikes. Below, we can see that if the test result is, low-risk, in the GET05_risk column then the answer in the other columns will be 0 with no additional details. However, for the first row which shows a 'critical risk' result we can see the scoring in the other columns and get additional details about the max spike length.
Note: Some test results might not show information in their respective 'Test_detail' column. This simply means that either it scored 'low risk' and therefore there is no additional information or that there are no details yet for this test currently included in the export.
We are always working to add more detail here and this may be part of a future version of our methodology release.
Viewing Results in GeoJSON
You can either watch the short video walkthrough below, or if you prefer to read you can find the step-by-step written guide below.
Here is a short guide to quickly see and start testing the results of your GeoJSON export.
In the example below we chose to export a GeoJSON file that was filtered for the test, GET07 - Farm plot polygon contains holes (so-called, doughnut shape).
Drag and drop the GeoJSON file into QGIS. You can zoom in and already visualise some of the farm plot holes.
Click the info icon to see precise info about this plot and the test. Select a farm plot, and view details on the side under 'Identify Results'.
In the Layers panel Right-click on the first layer and select 'Open Attribute Table' to see fields similar to those in the Excel version.
This is what that table looks like.
Additional Resources
We provide a resolutions template that explains the results in greater depth and also explains how to resolve these issues and communicate this to your suppliers.
The Tutorial is coming soon !
If you'd like to know more about how to fix holes in polygons then this tutorial can be really helpful for you.