Japan Geoscience Union Meeting 2018

Presentation information

[JJ] Oral

A (Atmospheric and Hydrospheric Sciences) » A-CG Complex & General

[A-CG45] Adaptation for climate change and social implementation

Mon. May 21, 2018 9:00 AM - 10:30 AM 301B (3F International Conference Hall, Makuhari Messe)

convener:Yoichi Ishikawa(JAPAN Agency for Marine-Earth Science and Technology), Shingo Watanabe(Japan Agency for Marine-Earth Science and Technology), KOJI DAIRAKU(防災科学技術研究所), Chairperson:Ishikawa Yoichi(JAPAN Agency for Marine-Earth Science and Technology), Watanabe Shingo(海洋研究開発機構), DAIRAKU KOJI(National Research Institute for Earth Science and Disaster Resilience)

9:45 AM - 10:00 AM

[ACG45-04] Development of a database system for SI-CAT climate experiments

*YUJIN NAKAGAWA1, Shintaro Kawahara1, Fumiaki Araki1, Daisuke Matsuoka1, Yoichi Ishikawa1, Mikiko Fujita1, Shiori Sugimoto1, Yasuko Okada1, Sho Kawazoe1, Shingo Watanabe1, Masayoshi Ishii2, Ryo Mizuta2, Akihiko Murata2, Hiroaki Kawase2 (1.Japan Agency for Marine-Earth Science and Technology, 2.Meteorological Research Institute)

Keywords:Climate Change, Relational Database

Analyses of large ensemble data are quite useful in order to produce probabilistic effect projection of climate change. Ensemble data of “+2K future climate simulations” are currently produced by Japanese national project “Social Implementation Program on Climate Change Adaptation Technology (SI-CAT)” as a part of a database for Policy Decision making for Future climate change (d4PDF; Mizuta et al. 2016) produced by Program for Risk Information on Climate Change. Those data consist of global warming simulations and regional downscaling simulations. Considering that those data volumes are too large (a few petabyte) to download to a local computer of users, a user-friendly system is required to search and download data which satisfy requests of the users.

We develop “a database system for SI-CAT climate experiments” (SI-CAT DBS) for providing functions to find necessary data for the users. The SI-CAT DBS mainly consists of a relational database, a data download function and user interface. The relational database using PostgreSQL is a key function among them. Temporally and spatially compressed data are registered on the relational database. As a first step, we developed the relational database for precipitation, temperature and track data of typhoon according to requests by SI-CAT members. The data download function provides a function to download temporally and spatially extracted data based on search results obtained by the relational database. We also develop the web-based user interface for using the relational database and the data download function. The SI-CAT DBS is currently in operational test on a server maintained by Data Integration and Analysis System Program (DIAS).

The SI-CAT DBS will be released on DIAS in fiscal year 2018. Techniques of the database system for near-future climate change projections might be quite useful for simulation and observational data in other research fields. We report current status of development and some case studies of the SI-CAT DBS.