User:Tagishsimon

Scotland

• de petscan
• en petscan
• fr petscan
• es petscan
• it petscan
• sco petscan
• cy petscan
• da petscan
• pt petscan

Todo:

• watercourse in valley (Q111360468)
• coast guard station (Q108603883)
• watch house (Q108603785)
• institute building (Q108616097)
• burial aisle (Q108657391)
• burial cairn (Q108657428)
• council office, town hall, municipal building &c - borked ontology
• James Abercrombie (Q108745196) - link to other gardens
• agricultural improver
• skerries (Q109538705)
• LB29261 - multiple records, snafu
• boundary wall (Q114832561)

Petscans

• UK categories, no P31, P279
• WiR Metrics non-biog items

Questions

• nl Aldie query

Reports

• no thesis in author item - - - no P5008 in author
• LLs
• geographic feature - - - Islands P706 - - - P706 wikibase:around - - - GB1900 map - - - new streams - Kyle of Sutherland - - - DoBIH

• GB1900 lake latlong - - - GB1900 Council - - - GB1900 dupes - - - Stream pools / OS name

• P1435 without P217 - - - grouped - - - multiple somethings - - - https://www.wikidata.org/wiki/Q17571030 & https://www.wikidata.org/wiki/Q1266330

• Stuff in Scotland by type - - - +Canmore, HSID - - - +P279* - - - canmores for HSID multiples

• Scholarly article Den - - - Den journals - - - Star Den (hot subdwarf star) - - - star types - - - No desc P131s - - - station alias

• MPs - - - UKAT

• count items by # statements - - - slice missing P21 by statements

• HES needing splitting

• slice

• national museum - Mapping Museums - - - MWAPI museums - - - P131 & P276 museums

• bridges coloured dots - - - Great Glen rivers - - - GG bridges

• Rivers with no mouth - - - lakes with no outflow (minus Orkney, Outer Hebrides, Shetland) - - - (Highland) - - - lakes with no standing - - - confluence - - - confluence finder - - - all rivers (OSName) - - - OS name book - - - river with no origin - - - bridges not crossing anything - - - bridges and rivers w/o whatsits - - - all lakes - - - reservoir - commons - - - name translations - - - waterfalls

• mouths on river

• check - - - lakes on river - - - lakes specified as a mouth, with no inflow - - - rivers with no P403 'mouth' coord - - - lakes w/o mouth coord - - - river running into streams

• rivers on Orkney - - - river by distance to mouth

• Spey - elevation, bank, mouthcoords

• coastal landform - part of / located in water

• date precision doodle

• Rivers &c to the sea - - - Seas to the river - - - RttS qually coords (QueryChest) - - - Sco & Eng

• Border inspection

• lakes acting as mouth, without outflow

• Hillforts near water

• hydro search

• watercourse descriptions

• count of items by number of directClaims by domain - - - list items by number of directClaims by domain (rivers) - - - report

• count of items by number of directClaims by domain - - - list items by number of directClaims by domain (lakes)

• Get P706 candidates based on P706

• lake properties - - - FNE - - - property type

• UK stuff no label - no description - no description P131/P131

• Borked .gd lakes - DB of UK & Ireland hills - check ga. & cy.

• Sco labels, single authority

• UK, 1 or 2 statements

• Inventory Garden & Designed Landscape

• Protected areas - - - how they're linked - - - All PEs

• Canmore scores

• misplaced parks & gardens refs

• heritage designation but no P709 HS ID

• Get Canmores for items that are P527 'part of' some other thing

• Settlement descriptions

• map of Scottish things with no P276

