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

[Carsten Hogertz]

Perfect! Thank you guys.
Carsten


2013/4/16 Hugues François <hugues.francois at irstea.fr>

> **
> 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
>>
>>
>
> _______________________________________________
> 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/9bd0e7fb/attachment.html>