[postgis-users] Rounding off coordinates

Gino Lucrezi gino-postgis at lucrezi.net
Mon Jun 28 06:33:09 PDT 2004

> new.lon := round(X(new.the_geom)::numeric,2);
> new.lat := round(Y(new.the_geom)::numeric,2);

This is simple if you're working with point data; but what if you're using any more complex data type, e.g. a line or a polygon? 

Gino Lucrezi
Penta Consulting Services Srl

More information about the postgis-users mailing list