1 of 14

Code-Point Open

An open dataset of all the current postcode units in Great Britain. For each postcode, Code-Point Open provides a positional quality indicator (PQI), country code, NHS area code along with local government county, district, and ward codes.

This product is updated quarterly

Locate your analysis

Link any dataset that includes postcode data to the postcode location in a GIS and build up a spatial picture of your data.

Additional attributes

To give you extra analytical power, Code-Point Open includes NHS authority and administrative unit codes.

Authoritative data

Code-Point Open provides accurate coverage of the 1.7 million postcodes in Great Britain that is updated quarterly.

Link statistical and numeric datasets to your postcode data

Using ONS administrative unit codes and NHS health authority code attributes in each postcode.

Access: Download
Data theme: Administrative and Statistical Units
Data structure: Vector - Points
Coverage: Great Britain
Scale: 1:1 250 to 1:10 000
Format: CSV, GeoPackage
Ordering area: All of Great Britain
Publication months: February, May, August, November
OS Data Hub plan: OS OpenData Plan (FREE), Public Sector Plan, Premium Plan, Energy & Infrastructure Plan

Northern Ireland coverage

Northern Ireland postcodes aren’t included in Code-Point Open, but they are present in Code-Point.

Code-Point accuracy and resolution

Code-Point is created by taking the average of the coordinates of all the individual addresses in a postcode (provided we have any of sufficient quality), then snapping to the nearest of those addresses. Code-Point then delivers the coordinates of that address, as representative of the whole postcode, to a resolution of 1 metre.

The accuracy of a Code-Point Open record could be expressed as, that the coordinated position will always be within the notional geographical extent of the postcode. The accuracy of each postcode unit coordinate pair is defined by the positional quality indicator (PQI) which provides a quality statement of a Code-Point record.

How to get this product

Access to OS OpenData is free through the OS Data Hub.

Code-Point Open Overview

This document contains additional theoretical information related to Code-Point Open. All users will find the Product Information document useful and informative.

Code-Point Open locates over 1.7 million postcode units for Great Britain, each having a notional geographical location. Postcodes are an alphanumeric abbreviated form of an address. Postcode units are unique references and identify an average of 15 addresses. In some cases, where an address receives a substantial amount of mail, a postcode will apply to only one address and is defined as a large-user postcode. The maximum number of addresses in a postcode is 100.

Key product features

With each coordinate point, the Code-Point Open product provides:

A postcode
A positional quality indicator (PQI), which indicates the quality of the data underlying the Code-Point location coordinate (CPLC)
The country code (either England, Scotland or Wales)
The National Health Service (NHS) region and area codes
The local government county, district and ward codes

Product applications

Code-Point Open can be used to display and analyse any data collected at the postcode level. This has led to the product being widely used in a variety of applications, including the following:

Site location
Enabling web searches
Market analysis and profiling
Health and epidemiology
Resource allocation
End-to-end journey route planning
Socio-economic profiling
Sales targeting

Product details

Postcodes

Postcodes are stored in Code-Point Open as alphanumerical values with a maximum length of eight characters (the number of characters in a postcode can vary from six to eight). A postcode contains two parts:

The outcode (also called outward code): The first two to four characters of the postcode, constituting the postcode area and the postcode district. It is the part of the postcode that enables mail to be sent from the accepting office to the correct area for delivery.
The incode (also called inward code): The last three characters of the postcode, constituting the postcode sector and the postcode unit. It is used to sort mail at the local delivery office.

For example:

Outcode

Incode

When used in an address, the incode is always separated from the outcode by a single space. The single space counts as a character.

The following table provides a list of the valid formats of postcodes. In the first two columns, an A indicates an alphabetic character, while an N indicates a numeric character. The last column shows how many characters each example postcode contains.

Outcode

Incode

Example postcode

Number of characters in the example postcode

Postcode position

Each postcode unit will be allocated a National Grid reference of a point that falls within the notional extent of the postcode unit, given as an Easting and Northing. This point is the co-ordinate of the nearest delivery point to the calculated mean position of the delivery points in the postcode unit. These coordinates are provided to a resolution of 1 metre.

