Re: [OSM-talk] OSM2PQSQL / PostGis: Coordinate Conversion

2010-02-22 Thread d8930
Strange enough, I still get the wrong result, even when using 100.0 instead of 100. The extra ) was because I copied the line from Java code. Maybe somethings wrong with my spatial_ref_sys table. I have two entries: 4326;EPSG; 4326; GEOGCS[WGS 84,DATUM[WGS_1984,SPHEROID[WGS

Re: [OSM-talk] OSM2PQSQL / PostGis: Coordinate Conversion

2010-02-22 Thread d8930
d8930 wrote: It works for me, though there was an extra ) in what you quoted. gis= select astext(ST_Transform(ST_SetSRID(ST_MakePoint(92409686/100,646985238/100),900913), 4326)); astext - POINT

Re: [OSM-talk] OSM2PQSQL / PostGis: Coordinate Conversion

2010-02-22 Thread d8930
d8930 wrote: Strange enough, I still get the wrong result, even when using 100.0 instead of 100. The extra ) was because I copied the line from Java code. Maybe somethings wrong with my spatial_ref_sys table. I have two entries: 4326;EPSG; 4326; GEOGCS[WGS 84,DATUM[WGS_1984

Re: [OSM-talk] OSM2PQSQL / PostGis: Coordinate Conversion

2010-02-22 Thread d8930
Sorry for spamming. I found out that it has to deal with the 4326 entry. I have added the projection 4324 from the Postgis installation package, and I get quite precise results: POINT(8.30107722233746 50.1359315159791) Nevertheless, this result differs a few meters from the one you obtained with

Re: [OSM-talk] OSM2PQSQL / PostGis: Coordinate Conversion

2010-02-21 Thread d8930
Hi, I am working on this as well. However, for testing I am using a point that lies in the German city of Wiesbaden-Naurod. This city has the geocoordinates 8.301388 / 50.13472. When I transform it by SELECT astext(ST_Transform(ST_SetSRID(ST_MakePoint(8.301388,50.13472), 4326), 900913)) I get the