I am working on a script that is attempting to use ORDER BY. The results I'm seeing are unordered. I've dug quite a bit in GeoNet and elsewhere to no avail. My data is in a FGBD, my understanding is ORDER BY should work... I'm hoping that there is something wrong with the logic in my script, and someone might help me identify it. In a nutshell the script selects a group of features based on FEAT_SEQ, the selection is then sorted by a RANK field (NOT WORKING), the first row is then written to a new feature class. All of this is working except for the ordering. The output simply writes the first row, unsorted. * The TableSelect, selects features in a FC by the FEAT_SEQ field. The FEAT_SEQ is a result of the identify duplicate tool. * This selection is intended to be "sorted" by the ORDER BY using the SearchCursor * Finally the first row is written to a new FC Seq_Count = 0 #counter for FEAT_SEQ selection for i in range ( 5 ) : #loop - range 7631 (all)? for full run Seq_Count = Seq_Count + 1 # adds 1 to Seq_Count Where = "FEAT_SEQ =" + str ( Seq_Count ) #sets sql expreassion to Seq_Count # print ( "Looping Seq #" + str(Seq_Count)) # prints Seq_Count # for ref. arcpy . TableSelect_analysis ( DUPES , Out , Where ) # selects #print("Selection Complete - saved to cleanscript.gdb/SelSection") # loop done ### load selection from previous output, evalute winner, save winner to winnigselection with arcpy . da . SearchCursor ( Out , field_names = fieldnames , sql_clause = ( None , 'ORDER BY RANK' ) ) as searchCursor : #orders search by ranked with arcpy . da . InsertCursor ( winnerTable , fieldnames ) as iCur : row = next ( searchCursor ) #goes to first row (previouly ordered by rank) #print(row) iCur . insertRow ( row ) #print("insert complete") #del iCur #seems like you do this for housekeeping #del searchCursor #seems like you do this for housekeeping result = arcpy . GetCount_management ( winnerTable ) #counts output to winnerTable print ( '{} has {} records' . format ( winnerTable , result [ 0 ] ) ) #prints count The sql_clause is on line 9 (shown below) with arcpy . da . SearchCursor ( Out , field_names = fieldnames , sql_clause = ( None , 'ORDER BY RANK' ) ) as searchCursor : screenshot of same code (in case it is easier to read) Thanks in advance for any insights anyone has to offer!

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

sql_clause in arcpy.da.SearchCursor is NOT honoring "ORDER BY"

WesleyGarrett1

I am working on a script that is attempting to use ORDER BY. The results I'm seeing are unordered. I've dug quite a bit in GeoNet and elsewhere to no avail. My data is in a FGBD, my understanding is ORDER BY should work...

I'm hoping that there is something wrong with the logic in my script, and someone might help me identify it.

In a nutshell the script selects a group of features based on FEAT_SEQ, the selection is then sorted by a RANK field (NOT WORKING), the first row is then written to a new feature class. All of this is working except for the ordering. The output simply writes the first row, unsorted.

The TableSelect, selects features in a FC by the FEAT_SEQ field. The FEAT_SEQ is a result of the identify duplicate tool.

This selection is intended to be "sorted" by the ORDER BY using the SearchCursor
Finally the first row is written to a new FC