Where several postcode units apply to one surveyed position (for example, a block of flats or offices), there is an identical location for each. However, there may be instances where the location is imprecise or approximate, due to the manual allocation by Royal Mail of a postcode outside the recognised geographical extent of that postcode. There may also be a small number of instances where coordinates cannot be allocated.

The accuracy of each postcode unit coordinate pair is defined by the Positional Quality Indicator (PQI), which provides a quality statement for the position of that Code-Point Open record. There are seven PQI values for the positional quality. A lower positional quality indicator will be allocated to postcode units awaiting a surveyed position, or which relate to addresses that do not have a surveyed position. Full details of the PQI can be found in the product's Technical Specification.

Coordinate reference system

The coordinates for postcodes in Great Britain (England, Wales, and Scotland) are provided in British National Grid (BNG). BNG uses the OSGB36 (EPSG 27700) geodetic datum and a single Transverse Mercator projection for the whole of Great Britain. Positions on this projection are described using Easting and Northing coordinates in units of metres. The BNG is a horizontal spatial reference system only; it does not specify a vertical (height) reference system.

Product supply

Available formats

Code-Point Open is available in the following formats:

Comma-separated values (CSV)
GeoPackage (GPKG)

Supply mechanism

Code-Point Open is only available as national cover of Great Britain. The product is supplied in two formats (CSV and GeoPackage) as an online download from the OS Data Hub.

The product is provided as a complete resupply. Any postcode that is deleted between supplies will not be included.

Product update schedule

Code-Point Open is supplied to customers quarterly (in February, May, August, and November), incorporating updates from georeferenced Royal Mail Postcode Address File (PAF) and GridLink. GridLink is a joint consortium dataset that provides geospatially referenced postcode data, consisting of UK postcodes, administration areas and health authority codes. The GridLink Consortium comprises Royal Mail, Ordnance Survey, the Office for National Statistics (ONS), Land & Property Services (LPS), and National Records of Scotland (NRS). Each consortium member supplies component data to create the GridLink dataset.

Administrative and health authority codes are allocated to postcodes using a point in polygon comparison against Boundary-Line data.

Coverage and file sizes

Code-Point Open covers postcodes for Great Britain.

The approximate file sizes of the respective data formats are as follows:

CSV: 153MB
GeoPackage: 257MB

Code-Point Open data structure

CSV

The Code-Point Open CSV format contains two folders in the root directory: Doc and Data The Doc folder contains the following files:

Codelist.xlsx – Lookup table of Government Statistical Service (GSS) codes.
Code-Point_Open_Column_Headers.csv – Description of column headers.
licence.txt – Important licence information.
metadata.txt – Number of postcode units in each postcode area.
NHS_Codelist.xls – Lookup table of health GSS codes.
readme.txt – Summary of supplied data.

The Data folder contains the following sub-folder:

CSV – 120 postcode area files in CSV format.

GeoPackage

The Code-Point Open GeoPackage format contains the following text file in the root directory:

Readme.txt – Summary of supplied data And two folders: Doc and Data

The Doc folder contains the following files:

Codelist.xlsx – Lookup table of GSS codes.
Code-Point_Open_Column_Headers.csv – Description of column headers.
Licence.txt – Important licence information.
Metadata.txt – Number of postcode units in each postcode area.
NHS_Codelist.xls – Lookup table of health GSS codes The Data folder contains the following file:
- Codepo_gb.gpkg – One postcode area file in GeoPackage format.

Code-Point Open Getting Started Guide

This technical specification provides detailed technical information about Code-Point Open. It is targeted at technical users and software developers.

This getting started guide focusses on using the product in comma-separated values (CSV) format.

Requirements for using the data

What you need to use Code-Point Open

Code-Point Open is a data product and does not include software for analysis but can be used with a variety of programs. Code-Point Open can be loaded into a GIS (geographical information system) for display and analysis of the data. Consult your GIS documentation to establish actual system requirements.

Supply mechanism

Code-Point Open is only available as national cover of Great Britain. The product is supplied in two formats (CSV and GeoPackage) as an online download from the OS Data Hub.

Product update schedule

Updates are supplied quarterly (February, May, August and November) and provided as a complete resupply. Any postcode that is deleted between supplies will not be included.

Coverage and file sizes

