Redirecting a file with location data, e.g.
https://commons.wikimedia.org/w/index.php?title=File:Berlin,_Germany_-_panoramio.jpg&redirect=no
leaves two entries in the geo_tags table. See the entries for the above file and its redirect in geo_tags
use commonswiki_p; select * from page where page_id in (55516538,54304734); select * from geo_tags where gt_page_id in (55516538,54304734);
(It is ok to find two entries in the page table, one marked as the redirect)
For the redirect, there are no location data in the redirect any more, but any app using geo_tags will find it still. Especially in case of wrong location data, it is not clear where to fix for the redirect.
I tried to add coordinates to a redirect and remove them again, and this will clear the entry for the redirect in geo_tags. Purging didn't.
What has to be done:
- any rename should remove the (old) file with its location data from db-table geo_tags
- a purge should also remove any remainders from the geo_tags table
- do necessary cleanup: remove location data for redirects left in geo_tags, if there are no longer location data in the redirect.