Dataset: Mill Road Project: Traffic Sensor Data

About this Dataset

Mill Road Project: Traffic Sensor Data

The Mill Road Sensor Project which monitored the eight week closure of the Mill Road bridge by Govia Thameslink to carry out crucial work to improve rail services in 2019 has now completed.

15 smart sensors were installed on Mill Road and surrounding streets to record numbers of pedestrians, bicycles, cars and other vehicles using the network in this area. During the works, access to motorised traffic was not permitted however pedestrians and cyclists were still able to cross the railway for most of the working time. The data collated and analysed by the Smart Cambridge programme has helped the Greater Cambridge Partnership understand how people use the road network and allowed engineers to see the impact of the closure on surrounding roads, including on air quality (Air quality work was completed by Cambridge City Council and information on this can be found on their website here). Final reports on the learnings from the project, which completed in December 2020, can be found on the Smart Cambridge website here. Data captured by the 15 sensors used during this trial can be found on this page for the period up to and including December 2020. Keeping the sensors in place for this long has also allowed teams to make greater comparisons, by taking in to account daily, weekly, monthly and annual variations in traffic levels.

The below data release offers counts for each sensor over 1 hour periods. The current data covers the period 03/06/2019 to 13/12/2020.

Hourly counts are broken down by inbound and outbound journeys. .

Counts are also broken down by vehicle type. This includes:

Pedestrians
Cyclists
Buses
LGV
OGV 1
OGV 2

The release also includes a full list of sensor sites with geographic point location data.

Data collected by the sensors from 1st January 2021 can be found here and will be updated on a quarterly basis. The Mill Road Project demonstrated the level of insight that can be gained from these sensors, leading to additional sensors in more locations being installed in Cambridge since the summer of 2019. Therefore the data on this page includes both the sensors originally installed for the Mill Road Project and additional sensors deployed at later dates.
Publisher name: Cambridgeshire Insight
Last updated: 2025-05-03T04:00:05Z

Tables

Sensor 1: Mill Road

@ukgov.mill_road_project_traffic_sensor_data.sensor_1_mill_road

259.25 KB
35328 rows
13 columns


CREATE TABLE sensor_1_mill_road (
  "local_time_sensor" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "countlinename" VARCHAR,
  "direction" VARCHAR,
  "car" DOUBLE,
  "pedestrian" DOUBLE,
  "cyclist" DOUBLE,
  "motorbike" DOUBLE,
  "bus" DOUBLE,
  "ogv1" DOUBLE,
  "ogv2" DOUBLE,
  "lgv" DOUBLE
);

Sensor 10: East Road

@ukgov.mill_road_project_traffic_sensor_data.sensor_10_east_road

302.71 KB
35328 rows
13 columns


CREATE TABLE sensor_10_east_road (
  "local_time_sensor" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "countlinename" VARCHAR,
  "direction" VARCHAR,
  "car" DOUBLE,
  "pedestrian" DOUBLE,
  "cyclist" DOUBLE,
  "motorbike" DOUBLE,
  "bus" DOUBLE,
  "ogv1" DOUBLE,
  "ogv2" DOUBLE,
  "lgv" DOUBLE
);

Sensor 6: Station Road

@ukgov.mill_road_project_traffic_sensor_data.sensor_6_station_road

270.4 KB
35328 rows
13 columns


CREATE TABLE sensor_6_station_road (
  "local_time_sensor" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "countlinename" VARCHAR,
  "direction" VARCHAR,
  "car" DOUBLE,
  "pedestrian" DOUBLE,
  "cyclist" DOUBLE,
  "motorbike" DOUBLE,
  "bus" DOUBLE,
  "ogv1" DOUBLE,
  "ogv2" DOUBLE,
  "lgv" DOUBLE
);

Sensor 4: Vinery Road

@ukgov.mill_road_project_traffic_sensor_data.sensor_4_vinery_road

207.79 KB
26880 rows
13 columns


CREATE TABLE sensor_4_vinery_road (
  "local_time_sensor" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "countlinename" VARCHAR,
  "direction" VARCHAR,
  "car" BIGINT,
  "pedestrian" BIGINT,
  "cyclist" BIGINT,
  "motorbike" BIGINT,
  "bus" BIGINT,
  "ogv1" BIGINT,
  "ogv2" BIGINT,
  "lgv" BIGINT
);

Sensor 16: Perne Road

@ukgov.mill_road_project_traffic_sensor_data.sensor_16_perne_road

276.49 KB
26880 rows
13 columns


CREATE TABLE sensor_16_perne_road (
  "local_time_sensor" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "countlinename" VARCHAR,
  "direction" VARCHAR,
  "car" BIGINT,
  "pedestrian" BIGINT,
  "cyclist" BIGINT,
  "motorbike" BIGINT,
  "bus" BIGINT,
  "ogv1" BIGINT,
  "ogv2" BIGINT,
  "lgv" BIGINT
);

Sensor 2: Mill Road

@ukgov.mill_road_project_traffic_sensor_data.sensor_2_mill_road

282.31 KB
35328 rows
13 columns


CREATE TABLE sensor_2_mill_road (
  "local_time_sensor" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "countlinename" VARCHAR,
  "direction" VARCHAR,
  "car" DOUBLE,
  "pedestrian" DOUBLE,
  "cyclist" DOUBLE,
  "motorbike" DOUBLE,
  "bus" DOUBLE,
  "ogv1" DOUBLE,
  "ogv2" DOUBLE,
  "lgv" DOUBLE
);