Code-Point Open covers postcodes for Great Britain. In CSV format, postcodes are divided into postcode areas and supplied as 120 files. GeoPackage format is a self-contained database.

The approximate file sizes of the respective data formats are as follows:

CSV: 153MB
GeoPackage: 257MB

Code-Point Open data structure

CSV

The Code-Point Open CSV format contains two folders in the root directory: Doc and Data The Doc folder contains the following files:

Codelist.xlsx – Lookup table of Government Statistical Service (GSS) codes.
Code-Point_Open_Column_Headers.csv – Description of column headers.
licence.txt – Important licence information.
metadata.txt – Number of postcode units in each postcode area.
NHS_Codelist.xls – Lookup table of health GSS codes.
readme.txt – Summary of supplied data.

The Data folder contains the following sub-folder:

CSV – 120 postcode area files in CSV format.

GeoPackage

The Code-Point Open GeoPackage format contains the following text file in the root directory:

Readme.txt – Summary of supplied data And two folders: Doc and Data.

The Doc folder contains the following files:

Codelist.xlsx – Lookup table of GSS codes.
Code-Point_Open_Column_Headers.csv – Description of column headers.
Licence.txt – Important licence information.
Metadata.txt – Number of postcode units in each postcode area.
NHS_Codelist.xls – Lookup table of health GSS codes The Data folder contains the following file:
- Codepo_gb.gpkg – One postcode area file in GeoPackage format.

Available formats

CSV

The structure of Code-Point Open supplied in CSV is described in the product's Technical Specification.

GeoPackage

The structure of Code-Point Open supplied in GeoPackage is described in the product's Technical Specification.

CSV file processing

As Code-Point Open data is supplied in separate .csv files by two-digit grid references, the files will require some processing in order to proceed.

The Great Britain .csv files should be combined with the Code-Point_Open_Column_Headers.csv. To do this:

Before processing the data, create the following folder:
- Great Britain

Then, copy all the .csv files from the CSV folder for Great Britain into this folder (120 in total).

Add the Code-Point_Open_Column_Headers.csv (located in the Doc folder) into the Great Britain folder and prefix the name with: aa_

Combining multiple CSV files

The following is an example of one way to combine all the individual .csv files into a single file by using a .bat batch file.

The .csv file that is created comes to approximately 150MB, and 1.7 million records. If this is opened in Microsoft Excel, only the first million records can be seen as the software cannot display more than this number of records.

To use the batch function:

Copy the following text and paste it into a new Notepad document: copy *.csv outputfile.csv
Save the Notepad document with the file extension .bat (for example, combine_csv.bat) in the Great Britain folder containing the 120 Great Britain .csv files.
Close the .bat file and navigate to the Great Britain folder, where it was saved. Double-click on the .bat file and an MS-DOS window will appear. Once the process is complete, the MS-DOS screen will close automatically.
A new CSV file with the name outputfile.csv has now been created within the Great Britain folder. All the .csv files apart from outputfile.csv can now be deleted as they have all been copied into the one ouputfile.csv.

The outputfile.csv will have two column headers at rows 1 and 2 – an abbreviated version and a full version.

Open the .csv file in a text editor (not Excel) and delete the column header that you don’t want to use, ensuring that any resulting empty row is closed.

You will now have an output file ready for uploading into geospatial software (such as QGIS).

Data measures

Ordnance Survey measures the data in its products in one or more of the ways set out in the definitions of data measures table below.

Data measure

Definition

Sub-measure

Definition

* When testing the data according to the dataset specification against the ‘real world’ or reference dataset.

Metadata

Metadata, which is ISO 19115 UK GEMINI 2 compliant, can be found at https://www.data.gov.uk/dataset/e3d9cd8e-e702-4fc6-a674-c1f25eb5efab/ordnance-survey-code-point-open. Metadata .xml files can be found at http://www.ordnancesurvey.co.uk/oswebsite/xml/products/.

Loading the data into a GIS

The data can be loaded into several geographic information systems (GIS). This section describes how to load the combined CSV output file (for more information on how to combine multiple CSV files, see Section 3.1) into four commonly used GIS, including:

QGIS
ArcGIS Pro
ArcMap
MapInfo Pro 2019

QGIS

