LogoLogo
OS Docs HomeOS NGDOS APIsOS Download ProductsMore than MapsProduct Refresh Dates
  • OS Download Products' Documentation
  • Addressing and Location
    • Addressing and Location Portfolio Information
    • AddressBase Fundamentals
      • Release Notes
        • AddressBase Products May 2025 – Epoch 118
        • AddressBase Islands May 2025 – Epoch 118
        • AddressBase Products March 2025 – Epoch 117
        • AddressBase Islands March 2025 – Epoch 117
        • AddressBase Products February 2025 – Epoch 116
        • AddressBase Islands February 2025 – Epoch 116
        • AddressBase Products December 2024 – Epoch 115
        • AddressBase Islands December 2024 – Epoch 115
        • AddressBase Products November 2024 – Epoch 114
        • AddressBase Islands November 2024 – Epoch 114
        • AddressBase Products September 2024 – Epoch 113
        • AddressBase Islands September 2024 – Epoch 113
        • AddressBase Products August 2024 – Epoch 112
        • AddressBase Islands August 2024 – Epoch 112
        • AddressBase Products June 2024 – Epoch 111
        • AddressBase Islands June 2024 – Epoch 111
        • AddressBase Products May 2024 – Epoch 110
        • AddressBase Islands May 2024 – Epoch 110
        • AddressBase Products April 2024 – Epoch 109
        • AddressBase Islands April 2024 – Epoch 109
      • AddressBase product family
      • Future and past publication dates
      • Unique Property Reference Number (UPRN)
      • Coordinate reference systems
      • Classification scheme
      • Data sources
      • Street names and numbering
      • Currency, completeness and precision
      • Product supply
      • Code lists and enumerations
        • AddressbasePostalCode
        • BLPUStateCode
        • ChangeTypeCode
        • CountryCode
        • Date
        • FileTypeCode
        • LanguageCode
        • LogicalStatusCode
        • OfficialFlagCode
        • PostcodeTypeCode
        • RPCCode
        • StateCode
        • StreetClassificationCode
        • StreetRecordTypeCode
        • StreetStateCode
        • StreetSurfaceCode
        • Time
        • USRNMatchIndicatorCode
      • AddressBase local custodian codes
      • AddressBase Islands local custodian codes
    • AddressBase
      • Release Notes
      • AddressBase Getting Started Guide
        • Prerequisites
        • Data supply
        • Working with CSV data
        • Working with GML data
        • Working with COU data
        • Creating a single-line or multi-line address
        • Searching for addresses
      • AddressBase Technical Specification
        • Data formats
        • Supply and update
        • AddressBase structure
        • Feature types
          • Address
          • AddressBase Supply Set
        • Code list and enumerations
        • CSV to GML mapping
        • Example records
          • CSV
          • GML
      • AddressBase Downloads
      • AddressBase Known Data Issues
    • AddressBase Core
      • Release Notes
        • 20 May 2025
        • 13 May 2025
        • 07 May 2025
        • 29 April 2025
        • 23 April 2025
        • 15 April 2025
        • 08 April 2025
        • 01 April 2025
        • 25 March 2025
        • 18 March 2025
      • AddressBase Core Overview
        • Data capture and sources
        • GeoPlace
        • Unique Property Reference Number (UPRN)
        • Coordinate reference systems
        • Classification
        • Currency, completeness and precision
        • Product supply
      • AddressBase Core Getting Started Guide
        • Downloading a dataset
        • Working with CSV data
        • Working with GPKG data
        • Working with COU data
        • Working with tiled data
      • AddressBase Core Technical Specification
        • Data formats
        • Supply and update
        • Attributes
        • Enumerations
        • Example records
      • AddressBase Core Downloads
      • AddressBase Core Known Data Issues
    • AddressBase Plus
      • Release Notes
      • AddressBase Plus Getting Started Guide
      • AddressBase Plus Technical Specification
        • Data formats
        • Supply and update
        • AddressBase Plus structure
        • Feature types
          • Address
          • AddressBase Supply Set
        • Code lists and enumerations
        • CSV to GML mapping
        • Example records
          • CSV
          • GML
      • AddressBase Plus Downloads
      • AddressBase Plus Known Data Issues
    • AddressBase Plus Islands
      • Release Notes
      • AddressBase Plus Islands Getting Started Guide
      • AddressBase Plus Islands Technical Specification
        • Data formats
        • Supply and update
        • AddressBase Plus Islands structure
        • Feature types
          • Address
          • AddressBase Supply Set
        • Code lists and enumerations
        • CSV to GML mapping
        • Example records
          • CSV
          • GML
      • AddressBase Plus Islands Downloads
      • AddressBase Plus Islands Known Data Issues
    • AddressBase Premium
      • Release Notes
      • AddressBase Premium Getting Started Guide
        • Prerequisites
        • Data supply
        • Working with CSV data
        • Working with GPKG data
        • Working with GML data
        • Working with COU data
        • Creating a single-line or multi-line address
        • Searching for addresses
      • AddressBase Premium Technical Specification
        • Data formats
        • Supply and update
        • AddressBase Premium structure
        • Feature types
          • Street – (Type 11 Record)
          • BLPU – (Type 21 Record)
          • AddressBase supply set
          • Feature with lifecycle
        • Structured data types
          • Street Descriptor – (Type 15 Record)
          • Application Cross Reference – (Type 23 Record)
          • LPI – (Type 24 Record)
          • Delivery Point Address – (Type 28 Record)
          • Successor Cross Reference – (Type 30 Record)
          • Organisation – (Type 31 Record)
          • Classification – (Type 32 Record)
          • Entity with lifecycle
        • Dataset metadata
          • Metadata – (Type 29 Record)
          • Header – (Type 10 Record)
          • Trailer – (Type 99 record)
        • Code lists and enumerations
        • Attribute format comparison
        • Example records
          • CSV
          • GML
      • AddressBase Premium Downloads
      • AddressBase Premium Known Data Issues
    • AddressBase Premium Islands
      • Release Notes
      • AddressBase Premium Islands Getting Started Guide
      • AddressBase Premium Islands Technical Specification
        • Release Notes
          • June 2024
        • Data formats
        • Supply and update
        • AddressBase Premium Islands structure
        • Feature types
          • Street – (Type 11 Record)
          • BLPU – (Type 21 Record)
          • AddressBase supply set
          • Feature with lifecycle
        • Structured data types
          • Street Descriptor – (Type 15 Record)
          • Application Cross Reference – (Type 23 Record)
          • LPI – (Type 24 Record)
          • Delivery Point Address – (Type 28 Record)
          • Successor Cross Reference – (Type 30 Record)
          • Organisation – (Type 31 Record)
          • Classification – (Type 32 Record)
          • Entity with lifecycle
        • Dataset metadata
          • Header – (Type 10 Record)
          • Metadata – (Type 29 Record)
          • Trailer – (Type 99 record)
        • Code lists and enumerations
        • Attribute format comparison
        • Example records
          • CSV
          • GML
      • AddressBase Premium Islands Downloads
      • AddressBase Premium Islands Known Data Issues
    • Boundary-Line
      • Release Notes
        • May 2025
        • October 2024
        • June 2024
      • Boundary-Line Overview
        • Data overview
        • Product supply
      • Boundary-Line Product Information
        • Relationships of administrative areas
        • Structure of Boundary-Line
        • Boundary-Line principles and features
        • Case studies
        • Metadata
        • Glossary
        • Exception areas
        • The coastline and associated items
      • Boundary-Line Technical Specification
        • Shapefile, TAB and GKPG
          • Features - Shapefile, TAB and GPKG
            • Area - GB
            • Area - English region
            • Area - Wales region
            • Link feature type
            • Area - Polling districts England
            • Historical and ceremonial boundaries features
          • Layers - Shapefile, TAB and GKPG
            • Shapefile
            • TAB
            • GKPG
          • Code lists - Shapefile, TAB and GKPG
            • AreaCode
            • TypeCode
        • GML
          • Features - GML
            • AdministrativeUnit
          • Code lists - GML
            • AdministrativeHierarchyValue
            • NationalClassificationValue
          • Example record - GML
        • Vector tiles
      • Guide to Ceremonial County Boundaries
      • Additional Product Details
      • Boundary-Line Downloads
      • Boundary-Line Known Data Issues
    • Code-Point
      • Code-Point Overview
        • Product details
        • Product supply
      • Code-Point Products Comparison
      • Code-Point Getting Started Guide
        • Product supply
        • Data structure
        • CSV file processing
        • Data measures
        • Metadata
        • Glossary
      • Code-Point Technical Specification
        • Product structure
        • Supply formats
      • Code-Point Downloads
      • Code-Point Known Data Issues
    • Code-Point Open
      • Code-Point Open Overview
        • Product details
        • Product supply
      • Code-Point Open Products Comparison
      • Code-Point Open Getting Started Guide
        • Requirements for using the data
        • CSV file processing
        • Data measures
        • Loading the data into a GIS
        • Glossary
      • Code-Point Open Technical Specification
        • Product structure
        • Supply formats overview
      • Code-Point Open Downloads
      • Code-Point Open Known Data Issues
    • Code-Point with Polygons
      • Release Notes
        • January 2025
      • Code-Point with Polygons Overview
        • Product details
        • Product supply
      • Code-Point with Polygons Products Comparison
      • Code-Point with Polygons Getting Started Guide
        • Using the vertical street lookup
        • Creating single-space postcodes
        • Data measures
      • Code-Point with Polygons Technical Specification
        • Data supply
        • Specification
      • Code-Point with Polygons Downloads
      • Code-Point with Polygons Known Data Issues
    • 🆕OS Emergency Services Gazetteer
      • 🆕OS ESG Overview
        • 🆕Product supply
        • 🆕Planned enhancements
      • OS ESG Getting Started Guide
      • OS ESG Technical Specification
        • Feature type
          • BLPU (Type 21 Record)
        • Structured data types
          • LPI (Type 24 Record)
          • Classification (Type 32 Record)
        • 🆕Code lists
          • AddressbasePostalCode
          • BLPUStateCode
          • ChangeTypeCode
          • 🆕ClassificationCode
          • CountryCode
          • FileTypeCode
          • LanguageCode
          • LogicalStatusCode
          • OfficialFlagCode
          • RPCCode
          • USRNMatchIndicatorCode
        • Dataset metadata
          • Header (Type 10 Record)
          • Metadata (Type 29 Record)
          • Trailer (Type 99 Record)
      • 🆕OS ESG FAQs
      • 🆕OS ESG Downloads
      • OS ESG Known Data Issues
    • OS Open Built Up Areas
      • Release notes
        • April 2024
      • OS Open Built Up Areas Overview
        • Product details
        • Product supply
      • OS Open Built Up Areas Technical Specification
        • Feature types
          • Built Up Areas
          • Built Up Extents
          • Non Built Up Extents
        • Structured data types
          • MultiSurfaceWithAreaType
          • NameType
        • Code list
          • LanguageValue
        • Supply formats
      • OS Open Built Up Areas Known Data Issues
    • OS Open Names
      • Release Notes
        • April 2025
        • January 2025
        • October 2024
        • July 2024
      • OS Open Names Overview
        • Product applications
        • Product details
        • Product supply
      • OS Open Names Getting Started Guide
        • Obtaining OS Open Names data
        • CSV file processing
        • Loading the data in a GIS
      • OS Open Names Technical Specification
        • Source of OS Open Names
        • Viewing resolution
        • Product structure
        • Feature type
          • NamedPlace
        • Code lists
          • LanguageValue
          • NamedPlaceTypeValue
          • LocalTypeValue
        • Structured data types
          • GeographicalName
          • Identifier
        • Local Type
        • Supply formats overview
        • Attribute naming format comparison
        • LocalType code list
      • OS Open Names Downloads
      • OS Open Names Known Data Issues
    • Points of Interest
      • Release Notes
        • March 2025
        • December 2024
        • September 2024
        • June 2024
      • Points of Interest Product Information
        • Using Points of Interest
        • Data measures and data sources
        • Classification scheme
        • Points of Interest Provenance
        • Glossary
        • Points of Interest symbology
      • Points of Interest Technical Specification
        • Using Points of Interest
        • Pipe delimited text (PDT) file format
          • Record structure
        • Code lists
          • Positional Accuracy
          • Match Indicator
        • Example records
        • Glossary
      • Points of Interest Classification Scheme
        • Accommodation, eating and drinking
        • Commercial services
        • Attractions
        • Sport and entertainment
        • Education and health
        • Public infrastructure
        • Manufacturing and production
        • Retail
        • Transport
      • Points of Interest Class Count
        • Accommodation, eating and drinking
        • Commercial services
        • Attractions
        • Sport and entertainment
        • Education and health
        • Public infrastructure
        • Manufacturing and production
        • Retail
        • Transport
      • Points of Interest Downloads
      • Points of Interest Known Data Issues
  • Contextual or derived mapping
    • Contextual or Derived Mapping Portfolio Information
    • Colour Raster Map Fundamentals
      • Colour Raster Map Overview
        • Metadata
        • Data compression
        • Data measures
        • Product supply
      • Colour Raster Map Technical Specification
        • Georeferencing
        • Image file directory (TIFF)
        • Abbreviations used on OS 1:25 000 and 1:50 000 scale mapping
        • Product glossary
    • 1:25 000 Scale Colour Raster
      • 1:25 000 Scale Colour Raster Overview
        • Product details
        • Features depicted in the product
        • Georeferencing
      • 1:25 000 Scale Colour Raster Technical Specification
      • 1:25 000 Scale Colour Raster Downloads
      • 1:25 000 Scale Colour Raster Known Data Issues
    • 1:50 000 Scale Colour Raster
      • 1:50 000 Scale Colour Raster Overview
        • Product details
        • Features depicted in the product
        • Georeferencing
      • 1:50 000 Scale Colour Raster Technical Specification
      • 1:50 000 Scale Colour Raster Downloads
      • 1:50 000 Scale Colour Raster Known Data Issues
    • 1:250 000 Scale Colour Raster
      • 1:250 000 Scale Colour Raster Overview
        • Product details
        • Georeferencing
        • Gazetteer
      • 1:250 000 Scale Colour Raster Technical Specification
      • 1:250 000 Scale Colour Raster Downloads
      • 1:250 000 Scale Colour Raster Known Data Issues
    • GB Overview Maps
      • GB Overview Maps Downloads
      • GB Overview Maps Known Data Issues
    • MiniScale
      • MiniScale Product Guide
        • Supply and formats
        • Georeferencing
        • Depiction of roads and towns
        • Data compression
        • Features, layers and styles
      • MiniScale Technical Specification
        • National Grid
        • MiniScale file management
      • MiniScale Downloads
      • Miniscale Known Data Issues
    • OS Open Zoomstack
      • OS Open Zoomstack Getting Started Guide
        • Zoomstack vector tiles
        • Zoomstack GeoPackage format
      • OS Open Zoomstack Technical Specification
        • List of Layers
        • Description of the cartographic styles
        • Sea Extent and Name Languages
        • Vector Tiles Schema
        • GeoPackage Schema
      • OS Open Zoomstack Known Data Issues
    • OS OpenMap – Local
      • Release Notes
        • April 2025
      • OS OpenMap – Local Overview
        • Product applications and uses
        • Product details
        • Product supply
      • OS OpenMap – Local Getting Started Guide
        • Loading raster data
        • Loading vector data
        • Loading and displaying GML Data
        • POSTGIS
        • Loading and displaying Shapefile supply
        • Viewing the data in QGIS
        • Using shapefiles in PostGIS
        • Using MapInfo Professional
      • OS OpenMap – Local Technical Specification
        • Data structure
        • Feature types
          • Building
          • ElectricityTransmissionLine
          • Glasshouse
          • RailwayStation
          • RailwayTrack
          • RailwayTunnel
          • Road
          • RoadTunnel
          • Roundabout
          • MotorwayJunction
          • CarChargingPoint
          • Foreshore
          • SurfaceWater_Area
          • SurfaceWater_Line
          • TidalBoundary
          • TidalWater
          • Woodland
          • FunctionalSite
          • ImportantBuilding
          • NamedPlace
        • Code lists
          • RailwayStationClassification
          • RailwayTrackClassification
          • DrawLevelValue
          • OverrideValue
          • RoadClassification
          • RoundaboutClassification
          • CarChargingType
          • RatedVoltage
          • ChargeMethod
          • TidalBoundaryClassification
          • BuildingTheme
          • BuildingClassification
          • SiteClassification
          • FontHeightClassification
          • NamedPlaceClassification
      • OS OpenMap – Local Downloads
      • OS OpenMap – Local Known Data Issues
    • OS VectorMap District
      • OS VectorMap District Overview
        • Generalisation
        • Feature types
        • Style definition
        • Product supply
      • OS VectorMap District Technical Specification
        • GML Overview
        • Raster Specification
        • Georeferencing
        • Feature types
          • Building
          • ElectricityTransmissionLine
          • Glasshouse
          • RailwayStation
          • RailwayTrack
          • RailwayTunnel
          • MotorwayJunction
          • Road
          • RoadTunnel
          • Roundabout
          • Foreshore
          • SurfaceWater_Area
          • SurfaceWater_Line
          • TidalBoundary
          • TidalWater
          • Ornament
          • Woodland
          • FunctionalSite
          • NamedPlace
          • SpotHeight
          • AdministrativeBoundary
        • Code lists
          • RailwayStationClassification
          • RailwayTrackClassification
          • RoadClassification
          • RoundaboutClassification
          • DrawLevelValue
          • OverrideValue
          • TidalBoundaryClassification
          • FunctionalSiteClassification
          • NamedPlaceClassification
          • FontHeightClassification
          • AdministrativeBoundaryClassification
        • Attributes
        • Feature Codes
        • Styling of Land and Sea
      • Vector Simple Guide
        • Downloading OS OpenData
        • Opening OS OpenData in QGIS
        • Styling vector data
        • Opening and saving maps in Composer
      • Raster Simple Guide
        • Downloading OS OpenData
        • Opening OS OpenData in QGIS
        • Opening and saving a map in composer
      • OS VectorMap District Downloads
      • OS VectorMap District Known Data Issues
    • OS VectorMap Local
      • Release Notes
        • January 2025
      • OS VectorMap Local Overview
        • Product details
        • Features represented in the product
        • Product style definition
        • Product supply
        • National Grid coverage for OS VectorMap Local
      • OS VectorMap Local Technical Specification
        • GeoPackage overview
        • GML overview
        • Raster data
        • Feature types
          • Area
          • Line
          • VectorMapPoint
          • RoadCLine
          • RailCLine
          • Text
        • Code lists
          • DrawLevelValue
          • AnchorPositionValue
          • TextFontValue
        • Structured data types
          • textRenderingType
        • Feature codes and descriptions
        • Vector tiles overview
        • Important Buildings classification
      • OS VectorMap Local Downloads
      • Supporting documents
        • OS VectorMap Local Cartographic Style Definitions
      • OS VectorMap Local Known Data Issues
  • Networks
    • Networks Portfolio Information
    • OS Detailed Path Network
      • OS Detailed Path Network Overview
        • Product details
        • Attribution
        • Product supply
        • Coordinate reference system
      • OS Detailed Path Network Getting Started Guide
        • Downloading the data
        • Loading GML data
      • OS Detailed Path Network Technical Specification
        • OS Detailed Path Network structure
        • Feature types
          • Route
          • RouteLink
          • RouteNode
        • Structured data types
          • VerticalGainType
        • Code lists
          • LevelCodeValue
          • PotentialHazardValue
          • RightOfWayValue
          • RouteDescriptiveGroupValue
          • RouteDescriptiveTermValue
          • RouteLinkDescriptiveTermValue
          • RouteNodeDescriptiveTermValue
          • SurfaceTypeValue
        • Data quality
        • GML overview
        • GeoPackage overview
          • Route
          • RouteLink
          • RouteNode
        • Vector Tiles overview
          • Route
          • RouteLink
        • GML examples
      • OS Detailed Path Network Downloads
      • OS Detailed Path Network Known Data Issues
    • OS MasterMap Highways Network Fundamentals
      • Release Notes
        • May 2025
        • April 2025
        • March 2025
        • February 2025
        • January 2025
        • December 2024
        • November 2024
        • October 2024
        • September 2024
        • August 2024
        • July 2024
        • June 2024
      • OS MasterMap Highways Network Product Family
      • OS MasterMap Highways Network Overview
        • Standards
        • Coordinate reference system
        • Feature types
          • Road Link (present in Roads & RAMI products)
          • Road Node (present in Roads & RAMI products)
          • Path Link (present in Paths product)
          • Path Node (present in Paths product)
          • Connecting Link (present in Paths product)
          • Connecting Node (Present in Paths product)
          • Road (present in Roads & RAMI products)
          • Path (present in Paths product)
          • Street (present in all OS MasterMap Highways Network products)
          • Road Junction (present in Roads & RAMI products)
          • Ferry Link (present in all OS MasterMap Highways Network products)
          • Ferry Node (present in all OS MasterMap Highways Network products)
          • Ferry Terminal (present in all OS MasterMap Highways Network products)
          • Access Restrictions (present in RAMI product)
          • Turn Restrictions (present in RAMI product)
          • Restrictions For Vehicles (present in RAMI product)
          • Hazards (present in RAMI product)
          • Structures (present in RAMI product)
          • Maintenance (present in RAMI & Paths products)
          • Reinstatement (present in RAMI & Paths products)
          • Highways Dedication (present in RAMI & Paths products)
          • Special Designations (present in RAMI & Paths products)
        • Product supply
        • Product packaging
        • File naming
        • Feature validation data set
        • Volume feature count
        • OS Open Roads Lookup Table
      • OS MasterMap Highways Network Getting Started Guide
        • What do I need to use this data?
        • Product supply
        • Coverage
        • Product packaging
        • File naming
        • Unzipping GML, GeoPackage, and vector tiles files
        • Loading OS MasterMap Highways Network products into a GIS
        • Relationships between Highways tables
      • OS MasterMap Highways Network Playbook
        • Connecting to Address Data
        • Identifying Change in the Network
        • Highlighting Roads Under Construction
        • Creating a Map of Winter Gritting Routes
        • Adding Road Names and Numbers to a Map
        • Merging Tables and Dropping Geometry
        • Creating a Routable Network
      • OS MasterMap Highways Network Downloads
      • OS MasterMap Highways Network Known Data Issues
    • OS MasterMap Highways Network – Roads
      • OS MasterMap Highways Network Overview
      • OS MasterMap Highways Network – Roads Technical Specification
        • Specification changes
        • Structure
        • How the product fits together
        • Change-Only Update (COU) supply
        • Feature types
          • RoadLink
          • RoadNode
          • Road
          • Street
          • RoadJunction
          • FerryLink
          • FerryNode
          • FerryTerminal
        • Structured data types
          • identifier
          • OperationalStateType
          • DesignatedNameType
          • ResponsibleAuthority
          • CycleFacilityType
          • ElevationGainType
          • RoadWidthType
        • Code lists and Enumerations
          • ChangeValue
          • RoadClassificationValue
          • RoadFunctionValue
          • MatchStatusValue
          • OperationalStateValue
          • ProvenanceSourceValue
          • RoadStructureValue
          • LinkDirectionValue
          • FormOfWayValue
          • CycleFacilityValue
          • RoadWidthConfidenceLevelValue
          • FormOfRoadNodeValue
          • RoadNodeClassificationValue
          • AccessPointValue
          • StreetTypeValue
          • JunctionTypeValue
          • ConnectionTypeValue
          • FormOfWaterwayNodeValue
        • GML overview
        • GeoPackage overview
          • ferry_link
          • ferry_node
          • ferry_terminal
          • road
          • road_junction
          • road_link
          • road_node
          • street
        • Vector tiles overview
          • ferry_link
          • ferry_node
          • ferry_node
          • road_link
          • road_node
          • street
        • GML examples
      • OS MasterMap Highways Network Getting Started Guide
      • OS MasterMap Highways Network Known Data Issues
    • OS MasterMap Highways Network – Routing and Asset Management Information
      • OS MasterMap Highways Network Overview
      • OS MasterMap Highways Network – Routing and Asset Management Information Technical Specification
        • Specification changes
        • How the product fits together
        • Routing and Asset Management feature information
          • Data types
            • NetworkReference
            • NodeReference
            • LinkReference
            • PointReference
            • Multiple Link Reference
            • Point Reference
        • Common attribution
        • Rights and Restrictions
          • Feature types
            • AccessRestriction
            • HighwayDedication
            • TurnRestriction
            • RestrictionForVehicles
        • Advisory information
          • Feature types
            • Hazard
            • Structure
        • Asset management
          • Feature types
            • Maintenance
            • Reinstatement
            • Special Designation
        • Change-Only Update (COU) supply
        • Code lists and enumerations
          • ChangeValue
          • UseTypeValue
          • VehicleTypeValue
          • LoadTypeValue
          • NamedDateValue
          • NamedDayValue
          • NamedPeriodValue
          • NamedTimeValue
          • AccessRestrictionValue
          • DedicationValue
          • TurnRestrictionValue
          • RestrictionTypeValue
          • HazardTypeValue
          • StructureTypeValue
          • ReinstatementTypeValue
          • SpecialDesignationTypeValue
          • LinkDirectionValue
          • MaintenanceValue
        • Data types
          • TemporalPropertyType
          • DateRangeType
          • DayPropertyType
          • TimePropertyType
          • TimeRangeType
          • TrafficRegulationOrderType
          • VehicleQualifier
          • ResponsibleAuthority
          • Identifier
        • GML overview
        • GeoPackage overview
          • Access Restriction
          • Highway Dedication
          • Turn Restriction
          • Restriction for Vehicles
          • Hazard Point
          • Hazard
          • Structure Point
          • Structure
          • Maintenance
          • Maintenance Point
          • Maintenance Line
          • Maintenance Area
          • Reinstatement
        • GML examples
      • OS MasterMap Highways Network Getting Started Guide
      • OS MasterMap Highways Network Known Data Issues
    • OS MasterMap Highways Network – Paths
      • OS MasterMap Highways Network Overview
      • OS MasterMap Highways Network – Paths Technical Specification
        • Specification changes
        • Structure
        • How does the product fit together?
        • Change-Only Update (COU) Supply
        • Feature types
          • PathLink
          • PathNode
          • ConnectingLink
          • ConnectingNode
          • Path
          • Street
          • FerryLink
          • FerryNode
          • FerryTerminal
          • Maintenance
          • Reinstatement
          • SpecialDesignation
          • HighwayDedication
        • Structured data types
          • Identifier
          • CycleFacilityType
          • ElevationGainType
          • OperationalStateType
          • DesignatedNameType
          • ResponsibleAuthority
          • TemporalPropertyType
          • DateRangeType
          • DayPropertyType
          • TimePropertyType
          • TimeRangeType
        • Data types
          • NetworkReferenceLocation
          • Temporal Properties
        • Code lists and Enumerations
          • ChangeValue
          • FormOfWayValue
          • SurfaceTypeValue
          • MatchStatusValue
          • ProvenanceSourceValue
          • CycleFacilityValue
          • FormOfRoadNodeValue
          • RoadNodeClassificationValue
          • OperationalStateValue
          • StreetTypeValue
          • ConnectionTypeValue
          • FormOfWaterwayNodeValue
          • DedicationValue
          • ReinstatementTypeValue
          • SpecialDesignationTypeValue
          • MaintenanceValue
        • GML Overview
        • GeoPackage overview
          • connecting_link
          • connecting_node
          • ferry_link
          • ferry_node
          • ferry_terminal
          • highway_dedication
          • maintenance
          • path
          • path_link
          • path_node
          • reinstatement
          • special_designation
          • street
        • Vector tiles overview
          • connecting_node
          • ferry_link
          • ferry_node
          • highway_dedication
          • path_link
          • path_node
          • street
        • GML examples
      • OS MasterMap Highways Network Getting Started Guide
      • OS MasterMap Highways Network Known Data Issues
    • OS MasterMap Water Network Layer
      • Release Notes
        • April 2025
        • January 2025
        • October 2024
        • April 2024
      • OS MasterMap Water Network Layer Overview
        • Feature types in the product
        • Standards and CRS
        • Product supply
      • OS MasterMap Water Network Layer Getting Started Guide
        • Requirements for using the data
        • Structure of the supplied data
        • Loading GML data into a GIS
        • Creating a water network using ESRI software
      • OS MasterMap Water Network Layer Technical Specification
        • Product notes
          • January 2022 product notes
        • Product structure
        • Feature types
          • WatercourseLink
          • HydroNode
        • Structured data types
          • LinearReference
          • PointReference
        • Code lists and enumerations
          • LinkDirectionValue
          • WatercourseFormValue
          • WatercourseProvenanceValue
          • LevelOfDetailValue
          • ReasonForChangeValue
          • VerticalPositionValue
          • HydroNodeCategoryValue
          • WatercourseTypeValue
        • Feature types for future release
          • WatercourseSeparatedCrossing
          • WatercourseLinkSet
          • WatercourseInteraction
        • GML overview
        • GeoPackage overview
          • WatercourseLink
          • HydroNode
        • Vector tiles overview
          • Attribute naming differences
          • HydroNode
        • Data provenance
        • Additional resources
      • OS MasterMap Water Network Layer Downloads
      • OS MasterMap Water Network Layer Known Data Issues
    • 🆕OS Multi-modal Routing Network
      • OS MRN Overview
        • Product supply
        • Coordinate reference system
        • Feature types overview
          • Transport Link overview
          • Transport Node overview
          • Turn Restriction overview
        • OpenStreetMap schema
        • Modal change
        • Grade separation
      • OS MRN Getting Started Guide
        • pgRouting
        • GraphHopper
        • OpenTripPlanner
        • Working with OpenStreetMap files
      • OS MRN Technical Specification
        • Feature types
          • Transport Link
          • Transport Node
          • Turn Restriction
        • Code lists
          • AccessValue
          • BridgeValue
          • FordValue
          • HighwayValue
          • JunctionValue
          • OneWayValue
          • RailServiceValue
          • RailwayValue
          • RestrictionLabelValue
          • RouteValue
          • TunnelValue
      • OS MRN Known Data Issues
    • OS Open Rivers
      • Release notes
        • April 2025
        • October 2024
      • OS Open Rivers Overview
        • OS Open Rivers Data
        • Product supply
        • Coverage and file sizes
      • OS Open Rivers Technical Specification
        • Product structure
        • Feature types
          • WatercourseLink
          • HydroNode
        • Code lists
          • LinkDirectionValue
          • WatercourseFormValue
          • HydroNodeCategoryValue
        • GML overview
        • Esri shapefile overview
          • WatercourseLink
          • HydroNode
        • GeoPackage overview
          • GeoPackage format changes April 2023
          • WatercourseLink
          • HydroNode
        • Vector tiles overview
          • Vector tiles schema
          • WatercourseLink
          • HydroNode
      • OS Open Rivers Downloads
      • OS Open Rivers Known Data Issues
    • OS Open Roads
      • Release notes
        • April 2025
        • October 2024
        • April 2024
      • OS Open Roads Overview
        • OS Open Roads Data
        • Feature types
        • Product supply
        • Coverage and file sizes
      • OS Open Roads Technical Specification
        • Product structure
        • Feature types
          • RoadLink
          • RoadNode
          • MotorwayJunction
        • Code lists and enumerations
          • RoadClassificationValue
          • RoadFunctionValue
          • FormOfWayValue
          • RoadStructureValue
          • FormOfRoadNodeValues
        • GML overview
        • Esri shapefile overview
          • RoadLink
          • RoadNode
        • GeoPackage overview
          • RoadLink
          • RoadNode
        • Vector Tiles overview
          • RoadLink
          • RoadNode
          • MotorwayJunction
      • OS Open Roads Downloads
      • OS Open Roads Known Data Issues
  • Topography
    • Topography Portfolio Information
    • OS MasterMap Topography Layer – Building Height Attribute
      • Release Notes
        • April 2025
        • October 2024
        • April 2024
      • OS MasterMap Topography Layer – Building Height Attribute Overview
        • Product details
        • Product attributes
        • Product supply information
        • Product data
      • OS MasterMap Topography Layer – Building Height Attribute Getting Started Guide
        • What do I need to use this data?
        • Product supply information
        • Managing .csv data
        • Loading data into a GIS
        • Joining Building Height Attribute data to a OS MasterMap Topography Layer
        • Importing data into a database
      • OS MasterMap Topography Layer – Building Height Attribute Technical Specification
        • Product supply
        • Product structure
        • Feature type
          • Building Height Attribute
        • Code list
          • BHA_ConfValue
        • Example record
      • OS MasterMap Topography Layer – Building Height Attribute Downloads
      • OS MasterMap Topography Layer – Building Height Attribute Known Data Issues
    • OS MasterMap Greenspace Layer
      • Release Notes
        • April 2025
        • October 2024
      • OS MasterMap Greenspace Layer Overview
        • Product details
        • Function and form
        • Data creation
        • Product supply
      • OS MasterMap Greenspace Layer Getting Started Guide
        • Using GeoPackage and Vector Tile formats
        • QGIS
        • ArcGIS ArcMap
        • PostGIS
        • MapInfo Professional
        • CadCorp Map Modeller
        • Loading the data
      • OS MasterMap Greenspace Layer Technical Specification
        • Product classification and structure
        • Feature types
          • Greenspace Area
        • Code lists and Enumerations
          • Function
          • Form
        • Function hierarchy
        • Form hierarchy
        • OS Open Greenspace lookup table
        • GML overview
        • ESRI Shapefile overview
        • GeoPackage overview
        • Vector Tiles overview
        • Attribute mapping
        • GML example record
      • OS MasterMap Greenspace Layer Downloads
      • OS MasterMap Greenspace Layer Known Data Issues
    • OS MasterMap Sites Layer
      • Release Notes
        • April 2025
        • October 2024
        • April 2024
      • OS MasterMap Sites Layer Overview
        • Product details
        • Product supply
        • Coordinate reference systems
        • Product glossary
      • OS MasterMap Sites Layer Getting Started Guide
        • QGIS
        • Cadcorp SIS Desktop
        • FME Desktop
        • ArcGIS and ArcMap
        • MapInfo Professional
        • Astun Technology GML/KML Loader
      • OS MasterMap Sites Layer Technical Specification
        • Data specification overview
        • Theme definitions
          • Air transport
          • Education
          • Medical care
          • Rail transport
          • Road transport
          • Water transport
          • Utility or industrial
        • Functional site extent overview
        • Access point overview
        • Routing point overview
        • Feature types
          • FunctionalSite
          • AccessPoint
          • RoutingPoint
        • Enumerations
          • FunctionStatusValue
          • StakeholderRoleValue
          • ExtentDefinitionValue
          • AccessTypeValue
          • NatureOfAccessValue
          • AccessUseRestrictionValue
          • AccessMechanismValue
          • AccessDirectionValue
          • ReasonForChangeValue
        • Code lists
          • FunctionValue
          • FunctionThemeValue
        • Geometry
        • GML
        • GeoPackage
          • Functional Site attributes
          • Access Point attributes
          • Routing Point
        • Vector tiles
      • OS MasterMap Sites Layer Downloads
      • OS MasterMap Sites Layer Known Data Issues
    • OS MasterMap Topography Layer
      • Release Notes
        • April 2025
        • March 2025
        • February 2025
        • December 2024
        • November 2024
        • September 2024
        • August 2024
        • June 2024
        • May 2024
        • April 2024
      • Product Refresh Dates
      • OS MasterMap Topography Layer Overview
        • Product purpose
        • Product applications
        • Product details
        • Styling
        • Product themes
        • Coordinate reference systems
        • Product supply
          • Product supply mechanism and options
          • GML supply options
          • Updating data holdings
        • Change management and data association
      • OS MasterMap Topography Layer Getting Started Guide
        • QGIS
        • ArcGIS Pro
        • ArcMap
        • Cadcorp SIS Desktop Express
        • MapInfo Professional
        • FME Desktop
        • Astun Technology GML/KML Loader
      • OS MasterMap Topography Layer Getting Started with Styling Guide
        • Styling method overview
        • How to use the SQL scripts
        • How to use the stylesheets
        • Attribute tables
      • OS MasterMap Topography Layer Standard Styling Specification
        • Cartographic styling
        • Cartographic style definitions
        • Cartographic styling for new descriptive terms
          • TopographicArea
          • TopographicLine
          • TopographicPoint
        • Shared symbol geometry
        • Point symbols
        • Fill symbols
        • Compound symbols
        • Pattern definitions
        • Line styles
        • Cartographic descriptive term style definitions
      • OS MasterMap Topography Layer Technical Specification
        • File naming
        • Supply mechanisms
        • Product themes
          • Administrative Boundaries
          • Buildings
          • Heritage and Antiquities
          • Land
          • Rail
          • Roads, Tracks, and Paths
          • Structures
          • Terrain and Height
          • Water
        • Feature types
          • TopographicPoint
          • TopographicLine
          • TopographicArea
          • BoundaryLine
          • CartographicSymbol
          • CartographicText
        • Complex attributes
          • ChangeHistoryType
          • HeightAboveDatumType
          • HeightAboveGroundLevelType
          • TextRenderingType
        • Enumerations
          • ThemeValue
          • DescriptiveGroupValue
          • AccuracyOfPositionValue
          • ReasonForChangeValue
          • PhysicalPresenceValue
          • MakeValue
          • DescriptiveTermValue
        • Geometric data types
        • Topology
        • Seamless data supply
        • Feature lifecycles and tracking change
          • Polygon feature lifecycle rules
          • Line feature lifecycle rules
          • General point feature lifecycle rules
        • GML overview
          • GML examples
        • GeoPackage overview
        • Vector tiles overview
        • Attribute mapping
        • Geometry mapping
        • COU overview
        • Feature code lookup table
        • Change value descriptions
        • Administrative boundary alignments
      • OS MasterMap Topography Layer Downloads
      • OS MasterMap Topography Layer Known Data Issues
    • OS Open Greenspace
      • Release Notes
        • April 2025
        • October 2024
      • OS Open Greenspace Overview
        • Product details
        • Data creation
        • Product supply
      • OS Open Greenspace Getting Started Guide
        • QGIS
        • ESRI ArcGIS
        • PostGIS
        • MapInfo Professional
        • Cadcorp Map Modeller
      • OS Open Greenspace Technical Specification
        • Data structure
        • Feature types
          • GreenspaceSite
          • AccessPoint
        • Code lists
          • AccessTypeValue
          • FunctionValue
        • GML overview
        • GeoPackage overview
        • Vector tiles overview
        • Attribute mapping
      • OS Open Greenspace Downloads
      • OS Open Greenspace Known Data Issues
  • Identifiers
    • Identifiers Portfolio Information
    • OS Open Identifiers Family Information
    • OS Open Linked Identifiers
      • Release Notes
        • May 2025 – Epoch 43
        • March 2025 – Epoch 42
        • February 2025 – Epoch 41
        • January 2025 – Epoch 40
        • November 2024 – Epoch 39
        • October 2024 – Epoch 38
        • August 2024 – Epoch 37
        • July 2024 – Epoch 36
      • OS Open Linked Identifiers Overview
        • Uses of OS Open Linked Identifiers
        • Product details
      • OS Open Linked Identifiers Getting Started Guide
        • Linked identifiers
        • Instructions to install/load into a database application
      • OS Open Linked Identifiers Technical Specification
        • Product structure
        • Linked Identifier data (CSV) attributes
        • Product Version Information file (JSON)
        • RoadLink_TOID_TopographicArea_TOID_2
        • Road_TOID_TopographicArea_TOID_3
        • Street_USRN_TopographicArea_TOID_4
        • BLPU_UPRN_TopographicArea_TOID_5
        • RoadLink_TOID_Road_TOID_7
        • RoadLink_TOID_Street_USRN_8
        • BLPU_UPRN_RoadLink_TOID_9
        • Road_TOID_Street_USRN_10
        • BLPU_UPRN_Street_USRN_11
        • ORRoadLink_GUID_RoadLink_TOID_12
        • ORRoadNode_GUID_RoadLink_TOID_13
      • OS Open Linked Identifiers Known Data Issues
    • OS Open TOID
      • Release Notes
        • May 2025 – Epoch 43
        • March 2025 – Epoch 42
        • February 2025 – Epoch 41
        • January 2025 – Epoch 40
        • November 2024 – Epoch 39
        • September 2024 – Epoch 38
        • August 2024 – Epoch 37
        • July 2024 – Epoch 36
      • OS Open TOID Overview
        • Product supply
        • Coordinate reference system
      • OS Open TOID Technical Specification
        • Product Details
        • Data structure
        • Product Supply
      • OS Open TOID Known Data Issues
    • OS Open UPRN
      • Release Notes
        • May 2025
        • March 2025
        • February 2025
        • December 2024
        • November 2024
        • September 2024
      • OS Open UPRN Overview
        • Product supply
        • Coordinate reference systems
      • OS Open UPRN Technical Specification
        • Feature type
          • OS Open UPRN
      • OS Open UPRN Known Data Issues
    • OS Open USRN
      • Release Notes
        • May 2025
        • April 2025
        • March 2025
        • February 2025
        • January 2025
        • December 2024
        • November 2024
        • October 2024
        • September 2024
        • August 2024
        • July 2024
      • OS Open USRN Overview
        • Product supply
        • Coordinate reference system
      • OS Open USRN Technical Specification
        • Street Type
        • Feature type
          • OS Open USRN
        • Geometry
        • Metadata
      • OS Open USRN Known Data Issues
  • Height and imagery
    • Height and Imagery Portfolio Information
    • 🆕OS 3D Mesh (Beta Product)
      • 🆕OS 3D Mesh Overview
        • 🆕Product data
        • 🆕Feature modelling
      • 🆕OS 3D Mesh Getting Started Guide
        • 🆕Importing an OS integrated mesh model into ArcGIS Pro
          • 🆕Navigation
          • 🆕Scene lighting
          • 🆕Adding additional vector data
          • 🆕Adding 2D polygon layers
          • 🆕Adding 3D line feature layers
          • 🆕Adding point datasets
          • 🆕Adding miscellaneous 3D models
          • 🆕'Line of sight' analysis
          • 🆕Animation
        • 🆕Importing an OS integrated mesh model into ArcGIS Online
          • 🆕Adding data to AGOL
          • 🆕Creating a 3D scene
          • 🆕Adding an OS mesh
          • 🆕Spatial reference systems
          • 🆕Defining 'Layer Style' options
          • 🆕Polygon layers
          • 🆕Line layers
          • 🆕Point layers
          • 🆕Text labels
          • 🆕Custom 3D models
          • 🆕Spatial analysis and reporting
    • OS Terrain 5
      • OS Terrain 5 Overview
        • Product supply
        • Pre-requisites
        • Data structure
        • Source data
        • The National Grid
      • OS Terrain 5 Technical Specification
        • Grid data
        • Contour data
        • GML Feature types
        • Esri shapefile
        • Metadata
        • Product glossary
      • OS Terrain 5 Downloads
      • OS Terrain 5 Known Data Issues
    • OS Terrain 50
      • OS Terrain 50 Overview
        • Product supply
        • Pre-requisites
        • Data structure
        • Source data
      • OS Terrain 50 Technical Specification
        • Grid data
        • Contour data
        • GML Feature Types
        • Esri Shapefile
        • GeoPackage
        • Vector tiles
        • Metadata
        • Product glossary
      • OS Terrain 50 Downloads
      • OS Terrain 50 Known Data Issues
    • OS MasterMap Imagery Layer
      • OS MasterMap Imagery Layer Technical Specification
        • Image appearance
        • Ancillary files
      • OS MasterMap Imagery Layer Downloads
      • OS MasterMap Imagery Layer Known Data Issues
  • Getting Started
    • Getting Started with GeoPackage
      • Accessing GeoPackage data via GIS software
      • Loading GeoPackage into a database
      • Reading GeoPackage data via FME
    • Getting Started with Vector Tiles
      • Installing vector tiles in GIS software
      • Using OS styles to get started in Mapbox Studio
      • Hosting and serving your own vector tiles
      • Using OS styles on vector tiles you have created
      • Product downloads
  • Resources
    • 📅Product Refresh Dates
    • 📣Product Announcements
    • 🗺️PSGA Product Summary
    • 🔍OS MasterMap Product Viewer Tool
    • OS Product Roadmap
    • End of Life Product Notices
      • End of Life Notice – OS MasterMap Water Network Layer
    • Accessibility
    • Contact Us
    • 📃Terms and Conditions
    • 📔Open Identifiers Policy
    • Use of NSG and OS Data
