query-e3e128447d20995d0846aa4c3f678693

rq turtle/ttl

land borders of current countries in descending order of length SELECT DISTINCT ?item ?itemLabel ?c1Label ?c2Label ?len ?lenUnitLabel ?normalised WHERE { ?item wdt:P31 wd:Q12413618 . # international border ?item wdt:P31 wd:Q15104814 . # land border

# countries ?item wdt:P17 ?c1. ?item wdt:P17 ?c2.

# show each border only once BIND (xsd:integer(substr(str(?c1), 33)) as ?c1Num). BIND (xsd:integer(substr(str(?c2), 33)) as ?c2Num). filter(?c1Num < ?c2Num )

# border length and unit ?item wdt:P2043 ?len. ?item p:P2043 ?lenStat . ?lenStat psv:P2043 ?valuenode. optional {?valuenode wikibase:quantityUnit ?lenUnit}

?lenStat psn:P2043 ?lenNorm. ?lenNorm wikibase:quantityAmount ?normalised . # get normalised length value

?lenStat ps:P2043 ?len . # make sure the statement we are using has the same value as the one returned by wdt, ie is best available

# lack of end time means current optional {?item wdt:P582 ?endTime}. filter(?c1 != ?c2 && !bound(?endTime) ) SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } order by desc(?len)

Use at

• https://query.wikidata.org/sparql

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX psn: <http://www.wikidata.org/prop/statement/value-normalized/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# land borders of current countries in descending order of length
SELECT DISTINCT ?item ?itemLabel ?c1Label ?c2Label ?len ?lenUnitLabel ?normalised WHERE {
  ?item wdt:P31 wd:Q12413618 . # international border
  ?item wdt:P31 wd:Q15104814 . # land border

  # countries
  ?item wdt:P17 ?c1.
  ?item wdt:P17 ?c2.

  # show each border only once
  BIND (xsd:integer(substr(str(?c1), 33)) as ?c1Num).
  BIND (xsd:integer(substr(str(?c2), 33)) as ?c2Num).
  filter(?c1Num < ?c2Num )

  # border length and unit
  ?item wdt:P2043 ?len.
  ?item p:P2043 ?lenStat .
  ?lenStat psv:P2043 ?valuenode.
  optional {?valuenode wikibase:quantityUnit ?lenUnit}

  ?lenStat psn:P2043 ?lenNorm.
  ?lenNorm wikibase:quantityAmount ?normalised .
  # get normalised length value

  ?lenStat ps:P2043 ?len .
  # make sure the statement we are using has the same value as the one returned by wdt, ie is best available

  # lack of end time means current
  optional {?item wdt:P582 ?endTime}.
  filter(?c1 != ?c2 && !bound(?endTime) )
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
} order by desc(?len)

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2022/11