| STREET1 |
CHAR (*) |
No |
Official street name |
| STREET2 |
CHAR (*) |
No |
Alternate street name or official street name in local
language. |
| STREET3^ |
CHAR (*) |
No |
Alternate street name 2 or official street name in second local
language. |
| STREET4^ |
CHAR (*) |
No |
Alternate street name 3 or official street name in second local
language. |
| ATTRIBUTE |
SMALL INTEGER |
No |
Routefinder road class value |
| AVOID |
SMALL INTEGER |
No |
Sum of Avoid1-Avoid8 values. |
| ROAD_CLASS |
CHAR (2) |
No |
Road classification code (refer to Road_Class Specification table below) |
| AREA_TYPE |
SMALL INTEGER |
No |
Code representing the Area_Type (refer to Area_Type classification table below) |
| FEATUREID |
CHAR (36) |
Yes |
Unique feature identifier |
| SPEED |
INTEGER |
No |
Segment speed limit |
| SPEED_AMPEAK |
DECIMAL (8,2) |
No |
Average segment speed during peak AM time. |
| SPEED_PMPEAK |
DECIMAL (8,2) |
No |
Average segment speed during peak PM time. |
| SPEED_INTERPEAK |
DECIMAL (8,2) |
No |
Speed between end of AM Peak and beginning of PM Peak |
| SPEED_NIGHT |
DECIMAL (8,2) |
No |
Average speed for night |
| SPEED_SEVENDAY |
DECIMAL (8,2) |
No |
Average speed over complete week |
| START_Z |
SMALL INTEGER |
No |
Value indicating the z-level at the start of the segment |
| END_Z |
SMALL INTEGER |
No |
Value indicating the z-level at the end of the segment |
| MAX_HEIGHT^^ |
SMALL INTEGER |
No |
Maximum vehicle height allowed along the segment |
| MAX_WIDTH^^ |
SMALL INTEGER |
No |
Maximum vehicle width allowed along the segment |
| MAX_WEIGHT^^ |
SMALL INTEGER |
No |
Maximum vehicle weight allowed along the segment |
| AVOID1 |
SMALL INTEGER |
No |
1-Pedestrian values only |
| AVOID2 |
SMALL INTEGER |
No |
2-Vehicle values only |
| AVOID3 |
SMALL INTEGER |
No |
4-Toll Roads values only |
| AVOID4 |
SMALL INTEGER |
No |
8-Motorways values only |
| AVOID5 |
SMALL INTEGER |
No |
16-Ferries values only |
| AVOID6 |
SMALL INTEGER |
No |
32-Tunnel values only |
| AVOID7 |
SMALL INTEGER |
No |
64-Four Wheel Drive (4WD) values only |
| AVOID8 |
SMALL INTEGER |
No |
128-Bridges values only |