spoi-importer-original/Belluno.sh

#!/bin/bash

# SPOI - Belluno data (Foodie project)
# ====================================

# The first line with labels of collumns was deleted

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

echo '<?xml version="1.0" encoding="utf-8"?>' > $file_out
echo '<rdf:RDF xmlns:dc="http://purl.org/dc/elements/1.1/"
	 xmlns:dbo="http://dbpedia.org/ontology/"
 	 xmlns:dbp="http://dbpedia.org/property/"
         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:locn="http://www.w3.org/ns/locn#"
         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
echo '<rdf:Description rdf:about="http://www.sdi4apps.eu/poi/#Belluno'$i'">' >> $file_out
echo '<rdfs:label xml:lang="it">'${A[13]}'</rdfs:label>' >> $file_out
if [ -n "${A[14]}" ]; then echo '<rdfs:label xml:lang="en">'${A[14]}'</rdfs:label>' >> $file_out; fi
if [ "${A[15]}" != "-" ]; then echo '<rdfs:label xml:lang="de">'${A[15]}'</rdfs:label>' >> $file_out; fi
if [ "${A[20]}" != "-" ]; then echo '<rdfs:comment xml:lang="it">'${A[20]}'</rdfs:comment>' >> $file_out; fi
if [ "${A[31]}" != "-" ]; then echo '<rdfs:comment xml:lang="it">'${A[31]}'</rdfs:comment>' >> $file_out; fi

echo '<geos:asWKT rdf:datatype="http://www.openlinksw.com/schemas/virtrdf#Geometry">POINT('${A[4]}' '${A[3]}')</geos:asWKT>' >> $file_out
echo '<poi:region resource="http://nuts.geovocab.org/id/ITD33"/>' >> $file_out

echo '<poi:class rdf:resource="http://gis.zcu.cz/SPOI/Ontology#lodging"/>' >> $file_out

if [ "${A[5]}" != "-" ]; then echo '<foaf:phone>'${A[5]}'</foaf:phone>' >> $file_out; fi
if [ "${A[7]}" != "-" ]; then echo '<foaf:mbox>'${A[7]}'</foaf:mbox>' >> $file_out; fi

if [ "${A[50]}" != "-" ]; then echo '<poi:access>'${A[50]}'</poi:access>' >> $file_out; fi
if [ "${A[51]}" != "-" ]; then echo '<poi:access>'${A[51]}'</poi:access>' >> $file_out; fi
if [ "${A[52]}" != "-" ]; then echo '<poi:access>'${A[52]}'</poi:access>' >> $file_out; fi

if [ "${A[2]}" != "-" ]; then echo '<rdfs:seeAlso><rdf:Description rdf:about="'${A[2]}'"><dc:type>Image</dc:type></rdf:Description></rdfs:seeAlso>' >> $file_out; fi #původní photo


if [ "${A[17]}" != "-" ]; then echo '<rdfs:seeAlso>'${A[17]}'</rdfs:seeAlso>' >> $file_out; fi

echo '<geos:sfWithin rdf:resource="http://dbpedia.org/resource/Italy"/>
<geos:sfWithin rdf:resource="http://www.geonames.org/3175395"/>' >> $file_out

echo '<dc:identifier rdf:resource="http://www.sdi4apps.eu/poi/Belluno'$i'"/>' >> $file_out
echo '<dc:publisher>SPOI (http://sdi4apps.eu/spoi)</dc:publisher>' >> $file_out
echo '<dc:title>'${A[13]}'</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.infodolomiti.it'"/>' >> $file_out
echo '<dcterms:created rdf:datatype="http://www.w3.org/2001/XMLSchema#date">'$(date +%Y-%m-%d)'</dcterms:created>' >> $file_out

((i=i+1))
echo '</rdf:Description>' >> $file_out
echo '' >> $file_out
done < $file_in

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