Wikidata:WikiProject PCC Wikidata Pilot/UC Davis/Faculty

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

Existing Items

The Tabernacle Interface is a good way to compare the existing labels for the organizations already in wikidata.

Professors

Employees

Search for Employees First

Trying to search forward for persons with their names is frustrating...

The following query uses these:

• Items: professor (Q121594)   , University of California, Davis (Q129421)   , human (Q5)   

• Properties: employer (P108)   , family name (P734)   , given name (P735)   , ORCID iD (P496)   

  SELECT distinct ?last_nameLabel ?personLabel ?personDescription ?qid ?orcid
  WHERE {
    BIND(wd:Q121594 as ?prof).
    VALUES(?from) {
     (wdt:P108)
      }
     ?person ?from wd:Q129421  ;
             ?P31 wd:Q5;
         wdt:P734 ?last_name;
      bind(replace(STR(?person),"http://www.wikidata.org/entity/","") AS ?qid)         
     OPTIONAL { ?person wdt:P735 ?first_name. }
     OPTIONAL { ?person wdt:P496 ?orcid.}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  } order by ?last_nameLabel ?first_nameLabel
  

Try it!

Discovery Query

Trying to search forward for persons with their names is frustrating...

The following query uses these:

• Items: human (Q5)   , University of California, Davis (Q129421)   

• Properties: instance of (P31)   , family name (P734)   , native label (P1705)   , given name (P735)   , employer (P108)   

  SELECT distinct ?lname ?fname ?person ?personLabel ?ucd
    WITH { SELECT distinct ?person ?lname ?fname WHERE {
        VALUES (?fname ?lname) {
  ("Ursula" "Abbott")
  ("Norman" "Akesson")
  ("Henry" "Alder")
  ("V." "Algazi")
  ("R." "Allard")
  ("Thomas" "Allen")
  ("Maynard" "Amerine")
  ("David" "Anderson")
  ("Gary" "Anderson")
  ("Lawrence" "Andrews")
  ("Samuel" "Armistead")
  ("Floyd" "Ashton")
  ("Daniel" "Axelrod")
  ("John" "Ayer")
  ("Oscar" "Bacon")
  ("R." "Baldwin")
  ("Michael" "Barbour")
  ("David" "Barnette")
  ("Edward" "Barrett")
  ("Donald" "Bath")
  ("Arnold" "Bauer")
  ("Herbert" "Bauer")
        }
      bind(concat(?fname," ",?lname) as ?s)
      SERVICE wikibase:mwapi {
        bd:serviceParam wikibase:endpoint "www.wikidata.org";
                      wikibase:api "Generator";
                      mwapi:generator "search";
                      mwapi:gsrsearch ?s;
                      mwapi:gsrlimit "max".
       ?person wikibase:apiOutputItem mwapi:title.
     } } } as %SEARCH {
      include %SEARCH .
    hint:Query hint:optimizer "None".
              
    ?person wdt:P31 wd:Q5;
            wdt:P734/wdt:P1705 ?ln;
            wdt:P735/wdt:P1705 ?fn;
            .
    filter(xsd:string(?ln) = ?lname)
    filter(xsd:string(?fn) = ?fname)
    OPTIONAL {
      bind(wd:Q129421 as ?ucd)
      ?person wdt:P108 ?ucd.
      }
     SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  } order by ?lname ?fname ?person
  

Try it!