To view this window, follow the steps below:

  1. Select System in the top banner menu
  2. Select LRS/GIS
  3. Select Linear Network Tools 
  4. Select Geometry
  5. Select Routes List

The SETUP_NETWORK_LINES table (accessed using the path above) lists each unique route within the system along with its initial and final measure value. This is commonly known as the "network" in the LRS. The primary key of the table is a unique integer linked to the sequence S_SETUP_NETWORK_LINES. The name of each route contained in the ROUTE_NAME field must also be unique. Table structure is shown below.

Column Name

Pk

Null?

Data Type

Comment

NETWORK_ID


N

INTEGER

Allows multiple networks to be defined (not used – should be 1 throughout the system)

ROUTE_ID

Y

N

INTEGER

Unique identifier for each route

ROUTE_NAME


N

VARCHAR2 (100 Char)

Unique name of the Route

OFFSET_FROM


Y

NUMBER (22,3)

Begin measure of the route

OFFSET_TO


Y

NUMBER (22,3)

End measure of the route

IS_INACTIVE


Y

NUMBER (1)

Equals 1 if the route is no longer active in the network (record in SETUP_NETWORK_LINES are never deleted)

TEMPO_EFF_BIRTH_DATE


Y

DATE

Because record in SETUP_NETWORK_LINES are never deleted, this field the start date of the route.

TEMPO_EFF_DEATH_DATE


Y

DATE

Because record in SETUP_NETWORK_LINES are never deleted, this field the start date of the route, this field records the end date of the route.

IS_INACTIVE


Y

NUMBER (1)

Equals 1 if the route is no longer active in the network

GEOM


Y

Geometry

Geometry (geospatial representation) of the route