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

Shifting X coordinates using SHAPE@X

anTonialcaraz

Hi,

I need to shift by 360° points that are offset. It is just 7 columns of points in the West on the X axis that need to be shifted (see pictures and script below). I'm getting this error: TypeError: 'float' object has no attribute '__getitem__'

Also, I'm not sure if I'm selecting/identifying the 7 columns of points I want correctly on my script.

Any help will be much appreciated.

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


FC <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"H:\NETcdf_TEST\TEST.gdb\rast2point"</SPAN>

x_shift <SPAN class="operator token">=</SPAN> float<SPAN class="punctuation token">(</SPAN><SPAN class="number token">360</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>FC<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'SHAPE@X'</SPAN><SPAN class="punctuation token">]</SPAN><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; cursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN><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="number token">7</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> x_shift<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">del</SPAN> cursor

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

Find more posts tagged with

Accepted answers

anTonialcaraz

Thanks for all the suggestions. I did it selecting first the points I wanted to move. Maybe not very elegant but it works.

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env
<SPAN class="keyword token">from</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>sa <SPAN class="keyword token">import</SPAN> <SPAN class="operator token">*</SPAN>



FC1 <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"H:\NETcdf_TEST\TEST.gdb\rast2point"</SPAN> <SPAN class="comment token"># This is the point FC after resampling (0.25/bilinear) and converting the shifted netcdf</SPAN>
FC2 <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"H:\NETcdf_TEST\TEST.gdb\rast2point2"</SPAN>
FC1new <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"H:\NETcdf_TEST\TEST.gdb\rast2point_new1"</SPAN>
FC2new <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"H:\NETcdf_TEST\TEST.gdb\rast2point2_new2"</SPAN>
FCfinal <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"H:\NETcdf_TEST\TEST.gdb\rast2pointFinal"</SPAN>


<SPAN class="comment token"># Add XY coordinate fields and calculate field geometry</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>AddXY_management<SPAN class="punctuation token">(</SPAN>FC1<SPAN class="punctuation token">)</SPAN>


<SPAN class="comment token"># Make a copy of FC1</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>Copy_management<SPAN class="punctuation token">(</SPAN>FC1<SPAN class="punctuation token">,</SPAN>FC2<SPAN class="punctuation token">)</SPAN>


<SPAN class="comment token"># Make layers from FCs</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>FC1<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"FC1_lyr"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>FC2<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"FC2_lyr"</SPAN><SPAN class="punctuation token">)</SPAN>


<SPAN class="comment token"># Select point values <-180 (FC1) and point values >-180 (FC2)</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"FC1_lyr"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'"POINT_X" <-180'</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"FC2_lyr"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'"POINT_X" >-180'</SPAN><SPAN class="punctuation token">)</SPAN>


<SPAN class="comment token"># Write the selected features to a new featureclass</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>CopyFeatures_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"FC1_lyr"</SPAN><SPAN class="punctuation token">,</SPAN> FC1new<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CopyFeatures_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"FC2_lyr"</SPAN><SPAN class="punctuation token">,</SPAN> FC2new<SPAN class="punctuation token">)</SPAN>


<SPAN class="comment token"># Perform the move of FC1new</SPAN>

xOffset <SPAN class="operator token">=</SPAN> <SPAN class="number token">360.000</SPAN>
yOffset <SPAN class="operator token">=</SPAN> <SPAN class="number token">0.000</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>FC1new<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"SHAPE@XY"</SPAN><SPAN class="punctuation token">]</SPAN><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; cursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN><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="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> xOffset<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="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> yOffset<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>


<SPAN class="comment token"># Refresh GDB</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>RefreshCatalog<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">"H:\NETcdf_TEST\TEST.gdb"</SPAN><SPAN class="punctuation token">)</SPAN>


<SPAN class="comment token"># Merge FC1new and FC2new into FCfinal</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>Merge_management<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>FC1new<SPAN class="punctuation token">,</SPAN> FC2new<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> FCfinal<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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

