[postgis-users] digit problem about sql file.

Hyung Joo Lee procarrie at imrc.kist.re.kr
Wed Feb 3 23:40:14 PST 2010


Hi all. 

I have a question about the decimal of shapefile that was created in Arcgis.

The file I have defined the coordinates of the coordinate system like (56.631 55.612)

That file was put in the DB using shp2pgsql( ---# shp2pgsql -a -w -S -I ###.shp table_name > ###.sql).

And then I checked the sql file. But the point coordinates that comes a lot more than 3-digit  like 56.6313000004739 55.6119999999646

I want to come out only 3-digit, so how can I do?

What option should I use?

I'll wait for the users a clear answer.



Best regards and thanks in advance.

Kevin.




More information about the postgis-users mailing list