DOI: 10.6084/m9.figshare.13135727
title: Metadata record for the manuscript: Water scarcity will constrain the formation of a world-class megalopolis in North China

description: <b>Summary</b> This metadata record provides details of the data supporting the claims of the related manuscript: “Water scarcity will constrain the formation of a world-class megalopolis in North China”. The data consist of 15 Excel .xlsx format data files. The related study investigated the water challenge the water-scarce Beijing-Tianjin-Hebei (BTH) region faces under China’s goal of developing it into a world-class megalopolis, and the effects of the main water conservation measures in the region towards the goal. <b>Data access</b> The data generated and analysed during the related study are publicly available as part of this data record. The 15 Excel files are listed below, along with the names of the figures and supplementary tables from the manuscript that each file supports in square brackets.<b>1-Economic growth &Water use: </b>This table provides the data of GDP and water use in the BTH region and existing world-class megalopolises (2017). The data sources include United States Geological Survey, The Great Lakes Regional Water Use Database, Statistics of Tokyo, Eurostat, and National Bureau of Statistics of China. [Figure 1] <b>2-The BTH economic and water resource conditions:</b> This table provides the city-level data of the economic and water resource conditions in the BTH region (2017). The data sources include China Statistical Yearbook, Hebei Economic Yearbook, and Water Resources Bulletin of Beijing, Tianjin, and Hebei. [Figure 2 and Supplementary Table 4] <b>3-Water gaps: </b>This table provides the data of water gaps for the BTH region to achieve the two benchmarking goals. The data in the column of ‘Minimum water requirement’ are from model simulation and the data in the column of ‘Average water resources’ are calculated based on official data from China Statistical Yearbook. Water gaps are obtained by subtracting the latter from the former. [Figure 3] <b>4-GDP comparison: </b>This table provides the GDP data of the BTH region and the existing world-class megalopolises. BTH region’s maximum GDP data are from model simulation and the rest of the GDP data are officially released data. The data sources include Bureau of Economic Analysis, Eurostat, Tokyo Statistical Yearbook, and China Statistical Yearbook. [Figure 4] <b>5-Measure effects: </b>This table provides the data of the effects of the applications of water conservation measures. The data in the column of ‘Minimum water requirement’ are from model simulation and the data in the column of ‘The BTH annual average water resources’ are calculated based on official data from China Statistical Yearbook. ‘Water saved by the measures’ are obtained by subtracting the ‘minimum water requirement’ of each measure from the ‘minimum water requirement’ of ‘No conservation measure applied’. [Figure 5] <b>6-Water gaps_four-city-excluded: </b>This table provides the data of the water gaps for the four-city-excluded BTH region to achieve the two benchmarking goals. The data are from model simulation, in which four cities (Handan, Xingtai, Hengshui and Cangzhou) are excluded from the BTH region. [Figure 6] <b>7- Economic size : </b>This table provides the GDP data of the BTH region and the six world-class megalopolises (2017). The data sources include Bureau of Economic Analysis, Eurostat, Statistics of Tokyo, National Bureau of Statistics of China. The exchange rate between USD and CNY is based on the averaged central parity rate of year 2017 released by the People's Bank of China. [Supplementary Table 1] <b>8- Industrial structure :</b> This table provides the data of the industrial structure of the BTH cities (2017). The data are provided by Hebei Provincial Bureau of Statistics and National Bureau of Statistics of China. [Supplementary Table 2] <b>9- Trade data : </b>This table provides the data of the total trade of the BTH cities with their trade partners. The data are calculated based on inter-city input-output table of the BTH region (2012). Total trade value is the summation of the bilateral trade amount between the BTH cities and their trade partners. The exchange rate between USD and CNY is based on the averaged central parity rate of year 2012 released by the People's Bank of China. [Supplementary Table 3] <b>10- Indicators for benchmarks: </b>This table provides the data of representing indicators as criteria for the BTH region's goal of being a world-class megalopolis in model settings. The data are obtained from National Bureau of Statistics of China, Shanghai Bureau of Statistics, Zhejiang provincial Bureau of Statistics, Jiangsu provincial Bureau of Statistics, Bureau of Economic Analysis, and Great Lakes Maritime Research Institute. [Supplementary Table 5] <b>11- Objective of water use efficiency: </b>This table provides the data of water control objective for improving water use efficiency in the BTH region. The Data Sources include: 1) The People’s Government of Beijing Municipality. Beijing Water Development Plan for 'the 13th Five-Year Plan' Period, (2016-7-8). 2) Tianjin Municipal People’s Government. Tianjin Action Plan for Dual Control of Total Water Consumption and Intensity for ‘the 13th Five-Year Plan' Period, (2017-3-30). 3) The People’s Government of Hebei Province. Hebei Implementation Plan for Dual Control of Total Water Consumption and Intensity 2016-2020, (2017-3-7). [Supplementary Table 6] <b>12-SNWTP water use:</b> This table provides the data of the SNWTP water use in the water intake cities of the BTH region (2018). The data are provided by Water Transfer Management Office in Department of Water Resources of Hebei Province. [Supplementary Table 7] <b>13- Macroeconomic parameter comparison_provincial level:</b> This table provides the key macroeconomic parameters at provincial level. The data sources include Beijing Municipal Bureau of Statistics, Tianjin Municipal Bureau of Statistics and Hebei Provincial Bureau of Statistics. [Supplementary Table 8] <b>14- Macroeconomic parameter comparison_city level:</b> This table provides the key macroeconomic parameters at city level. The data are provided by National Bureau of Statistics of China and Hebei Provincial Bureau of Statistics. [Supplementary Table 9]<b>15- Water parameter comparison_city level: </b>This table provides the key water use related parameters at city level. The data are provided by Beijing Water Authority, Tianjin Water Authority, and Department of Water Resources of Hebei Province. [Supplementary Table 10]