Section 3: ADABAS Matrix
Anchor: #i1021489Why Use the ADABAS Matrices?
Use the following ADABAS legend and Matrices to help you input the correct, system-required information to TRM accurately and successfully.
Anchor: #i1021499ADABAS Legend
Use this legend to interpret the information in the ADABAS Matrix:
Column |
Description |
---|---|
ADABAS Attribute Name |
The search name used to retrieve data records. |
Common Name |
Appears in instructions and on the TRM data screens. |
Data Type |
|
Field size |
Number of digits before and after the decimal |
Roadbed Classification |
|
Anchor: #i1021508
TPP ADABAS Matrix
Use this ADABAS matrix to determine the attribute’s data type, field size, and roadbed class that are TPP’s maintenance responsibility:
DataType |
Field Size |
Rdbd Class |
||
---|---|---|---|---|
AADT-ADJUST-CURRENT |
L |
6 |
MF |
|
AADT-CURRENT |
Current AADT |
L |
6 |
MF |
AADT-CURRENT-YEAR |
Current Year AADT |
L |
8 |
MF |
AADT-FOR-DESIGN-YEAR |
Design Year AADT |
L |
8 |
MF |
AADT-HISTORY |
Historical AADT |
L |
6 |
MF |
AADT-HISTORY-YEAR |
History Year AADT |
L |
8 |
MF |
ADMIN-SYSTEM-CODE |
Admin System |
L |
1 |
MF |
ATHWLD-PCT |
ATHWLD –PCT |
L |
6 |
MF |
ATHWLD-100-LBS |
ATHWLD –100-LBS |
L |
6 |
MF |
BASELINE- BEARING-GRP |
Baseline Bearing Data |
- |
||
|
|
P |
1 |
CL |
|
|
P |
2 |
CL |
|
|
P |
2 |
CL |
|
|
P |
2.1 |
CL |
|
|
P |
1 |
CL |
|
|
P |
1 |
CL |
|
|
P |
8 |
CL |
|
|
|||
|
|
P |
1 |
CL/MF |
|
|
P |
30 |
CL/MF |
|
|
|||
|
P |
1 |
CL/MF |
|
|
P |
1 |
CL/MF |
|
|
P |
2 |
CL/MF |
|
|
|
P |
1 |
CL/MF |
CENSUS-PLACE-NBR |
Census Place |
L |
5 |
MF |
CITY-NBR |
City Number |
L |
5 |
MF |
CONTROL-SECTION |
Control Section |
L |
6 |
CL |
COUNTY-NBR |
County Number |
L |
3 |
CL |
CURVE-POINT-CODE |
Curve Point |
P |
1 |
CL |
CURVE-INFO-GRP |
Curve Data |
|||
|
|
P |
2.3 |
CL |
|
|
P |
1 |
CL |
|
|
|||
|
|
P |
2 |
CL |
|
|
P |
2 |
CL |
|
|
P |
2.1 |
CL |
|
|
|||
|
|
P |
3 |
CL |
|
|
P |
2 |
CL |
|
|
P |
2.1 |
CL |
|
|
P |
1 |
CL |
|
|
P |
2.3 |
CL |
|
|
P |
2.3 |
CL |
DESIGN-HOURLY-VOLUME |
Design Hourly Volume |
L |
6 |
MF |
DESIGN-YEAR |
Design Year |
L |
8 |
MF |
DIRECTIONAL-FACTOR |
Directional Factor |
L |
3 |
MF |
DISTRICT-ID |
District-Id |
L |
2 |
CL |
ELEVATION-MEAS |
L |
4.2 |
CL |
|
FIPS-URBAN-AREA |
FIPS Urban Area Number |
L |
5 |
MF |
FLEX-18KIP-ESAL |
Flex 18KIP ESAL |
L |
6 |
MF |
FUNCTIONAL-SYSTEM |
Functional System |
L |
2 |
MF |
GOVT-CONTROL-LEVEL-CODE |
Govt Control Level |
L |
2 |
MF |
HIGHWAY-DESIGN CODE |
Highway Design |
L |
2 |
MF |
K-FACTOR |
L |
2 |
MF |
|
LATITUDE-MEAS |
P |
6.4 |
CL |
|
LINK-REF-MARKER-GRP |
Link Reference Marker Group |
|||
|
|
|||
|
N |
4 |
CL |
|
|
N |
1 |
CL |
|
|
|
N |
2.3 |
CL |
LINK-SIGNED-Highway |
Link Signed Highway |
|||
|
N |
2 |
CL |
|
- |
|
N |
4 |
CL |
- |
|
N |
1 |
CL |
LINK-TYPE-CODE |
Link Type |
N |
2 |
CL |
LINK-TYPE-NOTE |
Link Notation |
N |
30 |
CL |
LONGITUDE-MEAS |
L |
7.4 |
CL |
|
METRO-PLANG-AREA-NBR |
Metropolitan Planning Area |
L |
3 |
MF |
OFF-SYSTEM-LENGTH |
Off-System Length |
N |
3.3 |
CL |
RAILROAD-NBR |
Railroad Number |
P |
7 |
mx |
RIGID-18KIP-ESAL |
Rigid-18KIP ESAL |
L |
6 |
MF |
Roadbed-Id |
N/K |
|
RB |
|
RURAL-URBAN-CODE |
Rural/Urban Values |
L |
I |
MF |
SECONDARY-RTE-DESIG |
Secondary Route Designation |
N |
1 |
CL |
SIGNED-HIGHWAY |
- |
- |
- |
|
|
|
K |
2 |
MX |
|
|
K |
4 |
MX |
|
|
K |
1 |
mx |
SPECIAL-SYSTEM-CODE |
Special System Value |
L |
2 |
CL |
TRUCK-PCT-AADT |
Truck PCT AADT |
L |
6 |
MF |
TRUCK-PCT-DHV |
Truck PCT DHV |
L |
6 |
MF |
Anchor: #i1021517
District ADABAS Matrix
Use this ADABAS matrix to determine the attribute’s data type, field size, and roadbed class that are the districts’maintenance responsibility:
Data Type |
Field Size |
Rdbd Class |
||
---|---|---|---|---|
BASE-TYPE-CODE |
Base Type |
L |
1 |
RB |
CULV-FILL DEPTH –MEAS |
Culvert Fill Depth |
p |
2 |
MX |
CURB—TYPE-LEFT-CODE |
Curb Type Left |
p |
1 |
RB |
CURB—TYPE-RIGHT-CODE |
Curb Type Right |
p |
1 |
RB |
DIRECTION-OF-TRAVEL |
Direction of Travel |
L |
1 |
RB |
HIGHWAY-MAINT-STATUS-CODE |
Highway Maintenance Status |
L |
2 |
CL |
MAINT-FOREMAN-NBR |
Maintenance Foreman Number |
L |
2 |
CL |
|
|
L |
2 |
CL |
|
|
L |
2 |
CL |
MEDIAN-TYPE |
Median Type |
L |
1 |
LR |
MEDIAN -WIDTH |
Median Width |
L |
2 |
LR |
NUMBER— THRU-LANES |
Number of Through Lanes |
L |
2 |
RB |
ROADBED— WIDTH |
Roadbed Width |
L |
3 |
RB |
SHLDR-TYPE-LEFT-CODE |
Shoulder Type Left |
L |
1 |
RB |
SHOULDER—USE-LEFT-CODE |
Shoulder Use Left |
L |
1 |
RB |
SHOULDER —WIDTH-LEFT-CODE |
Shoulder Width Left |
L |
2 |
RB |
SHOULDER—TYPE-RIGHT-CODE |
Shoulder Type Right |
L |
1 |
RB |
SHOULDER—USE-RIGHT-CODE |
Shoulder Use Right |
L |
1 |
RB- |
SHOULDER— WIDTH-RIGHT-MEAS |
Shoulder Width Right |
L |
2 |
RB |
SPEED-LIMIT— MAX |
Speed Limit Maximum |
L |
2 |
RB |
SPEED-LIMIT— MIN |
Speed Limit Minimum |
L |
2 |
RB |
SURFACE-TYPE-CODE |
Surface Type |
L |
2 |
RB |
SURFACE-WIDTH-MEAS |
Surface Width |
L |
3 |
RB |
Anchor: #i1021526
TPP/District ADABAS Matrix
Use this ADABAS matrix to determine the attribute’s data type, field size, and roadbed class that are TPP and the districts’ maintenance responsibility:
DataType |
Field Size |
Rdbd Class |
||
---|---|---|---|---|
HIGHWAY-STATUS-GRP |
Highway Status Data |
|||
|
|
L |
1 |
RB |
|
|
L |
30 |
RB |
INTERSECTION-GRP |
Intersection Data |
- |
- |
|
|
|
P |
2 |
MX |
|
|
- |
- |
|
|
|
- |
- |
|
- |
a. Int Ref Marker Number |
P |
4 |
MX |
b. Int Ref Marker Suffix |
P |
1 |
MX |
|
|
|
P |
2.3 |
MX |
|
|
P |
2 |
MX |
|
|
- |
- |
|
- |
|
P |
2 |
MX |
- |
|
P |
4 |
MX |
- |
|
P |
1 |
MX |
|
|
P |
1 |
MX |
REF-MARKER-DATE |
Reference Marker Date |
- |
- |
|
- |
|
P |
V |
CL |
- |
|
P |
V |
CL |
- |
|
P |
V |
CL |
REFERENCE-MARKER-GRP |
Reference Marker Group |
- |
- |
|
|
|
- |
- |
|
- |
|
K |
4 |
CL |
- |
|
K |
1 |
CL |
|
|
K |
2.3 |
CL |
ROADSIDE-FEAT-TYPE-CODE |
Roadside Feature Type |
P |
1 |
RB |
ROADWAY-FEATURE-GRP |
Roadway Feature Data |
- |
- |
|
|
|
P |
2 |
RB |
|
|
P |
1 |
RB |
|
|
P |
1 |
RB |
|
|
P |
1 |
RB |
|
|
P |
30 |
RB |
|
|
- |
- |
|
- |
|
P |
1 |
RB |
- |
|
P |
1 |
RB |
- |
|
P |
2 |
RB |
ROW-WIDTH-MIN-MEAS |
ROW Width Minimum |
L |
3 |
CL |
ROW-WIDTH-USUAL-MEAS |
ROW Width Usual |
L |
3 |
CL |
STRUCTURE-NBR |
Structure Number |
P |
14 |
MX |
Anchor: #i1021535
Construction Division ADABAS Matrix
Use this ADABAS matrix to determine the attribute’s data type, field size, and roadbed class that are Construction Division’s maintenance responsibility:
DataType |
Field Size |
Rdbd Class |
||
---|---|---|---|---|
LOAD-LIMIT -AXLE |
Load Limit Axle |
L |
6 |
RB |
LOAD-LIMIT -GROSS |
Load Limit Gross |
L |
6 |
RB |
LOAD-LIMIT -TANDEM |
Load Limit Tandem |
L |
6 |
RB |
Anchor: #i1021549
TRM System ADABAS Matrix
Use this ADABAS matrix to determine the attribute’s data type, field size, and roadbed class that the TRM System maintains:
DataType |
Field Size |
Rdbd Class |
||
---|---|---|---|---|
CURVE-ID |
Curve Id |
P |
7 |
CL |
DIST-FROM-PREV-MARKER-NBR |
Dist Between Markers |
L |
2.3 |
CL |
DISTANCE-FROM-ORIGIN |
Distance From Origin |
L |
2.3 |
CL |
|
|
L |
8 |
RB |
LINK-TYPE-BEGIN-END |
Link Begin End |
N |
1 |
CL |
NETWORK-CHANGE-BEGIN-END |
Network Change Begin End |
N |
1 |
CL |
NETWORK-CHANGE-NOTE |
Network Change Notation |
N |
30 |
CL |
NETWORK-REASON-CODE |
Network Reason Code (1998 and before) |
N |
1 |
CL |
NETWORK-TRACKING-CODE |
Network Tracking Code |
N |
1 |
CL |
NETWORK-UPDATE-DATE |
Network Update Date |
N |
8 |
MX |
NETWORK-UPDATE-TIME |
Network Update Time |
N |
6 |
CL |
OLD-REF-MARKER-GRP |
Old Ref Marker |
- |
- |
|
|
|
N |
4 |
CL |
|
|
N |
1 |
CL |
|
|
N |
2.3 |
CL |
OLD-SIGNED-HIGHWAY |
Old Signed Highway |
- |
- |
|
|
|
N |
2 |
CL |
|
|
N |
4 |
CL |
|
|
N |
1 |
CL |
OLD-ROADBED-ID |
Old Roadbed-Id |
N |
2 |
CL |
OLD-DIST-FROM-ORIGIN |
Old Distance From Origin |
N |
2.3 |
CL |
PREV-REF-MARK-NBR |
Previous Marker Data |
|||
- |
|
P |
4 |
CL |
|
P |
1 |
CL |
|
ROADBED-BEGIN-END |
Roadbed Begin End |
P |
1 |
RB |