<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<!--Created by Justin Shell-DATCP August 2008.-->
<!--Created to modify XML output from WinTransect and transform it into an XML format MS Access can import.-->
<!--Comments are added in an attempt to clarify what is going on. They may be useful, but some familiarity with XSLT
is expected. For references to XSLT, suggest Michael Kay's XSLT 2.0 Programmer's Reference. Evan Lenz's XSLT 1.0 Pocket reference
also came in handy.-->
<!--XML was processed using Kernow 1.6. Go to http://kernowforsaxon.sourceforge.net for information. The XSLT processor under Kernow
was Saxon 9.0.0.4. For information, go to http://saxon.sourceforge.net/.-->
<xsl:output method="xml" indent="yes"/>
<!--<xsl:variable name="t">
	<xsl:choose>
		<xsl:when test="WTReport[@type='RUSLE2SoilLossSummary']">RUSLE2</xsl:when>
		<xsl:when test="WTReport[@type='TillageSystemsSummary']">Tillage</xsl:when>
		<xsl:when test="WTReport[@type='CropTypeSummary']">CropType</xsl:when>
	</xsl:choose>-->
</xsl:variable>
<xsl:variable name="n">
<!--This variable is used to set the FIPS code of the county for each table created. If the attribute "County_name"
is matched, then the three digit number is inserted into the table.-->
	<xsl:choose>
		<xsl:when test="WTReport/Report/@county='Adams'">001</xsl:when>
		<xsl:when test="WTReport/Report/@county='Ashland'">003</xsl:when>
		<xsl:when test="WTReport/Report/@county='Barron'">005</xsl:when>
		<xsl:when test="WTReport/Report/@county='Bayfield'">007</xsl:when>
		<xsl:when test="WTReport/Report/@county='Brown'">009</xsl:when>
		<xsl:when test="WTReport/Report/@county='Buffalo'">011</xsl:when>
		<xsl:when test="WTReport/Report/@county='Burnett'">013</xsl:when>
		<xsl:when test="WTReport/Report/@county='Calumet'">015</xsl:when>
		<xsl:when test="WTReport/Report/@county='Chippewa'">017</xsl:when>
		<xsl:when test="WTReport/Report/@county='Clark'">019</xsl:when>
		<xsl:when test="WTReport/Report/@county='Columbia'">021</xsl:when>
		<xsl:when test="WTReport/Report/@county='Crawford'">023</xsl:when>
		<xsl:when test="WTReport/Report/@county='Dane'">025</xsl:when>
		<xsl:when test="WTReport/Report/@county='Dodge'">027</xsl:when>
		<xsl:when test="WTReport/Report/@county='Door'">029</xsl:when>
		<xsl:when test="WTReport/Report/@county='Douglas'">031</xsl:when>
		<xsl:when test="WTReport/Report/@county='Dunn'">033</xsl:when>
		<xsl:when test="WTReport/Report/@county='Eau Claire'">035</xsl:when>
		<xsl:when test="WTReport/Report/@county='Florence'">037</xsl:when>
		<xsl:when test="WTReport/Report/@county='Fond du Lac'">039</xsl:when>
		<xsl:when test="WTReport/Report/@county='Forest'">041</xsl:when>
		<xsl:when test="WTReport/Report/@county='Grant'">043</xsl:when>
		<xsl:when test="WTReport/Report/@county='Green'">045</xsl:when>
		<xsl:when test="WTReport/Report/@county='Green Lake'">047</xsl:when>
		<xsl:when test="WTReport/Report/@county='Iowa'">049</xsl:when>
		<xsl:when test="WTReport/Report/@county='Iron'">051</xsl:when>
		<xsl:when test="WTReport/Report/@county='Jackson'">053</xsl:when>
		<xsl:when test="WTReport/Report/@county='Jefferson'">055</xsl:when>
		<xsl:when test="WTReport/Report/@county='Juneau'">057</xsl:when>
		<xsl:when test="WTReport/Report/@county='Kenosha'">059</xsl:when>
		<xsl:when test="WTReport/Report/@county='Kewaunee'">061</xsl:when>
		<xsl:when test="WTReport/Report/@county='La Crosse'">063</xsl:when>
		<xsl:when test="WTReport/Report/@county='Lafayette'">065</xsl:when>
		<xsl:when test="WTReport/Report/@county='Langlade'">067</xsl:when>
		<xsl:when test="WTReport/Report/@county='Lincoln'">069</xsl:when>
		<xsl:when test="WTReport/Report/@county='Manitowoc'">071</xsl:when>
		<xsl:when test="WTReport/Report/@county='Marathon'">073</xsl:when>
		<xsl:when test="WTReport/Report/@county='Marinette'">075</xsl:when>
		<xsl:when test="WTReport/Report/@county='Marquette'">077</xsl:when>
		<xsl:when test="WTReport/Report/@county='Menominee'">078</xsl:when>
		<xsl:when test="WTReport/Report/@county='Milwaukee'">079</xsl:when>
		<xsl:when test="WTReport/Report/@county='Monroe'">081</xsl:when>
		<xsl:when test="WTReport/Report/@county='Oconto'">083</xsl:when>
		<xsl:when test="WTReport/Report/@county='Oneida'">085</xsl:when>
		<xsl:when test="WTReport/Report/@county='Outagamie'">087</xsl:when>
		<xsl:when test="WTReport/Report/@county='Ozaukee'">089</xsl:when>
		<xsl:when test="WTReport/Report/@county='Pepin'">091</xsl:when>
		<xsl:when test="WTReport/Report/@county='Pierce'">093</xsl:when>
		<xsl:when test="WTReport/Report/@county='Polk'">095</xsl:when>
		<xsl:when test="WTReport/Report/@county='Portage'">097</xsl:when>
		<xsl:when test="WTReport/Report/@county='Price'">099</xsl:when>
		<xsl:when test="WTReport/Report/@county='Racine'">101</xsl:when>
		<xsl:when test="WTReport/Report/@county='Richland'">103</xsl:when>
		<xsl:when test="WTReport/Report/@county='Rock'">105</xsl:when>
		<xsl:when test="WTReport/Report/@county='Rusk'">107</xsl:when>
		<xsl:when test="WTReport/Report/@county='Saint Croix'">109</xsl:when>
		<xsl:when test="WTReport/Report/@county='Sauk'">111</xsl:when>
		<xsl:when test="WTReport/Report/@county='Sawyer'">113</xsl:when>
		<xsl:when test="WTReport/Report/@county='Shawano'">115</xsl:when>
		<xsl:when test="WTReport/Report/@county='Sheboygan'">117</xsl:when>
		<xsl:when test="WTReport/Report/@county='Taylor'">119</xsl:when>
		<xsl:when test="WTReport/Report/@county='Trempealeau'">121</xsl:when>
		<xsl:when test="WTReport/Report/@county='Vernon'">123</xsl:when>
		<xsl:when test="WTReport/Report/@county='Vilas'">125</xsl:when>
		<xsl:when test="WTReport/Report/@county='Walworth'">127</xsl:when>
		<xsl:when test="WTReport/Report/@county='Washburn'">129</xsl:when>
		<xsl:when test="WTReport/Report/@county='Washington'">131</xsl:when>
		<xsl:when test="WTReport/Report/@county='Waukesha'">133</xsl:when>
		<xsl:when test="WTReport/Report/@county='Waupaca'">135</xsl:when>
		<xsl:when test="WTReport/Report/@county='Waushara'">137</xsl:when>
		<xsl:when test="WTReport/Report/@county='Winnebago'">139</xsl:when>
		<xsl:when test="WTReport/Report/@county='Wood'">141</xsl:when>
		<xsl:otherwise>0</xsl:otherwise>
	</xsl:choose>
</xsl:variable>
	<xsl:template match="/">
		<dataroot>
			<xsl:element name="FIPS">
					<xsl:value-of select="$n"/>
			</xsl:element>
			<xsl:for-each select="WTReport/@*">
				<xsl:element name="{name()}">
					<xsl:value-of select="."/>
				</xsl:element>
			</xsl:for-each>
			<xsl:for-each select="WTReport/Report/@*">
				<xsl:element name="{name()}">
					<xsl:value-of select="."/>
				</xsl:element>
			</xsl:for-each>
			<xsl:for-each select="WTReport/Report/Transect/*/@*">
				<xsl:element name="{name()}">
					<xsl:value-of select="."/>
				</xsl:element>
			</xsl:for-each>
		</dataroot>
	</xsl:template>
</xsl:stylesheet>