ons and the
information:
power, fog,
pressure,
Ning area of
productive,
porated also
e format is
abase. The
NO kinds of
owing data:
ry, address
other table
lata in the
it emission,
^ emission,
X emission,
, production
arly waste
ases
s and
stems
Pi
^C
|
|
:
c database
At the object, points and streets segments the noise level
was measured creating in database noise monitoring
layer. And the table contains object identifier and address
and field with noise level measured in consecutive years.
Air pollution measurements are very often executed (one
or several times per day) therefore for each station
separate table containing one year measurement is
assigned with fields showing concentrations of pollution's
and dates of measurements. Moreover, description table
was created with following data: number of station, name
of measurements results file, parish, district/village,
address, station owner, station type, date of foundation
and closing down X, Y co-ordinates, co-ordinate system,
logical fields for queries.
The similar table was created for soil pollution and water
pollution as well as waste storages.
6. DATABASE CREATION AND SUPPLY
Database for environmental pollution monitoring based
on GIS analysis is created throughout Basic Geogra-
phic Database (Fig.2). Various databases of sources
supply the basic database. This base begins with geo-
referenced measurements of the environment - direct in
the terrain or by remote sensing. These measurements
use varied pathways into a digital spatial database. As it
is visible (Fig.1 and Fig.2) ground and survey measure-
ments may be introduced directly into the database. They
may be interpolated to compile a map and entered to da-
tabase through raster scanning or vector digitising. Aerial
photographs and analog satellite imagery after human in-
terpretation is converted to GIS.Digital imagery after ima-
ge processing and analysis is send to basic database.
Forest
Buildings |
All these information originated from ground, maps and
analog image data requires digitising, geo-referencing
and registration in basic geographic database. Therefore
they entail additional conversions or transformations.
The environmental pollution measurements were incor-
porated into attribute basic database. For recording of
these measurements and other descriptive data, FoxPro
System was used (Zabrzeska, Wróbel, 1994).
The system enables completion and modernisation in a
simple way the information which is stored in the
database. All this data was divided for thematic groups:
pollution emission, noise pollution, measurements of air,
soil and water pollution as well as waste storage yards.
34 industrial plants were stored in database which emits
to the atmosphere: dust, SO», NO», CO, hydrocarbons
and other gaseous pollutants.
Information taken from State Health Supervision Office in
Cracow concerning results of SO» and dust concentration
measurements executed at 28 chosen station every day
was stored in a database. Additionally this data
measured at 53 station presenting monthly, yearly and
seasons values (summer and winter) were stored.
Soil pollution data was collected from 66 stations located
at agriculture, forest, garden and orchard areas. At each
station once every 4 years measurements of soil
pollution by chromium, cadmium, nickel, lead and
fluorine were analysed. Additionally in gardens by
copper, zinc, iron and sulphur.
Pollution measurements of surface waters were executed
at 64 stations located along Cracow area rivers every
month. Only the concentration values of 30 characteristic
parameters specified at each stations were stored in
databases.
Polution category:
. B- medium
| C. heavy |
Fig.3. Heavy metals soils hazard over the DTM test area
International Archives of Photogrammetry and Remote Sensing. Vol. XXXI, Part B7. Vienna 1996