arrow-left

All pages
gitbookPowered by GitBook
1 of 1

Loading...

Reinstatement Line

A feature which has a line geometry and defines the standard the path must be restored to following opening due to works in the highway, as defined in the New Roads and Street Works Act Specification for the Reinstatement of Openings in Highways in England and Wales, and the New Roads and Street Works Act 1991 Specification for the Reinstatement of Openings in Roads in Scotland.

hashtag
Temporal filtering

The earliest date on which you can request a one-off snapshot of a date in the past for data in this feature type is 29 September 2022.

Any data temporally filtered earlier than the specified earliest date noted above for the data schema version may contain data inconsistencies.

hashtag
Feature type attributes

The following sub-sections provide details about the attributes included with this feature type, their data types in the different output formats, and other important metadata about them.

circle-info

hashtag
Loading OS NGD CSV files into databases

Comma-separated values (CSV) file format is universally supported for easy ingestion into all major database products. Before loading OS NGD data contained in CSV files into a database, it is necessary to create relevant tables. Data definition language (DDL) statements for PostgreSQL, SQL Server and Oracle can be accessed in our .

hashtag
osid

Primary identifier for the feature. The OSID is a Globally Unique Identifier (GUID) and requires no centralised authority to ensure uniqueness. Note that the same OSID can occur in more than one feature type when a single feature is represented multiple times in the OS NGD.

  • Data Types: String (GeoJSON), String (GPKG), String (CSV)

  • Nullable: false

  • Max Length: 36

hashtag
authorityid

  • Data Types: String (GeoJSON), String (GPKG), String (CSV)

  • Nullable: false

  • Max Length: 17

hashtag
versiondate

Date when the version was last updated.

  • Data Types: String (GeoJSON), Date (GPKG), Date (CSV)

  • Nullable: false

  • OS NGD API – Features Filterable: No

hashtag
versionavailablefromdate

The date this version of the feature became the latest version.

  • Data Types: String (GeoJSON), DateTime (GPKG), DateTime (CSV)

  • Nullable: false

  • OS NGD API – Features Filterable: No

hashtag
versionavailabletodate

The date this version of the feature was superseded by an update or ceased to exist.

  • Data Types: String (GeoJSON), DateTime (GPKG), DateTime (CSV)

  • Nullable: true

  • OS NGD API – Features Filterable: No

hashtag
changetype

The type of change that generated a new version of the feature.

  • Data Types: String (GeoJSON), String (GPKG), String (CSV)

  • Nullable: false

  • Code List Name:

hashtag
effectivestartdate

The date on which this record was inserted into the Local Authority database.

  • Data Types: String (GeoJSON), Date (GPKG), Date (CSV)

  • Nullable: false

  • OS NGD API – Features Filterable: No

hashtag
effectiveenddate

The date on which the record ceased to exist.

  • Data Types: String (GeoJSON), Date (GPKG), Date (CSV)

  • Nullable: true

  • OS NGD API – Features Filterable: No

hashtag
geometry

Geometry for the feature.

  • Data Types: Geometry (GeoJSON), Geometry (GPKG), WKT (CSV)

  • Nullable: false

  • OS NGD API – Features Filterable: No

hashtag
geometry_length

The measured length of the geometry in metres.

  • Data Types: Number (GeoJSON), Float (GPKG), Real (CSV)

  • Nullable: false

  • Precision: 15

hashtag
theme

The OS NGD theme to which this feature belongs.

  • Data Types: String (GeoJSON), String (GPKG), String (CSV)

  • Nullable: false

  • Code List Name:

hashtag
description

A single descriptive value intended for a quick understanding of what the feature represents.

  • Data Types: String (GeoJSON), String (GPKG), String (CSV)

  • Nullable: false

  • Code List Name:

hashtag
reinstatementtype

Reinstatement as defined in the 'Specification for Reinstatement of Opening in Highways' codes of practice in England and Wales and the 'Specification for the Reinstatement of Openings in Roads' codes of practice in Scotland.

  • Data Types: String (GeoJSON), String (GPKG), String (CSV)

  • Nullable: false

  • Code List Name:

hashtag
locationdescription

Textual description of the location extent of the referenced property when the feature partially references the network.

  • Data Types: String (GeoJSON), String (GPKG), String (CSV)

  • Nullable: true

  • Max Length: 250

hashtag
partialreference

Flag to indicate that the maintenance feature partially references a Street.

  • Data Types: Boolean (GeoJSON), Integer (GPKG), String (CSV)

  • Nullable: false

  • OS NGD API – Features Filterable: No

hashtag
usrn

The Unique Street Reference Number (USRN) of the referenced Street.

  • Data Types: Integer (GeoJSON), Integer (GPKG), Integer (CSV)

  • Nullable: false

  • OS NGD API – Features Filterable: Yes

For instructions on loading CSV files, see the guide.

OS NGD API – Features Filterable: Yes

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • OS NGD API – Features Filterable: Yes

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • Max Length: 50

  • OS NGD API – Features Filterable: No

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • Geometry Type: MultiLineString

  • Scale: 6

  • OS NGD API – Features Filterable: Yes

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • Max Length: 40

  • OS NGD API – Features Filterable: No

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • Max Length: 20

  • OS NGD API – Features Filterable: Yes

  • OS Select+Build Filterable: Yes

  • Data Schema Version: 1.0

  • Max Length: 60

  • OS NGD API – Features Filterable: Yes

  • OS Select+Build Filterable: Yes

  • Data Schema Version: 1.0

  • OS NGD API – Features Filterable: No

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • OS NGD Resources GitHub repositoryarrow-up-right
    changetypevalue
    themevalue
    associatedstreetdatadescriptionvalue
    reinstatementtypevalue
    Getting Started with CSVarrow-up-right