query-9c6cc86c06ca077985686dbb59c7e1be

rq turtle/ttl

NJ State Senate Map

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#defaultView:Map
SELECT DISTINCT ?item ?itemLabel ?district ?districtLabel ?shape (SAMPLE(?image) AS ?image) ?group ?groupLabel (IF((MIN(?groupID)) = "0", "Republican", IF((MIN(?groupID)) = "1", "Democrat", "Other")) AS ?layer) WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  ?item p:P39 ?rep.
  ?rep ps:P39 wd:Q19385767;
    pq:P2937 wd:Q65087533;
    pq:P768 ?district.
  ?district wdt:P3896 ?shape.
  ?rep pq:P4100 ?group.
  BIND(IF(?group = wd:Q29468, "0", IF(?group = wd:Q29552, "1", "2")) AS ?groupID)
}
GROUP BY ?item ?itemLabel ?layer ?district ?districtLabel ?shape ?image ?group ?groupLabel

Query found at