User:Geertivp/training/Wikidata/Wiki projects

Wiki projects are typically setup by chapters or user groups, in collaboration with partners.

Wikidata can be a handy tool and database to keep an inventory of items linked to the project, and helps to integrate and link Wikidata, Wikipedia, and Wikimedia Commons.

Supporting tools for Wikidata (for update) are OpenRefine, QuickStatements, and (read-only) ListeriaBot and Wikidata Query.

Images can be uploaded by a Wikimedia Commons campaign.

On Wikimedia Commons, images can be documented through Structured Data on Commons (SDoC), and e.g. the ISA Tool or AC/DC.

The Campaign and events tool can be used for user registration, automatic edit tracking, and project management.

Wikidata Query can be used for detailed project reporting purposes (flat lists, geospatial, hierarchical, linked).

AutoWikiBrowser (AWB), PetScan, Mix'n'match, and WDFIST can be used to amend Wikipedia pages, and Wikidata.

Lists of pages, or Q-numbers can be fed into Pywikibot programs, that can automatically update Wikidata items, statements, and Wiki page links.

History

Traditionally, Wiki projects, and edit-a-thons, were organised with non-integrated tools, often based on external, closed tools like Excel or Google Spreadsheets, and much personal effort.

Volunteers were confused, project teams needed to perform too many manual tasks, and the results where sub-optimal.

Therefore a Linked Open Data solution is much appreciated, available online for the community, well integrated and documented on the Wikimedia platforms, and can be easily used both by project teams, volunteers, and institutions, with a minimum of investment and a maximum result.

Nothing needs to be locally installed by the user (except AWB), all tools are online available, and supported by a Wikimedia single sign-on.

Most tools are available for all users, and are multilingual. For some tools like AWB, Pywikibot, and Wikimedia Commons campaigns, additional rights needs to be requested.

Data model for a Wikidata-centered project

The project is the central item in Wikidata, where other items can be interconnected through properties.

• Projects are identified by Property:P31 WikiProject (Q16695773)
• Projects are organised by one or more chapters via organizer (P664) (like) Wikimedia Belgium (Q18398868)
• One or more partners can participate to a project via participant (P710)
  • A partner can participate to multiple projects
• Items (we want to describe in Wikidata and write Wikipedia articles) are linked to projects via maintained by WikiProject (P6104)
  • Items can be linked to multiple projects
  • Items can have zero or more Wikipedia pages (red and blue links, depending on the language)
  • Wikimedia Commons objects can be linked to a Wikidata items:
    • via image (P18) in Wikidata
    • via Wikimedia Commons categories, using the {{Wikidata Infobox}}

This way, e.g. Wikipedia pages can be linked to a Wiki project, and a ListeriaBot query can automatically generate a table of created and missing pages per language; image (P18) can show a picture.

Functionality

• Items can be created with OpenRefine, QuickStatements, or manually
• Volunteers can amend the items
• Wikipedia pages can be written or amended (manually, or semi-automatically with AWB)
• Photographs can be linked or added
• Multiple maintenance tools can be used (see above)
• A query could be run to identify items without images (image (P18) can be part of the ListeriaBot query)
• Project leaders can report on the status, coaches can follow-up and assist the participants

Project queries

Inventory of projects

Get a list of Wiki projects for a chapter.

The following query uses these:

• Items: WikiProject (Q16695773)   , Wikimedia Belgium (Q18398868)   

• Properties: instance of (P31)   , organizer (P664)   

  # Get all projects by WMBE (Wikimedia Belgium)
  SELECT ?wikiproject ?wikiprojectLabel WHERE {
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    ?wikiproject wdt:P31 wd:Q16695773.
    ?wikiproject wdt:P664 wd:Q18398868.
  }
  

Try it!

Missing language labels for items

Identify items with missing language labels.

The following query uses these:

• Items: human (Q5)   , WikiProject (Q16695773)   , Wikimedia Belgium (Q18398868)   

• Properties: maintained by WikiProject (P6104)   , instance of (P31)   , organizer (P664)   

  # Get all items linked to WMBE WikiProjects that have missing labels
  SELECT distinct ?item WHERE {
    ?item wdt:P6104 ?wikiproject;
      wdt:P31 wd:Q5.
    ?wikiproject wdt:P31 wd:Q16695773;
      wdt:P664 wd:Q18398868.
    MINUS {
      ?item rdfs:label ?label.
      FILTER((LANG(?label)) = "da")
    }
  }
  

Try it!

The list of Q-numbers can be fed into a Pywikibot program to add the missing labels.

Example projects

• Wikimedia Belgium Wiki projects:
  • (en) Wiki Women Design (2020-2021) - ListeriaBot
  • (nl) Erfgoedcel Pajottenland Zennevallei - ListeriaBot
  • (fr) La Cambre Horta - ListeriaBot
• Wiki Women Design upload campaign (Wikimedia Commons)