Skip to end of metadata
Go to start of metadata

Setup & Concept

Network_Lanes_Count table contains information about the number of lanes in each direction for all routes within the system. It is a very simple table containing only 2 columns, LOC_IDENT (the reference to each locations data in SETUP_LOC_IDENT), and NUMBER_OF_LANES, which is a count of the number of lanes in the associated direction. The one caveat about this table is that all associated records in the SETUP_LOC_IDENT table (WHERE SOURSE_TABLE='NETWORK_LANES_COUNT') must be direction specific, meaning the LANE_DIR column will not be 0 for any referenced location in this table.

NETWORK_LANES_COUNT Structure

Column Name

Pk

Null?

Data Type

Comment

LOC_IDENT


N

INTEGER

Location Reference Link

NUMBER_OF_LANES


Y

INTEGER

Number of lanes over specific section


The figure below presents shows a hypothetical scenario that can be used to understand how information about the route directions stored in Network_Lanes_Count. The figure further dissects the example presented in the NETWORK_LINE_DIRECTIONS section above. For the route H001A, we are now looking at the number of lanes on the undivided highway, that is two-way for a certain portion and one-way for a small portion. It is useful to define the LRS this way if, users will be able to record events on the lanes in each direction.


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

Record

LOC_IDENT

ROUTE_ID

LANE_DIR

LANE_ID

OFFSET_FROM

OFFSET_TO

SOURSE_TABLE

1

71298351

1145

2

0

0

10

NETWORK_LANES_COUNT

2

71298352

1145

2

0

15

25

NETWORK_LANES_COUNT

3

71298353

1145

1

0

0

25

NETWORK_LANES_COUNT


This table contains a record for all contiguous sections of road in each direction for each route. In the example above, ROUTE_ID = 1145 is the unique identifier for H001A from SETUP_NETWORK_LINES. The above LOC_IDENTS are stored as three different records in NETWORK_LINE_DIRECTIONS table. Corresponding to each of the above records entered in SETUP_LOC_IDENT, three records are entered in NETWORK_LANES_COUNT, each with the number of lanes and the corresponding LOC_IDENT.
The example shown above is in the scenario where the bi-directional highway is identified by a single route in SETUP_NETWORK_LINES (i.e. "H001A"). On the other hand, if the route in each direction is modeled as a separate route in Setup_Network_Lines (e.g., H002A and H002D), when the two routes are sharing the same road bed (e.g., spanning across mile-points 0 and 10; 15 and 25), it is required that one of these routes should be declared a subordinate route between these mile-points. The corresponding records should be entered in accordance CONCURRENT_LOCATION_SUB and CONCURRENT_LOCATION_DOM, using only dominant route to store the location records (as described in Section 8.3.2).

Window

Out of the box, the window is located at: System > LRS/GIS > Linear Network Tools > Geometry > Network Lanes.

Import

Out of the box, a standard import using csv file has been configured that matches the NETWORK_LANES_COUNT configuration. It uses a csv file with the following specification:

Column Header

Data Type

Description

ROUTE_NAME

String

Route Identifier in the LRS network

LANE_DIR

Number

1 for Ascending (Cardinal or Primary) direction.
2 for Descending (Non-cardinal or Reverse or Non-Primary) direction.

Because this dataset identifies all the validation directions in the LRS network, 0 should not be used in this dataset.

LANE_ID

Number

Use 0 for all lines. Do not include specific lane ID in this dataset.

OFFSET_FROM

Number

Start Measure of the location

OFFSET_TO

Number

End Measure of the location

NUMBER_OF_LANES

String

Total number of lanes in the specified Lane_Dir. If a location (from a Start Measure to an End Measure on a given route) does not have lanes (e.g., divided highway), do not include the location in the dataset.


After running the import, the system will have a populated NETWORK_LANES_COUNT table and the window will display the corresponding data.

  • No labels