View table

• Create an MS Excel template for this table
• Create an OpenDocument spreadsheet template for this table

Identifier	DischargePoints
Short name	DischargePoints
Dataset	UWWTDArt15
Reference URL	http://dd-test.01dev.eea.europa.eu/datasets/latest/UWWTDArt15/tables/DischargePoints
Name	DischargePoints
Short Description	Information on individual points of discharge from treatment plants or collecting systems.
Definition	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.
Methodology for obtaining data	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.

Elements

Element name	Datatype	Element type
* dcpState (dcpState)	integer	Fixed values
* repCode (repCode) C	string	Quantitative
* uwwCode (uwwCode)	string	Quantitative
* dcpCode (dcpCode)  (PK)	string	Quantitative
dcpName (dcpName)	string	Quantitative
dcpNUTS (dcpNUTS)	string	Fixed values
dcpLatitude (dcpLatitude)	decimal	Quantitative
dcpLongitude (dcpLongitude)	decimal	Quantitative
* dcpWaterBodyType (dcpWaterBodyType)	string	Fixed values
dcpIrrigation (dcpIrrigation)	string	Fixed values
dcpTypeOfReceivingArea (dcpTypeOfReceivingArea)	string	Fixed values
rcaCode (rcaCode)	string	Quantitative
dcpSurfaceWaters (dcpSurfaceWaters)	boolean	Fixed values
dcpWaterbodyID (dcpWaterbodyID)	string	Quantitative
dcpNotAffect (dcpNotAffect)	boolean	Fixed values
dcpMSProvide (dcpMSProvide)	boolean	Fixed values
dcpCOMAccept (dcpCOMAccept)	boolean	Fixed values
dcpGroundWater (dcpGroundWater)	string	Quantitative
dcpReceivingWater (dcpReceivingWater)	string	Quantitative
dcpWFDSubUnit (dcpWFDSubUnit)	string	Quantitative
dcpWFDRBD (dcpWFDRBD)	string	Quantitative
dcpRemarks (dcpRemarks)	string	Quantitative
dcpWaterBodyReferenceDate (dcpWaterBodyReferenceDate)	date	Quantitative
dcpGroundWaterReferenceDate (dcpGroundWaterReferenceDate)	date	Quantitative
dcpReceivingWaterReferenceDate (dcpReceivingWaterReferenceDate)	date	Quantitative
dcpWFDSubUnitReferenceDate (dcpWFDSubUnitReferenceDate)	date	Quantitative
dcpWFDRBDReferenceDate (dcpWFDRBDReferenceDate)	date	Quantitative
dcpBeginLife (dcpBeginLife)	date	Quantitative
dcpEndLife (dcpEndLife)	date	Quantitative