To view this window, follow the steps below:
- Select System in the top banner menu
- Select LRS/GIS
- Select Linear Network Tools
- Select Geometry
- 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 |
