UWWTD query


      SELECT *
      FROM T_UWWTPS, T_Agglomerations, T_UWWTPAgglos
      WHERE
        T_UWWTPAgglos.aucUwwCode = T_UWWTPS.uwwCode AND
        T_UWWTPAgglos.aucAggCode = T_Agglomerations.aggCode AND
        T_UWWTPS.uwwState=1 AND
        (
          T_UWWTPS.uwwBeginLife LIKE '19%'
          OR
          T_UWWTPS.uwwLoadEnteringUWWTP > T_UWWTPS.uwwCapacity
        )
      ;
    


4422 results ( results > 20 kms)
numfidgeomOBJECTIDuwwStaterepCodeaggCodeuwwCodeuwwNameuwwCollectingSystemuwwDateClosinguwwHistorieuwwLatitudeuwwLongitudeuwwNUTSuwwLoadEnteringUWWTPuwwCapacityuwwPrimaryTreatmentuwwSecondaryTreatmentuwwOtherTreatmentuwwNRemovaluwwPRemovaluwwUVuwwChlorinationuwwOzonationuwwSandFiltrationuwwMicroFiltrationuwwOtheruwwSpecificationuwwBOD5PerfuwwCODPerfuwwTSSPerfuwwNTotPerfuwwPTotPerfuwwOtherPerfuwwBadPerformanceuwwAccidentsuwwBadDesignuwwInformationuwwBODIncomingMeasureduwwBODIncomingCalculateduwwBODIncomingEstimateduwwCODIncomingMeasureduwwCODIncomingCalculateduwwCODIncomingEstimateduwwNIncomingMeasureduwwNIncomingCalculateduwwNIncomingEstimateduwwPIncomingMeasureduwwPIncomingCalculateduwwPIncomingEstimateduwwBODDischargeMeasureduwwBODDischargeCalculateduwwBODDischargeEstimateduwwCODDischargeMeasureduwwCODDischargeCalculateduwwCODDischargeEstimateduwwNDischargeMeasureduwwNDischargeCalculateduwwNDischargeEstimateduwwPDischargeMeasureduwwPDischargeCalculateduwwPDischargeEstimateduwwWasteWaterTreateduwwMethodWasteWaterTreateduwwBeginLifeuwwEndLifeuwwHyperlinkuwwWasteWaterReuseuwwInspireIDFacilityuwwRemarksrptMStateKeyaggAccOverflowNumberaggAccOverflowsaggBeginLifeaggBeginLife_originalaggBestTechnicalKnowledgeaggC1aggC2aggCalculationaggCapacityaggChangesaggChangesCommentaggDilutionRatesaggEndLifeaggExistMaintenancePlanaggExplanationOtheraggForecastaggGeneratedaggHaveRegistrationSystemaggLatitudeaggLongitudeaggMethodC1aggMethodC2aggMethodWithoutTreatmentaggNameaggNUTSaggOtherMeasuresaggPercPrimTreatmentaggPercSecTreatmentaggPercStringentTreatmentaggPercWithoutTreatmentaggPeriodOveraggPressureTestaggRemarksaggSewageNetworkaggSewerOverflows_m3aggSewerOverflows_peaggStateaggVideoInspectionsbigCityIDaggDateArt3aggDateArt4aggDateArt5aggHyperlinkaggIDaucAggCodeaucAggNameaucMethodPercEnteringUWWTPaucPercC2TaucPercEnteringUWWTPaucUwwCodeaucUwwNameaucUWWTP_AggloIDdistance (kms)
11061GP¢ð3.˜;@x9—⪚E@10611BG2022BGAG12574_00BGWT20482_00_01UWWTP DevnyaISCON43.2083427.59418BG331386232330011100010000PPPNRNRNR0003651495M2010-01-01T00:00:00.000BG74.825.2calculated1The size decreased due to changes of the population according to data of National Statistical Institute 202020301231270543.4062127.54779EEEVylchi dolBG33125250020141231000000aggGenerated load is according to project for construction works112/31/14 00:00:0012/31/14 00:00:00BGAG12574_00E25.274.8BGWT20482_00_01338409222.320035120798
21367GP¢€Ûæ|g‚)@˜íZj'I@13671CZ1CZAG555380CZ4103-634522-00254801-4/1UCOV NejdekISCON50.307933112.7546958CZ04117207815011011000000PPNRNR2185501218632132578550M2018-01-01T00:00:00.0002018 - Waste water from agglomeration Nejdek treated at UWWTP CZ4103-634522-00254801-4/1U. UWWTP CZ4103-702625-00013111-4/1U only treats industrial water.CZ919E0760150.192112.4346EEENejdekCZ041020101231000000112/31/10 00:00:0012/31/10 00:00:00CZAG555380E91CZ4103-634522-00254801-4/1U336446226.151323835985
31553GP¢tµû›0@ &S£ŠH@15531CZ1CZAG581682CZ6201-658154-49468952-4/1UCOV JedovniceISCON49.083116.6093CZ0646279394311111000010MicrofiltrationPPNRNR1382894291445500MCZ982E0640449.347916.7564EEEJedovniceCZ064020101231000000112/31/10 00:00:0012/31/10 00:00:00CZAG581682E98CZ6201-658154-49468952-4/1U336465531.323014091257
45906GP¢€ÎQ:$@(jMó^L@59061DK2020DK423DK8400001MARIAGERFJORD RENSEANLAEGISCON56.741810.1139DK050849207550011111000000PPPPNR0001860387822736171632825206733MDK01000DS006824656.636559.806481CCCHOBRODK050002000123100000001012/31/00 00:00:0012/31/00 00:00:0012/31/00 00:00:00DK423100DK8400001336538322.122074293773
56826GP¢@±•B"À0ùvêÈCE@68261ESES12150730908010ES12150730908010EAGUIÑO (RIBEIRA)ISCON42.529568966-9.035664099ES111325053250011111100010PPNRNRNRNR0003573217E2016-08-01T00:00:00.000http://sig.mapama.es/geoportal/visor.htmlES01000POBLACION RESIDENTE. POBLACION ESTACIONAL Y CARGA INDUSTRIAL0003250542.7101-8.72207EEERIBEIRAES11100000200012310000000C1012/31/00 00:00:0012/31/00 00:00:00http://sig.mapama.es/geoportal/visor.htmlES12150730908010E0100ES12150730908010E337801132.57886755638
68077GP¢š™™™@È>:uåßD@80771ESES9080140001010ES9080140001010EAIGUAFREDAISCON41.749192.2625ES5112895594211110000000PPPNRNRP0006314221242481745879C1995-06-01T00:00:00.000http://aca.gencat.cat/web/.content/20_Aigua/02_infraestructures/05_estacions_depuradores_daigues_residuals/Fitxes_EDAR/dagf_edar_aiguafreda.pdfES0001000(PROMEDIO ANUAL CAUDAL TRATADO(M3/D)* PROMEDIO ANUAL DE CONCENTRACIÿN DBO5 (MG/L) DEL INFLUENTE) / 600100199506012895041.450082.15986EEEAIGUAFREDAES51100000200512310000000001012/31/05 00:00:0012/31/05 00:00:00http://aca-web.gencat.cat/aca/appmanager/aca/aca?_nfpb=true&_pageLabel=P1225554461208201540084&profileLocale=esES9080140001010C0100ES9080140001010E337708134.337092179125
78110GP¢ó7¡P@0yuŽÍD@81101ESES9081200001100ES9081200001100EMATADEPERAISCON41.601612.03937ES5112530812511000000100PPPNRNRP0005516316241841274269C1995-06-01T00:00:00.000http://aca.gencat.cat/web/.content/20_Aigua/02_infraestructures/05_estacions_depuradores_daigues_residuals/Fitxes_EDAR/dmtp_edar_matadepera.pdfES0001000(PROMEDIO ANUAL CAUDAL TRATADO(M3/D)* PROMEDIO ANUAL DE CONCENTRACIÿN DBO5 (MG/L) DEL INFLUENTE) / 60012018: EDAR trata menos de 2.000 h-e00199506012530041.354812.01364EEEMATADEPERAES51100000200512310000000001012/31/05 00:00:0012/31/05 00:00:00http://aca-web.gencat.cat/aca/appmanager/aca/aca?_nfpb=true&_pageLabel=P1225554461208201540084&profileLocale=esES9081200001100C0100ES9081200001100E337818427.526493346277
88281GP¢¢#¹üø? odù£D@82811ESES9430740001020ES9430740001020ELLORENÇ DEL PENEDESISCON41.281041.5617ES5142415300011000000000PPPNRNRP000539916116510C1996-06-01T00:00:00.000http://aca.gencat.cat/web/.content/20_Aigua/02_infraestructures/05_estacions_depuradores_daigues_residuals/Fitxes_EDAR/dldp_edar_llorencdelpenedes.pdfES0001000(PROMEDIO ANUAL CAUDAL TRATADO(M3/D)* PROMEDIO ANUAL DE CONCENTRACIÿN DBO5 (MG/L) DEL INFLUENTE) / 60012018: EDAR trata menos de 2.000 h-e00199606012415041.170311.33024EEELLORENC DEL PENEDESES51400000200512310000000001012/31/05 00:00:0012/31/05 00:00:00http://aca-web.gencat.cat/aca/appmanager/aca/aca?_nfpb=true&_pageLabel=P1225554461208201540084&profileLocale=esES9430740001020C0100ES9430740001020E337812622.941452643711
98294GP¢ÙžY ù?ÀJ°8œ¥D@82941ESES9431370002010ES9431370002010ESANT JAUME DELS DOMENYS (CORNUDELLA)ISCON41.293831.57033ES5141918466611000000000PPPNRNRP000428431132069877C1983-06-01T00:00:00.000http://aca.gencat.cat/web/.content/20_Aigua/02_infraestructures/05_estacions_depuradores_daigues_residuals/Fitxes_EDAR/dsjdc_edar_santjaumedelsdomenys_cornudella.pdfES0001000(PROMEDIO ANUAL CAUDAL TRATADO(M3/D)* PROMEDIO ANUAL DE CONCENTRACIÿN DBO5 (MG/L) DEL INFLUENTE) / 60012018: EDAR trata menos de 2.000 h-e00198306011918041.175821.33323EEESANT JAUME DELS DOMENYS (CORNUDELLA)ES51400000200512310000000001012/31/05 00:00:0012/31/05 00:00:00http://aca-web.gencat.cat/aca/appmanager/aca/aca?_nfpb=true&_pageLabel=P1225554461208201540084&profileLocale=esES9431370002010C0100ES9431370002010E337813923.775474048747
108317GP¢°`<ƒ¶8@PùIµON@83171FI2020FIYKR12_T1265FIJVP_O000000000036TP (36) of Helsingin kt.ISCON60.1508724.71294FI1B137200033600011111000000NPPPPPNR00042790984Mhttp://paikkatiedot.fi/so/1002031/pf/ProductionFacility/0000000135.ProductionFacilityFI011000Population register data for 2020 + industrial wastewater estimate + estimated non-resident population00012300160.13645824.223573EESiuntion as.seutuFI1B10200512310000000B1012/31/98 00:00:0012/31/98 00:00:0012/31/98 00:00:00FIYKR12_T1265E100FIJVP_O000000000036336511127.136614405963