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 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.

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