arrow-left

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

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
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
designation

Type of special designation.

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

  • Nullable: false

  • Code List Name:

hashtag
designationdescription

Additional information describing the special designation.

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

  • Nullable: true

  • Max Length: 254

hashtag
timeinterval

Time period to which the restriction applies.

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

  • Nullable: true

  • Max Length: 254

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

hashtag
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

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


hashtag
Date Time Qualifier

hashtag
datetimequalifierid

The OS identifier of the date time qualifier feature.

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

  • Nullable: false

  • Max Length: 36

hashtag
specialdesignationid

The identifier for the Special Designation feature.

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

  • Nullable: false

  • Max Length: 36

hashtag
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

hashtag
nameddate

The named month or period this time interval applies to.

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

  • Nullable: true

  • Code List Name:

hashtag
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

hashtag
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

hashtag
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

hashtag
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

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

hashtag
starttime

The time the restriction begins.

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

  • Nullable: true

  • Max Length: 8

hashtag
endtime

The time the restriction ends.

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

  • Nullable: true

  • Max Length: 8

hashtag
namedperiod

A specified period in which the restriction applies.

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

  • Nullable: true

  • Code List Name:

hashtag
namedday

The named day this restriction applies to.

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

  • Nullable: true

  • Code List Name:

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

  • 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 NGD API – Features Filterable: No

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • OS NGD API – Features Filterable: Yes

  • OS Select+Build Filterable: Yes

  • Data Schema Version: 1.0

  • OS NGD API – Features Filterable: Yes

  • OS Select+Build Filterable: Yes

  • 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 API – Features Filterable: No

  • OS Select+Build Filterable: No

  • 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

  • Max Length: 9

  • 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 API – Features Filterable: No

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

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

  • OS NGD API – Features Filterable: No

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

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

  • OS NGD Resources GitHub repositoryarrow-up-right
    changetypevalue
    themevalue
    associatedstreetdatadescriptionvalue
    specialdesignationtypevalue
    nameddatevalue
    namedtimevalue
    namedperiodvalue
    nameddayvalue
    Getting Started with CSVarrow-up-right