About this Dataset

Mill Road Cambridge: Monitoring Air Quality

Cambridge City Council has been awarded grant funding from Defra to purchase new equipment to monitor air quality in and around and the Mill Road area. This data is also been used to understand the impact of the Mill Road bridge closure over the course of the summer of 2019.

This open data release is linked to the monitoring of traffic and pedestrian counts around Mill Road. The traffic data can be accessed here:https://data.cambridgeshireinsight.org.uk/dataset/mill-road-closure-traffic-sensor-data

The data is available from the 08/07/2019 to 27/10/2019.

Please note- Data for sensors 189245 and 292245 was unable to be extracted for the most recently release. This is being investigated

The data in this release is broken down by hourly increments.

Please note that this is the raw data without any verification / correction factors applied.

The data extracts are broken down by pollutent:

NO2- Nitrogen Dioxide
PM2.5:Particulate Matter 2.5
PM10: Particulate Matter 10

Field Descriptions:

Serial Number_Pollutant_PreScaled- un-calibrated (prior to ratification)

Serial Number_Pollutant_Scaled- calibrated (This is the raw data without any verification / correction factors applied.)

Serial Number_Pollutant_Unit- unit measurement

Serial Number_Pollutant_Slope- slope of the line used in linear regression to calibrate the monitor (not used in pre-scaled results)

Serial Number_Pollutant_Offset- – data offset of the line used in the linear regression to calibrate the monitor (not used in pre-scaled results)
Publisher name: Cambridgeshire Insight
Last updated: 2024-09-14T16:03:06Z

Tables

Mill Road Air Quality NO2

@ukgov.mill_road_cambridge_monitoring_air_quality.mill_road_air_quality_no2

295.52 kB
2,702 rows
50 columns

CREATE TABLE mill_road_air_quality_no2 (
  "timebeginning" VARCHAR,
  "timeending" VARCHAR,
  "n_183245_no2_prescaled" DOUBLE  -- 183245 NO2 PreScaled,
  "n_183245_no2_scaled" DOUBLE  -- 183245 NO2 Scaled,
  "n_183245_no2_unit" VARCHAR  -- 183245 NO2 Unit,
  "n_183245_no2_slope" BIGINT  -- 183245 NO2 Slope,
  "n_183245_no2_offset" BIGINT  -- 183245 NO2 Offset,
  "n_183245_no2_status" VARCHAR  -- 183245 NO2 Status,
  "n_184245_no2_prescaled" DOUBLE  -- 184245 NO2 PreScaled,
  "n_184245_no2_scaled" DOUBLE  -- 184245 NO2 Scaled,
  "n_184245_no2_unit" VARCHAR  -- 184245 NO2 Unit,
  "n_184245_no2_slope" BIGINT  -- 184245 NO2 Slope,
  "n_184245_no2_offset" BIGINT  -- 184245 NO2 Offset,
  "n_184245_no2_status" VARCHAR  -- 184245 NO2 Status,
  "n_185245_no2_prescaled" DOUBLE  -- 185245 NO2 PreScaled,
  "n_185245_no2_scaled" DOUBLE  -- 185245 NO2 Scaled,
  "n_185245_no2_unit" VARCHAR  -- 185245 NO2 Unit,
  "n_185245_no2_slope" BIGINT  -- 185245 NO2 Slope,
  "n_185245_no2_offset" BIGINT  -- 185245 NO2 Offset,
  "n_185245_no2_status" VARCHAR  -- 185245 NO2 Status,
  "n_186245_no2_prescaled" DOUBLE  -- 186245 NO2 PreScaled,
  "n_186245_no2_scaled" DOUBLE  -- 186245 NO2 Scaled,
  "n_186245_no2_unit" VARCHAR  -- 186245 NO2 Unit,
  "n_186245_no2_slope" BIGINT  -- 186245 NO2 Slope,
  "n_186245_no2_offset" BIGINT  -- 186245 NO2 Offset,
  "n_186245_no2_status" VARCHAR  -- 186245 NO2 Status,
  "n_187245_no2_prescaled" DOUBLE  -- 187245 NO2 PreScaled,
  "n_187245_no2_scaled" DOUBLE  -- 187245 NO2 Scaled,
  "n_187245_no2_unit" VARCHAR  -- 187245 NO2 Unit,
  "n_187245_no2_slope" BIGINT  -- 187245 NO2 Slope,
  "n_187245_no2_offset" BIGINT  -- 187245 NO2 Offset,
  "n_187245_no2_status" VARCHAR  -- 187245 NO2 Status,
  "n_188245_no2_prescaled" DOUBLE  -- 188245 NO2 PreScaled,
  "n_188245_no2_scaled" DOUBLE  -- 188245 NO2 Scaled,
  "n_188245_no2_unit" VARCHAR  -- 188245 NO2 Unit,
  "n_188245_no2_slope" BIGINT  -- 188245 NO2 Slope,
  "n_188245_no2_offset" BIGINT  -- 188245 NO2 Offset,
  "n_188245_no2_status" VARCHAR  -- 188245 NO2 Status,
  "n_189245_no2_prescaled" DOUBLE  -- 189245 NO2 PreScaled,
  "n_189245_no2_scaled" DOUBLE  -- 189245 NO2 Scaled,
  "n_189245_no2_unit" VARCHAR  -- 189245 NO2 Unit,
  "n_189245_no2_slope" DOUBLE  -- 189245 NO2 Slope,
  "n_189245_no2_offset" DOUBLE  -- 189245 NO2 Offset,
  "n_189245_no2_status" VARCHAR  -- 189245 NO2 Status,
  "n_292245_no2_prescaled" DOUBLE  -- 292245 NO2 PreScaled,
  "n_292245_no2_scaled" DOUBLE  -- 292245 NO2 Scaled,
  "n_292245_no2_unit" VARCHAR  -- 292245 NO2 Unit,
  "n_292245_no2_slope" DOUBLE  -- 292245 NO2 Slope,
  "n_292245_no2_offset" DOUBLE  -- 292245 NO2 Offset,
  "n_292245_no2_status" VARCHAR  -- 292245 NO2 Status
);