Powered by GitBook
On this page

Was this helpful?

Export as PDF
  1. Topography
  2. OS MasterMap Topography Layer
  3. OS MasterMap Topography Layer Getting Started with Styling Guide

How to use the SQL scripts

PreviousStyling method overviewNextHow to use the stylesheets

Last updated 8 months ago

Was this helpful?

This section contains instructions on how to use the scripts in various databases (PostgreSQL/PostGIS, Oracle and SQL Server) and an overview of the key principles on which the scripts are based.

The SQL scripts are available in the SQL directory of the GitHub repository.

Introduction to the SQL scripts

Before using the SQL scripts, you need to determine how your OS MasterMap Topography Layer loading software handles the descriptiveGroup and descriptiveTerm attributes, because these attributes often contain multiple values. Some loaders use a simple VARCHAR(254) data type and load in the data as a comma separated list of values, while others load in the data as an array. For example, this is what a descriptiveTerm with multiple values, looks like when loading OS MasterMap Topography Layer data using:

  • FME: Rough Grassland,Scrub,Heath

  • GDAL/OGR2OGR library: {“Rough Grassland”,Scrub,Heath}

This is an important distinction as it determines which SQL queries you can use to find the different descriptiveGroup and descriptiveTerm values. If you are unsure which method your loader uses, look at the data in your database or at the CREATE TABLE SQL statement that was used. Either of these will show you the data type of each attribute field. For example, in PostgreSQL/PostGIS using OGR2OGR, if the descriptive term field was created as descriptiveterm character varying[], it is an ARRAY. When you know this, you can choose the correct SQL query script to use.

