LogoLogo
OS Docs HomeOS NGDOS APIsOS Download ProductsMore than MapsContact Us
  • More than Maps
  • Geographic Data Visualisation
    • Guide to cartography
      • Introduction to cartography
      • Types of maps
      • Symbology
      • Colour
      • Text on maps
      • Generalisation
      • Coordinate reference systems
      • Projections
      • Scale
      • Map legends
      • Map layout
      • Relief representation
      • North arrows
    • Guide to data visualisation
      • Introduction to data visualisation
      • GeoDataViz design principles
      • Types of visualisation
      • Thematic mapping techniques
      • Data visualisation critique
      • Accessible data visualisation
      • Ethical data visualisation
      • Software
      • Data
    • GeoDataViz assets
      • GeoDataViz basemaps
      • Stylesheets
      • GeoDataViz virtual gallery
      • Equal area cartograms
      • How did I make that?
        • Apollo 11 Landing
        • North York Moors National Park, 70 years
        • Snowdonia National Park, 70 years
        • Great Britain's National Parks
        • Great Britain's Islands
        • Great Britain's AONB's and National Scenic Areas
        • Famous shipwrecks of Pembrokeshire
        • Trig pillars today
        • Britain's most complex motorway junctions
      • #30DayMapChallenge
  • Data in Action
    • Examples
  • Demonstrators
    • 🆕Product Viewer
    • Addressing & location demonstrators
      • Address Portfolio overview
      • Which address product should you use?
      • AddressBase
      • AddressBase Core
      • AddressBase Plus
      • AddressBase Premium
      • Address Classifications
      • Addressing Lifecycle
      • OS Emergency Services Gazetteer
      • What are Vertical Streets?
      • Why are there differences in boundaries?
    • Contextual demonstrators
    • Customer best practice
      • Channel Shift
      • Data Management and OS Data Hub
      • End User Licence vs Contractor Licence
      • 🆕 IDs vs Spatial Relationships
      • Why we should capture good quality addresses at source
      • Why we Snap and Trace
    • Network Demonstrators
      • OS Detailed Path Network
      • OS Multi Modal Routing Network
        • OS Multi Modal Routing Network
      • Water Networks overview
      • OS MasterMap Highways Network and OS NGD Speeds
      • OS MasterMap® Highways Network and OS Open Roads™
    • OS MasterMap Generation APIs
      • Using the OS Features API
      • Using the OS Features API Archive
      • Using the OS Downloads API
      • Using OS APIs in ESRI Software
    • 🆕OS NGD (National Geographic Database)
      • OS NGD Address
      • OS NGD Boundaries
      • 🆕OS NGD Buildings
        • 🆕Building and Building Access Feature Types
        • Building Part and Building Line Feature Types
      • 🆕OS NGD Geographical Names
      • OS NGD Land
      • OS NGD Land Cover enhancements
      • 🆕OS NGD Land Use
      • OS NGD Land Use enhancements
      • 🆕OS NGD Structures
        • 🆕OS NGD Structures
        • Field Boundaries
      • 🆕OS NGD Transport Features
      • 🆕OS NGD Transport Network
      • OS NGD Transport RAMI
      • OS NGD Water Features
      • OS NGD Water Network
      • OS NGD API - Features
      • Ordering OS NGD data
      • Change only updates
      • OS NGD Versioning
      • Creating a topographic map from OS NGD Data
      • Analytical styling for OS NGD data
    • OS MasterMap® demonstrators
    • 🆕Product & API Comparisons
      • 🆕Comparison of Water Network Products
  • Tutorials
    • GeoDataViz
      • Thematic Mapping Techniques
      • Downloading and using data from the OS Data Hub
      • How to download and use OS stylesheets
      • How to use the OS Maps API
      • Creating a bespoke style in Maputnik
    • GIS
      • Analysing pavement widths
      • Basic routing with OS Open Data and QGIS
      • Walktime analysis using OS Multi-modal Routing Network and QGIS
      • Creating 3D Symbols for GIS Applications
      • Constructing a Single Line Address using a Geographic Address
      • Creating a Digital Terrain Model (DTM)
      • Visualising a road gradient using a Digital Terrain Model
      • Visualising a road gradient using OSMM Highways
    • 🆕APIs
      • 🆕Using OS APIs with EPC API
      • 🆕OS APIs and ArcGIS
  • Deep Dive
    • Introduction to address matching
    • Guide to routing for the Public Sector
      • Part 1: Guide to routing
      • Part 2: Routing software and data options
      • Part 3: Building a routable network
    • Unlocking the Power of Geospatial Data
    • Using Blender for Geospatial Projects
    • A Guide to Coordinate Systems in Great Britain
      • Myths about coordinate systems
      • The shape of the Earth
      • What is position?
        • Types of coordinates
        • We need a datum
        • Position summary
      • Modern GNSS coordinate systems
        • Realising WGS84 with a TRF
        • The WGS84 broadcast TRF
        • The International Terrestrial Reference Frame (ITRF)
        • The International GNSS Service (IGS)
        • European Terrestrial Reference System 1989 (ETRS89)
      • Ordnance Survey coordinate systems
        • ETRS89 realised through OS Net
        • National Grid and the OSGB36 TRF
        • Ordnance Datum Newlyn
        • The future of British mapping coordinate systems
        • The future of British mapping coordinate systems
      • From one coordinate system to another: geodetic transformations
        • What is a geodetic transformation?
        • Helmert datum transformations
        • National Grid Transformation OSTN15 (ETRS89–OSGB36)
        • National Geoid Model OSGM15 (ETRS89-Orthometric height)
        • ETRS89 to and from ITRS
        • Approximate WGS84 to OSGB36/ODN transformation
        • Transformation between OS Net v2001 and v2009 realisations
      • Transverse Mercator map projections
        • The National Grid reference convention
      • Datum, ellipsoid and projection information
      • Converting between 3D Cartesian and ellipsoidal latitude, longitude and height coordinates
      • Converting between grid eastings and northings and ellipsoidal latitude and longitude
      • Helmert transformation worked example
      • Further information
  • Code
    • Ordnance Survey APIs
    • Mapping
    • Routing with pgRouting
      • Getting started with OS MasterMap Highways and pgRouting
      • Getting started with OS MasterMap Highways Network - Paths and pgRouting
      • Getting started with OS NGD Transport Theme and pgRouting
      • Getting started with OS NGD Transport Path features and pgRouting
  • RESOURCES
    • 🆕Data Visualisation External Resources
