Dataset: Mill Road Cambridge: Monitoring Air Quality

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 Trial: Sensor Point Location

@ukgov.mill_road_cambridge_monitoring_air_quality.mill_road_trial_sensor_point_location

5.87 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
);

Mill Road Air Quality: PM 2.5

@ukgov.mill_road_cambridge_monitoring_air_quality.mill_road_air_quality_pm_2_5

296.42 KB
2702 rows
63 columns


CREATE TABLE mill_road_air_quality_pm_2_5 (
  "timebeginning" TIMESTAMP,
  "timeending" TIMESTAMP,
  "n_183245_pm2_5_prescaled" DOUBLE,
  "n_183245_pm2_5_scaled" DOUBLE,
  "n_183245_pm2_5_unit" VARCHAR,
  "n_183245_pm2_5_slope" BIGINT,
  "n_183245_pm2_5_offset" BIGINT,
  "n_183245_pm2_5_status" VARCHAR,
  "n_184245_pm2_5_prescaled" DOUBLE,
  "n_184245_pm2_5_scaled" DOUBLE,
  "n_184245_pm2_5_unit" VARCHAR,
  "n_184245_pm2_5_slope" BIGINT,
  "n_184245_pm2_5_offset" BIGINT,
  "n_184245_pm2_5_status" VARCHAR,
  "n_185245_pm2_5_prescaled" DOUBLE,
  "n_185245_pm2_5_scaled" DOUBLE,
  "n_185245_pm2_5_unit" VARCHAR,
  "n_185245_pm2_5_slope" BIGINT,
  "n_185245_pm2_5_offset" BIGINT,
  "n_185245_pm2_5_status" VARCHAR,
  "n_186245_pm2_5_prescaled" DOUBLE,
  "n_186245_pm2_5_scaled" DOUBLE,
  "n_186245_pm2_5_unit" VARCHAR,
  "n_186245_pm2_5_slope" BIGINT,
  "n_186245_pm2_5_offset" BIGINT,
  "n_186245_pm2_5_status" VARCHAR,
  "n_187245_pm2_5_prescaled" DOUBLE,
  "n_187245_pm2_5_scaled" DOUBLE,
  "n_187245_pm2_5_unit" VARCHAR,
  "n_187245_pm2_5_slope" BIGINT,
  "n_187245_pm2_5_offset" BIGINT,
  "n_187245_pm2_5_status" VARCHAR,
  "n_188245_pm2_5_prescaled" DOUBLE,
  "n_188245_pm2_5_scaled" DOUBLE,
  "n_188245_pm2_5_unit" VARCHAR,
  "n_188245_pm2_5_slope" BIGINT,
  "n_188245_pm2_5_offset" BIGINT,
  "n_188245_pm2_5_status" VARCHAR,
  "n_189245_no2_prescaled" DOUBLE,
  "n_189245_no2_scaled" DOUBLE,
  "n_189245_no2_unit" VARCHAR,
  "n_189245_no2_slope" DOUBLE,
  "n_189245_no2_offset" DOUBLE,
  "n_189245_no2_status" VARCHAR,
  "n_189245_pm10_prescaled" DOUBLE,
  "n_189245_pm10_scaled" DOUBLE,
  "n_189245_pm10_unit" VARCHAR,
  "n_189245_pm10_slope" DOUBLE,
  "n_189245_pm10_offset" DOUBLE,
  "n_189245_pm10_status" VARCHAR,
  "n_189245_pm2_5_prescaled" DOUBLE,
  "n_189245_pm2_5_scaled" DOUBLE,
  "n_189245_pm2_5_unit" VARCHAR,
  "n_189245_pm2_5_slope" DOUBLE,
  "n_189245_pm2_5_offset" DOUBLE,
  "n_189245_pm2_5_status" VARCHAR,
  "n_292245_pm2_5_prescaled" DOUBLE,
  "n_292245_pm2_5_scaled" DOUBLE,
  "n_292245_pm2_5_unit" VARCHAR,
  "n_292245_pm2_5_slope" DOUBLE,
  "n_292245_pm2_5_offset" DOUBLE,
  "n_292245_pm2_5_status" VARCHAR,
  "unnamed_62" VARCHAR
);

Mill Road Air Quality NO2

@ukgov.mill_road_cambridge_monitoring_air_quality.mill_road_air_quality_no2

288.6 KB
2702 rows
50 columns


