https://ebike.bitplan.com/index.php?action=history&feed=atom&title=NorthernSpain 2026-04-08T09:13:44Z Revision history for this page on the wiki MediaWiki 1.35.5 https://ebike.bitplan.com/index.php?title=NorthernSpain&diff=4982&oldid=prev 2025-01-20T20:43:30Z

<p>Created page with &quot;&lt;source lang=&#039;sparql&#039;&gt; # 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: &lt;ht...&quot;</p> <p><b>New page</b></p><div>&lt;source lang='sparql'&gt;<br /> # truly tabular naive query for <br /> # Q162620:province of Spain<br /> # generated by trulytabular.py version 0.12.4 on 2025-01-20T20:37:36.047515<br /> PREFIX rdf: &lt;http://www.w3.org/1999/02/22-rdf-syntax-ns#&gt;<br /> PREFIX rdfs: &lt;http://www.w3.org/2000/01/rdf-schema#&gt;<br /> PREFIX schema: &lt;http://schema.org/&gt;<br /> PREFIX wd: &lt;http://www.wikidata.org/entity/&gt;<br /> PREFIX wdt: &lt;http://www.wikidata.org/prop/direct/&gt;<br /> PREFIX wikibase: &lt;http://wikiba.se/ontology#&gt;<br /> PREFIX xsd: &lt;http://www.w3.org/2001/XMLSchema#&gt;<br /> <br /> SELECT ?province_of_SpainItem ?province_of_Spain<br /> ?coordinate_location<br /> ?ISO_3166_2_code<br /> ?OpenStreetMap_relation_ID<br /> WHERE {<br /> # instanceof Q162620:province of Spain<br /> ?province_of_SpainItem wdt:P31 wd:Q162620.<br /> # label<br /> ?province_of_SpainItem rdfs:label ?province_of_Spain. <br /> FILTER (LANG(?province_of_Spain) = &quot;en&quot;).<br /> # coordinate location (P625)<br /> OPTIONAL { <br /> ?province_of_SpainItem wdt:P625 ?coordinate_location.<br /> # Extract latitude and longitude<br /> BIND(geof:latitude(?coordinate_location) AS ?latitude).<br /> BIND(geof:longitude(?coordinate_location) AS ?longitude).<br /> }<br /> # ISO 3166-2 code (P300)<br /> OPTIONAL { <br /> ?province_of_SpainItem wdt:P300 ?ISO_3166_2_code. <br /> }<br /> # OpenStreetMap relation ID (P402)<br /> OPTIONAL { <br /> ?province_of_SpainItem wdt:P402 ?OpenStreetMap_relation_ID. <br /> }<br /> # Filter for northern and central bounding box<br /> FILTER (?latitude &gt; 42.0) # Northern Spain<br /> FILTER (?longitude &gt; -7.0 &amp;&amp; ?longitude &lt; -1.0) # Central Spain by longitude<br /> }<br /> &lt;/source&gt;</div>

Wf