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

Copy specific field values using python in ArcGIS Pro

nonipaulette

Hi there everyone.

First of all thanks for helping, and I realize I need some tutorials in python and can hopefully address that soon.

Problem: Using the Calculate Field tool I would like copy values from two other fields based on specific criteria. For instance I have a new field called "UnathorizedOccupantID". I would like to copy values from the field called "ClusterID", however when there is a value of -1 I would like to copy the corresponding values from the "SourceID" field. As seen here:

I believe this will get me to the next part of the analysis which is aggregating the cluster ID's using the Dissolve tool.

Thanks for any help it is greatly appreciated!

Find more posts tagged with

Accepted answers

LanceCole

noni paulette‌,

Just modify the function as follows. Make sure your 'UOID' field is set to text and not numeric.

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">uio</SPAN><SPAN class="punctuation token">(</SPAN>cluster<SPAN class="punctuation token">,</SPAN> source<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
  <SPAN class="keyword token">if</SPAN> cluster <SPAN class="operator token">></SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">return</SPAN> <SPAN class="string token">'C%s'</SPAN> <SPAN class="operator token">%</SPAN>cluster
  <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">return</SPAN> <SPAN class="string token">'S%s'</SPAN> <SPAN class="operator token">%</SPAN>source‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

LanceCole

noni paulette‌,

Just modify the function as follows. Make sure your 'UOID' field is set to text and not numeric.

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">uio</SPAN><SPAN class="punctuation token">(</SPAN>cluster<SPAN class="punctuation token">,</SPAN> source<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
  <SPAN class="keyword token">if</SPAN> cluster <SPAN class="operator token">></SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">return</SPAN> <SPAN class="string token">'C%s'</SPAN> <SPAN class="operator token">%</SPAN>cluster
  <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">return</SPAN> <SPAN class="string token">'S%s'</SPAN> <SPAN class="operator token">%</SPAN>source‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

nonipaulette

Hi Lance im running into an issue where two fields are populating the new field with the same value. Here is a description below:

Your code worked, however I need to tweak it so that the copied values are uniquely distinguishable.

Thanks again!

nonipaulette

Lance

Thanks alot for taking the time to resolve the task and the geonet tip. Greatly appreciated!

-Noni

LanceCole

noni,

For future reference, when you have a question please post as a question not as a discussion. You will get a better response from GeoNet.

This can be easily completed using python in field calculator. Create a function (uio), such as the following, which has a conditional statement that returns the ClusterID if it is not negative and otherwise returns the SourceID. You can customize this as needed.

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">uio</SPAN><SPAN class="punctuation token">(</SPAN>cluster<SPAN class="punctuation token">,</SPAN> source<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
  <SPAN class="keyword token">if</SPAN> cluster <SPAN class="operator token">></SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">return</SPAN> cluster
  <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">return</SPAN> source‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

You will call this using the statement uio( !ClusterID!, !SourceID!).

Below is the same shown in Field Calculator from ArcGIS Desktop. It would be the same in Pro.

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.