1

A.Angelopoulou

National Technical University of AthensDepartment of Chemical Engineering

Laboratory of Environmental Science and Technology

Introduction / Presentationof the Industrial Waste Database System

LIFETCY 98/CY/167

Industrial Waste Database System

Software characteristics

The application is designed for use in a network

environment – Microsoft NT Windows

The database was designed with Microsoft SQL Server

The application was developed using the programming

language DELPHI

The Geographical Information System (GIS) used is

ARCVIEW (by ESRI)

Work breakdown structurePhase Description

System engineering and analysis

Software requirements analysis

Design

Implementation

Testing

Maintenance

Training

Project Scope

Development of an industrial waste

database system in which technicaltechnical and

environmentalenvironmental data of industrial units is

statistically processed and evaluated

according to the environmental regulations.

Software application modules

Management of database tables

Reports and Statistical programs evaluating

effluent measurements

Geographical Information System (GIS)

Management of Database Tables

This module contains programs which allow

the user to enter data concerning the

industry’s identity, water supply, liquid

wastes, VOC emissions, solid and dangerous

wastes, oil residues.

Main Screen Search Search criteriacriteria::

•Industry Industry namename

•NACE codeNACE code

•QuestionnairQuestionnaire datee date

•Internal Internal codingcoding

Menu choicesMenu choices::

•FileFile

•IndustryIndustry

•QuestionnairQuestionnairee

•ReportsReports

Company / Company / Industry / Industry / QuestionnairQuestionnairevieweview Search Search

resultsresults

Menu choices (File)

File > File > Help TablesHelp Tables

Help tables hold Help tables hold data used by all data used by all other programs of other programs of the application :the application :

•TechnicalTechnical

•EnvironmentalEnvironmental

•GeographicalGeographical

Menu choices (Industry)

These programs These programs allow the user to : allow the user to :

• insert a new insert a new company / company / industryindustry

• view data of an view data of an existing company / existing company / industryindustry

• update / delete update / delete an existing an existing company / company / industryindustry

Menu choices (Industry)View Company’s Data

Company’s identity

Responsible person

Menu choices (Industry)View Industry’s Data

A number of programs allow the A number of programs allow the user to easily pass through some user to easily pass through some screens and view the industry’s screens and view the industry’s datadata

Menu choices (Questionnaire)

These programs allow the user These programs allow the user to :to :

•View an existing questionnaireView an existing questionnaire

•Insert a new questionnaireInsert a new questionnaire

•Delete a questionnaireDelete a questionnaire

Questionnaire

The Questionnaire holds environmental The Questionnaire holds environmental data concerning a specific industry.data concerning a specific industry.

An industry may have as many An industry may have as many questionnaires as possible which may questionnaires as possible which may be related to a specific sample and be related to a specific sample and date of measurement.date of measurement.

Production process units

Holds environment

al data concerning :

Liquid wastes

Solid wastes

Gaseous wastes

VOC’s

Oil residues

Questionnaire All programs are All programs are designed to have a user-designed to have a user-friendly interface. friendly interface.

Tab access to various Tab access to various screensscreens

Links to all help Links to all help tablestables

List boxes for all parametric List boxes for all parametric tablestables

Reports / Statistical programs

The application offers 21 The application offers 21 reports, some of them are reports, some of them are ::

• Effluent measurements Effluent measurements per industry, per industry, geographical area, NACE geographical area, NACE code, recipientcode, recipient

• Water usage,Water usage,

• Industry categorization Industry categorization (NACE coding)(NACE coding)

Reports / Statistical programs

For each report, the user For each report, the user may define different may define different selection criteria.selection criteria.

The reports may be The reports may be viewed on the screen and viewed on the screen and forwarded to the network forwarded to the network printer.printer.

Geographical Information System

In order to view Cyprus In order to view Cyprus map enriched with data map enriched with data entered, the database entered, the database tables should be linked tables should be linked with the GIS project file.with the GIS project file.

Geographical Information System

Data contained in the Data contained in the database tables is shown on database tables is shown on line on the Cyprus map line on the Cyprus map according to the view according to the view selected by the user.selected by the user.

Each time an emission entry Each time an emission entry is added to the database, it is added to the database, it is projected on the map.is projected on the map.

Geographical Information System

The user may also select The user may also select and view data for specific and view data for specific districtsdistricts which are colored which are colored according to the level of according to the level of liquid wastes (e.g. beige for liquid wastes (e.g. beige for 333 mg/l, light brown for up 333 mg/l, light brown for up to 1809 mg/l etc.)to 1809 mg/l etc.)

Conclusion

This application is very important as a decision

support tool since it can assist the

environmental authorities to :

access / update the existing situation of emissions

define problematic areas where pollutants exceed allowable levels

take necessary pollution control measures

AcknowledgmentsMinistry of Labour and Social Insurance :

A.Economides and all partners

NTUA:

Prof.M.Loizidou

Dr.D.Fatta

Collaborators in developing the application :

Stelios Angelis

Fivos Vilanakis

Haris Loukatzikos