Wikidata:WikiProject PCC Wikidata Pilot/UC Davis/Organizations

The plan for UC Davis Organizations is to standardize the Data Model used for campus entities, verify these entities are accurate, complete missing items, provide provenance and develop a plan for updating these records.

Secondarily, we will look at the prospect of enhancing the campus' Wikidata presence with auto updated pages from wikidata.

TimeLine

We will work from the top down, starting with Colleges, and moving to Divisions, Departments. This will be followed with Research Units and Key facilitties.

Informational Queries

This query shows items that are part of UCD, and are a type of organization

The following query uses these:

• Items: University of California, Davis (Q129421)   , organization (Q43229)   

• Properties: part of (P361)   , instance of (P31)   , subclass of (P279)   

  SELECT ?item
  WHERE {
   ?item  wdt:P361 wd:Q129421;
      wdt:P31/wdt:P279* wd:Q43229.
  }
  

Try it!

This next query shows the types of instances for these organizations. Remember, a single item has multiple instanceOf P31 predicates.

The following query uses these:

• Items: University of California, Davis (Q129421)   , organization (Q43229)   

• Properties: part of (P361)   , instance of (P31)   , subclass of (P279)   

  SELECT ?instance ?instanceLabel ?cnt WHERE {
    {  SELECT ?instance (count(*) as ?cnt) WHERE {  
       ?item  wdt:P361 wd:Q129421;
          wdt:P31/wdt:P279* wd:Q43229;
          wdt:P31 ?instance;
          .
       } GROUP BY ?instance ?instanceLabel 
    }                     
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  } order by desc(?cnt)
  

Try it!