All official European Union website addresses are in the europa.eu domain.
See all EU institutions and bodiesDo something for our planet, print this page only if needed. Even a small action can make an enormous difference when millions of people do it!
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 Name | Field definition | Note | Data 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 Name | Field definition | Note | Data 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 Name | Field definition | Note | Data 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 Name | Field definition | Note | Data 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 Name | Field definition | Note | Data 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 Name | Field definition | Note | Data 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 Name | Field definition | Note | Data 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 Name | Field definition | Note | Data 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 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) |
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 Name | Field definition | Note | Data 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 Name | Field definition | Note | Data 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 Name | Field definition | Note | Data 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) |
T_BigCity
Codelist of Big cities / Big discharges
Field Name | Field definition | Note | Data 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 Name | Field definition | Note | Data 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 Name | Field definition | Note | Data 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) |
For references, please go to https://www.eea.europa.eu/data-and-maps/data/waterbase-uwwtd-urban-waste-water-treatment-directive-5/waterbase-uwwtd or scan the QR code.
PDF generated on 02 Dec 2024, 08:25 AM
Engineered by: EEA Web Team
Software updated on 26 September 2023 08:13 from version 23.8.18
Software version: EEA Plone KGS 23.9.14
Document Actions
Share with others