spoi-importer-original/Hyperborea.sh

#!/bin/bash

file_in="/media/cerba/Data/Data/SPOI/SPOI_In/Italy.csv"
file_out="/media/cerba/Data/Data/SPOI/RDF_output/Hyperborea_S4a.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


i=1
while IFS=$';' read -r -a A
do

test $i -eq 1 && ((i=i+1)) && continue


if [ "${A[3]}" = "alimentari" ] || [ "${A[3]}" = "appartamenti vacanze" ] || [ "${A[3]}" = "appartamentovacanze" ] || [ "${A[3]}" = "bar" ] || [ "${A[3]}" = "Bar" ] || [ "${A[3]}" = "biblioteca" ] || [ "${A[3]}" = "Biblioteca" ] || [ "${A[3]}" = "hotel" ] || [ "${A[3]}" = "museo" ] || [ "${A[3]}" = "Museo" ]; then 

echo '<rdf:Description rdf:about="http://www.sdi4apps.eu/poi/#Hyp_'${A[1]}'">' >> $file_out

echo '<rdfs:label xml:lang="cs">'${A[7]}'</rdfs:label>' >> $file_out

echo '<geos:asWKT rdf:datatype="http://www.openlinksw.com/schemas/virtrdf#Geometry">'${A[0]}'</geos:asWKT>' >> $file_out

if [ "${A[3]}" = "alimentari" ]; then 
echo '<poi:class rdf:resource="http://gis.zcu.cz/SPOI/Ontology#shopping_and_service"/>' >> $file_out
fi

if [ "${A[3]}" = "appartamenti vacanze" ] || [ "${A[3]}" = "appartamentovacanze" ]; then 
echo '<poi:class rdf:resource="http://gis.zcu.cz/SPOI/Ontology#apartment"/>' >> $file_out
echo '<poi:class rdf:resource="http://gis.zcu.cz/SPOI/Ontology#lodging"/>' >> $file_out
fi

if [ "${A[3]}" = "bar" ] || [ "${A[3]}" = "Bar" ]; then 
echo '<poi:class rdf:resource="http://gis.zcu.cz/SPOI/Ontology#bar"/>' >> $file_out
echo '<poi:class rdf:resource="http://gis.zcu.cz/SPOI/Ontology#food_and_drink"/>' >> $file_out
fi

if [ "${A[3]}" = "biblioteca" ] || [ "${A[3]}" = "Biblioteca" ]; then 
echo '<poi:class rdf:resource="http://gis.zcu.cz/SPOI/Ontology#library"/>' >> $file_out
echo '<poi:class rdf:resource="http://gis.zcu.cz/SPOI/Ontology#professional_and_public"/>' >> $file_out
fi

if [ "${A[3]}" = "hotel" ]; then 
echo '<poi:class rdf:resource="http://gis.zcu.cz/SPOI/Ontology#hotel"/>' >> $file_out
echo '<poi:class rdf:resource="http://gis.zcu.cz/SPOI/Ontology#lodging"/>' >> $file_out
fi

if [ "${A[3]}" = "museo" ] || [ "${A[3]}" = "museum" ]; then 
echo '<poi:class rdf:resource="http://gis.zcu.cz/SPOI/Ontology#museum"/>' >> $file_out
echo '<poi:class rdf:resource="http://gis.zcu.cz/SPOI/Ontology#culture_and_entertainment"/>' >> $file_out
fi

if [ -n "${A[8]}" ]; then echo '<foaf:homepage>'${A[8]}'</foaf:homepage>' >> $file_out; fi
if [ -n "${A[2]}" ]; then echo '<foaf:mbox>'${A[2]}'</foaf:mbox>' >> $file_out; fi
if [ -n "${A[4]}" ]; then echo '<foaf:phone>'${A[4]}'</foaf:phone>' >> $file_out; fi
if [ -n "${A[5]}" ]; then echo '<poi:fax>'${A[5]}'</poi:fax>' >> $file_out; fi

if [ -n "${A[6]}" ]; then echo '<locn:fullAddress>'${A[6]}'</locn:fullAddress>' >> $file_out; fi

echo '<dc:identifier rdf:resource="http://www.sdi4apps.eu/poi/#Hyp_'${A[1]}'"/>' >> $file_out
echo '<dc:publisher>SPOI (http://sdi4apps.eu/spoi)</dc:publisher>' >> $file_out
echo '<dc:title>'${A[7]}'</dc:title>' >> $file_out
echo '<dc:rights rdf:resource="http://opendatacommons.org/licenses/odbl/1.0/"/>' >> $file_out
echo '<dc:source rdf:resource="'http://www.hyperborea.com/'"/>' >> $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

fi

done < $file_in

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