City of Kansas City, Mo.

Kate Bender
This data set contains asset ratings for the City's Roads, Bridges, and Street Lighting systems. This data is Citywide, and not granular to a specific piece of infrastructure. This is the same information that is reported to the Government Accounting Standards Board (GASB). Public Works has established a program to evaluate the condition of all pavements. The name of the program is the Street Distress Rating System (SDRS). This program rates all segments of pavement over a three year period. The program measures actual physical defects in the pavement system which can be observed and quantified through visual inspection of the roadway surface. Broad categories include cracking, patching, depression, and surface wear. The system calculates the Pavement Condition Index representing a value ranging from "0" to "100". The department's intent is to achieve and retain a system-wide average value of not less than "60". The value below 80 represents a system that needs repairs, and improvements. A rating of "90" to "100" would show an excellent condition, "80" to "89" good condition, "70" to "79" fair condition, and below "70", poor condition. The condition of bridges is measured using the Federal Highway Administration Rating System. The Federal system uses a measurement scale that is based on a condition index ranging from zero for a failed bridge to 100 for a bridge in perfect condition. The condition index is used to classify bridges and culverts in good or better condition (65 and 75 on up, respectively), fair condition (45 to 65) and substandard condition (less than 45). It is the City’s policy to maintain, on average, at least 75 percent of its bridge system at a good or better condition level. No more than 10 percent should be in the substandard condition. Condition assessments are determined every other year. All bridges are rated at least once every two years. The condition of street lighting is measured using a system designed by the City. The system uses a measurement scale that is based on an assigned condition index to a streetlight of zero for failing or 100 for passing each measured factor and measures 16 different factors. The condition index is used to classify street lighting in better condition ( 90 and up), good condition ( 80 to 89) and substandard condition (less than 80). It is the City’s policy to maintain an overall average of at least 90 percent condition rating (better condition rating) for the entire street light system. No more than 10 percent of the entire street lighting system should be below the better condition rating. Condition assessments are determined every year. Street lights are selected for condition assessments systematically by private contractor hired to assess and immediately repair all street lights inspected. The plan is to have 100 percent of all street lights inspected, with corresponding repairs, every two years.
bridge, road, street, street light, street lighting, bridge rating, road rating, street rating, street light rating
Current value: 0 out of 5
Data Provided By
City of Kansas City, MO Public Works Department
Source Link
Public Domain
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

Calendar Year
Calendar Year - Label
Roadways - Percent in Good Condition
Roadways - Percent in Fair Condition
Roadways - Percent in Poor Condition
Bridges - Percent with Sufficiency Rating of 50 or Higher
Street Lighting - Percent in Good or Better Condition
Street Lighting - Percent in Substandard Condition

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.