INVENTORY FILE:
Download
this table (.dbf format, in a DOS/Windows self-extracting executable)
The related file MHDROADS_ARC_INVENTORY (MRD.INV in the Quad library's 'database' directory) file stores
information on the road inventory. The items are:
1 CITY_NUM:
City or Town Number (Abington = 1 ... Yarmouth = 351)
2 RIN: Road
Inventory Number. Uniquely identifies each road within a given town
3 STREET_NAME:
Street name with suffix (added from MRD.STREETS)
4 FRM-ST-NUM:
From Road Inventory Number (RIN)
xxxx = RIN
Xxxx = Bordering town
line, where X=1st letter of bordering town name and xxx=CITY_NUM
0000 = Dead end
00CT = CT state line
00NH = NH state line
00NY = NY state line
00RI = RI state line
00VT = VT state line
8888 = Private property
9999 = Cul-de-sac
Note: From and
To Road Inventory Number are for the entire road (RIN), not for the road
segment (SERIAL_NUMBER).
5 FRM-ST-NAME:
From Street name (added from MRD.STREETS)
Refers to either a
road, a town or state line, a dead end, private property, or a cul-de-sac.
6 TO-ST-NUM:
To Road Inventory Number (RIN)
See Item # 3 (FRM-ST-NUM)
for description
7 TO-ST-NAME:
To Street name (added from MRD.STREETS)
See Item #62 (FRM-ST-NAME)
for description.
8 ADMIN_SYS:
Administrative System
1 = Massachusetts
Highway Department
2 = City or town accepted
road
3 = Metropolitan District
Commission
4 = Massachusetts
Turnpike Authority
5 = Massachusetts
Port Authority
6 = State Park or
Forest
7 = State institutional
8 = Federal Park or
Forest
9 = County Institutional
0 = Unaccepted by
city or town
B = State college
or university
C = US Department
of Defense
D = US Army Corps
of Engineers
E = Federal Institutional
F = Other Federal
G = Federal Bureau
of Indian Affairs
H = Private
9 FEDAID_SYS:
National Highway System (NHS) Status
0 = Not on NHS
1 = NHS - Interstate
2 = NHS - Strategic
Defense Highway System (STRAHNET)
3 = NHS - STRAHNET
Connector
4 = NHS - Other
5 = NHS - Other -
One-way pair
6 = NHS - Other truck
route exclusion
7 = NHS connection
to major intermodal terminal (proposed)
10 FEDAID-RT-NUM:
Federal-Aid Route Number
11 FEDAID-UR-DESIG:
Federal-Aid Urban/Rural Designation
1 = Urban city
2 = Urban town
5 = Rural town
Note: A town may
be partially urban and partially rural.
12 FUNC-CLASS:
Functional Classification
0 = Local
1 = Interstate
2 = Rural principal
arterial and Urban extension
3 = Rural minor arterial
and Urban extensions
4 = Other Urban principal
arterial
5 = Urban minor arterial
or Rural major collector
6 = Urban collector
or Rural minor collector
Note: Use
urban/rural designation to interpret functional classification.
13 AUTO-RT-NUMBER:
Route Number
Interstate, US Highway,
or State Numbered Highway route number
Note: If
multiple routes exist on a section, the lowest number on the highest system
is recorded (Interstate>US>State);
Other routes under
hierarchy are listed in Item # 12 (ALT-RT-NUMBER).
14 ALT-RT-NUMBER:
Alternate Route Number(s)
All other routes under
hierarchy of Item # 11
Note: Field
begins and ends with a “+”, and routes are separated by “+”s.
15 FAC_TYPE:
Facility Type
0 = Mainline roadway
1 = Simple Ramp *
2 = Uni-directional
compound ramp *
3 = Simple Ramp -
carries NB or EB route
4 = Simple Ramp -
carries SB or WB route
5 = Bi-directional
compound ramp *
6 = Terminal Ramp
- end of NB or EB route *
7 = Terminal Ramp
- end of SB or WB route *
8 = Rotary
9 = Collector - Distributor
*
Note: This field
is currently under development. * = not reported in HPMS file.
16 D-SH-WID:
Left
Side Right Shoulder Width for DIVIDED Roadway Only
Note: Width in
feet
17 D-SH-TYP:
Left Side Right Shoulder Type for DIVIDED Roadway Only
S = Stable - Unruttable
compacted subgrade
U = Unstable shoulder
H = Hardened bituminous
mix or penetration
Note: Null = no
left side right shoulder OR not a divided roadway OR no data.
18 DIV-L-SU-WID:
Left
Side Surface Width of Travel Lanes for DIVIDED Roadway Only
0 = Not a divided
roadway OR no data.
Note: Width of
traveled way in feet, excluding shoulders/auxiliary lanes.
19 MED-WID:
Median Width for DIVIDED Roadway Only
0 = Not a divided
roadway OR No data
Note: Width
in feet; coded as 99, if over 100 feet.
20 DIV-L-NUM-TR-LA:
Left
Side Number of Travel Lanes for DIVIDED Roadway Only
0 = Not a divided
roadway OR No data
21 CURBS: Curbs
0 = None
1 = Left side only
2 = Right side only
3 = Both sides
4 = Along median only
5 = All curbs (divided
highway)
22 L-SW-WID:
Left Sidewalk Width
0 = No left sidewalk
OR No data
Note: Width in
feet.
23 R-SW-WID:
Right Sidewalk Width
0 = No right sidewalk
OR No data
Note: Width in
feet.
24 STREET-OPERATION:
Street Operation
0 = No data
1 = One-way traffic
2 = Two-way traffic
25 L-SH-WID:
Median
Shoulders Width for DIVIDED Roadway OR Left Shoulder Width for UNDIVIDED
Roadway
Note: Width in
feet; for DIVIDED roadways, median shoulders are assumed to have the same
width.
26 L-SH-TYP: Median
Shoulders Type for DIVIDED Roadway OR Left Shoulder Type for UNDIVIDED
Roadway
See item # 15 (D-SH-TYP)
for description
Note: For DIVIDED
roadways, median shoulders are assumed to have the same type.
27 SUR-WID: Right
Side Surface Width for DIVIDED Roadway OR Surface Width for Entire UNDIVIDED
Roadway
0 = No data
Note: Coded
as 99, if over 100 feet; Measurement of travelled way, excluding shoulders/auxiliary
lanes.
28 SUR-TYP: Surface
Type of Either DIVIDED or UNDIVIDED Roadway
0 = No data
1 = Unimproved, graded
earth, or soil surface road
2 = Gravel or stone
road
3 = Brick road
4 = Block road
5 = Surface-treated
road
6 = Bituminous concrete
road
7 = Portland cement
concrete road
8 = Composite road;
flexible over rigid
9 = Composite road;
rigid over flexible or rigid over rigid (‘white topping’)
Note: For
both DIVIDED and UNDIVIDED roadways.
29 R-SH-WID:
Right
Side Right Shoulder Width for DIVIDED Roadway OR Right Shoulder Width for
UNDIVIDED Roadway
Note: Width in
feet
30 R-SH-TYP:
Right
Side Right Shoulder Type for DIVIDED Roadway OR Right Shoulder Type for
UNDIVIDED Roadway
See Item # 15 (D-SH-TYP)
for description
31 UNDIV-RRWY-#TRLA:
Right Side Number of Travel Lanes for DIVIDED Roadway OR Total Number of
Travel Lanes for UNDIVIDED Roadway
0 = No data
32 ACC_CON:
Access Control
0 = No control
1 = Full control
2 = Partial control
33 TERRAIN:
Terrain
0 = No data
1 = Level
2 = Rolling
3 = Mountainous
34 ROW-WID: Right
of Way Width
0 = No data
Note: Width in
feet
35 SPEED_LIMIT:
Speed Limit
0 = No data
Note: Speed limit
in miles per hour
36 ODOM-READ:
Cumulative Odometer Reading
Note: In hundredths
of a mile (xx.xx); This value does not represent section length. See Item
#59 (MILES) for section length.
37 URB-AREA:
Urbanized Area
URBANIZED AREAS
A = Boston
H = Pittsfield
B = Brockton
I = Providence-Pawtucket
C = Fall River
J = Springfield
D = Fitchburg-Leominster K = Worcester
E = Lawrence-Haverhill L =
Taunton
F = Lowell
M = Hyannis
G = New Bedford
SMALL URBAN AREAS
1 = Athol
R = Plymouth
5 = Spencer
S = Greenfield
6 = Ware
U = Southbridge
O = North Adams
V = Clinton-Lancaster
Q = Gardner-Templeton
Note: If NULL,
roadway section is in RURAL area.
38 HPMS-CODE:
HPMS (Highway Performance Monitoring System) Code
0 = Not an HPMS section
nor on a road that has an HPMS section
1 = Not an HPMS section
but is on a road that has an HPMS section
2 = An HPMS section
39 AUTO-RT-SIGN:
Auto Route Signing
0 = Roadway is not
signed as a numbered auto route
1 = Roadway is signed
as an Interstate route
2 = Roadway is signed
as a US Highway route
3 = Roadway is signed
as a State route
Note: System
hierarchy in Item # 11 (AUTO-RT-NUMBER) is used.
40 SPECIAL_FUN:
Special Systems
0 = Not an addition
to the Interstate system
1 = Addition to Interstate
system (23 U.S.C. 139(c))
2 = Addition to Interstate
system (23 U.S.C. 139(a))-approved before March 9, 1984
3 = Addition to Interstate
system (23 U.S.C. 139(a))-approved on or after March 9, 1984
Note: Used
to identify Special Highway System Categories.
41 MEDIAN_TYPE:
Median Type for DIVIDED Roadway Only
0 = None
1 = Curbed
2 = Positive barrier
3 = Unprotected
42 TYPE_URB_LOC:
Urban Location
0 = Not applicable
(i.e., not a principal arterial nor in an urbanized area)
1 = Central Business
District (CBD)
2 = High density business/commercial
center (excluding CBD)
3 = Low density commercial
4 = High density residential
(5,000 or more persons per square mile)
5 = Low density residential
(less than 5,000 persons per square mile)
6 = Other urban area,
including undeveloped land
43 TOLL_RD:
Toll
1 = Not a toll road
2 = A toll road
44 COUNTY-CODE:
County Code
A = Barnstable H = Hampshire
B = Berkshire I = Middlesex
C = Bristol J = Nantucket
D = Dukes K = Norfolk
E = Essex L = Plymouth
F = Franklin M = Suffolk
G = Hampden N = Worcester
45 SERIAL_NUMBER:
Serial Number
Uniquely identifies
each roadway segment within a given county
46 CSN_H: County
Code + Serial Number (with blanks)
Uniquely identifies
each roadway segment within the entire state
Note: This item
is the link to the town-level and statewide coverages (MRDxxx's).
See Items 44 & 45
for descriptions
47 CSN_ZF: County
Code + Serial Number (zero filled)
Uniquely identifies
each roadway segment within the entire state
Note: This item is
the link to the town-level coverages (MRDxxx's).
See Items 44 & 45
for descriptions
48 CITY_RIN_H: City
or Town Number + Road Inventory Number (zero filled)
Uniquely identifies
each road within the entire state
Note: This item is
the link to the street listing file (MRD.STREETS).
49 MILES:
Length of street segement in miles.
Note: In miles
(with decimal)
50 CITY_RIN: CITY_NUM
+ RIN
See Items 1 & 2
for descriptions
51 D-SH-WT: D-SH-WID
+ D-WID-TYP (Divided shoulder width and type)
See Items 16 & 17
for descriptions
52 L-SH-WT: L-SH-WID
+ L-WID-TYP (Left shoulder width and type)
See Items 25 & 26
for descriptions
53 R-SH-WT: R-SH-WID
+ R-WID-TYP (Right shoulder width and type)
See Items 29 & 30
for descriptions
54 CSN: County
Code + Serial Number (with blanks).
Uniquely identifies
each roadway segment within the entire state
Note: This item
is the link to the town-level and statewide arc coverages (MRDxxx's).
See Items 44 & 45
for descriptions
