{"id":575,"date":"2010-12-05T21:09:54","date_gmt":"2010-12-05T21:09:54","guid":{"rendered":"http:\/\/blog.soton.ac.uk\/webteam\/?p=575"},"modified":"2010-12-05T21:36:52","modified_gmt":"2010-12-05T21:36:52","slug":"new-tools","status":"publish","type":"post","link":"https:\/\/blog.soton.ac.uk\/webteam\/2010\/12\/05\/new-tools\/","title":{"rendered":"New Tools"},"content":{"rendered":"

As well as the more experimental stuff, I’ve also produce several more useful tools:<\/p>\n

sparql2kml<\/h3>\n

http:\/\/graphite.ecs.soton.ac.uk\/sparql2kml\/<\/a> – 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!<\/p>\n

As an experiment I used the following to find the birth place of Southampton football players.<\/p>\n

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

\u00a0<\/p>\n<\/div>\n

View it: Google Maps<\/a> or KML for Google Earth<\/a>.<\/p>\n

excel2csv<\/h3>\n

This one is dead simple. It converts an excel file into comma separated values.<\/p>\n

http:\/\/graphite.ecs.soton.ac.uk\/excel2csv?src=http:\/\/opendata.s3.amazonaws.com\/bridge-weight-limits-2010.xls<\/a><\/p>\n

sparqllib.php<\/h3>\n

http:\/\/graphite.ecs.soton.ac.uk\/sparqllib\/<\/a><\/p>\n

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.<\/p>\n

\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-575","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/blog.soton.ac.uk\/webteam\/wp-json\/wp\/v2\/posts\/575","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.soton.ac.uk\/webteam\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.soton.ac.uk\/webteam\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.soton.ac.uk\/webteam\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.soton.ac.uk\/webteam\/wp-json\/wp\/v2\/comments?post=575"}],"version-history":[{"count":15,"href":"https:\/\/blog.soton.ac.uk\/webteam\/wp-json\/wp\/v2\/posts\/575\/revisions"}],"predecessor-version":[{"id":577,"href":"https:\/\/blog.soton.ac.uk\/webteam\/wp-json\/wp\/v2\/posts\/575\/revisions\/577"}],"wp:attachment":[{"href":"https:\/\/blog.soton.ac.uk\/webteam\/wp-json\/wp\/v2\/media?parent=575"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.soton.ac.uk\/webteam\/wp-json\/wp\/v2\/categories?post=575"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.soton.ac.uk\/webteam\/wp-json\/wp\/v2\/tags?post=575"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}