nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

arcpy: maximum of a field of a feature class

RamB

I would like to get the maximum of a field in a feature class. If no features are selected, I get the right value. But if some features are selected, I am getting the maximum of a field from within these selected features. However, I would like to get maximum of a field from the whole table i.e., from both selected and un-selected features.

how may I do it?

Thank you

Najděte více příspěvků označených jako

Accepted answers

All comments

DanPatterson_Retired

in_fc <SPAN class="operator token">=</SPAN> <SPAN class="string token">'C:/Your_spaceless_path/CoordGeom.gdb/Polygons'</SPAN>

arr <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>TableToNumPyArray<SPAN class="punctuation token">(</SPAN>in_fc<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Shape_Area'</SPAN><SPAN class="punctuation token">)</SPAN>  <SPAN class="comment token"># pick a field</SPAN>

<SPAN class="comment token"># nan functions account for nulls, cast to the dtype of the field using astype </SPAN>
np<SPAN class="punctuation token">.</SPAN>nanmax<SPAN class="punctuation token">(</SPAN>arr<SPAN class="punctuation token">.</SPAN>astype<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'float'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>  

<SPAN class="number token">155.0</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

RamB

Thank you, may be I was not clear. Your code gives same answer as mine. Let me try again.

Imagine you have 3 features [0,1,2] in a fc. They have a income field which is an integer [10,12,14] respectively .

case1: I have selected no feature selected, I ask for max of fc , I get 14 >> correct

case2: I have selected features [0,1], i ask for max of fc , I get 12 >> incorrect, I still want 14, because I am asking max of fc, not max of selection of fc.

case3: I have selected features [1,2], i ask for max of fc, I get 14, >> correct

I hope it clarifies a bit?

RamB

I mean, I am asking max of income field in fc.

JoeBorgione

Just need to ask: have you actually looked at the values of your selected versus non-selected and done the summation manually? Sounds like one of your fields is 0 or None value. What is your objective of comparing your selected sum versus the non-selected? If you know the sum of the income field without any selections, why not write that value to a variable if you need to make comparisons to it?

DanPatterson_Retired

My answer gives you the maximum whether you have a selection or not.

If you need that maximum, that is the way to get it without worrying about selections or not.

If you need maximum-ish (ie there is a selection) then work with arcpy

If you want the best of both worlds, they you can work with both approaches

RamB

would your solution of accessing a disk file be affected by:

1. lock imposed by arcmap

2. hard-coded path on the file system?

DanPatterson_Retired

If you see the requirements for the function, it just requires the path to the featureclass's table. Locks aren't for reading, only modifying a featureclass.

You could try it and report back

LukeWebb

Dans Answer is correct.

in_fc <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">=</SPAN> <SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;">'C:/Your_spaceless_path/CoordGeom.gdb/Polygons'</SPAN>

arr <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">=</SPAN> arcpy<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>da<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>TableToNumPyArray<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN>in_fc<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">,</SPAN> <SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;">'Shape_Area'</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">)</SPAN>&nbsp; <SPAN class="" style="color: slategray; border: 0px; font-weight: inherit;"># pick a field</SPAN>

<SPAN class="" style="color: slategray; border: 0px; font-weight: inherit;"># nan functions account for nulls, cast to the dtype of the field using astype </SPAN>
np<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>nanmax<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN>arr<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>astype<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN><SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;">'float'</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">)</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">)</SPAN>&nbsp; 

<SPAN class="" style="color: #990000; border: 0px; font-weight: inherit;">155.0</SPAN>

If this is returning different numbers based on selection, then this is because you are not entering "in_fc" as shwon above.

E.g.

in_fc <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">=</SPAN> <SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;">'C:/Your_spaceless_path/CoordGeom.gdb/Polygons'</SPAN>

Is different than:

in_fc <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">=</SPAN> <SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;">'Polygons'</SPAN>

One points to a layer in a map, and will return results based on selections and things, the other points to data on a disk, and will return counts of whatever is inside that dataset.

The only possible thing that could go wrong using this, is if a user is inside an Edit session, then there features are not saved to the "dataset on disk" until they save Edits.

JoshuaBixby

Just use a Describe object to retrieve the underlying feature class of the feature layer.

featlyr_name <SPAN class="operator token">=</SPAN> <SPAN class="string token">"rangerdistrict"</SPAN> <SPAN class="comment token"># name of existing feature layer</SPAN>
fld_max <SPAN class="operator token">=</SPAN> <SPAN class="string token">"GIS_ACRES"</SPAN> <SPAN class="comment token"># field for determining maximum value</SPAN>

max<SPAN class="punctuation token">(</SPAN>fld <SPAN class="keyword token">for</SPAN> fld<SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>featlyr_name<SPAN class="punctuation token">,</SPAN>fld_max<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

fc <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>featlyr_name<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>featureclass<SPAN class="punctuation token">.</SPAN>catalogPath
max<SPAN class="punctuation token">(</SPAN>fld <SPAN class="keyword token">for</SPAN> fld<SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN>fld_max<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

RamB

Thank you Dan Patterson‌ Joshua Bixby‌ Luke Webb

I did two different approaches and both worked.

Approach 1. I first got a max for the selection, then switched the selection and got a second max, then took max of the both. I felt it was slow, but it works and this switching also updated my labels in display, which kind of confirmed the display of new max assigned to the features.

Approach 2. I did not follow the advice of giving a hard coded path, because user can have the file anywhere on the system. So instead, I used layer.dataSource to get the path. Then I used np.amax to get the max of the array (attribute table).

So broadly I followed the advice of path and the advice of np.array and also liked the list comprehension technique by Joshua. that also works.

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.