My code loops through layers in multiple projects and prints the highest values for a specific field. I want to then append those values to an empty dictionary, but when I try and print the dictionary at the end of the code it is still empty. I've been trying to figure this out for a couple days now, but can't seem to figure it out myself or find a solution online. Any help or suggestions would be greatly appreciated. Thanks. import arcpy from arcpy import env markets = [ 3000 ] ### Declare variables fc = 'OpenCenters' fields = [ 'USER_market_id' , 'USER_ID' , 'USER_Center_Name' , 'USER_Opening_Date' ] fieldname = 'USER_market_id' sqlclause = ( None , 'Order By USER_market_id, USER_ID' ) for market in markets : print ( market ) results_dict = { } env . workspace = r "E:\arcGIS_Shared\Python\HeatMaps_{0}\HeatMaps_{0}.gdb" . format ( market ) ## Define WHERE clause statement whereclause = """{} = """ . format ( arcpy . AddFieldDelimiters ( fc , fieldname ) ) + str ( market ) ### Cursor to create list of centers to loop through with arcpy . da . SearchCursor ( in_table = fc , field_names = fields , where_clause = whereclause , sql_clause = sqlclause ) as cursor : ###Loop to run SummarizeWithin by center for row in ( cursor ) : p = arcpy . mp . ArcGISProject ( r 'E:\arcGIS_Shared\Python\HeatMaps_{0}\DiscreteHeatMaps{0}_{1}.aprx' . format ( market , row [ 2 ] ) ) m = p . listMaps ( ) [ 0 ] Layers = m . listLayers ( "DiscreteVisitsSumWithin{0}_{1}*" . format ( market , row [ 2 ] ) ) fields = [ 'SUM_USER_VisitCount' ] for Layer in Layers : try : sqlClause = ( None , 'ORDER BY ' + 'SUM_USER_VisitCount' ) with arcpy . da . SearchCursor ( in_table = Layer , field_names = fields , sql_clause = sqlClause ) as searchCursor : print ( max ( searchCursor ) ) results_dict [ Layer ] = max ( searchCursor ) except : pass print ( results_dict )

You will return a tuple when searching for the max value, i.e: (100,) Try the following: with arcpy . da . SearchCursor ( in_table = Layer , field_names = fields , sql_clause = sqlClause ) as searchCursor : for val in max ( searchCursor ) : results_dict [ Layer ] = int ( val ) del searchCursor

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

Python Add max(searchCursor) values to Dictionary

Business_IntelligenceSoftware

My code loops through layers in multiple projects and prints the highest values for a specific field. I want to then append those values to an empty dictionary, but when I try and print the dictionary at the end of the code it is still empty.

I've been trying to figure this out for a couple days now, but can't seem to figure it out myself or find a solution online.

Any help or suggestions would be greatly appreciated. Thanks.

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


markets <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">3000</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token">### Declare variables</SPAN>
fc <SPAN class="operator token">=</SPAN> <SPAN class="string token">'OpenCenters'</SPAN>
fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'USER_market_id'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'USER_ID'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'USER_Center_Name'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'USER_Opening_Date'</SPAN><SPAN class="punctuation token">]</SPAN>
fieldname <SPAN class="operator token">=</SPAN> <SPAN class="string token">'USER_market_id'</SPAN>


sqlclause <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Order By USER_market_id, USER_ID'</SPAN><SPAN class="punctuation token">)</SPAN>
 

