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.

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.

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

• OS Select+Build Filterable: No

• Data Schema Version: 1.0

authorityid

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

• Nullable: false

• Max Length: 17

• OS NGD API – Features Filterable: Yes

• OS Select+Build Filterable: No

• Data Schema Version: 1.0

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

• Data Schema Version: 1.0

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

• Data Schema Version: 1.0

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

• Data Schema Version: 1.0

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: changetypevalue
• Max Length: 50

• OS NGD API – Features Filterable: No

• OS Select+Build Filterable: No

• Data Schema Version: 1.0

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

• Data Schema Version: 1.0

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

• Data Schema Version: 1.0

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

• Data Schema Version: 1.0

• Geometry Type: MultiPoint

theme

The OS NGD theme to which this feature belongs.

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

• Nullable: false

• Code List Name: themevalue
• Max Length: 40

• OS NGD API – Features Filterable: No

• OS Select+Build Filterable: No

• Data Schema Version: 1.0

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: associatedstreetdatadescriptionvalue
• Max Length: 20

• OS NGD API – Features Filterable: Yes

• OS Select+Build Filterable: Yes

• Data Schema Version: 1.0

designation

Type of special designation.

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

• Nullable: false

• Code List Name: specialdesignationtypevalue
• Max Length: 70

• OS NGD API – Features Filterable: Yes

• OS Select+Build Filterable: Yes

• Data Schema Version: 1.0

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

• OS Select+Build Filterable: Yes

• Data Schema Version: 1.0

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

• OS Select+Build Filterable: No

• Data Schema Version: 1.0

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

• OS Select+Build Filterable: No

• Data Schema Version: 1.0

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

• OS Select+Build Filterable: Yes

• Data Schema Version: 1.0

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

• OS Select+Build Filterable: Yes

• Data Schema Version: 1.0

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

• Data Schema Version: 1.0

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

• Data Schema Version: 1.0

---

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

• OS Select+Build Filterable: No

• Data Schema Version: 1.0

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

• OS Select+Build Filterable: No

• Data Schema Version: 1.0

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

• Data Schema Version: 1.0

nameddate

The named month or period this time interval applies to.

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

• Nullable: true

• Code List Name: nameddatevalue
• Max Length: 9

• OS NGD API – Features Filterable: No

• OS Select+Build Filterable: No

• Data Schema Version: 1.0

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

• Data Schema Version: 1.0

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

• Data Schema Version: 1.0

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

• OS Select+Build Filterable: No

• Data Schema Version: 1.0

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

• OS Select+Build Filterable: No

• Data Schema Version: 1.0

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: namedtimevalue
• Max Length: 17

• OS NGD API – Features Filterable: No

• OS Select+Build Filterable: No

• Data Schema Version: 1.0

starttime

The time the restriction begins.

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

• Nullable: true

• Max Length: 8

• OS NGD API – Features Filterable: No

• OS Select+Build Filterable: No

• Data Schema Version: 1.0

endtime

The time the restriction ends.

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

• Nullable: true

• Max Length: 8

• OS NGD API – Features Filterable: No

• OS Select+Build Filterable: No

• Data Schema Version: 1.0

namedperiod

A specified period in which the restriction applies.

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

• Nullable: true

• Code List Name: namedperiodvalue
• Max Length: 28

• OS NGD API – Features Filterable: No

• OS Select+Build Filterable: No

• Data Schema Version: 1.0

namedday

The named day this restriction applies to.

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

• Nullable: true

• Code List Name: nameddayvalue
• Max Length: 15

• OS NGD API – Features Filterable: No

• OS Select+Build Filterable: No

• Data Schema Version: 1.0