Skip to end of metadata
Go to start of metadata

Setup & Concept

Network_Line_Lanes table is used to spell out each travel directions and lanes on any given route at any particular point of time. It is also utilized when running finest partition functions in the system. The table's data is an even further dissection of Network_Lanes_Count data in the previous section. The table only has one column Loc_Ident, which references to SETUP_LOC_IDENT table, where actual location information is stored.
The data can also be fully derived from the Nnetwork_Lanes_Count table (see next section), but its data must be stored separately.

NETWORK_LINE_LANES Structure

Column Name

Pk

Null?

Data Type

Comment

LOC_IDENT


N

INTEGER

A location reference for a valid contiguous single lane, in a travel direction, of travel section within each route.


The figure below is the same example from Network_Lanes_Count, which can be used to understand how information about the route lanes stored in Network_Line_Lanes. For the route H001A, we are now looking at the number of lanes.


In order to capture the network setup shown in figure above, there will be nine records added to the SETUP_LOC_IDENT table, corresponding to the source table NETWORKK_LINE_LANES.

Record

LOC_IDENT

ROUTE_ID

LANE_DIR

LANE_ID

OFFSET_FROM

OFFSET_TO

SOURSE_TABLE

1

71298361

1145

2

1

0

10

NETWORK_LINE_LANES

2

71298362

1145

2

2

0

10

NETWORK_LINE_LANES

3

71298363

1145

2

3

0

10

NETWORK_LINE_LANES

4

71298364

1145

2

1

15

25

NETWORK_LINE_LANES

5

71298365

1145

2

2

15

25

NETWORK_LINE_LANES

6

71298366

1145

2

3

15

25

NETWORK_LINE_LANES

7

71298367

1145

1

3

0

25

NETWORK_LINE_LANES

8

71298368

1145

1

2

0

25

NETWORK_LINE_LANES

9

71298369

1145

1

1

0

25

NETWORK_LINE_LANES


Where ROUTE_ID = 1145 is the unique identifier for H001A from SETUP_NETWORK_LINES. The above LOC_IDENTS are stored as 9 different record in NETWORK_Line_lanes table.

Window

Out of the box, there is no front end window displaying the data.

Import

Data in Network_Line_Lanes can be fully derived from Network_Lanes_Count. The system job "Pavement Analyst: Update Network_Line_Directions and Network_Line_Lanes" uses the data from Network_Lanes_Count to populate Update Network_Line_Directions and Network_Line_Lanes. After Network_Lanes_Count is populated, run the system job and verify the data is displayed in the window

  • No labels