This README.txt file provides details on the dataset and is generated by Lishan Ran (Department of Geography, HKU) ------------------- GENERAL INFORMATION ------------------- 1. This is the dataset for our research on assessing CO2 emissions from Chinese inland waters. 2. Contact information Lishan Ran (Dr) Department of Geography, The University of Hong Kong Email:lsran@hku.hk --------------------- DATA DESCRIPTION --------------------- This dataset includes four parts. They are Part 1: Lakes and Reservoirs_1980s, Part 2: CO2 Dataset_2010s, Part 3: Water chemistry records, and Part 4: A script 'mapEdit' developed in C# for delineating river networks and lakes/reservoirs. Detailed information on the four parts are provided below. ------------ Part 1: Lakes and Reservoirs_1980s This file includes two sheets, namely 'Lake' and 'Reservoir'. The 'Lake' sheet includes the lakes with surface area larger than 1 km2 in China in the 1980s. The 'Reservoir' sheet includes the major reservoirs in China constructed by the 1980s. For the Sheet named 'Lake': Column A: Lake code Column B: Lake name Comumn C: Longtitude of the lake location Column D: Latitde of the lake location Column E: Location of the lake (in which province?) Comumn F: Water surface area in km2 For the Sheet named 'Reservoir': Column A: Name of reservoir Column B: Location of the reservoir (in which province?) Column C: Longtitude of the reservoir location Column D: Latitde of the reservoir location Column E: Drainage area of upstream catchment in km2 Column F: Year of construction Column G: Water surface area in km2 Column H: Data source ------------ Part 2: CO2 Dataset_2010s This file compiles the collected CO2 emission measurements from the literature. There are three sheets in this file, including 'River', 'Lake & Reservoir' and 'Reference'. For the Sheet named 'River': Column A: Data source Column B: Name of the river sampled Column C: Location of the river Column D: Sampling date Column E: Latitude of the sampling site Column F: Longitude of the sampling site Column G: Elevation of the sampling site in m Column H: Stream order of the sampling site Column I: Annum precipitaiton in mm Column J: pH Column K: Water temperature in degrees Celsius Column L: Dissolved organic carbon in mg/L Column M: Dissolved inorganic carbon in mg/L Column N: CO2 partial pressure (pCO2) in the dry season in µatm Column O: CO2 partial pressure (pCO2) in the wet season in µatm Column P: CO2 emissions in the dry season in mmol/m^2/d Column Q: CO2 emissions in the wet season in mmol/m^2/d For the Sheet named 'Lake & Reservoir': Column A: Data source Column B: Name of lake or reservoir Column C: Sampling date Column D: Latitude of the sampling site Column E: Longitude of the sampling site Column F: Water surface in km2 Column G: pH Column H: Water temperaturein degrees Celsius Column I: Dissolved organic carbon in mg/L Column J: Dissolved inorganic carbon in mg/L Column K: CO2 partial pressure (pCO2) in the dry season in µatm Column L: CO2 partial pressure (pCO2) in the wet season in µatm Column M: CO2 emissions in the dry season in mmol/m^2/d Column N: CO2 emissions in the wet season in mmol/m^2/d For the Sheet named 'Reference': Column A: Detailed information of the data source ------------ Part 3: Water chemistry records This part includes the retrieved water chemistry records for major river catchments in China. Except the fisrt sheet 'CATALOG1' which includes the sampling sites and their location (longitude and latitude), there are another 1757 sheets with each representing a gauge-based sampling site. Detailed information is provided below. For the first Sheet named 'CATALOG1': Column A: Name of the sampling site Column B: Longitude of the sampling site Column C: Latitude of the sampling site Column D: Notes (groundwater sampling sites are highlighted in yellow) Note: By double-clicking the name of the sampling site (Column A), the water chemistry records for the site of concern will be automatically opened. For the remaining sheets showing the water chemistry records: Column A: Year Column B: Sampling date (e.g., 1.1 represents January 1st, and 3.15 represents March 15th) Column C: Flow discharge in m3/s Column D: Water temperaturein degrees Celsius Column E: Dissolved CO2 concentration in mg/L Column F: pH Column G: Concentration of carbonate ion (CO3--) in mg/L Column H: Concentration of bicarbonate ion (HCO3-) in mg/L Column I: Total alkalinity in meq/L Note: The sybmol '-' or '—' indicates missing values. ------------ Part 4: The script 'mapEdit' (zip file): By using this code, we divided inland water bodies into three categories: rivers (including artificial ditches), natural lakes, and artificial reservoirs, as it is extremely difficult to accurately identify the three types of water bodies by only using computer algorithms. The script was developed in C# to assist the classification, and visual interpretation, if necessary, was used to reduce misclassification errors. The human-computer interaction application also integrated high-resolution satellite images and electronic maps of China. Using this application, we could display the shape and location of each water body as well as its corresponding high-resolution satellite base map or electronic map side by side. By comparing such reference information, our GIS technicians were able to determine the type of each water body. After classification, attributes of the water bodies, such as location, surface area and name, were added into the dataset for further analysis. To launch the app, this app requires the following components: (1) Visual studio 2010; (2) DevExpress 15.2 (trail version); (3) ArcGIS Engine Developer Kit 10.0.0; (4) ArcObjects SDK (.NET) 10.0.0 --------END--------