Survey of the network is a key part of the job for Eryri's wardens. The CAMS Mobile app allows efficient data collection in the field, integrating with the device's camera and GPS. As network coverage can be unreliable, it was important that the mobile app could function completely offline, without an internet connection. All the data and background mapping are held on the device for use in the field, and a one-touch operation allows the data to be synchronised with the main system when a connection is available. To help ensure quality and consistency of data, we configured the app to make certain data fields mandatory, and to ensure all updates from the field had a photo associated with them. It was also important for Eryri that the app could also be used in the Welsh language, so we worked with them to implement translations and allow the app to switch between Welsh and English at the touch of a button.

Eryri wardens have a rolling programme of rights of way to survey, and tools built into the CAMS Pro and CAMS Mobile solution assist with this. A task is created for a warden to survey a path by a particular date, and when that task is completed, the system automatically generates the next survey task based on the priority of the path and when it was surveyed this time. This process saves Eryri's senior wardens a lot of time from having to manually identify and reassign links to wardens for survey. From the perspective of the surveyors, they get a prioritised, date-based task list that they can work from, so they always know their priority tasks.

Field survey is only part of the story. In the office, Eryri staff need a system that helps them manage the rights of way network and respond to problems. The CAMS Pro solution provides this. An intuitive, easy-to-use web application provides a portal for members of the public to report issues on the path network, and for officers to track these issues through to completion. The system assists with prioritising issues and setting target dates, based on the authority's published rule base, and allows office staff to record tasks for field teams to work on. Operating fully bilingually, the website allows members of the public to submit reports of issues they encounter, and to see the and be notified about progress of their reported issues. This self-service frees up officer time to work on resolving the issues.

For officers, the public portal makes their job easier as the issue reports come to them in a standardised format, linked to a map location and using standardised descriptors. Photos may also be included. A simple interface takes the officer through the workflow of reviewing the issue, accepting or rejecting it in the system, and assigning appropriate tasks to wardens. Wardens receive all the information about their jobs on their tablets, and can update the information in the field, whether that's adding further detail for specialist teams, or signing the issue off when the work is done. This closes the loop, and the system automatically updates the complainant to let them know their issue is now resolved.

Further information from Timothy Derbyshire

We worked with Staffordshire County Council to agree the standards for the survey and produce the survey manual, and after an on-site Pilot to confirm the standards, the fieldwork began in earnest. The survey ran from their live CAMS solution, so all the data collected immediately went back into their live CAMS and was instantly available to officers. While the surveyors were collecting data and photographs in the field, Exegesis consultants in the office worked on other areas of the project. We completed a GIS exercise to calculate the gradients along the route by intersecting the route with the 5m contour data, and used this information to identify the maximum gradient along each of the link sections. We also identified useful facilities on or near the route (such as car parks, EV chargers, accommodation providers and public conveniences) by buffering the route and intersecting this with the OpenStreetMap data.

A number of issues were identified during the survey, and for each of these we identified suitable next steps for mitigating or resolving these issues. Each of these actions had cost estimates associated with them, allowing us to produce a costed summary of the work required to resolve these issues. By classifying each of the issues by their effect on the user, and giving each a priority, we were able to break the cost down by the priority of the issues, as well as by those on the circular walks compared to the Staffordshire Way itself. A new form of analysis which we undertook was to give each issue a score based on the impact it had on the user and to total these scores for each link on the Staffordshire Way and associated walks. What this showed was that while some links were impacted by one serious issue, others had a larger number of smaller issues whose cumulative effect was just as significant.

After the fieldwork was completed, we collated the data from the analyses and the survey to provide useful reports for Staffordshire Council. A key area of interest was around accessibility, and being able to provide potential visitors with the information about where potential barriers were. The gradient analysis was obviously a key part of this, and we used this information alongside the data from the fieldwork about stiles, steps and similar items of furniture to show areas where accessibility could best be improved, as well as maps showing gradients and barriers. In addition, we produced atlases of the road crossings and sections of the route that followed roads, with photos, comments from the surveyor, details of any specific problems, and assessment of the provision and visibility.

All the information was loaded into Staffordshire's CAMS solution, where it is easily searchable and updatable by Staffordshire's public rights of way team.

Further information from Timothy Derbyshire

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

Following a review of approaches used in Ireland and other countries, it was clear that the approach should consider the number of occupied hectads (10 km × 10 km squares). Following discussion with other experts, we set the following thresholds:

• Rare species occur in 10 hectads or fewer. 10 hectads equates to about 1% of the land area of Ireland.
• Scarce species occur in between 11 and 50 hectads. 50 hectads equates to about 6% of the land area of Ireland.

We tested these on existing datasets for macro-moths and water beetles. We developed a set of PostgreSQL/PostGIS views that consistently processed and analysed these raw biodiversity datasets. We also generated standardised distribution maps for all 861 insect species through a novel use of atlas functionality in QGIS.

We also pushed the process further to provide additional insights into the distribution of each species. This included:

• Distinguishing coastal species, defined as species where 75% of occupied hectads were within 1 km of the coastline. To aid interpretation, inland and coastal hectads were shaded differently on the maps.
• Identifying geographic skew in species distributions, calculated using the spatial distribution of the underlying records. This skew was presented on each map as standard box-and-whisker plots, and using cardinal and intercardinal compass directions (e.g. north-eastern).
• Recognising species that had a patchy distribution using a DBSCAN cluster analysis algorithm. This helped to identify species that had no clear geographic skew but were nonetheless geographically restricted.

We also considered whether it was possible to assess the abundance of a species in the hectads from which it was recorded. This needed to overcome the effect of variable recording effort, which means that abundances in different datasets are not comparable. We therefore developed a Normalized Hectad Abundance Score, which scored the abundance of each species from 0 (lowest abundance, which is usually an average of 1 record per hectad) to 1 (the species with the highest average number of records per hectad) within each dataset.

All this information was clearly included on the maps, to facilitate the expert review of the results.

Further information from Crispin Flower.

Deer are large animals that are a potential hazard to vehicles on the road. Each year in the UK alone, it is thought that over 700 people suffer injuries or fatalities and over £17 million is spent on vehicle repairs because of Deer Vehicle Collisions (DVCs). In Scotland, a combination of increasing deer populations, especially in the central belt, and a growth in traffic has led to an increase in DVCs.

Exegesis was awarded a contract to collect and analyse data on Deer Vehicle Collisions (DVCs) in Scotland between 2019 and 2021. This work involved obtaining DVC records from a variety of sources in the public, private and third sectors, collating it into a consistent database, and analysing the data to identify trends and highlight areas of concern. This continued work undertaken since 2008 that had established data collation, processing and analysis protocols.

We added 5,479 records of DVC incidents in Scotland, bringing the total in the database for 2008 to 2021 up to 22,753 records. These were analysed in detail and a full report produced. Key findings included:

• Whilst there has been no recent significant increase in DVCs in Scotland overall, there has been a general increase in the central belt that has been offset by a decrease in northern Scotland (see map).
• Dusk is the worst time for DVCs, especially in May and June when overall numbers of DVCs are higher. This information can be used to target mitigation activities.
• There was no evidence of a decrease in DVC incidents resulting from travel restrictions introduced due to the Covid-19 pandemic (shown below). This contradicts claims of an anthropause where human impacts on wildlife were reduced. Nevertheless, the number of DVCs reported by members of the public, who would have been affected by the restrictions, were clearly suppressed. This suggests that freight traffic, which was largely unaffected by travel restrictions, was the cause of many DVCs during this time.

We also developed a new approach to analysing DVC risk on sections of the trunk road network, by using a moving window algorithm to identify the parts of roads with the most DVCs. We identified the blackspots with the highest DVC risk from the results. Most of these proved to be junctions surrounded by woodland in the more urban central belt. We recommended actions to mitigate the risk at the 10 worst blackspots.

The report has been published by NatureScot. We also produced a short non-technical summary of the key results.

Further information from Richard Griffiths.

The objectives of this review were to:

• Review the ecosystem effects of common cord-grass
• Map the distribution and extent of common cord-grass in Ireland
• Review the options for the control and management of common cord-grass
• Develop a common cord grass control action plan that can be applied to coastal sites in Ireland

Literature review suggested that the perceived impacts of common cord-grass are often speculative. There was evidence of an impact on macrobenthos diversity, which may explain reported impacts on wading birds that feed on these organisms. There is also evidence that it can impact eelgrass Zostera beds. However, few other reported impacts had strong support and there were suggestions that common cord-grass might facilitate other species. There are also uncertainties about the relationship of sediment regimes and common cord-grass, and the potential impact of management and dieback.

