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 February 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-03-17T04:00:01Z

Tables

Table 1

@ukgov.onspd_online_latest_centroids4.table_1

310.79 MB
2,712,506 rows
80 columns

CREATE TABLE table_1 (
  "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,
  "oseast100m" DOUBLE,
  "osnrth100m" DOUBLE,
  "osgrdind" BIGINT,
  "oshlthau" VARCHAR,
  "hro" VARCHAR,
  "ctry" VARCHAR,
  "genind" DOUBLE,
  "pafind" DOUBLE,
  "rgn" VARCHAR,
  "streg" DOUBLE,
  "pcon" VARCHAR,
  "eer" VARCHAR,
  "teclec" VARCHAR,
  "ttwa" VARCHAR,
  "pct" VARCHAR,
  "itl" VARCHAR,
  "psed" VARCHAR,
  "cened" VARCHAR,
  "edind" DOUBLE,
  "addrct" DOUBLE,
  "dpct" DOUBLE,
  "moct" DOUBLE,
  "smlbusct" DOUBLE,
  "oshaprev" VARCHAR,
  "lea" VARCHAR,
  "oldha" VARCHAR,
  "wardc91" VARCHAR,
  "wardo91" VARCHAR,
  "ward98" VARCHAR,
  "statsward" VARCHAR,
  "oa01" VARCHAR,
  "oaind" DOUBLE,
  "casward" VARCHAR,
  "park" VARCHAR,
  "lsoa01" VARCHAR,
  "msoa01" VARCHAR,
  "ur01ind" VARCHAR,
  "oac01" VARCHAR,
  "oldpct" VARCHAR,
  "oldhro" VARCHAR,
  "canreg" VARCHAR,
  "cannet" VARCHAR,
  "oa11" VARCHAR,
  "lsoa11" VARCHAR,
  "msoa11" VARCHAR,
  "sicbl" VARCHAR,
  "ru11ind" VARCHAR,
  "oac11" VARCHAR,
  "wz11" VARCHAR,
  "bua11" VARCHAR,
  "buasd11" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "lep1" VARCHAR,
  "lep2" VARCHAR,
  "pfa" VARCHAR,
  "imd" BIGINT,
  "calncv" VARCHAR,
  "nhser" VARCHAR,
  "icb" VARCHAR,
  "oa21" VARCHAR,
  "lsoa21" VARCHAR,
  "msoa21" VARCHAR,
  "globalid" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);