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.