Geographical database for potentially contaminated sites

Development and implementation of a geographically
structured database system for mapping current and
historical information of activities on potentially
contaminated sites.

Background: Environmental mapping and historical investigations are efficient administrative tools for Local Authorities in their increasingly demanding work in solving environmental problems arising from contaminated sites and offer indispensable help for Central and Local Authorities in their work with: 1. Environmental supervision, hazard assessments and establishing priority lists on: * industrial pollution control * plans for the use of ground water resources * considerations of surface water conditions. 2. Planning for future use of industrial areas including hazard assessments and the establishment of priority lists. The aim of historical mapping is to record industries, waste disposal sites, various trades and potentially contaminated areas in general, based on available literature, maps, aerial and satellite photographs, databases, etc. Environmental mapping includes identification and localisations of potentially contaminating industrial activities and gives both a historical and current view of the geographical distribution of potentially contaminated sites. GEOENVIRON will be designed and implemented as an integrated tool for authorities, consultants and others who deal with environmental planning and assessment in EUREKA countries and in countries where environmental concerns have high priority. GEOENVIRON handles registration and presentation of point sources (e.g. industries, waste disposal sites), diffuse sources (e.g. agricultural industry) and recipients in an interactive client/server environment combining geographical information systems (GIS) and database management systems (DBMS) using object-oriented techniques. As a part of the system, GEOENVIRON will include a knowledge database on the behaviour within the environment of selected chemicals, remediation techniques and literature references to environmental issues. Research in and implementation of new models within risk assessment and clean up prioritization will also be available. Another important concern in the GEOENVIRON project is to establish a basic method for the historical mapping of potentially contaminated sites. Many countries have not yet established a systematic approach to the problem and are therefore not able to make priorities on regional and local clean up procedures and overall environmental management. In short, GEOENVIRON intends to offer a method and an efficient, high quality tool for government, Local Authorities and consultants doing individual work on planning and remediation within the environmental administration sphere. Note under estimated costs: Since there is a pre-feasibility study going on which deals with the definition of the frame of the system, project organisation and the selection of the participants in the project group, the detailed budget and distribution of the activities between the participants has not yet been calculated. Based on experience from former projects of similar size, GEOKON has made a budget frame, which has been discussed and confirmed by the group members. Costs are calculated for every phase as a sum of manpower, travel expenses and materials. Manpower has been calculated as average man/month salary including 25% overhead to 5,850 ECU. Travel and materials are included in the costs of the appropriate phases. Total travel costs: 55,000 ECU Total materials costs: 109,000 ECU. Feasibility phase: During the second half of 1994 GEOKON carried out a pre-feasibility study comprising market research on possible competitive products, preliminary design of system concepts and search for partners through the Danish EUROENVIRON organisation. It is the opinion of GEOKON that we have found most competent partners in the U.K. and RUSSIA. The experience of the project group thus covers GREAT BRITAIN, SNG and Scandinavia. There might be a need for supplementary investigations of the situation in Mediterranean countries and eventually in parts of former Eastern Europe as well. Time for database search, literature studies and contacts with environmental authorities in the rest of the EUREKA countries is calculated as one of the main activities in the feasibility phase of the main project. Another main activity is the evaluation of basic software packages for the first version of GEOENVIRON e.g., database system, GIS, etc. Definition Phase: The definition phase consists of system design, system description, and description of the method for historical mapping with special respect to environmental threats. It is suggested that GEOKON design and describe the core of the GEOENVIRON system and that the partners modify design and description in agreement with guidelines for their respective countries. The description of the method must be done in close cooperation with all members of the project group. As there are very many aspects in this phase to be considered and a great deal of effort must be made to harmonize the product, the definition phase is the most important and time consuming phase. Implementation phase: The implementation phase consists of main activities as follows: preparation of development environment, establishment and programming of standards for object libraries, windows, menus, error messages, help system, etc. The programming of a security system, copy protection, ancestor and descendent windows, batch modules, reports, interfaces to selected SQL-databases, word processing, spreadsheets, etc., integration with GIS. Establishing of systematic internal and external test environment, and implementation of automatic version control system. Production of user manuals and other user documentation. Full Exploitation Phase: In the exploitation phase it is planned to find potential clients among environmental authorities willing to test GEOENVIRON and the method following the system to full scale. After tests and readjustments, marketing plans will be conducted by the project group and carried out by members in the individual countries. Duration of Phases: The duration of phases in calculated in calendar months. As there is some overlap between phases, the total duration of the project is less than the sum of the individual phases.
Project ID: 
1 280
Start date: 
Project Duration: 
Project costs: 
880 000.00€
Technological Area: 
Market Area: 

Raising the productivity and competitiveness of European businesses through technology. Boosting national economies on the international market, and strengthening the basis for sustainable prosperity and employment.