#!/bin/bash

file_in="/media/cerba/Data/Data/SPOI/SPOI_In/Adventura.csv"
file_out="/media/cerba/Data/Data/SPOI/RDF_output/Adventura.rdf"

echo '<?xml version="1.0" encoding="utf-8"?>' > $file_out
echo '<rdf:RDF xmlns:dc="http://purl.org/dc/elements/1.1/"
         xmlns:dcterms="http://purl.org/dc/terms/1.1/"
         xmlns:foaf="http://xmlns.com/foaf/0.1/"
         xmlns:geos="http://www.opengis.net/ont/geosparql#"
         xmlns:owl="http://www.w3.org/2002/07/owl#"
         xmlns:poi="http://www.openvoc.eu/poi#"
         xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
         xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#"
         xmlns:sf="http://www.opengis.net/ont/sf#"
         xmlns:skos="http://www.w3.org/2004/02/skos/core#">' >> $file_out

sed 1d $file_in | while IFS=$'*' read -r -a arry
do
echo '<rdf:Description rdf:about="http://www.sdi4apps.eu/poi/#Adv_'${arry[0]}'">' >> $file_out
echo '<rdfs:label xml:lang="cs">'${arry[1]}'</rdfs:label>' >> $file_out
echo '<rdfs:comment xml:lang="cs">'${arry[2]}'</rdfs:comment>' >> $file_out
echo '<geos:asWKT rdf:datatype="http://www.openlinksw.com/schemas/virtrdf#Geometry">POINT('${arry[6]}' '${arry[5]}')</geos:asWKT>' >> $file_out
echo '<poi:class rdf:resource="'${arry[7]}'"/>' >> $file_out
if [ "${arry[8]}" != "-" ]; then echo '<poi:class rdf:resource="'${arry[8]}'"/>' >> $file_out; fi
if [ "${arry[9]}" != "-" ]; then echo '<poi:class rdf:resource="'${arry[9]}'"/>' >> $file_out; fi
if [ "${arry[3]}" = "y" ]; then echo '<poi:class rdf:resource="http://gis.zcu.cz/SPOI/Ontology#unesco_heritage_object"/>' >> $file_out >> $file_out; fi
if [ "${arry[4]}" = "Senegal" ]; then echo '<geos:sfWithin rdf:resource="http://dbpedia.org/resource/Senegal"/>
<geos:sfWithin rdf:resource="http://www.geonames.org/2245662"/>' >> $file_out >> $file_out; fi
if [ "${arry[4]}" = "Gambie" ]; then echo '<geos:sfWithin rdf:resource="http://dbpedia.org/resource/The_Gambia"/>
<geos:sfWithin rdf:resource="http://www.geonames.org/2413451"/>' >> $file_out >> $file_out; fi
if [ "${arry[4]}" = "Itálie" ]; then echo '<geos:sfWithin rdf:resource="http://dbpedia.org/resource/Italy"/>
<geos:sfWithin rdf:resource="http://www.geonames.org/3175395"/>' >> $file_out >> $file_out; fi
if [ "${arry[4]}" = "Německo" ]; then echo '<geos:sfWithin rdf:resource="http://dbpedia.org/resource/Germany"/>
<geos:sfWithin rdf:resource="http://www.geonames.org/2921044"/>' >> $file_out >> $file_out; fi
echo '<dc:identifier rdf:resource="http://www.sdi4apps.eu/poi/#Adv'${arry[0]}'"/>' >> $file_out
echo '<dc:publisher>SPOI (http://sdi4apps.eu/spoi)</dc:publisher>' >> $file_out
echo '<dc:title>'${arry[1]}'</dc:title>' >> $file_out
echo '<dc:rights rdf:resource="http://opendatacommons.org/licenses/odbl/1.0/"/>' >> $file_out
echo '<dc:source rdf:resource="'http://cz.linkedin.com/in/otakarcerba/'"/>' >> $file_out
echo '<dcterms:created rdf:datatype="http://www.w3.org/2001/XMLSchema#date">'$(date +%Y-%m-%d)'</dcterms:created>' >> $file_out
echo '</rdf:Description>' >> $file_out

done

echo '</rdf:RDF>' >> $file_out