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 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
