query-625426dfacb135b436cf99fb056968ce

rq turtle/ttl

Find all mineral type localities that are meteorites and sort them by defined minerals SELECT ?locality ?name (COUNT(DISTINCT ?mineral) AS ?count) WHERE { ?mineral wdt:P579 ?status . ?mineral wdt:P2695 ?locality . # Where a locality statement exists ?locality wdt:P31 ?thing . # Where the locality is the instance of a thing (helper) ?thing wdt:279* wd:Q60186 . # And the thing is in the subclass tree of meteorite (Should also work if p31 = iron meteorite for example)

SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en" .
    ?locality rdfs:label ?name
}

} GROUP BY ?locality ?name ORDER BY DESC(?count)

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
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#>
PREFIX bd: <http://www.bigdata.com/rdf#>
# Find all mineral type localities that are meteorites and sort them by defined minerals
SELECT ?locality ?name (COUNT(DISTINCT ?mineral) AS ?count)
WHERE
{
    ?mineral wdt:P579 ?status .
    ?mineral wdt:P2695 ?locality .    # Where a locality statement exists
    ?locality wdt:P31 ?thing .        # Where the locality is the instance of a thing (helper)
    ?thing wdt:279* wd:Q60186 .       # And the thing is in the subclass tree of meteorite (Should also work if p31 = iron meteorite for example)

    SERVICE wikibase:label {
        bd:serviceParam wikibase:language "en" .
        ?locality rdfs:label ?name
    }
}
GROUP BY ?locality ?name
ORDER BY DESC(?count)

Query found at

• https://www.wikidata.org/wiki/Wikidata:WikiProject_Mineralogy/Queries