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

List:       postgis-users
Subject:    Re: [postgis-users] how to set precision
From:       Kevin Neufeld <kneufeld () refractions ! net>
Date:       2010-02-10 16:58:28
Message-ID: 4B72E5B4.6080307 () refractions ! net
[Download RAW message or body]

On 2/10/2010 12:36 AM, Marko Čubranić wrote:
> hi
> 
> i want to set geometry precision in postgis database, can i do that?


Yes, use ST_SnapToGrid[1].  Wrap it with a ON INSERT/UPDATE rule or trigger on every \
spatial table in your database and  you'll in effect ensure your entire database is \
set to some grid.  Although it's not the same as geometry precision,  it's the \
closest proxy we have to it at the moment.


[1] http://postgis.refractions.net/docs/ST_SnapToGrid.html

-- Kevin
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


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