The Rights of Way network in Calderdale comprises nearly 1,400km of moorland, steep valleys, and urban areas. The fieldwork was completed in three months, using a team of five surveyors armed with rugged tablets using our CAMS Mobile app. Our surveyors collected information on every furniture item and every issue/problem and captured over 27,000 photos. This gave officers at Calderdale Council a complete picture of their public rights of way.

Rather than simply handing back static report files, Exegesis loaded all the information from the survey into our new cloud-based CAMS Pro solution. This provides powerful searching capabilities, interactive mapping and photos integrated via LibraryLink in an accessible, intuitive website interface. But CAMS Pro is more than just an interface for viewing the survey data; it also includes tools for prioritising the issues, assigning tasks to officers, and tracking the progress of issues through to completion. A wide range of reports can be run from the system, and the interactive map allows the information to be visualised in different ways. In addition, CAMS Pro facilitates engagement with the public by allowing Calderdale Council to easily publish their register of applications for Definitive Map Modification Orders & Public Path Orders. To help keep the data up to date when working in the field, we also provided Calderdale Council with CAMS Mobile for their own use as well, allowing offline edits to the data, and synchronising directly with their CAMS Pro system when signal is available.

This project provided Calderdale Council with a comprehensive, up to date dataset of their public rights of way, along with easy-to-use tools to enable them to manage the data and to get the most value from it.

Further information from Timothy Derbyshire

Given the dynamic nature of the sand dune habitat, it was not possible to use historical mapping, MasterMap or any of the datasets that are normally used for digitising Rights of Way networks. We instead used the most recent available aerial photography to identify and capture the walked lines of the paths.

Once the network had been captured, it was loaded to the CAMS Mobile solution for the fieldwork. This allowed the surveyor to capture details of the furniture items and issues on the network, using the tablet's GPS to assist with positioning and capturing images on the tablet's camera. The data, including the digitised network, were then all synchronised back into the client's CAMS dataset, with all the photos linked to the records.

Further information from Timothy Derbyshire.

Exegesis were asked to develop a straightforward way for the office staff to import these spreadsheets into their CAMS. The spreadsheets contained detailed information that was used by the officers to inform tree management. The data collected in the survey spreadsheets could relate to new trees that were not previously in the system, or existing trees for which the information needed to be updated. The solution needed to create or update tree records in the database as appropriate, and also create spatial information for new trees, based on eastings and northings in the spreadsheet.

We developed an import routine for CAMS that read a user selected spreadsheet, matched the data to trees in the CAMS database, and updated data for existing trees or created new tree records if there wasn't a match. It was also able to make certain calculations from the data, such as working out when the next survey was due. Where new trees were recorded, map features were created automatically for these by the import routine.

Further information from Timothy Derbyshire.

We developed the hub using WordPress to create a mobile-friendly website comprising a comprehensive data management system and public face for the project. This included:

• Pages providing general information about red squirrels and the project.
• The development of data entry forms for squirrel sightings and a range of different surveys.
• Bespoke maps and dashboards to display records in an easy to understand way.
• News/blog pages.
• Forums for groups defined by survey type and location.
• Events manager.
• Full user authentication and management.
• A record of volunteer activities that allows users to log time spent and view their activity.
• A volunteer training record.
• A configurable messaging system that operates for all users or user groups.

We are continuing to provide technical support for ongoing operation of the website.

Visit the Saving Scotland's Red Squirrels hub.

Further information from Patrick Beasley.

Exegesis was commissioned by Zero Waste Scotland (ZWS) to develop a website and mobile app, plus the underlying database and API, to enable local authorities and other stakeholders in Scotland to monitor litter and fly-tipping incidents.

ZWS is the body responsible for reducing waste and promoting a circular economy in Scotland and has been a FlyMapper partner organisation since 2013. The Litter Monitoring System (LMS) took the pre-existing functionality of FlyMapper and added the ability to record and analyse detailed surveys of street litter. These surveys are used to support the requirements of the Scottish Government's Code of Practice on Litter and Refuse (CoPLAR).

The LMS mobile app is built using Xamarin, a cross-platform development tool that allows the sharing of a codebase between Android and iOS app versions.

The LMS web site allows management of both the fly-tipping and litter monitoring elements and is built within a cloudscribe Content Management System. It already contains details of previously recorded fly-tipping incidents in Scotland.

Data taken from the Technical support for CoPLAR Land Zoning in Scotland project is imported into LMS as local authorities continue to come on-board.

Further information from Richard Griffiths.

The first stage was to digitise the route of the new section into the Authority's CAMS. This included correcting the alignment of the path against OS MasterMap and dividing the route into Link sections.

The data were then loaded to the CAMS Mobile table application for survey in the field. The information captured included spatial and text data on all the signage, gates seating and other furniture along the Trail, along with photographs. In addition, detailed information, including mapping and photographs, was captured of all problems encountered along the Thames Path.

The collected data were analysed and loaded into the client's CAMS solution, and copies of map layers, geo-tagged photos and reports were made available to Transport for London.

More information from Timothy Derbyshire.

The surveyor found the system easy to use in the field, and was impressed with the performance, GPS response and camera quality in the tablet. The 16% survey equated to about 140km of public rights of way, and this was completed in the field in just a couple of weeks.

After the fieldwork was successfully completed, the data were synchronised into the authority's CAMS system, allowing them to generate reports and plan for the future maintenance of the network.

Further information from Timothy Derbyshire

The site of the path was steeply sloping with significant vegetation cover, making it difficult for standard GPS receivers to get an accurate fix.

Working with the National Park authority, exeGesIS used high-precision GPS equipment to mark the line of the path, achieving sub-metre accuracy. These GPS data were used to create a map layer that could be incorporated into the authority's CAMS and GIS applications.

Further information from Timothy Derbyshire.

Each individual grave was accurately plotted on the GIS map. A high-precision differential GPS receiver was used, with aerial photography to support the GIS mapping. Once located, each grave was photographed, basic information and more detailed information on the condition of the headstone was recorded, and a detailed risk assessment was carried out.

The fieldwork was completed within less than a month by one of Exegesis' own surveyors, with full support from the office team. After this had been completed, Exegesis provided data analysis and reports to the client.

Further information from Timothy Derbyshire.

Data were collated to create a dataset of candidate Greenspaces, an access network dataset and an access point dataset, all of which were checked by local authority staff. In addition the data was validated by undertaking a survey of greenspace type, condition and access points for a sample of 250 non-Local Authority sites. 

Population for each settlement was calculated from national census data. Analysis was undertaken to determine the area within the distance criteria for each Greenspace access point.

These data were then used to calculate the percentage of the population in each settlement which passed the criteria. The results were reviewed by local authority staff via a website, which allowed comments to be left and read by others. The data was then reprocessed to produce the final outputs.

Further information from Claire Lush.