topic Re: Added Subtype field, need to populate data in Data Management Questions

Added Subtype field, need to populate data

DaveAugspurger — Fri, 20 Jan 2012 16:29:07 GMT

I have a feature with about 1200 entries. I have just added a subtype field with about 15 different subtype codes. The vast majority of the entries are of one particular subtype. Is there a way to automatically populate the subtype field with that more common subtype code? I don't want to have to click the dropdown box and select the correct subtype code from all 1200 entries. Hope that makes sense...just learning how to use the domains and subtypes and I'm not sure I'm using the correct jargon. Thanks.

Re: Added Subtype field, need to populate data

Robert_LeClair — Fri, 20 Jan 2012 18:02:27 GMT

Dave -

The fastest and easiest way to populate your subtype field is use "Select by Attributes" and select the records based on a particular attribute value. For example, Type = "Interstate". From there, use the Field Calculator and calculate the subtype field to the appropriate subtype code (i.e. Subtype_Field = 1) Do this workflow for the remaining 14 subtype codes. There are other ways to select features as well - manual approach and then use the Field Calculator.

Hope this helps!

Robert LeClair
Esri-Denver

Re: Added Subtype field, need to populate data

DaveAugspurger — Wed, 25 Jan 2012 12:28:29 GMT

[SUB][/SUB]

Dave -

The fastest and easiest way to populate your subtype field is use "Select by Attributes" and select the records based on a particular attribute value. For example, Type = "Interstate". From there, use the Field Calculator and calculate the subtype field to the appropriate subtype code (i.e. Subtype_Field = 1) Do this workflow for the remaining 14 subtype codes. There are other ways to select features as well - manual approach and then use the Field Calculator.

Hope this helps!

Robert LeClair
Esri-Denver

Thanks, that did the trick and it was easy 🙂

Re: Added Subtype field, need to populate data

KarlWilson — Tue, 15 May 2012 07:30:09 GMT

The fastest and easiest way to populate your subtype field is use "Select by Attributes" and select the records based on a particular attribute value. For example, Type = "Interstate". From there, use the Field Calculator and calculate the subtype field to the appropriate subtype code (i.e. Subtype_Field = 1) Do this workflow for the remaining 14 subtype codes. There are other ways to select features as well - manual approach and then use the Field Calculator.

I find that when I use Field Calculator to calculate the subtype field, it doesn't update the other fields with the associated default values for that subtype. Only when I manually select a subtype value (from the drop-down list) for a particular row, do the other fields update.

Is there a way to update the subtype of multiple features in one go, which also updates the other fields to their defaults for that subtype?

Thanks,
Karl

Re: Added Subtype field, need to populate data

NIYONSHUTIOlivier — Mon, 29 Aug 2022 06:47:50 GMT

Hi Karl,

Did you get help for this issue?

How did you select subtype field in field calculator anyway?

Thanks.

Re: Added Subtype field, need to populate data

Cyprus_Forest_Department — Mon, 29 Jul 2024 09:18:31 GMT

Any updates on this one? I stumbled upon it today...

Re: Added Subtype field, need to populate data

JoaquinQuintana — Mon, 09 Jun 2025 18:27:51 GMT

I am having this same issue... I would like to apply default values to a large set of records based on subtype but I cannot figure out how to do this other than manually calculating fields or selecting subtype from drop down on one record at a time.

Is there a way to update the subtype of multiple features in one go, which also updates the other fields to their defaults for that subtype?