User talk:Dirac

Skype discussion 2017-09-14

Agenda:

Observations type available from Environment Canada (per station)
1. Climate
2. Monthly
3. Daily
4. Hourly
Which weather elements do we want to include?
1. "Average Max. Temp. (°C)"
2. "Average Min. Temp. (°C)"
3. "Frequency of Precip. (%)"
4. "Highest Temp. (°C)"
5. "Highest Temp.Year"
6. "Highest Temp. Period"
7. "Highest Temp. Data Quality"
8. "Lowest Temp. (°C)"
9. "Lowest Temp. Year"
10. "Lowest Temp. Period"
11. "Lowest Temp. Data Quality"
12. "Greatest Precip. (mm)"
13. "Greatest Precip. Year"
14. "Greatest Precip. Period"
15. "Greatest Precip. Data Quality"
16. "Greatest Rainfall (mm)"
17. "Greatest Rainfall Year"
18. "Greatest Rainfall Period"
19. "Greatest Rainfall Data Quality"
20. "Greatest Snowfall (cm)"
21. "Greatest Snowfall Year"
22. "Greatest Snowfall Period"
23. "Greatest Snowfall Data Quality"
24. "Most Snow on the Ground (cm)"
25. "Most Snow on the Ground Year"
26. "Most Snow on the Ground Period"
27. "Most Snow on the Ground Data Quality"
How do we relate a station to an element?
1. Based on Lat/Lon, IATA airport code (when available)
2. Linked to closest city (if not within), airport page?
Proof of concept
1. Could we try with one station?
2. Do we have to create an element (identificator?) ?

Example: Let's take a concrete example. For the airport near the city where I was born (Bagotville Airport, code AITA YBG), the « Average max temperature » for « January 1st » is « -9,6 °C » (it is pretty cold in the winter).

WikiData elements

Bagotville Airport
Saguenay (City in which the airport is now located)

Useful links

Changing weather history

Properties get created via our property proposal process and changes in the meaning of a property should at least reflect a kind of consensus. I don't see that there's any consensus for changing weather history (P4150) in a way that discourages the storage of daily/hourly weather. ChristianKl (talk) 09:21, 29 October 2017 (UTC)[reply]

@ChristianKl: Should I create a sub-property to discriminate between monthly/daily/hourly observations? This is an important information, where could it be located? Dirac (talk) 10:55, 29 October 2017 (UTC)[reply]

We haven't yet much discussions about how to deal with the tabular datatype. I consider subproperties to be a good idea and if there's a property proposal for monthly/daily/hourly we can get more input from other people as well about how they consider it to be good way to model it. ChristianKl (talk) 14:18, 29 October 2017 (UTC)[reply]

@ChristianKl:Where can we discuss about this? Dirac (talk) 14:27, 29 October 2017 (UTC)[reply]

Liste des villes du Québec

# Toutes les villes du Québec

SELECT DISTINCT ?city ?cityLabel ?cityPopulation
WHERE
{
  	?city wdt:P31/wdt:P279* wd:Q3788231 .  # find instances of subclasses of city
    # Ville du Québec
    OPTIONAL { ?city wdt:P3856 ?idQC }
     FILTER(# code géographique des municipalités du Québec
      BOUND(?idQC)    
     )
  
	# Now select the population value of the ?city
	# (wdt: properties use only statements of "preferred" rank if any, usually meaning "current population")
   ?city p:P1082 ?populationStatement .
   ?populationStatement ps:P1082 ?cityPopulation.
   ?populationStatement pq:P585 ?date
   FILTER NOT EXISTS { ?city p:P1082/pq:P585 ?date_ . FILTER (?date_ > ?date) } 
  
	# Optionally, find English labels for city and mayor:
	SERVICE wikibase:label {
		bd:serviceParam wikibase:language "fr" .
	}
}
ORDER BY DESC(?cityPopulation)
#LIMIT 200

Try it!

Les maires et mairesses du Québec

