A considerable amount of the data from this open and linked social data is now available on a SparQL endpoint through a Jena/Fuseki instance.

Three problems were detected in loading data into the Jena/fuseki instance:

  • Datetime format used in Cidade Democrática is not undestood by Jena (and seems to be an unusual standard).
  • Some non-standard URIs were detected in the linked data from email lists.
  • Non-utf8 chars are found in some IRC logs, tweets and email messages.

Only the last problem, in some cases, have lead to a fail in the data loading process of Jena/Fuseki. They might be resolved in near future.

For making the configuration files, these routines have been developed. Here is a snapshot of current configuration file, where it is specified each dataset loaded and the respective query point.

The endpoint can be dealt with through normal html browsing. Here are some examples for using the endpoint for rapid rendering of friendship and interaction networks. The advance consists in the access to the data through powerful semantic queries (using the SparQL language), and the fast access to the data (available through the Jena/Fuseki endpoint). The total space in RAM used by JenaFuseki for the current data is between 5GB and 8GB.

Here are some examples of using SparQL queries to explore data from other endpoints, e.g. for making networks of collaborators in scientific articles form Aalto University and of friendships found in DBpedia.