SPIDER/pg2rdf_extra.bat at master · FransKnibbe/SPIDER · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
:: This is a Windows batch file to write a dump of triples from PostgreSQL tables in NTriples format
:: The PostgreSQL client psql needs to be available on the command line
:: Edit the .pgpass file to prevent password prompts
:: Convert output to turtle: riot --formatted=turtle churches_extra.nt > churches_extra.ttl

@echo off
SETLOCAL ENABLEEXTENSIONS
set base=http://data.spider-ld.org/kerkennl/data/
set rdf=http://www.w3.org/1999/02/22-rdf-syntax-ns#
set rdfs=http://www.w3.org/2000/01/rdf-schema#
set xsd=http://www.w3.org/2001/XMLSchema#
set dcterms=http://purl.org/dc/terms/
set geo=http://www.w3.org/2003/01/geo/wgs84_pos#
::set cidoc=http://www.cidoc-crm.org/cidoc-crm/ . # apparently version 5.0.4
::set cidoc=http://www.cidoc-crm.org/rdfs/cidoc_crm_v6.2-draft-2015August.rdfs# .  # Does not work any longer
set cidoc=http://erlangen-crm.org/160714/
set dbo=http://dbpedia.org/ontology/
set dbp=http://dbpedia.org/resource/
set aat=http://vocab.getty.edu/aat/
set schema=http://schema.org/
set bag=http://lod.geodan.nl/vocab/bag#
set locn=http://www.w3.org/ns/locn#
set eth=http://data.cultureelerfgoed.nl/semnet/
set event=http://purl.org/NET/c4dm/event.owl#
set void=http://rdfs.org/ns/void#
set dcat=http://www.w3.org/ns/dcat#
set foaf=http://xmlns.com/foaf/0.1/
set dul=http://www.ontologydesignpatterns.org/ont/dul/DUL.owl#
set umbel=http://umbel.org/umbel#
set rc=http://umbel.org/umbel/rc/
set time=http://www.w3.org/2006/time#
set geosparql=http://www.opengis.net/ont/geosparql#
set sd=http://www.w3.org/ns/sparql-service-description#
set crs=http://www.opengis.net/def/crs/EPSG/0/
set extra=http://data.spider-ld.org/kerkennl_extra/data/
set geom=http://data.ign.fr/def/geometrie#

psql -U postgres -A -t -d spiderdb1 -c "select '<%base%kerk' || id || '> <%locn%location> <%extra%locatie' || id || '> .' from kerken_locatie;" > churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%locatie' || id || '> <%dbo%province> ""' || provincie || '"".' from kerken_locatie;" >> churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%locatie' || id || '> <%dbo%municipality> ""' || gemeente || '"".' from kerken_locatie;" >> churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%locatie' || id || '> <%rdf%type> <%dcterms%Location> .' from kerken_locatie;" >> churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%locatie' || id || '> <%void%inDataset> <http://data.spider-ld.org/kerkennl_extra/data> .' from kerken_locatie;" >> churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%locatie' || id || '> <%dbo%area> ""' || oppervlakte || '""^^<http://www.w3.org/2001/XMLSchema#double> .' from kerken_locatie;" >> churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%locatie' || id || '> <%locn%geometry> <%extra%geom' || id || '_point_crs84> .' from kerken_locatie;" >> churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%locatie' || id || '> <%locn%geometry> <%extra%geom' || id || '_polygon_crs84> .' from kerken_locatie;" >> churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%locatie' || id || '> <%locn%geometry> <%extra%geom' || id || '_point_rd> .' from kerken_locatie;" >> churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%locatie' || id || '> <%locn%geometry> <%extra%geom' || id || '_polygon_rd> .' from kerken_locatie;" >> churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%geom' || id || '_point_rd> <%rdf%type> <%geom%Geometry> .' from kerken_locatie;" >> churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%geom' || id || '_point_rd> <%rdf%type> <%locn%Geometry> .' from kerken_locatie;" >> churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%geom' || id || '_point_rd> <%rdf%type> <%geom%Point> .' from kerken_locatie;" >> churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%geom' || id || '_point_rd> <%geom%crs> <http://www.opengis.net/def/crs/EPSG/0/28992> .' from kerken_locatie;" >> churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%geom' || id || '_point_rd> <%geosparql%asWKT> ""<%crs%28992> ' || ST_AsText(ST_GeomFromGeoJSON(ST_AsGeoJSON(puntgeometrie_28992,0,0))) || '""^^' || '<%geosparql%wktLiteral> .' from kerken_locatie;" >> churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%geom' || id || '_polygon_rd> <%rdf%type> <%geom%Geometry> .' from kerken_locatie;" >> churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%geom' || id || '_polygon_rd> <%rdf%type> <%locn%Geometry> .' from kerken_locatie;" >> churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%geom' || id || '_polygon_rd> <%rdf%type> <%geom%Polygon> .' from kerken_locatie;" >> churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%geom' || id || '_polygon_rd> <%geom%crs> <http://www.opengis.net/def/crs/EPSG/0/28992> .' from kerken_locatie;" >> churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%geom' || id || '_polygon_rd> <%geosparql%asWKT> ""<%crs%28992> ' || ST_AsText(ST_GeomFromGeoJSON(ST_AsGeoJSON(pandgeometrie_28992,2,0))) || '""^^' || '<%geosparql%wktLiteral> .' from kerken_locatie;" >> churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%geom' || id || '_point_crs84> <%rdf%type> <%geom%Geometry> .' from kerken_locatie;" >> churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%geom' || id || '_point_crs84> <%rdf%type> <%locn%Geometry> .' from kerken_locatie;" >> churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%geom' || id || '_point_crs84> <%rdf%type> <%geom%Point> .' from kerken_locatie;" >> churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%geom' || id || '_point_crs84> <%geom%crs> <http://www.opengis.net/def/crs/OGC/1.3/CRS84> .' from kerken_locatie;" >> churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%geom' || id || '_point_crs84> <%geosparql%asWKT> ""' || ST_AsText(ST_GeomFromGeoJSON(ST_AsGeoJSON(puntgeometrie_4326,5,0))) || '""^^' || '<%geosparql%wktLiteral> .' from kerken_locatie;" >> churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%geom' || id || '_polygon_crs84> <%rdf%type> <%geom%Geometry> .' from kerken_locatie;" >> churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%geom' || id || '_polygon_crs84> <%rdf%type> <%locn%Geometry> .' from kerken_locatie;" >> churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%geom' || id || '_polygon_crs84> <%rdf%type> <%geom%Polygon> .' from kerken_locatie;" >> churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%geom' || id || '_polygon_crs84> <%geom%crs> <http://www.opengis.net/def/crs/OGC/1.3/CRS84> .' from kerken_locatie;" >> churches_extra.nt
psql -U postgres -A -t -d spiderdb1 -c "select '<%extra%geom' || id || '_polygon_crs84> <%geosparql%asWKT> ""' || ST_AsText(ST_GeomFromGeoJSON(ST_AsGeoJSON(pandgeometrie_4326,7,0))) || '""^^' || '<%geosparql%wktLiteral> .' from kerken_locatie;" >> churches_extra.nt