1Report_Englishx

pointdepressedΜηχανική

22 Φεβ 2014 (πριν από 3 χρόνια και 7 μήνες)

168 εμφανίσεις



Preparatory works

for development of Sopron Master plan

to support Sopron city’s sewage system
development




PHASE I.

Data Collection Report

October 2011


Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



1


Cover
P
age


Project name:

Preparatory works for development of Sopron
Master plan to
support Sopron city’s sewage
system development


Phase:

Phase I


data collection


Client:

Sopron Water Utility


Executor
:

DHI a.s.
,
Na vrších 5,
Prague

10
, Czech Republic


Department of Sanitary and Environmental Engineering


Budapest University of
Technology and

Economics




Delivery date:

30.10.2011



Project team
:


Ing. Tomáš Metelka, Ph.D.


Ing.


Jaroslav Kinkor


Martin Havliček


Ing. Anna Chladková


Ing.
Erzsébet Lenke Pieskó


Ing. Kalman Buzas, Ph.D.


Ing.

Roland Fülöp



Ing. Marcell Knolmár


Ing. László Raum





Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



2





Acknowledgements


Special thanks are devoted to the open and fruitful cooperation with Sopron Water Utility.
Some of the data were received thanks to
Western Hungarian University and their research
funded by Social Renewal
Operational Programme (TÁMOP 4.2.1/B
-
09/KONV
-
2010
-
0006).
Participation of Zoltán Gribovszki was partly funded by Bolyai Fund of the Hungarian
Academy of Science.

Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



3


Contents

1

INTRODUCTION


PURPOSE OF

WORKS

................................
....................

4

2

DATA SOURCES

................................
................................
.........................

6

2.1

D
ATA SOURCES

................................
................................
................................
................................
........................

6

2.2

D
ATA
I
MPORTS

................................
................................
................................
................................
.......................

6

3

DATA ANALYSIS

................................
................................
........................

9

3.1

S
TORM
-
WATER NETWORK DATA

................................
................................
................................
................................
..

9

3.1.1

Closed conduits

................................
................................
................................
................................
.................

9

3.1.2

Open channels
-

BME

................................
................................
................................
................................
......

18

3.2

S
EWERAGE
-
NETWORK DATA
-

BME

................................
................................
................................
..........................

23

3.2.1

Network data


BME

................................
................................
................................
................................
.......

23

3.2.
2

Structures
-

BME

................................
................................
................................
................................
.............

25

3.3

W
ASTEWATER PRODUCTION

DATA
-

BME

................................
................................
................................
...................

25

3.3.1

Population data
-

BME

................................
................................
................................
................................
....

26

3.3.2

Water consumption data
-

BME

................................
................................
................................
.....................

26

3.3.3

Industrial water producers
-

BME

................................
................................
................................
..................

28

3.4

C
ATCHMENT AND HYDROLO
GICAL DATA

................................
................................
................................
......................

29

3.4.1

Hydrological and administrative boundary

................................
................................
................................
.....

29

3.4.2

Urban sub
-
catchments

................................
................................
................................
................................
....

30

3.4.3

Urban infrastructure data

................................
................................
................................
...............................

31

3.5

O
NGOING
M
EASUREMENT DATA

................................
................................
................................
...............................

35

4

RECOMMENDATIONS

................................
................................
.............

36

5

CONCLUSION

................................
................................
..........................

37

7

LIST OF FIGURE
S

................................
................................
.....................

38

8

LIST OF TABLES

................................
................................
.......................

39

9

ANNEX 1


SOURCE DATA LIST

................................
................................

40


Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



4


1

Introduction


purpose of
works

The Sopron Water Utility is operating the urban drainage system in the area of the city of
Sopron. The drainage system of the city is of separate type composed of sewage and storm
water networks. This technical solution makes the separation of “clean
” storm water from
polluted sewage waters possible with benefit in better performance of wastewater treatment
plant and good water quality in rivers (rivers Ikva and Rák). However, there are some
bottlenecks in this concept resulting in not optimal perform
ance of both drainage networks.
These are at least as follow:

a.

expected interconnections between sewage and storm water systems,

b.

high dilution ratio at WWTP because of storm water inflow/infiltration into sewage
network,

c.

presence of overflows at sewage
water network polluting local rivers,

d.

high rage of infiltration and sedimentation in both networks.

These reasons cause the operation of the Sopron urban drainage system not optimal. This is
one of reasons driving Sopron water utility management to decide
in investingon detailed
analysis of the current system performance and in disclosing performance bottlenecks as
well as in future sustainable network development harmonized with expected future
development of the city of Sopron.

In early 2011 the Sopron W
ater Utility (SWU) contracted Consortium of DHI a.s. and BME for
execution of the project of Sopron urban drainage master plan, which should bring the
answers for the above challenges. The project is defined in four subsequent phases:

a.

Phase A
-

data colle
ction

b.

Phase B


monitoring campaign

c.

Phase C


model build

d.

Phase D


proposal of long term sustainable measures

This report is focusing on the Phase A of the project


Data collection. The main objective of
this project phase is

a.

to collect all information
necessary for later model build,

b.

to analyse the quantity and quality of information received,

Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



5

c.

to disclose potential gaps in information,

d.

to propose the steps for filling up the missing information (if any) and

e.

to migrate all information from distinct sourc
es into MikeUrban data structure.

Special focus is spent on storm water network data collection, however, the sewage network
data is collected as well because of reasoning above. The data is collected from distinct data
sources e.g. SWU, municipality of So
pron, public data available in the internet, etc. The
results and findings of the data collection works is summarised in following chapters.
Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



6

2. Data sources

2.1
Data sources

The source data were collected from several distinct data sources. The most import
ant data
source represented Sopron Water Utility. However, also other data sources were utilizede.g.
municipal data, hydro meteorological data, satellite data, etc. to complement missing
information necessary for the model build. List of the approved data
with comments is in
Annex 1.

2.2
Data Imports

All collected data were of distinct format e.g. ESRI SHP files, Excel files, MapInfo files, etc.
There files were converted and imported into Mike Urban database. Next shapefiles with
collection network were
imported to Mike Urban Asset model.

Table
1

List of imported files

Shapefile

Asset
model

C_ATEMELO_DB_point.shp

Asset
pumps

C_KITOR_DB_point.shp

Asset nodes

C_MUTARGY_DB_point.shp

Asset nodes

C_RACSOK_DB_point.shp

Asset nodes

C_TISZTITOAKNA_DB_point.shp

Asset nodes

C_VEZETEK_DB_polyline.shp

Asset Links


Received shapefiles were imported to Mike
URBAN database using specialized data import
bridge. The main, unique
identificator providing
the link between Mike URBAN and client database
is MUID (on Mike Urban side) and MAPGUIDEKE
(on Water Utility GIS side).

