Personal tools

Notifications
Get notifications on new reports and products. Frequency: 3-4 emails / month.
Subscriptions
Sign up to receive our reports (print and/or electronic) and quarterly e-newsletter.
Follow us
Twitter icon Twitter
Facebook icon Facebook
YouTube icon YouTube channel
RSS logo RSS Feeds
More

Write to us Write to us

For the public:


For media and journalists:

Contact EEA staff
Contact the web team
FAQ

Call us Call us

Reception:

Phone: (+45) 33 36 71 00
Fax: (+45) 33 36 71 99


next
previous
items

Skip to content. | Skip to navigation

Sound and independent information
on the environment

You are here: Home / Data and maps / Datasets / Waterbase - UWWTD: Urban Waste Water Treatment Directive / Waterbase-UWWTD (8 tables)

Waterbase-UWWTD (8 tables)

The database contains data selected from the reporting of Member States as part of the UWWTD implementation. The database 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.
Category
European data
Table definition

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

Field name Field Definition Note Data type Primary key
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 Text(16)
repVersion Version of reported data Date(10)
repSituationAt Situation as at Date(10)
repReportedPeriod Reported Year Text(4)

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

Field name Field Definition Note Data type Primary key
rptMStateKey Member State ISO 3166-alpha-2 code Text(2)
rptMStateValue Member State Text(64)
rptCulture Culture code Text(5)