Before running the SQL scripts, please check your schema and table names as these may be different from those used in our SQL queries. You can use find and replace in a text editor to tweak the SQL queries to match your database configuration.

PostgreSQL/PostGIS

This section is only relevant if you are using GML data. The data in the GeoPackage and Vector tiles (MBTiles) formats of the product already include a style_code column and other

As mentioned in the previous section, the structure of your database and data depends on how you load your data. You need to use the SQL query that correctly matches your data structure. Different operators are available to find the attribute values, depending on whether your data is loaded as a string or an array.

For example, in PostGIS:

  • String: You can use the ~operator to find a value within the string of values, for example: WHEN descriptivegroup ~ ‘Building’ AND descriptiveterm IS NULL THEN ‘Building Fill’

  • Array: You can use the @> (contains) operator to find a value within the array of values, for example: WHEN descriptivegroup @> ‘{Building}’ AND descriptiveterm IS NULL THEN ‘Building Fill’

Both types of SQL query create a new table using a CASE statement. This is more efficient than using an UPDATE SET statement, because the PostgreSQL MVCC model creates a new row for each row affected by the UPDATE. This means that the original rows then need to be deleted. Previous tests that compared the methods showed that the CASE method took seven hours for a GB OS MasterMap Topography Layer set, whereas the UPDATE method took several days.