This is rather important
link that should be meintained also in the future
once the mutual connection between C
orporate
GIS and Mike Urban is to be preserved.



Figure
1
Import from client database to Mike URBAN
Database

GIS

MIKE
URBAN

Datab
a
se

BRIDGE

Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



7

The Mike Urban import module details are presented on the Fig.2.bellow. For details please
refer to the Mike Urban User Guide docum
entation.


Figure
2

Example of import

The storm water network was imported into
Mike Urban including open creeks RAK
and IKVA. Data for these creeks resulted
format the
intensive geodetical survey
executed by the Consortium MBE/DHI
during the period August
-
September 2011.
The original data were stored in the
ASSET data structure of the Mike Urban
allowing the used to refer to original data
any time during the use of simul
ation
model. Some of data got also post
processed and imported into MOUSE
simulation module data structure of Mike
Urban. The data were analysed for
consistency and gaps. Finally, the proposal
for next steps was introduced if necessary.
The figure 3. Shows

the Mike Urban
overview of storm water network of the city
of Sopron.


Figure
3

Storm water network


Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



8


The general preparatory works for the execution of the Urban drainage master plan for the
city of Sopron necessitated the involvement of separate sewage network into the
consideration
s of the Contractor. It is obvious that both storm water and sewage networks
are interconnected by connection pipes and overflows. In addition, it is expected that there is
a high rate of infiltration from the soil into separate sewage network.



Figure

4

Collection system in MU


These reasons caused that the Contractor focused the data collection activities also on
separate sewage system of the city of Sopron. The sewage network data were collected from
Sopron Water Utility in
addition to storm water data. In parallel other information necessary
for sewage model build was collected including wastewater production data, hydrological
data, etc. The figure 4. shows the Mike Urban overview of storm water and sewage networks
of the c
ity of Sopron.


Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



9

3

Data analysis

All collected data were imported into Mike Urban simulation model of DHI. The data was
stored in the ASSET data structure of Mike Urban. The data was then analysed on
consistency, quality, gaps, etc. The results of this work a
re presented in bellow.


3.1

Storm
-
water network data

3.1.1

Closed conduits

Data were analysed in terms of quality


missing values are reported in each layer by count
of empty attributes / km of pipes and in percentage of the whole part of the system

(Figure 5)
.


Figure
5

Collection system in MU

/perhaps the title of Fig 5 is not appropriate!!!!!!!!!!!/

Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



10



3.1.1.1

Network data


Manholes

In Sopron storm


water network is 7598 manholes. They are summarized in the table found
bellow. Out of them the only “main channel” manholes are of the concern for later model
build.

Table
2

Manhole survey by type and function





















Function

Count



B

1321

house connections

G

2764

main channel

H

3513

internal private
system

FUNKCIO

KEZELO

Count

B

fogyaszto

47

B

polghiv

1

B

vizmu

1273

G

fogyaszto

1

G

kozutkez

1

G

polghiv

1

G

vizmu

2761

H

fogyaszto

3292

H

kozutkez

134

H

polghiv

78

H

vizmu

9

Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



11


The information needed to create the model is as follows:



Ground elevation Z1



Bottom elevation Z2



Manhole shape



Dimension


Missing values in “G” category:

Table
3

Missing values in category “G”

Missing values

Number

%

ground level Z1

456


16,5

bottom level Z2


458


16,5

shape


1305


47,2

dimension


1314


47,5


The table above shows that there are approx. 15% of manholes with missing Z1, Z2
elevations. This could indicate need for additional

geodetic survey during the model build
process. Again the Contractor proposes to wait till the model schematization is done. Then
the reduction of manholes with missing Z1,2 is expected. There are several methods to be
used helping with the missing number
s e.g. use of digital terrain model, etc. It is expected
that the Contractor will discuss this possibility with the Client at the beginning of next project
phase.

Regarding manhole shape and dimension (missing aaprox.50% of data) is can be stated that
thes
e data are of low information content for the model build and can be filled up by global
data operation methods with e.g. manhole diameter = 1m. So these missing values do not
represent any problem for the subsequent model build.



Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



12


3.1.1.2

Network data


pipes

In

Sopron collection system there is 579,2 km of closed pipes, of which 226,4 km is storm
water network and 352,8 km is sewerage network.

Length of particular pipes category (storm
-
water) is in the following table.


Table
4
Length of
particular pipes by category

Function

Length (m)



B

36341.60

house connections

G

79657.16

main channel

H

110414.29

internal private system




FUNKCIO

KEZELO

Length (m)

B

fogyaszto

194.0706072

B

kozutkez

15.4232121

B

polghiv

32.82356078

B

vizmu

36099.28206

G

fogyaszto

84.47290129

G

kozutkez

22.61596324

G

polghiv

26.99106146

G

vizmu

79523.08479

H

fogyaszto

99278.7945

H

kozutkez

8102.720718

H

polghiv

2689.386744

Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



13

H

vizmu

343.3853291

For the purpose of creating model in the future is
necessary to know next information:



From Manhole



To Manhole



Dimension (DN, height, etc.)



Shape



Upstream Z1 elevation



Downstream Z2 elevation



Material

Some of this information
are
missing; in the following table is a summary of missing values in
the storm


water system (closed conduits). Only data of main channels were analysed,
about internal private systems client (WU) does not have enough information.

Table
5

Missing values in internal private in systems


Missing values

km

%

Shape


0,03


0,04

Dimension


0


0

material


0


0

upstream Z1


12,4


15,6

downstream
Z2


12,9


16,2

It can be concluded after the analysis of data that most of data is available and ready to be
used for model build. The absence of Z1 and Z2 coordinates

could cause a need for
additional survey in Sopron storm water network. However, the situation can get changed
after the process of physical system schematization


first step in the model build process.

Physical system can be modelled with distinct level

of complexity referred to as system
schematization. The schematization of the physical system reality represents very important
procedure which affects the way model behaves and the results it produces. It consists of
Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



14

schematization on distinct sub
-
domain
s where flow / generation / consumption of water can
be defined e.g. sewer system schematization, catchment schematization, treatment plant
schematization and receiving water schematization. The schematization can vary from
coarse strategic model to detail
ed planning model based on purpose of the model and data
available.

In parallel with structural system data schematization so called initial and boundary
conditions necessary for model run are to be schematized. These are represented for
instance by histor
ical rainfall series, long term water demands, water level variation, etc.

The Contractor proposes to wait with the final decision till the schematization of the system is
done during the subsequent model build phase of the project.

After schematization t
he
percentage of missing Z1, Z2 will for sure decrease. Missing values can be filled in
cooperation with Sopron Water utility (survey, employee observations, survey) and by
applying special techniques e.g. slope similarity.


List of profiles

