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

Update Cursor on Join Tables

deleted-user-yC5VkbyXzrQR

Hello,

So I'm having a hard time trying to figure how to do this script. I almost have it figured out I'm just missing something.

I figured out that you can't use CursorUpdate with a join table so I'm doing a work around that I found on other forums.

Trying to do this:

1. Download Parcels from Hosted Feature Layer from ArcGIS Online (completed)

2. Compare the Hosted Feature Layer to our parcel database (exact same dataset).

3. Find the differences in the "Status" Field and update our database with the new "Status" field from the Hosted Layer.

4. Keep track of what parcels have changed in a list.

Below is what I thought it would work but it prints all yes for every single parcel and not the ones where the Status is differnt. (i'm just using print yes, Not updating them until I get this part figured out)

hostedfc <SPAN class="operator token">=</SPAN> dict<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN>r<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>r<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> r <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"testingg_3"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"APN"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Status_5"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>  
  
  
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"testingg_2"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"APN"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Status_5"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<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">if</SPAN> hostedfc<SPAN class="punctuation token">[</SPAN>keys<SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">in</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">and</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">!=</SPAN> hostedfc<SPAN class="punctuation token">[</SPAN>values<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
			<SPAN class="keyword token">print</SPAN> <SPAN class="string token">"yes"</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Am I on the right track? I've spent hours trying to figure this part out.

Find more posts tagged with

Accepted answers

RandyBurton

Looks like you are trying to accomplish what Richard Fairhurst‌ is describing in his blog: Turbo Charging Data Manipulation with Python Cursors and Dictionaries. See his code for Example 1.

All comments

bixb0012

The link you quote creates and populates the dictionary, including keys. That said, you do not access the keys by dict[keys]. The syntax is dict.keys().

deleted-user-yC5VkbyXzrQR

Nice Randy! This was exactly what I was looking for!

JoeBorgione

I try to be a little more explicit when using dictionaries as update sources, and following the turbo charging approach Randy Burton‌ mentions above, just yesterday I was working on this def():

<SPAN class="keyword token">import</SPAN> arcpy<SPAN class="punctuation token">,</SPAN> decimal
decimal<SPAN class="punctuation token">.</SPAN>getcontext<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>prec<SPAN class="operator token">=</SPAN><SPAN class="number token">3</SPAN>
<SPAN class="keyword token">from</SPAN> decimal <SPAN class="keyword token">import</SPAN> Decimal

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">updateField</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>

    
    outSDE <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'I:\GIS\arcsde\SuperUser\slcogis\gdb_AG\gdb_AG@slcogisTEST.sde'</SPAN>
    
    
    targetFC <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'I:\GIS\arcsde\SuperUser\slcogis\gdb_AG\gdb_AG@slcogisTEST.sde\SLCOGIS.GDB_AG.ClientsDeliveries_2019'</SPAN>
    targetFields <SPAN class="operator token">=</SPAN>  <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Zipcode'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'ClientCount'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'PercentPopServed'</SPAN><SPAN class="punctuation token">]</SPAN>
    
    popSrcTable <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'I:\GIS\ArcSDE\SuperUser\slcogis\gdb_AG\gdb_AG@slcogisTEST.sde\SLCOGIS.GDB_AG.Over60Population_2018'</SPAN> <SPAN class="comment token">#'{}\SLCOGIS.GDB_AG.Over60Population2018'.format(outSDE)</SPAN>
    popSrcFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'ID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'TotalOVer60'</SPAN><SPAN class="punctuation token">]</SPAN>
    
    edit <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>Editor<SPAN class="punctuation token">(</SPAN>outSDE<SPAN class="punctuation token">)</SPAN>
    edit<SPAN class="punctuation token">.</SPAN>startEditing<SPAN class="punctuation token">(</SPAN><SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">)</SPAN>
    edit<SPAN class="punctuation token">.</SPAN>startOperation<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
    
    <SPAN class="comment token">#create dictionary....</SPAN>
    popDict <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>r<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>r<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> r <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>popSrcTable<SPAN class="punctuation token">,</SPAN>popSrcFields<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">}</SPAN>
    
    <SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>targetFC<SPAN class="punctuation token">,</SPAN>targetFields<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> updateCursor<SPAN class="punctuation token">:</SPAN>
            <SPAN class="keyword token">for</SPAN> updateRow <SPAN class="keyword token">in</SPAN> updateCursor<SPAN class="punctuation token">:</SPAN>
                keyValue <SPAN class="operator token">=</SPAN> updateRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
                <SPAN class="keyword token">if</SPAN> keyValue <SPAN class="operator token">==</SPAN> None<SPAN class="punctuation token">:</SPAN>
                    <SPAN class="keyword token">pass</SPAN>
                <SPAN class="keyword token">elif</SPAN> keyValue <SPAN class="keyword token">in</SPAN> popDict<SPAN class="punctuation token">:</SPAN>
                    client <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>updateRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
                    pop <SPAN class="operator token">=</SPAN> popDict<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN>keyValue<SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
                    newValue <SPAN class="operator token">=</SPAN> Decimal<SPAN class="punctuation token">(</SPAN>client<SPAN class="punctuation token">)</SPAN><SPAN class="operator token">/</SPAN>Decimal<SPAN class="punctuation token">(</SPAN>pop<SPAN class="punctuation token">)</SPAN><SPAN class="operator token">*</SPAN><SPAN class="number token">100</SPAN>
                    updateRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> newValue
                    updateCursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>updateRow<SPAN class="punctuation token">)</SPAN>
            <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Success: mergeClientToDelivery updated fields in deliveries table in memory'</SPAN><SPAN class="punctuation token">)</SPAN>
            edit<SPAN class="punctuation token">.</SPAN>stopOperation<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
            edit<SPAN class="punctuation token">.</SPAN>stopEditing<SPAN class="punctuation token">(</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">except</SPAN> Exception <SPAN class="keyword token">as</SPAN> err<SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Error: mergeClientToDelivery could not update deliveries table in memory'</SPAN><SPAN class="punctuation token">)</SPAN>
        <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>err<SPAN class="punctuation token">)</SPAN>
        <SPAN class="comment token">#sendEmail(err)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍</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>

I have a table of population data referenced as popSrcTable that has a Zipcode field (ID) and the Population of that zipcode (TotalOVer60) and I need to ratio that population value to the number of Clients served (ClientCount) to get a percentage (PercentPopServed) updated in the target feature class.

First step is to create the dictionary of the population data in the form of

<SPAN class="punctuation token">{</SPAN><SPAN class="string token">'84009'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">2818</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'84006'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">145</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'84084'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">4788</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'84113'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">14</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">}</SPAN>‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Where the keys values are zipcode, and the associated values are the population. Line 30 is where things get interesting: there it checks for the presence of the zipcode in my target (updateRow[0]). Line 31 gets the number of clients((updateRow[1]). Line 32 is where I 'get' the value of the population for the given zipcode; that's the linch pin when using dictionary. Finally I do a little math and update...

In my case the dictionary is simple: 1 key, 1 value, but you could have multiple values to a single key and update multiple fields if you need to.

RandyBurton

Looks like you are trying to accomplish what Richard Fairhurst‌ is describing in his blog: Turbo Charging Data Manipulation with Python Cursors and Dictionaries. See his code for Example 1.

deleted-user-yC5VkbyXzrQR

Thanks for the reply Joshua.

hmmm, I thought I was defining the keys and values in line 1.

</CODE><PRE class="" style="color: #000000; background: #f5f2f0; border: 0px; margin: 0.5em 0px; padding: 1em 1em 1em 3.8em;"><CODE style="border: 0px; font-weight: inherit;">hostedfc = dict([(r[0], (r[1])) for r in arcpy.da.SearchCursor("testingg_3", ["APN","Status_5"])])

If I just run that line of code. And then type in "hostedfc"

</CODE><CODE style="border: 0px; font-weight: inherit;">

I get the whole dictionary to populate with The key: APN and the Value is Status_5

bixb0012

Where is keys being defined? You are using it in Line #6, but it isn't defined anywhere in the code snippet you provide.

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.