Because the queries essentially create duplicate tables, you need to ensure that you have enough server hard drive space before running them.

The example below uses pgAdmin III.

To run either SQL query:

  1. Open pgAdmin.

  1. Click (Execute SQL Query) in the toolbar.

  2. Copy the SQL code from the correct PostGIS SQL file and paste into the PostGIS SQL Query window.

See scripts above for guidance on how to choose the correct script.

  1. Click (Execute Query) in the toolbar to run the script.

At Ordnance Survey we run all the SQL scripts (that is, for all feature types) simultaneously. Before attempting this, please check that your PostgreSQL configuration is set to handle this approach because it may consume a lot of server resources.

Post processing may take several hours, depending on the amount of OS MasterMap Topography Layer data you have loaded and your configuration settings.

  1. After the SQL query has run, you will have both your original database table (for example “osmm. topo.topographicarea”) and a new table that includes the additional styling attributes (for example, “osmm_topo.topographicarea_styled”). You can manage these tables in one of two ways:

    • DROP/DELETE the original table and rename the new styled table the name of the original table. The advantage of this is that existing connections to that database table will continue to work.

    • DROP/DELETE the original table and leave the new styled table as it is. The disadvantage of this is that an existing database connection looking for your original table will fail; you will need to connect to the new styled database table.

