[OSM-dev] Osmosis apidb schema - "visible" column and deleted nodes/ways/relations ?

Toby Murray toby.murray at gmail.com
Sun Oct 9 18:42:03 BST 2011


On Sun, Oct 9, 2011 at 9:12 AM, kimaidou <kimaidou at gmail.com> wrote:
> Hi list,
>
> I am trying to set up and osmosis database (apidb schema). Installation and
> data importation are done. I would like to know what exactly does the column
> "visible" represent in the nodes and ways tables ? I thought "visible =
> False" meant "the node/way has been deleted, but I checked, and for example,
> this node (with visible = False) does still exist :
> http://www.openstreetmap.org/browse/node/26694402
>
> What is the best way to find which nodes/ways have been deleted between to
> diff diles imports ?

I believe you are correct. The node in question has never had
visible=false according to its full history:
http://www.openstreetmap.org/api/0.6/node/26694402/history

So I don't know why your database would indicate that it is not visible.

Toby



More information about the dev mailing list