Open main menu

Richard Nevell

Joined 12 July 2015
Babel user information
en-N This user has a native understanding of English.
cs-0 Tento uživatel nerozumí česky (nebo rozumí se značnými problémy).
de-0 Dieser Benutzer beherrscht Deutsch nicht (oder versteht es nur mit beträchtlichen Schwierigkeiten).
Users by language

Worked on:

Will add more to:

Example queriesEdit

UK heritage sitesEdit

Map of scheduled monumentsEdit

The following query uses these:

Features: Map (Q24515275)    

1 #Locations of scheduled monuments (29,115 in total as of September 2019 - vastly under-represented in Wales)
2 #defaultView:Map
3 SELECT ?label ?coord ?subj
4 WHERE {
5    ?subj wdt:P1435 wd:Q219538 ; # scheduled monument
6          wdt:P625 ?coord .
7   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". 
8                          ?subj rdfs:label ?label}
9 }

Map of scheduled monuments without a category on CommonsEdit

The following query uses these:

Features: Map (Q24515275)    

 1 #Locations of scheduled monuments (27,557 in total as of 26 September 2019 - vastly under-represented in Wales)
 2 #defaultView:Map
 3 SELECT ?label ?coord ?subj
 4 WHERE {
 5    ?subj wdt:P1435 wd:Q219538 ; # scheduled monument
 6          wdt:P625 ?coord .
 7   MINUS { ?subj wdt:P373 [] } . # Commons category
 8   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". 
 9                          ?subj rdfs:label ?label}
10 }

Map of scheduled monuments with a category on Commons but no imageEdit

The following query uses these:

Features: Map (Q24515275)    

 1 #Locations of scheduled monuments (150 in total as of 27 September 2019 - vastly under-represented in Wales)
 2 #defaultView:Map
 3 SELECT ?label ?coord ?subj
 4 WHERE {
 5    ?subj wdt:P1435 wd:Q219538 ; # scheduled monument
 6          wdt:P625 ?coord ;
 7          wdt:P373 [] . # Commons category
 8   MINUS { ?subj wdt:P18 [] } . # image
 9   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". 
10                          ?subj rdfs:label ?label}
11 }

Map of listed buildings with a category on Commons but no imageEdit

The following query uses these:

Features: Map (Q24515275)    

 1 #Locations of scheduled monuments (4558 in total as of 27 September 2019)
 2 #defaultView:Map
 3 SELECT ?label ?coord ?subj
 4 WHERE {
 5    ?subj wdt:P1435/wdt:P279* wd:Q570600 ; # listed building
 6          wdt:P625 ?coord ;
 7          wdt:P373 [] . # Commons category
 8   MINUS { ?subj wdt:P18 [] } . # image
 9   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".  
10                          ?subj rdfs:label ?label}
11 }

Castles and archaeologyEdit

Map of archaeological sites in the United KingdomEdit

The following query uses these:

Features: Map (Q24515275)    

1 # UK archaeological site on a map (must have coordinates!)
2 #defaultView:Map
3 SELECT ?library ?libraryLabel ?coords WHERE {
4   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,fr". }
5   ?library (wdt:P31/wdt:P279*) wd:Q839954.
6   ?library wdt:P17 wd:Q145.
7   ?library wdt:P625 ?coords.
8 }


Map of castles in the United KingdomEdit

The following query uses these:

Features: Map (Q24515275)    

1 # Castles on a map (must have coordinates!)
2 #defaultView:Map
3 SELECT ?library ?libraryLabel ?coords WHERE {
4   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,fr". }
5   ?library (wdt:P31/wdt:P279*) wd:Q23413.
6   ?library wdt:P17 wd:Q145.
7   ?library wdt:P625 ?coords.
8 }

Castles per year per countryEdit

The following query uses these:

  • Properties: instance of (P31)    , subclass of (P279)    , inception (P571)    , country (P17)    
     1 #defaultView:BarChart
     2 SELECT (SAMPLE(?year) AS ?year) (COUNT(?_country) AS ?count) (SAMPLE(?_countryLabel) AS ?_countryLabel) WHERE {
     3   ?object wdt:P31/wdt:P279* wd:Q23413. # Castles or subtypes
     4   BIND(STR(YEAR(?_inception)) AS ?year)
     5   ?object wdt:P571 ?_inception;
     6           wdt:P17 ?_country.
     7 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
     8                         ?_country rdfs:label ?_countryLabel. }
     9 }
    10 GROUP BY ?year ?_country
    11 ORDER BY ?_countryLabel
    

Map of slighted placesEdit

The following query uses these:

Features: Map (Q24515275)    

1 #defaultView:Map
2 SELECT * WHERE {
3   ?item wdt:P793 wd:Q2238935;
4         wdt:P625 ?geo .
5 }

Castle studies publicationsEdit

Papers in Chateau Gaillard without the subject of castellologyEdit

