AB - Site Tangent Road

This transaction is used to store information for each tangent road near the site. The physical description of each road is entered here and the nearest road to any particular monitor is referred to on the monitor transaction by the index given in this transaction. This data is only needed for sites that have one or more tangent roads that will be referenced in a monitor record.

Business Rules

A site tangent road record cannot be deleted if a corresponding monitor tangent road record exists.

Notes

This used to be called site tangent street, but was renamed to use the term road since that’s what’s used elsewhere in AQS.

Examples:

AB transaction in default mode
AB|I|06|001|0009|1|International Blvd|MAJ ST OR HY|21988|2011|NE|
AB transaction in Tribal mode
AB|I|TT|183|0001|1|US HIGHWAY 95|ARTERIAL|120000|1996|W|

Format

AB - Site Tangent Road transaction format

Seq.

Name

Description

Formatting Rules

Required

Key

1

Transaction Type

Site Street Info transaction identifier.

Must = AB

Always

2

Action Indicator

Indicator for Insert, Update, or Delete action.

Must = I, U, or D

Always

3

State Code / Tribal Indicator

The FIPS state code of the monitor, or “TT” to indicate that the next field on the transaction is a Tribal code.

Must exist in STATES Reference Table or be ‘TT’ for Tribal Site

Always

Y

4

County Code / Tribal Code

The FIPS County Code of the site. If the previous field on the transaction contains “TT”, then the Tribal Code of the site.

Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table

Always

Y

5

Site Number

Four digit number to uniquely identify site in county and/or tribe.

Must exist in SITES table with {State Code, county Code} or Tribal Code

Always

Y

6

Tangent Street Number

Identifies a street near the site.

Integer - 2 digit.

Always

Y

7

Street Name

The name of the street.

Text (up to 50 characters).

Insert

8

Road Type

The type of the street.

Must exist in ROAD TYPES reference table.

Insert

9

Traffic Count

An estimate of the daily traffic volume on the street.

Integer.

Insert

10

Traffic Count Year

The year for which the traffic count value was estimated.

Four digit year (YYYY).

Insert

11

Direction from Site to Street

The true direction from the site to the street at its nearest point.

Must exist in COMPASS SECTORS reference table.

Insert

12

Traffic Count Source

The method by which the traffic volume/flow count was obtained.

Must exist in TRAFFIC VOLUME SOURCES reference table.

No