T_ReceivingAreas (2216 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 name Field Definition Note Data type Primary key
rcaState Status of the area, 105=deactivated, 106=active Integer
rptMStateKey Member State All data are linked to rpMStateKey; ISO 3166-alpha-2 code Text(2)
rcaID internal numerical database code of receiving area Long integer
rcaCode ID of the area Text(32)
rcaName Name of the Receiving area Text(255)
rcaType Type of the area, 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 Long integer
rcaDateArt58 Starting date of application of Art. 5(8) of UWWTD Date(10)
rcaParameterN Parameters subject to More Stringent Treatment: N Bool(1)
rcaParameterP Parameters subject to More Stringent Treatment: P Bool(1)
rcaParameterOther Parameters subject to More Stringent Treatment: Other Bool(1)
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(10)
rcaANitro Designation Criteria (a, b, c): a - Nitrogen Bool(1)
rcaAPhos Designation Criteria (a, b, c): a - Phosphorus Bool(1)
rcaB Designation Criteria (a, b, c): b Bool(1)
rcaC Designation Criteria (a, b, c): c Bool(1)
rcaCRelevantDirective Designation criteria c - relevant EU-Directives and related parameters Memo
rcaMorphology Les sensitive area - Designation criteria (Annex II B): Morphology Bool(1)
rcaHydrologie Les sensitive area - Designation criteria (Annex II B): Hydrology Bool(1)
rcaHydraulic Les sensitive area - Designation criteria (Annex II B): Specific hydraulic conditions Bool(1)
rcaAbsenceRisk Les sensitive area - Designation criteria (Annex II B): Absence of risk of transfer of discharged load to adjacent areas Bool(1)
rcaDateArt54 Starting date of application of Art. 5(4) of UWWTD Date(10)
rcaArt54Applied Indication of application of Art. 5(4) of UWWTD Bool(1)

T_Agglomerations (26098 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 name Field Definition Note Data type Primary key
aggState Status of the agglomeration, 105=deactivated, 106=active Integer
rptMStateKey Member State All data are linked to rpMStateKey; ISO 3166-alpha-2 code Text(2)
aggID internal numerical database code of agglomeration Long integer
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 table NUTS) Integer
aggLatitude Latitude Decimal(18)
aggLongitude Longitude Decimal(18)
aggGenerated Generated load (p.e.) Long integer
bigID internal numerical database code of the big city/ big discharger (link to the table 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? 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(10)
aggC1 Rate of generated load of agglomeration collected through collecting system (% of p.e.) Decimal(18)
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(18)
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(18)
aggMethodWithoutTreatment Method used to obtain the %-value (calculated or estimated, for aggPercWithoutTreatment) Integer

T_UWWTPs (27083 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 Primary key
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 Long integer
aggID internal numerical database code of agglomeration (link to the table 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 , 111=collecting system connected to UWWTP, 112=collecting system not connected to UWWTP Integer
uwwDateClosing Date of closing of the UWWTP Date(10)
uwwHistorie Explanation for closing of the UWWTP/What happened with the wastewater since last reporting exercise Memo
uwwLatitude Latitude Decimal(18)
uwwLongitude Longitude Decimal(18)
uwwNUTS internal numerical database code of Region (NUTS) (link to the table NUTS) Integer
uwwLoadEnteringUWWTP Load entering UWWTP (p.e.) Long integer
uwwCapacity Organic design capacity (p.e.) Long integer
uwwPrimaryTreatment Primary treatment Bool(1)
uwwSecondaryTreatment Secondary treatment Bool(1)
uwwOtherTreatment More stringent treatment Bool(1)
uwwNRemoval N-removal Bool(1)
uwwPRemoval P-removal Bool(1)
uwwUV UV Bool(1)
uwwChlorination Chlorination Bool(1)
uwwOzonation Ozonation Bool(1)
uwwSandFiltration Sand filtration Bool(1)
uwwMicroFiltration Micro filtration Bool(1)
uwwOther Other type of more stringent Bool(1)
uwwSpecification Please specify other type of more stringent treatment Text(128)
uwwBOD5Perf Treatment performance: BOD5, 1=FAIL, 2=PASS Integer
uwwCODPerf Treatment performance: COD, 93=FAIL, 95=PASS, 94=Not relevant Integer
uwwTSSPerf Treatment performance: TSS,93=FAIL, 95=PASS, 94=Not relevant Integer
uwwNTotPerf Treatment performance: N, 93=FAIL, 95=PASS, 94=Not relevant Integer
uwwPTotPerf Treatment performance: P, 93=FAIL, 95=PASS, 94=Not relevant Integer

T_UWWTPAgglo (27083 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 Primary key
aucID internal numerical database code of joint entry of agglomeration and UWWTP/collecting system without treatment Long 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
aucUwwCode ID of the UWWTP Text(32)
aucUwwName Name of the UWWTP Text(255)
aggID internal numerical database code of agglomeration (link to the table Agglomerations) Long integer
aucAggCode 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 Insert % of load of agglomeration collected in collecting system and entering that treatment plant Decimal(18)
aucMethodPercEnteringUWWTP Method used to obtain the % value Integer
aucPercC2T Rate of generated load of agglomeration transported to this UWWTP by trucks (%) Decimal(18)

T_DischargePoints (27757 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.

Field name Field Definition Note Data type Primary key
dcpState Status of the discharge point, 105=deactivated, 106=active Integer
rptMStateKey Member State All data are linked to rpMStateKey; ISO 3166-alpha-2 code Text(2)
dcpID internal numerical database code of discharge point Long integer
uwwID internal numerical database code of UWWTP/ collecting system without treatment (link to the table 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 table NUTS) Long integer
dcpLatitude Latitude Decimal(18)
dcpLongitude Longitude Decimal(18)
dcpWaterBodyType 113 and 118=discharge in coastal water, 114 anbs 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 In case of discharge on land please specify the purpose Integer
dcpTypeOfReceivingArea 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 ReceivingAreas) Relevant in case SA, CSA or LSA was chosen for parameter dcpTypeOfReceivingArea Long integer
dcpSurfaceWaters Are there surface waters available? Integer
dcpWaterbodyID ID of WFD waterbody Text(64)
dcpNotAffect Do comprehensive studies indicate that the discharge does not adversely affect the environment? Integer
dcpMSProvide Has the Member State provided these studies to the Commission Integer
dcpCOMAccept Did the Commission formally accept that the conditions under Art. 6(2) are met? 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(10)
dcpWaterBodyReferenceDate Reference date of the WFD waterbody Date(10)
dcpGroundWaterReferenceDate Reference date of the WFD groundwater body Date(10)
dcpReceivingWaterReferenceDate Reference date of the receiving water Date(10)
dcpWFDSubUnitReferenceDate Reference date of the WFD sub-unit Date(10)

T_MSLevel (28 records)
Table summarises aggregated (on MS level) information on the sludge hangling, its discharge and/or disposal and re-use of treated water.

Field name Field Definition Note Data type Primary key
rptMStateKey Member State All data are linked to rpMStateKey; ISO 3166-alpha-2 code Text(2)
mslSludgeProduction Yearly production of sludge (t DS/y) Long integer
mslDischargePipelines Of which discharged into surface waters: Pipelines (t DS/y) Decimal(18)
mslDischargeShips Of which discharged into surface waters: Ships (t DS/y) Decimal(18)
mslDischargeOthers Of which discharged into surface waters: Others (t DS/y) Decimal(18)
mslReuseSoilAgriculture Of which: re-used: Soil and agriculture (t DS/y) Decimal(18)
mslReuseOthers Of which: re-used: Others (t DS/y) Decimal(18)
mslDisposalLandfill Of which: disposed: Landfill (t DS/y) Decimal(18)
mslDisposalIncineration Of which: disposed: Incineration (t DS/y) Decimal(18)
mslDisposalOthers Of which: disposed: Others (t DS/y) Decimal(18)
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 Bool(1)
mslWWReuseInd Re-use of treated wastewater in: Industry Bool(1)
mslWWReuseOther Re-use of treated waste water in: Others Bool(1)
mslWWReuseExplain Re-use of treated waste water: Please explain others Text(50)
Files

Geographical coverage

[+] Show Map

Document Actions

Comments

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