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
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
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
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
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
5 matches
Mail list logo