I'm not having any success sorting an arcpy.da.SearchCursor by the SHAPE Area values. No errors but it doesn't sort descending from my testing. Anyone able to confirm this or offer a suggestion? with arcpy . da . SearchCursor ( clip_fc , [ 'SHAPE@AREA' , 'POLYGON_NM' ] , sql_clause = ( None , 'ORDER BY SHAPE.STArea() DESC' ) ) as clipcur : for cliprow in clipcur : areaval = cliprow [ 0 ]

sorted is a Python built-in, and your code is following a standard Python pattern. If it works, great. A couple of things to think about. * Sorted returns "a new sorted list from the items in iterable." In this case, it means your entire cursor will have to be iterated and stored in a new list before sorted sorts it and gives you a list back. For very large data sets, it may not be desirable to copy the entire cursor into memory. * Since your cursor is returning more than one field, it would be best for you to specify a key to select the one and only column you are interested in sorting on. In your current example, you are actually comparing a combination of SHAPE@AREA and POLYGON_NM, whatever the latter is. For the key, you can either use operator.itemgetter() or define a lambda/anonymous function to select just the area field.

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; } } }

da.SearchCursor ORDER BY SHAPE@AREA

JamesCrandall

I'm not having any success sorting an arcpy.da.SearchCursor by the SHAPE Area values. No errors but it doesn't sort descending from my testing.

Anyone able to confirm this or offer a suggestion?

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>clip_fc<SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'SHAPE@AREA'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'POLYGON_NM'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>sql_clause<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'ORDER BY SHAPE.STArea() DESC'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> clipcur<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> cliprow <SPAN class="keyword token">in</SPAN> clipcur<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; areaval <SPAN class="operator token">=</SPAN> cliprow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Encontre mais publicações marcadas com

Accepted answers

bixb0012

sorted is a Python built-in, and your code is following a standard Python pattern. If it works, great. A couple of things to think about.

Sorted returns "a new sorted list from the items in iterable." In this case, it means your entire cursor will have to be iterated and stored in a new list before sorted sorts it and gives you a list back. For very large data sets, it may not be desirable to copy the entire cursor into memory.
Since your cursor is returning more than one field, it would be best for you to specify a key to select the one and only column you are interested in sorting on. In your current example, you are actually comparing a combination of SHAPE@AREA and POLYGON_NM, whatever the latter is. For the key, you can either use operator.itemgetter() or define a lambda/anonymous function to select just the area field.

All comments

JamesCrandall

itemgetter implemented.

Thanks for your input.

bixb0012

sorted is a Python built-in, and your code is following a standard Python pattern. If it works, great. A couple of things to think about.

Sorted returns "a new sorted list from the items in iterable." In this case, it means your entire cursor will have to be iterated and stored in a new list before sorted sorts it and gives you a list back. For very large data sets, it may not be desirable to copy the entire cursor into memory.
Since your cursor is returning more than one field, it would be best for you to specify a key to select the one and only column you are interested in sorting on. In your current example, you are actually comparing a combination of SHAPE@AREA and POLYGON_NM, whatever the latter is. For the key, you can either use operator.itemgetter() or define a lambda/anonymous function to select just the area field.

bixb0012

SQL Server doesn't support ST_Geometry. For SQL Server it will be GEOMETRY or GEOGRAPHY if using native types, or SDEBINARY if using an Esri type.

JamesCrandall

It looks like I implemented the same but the cursor was not sorted as expected!

Edit: I'm on ArcGIS 10.3

JamesCrandall

Do you have any comment on the solution I mentioned above? (It's linked to from the 10.1 documentation under example #5 "sorting Mini-HOW TO" -- which I thought was strange).

bixb0012

I just tested with ArcMap 10.5 connecting to a 10.4.x enterprise geodatabase in SQL Server, and using a SQL clause works:

<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">'Database Connections\Default@SGDB@localdb.sde\SGDB.DBO.Infra'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"SHAPE@AREA"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"OID@"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>sql_clause<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"ORDER BY SHAPE.STArea() DESC"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cur<SPAN class="punctuation token">:</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> area<SPAN class="punctuation token">,</SPAN>oid <SPAN class="keyword token">in</SPAN> cur<SPAN class="punctuation token">:</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"{} {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>area<SPAN class="punctuation token">,</SPAN>oid<SPAN class="punctuation token">)</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>
<SPAN class="number token">39593.1062297</SPAN> <SPAN class="number token">3</SPAN>
<SPAN class="number token">26339.7586344</SPAN> <SPAN class="number token">2</SPAN>
<SPAN class="number token">20269.7498507</SPAN> <SPAN class="number token">6</SPAN>
<SPAN class="number token">8894.95466122</SPAN> <SPAN class="number token">11</SPAN>
<SPAN class="number token">8412.44189983</SPAN> <SPAN class="number token">4</SPAN>
<SPAN class="number token">8049.8586996</SPAN> <SPAN class="number token">1</SPAN>
<SPAN class="number token">7620.10032388</SPAN> <SPAN class="number token">10</SPAN>
<SPAN class="number token">7431.46963174</SPAN> <SPAN class="number token">5</SPAN>
<SPAN class="number token">6953.70626041</SPAN> <SPAN class="number token">8</SPAN>
<SPAN class="number token">6316.28689426</SPAN> <SPAN class="number token">9</SPAN>
<SPAN class="number token">6142.45012789</SPAN> <SPAN class="number token">7</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JamesCrandall

1, SQL Server

2. I'm guessing ST_geometry since Shape.STArea() is the name of the area column on polygon FC's.

bixb0012

What is your backend database and what geometry storage type is being used?

JamesCrandall

This appears to be one solution:

<SPAN class="keyword token">for</SPAN> cliprow <SPAN class="keyword token">in</SPAN> sorted<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>clip_fc<SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'SHAPE@AREA'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'POLYGON_NM'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>reverse<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>

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

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

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