Anchor: #i1021484

Section 3: ADABAS Matrix

Anchor: #i1021489

Why 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: #i1021499

ADABAS Legend

Use this legend to interpret the information in the ADABAS Matrix:

Anchor: #i1015572Legend for the ADABAS Data 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

  • K = Key field
  • P = Point data
  • L = Continuous Length data
  • N = Non-continuous Length data

Field size

Number of digits before and after the decimal

Roadbed Classification

  • RB = Roadbed-specific
  • CL = Centerline
  • MF = Combination mainlanes plus each frontage road
  • LR = Combination of the Left and Right Mainlanes
  • MX = Mixture
  • CL/MF = Some values of this attribute are centerline, some are a combination of mainlanes plus each frontage road


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:

Anchor: #i1015594TPP ADABAS Matrix

DataType

Field Size

Rdbd Class

AADT-ADJUST-CURRENT

Adjusted Current AADT

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

-

  • BLB-TYPE-CODE

P

1

CL

  • BLB-DEGREE-MEAS
  • Bearing Degrees

P

2

CL

  • BLB-MINUTES-MEAS
  • Bearing Minutes

P

2

CL

  • BLB-SECONDS-MEAS
  • Bearing Seconds

P

2.1

CL

  • BLB-DIRECTION-BEG
  • Bearing Direction Begin

P

1

CL

  • BLB-DIRECTION-END
  • Bearing Direction Ending

P

1

CL

  • BLB-NOTE

P

8

CL

  • BOUNDARY-DATA-GRP
  • Boundary Data

  • BOUNDARY-TYPE
  • Boundary Type

P

1

CL/MF

  • BOUNDARY-NOTE
  • Boundary Notation

P

30

CL/MF

  • BOUNDARY-SKEW

  • Quad

P

1

CL/MF

  • Type

P

1

CL/MF

  • Angle

P

2

CL/MF

  • BOUNDARY-BEGIN-END
  • Boundary Begin End

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

  • Cl-CURVE-LENGTH
  • Curve Length

P

2.3

CL

  • Cl-CURVE-TYPE-CODE

P

1

CL

  • Cl-CURVE-DEGREE-GRP
  • Curve Degree Angle

  • Cl-CD-DEGREE-MEAS
  • Curve Degrees

P

2

CL

  • Cl-CD-MINUTES-MEAS
  • Curve Minutes

P

2

CL

  • Cl-CD-SECONDS-MEAS
  • Curve Seconds

P

2.1

CL

  • Cl-DELTA-GRP
  • Delta Angle
  • Cl-DELTA-DEGREE-MEAS
  • Delta Degrees

P

3

CL

  • Cl-DELTA-MINUTES-MEAS
  • Delta Minutes

P

2

CL

  • Cl-DELTA-SECONDS-MEAS
  • Delta Seconds

P

2.1

CL

  • Cl-DLT-LEFT-RIGHT-CODE
  • Delta Left/Right

P

1

CL

  • Cl-TS1-TANG ENT-LENGTH
  • Tangent Length 1

P

2.3

CL

  • Cl-TS2-TANGENT-LENGTH
  • Tangent Length 2

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

Elevation

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

K Factor

L

2

MF

LATITUDE-MEAS

Latitude

P

6.4

CL

LINK-REF-MARKER-GRP

Link Reference Marker Group

  • LINK-REF-MKR-NBR
  • Link Ref Marker Number

  • Link Ref Marker Number

N

4

CL

  • Link Ref Marker Suffix

N

1

CL

  • LINK-REF-MKR-DISP
  • Link Ref Marker Displacement

N

2.3

CL

LINK-SIGNED-Highway

Link Signed Highway

  • Link Highway System

N

2

CL

-

  • Link Highway Number

N

4

CL

-

  • Link Highway Suffix

N

1

CL

LINK-TYPE-CODE

Link Type

N

2

CL

LINK-TYPE-NOTE

Link Notation

N

30

CL

LONGITUDE-MEAS

