[Tile-serving] Renaming the Gulf of Mexico

[Peter Townsend]

As everyone here is surely aware, the name of the Gulf of Mexico is now the
Gulf of America. I have an extremely ancient osm tile server hailing from
2017 that still receives some use but has never been updated since then. It
basically followed the instructions from switch2osm (like this one here at
https://switch2osm.org/serving-tiles/manually-building-a-tile-server-16-04-2-lts/
).

The name "Gulf of Mexico" only appears in two tiles at zoom level 3, so I
really just need those two tiles updated.

I don't really have the time/resources to go into this server and fully
upgrade it to the latest everything. The planet file is from 2017. It's
using a particularly old stylesheet that isn't supported anymore (based on
https://github.com/MapQuest/MapQuest-Mapnik-Style). I had a crazy idea, why
don't I just go into its postgres database and update some planet_osm_point
records and invalidate the mod_tile cache?

So I did that, but it isn't working.

The gulf's osm id is 305639190, so this updates the point record.
update planet_osm_point
set "name" = 'Gulf of America'
where osm_id = 305639190;

To invalidate the cache, I tried two approaches, changing the zoom 3 meta
file filetime:
touch -t 200001011000
/mnt/tileserver/mod_tile/the-stylesheet-name/3/0/0/0/0/0.meta

I also tried render_expired w/ deleting the meta file:
printf "3/1/3\n3/2/3" | render_expired --map the-stylesheet-name --min-zoom
3 --max-zoom 3 --tile-dir /mnt/tileserver/mod_tile --delete-from 3 --verbose

And still, it says Gulf of Mexico. I restarted apache, I restarted the
server, it just keeps saying Gulf of Mexico. I don't believe it's also
running mapproxy (didn't see any reference to it in the apache configs) or
any other cache in front of it. Render stats do go up when I access the
tile url directly and logging appears in ./var/log/syslog.

I'm hoping someone on this mailing list might have another idea to try. Or
perhaps knows why it seems to be pulling the old string out of somewhere
else.

-- 
Peter Townsend
Senior Software Developer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20250221/5a8286a8/attachment.htm>