Oracle

The SQL scripts for Oracle work with descriptiveGroup and descriptiveTerm attributes that are strings and use the INSTR function to find attribute values within the string. We chose to use INSTR rather than LIKE because in our tests INSTR SQL queries ran faster. The Oracle scripts UPDATE and SET the new style_description and style_code attributes and you need to add extra columns to your database tables for these attributes before running the SQL scripts.

The example below adds the style_description attribute to the “topographicarea” table. We use SQL Developer to run the SQL script.

To run the Oracle SQL queries:

  1. Open SQL Developer and navigate to the database in which your OS MasterMap Topography Layer is stored.

  2. Add the extra attribute column/s:

Our example adds a “style_description” column to the “sw_topographicarea” table.

  • In the Connections panel select the table to which you want to add a new attribute column/s. In the Worksheet area, enter an SQL query to add the a new attribute column.

ALTER TABLE sw_topographicarea ADD (style_description varchar(250), style_code number);

Substitute the table name as necessary.

  • Click (Run) to run the query.

If the SQL runs successfully, the message “table <table name> altered” for example “table SW_TOPOGRAPHICAREA altered” will display in the Script Output area (below the Worksheet area).

  • Click in the Connections panel to refresh the list. This ensures that the new “style_description/style_code” column displays in the list.

  • In the Connections panel, select the table (for example, “sw_topographicarea”) once again. A new tab showing the revised data structure of the table (including the new column) will open.

  • Repeat this procedure (steps a. to d. above) for the other OS MasterMap Topography Layer database tables.

