topic Re: Create New Field Issues -- Specify LONG creates DOUBLE in Python Questions

Create New Field Issues -- Specify LONG creates DOUBLE

kapalczynski — Thu, 09 Jan 2025 18:50:40 GMT

I am trying to create a new field in an Enterprise GDB ...

I use the below and for some reason it creates the field with DOUBLE, 38, 8

arcpy.management.AddField(toFeatureClass, "LOCALITY", "LONG", 20, "", "", "Locality", "NULLABLE", "NON_REQUIRED")

Re: Create New Field Issues -- Specify LONG creates DOUBLE

DavidSolari — Thu, 09 Jan 2025 19:09:42 GMT

I have a feeling specifying a field length is tripping it up. This is what Pro spits out as a default Python command for adding a "Long" field, you should be able to tweak this:

arcpy.management.AddField( in_table=toFeatureClass, field_name="LOCALITY", field_type="LONG", field_precision=None, field_scale=None, field_length=None, field_alias="Locality", field_is_nullable="NULLABLE", field_is_required="NON_REQUIRED", field_domain="" )

Re: Create New Field Issues -- Specify LONG creates DOUBLE

Laura — Thu, 09 Jan 2025 19:22:03 GMT

Long field type I believe doesn't have precision or scale like (double or float) so the 20 would be ignored. Can you try without that?

arcpy.management.AddField(toFeatureClass, "LOCALITY", "LONG", "", "", "", "Locality", "NULLABLE", "NON_REQUIRED")

Re: Create New Field Issues -- Specify LONG creates DOUBLE

CodyPatterson — Thu, 09 Jan 2025 19:35:14 GMT

Hey @kapalczynski

It appears that the long will be created as a double if the precision is 11 or more from this documentation here:

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/add-field.htm

For a field with a scale of 0, use a long or short integer field type. When creating a long integer field, specify a precision of 10 or less, or the field may be created as a double.

Cody

Re: Create New Field Issues -- Specify LONG creates DOUBLE

kapalczynski — Thu, 09 Jan 2025 19:50:01 GMT

Thank you all for your comments...

So if I need the field to carry 15 digits I have to make it a DOUBLE with PRECISION of 15 and no DECIMALS?

Re: Create New Field Issues -- Specify LONG creates DOUBLE

TonyAlmeida — Thu, 09 Jan 2025 20:13:04 GMT

You must use Double.

arcpy.management.AddField( in_table=toFeatureClass, field_name="LOCALITY", field_type="DOUBLE", # Use DOUBLE for high-precision numbers field_precision=15, # Total number of digits field_scale=0, # No decimal places field_alias="Locality", field_is_nullable="NULLABLE", field_is_required="NON_REQUIRED" )

Re: Create New Field Issues -- Specify LONG creates DOUBLE

kapalczynski — Thu, 09 Jan 2025 21:17:40 GMT

As I needed 15 digits I had to create a DOULBE with 15 digits and 0 decimal places as LONG only holds 10 digits.