User:MargaretRDonald/MarieCurietimelineAndVolcanoes

Wikidata SPARQL tutorialEdit

SPARQL tutorial
SPARQL for absolute beginners
User:Ijon (who presented "Querying Wikidata with SPARQL for absolute beginnners"
Ijon's wikidata todo list for Estonia (Change the country)

Margaret's QueriesEdit

MiscellaneousEdit

Number of journals per publisher Short URL
Journals by publisher (includes all languages - 20290) short URL
Journals (in English) by publisher (10415) short URL
Open-access journals (in English) by publisher (2397) short url
Open-access journals (in English) by publisher with start-time - failed 0 results

Art worksEdit

Women artists held in Australian institution: birthplace & wikipedia article anything
Best described articles in Te Papa's collection
Women whose work is held in any Australian collection
Counts of women's artworks by institution in Australia
Counts of women's artworks by institution in Australia: Version 2
Counts of institutions for women artists without a wikipedia article
100 Works of Art with AGSA ids
Female & has works in NGA (together with birth & death dates & places) Returns 9 women
Women with works in the NGV, births, deaths, age etc
Female & has works in AGNSW (together with birth & death dates) Returns apparently 11 women (Confusion over Carlene West's birth date!)
Art museums in Australia (67 returned)
Museums including subclasses located in the ACT
Version 3: counts of paintings/prints by female artist by NSW institution: returns 151 women
Version 4: counts of paintings/prints/drawings/sculpture by female artist by ACT institution: returns 164 women*institutions
Version 5: counts of paintings/prints/drawings/sculpture by female artist by Victorian institution: returns 241 women*institutions
Map of all locations for paintings with counts of paintings
Emily Kngwarreye's artworks listed in Wikidata
Barbara Hanrahan's artworks listed in Wikidata
Japanese paintings and their creators in Wikidata
Artwork depicts a dragon/serpent (no use of instance of.....

Cicada artworks (But no insect artworks)

Australian women artists with institution count
(or slower) Australian women artists with institution count

HumansEdit

Map of birthplaces of artists with works in Wikidata held in AGSA Map of birthplaces of artists with works in Wikidata held in AGSA
Map of AGSA artists' birthplaces using the property "has works in the collection"
Bar Chart of Australian women articles by occupation Bar Chart of Australian women articles by occupation
Largest cities with female mayor Largest cities with female mayor (SPARQL)

Marie Curie timeline Marie Curie timeline

Barry James Marshall Barry James Marshall timeline

Tunisian women writers (in French?) Tunisian women writers ? in French

Failed code for Australian women artists Failed code for Australian women artists

ABLOs ABLOs

Articles by sex Articles by sex graph

Mary Shelley query Shelley artwork graph

Premier of New South Wales Premier of New South Wales

Birth and death locations of clerics
Siobhan's list of women botanists (Canadian & Amrerican) prior to 1900 (816)
Siobhan's list (those without enwiki articles - 292)
Works authored by Lesley Joy Rogers (90)
Australian women botanists
Mendeley code IDs
Female British writers with Gutenberg IDs between particular dates
Authors with more wikiquotes than wikipedia articles
Additional Sick people / day in the Australian coronavirus pandemic: No records available
Adrian Barnett's articles by journal (Query is crppy still)
Adrian Barnett's articles at F1000 (Query is very crappy still)

MappingEdit

Mapping volcanoes Mapping volcanoes

Earthquakes Mapping earthquakes

Mapping Australian Lighthouses Mapping Australian Lighthouses


School locations in Australia School locations in Australia

Plants etcEdit

Taxa named by Philip Miller with an enwiki article
APNI Apocynaceae aricles (154)
Plant name contains "chyrsocalyx" - and failed publication data (13)
Succu's query counting the role of a reference in a taxon name
Waray articles without Leucopogon Range maps
10 botanists with altlabels and descriptions
wikidata items with a SPRAT ID without an enwiki article (plus required APNI link (550 non-articles at 18 April 2020)
All wikidata items with a SPRAT ID without an enwiki article (plus optional APNI link (736 non-articles at 14 November 2011)
Australian taxa without basionyms (62389 items)
All wikidata items with a fossilworks ID without an enwiki article (59687 non-articles at 8 November 2011)
All NTFlora taxa with articles in Wikipedia
All NT Acacias without a wikipedia article
All Acacias with no taxon range map (2070)
All SPRAT database entries ordered by taxon
Taxon property items
SPRAT: All SPRAT entries with taxon names SPRAT value
Taxon names with NT flora IDs
Taxon names with VicFlora IDs
Taxon names with Flora of Australia IDs
Taxon names with FloraBase IDs
Taxon names with NSW Plant IDs (IDs from PlantNET)
Taxon names with Australian Tropical Rainforest IDs (ARTF IDs)
Taxon names with SA Flora IDs
Plant genera/gamilies without an article in English wikipedia Jura's query

Plant genera/families without an article in English wikipedia (Toby's query)

Paper counts by author in wikispecies

Taxa authored by Peter Brian Heenan with an enwiki article (7 items)
Taxa authored by Peter Brian Heenan (77 items)
Taxa without an article authored by Peter Brian Heenan (70 items)
Taxa authored by Paul Graham Wilson & William Paul
Query: Peter Heenan (NZ botanist): species requiring articles with links to NZPCN, POWO (now 69)
Query:APNI plant taxa without author qualifying information (limited to 200)
Query:APNI plant taxa without author qualifying information (35414)
Botanists' abbreviations (46764)
Taxa authored by John Teast Waterhouse with enwiki articles
Taxa authored by Joseph Dalton Hooker without an enwiki article
Taxa authored by Joseph Dalton Hooker with an enwiki article
Tropicos with no author
Plant List species without author information
Incorrectly formulated Species in Rubiaaceae family (2969) together with their plant list links
Taxa in the Rubiaceae family with plantlist links where they exist (5598 taxa)
Qvalues for Acacia species without taxon range maps (1985)
Vietnamese Lepidosperma articles without taxon range maps (58)
Finding articles in enwiki missing the range_map parameter when a range map exists (484 for Acacia)
Finding articles in frwiki missing the range_map parameter when a range map exists (73 for Acacia)
Finding articles in enwiki missing the range_map parameter when a range map exists (0 for Actinotus)
Finding Merr. named plants without an author link
Joseph Dalton Hooker as author in wikidata but not (linked) in the corresponding English article
Robert Brown as author in wikidata but not linked in the enwiki article
Taxa without taxonbars (Fails to work)
Enwiki articles for taxa authored by Barbara Lynette Rye

SELECT ?item ?itemLabel ?apni_id ?article ?sitelink
WHERE 
{
  {
    ?item wdt:P5984 ?apni_id.
    ?sitelink ^schema:name ?article .
    ?article schema:about ?item ;
             schema:isPartOf <https://en.wikipedia.org/> .
  }
  #MINUS
  {
    SERVICE wikibase:mwapi
    {
      bd:serviceParam wikibase:api "Search" .
      bd:serviceParam wikibase:endpoint "en.wikipedia.org" .
      bd:serviceParam mwapi:srnamespace "0" .
      bd:serviceParam mwapi:srlimit "max" .
      bd:serviceParam mwapi:srwhat "text" .
      bd:serviceParam mwapi:srsearch 'insource:"Noongar Bush Medicine Medicinal plants"' .
      ?title wikibase:apiOutput mwapi:title .
    }
    BIND (STRLANG(?title, "en") as ?sitelink)
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it! This times out

Examples from JarrahTreeEdit

Examples from helpEdit

Goats Goats

Horses with birthyear Horses: parents, birth & death years

Most used properties for poems Most used properties for poems

User 99of9's queriesEdit

parent taxa of Christmas Island red crabs

properties which are instances of a particular item, here "Wikidata property for items about works"

Failed queriesEdit

Women alumni of Sydney UEdit

# select Australian women who have an enwiki article and are said to be usyd alumni
# but wikidata does not assert "educated at Sydney Uni"
SELECT ?item ?itemLabel  ?article ?sitelink
WHERE 
{
  {
    ?item wdt:P21 wd:Q6581072. # is a woman
    ?item wdt:P27 wd:Q408.     # Is Australian
    ?sitelink ^schema:name ?article .
    ?article schema:about ?item ;
             schema:isPartOf <https://en.wikipedia.org/> .
  }
MINUS    { ?item wdt:P69 wd:Q487556.  # educated at Sydney University
           ?item wdt:P21 wd:Q6581072. # is a woman
           ?item wdt:P27 wd:Q408.     # Is Australian
          } 
  {
    SERVICE wikibase:mwapi
    {
      bd:serviceParam wikibase:api "Search" .
      bd:serviceParam wikibase:endpoint "en.wikipedia.org" .
      bd:serviceParam mwapi:srnamespace "0" .
      bd:serviceParam mwapi:srlimit "max" .
      bd:serviceParam mwapi:srwhat "text" .
      bd:serviceParam mwapi:srsearch 'insource:"Category:University of Sydney alumni"' .
      ?title wikibase:apiOutput mwapi:title .
    }
    BIND (STRLANG(?title, "en") as ?sitelink)
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
LIMIT 10

Try it!

  • Query times out