Seq_Count <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN> <SPAN class="comment token">#counter for FEAT_SEQ selection</SPAN>
<SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="comment token">#loop - range 7631 (all)? for full run</SPAN>
        Seq_Count <SPAN class="operator token">=</SPAN> Seq_Count <SPAN class="operator token">+</SPAN> <SPAN class="number token">1</SPAN> <SPAN class="comment token"># adds 1 to Seq_Count</SPAN>
        Where <SPAN class="operator token">=</SPAN> <SPAN class="string token">"FEAT_SEQ ="</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>Seq_Count<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token">#sets sql expreassion to Seq_Count #</SPAN>
        <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>"Looping Seq <SPAN class="comment token">#" + str(Seq_Count)) # prints Seq_Count # for ref. </SPAN>
        arcpy<SPAN class="punctuation token">.</SPAN>TableSelect_analysis<SPAN class="punctuation token">(</SPAN>DUPES<SPAN class="punctuation token">,</SPAN> Out<SPAN class="punctuation token">,</SPAN> Where<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># selects </SPAN>
        <SPAN class="comment token">#print("Selection Complete - saved to cleanscript.gdb/SelSection") # loop done</SPAN>
        <SPAN class="comment token">### load selection from previous output, evalute winner, save winner to winnigselection</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>Out<SPAN class="punctuation token">,</SPAN> field_names <SPAN class="operator token">=</SPAN> fieldnames<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 RANK'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> searchCursor<SPAN class="punctuation token">:</SPAN> <SPAN class="comment token">#orders search by ranked</SPAN>
                <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>winnerTable<SPAN class="punctuation token">,</SPAN> fieldnames<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> iCur<SPAN class="punctuation token">:</SPAN>
                                        row <SPAN class="operator token">=</SPAN> next<SPAN class="punctuation token">(</SPAN>searchCursor<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token">#goes to first row (previouly ordered by rank)</SPAN>
                                        <SPAN class="comment token">#print(row)</SPAN>
                                        iCur<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>
                                        <SPAN class="comment token">#print("insert complete")</SPAN>
                <SPAN class="comment token">#del iCur #seems like you do this for housekeeping </SPAN>
        <SPAN class="comment token">#del searchCursor #seems like you do this for housekeeping</SPAN>
result <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetCount_management<SPAN class="punctuation token">(</SPAN>winnerTable<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token">#counts output to winnerTable</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'{} has {} records'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>winnerTable<SPAN class="punctuation token">,</SPAN> result<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token">#prints count‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍</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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

The sql_clause is on line 9 (shown below)

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>Out<SPAN class="punctuation token">,</SPAN> field_names <SPAN class="operator token">=</SPAN> fieldnames<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 RANK'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> searchCursor<SPAN class="punctuation token">:</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

screenshot of same code (in case it is easier to read)

Same code from notepad++ if anyone prefers to view it tis way

Thanks in advance for any insights anyone has to offer!

Encontre mais publicações marcadas com

Accepted answers

JoshuaBixby

Your problem is this line:

Out <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"in_memory/Selection"</SPAN> ‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

In-memory workspaces, both the legacy in_memory and newer memory, are not full-fledged geodatabases. The newer memory workspace does support more geodatabase functionality than the older in_memory, but Esri doesn't clearly document all the improvements in the newer workspace.

I did some quick testing, and SQL ORDER BY is honored using the newer memory workspace. If you aren't using ArcGIS Pro already, I encourage you to switch and also switch to using the newer in-memory workspace.

See Write geoprocessing output to memory—ArcGIS Pro | Documentation :

Write geoprocessing output to memory
Writing geoprocessing outputs to memory is an alternative to writing output to a geodatabase or file-based format. It is often significantly faster than writing to on-disk formats. Data written into memory is temporary and is deleted when the application is closed, so it is an ideal location to write intermediate data created in a ModelBuilder model or Python script.
Memory-based workspaces
ArcGIS provides two memory-based workspaces where geoprocessing outputs can be written.
Caution:
Memory-based workspaces do not support geodatabase elements such as feature datasets, representations, topologies, geometric networks, or network datasets.
Folders cannot be created in memory-based workspaces.
Since memory-based workspaces are stored in your system's physical memory, or RAM, your system may run low on memory if you write large datasets into the workspace. This can negatively impact processing performance.
memory
memory is a new memory-based workspace developed for ArcGIS Pro that supports output feature classes, tables, and raster datasets.
To write to the memory workspace, specify an output dataset path beginning with memory\ and including no file extension—for example, memory\tempOutput.
You can add memory datasets to a map in ArcGIS Pro.
in_memory
Legacy:
in_memory is the legacy memory-based workspace built for ArcMap that supports output feature classes, tables, and raster datasets.
To write to the in_memory workspace, specify an output dataset path beginning with in_memory\ and including no file extension—for example, in_memory\tempOutput.

All comments

WesleyGarrett1

Thanks Josh! I'll give that a try.

JoshuaBixby

When I see a workflow using cursors in loops, more often than not there is a better/quicker workflow that leads to the same results. If I understand what you are trying to do, it is very similar to what someone asked in Rank features by Field A for each unique value in Field B . The code I provided in that thread was adapted from Deleting records from tabular intersect table based on 'PERCENTAGE' field .

I made a copy of the <SPAN class="">WRS_DUPE_JOINED2</SPAN> and ran the following code, which ran in a few seconds, and I think provides the results you are looking for here.

<SPAN class="keyword token">from</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da <SPAN class="keyword token">import</SPAN> UpdateCursor
<SPAN class="keyword token">from</SPAN> itertools <SPAN class="keyword token">import</SPAN> groupby
<SPAN class="keyword token">from</SPAN> operator <SPAN class="keyword token">import</SPAN> itemgetter

fc <SPAN class="operator token">=</SPAN> <SPAN class="comment token"># path to feature class</SPAN>
case_fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"FEAT_SEQ"</SPAN><SPAN class="punctuation token">]</SPAN>
sort_field<SPAN class="punctuation token">,</SPAN> sort_dir <SPAN class="operator token">=</SPAN> <SPAN class="string token">"RANK"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ASC"</SPAN>

sql_orderby <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ORDER BY {}, {} {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>
    <SPAN class="string token">", "</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>case_fields<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
    sort_field<SPAN class="punctuation token">,</SPAN>
    sort_dir
<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">with</SPAN> UpdateCursor<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> <SPAN class="string 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> sql_orderby<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cur<SPAN class="punctuation token">:</SPAN>
    case_func <SPAN class="operator token">=</SPAN> itemgetter<SPAN class="punctuation token">(</SPAN>
        <SPAN class="operator token">*</SPAN><SPAN class="punctuation token">(</SPAN>cur<SPAN class="punctuation token">.</SPAN>fields<SPAN class="punctuation token">.</SPAN>index<SPAN class="punctuation token">(</SPAN>fld<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> fld <SPAN class="keyword token">in</SPAN> case_fields<SPAN class="punctuation token">)</SPAN>
    <SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">for</SPAN> key<SPAN class="punctuation token">,</SPAN> group <SPAN class="keyword token">in</SPAN> groupby<SPAN class="punctuation token">(</SPAN>cur<SPAN class="punctuation token">,</SPAN> case_func<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        row <SPAN class="operator token">=</SPAN> next<SPAN class="punctuation token">(</SPAN>group<SPAN class="punctuation token">)</SPAN>
        <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> group<SPAN class="punctuation token">:</SPAN>
            cur<SPAN class="punctuation token">.</SPAN>deleteRow<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>‍</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>

WesleyGarrett1

Thanks so much! That was the problem. I switched to outputting to a GDB for the selection and everything worked as it should. Unfortunately I can't use Pro for this in the long run. We don't have the option at this time for enterprise applications.

Good new though, it is working, albeit a little slower than it's already snails pace.

Thanks again!

JoshuaBixby

Your problem is this line:

Out <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"in_memory/Selection"</SPAN> ‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

See Write geoprocessing output to memory—ArcGIS Pro | Documentation :

Write geoprocessing output to memory
Writing geoprocessing outputs to memory is an alternative to writing output to a geodatabase or file-based format. It is often significantly faster than writing to on-disk formats. Data written into memory is temporary and is deleted when the application is closed, so it is an ideal location to write intermediate data created in a ModelBuilder model or Python script.
Memory-based workspaces
ArcGIS provides two memory-based workspaces where geoprocessing outputs can be written.
Caution:
Memory-based workspaces do not support geodatabase elements such as feature datasets, representations, topologies, geometric networks, or network datasets.
Folders cannot be created in memory-based workspaces.
Since memory-based workspaces are stored in your system's physical memory, or RAM, your system may run low on memory if you write large datasets into the workspace. This can negatively impact processing performance.
memory
memory is a new memory-based workspace developed for ArcGIS Pro that supports output feature classes, tables, and raster datasets.
To write to the memory workspace, specify an output dataset path beginning with memory\ and including no file extension—for example, memory\tempOutput.
You can add memory datasets to a map in ArcGIS Pro.
in_memory
Legacy:
in_memory is the legacy memory-based workspace built for ArcMap that supports output feature classes, tables, and raster datasets.
To write to the in_memory workspace, specify an output dataset path beginning with in_memory\ and including no file extension—for example, in_memory\tempOutput.

MarcoBoeringa

I am slightly at loss why you don't feed the SQL clause used in the "Table Select" tool directly into the arpy.da.SearchCursor. If I am right, this should just work and give the same results, and maybe then the ORDER BY will work as well, as there is an actual SQL clause to combine it with.

WesleyGarrett1

Good Idea Joshua Bixby‌. I've removed the loop and I'm seeing the same result. I'm attaching the GDB and the script. Lines 13, 18, and 20 will need to be re-pathed to your workspace to function. Out is defined in line 20.

As you can see above for FEAT_SEQ = 1, the row rank 5 (the first row) is being written. If it were ordered I'd expect the values of 1 to be written, or 100 if it were somehow reversed.

I'll put the code below as well for ref.

<SPAN class="comment token">#### Wesley Garrett - 20200715 </SPAN>
<SPAN class="comment token"># script selects items based on feat_seq, exports to a feature class, that feature class is sorted and the top rank is selected & written to the winner feature class</SPAN>
<SPAN class="comment token"># used in modernization / label table to eliminate duplicate instances of fcsubtypes, chooses higheest ranked</SPAN>
<SPAN class="comment token"># duplicates must be indentified prior (using find identical tool) uses FEAT_SEQ</SPAN>
<SPAN class="comment token"># rank and rank field must be calculated / created prior (Expression_rank_fcsubtype_alltypes.cal) uses RANK (use python parser)</SPAN>
<SPAN class="comment token">######################</SPAN>


<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Loading Arcpy..."</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Setting Environment..."</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env
env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"T:\FS\NFS\WOEngineering\GMO-GTAC\Project\DDC\Workspace\wdgarrett\roadsshield\cleanscript.gdb"</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN>

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"loading paths..."</SPAN><SPAN class="punctuation token">)</SPAN>
DUPES <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"T:\FS\NFS\WOEngineering\GMO-GTAC\Project\DDC\Workspace\wdgarrett\roadsshield\cleanscript.gdb\WRS_DUPE_JOINED2"</SPAN> <SPAN class="comment token"># table to be clenaed </SPAN>
Out <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"in_memory/Selection"</SPAN> <SPAN class="comment token">#to improve speed</SPAN>
winnerTable <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"T:\FS\NFS\WOEngineering\GMO-GTAC\Project\DDC\Workspace\wdgarrett\roadsshield\cleanscript.gdb\winnerTable"</SPAN> <SPAN class="comment token"># winner output (uses copy of Dupes to start) Schema of DUPES and winnerTable need to match</SPAN>

<SPAN class="comment token">#copies DUPES to winnerTable for output</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>Copy_management<SPAN class="punctuation token">(</SPAN>DUPES<SPAN class="punctuation token">,</SPAN> winnerTable<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Copy for winnerTable"</SPAN><SPAN class="punctuation token">)</SPAN>
      
<SPAN class="comment token">#clean winnerTable prior to run</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>TruncateTable_management<SPAN class="punctuation token">(</SPAN>winnerTable<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"winnerTable Cleared"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#get fields names and assign to fields</SPAN>
dsc <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>DUPES<SPAN class="punctuation token">)</SPAN>
fields <SPAN class="operator token">=</SPAN> dsc<SPAN class="punctuation token">.</SPAN>fields

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"DUPES Fields"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> field <SPAN class="keyword token">in</SPAN> dsc<SPAN class="punctuation token">.</SPAN>fields<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"%-22s %s %s"</SPAN> <SPAN class="operator token">%</SPAN> <SPAN class="punctuation token">(</SPAN>field<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">":"</SPAN><SPAN class="punctuation token">,</SPAN> field<SPAN class="punctuation token">.</SPAN>type<SPAN class="punctuation token">)</SPAN>
    <SPAN class="comment token">#print field.name + " = " + field.type</SPAN>

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"WinnerTable Fields"</SPAN><SPAN class="punctuation token">)</SPAN>
dscwinner <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>winnerTable<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> field <SPAN class="keyword token">in</SPAN> dscwinner<SPAN class="punctuation token">.</SPAN>fields<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"%-22s %s %s"</SPAN> <SPAN class="operator token">%</SPAN> <SPAN class="punctuation token">(</SPAN>field<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">":"</SPAN><SPAN class="punctuation token">,</SPAN> field<SPAN class="punctuation token">.</SPAN>type<SPAN class="punctuation token">)</SPAN>
    <SPAN class="comment token">#print field.name + " = " + field.type</SPAN>

out_fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>dsc<SPAN class="punctuation token">.</SPAN>OIDFieldName<SPAN class="punctuation token">,</SPAN> dsc<SPAN class="punctuation token">.</SPAN>shapeFieldName<SPAN class="punctuation token">]</SPAN> <SPAN class="comment token">#fields to not include this could include length etc. if not using tables </SPAN>

fieldnames <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>field<SPAN class="punctuation token">.</SPAN>name <SPAN class="keyword token">if</SPAN> field<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">!=</SPAN> <SPAN class="string token">'Shape'</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="string token">'SHAPE@'</SPAN> <SPAN class="keyword token">for</SPAN> field <SPAN class="keyword token">in</SPAN> fields <SPAN class="keyword token">if</SPAN> field<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">not</SPAN> <SPAN class="keyword token">in</SPAN> out_fields<SPAN class="punctuation token">]</SPAN> 

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Out Fields"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>out_fields<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Field Names"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>fieldnames<SPAN class="punctuation token">)</SPAN>

Seq_Count <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
Seq_Count <SPAN class="operator token">=</SPAN> Seq_Count <SPAN class="operator token">+</SPAN> <SPAN class="number token">1</SPAN> <SPAN class="comment token"># adds 1 to Seq_Count</SPAN>
Where <SPAN class="operator token">=</SPAN> <SPAN class="string token">"FEAT_SEQ ="</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>Seq_Count<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token">#sets sql expreassion to Seq_Count #</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>TableSelect_analysis<SPAN class="punctuation token">(</SPAN>DUPES<SPAN class="punctuation token">,</SPAN> Out<SPAN class="punctuation token">,</SPAN> Where<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># selects </SPAN>
<SPAN class="comment token">### load selection from previous output, evalute winner, save winner to winnertable</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>Out<SPAN class="punctuation token">,</SPAN> field_names <SPAN class="operator token">=</SPAN> fieldnames<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 RANK'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> searchCursor<SPAN class="punctuation token">:</SPAN> <SPAN class="comment token">#orders search by ranked</SPAN>
    <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>winnerTable<SPAN class="punctuation token">,</SPAN> fieldnames<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> iCur<SPAN class="punctuation token">:</SPAN>
        row <SPAN class="operator token">=</SPAN> next<SPAN class="punctuation token">(</SPAN>searchCursor<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token">#goes to first row (previouly ordered by rank)</SPAN>
        <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>
        iCur<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>
                                             
result <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetCount_management<SPAN class="punctuation token">(</SPAN>winnerTable<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token">#counts output to winnerTable</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'{} has {} records'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>winnerTable<SPAN class="punctuation token">,</SPAN> result<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token">#prints count</SPAN>

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"End / Done"</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>‍</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><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>‍</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><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>

Thanks!

GEONETTEST.zip

JoshuaBixby

If you can share a subset of data, that is most helpful. If not, can you create an example data set that generates the same behavior?

Looking at the code, where is "Out" being defined? And, for troubleshooting, take the loop out of it. Get the code working with a single FEAT_SEQ and then introduce the loop.

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.