[Wikidata-bugs] [Maniphest] T283576: Look in the database for malformed globe-coordiante precisions

Addshore closed this task as "Resolved". Addshore added a comment. This part of this task looks good to me TASK DETAIL https://phabricator.wikimedia.org/T283576 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Rosalie_WMDE, Addshore Cc:

[Wikidata-bugs] [Maniphest] T283576: Look in the database for malformed globe-coordiante precisions

Lucas_Werkmeister_WMDE added a comment. In T283576#7141092 , @Ladsgroup wrote: > Three notes: > > - Please edit your message and link to the paste instead of transcluding it (with {}). It's around 100K lines and It takes really long

[Wikidata-bugs] [Maniphest] T283576: Look in the database for malformed globe-coordiante precisions

Silvan_WMDE added a comment. The script looks good and the findings are consistent with error messages found in logstash: 262 corresponding "RDF builder" error messages have been logged in the last 90 days, but none are

[Wikidata-bugs] [Maniphest] T283576: Look in the database for malformed globe-coordiante precisions

Rosalie_WMDE added a comment. There are 2 affected items with malformed coordinates. Item ID-Precision Q3629997 146706019195900 Q3642430 146706019195900 TASK DETAIL https://phabricator.wikimedia.org/T283576 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T283576: Look in the database for malformed globe-coordiante precisions

Rosalie_WMDE added a comment. new script https://gist.github.com/rosalieper/83354c6677c92a008f412b21d7d41575. Thanks for the feedbacks @Ladsgroup. I Will post the results of the script once it is done runing. TASK DETAIL https://phabricator.wikimedia.org/T283576 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T283576: Look in the database for malformed globe-coordiante precisions

Ladsgroup added a comment. Three notes: - Please edit your message and link to the paste instead of transcluding it (with {}). It's around 100K lines and It takes really long time to open this ticket now and my computer basically freezes because it's massive - We need to check for

[Wikidata-bugs] [Maniphest] T283576: Look in the database for malformed globe-coordiante precisions

Rosalie_WMDE added a comment. I got a list of Items that give a precision = null for statements with coordinate location(P625 ), But for some reason, Q3642430 is not part of the list. P16319 Items with

[Wikidata-bugs] [Maniphest] T283576: Look in the database for malformed globe-coordiante precisions

Ladsgroup added a comment. It should at least find https://www.wikidata.org/wiki/Q3642430 too. TASK DETAIL https://phabricator.wikimedia.org/T283576 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Rosalie_WMDE, Ladsgroup Cc: Ladsgroup, Esc3300,

[Wikidata-bugs] [Maniphest] T283576: Look in the database for malformed globe-coordiante precisions

Esc3300 added a comment. There was a report on Contact_the_development_team about the coordinates of St John's College (Q691283)

[Wikidata-bugs] [Maniphest] T283576: Look in the database for malformed globe-coordiante precisions

Rosalie_WMDE added a comment. I ran this python script on https://dumps.wikimedia.org/wikidatawiki/entities/latest-all.json.bz2 and it ran for about 4 hours, ( did not complete but I terminated it, as the json dump in about 62G of data) . Nevertheless for those 5 hours I did not get a

[Wikidata-bugs] [Maniphest] T283576: Look in the database for malformed globe-coordiante precisions

Rosalie_WMDE claimed this task. TASK DETAIL https://phabricator.wikimedia.org/T283576 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Rosalie_WMDE Cc: Aklapper, Addshore, ItamarWMDE, Invadibot, maantietaja, Akuckartz, Iflorez, alaa_wmde, Nandana,

[Wikidata-bugs] [Maniphest] T283576: Look in the database for malformed globe-coordiante precisions

ItamarWMDE renamed this task from "Look in the database malformed globe-coordiante precisions" to "Look in the database for malformed globe-coordiante precisions". TASK DETAIL https://phabricator.wikimedia.org/T283576 EMAIL PREFERENCES