CartographicText requires additional attributes to be added before running the SQL below:

ALTER TABLE osmm_topo.cartographictext ADD (font_code number, colour_code 
number, rotation number, geo_x number, geo_y number, anchor varchar(2));
  1. Run the styling SQL scripts using the same procedure as above:

    • Select the appropriate table in the Connections panel (for example, “sw_topographicarea”).

    • Copy and paste the content of the matching SQL script (for example, “topographicarea_update_string.sql”) into the Worksheet area.

    • Click (Run) to run the query.

    • Repeat this procedure (steps a. to c. above) for the other OS MasterMap Topography Layer database tables.

You can now go ahead and use the new stylesheets with the data.

SQL Server

The SQL scripts for SQL Server work with descriptiveGroup and descriptiveTerm attributes that are strings and use the CHARINDEX function to find attribute values within the string. The SQL Server scripts UPDATE and SET the new style_description and style_code attributes. Before running the SQL scripts, you need to add extra columns for these attributes to your database tables.

To run the SQL Server scripts:

  1. Open SQL Server Management Studio and connect to your OS MasterMap Topography Layer database.

  2. Add new attribute column/s:

    • Open the Query Editor and run the following SQL query.

ALTER TABLE sw_topographicarea ADD (style_description varchar(250), style_code number);