Powered by GitBook

Website

  • Ordnance Survey

Data

  • OS Data Hub
On this page
  • Step 1: Finding and filtering the data
  • Step 2: Creating a hexagonal grid
  • Step 3: Performing a spatial join
  • Step 4: Playing with bivariate symbology
  • Step 5: The all-important colour scheme
  • Step 6: The finishing touches

Was this helpful?

  1. Geographic Data Visualisation
  2. GeoDataViz assets
  3. How did I make that?

Trig pillars today

PreviousFamous shipwrecks of PembrokeshireNextBritain's most complex motorway junctions

Last updated 1 year ago

Was this helpful?

The humble trig pillar is an iconic part of the Great British landscape. They’re part of the vast original retriangulation network of over 31000 points that included lighthouses, turrets, and beacons. With substantial foundations, 6500+ of these weathered pillars can still be found standing today as loved elements of our landscape.

Hexagonal cartogram, illustrating both trig pillar occurrence and elevation across Great Britain

To celebrate the 87th anniversary of the Trig Pillar, our Geospatial Graduate Alice Cunningham describes how she used a bivariate cartogram to analyse trig pillars today, to show us where trig pillars are concentrated, and how does their elevation vary across the landscape.

Step 1: Finding and filtering the data

This is a legacy dataset that is no longer maintained, but a good open-source representation of trig pillars in Great Britain.

When creating any visual representation of geospatial data, it’s important to take a look at the data first. My preferred programme of choice is Safe Software’s FME – but you can use the attribute table within your chosen GIS, or various programming languages to achieve the same result. So, let’s take a look at what we’ve got:

First, I used a Statistics Calculator to summarise 3 variables in the archive:

· TYPE OF MARK (including trig pillars)

· DESTROYED MARK INDICATOR (a binary value assigned for the status of the trig point)

· HEIGHT (the height of the trig pillar above sea level)

