A.Angelopoulou

1
A.Angelopoulou
LIFETCY 98/CY/167
Introduction / Presentation of the Industrial
Waste Database System

• National Technical University of Athens
• Department of Chemical Engineering
• Laboratory of Environmental Science and Technology

2
Industrial Waste Database System
3
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)

4
Work breakdown structurePhase Description

• System engineering and analysis
• Software requirements analysis
• Design
• Implementation
• Testing
• Maintenance
• Training

5
Project Scope

• Development of an industrial waste database
  system in which technical and environmental data
  of industrial units is statistically processed
  and evaluated according to the environmental
  regulations.

6
Software application modules

• Management of database tables
• Reports and Statistical programs evaluating
  effluent measurements
• Geographical Information System (GIS)

7
Management of Database Tables
This module contains programs which allow the
user to enter data concerning the industrys
identity, water supply, liquid wastes, VOC
emissions, solid and dangerous wastes, oil
residues.
8
Main Screen

• Search criteria
• Industry name
• NACE code
• Questionnaire date
• Internal coding

• Menu choices
• File
• Industry
• Questionnaire
• Reports

Company / Industry / Questionnaireview
Search results
9
Menu choices (File)

• File gt Help Tables
• Help tables hold data used by all other programs
  of the application
• Technical
• Environmental
• Geographical

10
Menu choices (Industry)

• These programs allow the user to
• insert a new company / industry
• view data of an existing company / industry
• update / delete an existing company / industry

11
Menu choices (Industry)View Companys Data
Companys identity
Responsible person
12
Menu choices (Industry)View Industrys Data
A number of programs allow the user to easily
pass through some screens and view the industrys
data
13
Menu choices (Questionnaire)

• These programs allow the user to
• View an existing questionnaire
• Insert a new questionnaire
• Delete a questionnaire

14
Questionnaire
Holds environmental data concerning
Production process units
Liquid wastes
Solid wastes
The Questionnaire holds environmental data
concerning a specific industry. An industry may
have as many questionnaires as possible which may
be related to a specific sample and date of
measurement.
Gaseous wastes
VOCs
Oil residues
15
Questionnaire
All programs are designed to have a user-friendly
interface.
Links to all help tables
Tab access to various screens
List boxes for all parametric tables
16
Reports / Statistical programs

• The application offers 21 reports, some of them
  are
• Effluent measurements per industry, geographical
  area, NACE code, recipient
• Water usage,
• Industry categorization (NACE coding)

17
Reports / Statistical programs
For each report, the user may define different
selection criteria. The reports may be viewed on
the screen and forwarded to the network printer.
18
Geographical Information System
In order to view Cyprus map enriched with data
entered, the database tables should be linked
with the GIS project file.
19
Geographical Information System
Data contained in the database tables is shown on
line on the Cyprus map according to the view
selected by the user. Each time an emission entry
is added to the database, it is projected on the
map.
20
Geographical Information System
The user may also select and view data for
specific districts which are colored according to
the level of liquid wastes (e.g. beige for 333
mg/l, light brown for up to 1809 mg/l etc.)
21
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

22
Acknowledgments
Ministry of Labour and Social Insurance
A.Economides and all partners NTUA Prof.M.Loiz
idou Dr.D.Fatta Collaborators in developing the
application Stelios Angelis Fivos
Vilanakis Haris Loukatzikos