<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Yes it is! <br>
I Hadn't thought of that!<br>
thank you!<br>
<br>
<div class="moz-cite-prefix">On 26/11/2014 11:29, Nicklas Avén
wrote:<br>
</div>
<blockquote
cite="mid:vgku0cyqurneruq2ea8pum80.1416997765411@email.android.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<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> </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>
</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>
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<br>
</body>
</html>