Another impor
tant model input is represented by cross section profiles. These can vary from
simple circular shapes through Egg shape to specialized shape e.g. “mouth type”. After the
analysis it can be concluded that most of the cross sections are available and localiz
ed to the
particular pipe in the network. The summary of cross section analysis is presented below.

Circular profile:

Table
6

Circular pipes length by materials and size


Material / Length (km)

MERET

ac

b

hobas

KG

Koagyag

tegla

up

100


1.67

0.31





15


0.02


0.02

0.04



20

0.43

1.56


0.21

0.88


0.01

25


0.28


0.03




30

2.21

18.31

0.56

1.33

5.04



40

1.81

13.73

0.12

0.71

3.69



50

0.97

5.90

0.34

0.37

1.57



60

0.29

5.30

0.33


0.96


0.72

70



0.78





Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



15

80

0.07

2.34

0.45


0.23



Egg shape profile:




Table
7

Egg shape pipes length by material and size



Material / Length
(km)

MERET

b

tegla

100/70

0.27

0.91

110/70



0.10

110/80



0.14

120/90

1.55

0.30

30/40

0.51



60/90

1.64

0.32

90/60

0.12



90/70

0.003




The cross section data were imported into Mike Urban Cross section database to be later
used during the development of simulation model.



3.1.1.3

Network data
-

s
tructures

The hydraulic structures represent important item of the urban drainage
system. These
structures affect the hydraulic behaviour of the system, water balances and overall system
performance. That is why it is important to analyse these structures in detail. Next structures
Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



16

were analysed in Sopron drainage network


outlets, ret
ention/sedimentation basins, pumps,
CSOs, inverted siphons.


3.1.1.3.1

Outlets

In Sopron storm


water network there is 268 outlets as summarized in bellow.

Table
8

Outlets

Function

Count



B

94

house connections

G

133

main channel

H

41

internal private
system


FUNKCIO

KEZELO

Count

B

fogyaszto

44

B

kozutkez

22

B

polghiv

20

B

vizmu

8

G

fogyaszto

32

G

kozutkez

9

G

polghiv

14

G

vizmu

78

H

fogyaszto

37

H

kozutkez

2

H

polghiv

2


The information needed to create a model is as
follows:



Ground elevation Z1

Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



17



Bottom elevation Z2



Water level at outlet (if outlet is flooded from river side)

This information is not in the shapefile (client database), for the purpose of creating a model
in the future is necessary to collect this informa
tion.

3.1.1.3.2

Retention/sedimentation basins

In Sopron storm


water network there are 62 structures (sedimentation basins).

Table
9

Structures

Function

Count



B

4

house connections

G

20

main channel

H

38

internal private
system


FUNKCIO

KEZELO

Count

B

fogyaszto

2

B

vizmu

2

G

fogyaszto

8

G

vizmu

12

H

fogyaszto

37

H

polghiv

1

The information needed to create a model is as follows:



Volume



Connections,



Dimension

Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



18

Table
10

Missing values

Missing values

count

%

Volume

5

41,6


This information is not available.

For the purpose of creating a model in the future it will be
necessary to collect this information.

3.1.1.3.3

Pumping stations

In the storm


water network are two private pumping stations. The data of
these pumping
stations are not available and it is a question if there is a need for incorporation of private
networks into Sopron simulation model.

3.1.1.3.4

Weirs

In received data was no information about

presence of
weirs

in the storm water network
.

3.1.1.3.5

Operational d
ata

The Sopron Water utility logs as operational data pumping station data and logs problem and
system failures. System failures are recorded on work sheets and stored in Technical
Information System. No relevant problem was recorded.

However, such operati
onal data can
be used during model calibration phase. The details will be discussed at the beginning of
model build process.

3.1.2

Open channels and creeks

The open channels generally do not form a system in the city, except at the district
Kutyahegy. Data based on detailed survey of us and from the report of West
-
Hungarian
University are available. Channels
on area Kutyahegy

have been built recently with
pre
fabricated concrete elements, and from hydraulic point of view they are in good condition.
There are several culverts with varying density along the channels, which can modify
significantly the hydraulic capacities. D
ue to this condition and d
epending on t
he
system
schematization, further refinement would be necessary concerning channels remained

in the
model
.

The receiving water bodies of surface runoff from the city are the Ikva and the Rák creeks
and their some small tributaries. During July
-
August 2011 some survey trips were executed
along the creeks, from the inflow of treated wastewater to the Ikva creek a
t the WWTP up to
the practical border of the built area of Sopron. Further data and information gained from
channel control plans of both creeks. The plans (ÉDUKÖVIZIG: Sopron, Ikva riverbed control
/43+376


44+996/, 2007, and Ökopartner: Sopron, Rák cree
k bed control and reconstruction
/3+630
-
5+830/, 2003) were borrowed by the Municipality of Sopron.

Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



19


3.1.2.1
Network data


Cross sections

Some 156 cross sections were surveyed or data of them imported from plans mentioned
above.
We found extremely differ
ent bed conditions along the creeks. The downstream
reaches, between the city border and the WWTP outflow we found
as naturalized like

bed
(however, which is rather dilapidated)
with rich vegetation in the high water bed and pure bed
conditions in the low
water bed. Reaches inside the city show really different conditions and
shapes. Latter are altering as V
-
shaped, trapezoidal, and
multiple, furthermore
rectangular,
with or without paved slopes. There were found well and poorly maintained longer and
shorte
r reaches

with sedimentation and/or wash
-
out paved bed
. Photo 1 shows typical
reaches.





Photo 1:

Typical reaches of Ikva and Rák creeks

Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



20

3.1.2.2 Network data
-

Structures

In open channels there are few types of construction. At
inflow

of open channels
into

closed
conduits generally (but not in every cases) bed load samplers can be found. Their sizes look
like
mostly
haphazard, without proper planning. We also found rack for blocking floating
garbage

(Ágfalvi út). These racks (if there
are in other channels), also) would cause
unpredictable local hydraulic losses, which depends on the amount of garbage entrapped.

In
creeks above the closed conduits we found bottom drops, stilling basins with bed load
trapping (Photo 2). Cross
-
sections of

them are surveyed.



Photo 2: Stilling basin on Ikva creek and bottom drops on Rák creek

The open riverbeds, especially of the Rák creek are changed to closed ones several times.
At the Hajnal square a 1278 m long (between 7+107 and 5+830 river kilomet
res), and at the
Fasor street an other 1475 m long (between 3+630 and 2+155 river kilometres) closed
conduits are headed

in the Rák creek
. Because of safety reasons no survey was done inside
these sections. It will be supposed in hydraulic modelling that s
hape
is the same along the
tunnels. Several f
urther closed cross sections are at bridges. At these points there are
changes in the shapes. Generally the nearly trapezoidal alters to rectangular. Heads of
the
two longest