Sensor 12: Devonshire Road Cycle Path

@ukgov.mill_road_project_traffic_sensor_data.sensor_12_devonshire_road_cycle_path

170.43 KB
26880 rows
13 columns


CREATE TABLE sensor_12_devonshire_road_cycle_path (
  "local_time_sensor" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "countlinename" VARCHAR,
  "direction" VARCHAR,
  "car" BIGINT,
  "pedestrian" BIGINT,
  "cyclist" BIGINT,
  "motorbike" BIGINT,
  "bus" BIGINT,
  "ogv1" BIGINT,
  "ogv2" BIGINT,
  "lgv" BIGINT
);

Sensor 41: Tenison Road

@ukgov.mill_road_project_traffic_sensor_data.sensor_41_tenison_road

219.84 KB
26880 rows
13 columns


CREATE TABLE sensor_41_tenison_road (
  "local_time_sensor" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "countlinename" VARCHAR,
  "direction" VARCHAR,
  "car" BIGINT,
  "pedestrian" BIGINT,
  "cyclist" BIGINT,
  "motorbike" BIGINT,
  "bus" BIGINT,
  "ogv1" BIGINT,
  "ogv2" BIGINT,
  "lgv" BIGINT
);

Sensor 3: Coleridge Road

@ukgov.mill_road_project_traffic_sensor_data.sensor_3_coleridge_road

230.11 KB
26880 rows
13 columns


CREATE TABLE sensor_3_coleridge_road (
  "local_time_sensor" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "countlinename" VARCHAR,
  "direction" VARCHAR,
  "car" BIGINT,
  "pedestrian" BIGINT,
  "cyclist" BIGINT,
  "motorbike" BIGINT,
  "bus" BIGINT,
  "ogv1" BIGINT,
  "ogv2" BIGINT,
  "lgv" BIGINT
);

Sensor 15: Newmarket Road

@ukgov.mill_road_project_traffic_sensor_data.sensor_15_newmarket_road

267.73 KB
35328 rows
13 columns


CREATE TABLE sensor_15_newmarket_road (
  "local_time_sensor" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "countlinename" VARCHAR,
  "direction" VARCHAR,
  "car" DOUBLE,
  "pedestrian" DOUBLE,
  "cyclist" DOUBLE,
  "motorbike" DOUBLE,
  "bus" DOUBLE,
  "ogv1" DOUBLE,
  "ogv2" DOUBLE,
  "lgv" DOUBLE
);

Sensor 13: Milton Road

@ukgov.mill_road_project_traffic_sensor_data.sensor_13_milton_road

301.89 KB
35328 rows
13 columns


CREATE TABLE sensor_13_milton_road (
  "local_time_sensor" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "countlinename" VARCHAR,
  "direction" VARCHAR,
  "car" DOUBLE,
  "pedestrian" DOUBLE,
  "cyclist" DOUBLE,
  "motorbike" DOUBLE,
  "bus" DOUBLE,
  "ogv1" DOUBLE,
  "ogv2" DOUBLE,
  "lgv" DOUBLE
);

All Sensors

@ukgov.mill_road_project_traffic_sensor_data.all_sensors

2.6 MB
376320 rows
13 columns


CREATE TABLE all_sensors (
  "local_time_sensor" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "countlinename" VARCHAR,
  "direction" VARCHAR,
  "car" BIGINT,
  "pedestrian" BIGINT,
  "cyclist" BIGINT,
  "motorbike" BIGINT,
  "bus" BIGINT,
  "ogv1" BIGINT,
  "ogv2" BIGINT,
  "lgv" BIGINT
);

Sensor 14: Hills Road

@ukgov.mill_road_project_traffic_sensor_data.sensor_14_hills_road

313.15 KB
35328 rows
13 columns


CREATE TABLE sensor_14_hills_road (
  "local_time_sensor" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "countlinename" VARCHAR,
  "direction" VARCHAR,
  "car" DOUBLE,
  "pedestrian" DOUBLE,
  "cyclist" DOUBLE,
  "motorbike" DOUBLE,
  "bus" DOUBLE,
  "ogv1" DOUBLE,
  "ogv2" DOUBLE,
  "lgv" DOUBLE
);

Sensor 40: Cherry Hinton Road

@ukgov.mill_road_project_traffic_sensor_data.sensor_40_cherry_hinton_road

264.84 KB
35328 rows
13 columns


CREATE TABLE sensor_40_cherry_hinton_road (
  "local_time_sensor" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "countlinename" VARCHAR,
  "direction" VARCHAR,
  "car" DOUBLE,
  "pedestrian" DOUBLE,
  "cyclist" DOUBLE,
  "motorbike" DOUBLE,
  "bus" DOUBLE,
  "ogv1" DOUBLE,
  "ogv2" DOUBLE,
  "lgv" DOUBLE
);

Sensor 7: Coldhams Lane

@ukgov.mill_road_project_traffic_sensor_data.sensor_7_coldhams_lane

255.06 KB
35328 rows
13 columns


CREATE TABLE sensor_7_coldhams_lane (
  "local_time_sensor" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "countlinename" VARCHAR,
  "direction" VARCHAR,
  "car" DOUBLE,
  "pedestrian" DOUBLE,
  "cyclist" DOUBLE,
  "motorbike" DOUBLE,
  "bus" DOUBLE,
  "ogv1" DOUBLE,
  "ogv2" DOUBLE,
  "lgv" DOUBLE
);