Results

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

Aquifer

Country

Withdrawal hm3/year

2000

2010

 

 

IC

Algeria

687

1093

Libya

106

154

Tunisia

70

83

IC SASS

863

1330

 

 

TC

Algeria

669

815

Libya

129

142

Tunisia

490

486

TC SASS

1288

1443

Total Withdrawal

2151

2773

Evolution of water withdrawal between 2000 and 2010

 

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


 

Aquifer

Country

Number of used forages

2000

2010

 

 

IC

Algeria

789

2078

Libya

437

609

Tunisia

101

275

IC SASS

1327

2962

 

 

TC

Algeria

1123

2003

Libya

209

350

Tunisia

532

5300

TC SASS

1864

7653

Total Withdrawal

3191

10615

The total number of forages in 2010 in Tunisia includes the forages called before “the soundings group”. 

 

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.