<SPAN class="keyword token">for</SPAN> market <SPAN class="keyword token">in</SPAN> markets<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>market<SPAN class="punctuation token">)</SPAN>

    results_dict <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN>
    
    env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"E:\arcGIS_Shared\Python\HeatMaps_{0}\HeatMaps_{0}.gdb"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>market<SPAN class="punctuation token">)</SPAN>
    
    <SPAN class="comment token">## Define WHERE clause statement</SPAN>
    whereclause <SPAN class="operator token">=</SPAN> <SPAN class="string token">"""{} = """</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>AddFieldDelimiters<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> fieldname<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>market<SPAN class="punctuation token">)</SPAN>
        
    <SPAN class="comment token">### Cursor to create list of centers to loop through</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>in_table <SPAN class="operator token">=</SPAN> fc<SPAN class="punctuation token">,</SPAN> field_names <SPAN class="operator token">=</SPAN> fields<SPAN class="punctuation token">,</SPAN> where_clause<SPAN class="operator token">=</SPAN>whereclause<SPAN class="punctuation token">,</SPAN> sql_clause<SPAN class="operator token">=</SPAN>sqlclause<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
        <SPAN class="comment token">###Loop to run SummarizeWithin by center</SPAN>
        <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> <SPAN class="punctuation token">(</SPAN>cursor<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    
            
            p <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mp<SPAN class="punctuation token">.</SPAN>ArcGISProject<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">'E:\arcGIS_Shared\Python\HeatMaps_{0}\DiscreteHeatMaps{0}_{1}.aprx'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>market<SPAN class="punctuation token">,</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
            m <SPAN class="operator token">=</SPAN> p<SPAN class="punctuation token">.</SPAN>listMaps<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
                            
            Layers <SPAN class="operator token">=</SPAN> m<SPAN class="punctuation token">.</SPAN>listLayers<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"DiscreteVisitsSumWithin{0}_{1}*"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>market<SPAN class="punctuation token">,</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

            fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'SUM_USER_VisitCount'</SPAN><SPAN class="punctuation token">]</SPAN>


            <SPAN class="keyword token">for</SPAN> Layer <SPAN class="keyword token">in</SPAN> Layers<SPAN class="punctuation token">:</SPAN>
    
                <SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
    
                    sqlClause <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ORDER BY '</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'SUM_USER_VisitCount'</SPAN><SPAN class="punctuation 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>in_table <SPAN class="operator token">=</SPAN> Layer<SPAN class="punctuation token">,</SPAN> field_names <SPAN class="operator token">=</SPAN> fields<SPAN class="punctuation token">,</SPAN> 
                    sql_clause <SPAN class="operator token">=</SPAN> sqlClause<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> searchCursor<SPAN class="punctuation token">:</SPAN>
                        <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>max<SPAN class="punctuation token">(</SPAN>searchCursor<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
                        
                        results_dict<SPAN class="punctuation token">[</SPAN>Layer<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> max<SPAN class="punctuation token">(</SPAN>searchCursor<SPAN class="punctuation token">)</SPAN>
                        
                <SPAN class="keyword token">except</SPAN><SPAN class="punctuation token">:</SPAN>
                    <SPAN class="keyword token">pass</SPAN>


<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>results_dict<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>

Trouver plus de publications taguées avec

Accepted answers

jskinner

You will return a tuple when searching for the max value, i.e:

(100,)

Try the following:

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>in_table <SPAN class="operator token">=</SPAN> Layer<SPAN class="punctuation token">,</SPAN> field_names <SPAN class="operator token">=</SPAN> fields<SPAN class="punctuation token">,</SPAN> sql_clause <SPAN class="operator token">=</SPAN> sqlClause<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> searchCursor<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">for</SPAN> val <SPAN class="keyword token">in</SPAN> max<SPAN class="punctuation token">(</SPAN>searchCursor<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        results_dict<SPAN class="punctuation token">[</SPAN>Layer<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> int<SPAN class="punctuation token">(</SPAN>val<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">del</SPAN> searchCursor<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

Business_IntelligenceSoftware

I was not aware of that. Thank you!

Luke_Pinner

And don't forget that you can only use a cursor once and then it's exhausted/empty. So by using

<SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">print</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN>max<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN>searchCursor<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">))</SPAN>

You have exhausted the cursor.

Business_IntelligenceSoftware

This worked! Thank you Jake

jskinner

You will return a tuple when searching for the max value, i.e:

(100,)

Try the following:

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>in_table <SPAN class="operator token">=</SPAN> Layer<SPAN class="punctuation token">,</SPAN> field_names <SPAN class="operator token">=</SPAN> fields<SPAN class="punctuation token">,</SPAN> sql_clause <SPAN class="operator token">=</SPAN> sqlClause<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> searchCursor<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">for</SPAN> val <SPAN class="keyword token">in</SPAN> max<SPAN class="punctuation token">(</SPAN>searchCursor<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        results_dict<SPAN class="punctuation token">[</SPAN>Layer<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> int<SPAN class="punctuation token">(</SPAN>val<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">del</SPAN> searchCursor<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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