topic Re: Deleting a field where subtype was removed in Data Management Questions

Deleting a field where subtype was removed

ScottFortman1 — Thu, 07 Mar 2024 22:02:03 GMT

Hi there,

so we want to remove a subtype from a field and create a new field with a domain that has the same values we use in the subtyped field. I used the remove subtype geoprocessing tool,it seemed to worked fine. I create a new field and calculated the values from the old subtyped field over, all is well. I am trying to delete the old field now and am unable to do it. Does anybody know how to do it, if even possible? Thanks for any advice!

Re: Deleting a field where subtype was removed

MarceloMarques — Thu, 07 Mar 2024 22:25:03 GMT

@ScottFortman1 - If you are using an ArcSDE Enterprise Geodatabase then you can be locking yourself, try to close ArcGIS Pro / ArcCatalog, then connect again with the data owner user, do not click any other geodatabase connection file, and try again to make the schema change, you also need to ask all other users to disconnect and stop all ArcGIS Server Services that use the ArcSDE Enterprise Geodatabase that you are trying to make schema changes.

Re: Deleting a field where subtype was removed

ScottFortman1 — Thu, 07 Mar 2024 23:06:41 GMT

Thanks for replying Marcelo. Yes I did try that. Whenever I make schema change on our SDE Enterprise databases, we shut down all services, connect as database owner, check connections and locks, then make our changes. After I removed the subtype from the field, I did this again. I also tried running our nightly jobs, which compresses our databases.

Re: Deleting a field where subtype was removed

MarceloMarques — Thu, 07 Mar 2024 23:08:13 GMT

@ScottFortman1 - ArcGIS Pro will not let you delete the *Subtype field, that is expected behavior.

You will need to create a new empty Featureclass with the new fields and domains that you want then you will reload the data using the old Featureclass.

Re: Deleting a field where subtype was removed

ScottFortman1 — Thu, 07 Mar 2024 23:10:17 GMT

Ok thanks, so to be clear, this is true even after you remove the subtype?

Re: Deleting a field where subtype was removed

MarceloMarques — Thu, 07 Mar 2024 23:33:58 GMT

yes, you cannot delete the *Subtype field if the Featureclass was created with one from the beginning, this because the *Subtype field is how the data gets organized, hence the only way around this is to create a new Featureclass without the *Subtype field and reload the data.

Re: Deleting a field where subtype was removed

ScottFortman1 — Fri, 08 Mar 2024 00:14:09 GMT

Ok thanks. Just to try it, I did try this in ArcCatalog (10.8.1) and was able to delete the field there.

Re: Deleting a field where subtype was removed

MarceloMarques — Fri, 08 Mar 2024 19:15:37 GMT

@ScottFortman1 - I am adding this comment so others can understand.

ArcCatalog 10.8.2 cannot delete the *Subtype field. But if we go to the "Subtypes" tab and set to <None> then under the "Fields" tab will be able to delete the Subtype field.

Workaround

Re: Deleting a field where subtype was removed

RhettZufelt — Fri, 08 Mar 2024 19:05:09 GMT

Will be a sad day when good old ArcCatalog goes away.....

Re: Deleting a field where subtype was removed

ScottFortman1 — Fri, 08 Mar 2024 19:07:53 GMT

Yes, that is exactly what I did. It would be great if there was a way do that in Pro. Thanks for clarifying the solution for others who view this.

Re: Deleting a field where subtype was removed

MarceloMarques — Fri, 08 Mar 2024 19:16:39 GMT

@ScottFortman1 - here is how to delete the Subtype field in ArcGIS Pro.
These steps should have worked for you in Pro as well.

ArcGIS Pro 3.2.2 > Data Design > Fields

"Delete" is disabled for the *Subtype field.

Workaround

ArcGIS Pro 3.2.2 > Data Design > Subtypes

Subtypes > Create/Manage

Subtype Field: <Clear all subtypes...>

Click OK

Click Save

Close the Subtypes tab

Open the Fields tab

select the Subtype field > right click > choose delete

Click Save

The Subtype field was removed.

Re: Deleting a field where subtype was removed

LaurensKusse_hhdelfland — Thu, 16 May 2024 15:03:04 GMT

Is there also a way to do the "Clear all subtypes" action with arcpy?

I used arcpy.management.RemoveSubtype to remove all subtypes, but then the field is still showing with an asterix and bold. Only when I go to Subtypes > Create/Manage > "select Clear all subtype...", the subtypes are really gone and the field is showing as other fields.

It seems strange that this can't be achieved by removing all subtypes using arcpy.management.RemoveSubtype.

Re: Deleting a field where subtype was removed

PierreloupDucroix — Thu, 07 Nov 2024 03:21:32 GMT

Hi @LaurensKusse_hhdelfland

did you find a solution ?

I am also trying to remove a field with arcpy after removing all the subtypes but still get this error :

ERROR 002557: Cannot delete field assetgroup

[EDIT] I found the solution :

arcpy.management.SetSubtypeField(
in_table=my_table,
field=None,
clear_value="CLEAR_SUBTYPE_FIELD"
)

Re: Deleting a field where subtype was removed

LaurensKusse_hhdelfland — Thu, 07 Nov 2024 07:38:36 GMT

Yes, that was the solution! I found this in my Git-repository:

subtype_code = "'1: Dijk';'2: Dam';'3: Duin';'4: Kunstwerk';'5: Bijzondere waterkerende constructie';'6: Hoge grond'" arcpy.management.RemoveSubtype(in_table, subtype_code) print('RemoveSubtype:', arcpy.GetMessages()) arcpy.management.SetSubtypeField(in_table,'','CLEAR_SUBTYPE_FIELD') print('SetSubtypeField:', arcpy.GetMessages())