The following step-by-step instructions outline how to load Code-Point Open CSV files into QGIS. They have been prepared using version 3.8.1-Zanzibar of QGIS Desktop – an open-source GIS in which you can create, edit and visualise and publish geographic information. You can download QGIS for free from the Download QGIS for your platform page of the QGIS website.

Loading and displaying the CSV supply

To load and display CSV data in QGIS:

Open an existing project in QGIS or create a new one.
In Layer, click Add Layer > Add Delimited Text Layer… or click on the Add Delimited Text Layer symbol in the Manage Layers Toolbar.
This will open the Data Source Manager Delimited Text dialog.
In the Data Source Manager Delimited Text dialog:
- File name: Use the ellipsis button (…) to the right of the File name pane to navigate to the saved outputfile.csv.
- File Format: Select CSV (comma separated values).
- Record and Fields Options: Select First Record has field names.
- Geometry Definition:
  - Select Point coordinates.
  - X field: Choose Eastings (or EA if the abbreviated column header was selected).
  - Y field: Choose Northings (or NO if the abbreviated column header was selected).
  - Geometry CRS: Select EPSG:27700 – OSGB 1936 / British National Grid.
- Click Add.
  It will take a minute or so to load the data into the map pane, but when it has finished, the map pane will look like the example below:
  OS Maps API Light 27700 is being used as the background map for geographic context
The outputfile can now be saved out into any format of your choosing. It is best to do this, otherwise you will have to repeat the process of geoprocessing the outputfile.csv every time you need to use it.

ArcGIS Pro

The following step-by-step instructions outline how to load Code-Point Open CSV files into ArcGIS Pro. They have been prepared using version 3.0.

Loading and displaying the CSV supply

To load and display CSV data in ArcGIS Pro:

Open ArcGIS Pro.
Open a project and name it (in this example, the project will be called cpOpen).
1. Browse to a memorable location in which to save the project and keep the ‘Create a new folder for this project’ option checked.
2. Click OK.
3. Once the project opens, add a background map for geographic context (in this example, OS Maps API Light 27700 has been added as the background map).
4. From the Map tab, click Add Data > XY Point Data.
  A Geoprocessing pane will open on the right-hand side of the map pane.
5. Input Table: Use the folder symbol to the right of the field to navigate to the outputfile.csv.
  - Output Feature Class: This will auto-populate.
  - X Field: Select Easting (or EA if the abbreviated column headers were chosen).
  - Y Field: Select Northing (or NO if the abbreviated column headers were chosen).
  - Coordinate System: Select Current Map [Map]. This will then populate with British National Grid (the OS Maps API Light 27700 map has already been chosen for the background context mapping in this example).
  - Click Run at the bottom right of the Geoprocessing pane.
  In the Geoprocessing pane:
  - Input Table: Use the folder symbol to the right of the field to navigate to the outputfile.csv.
  - Output Feature Class: This will auto-populate.
  - X Field: Select Easting (or EA if the abbreviated column headers were chosen).
  - Y Field: Select Northing (or NO if the abbreviated column headers were chosen).
  - Coordinate System: Select Current Map [Map]. This will then populate with British National Grid (the OS Maps API Light 27700 map has already been chosen for the background context mapping in this example).
  - Click Run at the bottom right of the Geoprocessing pane.
    It will take a minute or so to load the data into the map pane, but when the data has finished loading, the map pane will look like the example below:
    OS Maps API Light 27700 has been used as the background map for geographic context.
    As a result of this process, a new file geodatabase will have been created in the new folder that was created when the project was opened.

ArcMap

The following step-by-step instructions outline how to load Code-Point Open CSV files into ArcMap. They have been prepared using version 10.7.1.

Loading and displaying the CSV supply

To load and display CSV data in ArcMap:

