Dataset: Air Quality Data - Brisbane CBD

About this Dataset

Air Quality Data - Brisbane CBD

Context

Brisbane CBD 2017 hourly air quality and meteorological data

Content

Period of operation: 1 January to 31 December 2017
Site location: Latitude: -27.4774; Longitude: 153.0281
AS/NZS 3580.1.1 site classification: Neighbourhood
AS/NZS 3580.1.1 compliance (pollutants): Complies, except for:

Equipment located in room on sixth floor of building.
Nephelometer inlet located on eastern side of building, 1 metre out from building.
PM10 inlet located on building roof above equipment room, 1 metre above roof surface.
Building lift shaft higher than PM10 inlet located 8 metres south of inlet.
AS/NZS 3580.14 compliance (meteorology): Complies, with exceptions:

Building lift shaft higher than wind sensor and within 10 metres of sensor.
Buildings higher than wind sensor located within 40 metres of sensor.
Wind: Ultrasonic sensor

Height above roof level: 4 metres.
The wind direction sensor is aligned to magnetic north. The reported wind direction is referenced to true north by application of a magnetic declination correction of +11 degrees to the sensor output value.
Temperature: Capacitive ceramic sensor

Height above roof level: 4 metres.
Relative humidity: Capacitive thin film polymer sensor

Height above roof level: 4 metres
Rainfall: Vaisala RAINCAP® precipitation sensor

Height above roof level: 4 metres
Barometric pressure: Capacitive silicon sensor

Height above roof level: 4 metres
PM10: Tapered Element Oscillating Balance (TEOM) Model 1405-F fitted with Filter Dynamics Measurement System operated in accordance with AS/NZS 3580.9.16

The FDMS system compensates for the loss of semi-volatile components from the collected particulate matter.
Reported concentrations are uncorrected instrument output values.
The reported PM10 concentrations are calculated from running 1-hour average concentrations updated at six minute intervals.
Negative hourly PM10 concentrations down to -5 µg/m^3 resulting from instrument noise at low particle concentrations are reported.
Visibility-reducing particles: Nephelometer operated in accordance with AS/NZS 3580.12.1

Detector spectral response centred at 530 nm.
Instrument output offset and/or scaled based on calibration and daily zero/span response data.

Acknowledgements

Open Data Australia

Inspiration

Analyse the air quality of a metropolitan city in Australian State of Queensland

Tables

Brisbanecbdaq2017

@kaggle.kkhandekar_air_quality_data_brisbane_cbd.brisbanecbdaq2017

103.33 KB
8760 rows
12 columns


CREATE TABLE brisbanecbdaq2017 (
  "date" TIMESTAMP,
  "time" VARCHAR,
  "wind_direction_degtn" DOUBLE,
  "wind_speed_m_s" DOUBLE,
  "wind_sigma_theta_deg" DOUBLE,
  "wind_speed_std_dev_m_s" DOUBLE,
  "air_temperature_degc" DOUBLE,
  "relative_humidity" DOUBLE,
  "rainfall_mm" DOUBLE,
  "barometric_pressure_hpa" DOUBLE,
  "pm10_ug_m_3" DOUBLE,
  "visibility_reducing_particles_mm_1" DOUBLE
);