topic Re: Exporting data from File GeoDB to SHP �?? attribute data tampering? in Data Management Questions

Exporting data from File GeoDB to SHP ??? attribute data tampering?

PieterCoetzer — Sat, 21 Jan 2012 19:06:34 GMT

Hi guys,

I have now come across this problem a couple of times. I have data in a File GeoDB that I export to SHP file format using ArcCatalogue. The spatial data and almost all the attributes exports correctly except for an ID filed (Type Double).

In the GeoDB the ID field is 17100027000010 but when exported to the SHP format it is changed to 17100027000000. This happens with all the values in the same range, leading to all of the records in the range ending with a value of 17100027000000.

Has anyone come across this and if so, id there a fix or workaround to export the data to the correct values?

Cheers,

Pieter

Re: Exporting data from File GeoDB to SHP �?? attribute data tampering?

VinceAngelo — Sun, 22 Jan 2012 01:06:56 GMT

If you look at the raw data stored in the .dbf file of the shpfile triplet, you'll probably
see that the value is represented in scientific notation with 18 characters:

+1.71000270000E+13

This is an intrinsic limitation to the dBase-III+ format. In the famous words of Chief
Engineer Scott -- "She cannae take any more, Captain!"

If you want to represent this value in dBase, you'll need to convert the value to string
(in Hexadecimal notation it would be 0F8D6908F4CA) or use some other method to
eliminate some zeros.

- V