closed conduits can be seen in Photo

3
.




Photo 3: Head of tunnels on Rák creek

Head of tunnel at Fasor street


Head of tunnel at Hajnal square


Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



21

During the survey we realised that new mouth of rainwater channel was under construction
on the Rák creek just downstream at the crossing of railway line Sopron
-
Budapest
and the
crek
(Photo 4.).




Photo 4: New mouth of rainwater channel


As

we were i
nformed by the Engineer, t
ogether with this inlet construction were done
(will
be?)
some, temporarely not known reconstructions in the sub
-
watershed aro
u
nd the Harkai
street.

Before build up a simulation model the new system configuration
on this area
sho
uld make
clear. It needs consultancy with the Client.




3.1.2.1.1

Connections between storm water and sewer network

The drainage system of the city is of separate type composed of sewage and storm water
networks. The system connects
at least
at two points: at the
corner of Híd
-

Margitbányai
street and Besenyő Street 15. The following map shows the location of the two connections:

The main purpose of these two

connections is to relieve the sewage system during rain
events or to solve capacity problems.
This indicat
es another problem of separate sewage
system e.g. inflow/infiltration during wet weather periods.

Information received about the connection

is placed in Table 11.

Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



22



















Table
11

Connections between sewage and storm water networks

ID

Material

Size

Shape

Construction
year

Cover
level
(m.B.f)

Bottom
level
(m.B.f)

Híd
-

Margitbányai
street

concrete

100

Circular

1980

209,29

207,14

Besenyő Street
15

concrete

80x80

Rectangular

1975

232,39

230,16


Figure
6

Connections between the sewage and storm water networks


Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



23

3.2

Sewerage
-
network data

The total length of sewerage system is 352,8 km, of which the total length of mains is 162.71
km. The rest is the length of
the household connections. In Table 12 only the length of mains
are listed by profiles and pipe materials (139.45 km). We have found further 23.26 km pipes
of which no material was indicated. These are summarized in Table 12a.

The majority of
pipes are
circular, but due to the former combined system character there are egg
-
shaped
pipes, too.

3.2.1

Network data

Table 12: Pipes by profiles
, materials

and len
g
ths in
meter for t
he sewerage system


Size

(cm)

steel

ac

Con
-

crete

other

Hobas

KG

KM
-
PVC

KPE

V
itrif.

clay

Plas
-

tic

PVC

brick

Ü
P
E

6.3








619






10


4




16





247



12.5


40




51





11



15


113

589



3053


23

246





16






249


23





72

20

12

3477

4799

238


64115

74

28

5878

1035

959


1978

25


107

1188

68


101

6


12642





30

4

1018

13977

26


5954


138

469

27

45



35



14











40


101

2552



1060


10

2147

38




50


342

2824


58




883





60


2427

69
2


41




47





60/90



911









5


70














70
/105



441











80



866


206









80/110



65











Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



24

Table 2a: Sewer pipes by profiles

Size

(cm)

Lengths

(m)

15

211

20

5216

25

1227

30

15176

40

1337

50

1

100

25

200

66




Figure
7

Sopron sewerage network


Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



25

3.2.2

Structures

Data of six structures were received
from the operator, of which five are located in the
sewerage network inside the city and one CSO is at the wastewater treatment plant inflow.
The structures are different and unique side weirs, of which modelling are hydraulically rather
difficult. Four of

them represent outflows to the Ikva creek. The rest are dividers in the sewer
network. 3D figures produced by the Department of Hydrodynamic Systems at Budapest
University of Technology and Economics. Because these structures can play decisive roles in
th
e operation of rainwater affected sewerage system, their sizes need additional verification
before build up of the simulation model. Structures summary is presented in Tab. 1
3
.


Table 1
3
: Structures in the sewerage network


Location

Type

Outlet
to creek

WWTP inflow

Multiple side weir

Yes

Tóth A. street

Side weir in curve

Yes

Apácakert

Side weir in basin

Yes

Selmeci
-
Táncsics streets

Multiple side weir, divider

No

Lehár F. str
-
Ikva creek

Side weir, divider

No

Fuvaros str
-

Ikva creek

Multiple side weir at inflow of
inverted siphon
crossing

Ikva
creek

Yes



3.3

Wastewater production data

Generally there are two ways of wastewater discharge assessment as input parameter of the
network hydraulic model:




Application of national or
international guidelines (in Hungary:MI 10
-
167
-
2:1987), or



Operator’s data


First is rather used in planning process, and it is well known that it could result significant
overestimation. Operator’s data generally approached better the reality, although certain
measuring inaccuracies can distort the results. In our case latter was

applied. Measurements
taken into account were as follows:

Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



26




Yearly water consumption by consumers,



Measured hydraulic discharges at the WWTP,



Measures on the network, and



Records of rain events.


Measures can support our understandings about the spatial a
nd temporal changes of
consumption. Distribution of waste water released can be gained from the drinking water
consumption data. Based on measured consumption and its „known” wastewater proportion
the discharges of sewer network become calculable. Wastewat
er production profile, in default
of measures is not known. Records of rain events are needed in order to assess of ballast
water in the sewer system.


3.3.1

Population data


Population data was only available by settlements including Sopron city and its
agglom
eration (Table 1
4
.).

Table 1
4
: population data of settlements supplied through the Client’s network system

Settlement

Population
(capita)

Sopron city

55932

Kópháza

1887

Harka

1533

Fertőrákos

2182

Ágfalva

1951

Distribution of population and population density by streets or even districts was not
available.

3.3.2

Water consumption data


Wastewater discharge model is derived from the water consumption. Although the high
resolution of population distribution is not
available, but the fairly good spatial resolution of
water consumption gained from the operators’ database supported this job. Altogether 65535
flow meters (of which majority is not primal and/or disparate) data with their coordinates
cover the whole city.

Consumption by streets (457) was derived. However, the temporal
resolution of measured data is rather rough, inasmuch as only monthly average (and yearly)
data received. The structure of consumption database is shown in Table 1
5
.


Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



27

Table 1
5
: Structure of d
rinking water consumption database

Mapguidekey

EOV_Y_coordinate

EOV_X_coordinate

Number of
measuring
point

Average
consumption

(m
3
/month)

1AABAB

466845.9547

264000.0216

1

8

...

...

....

...

...

...

...

....

...

...



Besides the water consumption of
Sopron, further four small settlements’ consumption was
also collected. Networks of these (Kópháza, Harka, Fertőrákos and Ágfalva) are connected
to the system of Sopron. The yearly consumptions are listed in Table 1
6
.


Table 1
6
: Yearly water consumptions

Settlement

Yearly consumption (m
3
/a)

Sopron

3 466 185

Kópháza

63 720

Harka

13 972

Fertőrákos

10 524

