X=0;
cd google-geocoded

echo 'delete from qkoorts;'

ls -1 | while read i; do
	LOC=`sed "s/.*,\(.*\),\(.*\)$/\2 \1/g" "$i"`
	LAD=`echo "$i" | sed "s/\(.*\), \(.*\)/\1/g"`

	BESMETTING=`grep "$LAD" "../Normlijst Q-Koorts.txt" | sed "s/.* \(.*-[0-9]\{4\}\) \(Geit\|Schaap\)/\1/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
	if [ "`grep -l \"$LAD\" ../Verwijderd.txt`" == "" ]; then
		X=$(( $X + 1 ))
		echo "insert into qkoorts values (GeomFromText('POINT($LOC)'));"
	fi
done