This content has been archived on 27 Feb 2015, reason:
Other
(New version data-and-maps/data/waterbase-uwwtd-urban-waste-water-treatment-directive-4 was published)

Urban Waste Water treatment Directive concerns the collection, treatment and discharge of urban waste water and the treatment and discharge of waste water from certain industrial sectors. The objective of the Directive is to protect the environment from the adverse effects of the above mentioned waste water discharges.

European data

Waterbase-UWWTD (9 tables)

The dataset contains data selected from the reporting of Member States as part of the UWWTD implementation. The dataset is divided into tables on: reported period, receiving areas, agglomerations, waste water treatment plants (WWTP), links agglomerations – WWTPs, discharge points, and (at Member State level) sludge handling and treated waste water re-use. An extra table contains additional data, provided by some Member States beyond the scope of UWWTD compliance. The table definitions can be shown from [+] below and also downloaded from below Tables Metadata.

[+]Show table definition

T_ReportPeriod (27 records)Table specifies version of reported data and reference year for reporting.

Field name

Field Definition

Note

Data type

repID

internal numerical database code

Long integer

rptID

internal numerical database code connecting data to proper reporter

Long integer

rptMStateKey

Member State

ISO 3166-alpha-2 code.

Text(2)

repCode

Report ID

All data are linked to Report ID defined in form Country and Contact Details

T_ReceivingAreas (2342 records)Table summarises information on designated sensitive areas, date of designation, the purpose of the designation, type of sensitive areas. Moreover, the table specifies which particular article of the UWWTD is applied in regards to designation of sensitive areas.

Methods used for calculation of the generated load of the agglomeration

Memo

aggChanges

Are there any significant changes of the generated load compared to the previous Report?

Long integer

aggChangesComment

Comments on significant changes of the generated load compared to the previous reported load

Memo

aggPeriodOver

Date of the relevant deadline of UWWTD or Transitional Period

Date

aggC1

Rate of generated load of agglomeration collected through collecting system (% of p.e.)

Decimal

aggMethodC1

Method used to obtain the %-value (calculated or estimated, for aggC1)

14=calculated, 15=estimated

Integer

aggC2

Rate of generated load of agglomeration addressed through IAS (% of p.e.)

Decimal

aggMethodC2

Method used to obtain the %-value (calculated or estimated, for aggC2),

Integer

aggPercWithoutTreatment

Rate of generated load of agglomeration not collected through collecting systems and not addressed through IAS (% of p.e.)

Decimal

aggMethodWithoutTreatment

Method used to obtain the %-value (calculated or estimated, for aggPercWithoutTreatment)

Integer

T_UWWTPs (27644 records)Table includes data on individual waste water treatment plants and collecting systems without UWWTP, their localisation, capacity and actual load treated, type of treatment, aggregated data on the performance of plants.

Field name

Field Definition

Note

Data type

uwwID

internal numerical database code of UWWTP/ collecting system without treatment

T_UWWTP_Agglo (26885 records)Table is a connection table combining data on agglomeration and waste water treatment plants aloowing repoting of situations where the ratio agglomeration:UWWTP is 1:n or m:1.

Field name

Field Definition

Note

Data type

aucID

internal numerical database code of joint entry of agglomeration and UWWTP/collecting system without treatment

Selected agglomeration (ID of the agglomeration connected to this UWWTP)

Text(32)

aucAggName

Selected agglomeration (Name of the agglomeration connected to this UWWTP)

Text(255)

aucPercEnteringUWWTP

% of load of agglomeration collected in collecting system and entering that treatment plant

Decimal

aucMethodPercEnteringUWWTP

Method used to obtain the % value

Integer

aucPercC2T

Rate of generated load of agglomeration transported to this UWWTP by trucks (%)

Decimal

T_DischargePoints (28597 records)Table contains information on individual points of discharge from treatment plants or collecting systems, localisation of discharge, link to specific treatment plant, type of receiving area into which the effluent/wastwater is dicharged, related waterbody (or river basin), information on the discharge on land.

113 and 118=discharge in coastal water, 114 and 119=discharge to estuary, 115=discharge in freshwater, 116 and 120 =discharge on land catchment of fresh water, 117 and 121=discharge on land catchment of coastal water

T_UWWTPs_emission_load (8781 records)Table contains additional data on incoming and discharged loads of organic matter and nutrients, provided by some Member States beyond the scope of UWWTD compliance. The data can be linked with the T_UWWTPs for further characteristics for the specific plants. A QA flag for some records relates to certain criteria and should be considered by the user for specific purposes.

Field name

Field Definition

Note

Data type

uwwState

Status of the UWWTP

105=deactivated, 106=active

Integer

rptMStateKey

Member State

All data are linked to rpMStateKey; ISO 3166-alpha-2 code

Text(2)

uwwID

internal numerical database code of UWWTP/ collecting system without treatment (link to the table UWWTPS)

Long integer

uwwCode

ID of UWWTP

Text(32)

uwwName

Name of UWWTP

Text(255)

BODIncoming

Incoming loads (t/y): BOD

Decimal

CODIncoming

Incoming loads (t/y): COD

Decimal

NIncoming

Incoming loads (t/y): Ntot

Decimal

PIncoming

Incoming loads (t/y): Ptot

Decimal

BODDischarge

Discharged loads (t/y): BOD

Decimal

CODDischarge

Discharged loads (t/y): COD

Decimal

NDischarge

Discharged loads (t/y): Ntot

Decimal

PDischarge

Discharged loads (t/y): Ptot

Decimal

QA flag

information on the data flagging

Y=record flagged

Text(1)

Remark

reference to the detailed information on the QA of the emissin load data

Additional information

The directive imposes different reporting obligations (Situation report according to Article 16 and implementation programme according to Article 17). The data presented in the UWWTD WaterBase pertains to Article 15 of the Directive, which stipulates that discharges from urban waste water treatment and amounts and composition of sludges disposed to surface waters must be monitored to verify the compliance with specific provisions of the Directive.

Some technical insight and familiarity with the terms and contexts used for the implementation of the UWWTD is required to make use of the tables.

By linking the information in the tables on agglomerations, WTTP , discharge points and receiving areas it is possible to obtain a complete picture showing what type of treatment is applied to treat waste water generated in specific agglomeration , what is the character of the area (e.g. water body) receiving discharges from waste water treatment plans or collecting systems without treatment.

The content of the table with additional data can be used for further quantitative analyses on emissions from UWWTPs with different types of treatment and various size categories. A QA-document describes a flagging of some of the provided data according to certain criteria. These flags should be considered by the user for specific purposes.

All the tables from Waterbase can be downloaded for use by all stakeholders according to below Rights. Lists and explanation of codes can also be shown and downloaded from Additional information - Code Lists. Link to further details on reporting guidelines is given from below Reporting Obligations.