next
previous
items

Waterbase-UWWTD

Data Table
2 min read
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.
Category
European data
Table definition

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 NameField definitionNoteData 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)

Code lists

T_BigCity
Codelist of Big cities / Big discharges

Field NameField definitionNoteData Type
bigCityID ID of the Big city Text(32)
bigCountryCode Member State abbreviation ISO 3166-alpha-2 code Text(4)
bigCity Name of the BigCity Text(255)

T_NUTS
Codelist of NUTS

Field NameField definitionNoteData Type
nutNUTS ID of the NUTS Text(16)
nutCountryCode Member State abbreviation ISO 3166-alpha-2 code Text(2)
nutRegion Name of the NUTS Text(64)

T_LOV
Common codelist of values appropriated to various fields and tables

Field NameField definitionNoteData Type
lovName Name of the LOV Text(32)
lovKey Key of the LOV Text(16)
lovValue Value of the LOV Text(64)
Files
Document Actions