Code Monkey home page Code Monkey logo

aksw / transform-bvl-pages-to-csv-file Goto Github PK

View Code? Open in Web Editor NEW
1.0 20.0 2.0 7.17 MB

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.

Home Page: https://behindertenverband-leipzig.de/projekte/stadtfuehrer/

License: GNU General Public License v3.0

PHP 100.00%
opendata open-data leipzig building csv behindertenverband-leipzig disability r2rml

transform-bvl-pages-to-csv-file's Introduction

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.

transform-bvl-pages-to-csv-file's People

Contributors

fteichmann avatar k00ni avatar

Stargazers

 avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

transform-bvl-pages-to-csv-file's Issues

Parking slots on front?

We have the properties

numberOfSlotsDisabledParkingLotInFrontOfPlace
numberOfSlotsDisabledParkingLotOnSite
locationParkingLotOnSite

But no property for parking slots on front (for may not disabled people).

Is this missing or not documented?

RDF: optimizing data structure to speed up queries

Discussion started in AKSW/transform-bvl-csv-to-json-files#6

Beside the performance another question is, who decides (and where) if an elevator is wheelchair accessible, eg what is the min door width. It think its better to not do that in the building navigator app, but in the data processing.

Do you mean, that you would like to have only a few fields, which tell you if something is e.g. partly/fully wheelchair accessible?

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.