Help transferring list of monuments - WikiLovesMonuments

Mārtiņš Bruņenieks

22 Jul 22 Jul

8:02 a.m.

Hi! Take a look at OpenRefine, it can map spreadsheet data to Wikidata items/properties I think this is a very good demo: https://media.ed.ac.uk/media/OpenRefine+Beginners+Tutorial/0_y5bxsswq As of properties to use, look at similar items like this https://www.wikidata.org/wiki/Q3744576 Mārtiņš On Wed, Jul 22, 2020 at 10:48 AM Neville Borg <neville.borg(a)wikimalta.org> wrote:

...

Hi everyone, We're looking for some advice/help/guidance - we would like to update our list of monuments <https://en.wikipedia.org/wiki/List_of_monuments_in_Malta> that are eligible for this year's edition of WLM to include a list of properties scheduled by Malta's Planning Authority. We currently have this list as a spreadsheet - what is the best way to go about transferring this to Wikidata and Wikipedia? Is there a way to bulk transfer this list? Thanks, Neville -- Administrator Wikimedia Community Malta <http://www.wikimalta.org> _______________________________________________ Wiki Loves Monuments mailing list WikiLovesMonuments(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org

Reply

Sara Thomas

28 Jul 28 Jul

12:42 p.m.

Hi there, You could also use Quickstatements - works best in Firefox: https://www.wikidata.org/wiki/Help:QuickStatements Best, Sara On Wed, 22 Jul 2020 at 09:57, Philip Kopetzky <philip.kopetzky(a)gmail.com> wrote:

...

You can then also build a list with the ListeriaBot, one example with an embedded upload link with a campaign would be https://en.wikipedia.org/wiki/User:Braveheart/List_of_provincial_parks_of_B… BR, Philip On Wed, 22 Jul 2020 at 10:30, Mārtiņš Bruņenieks <martinsb(a)gmail.com> wrote:

Hi! Take a look at OpenRefine, it can map spreadsheet data to Wikidata items/properties I think this is a very good demo: https://media.ed.ac.uk/media/OpenRefine+Beginners+Tutorial/0_y5bxsswq As of properties to use, look at similar items like this https://www.wikidata.org/wiki/Q3744576 Mārtiņš On Wed, Jul 22, 2020 at 10:48 AM Neville Borg <neville.borg(a)wikimalta.org> wrote:

Hi everyone, We're looking for some advice/help/guidance - we would like to update our list of monuments <https://en.wikipedia.org/wiki/List_of_monuments_in_Malta> that are eligible for this year's edition of WLM to include a list of properties scheduled by Malta's Planning Authority. We currently have this list as a spreadsheet - what is the best way to go about transferring this to Wikidata and Wikipedia? Is there a way to bulk transfer this list? Thanks, Neville -- Administrator Wikimedia Community Malta <http://www.wikimalta.org> _______________________________________________ Wiki Loves Monuments mailing list WikiLovesMonuments(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org