Open ArcMap.
Click on the Add Data button from the top ribbon.
In the Add Data dialog, browse to where you have saved your outputfile.csv, select the file and click Add.
The file will now appear in the Table Of Contents.
Right-click on the outputfile.csv in the Table of Contents and select Display XY data…
In the Display XY Data dialog:
1. X Field: Select Eastings (or EA if the abbreviated column headers have been chosen).
2. Y Field: Select Northings (or NO if the abbreviated column headers have been chosen).
3. Coordinate System of the Input Coordinates: Select British National Grid.
4. Click OK.
Click OK in the following window which will automatically pop up:
The message warns you that the file resulting layer is only a temporary table and will need to be saved out.
After a minute or so, the points will appear in the map pane; the map pane should look similar to the following example:
Before the points can be used meaningfully, you'll need to save the layer out as a shapefile:
- Right-click on the outputfile.csv Events layer in the Layers panel.
- Click Export from the drop-down menu.
- In the Export Data dialog, browse to and select a file name for the data.
- Click OK.
  The shapefile will take several minutes to create, but progress can be monitored in the Export Progress window that will automatically pop up. This window will close when the export is complete.
The following window will also pop up, giving you the option to add the newly created data to the workspace. If you click Yes, then a shapefile and associated files will be created at the chosen location.

MapInfo Pro

The following step-by-step instructions outline how to load Code-Point Open CSV files into MapInfo Pro. They have been prepared using version MapInfo Pro 2019, release build 58.

Loading and displaying the CSV supply

To load and display CSV data in MapInfo Pro:

Open MapInfo Pro 2019.
Select Open > Blank Workspace.

Open a mapping background for geographic context (in this example, OS Maps API Light 27700 has been added as the background map).

From the HOME tab, click Open Table.
In the Open dialog:
- Files of type: Change from MapInfo.tab to Comma delimited CSV (*.csv).
- Browse to outputfile.csv and click on it.
- Click Open.
In the Open dialog:
- Files of type: Change from MapInfo.tab to Comma delimited CSV (*.csv).
- Browse to outputfile.csv and click on it.
- Click Open.
  It will take several minutes for the table to load, but when it does, a window called outputfile Browser will open:
To create the points from the table, click on the SPATIAL tab from the top ribbon > Create > Create Points.
In the Create Points dialog:
- Projection: Change this from Longitude / Latitude (WGS 84) to British National Grid [EPSG:27700]. The easiest way to do this is to click the ellipsis button next to Projection and then tap B on the keyboard 6 times, highlight British National Grid [EPSG:27700] in the results and click OK.
- using Symbol: The default style in this dialog is a square. You can change this to something a bit more visible (for example, a red star) if you like by clicking on the ‘using Symbol’ button and following the instructions.
- Leave all the other settings.
- Click OK.
  A progress bar will appear; it will disappear when the geoprocessing has finished:
  Once the process has finished, the points will appear in the map pane with your chosen point style. The map pane should look similar to the following example:
  A .tab file (and associated .MAP and .ID files) is automatically created in the same folder as the outputfile.csv. However, these are the temporary files that are created as part of the point creation process and they will be difficult to query.

To save the output file layer as a true .tab file, click the HOME tab > Save > Save Copy As. In the Save Copy As dialog, select outputfile and click Save As…

In the Save Copy of Table As dialog, navigate to where you would like to save the .tab file, give it a memorable name and click Save:
A progress bar will once again appear and then disappear when the save has completed. A more easily queryable .tab file will now be available to use in MapInfo.

Glossary

Glossary term

Definition

Code-Point Open Technical Specification

This technical specification provides detailed technical information about Code-Point Open. It is targeted at technical users and software developers.

Code-Point Open is a dataset that contains postcode units for Great Britain, each having a notional geographical location. Postcodes are an alphanumeric abbreviated form of an address. Postcode units are unique references and identify an average of 15 addresses. In some cases, where an address receives a substantial amount of mail, a postcode will apply to only one address and is defined as a large-user postcode. The maximum number of addresses in a postcode is 100.

Product structure

Attributes

Attribute

Description

An asterisk (*) indicates that the attribute is blank when the entity does not have a code. The Welsh Local Health Boards are included in Code-Point Open.

Each postcode unit location – also known as CPLC (Code-Point Location Coordinate) – is coordinated on the respective National Grid, with Eastings and Northings quoted to a resolution of 1m. The accuracy of each postcode unit coordinate pair is defined by the positional quality indicator (PQI), which provides a quality statement of that Code-Point Open record. There are seven PQI values for the positional quality:

PQI

Description

Supply formats overview

CSV and GeoPackage

