[postgis-users] rounding off geometry coordinates

toni hernández toni at sigte.udg.edu
Wed Nov 26 03:22:32 PST 2014


Yes it is!
I Hadn't thought of that!
thank you!

On 26/11/2014 11:29, Nicklas Avén wrote:
> Hallo
>
> ST_Snaptogrid should be what you are looking for.
>
> HTH
> Nicklas
>
>
> Skickat från min Samsung Mobil.
>
>
> -------- Originalmeddelande --------
> Från: toni hernández
> Datum:11-26-2014 11:17 (GMT+01:00)
> Till: PostGIS Users Discussion
> Rubrik: [postgis-users] rounding off geometry coordinates
>
> 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
>
>
>
> _______________________________________________
> 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/ef849ba4/attachment.html>


More information about the postgis-users mailing list