_______________________________________________ Wiki Loves Monuments mailing list WikiLovesMonuments(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org

-- Dr Sara Thomas Scotland Programme Coordinator, Wikimedia UK 07803 505 172 https://wikimedia.org.uk/wiki/Wikimedia_in_Scotland *I work part time and am not in the office on Mondays. * *Wikimedia UK* is the national chapter for the global Wikimedia open knowledge movement. We rely on donations from individuals to support our work to make knowledge open for all. Have you considered supporting Wikimedia? https://donate.wikimedia.org.uk Wikimedia UK is a Company Limited by Guarantee registered in England and Wales, Registered No. 6741827. Registered Charity No.1144513. (England & Wales), SC048644 (Scotland). Registered Office Ground Floor, Europoint, 5 - 11 Lavington Street, London SE1 0NZ <https://maps.google.com/?q=5+-+11+Lavington+Street,+London+SE1+0NZ&entry=gmail&source=g> . Wikimedia UK is the UK chapter of a global Wikimedia movement. The Wikimedia projects are run by the Wikimedia Foundation (who operate Wikipedia, amongst other projects). *Wikimedia UK is an independent non-profit charity with no legal control over Wikipedia nor responsibility for its contents.*

Reply

Sara Thomas

2 p.m.

side point, but a QS vs OR guideline would be AMAZING. S On Tue, 28 Jul 2020 at 14:53, Nicolas VIGNERON <vigneron.nicolas(a)gmail.com> wrote:

...

Hi, Good point Sara ! I really need to write a QuickStatements vs. OpenRefine guideline someday... In a nutshell: both tools are similar and used to import data into Wikidata. QuickStatements is (arguably) a bit easier and quicker to use but less powerful (it doesn't spot duplicates, don't do reconciliation, etc.). In the end, I guess it depends on how many monuments of Malta already have items on Wikidata and what/how much data you want to import. If there are more than ~20 % with items then creating duplicates is a bad idea (more time will be lost afterward to spot and correct the duplicate) and you should prefer OpenRefine. But you can also try to spot the duplicate before and still use QuickStatement. In both cases, if you need help, don't hesitate to ask. Meanwhile, here is a quick query showing items already on Wikidata for things in Malta with an heritage designation : https://w.wiki/Y7$ (I see 10 type of heritage in this list: 3 being related to World Heritage Site, one for Nature, one for Inventory and types who looks more-or-less like the heritage in England : Class A, Class B, Grade 1, Grade 2, Grade 3) which allows to do this first draft map : https://w.wiki/Y85 Cheers, ~nicolas Le mar. 28 juil. 2020 à 14:43, Sara Thomas <sara.thomas(a)wikimedia.org.uk> a écrit :

Hi there, You could also use Quickstatements - works best in Firefox: https://www.wikidata.org/wiki/Help:QuickStatements Best, Sara On Wed, 22 Jul 2020 at 09:57, Philip Kopetzky <philip.kopetzky(a)gmail.com> wrote:

You can then also build a list with the ListeriaBot, one example with an embedded upload link with a campaign would be https://en.wikipedia.org/wiki/User:Braveheart/List_of_provincial_parks_of_B… BR, Philip On Wed, 22 Jul 2020 at 10:30, Mārtiņš Bruņenieks <martinsb(a)gmail.com> wrote:

Hi! Take a look at OpenRefine, it can map spreadsheet data to Wikidata items/properties I think this is a very good demo: https://media.ed.ac.uk/media/OpenRefine+Beginners+Tutorial/0_y5bxsswq As of properties to use, look at similar items like this https://www.wikidata.org/wiki/Q3744576 Mārtiņš On Wed, Jul 22, 2020 at 10:48 AM Neville Borg < neville.borg(a)wikimalta.org> wrote: > Hi everyone, > > We're looking for some advice/help/guidance - we would like to update > our list of monuments > <https://en.wikipedia.org/wiki/List_of_monuments_in_Malta> that are > eligible for this year's edition of WLM to include a list of properties > scheduled by Malta's Planning Authority. We currently have this list as a > spreadsheet - what is the best way to go about transferring this to > Wikidata and Wikipedia? Is there a way to bulk transfer this list? > > Thanks, > Neville > > -- > > Administrator > Wikimedia Community Malta <http://www.wikimalta.org> > _______________________________________________ > Wiki Loves Monuments mailing list > WikiLovesMonuments(a)lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments > http://www.wikilovesmonuments.org _______________________________________________ Wiki Loves Monuments mailing list WikiLovesMonuments(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org

_______________________________________________ Wiki Loves Monuments mailing list WikiLovesMonuments(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org

-- Dr Sara Thomas Scotland Programme Coordinator, Wikimedia UK 07803 505 172 https://wikimedia.org.uk/wiki/Wikimedia_in_Scotland *I work part time and am not in the office on Mondays. * *Wikimedia UK* is the national chapter for the global Wikimedia open knowledge movement. We rely on donations from individuals to support our work to make knowledge open for all. Have you considered supporting Wikimedia? https://donate.wikimedia.org.uk Wikimedia UK is a Company Limited by Guarantee registered in England and Wales, Registered No. 6741827. Registered Charity No.1144513. (England & Wales), SC048644 (Scotland). Registered Office Ground Floor, Europoint, 5 - 11 Lavington Street, London SE1 0NZ <https://maps.google.com/?q=5+-+11+Lavington+Street,+London+SE1+0NZ&entry=gmail&source=g> . Wikimedia UK is the UK chapter of a global Wikimedia movement. The Wikimedia projects are run by the Wikimedia Foundation (who operate Wikipedia, amongst other projects). *Wikimedia UK is an independent non-profit charity with no legal control over Wikipedia nor responsibility for its contents.* _______________________________________________ Wiki Loves Monuments mailing list WikiLovesMonuments(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org

_______________________________________________ Wiki Loves Monuments mailing list WikiLovesMonuments(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org

-- Dr Sara Thomas Scotland Programme Coordinator, Wikimedia UK 07803 505 172 https://wikimedia.org.uk/wiki/Wikimedia_in_Scotland *I work part time and am not in the office on Mondays. * *Wikimedia UK* is the national chapter for the global Wikimedia open knowledge movement. We rely on donations from individuals to support our work to make knowledge open for all. Have you considered supporting Wikimedia? https://donate.wikimedia.org.uk Wikimedia UK is a Company Limited by Guarantee registered in England and Wales, Registered No. 6741827. Registered Charity No.1144513. (England & Wales), SC048644 (Scotland). Registered Office Ground Floor, Europoint, 5 - 11 Lavington Street, London SE1 0NZ <https://maps.google.com/?q=5+-+11+Lavington+Street,+London+SE1+0NZ&entry=gmail&source=g> . Wikimedia UK is the UK chapter of a global Wikimedia movement. The Wikimedia projects are run by the Wikimedia Foundation (who operate Wikipedia, amongst other projects). *Wikimedia UK is an independent non-profit charity with no legal control over Wikipedia nor responsibility for its contents.*

Reply

Nicolas VIGNERON

22 Jul 22 Jul

8:30 a.m.

Hi Neville, It would help to see the original spreadsheet to see exactly what we are dealing with. For the Wikipedia part, I'm not entirely sure (I'm not a specialist of the templates on en.wp ). For Wikidata, OpenRefine[1] is probably the best tool. Here I know this tool and I can probably help (or maybe even do it for you, depending on the work and available time). Plus, I see there is a NICPMI identifier in Wikidata which will help a lot (to spot duplicates - because it's not just a bulk transfer as you don't want to import what is already in Wikidata ;) - and to align/augment data), I hope this identifier is in your spreadsheet too. PS: maybe we can continue in private or in a small group if other people are interested (either to help for Malta or in a similar situation in an other country). Cheers, ~nicolas [1] https://www.wikidata.org/wiki/Wikidata:Tools/OpenRefine Le mer. 22 juil. 2020 à 09:49, Neville Borg <neville.borg(a)wikimalta.org> a écrit :

...

Hi everyone, We're looking for some advice/help/guidance - we would like to update our list of monuments <https://en.wikipedia.org/wiki/List_of_monuments_in_Malta> that are eligible for this year's edition of WLM to include a list of properties scheduled by Malta's Planning Authority. We currently have this list as a spreadsheet - what is the best way to go about transferring this to Wikidata and Wikipedia? Is there a way to bulk transfer this list? Thanks, Neville -- Administrator Wikimedia Community Malta <http://www.wikimalta.org> _______________________________________________ Wiki Loves Monuments mailing list WikiLovesMonuments(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org

Reply