topic Re: How to edit precision and scale attribute table in Data Management Questions

How to edit precision and scale attribute table

YuniantoTri_Wijayanto — Fri, 23 May 2014 02:26:53 GMT

Hi,

Excuse me Master GIS in this forum. Need ur help, please? I have problem in editing precision and scale attribute table. I build feature class with name ID_PILE_P. Furthermore, my build geodatabase has been reviewed by client. The result had different in precision and scale table. How to edit precision and scale table in feature class in this geodatabase. Review result and geodatabase attached this question. Please help me..thank you for ur help before.

Best Regards,

Yunianto
from Indonesia

Re: How to edit precision and scale attribute table

VinceAngelo — Fri, 23 May 2014 12:54:18 GMT

Generally speaking, you should set the desired floating-point precision parameters (width and digits)
at table creation. Oracle sometimes won't let you change values after the fact (if the table has data
and it thinks you are trying to increase precision retroactively).

- V

Re: How to edit precision and scale attribute table

Anonymous User — Fri, 23 May 2014 13:43:42 GMT

Original User: Yunianto1989

I have set precision and scale appropriate request from my client. I created a table column with type "double" with precision 38 and scale 8 but the precision be 18 and scale 8. And then, I input the shapefile into a personal geodatabase, the precision and scale be zero value (0). How is maximum value precision and scale in column attribute table? Is it the default value in the geodatabase? Is it a case that affect this change? Please explanation or way to the precision and scale not change zero value into geodatabase.

Re: How to edit precision and scale attribute table

VinceAngelo — Fri, 23 May 2014 15:53:33 GMT

You're not going to get 38 digits of precision out of a IEEE 64-bit floating point value, period.
Shapefiles, due to a dBase limitation, aren't even going to get 18 digits. Personal geodatabase
is a form of Access; I don't ever use that.

It's time for a more complete description of your ArcGIS software and input and output data
formats, so you can find someone familiar with your goal.

- V