Anchor: #i1018937

Section 7: TRM Query

Anchor: #i1018942

How to Query the TRM System

See real-time values of any particular attribute in the TRM Query facility.

From the TRM Main Menu, input ‘E’ for TRM Query and press <E>. The Database Query Selection Menu appears:

Database Query Selection Menu. (click in image to see full-size image) Anchor: #i1003291

Figure 3-26. Database Query Selection Menu.

This table lists the Required/Optional input fields on the Database Query Selection Menu:

Anchor: #i1012628Query Selection Menu Descriptions

Field

Required/Optional

Signed Highway
  • System (Required)
  • Number (Required)
  • Suffix (Optional)

From Reference Marker
  • Number (Required)
  • Suffix (Optional)
  • Displacement (Optional)

To Reference Marker
  • Number (Required)
  • Suffix (Optional)
  • Displacement (Optional)

Roadbed-Id

Depends on Type Choice—See Query Selections Table

Type Choice

Required


Select features according to the corresponding letters or “Type Choices”, input Required/Optional fields, and press <E>. The applicable query submenu or query data screen appears.

This table lists each feature type choice, the attributes or features available for that choice, and the valid Roadbed-IDS. The links go to a specific manual section or subsection containing information about your feature choice:

Anchor: #i1012650Query Selections

Type Choice

Attributes/Features Available

Valid Roadbeds

A. Highway Status

Highway Status Code, Date, and Notation

K, R, L, M, S, T, P, X, Y, A, B

B. Marker Displacement

Distance From Origin, From Previous Marker, Previous Marker Number

C or Blank

C. Roadbed-Id

Roadbed-Id, Roadbed Begin/End

NOTE: Leave the Roadbed-Id field blank and all roadbed breaks display

K, R, L, M, S, T, P, X, Y, A, B or Blank

D. Administrative

Rural/Urban Code, FIPS Urban Area Number, Administrative System, City Number, Govt Control Level, Metropolitan Planning Area Number, Census Place Number, Functional System

N, X, Y, A, B

D. Administrative

Special System, MSA Class

C

E. District/County/ Control-Section

District-Id, County Number, Control-Section

C or Blank

F. Median Data

Median Width/Type

N

G. Baseline Bearings

Type, Beginning Direction, Degrees, Minutes, Seconds, Ending Direction, Location

C or Blank

H. PI Curve Data

Delta Degrees, Minutes, Seconds, Left/Right

C or Blank

Type Choice

Attributes/Features Available

Valid Roadbeds

I. Normal Curve

Point of Curvature, Point of Tangent, Delta Degrees, Minutes, Seconds, Tangent Length, Curve Degrees, Minutes, Seconds, Curve Length

C or Blank

J. Spiral Curve

Tangent to Spiral, Spiral to Curve, Curve to Spiral, Spiral to Tangent, Delta Degrees, Minutes, Seconds, Tangent Length 1 & 2, Curve Degrees, Minutes, Seconds, Curve Length

C or Blank

K. Boundaries

Begin/End, Type, Skew, Value, Notation

C, N, X, Y, A, B

L. HPMS

HPMS Current ID

N, X, Y, A, B

M. Links

Link Begin/End, Type, Signed Highway, Reference Marker limits, Off- System Length

C or Blank

N. Traffic

Current/History Year, Current/History AADT, Adjusted Current, Design Year, Design Hourly Volume, K-Factor, Directional Factor, Truck PCT AADT, Truck PCT DHV, ATHWLD 100 lbs., ATHWLD PCT, Flex/Rigid 18Kip

N, X, Y, A, B

O. Maintenance

Maintenance Section, District, Foreman Number

C or Blank

P. Pavement/ Lane/Speed Limit

Speed Limit Maximum/Minimum, Roadbed Width, Base Type, Surface Width/Type, Number of Thru Lanes, Direction of Travel, Left/Right Shoulder Width, Type, & Use, Left/Right Curb Type

K, R, L, M, S, T, P, X, Y, A, B

Q. Right of Way Width

Right of Way Width Usual/Minimum

C or Blank

R. Hwy Design

Highway Design

N, X, Y, A, B

R. Maint Status

Maintenance Status

C

S. Load Limit

Load Limit Axle, Gross, Tandem

K, R, L, M, S, T, P, X, Y, A, B

Type Choice

Attributes/Features Available

Valid Roadbeds

T. Features

Cattle Guards, Connectors (no “N”), Culverts, Ferries, Gates, Historical Marker, Intersecting Roadways, Litter Barrel, Material Stock Pile, Overhead Sign, Pedestrian Passageways, Picnic Area, Pipe Lines, Railroads, Ramps (no “N”) Roadside Rest Area, Scenic Overlook, Streams, Structures, Telephone Lines, Test Site, Tourist Information Center, Traffic Monitoring Site, Transmission Lines, Tunnels, TxDOT Facility, Water Lines, Other Features, Other Intersecting Features, Other Roadside Features

K, R, L, M, S, T, P, X, Y, A, B, N

T. Features

Roadway Gaps

C

U. Tracking

Reason Code, Update Date/Time, Old Signed Highway, Reference Marker and Roadbed-Id, Old Distance From Origin, Notation

C

V. Secondary Route

Secondary Route Type, Begin/End, Notation

C

W. Marker Coordinates

Latitude, Longitude, Elevation

C
  • If entering roadbeds CG or NG, the heading appears as Route B/E
  • If entering a specific roadbed, the heading appears as Rdbd B/E
  • Select any or all of the available attributes to display
  • Only data values for those attributes selected display


When querying the system, keep in mind:

  • If more than one data screen is available for viewing, the word “more...” appears in the bottom right corner of the screen and the <F8> key is available. To view these additional data screens, press <F8> to scroll forward and <F7> to scroll backward
  • Change the Location Key Fields on the query data screen to other values and press <E>. New data values appear for the new Key Fields. Change the Roadbed-Id to an Id valid to the query selection
  • To exit any screen, press <F3>.
Anchor: #i1019006

Length Data Display

The TRM screen displays length data differently from point data because length data exists along the roadway from one point to another. We list examples of each characteristic below with an example including seven general characteristics at the end of this section:

Reference Marker Display. Only one reference marker location appears, representing the From and To marker range of attribute values. Records appear indicating the marker location where the length data value changed from one value to another. The value displayed at the marker location is the value that existed up to the point of change, not the value existing from the change forward.

Example 1: The value for Speed Limit Maximum changed from 55 to 65 mph at marker location 420 + 1.000. It changed back to 55 at marker location 466 + 0.773 for the remainder of the route. Three records appear to indicate the speed changes:

Anchor: #i1012778Example 1 Table

Reference Marker

Speed Limit

Maximum

Explanation

Num

Suf

Disp

-

-

0420

-

1.000

55

55 up to this point

0466

-

0.773

65

65 up to this point

0518

-

0.830

55

55 to end of route


Specified Roadbed-Id. If the system requires Roadbed-Id, values display for that specified roadbed only. If the Roadbed-Id entered is not valid for other attributes on the same screen, their values appear as blank.

Example 2: Request data for roadbed XG on the Hwy Design/Maint Stat query selection. This roadbed is valid for Highway Design, but not for Maintenance Status. Therefore, no values appear for Maintenance Status:

Anchor: #i1012812Example 2 Table

Reference Marker

Highway

Design

Maintenance Status

Num

Suf

Disp

-

-

0420

-

1.000

15

-