Ágfalva

17 408

Total consumption

3 571 809

Based on the drinking water consumption and taken out the industrial consumptions higher
than 50m
3
/d, the
specific water consumptions by settlements is listed in Tab. 1
7
. Considering
the consumption data of Table 15 and population data of Table 1
4
, one can conclude that in
the settlements of agglomerations the specific water consumption hardly reaches 25 l/cap
ita,
day, which is simply unbelievable. No household could run by such low drinking water
consumption. It is supposed that people probably use their dug wells, too. As a consequence,
the average daily waste water release should higher than water consumptio
n. It can be
estimated 70 l/capita/day as a moderate and realistic value. Further discussion with Client is
necessary.

Table 1
7
: Specific water consumptions

Settlement

Specific water consumption
(l/capita/d)

Sopron

137

Kópháza

92

Harka

70

Fertőrákos

70

Ágfalva

70

Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



28

The proportion of wastewater relative to water consumption estimated 95%, as minimum.
There is no way to conclude from the consumption to an accurate value due to the significant
ballast water. The hydraulic discharge of the WWTP is always higher than the
water
consummated. Taking into account also the corrections, the WWTP’s yearly discharge is
at
least
1.6 times higher than the total consumption included industrial consumption, as well.
The wastewater production is presented in Fig. 8.






Figure
8
: Sopron wastewater production map

3.3.3

Industrial water producers

Industrial plants with high water consumption very frequently produce themselves their water
demand, meanwhile their wastewater is released to the public sewer network. In
these cases
the sewer network operator has few or no information. Fortunately Sopron Brewery is
engaged to measure the outflow. From modelling point of view the locations of industrial
and/or institutional wastewater producers releasing 50m
3

or more daily
are have higher
importance. These locations are shown in Fig. 8a.



Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



29


Figure 8a: Sites of wastewater production higher than 50m3/d


3.4

Catchment and hydrological data

The understanding of catchment hydrology and waste water production represents another
important step on the way to Sopron urban drainage model build. This information helps the
understanding of surface runoff

generation on the territory of Sopron city as well as the dry
weather flow performance of the drainage network.

3.4.1

Hydrological and admi
nistrative boundary

The administrative boundary polygon represents in fact the territory of the urban drainage
project Fig.
9
. (grey colour). This area is considered to contribute to the surface runoff
formation and transportation through the storm water ne
twork. The data is obtained in SHP
file and imported into Mike Urban.


Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



30


Figure
9
:
Sopron administrative boundary


3.4.2

Urban sub
-
catchments

The analysis of urban hydrology necessitated the development of urban sub
-
catchments
based on “
roof method”. These sub
-
catchments were generated by Mike Urban automatic
delineation tool. However, rough schematization of storm water network was necessary to
accomplish this task.

The Contractor performed rough schematization of storm water network as

indicated on
Fig.6. This schematization will be however subjected to further check/update during the
model build process. As result of urban sub
-
catchment development
3098
sub catchments
was created with total area of
18.75

km
2
see Fig.
10
.

Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



31


Figure
10

Sopron
urban sub
-
catchments


3.4.3

Urban infrastructure data

The urban infrastructure data are very important for model build in terms of the assessment
of catchment impermeability. The two main information sources are necessary to ac
complish
the task e.g. information regarding houses and roads


both expected to represent totally
impervious surface.

3.4.3.1

Houses

The layer of houses was received in dwg format as closed polygon set.After some post
-
processing, this layer is found suitable for
the impermeability analysis. Layer with houses was
Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



32

converted to polygon shapefile (ESRI format). After the conversion new shapefile was
checked and missing polygons was filled i
n (unclosed polylines) see Fig.11
.



Figure
11
: Layer

with houses



3.4.3.2

Roads

The received road layer was found useless for the processing routine implemented in Mike
Urban. That is why the Contractor used another method based on assumption of the sewage
network and street correspondence.

For the purpose of comp
utation of impermeable area sewerage network layer was utilized (as
pipes are usually under the roads). The buffer (10m) was created around the polylines
representing the system of roads in the city of Sopron. Comparison of the sewerage network
and roads i
s on the next Fig.
12
.

Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



33


Figure
12

Layer with roads



3.4.3.3

Catchment i
mpermeability data

The information regarding houses and roads brings add on value to the data analysis. By
making a use of such information the impermeability of the S
opron drainage area can be
assessed.

The layer with roads and houses was imported into Mike Urban and combined with the layer
of sub
-
catchments. The overlap of impervious areas with particular sub
-
catchment then
results in assessment of total impermeable
area for such sub
-
catchment. This work was
performed by means of Mike Urban and resulted in the hydrological analysis of the whole
drainage area of the city of Sopron. The result of this work is presented on the Figure 13
bellow.

Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



34



Figure
13
: Layer with impermeability analysis of the city of Sopron


Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



35


3.5

Ongoing Measurement data

The
ongoing measurements in the Sopron drainage area was provided for customer
information system and for waste water treatment plant (WWTP).
Based on this data next
preliminary analysis was executed.

The w
ater consumption
for year
2010 (
from
customer information system)
indicates the 9972
location
s of water supply customers and average daily

consumption

of in total 9496 m3 of
water per day.

The

permanent m
easurement at WWTP and
in the outlet of
Brewery
inn
2010
shows next
daily averages:



Pumped wastewater at the WWTP,
average 18274 m
3
/d
,



Wastewater
in the outlet of

Brewery, average
799 m
3
/d,



WWTP effluent, average
16546 m
3
/d.

The water balance between wastewater production and treatment indicates large portion of
infiltration/inflow into sewerage network during both wet and dry weather periods. The Figure
13 below shows the response of the sewerage flows to rainfall events as w
ell as the constant
infiltration during dry periods. The amount of this so called “ballast water” amounts to 100%
of sewerage water. Such dilution of sewage waters could cause bad performance of
biological component of WWTP.


Figure
14

Balance between water consumption and wastewater pumped at WWTP


Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



36

4

Recommendations

During the project Phase
-
I a number of distinct data was collected with help of Sopron Water
Utility. The data was analysed for gaps and inconsistencies and later migra
ted into Mike
Urban simulation model of DHI. Based on the data analysis next recommendations are
provided for subsequent project phase focussed on model build.


a.

Structures in storm water system


It is recommended to verify the locations and parameters of
hydraulic
structures located on storm water network. If the Sopron Water Utility made
some reconstructions in the network, this information should be
incorporated into current model data.



b.

Structures in sewage water system


Most probably the storm water network model will have to couple with
sewage water network model and both creeks to model the overall
hydrology of the Sopron drainage system.

That is why i
t is recommended to verify
also
the location and parameters of
hydra
ulic structures located on storm water network.
If
Sopron Water Utility
made some reconstructions in the network
, t
his information should be
incorporated into current model data.



