
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"
xmlns:office='urn:oasis:names:tc:opendocument:xmlns:office:1.0'
 xmlns:table='urn:oasis:names:tc:opendocument:xmlns:table:1.0'
 xmlns:text='urn:oasis:names:tc:opendocument:xmlns:text:1.0'
    xmlns:dd802="https://dd.eionet.europa.eu/namespace.jsp?ns_id=802" xmlns:dd820="https://dd.eionet.europa.eu/namespace.jsp?ns_id=820">
    <xsl:template match="dd802:Agglomerations"> <office:document-content xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0" xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0" xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0" xmlns:draw="urn:oasis:names:tc:opendocument:xmlns:drawing:1.0" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0" xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0" xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0" xmlns:chart="urn:oasis:names:tc:opendocument:xmlns:chart:1.0" xmlns:dr3d="urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0" xmlns:math="http://www.w3.org/1998/Math/MathML" xmlns:form="urn:oasis:names:tc:opendocument:xmlns:form:1.0" xmlns:script="urn:oasis:names:tc:opendocument:xmlns:script:1.0" xmlns:ooo="http://openoffice.org/2004/office" xmlns:ooow="http://openoffice.org/2004/writer" xmlns:oooc="http://openoffice.org/2004/calc" xmlns:dom="http://www.w3.org/2001/xml-events" xmlns:xforms="http://www.w3.org/2002/xforms" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" office:version="1.0">	<office:automatic-styles>		<style:style style:name='cell1' style:family='table-cell' >			<style:text-properties fo:text-align='left' fo:font-size='10pt'/>		</style:style>		<style:style style:name='cell2' style:family='table-cell' >			<style:text-properties fo:text-align='center' fo:font-size='12pt' fo:font-style='italic'/>		</style:style>		<style:style style:name='Heading1' style:family='table-cell' >			<style:text-properties fo:text-align='left' fo:font-size='10pt' fo:font-style='italic' style:text-align-source='fix' fo:font-weight='bold'/>		</style:style>		<style:style style:name='Heading2' style:family='table-cell' >			<style:text-properties fo:text-align='center' fo:font-size='10pt' fo:font-weight='bold' />		</style:style>	</office:automatic-styles>	<office:body>	<office:spreadsheet>		<table:table>			<xsl:attribute name="table:name">Agglomerations</xsl:attribute>		<xsl:attribute name="schema-url">https://dd.eionet.europa.eu/GetSchema?id=TBL11935</xsl:attribute>		<xsl:attribute name="table-schema-urls">https://dd.eionet.europa.eu/GetSchema?id=TBL11935</xsl:attribute>			<table:table-columns>				<table:table-column table:default-cell-value-type='number' table:default-cell-style-name='cell1' >					<xsl:attribute name="table:number-columns-repeated"><xsl:value-of select="count($elementsMetadata/element)"/></xsl:attribute>				</table:table-column>			</table:table-columns>			<!-- create header rows -->			<table:table-rows>				<xsl:apply-templates select="dd802:Row"/>			</table:table-rows>		</table:table>	</office:spreadsheet>	</office:body></office:document-content></xsl:template><xsl:template match="dd802:Row">		<xsl:if test="position()=1">			<xsl:call-template name="header"/>		</xsl:if>	<table:table-row><xsl:variable xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="row" select="."></xsl:variable>
<xsl:for-each xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="$elementsMetadata/element">
   <xsl:variable name="elemIdentifier">
      <xsl:value-of select="identifier"></xsl:value-of>
   </xsl:variable>
   <xsl:variable name="multiValueSeparator">
      <xsl:call-template name="getSeparator">
         <xsl:with-param name="element" select="$elemIdentifier"></xsl:with-param>
      </xsl:call-template>
   </xsl:variable>
   <table:table-cell xmlns:table="http://openoffice.org/2000/table">
      <text:p xmlns:text="http://openoffice.org/2000/text">
         <xsl:choose>
            <xsl:when test="count($row/*[local-name()= $elemIdentifier])=0 or string-join($row/*[local-name()= $elemIdentifier ],'')=''"></xsl:when>
            <xsl:otherwise>
               <xsl:value-of select="string-join($row/*[local-name()= $elemIdentifier ],$multiValueSeparator)"></xsl:value-of>
            </xsl:otherwise>
         </xsl:choose>
      </text:p>
   </table:table-cell>
</xsl:for-each>	</table:table-row></xsl:template><!--   template for building table cells with values --><!--  a named template, which creates the table header row --><xsl:template name="header">	<table:table-header-rows>		<table:table-row  table:default-cell-value-type='string' table:default-cell-style-name='Heading1' >
<xsl:for-each xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="$elementsMetadata/element">				<table:table-cell><text:p><xsl:value-of select="identifier" /></text:p> 
				</table:table-cell></xsl:for-each>		</table:table-row>	</table:table-header-rows></xsl:template>
