Hello,
> I'm not sure why proj would require the NAD gridshift files for
> converting a google (900913) projection to WGS84 long/lat. Do you get
> any errors with this:
>
> select st_X(wayLL), st_Y(wayLL)
> from (
> select ST_Transform('SRID=900913;POINT(653103 6.63036e+06 0)'::geometry,
>
I'm not sure why proj would require the NAD gridshift files for
converting a google (900913) projection to WGS84 long/lat. Do you get
any errors with this:
select st_X(wayLL), st_Y(wayLL)
from (
select ST_Transform('SRID=900913;POINT(653103 6.63036e+06 0)'::geometry,
4326) as wayLL
) as foo;
Hello,
thanks for your help.
Regarding your questions:
No, i don't use www.pgrpms.org, my system is openSuse 11.2, i installed their
postgresql, which is version 8.4.4.
Yes, i installed Proj4 from source. I have to say i'm not sure any more if i
installed Proj-datumgrid in the /nad subdirecto
Am Dienstag, 2. November 2010 22:48:08 schrieb Mike Toews:
> select distinct st_srid(way) from planet_osm_point;
>
Hello,
i have to say i don't know exactly, but placing that query i got:
gis=> select distinct st_srid(way) from planet_osm_point;
st_srid
-
900913
(1 Zeile)
Best regard
Also, what is the source SRID of your geometry column(s)? If you're
not sure, check the geometry_columns table, the constraints used in
the DDL, or try:
select distinct st_srid(way) from planet_osm_point;
-Mike
On 2 November 2010 14:09, Torsten Mohr wrote:
> Hello,
>
> (i accidentially posted t
It appears the grid shift files are missing. These are not necessarily
installed by default.
Are you using http://www.pgrpms.org/ ? Is proj-nad installed? Did you
install proj.4 from source? If so, did you get the ZIP files and put
them in the right place before configuring?
-Mike
On 2 November
Hello,
(i accidentially posted this on the openstreetmap mailing list, but it
belongs here:)
I once got a hint on this mailing list to use a query like this to get the
lat/lon of the world capitals:
A)
select st_X(wayLL), st_Y(wayLL), name from (select
ST_AsText(ST_Transform(way,4326)) as way