Photo: coolwaterman, Photocase
Contaminated Site Register For The Federal State Mecklenburg-West Pomerania
For the decentralised capture of data from suspected polluted areas in the federal state of Mecklenburg-West Pomerania, and the centralised evaluation of this data, RISA GmbH, in collaboration with the technical university of Berlin, developed the program system ALPHA 2000 (Based on RISA 2000).
Contaminated Site Register For The Federal State Brandenburg
In collaboration with the State Environmental Agency of Brandenburg (LUA) we have developed, based on RISA-GEN, the 'contaminated site Register' (ALKAT). Its purpose is the decentralised capture and centralised management and evaluation of extensive information on old deposits / old locations and substantially detrimental soil changes.
Waste Water Register For The Federal State Bavaria
For the capture and evaluation of data about municipal and industrial waste water treatment plants in the federal state Bavaria, we developed on the basis of UDIS the application system UDIS-BY. The UDIS data model and in particular the user interface were adapted to the Bavarian requirements.
IPPC applications within the scope of
TWINNING projects in Czechia and
Romania
Contracted by the Federal Environment Agency, in collaboration with German experts for environmental management, we developed, based on RISA-GEN, an IPPC (Integrated Pollution Prevention and Control) application system for the Czech Republic and Romania. This software is in the respective national languages.
Application for Entitlement to an allotment of CO2-emissions certificates
In 2004, the allocation law 2007 for the trading of CO2 on an exchange in Germany, was very quickly transformed by RISA into a data capture software, to be used for filing applications for entitlement. The basis of this development was the database application RISA-GEN. For the trading period 2005-2007, this program, with a few extensions, continued to be used for new applications of entitlement and applications for additional capacity for existing entitlement.
Projects
Between 2003 to 2006 we developed a waste water register in close collaboration with the regional authorities for water management, coastal and nature preservation (NLWKN). Based on our RISA-GEN software, AKN is an office application that consists of different modules to support the collection, evaluation and exchange of data, and is used in all agencies of the NLWKN in lower Saxony as well as in numerous other water sub-authorities. It is a distributed software system with the central data management held in NLWKN-Hildesheim.
The RISA-GEN Explorer: Plant, test points and master data of a test point.
Workplace application RISA-GEN-AKN
The workplace application RISA-GEN-AKN fulfils the requirements for the capture and evaluation of wastewater discharge data at source, allowing both the official in charge and the software application administrator an improved workflow.
Assistants for data acquisition
Special assistants have been implemented for data entry, so that monitoring values can be more easily updated. The input of test data is also supported by individual assistants. These assistants use easily configurable measuring program templates and a comprehensive validation to monitoring values. Additionally, all essential structures of the data model, such as industrial plants, discharge points, test points and water rights can be controlled through an assistant. This means that required data and dependencies are requested from the user in such a way that a clear and easy input is possible. There are also assistants for the evaluation of the data, for example for analysis report preparation with the 4 out of 5 rule.
Implemented legal framework
The RISA-GEN-AKN allows the input of all necessary data to the EU-report requirements 91/271 European Economic Community (municipal sewage), 76/464 European Economic Community (discharge of dangerous substances) and in 2000/479 the EC (EPER). The transfer of this data from other applications to the AKN is supported by the mandatory prerequisite of VADAF_NI XML format (developed by RISA). Furthermore the application contains a complete map of the German §7a WHG (Water Resources Law) and a permitted substance database for the state of lower Saxony.
Waste water tax evaluation and query tools
We have created a module for waste water tax evaluation, correspondent to the current federal state law. After taking into account many complex rules, this module makes an appraisal of the amount of contamination contained in the waste water discharge, so that taxes can be levied.
With the use of query tools contained in every RISA-GEN application, all data values of the AKN application can be comfortably evaluated, in particular when using predefined queries.
Thin online compilation of the plant data
Online compilation
Because some users only need to enter the EU-report requirements for 91/271/EWG (municipal waste water) and 76/464/EWG (discharge of dangerous substances) and 2000/479/EG (EPER), and because the complete AKN software would signify a too great functionality and installation cost, we have also created a software for online compilation of the data. The configuration of this Internet application is especially easy, because the data model limits itself to a small part of the whole data model. This application is also assistant-oriented and leads the user smoothly through the individual input masks.
Conclusion
The collaboration with our project partners at NLWKN has been very successful, for both sides. Through training of the different application groups, the individual users become familiar with the application. In the AKN-workshops we listen to the individual wishes of the users, taken from their working experience, and find solutions for their individual problems. As a result, we achieve a high acceptance level with our users.