Grel: if(value.startsWith("http"), value, "https://" + value )

Source: https://www.donneesquebec.ca/recherche/fr/dataset/repertoire-des-municipalites-du-quebec/resource/19385b4e-5503-4330-9e59-f998f5918363

Code bash pour faire le tri des pid qui sont à retirer: for maire in `cat pid_villes_avec_maire.txt`;do grep -v $maire villes_sans_maires.txt > villes_sans_maires_tmp.txt; mv villes_sans_maires_tmp.txt villes_sans_maires.txt; done

Les mairesses en ordre de la population des villes du Québec

#Les plus grosses villes avec une femme maire
#added before 2016-10
#TEMPLATE={"template":"Largest ?c with ?sex head of government","variables":{"?sex":{"query":" SELECT ?id WHERE { ?id wdt:P31 wd:Q48264 .  } "},"?c":{"query":"SELECT DISTINCT ?id WHERE {  ?c wdt:P31 ?id.  ?c p:P6 ?mayor. }"} } }
SELECT DISTINCT ?city ?cityLabel?mayorLabel ?cityPopulation
WHERE
{
  BIND(wd:Q6581072 AS ?sex)
  BIND(wd:Q515 AS ?c)
  BIND(wd:Q16 AS ?Canada)

	?city wdt:P31/wdt:P279* ?c .  # find instances of subclasses of city
    ?city wdt:P17 ?Canada.  # Only cities in Canada
	?city p:P6 ?statement .            # with a P6 (head of goverment) statement
	?statement ps:P6 ?mayor .          # ... that has the value ?mayor
	?mayor wdt:P21 ?sex .       # ... where the ?mayor has P21 (sex or gender) female
	FILTER NOT EXISTS { ?statement pq:P582 ?x }  # ... but the statement has no P582 (end date) qualifier
	
    # Ville du Québec
    OPTIONAL { ?city wdt:P3856 ?idQC }
     FILTER(# code géographique des municipalités du Québec
      BOUND(?idQC)    
     )
  
	# Now select the population value of the ?city
	# (wdt: properties use only statements of "preferred" rank if any, usually meaning "current population")
   ?city p:P1082 ?populationStatement .
   ?populationStatement ps:P1082 ?cityPopulation.
   ?populationStatement pq:P585 ?date
   FILTER NOT EXISTS { ?city p:P1082/pq:P585 ?date_ . FILTER (?date_ > ?date) } 

  
	# Optionally, find English labels for city and mayor:
	SERVICE wikibase:label {
		bd:serviceParam wikibase:language "fr" .
	}
}
ORDER BY DESC(?cityPopulation)
LIMIT 20

Try it!

Députés de la 42e législature du Québec

SELECT ?nom ?nomLabel ?date_de_naissance  WHERE {
  ?nom wdt:P39 wd:Q3305338.
  ?nom p:P39 _:b23.
  _:b23 ps:P39 ?fonction.
  _:b23 pq:P2937 wd:Q57172022.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr". }
  OPTIONAL { ?nom wdt:P569 ?date_de_naissance. }
}

Try it!

Information sur les stations météo

PREFIX schema: <http://schema.org/>

