About this Dataset

Drought - Cities And FUAs

This dataset provides regional statistics on estimate of soil moisture anomaly, in Functional Urban Areas (FUAs) and Cities.

Data sources and methodology

Drought intensity is here estimated in terms of soil moisture anomaly compared to the reference period 1981-2010. Soil moisture refers to the volume of water in the top soil layer (0 to 7 cm). This dataset provides annual soil moisture estimates in percentage points, along with changes in soil moisture. The data is based on ERA5-Land reanalysis dataset.

Defining FUAs and cities

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:

A city – defined by urban centres in the degree of urbanisation, adapted to the closest local administrative units to define a city.
A commuting zone – including all local areas where at least 15% of employed residents work in the city.

The delineation process includes:

Assigning municipalities surrounded by a single FUA to that FUA.
Excluding non-contiguous municipalities.

The definition identifies 1 285 FUAs and 1 402 cities in all OECD member countries except Costa Rica and three accession countries.

Cite this dataset

OECD Regions, cities and local areas database (Drought - Cities and FUAs), http://oe.cd/geostats

Further information

For questions and/or comments, please email CitiesStat@oecd.org

Tables

Observations

@oecd.oecd_cfe_eds_dsd_fua_clim_df_drought_v1_2.observations

191.32 kB
118,228 rows
13 columns

CREATE TABLE observations (
  "dataflow" VARCHAR,
  "ref_area" VARCHAR,
  "freq" VARCHAR,
  "measure" VARCHAR,
  "unit_measure" VARCHAR,
  "ret_period" VARCHAR,
  "heat_stress" VARCHAR,
  "territorial_level" VARCHAR,
  "time_period" BIGINT,
  "obs_value" DOUBLE,
  "obs_status" VARCHAR,
  "unit_mult" BIGINT,
  "decimals" VARCHAR
);