[postgis-users] Geometry precision setting

[Mark Leslie]

Ramachandran wrote:
> Hi,
> 
> I would like to change Geometry precision setup,  is it possible to
> change in postGIS?
> Actually, i need have precision of 5 digits after the dot placement in
> lat/lat with srid 4326
> for example...
>     42.65832, 12.58464
> 
> Can anyone advise me,  how to get this level of precision in postgis?
> 
> Thanks in advance,
> 

UPDATE table_name SET the_geom = ST_SnapToGrid(the_geom, 0.00001, 0.00001);

See http://postgis.refractions.net/docs/ch06.html#id2681426 under
ST_SnapToGrid for details.
If you need to maintain this precisions through updates and insertions,
you'll need to attach a trigger to the table.

-- 
Mark Leslie
Software Architect
LISAsoft Pty Ltd
www.lisasoft.com