<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"></head><body ><div>Hallo</div><div><br></div><div>ST_Snaptogrid should be what you are looking for.</div><div><br></div><div>HTH</div><div>Nicklas</div><div><br></div><div><br></div><div><div style="font-size:9px;color:#575757">Skickat från min Samsung Mobil.</div></div><br><br><div>-------- Originalmeddelande --------</div><div>Från: toni hernández <toni@sigte.udg.edu> </div><div>Datum:11-26-2014 11:17 (GMT+01:00) </div><div>Till: PostGIS Users Discussion <postgis-users@lists.osgeo.org> </div><div>Rubrik: [postgis-users] rounding off geometry coordinates </div><div><br></div>Hello,<br><br>I need to round off all the coordinates of some polygon geometries.<br>So far I am using the st_asgeojson function to use the precision I need, <br>and then I create a new geometry from the GeoJSon I have just created.<br><br>Something like this:<br>SELECT ST_ST_GeomFromGeoJSON(ST_AsGeoJSON(value_old,geom_precision))<br><br>Is there a more efficent way to do this?.<br><br>_______________________________________________<br>postgis-users mailing list<br>postgis-users@lists.osgeo.org<br>http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users<br><br></body>