Quinn.hart

Babel user information

en-N	This user has a native understanding of English.

This user loves Wikidata.

This user uses QuickStatements.

This user reads and edits Wikidata from the command line using wikibase-cli.

I am new to the wikidata community, though I've worked with linked data in other contexts for awhile now.

UC Davis PCC Program edit

Faculty Members edit

In order to do my faculty members, I used this tabernacle query

Selected Professors

I also verified the normal way for National academy members was with the memberOf predicate, where this is the overwhelming use of this object.

The following query uses these:

Items: National Academy of Sciences (Q270794)   , human (Q5)

Properties: instance of (P31)  
```
select ?p  (count(*) as ?cnt) WHERE {
SELECT ?p
WHERE {
  ?s ?p wd:Q270794.
  ?s wdt:P31 wd:Q5.
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} limit 1000
}group by ?p order by ?p
```

Try it!

Departmental Membership edit

Looking at the current usage of how to define the relationship between faculty and their departments, this query looks at the most popular predicates, based on this we are using affiliation (P1416) as our default relationship

The following query uses these:

Items: human (Q5)   , academic department (Q2467461)

Properties: instance of (P31)  
```
select ?p  (count(*) as ?cnt) WHERE {
SELECT *
WHERE {
  ?s ?p ?dept;
     wdt:P31 wd:Q5.
  ?dept wdt:P31 wd:Q2467461.
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} limit 10000
}group by ?p order by desc(?cnt) limit 10
```

Try it!

DAMS edit

Here's an example search trying to find dams that are listed in our digital collections, by searching on the name of the dam.

The following query uses these:

Items: dam (Q12323)

Properties: instance of (P31)   , located in the administrative territorial entity (P131)   , subclass of (P279)  
```
SELECT ?item ?itemLabel ?search ?countyLabel
WHERE {
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

  VALUES ?search {
  'Arroya Seco'
'Barrett'
'Bassano'
'Bear Valley'
'Big Rock Creek'
'Brush Breakwater'
'Capay'
'Clear Lake'
'Cuyamaca'
'Dominici Fill'
'Don Pedro'
'Dye Canon'
'Echo Lake'
'Escondido'
'Exchequer'
'Franklin Canyon'
'Hemet'
'Hodges'
'Indian Hill'
'La Grange'
'La Mesa'
'Laguna'
'Lookout'
'Melones'
'Middle Dam'
'Mockingbird'
'Mockingbird Canyon'
'Moore'
'Morgan Fill'
'New Eastwood'
'Oakdale'
'Old Mission'
'Otay'
'Pacino'
'Rairden Fill'
'Salter'
'San Fernando'
'San Mateo'
'Silver Flat'
'Strawberry Furrow'
'Sweetwater'
'Timber Crib'
'Tujonga'
'Van Giesen'
'Yorba' }

  SERVICE wikibase:mwapi {
      bd:serviceParam wikibase:endpoint "www.wikidata.org";
                      wikibase:api "EntitySearch";
                      mwapi:search ?search;
                      mwapi:language "en".
      ?item wikibase:apiOutputItem mwapi:item.
      ?num wikibase:apiOrdinal true.
  }
#  ?item wdt:P31 wd:Q12323
  ?item wdt:P31 ?type;
        wdt:P131 ?county.
  ?type wdt:P279* wd:Q12323.

} ORDER BY ?search LIMIT 50
```

Try it!

There are other hydrologic types as well, for example spillways.

The following query uses these:

Items: spillway (Q911379)

Properties: instance of (P31)   , located in the administrative territorial entity (P131)   , subclass of (P279)  
```
SELECT ?item ?itemLabel ?countyLabel
WHERE {
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

  ?item wdt:P31 ?type;
        wdt:P131 ?county.
  ?type wdt:P279* wd:Q911379.

} ORDER BY ?itemLabel
```

Try it!

ROR edit

We are interested in how ROR could be extended to provided trusted identifiers for sub-organizations.

Here's a query showing the number of ROR identified organizations that have sub-organizations, and that total count.

The following query uses these:

Items: academic department (Q2467461)

Properties: ROR ID (P6782)   , part of (P361)   , instance of (P31)  
```
select (count(*) as ?cnt) (sum(?org_cnt) as ?tot) WHERE {
SELECT ?org (count(*) as ?org_cnt) 
WHERE {
  ?org wdt:P6782 ?ror_id.
  ?sub wdt:P361 ?org.
#  ?dept wdt:P31 wd:Q2467461.
#   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} group by ?org #order by desc(?org_cnt)
}
```

Try it!