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

[Hugues François]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130416/c5e3330f/attachment.html>