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 |