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

[Brett Henderson]

Oh crap, apparently I didn't test that bit.  I never did get the mysql 
extensions installed to compare against.

I doubt if I'll get to this for a few days, bit run off my feet at the 
moment.  I don't know what the problem is but perhaps Java is doing some 
unexpected rounding along the way.

Christopher Schmidt wrote:
> 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,
>