This told me that there were roughly 6500 pillars still standing across the UK at the time of archived data publication, and that their height varied between -1 m (Little Ouse, near Ely) and 1345 m (Ben Nevis) (accounting for the trig pillar height itself).

After using a simple Test Filter to extract non-destroyed pillars only, I wrote this out to a shapefile.

Step 2: Creating a hexagonal grid

I could create a heatmap, but to keep things even and neat I decided to create a grid of hexagons to represent data. Using an equal-area projection, I ran the “Generate Tessellation” tool for transverse hexagons.

Step 3: Performing a spatial join

At the moment we have a grid of hexagons, but we don’t have any data assigned to them. Often we manage data using joins and relates, perhaps joining data on the basis of a common attribute.

Here, the link between the hexagon and trig archive is purely spatial – i.e., how many trig pillars occur within the area of a given hexagon? By assigning a spatial join on the hexagonal grid to our trig pillar shapefile, we can count the number of trig pillars inside that hexagon.

Step 4: Playing with bivariate symbology

Taking a step back from our map so far, we’ve got not one but two variables to play with here: the count of trig pillars in each hexagon, and the average height of trig pillars in that area.

We could create two separate maps with a single hue colour ramp, one for occurrence, and one for elevation. But thinking back to their purpose, trig pillar occurrence and their elevation are intrinsically linked.

There are several ways to visualise two linked variables on one cartogram, but in this instance we can make use of colour to blend these variables. Not only does this declutter the visualisation, the blending of two colours (called a bivariate colour scheme) purposefully indicates the fundamental link between the two variables. This creates what’s known as a “bivariate” cartogram. I’m calling this a cartogram rather than a map as the hexagonal grid is a statistical diagram of the UK, not intended as a cartographically accurate map.

By using ArcGIS Pro, I amended the automated legend from “HEIGHT” to “Elevation”, to better communicate that it’s the height above sea level, not the height of the pillar itself.

Step 5: The all-important colour scheme

We need to choose a colour scheme that accommodates for varying Colour Vision Deficiency perception. Helpfully, ArcGIS Pro has a CVD filter that helped me choose a blue-green colour scheme that improves CVD accessibility for the cartogram.

Step 6: The finishing touches

Taking the layout out of ArcGIS Pro, I used Adobe Illustrator to add the finishing touches to this map. Adobe Illustrator isn’t strictly necessary here, and on other projects I have opted for Inkscape as an open-source alternative, or solely used layouts in GIS.

Some of our hexagons were left empty from the spatial join, so these need to be filled in to represent “holes” in our data. Coastal hexagons with no data were omitted due to the spatial join process, meaning this map is a generalised representation of Great Britain. We tend not to use solid black for these hexagons on a GeoDataViz layout, as this creates unwanted focal points and dominates the visualisation.

The final touch was a grey outline and gentle blue halo, used to symbolise the ocean without using a solid fill, creating the impression of the cartogram “popping” off the screen.

To find some data to work with, I took a dive into the .

FME Workbench, used to filter the OS Complete Trig Archive
Placing the data in ArcGIS Pro illustrates the density of the data to work with

I popped the shapefile into ArcGIS Pro, using the ONS Countries (Dec 2021) GB BFC . There were far too many trig points for the reader to comprehend on a single scale.

It is often best to create multiple grid sizes before settling on your final visual. Using the formula for hexagon area on the , I decided that hexagons with a side of 20 km was detailed enough to represent the data without cluttering the view

Using the Generate Tessellation tool in ArcGIS Pro to create a hexagonal grid across Great Britain
By altering the legend, we can communicate that height actually means elevation above sea level in this context
ArcGIS Pro has some helpful CVD filters, that should be used to check your colour scheme before sharing your design
Adding an outline to the map
OS Complete Trig Archive
outline for reference
ESRI toolset
Using the Generate Tessellation tool in ArcGIS Pro to create a hexagonal grid across Great Britain
By altering the legend, we can communicate that height actually means elevation above sea level in this context
Hexagonal cartogram, illustrating both trig pillar occurrence and elevation across Great Britain
ArcGIS Pro has some helpful CVD filters, that should be used to check your colour scheme before sharing your design
FME Workbench, used to filter the OS Complete Trig Archiv
Placing the data in ArcGIS Pro illustrates the density of the data to work with
Adding an outline to the map.