| Column Name |
Format |
| Code |
CHAR 2 - Primary key |
| Descptn |
CHAR 30 NULL |
| |
| Relationships |
|---|
| roadtype.code |
c5ad.road_type |
|
|
|
| Code |
Descrptn |
| AL |
Alcove |
| AV |
Avenue |
| BA |
Bay |
| BL |
Boulevard |
| BN |
Bend |
| CH |
County Highway |
| CI |
Circle |
| CO |
County |
| CR |
County Road |
| CS |
CSAH-County State Aid Highway |
| CT |
Court |
| CV |
Curve |
| DR |
Drive |
| HC |
Highway Contract |
| HY |
Highway |
| IH |
Interstate |
| IS |
Interstate |
| LA |
Lane |
| LM |
Landmark |
| LO |
Loop |
| MH |
Minnesota Highway |
| MM |
Memorial Highway |
| OH |
Old Highway |
| OV |
Overlook |
| PA |
Path |
| PK |
Parkway |
| PL |
Place |
| PT |
Point |
| RD |
Road |
| RE |
East Route |
| RF |
Rural Free Delivery |
| RH |
Reservation Highway |
| RN |
North Route |
| RR |
Rural Route |
| RS |
South Route |
| RT |
Route |
| RW |
West Route |
| SA |
State |
| SC |
Scenic Highway |
| SH |
State Highway |
| SQ |
Square |
| SR |
Star Route |
| ST |
Street |
| TE |
Terrace |
| TH |
Trunk Highway |
| TR |
Trail |
| TU |
Turn |
| TW |
Township road |
| UH |
US Highway |
| UT |
Unorganized Township Road |
| WA |
Way |
|