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

[David Fawcett]

Take a look at the postgres round() function:
http://www.postgresql.org/docs/8.1/static/functions-math.html

round(ST_Y(geom),6)

David.



On Tue, Apr 16, 2013 at 8:50 AM, Carsten Hogertz
<carsten.hogertz at gmail.com>wrote:

> 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/6b3aa953/attachment.html>