NorthernSpain

# truly tabular naive query for 
# Q162620:province of Spain
# generated by trulytabular.py version 0.12.4 on 2025-01-20T20:37:36.047515
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX schema: <http://schema.org/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

SELECT ?province_of_SpainItem ?province_of_Spain
  ?coordinate_location
  ?ISO_3166_2_code
  ?OpenStreetMap_relation_ID
WHERE {
  # instanceof Q162620:province of Spain
  ?province_of_SpainItem wdt:P31 wd:Q162620.
  # label
  ?province_of_SpainItem rdfs:label ?province_of_Spain.  
  FILTER (LANG(?province_of_Spain) = "en").
  # coordinate location (P625)
  OPTIONAL { 
    ?province_of_SpainItem wdt:P625 ?coordinate_location.
    # Extract latitude and longitude
    BIND(geof:latitude(?coordinate_location) AS ?latitude).
    BIND(geof:longitude(?coordinate_location) AS ?longitude).
  }
  # ISO 3166-2 code (P300)
  OPTIONAL { 
    ?province_of_SpainItem wdt:P300 ?ISO_3166_2_code. 
  }
  # OpenStreetMap relation ID (P402)
  OPTIONAL { 
    ?province_of_SpainItem wdt:P402 ?OpenStreetMap_relation_ID. 
  }
  # Filter for northern and central bounding box
  FILTER (?latitude > 42.0) # Northern Spain
  FILTER (?longitude > -7.0 && ?longitude < -1.0) # Central Spain by longitude
}