Speed Database

Access

The Speed database contains:

  • A single table tblAVLSDATA, which holds all of the AVLS data points read from the AVLS files along with the TOID of the link to which they apply.
  • A sample query qryAVLSDATA. This query is provided to show how the results are calculated; it is not used by the Add-In.

There will also be a temporary table whilst the Add-In is loading data.

SQL Server

The Speed table is a spatial table.

A view V_tablename, is also created to show how the results are calculated; it is not used by the Add-In.