Supporting Local Roads LRS with Route Reference Table

  • Home
  • Blog
  • Supporting Local Roads LRS with Route Reference Table

The ARNOLD requirements pose many challenges, one of which is how to identify or reference local roads where mileposts do not exist, or for which driven mileage is not recorded.  As a result, the popular Milepoint or Reference Post LRMs are no longer applicable.

Usher in the most flexible LRM – Reference Point w/ Offset.  This LRM treats any features or landmarks such as cross streets, rivers, railways and bridges – even non-physical features like state/county boundaries – as reference points.

There are important advantages to using the Reference Point LRM.   First, the “plain-English” location description can be easily understood by humans.  Second, as long as stable intersecting features or landmarks are chosen as reference points, route changes such as extensions or realignments will not require cascading measure updates for events on the routes.

In fact, with the Reference Point LRM, route measures are no longer carried in asset or event tables in the database.  But what if we want to map event/assets via dynamic segmentation?  This is where the Route Reference table (also known as “Intersection” table or “Extended Intersection” table) comes into play.  It serves as a look-up table for measures, as it contains measures identifying the location of intersecting features and landmarks along routes.

Using a fictitious section of route Oak Rd illustrated below, the corresponding Route Reference table is shown in Table 1.

Supporting Diagrams (1)

Table1. Sample Route Reference table for Route Oak Rd
Oak Rd0Node Rail RouteBegin1
Oak Rd0.5RouteMaple LnLeft500
Oak Rd0.5RouteA StCross500
Oak Rd1.0RouteB StRight1000
Oak Rd1.1NodeEnd1100
Oak Rd1.6NodeBegin1600
Oak Rd1.8RailRail TracksCross1800
Oak Rd2.2RouteD StCross2200
Oak Rd3.0BoundaryCo. BoundaryCross3000

A basic Route Reference table should at least include route break points, intersecting routes/features and their intersection configurations.  Additional attributes such as address values at intersections, and the geometric angles at which the intersecting features cross the route, can also be desirable.

A Route Reference table is derived from GIS layers that are related, such as road centerline, route and other feature layers such as rail networks, streams and rivers, and various boundaries, etc.  Because of its dependencies on other layers, each time there is a change in the source or contributing layers, the Route Reference table will need to be regenerated.

LinearBench offers an off-the-shelf, Route Reference table generation solution that is feature-rich and efficient.

Bo Guo, PhD, PE

At Gistic Research, Bo leads a team in LinearBench product design and development. He is a passionate LRS researcher and practitioner who believes that LRS challenges can be solved through technology design and integration.

Leave a Reply