[OSM-talk] osm2pgsql enhancements
Martin Spott
Martin.Spott at mgras.net
Fri Mar 23 08:16:06 GMT 2007
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)
Stable:
landcover=> select asText(wkb_geometry) from planet_osm_point where osm_id = 100704;
astext
------------------------------------------
POINT(15.5464110374742 58.4113275664169)
Experimental:
landcover2=> select asText(wkb_geometry) from planet_osm_point where osm_id = 100704;
astext
----------------------------
POINT(15.546411 58.411328)
Cheers,
Martin.
--
Unix _IS_ user friendly - it's just selective about who its friends are !
--------------------------------------------------------------------------
More information about the talk
mailing list