topic Re: How to control numeric format using arcpy in ArcGIS Pro Questions

How to control numeric format using arcpy

AntoinePrince1805 — Wed, 02 Oct 2024 21:27:46 GMT

Does anyone knows of a way to control numeric format for DOUBLE or FLOAT values using only arcpy outside of ArcGIS Pro? I would like to find any ways to control the allowed number of decimals and also the thousand separator. As of now, I have explored two options :

1. Specifying the scale of the field when creating a new field using the "AddField" function, but I found out that the "scale" and "precision" parameters are ignored when using on a feature class inside a geodatabase.

2. Using the layer CIM to access the numberFormat properties with the following script, but the fieldDescriptions list always return empty. After reading a bit on the problem, this seems more like a feature than a bug (eventhough I don't get why we cannot acces the list in a python script, bu we can in the python command promt, inside ArcGIS Pro).

aprx_path = [PATH_TO_APRX] aprx = arcpy.mp.ArcGISProject(aprx_path) map = aprx.listMaps()[0] lyr = map.listLayers("MyLayer")[0] lyr_cim = lyr.getDefinition('V3') for fd in lyr_cim.featureTable.fieldDescriptions: fdNumFmt = fd.numberFormat fdNumFmt.useSeparator = True fdNumFmt.roundingValue = 2

So here I am, stuck...

Please help!

Thanks!

Re: How to control numeric format using arcpy

MariusBartašius1 — Thu, 03 Oct 2024 10:17:42 GMT

Solved: Programmatically format numeric fields with arcpy - Esri Community

Re: How to control numeric format using arcpy

AntoinePrince1805 — Thu, 03 Oct 2024 12:56:35 GMT

Thanks. That yet confirms that this does not seem possible unless I manually edit a layer file inside ArcGIS Pro, but I am looking for a python stand-alone solution.

Re: How to control numeric format using arcpy

JeffBarrette — Fri, 04 Oct 2024 15:35:44 GMT

@AntoinePrince1805

One of the efficiencies of the CIM is also one of its limitations. The CIM mostly persists non-default data to minimize its size and improve performance. So if no alterations are made to default field info, the field info does not appear in the CIM definition.

Try the code below. The trick is to use MakeFeatureLayer which does include the CIM definitions, make alterations and copy the updated CIM information to your target layer.

p = arcpy.mp.ArcGISProject('current') m = p.listMaps()[0] lyr = m.listLayers('Provinces')[0] lyr_cim = lyr.getDefinition('V3') fList = ["SQKM", "POP2001", "Shape_Length", "Shape_Area"] #IF NO CIM FIELD DESC INFO IS AVAILBLE if len(lyr_cim.featureTable.fieldDescriptions) == 0: print('No CIM Field Info') #Make temporary layer (which automatically gets CIM field info) mkLyr = arcpy.management.MakeFeatureLayer(lyr)[0] mkLyr_cim = mkLyr.getDefinition('V3') for fd in mkLyr_cim.featureTable.fieldDescriptions: if fd.fieldName in fList: fd.numberFormat.roundingOption = "esriRoundNumberOfDecimals" fd.numberFormat.roundingValue = 0 fd.numberFormat.zeroPad = True mkLyr.setDefinition(mkLyr_cim) #Copy CIM information and remove temporary layer lyr_cim.featureTable.fieldDescriptions = mkLyr_cim.featureTable.fieldDescriptions lyr.setDefinition(lyr_cim) m.removeLayer(mkLyr)

Jeff - arcpy.mp and Layout teams

Re: How to control numeric format using arcpy

AntoinePrince1805 — Fri, 04 Oct 2024 21:01:18 GMT

This answer has been deleted.

Re: How to control numeric format using arcpy

AntoinePrince1805 — Fri, 04 Oct 2024 21:01:33 GMT

This is it!!

Exactly what I was looking for. Although you made me work a bit late for a friday afternoon, I am still grateful.