[postgis-users] rounding off geometry coordinates

toni hernández toni at sigte.udg.edu
Wed Nov 26 02:17:52 PST 2014


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?.

More information about the postgis-users mailing list