The TMC_DISTANCE_KM table hosts the location of the TMC network.
The information used to fill the table are provided by the customer, according to his TMC network that can be represented on TMC layer in Traffic Supervisor (see → TMC Locations layer).
The necessary information are:
- Ploc: the TMC location identifier, coincident with PLOC.IDNO.
- Distance_km: the progressive distance between the first location and the current ploc.
- Ord: the order number of a specific ploc (0 for the first location of the list).
An example:
|
Ploc |
Distance_km |
Ord |
|---|---|---|
|
1282 |
0 |
1 |
|
14126 |
2 |
2 |
|
1283 |
2.2 |
3 |
|
13984 |
2.6 |
4 |
|
1284 |
4 |
5 |
|
14384 |
8.8 |
6 |
If you have more than one TMC segment to be stored, the new segment always starts with this set of fields:
|
Ploc |
Distance_km |
Ord |
|---|---|---|
|
PLOC.IDNO |
0 |
1 |
This is an example with two TMC segments (second segment composed by four points):
|
Ploc |
Distance_km |
Ord |
|---|---|---|
|
1282 |
0 |
1 |
|
14126 |
2 |
2 |
|
1283 |
2.2 |
3 |
|
13984 |
2.6 |
4 |
|
1284 |
4 |
5 |
|
14384 |
8.8 |
6 |
|
1576 |
0 |
1 |
|
1577 |
9 |
2 |
|
1581 |
9.9 |
3 |
|
1608 |
13 |
4 |
The table is filled by the DB Administrator with a direct query.