Improving the database structure

• Integration of new information: socio-economic data, building scenarios on future withdrawals, the results of projected simulation provided by PM5.
• Collection of tabular and spatial information which greatly improves the flexibility and facility of using and maintaining the database.
   

​Migration of the MSACCESS database to the PostgresSQL database

For the following reasons:

• Integrate the spatial information in an adaptive way to the PostgreSQL database: the MSACCESS-PostgreSQL migration is the only means to avoid redundancy and ensure coherence between the two types of information.
• Enable data sharing in a client/server environment and resolve the problems generated by the operation of the system on autonomous workstations.
• Have more reliable and secure information.
   

Database Update and Reliability

• Integration of the data obtained since 2001: water points, withdrawal, static levels…

The TC contains superior stoneware and turonian

• Information provided by the piezometric network and  the water quality monitoring network 
   

Improvement of the data management tools (SAGESSE interface):

• Adaptation of the new interface to the new structure of the database and new storage format of the PostgreSQL – PostGis databases.

• Development of new features to integrate new needs: scenarios management, statistic request, multi-criteria research, …

• Establishment of the information management forms issued by the monitoring network (Piezometry and quality).

 Improvement of the updating and information exchange devices among partners: 

• Standard exchange format based on the XML language,
• Use of the OSS’s FTP server to update the common Database of the SASS project

Updading of the GEOSASS cartographic server and its adaptation to the new database:

• Use of simple, new and easy tools,
• Possibility for the user to formulate specific requests
• Display of the information generated by the monitoring network.