CREATE TABLE mill_road_air_quality_no2 (
  "timebeginning" VARCHAR,
  "timeending" VARCHAR,
  "n_183245_no2_prescaled" DOUBLE,
  "n_183245_no2_scaled" DOUBLE,
  "n_183245_no2_unit" VARCHAR,
  "n_183245_no2_slope" BIGINT,
  "n_183245_no2_offset" BIGINT,
  "n_183245_no2_status" VARCHAR,
  "n_184245_no2_prescaled" DOUBLE,
  "n_184245_no2_scaled" DOUBLE,
  "n_184245_no2_unit" VARCHAR,
  "n_184245_no2_slope" BIGINT,
  "n_184245_no2_offset" BIGINT,
  "n_184245_no2_status" VARCHAR,
  "n_185245_no2_prescaled" DOUBLE,
  "n_185245_no2_scaled" DOUBLE,
  "n_185245_no2_unit" VARCHAR,
  "n_185245_no2_slope" BIGINT,
  "n_185245_no2_offset" BIGINT,
  "n_185245_no2_status" VARCHAR,
  "n_186245_no2_prescaled" DOUBLE,
  "n_186245_no2_scaled" DOUBLE,
  "n_186245_no2_unit" VARCHAR,
  "n_186245_no2_slope" BIGINT,
  "n_186245_no2_offset" BIGINT,
  "n_186245_no2_status" VARCHAR,
  "n_187245_no2_prescaled" DOUBLE,
  "n_187245_no2_scaled" DOUBLE,
  "n_187245_no2_unit" VARCHAR,
  "n_187245_no2_slope" BIGINT,
  "n_187245_no2_offset" BIGINT,
  "n_187245_no2_status" VARCHAR,
  "n_188245_no2_prescaled" DOUBLE,
  "n_188245_no2_scaled" DOUBLE,
  "n_188245_no2_unit" VARCHAR,
  "n_188245_no2_slope" BIGINT,
  "n_188245_no2_offset" BIGINT,
  "n_188245_no2_status" VARCHAR,
  "n_189245_no2_prescaled" DOUBLE,
  "n_189245_no2_scaled" DOUBLE,
  "n_189245_no2_unit" VARCHAR,
  "n_189245_no2_slope" DOUBLE,
  "n_189245_no2_offset" DOUBLE,
  "n_189245_no2_status" VARCHAR,
  "n_292245_no2_prescaled" DOUBLE,
  "n_292245_no2_scaled" DOUBLE,
  "n_292245_no2_unit" VARCHAR,
  "n_292245_no2_slope" DOUBLE,
  "n_292245_no2_offset" DOUBLE,
  "n_292245_no2_status" VARCHAR
);

Mill Road Air Quality: PM 10

@ukgov.mill_road_cambridge_monitoring_air_quality.mill_road_air_quality_pm_10

291.08 KB
2702 rows
51 columns


CREATE TABLE mill_road_air_quality_pm_10 (
  "timebeginning" TIMESTAMP,
  "timeending" TIMESTAMP,
  "n_183245_pm10_prescaled" DOUBLE,
  "n_183245_pm10_scaled" DOUBLE,
  "n_183245_pm10_unit" VARCHAR,
  "n_183245_pm10_slope" BIGINT,
  "n_183245_pm10_offset" BIGINT,
  "n_183245_pm10_status" VARCHAR,
  "n_184245_pm10_prescaled" DOUBLE,
  "n_184245_pm10_scaled" DOUBLE,
  "n_184245_pm10_unit" VARCHAR,
  "n_184245_pm10_slope" BIGINT,
  "n_184245_pm10_offset" BIGINT,
  "n_184245_pm10_status" VARCHAR,
  "n_185245_pm10_prescaled" DOUBLE,
  "n_185245_pm10_scaled" DOUBLE,
  "n_185245_pm10_unit" VARCHAR,
  "n_185245_pm10_slope" BIGINT,
  "n_185245_pm10_offset" BIGINT,
  "n_185245_pm10_status" VARCHAR,
  "n_186245_pm10_prescaled" DOUBLE,
  "n_186245_pm10_scaled" DOUBLE,
  "n_186245_pm10_unit" VARCHAR,
  "n_186245_pm10_slope" BIGINT,
  "n_186245_pm10_offset" BIGINT,
  "n_186245_pm10_status" VARCHAR,
  "n_187245_pm10_prescaled" DOUBLE,
  "n_187245_pm10_scaled" DOUBLE,
  "n_187245_pm10_unit" VARCHAR,
  "n_187245_pm10_slope" BIGINT,
  "n_187245_pm10_offset" BIGINT,
  "n_187245_pm10_status" VARCHAR,
  "n_188245_pm10_prescaled" DOUBLE,
  "n_188245_pm10_scaled" DOUBLE,
  "n_188245_pm10_unit" VARCHAR,
  "n_188245_pm10_slope" BIGINT,
  "n_188245_pm10_offset" BIGINT,
  "n_188245_pm10_status" VARCHAR,
  "n_189245_pm10_prescaled" DOUBLE,
  "n_189245_pm10_scaled" DOUBLE,
  "n_189245_pm10_unit" VARCHAR,
  "n_189245_pm10_slope" DOUBLE,
  "n_189245_pm10_offset" DOUBLE,
  "n_189245_pm10_status" VARCHAR,
  "n_292245_pm10_prescaled" DOUBLE,
  "n_292245_pm10_scaled" DOUBLE,
  "n_292245_pm10_unit" VARCHAR,
  "n_292245_pm10_slope" DOUBLE,
  "n_292245_pm10_offset" DOUBLE,
  "n_292245_pm10_status" VARCHAR,
  "unnamed_50" VARCHAR
);