[postgis-users] digit problem about sql file.

[Ben Madin]

Kevin,

I suspect this is mainly an artefact of floating-point numbers, and the conversion to and storage of these points in binary format.

As an aside I also notice that your shp2pgsql command didn't include a -s flag - so you haven't defined a spatial reference system for your data. This may be fine (if it is arbitrary cartesian coordinates), but it may (I'm not sure) have implications for the storage of these values.

I'm sure others will be able to help out more.

cheers

Ben


On 04/02/2010, at 15:40 , Hyung Joo Lee wrote:

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