The following query uses these:

  • Properties: published in (P1433)    , main subject (P921)    
    1 SELECT ?paper ?paperLabel
    2 WHERE
    3 {
    4     ?paper wdt:P1433 wd:Q27443263 .
    5     MINUS { ?paper wdt:P921 wd:Q2941393 } .
    6 	SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" }
    7 }
    

People most cited by a particular authorEdit

The following query uses these:

  • Properties: author (P50)    , cites work (P2860)    , ORCID iD (P496)    
     1 #defaultView:Table
     2 SELECT
     3   ?count
     4   ?citing_author ?citing_authorLabel
     5 
     6   # Either show the ORCID iD or construct part of a URL to search on the ORCID homepage
     7   (COALESCE(?orcid_, CONCAT("orcid-search/quick-search/?searchQuery=", ENCODE_FOR_URI(?citing_authorLabel))) AS ?orcid)
     8 WITH {
     9   SELECT (COUNT(?citing_work) AS ?count) ?citing_author WHERE {
    10     ?work wdt:P50 wd:Q42712203 .
    11     ?citing_work ^wdt:P2860 ?work . 
    12     MINUS { ?citing_work wdt:P50 wd:Q42712203 }
    13     ?citing_work wdt:P50 ?citing_author .
    14   }
    15   GROUP BY ?citing_author 
    16   ORDER BY DESC(?count)
    17   LIMIT 500
    18 } AS %counts
    19 WITH {
    20   # An author might have multiple ORCID iDs
    21   SELECT
    22     ?count
    23     ?citing_author
    24     (SAMPLE(?orcids) AS ?orcid_)
    25   WHERE {
    26     INCLUDE %counts
    27     OPTIONAL { ?citing_author wdt:P496 ?orcids }
    28   }
    29   GROUP BY ?count ?citing_author
    30 } AS %result
    31 WHERE {
    32   INCLUDE %result
    33   
    34   SERVICE wikibase:label { bd:serviceParam wikibase:language "en,da,de,es,fr,jp,nl,no,ru,sv,zh". }
    35 } 
    36 ORDER BY DESC(?count)
    


Missing authors most cited often by a particular authorEdit

http://w.wiki/3i2

Most-cited author name strings for a given subjectEdit

https://w.wiki/5wU

Journal articles with lots of outgoing citations but few or no topicsEdit

https://w.wiki/6rb

Prolific authors in a journal with VIAF and LCCN IDsEdit

The following query uses these:

  • Properties: author (P50)    , published in (P1433)    , VIAF ID (P214)    , Library of Congress authority ID (P244)    
     1 # Prolific authors for a specific journal
     2 SELECT ?count ?author ?authorLabel ?viaf ?lccn ?example_work ?example_workLabel
     3 WITH {
     4   # Count the number of works author by the author publishing in the journal
     5   SELECT
     6     ?author
     7     (COUNT(?work) AS ?count)
     8     (SAMPLE(?work) AS ?example_work)
     9   WHERE {
    10     ?work wdt:P50 ?author ;
    11           wdt:P1433 wd:Q69499259 .
    12   }
    13   GROUP BY ?author
    14 } AS %result
    15 WHERE {
    16   INCLUDE %result 
    17           
    18   # Include optional ORCID iD
    19   OPTIONAL { ?author wdt:P214 ?viaf . }
    20   OPTIONAL { ?author wdt:P244 ?lccn . }
    21   
    22   # Label the results
    23   SERVICE wikibase:label { bd:serviceParam wikibase:language "en,da,de,es,fr,jp,no,ru,sv,zh" . } 
    24 }
    25 ORDER BY DESC(?count)
    26 LIMIT 500
    

CollectionsEdit

Image gallery of paintings from Kenwood HouseEdit

The following query uses these:

Features: ImageGrid (Q24515278)    

 1 #defaultView:ImageGrid
 2 SELECT DISTINCT ?painting ?paintingLabel ?painterLabel ?image where {
 3       ?painting wdt:P31/wdt:P279* wd:Q3305213 ;  # any painting (or type of painting)
 4        wdt:P195 wd:Q764804 ;  # in collection Kenwood House
 5        wdt:P170 ?painter ; # get painter
 6        wdt:P186 wd:Q296955 ; # Made with oil paint
 7        wdt:P18 ?image . # Image from Commons of the artwork
 8   SERVICE wikibase:label {
 9        bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,fr,es"
10     }
11 } LIMIT 160

Birthplaces of painters in the Kenwood House collection (based on query by Jane Darnell)Edit

The following query uses these:

Features: Map (Q24515275)    

 1 #defaultView:Map
 2 SELECT DISTINCT ?painter ?painterLabel ?birthplaceLabel ?geoloc where {
 3       ?painting wdt:P31/wdt:P279* wd:Q3305213 ;  # any painting (or type of painting)
 4        wdt:P195 wd:Q764804 ;  # in collection Kenwood House
 5        wdt:P170 ?painter . # get painter
 6       ?painter wdt:P19 ?birthplace . # get painter's birthplace
 7       ?birthplace wdt:P625 ?geoloc . #latitude and longitude
 8   SERVICE wikibase:label {
 9        bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,fr,es"
10     }
11 }