Longitude

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

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

Signed Highway

-

-

-

  • Highway-System
  • Highway System

K

2

MX

  • Highway-Number
  • Highway Number

K

4

MX

  • Highway-Suffix
  • Highway Suffix

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:

Anchor: #i1016114District ADABAS Matrix

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

  • MAINT-DISTRICT
  • Maintenance District

L

2

CL

  • MAINT-SECTION
  • Maintenance Section

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:

Anchor: #i1016268TPP/District ADABAS Matrix

DataType

Field Size

Rdbd Class

HIGHWAY-STATUS-GRP

Highway Status Data

  • HIGHWAY-STATUS-CODE

L

1

RB

  • HIGHWAY-STATUS-NOTE
  • Highway Status Notation

L

30

RB

INTERSECTION-GRP

Intersection Data

-

-

  • INT-FEATURE-TYPE

P

2

MX

  • INT-REF-MARKER-GRP
  • Int Reference Marker Group

-

-

  • INT-REF-MARKER-NBR
  • Int Ref Marker Number

-

-

-

a. Int Ref Marker Number

P

4

MX

b. Int Ref Marker Suffix

P

1

MX

  • INT-REF-MARKER-DISP
  • Int Ref Marker Displacement

P

2.3

MX

  • INT-ROADBED-ID

P

2

MX

  • INT-SIGNED-HIGHWAY

-

-

-

  • Int Highway System

P

2

MX

-

  • Int Highway Nbr

P

4

MX

-

  • Int Highway Suffix

P

1

MX

  • INT-TYPE

P

1

MX

REF-MARKER-DATE

Reference Marker Date

-

-

-

  • Month

P

V

CL

-

  • Day

P

V

CL

-

  • Year

P

V

CL

REFERENCE-MARKER-GRP

Reference Marker Group

-

-

  • REF-MARKER-NBR
  • Ref Marker Number

-

-

-

  • Ref Marker Number

K

4

CL

-

  • Ref Marker Suffix

K

1

CL

  • REF-MARKER-DISP
  • Ref Marker Displacement

K

2.3

CL

ROADSIDE-FEAT-TYPE-CODE

Roadside Feature Type

P

1

RB

ROADWAY-FEATURE-GRP

Roadway Feature Data

-

-

  • ROADWAY-FEATURE-CODE
  • Roadway Feature Value

P

2

RB

  • ROADWAY-FEATURE-BEGIN-END
  • Roadway Feature Begin/End

P

1

RB

  • ROADWAY-FEATURE-GRADE

P

1

RB

  • ROADWAY-FEATURE-LEFT-RIGHT
  • Roadway Feature Left/Right

P

1

RB

  • ROADWAY-FEATURE-NOTE
  • Notation

P

30

RB

  • ROADWAY-FEATURE-SKEW

-

-

-

  • Quad

P

1

RB

-

  • Type

P

1

RB

-

  • Angle

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:

Anchor: #i1016524Construction Division ADABAS Matrix

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:

Anchor: #i1016552TRM System ADABAS Matrix

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

  • HIGHWAY-STATUS-DATE
  • Highway Status Date

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

-

-

  • Old-Ref-Marker-Nbr
  • Old Ref Marker Number

N

4

CL

  • Old-Ref-Marker-Suf
  • Old Ref Marker Suffix

N

1

CL

  • OLD-Ref-Marker-Disp
  • Old Ref Marker Displacement

N

2.3

CL

OLD-SIGNED-HIGHWAY

Old Signed Highway

-

-

  • Old-Highway-System
  • Old Highway System

N

2

CL

  • Old-Highway-Nbr
  • Old Highway Nbr

N

4

CL

  • Old-Highway-Suffix
  • Old Highway Suffix

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

-

  • Previous Ref Marker Number

P

4

CL

  • Previous Ref Marker Suffix

P

1

CL

ROADBED-BEGIN-END

Roadbed Begin End

P

1

RB



Previous page  Next page   Title page