[postgis-users] rounding off geometry coordinates

Rémi Cura remi.cura at gmail.com
Wed Nov 26 02:39:10 PST 2014

you may use ST_SNapToGrid

2014-11-26 11:17 GMT+01:00 toni hernández <toni at sigte.udg.edu>:

> Hello,
> I need to round off all the coordinates of some polygon geometries.
> So far I am using the st_asgeojson function to use the precision I need,
> and then I create a new geometry from the GeoJSon I have just created.
> Something like this:
> SELECT ST_ST_GeomFromGeoJSON(ST_AsGeoJSON(value_old,geom_precision))
> Is there a more efficent way to do this?.
> _______________________________________________
> 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/20141126/d32d2f31/attachment.html>

More information about the postgis-users mailing list