My conundrum is, is it possible to calculate fields based on other fields in a stand-alone python script. An example would be a group of values bases on two fields dictates what gets calculated in two other fields such as GeneralConcern = 1 (subytype) and SpecificConcern = "Pothole" and ContactDept IS NULL and DeptInfo IS NULL, calculate ContactDept = "Street Dept" and calculates DeptInfo = "715-555-5555".? This is what I have come up with so far, but I am having a hard time wrapping my head around it. import arcpy # Set workspaces workspace = r 'C:\ESRITest\GeoReportingSystem\Testing9116\Testing9116.gdb' outWorkspace = r 'C:\ESRITest\GeoReportingSystem\Testing9116\Scratch.gdb' # Set feature classes tbl = r 'C:\ESRITest\GeoReportingSystem\Testing9116\Testing9116.gdb\GeoReporting' # Set other variables pContact = "PrimaryContact" contactInfo = "PrimaryInformation" sql = """{} is NULL AND {} IS NULL""" . format ( pContact , contactInfo ) specificCon1 = [ 'Commercial Signage Concern' , 'Temporary Signage Concern' , 'Building Maintenance Issue' , 'Fence Concern' , 'Land Use Concern' , 'Property Maintenance Concern' , 'Setback or Property Concern' , 'Other' ] # Mulitple General Concern Numbers specificCon2 = [ 'Athletic Field Issue' , 'Fairgrounds Issue' , 'Park Maintenance Issue' , 'Pool Issue' , 'Restroom Issue' , 'Shelter Issue' , 'Skate Park Issue' , 'Trail Maintenance Issue' , 'Unsafe or Downed Tree' , 'Zoo Issue' , 'Other' ] # Starting an Edit Session - DMB edit = arcpy . da . Editor ( workspace ) edit . startEditing ( False , True ) edit . startOperation ( ) # What I am trying to do is update the Null PrimaryContact and PrimaryInformation fields based on a General Concern (subtype number) and a specific concern. #Example would be General Concern = 6 and Specific Concern = Pool Issue then PrimaryContact = Parks and Recreation and PrimaryInformation = 715-555-5555 # See specificCon1. That variable will be a mix of several General Concern numbers like with arcpy . da . UpdateCursor ( tbl , [ 'PrimaryContact' , 'PrimaryInformation' ] , where_clause = sql ) as cursor : for row in cursor : if value == specificCon1 : row . setValue ( "PrimaryContact" , "Development Services" row . setValue ( "PrimaryInformation" , "715-555-5555" ) elif value == specificCon2 : row . setValue ( "PrimaryContact" , "Parks and Recreation" row . setValue ( "PrimaryInformation" , "715-555-5555" ) else : == "??????" : # Closing the Edit Session - DMB edit . stopOperation ( ) edit . stopEditing ( True )

There are many possibilities, but getting your options into some sort of data structure (list, dictionary, table, etc.) would be my first step. Then, if the cursor values match the option values, fill in the other values. options = [ [ 1 , 'Traffic Issue' , 'Engineering' , '715-555-5555' ] , [ 1 , 'Traffic Signal Issue' , 'Engineering' , '715-555-5555' ] , [ 1 , 'Vision Obstruction' , 'Engineering' , '715-555-5555' ] , [ 2 , 'Cracked Sidewalks' , 'Engineering' , '715-555-5555' ] , [ 2 , 'Curb Ramp Issue' , 'Engineering' , '715-555-5555' ] , [ 2 , 'Slope Issue' , 'Engineering' , '715-555-5555' ] , [ 2 , 'Tree or Brush Clearance Issue' , 'Engineering' , '715-555-5555' ] , [ 2 , 'Uneven Sidewalk' , 'Engineering' , '715-555-5555' ] , [ 2 , 'Other' , 'Engineering' , '715-555-5555' ] , [ 8 , 'Culvert Replacement' , 'Engineering' , '715-555-5555' ] , [ 8 , 'Ditch Flow Issue' , 'Engineering' , '715-555-5555' ] , [ 8 , 'Ponding Water' , 'Engineering' , '715-555-5555' ] , [ 8 , 'Other' , 'Engineering' , '715-555-5555' ] , [ 5 , 'Fire Code Violation' , 'Fire Department' , '715-555-5555' ] , [ 5 , 'Illegal Burning' , 'Fire Department' , '715-555-5555' ] ] with arcpy . da . UpdateCursor ( tbl , [ 'GeneralConcern' , 'SpecificConcern' , 'PrimaryContact' , 'PrimaryInformation' ] , where_clause = sql ) as cursor : for row in cursor : for option in options : if option [ 0 ] == row [ 0 ] and option [ 1 ] == row [ 1 ] : row [ 2 ] = option [ 2 ] row [ 3 ] = option [ 3 ] if not row [ 2 ] and not row [ 3 ] : # not 100% sure about this print 'No Match' cursor . updateRow ( row ) # update row in table with values held in row variable

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

