Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Discover how to download OS NGD data using our bespoke download service, OS Select+Build.
OS Select+Build is our download service that gives you access to OS NGD data. You can use it to choose the OS NGD data you need (by theme, collection and feature type) and select how you want to download your data as a data package. OS Select+Build is available via the OS Data Hub.
OS NGD data from OS Select+Build can be downloaded in two file formats: GeoPackage and CSV. Detailed information on the supply options available can be found on the data ordering and currency page in the OS NGD Fundamentals guide.
For the first time, you can select only the data you need rather than taking off-the-shelf OS products, such as AddressBase or OS MasterMap Topography Layer. For example, if you're only interested in buildings information, then you just create a recipe featuring only the OS NGD Buildings Theme and the content (feature types) you require within it.
OS Select+Build also allows you to combine data from different OS NGD collections. For example, you could select the Building and Building Access Location Feature Types (which are both in the Building Features Collection of the Buildings Theme) and the Land Point and Landform Feature Types (which are both in the Land Features Collection of the Land Theme):
The screenshot above shows what selecting this data would look like using OS Select+Build. The secondary navigation menu on the left-hand side of the screen is where you select the feature types you want from the tree view of the OS NGD themes, collections, and feature types, and where you can apply filters to the feature types (if needed). The right-hand side panel displays the definition for the feature type you've selected and lists all the attributes present within it.
Learn more about recipes in the Getting started with recipes guide.
Adding a data package to your recipe allows you to select the area, format, and update frequency to receive for your data. Learn more about this in the Getting started with data packages guide.
Take a look at the following getting started guides to begin using OS Select+Build to access OS NGD data:
A guide to creating a bespoke selection of OS NGD data within OS Select+Build, covering:
A guide to applying data packages to your OS Select+Build recipes, covering:
A guide to accessing GeoPackage data GeoPackage data via popular GIS software packages
A guide to accessing OS NGD data in CSV (comma-separated values) format.
A recipe is a bespoke selection of OS NGD data which is made by a user within OS Select+Build. Recipes allow you to choose the OS NGD data that best fits your requirements.
OS NGD data is structured by themes, collections, and feature types; the main advantage to this data structure is that you can easily find and select individual feature types across different themes and build your own recipes and data package/s containing only the data you are interested in. There's also the option to select all or only a few feature types from a single theme.
Every new recipe you create will be stored in your OS Select+Build Recipe Library. This library will be visible to other people in your organisation. It provides a central place for colleagues to view and use recipes.
You can:
Delete a recipe
Edit an existing recipe (i.e. add or remove themes / feature types, or change attribute filtering or data schema versions)
Edit the name or description of a recipe
Create multiple data packages from a single recipe
Delete a data package
Search through your organisation's recipes in the OS Select+Build Recipe Library using the recipe name, description, or content (i.e. themes, collections, or feature types)
Search through your organisation's data packages in the Data packages list screen using the data package name, data package number, or product name
Collect your data package(s) via the OS Data Hub or the OS Downloads API
Share a recipe with another organisation that has access to OS Select+Build
You can't:
Download the contents of an OS NGD data package using the grouped file function
Accessing GeoPackage data via CadCorp
CadCorp SIS (version SIS 9 or later)
A GeoPackage dataset
These instructions were created using CadCorp SIS 9 Desktop Express; however all versions of CadCorp SIS 9 or later support GeoPackage.
The data should now appear on the map.
Create and manage OS Select+Build recipes within your organisation:
Edit your OS Select+Build recipes to improve your recipe library:
Share OS Select+Build recipes with external organisations to improve collaboration:
Use attribute filtering to narrow down data selection beyond the feature type level, creating bespoke recipes of OS NGD data:
A comma-separated values (CSV) file is a common interchange format for spreadsheets and databases which facilitates a simplistic use of data. Each field is either textual or numeric. Within the CSV, each field is separated from the next by a comma. CSV file format is universally supported for easy ingestion into all major database products.
Please be aware that CSV files are designed to be opened in a database or GI system, and opening them in other software applications could corrupt the data. In particular, Excel has a row limit which might be exceeded by some of our CSV files containing OS NGD data, depending on the order you placed and its size. We recommend that you load CSV files containing OS NGD data directly into a database or GI system, rather than trying to open these files in Excel.
CSV offers users the following key features:
Change-Only Update (COU) files are only supplied in CSV format (they are not supplied in GeoPackage format)
Geometry provided as Well-Known Text (WKT)
Header rows included in the file
There will be one record per line in each file
Fields will be separated by commas
Where string fields contain commas, they will be delimited by double quotes
Double quotes inside strings will be escaped by doubling
Records will be terminated by Carriage Returns and Line Feeds
CSV files will be Unicode encoded in UTF-8
Accessing GeoPackage data via ArcMap
ArcMap (version 10.2.2 or later)
A GeoPackage dataset
These instructions were created using ArcMap version 10.7, but versions from 10.2.2 onwards will also support GeoPackage features.
The GeoPackage layers should now be viewable in the layers list in the Table Of Contents on the left-hand side of the workspace.
Accessing GeoPackage data via MapInfo Professional
MapInfo Professional (version 15.2 or later)
A GeoPackage dataset
These instructions were completed using MapInfo Professional version 2019; however, any version from 15.2 onwards can be used.
The data should now be available in your workspace.
Accessing GeoPackage data via ArcGIS Pro
ArcGIS Pro (version 1.1 or later)
A GeoPackage dataset
These instructions were created using ArcGIS Pro version 2.5, but versions from 1.1 onwards will support GeoPackage.
The layers added into ArcGIS Pro will appear in the contents pane on the left-hand side of the project.
Accessing GeoPackage data via QGIS
QGIS (version 2.10.1 or later)
A GeoPackage dataset
These instructions were created using QGIS version 3.22. Other versions of QGIS can be used, from version 2.10.1 onwards.
The GeoPackage layers should now be viewable in the layers list on the left-hand side of the workspace.
Detailed documentation on OS NGD design and practical guides on how to apply OS NGD data:
Step-by-step instructions on how to create new data packages, find and download existing ones, and delete data packages.
Adding a data package to your OS Select+Build recipe allows you to select the area, format, and update frequency to receive for your data.
The following sub-sections on this page cover:
Once you've created a recipe, you'll then need to create a data package against it to receive your OS NGD data.
To create a new OS NGD data package:
Click Login on the OS Data Hub menu bar to log into your account.
Add the following details to your data package under Add a data package in the secondary navigation menu:
Give your data package a name.
Choose the area you want to receive your data for: Either 'All of Britain or Predefined Area' (this means you receive data and it will not be refined by location) or 'Draw a polygon / upload a file / use an OS polygon' (to select a smaller area for your data to be provided for).
Select the desired coordinate reference system.
Select a file format: CSV or GeoPackage.
Select the updates you want: Either not required or COU (Change-Only Update) frequency. There is also an option to select a one-off snapshot of a current or past date.
Set your initial supply date.
Click the Create data package button.
You will receive an email confirming that your data package is being created and another one when your new data package is ready to download.
All OS NGD, OS OpenData and OS Premium data packages created and ordered by your organisation will be catalogued in your Data Packages list in the OS Data Hub.
To find and download an existing data package:
Click Login on the OS Data Hub menu bar to log into your account.
Scroll through the list to find a particular data package or use the search bar to search by data package name, data package number, or product name.
Data packages linked to an OS NGD recipe can be identified by their prefix of 'OS NGD Recipe' against the recipe name in the Product column in the Data packages list.
Once you have found the data package you want from the list, click the Download button in the Status column.
You are now within the Data package summary screen, where you can view and download files. Under 'Individual file downloads' in the bottom left-hand side of your screen, you will see a .zip file for every feature type in your data package order. Click on a file to download it.
This is also known as a manifest file, a computing file which contains metadata. We provide an Order Summary file for each feature type in your data package. The following file naming convention will be applied to each Order Summary file you receive:
collection_featuretype_orderSummary.jso
For example, the file name for the Building Part Feature Type Order Summary file would look like this:
bld_fts_buildingpart_orderSummary.jso
The example below shows the information an Order Summary file contains:
{
"featureName": "bld-fts-buildingline",
"crs": "http://www.opengis.net/def/crs/EPSG/0/27700",
"schemaVersion": "1.0",
"validFromDate": null,
"validToDate": "2023-03-01",
"recordCount": 202653
}
To delete an existing OS NGD data package:
Click Login on the OS Data Hub menu bar to log into your account.
Scroll through the list to find a particular data package or use the search bar to search by data package name, data package number, or product name.
Data packages linked to an OS NGD recipe can be identified by their prefix of 'OS NGD Recipe' against the recipe name in the Product column in the Data packages list.
Click the Package options dropdown in the top right-hand side of your screen.
Click Delete package.
A warning pop up will appear.
Click the Delete package button in the pop up.
This guide introduces the concept of temporal filtering in the OS NGD and gives instructions on how to add a temporal filter to a new data package.
Temporal filtering allows you to order a one-off snapshot of data from the OS NGD from a current or past date.
Temporal filtering is an optional step when you create a new data package against one of your existing recipes. For further information and step-by-step instructions on creating recipes and data packages, please see the Getting started with recipes and Getting started with data packages pages.
You cannot apply a temporal filter to an existing data package held in your Data packages list; a temporal filter can only be added to new data packages during the data package creation stage.
The earliest date you can request for the majority of feature types in the OS NGD via a temporal filter is 29 September 2022.
As new feature types are added to the OS NGD, their temporal filter range will begin on the date they are added (for example, 28 March 2023 for the Waterbody Catchment Feature Type). Each feature type page states the earliest start date available for temporal filtering on that feature type.
If you request a temporal filter date for your new data package that precedes the date a feature type in the data package was added to the OS NGD, then no results will be returned.
To create a new OS NGD data package and apply a temporal filter to it:
Click Login on the OS Data Hub menu bar to log into your account.
In your OS NGD Select+Build Recipe Library, scroll or search for the recipe you wish to create a data package against, select that recipe, then click the Add data package button.
Add the following details to your data package under Add a data package in the secondary navigation menu:
Give your data package a name.
Choose the area you want to receive your data for: either 'All of Britain or Predefined Area' (this means you receive data and it will not be refined by location) or 'Draw a polygon / upload a file / use an OS polygon' (to select a smaller area for your data to be provided for).
Select the desired coordinate reference system.
Select a file format: CSV or GeoPackage.
Select the updates you want. Instead of selecting the 'not required' or COU (Change-Only Update) frequency options (which are available under the 'Select updates' drop-down), to apply a temporal filter, you should select the option for a one-off snapshot of a current or past date by ticking the following check box:
Select the supply date needed for the snapshot:
You will receive an email confirming that your data package is being created and another one when your new data package is ready to download.
Reading GeoPackage data via FME
FME is a data integration platform which can read the GeoPackage format and be used to convert and transform the data into other formats or databases. The below example shows how to read a GeoPackage into an FME workbench.
FME Desktop
An FME license
A GeoPackage dataset
In the FME top ribbon, click the Add Reader button
A dialog box will appear.
Another dialog box will appear to specify OGC GeoPackage Parameters.
Here, specific layers within the GeoPackage can be selected, rather than importing the entire file. Additionally, the Search Envelope can be used to clip the GeoPackage to an extent.
An orange reader will appear which will display the name of the GeoPackage table that has been ‘read in’.
GeoPackage (.gpkg) is an open, non-proprietary, platform-independent, and standard data format for geographic information systems (GIS), as (OGC). It is designed to be a lightweight format that can contain large amounts of varied and complex data in a single, easy to distribute and ready to use file. GeoPackage is natively supported by numerous software applications.
GeoPackage offers users the following key features and benefits:
The single file is easy to transfer and offers the end-user a rich experience.
Attribute names are not limited in length, making the format user-friendly.
The file size limit is very large at 140 TB, so lots of data can be easily accommodated (please note that a file size limit may be imposed by the file system to which the file is written).
It supports raster, vector and database formats, making it a highly versatile solution.
It is an OGC standard.
In most cases, it is a plug and play format.
Data will be supplied in British National Grid (ESPG:27700), World Geodetic System (WGS84: EPSG: 4326), or British National Grid + ODN Height (EPSG: 7405), depending on your selection when ordering OS NGD data.
The following sub-sections provide step-by-step instructions on how to access GeoPackage data via various GIS software packages, all current versions of these support GeoPackages natively.
It is possible to use Extract, Transform, Load (ETL) tools to convert the data into different formats and to load into databases.
Step-by-step instructions on how to share your OS Select+Build recipes with other organisations.
You can share a recipe you've created with another organisation (as long as they have access to OS Select+Build on the OS Data Hub). This functionality enables collaboration between organisations.
The following sub-sections on this page cover:
To share a recipe:
To accept a shared recipe:
Click the Accept recipe button. You will be presented with a dialog box explaining: When you accept a recipe, it is added to your organisation’s recipe library. It will show as 'shared'. You can create data packages from it, but you can’t share the recipe with other organisations.
If another team member in your organisation declines the invitation to accept a shared recipe before you view it, you may no longer have access to the shared recipe.
To reject a recipe shared with you:
Using GDAL to load a GeoPackage into a database
GDAL is a translator library for raster and vector geospatial data formats that is released under an X/MIT style Open Source License by the Open Source Geospatial Foundation. It comes with a variety of useful command line utilities for data translation and processing. The following section covers the loading of GeoPackage datasets into a PostgreSQL database using the ETL tool GDAL. The process will be similar for other databases such as Oracle and SQL Server, as well as converting to other data formats.
A PostgreSQL database with PostGIS extension enabled
GDAL version 1.11.0 or above (with access to a command line interface to use it)
A GeoPackage dataset
ogrinfo
<PATH_TO_GEOPACKAGE>
ogrinfo wtr_ntwk_waterlinkset.gpkg
INFO: Open of `C:\wtr_ntwk_waterlinkset.gpkg'
using driver `GPKG' successful.
1: wtr_ntwk_waterlinkset
2: wtr_ntwk_waterlinkset_wtrlinkref (None)
Without any arguments supplied, ogrinfo will return the layers contained within the GeoPackage.
-so
) and ‘List all features of all layers’ (-al
) arguments to view summary information about the layers within the GeoPackageogrinfo
<PATH_TO_GEOPACKAGE>
-so -al
ogrinfo wtr_ntwk_waterlinkset.gpkg -so -al
INFO: Open of `C:\wtr_ntwk_waterlinkset.gpkg'
using driver `GPKG' successful.
Layer name: wtr_ntwk_waterlinkset
Geometry: Unknown (any)
Feature Count: 116
Extent: (209562.134000, 79229.510000) - (341688.834000, 853194.875000)
Layer SRS WKT:
PROJCRS["OSGB 1936 / British National Grid",
[...]
Combined, these arguments will provide summary information about all the layers within the GeoPackage, including projection, schema, feature count and extents.
The arguments below will load all layers from the source GeoPackage into the specified target schema in the database:
ogr2ogr -f PostgreSQL "PG:user=
<USERNAME>
password=
<PASSWORD>
dbname=
<DATABASENAME>
host=
<HOST>
port=
<PORTNUMBER>
active_schema=
<TARGETSCHEMA>
"
<PATHTOGEOPACKAGE>
ogr2ogr -f PostgreSQL "PG:user=example_user password=example_password dbname=postgres host=localhost port=5432 active_schema=example_schema" wtr_ntwk_waterlinkset.gpkg
This will create twp tables in the example_schema
schema:
schemaname | tablename
---------------+---------------------------------
example_schema | wtr_ntwk_waterlinkset
example_schema | wtr_ntwk_waterlinkset_wtrlinkref
Different loading options (including renaming tables, reprojecting the data, etc.) can be found on the PostgreSQL / PostGIS — GDAL documentation page.
Creating data packages
Finding and downloading existing data packages
Deleting data packages
Viewing Order Summary files
Step-by-step instructions on how to create and manage your OS Select+Build recipes.
This guide will help you get started with creating, managing and deleting recipes in your OS Select+Build Recipe Library.
The following sub-sections on this page cover:
Before you create a data package to receive your OS NGD data, you'll need to create a recipe.
Click Login on the OS Data Hub menu bar to log into your account.
Give your recipe a descriptive name.
Add a detailed description for your recipe.
Select your OS NGD data by choosing the themes, collections and feature types you want to include in your recipe.
(Optional) Add filters to the feature types, if needed; more information about this is available on the Getting started with attribute filtering page.
If you wish to choose which schema version (where applicable) you'd like to receive the data in for a feature type, click on the feature type name within the tree view in the secondary navigation menu, then choose a data schema version from the drop-down box in the right-hand side panel.
We recommend defining a naming convention for your organisation before creating OS NGD recipes and / or data packages.
Adding filters to feature types is an optional step for those with advanced OS data knowledge; see the Getting started with attribute filtering page for more information on applying filters and step-by-step instructions.
Selecting a data schema version for a feature type is an optional step; if you don't choose a particular data schema version for a feature type, OS Select+Build will always select the latest available data schema version for you for each feature type by default. See the Data schema versioning page for more information.
Any recipes created by your organisation will be stored in your OS Select+Build Recipe Library in the OS Data Hub.
To find your OS Select+Build Recipe Library:
Click Login on the OS Data Hub menu bar to log into your account.
You can easily check details about any of your organisation's existing recipes, including a recipe's name, description, creation date, author, the filters used (if applicable), and what OS NGD themes, collections and feature types are included in a recipe.
To check what's in an existing recipe:
Click Login on the OS Data Hub menu bar to log into your account.
Select the recipe you're interested in from the menu. In this view, you can see the following high-level details about a recipe:
The recipe's name
The recipe's author
The date the recipe was created
A description of the recipe, if one has been added
OS NGD theme tags to show which themes are included in the recipe
In the screenshot below, you can see that the example recipe includes the following OS NGD themes: Land, Buildings, and Structures:
Clicking on a recipe opens the detailed information view, where you can find more information about the recipe, including:
The recipe's name
A description of the recipe, if one has been added
An option to view all of the filters applied to feature types in the recipe (if applicable)
The date the recipe was created
The recipe's author
An option to show the data schema version of each feature type in the recipe
A recipe tree detailing the OS NGD themes, collections, and feature types included in the recipe
A recipe can be deleted within your recipe library. You can do this if you are the author of the recipe or an admin user.
To delete a recipe:
Click Login on the OS Data Hub menu bar to log into your account.
Loading OS NGD CSV files into databases
It is recommended that you have a basic understanding of database terminology before following the guides in the tabs below. The guides contain generic instructions, and it is recognised that there are multiple ways to load CSV files into databases which may be more suitable to your environment and existing processes.
Prior to loading the data into a database, it is necessary to create the relevant tables in the database. We have supplied the DDL statements that can be accessed in our OS NGD Resources GitHub repository.
These instructions are based on PostgreSQL version 14, but should work for all supported versions. The instructions assume that you have set-up your database with the PostGIS spatial extension.
Once connected to your PostgreSQL database, with the relevant schema and table created, the CSV file can be loaded with the following SQL statement using the COPY command:
COPY destination_schema.destination_table
FROM 'source_path_to_csv_file\source_name_of_csv_file.csv'
DELIMITER ','
CSV HEADER
ENCODING 'UTF8';
There is a known bug affecting PostgreSQL versions 11, 12 and 13 in Windows environments, where the COPY
command cannot load files larger than 4GB. As a workaround, version 14 (or later) of the COPY
command can be used to load data into the affected database versions.
For reference, the error message states ERROR: could not stat file.
These instructions are based on Microsoft SQL Server 2019, but should work for all supported versions.
Once connected to your SQL Server database, with the relevant schema and table created, the CSV file can be loaded with the following SQL statement using the BULK INSERT command:
BULK INSERT destination_schema.destination_table
FROM 'source_path_to_csv_file\source_name_of_csv_file.csv'
WITH (
FORMAT = 'CSV',
FIRSTROW = 2
);
However, it is possible to change the destination geometry
column to a nvarchar(max)
type, and then either post process the table or use a a computed column to generate a geometry type column (see code examples below).
-- Add new geometry column
ALTER TABLE destination_schema.destination_table
ADD new_geometry_column_name geometry;
-- Set new geometry column using existing WKT column
UPDATE destination_schema.destination_table
SET [new_geometry_column_name] = geometry::STGeomFromText(destination_table.geometry, /* EPSG_CODE_OF_GEOM */);
-- Optional drop original WKT column
ALTER TABLE destination_schema.destination_table
DROP COLUMN geometry;
ALTER TABLE destination_schema.destination_table
ADD new_computed_column_name AS
geometry::STGeomFromText(destination_table.geometry, /* EPSG_CODE_OF_GEOM */) persisted;
It is not possible to load OS NGD CSV files into an Oracle database using the default SQL*Loader utility. The geometries are supplied in Well-Known Text (WKT) format and some of them are too large for SQL*Loader to process.
However, with the relevant schema and table created in your Oracle database, the CSV file can be loaded using ETL (extract, transform, load) tools, for example, GDAL or FME.
Creating new recipes
Finding your OS Select+Build Recipe Library
Checking what's in a recipe
Deleting recipes
Once you've created a recipe, you'll need to create a data package against it to receive your OS NGD data. This guide takes you through creating a new data package to apply against your newly created recipe.
Step-by-step instructions on how to edit OS Select+Build recipes.
You can edit the content of an existing recipe (i.e. add or remove themes / feature types, or change attribute filtering or data schema versions) and you can edit the name or description of an existing recipe.
The following sub-sections on this page cover:
To edit a recipe's name:
Click Login on the OS Data Hub menu bar to log into your account.
To edit a recipe's description:
Click Login on the OS Data Hub menu bar to log into your account.
You can edit the content of a recipe, i.e. add or remove themes / feature types, or change attribute filtering or data schema versions. However, you can't edit a recipe if it has data packages linked to it that receive change-only updates (COUs) – please see the warning note below for instructions on how to solve this issue and create a copy of a recipe.
To edit a recipe that doesn't have data packages linked to it that receive COUs:
Click Login on the OS Data Hub menu bar to log into your account.
You can't edit a recipe if it has data packages linked to it that receive change-only updates (COUs). To get round this issue, you'll need to create a copy of the recipe and then edit that copy.
To create a copy of a recipe:
Log into your OS Data Hub account.
Select Data from the main menu.
Choose Downloads > OS Select+Build Recipe Library from the secondary navigation menu.
From your list of recipes, click on the name of the recipe you wish to edit, then click on the Recipe actions dropdown and select Edit recipe.
When the 'Recipe cannot be edited' warning pop up appears, click the Copy recipe button.
Choose a suitable name for your copied recipe, then click Create recipe.
The copied recipe will appear in your OS Select+Build Recipe Library and you can now edit it following the 'How do I edit a recipe?' steps outlined above.
The process to load the COU files will depend on a number of factors based on your own environment and requirements, including:
Database software
Data loading method or software
Feature retention and lifecycle requirements
When processing COU supplies, it is essential that they are processed in the correct productVersion
date order; therefore, in automated processes, we strongly recommend that you build in a test to ensure that the previous supply has been fully processed. For daily COU orders, that will be the previous day’s productVersion
date; for monthly COU orders, that will be the preceding first of the month's productVersion
date.
There are two main scenarios that represent either extreme of the feature lifecycle options:
Latest feature view
Full feature archive
In this scenario, the COU files are processed and only the current version of every feature is retained. This will result in the same data holdings that would be achieved if a new full supply was received on this date.
To achieve this, either post-processing will have to be done once all COU data is loaded into a database, or the loading process will need to evaluate the COU data against your existing data and process accordingly. This processing will be based on the supplied attributes which detail the type of change and the dates for that version.
Each feature type is supplied with a Change Type attribute (changetype
), which is populated from a code list value (changetypevalue
).
Below is a table of the possible change types and the resultant actions required to maintain a latest feature view of the data for the specific feature type. Individual features should be targeted based on that feature type's unique identifier. In the majority of feature types, this will be the osid
, but this is not always the case; therefore, please check the appropriate feature type documentation.
New
Insert as a new feature
Moved From A Different Feature Type
Insert as a new feature
End Of Life
Delete existing feature based on unique identifier
Moved To A Different Feature Type
Delete existing feature based on unique identifier
Modified Attributes
Update the record (see section below)
Modified Geometry
Update the record (see section below)
Modified Geometry And Attributes
Update the record (see section below)
A single feature may be updated multiple times in a single COU file when multiple changes occur within the selected COU frequency. Instead of suppressing all changes other than the last edit, the COU will contain all of the edits which have been made to that feature.
To obtain the current 'live' view of a feature, the latest edit is required; all previous edits can be discounted. In essence, this requires the following two processes:
Discarding all feature records with the exception of the latest Version Available From Date (versionavailablefromdate
)
Discarding all feature records that have a Version Available To Date (versionavailabletodate
) populated, i.e. it is NOT NULL. These records will also have the Change Type Value (changetypevalue
) of 'End Of Life' or 'Moved To A Different Feature Type'.
In this scenario, every record is retained, giving a full lifecycle since the supply started of each feature. This will result in multiple records for each feature.
To enable this in a database, the default primary keys (as defined in the provided DDL scripts) will have to be changed to also include the version available from and to dates (versionavailablefromdate
, versionavailabletodate
).
Editing recipe names
Editing recipe descriptions
Editing the content of recipes
Step-by-step instructions on how to add attribute filters to recipes in your OS Select+Build Recipe Library.
Attribute filtering is a new concept which we have introduced as part of OS Select+Build. The filters can help you to narrow down the exact data you need from the OS NGD. If required, you can add attribute filters to individual feature types when you create a new bespoke recipe of OS NGD data using OS Select+Build. The managing OS Select+Build recipes page has step-by-step instructions on how to create a new recipe. You can also add, edit or remove attribute filters to / in / from feature types in an existing recipe of OS NGD data.
Attribute filtering is an optional step for those with advanced OS data knowledge.
You can:
Add attribute filters to feature types in a new recipe
Add, edit or remove attribute filters to / in / from feature types in an existing recipe
The following sub-sections cover:
To add attribute filters to a new recipe:
Click Login on the OS Data Hub menu bar to log into your account.
Click the Create a new recipe button, adding the relevant details to your recipe.
See the Managing OS Select+Build recipes page for more information on creating recipes.
Click the filter icon next to the feature type(s) you want to add a filter to in the theme selection tree.
The Advanced Filter Options panel will then slide into view from the right and you can begin to build your filter(s):
For a simple filter, select +Add rule.
For a more complex nested filter, select +Add group.
Once you have added all of your relevant filters, click Apply Filter.
To add attribute filters to an existing recipe:
Click Login on the OS Data Hub menu bar to log into your account.
In the Recipe details screen, click on the Recipe actions dropdown and select Edit recipe.
You'll now be able to add filters (see Step 6) or remove filters (see Step 7) from feature types in the recipe.
Click the filter icon next to the feature type you want to add a filter to in the selection tree for the recipe.
The Advanced Filter Options panel will then slide into view from the right and you can begin to build your filter(s):
For a simple filter, select +Add rule.
For a more complex nested filter, select +Add group.
Once you have added all of your relevant filters, click Apply Filter.
Select Save changes.
Add a description of the change you have made, then select Save changes.
Click the Edit filter iconnext to the feature type you want to remove a filter from in the selection tree for the recipe.
When the Advanced Filter Options panel slides into view from the right, select Clear all filters.
Select Save changes.
Add a description of the change you have made, then select Save changes.
In the following worked example of creating a simple filter, we will use the OS NGD Buildings Theme and select the Building Part Feature Type from the Building Features Collection. Our aim is to build a filter to select buildings where education is recorded as the land use.
Click Login on the OS Data Hub menu bar to log into your account.
Click the Create a new recipe button.
See the Managing OS Select+Build recipes page for more information on creating recipes.
Give your recipe a descriptive name.
Add a detailed description for your recipe
Select your OS NGD data by choosing the themes, collections and feature types you want to include in your recipe. For this worked example:
Click on the arrow to the right of Buildings within the theme selection tree to see the collections available within the theme, then click on the arrow to the right of Buildings Features to see the feature types available within that collection.
Click on the check box next to Building Part to select that feature type.
Click on the filter icon to the right of Building Part.
The Advanced Filter Options panel will slide into view from the right, where you can begin to build your filter(s):
In the Advanced Filter Options panel, click + Add rule, then select OSLandUseTierA from the first drop-down.
Leave the operator in the second drop-down as: = (i.e. the equal sign), then select Education from the third drop-down.
Click the Apply filter button.
Your filter will return buildings where education (Education) is recorded as the land use (OS Land Use Tier A attribute).
What if, in addition to the simple filter above (returning results for buildings with a land use of education), we want those results to show only buildings over 15metres in height? What if you also wanted to add an additional filter to show buildings with a land use of rail? To achieve this, you could create a nested filter using the + Add group option.
Click + Add rule to add a second rule below the OSLandUseTierA rule.
In the second rule, select relativeHeightMaximum from the first drop-down, set the operator in the second drop-down as > (i.e. the more than sign), and type 15 in the input box.
Before continuing, select whether you would like the rules within the group to have an And or an Or condition. In this case, you should select And from the And / Or selector.
Next, click + Add group.
The application has drawn an extra box for you. Whatever rules are contained inside this box will be evaluated together, before combining with any rules outside the box.
Before continuing, select whether you would like the rule in the second group to have an And or an Or condition. In this case, you should select Or from the And / Or selector.
In the rule in the extra box, select OSLandUseTierA from the first drop-down, leave the operator as = (i.e. the equal sign) in the second drop-down, and select Transport: Rail from the third drop-down.
Click Apply filter.
Your filter will return results for buildings (Building Part) that have either an education (Education) land use if that building is over 15 metres high or a railway land use (Transport:Rail).
To check what filters have been applied to feature types in an existing recipe:
Click Login on the OS Data Hub menu bar to log into your account.
You are now within the Recipe details screen, where you can view detailed information about the recipe, including the recipe's name, the date it was created, etc. If filters have been applied to the recipe, a filter icon(i.e. a black funnel symbol) will appear under the recipe name alongside text stating: 'Filters have been applied to this recipe'.
Click View all filters to view all of the filters that have been applied to feature types in the recipe.
In the example recipe below, you can see that there is a filter icon(i.e. the black funnel symbol) against the Building Part Feature Type; therefore, this feature type has filters applied to it.
Adding filters to a new recipe
Adding filters to an existing recipe
Creating a simple filter (worked example)
Creating a more complex nested filter (worked example)
Checking if filters are used in an existing recipe