Table - DWD_WSZ (11_WaterSupplyZone)/WISE

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en"> <head> <meta content="text/html; charset=UTF-8" http-equiv="Content-Type"/> <link rel="stylesheet" type="text/css" href="https://www.eionet.europa.eu/styles/eionet2007/print.css" media="print" /> <link rel="stylesheet" type="text/css" href="https://www.eionet.europa.eu/styles/eionet2007/handheld.css" media="handheld" /> <link rel="stylesheet" type="text/css" href="https://www.eionet.europa.eu/styles/eionet2007/screen.css" media="screen" /> <link rel="stylesheet" type="text/css" href="/css/eionet2007.css" media="screen"/> <link rel="stylesheet" type="text/css" href="/css/print.css" media="print" /> <link rel="stylesheet" type="text/css" href="/css/smoothness/jquery-ui-1.8.16.custom.css" /> <link rel="shortcut icon" href="/favicon.ico" type="image/x-icon"/> <script type="text/javascript" src="/pageops.js"></script> <script type="text/javascript" src="/mark_special_links.js"></script> <script type="text/javascript" src="/scripts/jquery-1.6.2.min.js"></script> <script type="text/javascript" src="/scripts/jquery-ui-1.8.16.custom.min.js"></script> <script type="text/javascript" src="/script.js"></script> <script type="text/javascript" src="/helpPopup.js"></script> <title>Table - DWD_WSZ (11_WaterSupplyZone)/WISE_DWD</title> <script type="text/javascript" src="/modal_dialog.js"></script> <script type="text/javascript"> // <![CDATA[ function submitForm(mode){ if (mode == "delete"){ var a = confirm("Please be aware that you are about to remove a table from a dataset definition " + "in Released status. Unless you change the dataset definition's status back to something lower, " + "this removal will become instantly visible for the public visitors! " + "Click OK, if you want to continue. Otherwise click Cancel."); if (a==false) return; } if (mode != "delete"){ if (!checkObligations()){ alert("You have not specified one of the mandatory fields!"); return; } if (hasWhiteSpace("idfier")){ alert("Identifier cannot contain any white space!"); return; } if (!validForXMLTag(document.forms["form1"].elements["idfier"].value)){ alert("Identifier not valid for usage as an XML tag! " + "In the first character only underscore or latin characters are allowed! " + "In the rest of characters only underscore or hyphen or dot or 0-9 or latin characters are allowed!"); return; } } //slctAllValues(); if (mode=="editclose"){ mode = "edit"; document.forms["form1"].elements["saveclose"].value = "true"; } document.forms["form1"].elements["mode"].value = mode; document.forms["form1"].submit(); } function delDialogReturn(){ var v = dialogWin.returnValue; if (v==null || v=="" || v=="cancel") return; document.forms["form1"].elements["upd_version"].value = v; deleteReady(); } function deleteReady(){ document.forms["form1"].elements["mode"].value = "delete"; document.forms["form1"].submit(); } function isIdentifierFilled(){ var idf = document.forms["form1"].idfier; if (idf!=null && idf.value.length == 0) return false; return true; } function checkObligations(){ var o = document.forms["form1"].short_name; if (o!=null && o.value.length == 0) return false; o = document.forms["form1"].idfier; if (o!=null && o.value.length == 0) return false; if ($("#form1 .vocabularyAttributeMandatoryValidationError").length) { return false; } var elems = document.forms["form1"].elements; for (var i=0; elems!=null && i<elems.length; i++){ var elem = elems[i]; var elemName = elem.name; var elemValue = elem.value; if (startsWith(elemName, "attr_")){ var o = document.forms["form1"].elements[i+1]; if (o == null) return false; if (!startsWith(o.name, "oblig_")) continue; if (o.value == "M" && (elemValue==null || elemValue.length==0)){ return false; } } } return true; } function hasWhiteSpace(input_name){ var elems = document.forms["form1"].elements; if (elems == null) return false; for (var i=0; i<elems.length; i++){ var elem = elems[i]; if (elem.name == input_name){ var val = elem.value; if (val.indexOf(" ") != -1) return true; } } return false; } function goTo(mode, id){ document.location.assign("/tables/" + id + "/" + mode + "/?&ds_id=3156&ds_name=WISE_DWD"); } function openElements(uri){ //uri = uri + "&open=true"; wElems = window.open(uri,"TableElements","height=800,width=1200,status=yes,toolbar=no,scrollbars=yes,resizable=no,menubar=no,location=yes"); if (window.focus) {wElems.focus()} } function slctAllValues(){ var elems = document.forms["form1"].elements; if (elems == null) return true; for (var j=0; j<elems.length; j++){ var elem = elems[j]; var elemName = elem.name; if (startsWith(elemName, "attr_mult_")){ var slct = document.forms["form1"].elements[elemName]; if (slct.options && slct.length){ if (slct.length==1 && slct.options[0].value=="" && slct.options[0].text==""){ slct.remove(0); slct.length = 0; } for (var i=0; i<slct.length; i++){ slct.options[i].selected = "true"; } } } } } function startsWith(str, pattern){ var i = str.indexOf(pattern,0); if (i!=-1 && i==0) return true; else return false; } function copyTbl(context){ if (!isIdentifierFilled()){ alert("You have not specified the table's identifier."); return; } if (hasWhiteSpace("idfier")){ alert("Identifier cannot contain any white space!"); return; } if (!validForXMLTag(document.forms["form1"].elements["idfier"].value)){ alert("Identifier not valid for usage as an XML tag! " + "In the first character only underscore or latin characters are allowed! " + "In the rest of characters only underscore or hyphen or dot or 0-9 or latin characters are allowed!"); return; } var url='/search_table.jsp?ctx=popup'; wAdd = window.open(context+url,"Search","height=800,width=1200,status=yes,toolbar=no,scrollbars=yes,resizable=yes,menubar=no,location=yes"); if (window.focus){wAdd.focus();} } function pickTable(id, name){ document.forms["form1"].elements["copy_tbl_id"].value=id; document.forms["form1"].elements["mode"].value="copy"; document.forms["form1"].submit(); return true; } function validForXMLTag(str){ // if empty string not allowed for XML tag if (str==null || str.length==0){ return false; } // check the first character (only underscore or A-Z or a-z allowed) var ch = str.charCodeAt(0); if (!(ch==95 || (ch>=65 && ch<=90) || (ch>=97 && ch<=122))){ return false; } // check the rets of characters ((only underscore or hyphen or dot or 0-9 or A-Z or a-z allowed)) if (str.length==1) return true; for (var i=1; i<str.length; i++){ ch = str.charCodeAt(i); if (!(ch==95 || ch==45 || ch==46 || (ch>=48 && ch<=57) || (ch>=65 && ch<=90) || (ch>=97 && ch<=122))){ return false; } } return true; } // ]]> </script> </head> <body> <div id="container"> <div id="toolribbon"> <div id="lefttools"> <a id="eealink" href="https://www.eea.europa.eu/">EEA</a> <a id="ewlink" href="https://ew.eea.europa.eu/">EnviroWindows</a> </div> <div id="righttools"> <a id="loginlink" href="https://sso.eionet.europa.eu/login?service=http%3A%2F%2Fdd.eionet.europa.eu%2Flogin" title="Login">Login</a> <a id="printlink" title="Print this page" href="javascript:this.print();"><span>Print</span></a> <a id="fullscreenlink" href="javascript:toggleFullScreenMode()" title="Switch to/from full screen mode"><span>Switch to/from full screen mode</span></a> <a id="eionetlink" title="Go to Eionet portal" href="https://www.eionet.europa.eu/"><span>Eionet portal</span></a> </div> </div>  <div id="pagehead"> <a href="/"><img src="/images/eea-print-logo.gif" alt="Logo" id="logo" /></a> <div id="networktitle">Eionet</div> <div id="sitetitle">Data Dictionary</div> <div id="sitetagline">This service is part of Reportnet</div> </div>  <div id="menuribbon"> </div> <div class="breadcrumbtrail"> <div class="breadcrumbhead">You are here:</div> <div class="breadcrumbitem eionetaccronym"><a href="https://www.eionet.europa.eu">Eionet</a></div> <div class="breadcrumbitem"><a href="/">Data Dictionary</a></div> <div class="breadcrumbitemlast">Dataset table</div> <div class="breadcrumbtail"> </div> </div> <div id="leftcolumn" class="localnav"> <ul> <li ><a href="/documentation">Help and documentation</a></li> <li ><a href="/datasets.jsp">Datasets</a></li> <li class="current"><a href="/searchtables">Tables</a></li> <li ><a href="/searchelements">Data elements</a></li> <li ><a href="/schemasets/browse/">Schemas</a></li> <li ><a href="/vocabularies">Vocabularies</a></li> <li ><a href="/services/list">Services</a></li> <li ><a href="/namespaces">Namespaces</a></li> </ul> </div> <div id="workarea"> <h1>View table </h1>  <div id="quickbar"><ul> <li class="quickLink"><a href="#elements">Elements</a></li> </ul></div> <form id="form1" method="post" action="/tables" style="clear:both">     <script type="text/javascript"> $(function() { applyExportOptionsToggle(); }); </script> <div id="createbox"> <ul> <li> <a rel="nofollow" href="/v2/dataset/3156/schema-tbl-9133.xsd" class="xsd"> Create an XML Schema for this table </a> </li> <li> <a rel="nofollow" href="/GetXls?obj_type=tbl&obj_id=9133" class="excel"> Create an MS Excel template for this table </a> <a class="helpButton" href="/help.jsp?screen=table&area=excel"></a> </li> <li> <a rel="nofollow" href="/GetOds?type=tbl&id=9133" class="open-doc"> Create an OpenDocument spreadsheet template for this table </a> <a class="helpButton" href="/help.jsp?screen=table&area=ods"></a> </li> <li> <a rel="nofollow" href="/codelists/tables/9133/csv" class="csv">Get the comma-separated codelists of this table</a> </li> <li> <a rel="nofollow" href="/codelists/tables/9133/xml" class="csv">Get the codelists of this table in XML format</a> </li> </ul> </div>  <div class="system-msg"> <strong> There are 0 QA scripts and 0 conversion scripts registered for this table. </strong> </div>  <div id="outerframe">  <table class="datatable results" width="100%">   <tr class="odd"> <th scope="row" class="scope-row simple_attr_title"> Identifier <a class="helpButton" href="/help.jsp?screen=dataset&area=identifier"></a> </th> <td class="simple_attr_value"> <b>DWD_WSZ</b> <input type="hidden" name="idfier" value="DWD_WSZ"/> </td> </tr>  <tr id="short_name_row" class="even"> <th scope="row" class="scope-row short_name"> Short name <a class="helpButton" href="/help.jsp?screen=dataset&area=short_name"></a> </th> <td class="short_name_value"> DWD_WSZ (11_WaterSupplyZone) <input type="hidden" name="short_name" value="DWD_WSZ (11_WaterSupplyZone)"/> </td> </tr>  <tr class="odd"> <th scope="row" class="scope-row simple_attr_title"> Dataset <a class="helpButton" href="/help.jsp?screen=table&area=dataset"></a> </th> <td class="simple_attr_value"> <a href="/datasets/3156"> <b>WISE_DWD</b> </a> </td> </tr>  <tr class="even"> <th scope="row" class="scope-row simple_attr_title"> Reference URL <a class="helpButton" href="/help.jsp?screen=dataset&area=refurl"></a> </th> <td class="simple_attr_value"> <small><a href="http://dd.eionet.europa.eu/datasets/latest/WISE_DWD/tables/DWD_WSZ">http://dd.eionet.europa.eu/datasets/latest/WISE_DWD/tables/DWD_WSZ</a></small> </td> </tr>  <tr class="odd"> <th scope="row" class="scope-row simple_attr_title"> Name <a class="helpButton" href="/help.jsp?attrid=1&attrtype=SIMPLE"></a> </th>  <td class="simple_attr_value"> 11_WaterSupplyZone <input type="hidden" name="oblig_1" value="M"/> </td>  </tr> <tr class="even"> <th scope="row" class="scope-row simple_attr_title"> Short Description <a class="helpButton" href="/help.jsp?attrid=15&attrtype=SIMPLE"></a> </th>  <td class="simple_attr_value"> General information on Water Supply Zones drinking water supply arrangements<br/>(With the exception of question 1.2 only information on individual supplies of water exceeding 1000 m3 a day as an average or serving more than 5000 persons should be reported)<br/>See "Guidance document on reporting under the Drinking Water Directive 98/83/EC" Table 1.4. <input type="hidden" name="oblig_15" value="O"/> </td>  </tr> <tr class="odd"> <th scope="row" class="scope-row simple_attr_title"> Definition <a class="helpButton" href="/help.jsp?attrid=4&attrtype=SIMPLE"></a> </th>  <td class="simple_attr_value"> General information on individual water supply zones witch exceed 1000 m3 a day as average or serving more than 5000 persons <input type="hidden" name="oblig_4" value="O"/> </td>  </tr> <tr class="even"> <th scope="row" class="scope-row simple_attr_title"> Methodology for obtaining data <a class="helpButton" href="/help.jsp?attrid=17&attrtype=SIMPLE"></a> </th>  <td class="simple_attr_value"> The data requested for DWD should be derived from existing Water Supply Zones within each Member State. One table should be used for all Water Supply Zones. The combination of the elements CountryCode and WaterSupplyZone ID must create a unique record in the table. No duplicate records should exist with this table.<br/><br/>This data should be reported to the European Commision every three years. <input type="hidden" name="oblig_17" value="O"/> </td>  </tr>  </table>   <h2 id="elements">Elements</h2> <table class="datatable results"> <col style="width:50%"/> <col style="width:19%"/> <col style="width:31%"/> <thead> <tr> <th>Element name</th> <th>Datatype</th> <th>Element type</th> </tr> </thead> <tr>  <td> <span style="font:bold;font-size:1.2em">*</span> <a href="/dataelements/67135" title="Abbreviation of EEA Member or Collaborating Country, as defined in the codelist."> Country Code (CountryCode) </a> <sup style="color:#858585;font-weight:bold;">C</sup> </td>  <td> string </td>  <td> <a href="/fixedvalues/elem/67135"> Fixed values </a> </td> </tr> <tr>  <td> <span style="font:bold;font-size:1.2em">*</span> <a href="/dataelements/71988" title="Primary Key / Unique identifier (ID) of the Water Supply Zone"> Water Supply Zone ID (WSZ_ID) </a> <sup style="color:#858585;font-weight:bold;">C</sup>  <span style="font: bold italic" title="Element participates in primary key">(PK)</span> </td>  <td> string </td>  <td> Quantitative </td> </tr> <tr>  <td> <span style="font:bold;font-size:1.2em">*</span> <a href="/dataelements/75598" title="Name of Water supply zone"> WSZ_Name (DWD_WSZ_Name) </a> </td>  <td> string </td>  <td> Quantitative </td> </tr> <tr>  <td> <a href="/dataelements/75556" title=""> WSZ_NUTScoordinates (WSZ_NUTScoordinates) </a> </td>  <td> string </td>  <td> Quantitative </td> </tr> <tr>  <td> <span style="font:bold;font-size:1.2em">*</span> <a href="/dataelements/75611" title="Population of the water supply zone"> Residents (WSZ_Residents) </a> </td>  <td> integer </td>  <td> Quantitative </td> </tr> <tr>  <td> <span style="font:bold;font-size:1.2em">*</span> <a href="/dataelements/75542" title="Volume of water supplied in m3/day"> Volume (WSZ_Volume) </a> </td>  <td> integer </td>  <td> Quantitative </td> </tr> <tr>  <td> <span style="font:bold;font-size:1.2em">*</span> <a href="/dataelements/72846" title="Year of reporting"> Year (DWD_Year) </a> <sup style="color:#858585;font-weight:bold;">C</sup>  <span style="font: bold italic" title="Element participates in primary key">(PK)</span> </td>  <td> integer </td>  <td> Quantitative </td> </tr> </table> <div class="barfont"> (an asterisk in front of element name indicates that the element is mandatory in this table) </div> <div class="barfont"> (the <sup style="color:#858585;">C</sup> sign marks a common element) </div>  </div> <div style="display:none"> <input type="hidden" name="ds_name" value="WISE_DWD"/> <input type="hidden" name="table_id" value="9133"/> <input type="hidden" name="del_id" value="9133"/> <input type="hidden" name="corresp_ns" value="581"/> <input type="hidden" name="parent_ns" value="579"/> <input type="hidden" name="submitter_url" value="dstable.jsp"/> <input type="hidden" name="mode" value="view"/> <input type="hidden" name="ds_id" value="3156"/> <input type="hidden" name="copy_tbl_id" value=""/> <input type="hidden" name="changed" value="0"/> <input type="hidden" name="saveclose" value="false"/> </div> </form> </div>  </div>  <div id="pagefoot"> <p> <a href="/documentation/doc1">Disclaimer</a> | Copyright: <a rel="license" href="https://creativecommons.org/licenses/by/2.5/dk/deed.en_GB" title="Creative Commons Attribution License"> <img alt="Creative Commons Attribution License" src="https://i.creativecommons.org/l/by/2.5/dk/80x15.png" /></a> | <a href="mailto:ServiceDesk@eea.europa.eu?subject=Feedback from the Data Dictionary website">Feedback</a> </p> <p> <a href="http://www.eea.europa.eu">European Environment Agency</a> <br/>Kgs. Nytorv 6, DK-1050 Copenhagen K, Denmark </p> </div> </body> </html>

CINXE.COM

Table - DWD_WSZ (11_WaterSupplyZone)/WISE_DWD