[Wikidata-bugs] [Maniphest] [Updated] T207839: Batch add WO II war memorials to Wikidata

2019-06-08 Thread Aklapper 
Aklapper added a project: OpenRefine.

TASK DETAIL
  https://phabricator.wikimedia.org/T207839

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Pintoch, Aklapper
Cc: Ecritures, Jane023, Multichill, Footech, Elvalente, Pintoch, RonnieV, 
SIryn, darthmon_wmde, Premeditated, Nandana, Lahi, Gq86, GoranSMilovanovic, 
QZanden, LawExplorer, _jensen, rosalieper, Wikidata-bugs, aude, Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Updated] T207839: Batch add WO II war memorials to Wikidata

2019-06-06 Thread Ecritures 
Ecritures edited projects, added Wikistorm-2019; removed Wikistorm-2018.

TASK DETAIL
  https://phabricator.wikimedia.org/T207839

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Pintoch, Ecritures
Cc: Ecritures, Jane023, Multichill, Footech, Elvalente, Pintoch, RonnieV, 
SIryn, darthmon_wmde, Premeditated, Nandana, Lahi, Gq86, GoranSMilovanovic, 
QZanden, LawExplorer, _jensen, rosalieper, Wikidata-bugs, aude, Mbch331, Yupik, 
Vemonet, A_ka_es, Teffubud, S9a8m, Arybolab, Dja, DDJJ, Harmonia_Amanda, 
Spinster, valhallasw
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Updated] T207839: Batch add WO II war memorials to Wikidata

2018-10-27 Thread Footech 
Footech added a comment.
We decided to ditch the Excel. Instead Maarten scraped Wikipedia for all war memorials in the Netherlands. We cleaned up the data and the used OpenRefine to reconcile and upload the data. We excluded the following items:
-Items without a name
-Items without an ID

All items were specified as 'an instance of ' war memorial. This could be further specified in the further, with the help of the attached Excel.

Some of the following properties were used:
Item name
P276	Location
P3638	Oologsmonument ID
P131	located in the 
P969	located at street adress
P281	Postal code
P625	Coordinates location
P571	Inception

F26883993: oorlogsmonumentenWikipedia.xlsx

SPARQL for Michelle:
SELECT ?oorlogsmonument ?Oorlogsmonument_identificatiecode ?oorlogsmonumentLabel WHERE {

SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
?oorlogsmonument wdt:P31 wd:Q575759.
OPTIONAL { ?oorlogsmonument wdt:P3638 ?Oorlogsmonument_identificatiecode. }
?oorlogsmonument wdt:P17 wd:Q55.

}
LIMIT 100TASK DETAILhttps://phabricator.wikimedia.org/T207839EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Pintoch, FootechCc: Jane023, Multichill, Footech, Elvalente, Pintoch, RonnieV, SIryn, Vemonet, A_ka_es, Teffubud, S9a8m, Arybolab, Dja, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, DDJJ, Harmonia_Amanda, Spinster, Wikidata-bugs, aude, Mbch331, valhallasw___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs