Calculate Tarifdaten

[ktk]

I've prepared calculation of "Tarifdaten". It is split into the following queries:

• calc-canton-municipality-population.rq: This query fetches all valid municipalities of a hard-coded year (2019 at the moment), gets the population data and writes them into a new graph. There is a link between the canton and the municipalities via skos:narrower so one can easily get all municipalities per canton.
• calc-provider-category-max-min.rq: This query fetches all tariffs of the same hard-coded year and calculates max/min values per municipality. It then attaches this information to the same municipality URI that is used in the previous query

I execute them like this:

#!/bin/sh
curl -H "Accept: text/turtle" -o canton-municipality-population.ttl --data-urlencode query@sparql/calc-canton-municipality-population.rq  https://ld.geo.admin.ch/query
curl -H "Accept: text/turtle" -o provider-category-max-min.ttl --data-urlencode query@sparql/calc-provider-category-max-min.rq  https://trifid-lindas.test.cluster.ldbar.ch/query

for testing I load the data in a local TDB and execute the last query on them:

• calc-table.rq: This query fetches for a particular, hard-coded canton the municipalities, the population & corresponding min/max values.

This query returns a result-set and should be executed for each canton. This can be done by replacing 8: on line 16 with an integer between 1-26.

Sample for Kanton Glarus:

municipality	name	population	max	min
https://ld.geo.admin.ch/boundaries/municipality/1630	"Glarus Nord"	18247	1.900873374938965E1	1.900873374938965E1
https://ld.geo.admin.ch/boundaries/municipality/1631	"Glarus Süd"	9581	1.8326534271240234E1	1.8326534271240234E1

Note that the municipality Glarus is missing due to a bug in the source-data.

[ktk]

@bergos btw I can't seem to remember how to assign proper dataype in SPARQL, sorry for the max/min format.

[ktk]

Ah and I assume we have to do that for each category, which is hardcoded here, the list of all categories used can be found here