Field

Data Type

Required

Description

Road Number

Char(10)

Yes

Road Number

Road ID

Char(2)

No

Road ID (combination of Road Number and Road ID create a unique road)

Road/Street Name

Char(30)

Yes

Road/Street Name

Road Type

Char(2)

No

Rd, St, AV, etc.

Road Direction

Char(2)

No

N, S, E, W, NE, etc.

Road Beginning Milepost

Real

Yes

Beginning Milepost of Road

Road Ending Milepost

Real

Yes

Ending Milepost of Road

Beginning Road Description

Char(55)

No

Description of the beginning of the road

Ending Road Description

Char(55)

No

Description of the ending of the road

Comments

Char(55)

No

Comments associated with road

Beginning Road Name Milepost

Real

Yes

Milepost of the beginning of the road name

Ending Road Name Milepost

Real

Yes

Milepost of the ending of the road name