Updating fields based on other fields - Python Script

alexis_s

My conundrum is, is it possible to calculate fields based on other fields in a stand-alone python script. An example would be a group of values bases on two fields dictates what gets calculated in two other fields such as GeneralConcern = 1 (subytype) and SpecificConcern = "Pothole" and ContactDept IS NULL and DeptInfo IS NULL, calculate ContactDept = "Street Dept" and calculates DeptInfo = "715-555-5555".?

This is what I have come up with so far, but I am having a hard time wrapping my head around it.

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

<SPAN class="comment token"># Set workspaces</SPAN>
workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\ESRITest\GeoReportingSystem\Testing9116\Testing9116.gdb'</SPAN>
outWorkspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\ESRITest\GeoReportingSystem\Testing9116\Scratch.gdb'</SPAN>

<SPAN class="comment token"># Set feature classes</SPAN>
tbl <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\ESRITest\GeoReportingSystem\Testing9116\Testing9116.gdb\GeoReporting'</SPAN>

<SPAN class="comment token"># Set other variables</SPAN>
pContact <SPAN class="operator token">=</SPAN> <SPAN class="string token">"PrimaryContact"</SPAN>
contactInfo <SPAN class="operator token">=</SPAN> <SPAN class="string token">"PrimaryInformation"</SPAN>
sql <SPAN class="operator token">=</SPAN> <SPAN class="string token">"""{} is NULL AND {} IS NULL"""</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>pContact<SPAN class="punctuation token">,</SPAN> contactInfo<SPAN class="punctuation token">)</SPAN>

specificCon1 <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Commercial Signage Concern'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Temporary Signage Concern'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Building Maintenance Issue'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Fence Concern'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Land Use Concern'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Property Maintenance Concern'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Setback or Property Concern'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Other'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"># Mulitple General Concern&nbsp; Numbers</SPAN>
specificCon2 <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Athletic Field Issue'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Fairgrounds Issue'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Park Maintenance Issue'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Pool Issue'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Restroom Issue'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Shelter Issue'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Skate Park Issue'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Trail Maintenance Issue'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Unsafe or Downed Tree'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Zoo Issue'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Other'</SPAN> <SPAN class="punctuation token">]</SPAN>


<SPAN class="comment token"># Starting an Edit Session - DMB</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>workspace<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">True</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"># What I am trying to do is update the Null PrimaryContact and PrimaryInformation fields based on a General Concern (subtype number) and a specific concern.</SPAN>
<SPAN class="comment token">#Example would be General Concern = 6 and Specific Concern = Pool Issue then PrimaryContact = Parks and Recreation and PrimaryInformation = 715-555-5555</SPAN>
<SPAN class="comment token"># See specificCon1.&nbsp; That variable will be a mix of several General Concern numbers like</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>tbl<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'PrimaryContact'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'PrimaryInformation'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="punctuation token">,</SPAN> where_clause <SPAN class="operator token">=</SPAN> sql<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> value <SPAN class="operator token">==</SPAN> specificCon1<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">.</SPAN>setValue<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"PrimaryContact"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Development Services"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">.</SPAN>setValue<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"PrimaryInformation"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"715-555-5555"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">elif</SPAN> value <SPAN class="operator token">==</SPAN> specificCon2<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">.</SPAN>setValue<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"PrimaryContact"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Parks and Recreation"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">.</SPAN>setValue<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"PrimaryInformation"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"715-555-5555"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="string token">"??????"</SPAN><SPAN class="punctuation token">:</SPAN>


<SPAN class="comment token"># Closing the Edit Session - DMB</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="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>

Encuentra más publicaciones etiquetadas con

Accepted answers

DarrenWiens2

There are many possibilities, but getting your options into some sort of data structure (list, dictionary, table, etc.) would be my first step. Then, if the cursor values match the option values, fill in the other values.

 

options <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Traffic Issue'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Engineering'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Traffic Signal Issue'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Engineering'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Vision Obstruction'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Engineering'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Cracked Sidewalks'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Engineering'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Curb Ramp Issue'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Engineering'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Slope Issue'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Engineering'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Tree or Brush Clearance Issue'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Engineering'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Uneven Sidewalk'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Engineering'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Other'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Engineering'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Culvert Replacement'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Engineering'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Ditch Flow Issue'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Engineering'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Ponding Water'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Engineering'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Other'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Engineering'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Fire Code Violation'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Fire Department'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Illegal Burning'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Fire Department'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</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>tbl<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'GeneralConcern'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'SpecificConcern'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'PrimaryContact'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'PrimaryInformation'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="punctuation token">,</SPAN> where_clause <SPAN class="operator token">=</SPAN> sql<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> option <SPAN class="keyword token">in</SPAN> options<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> option<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">and</SPAN> option<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> option<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> option<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">and</SPAN> <SPAN class="operator token">not</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># not 100% sure about this</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">'No Match'</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># update row in table with values held in row variable‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍</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>

 

