Open Weather Data Winner: RainMiner Environmental and Public Health Protection Weather & Environment Meteorology Innovations and Inspirations The Vaisala Open Weather Data Challenge competition challenged students and professionals to come up with creative and innovative ways to utilize open weather data. RainMiner, a concept developed by Mounir Ennenbach and Paulina Concha Larrauri, won the competition. Below, Mounir and Paulina talk about the concept and their participation in the Vaisala Open Weather Data Challenge. We found out about the Vaisala Challenge by surfing the internet for potential job openings. With graduation fast approaching, Mounir was trying to get his life together. While searching for jobs in the wind sector – he was working on wind energy forecasting for a class at the time – he stumbled upon the Vaisala Weather Challenge. The competition was in line with our research at the Water Center, so we decided to apply, and three days later, we had a submission ready. "With RainMiner, we wanted before we to create a rainwater harvesting "diagnosis" tool to assess the potential of rainwater harvesting in a particular location." Of course, the idea of the RainMiner came to life before we had heard about Vaisala's Weather challenge, back in September 2015. As part of our research at the Columbia Water Center, we seek to find solutions for the world's current water issues. In the United States, issues associated with aging water infrastructure have made us question what future water systems should look like. Within this framework, we believe that one of the viable solutions could be to rely more on the use of decentralized water systems. Rainfall in many places, particularly in large cities, usually goes directly down the drain. In places like Mexico City where water scarcity is a growing issue, the plentiful local rainfall could be used to partially cover the demand of millions of people, while reducing the stress of big, centralized systems that pump water from long distances at a high cost. With RainMiner, we wanted to create a rainwater harvesting "diagnosis" tool to assess the potential of rainwater harvesting in a particular location. The basic data we needed was a local precipitation time series (from stations or gridded data), demographic information, water demand estimations and available roof areas. Estimating the Potential Water Resource Our first goal was to estimate the water resource potential for each of the approximately 3,000 counties in the contiguous US. Daily precipitation data was obtained through the IRI/LDEO data library, and represented gridded data at a 0.5ox0.5o resolution. Due to the interpolation mechanism used by NOAA in creating this dataset, there were significant errors, especially in the percentage of days with measurable precipitation. In order to build an accurate model that generates synthetic rainfall series reflecting true weather patterns, we came up with a deconvolution algorithm that reduced the error, to nearly 0% in many cases. The deconvolution algorithm was developed and optimized by comparing daily rainfall data from actual stations – obtained from KNMI explorer – with gridded precipitation. Once the data was "cleaned up", we used a mass-balance algorithm, including water recycling, to estimate the reliability of RWH systems across the United States. The rainfall generator enabled us to bootstrap the data, resulting in more reliable estimates of the actual water resource potential. We then expanded the analysis to create interactive rainwater harvesting diagnosis tools for Mexico and Brazil; we called this the RainMiner. The data and the platform we used (RShiny) are all open-source. Mounir Ennenbach grew up in Jordan, the third-poorest country in terms of per-capita water resources. At the age of 12, he began recording daily precipitation values for six consecutive winters outside his home, setting off a passion for data-driven science that would lead him to study Earth and Environmental Engineering at Columbia University. His research has focused on environmental applications of computer programming, specifically synthetic rainfall generation and deconvolution algorithms for spatially interpolated gridded data. Paulina Concha Larrauri is originally from Guanajuato Mexico, a place with severe aquifer stress, and she has been interested in water since an early stage of her life. She got her master's degree in Environmental Engineering from Columbia University in New York and for the past three years she has been a full time researcher at the Columbia Water Center.