query-461b6125b3bbbc04a2155e953778d9ac

rq turtle/ttl

country (P17),  location (P276),  located in the administrative territorial entity (P131),  image (P18),  instance of (P31): PropertiesDeveloping enhanced map query:

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
#defaultView:Map
SELECT DISTINCT  (?foundingEra as ?layer) ?socLabel ?soc ?coord ?socBegan ?socLocQ WHERE {  
 { {?soc wdt:P31 wd:Q12160242 } UNION {  ?soc wdt:P31 wd:Q1797187 } }  .
  { ?soc wdt:P571 ?socBegan; BIND(IF(BOUND(?socBegan),year(?socBegan),1945) AS ?socBeganYr). }. 
  optional {?soc rdfs:label ?socLabel. FILTER(LANG(?socLabel) = "en").}.
  BIND( IF (?socBeganYr < 1800, "1 pre-1800", IF (?socBeganYr < 1850, "2 pre-1850", IF (?socBeganYr < 1900, "3 pre-1900", IF (?socBeganYr < 1915, "4 pre-WW1", 
                        IF (?socBeganYr < 1946, "5 inter-war", IF (?socBeganYr < 1990, "6 Post WW2", "7 Recent")))))) AS ?foundingEra).
  optional { ?soc wdt:P131 ?socLocAQ. ?socLocAQ wdt:P625 ?coord. } .
  optional { ?soc wdt:P740 ?socLocFQ. ?socLocFQ wdt:P625 ?coord. } .
  optional { ?soc wdt:P276 ?socLocPQ. ?socLocPQ wdt:P625 ?coord.} .
  optional { ?soc wdt:P937 ?socLocWLQ. ?socLocWLQ wdt:P625 ?coord. } .
  optional { ?soc wdt:P17 ?socCountryQ. ?socCountryQ wdt:P625 ?coord. } .
  BIND(IF(BOUND(?socLocPQ),?socLocPQ,?socLocAQ) AS ?socLocQ).
  BIND(IF(BOUND(?socLocQ),?socLocQ,?socLocFQ) AS ?socLocQ).
  BIND(IF(BOUND(?socLocQ),?socLocQ,?socLocWLQ) AS ?socLocQ).
  BIND(IF(BOUND(?socLocQ),?socLocQ,?socCountryQ) AS ?socLocQ).
} LIMIT 900

Query found at