View table

There are 0 QA scripts and 4 conversion scripts registered for this table.
Link to the schema page on XMLCONV
Identifier DWD_MS
Short name DWD_MS (02_MemberState)
Dataset WISE_DWD
Reference URL
Name 02_MemberState
Short Description General information on Member States drinking water supply arrangements.
See "Guidance document on reporting under the Drinking Water Directive 98/83/EC" Table 1.
Definition General information on member states drinking water supply arrangements
Methodology for obtaining data The data requested for DWD should be derived from the Memberstate. One table should be used for the memberstate. The element MemberState must create a unique record in the table. No duplicate records should exist with this table.

This data should be reported to the European Commision every three years.


Element name Datatype Element type
* Country Code (CountryCode) C  (PK) string Fixed values
* Year (DWD_Year) C  (PK) integer Quantitative
* TotalPopulation (MS_TotalPopulation) double Quantitative
* NumberWSZ (MS_NumberWSZ) integer Quantitative
* TotaResidentlPopulation (MS_TotaResidentlPopulation) double Quantitative
* TotalVolume (MS_TotalVolume) integer Quantitative
* Groundwater (MS_Groundwater) decimal Quantitative
* Surfacewater (MS_Surfacewater) decimal Quantitative
* Inlandwater (MS_Inlandwater) decimal Quantitative
* Coastalwater (MS_Coastalwater) decimal Quantitative
* Bankfiltrationwater (MS_Bankfiltrationwater) decimal Quantitative
* Rainwater (MS_Rainwater) decimal Quantitative
* Otherwater (MS_Otherwater) decimal Quantitative
* ArtificialGroundwaterRecharge (MS_ArtificialGrondwaterRecharge) decimal Quantitative
* WebsiteAddress (MS_WebsiteAddress) string Quantitative
* ResponsibleAuthority (MS_ResponsibleAuthority) string Quantitative
* Name (MS_Name) string Quantitative
* Address (MS_Address) string Quantitative
* City (MS_City) string Quantitative
* Telephone (MS_Telephone) string Quantitative
* Fax (MS_Fax) string Quantitative
* Email (MS_Email) string Quantitative
* NationalSummaryComment (MS_NationalSummaryComment) string Quantitative
(an asterisk in front of element name indicates that the element is mandatory in this table)
(the C sign marks a common element)