ModelBuilder - automatic rename attributes in table based on shape area

StanislavaV — Sun, 05 Dec 2021 21:13:55 GMT

Hi guys,

I was wondering if it is possible to rename my polygons based on shape area.

I am using this exact advice from mr. Pike https://community.esri.com/t5/arcmap-questions/modelbuilder-automatic-rename-attributes-in-table/m-p/1038995#M2157

but I am thinking if we can rename them like this - when I have polygons with CODE 2000, then CODE 2 would be calculated based on shape area - the biggest would be for CODE2 the same as it was original - in this case 1, smaller would be CODE2 2, the smallest would be CODE3 ... and so on...

From this

FID CODE CODE2 AREA

1 1001 2 0,5

2 1001 2 1

3 2000 1 0,25

4 2000 1 1,5

5 2000 1 0,75

To this

FID CODE CODE2 AREA

1 1001 3 0,5

2 1001 2 1

3 2000 3 0,25

4 2000 1 1,5

5 2000 2 0,75

Re: ModelBuilder - automatic rename attributes in table based on shape area

curtvprice — Mon, 06 Dec 2021 05:37:34 GMT

The easiest way to do this in ModelBuilder is to use the Sort tool to sort by CODE and Shape_Area and then write a python function in Calculate Field tool with a code block with a function that assigns values according to your rules as you navigate through the sorted table.

Or, take what I bet is @DanPatterson's advice and do this in Python/numpy in a Calculate Value function that reads the table, sorts it and does your logic.

I do not follow your logic here.

topic Re: ModelBuilder - automatic rename attributes in table based on shape area in ArcMap Questions

ModelBuilder - automatic rename attributes in table based on shape area

Re: ModelBuilder - automatic rename attributes in table based on shape area