On 22 February 2010 10:51, d8930 wrote:
> 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 dif
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
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",D
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(8.301
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
On Fri, 2010-02-19 at 08:19 -0800, d8930 wrote:
> 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
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
On Wed, 2010-01-13 at 20:39 +, Jon Burgess wrote:
> On Wed, 2010-01-13 at 22:45 +0300, Alexander Menk wrote:
> > Hi!
> >
> > how can I translate the coordinate from the database to "normal" GPS
> > coordinates as they are used by OpenLayers etc.
> >
> >
> > SELECT ST_Transform(lat,4326) FRO
Alexander Menk
mestrona.net> writes:
>
> Hi!
>
> how can I translate the coordinate from the database to "normal" GPS
> coordinates as they are used by OpenLayers etc.
>
> SELECT ST_Transform(lat,4326) FROM planet_osm_nodes
Try:
select transform(way,4326) from osm_line limit 1;
If you mostl
On Wed, 2010-01-13 at 22:45 +0300, Alexander Menk wrote:
> Hi!
>
> how can I translate the coordinate from the database to "normal" GPS
> coordinates as they are used by OpenLayers etc.
>
>
> SELECT ST_Transform(lat,4326) FROM planet_osm_nodes
>
> ERROR: function st_transform(double precision
Hi!
how can I translate the coordinate from the database to "normal" GPS
coordinates as they are used by OpenLayers etc.
SELECT ST_Transform(lat,4326) FROM planet_osm_nodes
ERROR: function st_transform(double precision, integer) does not exist
Alex
_
11 matches
Mail list logo