On 11/1/2015 5:27 AM, Bruno Remy wrote:

By the evidence, this is a database problem in osm2pgsql <http://wiki.openstreetmap.org/wiki/Databases_and_data_access_APIs#Osm2pgsql> schema , witch is used by Mapnik's rendering process. The most probable hypothesis is : some old nodes and old ways still exists in 'OldNode' and 'OldWay' tables, with the "visible" status as 'true' instead of 'false'.
See the shema for reference:
http://wiki.openstreetmap.org/w/images/c/cd/RailsPortModels.png

My suggested solution:
Create a brand new collection of nodes with the position of "all fantom nodes", and sending'them to the Tech tem of OSM. They'll be able to run a query into the 'OldNode' and 'OldWay' tables and switch the "visible" status from 'true' to 'false'.

Don't do this. The rendering database doesn't have OldNode or OldWay tables or a visible status. For that matter, the master apidb database doesn't have those tables either, it has ways and currentways tables.

This is normally where I'd give a solution, but I don't have one. It's an osm2pgsql bug, not a DB bug, but without a reproducible testcase and verification that the bug happens on recent versions, it becomes a significant effort to get anywhere.
_______________________________________________
Talk-ca mailing list
Talk-ca@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-ca

Reply via email to