AKSW / transform-bvl-pages-to-csv-file

Repository contains files to extract and enrich data from closed database of the Online-Stadtführer maintained by Behindertenverband Leipzig e.V (in German). Besides that, further files like a R2RML mapping, are maintained.
https://behindertenverband-leipzig.de/projekte/stadtfuehrer/
GNU General Public License v3.0
1 stars 2 forks source link
behindertenverband-leipzig building csv disability leipzig open-data opendata r2rml

Enriched CSV version of the building database from Behindertenverband Leipzig e.V.

This repository contains a simple PHP script, which transforms an exported CSV file with building information to an enriched version. It contains further information and normalized strings. Information are about buildings located in Leipzig and their degree of accessibility. The source data is being provided by the Behindertenverband Leipzig e.V.

The following areas are covered currently:

R2RML-Mapping (CSV => RDF)

The R2RML-mapping (file) allows the transformation of the CSV file to RDF using R2RML tools like sparqlmap. Its purpose is to lower the barrier to convert original data, modeled as a table, in further formats.

Our R2RML mapping is based on a couple of controlled vocabularies, such as Dublin Core and The vocabulary for (L)OD description of wheelchair accessibility as well as two vocabularies, inspired by and based on the data model of the building database, developed by ourselves.

The file places.n3 was generated using sparqlmap with our R2RML-mapping.

If you want to transform the CSV file a RDF file yourself, you can use this docker-container.

SHACL rules

We also developed, based on the building accessibility ontology, an extended set of SHACL rules. SHACL can be used to formulate rules about RDF graphs. Using a SHACL processor helps evaluating, if a given dataset is valid or not.

You can found the SHACL rules here: https://github.com/AKSW/shacl-shapes/tree/master/shape-groups/accessible-place

Usage infos

We used the closed building database maintained by the BVL to generate the CSV files. Without it, you can't use these scripts. In case you have it (table.csv) run the script enrich-table-csv.php. Furthermore, you need to run composer update to setup required vendors.

License

CSV and RDF (n3) files are licensed under the terms of Data licence Germany – attribution – version 2.0. Please use the following text as attribution: Behindertenverband Leipzig e.V., www.le-online.de.

Software source code is licensed under the terms of GPL 3.0.

The rest of the repository is licensed under the terms of the CC-BY 4.0.