Our example query adds “style_description” and “style_code” columns to a database table called “sw_topographicarea”. Substitute the table name as necessary.

  • Repeat this procedure for the other OS MasterMap Topography Layer database tables.

CartographicText requires additional attributes to be added before running the SQL:

ALTER TABLE sw_cartographictext ADD (font_code int, colour_code int, rotation float, geo_x int, geo_y int, anchor varchar(2));
  1. Next, run each of styling SQL scripts using the same procedure as above.

You can now go ahead and use the new stylesheets with the data.

Key SQL query principles

The SQL scripts were written to create the new style attributes as efficiently as possible. The SQL queries are based on the key principles detailed below:

  • Rule order: The rule order is based on the descending total count of a discrete feature. This means that as each feature is assessed, fewer rules need to be parsed to get to a matching rule for the feature. The only exception is in the Topographic Area SQL queries where the rules for built environment features are blocked together above the rules for natural environment features.

  • Minimal attributes: The rules try to examine as few attributes as possible. Consider, the following example rules:

    • WHEN descriptivegroup ~ ‘Building’ THEN ‘Building Fill’

    • WHEN descriptivegroup ~ ‘Building’ AND descriptiveterm = ‘Archway’ THEN ‘Archway Fill’

In this example, the second rule would never to be used, because every feature with “Building” in the descriptiveGroup would match the first rule and therefore be styled as “Building Fill”. To overcome this, we need to amend the first rule to take the descriptiveTerm into consideration.

  • WHEN descriptivegroup ~ ‘Building’ AND descriptiveterm IS NULL THEN ‘Building Fill’

  • WHEN descriptivegroup ~ ‘Building’ AND descriptiveterm = ‘Archway’ THEN ‘Archway Fill’

