Moving to the Discovery / Interactive (Maps) board for tracking.
This is based on a discovery found in T170022#3423437:
...going through your discovery-stats repo and currently taking a look at the geo_tag table. I'm noticing that sometimes there are geotags in the database that are no longer present on wiki.
For example, the geotag for File:Vossloh Euro 4000 pupitre.JPG got removed: https://commons.wikimedia.org/w/index.php?title=File%3AVossloh_Euro_4000_pupitre.JPG&type=revision&diff=88315031&oldid=86196480 but it's still in the geo_tags table. Do you know if there is any script that performs maintenance on those tables? Do you know who owns the code that adds data to geo_tags when a file on Commons has a location?
Do we have any working examples? The linked page has coordinates embedded into the file itself, and these are coordinates reported by the api. At least for the linked example page there doesn't appear to be any issue
Not the original reporter, and do not know how the extension works. I added the template to a test page:
But doesn't seem to report the coordinates (yet):
@MaxSem Do you know if it only supposed to work on File ns?
I answer myself, it works on a file ns:
Will now remove it and try to reproduce the bug.
The coords are gone from the API:
And from the DB:
Unless there is specific cases (which I cannot discard, for example, if a removal happened during an outage), I would close this as invalid/cannot reproduce. CC @MaxSem
Sounds reasonable. Based on what I see in GeoData code, if a LinksUpdate job is lost the coordinates will remain in the database until the next edit. On the following edit it should be removed. Hopefully we don't lose many LinksUpdate jobs these days.