Special designations contains references to which streets are gritted.
This information can be displayed against either the street geometry or road link.
Understanding which is the best route to use in winter avoiding untreated roads where possible
Emervency services
Logistics
Roads Specification
Roadlink
Street
StreetNetworkRef
RAMI Specification
SpecialDesingation_Area
SpecialDesingation_Line
SpecialDesingation_Point
SpecialDesingation_NoGeom
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.
Information on Gritting routes is held in the Special Designation tables. This can be viewed with a simple query for example:
However as Special Designation is split into 4 tables depending on geometry type. The results can be merged into 1 table by querying all 4 with UNION ALL and dropping the geometry from the query output.
If you are working with a large data set it may be easier to create a new table of the results. (CREATE TABLE AS…)
The results can be linked using USRN to the Street table and use the geometry to display.
However you may want to add these to RoadLink as this includes classifications as well as road name and number.
This can be achieved by linking the USRN using the StreetNetworkRef table containing TOIDS:
Use the TOID to then join the data to RoadLink, the example limits the information returned:
The output can then be displayed on a map or used as part of routable network to add a priority to roads that have been treated.
When FME writes to some databases it writes the geometry as geometry and not point, line or area.
This creates a problem for some software reading the metadata as it does not fully understand the data type.
This can be resolved by cleaning the metadata table – In PostGIS use: SELECT Populate_Geometry_Columns()
Or by pre-creating the table and in the FME writer set table handling to either ‘Use Existing’ or ‘Create If Needed’.
An SQL script can be used within FME to create the table if necessary