<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic How to get coordinates from next row? in Python Questions</title>
    <link>https://community.esri.com/t5/python-questions/how-to-get-coordinates-from-next-row/m-p/319850#M24859</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hello,&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I recently used the CalculateEndTime (&lt;/SPAN&gt;&lt;A href="http://goo.gl/mJqjG" rel="nofollow noopener noreferrer" target="_blank"&gt;http://goo.gl/mJqjG&lt;/A&gt;&lt;SPAN&gt;) tool and wanted to attempt something similar but with coordinates.&amp;nbsp; More specifically,&amp;nbsp; I'm trying to figure out a way to use the field calculator to get x and y values from the next row.&amp;nbsp; Technically, the code below works, but it's definitely not pretty... or fast!&amp;nbsp; Any thoughts or suggestions on how to do this better?&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;[ATTACH=CONFIG]16390[/ATTACH]&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;STRONG&gt;Expression:&lt;/STRONG&gt;&lt;BR /&gt;&lt;PRE class="lia-code-sample line-numbers language-none"&gt;
calculate_next_y(!OID!)
&lt;/PRE&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;STRONG&gt;Code Block:&lt;/STRONG&gt;&lt;BR /&gt;&lt;PRE class="lia-code-sample line-numbers language-none"&gt;
def calculate_next_y(my_field):

&amp;nbsp;&amp;nbsp;&amp;nbsp; oid_no = my_field

&amp;nbsp;&amp;nbsp;&amp;nbsp; rows = arcpy.SearchCursor(r"in_memory\points_mem", "", "", "", "OID; Time_Local")

&amp;nbsp;&amp;nbsp;&amp;nbsp; for row in rows:

&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; if row.getValue("OID") == oid_no:
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; try:
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; next_row = rows.next()
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; new_y = next_row.getValue("Latitude")
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; break
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; except:
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; new_y = row.getValue("Latitude")

&amp;nbsp;&amp;nbsp;&amp;nbsp; return new_y

&lt;/PRE&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks!&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Sat, 11 Dec 2021 15:12:00 GMT</pubDate>
    <dc:creator>NickJacob</dc:creator>
    <dc:date>2021-12-11T15:12:00Z</dc:date>
    <item>
      <title>How to get coordinates from next row?</title>
      <link>https://community.esri.com/t5/python-questions/how-to-get-coordinates-from-next-row/m-p/319850#M24859</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hello,&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I recently used the CalculateEndTime (&lt;/SPAN&gt;&lt;A href="http://goo.gl/mJqjG" rel="nofollow noopener noreferrer" target="_blank"&gt;http://goo.gl/mJqjG&lt;/A&gt;&lt;SPAN&gt;) tool and wanted to attempt something similar but with coordinates.&amp;nbsp; More specifically,&amp;nbsp; I'm trying to figure out a way to use the field calculator to get x and y values from the next row.&amp;nbsp; Technically, the code below works, but it's definitely not pretty... or fast!&amp;nbsp; Any thoughts or suggestions on how to do this better?&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;[ATTACH=CONFIG]16390[/ATTACH]&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;STRONG&gt;Expression:&lt;/STRONG&gt;&lt;BR /&gt;&lt;PRE class="lia-code-sample line-numbers language-none"&gt;
calculate_next_y(!OID!)
&lt;/PRE&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;STRONG&gt;Code Block:&lt;/STRONG&gt;&lt;BR /&gt;&lt;PRE class="lia-code-sample line-numbers language-none"&gt;
def calculate_next_y(my_field):

&amp;nbsp;&amp;nbsp;&amp;nbsp; oid_no = my_field

&amp;nbsp;&amp;nbsp;&amp;nbsp; rows = arcpy.SearchCursor(r"in_memory\points_mem", "", "", "", "OID; Time_Local")

&amp;nbsp;&amp;nbsp;&amp;nbsp; for row in rows:

&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; if row.getValue("OID") == oid_no:
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; try:
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; next_row = rows.next()
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; new_y = next_row.getValue("Latitude")
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; break
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; except:
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; new_y = row.getValue("Latitude")

&amp;nbsp;&amp;nbsp;&amp;nbsp; return new_y

&lt;/PRE&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks!&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Sat, 11 Dec 2021 15:12:00 GMT</pubDate>
      <guid>https://community.esri.com/t5/python-questions/how-to-get-coordinates-from-next-row/m-p/319850#M24859</guid>
      <dc:creator>NickJacob</dc:creator>
      <dc:date>2021-12-11T15:12:00Z</dc:date>
    </item>
  </channel>
</rss>

