topic Re: Field scale (decimal places) issuse in Python Questions

Field scale (decimal places) issuse

TonyAlmeida — Tue, 31 Dec 2013 15:21:41 GMT

I noticed that when using arcpy.CalculateField_management in python on a feature class it's changes the field scale (decimal places).
I had a shapefile with an Acres filed of field scale of 3 but now it seems to have a field scale of 11. Why after running arcpy.CalculateField_management does it change the field scale? This is annoying after your export the table and open it.

Any explanation or help would be great.

Thanks.

Re: Field scale (decimal places) issuse

JakeSkinner — Tue, 31 Dec 2013 15:40:03 GMT

Hi Tony,

At first you state that you are using a feature class, then a shapefile, and then at some point you are performing an export. Can you explain your workflow a little more?

Also, what version of the software are you using, including service packs? i.e. 10.1 SP1

Thanks!

Re: Field scale (decimal places) issuse

TonyAlmeida — Sat, 11 Dec 2021 08:14:00 GMT

The current script is ran in a temp gdb, i decided to run the script on a shapefile for testing because of the decimal issues i was having. After the script is ran i export the table and use the table in excel.

the calculate field looks like this.

PT = "C:\GIS\PARCEL TOOL\ParcelTool.gdb\FINAL_SF"

arcpy.CalculateField_management(PT, "Acres", "!SHAPE.AREA@Acres!", "PYTHON" )

Before running the CalculateField_management my field scale is set to 3, example Acres = 1.236
But after running CalculateField_management my field scale is set to 6, example Acres = 1.236789

I am using ArgGIS 10.1 with SP1

Re: Field scale (decimal places) issuse

JakeSkinner — Tue, 31 Dec 2013 17:12:03 GMT

Hi Tony,

I could not reproduce this with a shapefile. However, for a File Geodatabase feature class, the Precision and Scale are ignored. See the following link.

When you create a float, double, or integer field and specify 0 for precision and scale, the tool will attempt to create a binary type field if the underlying database supports it. Personal and file geodatabases support only binary type fields, and precision and scale are ignored.

Re: Field scale (decimal places) issuse

TonyAlmeida — Tue, 31 Dec 2013 19:25:11 GMT

JSkinn3, oh i see. I did not catch that.

I guess i'll just have to formate cells to 3 decimal places in Excel.

Thanks.