Waterbase - UWWTD: Urban Waste Water Treatment Directive – reported data

Data
Prod-ID: DAT-106-en
Created 15 Oct 2014 Published 27 Feb 2015 Last modified 23 Nov 2016, 03:55 PM
Topics: ,
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 (12 data tables, 3 codelists)

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, urban waste water treatment plants (UWWTPs), links agglomerations – UWWTPs, discharge points, and (at Member State level) sludge handling and treated waste water re-use. 3 codelist tables (big cities, NUTS, common list of values) and 3 add-on tables (for agglomerations, UWWTPs and MSLevel) are included as well.

[+] Show table definition

Data tables

T_ReportPeriod (30 records)
Table specifies country, version of the reported data and reference year for reporting. Field repID is used in nearly all other tables for interlinking of these tables with table T_ReportPeriod. Field rptID is related to the table T_Reporter.

Field NameField definitionNoteData Type
repID internal numerical database code (identification of country, reported period and data delivery version) Long integer
rptID internal numerical database code connecting data to proper reporter (link to the table T_Reporter) Long integer
rptMStateKey Member State abbreviation ISO 3166-alpha-2 code Text(2)
repCode Report ID All data are linked to Report ID defined in form Country and Contact Details Text(16)
repVersion Version of reported data Date(10)
repSituationAt Situation as at reference date Date(10)
repReportedPeriod Reported Year reference year Text(4)

T_Reporter (30 records)
Table provides information on reporting state.

Field NameField definitionNoteData Type
rptID internal numerical database code (identification of the country and culture) Long integer
rptMState Specification of the country (link to the field lovID in the codelist table T_LOV) 65 = Austria, 66 = Belgium, ..., 91 = Slovakia, 92 = United Kingdom, 132 = Croatia Integer
rptMStateKey Member State abbreviation ISO 3166-alpha-2 code Text(2)
rptMStateValue Member State name Text(64)
rptCulture Culture code Text(5)

