Quinn.hart
Babel user information | ||||||
---|---|---|---|---|---|---|
| ||||||
Users by language |
I am new to the wikidata community, though I've worked with
linked data in other contexts for awhile now.
Faculty Members
editIn order to do my faculty members, I used this tabernacle query
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:
- 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
Departmental Membership
editLooking 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
DAMS
editHere'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
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
ROR
editWe 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:
- 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) }