How can I copy the values from multiple fields from one feature class to another, based on a spatial join and name query

AyomipoAdeyemo

I'm trying to write a standalone script to copy the values from 6 fields in a feature class to another feature class based on a spatial join and name query. I am stuck at updating the values from the join table to my original table.

<SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Importing modules..."</SPAN>
<SPAN class="keyword token">import</SPAN> sys<SPAN class="punctuation token">,</SPAN> arcpy<SPAN class="punctuation token">,</SPAN> traceback


arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\LVS\PECO\PECO\Python\Python\Script\test_code.gdb\GAS"</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>

<SPAN class="comment token"># Local variables:</SPAN>
GFR <SPAN class="operator token">=</SPAN> <SPAN class="string token">"GFR"</SPAN>
Parcel <SPAN class="operator token">=</SPAN> <SPAN class="string token">"PECO_TaxParcels"</SPAN>
GFR_SpatialJoin <SPAN class="operator token">=</SPAN> <SPAN class="string token">"C:\\Users\\aadeyemo\\Documents\\ArcGIS\\Default.gdb\\GFR_SpatialJoin"</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"GFR"</SPAN><SPAN class="punctuation token">,</SPAN> GFR<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"PECO_TaxParcels"</SPAN><SPAN class="punctuation token">,</SPAN> Parcel<SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token"># Process: Select Layer By Attribute</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN>GFR<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"STREET_NAME IS NULL"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token"># Process: Spatial Join</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>SpatialJoin_analysis<SPAN class="punctuation token">(</SPAN>GFR<SPAN class="punctuation token">,</SPAN> Parcel<SPAN class="punctuation token">,</SPAN> GFR_SpatialJoin<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"JOIN_ONE_TO_ONE"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"KEEP_ALL"</SPAN><SPAN class="punctuation token">)</SPAN>

path_dict1 <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN>

SC1 <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor <SPAN class="punctuation token">(</SPAN>GFR_SpatialJoin<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"TARGET_FID"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"STHSNUM"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"STSTNAME"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"STSUFFIX"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"STCITY"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"STSTATE"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"STZIP"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> SC1<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp; path_dict1<SPAN class="punctuation token">[</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</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>
&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> SC1<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> path_dict1
<SPAN class="keyword token">del</SPAN> row

ucursor <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>GFR<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"OBJECTID"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"STREET_NUMBER"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"STREET_NAME"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"STREET_SUFFIX"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"CITY"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"STATE"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ZIP_CODE"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> urow <SPAN class="keyword token">in</SPAN> ucursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> path_dict1<SPAN class="punctuation token">.</SPAN>has_key<SPAN class="punctuation token">(</SPAN> urow<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>
&nbsp;&nbsp; urow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> path_dict1<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</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>

This currently returns a value of zero when i try to copy values.

MitchHolley1

Have you tried using a list instead of a dictionary?

path_list =[]

path_split = []

 

with arcpy.da.SearchCursor (GFR_SpatialJoin, ["TARGET_FID", "STHSNUM", "STSTNAME", "STSUFFIX", "STCITY", "STSTATE", "STZIP"]) as cursor:
   for row in cursor:
      path_list.append(row[0] + '|' + row[1] + '|' + row[2] + '|' + row[3] + '|' + row[4] + '|' + row[5] + '|' + row[6])
del row

 

for p in path_list:

   path_split.append(p.split('|'))

with arcpy.da.UpdateCursor(GFR, ["OBJECTID", "STREET_NUMBER", "STREET_NAME", "STREET_SUFFIX", "CITY", "STATE", "ZIP_CODE"]) as cursor:
   for row in cursor:

      for p in path_split:
         if str(row[0]) == s[0]:

               row[1] = s[1]

               row[2] = s[2]

               row[3] = s[3]

               row[4] = s[4]

               row[5] = s[5]

               row[6] = s[6]

         cursor.updateRow(row)