GeoPackage is an open, standard, platform-independent, portable, self-describing, compact format for transferring geospatial information. For more information on this format, please see the Getting started with GeoPackag guide.

The following tables give a comparison between the CSV attributes and the GeoPackage attribution:

CSV attribution and format

GeoPackage attribution and format

CSV format

Those fields containing text (A) will be enclosed by double quotes which have not been included in the sizes listed in the table above. An asterisk (*) denotes variable length.
Fields with null data will appear as "" for text and 0 for numeric.
Each record will be terminated with a carriage return character (ASCII 13) and a line feed character (ASCII 10).

Example of a Code-Point Open CSV record:

"SO16 0AS",10,437292,115542,"E92000001","E19000002","E18000009","E10000014","E07000093","E05012936"

GeoPackage format

Note that there are no Eastings or Northings in GeoPackage; the geometry is already created in the GeoPackage container and is not listed as data but will be seen as a column in a database (PostGIS) called geometry with a coordinate reference system of British National Grid

EPSG: 27700 for Great Britain (GB) postcodes.

Fields with a null value will appear as [Null] for text (PostGIS) or as an empty field in a GIS. A null numeric value will appear as 0 in both a database and an attribute table in a GIS.

Example of a Code-Point Open GeoPackage record taken from the Information tool in QGIS:

Glossary

Glossary Term

Definition

Loading the data into a GIS

QGIS
ArcGIS Pro
ArcMap
MapInfo Pro 2019

QGIS

Loading and displaying the CSV supply

To load and display CSV data in QGIS:

Open an existing project in QGIS or create a new one.
In Layer, click Add Layer > Add Delimited Text Layer… or click on the Add Delimited Text Layer symbol in the Manage Layers Toolbar.
This will open the Data Source Manager Delimited Text dialog.
In the Data Source Manager Delimited Text dialog:
- File name: Use the ellipsis button (…) to the right of the File name pane to navigate to the saved outputfile.csv.
- File Format: Select CSV (comma separated values).
- Record and Fields Options: Select First Record has field names.
- Geometry Definition:
  - Select Point coordinates.
  - X field: Choose Eastings (or EA if the abbreviated column header was selected).
  - Y field: Choose Northings (or NO if the abbreviated column header was selected).
  - Geometry CRS: Select EPSG:27700 – OSGB 1936 / British National Grid.
- Click Add.
  It will take a minute or so to load the data into the map pane, but when it has finished, the map pane will look like the example below:
  OS Maps API Light 27700 is being used as the background map for geographic context
The outputfile can now be saved out into any format of your choosing. It is best to do this, otherwise you will have to repeat the process of geoprocessing the outputfile.csv every time you need to use it.

ArcGIS Pro

The following step-by-step instructions outline how to load Code-Point Open CSV files into ArcGIS Pro. They have been prepared using version 3.0.

Loading and displaying the CSV supply

To load and display CSV data in ArcGIS Pro:

Open ArcGIS Pro.
Open a project and name it (in this example, the project will be called cpOpen).
1. Browse to a memorable location in which to save the project and keep the ‘Create a new folder for this project’ option checked.
2. Click OK.
3. Once the project opens, add a background map for geographic context (in this example, OS Maps API Light 27700 has been added as the background map).
4. From the Map tab, click Add Data > XY Point Data.
  A Geoprocessing pane will open on the right-hand side of the map pane.
5. Input Table: Use the folder symbol to the right of the field to navigate to the outputfile.csv.
  - Output Feature Class: This will auto-populate.
  - X Field: Select Easting (or EA if the abbreviated column headers were chosen).
  - Y Field: Select Northing (or NO if the abbreviated column headers were chosen).
  - Coordinate System: Select Current Map [Map]. This will then populate with British National Grid (the OS Maps API Light 27700 map has already been chosen for the background context mapping in this example).
  - Click Run at the bottom right of the Geoprocessing pane.
  In the Geoprocessing pane:
  - Input Table: Use the folder symbol to the right of the field to navigate to the outputfile.csv.
  - Output Feature Class: This will auto-populate.
  - X Field: Select Easting (or EA if the abbreviated column headers were chosen).
  - Y Field: Select Northing (or NO if the abbreviated column headers were chosen).
  - Coordinate System: Select Current Map [Map]. This will then populate with British National Grid (the OS Maps API Light 27700 map has already been chosen for the background context mapping in this example).
  - Click Run at the bottom right of the Geoprocessing pane.
    It will take a minute or so to load the data into the map pane, but when the data has finished loading, the map pane will look like the example below:
    OS Maps API Light 27700 has been used as the background map for geographic context.
    As a result of this process, a new file geodatabase will have been created in the new folder that was created when the project was opened.

