Passenger transport modal split, 2012
Data table via SPARQL
Published 24 Sep 2014
Last modified 20 Apr 2016
Download this dataset
Dataset preview
(Live Query)
Received 35 rows in 0.003 seconds.
https://www.eea.europa.eu/data-and-maps/daviz/sds/passenger-transport-modal-split-1/daviz.json
For system integrators
The following info can be used by a system developer / database administrator in order to retrieve this dataset programmatically over the web using a SPARQL client.
http://semantic.eea.europa.eu/sparql
#http://www.eea.europa.eu/data-and-maps/figures/passenger-transport-modal-split-without-1#
PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-attribute: <http://purl.org/linked-data/sdmx/2009/attribute#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#>
PREFIX unit: <http://rdfdata.eionet.europa.eu/eurostat/dic/unit#>
PREFIX geo: <http://rdfdata.eionet.europa.eu/eurostat/dic/geo#>
PREFIX vehicle: <http://dd.eionet.europa.eu/vocabulary/eurostat/vehicle/>
SELECT
year(?date) as ?year
bif:either (?geo = 'DE', 'Germany', ?country) as ?country
sum(xsd:decimal(?valueCAR)) as ?Car
sum(xsd:decimal(?valueTRN)) as ?Train
sum(xsd:decimal(?valueBUS_TOT)) as ?Bus
WHERE {
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/tran_hv_psmod.rdf.gz> {
_:tran_hv_psmod sdmx-dimension:timePeriod ?date . FILTER (year(?date) = 2012)
_:tran_hv_psmod property:geo ?ugeo .
{ _:tran_hv_psmod property:vehicle vehicle:BUS_TOT, _:l .
_:tran_hv_psmod sdmx-measure:obsValue ?valueBUS_TOT .
} UNION {
_:tran_hv_psmod property:vehicle vehicle:CAR, _:l .
_:tran_hv_psmod sdmx-measure:obsValue ?valueCAR .
} UNION {
_:tran_hv_psmod property:vehicle vehicle:TRN, _:l .
_:tran_hv_psmod sdmx-measure:obsValue ?valueTRN .
}
}
?ugeo skos:notation ?geo .
?ugeo skos:prefLabel ?country .
}
group by ?date ?ugeo ?geo ?country
order by DESC(?Car)
Related content
Visualisations produced
Permalinks
- Permalink to this version
- 374adfd4309e478e917992435568c4c6
- Permalink to latest version
- 9GCP40KXVI
Older versions
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/passenger-transport-modal-split-1 or scan the QR code.
PDF generated on 20 May 2019, 05:11 AM
Document Actions
Share with others