Data Management System for the National Energy-Water System (NEWS) Assessment Framework

Wednesday, 16 December 2015
Poster Hall (Moscone South)
Alex Prousevitch1, Fabio Corsi2, Stanley Glidden1, Michael Piasecki3, Paul Celicourt4, Ariel Miara5, Balazs M Fekete4 and Charles J Vorosmarty6, (1)University of New Hampshire, Earth Systems Research Center, Institute for the Study of Earth, Ocean, and Space, Durham, NH, United States, (2)CUNY City College, Department of Civil Engineering, New York, NY, United States, (3)University of Michigan Ann Arbor, Ann Arbor, MI, United States, (4)CUNY City College of New York, New York, NY, United States, (5)CUNY City College, Environmental Crossroads Initiative, New York, NY, United States, (6)CCNY-Environ Crossroads Initi, New York, NY, United States
Aiming at providing a comprehensive assessment of the water-energy nexus, the National Energy-Water System (NEWS) project requires the integration of data to support a modeling framework that links climate, hydrological, power production, transmission, and economical models. Large amounts of Georeferenced data has to be streamed to the components of the inter-disciplinary model to explore future challenges and tradeoffs in the US power production, based on climate scenarios, power plant locations and technologies, available water resources, ecosystem sustainability, and economic demand.

We used open source and in-house build software components to build a system that addresses two major data challenges:

  1. On-the-fly re-projection, re-gridding, interpolation, extrapolation, nodata patching, merging, temporal and spatial aggregation, of static and time series datasets in virtually any file formats and file structures, and any geographic extent for the models I/O, directly at run time;
  2. Comprehensive data management based on metadata cataloguing and discovery in repositories utilizing the MAGIC Table (Manipulation and Geographic Inquiry Control database). This innovative concept allows models to access data on-the-fly by data ID, irrespective of file path, file structure, file format and regardless its GIS specifications.

In addition, a web-based information and computational system is being developed to control the I/O of spatially distributed Earth system, climate, and hydrological, power grid, and economical data flow within the NEWS framework. The system allows scenario building, data exploration, visualization, querying, and manipulation any loaded gridded, point, and vector polygon dataset.

The system has demonstrated its potential for applications in other fields of Earth science modeling, education, and outreach. Over time, this implementation of the system will provide near real-time assessment of various current and future scenarios of the water-energy nexus.