'Re: [postgis-users] rounding off geometry coordinates'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] rounding off geometry coordinates
From:       <toni () sigte ! udg ! edu>
Date:       2014-11-26 11:22:32
Message-ID: 5475B7F8.8080600 () sigte ! udg ! edu
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]

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@lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

[Attachment #5 (text/html)]

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

_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread] 