All comments

alexis_s

Thanks Darren,

After seeing an example, I get it now. I appreciate your help on this. That works.

DarrenWiens2

 

options <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Traffic Issue'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Engineering'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Traffic Signal Issue'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Engineering'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Vision Obstruction'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Engineering'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Cracked Sidewalks'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Engineering'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Curb Ramp Issue'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Engineering'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Slope Issue'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Engineering'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Tree or Brush Clearance Issue'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Engineering'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Uneven Sidewalk'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Engineering'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Other'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Engineering'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Culvert Replacement'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Engineering'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Ditch Flow Issue'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Engineering'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Ponding Water'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Engineering'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Other'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Engineering'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Fire Code Violation'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Fire Department'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Illegal Burning'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Fire Department'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'715-555-5555'</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>tbl<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'GeneralConcern'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'SpecificConcern'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'PrimaryContact'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'PrimaryInformation'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="punctuation token">,</SPAN> where_clause <SPAN class="operator token">=</SPAN> sql<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> option <SPAN class="keyword token">in</SPAN> options<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> option<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">and</SPAN> option<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> option<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> option<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">and</SPAN> <SPAN class="operator token">not</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># not 100% sure about this</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">'No Match'</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># update row in table with values held in row variable‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍</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>

 

alexis_s

Darren,

I am not sure how to set it up either. Hopefully, this will help clarify:

GeneralConcern will have a integer 1 through 8

SpecificConcern will have a text value

PrimaryContact and PrimaryInformation should be null (no sense recalculating what is already calculated)

So if all the criteria are met, calculate PrimaryContact with a text value (a Department) and and PrimaryInformation with a text value (Phone Number) else do nothing and end.

Example would be:

Before:

GeneralConcern	SpecificConcern	PrimaryContact	PrimaryInformation
1	Traffic Issue	Engineering	715-555-5555
2	Slope Issue	<null>	<null>
1	Traffic Signal Issue	<null>	<null>

After:

GeneralConcern	SpecificConcern	PrimaryContact	PrimaryInformation
1	Traffic Issue	Engineering	715-555-5555
2	Slope Issue	Engineering	715-555-5555
1	Traffic Signal Issue	Engineering	715-555-5555

Here is sample of what present in the GeneralConcern and SpecificConcern fields and what PrimaryContact and PrimaryInformation should be calculated to:

GeneralConcern	SpecificConcern	PrimaryContact	PrimaryInformation
1	Traffic Issue	Engineering	715-555-5555
1	Traffic Signal Issue	Engineering	715-555-5555
1	Vision Obstruction	Engineering	715-555-5555
2	Cracked Sidewalks	Engineering	715-555-5555
2	Curb Ramp Issue	Engineering	715-555-5555
2	Slope Issue	Engineering	715-555-5555
2	Tree or Brush Clearance Issue	Engineering	715-555-5555
2	Uneven Sidewalk	Engineering	715-555-5555
2	Other	Engineering	715-555-5555
8	Culvert Replacement	Engineering	715-555-5555
8	Ditch Flow Issue	Engineering	715-555-5555
8	Ponding Water	Engineering	715-555-5555
8	Other	Engineering	715-555-5555
5	Fire Code Violation	Fire Department	715-555-5555
5	Illegal Burning	Fire Department	715-555-5555

DarrenWiens2

Please see da.UpdateCursor. You're going back and forth between the old (e.g. setValue) and new cursor syntax.

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>tbl<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'GeneralConcern'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'SpecificConcern'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'PrimaryContact'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'PrimaryInformation'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="punctuation token">,</SPAN> where_clause <SPAN class="operator token">=</SPAN> sql<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="string token">'SomeGeneralConcern1'</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> <SPAN class="string token">'SomeSpecificConcern1'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'SomePrimaryContact1'</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'SomePrimaryInformation1'</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">elif</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="string token">'SomeGeneralConcern2'</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> <SPAN class="string token">'SomeSpecificConcern2'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'SomePrimaryContact2'</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'SomePrimaryInformation2'</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">elif</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="string token">'SomeGeneralConcern3'</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> <SPAN class="string token">'SomeSpecificConcern3'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'SomePrimaryContact3'</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'SomePrimaryInformaton3'</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; etc<SPAN class="punctuation token">.</SPAN>
&nbsp;&nbsp;&nbsp; cursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># update row in table with values held in row variable‍‍‍‍‍‍‍‍‍‍‍‍‍</SPAN>

I'm not quite sure how best to set up the logic without knowing more about how you want to make decisions for primary contact and information.

alexis_s

I have GeoEvent Processor, which I know will do this, but I was hoping to off load it to a script as it does not need to get updated all that often in the grander scheme of the project.

JoeBorgione

I don't know about doing it in python, but the attribute assistant can do this for you...

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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