<xsl:template xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="getSeparator">
   <xsl:param name="element" select="''"></xsl:param>
   <xsl:value-of select="','"></xsl:value-of>
</xsl:template>
<xsl:variable xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="elementsMetadata">
   <element>
      <elementid>103138</elementid>
      <identifier>aggState</identifier>
      <parentNS>820</parentNS>
      <type></type>
      <length></length>
      <precision></precision>
   </element>
   <element>
      <elementid>101864</elementid>
      <identifier>repCode</identifier>
      <parentNS>null</parentNS>
      <type>string</type>
      <length>16</length>
      <precision></precision>
   </element>
   <element>
      <elementid>103146</elementid>
      <identifier>aggCode</identifier>
      <parentNS>820</parentNS>
      <type>string</type>
      <length>32</length>
      <precision></precision>
   </element>
   <element>
      <elementid>94180</elementid>
      <identifier>aggName</identifier>
      <parentNS>null</parentNS>
      <type>string</type>
      <length>255</length>
      <precision></precision>
   </element>
   <element>
      <elementid>103135</elementid>
      <identifier>aggNUTS</identifier>
      <parentNS>820</parentNS>
      <type></type>
      <length></length>
      <precision></precision>
   </element>
   <element>
      <elementid>103162</elementid>
      <identifier>aggLatitude</identifier>
      <parentNS>820</parentNS>
      <type>decimal</type>
      <length>18</length>
      <precision></precision>
   </element>
   <element>
      <elementid>103113</elementid>
      <identifier>aggLongitude</identifier>
      <parentNS>820</parentNS>
      <type>decimal</type>
      <length>18</length>
      <precision></precision>
   </element>
   <element>
      <elementid>103260</elementid>
      <identifier>aggGenerated</identifier>
      <parentNS>820</parentNS>
      <type>integer</type>
      <length>9</length>
      <precision></precision>
   </element>
   <element>
      <elementid>103244</elementid>
      <identifier>bigCityID</identifier>
      <parentNS>820</parentNS>
      <type></type>
      <length></length>
      <precision></precision>
   </element>
   <element>
      <elementid>103053</elementid>
      <identifier>aggCalculation</identifier>
      <parentNS>820</parentNS>
      <type>string</type>
      <length>4096</length>
      <precision></precision>
   </element>
   <element>
      <elementid>103100</elementid>
      <identifier>aggChanges</identifier>
      <parentNS>820</parentNS>
      <type></type>
      <length></length>
      <precision></precision>
   </element>
   <element>
      <elementid>103045</elementid>
      <identifier>aggChangesComment</identifier>
      <parentNS>820</parentNS>
      <type>string</type>
      <length>4096</length>
      <precision></precision>
   </element>
   <element>
      <elementid>103142</elementid>
      <identifier>aggPeriodOver</identifier>
      <parentNS>820</parentNS>
      <type></type>
      <length></length>
      <precision></precision>
   </element>
   <element>
      <elementid>103112</elementid>
      <identifier>aggDateArt3</identifier>
      <parentNS>820</parentNS>
      <type></type>
      <length></length>
      <precision></precision>
   </element>
   <element>
      <elementid>103137</elementid>
      <identifier>aggDateArt4</identifier>
      <parentNS>820</parentNS>
      <type></type>
      <length></length>
      <precision></precision>
   </element>
   <element>
      <elementid>103154</elementid>
      <identifier>aggDateArt5</identifier>
      <parentNS>820</parentNS>
      <type></type>
      <length></length>
      <precision></precision>
   </element>
   <element>
      <elementid>103166</elementid>
      <identifier>aggC1</identifier>
      <parentNS>820</parentNS>
      <type>decimal</type>
      <length>18</length>
      <precision></precision>
   </element>
   <element>
      <elementid>103065</elementid>
      <identifier>aggMethodC1</identifier>
      <parentNS>820</parentNS>
      <type></type>
      <length></length>
      <precision></precision>
   </element>
   <element>
      <elementid>103152</elementid>
      <identifier>aggC2</identifier>
      <parentNS>820</parentNS>
      <type>decimal</type>
      <length>18</length>
      <precision></precision>
   </element>
   <element>
      <elementid>103212</elementid>
      <identifier>aggMethodC2</identifier>
      <parentNS>820</parentNS>
      <type></type>
      <length></length>
      <precision></precision>
   </element>
   <element>
      <elementid>103181</elementid>
      <identifier>aggPercWithoutTreatment</identifier>
      <parentNS>820</parentNS>
      <type>decimal</type>
      <length>18</length>
      <precision></precision>
   </element>
   <element>
      <elementid>103190</elementid>
      <identifier>aggMethodWithoutTreatment</identifier>
      <parentNS>820</parentNS>
      <type></type>
      <length></length>
      <precision></precision>
   </element>
   <element>
      <elementid>103148</elementid>
      <identifier>aggPercPrimTreatment</identifier>
      <parentNS>820</parentNS>
      <type>decimal</type>
      <length>18</length>
      <precision></precision>
   </element>
   <element>
      <elementid>103186</elementid>
      <identifier>aggPercSecTreatment</identifier>
      <parentNS>820</parentNS>
      <type>decimal</type>
      <length>18</length>
      <precision></precision>
   </element>
   <element>
      <elementid>103136</elementid>
      <identifier>aggPercStringentTreatment</identifier>
      <parentNS>820</parentNS>
      <type>decimal</type>
      <length>18</length>
      <precision></precision>
   </element>
   <element>
      <elementid>103174</elementid>
      <identifier>aggHaveRegistrationSystem</identifier>
      <parentNS>820</parentNS>
      <type></type>
      <length></length>
      <precision></precision>
   </element>
   <element>
      <elementid>103232</elementid>
      <identifier>aggExistMaintenancePlan</identifier>
      <parentNS>820</parentNS>
      <type></type>
      <length></length>
      <precision></precision>
   </element>
   <element>
      <elementid>103264</elementid>
      <identifier>aggPressureTest</identifier>
      <parentNS>820</parentNS>
      <type></type>
      <length></length>
      <precision></precision>
   </element>
   <element>
      <elementid>103240</elementid>
      <identifier>aggVideoInspections</identifier>
      <parentNS>820</parentNS>
      <type></type>
      <length></length>
      <precision></precision>
   </element>
   <element>
      <elementid>103109</elementid>
      <identifier>aggOtherMeasures</identifier>
      <parentNS>820</parentNS>
      <type></type>
      <length></length>
      <precision></precision>
   </element>
   <element>
      <elementid>103041</elementid>
      <identifier>aggExplanationOther</identifier>
      <parentNS>820</parentNS>
      <type>string</type>
      <length>4096</length>
      <precision></precision>
   </element>
   <element>
      <elementid>103209</elementid>
      <identifier>aggSewageNetwork</identifier>
      <parentNS>820</parentNS>
      <type></type>
      <length></length>
      <precision></precision>
   </element>
   <element>
      <elementid>103130</elementid>
      <identifier>aggBestTechnicalKnowledge</identifier>
      <parentNS>820</parentNS>
      <type></type>
      <length></length>
      <precision></precision>
   </element>
   <element>
      <elementid>103119</elementid>
      <identifier>aggDilutionRates</identifier>
      <parentNS>820</parentNS>
      <type></type>
      <length></length>
      <precision></precision>
   </element>
   <element>
      <elementid>103216</elementid>
      <identifier>aggCapacity</identifier>
      <parentNS>820</parentNS>
      <type></type>
      <length></length>
      <precision></precision>
   </element>
   <element>
      <elementid>103203</elementid>
      <identifier>aggAccOverflows</identifier>
      <parentNS>820</parentNS>
      <type></type>
      <length></length>
      <precision></precision>
   </element>
   <element>
      <elementid>103156</elementid>
      <identifier>aggAccOverflowNumber</identifier>
      <parentNS>820</parentNS>
      <type>integer</type>
      <length>9</length>
      <precision></precision>
   </element>
   <element>
      <elementid>103242</elementid>
      <identifier>aggSewerOverflows_m3</identifier>
      <parentNS>820</parentNS>
      <type>integer</type>
      <length>9</length>
      <precision></precision>
   </element>
   <element>
      <elementid>103067</elementid>
      <identifier>aggSewerOverflows_pe</identifier>
      <parentNS>820</parentNS>
      <type>integer</type>
      <length>9</length>
      <precision></precision>
   </element>
   <element>
      <elementid>103086</elementid>
      <identifier>aggForecast</identifier>
      <parentNS>820</parentNS>
      <type></type>
      <length></length>
      <precision></precision>
   </element>
   <element>
      <elementid>103107</elementid>
      <identifier>aggBeginLife</identifier>
      <parentNS>820</parentNS>
      <type></type>
      <length></length>
      <precision></precision>
   </element>
   <element>
      <elementid>103079</elementid>
      <identifier>aggEndLife</identifier>
      <parentNS>820</parentNS>
      <type></type>
      <length></length>
      <precision></precision>
   </element>
   <element>
      <elementid>103194</elementid>
      <identifier>aggHyperlink</identifier>
      <parentNS>820</parentNS>
      <type>string</type>
      <length>255</length>
      <precision></precision>
   </element>
   <element>
      <elementid>103144</elementid>
      <identifier>aggRemarks</identifier>
      <parentNS>820</parentNS>
      <type>string</type>
      <length>4096</length>
      <precision></precision>
   </element>
</xsl:variable></xsl:stylesheet>
