User:MargaretRDonald/MarieCurietimelineAndVolcanoes
Wikidata SPARQL tutorial
editSPARQL 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)
Species named after the FRV Kapala
Margaret's Queries
editConferences
editBHL proposal for Nicole Kearney
edit- AFD bryozoa without English pages
- AFD crustacea without English pages
- APNI Asteraceae with/without enwiki pages
- Ausfungi_ID fungi with enwiki pages
- SPRAT_ids with enwiki pages
- Lymnaeoidea (molluscs) with AFD_ids & without an enwiki page
- Qitems with both BHL page ids and AFD publication IDs
- AFD Arachnids with enwiki page without a page no article +/- author + some authors
- Proceedings of Zoological Society + pubdate + author deathdate
- AFD taxa with no author AFD taxa with author]
- AFD taxa with no image
- Taxa named by M.R. Gray +/- enwiki pages
- Chris H.S. Watts taxa with/without articles
- H.H. Karny taxa with/without articles
Miscellaneous
edit- Nicole Kearney on youtube
- BHL downloads
- Siobhan's notes for her entity schema
- Proposed properties for Research expeditions (Siobhan)
- Cradle
- EntitySchema for organisation
- Let's write a schema together
- Everything is connected
Wikimedia wikidata proposal 2022
editEnwiki: Disparity between authorities for Eremopola
1000 AFD Curciiulionidae without Insects (Insecta) of the World IDs
Squamata AFD-ids with no Reptile DB ids
Number of articles by wikipedia (AFD id articles)
Number of birds vs Number of external identifiers
Number of insects vs external ids (n(id) <=7)
Number of insects vs external ids (n(id) > 7)
Australian Protected places without enwiki articles and with photo in WLE2021 AU +/- enwiki articles
APNid wikidata without authors
YouTube video: Toby creating mix'n'match tool for WoRMS
YouTube video: creating mix'n'match via a TSV upload IRMNG Molluscs
Euphorbia bicompacta (Q5851419) models how to represent a taxon
Survey for conference
Things to talk about
- items with AFD publication IDs
- Lasioglossum froggatti
- Pauropsalta extrema (Q111908783) + Wikidata talk:WikiProject Taxonomy/Archive/2021/10
- Gondwanenneboeus minutissimus (Q2355219)
AFD echinodermata without WoRMS ids
AFD porifera without IRMNG ids
Wikidata fellowship blog
editScottish witches
editopenRefine witches: University of Edinburgh
Scottish witches: Place of death
Scottish witches: Number of statements
Scottish witches: Without a significant event
Scottish witches: Significant event in time
Scottish witches: Significant persons
Scottish witches: manner of death (all) just 236 with manner of death specified
Consistency in cause of death?
Miscellaneous queries
edit(US) researchers with orcid IDs ordered by sitelinks
Full works available url for "Envronmental and Planning Law" journal
Australian cartoonists Australian cartoonists with deathdate
Low cartoons
Counts of species for Amphipoda genera
South Korean screenwriters
[1]
Species named after the FRV Kapala
Women educated or employed at QUT
Slicing - with limits
Australians in "The Australian dictionary of science by sex and birth-date (3463)
Australian scientists & year of birth (97, probably because citizenship used)
AFD publications without "full work available at"
Taxa with property "named after" together with the type of entity for which they are named
Zoologists at the Australian Museum
People employed by the Australian Museum & born later than 1800: Number of sitelinks
Upcoming world days to celebrate this or that
Spanish actresses without an article in eswiki, but having articles on other wikis
Korean actors
Map of Inaturalist placeIDs
Laura A. Katz articles by descending date
W.R.Barker articles by descending date
Failed (0 results): women without wikipedia scholia templates
Failed Ambrozia10
Artists and their works (Ambrosia10)
Articles authored by James Scott Bowerbank
Articles authored by Clair Alston-Knox
500 scientists by year of birth
Number of Nuytsia journals uploaded (grouped by volume)
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
Taxon articles where both vietnamese and english articles exist and have an image file beginning with P (12286)
500 No parent AusFungi
women botanists with no IPNI id
Other biota
editSPRAT articles
QLD Biota ID articles
Type specimens
Chris H.S. Watts taxa with/without articles
H.H. Karny taxa with/without articles
Reptiles with AFD-id, Reptile DB-id & no article Reptile articles to write
Lepidoptera with AFD id and an enwiki page Query for Tom
Jane Fromont authored taxa with optional article and AFD-id
AFD taxa without parents
Taxa with AFD-ids and no GBIF id
Taxa with author citation containing Navás and which have AFD_ids
Blattodea with AFD_ids
AFD genera with articles
APNI-ids with photo, no article
AFD Fauna with photo, but no article
AFD Arachnida
Reptilia For Tom
Genera from Chrysomelidae (2330)
authored by Samuel Booker McDowell
Articles by Jessica Meeuwig
FishBase ids with and without enwiki articles
Taxa named by Gert Worheide
Articles written by Gert Wörheide
Arthur Dendy sponges (94)
Patricia Bergquist sponges: 50
AusLichen without taxon author citations
Auslichen with no parent
AusLichens with author citations (For Tom May)
12883 articles have a QLD biota ID
Art works
editCollectives/women on Know My Name focus list
Women artists with work in the collection of the NGA (210)
Women artists on the focus list of Know My Name (199)
Know My Name focus artists together with links (to form list for use in wikipedia)
Women artists on the focus list of Art+Feminism (limited to 4000)
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
Humans
editAustralian women scientists - researcher/scientist, Australian women scientists - researcher/scientist/physicist (based on citizenship
American writers:sex and birthdate
Non male botanists and country of citizenship
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)
Mapping
editMapping volcanoes Mapping volcanoes
Earthquakes Mapping earthquakes
Mapping Australian Lighthouses Mapping Australian Lighthouses
School locations in Australia
School locations in Australia
Plants etc
editColeoptera genera
Allwikidata with Chrysomelinae ancestors + /- AFD-ids
Query to find WA Loranthaceae
Portuguese APNI articles
Fungi genera from Index Fungorum Fungi genera from either AusFungi or IndexFungorum
Any taxa in IF AusFungi or mycobank
In index fungorum, auslichen, or ausfungg - optional Mycobank
IndexFungorum union Mycobank minus AusFungi (did not use select DISTINCT
Count excess fungi taxa (>12000)
Taxa authored by John Alan Elix
Taxa authored by Marie Leonore Farr
Taxa authored by Daniel McAlpine
AusFungi IDs with no author no ex author
AusLichenIDs with no author or no ex taxon author
Count distinct Ausfungi taxa with no author
AusFungi IDs with no parents
Botanists & their abbreviations
APNI id with optional NTFlor IDs
Fungi No Author (101037 items)
1073 wikidata fungi items
Fungi enwiki articles
Australian Comesperma species and subspecies
Australian Cyperus species
Taxa named by K.L.Wilson with an enwiki article
Mycotaxon journal articles
400 Index Fungorum records
Lichenologist articles
Benedictus Hubertus Danser articles
Left-over Kevin Thiele images
Acacia articles without images
Australian Systematic Botany articles
Muelleria articles
Vietnamese articles with image beginning in P and no enwiki article and pphotgraphs by Kevin Thiele
Vietnamese articles with image beginning in P and no enwiki article (124
Trying to find plant with no image
Muelleria articles uploaded to wikidata
Nuytsia artiles uploaded to wikidata
Cunninghamia articles
Enwiki articles for Kraenzl.
Phillip Gerhard Kodela's articles together with dates
Kevin Thiele's journal articles
Items with ATRF ids
Items with either an ATRFid or a QLD Biota id
Hayata's enwiki articles (58)
Stuff to allow corrections of Australian Weed IDs
Kelly Anne Shepherd's plants on enwiki
Robert Brown's 1068 enwiki articles
Lindauer's plants/seaweeds
Women botanists without enwiki article
Women botanists (needs modification to omit those with enwiki articles
Count of NT Flora Ids (1190)
APNI id plants with no wikidata basionym (58082)
Taxa named by Barbara Lynette Rye with enwiki article
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 enwiki articles for Prostanthera without a range map
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
Alan W. Archer enwiki taxon articles
enwiki articles with AusLichen IDs
Taxa named by David John Galloway
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". }
}
This times out
Partially failed stuff
editExamples from JarrahTree
edit- Query examples:
- All deaths in Game of Thrones (source)
- Wikidata knows of at least 5263 buildings started before Notre Dame de Paris (query based on this discussion)
- Timeline for the History of Telecommunications (source)
- Graph of London Tube stations that are on at least three lines (source)
- Map of churches in Sri Lanka (source)
- Query examples:
Examples from help
editGoats Goats
Horses with birthyear Horses: parents, birth & death years
Most used properties for poems Most used properties for poems
User 99of9's queries
editparent taxa of Christmas Island red crabs
properties which are instances of a particular item, here "Wikidata property for items about works"
- Wikidata property for items about people
- parent taxons of komodo dragon
- Schools in Australia ... now recursive? better
- subclasses of schools
- children of clergy
- Sydney Archbishops inc wiki article
- Prime Ministers, dates & spouses
- birth and death locations of a group of people (clerics)
- all instances of subclasses* of volcanoes
- Minerals all subclasses of mineral all instances of mineral instances of subclasses of mineral
- country of origin !Australia but citizenship is, citizenship=Australia but not born here
- states and highest offices (many missing)
- Given names born in Australia containing T
- Genders born in Australia
- Australian-born politician cast-members or members of Australian state or federal parliaments who are also cast members
- statues in Manhattan
- powerplants in Australia
- cast ages histogram gender histogram USA to 1985 USA from 2000
- books by publisher
- books per year by publisher
- elements
- confederate depiction timeline attempt to reproduce [2]
- Australian things named after
- timeline of a person (Krebs)
- university pageranking
- items with only "Australia"
- named after chain
- Australian philosophers
- SUCS near elements test test 2 test 3 best?
- Scientific article gender-age distribution
- Chemical compounds with the least, most statements
- mass vs boiling point (ignores units) with units Celsius only
- copublishers COE journals
- author name
- properties for diseases
- properties for compounds full count for a specific property
- ceb suburbs with no ssc
- Aussie OSM relations for use with Kartographer maps example: w:Coburg, Victoria
- USA newspapers missing USNPL ID map global map by sitelinks en-wiki infoboxes infoboxes joined to USNPL
- Trove Australia newspaper wiki coverage
Failed queries
editWomen alumni of Sydney U
edit# 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
- Query times out