A dashboard application to explore geospatial data using interactive tables, web maps, and charts.
Use map.landscape to quickly explore and sync data collected using QField mobile GIS.
This tutorial is a demo of analysing data using the map.landscape dashboard.Fake test data generated using the Fiji Government’s Ministry of Agriculture farmer profile form is used here. This tutorial will introduce a workflow to explore and visualise data related to dalo production on subsistence, semi-subsistence, and commercial farms.
It will demonstrate:
Tabs in the navbar to move between the Data (table), Map, and Chart analysis pages.
Data: upload data and perform analysis on data tables. Map: visualise data on a web map. Chart: visualise data using histograms, bar plots, and scatter charts.
Download the data for the tutorial here here.
Go to map.landscape dashboard.
Follow these operations to load the farmer-profile-form.gpkg data into the dashboard:
The file should start loading into the dashboard. Once complete you should see a list of tables that are stored in the GeoPackage file under the Select active layer drop down list.
Before doing any analysis of dalo cultivation, explore the data on the map interface.
Click on the Map tab.
Click the Map controls check box to bring up the options to style your web map. To quickly explore the data we’ll make a map of the fields surveyed using the farmer profile form and represent the area of each field using a colour scale.
Style your web map:
Click on the Data tab.
Use the Select active layer selector to click on the farmer-profile (farmer-profile-form)_1 and crops (farmer-profile-form)_3 tables. Explore these tables in the interactive table interface.
The farmer-profile (farmer-profile-form)_1 is a spatial table which includes geographic information (shape and location) for each field surveyed (you just saw this on the web map). Each field is uniquely identified by a value in the column farm_id. There are other columns in this table which describe farm attributes such as type_of_farmer which tells us if this field is part of a subsistence, semi-subsistence, or commercial farm.
The crops (farmer-profile-form)_3 is a non-spatial table (like an Excel spreadsheet). Each column in this table stores a variable describing some attribute about crop cultivation. There is a column crop_id; the value in this column relates each crop observation to a field. This tells us which crops are grown in each field.
We can use matches between the farm_id and the crop_id to attach the crops information to each field. This will allow us to make maps of dalo cultivation and summarise dalo cultivation across different types of farmer.
Under Table Analysis and the Select analysis selector choose Combine Tables.
Fill out the Combine Tables options:
Click on the Select active layer selector and check that the table you just created by combining the farmer-profile (farmer-profile-form)_1 and crops (farmer-profile-form)_3 tables is listed.
Next, we need to create a table that contains only the information related to dalo cultivation. We can do this by filtering values in a table based on values in one or more columns.
Under Table Analysis select Filter Rows.
Select the table you just created by combining farmer-profile (farmer-profile-form)_1 and crops (farmer-profile-form)_3.
Click Filter Options and a popup window will appear.
In Conditions to filter rows add
crop == 'dalo' and in Table name enter dalo.
Click on the Select active layer selector and check that the dalo table you just created is listed.
Next, we will calculate the area of dalo cultivation in each field. The dalo table has an area.x column which records the area of the field (computed by QField) and an area.y column which records the percentage of a field under dalo cultivation. We can combine values in these two columns to calculate the area of dalo in square metres in a new column.
Under Table Analysis select Add Column.
In the Select table to add new column selector choose the dalo table.
Click Add Column Options
In the popup window, enter *the following into dalo_area into the New column name and
area.x * (area.y / 100) into Function to add new column.
Click Create column.
Click on the Select active layer selector and check that the dalo table you just created is listed. Select the dalo table and scroll to the far right to see if a dalo_area column has been created.
We have now identified all fields where dalo was cultivated and computed the area of dalo cultivation in these fields.
Next, we will use map.landscapes chart options to create a bar plot showing the area of dalo cultivation on commercial, semi-subsistence, and subsistence farms.
Click on the Charts tab in the navbar.
Set the following chart options:
Here, we are creating a bar plot which visualises amounts or quantities in different categories / groups. The categories are selected in the Grouping variable selector and here we are using type of farmer (commercial, semi-subsistence, and subsistence) as a category. The variable to summarise in each group is specified in the Summary variable selector; here we are summarising the area of dalo cultivation on different types of farms.
You should see a chart similar to the image below appear in your display.
We can also visualise dalo cultivation on a web map. Click on the Map tab in the navbar.
Click the Map controls checkbox and set the following options to create a map of the area of dalo cultivation in each field.
You should see a map similar to the below image render on your display. You can check the Legend checkbox in the Map controls to bring up a legend for your map.