# Information sur les stations météo du SMC
SELECT ?station ?label_en ?description_en ?label_fr ?description_fr ?instance_of ?coordinate_location ?province_label ?identifiant_WIGOS_de_station ?property_of ?start_date ?end_date ?msc_climate_id ?altitude ?data_interval ?hourly ?h_start ?h_end ?daily ?d_start ?d_end ?monthly ?m_start ?m_end WHERE {
  ?station (wdt:P31/wdt:P279*) wd:Q190107.
  ?station wdt:P17 wd:Q16.
  ?station wdt:P6242 ?MSCID

  # Data interval (HLY, DLY, MLY)
  OPTIONAL { ?station p:P6339 ?data_interval . }
  OPTIONAL { ?station p:P6339 ?d_interval .          # there is a P6339 property
             ?d_interval ps:P6339 wd:Q59657036 .  # and it's a daily
             ?d_interval ps:P6339 ?daily .        # and we get its value, in case there are no dates
             OPTIONAL { ?d_interval pq:P580 ?d_start .} # might be a start date
             OPTIONAL { ?d_interval pq:P582 ?d_end .}   # might be an end date
  }
  OPTIONAL { ?station p:P6339 ?m_interval .          # there is a P6339 property
             ?m_interval ps:P6339 wd:Q59657037 .  # and it's monthly
             ?m_interval ps:P6339 ?monthly .        # and we get its value, in case there are no dates
             OPTIONAL { ?m_interval pq:P580 ?m_start .} # might be a start date
             OPTIONAL { ?m_interval pq:P582 ?m_end .}   # might be an end date
  }
  OPTIONAL { ?station p:P6339 ?h_interval .          # there is a P6339 property
             ?h_interval ps:P6339 wd:Q59657010 .  # and it's hourly
             ?h_interval ps:P6339 ?hourly .        # and we get its value, in case there are no dates
             OPTIONAL { ?h_interval pq:P580 ?h_start .} # might be a start date
             OPTIONAL { ?h_interval pq:P582 ?h_end .}   # might be an end date
  }

  OPTIONAL { ?station wdt:P31 ?instance_of. }
  OPTIONAL { ?station wdt:P625 ?coordinate_location. }
  OPTIONAL { ?station wdt:P131 ?province_label. }
  OPTIONAL { ?station wdt:P4136 ?identifiant_WIGOS_de_station. }
  OPTIONAL { ?station wdt:P127 ?property_of. }
  OPTIONAL { ?station wdt:P729 ?start_date. }
  OPTIONAL { ?station wdt:P3999 ?end_date. }
  OPTIONAL { ?station wdt:P6242 ?msc_climate_id. }
  OPTIONAL { ?station wdt:P2044 ?altitude. }
  
  
  # FR/EN description
  OPTIONAL { ?station rdfs:label ?label_en. }
  OPTIONAL { ?station rdfs:label ?label_fr. }
  OPTIONAL { ?station schema:description ?description_en. }
  OPTIONAL { ?station schema:description ?description_fr. }
  FILTER((LANG(?label_en)) = "en")
  FILTER((LANG(?label_fr)) = "fr")
  FILTER((LANG(?description_en)) = "en")
  FILTER((LANG(?description_fr)) = "fr")

}
ORDER BY(?MSCID)

Try it!

Q60882708

Salut,

Juste pour te signaler une erreur dans les coordonnées de Point Lepreau (Q60882708) que je viens de corriger (classique inversion est/ouest).

Cdlt, VIGNERON (talk) 12:25, 19 March 2019 (UTC)[reply]

En effet. J'ai avisé le SMC pour qu'ils corrigent le fichier source.

Dirac (talk) 15:05, 19 March 2019 (UTC)[reply]

Merci. Cdlt, VIGNERON (talk) 18:42, 19 March 2019 (UTC)[reply]

Trouver les auteurs sans entrées dans Wikidata

L'idée, c'est de trouver les chaînes de caractères de author name string (P2093) les plus communes, ce qui permettra d'identifier les auteurs avec le plus d'articles rédigés, mais sans entrée dans Wikidata.

SELECT  ?item ?value

