ACEWATER2 Regional database: hydro-climatology data-analysis

The report presents the architecture of a regional hydro-climatology information system, developed in the framework of the ACEWATER2 project, in order to support effective organization of information. Information includes both freely available large and regional scale data sources, as well as databases compiled by the CoEs (Centers of Excellence) and submitted as part of their scientific undertakings. The information system builds upon and specializes the JRC knowledge sharing platform Aquaknow (https://aquaknow.jrc.ec.europa.eu/), including: • at the system core, a relational database; its schema has been designed to store both detailed metadata and, where relevant (avoiding duplication of information otherwise accessible), data themselves. Metadata include, among others, datasets extended description, spatial extent, temporal frequency, reference Institutions/authors, credits and limitations, web links to access original data and/or any further documentation. Data can be stored as public or private, depending upon confidentialy and sharing policies; • user friendly facilities, supporting the end user in efficiently browsing, querying, uploading and downloading information (metadata and data). System access is limited to accredited audience, via password authentication. Dedicated groups for the three ACEWATER CoE networks (Western, Southern and Central-Eastern Africa) have been setup and scientists invited to register. Currently the system is operational and we submitted databases documented and, depending upon confidentiality and authorization issues, also stored. A general review and classification of freely available information at continenal, regional and local scale of interest to ACEWATER2 project, and particularly to selected study areas (Senegal, Gambia and Niger; Zambezi; Blue Nile and Lake Victoria), have been completed. Metadata and, where relevant, data themselves have been stored to the information system database. Information submitted by the CoE (a continuous ongoing process) is migrated to the database as well, depending upon sharing authorization and/or limitations. The report also documents the ongoing scientific research at JRC on climate variability analysis based on L-Moments statistics. In particular maps of estimated precipitation deficit for different return periods at the river basins of interest are presented and included in the database.JRC.D.2-Water and Marine Resource