About this Dataset

Road Condition Survey 2017

The data published within this resource represents an ongoing pilot project of automated surface conditioning survey which is helping to extend the life of the UK’s public infrastructure assets. Although the data represents a snapshot in time of the road conditions around the city, due to the evolving nature of the project and the technology around it the data may be updated at any time to reflect any additional data development. Due to the nature of the underlying data, the association of pavement to street name represents just an approximation, with various level of accuracy across the dataset. The City of York Council is continuously developing new technologies to improve the way in which the services provided by the council are delivered. The data published within this resource is used towards ongoing complex analysis in order to provide better deterioration and financial modelling techniques to help in ensuring more effective maintenance of roads and pavements, as well as to improve the way in which the maintenance is prioritised across the city. The data records five condition categories: • Grade 1: very good • Grade 2: good • Grade 3: fair • Grade 4: poor • Grade 5: very poor For information on footway condition please visit the Footway Condition Survey 2017 dataset.
Publisher name: City of York Council
Last updated: 2024-09-14T19:48:29Z

Tables

Road Condition Survey 2017

@ukgov.road_condition_survey_2017.road_condition_survey_2017

2.09 MB
90497 rows
12 columns


CREATE TABLE road_condition_survey_2017 (
  "objectid" BIGINT,
  "survey_dat" BIGINT,
  "area_m2" DOUBLE,
  "grade" VARCHAR,
  "surface_ty" VARCHAR,
  "damage_typ" VARCHAR,
  "damage_wid" VARCHAR,
  "length" DOUBLE,
  "nsg_refere" BIGINT,
  "ne_id_of" BIGINT,
  "ne_descr" VARCHAR,
  "locality" VARCHAR
);