T_ReceivingAreas (2766 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. Field repID is related to the table T_ReportPeriod. Fields rcaState and rcaType are related to the field lovID in the codelist table T_LOV.

Field NameField definitionNoteData Type
rcaID internal numerical database code of Receiving area Long integer
repID internal numerical database code connecting data to proper country, reported period and data delivery version (link to the table T_ReportPeriod) Long integer
rptMStateKey Member State abbreviation ISO 3166-alpha-2 code Text(2)
rcaState Status of the Receiving area (link to the field lovID in the codelist table T_LOV) 105 = inactive, 106=active Integer
rcaCode ID of the Receiving area Text(32)
rcaName Name of the Receiving area Text(255)
rcaType Type of the Receiving area (link to the field lovID in the codelist table T_LOV) 96 = application of Article 5(4), 97 = application of Article 5(8), 98 = catchment of sensitive area, 99 = less sensitive area, 100 = normal area, 101 = sensitive area Integer
rcaSensitiveArea Related Sensitive area -999 = data not available Long integer
rcaDateArt58 Starting date of application of Art. 5(8) of UWWTD Date
rcaParameterN Parameters subject to More Stringent Treatment: N 0 = false, -1 = true Boolean
rcaParameterP Parameters subject to More Stringent Treatment: P 0 = false, -1 = true Boolean
rcaParameterOther Parameters subject to More Stringent Treatment: Other 0 = false, -1 = true Boolean
rcaDateDesignation Last date of designation or revision/ in case Art. 5(8) and 5(2-3) is applied: Starting date of application of Art. 5(2-3) Date
rcaANitro Designation Criteria (a, b, c): a - Nitrogen 0 = false, -1 = true Boolean
rcaAPhos Designation Criteria (a, b, c): a - Phosphorus 0 = false, -1 = true Boolean
rcaB Designation Criteria (a, b, c): b 0 = false, -1 = true Boolean
rcaC Designation Criteria (a, b, c): c 0 = false, -1 = true Boolean
rcaCRelevantDirective Designation criteria c - relevant EU-Directives and related parameters Memo
rcaMorphology Less sensitive area - Designation criteria (Annex II B): Morphology 0 = false, -1 = true Boolean
rcaHydrologie Less sensitive area - Designation criteria (Annex II B): Hydrology 0 = false, -1 = true Boolean
rcaHydraulic Less sensitive area - Designation criteria (Annex II B): Specific hydraulic conditions 0 = false, -1 = true Boolean
rcaAbsenceRisk Less sensitive area - Designation criteria (Annex II B): Absence of risk of transfer of discharged load to adjacent areas 0 = false, -1 = true Boolean
rcaDateArt54 Starting date of application of Art. 5(4) of UWWTD Date
rcaArt54Applied Indication of application of Art. 5(4) of UWWTD 0 = false, -1 = true Boolean

T_Agglomerations (27695 records)
Table contains information on agglomerations with generated load ≥ 2000 P.E., including names, coordinates, generated load and information whether the load generated is collected through collecting system or addressed via Individual Appropriate Systems (IAS) or not collected not addressed via IAS. Field repID is related to the table T_ReportPeriod. Field aggNUTS is related to the field nutID in the codelist table T_NUTS. Field bigID is related to the codelist table T_BigCity. Fields aggState, aggChanges, aggMethodC1, aggMethodC2 and aggMethodWithoutTreatment are related to the field lovID in the codelist table T_LOV.

Field NameField definitionNoteData Type
aggID internal numerical database code of Agglomeration Long integer
aggState Status of the Agglomeration (link to the field lovID in the codelist table T_LOV) 105 = inactive, 106 = active Integer
repID internal numerical database code connecting data to proper country, reported period and data delivery version (link to the table T_ReportPeriod) Long integer
rptMStateKey Member State abbreviation ISO 3166-alpha-2 code Text(2)
aggCode ID of the Agglomeration Text(32)
aggName Name of the Agglomeration Text(255)
aggNUTS internal numerical database code of Region (NUTS)) (link to the field nutID in the codelist table T_NUTS) Integer
aggLatitude Latitude (ETRS89, decimal degrees) Decimal
aggLongitude Longitude (ETRS89, decimal degrees) Decimal
aggGenerated Generated load (p.e.) Long integer
bigID internal numerical database code of the Big city / Big discharger (link to the field bigID in the codelist table T_BigCity) Long integer
aggCalculation 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? (link to the field lovID in the codelist table T_LOV) 122 = No, 123 = Yes 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) (link to the field lovID in the codelist table T_LOV) 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) (link to the field lovID in the codelist table T_LOV) 14 = calculated, 15 = estimated 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) (link to the field lovID in the codelist table T_LOV) 0 = information not available, 14 = calculated, 15 = estimated Integer

