[OSM-talk] osm2pgsql enhancements

[Artem Pavlenko]

On 23 Mar 2007, at 08:16, Martin Spott wrote:

> Martin Spott wrote:
>
>> Looks good so far,
>>
>> Table                   Experimental    Stable
>> planet_osm_line         341886          341883
>> planet_osm_point        102685          102685
> [...]
>
>
> ....  but the numerical representation differs. Stable:
>
> landcover=> select asText(wkb_geometry) from planet_osm_point where  
> osm_id = 2;
>                   astext
> ------------------------------------------
>  POINT(8.30237168388211 50.1360073958458)
>
>
> Experimental:
>
> landcover2=> select asText(wkb_geometry) from planet_osm_point  
> where osm_id = 2;
>           astext
> ---------------------------
>  POINT(8.302372 50.136007)
>


'Experimental' is using fixed point numbers to store coordinates,  
which gives about 0.08m deviation.

Cheers
Artem