-- MySQL dump 10.13  Distrib 5.7.28, for Win64 (x86_64)
--
-- Host: localhost    Database: db_data4iwrm
-- ------------------------------------------------------
-- Server version	5.7.28

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `t`
--

DROP TABLE IF EXISTS `t`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t`
--

LOCK TABLES `t` WRITE;
/*!40000 ALTER TABLE `t` DISABLE KEYS */;
/*!40000 ALTER TABLE `t` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_dmcase`
--

DROP TABLE IF EXISTS `t_dmcase`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dmcase` (
  `DMCCODE` int(11) NOT NULL AUTO_INCREMENT,
  `DMCLACODE` varchar(2) DEFAULT 'EN',
  `DMCPURPCODE` int(11) DEFAULT NULL,
  `DMCSTEPCODE` int(11) DEFAULT NULL,
  `DMCPROGOUV` int(11) DEFAULT NULL,
  `DMCPRODAPROD` int(11) DEFAULT NULL,
  `DMCPRODAMAN` int(11) DEFAULT NULL,
  `DMCPROPROCES` int(11) DEFAULT NULL,
  `DMCPROINFDISS` int(11) DEFAULT NULL,
  `DMCDMTCODE` int(11) DEFAULT '1',
  `DMCADORCODE` varchar(16) DEFAULT 'AAORG00000001',
  `DMCADORNAME` varchar(80) DEFAULT NULL,
  `DMCNAME` varchar(240) DEFAULT NULL,
  `DMCAREA` varchar(80) DEFAULT NULL,
  `DMCYEARSTART` int(11) DEFAULT NULL,
  `DMCYEAREND` int(11) DEFAULT NULL,
  `DMCBACKER` varchar(80) DEFAULT NULL,
  `DMCCLIENT` varchar(80) DEFAULT NULL,
  `DMCDESC` mediumtext,
  `DMCTOOL` mediumtext,
  `DMCPRESURL` mediumtext,
  `DMCDOCSOURCE` varchar(200) DEFAULT NULL,
  `DMCIMA1URL` varchar(200) DEFAULT NULL,
  `DMCIMA1TITLE` varchar(200) DEFAULT NULL,
  `DMCIMA2URL` varchar(200) DEFAULT NULL,
  `DMCIMA2TITLE` varchar(200) DEFAULT NULL,
  `DMCAUTHNAME` varchar(200) DEFAULT NULL,
  `DMCAUTHEMAIL` varchar(100) DEFAULT NULL,
  `DMCAUTHADCOCODE` varchar(16) DEFAULT NULL,
  `DMCAUTHCOMM` mediumtext,
  `DMCLABVALID` int(11) DEFAULT '0',
  `DMCPERT` int(11) DEFAULT '0',
  `DMCDISSLEV` int(11) DEFAULT NULL,
  `DMCUPDATE` datetime NOT NULL,
  PRIMARY KEY (`DMCCODE`),
  KEY `FK_step_case` (`DMCSTEPCODE`),
  KEY `FK_purpose_case` (`DMCPURPCODE`),
  KEY `FK_tool_case` (`DMCDMTCODE`),
  KEY `fb_order_DMCYEARSTART_INDEX` (`DMCYEARSTART`),
  KEY `fb_order_DMCNAME_INDEX` (`DMCNAME`(10)),
  KEY `fb_order_DMCUPDATE_INDEX` (`DMCUPDATE`),
  CONSTRAINT `FK_purpose_case` FOREIGN KEY (`DMCPURPCODE`) REFERENCES `t_dmpurpose` (`DMPCODE`) ON UPDATE CASCADE,
  CONSTRAINT `FK_step_case` FOREIGN KEY (`DMCSTEPCODE`) REFERENCES `t_dmstep` (`DMSCODE`) ON UPDATE CASCADE,
  CONSTRAINT `FK_tool_case` FOREIGN KEY (`DMCDMTCODE`) REFERENCES `t_dmtool` (`DMTCODE`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_dmcase`
--