Data analysis was undertaken in PostGIS. The extent of common cord-grass was determined based on the two Saltmarsh Monitoring Projects and the SAMFHIRES project. These provided excellent and up to date coverage, suggesting that the extent of common cord-grass was in the range 688 to 1,223 ha. These data combined with presence based records of the species showed that common cord-grass was widely distributed in Ireland, with records intersecting 167 out of 214 coastal sites.

The threat posed by common cord-grass to Annex I habitats was assessed. It was found to pose a substantial threat to three Annex I habitats, with particular concern for the rarest habitat considered (H1420).

Based on the literature review, a mixture of cutting, smothering, excavation and herbicide application could be used to control common cord-grass. However, this came with caveats, as some techniques, such as cutting, are unlikely to be effective on their own, and all techniques risk impacting other species and habitats in the vicinity. We therefore developed a management decision tool to help guide managers though the analysis required to determine the amount of survey and management action required for a site. This was provisionally implemented on the 167 coastal sites with records of common cord-grass to estimate the extent and costs of actions required.

Note that common cord-grass is currently subject to a degree of nomenclatural uncertainty. Formerly known as Spartina anglica, it is now considered to be a member of the genus Sporobolus, as Sporobolus anglicus. However, this change has not been universally accepted.

Further information from Claire Lush.

The aim of the project was to establish the suitability of aerial imagery taken from Unmanned Aerial Vehicles (UAV) to investigate the spatial and temporal extent of bait digging at selected sites in Wales.

Sites were flown at low tides and ortho-rectified seamless mosaics produced. Shore survey and ground truthing was also undertaken, and control holes dug to investigate the persistence of bait digging evidence on different shores. The shores were revisited to assess whether the control holes were still visible, to give an indication of the persistence of damage. The ortho-rectified imagery was used to create bait digging intensity maps on a variety of shore types.

Further information from Crispin Flower.

Zero Waste Scotland contracted Exegesis to support Scottish local authorities in meeting the requirement for land zoning data. This involved:

• Providing practical technical advice to local authority staff on the use of GIS to zone land.
• Creating first cut spatial datasets of relevant land to be zoned.
• Processing data on behalf of local authorities in various ways.
• Supporting local authority staff as they determine and apply zones to their data.
• Quality assuring data and preparing it for the Litter Monitoring System.

Data processing was generally undertaken in the PostgreSQL extension PostGIS, using QGIS to view the data in PostGIS. Some processing was also undertaken in GRASS where this was beneficial, such as cleaning and removing small areas from the spatial data (using v.clean, especially the rmarea tool). Advice to local authority staff was tailored to their corporate GIS, mainly ESRI ArcGIS and Pitney Bowes MapInfo.

One of the requirements was that zoned land was split into 1,000 m² sample locations. Each sample location defined an area of land that could be surveyed as part of litter monitoring. Part of the support provided to local authorities was to run the pre-existing QGIS Polygon Divider plugin on supplied data to create the sample locations. This highlighted the need to enhance the Polygon Divider, which we undertook following discussion with Zero Waste Scotland. This included:

• The addition of an approach to split complex polygons into more manageable chunks to the Polygon Divider interface.
• Improved data handling to use memory more efficiently and reduce crashes and failures.
• Implementation of PostGIS compatibility.
• Improved message logging.
• Various minor bug fixes.

The changes to the Polygon Divider were submitted for inclusion in the released tool.

Further information from Richard Griffiths.

The project outputs consisted of a web interface for configuring the mapper, a modern and feature-rich web application for displaying maps, and consultancy services to JNCC in managing their database and web mapping services.

The project drew on our knowledge of managing large spatial datasets, optimising web mapping services, familiarity with marine habitat classification systems, and expertise in creating interactive web mapping applications.

The new system is currently used to display marine protected area boundaries (MPAs) in UK waters by JNCC. It is also used for a diverse set of habitat and environmental variable datasets as part of the European Marine Observation and Data Network (EMODnet).

The mapper can be configured by JNCC staff, who decide which layers should be available, which are displayed by default, and how they may be filtered. It is not restricted to marine mapping and could be configured to display any tiled web mapping services.

Users of the map can search and browse layers, view information about specific habitats by clicking on the map, zoom to areas of interest using a gazetteer, change base maps, and filter layers for specific habitats for species. A permalink system allows users to save their current view of the map and share it with others via a URL.

