Description: This dataset provides the most up-to-date inventory of bridges in Kentucky, including key attributes and classifications relevant to their management and maintenance.
| Field | Data Type | Description |
|---|---|---|
| SUPER_RATING | STRING | Superstructure condition rating (numeric). Example: 8, 7, 6. Rates the condition of the bridge superstructure. |
| SUB_RATING | STRING | Substructure condition rating (numeric). Example: 8, 7, 6. Rates the condition of the bridge substructure. |
| STATE_LOCAL | STRING | State or local designation. Example: State, Local. Specifies whether the bridge is managed by the state or a local entity. |
| SS_CODE | STRING | Structure status code. Example: State Secondary, Supplemental Road. Describes the classification of the road the bridge serves. |
| SERVICE_UNDER | STRING | Type of service under bridge. Example: 5 Waterway, 1 Highway. Describes the type of feature or service passing beneath the bridge. |
| SERVICE_ON | STRING | Type of service on bridge. Example: 1 Highway, 5 Highway-pedestrian. Describes the type of traffic or service carried by the bridge. |
| RATINGDATE | DATE | Date of most recent bridge rating (YYYY-MM-DD). Example: 2021-08-24. Indicates when the bridge was last rated. |
| POSTED | STRING | Posting status. Example: A Open, no restriction; P Posted for load. Indicates if the bridge has load restrictions. |
| OWNERSHIP | STRING | Bridge ownership type. Example: County, KYTC, City. Identifies the entity responsible for the bridge. |
| OWNER | STRING | Owner code. Example: 01, 02, 04. Numeric code representing the bridge owner. |
| NHS | STRING | National Highway System (NHS) inclusion. Example: Yes, No. Indicates if the bridge is part of the NHS network. |
| LONGITUDE | FLOAT | Longitude coordinate in decimal degrees. Example: -85.747836. Specifies the east-west position of the bridge. |
| LOAD_RATING_AGENCY | STRING | Agency responsible for load rating. Example: KYTC, Contractor. Indicates whether the Kentucky Transportation Cabinet or a contractor performed the load rating. |
| LATITUDE | FLOAT | Latitude coordinate in decimal degrees. Example: 37.716616. Specifies the north-south position of the bridge. |
| GROSS_POSTING | INTEGER | Maximum gross load posting (tons). Example: 18.0. Maximum allowed vehicle weight on the bridge. |
| GFP | STRING | Good/Fair/Poor rating. Example: Good, Fair, Poor. Summarizes the overall bridge condition. |
| FEATURE_INTERSECT | STRING | Feature intersected by bridge. Example: Trib. of Youngers Creek, I-64 EB TO I-265 NB. Name or description of the feature crossed by the bridge. |
| FACILITY_CARRIED | STRING | Facility carried by bridge. Example: Miller Road, I-265. Name or designation of the road or facility supported by the bridge. |
| DISTRICT | STRING | Describes a KYTC District geographic boundary that contains multiple counties. This is used for reporting and should be formatted as "District xx". |
| DECK_RATING | STRING | Deck condition rating (numeric). Example: 8, 7, 6. Rates the condition of the bridge deck. |
| DECK_AREA | FLOAT | Deck area in square feet. Example: 720.0. Represents the surface area of the bridge deck. |
| DECADE | STRING | Decade of construction. Example: 2020s, 1990s. Indicates the decade when the bridge was built. |
| COUNTY | STRING | The name of a Kentucky county, formatted in proper case. |
| BRIDGE_ID | STRING | Unique bridge identifier. Example: 047C00095N. Used to uniquely identify each bridge. |
| BRIDGE_DESCRIPTION | STRING | Bridge description. Example: 1 (102 FT) PPC I-BEAM SPAN; 2 Span 35' Continuous 7\" Reinforced Concrete Slab. Provides details about the bridge structure. |
| ADT | FLOAT | Average Daily Traffic. Example: 127.0, 71346.0. Average number of vehicles crossing the bridge per day. |
| ADMINAREA | STRING | Administrative area code. Example: 3. Code for the administrative area within the district. |
Description: Transportation improvement projects awarded to construction. Includes all awarded contracts from the past six years, including Alternative Delivery.
| 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. |
| AWARD_AMOUNT | FLOAT | The total amount awarded per contract. Note: Contracts can contain multiple projects. |
| ADJUSTED_AWARDED_AMOUNT | FLOAT | No description available |
Description: This dataset is based on the most recent Highway Enacted Plan.
| Field | Data Type | Description |
|---|---|---|
| TYPE_WORK | STRING | Type of work or project. Example: SAF-GUARDRAIL(P), AM-BRIDGE (P) |
| SYP_NO | STRING | Six-Year Plan Number, correlates with the Enacted Highway Plan. Example: 08-04325.00, 03-00320.00 |
| RT_UNIQUE | STRING | No description available |
| RSY_YEAR | INTEGER | RSY (Recommended Six-Year) year. Example: 2026, 2030 |
| RSY_FUND | INTEGER | Funding amount for the RSY year. Example: 58000.0, 3859812.0 |
| ROUTE_PREFIX | STRING | Prefix of the route. Example: KY, US |
| ROUTE_NO | STRING | Number of the route. Example: 1702, 31 |
| ROUTE | STRING | Combined route prefix and number. Example: KY-1702, US-31 |
| NUMBER_OF_LETTINGS | INTEGER | Number of lettings for the project. Example: 1, blank if not available |
| LATEST_LETTING_DATE | DATE | Most recent letting date for the project. Example: 2025-04-24, blank if not awarded yet |
| GEOMETRY_WKT | STRING | No description available |
| FUND_CODE | STRING | Funding code for the project. Example: GR, BRX |
| ENACT_YEAR | INTEGER | Year of the current enacted plan. Example: 2024, 2022 |
| ENACT_PHASE | STRING | Phase of the enacted plan. Example: C, D |
| ENACT_INITIAL_YEAR | INTEGER | Initial year the project was enacted. Example: 2020, 2022 |
| EMP | FLOAT | Ending mile point of the project. Example: 2.19, 19.123 |
| DISTRICT | STRING | KYTC District boundary containing multiple counties. Example: District 08, District 03 |
| DESCRIPTION | STRING | Project description. Example: INSTALL GUARDRAIL ON KY-1702 IN ADAIR COUNTY, RECONSTRUCT KY-100 FROM KY-622 IN SIMPSON COUNTY TO EST OF SULPHUR FORK CREEK IN ALLEN COUNTY |
| COUNTY | STRING | Name of a Kentucky county in proper case. Example: Adair, Allen |
| BRIDGE_ID | STRING | Bridge identifier if applicable. Example: 001B00013N, blank if not a bridge project |
| BMP | FLOAT | Beginning mile point of the project. Example: 1.92, 16.343 |
| AWARDED | STRING | Awarded status of the project. Example: Awarded, blank if not awarded |
Description: This dataset is based on the expenditures over the last six years.
| Field | Data Type | Description |
|---|---|---|
| TRAK_ORG_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. |
| QUARTER | INTEGER | Fiscal quarter (1-4) of the expenditure. EXAMPLE: 1 (July-September), 2 (October-December) |
| PROGRAM_CODE | STRING | Code representing the project or program funding source. EXAMPLE: FD04 (Construction Projects), FD05 (Statewide Resurfacing/Maintenance) |
| PHASE_CODE | STRING | Single-letter code for project phase: P=Planning, D=Design, R=Right-of-Way, U=Utilities, C=Construction. EXAMPLE: P, D, R, U, C |
| MONTH | INTEGER | Month number (1-12) when the expenditure was made. EXAMPLE: 1 (January), 2 (February) |
| ITEM_NO | FLOAT | Project item number or code, often used for budgeting or tracking. EXAMPLE: 0.0, 8902.0 |
| FUND_CODE | STRING | Funding source code for the expenditure. EXAMPLE: FE04, FD52, FE01 |
| FISCAL_YEAR | INTEGER | Fiscal year in which the expenditure was recorded. EXAMPLE: 2021 |
| EXPENDED | FLOAT | Dollar amount expended for the record. EXAMPLE: 33682.74, 459208.98 |
| DIST_NO | INTEGER | Numeric identifier for the KYTC district. EXAMPLE: 0 or 99 (Statewide), 7 (District 07) |
| 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. |
Description:
| Field | Data Type | Description |
|---|---|---|
| trak_geo_district | STRING | No description available |
| trak_geo_county | STRING | No description available |
| trak_adj_mileage | NUMERIC | No description available |
| source_table | STRING | No description available |
| pbi_geo_milepoint | NUMERIC | No description available |
| geometry_wkt | STRING | No description available |
| geometry_length | FLOAT | No description available |
| geometry | STRING | No description available |
| api_status | STRING | No description available |
| WPC_JD_SEV | NUMERIC | No description available |
| WPC_JD_EXT | NUMERIC | No description available |
| STHWYSYS | STRING | No description available |
| R_F_SEV | NUMERIC | No description available |
| R_F_EXT | NUMERIC | No description available |
| RUT_AVG | FLOAT | No description available |
| RTUnique | STRING | No description available |
| ROUTE_NAME | STRING | No description available |
| ROUTE_ID | INTEGER | No description available |
| OS_P_SEV | NUMERIC | No description available |
| OS_P_EXT | NUMERIC | No description available |
| OC_SEV | NUMERIC | No description available |
| OC_EXT | NUMERIC | No description available |
| LatLong | STRING | No description available |
| LONGITUDE | FLOAT | No description available |
| LET_YEAR | NUMERIC | No description available |
| LET_DATE | INTEGER | No description available |
| LCMS_DATE | DATETIME | No description available |
| LATITUDE | FLOAT | No description available |
| LANE_DIR | INTEGER | No description available |
| KY_RATERNOTE | NUMERIC | No description available |
| KY_RATER2 | STRING | No description available |
| KY_RATER1 | STRING | No description available |
| KY_PVMNT | STRING | No description available |
| KY_DISTRICT_ID | INTEGER | No description available |
| KY_APPEAR | NUMERIC | No description available |
| JOINT_SEP | NUMERIC | No description available |
| GFP | STRING | No description available |
| EVAL_YEAR | NUMERIC | No description available |
| EMP | NUMERIC | No description available |
| EFF_YEAR | INTEGER | No description available |
| EFF_DATE | DATETIME | No description available |
| DETER_PTS | INTEGER | No description available |
| COMPLETION_DATE | DATETIME | No description available |
| CNTRCT_NAME | STRING | No description available |
| CAL_pdi | FLOAT | No description available |
| BMP | NUMERIC | No description available |
| BASE_ROUTE | STRING | No description available |
| AVG_PAVE_AGE | FLOAT | No description available |
| AVG_LANES | FLOAT | No description available |
| AVG_IRI | FLOAT | No description available |
| AADT | FLOAT | No description available |
Description: This dataset is compiled using data from Program Management and includes all approved authorizations from the past six years.
| Field | Data Type | Description |
|---|---|---|
| TRAK_ORG_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. |
| STATE_FISCAL_YEAR | INTEGER | No description available |
| SCOPE_LINES | STRING | No description available |
| RT_NUMBER | STRING | No description available |
| ROAD_NAME | STRING | No description available |
| REMARK_LINE | STRING | No description available |
| PROJECT_TYPE | STRING | No description available |
| PROGRAM_CODE | STRING | No description available |
| PHASE_CODE | STRING | No description available |
| MOD_LEVEL | INTEGER | No description available |
| LENGTH | STRING | No description available |
| ITEM_NUMBER | STRING | No description available |
| FUND_NBR | STRING | No description available |
| FISCAL_YEAR | INTEGER | No description available |
| EMARS_PROGRAM_CODE | STRING | No description available |
| DISTRICT | STRING | Describes a KYTC District geographic boundary that contains multiple counties. This is used for reporting and should be formatted as "District xx". |
| CURRENT_MOD_LEVEL | INTEGER | No description available |
| COUNTY | STRING | The name of a Kentucky county, formatted in proper case. |
| CONTRACT_ID | STRING | No description available |
| AUTH_NBR | INTEGER | No description available |
| AUTHORIZED | FLOAT | No description available |
| APPROVED_DATE | DATE | No description available |
| APPROPRIATION_CODE | STRING | No description available |
Description:
| Field | Data Type | Description |
|---|---|---|
| Total_Adjusted_Change_Order | FLOAT | No description available |
| TRAK_Program | STRING | No description available |
| Reason_Description | STRING | No description available |
| District | STRING | No description available |
| Contract_ID_Change_Order | STRING | No description available |
| Approval_Date | DATE | No description available |
Description:
| Field | Data Type | Description |
|---|---|---|
| TRAK_Program | STRING | No description available |
| District | STRING | No description available |
| Date | DATE | No description available |
| County | STRING | No description available |
| Contract | STRING | No description available |
| Awarded_Amount | FLOAT | No description available |
Description:
| Field | Data Type | Description |
|---|---|---|
| Vendor_Name | STRING | No description available |
| TRAK_Program | STRING | No description available |
| SYP_Project_Number | STRING | No description available |
| SYP_Enacted_Year | INTEGER | No description available |
| Letting_Date | DATETIME | No description available |
| Federal_Project_Number | STRING | No description available |
| District | STRING | No description available |
| County | STRING | No description available |
| Contract_Number | STRING | No description available |
| Adjusted_Awarded_Amount | FLOAT | No description available |
Description:
| Field | Data Type | Description |
|---|---|---|
| Total_Machine_Hours | FLOAT | No description available |
| Season | STRING | No description available |
| District | STRING | No description available |
| Date | DATE | No description available |
| County | STRING | No description available |
Description:
| Field | Data Type | Description |
|---|---|---|
| longitude | NUMERIC | No description available |
| latitude | NUMERIC | No description available |
| goky_link | STRING | No description available |
| Route | STRING | No description available |
| Road_Name | STRING | No description available |
| Reported_Year | INTEGER | No description available |
| Last_Reported_EST | DATETIME | No description available |
| First_Reported_EST | DATETIME | No description available |
| EventID | STRING | No description available |
| End_MP | FLOAT | No description available |
| District | STRING | No description available |
| County | STRING | No description available |
| Comments | STRING | No description available |
| Begin_MP | FLOAT | No description available |
| Agency | STRING | No description available |
Description:
| Field | Data Type | Description |
|---|---|---|
| Year | STRING | No description available |
| District | STRING | No description available |
| DVMT_Daily_Vehicle_Miles_Traveled | INTEGER | No description available |
| County | STRING | No description available |
Description:
| Field | Data Type | Description |
|---|---|---|
| Type_of_Work | STRING | No description available |
| TRAK_Program | STRING | No description available |
| SYP_Number | STRING | No description available |
| Project | INTEGER | No description available |
| Engineer_Estimate | FLOAT | No description available |
| Enacted_Plan_Estimate | FLOAT | No description available |
| Enact_Year | INTEGER | No description available |
| District | STRING | No description available |
| County | STRING | No description available |
| Contract | STRING | No description available |
| Awarded_Cost | FLOAT | No description available |
Description:
| Field | Data Type | Description |
|---|---|---|
| Sum_of_Expenditures | FLOAT | No description available |
| Fiscal_Year | STRING | No description available |
| Event | STRING | No description available |
| District | STRING | No description available |
| County | STRING | No description available |
| Calendar_Year | INTEGER | No description available |
Description:
| Field | Data Type | Description |
|---|---|---|
| Year | INTEGER | No description available |
| Unknown | FLOAT | No description available |
| Propane | FLOAT | No description available |
| Natural_Gas | FLOAT | No description available |
| Incomplete | INTEGER | No description available |
| Gas_Electric_Hybrid | FLOAT | No description available |
| Gas | INTEGER | No description available |
| Flexible | INTEGER | No description available |
| Electric | FLOAT | No description available |
| District | STRING | No description available |
| Diesel_Hybrid | FLOAT | No description available |
| Diesel | INTEGER | No description available |
| County | STRING | No description available |
| Convertable | FLOAT | No description available |
