
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="2.0"
    xmlns:dd11="https://dd.eionet.europa.eu/namespace.jsp?ns_id=11" xmlns:dd47="https://dd.eionet.europa.eu/namespace.jsp?ns_id=47">
    <xsl:output method="html"/>

    <xsl:template match="/">
<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>sites</title></head><body><h1>sites</h1><table border="1" style="border-collapse:collapse;">        <xsl:apply-templates select="dd11:sites/dd11:Row"/>
</table></body></html>    </xsl:template>

    <xsl:template match="dd11:sites/dd11:Row">
        <xsl:if test="position()=1">
            <xsl:call-template name="header"/>
        </xsl:if>
<tr><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>
   <td>
      <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>
   </td>
</xsl:for-each></tr></xsl:template>

<xsl:template name="header">
<tr>
<xsl:for-each xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="$elementsMetadata/element"><th bgcolor="#87cefa"><xsl:value-of select="identifier" /> 
</th> 
</xsl:for-each></tr></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>23438</elementid>
      <identifier>ALTITUDE_MAX</identifier>
      <parentNS>47</parentNS>
      <type>integer</type>
      <length>8</length>
      <precision></precision>
   </element>
   <element>
      <elementid>27730</elementid>
      <identifier>EIONET_CHNG_DATE</identifier>
      <parentNS>47</parentNS>
      <type></type>
      <length></length>
      <precision></precision>
   </element>
   <element>
      <elementid>17526</elementid>
      <identifier>LONSEC</identifier>
      <parentNS>47</parentNS>
      <type>integer</type>
      <length>3</length>
      <precision></precision>
   </element>
   <element>
      <elementid>29047</elementid>
      <identifier>SITE_CODE_NAT</identifier>
      <parentNS>47</parentNS>
      <type>string</type>
      <length>12</length>
      <precision></precision>
   </element>
   <element>
      <elementid>22793</elementid>
      <identifier>IUCNCAT</identifier>
      <parentNS>47</parentNS>
      <type></type>
      <length></length>
      <precision></precision>
   </element>
   <element>
      <elementid>27212</elementid>
      <identifier>To_be_deleted</identifier>
      <parentNS>47</parentNS>
      <type></type>
      <length></length>
      <precision></precision>
   </element>
   <element>
      <elementid>17076</elementid>
      <identifier>YEAR</identifier>
      <parentNS>47</parentNS>
      <type>string</type>
      <length>4</length>
      <precision></precision>
   </element>
   <element>
      <elementid>28966</elementid>
      <identifier>ISO3</identifier>
      <parentNS>47</parentNS>
      <type>string</type>
      <length>3</length>
      <precision></precision>
   </element>
   <element>
      <elementid>22403</elementid>
      <identifier>SITE_CODE</identifier>
      <parentNS>47</parentNS>
      <type>integer</type>
      <length>8</length>
      <precision></precision>
   </element>
   <element>
      <elementid>26577</elementid>
      <identifier>EIONET_INSTITUTE</identifier>
      <parentNS>47</parentNS>
      <type>string</type>
      <length>10</length>
      <precision></precision>
   </element>
   <element>
      <elementid>28810</elementid>
      <identifier>LAT</identifier>
      <parentNS>47</parentNS>
      <type>decimal</type>
      <length>30</length>
      <precision>15</precision>
   </element>
   <element>
      <elementid>21586</elementid>
      <identifier>DESIG_ABBR</identifier>
      <parentNS>47</parentNS>
      <type>string</type>
      <length>5</length>
      <precision></precision>
   </element>
   <element>
      <elementid>25686</elementid>
      <identifier>NOTES</identifier>
      <parentNS>47</parentNS>
      <type>string</type>
      <length>65535</length>
      <precision></precision>
   </element>
   <element>
      <elementid>28746</elementid>
      <identifier>NUTS</identifier>
      <parentNS>47</parentNS>
      <type>string</type>
      <length>5</length>
      <precision></precision>
   </element>
   <element>
      <elementid>20535</elementid>
      <identifier>LON</identifier>
      <parentNS>47</parentNS>
      <type>decimal</type>
      <length>30</length>
      <precision>15</precision>
   </element>
   <element>
      <elementid>24659</elementid>
      <identifier>PARENT_ISO</identifier>
      <parentNS>47</parentNS>
      <type>string</type>
      <length>3</length>
      <precision></precision>
   </element>
   <element>
      <elementid>28122</elementid>
      <identifier>AREANAME</identifier>
      <parentNS>47</parentNS>
      <type>string</type>
      <length>120</length>
      <precision></precision>
   </element>
   <element>
      <elementid>20248</elementid>
      <identifier>SIZE</identifier>
      <parentNS>47</parentNS>
      <type>decimal</type>
      <length>30</length>
      <precision>15</precision>
   </element>
   <element>
      <elementid>24456</elementid>
      <identifier>EIONET_EDITED_BY</identifier>
      <parentNS>47</parentNS>
      <type>string</type>
      <length>12</length>
      <precision></precision>
   </element>
   <element>
      <elementid>28007</elementid>
      <identifier>EIONET_CHNG_TYPE</identifier>
      <parentNS>47</parentNS>
      <type></type>
      <length></length>
      <precision></precision>
   </element>
   <element>
      <elementid>18794</elementid>
      <identifier>ALTITUDE_MIN</identifier>
      <parentNS>47</parentNS>
      <type>integer</type>
      <length>8</length>
      <precision></precision>
   </element>
</xsl:variable></xsl:stylesheet>
