Street Light
Last updated
Was this helpful?
Last updated
Was this helpful?
A point representation of a pole mounted light which is positioned to artificially illuminate sections of a road or path.
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 27 March 2025.
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.
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
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
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
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
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
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: Point
The date on which the latest evidence was gathered to make an update if required. For example, the date of collection by a surveyor or the date the information was received from a third party.
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
Date when the attribute 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
Indication of the method used to capture or produce the data.
Data Types: String (GeoJSON), String (GPKG), String (CSV)
Nullable: false
Max Length: 25
Code List Name: capturemethodvalue
OS NGD API – Features Filterable: No
OS Select+Build Filterable: No
Data Schema Version: 1.0
The OS NGD theme to which the 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
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: streetlightdescriptionvalue
Max Length: 13
OS NGD API – Features Filterable: No
OS Select+Build Filterable: No
Data Schema Version: 1.0
The unique identifier (OSID) of the link the Street Light is related to. This could be a Path Link or Road Link which will be described in the Link Reference Feature Type attribute.
Data Types: String (GeoJSON), String (GPKG), String (CSV)
Nullable: true
Max Length: 36
OS NGD API – Features Filterable: No
OS Select+Build Filterable: No
Data Schema Version: 1.0
The feature type the Street Light is related to.
Data Types: String (GeoJSON), String (GPKG), String (CSV)
Nullable: true
Max Length: 10
Code List Name: transportfeaturetypevalue
OS NGD API – Features Filterable: No
OS Select+Build Filterable: No
Data Schema Version: 1.0
Indicates the confidence of the accuracy of the reference from the Street Light to its associated Road Link or Path Link.
Data Types: String (GeoJSON), String (GPKG), String (CSV)
Nullable: false
Max Length: 30
Code List Name: linkreferenceconfidencevalue
OS NGD API – Features Filterable: No
OS Select+Build Filterable: No
Data Schema Version: 1.0
The date on which the latest evidence was gathered to make an update if required. For example, the date of collection by a surveyor or third party information received.
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
Date when the attribute 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
Indication of the method used to capture or produce the data.
Data Types: String (GeoJSON), String (GPKG), String (CSV)
Nullable: false
Max Length: 25
Code List Name: capturemethodvalue
OS NGD API – Features Filterable: No
OS Select+Build Filterable: No
Data Schema Version: 1.0
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.