[postgis-users] Cut lat/lon to six decimal digits
Hugues François
hugues.francois at irstea.fr
Tue Apr 16 07:06:58 PDT 2013
And what about round(st_y(geom)::numeric, 6) ?
Hug
________________________________
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 4:05 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Cut lat/lon to six decimal digits
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/b4f7273b/attachment.html>
More information about the postgis-users
mailing list