[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