anTonialcaraz

Thanks for all the suggestions. I did it selecting first the points I wanted to move. Maybe not very elegant but it works.

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env
<SPAN class="keyword token">from</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>sa <SPAN class="keyword token">import</SPAN> <SPAN class="operator token">*</SPAN>



FC1 <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"H:\NETcdf_TEST\TEST.gdb\rast2point"</SPAN> <SPAN class="comment token"># This is the point FC after resampling (0.25/bilinear) and converting the shifted netcdf</SPAN>
FC2 <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"H:\NETcdf_TEST\TEST.gdb\rast2point2"</SPAN>
FC1new <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"H:\NETcdf_TEST\TEST.gdb\rast2point_new1"</SPAN>
FC2new <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"H:\NETcdf_TEST\TEST.gdb\rast2point2_new2"</SPAN>
FCfinal <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"H:\NETcdf_TEST\TEST.gdb\rast2pointFinal"</SPAN>


<SPAN class="comment token"># Add XY coordinate fields and calculate field geometry</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>AddXY_management<SPAN class="punctuation token">(</SPAN>FC1<SPAN class="punctuation token">)</SPAN>


<SPAN class="comment token"># Make a copy of FC1</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>Copy_management<SPAN class="punctuation token">(</SPAN>FC1<SPAN class="punctuation token">,</SPAN>FC2<SPAN class="punctuation token">)</SPAN>


<SPAN class="comment token"># Make layers from FCs</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>FC1<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"FC1_lyr"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>FC2<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"FC2_lyr"</SPAN><SPAN class="punctuation token">)</SPAN>


<SPAN class="comment token"># Select point values <-180 (FC1) and point values >-180 (FC2)</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"FC1_lyr"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'"POINT_X" <-180'</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"FC2_lyr"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'"POINT_X" >-180'</SPAN><SPAN class="punctuation token">)</SPAN>


<SPAN class="comment token"># Write the selected features to a new featureclass</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>CopyFeatures_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"FC1_lyr"</SPAN><SPAN class="punctuation token">,</SPAN> FC1new<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CopyFeatures_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"FC2_lyr"</SPAN><SPAN class="punctuation token">,</SPAN> FC2new<SPAN class="punctuation token">)</SPAN>


<SPAN class="comment token"># Perform the move of FC1new</SPAN>

xOffset <SPAN class="operator token">=</SPAN> <SPAN class="number token">360.000</SPAN>
yOffset <SPAN class="operator token">=</SPAN> <SPAN class="number token">0.000</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>FC1new<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"SHAPE@XY"</SPAN><SPAN class="punctuation token">]</SPAN><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; cursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN><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="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> xOffset<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="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> yOffset<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>


<SPAN class="comment token"># Refresh GDB</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>RefreshCatalog<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">"H:\NETcdf_TEST\TEST.gdb"</SPAN><SPAN class="punctuation token">)</SPAN>


<SPAN class="comment token"># Merge FC1new and FC2new into FCfinal</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>Merge_management<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>FC1new<SPAN class="punctuation token">,</SPAN> FC2new<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> FCfinal<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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

curtvprice

Your points look like a raster that has been converted to points.

Do you want to shift a raster? This can be done using the Shift tool in Desktop and Pro.

(Thought it was worth mentioning.)

bixb0012

Are you selecting first only the points you want to shift? If you have a feature class with lots of points and only want to shift some, you either have to understand how the points are ordered or only select those you want to shift; otherwise, you won't have any way to know whether a point needs to be shifted or not.

In your code above, row will be a list with a single X value, the X value of the "first" point, whatever that point is depending on the ordering of the cursor. Your code is failing because row[0] returned a float, and floats don't support indexing, slicing, or other similar functions that sequences support.

DanPatterson_Retired

try [:7] instead of [7]

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.