[OSM-dev] Osmosis Bug Report: Node TileIDs Incorrect

[Christopher Schmidt]

Osmosis creates incorrect tile IDs for some nodes when reading from XML
and inserting into MySQL.

For the node:

<node id="21619242" lat="51.4781325" lon="-0.1474929" user="Osmosis
    System User" visible="true" timestamp="2007-11-11T09:11:14-05:00">

Osmosis generates:

2062265655

tile_for_point generates:

16:35:51 < crschmidt> select tile_for_point(514781325,-01474929);
16:35:56 < crschmidt> | tile_for_point(514781325,-01474929) |
16:35:56 < crschmidt> +-------------------------------------+
16:35:56 < crschmidt> |                          2062265654 | 

Updating a table with 115000 nodes in it says:

mysql> update current_nodes set tile=tile_for_point(latitude,
                                                    longitude);
Query OK, 103333 rows affected (11.41 sec)
Rows matched: 115692  Changed: 103333  Warnings: 0

Which means, I guess, that 12000 (~10%) ended up okay, and everything
else was (presumably) off by one.

Regards,
-- 
Christopher Schmidt
MetaCarta