echo '<?xml version="1.0" encoding="UTF-8"?><kml xmlns="http://earth.google.com/kml/2.2"><Document>'
echo '<StyleMap id="GeitNQ"><Pair><key>normal</key><styleUrl>#geitnq_n</styleUrl></Pair><Pair><key>highlight</key><styleUrl>#geitnq_h</styleUrl></Pair></StyleMap>
<StyleMap id="SchaapNQ"><Pair><key>normal</key><styleUrl>#schaapnq_n</styleUrl></Pair><Pair><key>highlight</key><styleUrl>#schaapnq_h</styleUrl></Pair></StyleMap>
<Style id="geitnq_n"><color>00ff11ff</color><colorMode>normal</colorMode></Style>
<Style id="geitnq_h"><color>00ff11ff</color><colorMode>normal</colorMode></Style>
<Style id="schaapnq_n"><color>00ee00ff</color><colorMode>normal</colorMode></Style>
<Style id="schaapnq_h"><color>00ee00ff</color><colorMode>normal</colorMode></Style>'

X=0;
cd google-geocoded

ls -1 | while read i; do
	LOC=`sed "s/.*,\(.*\),\(.*\)$/\2,\1/g" "$i"`
	LAD=`echo "$i" | sed "s/\(.*\), \(.*\)/\1/g"`
	if [ "`grep -l \"$LAD\" ../Verwijderd.txt`" != "" ]; then
		BESMETTING=`grep "$LAD" "../Normlijst Q-Koorts.txt" | sed "s/.* \(.*-[0-9]\{4\}\) \(Geit\|Schaap\)/\1/g"`
		VERWIJDERD=`grep "$LAD" "../Verwijderd.txt" | sed "s/.* \(Geit\|Schaap\) \(.*\)/\2/g"`
		DIER=`grep "$LAD" "../Normlijst Q-Koorts.txt" | sed "s/.* \(.*-[0-9]\{4\}\) \(Geit\|Schaap\)/\2/g"`
		POSTCODE=`grep "$LAD" "../Normlijst Q-Koorts.txt"  | sed "s/.*\([0-9]\{4\}\)\([A-Z]\{2\}\).*/\1/g"`
		VACCINATIE=`grep $POSTCODE ../postcodes-vaccinatie.csv`
		STYLE=$DIER
		if [ "$VACCINATIE " = " " ]; then
			VACCINATIE="Nee";
		else
			VACCINATIE="Ja";
		fi
		X=$(( $X + 1 ))
		echo "<Placemark id=\"NQ$X\"><name>$i</name><description><![CDATA[Dier: $DIER<br />Besmetting: $BESMETTING<br />Verwijderd: $VERWIJDERD<br /><a href=\"http://openkvk.nl/adresplaats:$i\">Zoek naar bedrijfsinfo</a><br />]]></description><styleURL>#$STYLE</styleURL><Point><coordinates>$LOC</coordinates></Point></Placemark>"
	fi
done

echo '</Document></kml>'