The mapper is easily deployed and can run as a standalone application or it can be displayed within a content management system to maintain corporate identity. The styling of the mapper itself is customisable so that it can also be themed to meet the style guidelines of the hosting organisation.

This mapper has been one of several marine mapping web applications we have created over the last few years including the United Kingdom Directory of Marine Observing Systems (UKDMOS) ArcGIS desktop application and the Integrated Marine Data and Information System (iMarDIS) https://portal.imardis.org/.

Further information from Andy Brewer.

NRW contracted Exegesis to establish a vegetation monitoring programme that would allow the development of the saltmarsh to be assessed and better understood. This involved:

• Collection of high-resolution aerial photography using out fixed-wing drone.
• The generation of an accurate height model.
• Capture of vegetation communities based on species dominance from the aerial photography and data collected in the field. The resolution of the aerial photography made sub-metre precision mapping possible.
• The selection of three transects across the main site.
• Detailed survey of a series of randomly located 2×2 metre quadrats along the transects, located using a high precision GPS.
• Photographs of transects, quadrats and features of interest.
• A full technical report detailing the methodology and results.

The report recommended repeat monitoring surveys following the same methodology and using the same quadrat locations, so that future vegetation change could be quantified and characterised.

Further information from Crispin Flower.

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.

Under the Commons Registration Act 1965, the Council is obliged to maintain a register of all the areas registered as Common Land or as Town or Village Greens, along with details of ownership, rights holders and rights particulars. Managing these data in CAMS allowed integration of the map features for the commons & greens with their database records, something that had not previously been possible. For the first time it enabled users to view a common and all its associated tenements (land holdings with rights over the common) with one click. In addition, holding all the data within CAMS makes it easily available and searchable to a wider range of users.

Exegesis developed a new CAMS module to manage the Common land and Village Green Register, allowing users to easily find information on a range of criteria, such as "who has rights on this common?" or "which commons does this farm have rights over?", and easily keep on top of the day-to-day management of the data. The new Commons module handles all the data from the Commons Register and enables easy production of the hard-copy register sheets as well as various application forms and reports. In addition, tools in the Commons Module assist users with the process of reapportioning tenements when properties change hands.

Further information from Timothy Derbyshire

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.

Prior to the National HLC (NHLC) project, virtually all of England had been characterised through individual HLC projects, but these were at county or sub-regional level, with each of the studies using slightly different methodologies and categorisation methods. In early 2016, Natural England appointed Exegesis to compile a national HLC dataset, drawing together the existing sub-regional HLC datasets and applying a common framework, structure and terminology to a new unified dataset. The aim of the project was to improve the awareness, understanding, appreciation and ability to manage and monitor the historic dimension of England’s landscape at a national scale, for both professional and non-professional end-users.

The database containing the terminology applied to all the different sub-regional datasets was cleaned and then the original terms used were mapped to a bespoke thesaurus, created to ensure that all could be mapped to a suitable, equivalent new term. The associated spatial data was also processed so that the irregular polygons were firstly imported to a merged dataset and then generalised into a gridded dataset. The gridded approach eliminated discrepancies in polygon size or accuracy, and overcame issues where there were small amounts of missing data in the original datasets.

The final gridded dataset was produced at 500m and 1000m scale, with each grid cell having a single associated record with information about the historic landscape character types (both broad types and narrower, character types) and period information. The datasets can be viewed and interrogated in GIS software packages, and when viewed alongside other datasets, the NHLC data can act as an indicator of historic landscape character and can therefore feed in to decisions about landscape management, planning, heritage asset management or research priorities.

View the outputs.

Further information from Abby Hunt.

The dataset was based upon Ordnance Survey MasterMap data, filtered to remove features that were unlikely to be hedges and excluding built up areas as garden hedges were not being targeted. These were then reviewed on the aerial imagery and assigned to one of the following types:

• Not a hedge
• Intensively managed
• Trimmed & dense
• Overgrown
• Line of trees
• Defunct
• Newly planted
• Recently coppiced
• Recently laid
• Woodland
• Uncertain

Hedges not included in the MasterMap data were also added, leading to a dataset of 22,370 features of which 17,013 were thought to be hedges. This was all undertaken in an incredibly short timescale, with data attribution starting on the 15th and finishing on the 27th December 2016.

Further information from Crispin Flower.