c.

Inflow, infiltration


It seems more than obvious that Sopron drainage syst
em suffers from high
level of inflow and infiltration into separate sewage network. This topic
should be in primary focus during modelling of scenarios after model built. It
is recommended that a special care should be spent on verification of
interconnect
ions between sewage and storm water networks because they
will play essential role in the process of drainage.



Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



37


5

Conclusion

The Phase I


“Data collection” of the
project
Preparatory works for development of Sopron
Master plan to support Sopron city’s
sewage system development
” was executed during the
period May


October 2011. The main purpose of these activities was found in the analysis of
the available data necessary for the simulation model build. All collected data are listed in the
Annex 1.

If a
ppropriate, the data was imported (migrated) into Mike Urban simulation model of DHI.
The source data is stored into Asset data structure and remain unchanged. Some of relevant
data was later migrated into MOUSE data structure after post
-
processing works.

The data quality and quantity is discussed for all analysed data sources. It can be concluded,
that most of collected data is useful for the model build and can be directly or indirectly
transformed into Mike Urban data.

There are data gaps and local inc
onsistencies disclosed in the data. These inconsistencies
however do not represent substantial problem for the model build phase. It is recommended
to wait with the final conclusions on data quality and quantity after the model schematization.
It is expect
ed that most of the gaps and inconsistencies will disappear because they refer to
either house connection pipes or to private networks.

Finally, it can be concluded that data collection phase had developed very good basement for
subsequent model build. It
is obvious that there will be some additional network survey
needed but most of the data is now in Mike Urban software and can be fruitfully used for
model build and scenario simulation.




Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



38


6

List of Figures

Figure 1Import from client database to Mike URBAN

................................
................................
................................
..............

6

Figure 2 Example of import

................................
................................
................................
................................
.......................

7

Figure 3 Storm water network

................................
................................
................................
................................
..................

7

Figure 4 Collection system in MU

................................
................................
................................
................................
..............

8

Figure 5 Collection system in MU

................................
................................
................................
................................
..............

9

Figure 6 Connections between the sewage and storm water networks

................................
................................
.................

22

Figure 7 Sopron sewerage network

................................
................................
................................
................................
........

24

Figure 8 Sopron wastewater production map

................................
................................
................................
........................

28

Figure 9 Sopron administrative boundary

................................
................................
................................
..............................

30

Figure 10 Sopron urban sub
-
catchments

................................
................................
................................
................................

31

Figure 11 Layer with houses

................................
................................
................................
................................
...................

32

Figure 12 Layer with roads

................................
................................
................................
................................
.....................

33

Figure 13 Layer with impermeability analysis of the city of Sopron

................................
................................
.......................

34

Figure 14 Balance between water consumption and wastewater pumped at WWTP

................................
...........................

35


Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



39


7

List of Tables

Table 1 List of imported files

................................
................................
................................
................................
.....................

6

Table 2 Manhole survey by type and funct
ion

................................
................................
................................
........................

10

Table 3 Missing values in category “G”

................................
................................
................................
................................
..

11

Table 4Length of particular pipes by category

................................
................................
................................
.......................

12

Table 5 Missing values in internal p
rivate in systems

................................
................................
................................
.............

13

Table 6 Circular pipes length by materials and size

................................
................................
................................
................

14

Table 7 Egg shape pipes length by material and size

................................
................................
................................
.............

15

Table 8 Outlets

................................
................................
................................
................................
................................
........

16

Table 9 Structures

................................
................................
................................
................................
................................
...

17

Table 10 Missing values

................................
................................
................................
................................
..........................

18

Table 11 Connections between sewage and
storm water networks

................................
................................
......................

22



Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



40


8

Annex 1


source data list

Source data list


Name of the file

Path in ekn.sopviz.hu

Data
format

description of file

Sopron_csatorna_BME.zip

kep>BME_DHI

dwg

Sewage system of Sopron in
AutoCAD format, without the
database

csatorna_Mapinfo_TAB_or_MIF.zip

kep>BME_DHI

tab

mif

Sewage system of Sopron
(pipes, manholes, gullies) in
MapInfo TAB and MIF format,
with database

retegkiosztas.doc

kep>BME_DHI

doc

Explanation of layer allocations
for each AutoCAD drawings.
Database is also included in the
LAYER field

sopron.ecw

kep>BME_DHI

ecw

Orthophoto of Sopron in 2005

sopron_alap_2011_03_21_BME.dwg

kep>BME_DHI

dwg

Map of
Sopron in AutoCAD
format, layer allocation is
simplified

sopron_szintvonalak.dwg

kep>BME_DHI

dwg

Contour
-
map covering city of
Sopron produced from
orthophotos. The internal object
data contains the height

Csapadék adatok.xls

kep> BME_DHI> Adatszolgáltatás

xls

Precipitation data from Sopron
-
Fotelep and Brennbergbanya
station (date and mm
dimensions)

Dataqua.zip

kep> BME_DHI> Adatszolgáltatás

waq

Data of the overflows: Ikva
-
culvert, Toth A. street,
Apacakert

Javasolt meresi pontok a
sznnyvhalozaton.pdf

kep> BME_DHI> Adatszolgáltatás

pdf

Proposed points of
measurement on the sewer
system

SLM (BDL II.utem).doc

kep> BME_DHI> Adatszolgáltatás

doc

BDL study. Developing a
complex dynamic model for
urban rainwater management.
Describing how the SWMM
mo
del was made

SzTT terhelése.doc

kep> BME_DHI> Adatszolgáltatás

doc

Sum amount of raw sewage,
cleaned wastewater,
overflowing diluted sewage at
the wwtp in 2010

Sznyv_mennyisegek.xls

kep> BME_DHI> Adatszolgáltatás

xls

Measured wastewater loads in
the sewer system in the main 4
industrial discharger (m3/year
for 2010 and

until 2011 may
m3/125 day)

Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



41

Name of the file

Path in ekn.sopviz.hu

Data
format

description of file

Vizfogyasztas 2008.zip

kep> BME_DHI> Adatszolgáltatás

xls

Water consumption broken
down by street by month in
2008. There is no
known
significant change in the water
consumption since then

sopron_fogyujtok_jelentes3.pdf

kep> BME_DHI> Adatszolgáltatás

pdf

Study from BME Department
of
Hydrodynamic on the main
channels of the sewer system

sopron_ora_DHI_BME.zip

kep> BME_DHI> Adatszolgáltatás

pdf

Proposed points on the storm
water system

Tómalomút_zárt
-
árok.dwg

kep> BME_DHI>
Adatszolgáltatás>
Árkok_befogadók mérése

dwg


Sopron_Tömb_Tisztítva.dwg

kep> BME_DHI>
Adatszolgáltatás>
Árkok_befogadók mérése

