All pages
Powered 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.

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.

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.

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

  • OS NGD API – Features Filterable:

authorityid

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

  • Nullable: false

  • Max Length: 17

  • OS NGD API – Features Filterable:

versiondate

Date when the version was last updated.

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

  • Nullable: false

  • OS NGD API – Features Filterable: No

  • OS Select+Build Filterable:

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

  • OS Select+Build Filterable:

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

  • OS Select+Build Filterable:

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:

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

  • OS Select+Build Filterable:

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

  • OS Select+Build Filterable:

geometry

Geometry for the feature.

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

  • Nullable: false

  • OS NGD API – Features Filterable: No

  • OS Select+Build Filterable:

geometry_length

The measured length of the geometry in metres.

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

  • Nullable: false

  • Precision: 15

  • Scale: 6

theme

The OS NGD theme to which this feature belongs.

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

  • Nullable: false

  • Code List Name:

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:

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:

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

  • OS NGD API – Features Filterable:

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

  • OS Select+Build Filterable:

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

  • OS Select+Build Filterable:

Yes
  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • Yes
  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • No
  • Data Schema Version: 1.0

  • No
  • Data Schema Version: 1.0

  • 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

  • No
  • Data Schema Version: 1.0

  • No
  • Data Schema Version: 1.0

  • No
  • Data Schema Version: 1.0

  • Geometry Type: MultiLineString

  • 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

  • No
  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • No
  • Data Schema Version: 1.0

  • No
  • Data Schema Version: 1.0

  • changetypevalue
    themevalue
    associatedstreetdatadescriptionvalue
    reinstatementtypevalue

    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 OS NGD Resources GitHub repository.

    For instructions on loading CSV files, see the Getting Started with CSV guide.