Skip to content


New Tools

As well as the more experimental stuff, I’ve also produce several more useful tools:

sparql2kml

http://graphite.ecs.soton.ac.uk/sparql2kml/ – This takes a SPARQL query which returns ?lat,?long (or ?georss) and ?title and maybe ?desc and ?placename and produces a KML file so you can see it on Google Maps or Earth!

As an experiment I used the following to find the birth place of Southampton football players.

PREFIX dbo: <http://dbpedia.org/ontology/>
PREFIX dbpedia: <http://dbpedia.org/resource/>
SELECT DISTINCT ?georss ?title ?placename WHERE {
?person dbo:team <http://dbpedia.org/resource/Southampton_F.C.> .
?person dbo:birthPlace ?place .
?place <http://www.georss.org/georss/point> ?georss .
?person rdfs:label ?title . FILTER langMatches( lang(?title), “EN” ) .
OPTIONAL { ?place rdfs:label ?placename . FILTER langMatches( lang(?placename), “EN” ) }
OPTIONAL { ?x <http://dbpedia.org/property/county> ?place }
FILTER (!bound(?x) && ?place != <http://dbpedia.org/resource/England> && ?place != &l
t;http://dbpedia.org/resource/Wales> )
}

 

View it: Google Maps or KML for Google Earth.

excel2csv

This one is dead simple. It converts an excel file into comma separated values.

http://graphite.ecs.soton.ac.uk/excel2csv?src=http://opendata.s3.amazonaws.com/bridge-weight-limits-2010.xls

sparqllib.php

http://graphite.ecs.soton.ac.uk/sparqllib/

Nice and simple library to let you use SPARQL from PHP. The function names are deliberately copied from the mysql ones so you have sparql_connect, sparql_fetchrow etc.

 

Posted in Uncategorized.


One Response

Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.

Continuing the Discussion

  1. Where Linked Data Would Be Useful – Creating More MPs’ Maps from the Guardian Politics API « OUseful.Info, the blog… linked to this post on December 10, 2010

    […] I really need to add Chris’ geo-tagged RDF to KML converter service (described here to my […]



Some HTML is OK

or, reply to this post via trackback.