User:Nattes à chat/witchmaps
Wikitechstorm 2019
[edit]Atelier carte
[edit]- integrate a map i https://github.com/ookgezellig/WikidataMapMakingWorkshop
Integrating a map into wikipedia using the kartographer extension
Other ressources (people)
[edit]- Addicted04 seems to create lots of maps centered on the use of languages using the format of a globe https://commons.wikimedia.org/wiki/User_talk:Addicted04#Venezuela_map
User:Addicted04 see https://commons.wikimedia.org/wiki/File:Spanish_Wikipedia_by_users.svg https://en.wikipedia.org/wiki/User:Gringer/perlshaper
- the francophone witch map was made by
- the wikitechstorm map workshop was made by Olaf Janssen
Olaf Janssen, Wikimedia coordinator of the national library of The Netherlands - https://www.kb.nl/wikipedia olaf.janssen@kb.nl User:OlafJanssen on (Dutch) Wikipedia, Wikimedia Commons and Wikidata Twitter: @ookgezellig
- another gifte3d cartographer : Sic19#Geoshapes
https://www.wikidata.org/wiki/User:Sic19#Geoshapes
Module 1 basic flat and layered maps in wikidata
[edit]1. make a sparql query with your own set of P265 data
Layering
[edit]exemple : https://query.wikidata.org/#%23All%20public%20library%20branches%20of%20the%20Netherlands%2C%20layered%20by%20province%0A%0A%23defaultView%3AMap%7B%22hide%22%3A%5B%22%3FdplLoc%22%5D%2C%22layer%22%3A%22%3FprovLabel%22%7D%0A%0ASELECT%20DISTINCT%20%3Fdpl%20%3FdplLabel%20%3FdplImage%20%3FdplLoc%20%3FmuniLabel%20%3FprovLabel%20WHERE%20%7B%0A%20%20%3Fdpl%20p%3AP31%2Fps%3AP31%20wd%3AQ28564%2Cwd%3AQ11396180%3Bwdt%3AP17%20wd%3AQ55.%20%23public%20library%20branch%20in%20The%20Netherlands%20%0A%20%20%3Fdpl%20wdt%3AP625%20%3FdplLoc.%20%23Geo%20location%20of%20the%20dpl%0A%20%20OPTIONAL%7B%3Fdpl%20wdt%3AP18%20%3FdplImage%7D%20%23Image%20of%20the%20dpl%7D%20%0A%20%20%0A%20%20%23---%20Find%20the%20municipality%20the%20libraty%20is%20in%0A%20%20%3Fdpl%20wdt%3AP131%20%3Fmuni.%20%23municipality%20derived%20from%20library%20item%2C%20has%20one%20single%20value%0A%20%20%3Fmuni%20p%3AP31%20%5Bps%3AP31%20%3FmuniIsA%5D.%0A%20%20VALUES%20%3FmuniIsA%20%7Bwd%3AQ2039348%7D%0A%20%20%23Instead%20of%20the%20the%20above%20line%2C%20you%20can%20also%20do%3A%20FILTER%28%3FmuniIsA%20%3D%20wd%3AQ2039348%29%20%0A%20%20%0A%20%20%23--%20Find%20the%20province%20the%20municipality%20is%20in%0A%20%20%3Fmuni%20wdt%3AP131%20%3Fprov.%20%20%23find%20the%20province%0A%20%20%3Fprov%20p%3AP31%20%5Bps%3AP31%20%3FprovIsA%5D.%0A%20%20VALUES%20%3FprovIsA%20%7Bwd%3AQ134390%7D%20%23Only%3A%20province%20of%20the%20Netherlands%20%28Q134390%29%20%0A%20%20%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%7D%20%20%0A%20%0A%7D%0AORDER%20BY%20%3FprovLabel début : mettre #defaultView:Map{"hide":["?item"],"layer":"?item"} en haut => coloration des points https://query.wikidata.org/#%23defaultView%3AMap%0A%23defaultView%3AMap%7B%22hide%22%3A%5B%22%3Fitem%22%5D%2C%22layer%22%3A%22%3Fitem%22%7D%0ASELECT%0A%20%20%3Fitem%0A%20%20%3FitemLabel%0A%20%20%3FdeathPlaceLabel%0A%20%20%3Fcoords%0A%0A%20%20%28if%28BOUND%28%3Flinkfr%29%2C%20concat%28%27%5B%5B%27%2C%20substr%28str%28%3Flinkfr%29%2C31%2C500%29%2C%20%20%27%7C%27%2C%20%3FitemLabel%2C%20%27%5D%5D%27%29%2C%20%3FitemLabel%29%0A%20%20%20as%20%3Ftitle%29%0A%20%20%28concat%28%27d%C3%A9c%C3%A8s%20en%20%27%2C%0A%20%20%20%20if%20%28BOUND%28%3Fdeath%29%2C%20str%28YEAR%28%3Fdeath%29%29%2C%20%27-%20date%20inconnue%20-%27%29%2C%0A%20%20%20%20%27%20%C3%A0%20%27%2C%0A%20%20%20%20%3FdeathPlaceLabel%2C%0A%20%20%20%20%27%5Cn%5Cn%27%2C%0A%20%20%20%20if%28BOUND%28%3Fimage%29%2C%20concat%28%27%5B%5BFile%3A%27%2C%20substr%28str%28%3Fimage%29%2C%2052%2C%20500%29%2C%20%27%7C200px%5D%5D%27%29%2C%20%27%27%29%2C%0A%20%20%20%20if%20%28BOUND%28%3Flinken%29%2C%20concat%28%27%20%5B%5B%3Aen%3A%27%2C%20substr%28str%28%3Flinken%29%2C31%2C500%29%2C%20%20%27%7C%28en%29%5D%5D%27%29%2C%20%27%27%29%2C%0A%20%20%20%20if%20%28BOUND%28%3Flinkde%29%2C%20concat%28%27%20%5B%5B%3Ade%3A%27%2C%20substr%28str%28%3Flinkde%29%2C31%2C500%29%2C%20%20%27%7C%28de%29%5D%5D%27%29%2C%20%27%27%29%2C%0A%20%20%20%20if%20%28BOUND%28%3Flinkes%29%2C%20concat%28%27%20%5B%5B%3Aes%3A%27%2C%20substr%28str%28%3Flinkes%29%2C31%2C500%29%2C%20%20%27%7C%28es%29%5D%5D%27%29%2C%20%27%27%29%2C%0A%20%20%20%20if%20%28BOUND%28%3Flinkno%29%2C%20concat%28%27%20%5B%5B%3Ano%3A%27%2C%20substr%28str%28%3Flinkno%29%2C31%2C500%29%2C%20%20%27%7C%28no%29%5D%5D%27%29%2C%20%27%27%29%0A%20%20%29%0A%20%20%20as%20%3Fdescription%29%0A%20%20%28%271000%27%20as%20%3Frandomise%29%0A%20%20%3Flinkfr%0A%20%20%3Flinkde%0A%20%20%3Flinken%0A%20%20%3Flinkes%0A%20%20%3Flinkno%0AWHERE%20%7B%0A%20%20%7B%20%3Fitem%20wdt%3AP1399%20wd%3AQ259745.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Fitem%20wdt%3AP1595%20wd%3AQ259745.%20%7D%0A%20%20%3Fitem%20wdt%3AP20%20%3FdeathPlace.%0A%20%20%3FdeathPlace%20wdt%3AP625%20%3Fcoords.%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP21%20%3Fgender.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP570%20%3Fdeath.%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22fr%2Cen%22.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP18%20%3Fimage.%20%7D%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Flinkfr%20schema%3Aabout%20%3Fitem%20.%0A%20%20%20%20%3Flinkfr%20schema%3AisPartOf%20%3Chttps%3A%2F%2Ffr.wikipedia.org%2F%3E%20.%0A%20%20%7D%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Flinkde%20schema%3Aabout%20%3Fitem%20.%0A%20%20%20%20%3Flinkde%20schema%3AisPartOf%20%3Chttps%3A%2F%2Fde.wikipedia.org%2F%3E%20.%0A%20%20%7D%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Flinken%20schema%3Aabout%20%3Fitem%20.%0A%20%20%20%20%3Flinken%20schema%3AisPartOf%20%3Chttps%3A%2F%2Fen.wikipedia.org%2F%3E%20.%0A%20%20%7D%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Flinkes%20schema%3Aabout%20%3Fitem%20.%0A%20%20%20%20%3Flinkes%20schema%3AisPartOf%20%3Chttps%3A%2F%2Fes.wikipedia.org%2F%3E%20.%0A%20%20%7D%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Flinkno%20schema%3Aabout%20%3Fitem%20.%0A%20%20%20%20%3Flinkno%20schema%3AisPartOf%20%3Chttps%3A%2F%2Fno.wikipedia.org%2F%3E%20.%0A%20%20%7D%0A%20%20%0A%7D
Integrating maps
[edit]see : https://www.mediawiki.org/wiki/Extension:Kartographer
Module 3
[edit]Open Refine
[edit]Atelier Wikitechstorm novembre 2019 https://m.mediawiki.org/wiki/Wiki_Techstorm/Programme/Wikidata_and_OpenRefine Task : genérer des desc en français qui ne soient pas mégenrées sur https://fr.wikipedia.org/wiki/Projet:Les_sans_pagEs/Listeria/ListeInformaticiennes -1- générer la requete SPARQL
(pour trouver comment afficher la desc) titre: ItemLabel https://w.wiki/CWk
puis télécharger sous format CSV
-2- importer dans open refine -
-3- créer projet (pas oublier de lui donner un nom)
intégrer le français voir ici : https://tools.wmflabs.org/openrefine-wikidata/ (remplacer en par fr (https://tools.wmflabs.org/openrefine-wikidata/fr/api)
-4- réconcilier Q5 avec Q5
https://tools.wmflabs.org/openrefine-wikidata/ -5- seule la desc en Anglais apparait =>
-6- pour générer la desc https://tools.wmflabs.org/autodesc
cela ne le fait que pour un élément Q et on veut ça pour tous les éléments de la colonne (dans le projet open refine)
puis exporter en JSON -7- intégrer APi générant desc automatiquement dans wikidata (en français)
PRENDRE URL coller à la place de value. Il faut encore changer le Q
other queries
[edit]Occupation of accused witches
New witch map on wordpress
[edit]LIEN VERS REQUETE SPARQL Aout 2021 carte mise ici https://wordpress.com/view/sanspages.org
code
[edit]- defaultView:Map
- defaultView:Map{"hide":["?item","?item"]}
SELECT
?item ?itemLabel ?deathPlaceLabel ?coords (if(BOUND(?linkfr), concat('', ?itemLabel, ''), ?itemLabel) as ?title) (concat('décès en ', if (BOUND(?death), str(YEAR(?death)), '- date inconnue -'), ' à ', ?deathPlaceLabel, '\n\n', if(BOUND(?image), concat('File:', substr(str(?image), 52, 500), ''), ), if (BOUND(?linken), concat(' (en)'), ), if (BOUND(?linkde), concat(' (de)'), ), if (BOUND(?linkes), concat(' (es)'), ), if (BOUND(?linkno), concat(' (no)'), ) ) as ?description) ('1000' as ?randomise) ?linkfr ?linkde ?linken ?linkes ?linkno
WHERE {
{ ?item wdt:P1399 wd:Q259745. } UNION { ?item wdt:P1595 wd:Q259745. } ?item wdt:P20 ?deathPlace. ?deathPlace wdt:P625 ?coords. OPTIONAL { ?item wdt:P21 ?gender. } OPTIONAL { ?item wdt:P570 ?death. } SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,en". } OPTIONAL { ?item wdt:P18 ?image. } OPTIONAL { ?linkfr schema:about ?item . ?linkfr schema:isPartOf <https://fr.wikipedia.org/> . } OPTIONAL { ?linkde schema:about ?item . ?linkde schema:isPartOf <https://de.wikipedia.org/> . } OPTIONAL { ?linken schema:about ?item . ?linken schema:isPartOf <https://en.wikipedia.org/> . } OPTIONAL { ?linkes schema:about ?item . ?linkes schema:isPartOf <https://es.wikipedia.org/> . } OPTIONAL { ?linkno schema:about ?item . ?linkno schema:isPartOf <https://no.wikipedia.org/> . }
}