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.

 

One Trackback/Pingback

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

Post a Comment

Your email is never published nor shared. Required fields are marked *
*
*