Name: Air Quality Data - Brisbane CBD
Creator: Kaggle
License: https://creativecommons.org/licenses/by/4.0/

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

105.81 kB
8,760 rows
12 columns

CREATE TABLE brisbanecbdaq2017 (
  "date" TIMESTAMP,
  "time" VARCHAR,
  "wind_direction_degtn" DOUBLE  -- Wind Direction (degTN),
  "wind_speed_m_s" DOUBLE  -- Wind Speed (m/s),
  "wind_sigma_theta_deg" DOUBLE  -- Wind Sigma Theta (deg),
  "wind_speed_std_dev_m_s" DOUBLE  -- Wind Speed Std Dev (m/s),
  "air_temperature_degc" DOUBLE  -- Air Temperature (degC),
  "relative_humidity" DOUBLE  -- Relative Humidity (%),
  "rainfall_mm" DOUBLE  -- Rainfall (mm),
  "barometric_pressure_hpa" DOUBLE  -- Barometric Pressure (hPa),
  "pm10_ug_m_3" DOUBLE  -- PM10 (ug/m^3),
  "visibility_reducing_particles_mm_1" DOUBLE  -- Visibility-reducing Particles (Mm^-1)
);