query

UWWTD query


      SELECT *
      FROM UWWTD_TreatmentPlants
      WHERE uwwBeginLife LIKE '19%'
      LIMIT 10;

10 results

fid	geom	OBJECTID	uwwState	repCode	uwwCode	uwwName	uwwCollectingSystem	uwwLatitude	uwwLongitude	uwwNUTS	uwwLoadEnteringUWWTP	uwwCapacity	uwwPrimaryTreatment	uwwSecondaryTreatment	uwwOtherTreatment	uwwNRemoval	uwwPRemoval	uwwUV	uwwChlorination	uwwMicroFiltration	uwwBOD5Perf	uwwCODPerf	uwwTSSPerf	uwwNTotPerf	uwwPTotPerf	uwwOtherPerf	uwwBadDesign	uwwInformation	uwwBODIncomingCalculated	uwwBODDischargeCalculated	uwwCODDischargeCalculated	uwwNDischargeCalculated	uwwPDischargeCalculated	uwwWasteWaterTreated	uwwMethodWasteWaterTreated	uwwBeginLife	uwwHyperlink	uwwInspireIDFacility	uwwRemarks	rptMStateKey
1043	GP��mj;@0��AE@	1043	1	BG2022	BGWT07079_00_01	UWWTP Burgas	ISCON	42.5147	27.41574	BG341	142980	397745	1	1	1	1	1	1	0	0	P	P	P	P	P	NR	0			2	6	0	0	13425031	M	1987-12-31T00:00:00.000		BG.CAED/002000010.FACILITY		BG
1065	GP��+��\;@�&p�E@	1065	1	BG2022	BGWT24565_00_01	UWWTP Dalgopol	ISCON	43.05811	27.36203	BG331	3078	5500	1	1	1	0	0	0	1	0	P	P	P	NR	NR	NR	0							220830	M	1974-01-01T00:00:00.000			The change in the capacity derived from Regional Feasibility Studies	BG
1080	GP��Έ�޸6@x��&E@	1080	1	BG2022	BGWT41112_00_01	UWWTP Kyustendil	ISCON	42.30173	22.72215	BG415	27386	90000	1	1	1	1	1	0	1	0	P	P	P	P	P	NR	0							1587885	C	1976-01-01T00:00:00.000				BG
1083	GP��:@�6q�E@	1083	1	BG2022	BGWT44166_00_01	UWWTP Loznitsa	ISCON	43.36283	26.60382	BG324	3398	4300	1	1	1	1	1	1	0	0	P	P	P	NR	NR	NR	0		257					259690	E	1976-12-31T00:00:00.000			Reconstruction of UWWTP in 2013	BG
1112	GP��#�6@`MuDE@	1112	1	BG2022	BGWT61577_00_01	UWWTP Radomir	ISCON	42.53221	22.93414	BG414	5443	14513	1	1	1	0	0	0	1	0	P	P	P	P	P	NR	0	the monitoring data for P show "Pass" , nevertheless there is no P removal available at the WWTP						549994	C	1987-01-01T00:00:00.000	http://2020.eufunds.bg/bg/0/0/Project/BasicData?contractId=S5RKygqYdCQ%3D&isHistoric=False			BG
1113	GP�p�u:@X� c�E@	1113	1	BG2022	BGWT61710_00_01	UWWTP Razgrad	ISCON	43.53941	26.49789	BG324	68162	78200	1	1	0	0	0	0	1	0	P	P	P	P	P	NR	0	the monitoring data for P and N show "Pass", nevetheless there is no tertiary treatment technology available at the WWTP	562						E	1974-12-31T00:00:00.000				BG
1127	GP��G�8@�K��D@	1127	1	BG2022	BGWT67653_01_01	UWWTP k.k.Pamporovo	ISCON	41.66143	24.69641	BG424	280	6000	1	1	0	0	0	0	1	0	P	P	P	NR	NR	NR									M	1986-01-01T00:00:00.000				BG
1133	GP��_�7@��E@	1133	1	BG2022	BGWT68789_00_01	UWWTP Dupnitsa	ISCON	42.23398	23.08045	BG415	21461	55000	1	1	0	0	0	0	1	0	P	P	P	P	P	NR	0	the monitoring data for P and N show "Pass", nevetheless there is no tertiary treatment technology available at the WWTP						5915566	C	1982-01-01T00:00:00.000				BG
1135	GP��ho��6@��n�LE@	1135	1	BG2022	BGWT72223_00_01	UWWTP Batanovtsi-Pernik	ISCON	42.60124	22.9551	BG414	12248	160000	1	1	1	0	0	0	1	0	P	P	P	P	P	NR	0	the monitoring data for P and N show "Pass", nevetheless there is no tertiary treatment technology available at the WWTP						3277632	C	1983-01-01T00:00:00.000				BG
6788	GP�`��\|�o ��;�[դE@	6788	1	ES	ES12150090001010E	BETANZOS	ISCON	43.287761198	-8.217807666	ES111	22519	25000	1	1	1	1	0	1	0	1	P	P	NR	NR	NR	NR	0							1496450	M	1990-12-31T00:00:00.000	http://sig.mapama.es/geoportal/visor.html			ES