dwg


Sopron_árkok_nyomtat_2.xls

kep> BME_DHI>
Adatszolgáltatás>
Árkok_befogadók mérése

xls

List of the open channels
(length, covered or
not,
settlement)

Problémás utakról_lista
-
1.xls

kep> BME_DHI>
Adatszolgáltatás>
Árkok_befogadók mérése

xls

List of
problematic roads

Befogadókról
-
lista_2.xls

kep> BME_DHI>
Adatszolgáltatás>
Árkok_befogadók mérése

xls

List of the operators of
the
creeks, lakes, etc.

Béka
-
tó_árok.dwg

kep> BME_DHI>
Adatszolgáltatás>
Árkok_befogadók mérése

dwg


Átnézeti_befogadókról_4.dwg

kep> BME_DHI>
Adatszolgáltatás>
Árkok_befogadók mérése

dwg


Muszaki_leiras.pdf

kep>BME_DHI>Adatszolgáltatás>
BDL I. ütem

pdf

Technical specifications

sopron_tv_szint_becs_max
-
Model.pdf

kep> BME_DHI>
Adatszolgáltatás> BDL I. ütem

pdf

Estimated relative maximum
depth of ground water level

sopron_tv_szint_becs_max_k10
-
3_szint
-
3_alatt_1.5m
-
ben
-
Model.pdf

kep> BME_DHI>
Adatszolgáltatás> BDL I. ütem

pdf

Estimated relative maximum
depth of ground water level
where the groundwater level is
deeper than 3 m and soil which
can be dried is in 3,5 m depth

sopron_tv_szint_becs_max_k10
-
3_szint
-
3_alatt_3.5m
-
ben
-
Model.pdf

kep> BME_DHI>
Adatszolgáltatás> BDL I. ütem

pd
f

Estimated relative maximum
depth of ground water level
where the groundwater level is
deeper than 3 m and soil which
can be dried is in 1,5 m depth

Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



42

Name of the file

Path in ekn.sopviz.hu

Data
format

description of file

sopron tv_Alapozasi_tr_1
-
5
-
Model.pdf

kep> BME_DHI>
Adatszolgáltatás> BDL I. ütem

pdf

Foundation map in 3,5 m depth

sopron tv_Alapozasi_tr_3
-
5
-
Model.pdf

kep> BME_DHI>
Adatszolgáltatás> BDL I. ütem

pdf

Foundation map in 3,5 m depth

Elotanulmany.pdf

kep>BME_DHI>Adatszolgáltatás>
Rák patak vízgyűjtő területe

pdf

Study on drainage of Sopron on
the Rák creek catchment. This
is

the measuring that the West
Hungarian University is doing
on the Rák creek

Fenykepek.zip

kep> BME_DHI>
Adatszolgáltatás> Rák patak
vízgyűjtő

területe

jpegs

Photos

arcview.png

kep> BME_DHI>
Adatszolgáltatás> Rák patak
vízgyűjtő területe

png


erozio

kep> BME_DHI>
Adatszolgáltatás> Rák patak
vízgyűjtő területe

shp

Area affected by erosion

kh

kep> BME_DHI>
Adatszolgáltatás> Rák patak
vízgyűjtő területe

shp


rakarok

kep> BME_DHI>
Adatszolgáltatás> Rák patak
vízgyűjtő területe

shp

Data on the open channels

rakateresz

kep> BME_DHI>
Adatszolgáltatás> Rák patak
vízgyűjtő területe

shp

Culverts

rakvuzgyujto

kep> BME_DHI>
Adatszolgáltatás> Rák patak
vízgyűjtő területe

shp

Rák creek catchment

szegely

kep> BME_DHI>
Adatszolgáltatás> Rák patak
vízgyűjtő területe

shp

Outer edges of high tops

utszel

kep> BME_DHI>
Adatszolgáltatás> Rák patak
vízgyűjtő területe

shp

End point of pavements, road,
coverage, etc.

Újdülő utca
-

Szépvölgyi utca. xlsx


kep>BME_DHI>Adatszolgáltatás>
Rák patak vízgyűjtő
területe>Tablazatok

xls

Újdülő utca and
Szépvölgyi
utca
open channel data: section
id, covered, type, size(cross
profile graph), material and
notes

Fényi Gyula utca.xls

kep> BME_DHI>
Adatszolgáltatás> Rák patak
vízgyűjtő területe> Tablazatok

xls

Fényi Gyula utca open
channel
data: section id, covered, type,
size(cross profile graph),
material and notes

Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



43

Name of the file

Path in ekn.sopviz.hu

Data
format

description of file

Gensel Ádám utca
-

Baracsi
László.xlsx


kep> BME_DHI>
Adatszolgáltatás> Rák patak
vízgyűjtő területe> Tablazatok

xls

Gensel Ádám utca and
Baracsi
László utca open
channel data:
section id, covered, type,
size(cross profile graph),
material and notes

Hajnalpír utca
-
Tűzoltó utca.xlsx


kep> BME_DHI>
Adatszolgáltatás> Rák patak
vízgyűjtő területe> Tablazatok

xls

Hajnalpír utca open channel
data: section id, covered,
type,
size(cross profile graph),
material and notes

Kertvárosi utca.xlsx


kep> BME_DHI>
Adatszolgáltatás> Rák patak
vízgyűjtő területe> Tablazatok

xls

Kertvárosi utca open channel
data: section id, covered, type,
size(cross profile graph),
material and
notes

Lakfalvi utca
-

Borz utca.xlsx


kep> BME_DHI>
Adatszolgáltatás> Rák patak
vízgyűjtő területe> Tablazatok

xls

Borz utca open channel data:
section id, covered, type,
size(cross profile graph),
material and notes

Lomb utca.xlsx

kep> BME_DHI>
Adatszolgáltatás> Rák patak
vízgyűjtő területe> Tablazatok

xls

Lomb utca open channel data:
section
id, covered, type,
size(cross profile graph),
material and notes

Menyhért
-

Holló utca.xlsx


kep> BME_DHI>
Adatszolgáltatás> Rák patak
vízgyűjtő területe> Tablazatok

xls

Menyhért utca and Holló utca
open channel data: section id,
covered, type, size(cross

profile
graph), material and notes

Rozsondai Károly
utca,Boldizsár
utca.xlsx


kep> BME_DHI>
Adatszolgáltatás> Rák patak
vízgyűjtő területe> Tablazatok

xls

Boldizsár utca and Rozsondai
Károly utca open channel data:
section id, covered, type,
size(cross profile graph),
material and notes


Szőlőskert .xlsx


kep> BME_DHI>
Adatszolgáltatás> Rák patak
vízgyűjtő területe> Tablazatok

xls

Szőlőskert utca o
pen channel
data: section id, covered, type,
size(cross profile graph),
material and notes