ArcMap

The following step-by-step instructions outline how to load Code-Point Open CSV files into ArcMap. They have been prepared using version 10.7.1.

Loading and displaying the CSV supply

To load and display CSV data in ArcMap:

Open ArcMap.
Click on the Add Data button from the top ribbon.
In the Add Data dialog, browse to where you have saved your outputfile.csv, select the file and click Add.
The file will now appear in the Table Of Contents.
Right-click on the outputfile.csv in the Table of Contents and select Display XY data…
In the Display XY Data dialog:
1. X Field: Select Eastings (or EA if the abbreviated column headers have been chosen).
2. Y Field: Select Northings (or NO if the abbreviated column headers have been chosen).
3. Coordinate System of the Input Coordinates: Select British National Grid.
4. Click OK.
Click OK in the following window which will automatically pop up:
The message warns you that the file resulting layer is only a temporary table and will need to be saved out.
After a minute or so, the points will appear in the map pane; the map pane should look similar to the following example:
Before the points can be used meaningfully, you'll need to save the layer out as a shapefile:
- Right-click on the outputfile.csv Events layer in the Layers panel.
- Click Export from the drop-down menu.
- In the Export Data dialog, browse to and select a file name for the data.
- Click OK.
  The shapefile will take several minutes to create, but progress can be monitored in the Export Progress window that will automatically pop up. This window will close when the export is complete.
The following window will also pop up, giving you the option to add the newly created data to the workspace. If you click Yes, then a shapefile and associated files will be created at the chosen location.

MapInfo Pro

The following step-by-step instructions outline how to load Code-Point Open CSV files into MapInfo Pro. They have been prepared using version MapInfo Pro 2019, release build 58.

Loading and displaying the CSV supply

To load and display CSV data in MapInfo Pro:

Open MapInfo Pro 2019.
Select Open > Blank Workspace.

Open a mapping background for geographic context (in this example, OS Maps API Light 27700 has been added as the background map).

From the HOME tab, click Open Table.
In the Open dialog:
- Files of type: Change from MapInfo.tab to Comma delimited CSV (*.csv).
- Browse to outputfile.csv and click on it.
- Click Open.
In the Open dialog:
- Files of type: Change from MapInfo.tab to Comma delimited CSV (*.csv).
- Browse to outputfile.csv and click on it.
- Click Open.
  It will take several minutes for the table to load, but when it does, a window called outputfile Browser will open:
To create the points from the table, click on the SPATIAL tab from the top ribbon > Create > Create Points.
In the Create Points dialog:
- Projection: Change this from Longitude / Latitude (WGS 84) to British National Grid [EPSG:27700]. The easiest way to do this is to click the ellipsis button next to Projection and then tap B on the keyboard 6 times, highlight British National Grid [EPSG:27700] in the results and click OK.
- using Symbol: The default style in this dialog is a square. You can change this to something a bit more visible (for example, a red star) if you like by clicking on the ‘using Symbol’ button and following the instructions.
- Leave all the other settings.
- Click OK.
  A progress bar will appear; it will disappear when the geoprocessing has finished:
  Once the process has finished, the points will appear in the map pane with your chosen point style. The map pane should look similar to the following example:
  A .tab file (and associated .MAP and .ID files) is automatically created in the same folder as the outputfile.csv. However, these are the temporary files that are created as part of the point creation process and they will be difficult to query.

To save the output file layer as a true .tab file, click the HOME tab > Save > Save Copy As. In the Save Copy As dialog, select outputfile and click Save As…

In the Save Copy of Table As dialog, navigate to where you would like to save the .tab file, give it a memorable name and click Save:
A progress bar will once again appear and then disappear when the save has completed. A more easily queryable .tab file will now be available to use in MapInfo.