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
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@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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
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_Br...
BR, Philip
On Wed, 22 Jul 2020 at 10:30, Mārtiņš Bruņenieks martinsb@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@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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
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@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_Br...
BR, Philip
On Wed, 22 Jul 2020 at 10:30, Mārtiņš Bruņenieks martinsb@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@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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
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@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@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_Br...
BR, Philip
On Wed, 22 Jul 2020 at 10:30, Mārtiņš Bruņenieks martinsb@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@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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
Wiki Loves Monuments mailing list WikiLovesMonuments@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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
side point, but a QS vs OR guideline would be AMAZING.
S
On Tue, 28 Jul 2020 at 14:53, Nicolas VIGNERON vigneron.nicolas@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@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@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_Br...
BR, Philip
On Wed, 22 Jul 2020 at 10:30, Mārtiņš Bruņenieks martinsb@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@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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
Wiki Loves Monuments mailing list WikiLovesMonuments@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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
Dear all,
Thank you so much for your suggestions and advice, I really appreciate it.
I've been trying to use OpenRefine by following the tutorial that was posted, but I seem to be having some difficulties and I'm not entirely sure where I'm going wrong. Nicolas - perhaps I can write to you off-list to discuss this a little further? I don't want to take too much of your time, but any pointers you could give me would be much appreciated.
Thanks, Neville
On Tue, 28 Jul 2020 at 16:00, Sara Thomas sara.thomas@wikimedia.org.uk wrote:
side point, but a QS vs OR guideline would be AMAZING.
S
On Tue, 28 Jul 2020 at 14:53, Nicolas VIGNERON vigneron.nicolas@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@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@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_Br...
BR, Philip
On Wed, 22 Jul 2020 at 10:30, Mārtiņš Bruņenieks martinsb@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@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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
Wiki Loves Monuments mailing list WikiLovesMonuments@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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
Wiki Loves Monuments mailing list WikiLovesMonuments@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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
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@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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
wikilovesmonuments@lists.wikimedia.org