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 FLOAT 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:This dataset is based on data from Construction Procurement. It 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.
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.

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
RSY_YEAR INTEGER RSY (Recommended Six-Year) year. Example: 2026, 2030
RSY_FUND FLOAT 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
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: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
SCOPE_LINES STRING
RT_NUMBER STRING
ROAD_NAME STRING
REMARK_LINE STRING
PROJECT_TYPE STRING
PROGRAM_CODE STRING
PHASE_CODE STRING
MOD_LEVEL INTEGER
LENGTH STRING
ITEM_NUMBER STRING
FUND_NBR STRING
FISCAL_YEAR INTEGER
EMARS_PROGRAM_CODE STRING
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
COUNTY STRING The name of a Kentucky county, formatted in proper case.
CONTRACT_ID STRING
AUTH_NBR INTEGER
AUTHORIZED FLOAT
APPROVED_DATE DATE
APPROPRIATION_CODE STRING