WHERE {
  ?item wdt:P31 wd:Q13442814.
  ?item wdt:P1433 wd:Q6053239.
  ?item wdt:P2093 ?value

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

Community Insights Survey

Share your experience in this survey

Hi Dirac,

The Wikimedia Foundation is asking for your feedback in a survey about your experience with Wikidata and Wikimedia. The purpose of this survey is to learn how well the Foundation is supporting your work on wiki and how we can change or improve things in the future. The opinions you share will directly affect the current and future work of the Wikimedia Foundation.

Please take 15 to 25 minutes to give your feedback through this survey. It is available in various languages.

This survey is hosted by a third-party and governed by this privacy statement (in English).

Find more information about this project. Email us if you have any questions, or if you don't want to receive future messages about taking this survey.

Sincerely,

RMaung (WMF) 17:37, 10 September 2019 (UTC)[reply]

(sparql AND categories)

Last updated on Thu, 11 Mar 2021 17:20:18 +0000. Regenerate this table or edit the query.

Title	Page ID	Size (bytes)	Last change
Dominik Pagacz	2901300	9412	20210107122835
Alexis O'Hara	4511851	8933	20201219123526
Billy Mavreas	4693769	13240	20201208021425
Christof Migone	4885400	5955	20201129152742
David Hoffos	5004747	15097	20201129192540
Elisha Lim	5128304	10993	20201126055158
Gord Smith	5345484	9587	20210226143156
Hilda Goldblatt Gorenstein	5530891	10532	20210221023246
Jack Dunham	5903837	8214	20201212080330
Jean Berger	5965950	13565	20210221041356
Kyle Mosher	6268204	10635	20210307190104
Mark Kenneth Woods	6614507	10748	20201202014639
Peter Ricq	7077875	13814	20210225120323
Samuel Roy-Bois	7322713	19253	20210210171146
VJ Hypnotica	7845136	7272	20201211104700
Yechiel (Eli) Shainblum	7998832	11759	20210222035608
Alberta Cleland	18696566	9260	20210223011426
Nora Collyer	18696572	8782	20210226110707
Mabel Lockerby	18704156	14181	20210226040742
Behzad Ghafarizadeh	20337219	7506	20201209011431
Marina Roy	21192265	12723	20210226041648
Chris Dorland	22378463	9422	20210222165122
Susanna Heller	22601995	11850	20210226060253
Nikki Forrest	24029357	12372	20201123125058
John Walker	25314645	7614	20210116050136
Marc Adornato	25807461	9372	20201208030623
Joanne Fitzgerald	28879311	11054	20201208201321
Maïna Militza	30623148	3565	20201209135215
Norman Jean Roy	30711348	7746	20201209143617
Celia Levetus	35919678	20943	20201210081041
E. Louise De Montigny-Giguère	43815505	8702	20210223034443
Heather Collins	46783457	11185	20201216025507
Elizabeth Eleanor D’Arcy Gaw	48133407	6558	20201211175927
Ethel Rosenfield	51337290	14322	20210226134944
Charlie Sivuarapik	52632735	18512	20201124134754
Deborah Margo	53146921	9286	20201212135625
Tivi Ilisituk	55267425	6294	20210210205831
Sylvia Lefkovitz	58553920	13693	20210226205327
David Ouellet	60614754	17697	20210214150805
Pierre Saindon	61309190	6820	20210311161704
Lilian Broca	61601308	11026	20201213011240
Lucy Pullen	61950049	6557	20201213021931
Laurence Vallières	62874007	7400	20210226162720
Michael Greenspan	68950490	14808	20210116141932
Lucas LaRochelle	77625013	3080	20210311161611
Nermin Grbic	95008649	4785	20201214063349
Dany Boivin	95008661	5737	20201214063400
Horace Champagne	97963153	5858	20210305232510
Adamie Niviaxie	99826104	2931	20210210204639

Merge request

Hello.

Can you merge the page "Azerbaijan at the Youth Olympics" (Q25540970) with the page "Azerbaijan at the Youth Olympics" (Q17995725)? The pages with language articles about the same topic were unknowingly created separately and have not been merged.

Thank you in advance.

Yours sincerely, 31.200.13.224 05:06, 10 February 2022 (UTC)[reply]

@31.200.13.224:, done! Dirac (talk) 07:43, 10 February 2022 (UTC)[reply]

Thank you very much! 31.200.13.224 08:04, 10 February 2022 (UTC)[reply]

Call for participation in a task-based online experiment

Dear Dirac,

I hope you are doing well,

I am Kholoud, a researcher at King's College London, and I am working on a project as part of my PhD research, in which I have developed a personalised recommender model that suggests Wikidata items for the editors based on their past edits.

I am inviting you to a task-based study that will ask you to provide your judgments about the relevance of the items suggested by our model based on your previous edits. Participation is completely voluntary, and your cooperation will enable us to evaluate the accuracy of the recommender system in suggesting relevant items to you. We will analyse the results anonymised, and they will be published to a research venue. The study should take no more than 15 minutes. If you agree to participate in this study, please either contact me at kholoud.alghamdi@kcl.ac.uk or use this form https://docs.google.com/forms/d/e/1FAIpQLSees9WzFXR0Vl3mHLkZCaByeFHRrBy51kBca53euq9nt3XWog/viewform?usp=sf_link

Then, I will contact you with the link to start the study.

For more information about the study, please read this post: https://www.wikidata.org/wiki/User:Kholoudsaa In case you have further questions or require more information, don't hesitate to contact me through my mentioned email.

Thank you for considering taking part in this research.

Regards Kholoudsaa (talk) 00:05, 14 February 2023 (UTC)[reply]

Descriptions écrasées par openrefine

Bonjour ! J'avais bien fait attention à ne pas cocher "override if present" sur openrefine, et pourtant je vois que mon import (via QuickStatements) remplace les descriptions existantes avec le "personne ayant travaillé sur la transidentité" que je ne veux absolument pas imposer sur les éléments déjà décrits. Sais-tu comment éviter ce souci ? Merci en tout cas de l'avoir remarqué, j'ai mis l'import en pause :) Exilexi (talk) 00:15, 14 October 2023 (UTC)[reply]

