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 <[email protected]>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 > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
