[M-GI30] Earth and planetary informatics with huge data management

[MGI30-P04] Development of tools to detect downtime during research cruise

*Yasuko Yamagishi¹, Kazuhiko Kashiwase¹, Tetsuji Maki¹, Masanobu Yanagitani¹, Ken Yatsu¹ (1.Japan Agency for Marine-Earth Science and Technology)

Japan Agency for Marine-Earth Science and Technology (JAMSTEC) owns five research vessels and is responsible for their operations. The most important task in operating the research vessels is the annual planning of their cruises. In order to provide useful information when planning a cruise, we have collected data on past cruises and have developed a database system to store the compiled data. Almost all cruises have periods of downtime, when the cruise or observation is interrupted by rough weather or instrument failure, or other causes. Research cruises should be planned to minimize downtime. Information on downtime for past cruises is also stored in the database. It is in reports via emails sent daily from vessels underway to the operations department on the ground. Therefore, we read these emails and manually collected information on downtime to store them into the database system, which was very expensive in terms of human cost. In order to reduce human costs, a tool was first developed to generate the reports and send them as emails from the vessels underway. The tool generates the reports and simultaneously outputs the contents of the emails as an Excel table. Next, a tool was developed to generate time-series data on vessel movements and operations from this Excel file and to detect downtime from the generated time-series data. With these tools, the collection of information on past cruise downtime could be partially automated. On the other hand, the database also contains basic information about the cruise, such as the name of the cruise, the chief researcher, the target survey area, the used research vehicles, etc. These are described in the cruise plan prepared by the chief scientist. Since the documents are written freely by the chief scientist and the contents in the documents are not in data format, this information must also be read and collected manually. In the near future, JAMSTEC's research cruise operations management division plans to introduce a comprehensive management application for research cruises, including a tool to create these cruise planning documents. In this study, we introduce the tools developed to collect information on downtime of past research cruises. In addition we will describe our vision for cooperation with the management application for research cruises.