Waterbase-UWWTD

Data Table

2 min read

This is an old version, kept for reference only.

Go to latest version

This page was archived on 19 May 2022 with reason: Other (New version data-and-maps/data/waterbase-uwwtd-urban-waste-water-treatment-directive-8/waterbase-uwwtd was published)

The dataset contains data reported by Member States under UWWTD reporting obligations: UWWTD implementation (Article 15) and UWWTD National Implementation Programme (Article 17). The dataset consists of tables containing information on: reported period, agglomerations, urban waste water treatment plants (UWWTPs), links agglomerations – UWWTPs, discharge points, receiving areas, and (at Member State level) sludge handling and treated waste water re-use. Relevant codelist tables (big cities, NUTS, common list of values) are included as well. Article 17 tables are distinguished by the „Art17“ prefix in the table name.

Data and maps

Menu

Data tables

Definition of the tables and fields creating the published dataset is available in the Data Dictionaries (excluding the table T_UWWTPS_emission_load and codelist tables T_BigCity, T_LOV and T_NUTS – their definition is provided at the end of this section). Hyperlinks to the Data Dictionaries are embedded to the table names below:

UWWTD Article 15 tables

Table name	count of records
T_Agglomerations	26 538
T_DischargePoints	27 734
T_MSLevel	30
T_ReceivingAreas_LSA	9
T_ReceivingAreas_SA54	124
T_ReceivingAreas_SAMain	2 781
T_ReceivingAreas_SAParameter	4 083
T_ReceivingAreas_SASA	1 411
T_Reporter	31
T_ReportPeriod	30
T_UWWTPAgglos	27 445
T_UWWTPS	28 529

UWWTD Article 17 tables

Table name	count of records
T_Art17_FLAAgglomeration	3 474
T_Art17_FLAUWWTP	5 516
T_Art17_Investments	239

Codelists and other tables

Table name	count of records
T_BigCity	654
T_LOV	112
T_NUTS	2 241
T_UWWTPS_emission_load	28 529

T_UWWTPs_emission_load

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 uwwState is related to the records having value State in the codelist table T_LOV, field lovName. Fields uwwCode and uwwName are related to the table T_UWWTPs.

Field Name	Field definition	Note	Data Type
uwwState	Status of the UWWTP (link to the field lovID in the codelist table T_LOV)	105 = inactive, 106 = active	Integer
rptMStateKey	Member State abbreviation	ISO 3166-alpha-2 code	Text(2)
uwwCode	ID of UWWTP / collecting system without treatment (link to the field uwwCode in the table T_UWWTPs)		Text(32)
uwwName	Name of the UWWTP (link to the field uwwName in the table T_UWWTPs)		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 emission load data		Text(255)