Adding Road Names and Numbers to a Map

Sources:

• RoadLine – includes name, number and alternative name

• Road – includes designated name and who has designated it

• Street – designated name, descriptor and local name

What are the Differences?

Street contains designated name given by name and numbering authority. Where matched this will be in the name field on the road link. Roadlink name comes from name plate from survey this will be alternative on matched streets and name on unmatched.

Use cases

• Adding street names to mapping

• Directions for routing

• Gazetter searching and identifying the correct street

What You Will Need

Data

• Roads Specification

• Roadlink

• Road

• Street

Software

• Translation software is required to convert data from GML into chosen format. FME workbenches are available on GitHub to help with this.

• Data storage – once translated the data will need to be stored in a format compatible with your systems, this may be on your file system as a shape file, geopackage or tab file or in a database.

• GIS or web application to manipulate and display your results.

Steps to Success: Adding Road Names and Numbers to a Map

1. Local name contains other names the authority may know a street by.

2. The GML and may contain multiple values for each e.g.

<highway:roadName xml:lang="cym">Ffordd Conway</highway:roadName> 
<highway:roadName xml:lang="eng">Conway Road</highway:roadName>

1. Note a language field is also present to indicate the language of the name, e.g. English, Welsh or Gallic. These can either be held as one or split into multiple fields.

2. Once translated the road names can be added to either roadlink or street geometry using the labelling tools within your chosen software.

3. You may want to combine names across tables, for instance, to display the local name with the road name on the roadlink There are a number of ways to do this:

   1. Construct are query in your labelling tool.

   2. Append local name from street to roadlink.

   3. Create a new table of roadlinks with the columns containing the labels.

Sample Code for Creating Name Table

CREATE TABLE schema.local_names AS SELECT
r.roadclassification, r.formofway, r.roadname1_name, r.roadname2_name, s.localname1, s.localname2, r.geom 
FROM
schema.roadlink AS r, schema.street AS s, schema.streetnetworkref AS n WHERE
(r.toid = n.roadlink_toid) AND
(s.usrn = n.usrn);