Skip to content

R Project for visualisation of bicycle accidents. Contains open data in RDF format from Portal de datos abiertos del Ayuntamiento de Madrid and the ontologies created for it.

Notifications You must be signed in to change notification settings

ettorepuccetti/BiSafe

Repository files navigation

BiSafe

R Project for visualisation of bicycle accidents. Contains open data from Portal de datos abiertos del Ayuntamiento de Madrid and the ontologies created for it.

logo

Reconciliation and data augmentation

The dataset has been reconciling using the tool provided by RDF extention in OpenRefine. It look for entities in WikiData that matches the rows of our dataset. Once the streets in our dataset have been linked to the objects they refer to by URI, it is possible to extract additional informations, like, as in our case, the latitude and longitude.

reconc

Ontology definition

Once our dataset in csv format looks complete, we need to define the RDF schema that will represent our records.
For the vocabulary, we tried to use already defined prefixes and classes. We took some definitions from common vocabularies like:

  • foaf
  • lode
  • wikidata
  • skos

ontology

GUI

Obtained the dataset in RDF turtle-like format (.ttl), we now need to query it from the R programming language, with the help of the library rdflib.

gui

It is possible to zoom in for expand the spots and better locate the accidents. On the left, some filters are provided. You can filter for specific values of Age, Date, Gender of the biker, and for District in which the accident took place.

Try BiSafe now!

About

R Project for visualisation of bicycle accidents. Contains open data in RDF format from Portal de datos abiertos del Ayuntamiento de Madrid and the ontologies created for it.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published