[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