Truncated decimal when creating shapefile

karinecliche — Sat, 25 Feb 2012 18:03:06 GMT

Hello

The data
An access table with xyz data along with other attributes with decimal numbers (ex: 0.0186) saved as numeric, double, 10 decimal. This table contains 500 000 records.

What I�??m trying to do:
Import this table into ArcGIS to query, select etc, according to 3D location

The problem:
Once I import my data into ArcGis and created a shapefile, the numbers of my attribute are truncated/rounded to 0.

So far what I have tried:
I establish an OLE DB Connection with the Access database (mdb) that work fine. I can preview my data and all the number appears correctly i.e. with decimal places. If I directly add this table to ArcMap and display the xy data, again my data appears correctly with all the decimal place.

Now, I select �??create feature class from xy table�?� to create a shapeline. I add this shapefile to a blank arcmap and when I open the attribute table all numbers are now rounded to no decimal place. I checked the field properties of the attributes table and change the decimal places to 10 but it doesn�??t change anything

I have tried to change my data type in access but due to the table size I cannot.

I�??m far from being an expert but I know this have to do with the nature of the data; being store in a �??double�?� format. I have read a few post in this forum about this issue but I didn't found a way to work around this or solve this.

Please help I have been a this for days now

Re: Truncated decimal when creating shapefile

karinecliche — Sat, 25 Feb 2012 20:03:47 GMT

So it's when you ask for help that you find the solution

I opened the desired access table in arcmap, exported that table as a text file, open the text file in arcmap then created a shapefile from that text file. And it works all my data, decimal places included were displayed without truncation or rounding.

thanks anyway

topic Truncated decimal when creating shapefile in Data Management Questions

Truncated decimal when creating shapefile

Re: Truncated decimal when creating shapefile