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