Thirring Gusztáv.xlsx


kep> BME_DHI>
Adatszolgáltatás> Rák patak
vízgyűjtő területe> Tablazatok

xls

Thirring Gusztáv utca open
channel data: section id,
covered,
type, size(cross profile
graph), material and notes

Utcák vízgyűjtő szerinti
csoportosítása.
docx


kep> BME_DHI>
Adatszolgáltatás> Rák patak
vízgyűjtő területe> Tablazatok

doc

Open channels broken by
catchment

Vepperdi utca.xlsx


kep> BME_DHI>
Adatszolgáltatás> Rák patak
vízgyűjtő területe> Tablazatok

xls

Péterfai utca and Vepperdi utca
open channel data: section id,
covered, type, size(cross profile
graph), material and notes

Walder József utca.xlsx


kep> BME_DHI>
Adatszolgáltatás> Rák patak
víz
gyűjtő területe> Tablazatok

xls

Walder József utca and Dalárda
utca open channel data:
section id, covered, type,
size(cross profile graph),
material and notes

s15.ini

kep>BME_DHI>Adatszolgáltatás>S
WMM

ini

SWMM files

s15.inp

kep> BME_DHI> Adatszolgáltatás>
SWMM

inp

SWMM files

Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



44

Name of the file

Path in ekn.sopviz.hu

Data
format

description of file

HS_teszt

kep> BME_DHI> Adatszolgáltatás>
SWMM


SWMM files

C_C_ARAMLAS_20110516102855586.
pdf

kep>BME_DHI>20110513_adatszol
galtatas

pdf

Proposed points on storm
water system detailed
maps

sopron_ora_DHI_BME_csapadekm.pdf

kep>BME_DHI>20110513_adatszol
galtatas

pdf

Proposed points on storm
water system

Cs1_Balfi u nem üzemeltetett úton
lévő csapadék akna c
s1/

kep>BME_DHI>20110513_adatszol
galtatas>csapadek_aramlas_helyek

jpg

Photos of Balfi utca
manhole on storm water
system

Cs3_Ady
-
Erzsbetkert elötti csapadék
akna cs3/

kep>BME_DHI>20110513_adatszol
galtatas>
csapadek_aramlas_helyek

jpg

Photos of Ady
-
Erzsébetkert utca manhole
on storm water system

Cs20_Balfi u üzemeltetett csapadék
akna cs20/

kep>BME_DHI>20110513_adatszol
galtatas>csapadek_aramlas_helyek

jpg

Photos of Balfi utca
manhole on storm water
system

Cs_1_1_Balfi u nem üzemeltetett
zöldben lévő cs
apadék akna
cs1.1/

kep>BME_DHI>20110513_adatszol
galtatas>csapadek_aramlas_helyek

jpg

Photos of Balfi utca
manhole not operating on
storm water system

Átemelő kapcsolási szint.doc


kep>BME>20110804_adatszolgalta
tas

doc

Pump station switching
level

Dataqua.zip

kep>BME>20110804_adatszolgalta
tas


Data of the overflows:
Ikva
-
culvert, Toth A.
street, Apacakert

Fajlagos térfogatok.doc

kep>BME>20110804_adatszolgalta
tas

doc

Pump station unit volume

Ikvab_T
-
2011
-
06
-
02_2011
-
08
-
10.txt

kep>BME>20110804_adatszolgalta
tas

txt

Ikva culvert temperature
measurement

Ikvab_m
-
2011
-
06
-
02_2011
-
08
-
10.txt

kep>BME>20110804_adatszolgalta
tas

txt

Ikva culvert water level
measurement

Kapcsolások 2011.05.01.
-
07.18..doc

kep> BME>
20110804_adatszolgaltatas

xls

Pump station switching
time

Mennyiségi adatok 05.01
-
07.18.
Sopron SZVT.2011.xls

kep> BME>
20110804_adatszolgaltatas

xls

Wwtp daily inflow,
outflow,
disunited rainwater

Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



45

Name of the file

Path in ekn.sopviz.hu

Data
format

description of file

NIVUS.zip

kep> BME>
20110804_adatszolgaltatas

txt

Measurement data at
Kertvárosi, Heimler Károly,
Apácakert

Tancsicsu_2011.06.01
-
2011.08.04.txt

kep> BME>
20110804_adatszolgaltatas

txt

Measurement data at
Táncsics utca

alarm_201105
-
07.zip

kep> BME>
20110804_adatszolgaltatas

xls

Pump station switching
time

támop_szintek_qh.zip

kep> BME>
20110804_adatszolgaltatas

xls

The zip file contains water
level measurements on
Rák creek and 1 xls with
Q
-
h curves they made wi
th
some measured and
calculated Q with levels.

ERESZC_ERESZ_DB_point


shp

Drips

C_MUTARGY_DB_point


shp

Structures

C_ATEMELO_DB_point


shp

Pump stations

C_KITOR_DB_point


shp

Outlet

C_RACSOK_DB_point


shp

Gullies

C_TISZTITOAKNA_DB_point


shp

Manholes

C_VEZETEK_DB_polyline


shp

Pipes

Construction


6 MUT_29A7E8.doc


doc

Construction drawing and
description of Ikva culvert
syphon and outlet
construction, Q
-
h curve is
included

Construction 5 MUT_28A3B2.doc


doc

Construction drawing of
overflow weir
at Lehár
Ferenc utca near Ikva
creek, Q
-
h curve is not
included

Constructions 1_MUT2A67B9.doc


doc

Construction drawing and
description of overflow at
the WWTP, Q
-
h curve is
not included

Constructions 2_TA73771.doc


doc

Construction drawing and
description of Tóth Antal
utca overflow, Q
-
h curve
is included

Constructions 3_ MUT_281E9E.doc


doc

Construction drawing and
description of Apácakert
overflow, Q
-
h curve is
included

Constructions 4 MUT_F3FBE.doc


doc

Construction drawing and
description of Selmeci
-
Táncsics overflow, Q
-
h
curve is included

Preparatory works for development of Sorpon Master plan to support Sopron city’s sewage system development

PHASE I

-

Data Collection Report



46

Name of the file

Path in ekn.sopviz.hu

Data
format

description of file

Daily wastewater production_2010.xls


xls

Wastewater productionin
brewery, water
consumption in 2010,
Pumped wastewater at
WWTP (m3/day) and rain
events mm/d, average
wastewater flows
/brewery
and settlements in the
agglomeration

settlement_border.dwg


dwg

Border
-

not closed line!

sopron_elevations.dwg


dwg

Contours

Sznyv_mennyisegek.xls


xls

Average wastewater flows
/brewery and settlements
in the agglomeration

impervious areas


dwg

Impervious areas

roofs


dwg

Roof borders