This change allows Archway features to pass the first rule and get styled by the second. However, this means that the first rule needs to examine both the descriptiveGroup and descriptiveTerm attributes, making it fractionally slower than the original rule. We have tried to keep the number of attributes that need to be checked as low as possible.

  • Minimal rules: The greater the number of rules, the greater the time to process all the features. To minimize the number of rules, we used different database operators to make finding certain attribute values easier. Consider the following example descriptiveTerms:

    • Nonconiferous Trees (Scattered), Rough Grassland Scrub,Nonconiferous Trees Nonconiferous Trees,Rough Grassland,Scrub

If we would like all of these to be styled as “Nonconiferous Tree Fill”, one solution is to write three rules:

  • WHEN descriptiveterm = ‘Nonconiferous Trees (Scattered),Rough Grassland’ THEN ‘Nonconiferous Tree Fill’

  • WHEN descriptiveterm = ‘Scrub,Nonconiferous Trees’ THEN ‘Nonconiferous Tree Fill’

  • WHEN descriptiveterm = ‘Nonconiferous Trees,Rough Grassland,Scrub’ THEN ‘Nonconiferous Tree Fill’

A better alternative is to use one rule that looks for “Nonconiferous Tree” or “Nonconiferous Tree (Scattered)” at any position of the descriptiveTerm.

  • WHEN descriptiveterm ~ ‘Nonconiferous Trees’ OR descriptiveterm ~ ‘Nonconiferous Trees (Scattered)’ THEN ‘Nonconiferous Tree Fill’

If all of these features have a style_description of “Nonconiferous Tree Fill”, it does not matter at which position the “Nonconiferous Tree” is as it will always be styled as “Nonconiferous Tree Fill”.

Ordnance Survey OSMM-Topography-Layer-
stylesheets
Introduction to the SQL
Main screen of PG Admin
pgAdmin III UI showing SQL script pasted in the SQL Editor
Oracle SQL Developer UI showing how to add a new attribute column
Oracle SQL Developer main window and worksheet
Opening screen of pgAdmin III UI
pgAdmin UI showing SQL script pasted in the SQL Editor
Oracle SQL Developer UI showing how to add a new attribute column
Oracle SQL Developer screen showing the toolbar necessary to run the query and view its output