Aucune idée! Personnellement, je fais des requêtes SPARQ pour identifier les personnes qui n'ont pas de description, mais ce n'est peut-être pas la meilleur façon de fonctionner, ou qui s'appliquer à votre cas. Peut-être demander à la communauté? Dirac (talk) 00:19, 14 October 2023 (UTC)[reply]

Merci, je vais faire ça ! Exilexi (talk) 00:21, 14 October 2023 (UTC)[reply]

Northwest Territories weather station descriptions

Bonjour Miguel. I noticed that all the Northwest Territories weather station descriptions are misspelled as "North-Western Territory". This seems to be a systematic issue.[1][2][3][4] Can they be batch corrected? OhanaUnited^{Talk page} 17:11, 15 April 2024 (UTC)[reply]

Indeed! I'll fix that soon. Thanks for reporting, Dirac (talk) 15:20, 23 April 2024 (UTC)[reply]

Seems like someone took care of it.

Thank you OhanaUnited! Dirac (talk) 12:53, 3 May 2024 (UTC)[reply]

No problem. I hope I caught every one of them. OhanaUnited^{Talk page} 13:25, 3 May 2024 (UTC)[reply]

User talk:Dirac

Contents

Skype discussion 2017-09-14

Useful links

Changing weather history

Liste des villes du Québec

Les maires et mairesses du Québec

Les mairesses en ordre de la population des villes du Québec

Députés de la 42e législature du Québec

Information sur les stations météo

Q60882708

Trouver les auteurs sans entrées dans Wikidata

Community Insights Survey

(sparql AND categories)

Merge request

Call for participation in a task-based online experiment

Descriptions écrasées par openrefine

Northwest Territories weather station descriptions

Navigation menu

User talk:Dirac

Skype discussion 2017-09-14

Useful links

Changing weather history

Liste des villes du Québec

Les maires et mairesses du Québec

Les mairesses en ordre de la population des villes du Québec

Députés de la 42e législature du Québec

Information sur les stations météo

Q60882708

Trouver les auteurs sans entrées dans Wikidata

Community Insights Survey

(sparql AND categories)

Merge request

Call for participation in a task-based online experiment

Descriptions écrasées par openrefine

Northwest Territories weather station descriptions

Navigation menu

Search