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

How do I add a list to arcpy.da.SearchCursor?

JordanMiller4

How can I use systemList variable with several defined types with arcpy.da.SearchCursor? Currently, I have it looking at '009' but I would like it to find every system defined in systemList.

import arcpy

fc = 'Database Connections\SDE.sde\NEO_1.SDE.P_PipeSystem\NEO_1.SDE.P_Meters'
field = 'SYSTEMNUMBER'

systemList = ["009", "10", "12", "13", "21", "22", "27", "27A", "27B", "27C", "30", "31", "33", "34", "35", "36"]


cursor = arcpy.da.SearchCursor(fc, (field, "SYSTEMNUMBER"), """SYSTEMNUMBER = '009'""")
count = 0 

# For each row print the 
for row in cursor:
&nbsp;&nbsp;&nbsp; # Print the name of the gas systems
&nbsp;&nbsp;&nbsp; #
&nbsp;&nbsp;&nbsp; #print(row[1])
&nbsp;&nbsp;&nbsp; #result = arcpy.GetCount_management(fc)
&nbsp;&nbsp;&nbsp; #print('{} has {} records'.format(row[1], result[0]))
&nbsp;&nbsp;&nbsp; count += 1&nbsp; 

print('{} has {} records'.format(row[1],count))&nbsp; 

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

Find more posts tagged with

Accepted answers

SanghongYoo1

If I understand your problem, I think you just need unique field value counts on SYSTEMUNUMBERS. I got the code from here and modified a little.

<SPAN class="keyword token">import</SPAN> arcpy

table <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Database Connections\SDE.sde\NEO_1.SDE.P_PipeSystem\NEO_1.SDE.P_Meters'</SPAN>
field <SPAN class="operator token">=</SPAN> <SPAN class="string token">'SYSTEMNUMBER'</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>table<SPAN class="punctuation token">,</SPAN> field<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; occurances <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> sorted<SPAN class="punctuation token">(</SPAN>set<SPAN class="punctuation token">(</SPAN>occurances<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; icount <SPAN class="operator token">=</SPAN> occurances<SPAN class="punctuation token">.</SPAN>count<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <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>i<SPAN class="punctuation token">,</SPAN> icount<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>

All comments

JordanMiller4

Thanks, this was what I was trying to achieve!

SanghongYoo1

If I understand your problem, I think you just need unique field value counts on SYSTEMUNUMBERS. I got the code from here and modified a little.

<SPAN class="keyword token">import</SPAN> arcpy

table <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Database Connections\SDE.sde\NEO_1.SDE.P_PipeSystem\NEO_1.SDE.P_Meters'</SPAN>
field <SPAN class="operator token">=</SPAN> <SPAN class="string token">'SYSTEMNUMBER'</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>table<SPAN class="punctuation token">,</SPAN> field<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; occurances <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> sorted<SPAN class="punctuation token">(</SPAN>set<SPAN class="punctuation token">(</SPAN>occurances<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; icount <SPAN class="operator token">=</SPAN> occurances<SPAN class="punctuation token">.</SPAN>count<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <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>i<SPAN class="punctuation token">,</SPAN> icount<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>

JoshuaBixby

You might be making this more difficult than it needs to be. Have you thought about using Summary Statistics—Help | ArcGIS Desktop and summarizing by SYSTEMNUMBERS and then deleting the results for the system numbers you are not interested in? If this is going to be a regular activity, it might be worth scripting. If this only happens occasionally, it might be easier to run a GP tool and manually clean up the results table.

If there is some objection to using Summary Statistics, there are two ways to handle this using cursors. One is to pass a SQL WHERE clause to the cursor to limit the records and the other is retrieve all the records and use Python to do the following, which is what Joe is proposing.

JordanMiller4

In our meter layer we have a field called SYSTEMNUMBERS. I was asked if it was possible to write a python script that could count each meter record in each system and display the total amount. We have over 70 systems. The script is able to display only 1 system which is the 009.

JoeBorgione

I'm not sure what your objective is, but I have used something like this in the past:

 types <SPAN class="operator token">=</SPAN> <SPAN class="string token">"('AVE','BAY','BLVD','CIR','CT','CV','CYN','DR','EXPY','FWY','HWY','LN','PKWY','PL','RD','ROW','ST','SQ','TER','WY','')"</SPAN>

<SPAN class="comment token">#.......</SPAN>

<SPAN class="keyword token">if</SPAN> theType <SPAN class="keyword token">in</SPAN> types<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; do something
<SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; do something <SPAN class="keyword token">else</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JoshuaBixby

So the field name is systemList and you just want to have the cursor select records with values that are in the list?

For your search cursor, why are you passing both field and "SYSTEMNUMBER"? Since field is defined as "SYSTEMNUMBER", you are asking the cursor for return the same field twice, which is unusual.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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