SPARQL- transports data in UK

Transport.data.gov.uk

http://datahub.io/dataset/transport-data-gov-uk

Data.gov.uk is the Cabinet Office’s project to open up government data and make it available for reuse. At Ito we take a great interest in all things open (maps, data, you name it). In this project, we are trying to retrieve transport-related linked data from transport.data.gov.uk.
Screen Shot 2015-02-17 at 16.21.41

Screen Shot 2015-02-17 at 16.21.32
This linking open data cloud catalog sets are Linked Data and contain data links pointing at other Linked Data sets. The site provides a series SPARQL endpoints for queries, for example, station, airport, stop-area, etc. The LINKED transport-related linked data provided by data.gov.uk are listed as follows:

  • Namespace for roads
  • Namespace for stations
  • Namespace for airports
  • Road traffic statistics (SCOVO)

The data needs to connect different sites to obtain the corresponding information:

URI Description
http://transport.data.gov.uk/doc/station lists UK railway stations
http://transport.data.gov.uk/doc/airport lists UK airports
http://transport.data.gov.uk/doc/stop-point lists NaPTAN stop points (eg. bus stops)
http://transport.data.gov.uk/def/naptan/StopPoint/subclass lists subclasses of NaPTAN stop point.
http://transport.data.gov.uk/doc/stop-area lists NaPTAN stop areas. Stop areas are groupings of adjacent NaPTAN stops
http://transport.data.gov.uk/def/naptan/StopArea/subclass lists subclasses of NaPTAN stop area.
http://transport.data.gov.uk/doc/traffic-count-point lists traffic count points
http://transport.data.gov.uk/doc/traffic-count-point/8615/observation list traffic count observations made athttp://transport.data.gov.uk/id/traffic-count-point/8615


Les différentes adresses du site (données en html, données RDF, sparql endpoint, etc.)

http://transport.data.gov.uk/sparql/transport/query.html

http://openuplabs.tso.co.uk/sparql/gov-transport

Requêtes SPARQL

  • Select a stop on Scotland Road, Liverpool

PREFIX naptan: <http://transport.data.gov.uk/def/naptan/>

SELECT ?stop WHERE {
?stop a naptan:StopPoint;
naptan:town « LIVERPOOL »;
naptan:street « SCOTLAND ROAD » .
}

Result : $stop <http://transport.data.gov.uk/id/stop-point/2800S40063G>

 

  • List of OnStreetStopPoints on Scotland Road

PREFIX naptan: <http://transport.data.gov.uk/def/naptan/>
SELECT distinct * WHERE {
?stop a naptan:OnStreetStopPoint;
naptan:street « Scotland Road »;
naptan:naptanCode ?code.
}
LIMIT 15

Result:

$stop	$code
<http://transport.data.gov.uk/id/stop-point/090033102441>	"cumapapt"^^<http://transport.data.gov.uk/def/naptan/NaptanCode>
<http://transport.data.gov.uk/id/stop-point/090033102481>	"cumapdgp"^^<http://transport.data.gov.uk/def/naptan/NaptanCode>
<http://transport.data.gov.uk/id/stop-point/2500LAA07400>	"lanjpawj"^^<http://transport.data.gov.uk/def/naptan/NaptanCode>
<http://transport.data.gov.uk/id/stop-point/090033102821>	"cumapjpw"^^<http://transport.data.gov.uk/def/naptan/NaptanCode>
<http://transport.data.gov.uk/id/stop-point/2500DCL5747>	"landmpmj"^^<http://transport.data.gov.uk/def/naptan/NaptanCode>
<http://transport.data.gov.uk/id/stop-point/090033102148>	"cumamwjw"^^<http://transport.data.gov.uk/def/naptan/NaptanCode>
<http://transport.data.gov.uk/id/stop-point/2500811>	"landadma"^^<http://transport.data.gov.uk/def/naptan/NaptanCode>
<http://transport.data.gov.uk/id/stop-point/090033101368>	"cumampjp"^^<http://transport.data.gov.uk/def/naptan/NaptanCode>
<http://transport.data.gov.uk/id/stop-point/090033102490>	"cumapdjp"^^<http://transport.data.gov.uk/def/naptan/NaptanCode>
<http://transport.data.gov.uk/id/stop-point/090033101932>	"cumamtma"^^<http://transport.data.gov.uk/def/naptan/NaptanCode>
<http://transport.data.gov.uk/id/stop-point/069000024330>	"wrgmdmw"^^<http://transport.data.gov.uk/def/naptan/NaptanCode>
<http://transport.data.gov.uk/id/stop-point/069000024320>	"wrgmdpa"^^<http://transport.data.gov.uk/def/naptan/NaptanCode>
<http://transport.data.gov.uk/id/stop-point/069000024340>	"wrgmdmt"^^<http://transport.data.gov.uk/def/naptan/NaptanCode>
<http://transport.data.gov.uk/id/stop-point/090074560826>	"cumdawpm"^^<http://transport.data.gov.uk/def/naptan/NaptanCode>
<http://transport.data.gov.uk/id/stop-point/0800COD41429>	"coratwma"^^<http://transport.data.gov.uk/def/naptan/NaptanCode>

 

 

Authors:

Wei JIANG

Hongcheng LIU

Yabing JU

Sining QU

Ce contenu a été publié dans Web Sémantique. Vous pouvez le mettre en favoris avec ce permalien.

Laisser un commentaire

Votre adresse de messagerie ne sera pas publiée. Les champs obligatoires sont indiqués avec *