T_UWWTPs (30043 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 repID is related to the table T_ReportPeriod. Field aggID is related to the table T_Agglomerations. Field uwwNUTS is related to the field nutID in the codelist table T_NUTS. Fields uwwState, uwwCollectingSystem, uwwBOD5Perf, uwwCODPerf, uwwTSSPerf, uwwNTotPerf, uwwPTotPerf and uwwOtherPerf are related to the field lovID in the codelist table T_LOV.

Field NameField definitionNoteData Type
uwwID internal numerical database code of UWWTP / collecting system without treatment Long integer
uwwState Status of the UWWTP (link to the field lovID in the codelist table T_LOV) 105 = inactive, 106 = active Integer
repID internal numerical database code connecting data to proper country, reported period and data delivery version (link to the table T_ReportPeriod) Long integer
rptMStateKey Member State abbreviation All data are linked to rpMStateKey; ISO 3166-alpha-2 code Text(2)
aggID internal numerical database code of agglomeration (link to the table T_Agglomerations) Long integer
uwwCode ID of UWWTP / collecting system without treatment Text(32)
uwwName Name of UWWTP / collecting system without treatment Text(255)
uwwCollectingSystem Identification whether it is the existing UWWTP (in operation) or a collecting system without UWWTPs (link to the field lovID in the codelist table T_LOV) 111 = collecting system connected to UWWTP, 112 = collecting system not connected to UWWTP Integer
uwwDateClosing Date of closing of the UWWTP year Integer
uwwHistorie Explanation for closing of the UWWTP / What happened with the wastewater since last reporting exercise Memo
uwwLatitude Latitude (ETRS89, decimal degrees) Decimal
uwwLongitude Longitude (ETRS89, decimal degrees) Decimal
uwwNUTS internal numerical database code of Region (NUTS) (link to the field nutID in the codelist table T_NUTS) Integer
uwwLoadEnteringUWWTP Load entering UWWTP (p.e.) Long integer
uwwCapacity Organic design capacity (p.e.) Long integer
uwwPrimaryTreatment Primary treatment 0 = false, -1 = true Boolean
uwwSecondaryTreatment Secondary treatment 0 = false, -1 = true Boolean
uwwOtherTreatment More stringent treatment 0 = false, -1 = true Boolean
uwwNRemoval N-removal 0 = false, -1 = true Boolean
uwwPRemoval P-removal 0 = false, -1 = true Boolean
uwwUV UV 0 = false, -1 = true Boolean
uwwChlorination Chlorination 0 = false, -1 = true Boolean
uwwOzonation Ozonation 0 = false, -1 = true Boolean
uwwSandFiltration Sand filtration 0 = false, -1 = true Boolean
uwwMicroFiltration Micro filtration 0 = false, -1 = true Boolean
uwwOther Other type of more stringent treatment 0 = false, -1 = true Boolean
uwwSpecification Please specify other type of more stringent treatment Text(255)
uwwBOD5Perf Treatment performance: BOD5 (link to the field lovID in the codelist table T_LOV) 0 = data not available, 1 = fail, 2 = pass, 94 = not relevant Integer
uwwCODPerf Treatment performance: COD (link to the field lovID in the codelist table T_LOV) 0 = data not available, 93 = fail, 95 = pass, 94 = not relevant Integer
uwwTSSPerf Treatment performance: TSS (link to the field lovID in the codelist table T_LOV) 93 = fail, 95 = pass, 94 = not relevant Integer
uwwNTotPerf Treatment performance: N (link to the field lovID in the codelist table T_LOV) 93 = fail, 95 = pass, 94 = not relevant Integer
uwwPTotPerf Treatment performance: P (link to the field lovID in the codelist table T_LOV) 93 = fail, 95 = pass, 94 = not relevant Integer
uwwOtherPerf Treatment performance: Other (link to the field lovID in the codelist table T_LOV) 93 = fail, 95 = pass, 94 = not relevant Integer

T_UWWTP_Agglo (28685 records)
Table is a connection table combining data on agglomeration and urban waste water treatment plants allowing repoting of situations where the ratio agglomeration:UWWTP is 1:n or m:1. Field repID is related to the table T_ReportPeriod. Field uwwID is related to the table T_UWWTPs. Fields aucUwwCode and aucUwwName are related to the fields uwwCode and uwwName in the table T_UWWTPs. Field aggID is related to the table T_Agglomerations. Fields aucAggCode and aucAggName are related to the fields aggCode and aggName in the table T_Agglomerations. Field aucMethodPercEnteringUWWTP is related to the field lovID in the codelist table T_LOV.

Field NameField definitionNoteData Type
aucID internal numerical database code of joint entry of agglomeration and UWWTP / collecting system without treatment Long integer
repID internal numerical database code connecting data to proper country, reported period and data delivery version (link to the table T_ReportPeriod) Long integer
rptMStateKey Member State abbreviation ISO 3166-alpha-2 code Text(2)
uwwID internal numerical database code of UWWTP / collecting system without treatment (link to the table T_UWWTPs) Long integer
aucUwwCode ID of UWWTP / collecting system without treatment (link to the field uwwCode in the table T_UWWTPs) Text(32)
aucUwwName Name of the UWWTP (link to the field uwwName in the table T_UWWTPs) Text(255)
aggID internal numerical database code of agglomeration entering that treatment plant (link to the tableT_Agglomerations) Long integer
aucAggCode ID of the agglomeration entering that treatment plant (link to the field aggCode in the table T_Agglomerations) Text(32)
aucAggName Name of the agglomeration entering that treatment plant (link to the field aggName in the table T_Agglomerations) Text(255)
aucPercEnteringUWWTP % of load of agglomeration collected in collecting system and entering that treatment plant Decimal
aucMethodPercEnteringUWWTP Method used to obtain the % value (link to the field lovID in the codelist table T_LOV) 14 = calculated, 15 = estimated Integer
aucPercC2T Rate of generated load of agglomeration transported to this UWWTP by trucks (%) Decimal

T_DischargePoints (28215 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/wastewater is discharged, related waterbody (or river basin), information on the discharge on land. Field repID is related to the table T_ReportPeriod. Field uwwID is related to the table T_UWWTPs, to ensure the link between Discharge point and UWWTP. Field rcaID is related to the table T_ReceivingArea, to ensure the link between Discharge point and Receiving area, into which the treated waste water is discharged. Field dcpNUTS is related to the field nutID in the codelist table T_NUTS. Fields dcpState, dcpWaterBodyType, dcpTypeOfReceivingArea, dcpSurfaceWaters, dcpNotAffect, dcpMSProvide and dcpCOMAccept are related to the field lovID in the codelist table T_LOV.

Field NameField definitionNoteData Type
dcpID internal numerical database code of Discharge point Long integer
dcpState Status of the Discharge point (link to the field lovID in the codelist table T_LOV) 105 = inactive, 106 = active Integer
repID internal numerical database code connecting data to proper country, reported period and data delivery version (link to the table T_ReportPeriod) Long integer
rptMStateKey Member State abbreviation ISO 3166-alpha-2 code Text(2)
uwwID internal numerical database code of UWWTP / collecting system without treatment (link to the table T_UWWTPs) Long integer
dcpCode ID of the Discharge point Text(32)
dcpName Name of the Discharge point Text(255)
dcpNUTS internal numerical database code of Region (NUTS) (link to the field nutID in the codelist table T_NUTS) Long integer
dcpLatitude Latitude (ETRS89, decimal degrees) Decimal
dcpLongitude Longitude (ETRS89, decimal degrees) Decimal
dcpWaterBodyType Water body type (link to the field lovID in the codelist table T_LOV) 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 Integer
dcpIrrigation Purpose of discharge on land Integer
dcpTypeOfReceivingArea Type of Receiving area (link to the field lovID in the codelist table T_LOV) 96 = application of Article 5(4), 97 = application of Article 5(8), 98 = catchment of sensitive area, 99 = less sensitive area, 100 = normal area, 101 = sensitive area Integer
rcaID internal numerical database code of Receiving area (link to the table T_ReceivingAreas) Relevant in case SA, CSA or LSA was chosen for parameter dcpTypeOfReceivingArea Long integer
dcpSurfaceWaters Availability of surface waters (link to the field lovID in the codelist table T_LOV) 122 = no, 123 = yes Integer
dcpWaterbodyID ID of WFD waterbody Text(64)
dcpNotAffect Comprehensive studies indicate that the discharge does not adversely affect the environment (link to the field lovID in the codelist table T_LOV) 122 = no, 123 = yes Integer
dcpMSProvide Member State provided these studies to the Commission (link to the field lovID in the codelist table T_LOV) 122 = no, 123 = yes Integer
dcpCOMAccept Commission formally accept that the conditions under Art. 6(2) are met (link to the field lovID in the codelist table T_LOV) 122 = no, 123 = yes Integer
dcpGroundWater ID of WFD groundwater body Text(64)
dcpReceivingWater ID of receiving water Text(64)
dcpWFDSubUnit ID of WFD sub-unit Text(64)
dcpWFDRBD ID of WFD river basin district Text(64)
dcpRemarks Remarks Memo
dcpWFDRBDReferenceDate Reference date of the WFD river basin district Date
dcpWaterBodyReferenceDate Reference date of the WFD waterbody Date
dcpGroundWaterReferenceDate Reference date of the WFD groundwater body Date
dcpReceivingWaterReferenceDate Reference date of the receiving water Date
dcpWFDSubUnitReferenceDate Reference date of the WFD sub-unit Date

T_MSLevel (29 records)
Table summarises aggregated (on MS level) information on the sludge handling, its discharge and/or disposal and re-use of treated water. Field mslMS is related to the field lovID in the codelist table T_LOV.

Field NameField definitionNoteData Type
mslID internal numerical database code Long integer
mslMS Specification of the country (link to the field lovID in the codelist table T_LOV) 65 = Austria, 66 = Belgium, ..., 91 = Slovakia, 92 = United Kingdom, 132 = Croatia Integer
repID internal numerical database code connecting data to proper country, reported period and data delivery version (link to the table T_ReportPeriod) Long integer
rptMStateKey Member State abbreviation ISO 3166-alpha-2 code Text(2)
mslSludgeProduction Yearly production of sludge (t DS/y) Long integer
mslDischargePipelines Sludge discharged into surface waters: Pipelines (t DS/y) Decimal
mslDischargeShips Sludge discharged into surface waters: Ships (t DS/y) Decimal
mslDischargeOthers Sludge discharged into surface waters: Others (t DS/y) Decimal
mslReuseSoilAgriculture Sludge re-used: Soil and agriculture (t DS/y) Decimal
mslReuseOthers Sludge re-used: Others (t DS/y) Decimal
mslDisposalLandfill Sludge disposed: Landfill (t DS/y) Decimal
mslDisposalIncineration Sludge disposed: Incineration (t DS/y) Decimal (18)
mslDisposalOthers Sludge disposed: Others (t DS/y) Decimal
mslRemarks Remarks Text(255)
mslWWReusePerc Rate of treated waste water re-used (% of total volume treated) Integer
mslWWReuseAgri Re-use of treated waste water in: Agriculture 0 = false, -1 = true Boolean
mslWWReuseInd Re-use of treated wastewater in: Industry 0 = false, -1 = true Boolean
mslWWReuseOther Re-use of treated waste water in: Others 0 = false, -1 = true Boolean
mslWWReuseExplain Re-use of treated waste water: Explanation of others Text(64)

T_UWWTPs_emission_load (30043 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 uwwState is related to the field lovID in the codelist table T_LOV. Fields uwwID, 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)
uwwID internal numerical database code of UWWTP / collecting system without treatment (link to the table T_UWWTPs) Long integer
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)

T_Add_on_Agglomerations (6462 records)
Table provides additional information on population connected to Individual Appropriate System (IAS) and population not connected to any type of treatment nor collecting system without treatment. The data is provided at agglomeration level and is supplementary to data reported in Table Agglomerations.

Field NameField definitionNoteData Type
aggID internal numerical database code of Agglomeration (can't be used as link to the table T_Agglomerations) Long integer
aggState Status of the Agglomeration (link to the field lovID in the codelist table T_LOV) 105 = inactive, 106 = active Integer
repID internal numerical database code connecting data to proper country, reported period and data delivery version (link to the table T_ReportPeriod) Long integer
aggCode ID of the Agglomeration (link to the table T_Agglomerations) Text(32)
aggName Name of the Agglomeration (link to the table T_Agglomerations) Text(255)
aggInhabitantsConnectedIAS number of inhabitants connected to Individual Appropriate Systems of waste water treatment Long integer
aggInhabitantsWithoutTreatment number of inhabitants not to collecting systems nor to Individual Appropriate Systems of waste water treatment Long integer
aggRemarks Memo Text(255)

T_Add_on_UWWTPs (834 records)
The data provided in this table is supplementary to information reported in Table UWWTPS. The table contains Information on population connected to individual waste water treatment plant or collecting system, EPRTR code of facility (waste water treatment plants) if relevant, information whether more stringent effluent standards apply to the individual waste water treatment plant. Moreover, Member States can provide information on the type of effluent flow.

Field NameField definitionNoteData Type
uwwID internal numerical database code of UWWTP / collecting system without treatment (can't be used as link to the table T_UWWTPs) Long integer
uwwState Status of the UWWTP (link to the field lovID in the codelist table T_LOV) 105 = inactive, 106 = active Integer
repID internal numerical database code connecting data to proper country, reported period and data delivery version (link to the table T_ReportPeriod) Long integer
uwwCode ID of UWWTP / collecting system without treatment (link to the table T_UWWTPs) Text(32)
uwwName Name of UWWTP / collecting system without treatment (link to the table T_UWWTPs) Text(255)
uwwCollectingSystem Identification whether it is the existing UWWTP (in operation) or a collecting system without UWWTPs (link to the field lovID in the codelist table T_LOV) 111 = collecting system connected to UWWTP, 112 = collecting system not connected to UWWTP Integer
uwwE_PRTRCode E-PRTR code of waste water treatment plant under which it is reported in E-PRTR database Text(128)
uwwpInhabitantsConnected number of inhabitants connected to waste water treatment plant Long integer
uwwMoreStringentStandards Indication of application of more stringent effluent standards as compared to UWWTD Boolean
uwwMoreStringentStandardsNtot Indication of application of more stringent effluent standards for N total as compared to UWWTD Boolean
uwwMoreStringentStandardsPtot Indication of application of more stringent effluent standards for Ptotal as compared to UWWTD Boolean
uwwMoreStringentStandardsBOD Indication of application of more stringent effluent standards for BOD as compared to UWWTD Boolean
uwwMoreStringentStandardsOther Indication of application of more stringent effluent standards for other parameters as compared to UWWTD Text(255)
uwwEffluentFLowType Specification of effluent treatment 1-fully treated effluent- dry and wet weather, partially treated storm water; 2-fully treated effluent- dry and wet weather; 3-fully treated effluent- dry weather; Integer
uwwEffluentFLowTypeRemark Remarks on the CSO Text(255)
uwwRemarks Memo Text(255)

T_Add_on_MSLevel (1 record)
Table contains aggregated information (at MS level) on population connected to collecting systems, wastewater treatment plants, population not connected to any type of treatment. The data is provided for both agglomeration above and below 2000 p.e.

Field NameField definitionNoteData Type
repID internal numerical database code connecting data to proper country, reported period and data delivery version (link to the table T_ReportPeriod) Long integer
mslInhabitantsConnetecIAS Number of inhabitants connected to IAS Long integer
mslInhabitantsWithoutTreatment Number of inhabitants not connected to collecting system nor served by IAS Long integer
mslInhabitantsUwwtpCollsys Number of inhabitants connected to collecting system or treatment plant Long integer
mslInhabitantsUwwtpAgglo2 Number of inhabitants connected to collecting system or treatment plant serving agglomeration smaller than 2 000 p.e. Long integer
mslInhabitantsIASAgglo2 Number of inhabitants connected to collecting system or treatment plant serving agglomeration smaller than 2 000 p.e. Long integer
mslInhabitantsWithoutTreatmentAgglo2 Number of inhabitants in agglomeration smaller than 2 000 p.e. Long integer
mslInfoFateWithoutTreatment brief text information on the fate of generated wastewater Text(255)

Code lists

T_BigCity
Codelist of Big cities / Big discharges

Field NameField definitionNoteData Type
bigID internal numerical database code of the Big city Long integer
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
nutID internal numerical database code of the NUTS Long integer
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
lovID internal numerical database code of the LOV Long integer
lovName Name of the LOV Text(32)
lovKey Key of the LOV Text(16)
lovValue Value of the LOV Text(64)

Additional information

Metadata

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.

 

Related content

Figures produced

Interactive maps produced

Produced Indicators

See also

Used in indicators

Visualisations produced

European Environment Agency (EEA)
Kongens Nytorv 6
1050 Copenhagen K
Denmark
Phone: +45 3336 7100