About this Dataset

ONSPD Online Latest Centroids

This file contains the digital vector centroids for the National Statistics Postcode Directory in the UK as at May 2025.

The centroids are of every live and terminated postcode in the United Kingdom.

Contains both Ordnance Survey and ONS Intellectual Property Rights.

REST URL of Feature Access Service – https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/ONSPD_Online_Latest_Centroids/FeatureServer

REST URL of WFS Server – https://dservices1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/services/ONSPD_Online_Latest_Centroids/WFSServer?service=wfs&request=getcapabilities

REST URL of MapServer – https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/ONSPD_Online_Latest_Centroids/MapServer
Publisher name: Office for National Statistics
Last updated: 2025-06-10T04:01:13Z

Tables

Table 1

@ukgov.onspd_online_latest_centroids5.table_1

277.37 MB
2714964 rows
57 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "pcd" VARCHAR,
  "pcd2" VARCHAR,
  "pcds" VARCHAR,
  "dointr" BIGINT,
  "doterm" DOUBLE,
  "oscty" VARCHAR,
  "ced" VARCHAR,
  "oslaua" VARCHAR,
  "osward" VARCHAR,
  "parish" VARCHAR,
  "usertype" BIGINT,
  "oseast1m" DOUBLE,
  "osnrth1m" DOUBLE,
  "osgrdind" BIGINT,
  "oshlthau" VARCHAR,
  "nhser" VARCHAR,
  "ctry" VARCHAR,
  "rgn" VARCHAR,
  "streg" DOUBLE,
  "pcon" VARCHAR,
  "eer" VARCHAR,
  "teclec" VARCHAR,
  "ttwa" VARCHAR,
  "pct" VARCHAR,
  "itl" VARCHAR,
  "statsward" VARCHAR,
  "oa01" VARCHAR,
  "casward" VARCHAR,
  "npark" VARCHAR,
  "lsoa01" VARCHAR,
  "msoa01" VARCHAR,
  "ur01ind" VARCHAR,
  "oac01" VARCHAR,
  "oa11" VARCHAR,
  "lsoa11" VARCHAR,
  "msoa11" VARCHAR,
  "wz11" VARCHAR,
  "sicbl" VARCHAR,
  "bua24" VARCHAR,
  "ru11ind" VARCHAR,
  "oac11" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "lep1" VARCHAR,
  "lep2" VARCHAR,
  "pfa" VARCHAR,
  "imd" BIGINT,
  "calncv" VARCHAR,
  "icb" VARCHAR,
  "oa21" VARCHAR,
  "lsoa21" VARCHAR,
  "msoa21" VARCHAR,
  "ruc21ind" VARCHAR,
  "globalid" VARCHAR
);