Baselight

Ordnance Survey Code-Point Open

Greater London Authority

@ukgov.ordnance_survey_code_point_open

Loading...
Loading...

About this Dataset

Ordnance Survey Code-Point Open

September 2017 OS Code-Point Open for Greater London and London boroughs are downloadable via the links below. OS Code-Point Open provides a National Grid coodinate for a point within each postcode unit (e.g. SE1 2AA) in Great Britain.There are approximately 1.6 million postcode units in the UK and each contains an average of 15 adjoining addresses. It also contains a number of columns of attributes which provide information about each postcode unit, including local authority area codes down to ward level and National Health Service. The geographic extent of the Code-Point dataset below has been limited to the Greater London area as well as extracts for the City of London and the 32 London boroughs individually. In addition to conventional CSV file format, the dataset is also available as ESRI shapefile format (.shp) for ease of use with Geographical Information Systems (GIS) for visualisation and further analysis. Key attributes: postcode unit, easting, northing, NHS health authority code and administrative codes Coverage: Greater London and 33 individual London borough. Format: Comma separated values (.csv) & Esri shapefile (.shp) External link: https://www.ordnancesurvey.co.uk/business-and-government/products/code-point-open.html
Publisher name: Greater London Authority
Last updated: 2024-09-14T08:14:27Z

Tables

Code-Point London

@ukgov.ordnance_survey_code_point_open.code_point_london
  • 5.62 MB
  • 181150 rows
  • 15 columns
Loading...

CREATE TABLE code_point_london (
  "objectid" BIGINT,
  "shape" VARCHAR,
  "postcode" VARCHAR,
  "eastings" BIGINT,
  "northings" BIGINT,
  "ward14_nm" VARCHAR,
  "ward14_cd" VARCHAR,
  "boroughcd" VARCHAR,
  "borough" VARCHAR,
  "lsoa11_cd" VARCHAR,
  "lsoa11_nm" VARCHAR,
  "msoa11_cd" VARCHAR,
  "msoa11_nm" VARCHAR,
  "rgn11_cd" VARCHAR,
  "rgn11_nm" VARCHAR
);

Share link

Anyone who has the link will be able to view this.