[postgis-users] digit problem about sql file.

[David Fawcett]

As an aside, it is likely that the numbers are being stored in the
shapefile to a higher precision (more decimal places) than you think.

When viewing the attribute table in an Arc product, there is commonly
a default format set so it appears as though there are only a limited
number of decimal places.  If you change the format to display more
decimal places, you will see that the data has not been rounded.

David.

On Thu, Feb 4, 2010 at 3:25 AM, Suhr, Ralf <Ralf.Suhr at itc-halle.de> wrote:
> 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: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] 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
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>