ArcGIS does not use floating point numbers. The conversation from intern ArcGIS number representation to Shapefile, Gml, Geodatabase, ... is the problem.
Gr Ralf -----Ursprüngliche Nachricht----- Von: [email protected] [mailto:[email protected]] Im Auftrag von Ben Madin Gesendet: Donnerstag, 4. Februar 2010 09:19 An: PostGIS Users Discussion Betreff: Re: [postgis-users] digit problem about sql file. 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 > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
