April 2024
This release note provides information about the April 2024 release of OS Open Roads.
Feature counts
| Feature | Count |
|---|---|
RoadLink | 3 877 950 |
RoadNode | 3 265 848 |
MotorwayJuncion | 669 |
Product issues and enhancements
GeoPackage format changes from April 2023
We have updated some of our products available in GeoPackage format to align with Open Geospatial Consortium (OGC) standards and to fix various formatting inconsistencies. Full details of the changes for OS Open Roads GeoPackage format can be found below:
Layer names – The following layer names have changed from title case to snake case:
| Layer name prior to April 2023 | Layer name from April 2023 |
|---|---|
RoadLink | road_link |
RoadNode | road_node |
MotorwayJunction | motorway_junction |
Constraints – The following constraints have changed from title case to snake case:
| Constraint prior to April 2023 | Constraint from April 2023 |
|---|---|
RoadLink_pkey | road_link_pkey |
RoadNode_pkey | road_node_pkey |
MotorwayJunction_pkey | motorway_junction_pkey |
Attribute names – The following attribute names have changed from camel case to snake case:
| Attribute name prior to April 2023 | Attribute name from April 2023 |
|---|---|
id | id |
endNode | end_node |
startNode | start_node |
roadNumberTOID | road_number_toid |
roadNameTOID | road_name_toid |
fictitious | fictitious |
roadClassification | road_classification |
roadFunction | road_function |
formOfWay | form_of_way |
length | length |
length_uom | length_uom |
loop | loop |
primaryRoute | primary_route |
trunkRoad | trunk_road |
roadClassificationNumber | road_classification_number |
name1 | name_1 |
name1_lang | name_1_lang |
name2 | name_2 |
name2_lang | name_2_lang |
roadStructure | road_structure |
formOfRoadNode | form_of_road_node |
junctionNumber | junction_number |
Column name – The geom column name has changed to geometry.
Data types – The Length attribute has changed data type from Integer to Real.
Attribute order – The attributes in the RoadLink layer have changed order:
| Attribute order prior to April 2023 | Attribute order from April 2023 |
|---|---|
id | id |
endNode | fictitious |
startNode | road_classification |
roadNumberTOID | road_function |
roadNameTOID | form_of_way |
fictitious | road_classification_number |
roadClassification | name_1 |
roadFunction | name_1_lang |
formOfWay | name_2 |
length | name_2_lang |
length_uom | road_structure |
loop | length |
primaryRoute | length_uom |
trunkRoad | loop |
roadClassificationNumber | primary_route |
name1 | trunk_road |
name1_lang | start_node |
name2 | end_node |
name2_lang | road_number_toid |
roadStructure | road_name_toid |
Identifier changes – Prior to April 2023, identifiers were prefixed with ‘id’. From April 2023, identifiers will no longer have the prefix ‘id’ (for example, id7F880726-8ADE-4952-B497-A54FE987C8F1 is now 7F880726-8ADE-4952-B497-A54FE987C8F1).
Next release
The next release of OS Open Roads is scheduled for October 2024.
Last updated