| Field | Data Type | Description |
|---|---|---|
| SUPER_RATING | STRING | None |
| SUB_RATING | STRING | None |
| STATE_LOCAL | STRING | None |
| SS_CODE | STRING | None |
| SERVICE_UNDER | STRING | None |
| SERVICE_ON | STRING | None |
| RATINGDATE | DATE | None |
| POSTED | STRING | None |
| OWNERSHIP | STRING | None |
| OWNER | STRING | None |
| NHS | STRING | None |
| LONGITUDE | FLOAT | None |
| LOAD_RATING_AGENCY | STRING | None |
| LATITUDE | FLOAT | None |
| GROSS_POSTING | FLOAT | None |
| GFP | STRING | None |
| FEATURE_INTERSECT | STRING | None |
| FACILITY_CARRIED | STRING | None |
| DISTRICT | STRING | None |
| DECK_RATING | STRING | None |
| DECK_AREA | FLOAT | None |
| DECADE | STRING | None |
| COUNTY | STRING | None |
| BRIDGE_ID | STRING | None |
| BRIDGE_DESCRIPTION | STRING | None |
| ADT | FLOAT | None |
| ADMINAREA | STRING | None |
| Field | Data Type | Description |
|---|---|---|
| TRAK_PROGRAM | STRING | TRAK Program is a method of classifying work into themes. These categories are sourced from project numbering systems throughout the Cabinet. Due to exceptions in business procedures and user-entered data, these classifications may not always be completely accurate. |
| SYP_NO | STRING | Six-Year Plan Number. This should correlate with the Highway Enacted Plan. |
| PROJECT_NM | STRING | A project identifier consisting of a 2-character organizational unit, 3-character county code, 4-character route, 2-character calendar year, and 2-character sequential number. Examples: DE (Design), MP (Maintenance resurfacing section), MB (Maintenance bridge section), BR (Bridge projects from consultant), RR (Rural Roads), 01-12 (District Office) |
| PROGRAM_CODE | STRING | Indicates the use of funds. Examples: FD04 = Construction Projects, FD05 = Statewide Resurfacing/Maintenance |
| LETTING_DATE | DATE | The date of the letting. |
| FUND_CODE | STRING | No description provided. |
| FED_PROJECT_NUM | STRING | Federal Project Number. This typically includes the Program Code, County Number, and Route Number. |
| DISTRICT | STRING | Describes a KYTC District geographic boundary that contains multiple counties. This is used for reporting and should be formatted as "District xx". |
| COUNTY | STRING | The name of a Kentucky county, formatted in proper case. |
| CONTRACT_ID | STRING | A contract numbering system where the first two digits represent the year the contract was created. |
| CONTRACTOR | STRING | The name of the pre-qualified prime contractor awarded the project. |
| CALCULATED_AWARDED_AMOUNT | FLOAT | A per-project distribution of the awarded contract dollars. This is calculated using the engineer's estimate per project and redistributing the awarded amount proportionally. |
| AWARD_AMOUNT | FLOAT | The total amount awarded per contract. Note: Contracts can contain multiple projects. |
| Field | Data Type | Description |
|---|---|---|
| TYPE_WORK | STRING | None |
| SYP_NO | STRING | Six-Year Plan Number. This should correlate with the Enacted Highway Plan. |
| RSY_YEAR | INTEGER | None |
| RSY_FUND | FLOAT | None |
| ROUTE_PREFIX | STRING | Prefix of the Route. EXAMPLE: I, US |
| ROUTE_NO | STRING | Number of the route. EXAMPLE: 75, 64, 80 |
| ROUTE | STRING | Combines the route prefix with the number. EXAMPLE: I-75, I-64, US-80 |
| NUMBER_OF_LETTINGS | INTEGER | None |
| LATEST_LETTING_DATE | DATE | Most recent letting date. NOTE: Some larger projects may take multiple years and lettings to complete. This value is the most recent letting date for a particular project. |
| FUND_CODE | STRING | None |
| ENACT_YEAR | INTEGER | None |
| ENACT_PHASE | STRING | None |
| ENACT_INITIAL_YEAR | INTEGER | None |
| EMP | FLOAT | The ending mile point of a project. NOTE: A mile point is a measurement along a roadway that begins at zero and increases based on the cumulative distance traveled along the roadway’s centerline. Unlike fixed GPS points, mile points can change over time if the roadway’s geometry is altered, reflecting the updated linear distance. |
| DISTRICT | STRING | Describes a KYTC District geographic boundary that contains multiple counties. This is used for reporting and should be formatted as "District xx". |
| DESCRIPTION | STRING | None |
| COUNTY | STRING | The name of a Kentucky county, formatted in proper case. |
| BRIDGE_ID | STRING | None |
| BMP | FLOAT | The beginning mile point of a project. NOTE: A mile point is a measurement along a roadway that begins at zero and increases based on the cumulative distance traveled along the roadway’s centerline. Unlike fixed GPS points, mile points can change over time if the roadway’s geometry is altered, reflecting the updated linear distance. |
| AWARDED | STRING | Indicates the awarded status of the project. Example: AWARDED for projects that have been awarded or blank if the project has not been awarded. |
| Field | Data Type | Description |
|---|---|---|
| TRAK_ORG_PROGRAM | STRING | None |
| QUARTER | INTEGER | None |
| PROGRAM_CODE | STRING | None |
| PHASE_CODE | STRING | None |
| MONTH | INTEGER | None |
| ITEM_NO | FLOAT | None |
| FUND_CODE | STRING | None |
| FISCAL_YEAR | INTEGER | None |
| EXPENDED | FLOAT | None |
| DIST_NO | INTEGER | None |
| DISTRICT | STRING | None |
| COUNTY | STRING | None |
| Field | Data Type | Description |
|---|---|---|
| STATE_FISCAL_YEAR | INTEGER | None |
| SCOPE_LINES | STRING | None |
| RT_NUMBER | STRING | None |
| ROAD_NAME | STRING | None |
| REMARK_LINE | STRING | None |
| PROJECT_TYPE | STRING | None |
| PROGRAM_CODE | STRING | None |
| PHASE_CODE | STRING | None |
| MOD_LEVEL | INTEGER | None |
| LENGTH | STRING | None |
| ITEM_NUMBER | STRING | None |
| FUND_NBR | STRING | None |
| FISCAL_YEAR | INTEGER | None |
| EMARS_PROGRAM_CODE | STRING | None |
| DISTRICT | STRING | None |
| CURRENT_MOD_LEVEL | INTEGER | None |
| COUNTY | STRING | None |
| CONTRACT_ID | STRING | None |
| AUTH_NBR | INTEGER | None |
| AUTHORIZED | FLOAT | None |
| APPROVED_DATE | DATE | None |
| APPROPRIATION_CODE | STRING | None |
