query-b86b3d41076c22d5c50061f16bf7b3e6

rq turtle/ttl

title: The northernmost city in Africa SELECT ?x ?xLabel ?latitude ?longitude WITH {

select all the cities in a continent

SELECT ?x WHERE { ?x wdt:P31/wdt:P279* wd:Q515 . # x is a type of city (big city, city state etc) ?x wdt:P17 ?country . ?country wdt:P30 wd:Q15 . # <== put the continent here MINUS { ?country wdt:P31 wd:Q3024240 } # current countries only } } AS %cities

get each city's latitude/longitude

sort depending on east/west or north/south

select the first one

WHERE { INCLUDE %cities ?x p:P625 [ psv:P625 [ wikibase:geoLatitude ?latitude ; wikibase:geoLongitude ?longitude ; ] ]
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
ORDER BY DESC (?latitude) # ASC for southernmost; DESC for northernmost

ORDER BY ASC (?longitude) # ASC for westernmost; DESC for easternmost

LIMIT 1

Use at

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

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 p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title: The northernmost city in Africa
SELECT ?x ?xLabel ?latitude ?longitude  
# get each city's latitude/longitude
# sort depending on east/west or north/south
# select the first one
WHERE {
   {

# select all the cities in a continent
SELECT ?x WHERE {
  ?x wdt:P31/wdt:P279* wd:Q515 . # x is a type of city (big city, city state etc)
  ?x wdt:P17 ?country .
  ?country wdt:P30 wd:Q15 .  # <== put the continent here
  MINUS { ?country wdt:P31 wd:Q3024240 } # current countries only
} }  ?x p:P625 [
    psv:P625 [
    wikibase:geoLatitude ?latitude ; 
    wikibase:geoLongitude ?longitude ;
      ]
    ]          
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}     
ORDER BY DESC (?latitude)      # ASC for southernmost; DESC for northernmost
#ORDER BY ASC (?longitude)      # ASC for westernmost; DESC for easternmost
LIMIT 1

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2021/07