Air Pollution - Cities And FUAs
OECD dataset from agency OECD.CFE.EDS: DSD_FUA_ENV@DF_POLLUTION (2021 - 2023)
@oecd.oecd_cfe_eds_dsd_fua_env_df_pollution_v1_2
OECD dataset from agency OECD.CFE.EDS: DSD_FUA_ENV@DF_POLLUTION (2021 - 2023)
@oecd.oecd_cfe_eds_dsd_fua_env_df_pollution_v1_2
This dataset provides indicators of PM2.5, PM10 (particulate matter), ozone and nitrogen dioxide air pollution in FUAs and cities.
Air pollution indicators use PlumLabs ( “Plume Labs by AccuWeather: Accurate Historical, Live, and Forecast Air Quality Data.” Plume Labs by AccuWeather: Accurate Historical, Live, and Forecast Air Quality Data, plumelabs.com/en/forecast-api/) gridded data. The available 0.1° by 0.1° resolution grids provide the estimated mean concentration of PM2.5, PM10, ozone and nitrogen dioxide. Indicators provide an estimate of the population-weighted average pollutant concentration and the share of the population living in areas where pollutant concentrations exceed World Health Organization guidelines (5 μg/m³ for PM2.5, 15 μg/m³ for PM10, 60 μg/m³ for ozone, and 10 μg/m³ for nitrogen dioxide).
The OECD, in cooperation with the EU, has developed a harmonised definition of functional urban areas (FUAs) to capture the economic and functional reach of cities based on daily commuting patterns (OECD, 2012). FUAs consist of:
The delineation process includes:
The definition identifies 1 285 FUAs and 1 402 cities in all OECD member countries except Costa Rica and three accession countries.
OECD Regions, cities and local areas database (Air pollution - Cities and FUAs), http://oe.cd/geostats
For questions and/or comments, please email CitiesStat@oecd.org
CREATE TABLE observations (
"dataflow" VARCHAR,
"ref_area" VARCHAR,
"freq" VARCHAR,
"measure" VARCHAR,
"unit_measure" VARCHAR,
"pollutant_concentration" VARCHAR,
"time_season" VARCHAR,
"territorial_level" VARCHAR,
"time_period" BIGINT,
"obs_value" DOUBLE,
"obs_status" VARCHAR,
"unit_mult" BIGINT,
"decimals" BIGINT
);Anyone who has the link will be able to view this.