Fix wrongly formatted coordinates in fr_(fr)
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Lokal_Profil
	May 23 2016, 12:43 PM

Description

The following are a list of objects with incorrectly formatted coordinates. Until they are fixed they will not be processed as coordinates (identified in T39422).

This is most commonly due to one of the following:

coordinates set to 0, 0 instead of being left blank
, used instead of . as a decimal separator
latitude and longitude values mixed up
Degree format used instead of decimal format (possibly through a template)
Or the coordinate values simply make no sense (and should be removed)

The relevant pages are:

MariaDB [s51138__heritage_p]> SELECT COUNT(source), source FROM `monuments_fr_(fr)` WHERE (lat='' AND lon='') OR (lat=0 AND lon=0) GROUP BY source;
+---------------+----------------------------------------------------------------------------------------------------------------------------+
| COUNT(source) | source                                                                                                                     |
+---------------+----------------------------------------------------------------------------------------------------------------------------+
|             1 | //fr.wikipedia.org/w/index.php?title=Liste_des_monuments_historiques_de_l%27Ard%C3%A8che&oldid=126335492                   |
|            10 | //fr.wikipedia.org/w/index.php?title=Liste_des_monuments_historiques_de_l%27Aube&oldid=125071516                           |
|            57 | //fr.wikipedia.org/w/index.php?title=Liste_des_monuments_historiques_de_La_R%C3%A9union&oldid=125660928                    |
|            50 | //fr.wikipedia.org/w/index.php?title=Liste_des_monuments_historiques_de_Moulins&oldid=122244819                            |
|            51 | //fr.wikipedia.org/w/index.php?title=Liste_des_monuments_historiques_de_Saint-Denis_%28La_R%C3%A9union%29&oldid=125660953  |
|            20 | //fr.wikipedia.org/w/index.php?title=Liste_des_monuments_historiques_de_Saint-Paul_%28La_R%C3%A9union%29&oldid=125811460   |
|            30 | //fr.wikipedia.org/w/index.php?title=Liste_des_monuments_historiques_de_Saint-Pierre_%28La_R%C3%A9union%29&oldid=125811503 |
+---------------+----------------------------------------------------------------------------------------------------------------------------+

Related Objects

Mentioned Here: T39422: Lat/lon should be NULL when empty

Event Timeline

Lokal_Profil created this task.May 23 2016, 12:43 PM

Restricted Application added subscribers: Zppix, Aklapper. · View Herald TranscriptMay 23 2016, 12:43 PM

JeanFred added subscribers: JeanFred, VIGNERON.May 23 2016, 1:09 PM

Gzen92 is having a look.

Almost clear !

MariaDB [s51138__heritage_p]> SELECT COUNT(source), source FROM `monuments_fr_(fr)` WHERE (lat='' AND lon='') OR (lat=0 AND lon=0) GROUP BY source;
+---------------+---------------------------------------------------------------------------------------------------------------------------+
| COUNT(source) | source                                                                                                                    |
+---------------+---------------------------------------------------------------------------------------------------------------------------+
|             2 | //fr.wikipedia.org/w/index.php?title=Liste_des_monuments_historiques_de_La_R%C3%A9union&oldid=126906125                   |
|             1 | //fr.wikipedia.org/w/index.php?title=Liste_des_monuments_historiques_de_Saint-Denis_%28La_R%C3%A9union%29&oldid=126902465 |
+---------------+---------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.64 sec)

I fixed the last 3 ones. Let’s wait for tomorrow’s harvest to confirm :)

Great work. pass on my thanks to Gzen92

I had missed one... because there are two entries with the same ID number >_>. Oh well, everything should be fine now.

Yay!

SELECT COUNT(source), source FROM `monuments_fr_(fr)` WHERE (lat='' AND lon='') OR (lat=0 AND lon=0) GROUP BY source;
Empty set (0.05 sec)

Fix wrongly formatted coordinates in fr_(fr)Closed, ResolvedPublicActions

Description

Related Objects

Event Timeline

Fix wrongly formatted coordinates in fr_(fr)
Closed, ResolvedPublic
Actions