HDM-4 Version 2
Description of the HDM-4 Road Network Export File Format
This document describes the format of the Road Network export file. Each export file is stored as a Microsoft Access (.mdb). As a result, this
document assumes that the reader has a basic understanding of the mdb file format, and Microsoft Access data types. As the export files are
stored in Microsoft Access format, they can be created/edited/viewed using a wide range of utilities including database tools such as Microsoft
Access, and spreadsheets such as Microsoft Excel.
A Road Network export file consists of a number of tables, some of which are linked using a reference field ID. The main table is the SECTIONS
table which has one record for each Section in the road network. The TRAFFIC table defines the traffic volume for each vehicle in the Vehicle Fleet
associated with the Road Network. The ROADNET table defines some attributes for the Road Network. The FILETYPE table is used by HDM-4
import wizard to determine the type of data the file contains. The table below lists all the tables and fields in the export file. The fields are listed in
the order in which they appear in the file for each table. The following details are given for each field:
Table Name the name of the database table
Field Name the name of the table field
Type the Microsoft Access field type.
Size the number of characters used in the export file to store field data (including decimal places for floats).
Surface Class denotes which surface class(es) the field applies to (see below)
Comment - an explanatory description of the HDM-4 data item represented by the field.
New in Version 2 indicates if the data was newly introduced in HDM-4 Version 2.
Please note that not all fields are required for every Section. Some fields are specific to only one surface type. Others are specific to 2 or all
surface classes. The following symbols are used in the table to represent which surface class(es) each field applies to:
B
C
U
All
denotes that the field applies to bituminous Sections
denotes that the field applies to concrete Sections
denotes that the field applies to unsealed Sections
denotes that the field applies for all surface classes
In those cases where a particular field does not apply to the current section (because of surface class), the field is set to 0. Please note that certain
numeric fields (e.g. PAVE_TYPE ) are used to store enumerated values. Where this is the case, a reference is given in the Comments column to
the section at the end of this document which lists the corresponding enumerated values. For a fuller description of all the parameters stored in the
various fields, please refer to the relevant parts of Volume 4.
If you have any problems interpreting the file format, try exporting a small Road Network. The resultant file can be used as a template and viewed
using one of the tools listed above.
Page 1
HDM-4 Version 2
The abbreviation TBS is sometimes used in the following table. The meaning of this abbreviation is To Be Specified.
Page 2
HDM-4 Version 2
Table
Name
FILETYPE
Field
#
1
Field Name
Type
Type
Text
Table
Name
Field
#
Field Name
ROADNET
NAME
ROADNET
DESCRIPTION
ROADNET
ROADNET
ROADNET
Type
Size
20
Surface
Class
n/a
Comments
Used as an identifier for the type of data contained in the file to HDM-4 (SECT_ID)
Size
Surface
Class
Text
100
n/a
The name of the Road Network, as it appears in the HDM-4 workspace
Text
100
n/a
CALIB_SET
Text
100
n/a
VFLEET
Text
100
n/a
A brief description of the road network provided by the user
The name of the Calibration Set associated with the Road Network, as it appears in the
HDM-4 Workspace
The name of the Vehicle Fleet associated with the Road Network, as it appears in the
HDM-4 Workspace
NOOFMT
Byte
n/a
Number of Motorsised Vehicles in the associated Vehicle Fleet
ROADNET
NOOFNMT
Byte
n/a
ROADNET
CURRENCY
Text
100
n/a
Number of Non-Motorsised Vehicles in the associated Vehicle Fleet
The name of the Currency associated with the Road Network, as it appears in the list of
Currencies in HDM-4 Workspace. The Asset value of the Road Network is defined in
this currency.
Comments
ROADNET
TERMROUGHB
Single
ROADNET
TERMROUGHC
Single
Default terminal roughness for concrete pavements
ROADNET
10
TERMROUGHU
Single
Default terminal roughness for unsealed pavements
Table
Name
Field
#
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Field Name
SECT_ID
SECT_NAME
LINK_ID
LINK_NAME
SPEED_FLOW
TRAF_FLOW
ACC_CLASS
ROAD_CLASS
CLIM_ZONE
SURF_CLASS
LENGTH
CWAY_WIDTH
SHLD_WIDTH
MT_AADT
Type
Text
Text
Text
Text
Text
Text
Text
Text
Text
Byte
Single
Single
Single
Single
Size
Surface
Class
20
100
20
100
255
100
100
30
100
1
4
4
4
4
All
All
All
All
All
All
All
All
All
All
All
All
All
All
New in
Version 2
New in
Version 2
Default terminal roughness for bituminous pavements
Comments
New in
Version 2
Identification code for this road section (e.g. N1-026)
Description of this road section (e.g. Km 123.4 - 145.6)
Identification code for link that section belongs to (e.g. N1)
Description of link that section belongs to (e.g. Dhaka - Chittagong)
Name of Speed Flow Type selected for this section
Name of Traffic Flow Pattern selected for this section
Name of Accident Class selected for this section
Name of Road Class selected for this section
Name of Climate Zone selected for this section
Surface class (bituminous, unsealed or concrete) (see note below)
Length of section in Km (L)
Width of carriageway in metres (CW)
Average width of shoulders in metres (SW, and used in W)
Annual Average Daily Traffic for motorised transport (veh/day in both directions)
(AADT)
Page 3
HDM-4 Version 2
SECTIONS
15
NM_AADT
Single
All
Annual Average Daily Traffic for non-motorised transport (veh/day in both directions)
(AADT)
SECTIONS
SECTIONS
16
17
AADT_YEAR
DIRECTION
Integer
Byte
2
1
All
All
Year in which above AADTs were recorded
Direction of traffic on section (one-way downhill, one-way uphill, two-way) (see note
below)
SECTIONS
SECTIONS
18
19
RF
NUM_RFS
Single
Single
4
4
All
All
The average absolute rise plus fall of the road in m/km (RF)
Average number of road rises and falls per kilometre (minimum value = 0.1) (NUM_RF)
SECTIONS
SECTIONS
SECTIONS
20
21
22
SUPERELEV
CURVATURE
SIGM_ADRAL
Single
Single
Single
4
4
4
All
All
All
Superelevation of the road (in %) (e)
Average horizontal curvature of the road (deg/km) (C)
Natural acceleration noise due to driver behaviour and road alignment, in m/s2 (sigma
adral)
SECTIONS
SECTIONS
23
24
SPEED_LIM
ENFORCEMNT
Single
Single
4
4
All
All
Posted speed limit on section in km/hr (PLIMIT)
Speed limit enforcement factor. Ratio of mean speed to posted speed limit. Typical
value 1.1 - users readily exceed limit (ENFAC)
SECTIONS
25
XNMT
Single
All
Speed reduction of motorised transport due to non-motorised transport (1=no
reduction, 0.6=significant reduction ) (XNMT)
SECTIONS
26
XMT
Single
All
Speed reduction of non-motorised transport due to motorised traffic and roadside
activities (default = 1.0) (XMT)
SECTIONS
27
XFRI
Single
All
Speed reduction of motorised transport due to road side activities ( 1=no side friction,
0.6=significant friction ) (XFRI)
SECTIONS
SECTIONS
SECTIONS
28
29
30
HSNEW
HSOLD
HBASE
Single
Single
Single
4
4
4
B
B
B
Thickness of most recent surfacing, in mm (HSNEW)
Total thickness of underlying previous surface layers, in mm (HSOLD)
Thickness of base layer in original pavement in mm (for stabilised base only) (HBASE)
SECTIONS
SECTIONS
31
32
RES_MODULU
REL_COMPCT
Single
Single
4
4
B
B
Resilient modulus of soil cement in GPa (for stabilised base only) (CMOD)
Relative compaction of the base, subbase and subgrade layers in % (COMP construction quality indicator)
SECTIONS
33
SNP_DERIVE
Byte
SNP derivation method (specified SNP, layer coefficients, benkelman beam, FWD)
(see note below)
SECTIONS
34
SN
Single
Structural number for pavement (used to calculate SNP depending on derivation
method see above)
SECTIONS
35
CBR
Single
Subgrade California Bearing Ratio (CBR) (used to calculate SNP depending on
derivation method - see above)
SECTIONS
SECTIONS
SECTIONS
36
37
38
SNP_DRY
D0
BENKEL_DEF
Yes/No
Single
Single
1
4
4
B
B
B
TRUE if specified SNP is for dry season, FALSE if specified SNP is for wet season
Deflection at the centre of the bowl (at 700kPa) (used to calculate SNP) (D0)
Benkelman beam rebound deflection under 80 kN axle load, 520 kPa tyre pressure and
30C average asphalt temperature for season s (mm) (DEFs)
SECTIONS
SECTIONS
SECTIONS
39
40
41
SURF_STREN
BASE_STREN
SUBB_STREN
Single
Single
Single
4
4
4
B
B
B
Strength coefficient of the new surface layer (used to calculate SNP) (ai)
Strength coefficient of the base layer (used to calculate SNP) (ai)
Strength coefficient of the subbase layer (used to calculate SNP) (ai)
Page 4
HDM-4 Version 2
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
HSUBBASE
SURF_THICK
SLAB_LENTH
BASE_THICK
BASE_MODUL
CNSTR_YEAR
SUBG_MATRL
COMPMETHOD
COND_YEAR
ROUGHNESS
CRACKS_ACA
CRACKS_ACW
CRACKS_ACT
RAVEL_AREA
PHOLE_NUM
EDGEBREAK
RUT_DEPTH
RUTDEPTH_SD
TEXT_DEPTH
SKIDRESIST
DRAIN_COND
Single
Single
Single
Single
Single
Integer
Byte
Byte
Integer
Single
Single
Single
Single
Single
Single
Single
Single
Single
Single
Single
Byte
4
4
4
4
4
2
1
1
2
4
4
4
4
4
4
4
4
4
4
4
1
B
C
C
C
C
C
U
U
B
All
B
B
B
B
B
B
B
TBS
B
B
B
Height of subbase in mm (used to calculate SNP)
Surface thickness
Slab length
Base thickness
Base modulus
Construction year
Subgrade material for unsealed pavement (see note below)
Method of compaction (mechanical or non-mechanical) (see note below)
Year for which following condition measures apply
Roughness in IRI m/km (RI)
Area of All Structural Cracking as a % of total carriageway area (ACA)
Area of Wide Structural Cracking as a % of total carriageway area (ACW)
Area of Thermal Cracking as a % of total carriageway area (ACT)
Ravelling area as % of total carriageway area (ARV)
Number of pothole units (0.1m) per Km (no./km) (NPT)
Broken edge in m2/km (VEB)
Mean rut depth in mm (RDM)
Rut Depth Standard Deviation
Texture depth in mm (TD)
Skid resistance (measured at 50 km/h) (SFC50)
Drain condition (used to determine values for drainage factors DFmin, DFmax) (see
note below)
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
63
64
65
66
67
68
69
FAULTING
SPALL_JNTS
CRACKSLABS
DETERCRACK
FAILURESKM
GRAV_THICK
LAST_CONST
Single
Single
Single
Single
Single
Single
Integer
4
4
4
4
4
4
2
C
C
C
C
C
U
B
Concrete Faulting
Concrete Spalled Joints
Concrete Cracked Slabs
Concrete Deteriorated cracks
Concrete Failures per km
Thickness of gravel in mm (THG)
Year of latest reconstruction / new construction activity (used in calculation of AGE
indicators)
SECTIONS
SECTIONS
SECTIONS
SECTIONS
70
71
72
73
LAST_SURF
LAST_PRVNT
LAST_REHAB
PREV_ACA
Integer
Integer
Integer
Single
2
2
2
4
B
B
B
B
Last surfacing year (used in calculation of AGE indicators)
Year of last preventive treatment (used in calculation of AGE indicators)
Year of last rehabilitation (used in calculation of AGE indicators)
Area of all structural cracking before latest reseal or overlay % of total carriageway
area (PCRA)
SECTIONS
74
PREV_ACW
Single
Area of wide cracking before latest reseal or overlay % of total carriageway area
(PCRW)
SECTIONS
75
PREV_NCT
Single
Number of transverse thermal cracks before the last overlay / resurfacing (no/km)
(PNCT)
SECTIONS
76
LASTGRAVEL
Integer
Year of last regravelling (used in calculating GAGE)
Page 5
HDM-4 Version 2
SECTIONS
77
DRAIN_TYPE
Byte
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
78
79
80
81
82
83
84
85
86
87
88
89
90
ALTITUDE
SHOULDTYPE
WIDN_WIDTH
EDGEDRAINS
NMT_SEPAR
NMTLANES
ELANES
CALIB_ITEM
REPCOST
CONDBASED
INIROUGH
TERROUGH
RDFOSBGR_PRRECO
Single
Byte
Single
Yes/No
Yes/No
Byte
Single
Text
Double
Yes/No
Single
Single
Single
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
91
92
93
94
95
RDPVLA_PRRECO
FTCYCLE_PRRECO
BRDGSTR_PRRECO
TRFSGN_PRRECO
RDFOSBGR_RESVAL
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
SECTIONS
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
RDPVLA_RESVAL
FTCYCLE_RESVAL
BRDGSTR_RESVAL
TRFSGN_RESVAL
RDFOSBGR_USELFE
RDPVLA_USELFE
FTCYCLE_USELFE
BRDGSTR_USELFE
TRFSGN_USELFE
RDFOSBGR_AGE
RDPVLA_AGE
FTCYCLE_AGE
BRDGSTR_AGE
TRFSGN_AGE
COMPAGEYEAR
USFLFEUNIT
ID
Type of drain (used to determine values for drainage factors DFmin & DFmax) (see
note below)
4
1
4
1
1
1
4
255
8
1
4
4
4
All
C
C
C
All
All
BC
TBS
TBS
TBS
TBS
TBS
TBS
Elevation of the road section above the mean sea level in m (ALT)
TBS
TBS
TBS
TRUE = separate NMT lanes, FALSE = no separate NMT lanes
Number of non-motorised lanes (NMTLN)
Effective number of lanes (ELANES)
Name of the Calibration Item for the section
Asset Valuation - TBS
Asset Valuation - TBS
Asset Valuation - TBS
Asset Valuation - TBS
Asset Valuation - TBS
Single
Single
Single
Single
Single
4
4
4
4
4
TBS
TBS
TBS
TBS
TBS
Asset Valuation - TBS
Asset Valuation - TBS
Asset Valuation - TBS
Asset Valuation - TBS
Asset Valuation - TBS
Single
Single
Single
Single
Single
Single
Single
Single
Single
Single
Single
Single
Single
Single
Integer
Byte
Long
Integer
4
4
4
4
4
4
4
4
4
4
4
4
4
4
2
1
4
TBS
TBS
TBS
TBS
TBS
TBS
TBS
TBS
TBS
TBS
TBS
TBS
TBS
TBS
TBS
TBS
TBS
Asset Valuation - TBS
Asset Valuation - TBS
Asset Valuation - TBS
Asset Valuation - TBS
Asset Valuation - TBS
Asset Valuation - TBS
Asset Valuation - TBS
Asset Valuation - TBS
Asset Valuation - TBS
Asset Valuation - TBS
Asset Valuation - TBS
Asset Valuation - TBS
Asset Valuation - TBS
Asset Valuation - TBS
Asset Valuation - TBS
Asset Valuation - TBS
Unique identifier of the section for use internally to link to TRAFFIC table
Page 6
HDM-4 Version 2
Table
Name
Field
#
Field Name
Type
Size
Surface
Class
Comments
TRAFFIC
SEC_ID
Long
Integer
All
TRAFFIC
VEH_ID
Integer
All
Identifies the vehicle for which the traffic is defined for
TRAFFIC
VEH_CAT
Integer
All
Vehicle Category (MOTORISED/NON-MOTORISED)
TRAFFIC
YEAR_IDX
Integer
All
Not currently used (should be set to 0)
TRAFFIC
YEAR
Integer
All
Actual year the traffic is defined for
TRAFFIC
AADT
Single
All
AADT of the vehicle for the section in the given year
New in
Version 2
Identifies the section for which the traffic is defined for
Page 7
HDM-4 Version 2
Surface Class
0 = Bituminous
1 = Unsealed
2 = Concrete
Bituminous Pavement Type
0 = AMBG (Asphalt Mix on Granular Base)
1 = AMAB (Asphalt Mix on Asphalt Base)
2 = AMAP (Asphalt Mix on Asphalt Pavement)
3 = AMSB (Asphalt Mix on Stabilised Base)
4 = STBG (Surface Treatment on Granular Base)
5 = STAB (Surface Treatment on Asphalt Base)
6 = STAP (Surface Treatment on Asphalt Pavement)
7 = STSB (Surface Treatment on Stabilised Base)
Unsealed Pavement Type
0 = Gravel
1 = Earth
2 = Sand
Concrete Pavement Type
0 = JPCP (Jointed Plain Concrete Pavement) + Dowel
1 = JPCP (Jointed Plain Concrete Pavement) no dowels
2 = JRCP (Jointed Reinforced Concrete Pavement)
3 = CRCP (Continuous Reinforced Concrete Pavement)
Direction
0 = One-way downhill
1 = One-way uphill
2 = Two-way
Bituminous Surface Material
0 = AC (Asphalt Concrete)
1 = HRA (Hot Rolled Asphalt)
2 = PMA (Polymer Modified Asphalt)
3 = RAC (Rubberised Asphalt Concrete)
4 = CM (Cold Mix / Soft Bituminous Mix)
5 = PA (Porous Asphalt)
6 = SMA (Stone Mastic)
7 = SBSD (Single Bituminous Surface Dressing)
8 = DBSD (Double Bituminous Surface Dressing)
9 = CAPE (Cape Seal)
10 = SL (Slurry Seal)
11 = PM (Penetration Macadam)
Unsealed Surface Material
0 = lateritic gravel
1 = quartzitic gravel
2 = volcanic gravels angular
3 = coral gravels angular
SNP Derivation Method
0 = specified SNP
1 = layer coefficients
2 = benkelman beam
3 = FWD
Concrete Subgrade Type
0 = fine
1 = coarse
Unsealed Subgrade Material
0 = well-graded gravel-sands with small clay content (GC)
1 = gravel-sand mixtures with excess fines (GF)
2 = sands with excess fines (SF)
3 = clayey silts, inorganic (CL)
4 = clays (inorganic) of medium plasticity (CI)
5 = clays (inorganic) of high plasticity (CH)
Compaction Method
0 = mechanical
1 = non-mechanical
Drain Condition
0 = Excellent
1 = Good
2 = Fair
3 = Poor
4 = Very poor
Time Lapse to Patching
0 = < 2 weeks
1 = 1 month
2 = 2 months
3 = 3 months
4 = 4 months
5 = 6 months
6 = 12 months
Drain Type
0 = Fully Lined and Linked
1 = Surface lined
2 = V-shaped hard
3 = V-shaped soft
4 = Shallow hard
5 = Shallow soft
6 = No invert overgrown
7 = No drainage effects
Concrete Shoulder Type
0 = Non-concrete
1 = Mono-concrete
2 = Tied-concrete
NMT Lane Surface Type
0 = Bituminous
1 = Concrete
Page 8
HDM-4 Version 2
2 = Block
3 = Gravel
4 = Earth
5 = Sand
Concrete Base Type
0 = Granular
1 = Asphalt treated
2 = Cement treated
2 = Preformed
3 = None
Concrete Reinforced Steel Placement
0 = chairs
1 = tubes
Vehicle Category
0 = motorised (MT)
1 = non-motorised (NM)
2 = unassigned motorised AADT
3 = unassigned non-motorised AADT
Concrete Joint Seal Type
0 = Silicon
1 = Asphalt
Page 9
