Daniel-Mietchen / ideas

A dumping ground for halfbaked ideas, some of which will hopefully be worked on soon
Other
26 stars 6 forks source link

Think about proposing a Wikidata property for "Maintenance query" #1134

Open Daniel-Mietchen opened 5 years ago

Daniel-Mietchen commented 5 years ago

e.g. this query can be used to curate items about earthquake-related publications:


SELECT DISTINCT ?item #?title
WHERE {
  hint:Query hint:optimizer "None".
{  SERVICE wikibase:mwapi {
    bd:serviceParam wikibase:api "Search";
                    wikibase:endpoint "www.wikidata.org";
                    mwapi:srsearch "earthquake and haswbstatement:P31=Q13442814".
    ?page_title wikibase:apiOutput mwapi:title.
  }
}
UNION
{  SERVICE wikibase:mwapi {
    bd:serviceParam wikibase:api "Search";
                    wikibase:endpoint "www.wikidata.org";
                    mwapi:srsearch "earthquake -and haswbstatement:P31=Q13442814".
    ?page_title wikibase:apiOutput mwapi:title.
  }
}
  BIND(IRI(CONCAT(STR(wd:), ?page_title)) AS ?item)
  FILTER NOT EXISTS { ?item wdt:P921 [ wdt:P31*/wdt:P279* wd:Q7944]. }

  ?item wdt:P31 wd:Q13442814;
        wdt:P1476 ?title.
  FILTER CONTAINS(LCASE(?title), "earthquake").
}
#LIMIT 1000

It would be good to have that represented somewhere as structured information in WIkidata, either via a dedicated property or via dedicated items.

Some relevant existing properties:

Daniel-Mietchen commented 5 years ago

A sample batch with the above query is at https://tools.wmflabs.org/quickstatements/#/batch/8252 .