topic Copy only id of points which has minimum value within group in ArcGIS in ArcGIS Pro Questions

Copy only id of points which has minimum value within group in ArcGIS

Kapil_DevAdhikari — Sun, 29 Dec 2019 09:17:39 GMT

I have points shape file with multiple attribute fields, as below:

In above attribute:
'FID_Net' is 'unique value/subset' and 'class' is the 'value'. And in my new data sheet, the values of column 'class' is not repeating. I have to copy that unique value 'FID_Net' to new field 'New_FID' of only one row which value 'class' is minimum within group 'FID_Net' and rest of others row should be 0 or NULL as in my paper's table (Expected).

Re: Copy only id of points which has minimum value within group in ArcGIS

JimCousins — Mon, 30 Dec 2019 22:10:49 GMT

A few comments:

You need to use a variable to return the value, not the column name itself

You need and End If at the end of your code

After the Else statement, you need to also use the same variable to return the 0 value

I am assuming that you are using the code block for the field calculation.

set the Expression = result

in the code block (I created fields from your table snapshot)

If [species] = "Pinus" and [class1] = 1 and [condition] ="G" then
result = [ITID]
elseif [species] = "Pinus" and [class1] = 1 and [condition] ="M" then
result = [ITID]
elseif [species] = "Pinus" and [class1] = 2 and [condition] ="G" then
result = [ITID]
elseif [species] = "Pinus" and [class1] = 2 and [condition] ="M" then
result = [ITID]
Else
result = 0
End if

Re: Copy only id of points which has minimum value within group in ArcGIS

Kapil_DevAdhikari — Tue, 31 Dec 2019 08:25:25 GMT

Thank you.

It does not account for only populating one row from each category

Re: Copy only id of points which has minimum value within group in ArcGIS

JimCousins — Tue, 31 Dec 2019 12:59:13 GMT

There was not a mention of anything like this in your post, and this is a bit vague. Could you be more specific about your comment and just what it is you wish to do?

Jim

Re: Copy only id of points which has minimum value within group in ArcGIS

Kapil_DevAdhikari — Fri, 03 Jan 2020 15:22:18 GMT

@Jim Cousins, I have updated my question and simplified some conditions.

Re: Copy only id of points which has minimum value within group in ArcGIS

JoshuaBixby — Fri, 03 Jan 2020 15:55:56 GMT

Since you posted this in ArcGIS for Desktop Training , a training space, is this an exercise you are trying to solve? If so, do you have to use a specific set of tools or is everything on the table for use? Are you comfortable with writing or using any Python code?