Perfect! Thank you guys. Carsten
2013/4/16 Hugues François <[email protected]> > ** > And what about round(st_y(geom)::numeric, 6) ? > > Hug > > > ------------------------------ > *From:* [email protected] [mailto: > [email protected]] *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 <[email protected]> > >> ** >> Hello, >> >> Did you simply try >> >> round(ST_Y(geom), 6) as lat >> round(ST_X(geom), 6) as lon >> >> Hugues. >> >> ------------------------------ >> *From:* [email protected] [mailto: >> [email protected]] *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 >> [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 > >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