Mill Road Air Quality: PM 10

@ukgov.mill_road_cambridge_monitoring_air_quality.mill_road_air_quality_pm_10

298.06 kB
2,702 rows
51 columns

CREATE TABLE mill_road_air_quality_pm_10 (
  "timebeginning" TIMESTAMP,
  "timeending" TIMESTAMP,
  "n_183245_pm10_prescaled" DOUBLE  -- 183245 PM10 PreScaled,
  "n_183245_pm10_scaled" DOUBLE  -- 183245 PM10 Scaled,
  "n_183245_pm10_unit" VARCHAR  -- 183245 PM10 Unit,
  "n_183245_pm10_slope" BIGINT  -- 183245 PM10 Slope,
  "n_183245_pm10_offset" BIGINT  -- 183245 PM10 Offset,
  "n_183245_pm10_status" VARCHAR  -- 183245 PM10 Status,
  "n_184245_pm10_prescaled" DOUBLE  -- 184245 PM10 PreScaled,
  "n_184245_pm10_scaled" DOUBLE  -- 184245 PM10 Scaled,
  "n_184245_pm10_unit" VARCHAR  -- 184245 PM10 Unit,
  "n_184245_pm10_slope" BIGINT  -- 184245 PM10 Slope,
  "n_184245_pm10_offset" BIGINT  -- 184245 PM10 Offset,
  "n_184245_pm10_status" VARCHAR  -- 184245 PM10 Status,
  "n_185245_pm10_prescaled" DOUBLE  -- 185245 PM10 PreScaled,
  "n_185245_pm10_scaled" DOUBLE  -- 185245 PM10 Scaled,
  "n_185245_pm10_unit" VARCHAR  -- 185245 PM10 Unit,
  "n_185245_pm10_slope" BIGINT  -- 185245 PM10 Slope,
  "n_185245_pm10_offset" BIGINT  -- 185245 PM10 Offset,
  "n_185245_pm10_status" VARCHAR  -- 185245 PM10 Status,
  "n_186245_pm10_prescaled" DOUBLE  -- 186245 PM10 PreScaled,
  "n_186245_pm10_scaled" DOUBLE  -- 186245 PM10 Scaled,
  "n_186245_pm10_unit" VARCHAR  -- 186245 PM10 Unit,
  "n_186245_pm10_slope" BIGINT  -- 186245 PM10 Slope,
  "n_186245_pm10_offset" BIGINT  -- 186245 PM10 Offset,
  "n_186245_pm10_status" VARCHAR  -- 186245 PM10 Status,
  "n_187245_pm10_prescaled" DOUBLE  -- 187245 PM10 PreScaled,
  "n_187245_pm10_scaled" DOUBLE  -- 187245 PM10 Scaled,
  "n_187245_pm10_unit" VARCHAR  -- 187245 PM10 Unit,
  "n_187245_pm10_slope" BIGINT  -- 187245 PM10 Slope,
  "n_187245_pm10_offset" BIGINT  -- 187245 PM10 Offset,
  "n_187245_pm10_status" VARCHAR  -- 187245 PM10 Status,
  "n_188245_pm10_prescaled" DOUBLE  -- 188245 PM10 PreScaled,
  "n_188245_pm10_scaled" DOUBLE  -- 188245 PM10 Scaled,
  "n_188245_pm10_unit" VARCHAR  -- 188245 PM10 Unit,
  "n_188245_pm10_slope" BIGINT  -- 188245 PM10 Slope,
  "n_188245_pm10_offset" BIGINT  -- 188245 PM10 Offset,
  "n_188245_pm10_status" VARCHAR  -- 188245 PM10 Status,
  "n_189245_pm10_prescaled" DOUBLE  -- 189245 PM10 PreScaled,
  "n_189245_pm10_scaled" DOUBLE  -- 189245 PM10 Scaled,
  "n_189245_pm10_unit" VARCHAR  -- 189245 PM10 Unit,
  "n_189245_pm10_slope" DOUBLE  -- 189245 PM10 Slope,
  "n_189245_pm10_offset" DOUBLE  -- 189245 PM10 Offset,
  "n_189245_pm10_status" VARCHAR  -- 189245 PM10 Status,
  "n_292245_pm10_prescaled" DOUBLE  -- 292245 PM10 PreScaled,
  "n_292245_pm10_scaled" DOUBLE  -- 292245 PM10 Scaled,
  "n_292245_pm10_unit" VARCHAR  -- 292245 PM10 Unit,
  "n_292245_pm10_slope" DOUBLE  -- 292245 PM10 Slope,
  "n_292245_pm10_offset" DOUBLE  -- 292245 PM10 Offset,
  "n_292245_pm10_status" VARCHAR  -- 292245 PM10 Status,
  "unnamed_50" VARCHAR  -- Unnamed: 50
);