The surprising answer is 'probably yes'.

We identified the Saproxylic Quality Index (SQI) as the best available measure of quality, as it was felt that a site's saproxylic (wood decay) beetle fauna would be a good surrogate of wider wood decay habitat quality, which is one of the most important elements of wood pasture and parkland. We combined available SQI scores with the wood-pasture and parkland inventory we had previously created for Natural England to create a sample dataset of 98 sites. We then analysed the sample data against other available data, including tree records from the Ancient Tree Hunt, geography, climate, designations and habitat networks using PostGIS and multiple regression analysis in the statistical package R. The models produced were refined to identify the model best able to predict wood-pasture and parkland quality.

Eleven site attributes were included in the final model for predicting SQI score. Sites in the south east and lowland sites tended to have higher scores, suggesting that warmer and less exposed sites were better for saproxylic beetles. Unsurprisingly sites with higher numbers and densities of veteran or ancient trees also tended to have higher scores, owing to the increased volume of wood decay habitat present.Sites that were in a landscape with other wood-pasture and parkland were also found to have higher SQI scores.

The best model proved to be remarkably good at predicting the SQI score of the sample. It suggested that sites with a predicted score of 600 or more were likely to have an actual score of at least 400 - itself quite a high score. This suggests that if the model were applied to the wider wood-pasture and parkland inventory it could be used to predict SQI scores and identify sites that could be targeted for survey.

However, this was a proof of concept study, so the model needs more work before we can conclusively state that wood-pasture and parkland quality can be predicted. This includes further refinements to identify attributes that help predict quality. It then needs to be tested to determine how well it predicts SQI scores for sites that were not part of the sample. We hope to be able to continue this work, as we believe the improved model could be very valuable for targeting entomological survey effort.

Further information from Crispin Flower.

The two GIS were not always completely comparable, so notes were made on many of the items of functionality to give a more nuanced assessment. These notes covered those instances where no direct comparison was possible, where functions behaved subtly differently, where almost identical results could be obtained through different means and where ArcGIS specific concepts applied that were not replicated in any other GIS. QGIS lacked some advanced functionality required by JNCC, but it would be possible to develop much of this for QGIS. The lack of QGIS support for the ESRI map document (mxd) format was a particular issue, as JNCC required these for sharing data with partner organisations, but since the format is proprietary it would not be possible to develop this functionality.

We also assessed any changes to JNCC’s IT infrastructure required as a result of implementing QGIS, as well as the associated costs. There were no obvious issues with delivering QGIS via their existing Citrix system, though this was not tested. Whilst QGIS is open source, leading to significant reductions in licensing and annual maintenance costs, this needed to be balanced by the loss of functionality not available in QGIS, the lack of support and the need to retrain staff. The assessment suggested that whilst it would certainly be possible to implement QGIS within JNCC, ideally alongside a spatial database, with PostGIS offering the best QGIS integration, it would be necessary to retain at least some ArcGIS licences to ensure that some required functionality remained available.

Read the report.

Further information from Claire Lush.

To support local authorities in meeting their duty to provide route maps of existing safe footpaths and cycle-ways, Exegesis were contracted to specify the structure of datasets and design a web based data management system. At the same time Sustrans carried out an initial survey of existing paths and infrastructure to populate the system.

Exegesis created a structured national road and public rights of way network ready for the survey, then presented the survey data via a web mapping interface. The Sustrans survey data was added and thematically displayed. The LAs then defined their routes by clicking on the existing paths and roads and entering route details. The routes were inspected to assess the condition, hazards and suitability for an Active Travel route.

The resulting data could be visualised and edited on the web site by all of the Welsh LAs, minimising costs and helping to ensure that a consistent data set was created. The public consultation maps could then be printed directly from the website, providing consistently styled and annotated maps.

The Active Travel data set became the first national system for managing Active Travel paths and cycle-ways in the UK and will be used to improve the network and plan for the future.

Further information from Crispin Flower.

The work involved consultation with staff at JNCC and the British Oceanographic Data Centre (BODC) to ensure a faithful import and production of meaningful layers that are useful to JNCC marine staff when assessing the current extent of UK marine monitoring according to each, broad marine discipline (e.g. biodiversity, physical oceanography and fisheries). In addition, users can create custom layers, selecting only the monitoring parameters that may be relevant to a particular analysis.

Further information from Andy Brewer