About this Dataset

River Flooding - Cities And FUAs

This dataset provides indicators of population and built-up exposure to river floods.

Data sources and methodology

River flooding indicators use the River Flood Hazard Maps at European and Global Scales datasets (Dottori, F. et al., 2021), which provide the extent of river floods for different return periods (10 to 100 years). A return period corresponds to the estimated time interval between floods of similar intensity. For OECD countries located in Europe and the Mediterranean Basin, the regional 250-metre resolution map was used. For the remaining OECD countries, the global map with a spatial granularity of 1 km was used. Built-up area exposure to river floods is computed by intersecting this map with Copernius annual land cover data (Copernicus Climate Change Service, Climate Data Store, 2019) and population exposure is computed using the Global Human Settlement Population layer (European Commission, GHSL Data Package 2023).

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 (River flooding - 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_river_flood_v1_1.observations

389.82 kB
300,936 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" BIGINT
);