Mill Road Air Quality: PM 2.5

@ukgov.mill_road_cambridge_monitoring_air_quality.mill_road_air_quality_pm_2_5

303.53 kB
2,702 rows
63 columns

CREATE TABLE mill_road_air_quality_pm_2_5 (
  "timebeginning" TIMESTAMP,
  "timeending" TIMESTAMP,
  "n_183245_pm2_5_prescaled" DOUBLE  -- 183245 PM2.5 PreScaled,
  "n_183245_pm2_5_scaled" DOUBLE  -- 183245 PM2.5 Scaled,
  "n_183245_pm2_5_unit" VARCHAR  -- 183245 PM2.5 Unit,
  "n_183245_pm2_5_slope" BIGINT  -- 183245 PM2.5 Slope,
  "n_183245_pm2_5_offset" BIGINT  -- 183245 PM2.5 Offset,
  "n_183245_pm2_5_status" VARCHAR  -- 183245 PM2.5 Status,
  "n_184245_pm2_5_prescaled" DOUBLE  -- 184245 PM2.5 PreScaled,
  "n_184245_pm2_5_scaled" DOUBLE  -- 184245 PM2.5 Scaled,
  "n_184245_pm2_5_unit" VARCHAR  -- 184245 PM2.5 Unit,
  "n_184245_pm2_5_slope" BIGINT  -- 184245 PM2.5 Slope,
  "n_184245_pm2_5_offset" BIGINT  -- 184245 PM2.5 Offset,
  "n_184245_pm2_5_status" VARCHAR  -- 184245 PM2.5 Status,
  "n_185245_pm2_5_prescaled" DOUBLE  -- 185245 PM2.5 PreScaled,
  "n_185245_pm2_5_scaled" DOUBLE  -- 185245 PM2.5 Scaled,
  "n_185245_pm2_5_unit" VARCHAR  -- 185245 PM2.5 Unit,
  "n_185245_pm2_5_slope" BIGINT  -- 185245 PM2.5 Slope,
  "n_185245_pm2_5_offset" BIGINT  -- 185245 PM2.5 Offset,
  "n_185245_pm2_5_status" VARCHAR  -- 185245 PM2.5 Status,
  "n_186245_pm2_5_prescaled" DOUBLE  -- 186245 PM2.5 PreScaled,
  "n_186245_pm2_5_scaled" DOUBLE  -- 186245 PM2.5 Scaled,
  "n_186245_pm2_5_unit" VARCHAR  -- 186245 PM2.5 Unit,
  "n_186245_pm2_5_slope" BIGINT  -- 186245 PM2.5 Slope,
  "n_186245_pm2_5_offset" BIGINT  -- 186245 PM2.5 Offset,
  "n_186245_pm2_5_status" VARCHAR  -- 186245 PM2.5 Status,
  "n_187245_pm2_5_prescaled" DOUBLE  -- 187245 PM2.5 PreScaled,
  "n_187245_pm2_5_scaled" DOUBLE  -- 187245 PM2.5 Scaled,
  "n_187245_pm2_5_unit" VARCHAR  -- 187245 PM2.5 Unit,
  "n_187245_pm2_5_slope" BIGINT  -- 187245 PM2.5 Slope,
  "n_187245_pm2_5_offset" BIGINT  -- 187245 PM2.5 Offset,
  "n_187245_pm2_5_status" VARCHAR  -- 187245 PM2.5 Status,
  "n_188245_pm2_5_prescaled" DOUBLE  -- 188245 PM2.5 PreScaled,
  "n_188245_pm2_5_scaled" DOUBLE  -- 188245 PM2.5 Scaled,
  "n_188245_pm2_5_unit" VARCHAR  -- 188245 PM2.5 Unit,
  "n_188245_pm2_5_slope" BIGINT  -- 188245 PM2.5 Slope,
  "n_188245_pm2_5_offset" BIGINT  -- 188245 PM2.5 Offset,
  "n_188245_pm2_5_status" VARCHAR  -- 188245 PM2.5 Status,
  "n_189245_no2_prescaled" DOUBLE  -- 189245 NO2 PreScaled,
  "n_189245_no2_scaled" DOUBLE  -- 189245 NO2 Scaled,
  "n_189245_no2_unit" VARCHAR  -- 189245 NO2 Unit,
  "n_189245_no2_slope" DOUBLE  -- 189245 NO2 Slope,
  "n_189245_no2_offset" DOUBLE  -- 189245 NO2 Offset,
  "n_189245_no2_status" VARCHAR  -- 189245 NO2 Status,
  "n_189245_pm10_prescaled" DOUBLE  -- 189245 PM10 PreScaled,
  "n_189245_pm10_scaled" DOUBLE  -- 189245 PM10 Scaled,
  "n_189245_pm10_unit" VARCHAR  -- 189245 PM10 Unit,
  "n_189245_pm10_slope" DOUBLE  -- 189245 PM10 Slope,
  "n_189245_pm10_offset" DOUBLE  -- 189245 PM10 Offset,
  "n_189245_pm10_status" VARCHAR  -- 189245 PM10 Status,
  "n_189245_pm2_5_prescaled" DOUBLE  -- 189245 PM2.5 PreScaled,
  "n_189245_pm2_5_scaled" DOUBLE  -- 189245 PM2.5 Scaled,
  "n_189245_pm2_5_unit" VARCHAR  -- 189245 PM2.5 Unit,
  "n_189245_pm2_5_slope" DOUBLE  -- 189245 PM2.5 Slope,
  "n_189245_pm2_5_offset" DOUBLE  -- 189245 PM2.5 Offset,
  "n_189245_pm2_5_status" VARCHAR  -- 189245 PM2.5 Status,
  "n_292245_pm2_5_prescaled" DOUBLE  -- 292245 PM2.5 PreScaled,
  "n_292245_pm2_5_scaled" DOUBLE  -- 292245 PM2.5 Scaled,
  "n_292245_pm2_5_unit" VARCHAR  -- 292245 PM2.5 Unit,
  "n_292245_pm2_5_slope" DOUBLE  -- 292245 PM2.5 Slope,
  "n_292245_pm2_5_offset" DOUBLE  -- 292245 PM2.5 Offset,
  "n_292245_pm2_5_status" VARCHAR  -- 292245 PM2.5 Status,
  "unnamed_62" VARCHAR  -- Unnamed: 62
);

Mill Road Trial: Sensor Point Location

@ukgov.mill_road_cambridge_monitoring_air_quality.mill_road_trial_sensor_point_location

6.01 kB
8 rows
7 columns

CREATE TABLE mill_road_trial_sensor_point_location (
  "monitor" BIGINT,
  "name" VARCHAR,
  "serial_number" BIGINT,
  "easting" BIGINT,
  "northing" BIGINT,
  "longitude" DOUBLE,
  "latitude" DOUBLE
);