Overview

AVLS in a vehicle captures data like location, speed or distance travelled. This data can be stored and subsequently used in various analyses.

Each individual data point record is associated with the relevant road segment; AVLS then attributes the average speed for the road segment to the topological network.

With AVLS, route finding operations (e.g. with the SIS Routing Tools) can be performed with speeds based on highly granular real life data rather than on assumptive speeds based on a road classification.

Using Databases

The add-in creates its own ‘Speed database’; this can be either an Access database or a spatial table in SQL Server.

There are two commands:

1. Load – Read AVLS data points from either text files, e.g. csv, or SQL Server determines to which road link each should be applied and stores in a Speed database records with x, y, speed and road link id.
2. Apply – Gets average speed per road link from a Speed database and writes them to an attribute on the link items in a topological network.

Both commands start by prompting for the location of a Speed database.

Load can be used iteratively to build a speed database.

Apply is then used to apply the speeds to a road network.

---