LOCK TABLES `t_dmcase` WRITE;
/*!40000 ALTER TABLE `t_dmcase` DISABLE KEYS */;
INSERT INTO `t_dmcase` VALUES (2,'EN',2000,23000,1,0,0,0,0,1,'FRORG00006891',NULL,'Defining a potential water data governance organisational scheme in Moldova','Moldova',2014,2014,'SDC/ Moldova','Ministry of Environment','More than twenty years after the break-up of the Soviet Union, the Republic of Moldova is still facing considerable challenges and remains one of the poorest countries in Europe.\r\nAfter more than 13 years of contribution to the development of innovative decentralized water supply and sanitation models and in order to specify its new Cooperation Strategy for Moldova 2014/17, SDC selected IOWater for analysing the situation and presenting recommendations in order to support the country for developing an integrated water resource management approach as well as its national Water information System.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'HAENER Paul',NULL,'AECTC00000001',NULL,0,0,0,'1970-01-01 00:00:00'),(6,'EN',2000,23000,0,0,0,0,0,1,'AAORG00000001','IOWater','Toward the sharing of water related data in the frame of an Euro-mediterranean water information system (EMWIS)','Euro mediterranean countries',1996,NULL,'EU','EMWIS','The overall objective is to share knowledge and to promote international environmental governance. The specific objectives are to contribute to setting up a Mediterranean water information system compatible with WISE and to develop the Med Joint Process. \r\nThe project activities planned are:\r\n- 	Water data harminonisation in 2 pilot countries (Jordan and Tunisia) using the water accounts approach defined the the UNSD and promoted by MedSat Environment programme. \r\n- 	Setting up a Mediterranean map server providing special references on hydrological networks (river bains, rivers, lakes, etc.) in Med countries, using formats compatible with the standards used by the European Environment Agency and the JRC fro WISE\r\n- 	Enriching of the existing multilingual water thesaurus (Arabic, English, French, Greek, Italian, Spanish and Turkish) with concepts specific to the Arabic culture and H2020 vocabulary. The thesaurus is already compatible with GEMET and is accessible from the EEA web site. \r\n- 	Contribution to the Med Joint Process EUWI / WFD on  « waster scarcity and drought » and « water monitoring »\r\n- 	Contribution to H2020 monitoring working group\r\n- 	Reporting to the Water Expert Group to the Union for the Mediterranean','- 	Preparation of water data master plans with water data providers and users\r\n- 	Implementation of an online map server based on spatial data provided by MPC\r\n- 	Support to Med Joint process working groups on « waster scarcity and drought » and « water monitoring »: coordination, web space, electronic forums, mailing lists, workshops, information collection, collaborative electronic workspace \r\n- 	Identification of national water data sources for H2020 monitoring based on the metadata catalogue and outputs of the water monitoring working gourp\r\n-	Implementationof an online water thesaurus and electronic forum for its improvement\r\n- 	Organisation of steeing group meeting and coordination with the preparation of the Mediteernean water Strategy','www.emwis.org#http://www.emwis.org#',NULL,NULL,NULL,NULL,NULL,'HAENER Paul','p.haener@oieau.fr',NULL,NULL,NULL,0,0,'1970-01-01 00:00:00'),(7,'EN',8000,23000,1,0,0,0,0,1,'AAORG00000001','IOWAter','Definition and implementation of procedures for water-related data exchange in relation to the activities of the Multilateral Working Group on Water Resources in the Middle East peace process.','Middle east',1996,1996,'EU',NULL,'Within the framework of the Middle East Peace Process, IOWater contributed in preliminary studies and in several assignments leading to the creation of the Exact Group (Execution Action Team), a group which  still coordinates many works related to water data management in the Middle East.\r\n\r\nIOWater also participated, as representative of the French Ministry for Foreign Affairs, in \'\'Multilateral Water\" meetings.','Contribution in the definition and implementation of procedures for water-related data exchange in relation to the activities of the Multilateral Working Group on Water Resources in the Middle East peace process :\r\n  - Participation in the initial mission for assessing the existing water data in Israel, Jordan and Occupied Territories ;\r\n  - Organisation of a study tour in France for Israelian, Jordanian and Palestinian experts ;\r\n  - Participation in the activities of the Coordination Committee ( EXACT) of Middle East Water Data Bank Implementation Plan actually financed by : \r\n    .  The European Union (2 million Ecu); \r\n    .  USA (nearly 2 million $); France (contribution to the activities of coordination and reinforcement of monitoring networks through a FFEM project  under study) ;\r\n    .  Canada.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'1970-01-01 00:00:00'),(9,'EN',4100,50000,0,0,1,1,1,18,'AAORG00000001',NULL,'Hydrology - Flood simulation: Generation of a Flood in a Rapid Basin (Gard)','France',2002,NULL,NULL,NULL,'The studied case is a disastrous hydrometeorological event that occured on Septembre 8-9, 2002 in the Cévènnes-Vivarais region of the Southern France. The hydrological instrumentation monitoring network of the Cévènnes-Vivarais region covers the three main river basins: the Gardon basin at Ners (1,090km²), the Cèze basin at Bagnols sur Cèze (1,110km²) and the Ardèche basin at Sauze Saint-Martin (2,240km²). Throughout the duration of this episode, the Gardons as a whole received an accumulation of 300mm of precipitation, with 200mm for the Cèze and around 100mm for the Ardèche.','19 stations hydrométriques ont pu être utilisés pour l\'étude présentée ici: 7 pour la rivière Ardèche, 6 pour la Gardons ans 6 pour la Cèze. Les champs de pluies ont été obtenus pour chaque heure par krigeage du réseau de pluviomètres disponibles avec une résolution spatiale de 50km².\r\nLa région des Cévènnes-Vivarais a été divisée en 90 sous-bassins d\'environ 50km². Une version du modèle de TOPMODEL a été appliquée à chacun de ces 90 mailles hydrologiques afin d\'obtenir sa propre valeur pour la pluie, les caractéristiques hydrodynamiques du sol, la vitesse de propagation hydraulique et son état ??initial. Les TOPMODELs calculent deux \r\nLes illustrations présentés ci-dessous montrent le comportement du modèle pour  : - le bassin qui reçoit la majorité desprécipitations (les Gardons) et celui qui en a reçu le moins (l\'Ardèche). - une diversité dans la taille des bassins, classés de 100km² à 2000km².',NULL,'Practival Applications in Engineering - J.M. Tanguy',NULL,NULL,NULL,NULL,'P. HAENER','p.haener@oieau.fr',NULL,NULL,0,0,0,'1970-01-01 00:00:00'),(10,'EN',4100,50000,0,0,1,1,1,24,'AAORG00000001',NULL,'Forecasting a flood in a branched network (Aude)','France',1999,NULL,NULL,NULL,'The Aude river basin at Moussoulens reaches flow rates of up to 4,840km². This basin has witnessed several catastrophic floods over the last ten years The case presented is that oh the real-time forecast of the flow rate through the Moussoulens station. This station is strongly influenced by the intermediate contributions generated by the Orbieu, which flows','Données hydrométriquesEn raison de la variabilité des temps de propagation, il a été décidé de calibrer plusieurs relations linéaires des débits augmentés type entre trois stations: cinq relations linéaires ont été choisis pour représenter au mieux les 15 inondations calibrés depuis 1990\r\nCes cinq relations linéaires ont été regroupées dans une procédure multi-modèle.\r\nToutes les demi-heures, la procédure multi-modèle  fournit des prévisions avec des simulations sur des périodes de trois et cinq heures à la station de Moussoulens. Ces données peuvent être observées sur la plateforme SOPHIE en fonction de la profondeur ou la vitesse d\'écoulement et comparées aux observations.',NULL,'Practival Applications in Engineering - J.M. Tanguy',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,'2016-07-28 00:00:00'),(17,'EN',2000,22000,1,0,0,0,0,1,'AAORG00000001',NULL,'National master plan on water data management (SNDE) adopted in France','France',2009,NULL,'FRANCE','ONEMA','The decree n° 2009-1543 signed by the 1st Minister specifies that: \n- the technical frame of reference of the national Water Information System, mentioned in the decree n°2007-443 and developed by the “Office national de l’eau et des milieux aquatiques “, consists of a national master plan on water data (SNDE) with annexed technical documents;\n- \"Any person wishing to participate in the establishment of the information system on water must meet the technical frame of reference. \'\'\n- This SNDE specifies:\no The objectives, the scope and the modalities of governance; \no Collection procedures, conservation and dissemination of data and indicators; \no The terms of implementation of these procedures; \no The modalities for the preparation of methodologies and the frame of reference of data and services that these procedure must follow to ensure their interoperability;\no Detailed rules for the exchange of data with other systems of information not fully included in the perimeter of the water information system\n','/','http://www.eaufrance.fr/documents/?id_article=829',NULL,NULL,NULL,NULL,NULL,'HAENER Paul - International Office for Water - France','ph@oieau.fr',NULL,'Description to be validated by ONEMA representative',0,0,1,'2016-07-28 00:00:00'),(19,'EN',2400,50000,0,0,0,1,1,1,'AAORG00000001',NULL,'Pilot Arno Water Accounts','Italy / Arno River Basin',2014,2015,'EC DG Env','Arno River Basin Authority ','During this pilot action, an overall approach and tools were developed using the SEEA-Water – System of Environmental-Economic Accounting for Water- for\r\ni) improving the knowledge on water resources available in the Arno River basin and their use within or outside the basin; \r\nii) assessing the potential impact of management, technological and economical measures to reduce the vulnerability of the territory against water scarcity and drought.\r\n\r\nWater accounts have been prepared on a monthly basis for the period 1993–2013, and considering development and climate change-based scenarios, simulations have been processed to define and evaluate the optimal water saving measures for the Arno River Basin Management Plan.\r\n\r\nA participatory approach was applied to each activity through the organisation of Stakeholder Workshops and regular concertation meetings with local stakeholders and data providers, in particular concerning data collection, estimations, validations, and measures assessment. \r\n\r\nA Visual Basic Application for MS-Excel was produced by the PAWA Consortium to automatically compile the SEEA-Water “Physical Use & Supply” tables (PSUAT) and the “Asset Account” tables. This tool was useful, and it will be useful for the future application, to perform the compilation of tables and the production of thematic graphs, in a quick and reliable way, directly using the data stored in the PAWA geo-referenced database (which can be easily updated) that was developed and populated for the project activities. The PAWA tool can be also used to support water decision-makers to find the best combination of measures to be implemented in the different territories, in order to reach specific water saving targets. In the future, economical assessment of measures implementation should be added as it is an important criterion for planning.\r\n\r\nThe water account approach together with prospective scenarios based on the application of a set of measures and various climate change hypotheses allowed the assessment of their potential impact compared to a reference situation (i.e., without applying any measure). Thus, the SEEA-Water tables appear to be a good decision support tool to define the most suitable water efficiency measures for a selected area. As the SEEA-Water tables do not take into account e-flows, such requirement can be considered during the optimisation of measures process by defining a specific target for the Water Exploitation Index Plus (WEI+) (which was set below 40% in the case of the simulation done for PAWA).\r\n\r\nThis pilot action was carried out during 15 months by ISPRA – Institute for Environmental Protection and Research , ARBA – Arno River Basin Authority and EMWIS TU – Technical Unit of Euro-Mediterranean Information System on know how in the Water Sector. ','* metadata calatogue for inventory of data from different stakeholders\r\n* geo-database for data compilation and harmonisation\r\n* dedicated MS-Excel application for compiling SEEA-Water “Physical Use & Supply” tables, processing scenarios and building graphs and indicators\r\n* local water models: Mobidic (for water balance) and modflow (for ground water)','http://pawa.emwis.net','PAWA final brochure','/images/studycase/D4I-form_PAWA_Case-study_v20160905_1.PNG','PAWA pilot areas','/images/studycase/D4I-form_PAWA_Case-study_v20160905_2.PNG','Exemple of PAWA indicators','Eric MINO (EMWIS) / Stefano Mariani (ISPRA) / Bernardo Mazzanti','e.mino@semide.org ; stefano.mariani@isprambiente.it;  b.mazzanti@adbarno.it',NULL,NULL,0,0,1,'2016-09-05 00:00:00'),(30,'EN',2000,50000,0,0,0,1,1,1,'AAORG00000001',NULL,'Key insights and lessons have emerged through the AQUASTAT programme over 20 years','World',1996,NULL,NULL,NULL,'The Source turned to the people behind the numbers at FAO-AQUASTAT, which for two decades has been collecting, analyzing and disseminating 180+ variables on water resources, water uses and agricultural management for 200+ countries. In the first of five segments, Marisha Wojciechowska-Shibuya interviews programme manager Karen Frenken about the challenges surrounding global data collection, and how to monitor of the SDGs. See link \n','/','http://www.thesourcemagazine.org/will-un-measure-monitor-sustainable-development-goal-6-water-sanitation/?utm_source=IWA-NET',NULL,'FAO',NULL,NULL,NULL,'Paul HAENER','p.haener@oieau.fr',NULL,'Interesting article underlying the for data collection on water resource and water uses',0,0,1,'2016-08-18 00:00:00'),(31,'EN',1000,50000,0,0,1,1,1,1,'AAORG00000001',NULL,'Project « UWWT SIIF »: a free tool for European countries to speed up the national sanitation data availability','European countries',2012,NULL,'European Commission',NULL,'In 2012, the “SIIF” concept (Structured Implementation and Information Framework), was introduced for the first time in a communication called “Improving the delivery of benefits from EU environment measures”. To demonstrate the added value of this concept before generalizing its application to all Directives, this communication suggested to apply it to the Directive 91/271/EEC of 21 May 1991 concerning urban waste-water treatment.\n \nSince 2012, the European Commission carries out a pilot program for the implementation of the “SIIF” concept to the Urban Waste-Water Treatment (UWWT) Directive, so as to speed up the availability of information for decision makers and for the general public, through the creation of a UWWT SIIF, Shared Information and Implementation Framework for sanitation.\n \n \nWhat purpose?\n \nThe speed up of availability of data and the improvement of its management by using interoperability are at the heart of the project, giving priority to the access and to a simple viewing of national data on sanitation. This way, SIIF contributes to improve the implementation of the UWWT Directive and to reduce the administrative burden, by automating and making easier this viewing and access, and permits also to meet efficiently the requirements of the INSPIRE Directive 2007/2/CE and Directive 2003/4/CE on public access to environmental information.\n \n','/','http://www.oieau.fr/iowater/our-projects-news-and-update/article/project-uwwt-siif-a-free-tool-for?lang=en','/','European Commission',NULL,NULL,NULL,'Paul HAENER','p.haener@oieau.fr',NULL,NULL,0,0,1,'2016-09-02 00:00:00'),(32,'EN',2000,60000,0,0,0,1,1,1,'AAORG00000001',NULL,'Resource center for the french community integrated water management actors','France',2002,NULL,'National 0ice of water and aquatic environments',NULL,'Gest’eau is a tool for the resource center of the french community integrated water management actors. This national website is dedicated to Water Development and Management Master Plan (SDAGE), to water development and management scheme (SAGE) and to environmental contract (river, bay and groundwater). It’s a reference website mentioned in several legal orders and circulars of the French Ministry for Ecology and Sustainable Development.\nGest’eau enables to get, besides information on each SAGE & environmental contracts, contour of boundaries, documents produced in the framework of each tool and at national scale; it also makes available some synthesis documents specifically written to meet the SAGE managers’ needs.\n\nCreated in 2002 by the International 0ice for Water (IOW), with the French Ministry for Ecology and Sustainable Development, it was first dedicated only to the SAGE. Then, in 2005, it was extended to the contracts & innovative restoration actions and to aquatic environment protection actions, and in 2010 to the River Basin Management Plan.\n\nApart from the definition of the different water integrated management tools (SDAGE, SAGE, environmental contracts), all the SAGE and environmental contracts are detailed on complete fact sheets. Gest\'eau allows to :\n- share information, knowledge and experience (news, articles, letters, documents, calendar, job listings, tools, methods, experiences, guides, studies, data repositories management, ...)\n- support stakeholders (web-conferences, training, ...),\n- federate the actors (forums, seminars, directory, ...).\n\n','- A national website dedicated to Water Development and Management Master Plan (SDAGE), to water development and management scheme (SAGE) and to environmental contract (river, bay and groundwater) www.gesteau.fr\n- Web-conferences','www.gesteau.fr',NULL,'International 0ice for Water',NULL,NULL,NULL,'International 0ice for Water - France','gesteau@oieau.fr',NULL,NULL,0,0,1,'2016-10-10 00:00:00'),(34,'EN',2000,21000,1,0,0,0,0,1,'AAORG00000001','ONEMA/AFB','Legislation related to the national Water Information System in France','France',1992,NULL,'ONEMA/AFB',NULL,'After an initial phase of development, which started in 1992 under the name of the National Network of Water Data (RNDE), and after various transitory decrees, the concept of the present national WIS was established by the Act on water and aquatic environments (LEMA) of 30 December 2006, L213-2. \r\nIn its article 88, the LEMA specifies that the “Office national de l’eau et des milieux aquatiques” (ONEMA, now integrated into the AFB), which is a state administrative institution, will among others:\r\n-	…\" ensure the implementation and technical coordination of an information system for the collection, conservation and dissemination of data on water, aquatic environments, their uses and distribution of water and sanitation utilities. Local authorities or their groupings are associated with their application to the constitution of this information system”.\r\nDecree n°2007-443 related to the ONEMA specifies in its article 1 that: “in relation with the information system, the AFB collects the data and indicators related to water, aquatic environments and their use and about water supply and sanitation utilities. It defines the technical frame of reference to enable interoperability of its components of collection, conservation and dissemination, and makes them available in conditions fixed by Decree”.\r\nDecree n° 2009-1543 signed by the Prime Minister specifies that: \r\n-	The technical frame of reference mentioned in the decree n°2007-443 and developed by the “Office national de l’eau et des milieux aquatiques“, consists of a national master plan on water data (SNDE) with annexed technical documents;\r\n-	\"Any person wishing to participate in the establishment of the information system on water must comply with the technical frame of reference.\'\'\r\n-	This SNDE specifies:\r\no	The objectives, scope and modalities of governance; \r\no	Collection procedures, conservation and dissemination of data and indicators; \r\no	The terms of implementation of these procedures; \r\no	The modalities for the preparation of methodologies and the frame of reference of data and services that these procedures must follow to ensure their interoperability;\r\no	Detailed rules for the exchange of data with other information systems not fully included in the perimeter of the water information system.','National Network of Water Data (RNDE)',NULL,'French Agency for Biodiversity – AFB','/images/studycase/eau-2.jpg',NULL,NULL,NULL,'French Agency for Biodiversity – AFB',NULL,NULL,NULL,0,0,NULL,'2018-11-16 00:00:00'),(35,'EN',2000,23000,1,0,0,0,0,1,'AAORG00000001','EMWIS','Analyse of the good conditions of water data governance in the case of national water information systems in the Mediterranean region','Euro mediterranean countries',2017,NULL,NULL,'Euro mediterranean countries','During a workshop organized in 2017 in the frame of EMWIS data management platform, it was considered that key elements for effective national water data governance are:\r\n- 	Confirming high-level political commitment to enhance cross-sectoral coordination, data sharing and joint information production for better water management. This political willingness is a key element to implement the governance structure necessary for developing and managing a water information system;\r\n- 	Positioning the importance of a water information system for efficient water management within the national water legislative framework, including sectoral coordination and definition of responsibilities with regard to cooperation and information sharing;\r\n- 	Formalizing the governance mechanism with a multi-stakeholder agreement, a Memorandum of Understanding or a regulatory text;\r\n- 	Ensuring broad agreement and commitment from all stakeholders by looking for win-win solutions at all stages of development as well as in the operation of the system;\r\n- 	Defining a multi-level governance structure, including strategic coordination, technical coordination and operational coordination from national to local level;\r\n-	Ensuring human and financial resources for the operation of the governance mechanism and the implementation of the water information system.\r\nThe strategic governance body is usually chaired by the minister in charge of water and brings together all ministries and agencies concerned by the water sector (environment, health, agriculture, industry, housing, finance, international cooperation), including representatives of river basin committees. It is responsible for:\r\n-	Defining priorities for the development of the WIS in order to respond to policy challenges;\r\n- 	Ensuring that the WIS is integrated into and contributes to cross-sectoral policy frameworks, such as climate change mitigation and adaptation strategy, administrative modernization, open public data, etc.;\r\n- 	Initiating when necessary new regulations enabling further development of the WIS, such as financing regulations; revising the role and competencies of public agencies to avoid overlaps while ensuring data production and sharing;\r\n- 	Reviewing WIS implementation progress and operation of the WIS \r\nThe technical governance body is chaired by the institution formally responsible for the water information system. It includes the technical department of the different ministries and agencies involved as well as scientific and research institutions and river basin agencies or regional entities in charge of water management. It is in charge of:\r\n- 	Ensuring communication among all stakeholders, including the user community;\r\n- 	Ensuring that the needs of all stakeholders are sufficiently addressed;\r\n- 	Setting up and running thematic working groups in charge of developing data exchange standards, reference data frameworks, guidance documents, and terms of references for the implementation of the system;\r\n-	Supervising WIS implementation and monitoring progress;\r\n-Coordinating reporting to the strategic governance body;\r\n-Operating the Water Information System and validating its results.\r\nThe local or river basin coordination body is usually chaired by the river basin organization or a regional entity in charge of water resources. It has the key role of data collection on the field and defining local operational needs in relation to water resources management as well as sectoral needs from local communities, e.g. agricultural sector, municipalities, industry, environment, transport, etc.','Key elements for effective national water data governance',NULL,'EMWIS',NULL,NULL,NULL,NULL,'EMWIS',NULL,NULL,NULL,0,0,NULL,'2018-11-16 00:00:00'),(38,'EN',1000,30000,0,1,0,1,1,1,'AAORG00000001','WHYCOS','The World Hydrological Cycle Observing System','World',1992,NULL,'World Meteorological Organization (WMO)',NULL,'Countries and basin organizations willing to develop their hydrological monitoring capacities can benefit from the support of WMO through the World Hydrological Cycle Observing System (WHYCOS) and its HYCOS projects. WHYCOS is a framework programme dedicated to strengthening hydrological observation activities, reinforcing international cooperation and promoting the free exchange of data in the field of hydrology. In 25 years, 12 projects were developed and around 500 measuring stations were installed. Yet, a new momentum is required to enhance the effectiveness of the HYCOS projects and ensure sustainability of the achievements. Accordingly, WMO launched in 2017 the Global Hydrometry Support Facility with the initial support of the Swiss government. Better known as the HydroHub, this facility aims to improve the full value chain from data collection to hydrological services through:\r\n•	Building on the WHYCOS experience to develop an efficient, innovative and sustainable framework to support operational systems in hydrometry in the world; \r\n•		Facilitating the operational uptake of innovative technologies by national services, including new technology, citizen science, better use of satellite products, low-cost devices, and information systems;\r\n•	Fostering the creation of a community of practice for operational hydrology to enhance information sharing and knowledge exchange;\r\n•	Promoting free and open data sharing with many stakeholders across communities;\r\n•	Bringing together actors from academia, public and private sectors to build benefit-sharing partnerships.\r\nHydrological data sharing will be facilitated through the development of WHOS Phase II, the new WMO Hydrological Observing System that aims to make hydrological data easily discoverable and accessible worldwide.\r\nThe WHYCOS framework aims to improve the efficiency and sustainability of the monitoring framework through:\r\n•	Better connection between data providers and all kinds of users, including political.\r\n•	Development of hydrological data services and products.\r\n•	A combination of different monitoring approaches and integration of data from different providers.\r\n•	Reinforced dedicated training and capacity building, including assessment of institutional and legal status of data provider organizations.\r\n•	A new financial model for HYCOS projects, including long-term maintenance and operation of stations.\r\n•	A reinforced open data policy.','The Global Hydrometry Support Facility with the initial support of the Swiss government. Better known as the HydroHub, this facility aims to improve the full value chain from data collection to hydrological services',NULL,'WMO',NULL,'Hydrologic data exchange by standardized service types and data formats in the Niger river basin',NULL,'Hydrologic data exchange by standardized service types and data formats in the Southern Africa',NULL,NULL,NULL,NULL,0,0,NULL,'2018-11-19 00:00:00'),(39,'EN',1000,30000,0,0,1,1,1,1,'AAORG00000001','GRDC','	Global Runoff Data Centre (GRDC)','World',1988,NULL,'World Meteorological Organization (WMO)','Earth science specialists','The Global Runoff Data Centre (GRDC) was created in 1988 at the German Federal Institute of Hydrology (BfG) under the auspices of the World Meteorological Organization (WMO). It is Germany’s contribution to the WMO’s Global Climate Observing System and Hydrology and Water Resources Programme.\r\nThe GRDC’s global base comprises a unique collection of data on river flows collected daily or monthly by over 9,400 stations in 160 countries. This represents over 410,000 station-years with an average record length of 43 years.\r\nThe GRDC archives international data over a 200-year period and encourages long-term hydrological studies. Its objective is to help earth science specialists analyze global climate trends, evaluate impacts and environmental risks, and assist the assessment of transboundary water resources.\r\nThe Centre manages several specialized databases, including the bases of the WMO Hydrology Commission and the Global Terrestrial Network for River Discharge (GTN-R) to support the Global Climate Observing System (GCOS) in evaluating freshwater flows into the sea. In addition, the GRDC offers products like GIS maps showing major basins and catchment area boundaries for over 7,000 GRDC stations.\r\nTo expand and update its database, the organization relies entirely on voluntary contributions from national hydrological services and related authorities responsible for monitoring flows. National hydrological services and basin authorities are encouraged to supply relevant data so that the GRDC can satisfy requests for flow-related data for non-commercial uses in science and research.','The GRDC’s global base comprises a unique collection of data on river flows collected daily or monthly by over 9,400 stations in 160 countries.',NULL,'Ulrich Looser',NULL,'9481 GRDC stations with monthly data',NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2018-11-19 00:00:00'),(40,'EN',3000,30000,0,1,0,0,0,1,'AAORG00000001',NULL,'	SWOT Satellite - Remote sensing programme','Africa',2016,NULL,'CNES',NULL,'The last 30 years have seen a sharp decline in hydrological databases around the world, particularly in Africa. Spatial altimetry makes it possible to complete the in situ measurement network in order to densify data and ensure better hydrological monitoring.\r\nThe Surface Water and Ocean Topography (SWOT) programme is a French-American Earth observation satellite with contributions from UKSA and CSA that by 2021 will monitor water level variations of major streams, such as lakes and rivers, estimate runoffs from rivers and monitor ocean levels.  The SWOT mission uses a new, as-yet untested technology: wide swath altimetry. This development constitutes a real technological breakthrough which aims to provide measurements with an unprecedented precision and to improve our understanding of the water cycle. Although SWOT is mainly a scientific satellite, it offers a great potential for the development of new applications and services with significant economic and societal impacts.\r\nAs part of the Future Investment Program, CNES* has set up a preparatory programme, the SWOT-Downstream programme. Its goal is to develop products tailored to end-users’ needs integrated into existing or future services, and to prepare water stakeholders for the use of these new data from space. In Hydrology, the SWOT-Downstream programme focuses on preparing the hydrology user community by sharing simulated SWOT datasets. It also shares multisensory hydrology derived products, such as soil moisture, water levels, land cover, etc., supports and promotes scientific work in space hydrology, and associates customers and service providers in the development of new applications. Most SWOT-Downstream activities will be gathered in a global “Water Database” portal (see figure below).\r\nA working group has been set up to demonstrate all the space data capabilities in hydrology. The Congo basin is the first pilot site. Applications in development include monitoring the Congo water level and discharge and forecasting navigation and hydropower capacity as well as a water information system. All of this work covering the Congo basin is financed by AFD and CNE.','The SWOT mission uses a new, as-yet untested technology: wide swath altimetry',NULL,'CNES France',NULL,'Space Water Database HYDROWEB NG',NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2018-11-20 00:00:00'),(41,'EN',1200,10000,0,0,1,1,1,1,'AAORG00000001',NULL,'Remote Sensing Based Agricultural Drought Monitoring and Yield Loss Prediction Method','Europe',1970,NULL,'ICPDR',NULL,'Multispectral remote sensing technology is widely used in agriculture and is appropriate for vegetation analysis. Vegetation has characteristic spectra, often showing characteristic absorption maxima or minima at particular wavelengths. Most vegetation indices are based on the sharp increase in reflectance from vegetation that occurs around 700 nm (the red-edge), a change that is characteristic of green vegetation and not found for most other natural surfaces that show relatively slow changes of reflectance with wavelength over this region [36]. In particular since 2002, new opportunities exist for producing better data for calculations thanks to the MODIS Aqua and Terra satellites, which provide free 36-band numbers, with 1-day repeating cycles and 250 to 500 m pixel size time series data sets. For agricultural water management today, remote sensing time series analysis (RS-TSA) is one of most important solutions for measuring agricultural droughts and their effects.\r\nThis case study, developed in the framework of ICPDR activities, aims to fill the knowledge gap in this field by developing agricultural drought-related decision parameters and applying them in practice from raw spectral datasets. Signaling levels of this activity, and free-of-charge available homogeneous remote sensing data (MODIS NDVI spectral indices) and land use (CORINE database) datasets, can be applied on national and Central and Eastern European scales.\r\nThe methods and databases explored include employment of remote sensing data on land use, as well as biomass production, soil characteristics for better integration and understanding of cropping patterns influenced by hydrology and soil types. Internationally available land use (CORINE database, topographic maps) remote sensing data, MODIS NDVI spectral indices, soil data (agro topographic map, soil water management properties, map of water management properties of soils), hydrology (soil water table), and digital elevation models have been processed and integrated to determine yield loss thresholds and soil water-holding capacities.','The methods and databases explored include employment of remote sensing data on land use, as well as biomass production, soil characteristics for better integration and understanding of cropping patterns influenced by hydrology and soil types.','http://isepei.org/case-studies/gwp-cee/remote-sensing-based-agricultural-drought-monitoring','ICPDR',NULL,'Main steps of the applied model',NULL,'Drought risk and signaling NDVI levels for maize and wheat',NULL,NULL,NULL,NULL,0,0,NULL,'2018-11-20 00:00:00'),(42,'EN',1200,30000,0,1,0,1,0,1,'AAORG00000001',NULL,'Acquisition of Non-Traditional Data through Local Involvement','Africa / Central Europe',1970,NULL,'Swiss Agency for Development and Cooperation',NULL,'An example of a large-scale, multi-year trial to collect data on water levels and discharges in small- to medium-scale canals as well as rivers in the context of dry land irrigation was carried out as part of the global iMoMo Initiative (www.imomohub.org). The latter was supported by the Swiss Agency for Development and Cooperation and was part of a drive for innovation in data acquisition, management and exchange, and an overview to help to address global water resource challenges in the context of population growth and increasing climate uncertainty. The device is currently in use in communities in Tanzania, Kyrgyzstan and Uzbekistan and is valued by local stakeholders because it allows incontrovertible water level readings and thus helps to ensure compliance with on-farm community-based water allocation rules.\r\nIn addition, an Android app for smartphones has been developed for measuring water levels and discharges based on an optical method that uses a mobile phone camera. The app provides a non-intrusive, accurate and cost-effective measurement method. The process of setting up a new site should ideally be conducted by experts and include measuring the cross-sectional area at maximum flow and the relative distances between four markers on both sides of the shoreline. Once a site is set up, even a non-expert can carry out a measurement in under a minute.  What is more, the App allows seamless data transmission to a dedicated cloud database via GSM/Wifi/SMS. The database can be accessed using a web application in a browser (see https://discharge.ch). The web application allows easy data visualization and data analysis. The app has been deployed in Tanzania, Uganda, Kenya and Ethiopia as well as in parts of Central Asia and is currently undergoing continued pilot testing in selected basins there.\r\nDespite the attractiveness of technologies such as those mentioned above, key lessons from the global iMoMo Initiative have shown that several important preconditions need to be in place for crowd-sensing campaigns to be successful in the sense that they can fill existing data gaps and thus help to improve stakeholders’ decision-making at different water resource management levels. As an example: 1/ clear visions need to be formulated by local stakeholders concerning the usage potential of non-traditional data; 2/ stakeholders from government agencies often show reluctance to promote and adopt these technologies due to non-compliance with national standards and agency underfunding; 3/ proper workflows need to be established, including data collection protocols; 4/ a stringent quality assurance and control process (QA/QC) needs to be put in place; 5/ a dedicated service should be made available to monitor data-collection efforts in a consistent fashion and chase up citizens who fail to deliver data as agreed.','Android app for smartphones','www.imomohub.org','Swiss Agency for Development and Cooperation',NULL,'Mirabs in Kyrgyzstan testing the SmartStick device for measuring water levels',NULL,'Measuring discharge of a small irrigation canal with 2 different smartphones in Tanzania for comparison','Dr. Tobias Siegfried, Robert Naudascher, (ydrosolutions Ltd.,) Oyture Anarbekov (IWMI-Central Asia Project Office)',NULL,NULL,NULL,0,0,NULL,'2018-11-21 00:00:00'),(43,'EN',2000,40000,0,0,1,0,0,1,'AAORG00000001',NULL,'Metadata catalogue for a collaborative inventory of data sources','Eastern Europe, Central Asia, Latin America, and South East Asia',1970,NULL,NULL,'National authorities','In the frame of various water resource management projects carried out in Eastern Europe, Central Asia, Latin America, and South East Asia, IOWater supports national authorities in developing their online metadata catalogue. Such a tool facilitates the inventory and description of available data sources and makes them easier to discover. After a configuration phase, the online tool is generally presented at the national data management workshops, and a specific password is given to each institution to allow them to capture online the descriptions of their data sources.','Online metadata catalogue',NULL,'IOWater',NULL,'Metadata catalogue Interface for data discovery',NULL,'Example of selection of a metadata sheet',NULL,NULL,NULL,NULL,0,0,NULL,'2018-11-21 00:00:00'),(44,'EN',2000,40000,0,0,1,0,0,1,'AAORG00000001','WMO','WMO approach in relation to data inventory','World',1970,NULL,'WMO','WMO Global Data Centres','Many hydrological studies and analyses require the availability of long time series. Experience shows that a significant amount of time within a project is dedicated to identifying, accessing and formatting appropriate datasets. Thus, it is strongly desirable to ease the data discovery process through data portals. Examples from academia are for instance the CUAHSI portal (Consortium of Universities for the Advancement of Hydrologic Science, Inc, https://www.cuahsi.org/data-models/portals/ ) which allows to publish datasets on a voluntary base. The GEOSS platform of the Group on Earth Observations can also be cited.\r\nThe WMO Commission of Hydrology is developing the new phase of the WMO Hydrological Observing System WHOS as the hydrological contribution to the WMO Integrated Global Observing System (WIGOS), the over-arching general framework for the coordination and optimized evolution of all WMO observing systems. In its current version, WHOS is a simple pointer system, a map interface that allows access to available datasets of national hydrological services which open their data (http://www.wmo.int/pages/prog/hwrp/chy/whos/index.php ). However, discovering and downloading data, and making use of them for an intended purpose can still be tedious as metadata are not easily available and data formats may be different; furthermore the national web portal may be in languages not familiar to the user. In its next version, WHOS should provide users with a user-friendly brokering system that allows easy discovery and download capacities of existing historical and real-time data, from national services and from other acknowledged sources. It will be a fully WIS/WIGOS-compliant, services-oriented framework linking hydrologic data providers and users through a hydrologic information system enabling data registration, data discovery, and data access. A primary concern of WMO being data quality assessment, quality checks and meta information will build trust in the datasets.\r\nLong time series of historical data are gathered and distributed by WMO Global Data Centres such as the Global Runoff Data Centre for Surface Runoff, hosted by Germany, the International Groundwater Assessment Centre hosted by the Netherlands and especially its Global Groundwater Network (GGMN) for Groundwater and the Hydrology of Lakes and Reservoirs (HYDROLARE) Centre, hosted by the Russian Federation.\r\nThese WMO Global Data Centres fulfil the following main duties:\r\n- Collect and provide hydrological time series with database management systems\r\n- Contribute to data rescue\r\n- Support data collection efforts and data management projects\r\n- Coordinate and disseminate information about national data holdings and about the conditions of data access, data quality and meta-information\r\n- Supply data for scientific and educational purposes, modelling, development','WHOS is a simple pointer system, a map interface that allows access to available datasets of national hydrological services which open their data','http://www.wmo.int/pages/prog/hwrp/chy/whos/index.php','The WMO Commission of Hydrology',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2018-11-21 00:00:00'),(45,'EN',2000,40000,0,0,0,0,0,1,'AAORG00000001','USGS Water Data for the Nation','Use of WaterML 2.0 by the United States Geological Survey (USGS)','United States',1970,NULL,NULL,'USA','This case study illustrates advanced data provision using WaterML 2.0 and other methods by the USGS, providing a freely available instantaneous values service providing access to streamflow and other real-time data from thousands of US monitoring stations, as well as a daily values service and groundwater levels service over the Internet. In March 2014, support for provision of time series data in the WaterML 2.0 format was added to these services.\r\nThis data is used for water resource management, monitoring floods and droughts, bridge design and for many recreational activities. Through its National Water Information Service (NWIS - USGS Water Data for the Nation. http://waterdata.usgs.gov/nwis), USGS provides summary reports, maps, statistics and other information via the Internet as well as the data services designed for machine-to-machine access via automated tools. These 24/7/365 operational services provide access to streamflow, water level and other data from over 50,000 surface water and 800,000 groundwater monitoring stations across the USA.  More than 15,000 of the monitoring stations report in near real-time. \r\nAs automated approaches to data access become more common, use of USGS water data services is increasing at a faster rate than more conventional web page access through as shown in the figure.\r\nData provision by USGS represents the current state of the art in real-time access to discharge and water level data encoded in WaterML 2.0. Using the USGS service, it is easy to create a persistent URL (web address) that provides a link to the latest discharge data for any site.','USGS provides summary reports, maps, statistics and other information via the Internet as well as the data services designed for machine-to-machine access via automated tools.','https://waterdata.usgs.gov/nwis',NULL,NULL,'Growth in use of USGS water data distribution methods (page requests per month)',NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2018-11-21 00:00:00'),(46,'EN',2000,40000,0,0,1,0,0,1,'AAORG00000001','SANDRE','SANDRE','France',1970,NULL,'French WIS',NULL,'Sandre’s mission is to build and make available the French WIS’s water reference data sets. These reference datasets are made up of free-of-charge technical specifications and code lists and describe how to exchange water data at the scale of France. From an IT perspective, Sandre guarantees interoperability between the French water information systems.\r\nRegulations\r\nThe National Scheme of Water Data (SNDE), supplemented by technical documents including those of SANDRE, must be respected by all contributors to the Water Information System (WIS), in accordance with Decree No. 2009-1543 of 11 December 2009. The state establishes which elements of the data repository must be used for applying the regulations, and the conditions of their use.\r\nOrganization\r\nSANDRE comprises a network of organizations that contribute their business knowledge to the WIS, participate in the administration of the reference system and ensure the coherence of the whole. SANDRE has data administrators within the WIS contributing agencies. Led by the French Agency for Biodiversity (AFB), the network relies on the SANDRE Technical Secretariat provided by the International Office for Water (OIEau) which has driven, developed and made available the standard since its inception.\r\nComposition of the repository\r\nThe Sandre Repository is a set of specification documents, reference datasets and freely distributed services namely: data dictionaries, exchange scenarios, administration documents, reference datasets, and assistance services.\r\nSandre’s mission is to build and make available the French WIS’s water reference data sets. These reference datasets are made up of free-of-charge technical specifications and code lists and describe how to exchange water data at the scale of France. From an IT perspective, Sandre guarantees interoperability between the French water information systems.\r\nRegulations\r\nThe National Scheme of Water Data (SNDE), supplemented by technical documents including those of SANDRE, must be respected by all contributors to the Water Information System (WIS), in accordance with Decree No. 2009-1543 of 11 December 2009. The state establishes which elements of the data repository must be used for applying the regulations, and the conditions of their use.\r\nOrganization\r\nSandre’s mission is to build and make available the French WIS’s water reference data sets. These reference datasets are made up of free-of-charge technical specifications and code lists and describe how to exchange water data at the scale of France. From an IT perspective, Sandre guarantees interoperability between the French water information systems.\r\nRegulations\r\nThe National Scheme of Water Data (SNDE), supplemented by technical documents including those of SANDRE, must be respected by all contributors to the Water Information System (WIS), in accordance with Decree No. 2009-1543 of 11 December 2009. The state establishes which elements of the data repository must be used for applying the regulations, and the conditions of their use.\r\nOrganization\r\nSANDRE comprises a network of organizations that contribute their business knowledge to the WIS, participate in the administration of the reference system and ensure the coherence of the whole. SANDRE has data administrators within the WIS contributing agencies. Led by the French Agency for Biodiversity (AFB), the network relies on the SANDRE Technical Secretariat provided by the International Office for Water (OIEau) which has driven, developed and made available the standard since its inception.\r\nComposition of the repository\r\nThe Sandre Repository is a set of specification documents, reference datasets and freely distributed services namely: data dictionaries, exchange scenarios, administration documents, reference datasets, and assistance services.','These reference datasets are made up of free-of-charge technical specifications and code lists and describe how to exchange water data at the scale of France.',NULL,'IOWAter',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2018-11-21 00:00:00'),(47,'EN',1100,40000,0,0,1,1,0,1,'AAORG00000001','SANDRE','EDILABO: Automatic exchange of data produced by water quality control laboratories in France','France',1970,NULL,'French WIS',NULL,'In the French WIS, automatic data exchanges have been organized, e.g. in the field of quality control of aquatic environments between the ordering parties responsible for monitoring the quality and the laboratories they employ to take samples and analyze them, which might be public or private. \r\nOrdering parties have their own specific information systems to match their particular information management requirements. As a result, it was difficult for these organizations to exchange specialized information. \r\nThe national standardization system for data exchange, called “EDILABO”, was set up by Sandre with the support of a group of experts in order to:\r\n1- Adopt a common vocabulary used by all stakeholders so that they can understand each other using specialized terminology;\r\n2- Choose the specialized information that stakeholders wish to exchange to carry out quality controls in aquatic environments and to make samples and analyses;\r\n3- Create a single code for some key data, such as parameters measured, for all stakeholders and use it to create a shared repository;\r\n4- Choose a specific syntax to format specialized information so that it can be exchanged.\r\nThanks to this standard, in 2017, several thousand results of analyses of physico-chemical and microbiological parameters relating to the quality of aquatic environments were able to transit between different information systems and stakeholders.','1- Adopt a common vocabulary used by all stakeholders so that they can understand each other using specialized terminology;\r\n2- Choose the specialized information that stakeholders wish to exchange to carry out quality controls in aquatic environments and to make samples and analyses;\r\n3- Create a single code for some key data, such as parameters measured, for all stakeholders and use it to create a shared repository;\r\n4- Choose a specific syntax to format specialized information so that it can be exchanged.',NULL,'IOWAter',NULL,'Levels of interoperability to consider',NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2018-11-21 00:00:00'),(48,'EN',1000,60000,0,1,1,1,1,1,'AAORG00000001',NULL,'PLATA-HIS to provide additional operational capability, in particular for in situ water observations, as a federated resource for National Hydrological Services\r\nPlata-HIS pour faciliter l\'accès et l\'échange de données hydrologiques','Argentina, Bolivia, Brazil, Uruguay and Paraguay',1970,NULL,'National Hydrological Services of the Plata basin',NULL,'The La Plata basin, with an area of 3,200,000 km2, is the second largest catchment area in South America and one of the largest in the world. It covers large territories belonging to Argentina, Bolivia, Brazil, Uruguay and Paraguay. To facilitate access and exchange of hydrological data provided by the National Hydrological Services of the Plata basin, CHy supported the development of a technical solution, called PLATA-HIS (see LaPlataHIS.pdf [43]). The aim was to provide additional operational capability, in particular for in situ water observations, as a federated resource for National Hydrological Services.\r\nUsing a combination of WMO and OGC web services, the PLATA-HIS (http://hydrolite.ddns.net/hisPlata/ ) is designed as a “service stack framework” that identi?es three types of services as essential to sharing hydrological information across the web: catalogue services, metadata services and data services. These three services work together to completely index, describe and provide access to hydrological time series in the La Plata river basin.\r\nThe system has been successfully used as follows: definition of a monitoring network of hydrological and meteorological stations maintained by countries belonging to the La Plata basin; analysis and optimization of the hydrological monitoring network at the basin scale; increased collaboration between countries to improve network design and lower costs; collaborative calibration of hydro-meteorological instruments; free exchange of meteorological and hydrological observations; common policies to control data quality; and creation of archives of hydrological data to improve services and respond faster to natural disasters.','is designed as a “service stack framework” that identi?es three types of services as essential to sharing hydrological information across the web: catalogue services, metadata services and data services.','http://hydrolite.ddns.net/hisPlata/','OMM',NULL,'Discovery and access of hydrological data in La Plata basin',NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2018-11-21 00:00:00'),(49,'EN',1000,40000,0,1,0,0,0,1,'AAORG00000001','NHSs','The Arctic-HYCOS','Arctic',1970,NULL,'NHSs','Arctic countries','Sharing information and knowledge among NHSs and international projects promotes a consolidated approach to studying the freshwater flux to the Arctic Ocean and Seas and furthers our understanding of the Arctic hydrological regime and related climatic variability and change. The Commission for Hydrology supported the implementation of a hydrological observation system within the Arctic drainage basin known as Arctic-HYCOS (see ArcticHycos.pdf [44]). The Arctic countries of Canada, Denmark, Finland, Iceland, Norway, Russian Federation, Sweden and the United States are participants in the Arctic-HYCOS project, and they freely and openly share all data and metadata from stations within the project network with all project participants, following Resolution 25 (Cg-XIII) on the Exchange of Hydrological Data and Products.\r\nThe Arctic-HYCOS project provides a platform (http://hydrolite.ddns.net/hisArctic/ ) for the regular collection and free exchange of Arctic hydrological data. Project activities also include evaluating, maintaining and potentially upgrading existing observation stations. Network analysis identifies observation stations suitable to evaluate freshwater flux into the Arctic Ocean and Seas and to study changes in Arctic hydrological regimes relative to climate change.\r\nThe development of the system in support of standardized data exchange allows: international cooperation to study and assess hydrological processes in the Arctic, in particular related to climate change; reliable assessments of freshwater flux into the Arctic Ocean and Seas both in the short and longer terms; a better understanding of links between Arctic river discharge, the freshwater balance of the Arctic Ocean, thermohaline circulation, and the global climate; improved water management enabling better stream flow monitoring and prediction of hydrological changes thus improving life support systems in polar communities; hydrological data to be contributed to other Arctic Observation Systems, in particular to research groups and monitoring programs dealing with Arctic snow hydrology, permafrost, glaciers and glacial runoff; and hydrological data to be contributed to Global Observation Systems, in particular WIGOS.','The Arctic-HYCOS project provides a platform (http://hydrolite.ddns.net/hisArctic/ ) for the regular collection and free exchange of Arctic hydrological data. Project activities also include evaluating, maintaining and potentially upgrading existing observation stations.','http://hydrolite.ddns.net/','OMM',NULL,'The Hydrological Information System in the Arctic-HYCOS project',NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2018-11-22 00:00:00'),(50,'EN',2000,40000,0,0,0,1,0,1,'AAORG00000001','UNESCO International Hydrological Programme (IHP)','UNESCO Water Family','United Nation Members',1975,NULL,'UNESCO','World','Created in 1975, UNESCO International Hydrological Programme (IHP) constitutes the only intergovernmental programme of the UN system devoted to facilitating water research, water resources management and governance, and education and capacity building. \r\nIn this endeavor, the IHP benefits from the support of the UNESCO Water family, which constitutes an extended network of water professionals based in water related Ministries (IHP National committees), universities, institutes and research facilities directly linked to IHP’s programmes in order to serve its Member States and build scientific knowledge. This network is composed of 168 IHP National Committees and focal points among UNESCO’s 195 Member States, 48 water-related chairs (interested universities around the world, aiming at bridging the knowledge gap) and 36 regional centres and institutes (working on relevant thematic and geographic priorities in their areas of expertise, under the auspices of UNESCO). \r\nIn January 2017, the IHP launched its Water Information Network System (IHP-WINS), an open-access, cooperative and participatory web platform that incorporates geospatial data on water resources into a database to foster knowledge sharing and access to information. IHP-WINS allows gathering and disseminating information and knowledge developed by the UNESCO Water Family and other stakeholders. \r\nIHP-WINS acknowledges that in order to build a strong spatial data infrastructure, metadata is crucial. As a result, in addition to supporting standard data formats, the platform also supports standard metadata representations. Metadata and metadata servers enable users to integrate data from multiple sources, organizations, and formats. On IHP-WINS, metadata for geographical data include the data source, its creation date, format, projection, and additional information such as the source, author, an abstract, a quality statement, and point of contact. Metadata on IHP-WINS build on the GeoNode 2.6 Metadata. Services enable users to create a central, online metadata repository that facilitates publishing and browsing metadata over the Internet.','On IHP-WINS, metadata for geographical data include the data source, its creation date, format, projection, and additional information such as the source, author, an abstract, a quality statement, and point of contact. Metadata on IHP-WINS build on the GeoNode 2.6 Metadata. Services enable users to create a central, online metadata repository that facilitates publishing and browsing metadata over the Internet.',NULL,'UNESCO',NULL,'The-UNESCO-Water-Family-network',NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2018-11-22 00:00:00'),(51,'EN',1,50000,0,0,0,1,0,1,'AAORG00000001','UNESCO-International Hydrological Programme (IHP)','FREEWAT: FREE and open source tools for WATer resource management','World',1970,NULL,'EU Commission',NULL,'In partnership with 18 universities, centres and other organizations, UNESCO-IHP is collaborating on the FREEWAT project (http://www.freewat.eu/), a HORIZON 2020 project financed by the EU Commission. The project adopts an innovative participatory approach gathering technical staff and relevant stakeholders, including policy and decision-makers, to design scenarios for the proper application of conjunctive water policies [46].\r\nFREEWAT’s main result is an open source and public domain GIS-integrated modelling environment (the FREEWAT platform) for the simulation of water quantity and quality in surface water and groundwater with an integrated water management and planning module. FREEWAT is a composite plugin for QGIS, designed as a modular ensemble of different tools, including for analysis, interpretation and visualization of hydrogeological and hydrochemical data and quality issues, for simulation of models related to the hydrological cycle and water resources management, or for performing model calibration\r\nThe consortium also organizes capacity-building workshops and seminars. So far, a total of 890 individuals had to be trained to use the platform within the EU, 60 in Switzerland, 100 in neighboring countries (Ukraine and Turkey) and another 80 in Africa (South Africa, Namibia and Botswana).\r\nA new version of the FREEWAT plugin (v.1.0) has been available since 17 October  2017, and can be downloaded, along with a complete set of up-to-date User Manuals and Tutorials, through accessing the Software -> Download area page of the FREEWAT website.','FREEWAT’s main result is an open source and public domain GIS-integrated modelling environment (the FREEWAT platform) for the simulation of water quantity and quality in surface water and groundwater with an integrated water management and planning module. FREEWAT is a composite plugin for QGIS, designed as a modular ensemble of different tools, including for analysis, interpretation and visualization of hydrogeological and hydrochemical data and quality issues, for simulation of models related to the hydrological cycle and water resources management, or for performing model calibration','http://www.freewat.eu/','UNESCO',NULL,'Percentage-of-FREEWAT-downloads-per-Continent',NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2018-11-22 00:00:00'),(52,'EN',1000,60000,0,0,1,1,1,1,'AAORG00000001','IOWater','Ma Conso','France',1970,NULL,'IOWater',NULL,'“Ma Cons\'eau” is a free application that allows you to estimate your water consumption and the impact of savings on your bill.\r\nBy answering a series of simple questions, My Cons\'eau assesses your annual consumption.\r\nThe estimated amount of your water bill is calculated based on the price of water in your municipality.\r\nYour municipality is determined by geolocation or by choosing from the list of French municipalities.\r\nThe price is determined by:\r\n- identifying the price for your town on the Internet,\r\n- or the average price in France if the price for your town is not found,\r\n- or the price indicated on your invoice that you enter into the application.\r\nFinally, tips are provided to reduce consumption per item of expenditure, with an evaluation of the impact on the overall bill.','French customers',NULL,'IOWater',NULL,'Ma Conso Application',NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2018-11-22 00:00:00'),(53,'EN',2000,10000,0,0,1,1,1,1,'AAORG00000001','UNESCO-International Hydrological Programme (IHP)','The Water Information Network System platform (IHP-WINS)','Local area / World',1970,NULL,'UNESCO',NULL,'UNESCO-IHP is behind the Water Information Network System (IHP-WINS), which was launched in January 2017 [49]. This online platform (available at: http://ihp-wins.unesco.org/) incorporates geospatial data on water resources into a cooperative and open-access participatory database to foster knowledge-sharing and access to information. IHP-WINS is freely made available by UNESCO-IHP to Member States, water stakeholders and partners with the aim of facilitating access to information, and encouraging contributors to share data on water. Thanks to these contributions, the platform benefits from continuous enrichments with spatial data and documents, coming from various sources. A variety of spatial data is shared and accessible on the platform: the scale varies from worldwide to very local level, information can be quantitative or qualitative, and both raster and vector files are available. Additionally, because the platform is open to a variety of contributors, information covers a large array of water-related topics ranging from quality to risk, and gender, etc. Users can combine these layers of information to create maps tailored to their own needs. \r\nTransparency and respect of authorship is guaranteed as all information provides the benefits of metadata in a standardized format from a Digital Object Identifier (DOI: 10.29104). This allows for accurate identification and crediting of all contributions, and facilitates later sharing. Inter-disciplinary collaboration, professional networking and mentoring are also stimulated through working groups where users can exchange and provide feedback on their ongoing work. This involvement and participation contribute to the building of an online community. By gathering global and inclusive knowledge on water, and facilitating interdisciplinary collaboration, IHP-WINS aims overall at supporting Members States and stakeholders involved in resource management. The platform will also contribute to close the gap between North and South in terms of access to knowledge. The initiative contributes to the follow-up on the monitoring and implementation of the targets of Sustainable Development Goal 6 (SDG 6) and those of other water-related goals.','Thanks to these contributions, the platform benefits from continuous enrichments with spatial data and documents, coming from various sources. A variety of spatial data is shared and accessible on the platform: the scale varies from worldwide to very local level, information can be quantitative or qualitative, and both raster and vector files are available.','http://ihp-wins.unesco.org/','UNESCO',NULL,'IHP-WINS map overlaying transboundary aquifers to groundwater pollution risk data',NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2018-11-22 00:00:00'),(54,'EN',2000,60000,0,0,1,1,1,1,'AAORG00000001','IOWater','Gest’eau','France',2002,NULL,'The French Agency for Biodiversity (AFB)',NULL,'The Water Development and Management Plan (SAGE) is a planning tool established by the Water Act of 1992, which aims at balanced and sustainable water resources management. This is a local variation of the Master Plan for Water Development and Management (SDAGE), which sets out the fundamental orientations of water policy in major French river basins.\r\nThe SAGE establishes, coordinates and prioritizes general objectives for the use and protection of water resources, taking into account the specificities of the territory. It determines priorities for action, identifies the resources needed, and lays down rules for the sharing of uses. Based on a voluntary approach, it has proved an effective tool for responding locally to the objectives of the Water Framework Directive (WFD), especially the objective of good status of water bodies.\r\nTo promote the balanced and sustainable management of water resources and aquatic environments and federate stakeholders, IOWater is responsible for facilitating the network of SAGE stakeholders and environment contracts. The objective is to meet the needs of local stakeholders, taking into account the national priorities of the water policy and its links with the biodiversity policy, the flood directive, its integration into land use planning and economic development policies, as well as its part in territorial reform.\r\nSince 2002, IOWater has been facilitating the network of stakeholders in local water management, especially through Gest\'eau, by pooling and disseminating knowledge, gathering, sharing and enhancing experiments, accompanying stakeholders, and building capacities.','To promote the balanced and sustainable management of water resources and aquatic environments and federate stakeholders, IOWater is responsible for facilitating the network of SAGE stakeholders and environment contracts. The objective is to meet the needs of local stakeholders, taking into account the national priorities of the water policy and its links with the biodiversity policy, the flood directive, its integration into land use planning and economic development policies, as well as its part in territorial reform.',NULL,'IOWater',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2018-11-22 00:00:00'),(55,'EN',2000,40000,0,1,1,1,1,1,'AAORG00000001','Bureau of Meteorology','Australian Water Resources Information System (AWRIS)','Australia',1970,NULL,'Bureau of Meteorology','Australia','The Bureau of Meteorology has responsibility for collecting, holding, managing, interpreting and disseminating Australia’s water information. Given this mandate, the Bureau developed the Australian Water Resources Information System (AWRIS) to receive and manage water data and related information, and to support the production and dissemination of a variety of water information ‘products’ and services. AWRIS is designed using a conventional best-practice ‘data warehouse’ architecture. It has an \'ecosystem\' of interdependent system components delivering Australia-wide water information services and products to industry managers, policy-makers, scientists, farmers and the general public. The AWRIS Ecosystem is capable of processing daily over 15,000 incoming water data and metadata files from 178 water data providers (DPs) across Australia. The ecosystem captures incoming files, performs validation functions and ingests data to the AWRIS data warehouse. The data warehouse holds over 4 billion observations (growing by approximately 500 million per annum) including streamflow, storages, water trading and markets information. A Data Flow Console provides a range of management functions to control and monitor the flow of files through the Ecosystem. \r\nThe Time Series Data Management component of the Ecosystem holds all time-series data enabling online access for customers and quality control, as well as being the source of truth to downstream Data Marts and to the Water Data Online product. Data Marts provide well-structured data views which together with the Web Map Services enable dashboards for online Water Storage and Water Market products as well as a plain text website.','The ecosystem captures incoming files, performs validation functions and ingests data to the AWRIS data warehouse. The data warehouse holds over 4 billion observations (growing by approximately 500 million per annum) including streamflow, storages, water trading and markets information. A Data Flow Console provides a range of management functions to control and monitor the flow of files through the Ecosystem.',NULL,'Bureau of Meteorology',NULL,'AWRIS ecosystem',NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2018-11-22 00:00:00'),(56,'EN',2000,40000,0,0,1,1,1,1,'AAORG00000001','DWR-MoNRE','Lao Water Information System (LaoWIS)','Lao',1970,NULL,'Department of Water Resources of the Ministry of Natural Resources',NULL,'LaoWIS is the first Water Information System (WIS) in Lao PDR and is developed by the Department of Water Resources of the Ministry of Natural Resources and Environment (DWR-MoNRE) with the support of French technical assistance. The water-related database LaoWIS aims to develop tools and scenarios to share useful data for IWRM among data producers/ managers/ users. The revised Law on water and water resources (2017) introduces the concept of a \"National Water and Water Resources Data and information System\" for the first time. It specifies that the MoNRE is responsible for collection, compilation and establishment of the national system of the data and information, and for the use and supply of water and water resources in connection with the National Statistic Information Centre and the relevant ministries and local administrations. \r\nLaoWIS is managed by the data team of the DWR-MoNRE and their first project involved gathering data from the 7 divisions of the DWR-MoNRE and inputting them into the database. With the current data available, the team has begun to develop some tools to share information on their web-portal, such as webmapping, reports about water status in Lao PDR, and a basin atlas gallery. \r\nIn conformity with the DWR-MoNRE mandates, the short-term plan is to develop an online water assessment tool and to reinforce data exchange with:\r\n- The line agencies at provincial level - PoNRE (starting with 3 provinces),\r\n- The Department of Meteorology and Hydrology (DMH-MoNRE) which produces meteorological and hydrological data at national level.\r\nConsidering the high number of dams in Lao PDR, the next step will be to add data from the energy sector into this sharing process, especially to acquire information about dam releases to boost water allocation knowledge. A sharing process could be developed with the Ministry of Energy and Mines (MEM), which has information about dams.','Gathering data from the 7 divisions of the DWR-MoNRE and inputting them into the database. With the current data available, the team has begun to develop some tools to share information on their web-portal, such as webmapping, reports about water status in Lao PDR, and a basin atlas gallery.',NULL,'Department of Water Resources of the Ministry of Natural Resources',NULL,'Some functionalities available on the LaoWIS Portal',NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2018-11-22 00:00:00'),(57,'EN',2000,40000,0,0,1,1,1,1,'AAORG00000001','The French Agency for Biodiversity (AFB)','French Water Information System (SIE)','France',2016,NULL,'The French Agency for Biodiversity (AFB)',NULL,'The French Agency for Biodiversity (AFB), created by the law of 8 August 2016 and the decree of 26 December 2016, has been operational since 1 January 2017. In mainland France and overseas, the agency contributes to the preservation, management and restoration of terrestrial, aquatic and marine biodiversity, the development of knowledge, resources, uses and ecosystem services related to biodiversity, the balanced and sustainable management of water, and the fight against biopiracy. Establishing reliable and shared data is a major challenge for these missions.\r\nThe AFB provides technical coordination of the information system on water, aquatic environments and public water and sanitation services. Along with its partners and territorial services, it designs and implements observation and evaluation systems for terrestrial, marine and aquatic environments and their uses. It is also responsible for the technical coordination of the biodiversity information system, including the Water Information System (WIS), the Nature and Landscape Information System, and the Marine Water Information System. It ensures their consistency and works to promote sharing and dissemination of data and indicators, particularly via the information services Eaufrance and Naturefrance.\r\nIn France, the purpose of the Water Information System (WIS) is the collection, conservation and dissemination of data and indicators on water, aquatic environments, their uses and public services on water distribution and sanitation. It comes under the National Scheme of Water Data (SNDE). The SNDE is supplemented by technical documents, some of which are produced by SANDRE, and must be respected by all WIS contributors in accordance with Decree No. 2009-1543 of 11 December 2009. The state establishes the elements of the data repository that must be used for the purposes of application of the regulations, and the conditions of their use.','The AFB provides technical coordination of the information system on water, aquatic environments and public water and sanitation services. Along with its partners and territorial services, it designs and implements observation and evaluation systems for terrestrial, marine and aquatic environments and their uses. It is also responsible for the technical coordination of the biodiversity information system, including the Water Information System (WIS), the Nature and Landscape Information System, and the Marine Water Information System. It ensures their consistency and works to promote sharing and dissemination of data and indicators, particularly via the information services Eaufrance and Naturefrance.',NULL,'The French Agency for Biodiversity (AFB)',NULL,'Topics of the French Water Information System',NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2018-11-22 00:00:00'),(58,'EN',2000,40000,0,0,1,1,1,1,'AAORG00000001','Haihe River Water Conservancy Commission','Water Information System Construction Achievement, Haihe River Water Conservancy Commission (HWCC)','China',1970,NULL,'Ministry of Water Resources of China',NULL,'In recent years, based on the Chinese government’s requirement to promote the modernization of water conservancy through informatization, the water authority in charge of the Haihe River Basin, Haihe River Water Conservancy Commission (www.hwcc.gov.cn) has built a basic integrated water information system consisting of an infrastructure, an application system and a support environment. The system has provided significant technical support for flood and drought control management and water resources management in the Haihe River Basin.\r\nFor the next step, HWCC plans to introduce a new informatization concept and technology to integrate information resources, improve networks, build a data centre and unify its portal. It will attempt to build an HWCC integrated water conservancy management platform with “one network, one map, one centre and one portal”.','The system has provided significant technical support for flood and drought control management and water resources management in the Haihe River Basin.',NULL,'Haihe River Water Conservancy Commission',NULL,'Haihe  River Basin Water Resources Monitoring and Control Platform and Mobile APP',NULL,'Main Framework Chart of HWCC Water Conservancy Informatization Development',NULL,NULL,NULL,NULL,0,0,NULL,'2018-11-22 00:00:00'),(59,'EN',2000,40000,0,0,0,1,1,1,'AAORG00000001','WMO','Water Resources Assessment (WRA)','World',1970,NULL,'WMO','Decision-makers','Water Resources Assessment is more than conducting a simple water balance, it requires a dynamic approach to the spatial and temporal variability of resources, and of demands and pressures put on them by various societal requirements (water supply, industry, agriculture, environmental protection, etc.).\r\nWRA must support the provision of information and data to decision-makers enabling them to implement evidence and fact-based policies for both long-term planning to respond to short-term emergencies, based on the knowledge of status and trends of the resource.\r\nWRA must also be flexible and adaptable to take into account the social, economic and environmental context, the skills and resources (human, financial) of the stakeholders (especially those involved in data monitoring and information generation), and the availability and quality of data. It is therefore important that they employ extensive consultative processes involving both users and providers of information to define requirements and the extent to which they can be satisfied\r\nTo support this broad interpretation of the WRA concept the whole value chain has to be addressed, from monitoring, to product development, to information delivery. In particular, existing WMO regulatory and guidance material refers to standards and recommended practices addressing several of the WRA process components, and the remaining gaps are being filled through the development of relevant material.',NULL,NULL,'OMM',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2018-11-23 00:00:00'),(60,'EN',2000,40000,0,0,1,1,1,1,'AAORG00000001','Conagua','National Water Information System (SINA)','Mexico',2004,NULL,'Conagua',NULL,'SINA is the institutional system that integrates and provides the general public in Mexico with the largest amount of relevant statistical and geographic information on the water sector. It is an intuitive system, using a common language. It can be accessed over the web with a personal computer or any mobile device using standard browsers and can download report information and graphs in Excel and PDF format. It presents 492 thematic maps available for download in shapefile (shp) format.\r\nThe system is made up of people, data, information, material and computer resources, set up through a web consultation platform called SINA. This statistical and geographic system comprises 42 topics organized in three axes (environmental, economic and social); it has a module of technical sheets, using a Geosina geographic viewer, a glossary of terms, links to publications generated by system information, and links to a monitor of the daily level of dams and sites of interest, such as WMS services as well as social networks. Information from maps, tables and graphs can be downloaded free of charge.\r\nSINA is an innovative statistical and geographic system since it integrates and publishes relevant information on the water sector, with a consultation interface, intuitive navigation, public access and easily understandable information for the general public, academics and specialists on the topic. The information can be viewed and downloaded in different formats (PDF, Excel and shp). It is a very useful tool for responding quickly to requests for information from different sources, including the National Institute for Transparency, Access to Information and Protection of Personal Data (INAI).','This statistical and geographic system comprises 42 topics organized in three axes (environmental, economic and social); it has a module of technical sheets, using a Geosina geographic viewer, a glossary of terms, links to publications generated by system information, and links to a monitor of the daily level of dams and sites of interest, such as WMS services as well as social networks. Information from maps, tables and graphs can be downloaded free of charge.','http://sina.conagua.gob.mx/sina/','Conagua',NULL,'Main functions of the SINA',NULL,'Welcome page of the SINA  http://sina.conagua.gob.mx/sina/',NULL,NULL,NULL,NULL,0,0,NULL,'2018-11-23 00:00:00'),(61,'EN',2000,20000,0,0,1,1,1,1,'AAORG00000001','Water Knowledge Bureau','The Water Knowledge Portal','Quebec',2018,NULL,'Water Knowledge Bureau','Several departments andagencies of the Government of Quebec and Canada, NGOs','The main objective of the Water Knowledge Portal (CEP) is to support water stakeholders in the realization of their IWRMmandates by providing integrated, fast and transparent access to water knowledge whilepromoting its circulation, particularly through the provision of services, sharing, and collaborativework tools,','t will offer different services and features, including:°A common site to share and search for knowledge and expertise;°Secure collaboration sites with different levels of accessibility;°Blog creation services, forum, wiki, etc.;°The creation of layers in geoprocessing extraction;°The development of geoprocessing tools.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2019-02-27 00:00:00'),(62,'EN',2000,20000,0,0,1,1,1,1,'AAORG00000001','The Water Secretariat (SENAGUA','The SI/GIRH platform','Ecuador',NULL,NULL,'SENAGUA',NULL,'The \"SI/GIRH\" platform aims to facilitate access to data and information to encourageparticipation, planning, and good integrated management of water resources, with a friendly toolthat can be used by all stakeholders. Developed with the technical support of IOWater, it aims tomake data easy to access following simple, dynamic, flexible and economical procedures,','n order to achieve these objectives, the \"SI/GIRH\" portal gathers information of national interest,relating to demarcationsand planning units basedon a principle ofparticipation. It alsoincludes the work ofSENAGUA and thecouncils in the planningframework (baselinemaps, practicalinformation). Thedynamic character of theinformation is assuredwith web services, ageographic viewer and acatalogue of metadatathat provides acomprehensivedescription of the dataand informationpresented. Theinformation madeavailable is based onmaterial produced bySENAGUA at central andlocal levels, applying theprinciple of subsidiarity,and also includesinformation available andproduced by all actors inthe sector,',NULL,'SENAGUA',NULL,'Diagram showing how the SI/GIRH sub-module fits into the nationalwater information system structure',NULL,'Example of maps within Ecuador’s SI/GIRH sub-module',NULL,NULL,NULL,NULL,0,0,NULL,'2019-02-27 00:00:00'),(63,'EN',3000,20000,0,1,1,1,1,1,'AAORG00000001','Basin Committee of the Adour Garonne Basin Agency','Mapping the vulnerability of territories to climate change in the watersector in the Adour Garonne basin','France',NULL,NULL,'Basin Committee of the Adour Garonne Basin Agency',NULL,'In response to this challenge, in parallel with the SDAGE (designed to solve the current problemsof water management), the Basin Committee of the Adour Garonne Basin Agency decided toinitiate a plan for adapting to climate change in the field of water (PACC). The PACC anticipatesthese changes by imagining new measures to limit future water management problems. This planis based on a study (mapping) of the territorial vulnerabilities to climate change in the watersector and ultimately proposes adaptation measures in the Adour Garonne basin andrecommended actions at local level,',NULL,NULL,NULL,NULL,'Example of a map showing the watershed’s vulnerability to eutrophicatio',NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2019-02-27 00:00:00'),(64,'EN',3000,20000,0,1,0,1,1,1,'AAORG00000001','World Bank','Climate Change Knowledge Portal (CCKP)','Local area / World',NULL,NULL,'World bank',NULL,'The portal provides an online tool for access tocomprehensive global, regional, and country data related to climate change and development.The portal is a web-based platform developed to assist in capacity building and knowledgedevelopment on climate and climate-related issues across the development community.Additionally, the portal was developed to help project teams to plan, monitor and evaluate projectresponses with respect to climate change risks,','The CCKP contains environmental, disaster risk, and socio-economic datasets, as well assynthesis products, such as the Climate Adaptation Country Profiles, which are built andpackaged for specific user-focused functions such as climate change indices for a particularcountry. The portal also provides intelligent links to other resources and tools.The CCKP consists of spatially referenced data visualized on a Google Maps interface. Users canevaluate climate-related vulnerabilities, risks, and actions for a particular location on the globe byinterpreting climate and climate-related data at different levels of detail,','http://sdwebx.worldbank.org/climateportal/index.cfm','World Bank',NULL,'Example of visualisation on the Climate Change Knowledge Porta',NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2019-02-27 00:00:00'),(65,'EN',4000,20000,0,0,0,1,1,1,'AAORG00000001','University of Princeton','Drought and flood monitoring system in Africa and Latin America','Africa / Latin America',NULL,NULL,'UNESCO-IH',NULL,'The system combines remote-sensing data onprecipitation, vegetation and atmospheric analysis with macro-hydrological modelling through theuse of a Variable Infiltration Capacity (VIC) land-surface hydrological model [65]. The systemtracks hydrological conditions including extremes (e.g. floods and droughts) in near real time andallows medium-term and seasonal forecasting. It therefore provides monitoring capabilities formeteorological, hydrological and agricultural drought and flood conditions, which is particularlyuseful in developing regions where institutional capacity for monitoring and early warning isgenerally lacking and access to information and technology prevents the development of suchsystems locally. In addition, the system has the advantage of providing a standardized format forany of the components of the water balance, thus enabling a comprehensive analysis of droughtand flood hazards at local, national and regional level. In essence, the system providesinformation on precipitation, temperature, radiation and wind speed, drought indicators (i.e.Standardized Precipitation Index - SPI, soil moisture, Normalized Difference Vegetation Index -NDVI, evapotranspiration) and flood indicators (i.e. surface runoff and streamflow). Theinformation can be obtained either spatially or for point locations, for specific dates, months orannual timescales, and is compared with the normally expected conditions or percentiles. Thesystem has been successfully deployed in Western, Eastern and Southern Africa combined withtraining of experts and is used as a complementary information system by regional institutions tomonitor agro-hydro-meteorological conditions particularly during the rainy season.',NULL,'http://stream.princeton.edu/',NULL,NULL,'Interface of the Latin American Flood and Drought Monit',NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2019-02-27 00:00:00'),(66,'EN',2000,20000,0,1,0,1,1,1,'AAORG00000001','WMO','The Hydrological Status and Outlook System HydroSOS','World',NULL,NULL,'WMO',NULL,'HydroSOS strives to build an operational system capable of assessing the current status ofsurface and groundwater hydrological systems, and predicting how they will change in thecoming weeks and months, in comparison to normal situations. This information can be criticalfor water management and mitigating negative effects of floods and droughts, as well as toreduce risks of conflicts in water sharing. Once operational, the worldwide operational system willregularly provide information on:➊Current global hydrological status, including groundwater, river flow, large lakes, reservoirsand soil moisture;➋Appraisal of where the current status is significantly different from ‘normal’, for exampleindicating potential drought and flood situations; and➌Assessment of trends i.e. likelihood of improvement or worsening over coming weeks andmonths.','HydroSOS will be built on the following components:°In situ data: river flow, soil moisture, large lake and reservoir levels and groundwater depths;°Global/regional-scale remotely sensed satellite data: precipitation, soil moisture, aquifers, andsnow cover/depth;°Global/regional weather and climate forecast models: precipitation and temperature; and°Global/regional/basin scale hydrological models: river flow, soil moisture, groundwater',NULL,'WMO',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2019-02-27 00:00:00'),(67,'EN',1000,20000,0,1,0,1,0,1,'AAORG00000001','UNESCO-IHP','Precipitation Estimation from Remotely Sensed Information (PERSIANN-CCS)','World',NULL,NULL,'UNESCO-IHP',NULL,'UNESCO-IHP has collaborated with the Center for Hydrometeorology and Remote Sensing (CHRS)at the University of California, Irvine, on the development of tools to provide near real-time globalsatellite precipitation estimates at high spatial and temporal resolutions, including thePrecipitation Estimation from Remotely Sensed Information using the Artificial Neural Networks-Cloud Classification System (PERSIANN-CCS) [66]. This specific system is used to informemergency planning and manage hydrological risks, such as floods, droughts, and extremeweather events. For example, the Namibia Drought Hydrological Services (NHS) uses it to preparedaily bulletins with up-to-date information on flood and drought conditions for loUNESCO-IHP has collaborated with the Center for Hydrometeorology and Remote Sensing (CHRS)at the University of California, Irvine, on the development of tools to provide near real-time globalsatellite precipitation estimates at high spatial and temporal resolutions, including thePrecipitation Estimation from Remotely Sensed Information using the Artificial Neural Networks-Cloud Classification System (PERSIANN-CCS) [66]. This specific system is used to informemergency planning and manage hydrological risks, such as floods, droughts, and extremeweather events. For example, the Namibia Drought Hydrological Services (NHS) uses it to preparedaily bulletins with up-to-date information on flood and drought conditions for local communities.cal communities.','The system is now available through the iRain mobile application, devoted to facilitate people’sinvolvement in collecting local data for global precipitation monitoring(http://en.unesco.org/news/irain-new-mobile-app-promote-citizen-science-and-support-water-management). iRain allows users to visualize real-time global satellite precipitation observations,track extreme precipitation eventsworldwide, and report local rainfallinformation using a crowd-sourcing functionality tosupplement the data, whichprovides opportunities to improveremote-sensing precipitationestimations.','http://en.unesco.org/news/irain-new-mobile-app-promote-citizen-science-and-support-water-management','UNESCO',NULL,'The iRain MobileApplication',NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2019-02-27 00:00:00'),(68,'EN',4000,20000,0,0,1,1,1,1,'AAORG00000001','Chilean Ministry of Agriculture','Drought indicators in Chile','Chile',2013,NULL,'Chilean Ministry of Agriculture',NULL,'In close collaboration with the Chilean Ministry of Agriculture, the Food and Agriculture Organization (FAO) and the International Research Institute for Climate and Society (IRI), the Chilean Agroclimatic Observatory (www.climatedatalibrary.cl/UNEA/maproom/) was launched in June 2013. A similar system was developed in collaboration with the Autoridad','Climate Data Library','www.climatedatalibrary.cl/UNEA/maproom/','Chilean Ministry of Agriculture',NULL,'Information on drought available on the Chilean Agroclimatic Observato',NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2019-02-27 00:00:00'),(69,'EN',4000,20000,0,0,0,1,1,1,'AAORG00000001','United Nations Environment Programme (UNEP)','Flood and Drought Management Tools (FDMT)','World',2014,NULL,'IWA',NULL,'The Flood and Drought Management Tools (FDMT)  project isfunded in 2014 by the Global Environmental Facility (GEF), International Waters (IW) andimplemented by the United Nations Environment Programme (UNEP) with DHI and theInternational Water Association (IWA) as executing agencies. This project is developing a packageof web-based technical applications (tools),',NULL,'www.flooddroughtmonitor.com','UNEP',NULL,'IWA Flood and Drought Portal home pag',NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2019-02-27 00:00:00'),(70,'EN',4000,20000,0,0,1,1,1,1,'AAORG00000001','DRIDANUBE','DUS (Drought User Service)','Europe',NULL,NULL,'International Commission for the Protection of the Danube River',NULL,'he Drought User Service (DUS), which will enable more accurate and efficientdrought monitoring and early warning for the entire Danube region. It will include a set of EarthObservation data from a range of operational remote sensing satellites, which are processed intoready-to-use drought information, available to the general public with a web-browser interface.With this service, the operational day-to-day work of national authorities, and end users such asfarmers and water managers, will be improved in all phases of drought-related disastermanagement (from monitoring, forecasting and evaluation to response).','The available data product catalogue will provide several products generated from satellite data,e.g. surface soil moisture, vegetation status, and maps with a forecast of the expected agricultural yield. The products will be pre-processed by the DriDanube project partners and provided on adaily to weekly basis in order to map dynamic drought events. The inspection of the products will be done via an easy-to-use web-interface (see Figure 2).Furthermore, the interface can be used to overlay auxiliary map layers like OpenStreetMap and administrative boundaries,',NULL,'ICPDR',NULL,'Simplified DroughtUser Service scheme',NULL,'Prototype of the Drought User Service (DUS) interface',NULL,NULL,NULL,NULL,0,0,NULL,'2019-02-27 00:00:00'),(71,'EN',7000,20000,0,0,0,0,0,1,'AAORG00000001','Horizon 2020','SWOS - Satellite-based Wetland Observation Service','Local area / World',NULL,NULL,'European Commission',NULL,'The Satellite-based Wetland Observation Service (SWOS) uses Earth Observation data (includingdata from ESA’s Sentinel satellites) to generate mapping products and indicators of wetlands.Timely observations allow for dynamic monitoring of wetland conditions and changes (and theirdrivers) on a large spatial and temporal scale.','SWOS provides a toolbox for users experienced with satellite data to process these data andgenerate map products (e.g. inventory and delineation, land use land cover and short- and long-termchanges, surface water dynamics, soil moisture, water quality, surface temperature) and indicators.Non-expert users can directly access final products online from the SWOS portal, which alsoprovides access to raw satellite data and external data resources. All map products are provided withInspire-compliant metadata for easier integration into global wetland portals such as GEO-wetland.Geoclassifier is available as standalone software, but also as a plug-in for Arc-GIS and soon forQGIS',NULL,'European Commission',NULL,'SWOS data porta',NULL,'Geoclassifier toolbox',NULL,NULL,NULL,NULL,0,0,NULL,'2019-02-28 00:00:00'),(72,'EN',7000,20000,0,0,0,0,1,1,'AAORG00000001','IOWater','BaladOmarais mobile application','France',NULL,NULL,'IOWater',NULL,'BaladOmarais is a mobile application developed by IOWater that can be used for discoveringwetlands in mainland France, French overseas territories and French-speaking countries, bygeolocation or in your area.It can be used to find thecoordinates of wetlandinformation centers. As anexample, each year, the appinventories events organizedaround World Wetlands Day(2 February),',NULL,NULL,'IOWater',NULL,'BaladOmarais mobileapplication',NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2019-02-28 00:00:00'),(73,'EN',1000,20000,0,0,1,1,1,1,'AAORG00000001','BRGM','ADES - French National Data Base on Groundwate','France',NULL,NULL,'BRGM',NULL,'The ADES website managed by the BRGM with thefinancial support of AFB, provides public access to data on groundwater chemicalquality and groundwater levels,the mapped results, metadata,and a series of information updates. As a one-stop point of access to relevant information, itconstitutes an essential tool for optimalmanagement of water resources, enhancesunderstanding of groundwater changes, andcontributes solutions for local, national,societal and European issues.','Discovering groundwater monitoring networksData come from more than 70,000 representative monitoring stations scattered all over thecountry. These stations measure key components of groundwater quality (qualitometers), andgroundwater levels (piezometers). Some stations can insure both measurements. The ADES databank gives access to descriptive data sheets for all of the monitoring stations: geographicalcoordinates, location on a map, station operators (water agencies, local and regional authorities,decentralized state administrative authorities, the French geological survey –BRGM, etc.),measurement frequencies, aquifers monitored, etc.#Carrying out an effective searchThe ADES data bank proposes several ways to access observation stations, technical data sheets,and data on quality (chemical analyses results) and/or groundwater levels (piezometric head). Itfeatures numbered buttons for quick access. °Quick access, by entering free expression in empty boxes with localization, type of data you arelooking for (monitoring station, parameter, water level); °Advanced search page: you can select by location on a map, or by specific network, company,aquifer, groundwater body or national code (BSS1). Whatever the access route, the results can be stored for later use.# Access, view, data exportThe ADES website provides access to export sets of data and offers users various features suchas: °Maps and photos; °Graphs: plot two chemical parameters for the same qualitometer on the same chart, and up tofive for a piezometric station.°Reliable indicators that are up-to-date, comparable and meet the needs of end-users.The website also offers an indicator on the hydrogeological situation of a piezometer for a longperiod (minimum 10 years), with tables, graphs and maps.','http://www.ades.eaufrance.fr','BRGM',NULL,'Example of ADES web pages',NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2019-02-28 00:00:00'),(74,'EN',2000,20000,0,0,1,1,1,1,'AAORG00000001',NULL,'Water Accountability in Transboundary Chu-Talas River Basins','Kyrgyzstan/Kazakhstan',NULL,NULL,'SDC',NULL,'This project focuses on the complete modernization of bottom-up demand scheduling and a top-down supply-driven water distribution system in the Chu-Talas River Basins. It includes:°Full digitization and automation of the accounting procedures in place with state-of-the-artinformation technology; °Development of new capabilities for planning, effective operational analysis, as well asreporting and data/knowledge exchange.Whereas in the existing system, data requests had in many cases to be laboriously communicatedvia fax and/or telephone, thanks to a modern digital WIS-type system, stakeholders will be able toimmediately query selected data on their computer terminals and/or tablets safely and securely. The data will be available for operational use and / or for reporting etc. and prepared in a way thatit is easily accessible and understandable for all stakeholders, from the WUA level up to thenational and transboundary scales.The activities led by IOWater in collaboration with hydrosolutions Ltd. and local expertconsultants, mainly aim to increase water delivery effectiveness though better on-time datamanagement, processing, and information production and dissemination.',' Among the main resultsit is particularly expected that thanks to the improvement of the water data managementprocedures:°At local level, the authority in charge of water allocation for irrigation will have the capacity tofollow online (on a tablet) the status of water allocation on a daily basis;\r\n4 MAIN DOMAINS OF APPLICATIONHANDBOOK WATER INFORMATION SYSTEMS  ADMINISTRATION, PROCESSING AND EXPLOITATION OF WATER-RELATED DATAwww.inbo-news.org | www.unesco.org/water/97(Cont’d)°At basin and national level, the national and basin authority will have access to new nationalinformation services (reports, indicators, bulletins, maps) facilitating the analysis of waterallocation efficiency per sector and per canal;°At transboundary level, transboundary data sharing will be reinforced with regular productionof transboundary bulletins on the water resource and water allocation situation.',NULL,'IOWater',NULL,'Example of interactive irrigation schemes on the Chu basin In Kirghizstan',NULL,'Draft georeferenced delineation of irrigation unit on the Chu basin in Kirghizstan',NULL,NULL,NULL,NULL,0,0,NULL,'2019-02-28 00:00:00'),(75,'EN',1000,20000,0,0,1,1,1,1,'AAORG00000001','IOWater','Aires - Areas of protection of drinking water catchments','France',NULL,NULL,'AFB',NULL,'This portal encourages stakeholder networking, centralizes anddisseminates some resources (data, documentation) on catchment protection, and combatsdiffuse pollution: all scientific and technical resources (tools and methodology) are available forfinal users.','Each section of the portal is designed to respond to the needs of the facilitators of all of thecatchment areas. The creation of a specific fact sheet describing each catchment area in France isan innovative approach. The information contained in these sheets comes from external databasesbut also from data directly entered by some of the portal’s users. This web portal is linked toother websites in order to make the selection of useful documentation easier and indicate trainingsessions for stakeholders involved in all catchment areas. Finally, the portal disseminates the workcarried out by the resource centre and by numerous partners of this project. OIEau conducted asurvey of European countries to identify their practices against diffuse pollution. OIEau showcasesthese European member state experiences on the web portal.','https://aires-captages.fr','IOWater',NULL,'Example of data processing with the application Aires',NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2019-02-28 00:00:00'),(76,'EN',1000,20000,0,1,1,1,1,1,'AAORG00000001',NULL,'GisAgua - Aguas de La Habana','Cuba',NULL,NULL,'Aguas de La Habana',NULL,'GisAgua is a GIS application specialized in the integrated management of the urban water cycle bymeans of the administration of a geographically referenced database that groups information oncartography, supply and sewerage. The development of GIS facilitates the consulting and spatialassessment of the infrastructure’s data, speeds up decision-making and provides aqueductcompanies with a modern tool for to plan, operate and maintain their system.','The development offers all the editing, analysis and results presentation that characterize GIS.Within its potentials, one can find the customized tools for the work on the aqueductinfrastructure (Figure 1), with the purpose of demarcating failures or scheduled shut downs, areasaffected by the lack of water, connections to the network’s mathematical models, studies of waterlosses, direct ties with the users and follow-ups during the maintenance periods. Likewise, it hasspecific developments for the management and assessment of the sewerage network, as well asfor the elaboration of new supply, sewerage, and rainwater drainage projects.The use of geographical locations is an important function used by the system to defineexploitation parameters. The multi-user editing on the Data Base makes the system provide fastinstruments for constant update. GisAgua can be the entrance and exit point for an importantnumber of computer applications of general use in a water supply company.The project GisAgua-Aguasde La Habana has become anessential tool for thedevelopment of the hydraulicand sewerage infrastructureof the capital city. It isconsidered to be of a greatuse for the planning andstrategies in a short,medium, and long-term, dueto its ability to generatemulti-criteria studies withgeographically referencedcomponents. It has become aconnection interface withentrance and exit points forthe company’s diversecontrol, management andoperation computer systems.The tool goes beyond theborders of Aguas de LaHabana by becoming anessential information sourcefor urban growth andterritorial organizationprojects, and studies onrational and productive useof water. The aforementionedproject has laid thefoundations for thedevelopment of water andsewerage informationsystems in Cuba byestablishing the needs for itsefficient development.',NULL,NULL,NULL,'Some infrastructures of the “La Habana” main water supply network',NULL,'Example of information on the pipes of La Habana water supply network',NULL,NULL,NULL,NULL,0,0,NULL,'2019-02-28 00:00:00'),(77,'EN',1100,20000,0,0,1,1,1,1,'AAORG00000001','IOWater','SISPEA - Water and SanitationPublic Utility Information System','France',2009,NULL,'ONEMA (AFB)',NULL,'In France, as in a number of European countries,performance indicators (PIs) for monitoring waterand sanitation utilities have been significantly developed since the end of the 1990s. Todisseminate this information on the performance of water and sanitation utilities as widely aspossible and make relevant comparisons, ONEMA (now integrated into AFB) has been charged with creating a monitoring systemcompiling both descriptive data andindicators of the French services. ts role is to gather all data andperformance indicators from localauthorities or from their operators,to compare them and point out areasfor improvement. It then producesan annual consolidated nationalreport on the performance of waterand sanitation services.','The Sispea smartphone application and the mobile site provide access to data on public water andsanitation services: management mode, price of services, yield, water quality, claim rate, etc., bygeolocation or by search for a municipality.','http://www.services.eaufrance.fr/','IOWater',NULL,'water prices in France per Department',NULL,'Interface of the Sispea smartphone application',NULL,NULL,NULL,NULL,0,0,NULL,'2019-02-28 00:00:00'),(78,'EN',2000,20000,0,0,1,1,1,1,'AAORG00000001',NULL,'WISE - Water Information System for Europ','Europe',2007,NULL,'European Commission/DG Environment / Eurostat',NULL,'WISE is a shared information system providing water-relatedinformation available at European level. It works to modernize and streamline the collection anddissimation of information related to  European water policy. Its formal reporting framework is theEuropean Water Framework Directive. was launched for public use as a web-based service in 2007 providing a web-portal entry towater-related information ranging from inland waters to marine waters. The web-portal is groupedinto sections covering:°EU water policies (directives, implementation reports and supporting activities, etc.);°Data and topics(reported datasets, interactive maps, statistics, indicators); °Modelling(current - and forecasting services across Europe); °Projects and research(inventory for links to recently completed and ongoing water-relatedprojects and research activities).','The main objectives of WISE are: °To provide a single entry point to access harmonized, high-quality European water data andinformation provided by mainly Member States; °To assess and compare environmental status and trends related to water and their associatedpressures and impacts from human activities including the underlying socio-economic drivingforces;.°To check the compliance with and implementation of European water legislation and nationallaws and inform the citizens thereof;°To use the collected information to assess the effects and effectiveness of EU water policy.','http://water.europa.eu/',NULL,NULL,'Example of WISE application interface',NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2019-02-28 00:00:00'),(79,'EN',2000,20000,0,0,1,1,1,1,'AAORG00000001','European Commission','The Structured Implementation and Information Framework (SIIF)','Europe',2012,NULL,'European Commission',NULL,'The Structured Implementation and Information Framework (SIIF)concept is an ongoingEuropean Commission (Environment Directorate General) project essentially focused on theorganization and management of data in order to enhance the generation of information for policymakers, interested parties and the public at all levels on how legislation is practicallyimplemented. The concept developed is in line with the provisions of the Public Access toEnvironmental Information and INSPIRE Directives.The SIIF concept is composed of a governance approach and an IT system.The SIIF implies governance focused on compliance, good environmental status, environmentalpressure and impact, economic activities, and job creation. It also has an objective to reduce theadministrative burden, provide more up-to-date data, and increase efficiency for all potentialusers. Providing an implementation programme on how to reach or maintain policy compliance isalso part of the SIIF governance approach.','The SIIF’s IT system features three components: (1) content for the data community (informationneeds and how they are organized); (2) the process for data providers (who does what and how);(3) dissemination for data users (how to display). All of these components have a national andEuropean dimension.This IT development is related to the process and dissemination of the existing content of theEuropean urban waste water data model.The SIIF project opted to implement an open-source IT toolbox. The tool was designed todisseminate environmental data and information at national level but also to facilitate the reportingprocess. It provides EU Member States with a cheap way to implement Article 11 of the INSPIREdirective, and thus to develop a national waste water website. The framework of this website canalso be adapted to correspond to other European Policies.',NULL,'IOWater',NULL,'Cover page of the UWWTD SIIFEuropean node',NULL,'Urban waste water treatment plants in France',NULL,NULL,NULL,NULL,0,0,NULL,'2019-02-28 00:00:00'),(80,'EN',2000,20000,0,1,1,1,1,1,'AAORG00000001','ICPR','WasserBLIcK','Europe',NULL,NULL,'ICPR',NULL,'For the purpose of data management related to the implementationof both the European Water Framework Directive and the FloodsDirective within the Rhine basin, the ICPR has concluded acooperation agreement with the German Federal Institute ofHydrology (BfG) comprising the use of the water portal“WasserBLIcK”(data exchange and hosting platform) and theproduction of different maps for the general and specialized public.','Rhine Warning and Alarm Plan After the chemical accident at Sandoz in 1986, the ICPR strengthenedits international Warning and Alarm Plan (WAP). If, despite allpreventive measures, an accident occurs or great amounts ofhazardous substances flow into the Rhine that may detrimentallyimpact the water quality or drinking water supply along the river, themodel-based WAP is activated, which above all warns all usersdownstream. Apart from warnings, which are only issued by theInternational Main Alert Centres (IAC) during huge and serious waterpollution events, the WAP is increasingly used as an instrument forexchanging reliable information on sudden water pollution measuredby monitoring stations along the Rhine, Neckar and Main rivers and smaller tributaries. The warningsand information issued every year are compiled in an annual report available on the ICPR website. # Transboundary Information systems related to flood risk managementThe “Rhine Atlas”is a supra-national sensitization tool comprising aggregated flood hazard and riskmaps of the countries on the river. For the main stream of the Rhine, flood depth and areas as well asobjects at risk are shown for three scenarios (high, medium and low flood probability). Additionalinformation and more detailed national maps are available by clicking on any area of the atlas. TheRhine Atlas, which is available on the ICPR website, raises risk awareness, supports theimplementation of preventive measures in flood-prone areas, and represents a database for riskcalculations (see below, the tool ICPR FloRiAn). # Flood forecasting and flood announcement contribute to reducing damage in case of a flood event.Therefore, the Rhine countries – through national centres along the river - cooperate at internationallevel when exchanging data on discharge and precipitation and using them for flood forecasting. Thequality of information and forecasting is continuously being improved. Today, national mobileapplications like “Meine Pegel” (my gauges) disseminate information and warnings on water levels.# Instrument for assessing the impact of flood risk management measures on risk evolution:The ICPR,supported by the engineering consultant HKV, developed the GIS instrument “ICPR FloRiAn (FloodRisk Analysis)”. Its purpose is to evaluate the effect of measures to reduce flood risk and estimate thefuture evolution of flood risk. Flood maps (e.g. developed under the FD) are the basis for the tool. Inaddition to the quantification of economic flood risk, modules are developed for quantifying theconsequences of risks for human health, the environment and cultural heritage. In short, the maininstrument consists of three interacting calculation modules resulting in an overall damage or riskassessment. The ICPR uses this tool to assess risk reduction and evolution along the Rhine takinginto account the impacts of measures. The instrument is available on demand from the ICPR and isapplicable to other river basins.',NULL,'ICPR',NULL,'The International Main AlertCentres (IAC) and information flow',NULL,'Rhine Atlas (floodhazard and flood risk maps)',NULL,NULL,NULL,NULL,0,0,NULL,'2019-02-28 00:00:00'),(81,'EN',2000,20000,0,1,1,1,1,1,'AAORG00000001','The International Sava River Basin Commission','Sava GIS - GeoInformation System for the Sava River Basin','Europe',2016,NULL,NULL,NULL,'The overall objective of Sava GIS is to provide good communicationchannels for the Sava Commission community in order to share and disseminate information andknowledge about protection of water resources and water management activities in the Sava RiverBasin. It also facilitates the exchange and use of hydrological and meteorological information anddata through its component, the Hydrological Information System (Sava HIS).','he focus of the Sava Geoportal is datavisualization and management as well as open web services like WFS and WMS. Once the systemis fully functional, interested parties (government institutions, private entities, general public, etc.)will be able to view available datasets through the Sava Geoportal and its submodules (MetadataCatalogue, Sava HIS). The Sava GIS Geoportal can be reached at: http://savagis.org/. A webapplication for editing, loading and retrieving data and metadata allows registered users to view,visualize, share and retrieve geographic information and datasets stored in the database for thewhole basin. Sava HIS, as the Sava GIS component, represents a tool for collecting, storing, analyzing andreporting sufficiently high-quality hydrological and meteorological data. The overall objective ofSava HIS is to support Sava countries in sharing and disseminating hydrologic and meteorologicaldata, information and knowledgeabout water resources in the SavaRiver Basin. These data andinformation are used by decision-making systems in all aspects ofwater resources management,especially flood risk managementand forecasting, and in a widerange of operational applicationsand research. Since the WaterML2.0 format is implemented in SavaHIS, the WMO exchange standard,the system can store waterobservation data and spatialinformation, shared by countries,in a standard format. It alsosupports data sharing andpublication via web services forfurther use.','http://savagis.org/',NULL,NULL,'Screen shot of the Sava GIS',NULL,'Screen shot of the Sava HIS',NULL,NULL,NULL,NULL,0,0,NULL,'2019-02-28 00:00:00'),(82,'EN',2000,20000,0,0,1,1,1,1,'AAORG00000001','ANBO','African Water Documentation and Information System (AWIS)','Africa',2007,NULL,'ANBO',NULL,'AWIS aims to build the information management capacity of organizations in the African watersector through sharing knowledge, experience and information between water professionals,communities and local and national governments on a pan-African scale.','AWIS is a strategic tool of ANBO (African Network of Basin Organizations), and provides amanagement platform of information and knowledge on the scale of Africa.The targets of the ANBO resource centre are operational actors of public policies involved in waterresource management: ministries (central, decentralized), basins, organizations, associations,socioeconomic actors, education / training organizations, water users, local communities andconsumer authorities.','http://www.african-wis.org/','IOWater',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'2019-02-28 00:00:00');
/*!40000 ALTER TABLE `t_dmcase` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_dmpurpose`
--

DROP TABLE IF EXISTS `t_dmpurpose`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dmpurpose` (
  `DMPCODE` int(11) NOT NULL,
  `DMPNAME` varchar(80) DEFAULT NULL,
  `DMPNAME2` varchar(80) DEFAULT NULL,
  `DMPNAME3` varchar(80) DEFAULT NULL,
  `DMPMain` smallint(6) DEFAULT NULL,
  `DMPCLASS` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`DMPCODE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_dmpurpose`
--

LOCK TABLES `t_dmpurpose` WRITE;
/*!40000 ALTER TABLE `t_dmpurpose` DISABLE KEYS */;
INSERT INTO `t_dmpurpose` VALUES (1,'_Not determined',NULL,NULL,0,NULL),(1000,'SECTORIAL WATER MANAGEMENT (SWM)',NULL,NULL,1,NULL),(1100,'SWM/ Drinking water supply and sanitation',NULL,NULL,1,NULL),(1200,'SWM/ Irrigation',NULL,NULL,1,NULL),(1300,'SWM/ Energy',NULL,NULL,1,NULL),(1400,'SWM/ Health',NULL,NULL,1,NULL),(2000,'IWRM= Integrated Water resource management national or basin level',NULL,NULL,2,0),(2100,'IWRM/Etat des Lieux',NULL,'Linea base',2,NULL),(2200,'IWRM/Diagnostic',NULL,NULL,2,NULL),(2210,'IWRM/Diag/ Presentation generale',NULL,NULL,2,NULL),(2220,'IWRM/Diag/ Risque non atteinte objectif',NULL,NULL,2,NULL),(2230,'IWRM/Diag/ Etat',NULL,NULL,2,NULL),(2240,'IWRM/Diag/ Economie',NULL,NULL,2,NULL),(2250,'IWRM/Diag/ Zones protégées',NULL,NULL,2,NULL),(2260,'IWRM/Diag/ Pressions',NULL,NULL,2,NULL),(2270,'IWRM/Diag/ Scenario tendanciel',NULL,NULL,2,NULL),(2280,'IWRM/Diag/ Recuperation couts',NULL,NULL,2,NULL),(2300,'IWRM/ SDAGE',NULL,NULL,2,NULL),(2400,'IWRM/POM',NULL,NULL,2,NULL),(2500,'IWRM//MO/ Suivi avancement SDAGE/PoM',NULL,NULL,2,NULL),(2510,'IWRM/MO/ programme de surveillance',NULL,NULL,2,NULL),(2520,'IWRM/MO/ tableau de bord SDAGE Conseil Bassin',NULL,NULL,2,NULL),(2530,'IWRM/MO/ tableau de bord SDAGE Public',NULL,NULL,2,NULL),(2540,'IWRM/MO/ bilan du PDM',NULL,NULL,2,NULL),(3000,'CLIMATE CHANGE ADAPTATION',NULL,NULL,3,NULL),(4000,'RISK MANAGEMENT',NULL,NULL,4,NULL),(4100,'RM/ Flood risk management',NULL,NULL,4,NULL),(4200,'RM/ Drought management',NULL,NULL,4,NULL),(5000,'REPORTING',NULL,NULL,5,NULL),(5100,'REP/SDG',NULL,NULL,5,NULL),(5200,'REP /EU',NULL,NULL,5,NULL),(7000,'Aquatic Ecosystem protection',NULL,NULL,7,NULL),(8000,'Transboundary basins',NULL,NULL,NULL,NULL),(9000,'Other purpose',NULL,NULL,9,NULL),(9100,'Territorial management',NULL,NULL,6,NULL);
/*!40000 ALTER TABLE `t_dmpurpose` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_dmstep`
--

DROP TABLE IF EXISTS `t_dmstep`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dmstep` (
  `DMSCODE` int(11) NOT NULL,
  `DMSNAME` varchar(120) NOT NULL,
  `DMSNAME2` varchar(120) DEFAULT NULL,
  `DMSNAME3` varchar(120) DEFAULT NULL,
  `DMSSNAME` varchar(120) DEFAULT NULL,
  `DMSSNAME2` varchar(120) DEFAULT NULL,
  `DMSSNAME3` varchar(120) DEFAULT NULL,
  `DMSMAIN` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`DMSCODE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_dmstep`
--

LOCK TABLES `t_dmstep` WRITE;
/*!40000 ALTER TABLE `t_dmstep` DISABLE KEYS */;
INSERT INTO `t_dmstep` VALUES (0,'Step not determined','Activité non déterminé',NULL,'/',NULL,NULL,0),(10000,'Processus classique incluant toutes ou au moins 2 étapes','Processus global incluant toutes ou au moins 2 étapes',NULL,'/',NULL,NULL,1),(20000,'Governance of data management','Gouvernance gestion des données',NULL,'/',NULL,NULL,1),(21000,'Governance of data management',NULL,NULL,'Legislative text',NULL,NULL,0),(22000,'Governance of data management',NULL,NULL,'Instrument for coordination',NULL,NULL,0),(23000,'Governance of data management',NULL,NULL,'Study related to data  governance',NULL,NULL,0),(30000,'Data production','Production des données',NULL,'/',NULL,NULL,1),(40000,'Shared and integrated data management','Gestion intégrée et partagée des données',NULL,'/',NULL,NULL,1),(50000,'Data processing and valorisation','Traitement et valorisation des données',NULL,'/',NULL,NULL,1),(60000,'Information/knowledge dissemination','Diffusion des connaissances',NULL,'/',NULL,NULL,1),(80000,'Service et projets d\'intelligence numérique',NULL,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `t_dmstep` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_dmtool`
--

DROP TABLE IF EXISTS `t_dmtool`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dmtool` (
  `DMTCODE` int(11) NOT NULL AUTO_INCREMENT,
  `DMTDMTTYPECode` int(11) DEFAULT NULL,
  `DMTLACODE` varchar(2) DEFAULT NULL,
  `DMTACRONYM` varchar(50) DEFAULT NULL,
  `DMTNAME` varchar(150) DEFAULT NULL,
  `DMTNAME2` varchar(150) DEFAULT NULL,
  `DMTTMONIT` int(11) DEFAULT NULL,
  `DMTTTRANS` int(11) DEFAULT NULL,
  `DMTTDBGIS` int(11) DEFAULT NULL,
  `DMTTMODEL` int(11) DEFAULT NULL,
  `DMTTPROCESS` int(11) DEFAULT NULL,
  `DMTTREPORT` int(11) DEFAULT NULL,
  `DMTTPLATFORM` int(11) DEFAULT NULL,
  `DMTDESC` mediumtext,
  `DMTDESC2` mediumtext,
  `DMTURL1` varchar(150) DEFAULT NULL,
  `DMTURL2` varchar(150) DEFAULT NULL,
  `DMTDOCSOURCE` varchar(150) DEFAULT NULL,
  `DMTCOST` varchar(100) DEFAULT NULL,
  `DMTADORCODE` varchar(14) DEFAULT NULL,
  `DMTADORNAME` varchar(150) DEFAULT NULL,
  `DMTIMA1URL` varchar(200) DEFAULT NULL,
  `DMTIMA1TITLE` varchar(200) DEFAULT NULL,
  `DMTIMA2URL` varchar(200) DEFAULT NULL,
  `DMTIMA2TITLE` varchar(200) DEFAULT NULL,
  `DMTSFLANGUAGE` varchar(50) DEFAULT NULL,
  `DMTSFLICENSE` varchar(50) DEFAULT NULL,
  `DMTMDDOMAIN` varchar(50) DEFAULT NULL,
  `DMTMDDIM` varchar(50) DEFAULT NULL,
  `DMTMDFLOWTYPE` varchar(150) DEFAULT NULL,
  `DMTMDSURFACE` varchar(50) DEFAULT NULL,
  `DMTMDEQUATION` varchar(150) DEFAULT NULL,
  `DMTSFDATAENTRY` mediumtext,
  `DMTMDREGIME` varchar(150) DEFAULT NULL,
  `DMTMDMAILLAGE` varchar(250) DEFAULT NULL,
  `DMTAUTHNAME` varchar(200) DEFAULT NULL,
  `DMTAUTHADCOCODE` varchar(16) DEFAULT NULL,
  `DMTAUTHEMAIL` varchar(80) DEFAULT NULL,
  `DMTCOMM` mediumtext,
  `DMTCOMM2` mediumtext,
  `DMTDISSLEV` int(11) DEFAULT '0',
  `DMTLABVALID` int(11) DEFAULT '0',
  `DMTPERT` int(11) DEFAULT '0',
  `DMTUPDATE` datetime NOT NULL,
  PRIMARY KEY (`DMTCODE`),
  KEY `FK_type_tool` (`DMTDMTTYPECode`),
  CONSTRAINT `FK_type_tool` FOREIGN KEY (`DMTDMTTYPECode`) REFERENCES `t_dmttype` (`DMTTCODE`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_dmtool`
--

LOCK TABLES `t_dmtool` WRITE;
/*!40000 ALTER TABLE `t_dmtool` DISABLE KEYS */;
INSERT INTO `t_dmtool` VALUES (1,0,'EN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'_non déterminé',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,'1970-01-01 00:00:00'),(2,22000,'EN','MIKE SHE','MIKE SHE',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'modélisation des eaux de surface et et souterraine, hydrologie intégrée des BV, gestion de l\'irrigation et dfe la sécheresse, gestion et restauration des zones humides, gestion des plaines d\'inondation, utilisation des sols et changement climatiques, dépollution de l\'eau souterraine.',NULL,'http://www.mikebydhi.com/Products/WaterResources/MIKESHE.aspx',NULL,NULL,NULL,NULL,'DHI',NULL,NULL,NULL,NULL,NULL,NULL,'Hydrologie','1D & 2D',NULL,NULL,'Richard',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,'1970-01-01 00:00:00'),(3,22000,'EN','MIKE FLOOD','MIKE FLOOD',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'inondations urbaines',NULL,'http://www.mikebydhi.com/Products/WaterResources/MIKEFLOOD.aspx',NULL,NULL,NULL,NULL,'DHI',NULL,NULL,NULL,NULL,NULL,NULL,'Modélisation de crue','1D & 2D',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,'1970-01-01 00:00:00'),(4,22000,'EN','MIKE 11','MIKE 11',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'simulation d\'inondations, de transport de sédiments et de la qualités de l\'eau dans les rivières et canaux',NULL,'http://www.mikebydhi.com/Products/WaterResources/MIKE11.aspx',NULL,NULL,NULL,NULL,'DHI',NULL,NULL,NULL,NULL,NULL,NULL,'Hydraulique','1D',NULL,NULL,'Saint Venant (différences finies)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,'1970-01-01 00:00:00'),(5,22000,'EN','MIKE 21','MIKE 21',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'hydraulique côtière et océanographique, effet de vagues, transport sédimentaire',NULL,'http://www.mikebydhi.com/Products/CoastAndSea/MIKE21.aspx',NULL,NULL,NULL,NULL,'DHI',NULL,NULL,NULL,NULL,NULL,NULL,'Hydraulique côtière et océanographique','2D',NULL,'Libre','Saint Venant (différences finies)',NULL,NULL,'standard (régulier, méthode desdifférences finies)/curvilinéaire (semi-régulier, méthode des différences finies)/flexible (irrégulier, méthode des volumes finis)',NULL,NULL,NULL,NULL,NULL,0,NULL,0,'1970-01-01 00:00:00'),(6,22000,'EN','ISIS','ISIS',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'modélisation des débits et niveaux d\'eau dans les canaux ouverts et les plaines inondables, modélisation de structures telles que des ponts, des biefs d\'écoulement, des ponceaux, des pompes et des déversoirs.',NULL,'http://www.isisuser.com/isis/isisfree.asp',NULL,NULL,NULL,NULL,'Halcrow',NULL,NULL,NULL,NULL,NULL,NULL,'Hydraulique/Hydrodynamique','1D & 2D','débits uniformes, transitoires, sous-critiques, surcritiques et de transition',NULL,'Saint Venant',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,'1970-01-01 00:00:00'),(7,22000,'EN','HEC-RAS','HEC-RAS',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'analyse des débits dans les lits de rivière, détermine les zones inondables',NULL,'http://www.hec.usace.army.mil/software/hec-ras/',NULL,NULL,NULL,NULL,'Hydrologic Engineering Center (HEC) de l’U.S. Army Corps of Engineers (USACE)',NULL,NULL,NULL,NULL,NULL,NULL,'Hydraulique','1D','subcritique, de transition, supercritique',NULL,'Saint Venant',NULL,'permanent/non permanent',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,'1970-01-01 00:00:00'),(8,22000,'EN','HEC-HMS','HEC-HMS',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'permet de subdiviser un bassin versant en plusieurs sous-bassins, simuler le comportement hydrologique de bassins versants non urbanisés, logiciel permet de calculer des hydrogrammes de crues, modèles pour le calcul des précipitations, du volume de ruissellement, du ruissellement direct et  des écoulements souterrains.',NULL,'http://www.hec.usace.army.mil/software/hec-hms/',NULL,NULL,NULL,NULL,'Hydrologic Engineering Center (HEC) de l’U.S. Army Corps of Engineers (USACE)',NULL,'dmtiA1titre1','0','0',NULL,NULL,'Hydrologie','1D',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,'2016-09-15 00:00:00'),(9,22000,'EN','TELEMAC 2D','TELEMAC 2D',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'TELEMAC2D fournit en chaque nœud du maillage des laveleurs des variables de base : la hauteur d\'eau et les composantes horizontales des vitesses moyennées sur la hauteur d\'eau. Il prend en compte les facteurs suivants : rugosité, turbulence, vitesse du vent, variations de la pression atmosphérique, forces d\'attraction des marées solaire et lunaire, digues submergées, déversoirs et conduites.','Dans le milieu maritime : conception de la structure de ports, étude de l\'impact de brises-lames submersibles ou aautres travaux de dragage. Dans les rivières : impact de construction telles que des ponts, seuils et épis, rupture de barragesn études d\'inondation, ..','http://www.opentelemac.org/index.php/presentation?id=17',NULL,'Logiciels d\'ingénierie du cycle de l\'eau vol.9 - J.M. Tanguy',NULL,NULL,'EDF R&D',NULL,NULL,NULL,NULL,'Fortran90','Libre','Hydraulique/Hydrodynamique','2D','fluviaux/torrentiels','libre','Saint Venant (éléments finis)',NULL,'permanent/transitoire','triangulaire non structuré',NULL,NULL,NULL,NULL,NULL,0,NULL,0,'1970-01-01 00:00:00'),(10,22000,'EN','TELEMAC 3D','TELEMAC 3D',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'Le domaine d\'application originel de TELEMAC3D est le milieu matitime côtier à travers les études de courants induits par la marée ou par les gradients de densité, avec ou sans influence de forçage externe (vent, surcote, etc.). Dans le domaine des eaux continentales, on peut également citer l\'étude des panaches thermiques en rivières, de comportement hydrodynamique de las naturels ou artificiels. TELEMAC3D est rattaché aux modules : SUBIEF3D, SISYPHE, SEDI3D et POSTEL3D.',NULL,'http://www.opentelemac.org/index.php/presentation?id=18',NULL,'Logiciels d\'ingénierie du cycle de l\'eau vol.9 - J.M. Tanguy',NULL,NULL,'EDF R&D',NULL,NULL,NULL,NULL,'Fortran90',NULL,'Hydraulique (Milieu maritime côtier)','3D',NULL,'libre','Navier Stokes (évolutives au cours du temps sous l\'hypothèse d\'une répartition hydrostatique ou non des pressions par la méthode des éléments finis)',NULL,NULL,'Maillage constitué de prismes à base triangulaire',NULL,NULL,NULL,NULL,NULL,0,NULL,0,'1970-01-01 00:00:00'),(11,22000,'EN','SISYPHE','SISYPHE',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'SISYPHE est un module de transport de sédiment par charriage et en suspension à partir des résultats de l\'hydrodynamique. Les formulations des lois de transport classiques sont incluses : Engelund-Hansen, Einstein-Brown et Bijker.',NULL,'http://www.opentelemac.org/index.php/modules-list/164-sysiphe-sediment-transport-and-bed-evolution',NULL,'Logiciels d\'ingénierie du cycle de l\'eau vol.9 - J.M. Tanguy',NULL,NULL,'EDF R&D',NULL,NULL,NULL,NULL,'Fortran',NULL,'Transport de sédiment','2D',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,'1970-01-01 00:00:00'),(12,22000,'EN','MASCARET','MASCARET',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'propagations de crues et modélisations des champs d’inondations, les ondes de submersion résultant de rupture d’ouvrages hydrauliques, les régulations de rivières et les propagations d’onde dans les canaux (intumescences, éclusées, mise en eau). Il prend en compte les singularités des rivières telles que les barrages et seuils.',NULL,'http://www.opentelemac.org/index.php/presentation?id=138',NULL,'Logiciels d\'ingénierie du cycle de l\'eau vol.9 - J.M. Tanguy',NULL,NULL,'EDF R&D',NULL,NULL,NULL,NULL,'Fortran 90','Libre','Hydraulique (études d\'ondes de submersion)','1D','Fluviaux/transcritiques/torrentiels','Libre','Saint Venant écrites sous forme conservative (volumes finis)',NULL,'permanent/non permanent',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,'1970-01-01 00:00:00'),(13,22000,'EN','ARTEMIS','ARTEMIS',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'ARTEMIS traite les modélisations de la houle avec prise en compte de la réfraction, diffraction et réflexion par les obstacles, incluant l\'effet de la rugosité du fond et le déferlement à l\'approche du rivage.',NULL,'http://www.opentelemac.org/index.php/presentation?id=19',NULL,'Logiciels d\'ingénierie du cycle de l\'eau vol.9 - J.M. Tanguy',NULL,NULL,'EDF R&D',NULL,'0',NULL,'0','Fortran',NULL,'Etude de la houle','2D',NULL,NULL,'Berkhoff',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,'1970-01-01 00:00:00'),(14,22000,'EN','TOMAWAC','TOMAWAC',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'TOMAWAC est un modèle de houle spectrale de troisième génération. On l\'utilise dans les calculs de propagation des vagues dans les zones côtières',NULL,'http://www.opentelemac.org/index.php/presentation?id=20',NULL,'Logiciels d\'ingénierie du cycle de l\'eau vol.9 - J.M. Tanguy',NULL,NULL,'EDF R&D',NULL,NULL,NULL,NULL,'Fortran',NULL,'Propagation de vagues','2D',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,'1970-01-01 00:00:00'),(15,22000,'EN','MARINE','Modelisation de l\'anticipation du ruisselement et des inondations pour des evenements extremes',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'Le code MARINE, à base physique, permet de simuler des crues à cinétique rapide en temps réel. Il regroupe une fonction de production et une fonction de transfert sur le bassin versant. MARINE fournit en particulier l\'hydrogramme de crue à l\'éxutoire d\'un bassin versant.',NULL,NULL,NULL,'Logiciels d\'ingénierie du cycle de l\'eau vol.9 - J.M. Tanguy',NULL,NULL,'IMFT (Institut de Mécanique des Fluides de Toulouse)',NULL,NULL,NULL,NULL,NULL,NULL,'Crues à cinétique rapide','2D',NULL,NULL,'Darcy / Euler','Données invariantes au cours du temps (MNT, occupation du sol, délimitation du bassin versant, etc.) et données variables (humidité initiale du sol, précipitations)',NULL,'Régulier',NULL,NULL,NULL,NULL,NULL,0,NULL,0,'1970-01-01 00:00:00'),(16,22000,'EN','ATHYS','ATelier HYdrologique Spatialisé','ATelier HYdrologique Spatialisé',NULL,NULL,NULL,1,NULL,NULL,NULL,'ATHYS réunit un ensemble de modèles hydrologiques spatialisés, associés à des traitements de données hydroclimatiques et géographiques. Ses diverses applications sont : gestion de la ressource en eau, calcul de crues de projet, prévision des événements extrêmes, études d\'impaact liées à des modifications anthropiques ou climatiques. ATHYS est constitué de quatre modules : MERCEDES, VISHYR, VICAIR et SPATIAL.',NULL,NULL,NULL,'Logiciels d\'ingénierie du cycle de l\'eau vol.9 - J.M. Tanguy',NULL,NULL,'IRD (Instritut de Recherche pour le Développement)',NULL,NULL,NULL,NULL,NULL,'libre et ouvert','Modèles hydrologiques spatialisés','2D',NULL,NULL,'MERCEDES : SCS, Green&Ampt, Horton, TopModel,  Smith&Parlange','Il y a 3 fichiers de données indispensables : le fichier des épisodes pluie-débit, le fichier MNT, le fichier des directions de drainage. D\'autres fichiers peuvent être utilisés (unités des sols, pente, géologie, réseau hydrographique, etc.)',NULL,'Mailles carrées régulières',NULL,NULL,NULL,NULL,NULL,0,NULL,0,'1970-01-01 00:00:00'),(17,22000,'EN','LARSIM','Large Area Runoff simulation Model','Large Area Runoff simulation Model',NULL,NULL,NULL,1,NULL,NULL,NULL,'LARSIM est un modèle hydrologique conceptuel somprenant des processus déterministes. Il prévoir 2 modes de calcul : \"pluie-débit\" (simulation des événements de crues) et \"régime des eaux\" (simulation coninuelle du débit).',NULL,NULL,NULL,'Logiciels d\'ingénierie du cycle de l\'eau vol.9 - J.M. Tanguy',NULL,NULL,'SourceForge',NULL,NULL,NULL,NULL,NULL,NULL,'Prévision des crues','2D','continus',NULL,NULL,'En mode \"pluie -débit\" : précipitations. En mode \"régime des eaux\" : précipitations, température, vitesse du vent, humidité atmosphér., radiation, pression.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,'1970-01-01 00:00:00'),(18,22000,'EN','TOPMODEL','TOPopgraphy based hydrological MODEL','TOPopgraphy based hydrological MODEL',0,0,0,1,0,0,0,'TOPMODEL est un modèle hydrologique distribué. Il considère que la composante prépondérante dans la génération des crues est le ruissellement par excès de saturation. TOPMODEL utilise une information topographique détaillée pour déduire la distribution spatiale du contenu en eau au sein d’un bassin versant hydrologique.',NULL,NULL,NULL,'Logiciels d\'ingénierie du cycle de l\'eau vol.9 - J.M. Tanguy',NULL,NULL,'K.J. Beven (Lancaster University, Lancaster Environment Centre) et M.J. Kirkby (School of GeographyUniversity of Leeds)',NULL,NULL,NULL,NULL,NULL,NULL,'Modèle hydrologique distribué','2D',NULL,NULL,'indice de similarité hydrologique','Dépendent du mode choisi mais en général : la pluie, le bilan radiatif et caractéristiques géographiques (topographie, caractéristiques hydrodynamiques et épaisseur des sols, couvert végétal et les réseaux de drains anthropiques)',NULL,'Pixel',NULL,NULL,NULL,NULL,NULL,0,0,0,'1970-01-01 00:00:00'),(19,22000,'EN','CANOE','CANOE',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'CANOE est basé sur un système spécifique de gestion de données, son objectif es de fournir un outil unique utilisable pour des tâches telles que le dimensionnement de réseaux d\'assainissement, les études diagnostics ou la simulation de rejets polluants. CANOE se développe autours de 7 applicatifs : gestion des données de projets, gestion des pluies, gestion des conduites, simulation hydraulique, simulation qualité, aide au projet, SIG CANOE.',NULL,NULL,NULL,'Logiciels d\'ingénierie du cycle de l\'eau vol.9 - J.M. Tanguy',NULL,NULL,'LGCIE (Laboratoire de Génie Civil et d\'ingénierie Environnementale) de l\'INSA de Lyon et la société SOGREAH','0','0','0','0',NULL,NULL,'Hydrologie urbaine','1D',NULL,NULL,'Modélilisation hydraulique ; modèle Muskingum/Saint-Venant',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,'1970-01-01 00:00:00'),(20,22000,'EN','RUBAR 3','RUBAR 3',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'Le code RUBAR 3 traite les écoulements transcritiques unidimensionnels en rivières, avec eventuellement lits composés et affluents. Il prend en compte des singularités telles que barrages et seuils et a été initialement conçu pour les études d\'ondes de submersion.',NULL,NULL,NULL,'Logiciels d\'ingénierie du cycle de l\'eau vol.9 - J.M. Tanguy',NULL,NULL,'CEMAGREF (Centre national du machinisme agricole du génie rural, des eaux et des forêts)',NULL,NULL,NULL,NULL,NULL,NULL,'Hydraulique (études d\'ondes de submersion)','1D','transcritiques',NULL,'Saint-Venant sous forme conservatives (volumes finis)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,'1970-01-01 00:00:00'),(21,22000,'EN','Reflux 3D','Reflux 3D',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'Reflux 3D adopte une approche novatrice dite h-s qui induit implicitement une très bonne approximation de la relation de dispersion. Cette approche consiste à donner un traitement particulier aux variables selon la vertical, il n\'y a plus de maillage du domaine tridimensionnel, mais chaque variable est remplacée par un nœud enrichi en degrés de liberté.',NULL,NULL,NULL,'Logiciels d\'ingénierie du cycle de l\'eau vol.9 - J.M. Tanguy',NULL,NULL,'DR. K. Meftah  (Université de Technologie de Compiègne)',NULL,NULL,NULL,NULL,NULL,NULL,'Hydrodynamique (houle non linéaire)','3D',NULL,'libre','Boussinesq (éléments finis)','Semis de points, direction, hauteur et période de la houle',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,'1970-01-01 00:00:00'),(22,22000,'EN','RUBAR 20TS','RUBAR 20TS',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'Le modèle RUBAR 20TS modélise le transport de sédiments en suspension et l\'évolution du fond de la rivière qui en résulte. Ce modèle peut aussi simuler le transport de sédiments par charriage ou le transport de solutés (moyennant une modification des termes sources et puits)',NULL,NULL,NULL,'Logiciels d\'ingénierie du cycle de l\'eau vol.9 - J.M. Tanguy',NULL,NULL,'CEMAGREF (Centre national du machinisme agricole du génie rural, des eaux et des forêts)',NULL,NULL,NULL,NULL,NULL,NULL,'Transport de sédiments en suspension','2D',NULL,NULL,'Saint-Venant',NULL,NULL,'quadrilatères et triangles',NULL,NULL,NULL,NULL,NULL,0,NULL,0,'1970-01-01 00:00:00'),(23,22000,'EN','MARTHE','Modélisation d\'Aquifères par un maillage Rectangulaire en régime Transitoire pour le calcul Hydrodynamique des Ecoulements',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'La chaîne de logiciels MARTHE a été conçue pour la modélisation hydrodynamique et hydrodispersive des écoulement souterrains en milieu poreux. Elle est destinée à modéliser les problèmes d\'écoulements rencontrés dans sivers contextes : gestion des ressources en aquifères, génie civil, environnement et exploitation minière. MARTHE permet de simuler de nombreux types d\'écoulements en zones saturées et non saturées, en milieux monophasiques ou diphasiques.',NULL,NULL,NULL,'Logiciels d\'ingénierie du cycle de l\'eau vol.9 - J.M. Tanguy',NULL,NULL,'BRGM (Bureau de Recherches Géologiques et Minières)',NULL,NULL,NULL,NULL,NULL,NULL,'Ecoulements souterrains en milieux poreux','3D',NULL,'nappes libres/captives/semi-captives','Plusieurs algo. de résolution par gradients conjugués : gradients conjugués avec préconditionnement de Choleski, méthode Eisenstat (volumes finis)',NULL,'Permanent/transiotire','maillage rectangulaire de type \"ecossais\"',NULL,NULL,NULL,NULL,NULL,0,NULL,0,'1970-01-01 00:00:00'),(24,22000,'EN','SOPHIE','Système Ouvert de Prévision Hydrologique Informatisé avec Expertise','Système Ouvert de Prévision Hydrologique Informatisé avec Expertise',NULL,NULL,NULL,1,NULL,NULL,NULL,'SOPHIE est une application modulaire capable d\'accueillir certains modèles de prévision des crues. Elle est adaptée aux contraintes du temps réel et permet aux prévisionnistes de réaliser un diagnostic hydrologique de la situation et d\'anticiper les événements. SOPHIE calcule des prévisions de hauteurs d\'eau et de débits à une échéance donnée à chaque station de mesure. C\'est une plateforme de modèles conceptuels globaux (autorégressifs, débits-débits, pluies-débits, multi-agent, etc.).',NULL,NULL,NULL,'Logiciels d\'ingénierie du cycle de l\'eau vol.9 - J.M. Tanguy',NULL,NULL,' bassin de la Garonne',NULL,NULL,NULL,NULL,NULL,NULL,'Prévision des crues','1D',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,'1970-01-01 00:00:00'),(25,22000,'EN','ProSe','ProSe',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'Le modèle ProSe a été développé pour simuler l\'impact sur un réseau hydrographique de pollutions tant diffuses que ponctuelles.',NULL,NULL,NULL,'Logiciels d\'ingénierie du cycle de l\'eau vol.9 - J.M. Tanguy',NULL,NULL,'Centre d’Informatique Géologique de l’École des Mines de Paris',NULL,NULL,NULL,NULL,NULL,NULL,'Qualité des eaux','1D',NULL,NULL,'Saint-Venant',NULL,'Permanent/transitoire',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,'1970-01-01 00:00:00'),(26,22000,'EN','VAG','VAG',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'Le logiciel VAG est un code de calcul aux différences finies qui permet très simplement de connaître l’amplitude de la houle et sa direction sur un site donné quand on dispose de ses caractéristiques au large. Ce logiciel ne prend en compte que le phénomène de réfraction qui se traduit par un changement des caractéristiques de la houle lorsque celle-ci rencontre des variations bathymétrique.',NULL,NULL,NULL,'Logiciels d\'ingénierie du cycle de l\'eau vol.9 - J.M. Tanguy',NULL,NULL,'CETMEF (Centre d\'études techniques maritimes et fluviales)',NULL,NULL,NULL,NULL,NULL,NULL,'Propagation de la houle','1D',NULL,'libre','Huygens','Semis de points, direction, hauteur et période de la houle, nombre d\'orthogonales et leur espacement.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,'1970-01-01 00:00:00'),(27,22000,'EN','RUBARBE','Rupture de BARrage with Bed Evolution','Rupture de BARrage with Bed Evolution',NULL,NULL,NULL,1,NULL,NULL,NULL,'Le code RUBARBE permet de calculer l\'écoulement, le transport solide et d\'en déduire la déformation du lit. Il vise à modéliser l\'évolution du profil en long du fond et de la ligne d\'eau lors des crues. Il se focalise sur le transport par charriage, les événements rares pendant lesquels le régime peut devenir torrentiel et la modification de la géométrie pendant l\'événement.',NULL,NULL,NULL,'Logiciels d\'ingénierie du cycle de l\'eau vol.9 - J.M. Tanguy',NULL,NULL,'CEMAGREF (Centre national du machinisme agricole du génie rural, des eaux et des forêts)',NULL,NULL,NULL,NULL,NULL,NULL,'Transport solide','1D','fluvial / torrentiel','libre','Saint-Venant (méthode explicite)','profils en travers',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,'1970-01-01 00:00:00'),(28,22000,'EN','MODFLOW','MODFLOW',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'Permet de traiter de très nombreuses applications telles que : Problèmes de pompages dans une nappe d\'eau souterraine; Nappes captives ou à surface libre; Pompages près d\'un mur ou ligne étanche; Problèmes de drainages; Echanges nappe-rivière; Recharges d\'une nappe par les précipitations et prise en compte de l\'évapotranspiration.',NULL,'http://water.usgs.gov/ogw/modflow/MODFLOW.html',NULL,NULL,NULL,NULL,'USGS (U.S. Geological Survey)',NULL,NULL,NULL,NULL,NULL,NULL,'Ecoulements souterrains','3D',NULL,NULL,NULL,NULL,'permanent ou transitoire',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,'1970-01-01 00:00:00'),(29,22000,'EN','TSAR','TSAR',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'TSAR vise à modéliser la tendance d\'évolution à court ou long terme des fonds d\'une rivière tant en niveau qu\'en composition sédimentaire. Il se focalise sur la description granulométrique en place et en mouvement (charriage ou suspension). Le code TSAR s\'intéresse aux rivières de plaine pour lesquelles l\'évolution du lit est relativement lente. Il est donc choisi de séparer la résolution liquide effectuée avec un pas de temps spécifique adapté et la résolution solide effectuée avec un pas de temps généralement plus grand.',NULL,NULL,NULL,'Logiciels d\'ingénierie du cycle de l\'eau vol.9 - J.M. Tanguy',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Transport solide','1D',NULL,'libre','Saint-Venant (schéma implicite aux différences finies)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,'1970-01-01 00:00:00'),(36,22000,'EN','MOBIDIC','MOBIDIC - Distributed Hydrologic model for water balance and flood forecasting',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'MOBIDIC (MOdello di Bilancio Idrologico DIstribuito e Continuo) is a physically-based hydrologic model. It is continuous in time and distributed in space, with rasterbased horizontal discretization. MOBIDIC solves a coupled mass and energy balance at the surface and employs a computationally efficient representation of soil moisture dynamics, that has been recently improved.\r\nIt has a single layer scheme for soil, whose peculiarity is the conceptual subdivision of the layer into two non-linear reservoirs, the capillary and gravitational one. They correspond to larger pores that drains under gravity and smaller pores that hold water through capillary forces. The two components control different sets of hydrologic fluxes. In particular, available water for evapotranspiration is capillary water, that is fed by gravitational water through an absorption flux.\r\nInteractions between surface and subsurface hydrology are explicitly taken into account. Groundwater dynamics may be modeled through 2-D Dupuit approximation or as a linear reservoir. Three options are available for flow routing through the network,  i.e. the lag approach, the Muskingum–Cunge method and the cascade of liner reservoirs. MOBIDIC runs operatively at the hydrologic service of Tuscany region (Servizio Idrologico Regionale, Regione Toscana) for floods forecasting and water resources management purposes. Spatial resolution up to 10 m cell. Temporal resolution up to 5 minutes.',NULL,'https://e-l.unifi.it/pluginfile.php/152501/mod_resource/content/1/mobidic_userman_may2015.pdf',NULL,'Mobidic User manual','/',NULL,'Florence University - Civil and Environmental Engineering Department','/images/tools/mobidic1.jpg','Schematic representation of MOBIDIC model','/images/tools/mobidic2.jpg','Example of application: detailed evaluation of dry conditions for not monitored waterbodies in the Tuscany region',NULL,NULL,'Surface and groundwater.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bernardo Mazzanti',NULL,'b.mazzanti@adbarno.it','MOBIDIC has been calibrated and tested by the Arno River Basin Authority for the evaluation of water balance conditions in the framework of River basin Management Plan and for a list of advanced projects (e.g PAWA, Pilot Arno Water Accounts, 2014-2015, Preparatory Action on development of prevention activities to halt desertification in Europe of European Commission DG Envrionment)',NULL,1,0,0,'2016-09-29 00:00:00'),(37,0,'EN','TENEVIA FlowSnap®','TENEVIA FlowSnap®: software dedicated to the experts in hydrometry for surface flow measurements',NULL,0,0,0,0,1,0,0,'TENEVIA FlowSnap® software enalbes the measurement of surface flow velocities using sequences of images. Simple, intuitive and verifiable measurment technique.\n\nIt is a non contact approach using fixed or mobile cameras, for which flow measurement is limited to images aquisition.\n\nThe obtained result is spatially distributed surface velocitiy measurements across the entire river section.\n',NULL,'http://tenevia.com/flowsnap/',NULL,NULL,'from 450 euros free of charge (+ change fees are not included)',NULL,'TENEVIA, 15 Chemin de la Malacher, Inovallée, 38240 MEYLAN, FRANCE','http://193.70.117.229/data4iwrm/images/article/Fiche/TOOLS_TENEVIA_FLOWSNAP_Velocity_Measurements.JPG','Surface velocitiy measurements obtained with TENEVIA FlowSnap® ','http://193.70.117.229/data4iwrm/images/article/Fiche/TOOLS_TENEVIA_FLOWSNAP_Data_Acquisition.JPG','Data acquisition on the field from the riverbank',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Virginie GIRARD - TENEVIA - FRANCE',NULL,'virginie.girard@tenevia.com','(1) The software is an evolutive system offering various levels of services.\n\n(2) Training course is provided to be initiated to the technic of image analysis and the collection of data on the field.',NULL,0,0,0,'2016-06-07 00:00:00'),(38,0,'EN','TENEVIA HydroCore®','TENEVIA HydroCore® : spatially distributed hydrological model',NULL,0,0,1,1,0,1,0,'TENEVIA, the water resource study and analysis software specialist (hydrological models of catchment areas), offers a hydrological data provision service. With the strength of its experience in producing hydrological models for the leading French hydropower production companies (EDF, CNR, ...), TENEVIA wants its unique expertise to be available to all those that need it (local authorities, management agents, river and catchment area contracts, engineering services, etc).\nThis service ensures that you obtain the latest hydrological and geo-referenced information. Waterway discharges, water maps and snow maps allow you to anticipate the risk of flooding and the severity of low water levels as well as assess hydropower potential and manage water resources being used for different activities.\nThe Hydrological Information System (HIS) based on a digital representation of your region, uses and concentrates different sources of data: geomorphological and hydrometeorological, in particular. This is analysed in real time by our software to produce a final calculation that is ready to be exploited. The data produced by TENEVIA’s Hydrological Information System must be used both in your studies and to support your decision making.\nTENEVIA provide data and web services according to the international standards of the Open Geographical Consortium offering the advantage of an easy access to the data. Amongst others, TENEVIA’s Hydrological Information System is compatible with the ArcGIS and ArcGIS On-line platforms, ESRI’s ELA licenses (Enterprise License Agreement), QGIS, etc.  ',NULL,'http://tenevia.com/en/expertise.html',NULL,NULL,'From 2 000Euros Free of Charge (+ change fees are not included)',NULL,'TENEVIA, 15 Chemin de la Malacher, Inovallée, 38240 MEYLAN, FRANCE','http://193.70.117.229/data4iwrm/images/article/Fiche/TOOLS_TENEVIA_HYDROCORE_HydroCore_Web-Interface.jpg','Monitoring discharge in real time with TENEVIA’s HydroCore® web application','http://193.70.117.229/data4iwrm/images/article/Fiche/TOOLS_TENEVIA_HYDROCORE_Discharge_Plot.jpg','Dicharge observations (in black) vs. predictions (in green)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Virginie GIRARD - TENEVIA - FRANCE',NULL,'virginie.girard@tenevia.com','(1) Various levels of services are provided intergating different type of data (observations, predictions, from various sensor in situ, from camera or satellite...) in order to fit precision of data according to stakes.\n\n(2) We realise assimilation of data in real time',NULL,0,0,0,'2016-06-07 00:00:00'),(39,0,'EN','TENEVIA RIVERBOARD® hydrometry solution','TENEVIA RIVERBOARD® hydrometry solution: Production of hydrological data to monitor waterways based on video image analysis ',NULL,1,0,0,0,0,0,0,'TENEVIA RiverBoard® is a patented system of measuring and helping to monitor waterways based on image analysis and processing. It uses the images supplied by a surface-based image acquiring device (IP camera and infrared projector) installed very close to a waterway or canal to measure the water’s height and surface flow velocity and calculate the discharge.\n\nThe non-intrusive nature (not submerged) of this solution means that it continues to function during extreme events such as flooding. Designed as a hydrometric information service, TENEVIA RiverBoard® is a \"4 in 1\" data and measurement display system (height, velocity, discharge and visual control using video) making it possible to:\n- create and update a rating curve using a number of discharge estimates calculated by the software using the images;\n- obtain two discharge calculations: the discharge estimated by the current rating curve (Q) systematically, as well as the discharge estimated using the surface velocity measured (Qcalc) on an ad hoc basis;\n- detect changes in hydraulic behaviour (i.e. rating curve shift).',NULL,'http://tenevia.com/en/concept.html','http://tenevia.com/riverboard/',NULL,'From 4 600Euros Free of Charge (+ change fees are not included)',NULL,'TENEVIA, 15 Chemin de la Malacher, Inovallée, 38240 MEYLAN, FRANCE','http://193.70.117.229/data4iwrm/images/article/Fiche/TOOLS_TENEVIA_RIVERBOARD_RiverBoard_Web-Interface.JPG','Monitoring hydrometric conditions in real time with TENEVIA’s Riverboard web application','http://193.70.117.229/data4iwrm/images/article/Fiche/TOOLS_TENEVIA_RIVERBOARD_Entrevaux_Velocity.JPG','Flow surface measurements in the Var river at Entrevaux',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Virginie GIRARD - TENEVIA - FRANCE',NULL,'virginie.girard@tenevia.com',NULL,NULL,0,0,0,'2016-06-07 00:00:00'),(40,0,'EN','TENEVIA SNOWBOARD','TENEVIA SNOWBOARD® TO ASSESS THE SNOWPACK\'S WATER CONTENT',NULL,1,0,0,1,1,0,0,'TENEVIA SnowBoard® is a tool to assess the snowpack\'s water content. It uses a digital model representing the dynamic of the snowpack combined with an image processing and analysis software program on mountain slopes. Using an IP camera type image capturing device, the idea here is to detect the presence of snow on the images of a catchment area. Once this basic information is established, the TENEVIA SnowBoard® system provides an assessment of the potential water content in the catchment area.\r\nThis solution is mainly intended to assist with the management of hydropower structures, as well as monitoring water resources and floods.',NULL,'http://tenevia.com/en/concept.html',NULL,NULL,'From 3 500euros free of charge (+ change fees not included)',NULL,'TENEVIA, 15 Chemin de la Malacher, Inovallée, 38240 MEYLAN, FRANCE','http://193.70.117.229/data4iwrm/images/article/Fiche/TOOLS_TENEVIA_SNOWBOARD_comANENA_CNR-TENEVEIA_Ossau_final_light.png','snowpack\'s water content in the Pyrenees',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Virginie GIRARD - TENEVIA - FRANCE',NULL,'virginie.girard@tenevia.com',NULL,NULL,0,0,0,'2016-06-07 00:00:00'),(41,0,'EN',NULL,'SWOS Product - Water Quality (short term status and trends) ',NULL,0,0,0,0,1,0,0,'The SWOS Water Quality product is elaborated combining and processing satellite data from Envisat-MERIS-Sentinel 3 or Landsat 8/Sentinel-2. It allows monitoring of aquatic pollution and physical disturbances for wetland ecosystems within a year or a season. \n\nSWOS products use the possibilities offered by free satellite data to generate mapping products and indicators which will be applicable globally. The precision of the products is about 300 meters, with temporal resolution of 8 days. The minimum size of water body to be mapped is 3 km2. \n\nThe following 3 parameters can be monitored: \n- Chl a, Chlorophyll a (µg l-1)\n- TSM, Total Suspended Matter (mg l-1)\n- CDOM, Colored Dissolved Organic Matter absorption (m-1)\n\nThe water quality software product is available as part of:\n* the SWOS software toolbox for users who want to make maps and indicators by themselves;\n* the SWOS service portal (http://portal.swos-service.eu) for users  who want to access the final product on areas where water quality maps have already been generated.',NULL,'http://swos-service.eu/wp-content/uploads/2015/06/SWOS-flyer-ENGLISH-A4-FINAL-05-02-2016-WEB.pdfnd ','http://swos-service.eu/wp-content/uploads/2016/06/SWOS_brochure.pdf',NULL,'not defined yet',NULL,'Jena-Optronik GmbH\nOtto-Eppenstein-Strasse 3\n07745 Jena\nGermany','http://193.70.117.229/data4iwrm/images/article/Fiche/TOOLS_SWOS_Water-Quality-CHL.png','Chlorophyll a,  Monthly mean for Etang de Berre','http://193.70.117.229/data4iwrm/images/article/Fiche/TOOLS_SWOS_Water-Quality-TSM.png','Total Suspended Matter, monthly mean for Etang de Berre ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Eric MINO  - EMWIS as member of the project (test and validation) - France',NULL,'e.mino@semide.org',NULL,NULL,0,0,0,'2017-05-22 00:00:00'),(42,0,'EN','SAMBAT','SAMBAT',NULL,1,1,0,0,0,0,0,'SAMBAT is an autonomous multiparameter probe with brush and teletransmission. This equipment is used to measure and record the main physical water parameters (temperature, depth, conductivity for the calculation of salinity, turbidity, fluorescence, dissolved oxygen and pH) on a period of time up to several months.\n\nSAMBAT uses a brush to protect the fluorescence, turbidity and dissolved oxygen sensors from biofouling.\n\nExamples of use of the SAMBAT :\n\nMonitoring Station\nWater quality control\nEnvironmental monitoring\nCivil engineering works follow-up\nSalinity and turbity measurement for hydrodynamic models settings\nBathing waters monitoring',NULL,'http://www.nke-instrumentation.fr/instruments-nke/sondes-multiparametres/multiparametre/sambat.html',NULL,NULL,'NC',NULL,'NKE Instrumentation \n6 rue Gutenberg\nZI Kerandre\n56 700 Hennebont\nFRANCE','http://193.70.117.229/data4iwrm/images/article/Fiche/TOOLS_NKE-INSTRUMENTATION_SAMBAT.JPG','SAMBAT',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,'2017-06-14 00:00:00'),(43,0,'EN','WISENS TD','WISENS TD',NULL,1,1,0,0,0,0,0,'WiSens-TD measures and records temperature and pressure.  \nIt has been designed to be used down to 6000m. \n\nNew generation:\nWiFi connection\ncompatible IOS, Mac OS, Windows, Android\nNos specific software\n\nEasy to use: \nFast wireless configuration configuration and data collection thanks to the WiFi communication\nEasy maintenance\n\nRugged and reliable: \nOptimal protection of the sensors\nLithium batteries for long-term use (several years) ',NULL,'http://www.nke-instrumentation.com/products/multiparameter-probes/pressure-temperature/wisens-td.html',NULL,NULL,'NC',NULL,'NKE Instrumentation \n6 rue Gutenberg\nZI Kerandre\n56 700 Hennebont\nFRANCE','http://193.70.117.229/data4iwrm/images/article/Fiche/TOOLS_NKE-INSTRUMENTATION_WISENS.jpg','WISENS-TD',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,'2017-06-14 00:00:00'),(44,0,'EN','AQUATOOL','AQUATOOL',NULL,0,0,1,1,1,1,0,'AQUATOOL is a Decision Support System Shell (DSSS) model for planning and water management. This DSSS helps in providing diagrams, analysis and result management. It is composed of the AQUATOOL+ user interface and 5 modules which can be used for specific modelling aspects we detail bellow. \nSIMGES is a reservoir based model for water resources systems management, including groundwater. Simulations are computed for a monthly scale and the flow can be obtained for any spatial scale.\nGESCAL provides basin water quality evaluation. It calculates the water quality of the rivers and reservoirs. Then, the model is linked to the SIMGES model to use the calculated flow values and deduce the water quality over the all basin.\nOPTIGES is used for water balance and water uses modelling. For that, it uses only little information about the physical description of the basin (links, reservoirs and demands) but cannot provide results for a precise time step (monthly at maximum).\nThe SIMRISK model is a medium-term for management risks. The user defines an initial condition and the model runs different hydrological scenarios to evaluate the hydrological status for each scenario.\nEVALHID is a module for the development of rainfall-runoff in complex basin which uses several types of models to evaluate the water resources produced.',NULL,NULL,NULL,NULL,NULL,NULL,'Instituto de Ingenieria del Agua y Medio Ambiante- -Universitat Politècnica de València',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,'2017-07-17 00:00:00');
/*!40000 ALTER TABLE `t_dmtool` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_dmttype`
--

DROP TABLE IF EXISTS `t_dmttype`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dmttype` (
  `DMTTCODE` int(11) NOT NULL,
  `DMTTNAME` varchar(50) DEFAULT NULL,
  `DMTTNAME2` varchar(50) DEFAULT NULL,
  `DMTTCLASS` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`DMTTCODE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_dmttype`
--

LOCK TABLES `t_dmttype` WRITE;
/*!40000 ALTER TABLE `t_dmttype` DISABLE KEYS */;
INSERT INTO `t_dmttype` VALUES (0,'_Not determined',NULL,NULL),(10000,'Tool for monitoring and data production','',0),(20000,'Software',NULL,NULL),(21000,'Tool for database and GIS development',NULL,NULL),(22000,'Modeling tool','',0),(23000,'Tool for processing (out of modeling)',NULL,NULL),(24000,'Tool for developing reports',NULL,NULL),(25000,'Tool for developing dissemination platforms',NULL,NULL);
/*!40000 ALTER TABLE `t_dmttype` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2023-05-04 21:00:49
