All pages
Powered by GitBook
1 of 1

Loading...

Special Designation Point

Special Designations are statutory and advisory designations that can be applied to protect a highway when street or road works are to be undertaken. A Special Designation feature will reference back to the Roads product through network reference and will reference a Street feature. Features which are a partial reference will provide a network reference location.

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:

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:

designation

Type of special designation.

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

  • Nullable: false

  • Code List Name:

designationdescription

Additional information describing the special designation.

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

  • Nullable: true

  • Max Length: 254

  • OS NGD API – Features Filterable:

timeinterval

Time period to which the restriction applies.

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

  • Nullable: true

  • Max Length: 254

  • OS NGD API – Features Filterable:

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:

contactauthority_identifier

The identifier of the Highway or Road Authority to be contacted for further consultation about the special designation.

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

  • Nullable: true

  • Max Length: 4

  • OS NGD API – Features Filterable:

contactauthority_authorityname

The name of the Highway or Road Authority to be contacted for further consultation about the special designation.

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

  • Nullable: true

  • Max Length: 100

  • 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:


Date Time Qualifier

datetimequalifierid

The OS identifier of the date time qualifier feature.

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

  • Nullable: false

  • Max Length: 36

  • OS NGD API – Features Filterable:

specialdesignationid

The identifier for the Special Designation feature.

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

  • Nullable: false

  • Max Length: 36

  • OS NGD API – Features Filterable:

specialdesignationversiondate

The version date of the Special Designation feature.

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

  • Nullable: true

  • OS NGD API – Features Filterable: No

  • OS Select+Build Filterable:

nameddate

The named month or period this time interval applies to.

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

  • Nullable: true

  • Code List Name:

startdate

The date at which the restriction applied starts. This date will be in the format YYYY-MM-DD.

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

  • Nullable: true

  • OS NGD API – Features Filterable: No

  • OS Select+Build Filterable:

enddate

The date at which the restriction applied ends. This date will be in the format YYYY-MM-DD.

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

  • Nullable: true

  • OS NGD API – Features Filterable: No

  • OS Select+Build Filterable:

startmonthday

The date at which the restriction applied starts. This date will be in the format -MM-DD.

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

  • Nullable: true

  • Max Length: 6

  • OS NGD API – Features Filterable:

endmonthday

The date at which the restriction applied ends. This date will be in the format MM-DD.

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

  • Nullable: true

  • Max Length: 6

  • OS NGD API – Features Filterable:

namedtime

These are named time periods that do not relate to the same time each day.

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

  • Nullable: true

  • Code List Name:

starttime

The time the restriction begins.

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

  • Nullable: true

  • Max Length: 8

  • OS NGD API – Features Filterable:

endtime

The time the restriction ends.

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

  • Nullable: true

  • Max Length: 8

  • OS NGD API – Features Filterable:

namedperiod

A specified period in which the restriction applies.

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

  • Nullable: true

  • Code List Name:

namedday

The named day this restriction applies to.

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

  • Nullable: true

  • Code List Name:

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: MultiPoint

  • 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:
    70
  • OS NGD API – Features Filterable: Yes

  • OS Select+Build Filterable: Yes

  • Data Schema Version: 1.0

  • Yes
  • OS Select+Build Filterable: Yes

  • Data Schema Version: 1.0

  • No
  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • No
  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • Yes
  • OS Select+Build Filterable: Yes

  • Data Schema Version: 1.0

  • Yes
  • OS Select+Build Filterable: Yes

  • Data Schema Version: 1.0

  • No
  • Data Schema Version: 1.0

  • No
  • Data Schema Version: 1.0

  • No
  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • No
  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • No
  • Data Schema Version: 1.0

  • Max Length:
    9
  • 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
  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • No
  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • Max Length:
    17
  • OS NGD API – Features Filterable: No

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • No
  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • No
  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • Max Length:
    28
  • OS NGD API – Features Filterable: No

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • Max Length:
    15
  • OS NGD API – Features Filterable: No

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • changetypevalue
    themevalue
    associatedstreetdatadescriptionvalue
    specialdesignationtypevalue
    nameddatevalue
    namedtimevalue
    namedperiodvalue
    nameddayvalue

    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.