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|I|06|001|0009|1|International Blvd|MAJ ST OR HY|21988|2011|NE|
AB|I|TT|183|0001|1|US HIGHWAY 95|ARTERIAL|120000|1996|W|
Format¶
Seq. |
Name |
Description |
Formatting Rules |
Required |
Key |
---|---|---|---|---|---|
1 |
Site Street Info transaction identifier. |
Must = AB |
Always |
||
2 |
Indicator for Insert, Update, or Delete action. |
Must = I, U, or D |
Always |
||
3 |
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 |
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 |
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 |
Identifies a street near the site. |
Integer - 2 digit. |
Always |
Y |
|
7 |
The name of the street. |
Text (up to 50 characters). |
Insert |
||
8 |
The type of the street. |
Must exist in ROAD TYPES reference table. |
Insert |
||
9 |
An estimate of the daily traffic volume on the street. |
Integer. |
Insert |
||
10 |
The year for which the traffic count value was estimated. |
Four digit year (YYYY). |
Insert |
||
11 |
The true direction from the site to the street at its nearest point. |
Must exist in COMPASS SECTORS reference table. |
Insert |
||
12 |
The method by which the traffic volume/flow count was obtained. |
Must exist in TRAFFIC VOLUME SOURCES reference table. |
No |