[postgis-users] Cut lat/lon to six decimal digits

[Carsten Hogertz]

Thanks.
Indead I did. I also tried

trunc(ST_Y(geom), 6)

But it gives back:

Function round(double precision, integer) does not exist



2013/4/16 Hugues François <hugues.francois at irstea.fr>

> **
> Hello,
>
> Did you simply try
>
> round(ST_Y(geom), 6) as lat
> round(ST_X(geom), 6) as lon
>
> Hugues.
>
>  ------------------------------
> *From:* postgis-users-bounces at lists.osgeo.org [mailto:
> postgis-users-bounces at lists.osgeo.org] *On Behalf Of *Carsten Hogertz
> *Sent:* Tuesday, April 16, 2013 3:51 PM
> *To:* PostGIS Users Discussion
> *Subject:* [postgis-users] Cut lat/lon to six decimal digits
>
>  Hi everyone,
> I've got the following SQL to extract the lat/lon of a polygone:
>
> SELECT
> ROW_NUMBER () over () as id,
> name,
> geom,
> ST_Y(geom) as lat,
> ST_X(geom) as lon
> FROM (SELECT name, (ST_DumpPoints(geom)).* FROM timezones20032013) as foo
>
> It gives me back the lat and lon as a number with a lot of digits, e.g.:
> 42.4734992980957
> 1.71096694469452
>
> Instead what I need is:
> 42.473499
> 1.710967
>
> How could I change my SQL to get the result cut/rounded?
>
> Any help would be appreciated.
>
> Thanks in advance
> Carsten
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130416/b83a42df/attachment.html>