, ,

Quick Field Inspection Reports From Mappt

Mobile GIS application used in field on tablet

Mappt continues to prove itself as a versatile tool with new and innovative uses occurring regularly.  This post focuses on implementing field inspections and in-field reporting using Mappt. 

Using Mappt to perform on-site roadworks inspections

Using Mappt to perform on-site roadworks inspections

A recent client inquired about Mappt’s ability to generate in-field inspection reports suitable as a client deliverable.  As an agnostic data collector (i.e. unhindered by proprietary data formats) Mappt renders data in various formats – both GIS-specific (e.g. shapefiles) and generic (e.g. .csv files).  As an efficient data capture tool, Mappt gives users the flexibility to create field forms following a natural data collection hierarchy and progression.

Completed roadworks inspection report from Mappt

Completed roadworks inspection report from Mappt

In this instance, we were provided with the client’s standard field inspection report and tasked with developing a workflow within Mappt for capturing all data to be included within the report and to provide functionality to generate reports in-field as a client deliverable.

The client’s standard six page inspection report was inclusive of seven unique data types covering the following categories;

  • General Parameters: date, time, inspector, weather
  • Site Photos: works in progress & comments
  • Roadworks by Location:  specific road locations & activities
  • Manpower Classification: job classifications and aggregate hours
  • Equipment Type and Number:  equipment in operation on site
  • Quality Assessments: assessments of roadworks to design
  • Safety Compliance: titles and names of responsible parties, proper signage, etc.
Segregating inspection data types into Layers improves data management

Segregating inspection data types into layers improves data management

Breaking each category into separate layers was deemed most effective as some categories were not required to be populated during each inspection/site visit.  For example, inspections might occur when the contractor was offsite and therefore recording the “equipment in operation on site” was unnecessary.  In addition, a single category might include upwards of forty-five attributes.  Including the possibly hundreds of features in a single field form is less ergonomic, requires the user to look at their screen for an extended period, and possibly unsafe as the user could become unaware of equipment operating nearby.Creating a comprehensive layer inclusive of 45 attributesCreating a comprehensive layer inclusive of 45 attributes

A unique but useful utility in Mappt is the ability to call up Google Street views directly from Mappt.  It is useful for orienting site visitors who may be unfamiliar to the project or for inclusion into a client deliverable such as these field reports.

The Google Street View Icon lets can help orient users to new locations

The Google Street View Icon (red circle) launches Google Street View on your tablet

Google Street View captured in Mappt helps users find new locations

Google Street View captured in Mappt helps users find new locations

After data collection for the inspection report has been completed the data are exported as comma separated values files.  Using a previously formatted spreadsheet workbook, the data is imported to a data input worksheet and a second formatted worksheet makes reference calls to the first to generate a print-ready field inspection report.  Users can than render the report in a printer friendly format (e.g. .pdf) and email it to the client.  Spreadsheet software for Android tablets includes MS Excel, Google Sheets, and Polaris Office.

Formatted field inspection report with reference calls to input sheet

Formatted field inspection report with reference calls to input sheet

Visualising Roadworks Inspection Information on Your Desktop

To visualise the roadworks inspection information on your desktop, first share the layers from Mappt as either GeoJSON or Shape Files and them import them to your desktop GIS system.  We mentioned that each feature contains numerous attributes and it may be necessary to call this information up ‘on-the-fly’ to recap previous inspections or track progress onsite.  Tool tips in QGIS are an effective means to call up attribute information, especially text information like this.  By calling up the display properties for your layer, it’s possible to call up any attribute information possible using HTML syntax.  Referencing an attribute is as follows; [% “AttributeName” %].  Using <br> ensures that a carriage return is used and any text typed in will also appear in the tool tip.  You’ll need to enable map tips from the View tab in QGIS to switch on map tips.  When map tips are enabled, hovering your mouse over a feature in the active/selected layer will cause the tool tip to appear.

Syntax used for displaying multiple attribute information in QGIS

Syntax used for displaying multiple attribute information in QGIS

 

Displaying information for features with multiple text attributes in QGIS

Displaying information for features with multiple text attributes in QGIS.  

This exercise highlights how Mappt can simplify field inspection report generation and improve data integrity.


Harmeet Kuar developed the workflow for: Quick Field Inspection Reports with Mappt

Harmeet Kuar developed the workflow for: Quick Field Inspection Reports with Mappt

By Harmeet Kaur

Harmeet Kaur is a recent Geographic Information Systems graduate from the University of Western Australia and has recently completed an internship with Takor. While at Takor, Harmeet focused on developing workflows to improve Mappt’s in-field usability and has contributed to many of the blog posts you see here.


If you would like to know more about using Mappt as an efficient and robust field inspection utility, please contact us at: support@mappt.com.au

Try Mappt today by downloading it from the Google Play Store or Apple App Store