• Scottish HSID items with no (useful) P31, optional canmore (canmore_points#WD)

• Scottish HSID item location query (Canmore_points#P276)

• count Scottish P31s - - - count P31 by country

• Descriptions based on P276=human settlement

• Descriptions based on P276=human settlement, 2 P31s

• Scottish things with commonscat but no image

• Scotland things, filter by label - - - ditto - FNE P276

• filter description by string - descriptions & P276, P706 for HSID items

• by local authority categories query

• things on Orkney & Shetland Islands - P1332-5(NESW limits) UNION {?place ?predicate ?island.} UNION P706*(terrain)

• geoRadius FNE P276

• Borked Orkney GeoNames - - - how borked is geonames - Scotland? - - - NormalRank geonames coords - - - Cebwiki coords - - - 2 coords inc GeoNames, Cebwiki - - - 1 coord by reference - - - 1 coord by reference rivers

• object has role qualifier counts for Scottish Council Area P131 values

• Bays &c

• POWiS

• RNLI

• OSM

• OSM2

• town halls

• film no description

• non-EN film dump Q125145373

• Scottish things, no P131, shapefiles

• ambassadors

• borked MPs

• Orcid

• CBDB
• No description by occuption, show demonym, dob & dod - =""""&IF(C2<>"",C2&" ","")&"baseball player"&IF(D2+E2<>0," ("&CONCAT(D2,"-",E2)&")","")&""""

• wikipedia list articles

• church building, no Den, single location, UN country

• Missing Lens

• island no desc

• Island no desc, state

• no gender

• CEBwiki no EN desc

• chronology with no EN label

• missing descriptions gc type & creator

• Gender

• films

• Citizens

• No properties

• P1216 dupes

• User:Pasleim/Language statistics for items

• No label

• missing labels 2
• album descriptions

• Occ no desc - place of birth ->P17:country
• occ no desc - country of citizenship
• occ no desc, no country

• occ no desc - handle multiple countries
• Gender by occ

• Occupation count - female, no en.wiki

• MWAPI - main subject

• MWAPI people by occupation

• no P21, P31, P279

• WiR Musician counts

• categories

• cats with subquery

• check P971s for cats

• Ambassador qualifiers

• commons thang - - - thang 2

• Properties of sets of items (slice, type)

• category - values

• Seas around UK - - - revised - - - shipping forecast areas
• main subject law

SPARQL

Demonyminiser

values (?c ?d) {(wd:Q1007 "Guinea-Bissauan") (wd:Q1008 "Ivorian") (wd:Q1011 "Cape Verdean") (wd:Q1013 "Lesotho") (wd:Q1037 "Rwandan") (wd:Q1039 "São Tomé and Príncipe") (wd:Q1042 "Seychellois") (wd:Q215 "Slovenian") (wd:Q217 "Moldovan") (wd:Q225 "Bosnia and Herzegovina") (wd:Q227 "Azerbaijani") (wd:Q232 "Kazakhstani") (wd:Q235 "Monacan") (wd:Q265 "Uzbekistani") (wd:Q32 "Luxembourgish") (wd:Q33 "Finnish") (wd:Q35 "Danish") (wd:Q36704 "Yugoslavian") (wd:Q414 "Argentinian") (wd:Q664 "New Zealand") (wd:Q685 "Solomon Islands") (wd:Q686 "Vanuatuan") (wd:Q711 "Mongolian") (wd:Q736 "Ecuadorian") (wd:Q757 "Saint Vincent and the Grenadines") (wd:Q763 "Saint Kitts and Nevis") (wd:Q781 "Antigua and Barbuda") (wd:Q783 "Honduran") (wd:Q794 "Iranian") (wd:Q801 "Israeli") (wd:Q813 "Kyrgyzstani") (wd:Q819 "Laotian") (wd:Q836 "Myanma") (wd:Q837 "Nepalese") (wd:Q851 "Saudi Arabian") (wd:Q865 "Taiwanese") (wd:Q878 "Emirati") (wd:Q928 "Philippine") (wd:Q963 "Botswanan") (wd:Q965 "Burkinabe") (wd:Q983 "Equatorial Guinean") (wd:Q1000 "Gabonese") (wd:Q1005 "Gambian") (wd:Q1006 "Guinean") (wd:Q1009 "Cameroonian") (wd:Q1014 "Liberian") (wd:Q1016 "Libyan") (wd:Q1019 "Malagasy") (wd:Q1020 "Malawian") (wd:Q1025 "Mauritanian") (wd:Q1027 "Mauritian") (wd:Q1028 "Moroccan") (wd:Q1029 "Mozambican") (wd:Q1030 "Namibian") (wd:Q1032 "Nigerien") (wd:Q1033 "Nigerian") (wd:Q1036 "Ugandan") (wd:Q1041 "Senegalese") (wd:Q1044 "Sierra Leonean") (wd:Q1049 "Sudanese") (wd:Q1050 "Swazi") (wd:Q114 "Kenyan") (wd:Q115 "Ethiopian") (wd:Q117 "Ghanaian") (wd:Q142 "French") (wd:Q145 "British") (wd:Q148 "Chinese") (wd:Q15180 "Soviet") (wd:Q155 "Brazilian") (wd:Q159 "Russian") (wd:Q16 "Canadian") (wd:Q16957 "East German") (wd:Q17 "Japanese") (wd:Q183 "German") (wd:Q184 "Belarusian") (wd:Q189 "Icelandic") (wd:Q191 "Estonian") (wd:Q20 "Norwegian") (wd:Q211 "Latvian") (wd:Q212 "Ukrainian") (wd:Q213 "Czech") (wd:Q214 "Slovak") (wd:Q218 "Romanian") (wd:Q219 "Bulgarian") (wd:Q221 "Macedonian") (wd:Q222 "Albanian") (wd:Q224 "Croatian") (wd:Q228 "Andorran") (wd:Q229 "Cypriot") (wd:Q230 "Georgian") (wd:Q233 "Maltese") (wd:Q236 "Montenegrin") (wd:Q238 "Sammarinese") (wd:Q241 "Cuban") (wd:Q242 "Belizean") (wd:Q244 "Barbadian") (wd:Q252 "Indonesian") (wd:Q258 "South African") (wd:Q262 "Algerian") (wd:Q27 "Irish") (wd:Q28 "Hungarian") (wd:Q29 "Spanish") (wd:Q298 "Chilean") (wd:Q29999 "Dutch") (wd:Q30 "American") (wd:Q31 "Belgian") (wd:Q334 "Singaporean") (wd:Q33946 "Czechoslovak") (wd:Q34 "Swedish") (wd:Q347 "Liechtensteiner") (wd:Q36 "Polish") (wd:Q37 "Lithuanian") (wd:Q38 "Italian") (wd:Q39 "Swiss") (wd:Q398 "Bahraini") (wd:Q399 "Armenian") (wd:Q40 "Austrian") (wd:Q403 "Serbian") (wd:Q408 "Australian") (wd:Q41 "Greek") (wd:Q419 "Peruvian") (wd:Q423 "North Korean") (wd:Q424 "Cambodian") (wd:Q43 "Turkish") (wd:Q45 "Portuguese") (wd:Q574 "East Timorese") (wd:Q657 "Chadian") (wd:Q668 "Indian") (wd:Q672 "Tuvaluan") (wd:Q678 "Tongan") (wd:Q683 "Samoan") (wd:Q691 "Papua New Guinean") (wd:Q695 "Palauan") (wd:Q697 "Nauruan") (wd:Q702 "Micronesian") (wd:Q709 "Marshallese") (wd:Q710 "I-Kiribati") (wd:Q712 "Fijian") (wd:Q717 "Venezuelan") (wd:Q730 "Surinamese") (wd:Q733 "Paraguayan") (wd:Q734 "Guyanese") (wd:Q739 "Colombian") (wd:Q750 "Bolivian") (wd:Q754 "Trinidadian") (wd:Q760 "Saint Lucian") (wd:Q766 "Jamaican") (wd:Q769 "Grenadian") (wd:Q77 "Uruguayan") (wd:Q774 "Guatemalan") (wd:Q778 "Bahamian") (wd:Q784 "Dominican") (wd:Q786 "Dominican") (wd:Q79 "Egyptian") (wd:Q790 "Haitian") (wd:Q792 "Salvadoran") (wd:Q796 "Iraqi") (wd:Q800 "Costa Rican") (wd:Q804 "Panamanian") (wd:Q805 "Yemeni") (wd:Q810 "Jordanian") (wd:Q811 "Nicaraguan") (wd:Q817 "Kuwaiti") (wd:Q822 "Lebanese") (wd:Q826 "Maldivian") (wd:Q833 "Malaysian") (wd:Q842 "Omani") (wd:Q843 "Pakistani") (wd:Q846 "Qatari") (wd:Q854 "Sri Lankan") (wd:Q858 "Syrian") (wd:Q863 "Tajikistani") (wd:Q869 "Thai") (wd:Q874 "Turkmen") (wd:Q881 "Vietnamese") (wd:Q884 "South Korean") (wd:Q889 "Afghan") (wd:Q902 "Bangladeshi") (wd:Q912 "Malian") (wd:Q916 "Angolan") (wd:Q917 "Bhutanese") (wd:Q921 "Bruneian") (wd:Q924 "Tanzanian") (wd:Q929 "Central African") (wd:Q945 "Togolese") (wd:Q948 "Tunisian") (wd:Q953 "Zambian") (wd:Q954 "Zimbabwean") (wd:Q958 "South Sudanese") (wd:Q96 "Mexican") (wd:Q962 "Beninese") (wd:Q967 "Burundian") (wd:Q970 "Comorian") (wd:Q971 "Congolese") (wd:Q974 "Congolese") (wd:Q977 "Djiboutian") (wd:Q986 "Eritrean") }

Sequential queries

SELECT ?something
with {SELECT ?something where {
  . . .
} group by ?something
     } as %stuff
. . .
 where { include %stuff
 SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
}

Try it!

Qid from article name

SELECT ?item ?sitelink ?website
WHERE 
{
  VALUES ?sitelink {
"Admiral Group"@en
  } .
  ?article schema:about ?item ;
  schema:isPartOf <https://en.wikipedia.org/> ; 
  schema:name ?sitelink .
  ?item wdt:P856 ?website
}

Try it!

Hints

• query optimization
• wdt:P569 ?dateOfBirth. hint:Prior hint:rangeSafe true.
• hint:Query hint:optimizer "None".
• hint:SubQuery hint:optimizer "None"
• hint:Prior hint:gearing "forward".
• hint:Prior hint:runFirst true.
• hint:Prior hint:runLast true.

• filter not exists {?item schema:description ?d filter(lang(?d)="en") }
• filter not exists {?item rdfs:label ?l filter(lang(?l)="en") }