{"id":950,"date":"2023-01-09T22:29:34","date_gmt":"2023-01-09T20:29:34","guid":{"rendered":"http:\/\/tuijasonkkila.fi\/?p=950"},"modified":"2024-09-20T13:14:32","modified_gmt":"2024-09-20T10:14:32","slug":"station-to-station","status":"publish","type":"post","link":"https:\/\/tuijasonkkila.fi\/?p=950","title":{"rendered":"Station to station"},"content":{"rendered":"\n<p>While slowly going through the Wikidata SPARQL <a href=\"https:\/\/www.wikidata.org\/wiki\/Wikidata:SPARQL_query_service\/qotw\/2022\">query examples of last year<\/a> I ran across <a href=\"https:\/\/w.wiki\/4xyY\">this one<\/a> which draws the shortest railway link between Narvik, Norway, and Singapore. Amazing, really. What was also interesting to find out that still in October 2021, <a href=\"https:\/\/twitter.com\/LibrErli\/status\/1451528085833195546\">the route went via Sweden<\/a>. I&#8217;m not that inclined in train networks but AFAIK the opening of Lule\u00e5-Haparanda track in the beginning of April 2021 changed this route also in Wikidata, eventually. <\/p>\n\n\n\n<p>The news came from <a href=\"https:\/\/twitter.com\/jbenedictbrown\/status\/1377500696694697986\">a tweet<\/a> by James Benedict Brown, Associate Professor of Architecture at Ume\u00e5 University. His travel stories are nice reading. For example, <a href=\"https:\/\/threadreaderapp.com\/thread\/1536544270588452864.html\">here is a thread<\/a> on how he and his students traveled in Finland at ground level in summer 2022. Recently, he <a href=\"https:\/\/mastodon.nu\/@jamesbenedictbrown\/109613217522173289\">announced <\/a>in Mastodon, that early next spring, the target will be Athens. Having the above-mentioned SPARQL query at hand, I asked Wikidata to draw me the shortest route from Ume\u00e5 to Athens.<\/p>\n\n\n\n<p>The return was 0. Wikidata does not know about a consecutive line of adjacent railway stations between these two cities. How far, in the direction of Athens, does it know these stations then? Inside the borders of Greece , one of the last stations with a clear, labelled indication of a preceding station is <a href=\"https:\/\/en.wikipedia.org\/wiki\/Didymoteicho_railway_station\">Didymoteicho<\/a> near the Turkish border. From that station on towards Athens, the route quickly stagnates. You can run the query <a href=\"https:\/\/query.wikidata.org\/#%23%20Source%20https%3A%2F%2Fwww.wikidata.org%2Fwiki%2FWikidata%3ASPARQL_query_service%2Fqotw%2F2022%23March%20%22Shortest%20rail%20link%20between%20Narvik%20and%20Singapore%22%0A%23defaultView%3AMap%0ASELECT%20%3Fstation%20%3FstationLabel%20%3Fcds%20%3Fline%20%3Flayer%20WHERE%20%7B%20%0A%20%20%7B%20SERVICE%20gas%3Aservice%20%7B%0A%20%20%20%20%20%20%20gas%3Aprogram%20gas%3AgasClass%20%22com.bigdata.rdf.graph.analytics.BFS%22%20%3B%20%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3Ain%20wd%3AQ3374603%20%3B%20%23%20Ume%C3%A5%20central%20station%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3Atarget%20wd%3AQ18337797%20%3B%20%23%20Didymoteicho%20railway%20station.%20From%20here%20on%2C%20adjacent%20stations%20rapidly%20vanish%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3Aout%20%3Fstation%20%3B%20%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3Aout1%20%5B%5D%20%3B%20%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3Aout2%20%3Fpred%20.%0A%20%20%20%20%20%20%20gas%3Aprogram%20gas%3AlinkType%20wdt%3AP197%20.%20%7D%20%23%20adjacent%20station%0A%20%20%7D%0A%20%20FILTER%28%3Fstation%20%21%3D%20wd%3AQ3374603%29%20%0A%20%20%3Fpred%20p%3AP625%2Fpsv%3AP625%2Fwikibase%3AgeoLatitude%20%3Flat1%20%3B%20%0A%20%20%20%20%20%20%20%20p%3AP625%2Fpsv%3AP625%2Fwikibase%3AgeoLongitude%20%3Flon1%20.%0A%20%20%3Fstation%20p%3AP625%2Fpsv%3AP625%2Fwikibase%3AgeoLatitude%20%3Flat2%20%3B%20%0A%20%20%20%20%20%20%20%20%20%20%20p%3AP625%2Fpsv%3AP625%2Fwikibase%3AgeoLongitude%20%3Flon2%20.%0A%20%20BIND%28CONCAT%28%27LINESTRING%28%27%2C%20STR%28%3Flon1%29%2C%20%27%20%27%2C%20STR%28%3Flat1%29%2C%20%27%2C%27%2C%20STR%28%3Flon2%29%2C%20%27%20%27%2C%20STR%28%3Flat2%29%2C%20%27%29%27%29%20AS%20%3Fstr%29%20.%20%0A%20%20BIND%28STRDT%28%3Fstr%2C%20geo%3AwktLiteral%29%20AS%20%3Fline%29%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D%0A\">here<\/a> Click the big Run\/Play button. The query takes a few seconds to complete. <\/p>\n\n\n\n<p>(I couldn&#8217;t help choosing the title, thank you <a href=\"https:\/\/en.wikipedia.org\/wiki\/Station_to_Station\">Bowie<\/a>.)<br><\/p>\n\n\n\n<p><br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>While slowly going through the Wikidata SPARQL query examples of last year I ran across this one which draws the shortest railway link between Narvik, Norway, and Singapore. Amazing, really. What was also interesting to find out that still in October 2021, the route went via Sweden. I&#8217;m not that inclined in train networks but &hellip; <a href=\"https:\/\/tuijasonkkila.fi\/?p=950\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Station to station<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[149],"tags":[15,145],"class_list":["post-950","post","type-post","status-publish","format-standard","hentry","category-diverse-coding","tag-sparql","tag-wikidata"],"_links":{"self":[{"href":"https:\/\/tuijasonkkila.fi\/index.php?rest_route=\/wp\/v2\/posts\/950","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tuijasonkkila.fi\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tuijasonkkila.fi\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tuijasonkkila.fi\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tuijasonkkila.fi\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=950"}],"version-history":[{"count":2,"href":"https:\/\/tuijasonkkila.fi\/index.php?rest_route=\/wp\/v2\/posts\/950\/revisions"}],"predecessor-version":[{"id":952,"href":"https:\/\/tuijasonkkila.fi\/index.php?rest_route=\/wp\/v2\/posts\/950\/revisions\/952"}],"wp:attachment":[{"href":"https:\/\/tuijasonkkila.fi\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=950"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tuijasonkkila.fi\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=950"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tuijasonkkila.fi\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=950"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}