[OSM-dev] osm2pgsql - strange behaviour

Nick Black nickblack1 at gmail.com
Fri Jun 22 13:24:19 BST 2007


Trying to run osm2pgsql I get some strange values in the geometry columns of
postgis.  For example, if I import the following made up osm file:

<?xml version="1.0" encoding="UTF-8"?>
<osm version="0.4" generator="OpenStreetMap server">
  <way id="1" visible="true" timestamp="2006-08-18T22:51:40+01:00"
    <seg id="1"/>
    <tag k="created_by" v="JOSM"/>
    <tag k="name" v="Marine Drive"/>
    <tag k="highway" v="secondary"/>
  <segment id="1"  visible="true" timestamp="2006-08-18T22:51:40+01:00"
from='1' to='2'>
  <node id='1'  timestamp='2006-08-15 02:08:50' visible='true' lat='1.2345'
    <tag k='source' v='PGS' />
    <tag k='created_by' v='almien_coastlines' />
  <node id='2'  timestamp='2006-08-15 02:08:50' visible='true' lat='2.2345'
    <tag k='source' v='PGS' />
    <tag k='created_by' v='almien_coastlines' />


and then do :

# select astext(way) from planet_osm_roads ;

I get:

 LINESTRING(-755748.02 136514.64,-867067.51 247141.71)

Which isnt what the values should be. Is there some kind of reprojection
going on somewhere?  I have geometry columns and spatial ref sys set up
seemingly correctly, with planet_osm_roads referencing srid 4326, which has
the following entry ins spatial_ref_sys:

GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS 84",6378137,298.257223563
0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4326"]] |
+proj=longlat +ellps=WGS84 +datum=WGS84 +no_defs

I'm taking a look through the osm2pgsql src to see how the database
connections work, but the c++ will take me a while to figure out...


Nick Black
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20070622/33191579/attachment.html>

More information about the dev mailing list