Project:SPARQL/examples

Grama Panchayaths

Grama Panchayaths in Kerala by district

This query looks at all items whose value of P2 is Q24 and P4 is Q1. It uses the service wikibase:label to return the labels in your default language or in English.

PREFIX wd: <https://opendatakerala.wikibase.cloud/entity/>
PREFIX wdt: <https://opendatakerala.wikibase.cloud/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?ilen ?ilml ?district ?districtLabel ?SEC_Kerala_code ?LSG_localbody_code WHERE {
  ?item wdt:P2 wd:Q24;
    (wdt:P4*) wd:Q1.
  OPTIONAL {
    ?item rdfs:label ?ilml.
    FILTER((LANG(?ilml)) = "ml")
    ?item rdfs:label ?ilen.
    FILTER((LANG(?ilen)) = "en")
  }
  OPTIONAL { ?item <https://opendatakerala.wikibase.cloud/prop/direct/P5> ?district. }
  OPTIONAL { ?item <https://opendatakerala.wikibase.cloud/prop/direct/P21> ?SEC_Kerala_code. }
  OPTIONAL { ?item <https://opendatakerala.wikibase.cloud/prop/direct/P20> ?LSG_localbody_code. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

Wards in Kerala

Wards in Kerala from OSM

#defaultView:Map
PREFIX osmt: <https://wiki.openstreetmap.org/wiki/Key:>
PREFIX osmm: <https://www.openstreetmap.org/meta/>
PREFIX osmrel: <https://www.openstreetmap.org/relation/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX odwb: <https://opendatakerala.wikibase.cloud/entity/>
PREFIX odwbt: <https://opendatakerala.wikibase.cloud/prop/direct/>
SELECT DISTINCT ?item ?ward_name ?wikidataLink ?loc ?osmId
WHERE {
  ?item odwbt:P2 odwb:Q23;
        (odwbt:P5/odwbt:P4*) odwb:Q1;
        odwbt:P17 ?wikidata .
   SERVICE <https://sophox.org/sparql> {
    ?osmId osmt:wikidata ?wikidataLink ;
           osmt:admin_level "10" ;
           osmt:name ?ward_name ;
           osmm:loc ?loc ;
           osmm:type "r".
  }
  BIND(IRI(CONCAT("http://www.wikidata.org/entity/", ?wikidata)) AS ?wikidataLink)
}

Try it!