table with 2 sets X, Y

GeorgeKatsambas

I have a table that has an origin X, Y (XP YP) and a destination X, Y (XD, YD) and an in-house 3rd party program that creates a OD vector line, however, this 3rd party tool reads lat/lons only. is there a formular to convert X to longitude etc. This is a table so calculate geometry is not available. 

RandyBurton

If you know the spatial reference of your x,y coordinates, you could use something like the following:

inSR <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SpatialReference<SPAN class="punctuation token">(</SPAN><SPAN class="number token">3857</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># web mercator (use your spatial reference here)</SPAN>
outSR <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SpatialReference<SPAN class="punctuation token">(</SPAN><SPAN class="number token">4326</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># wgs_1984 (lon-lat)</SPAN>

ptGeo <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>PointGeometry<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>Point<SPAN class="punctuation token">(</SPAN>x<SPAN class="punctuation token">,</SPAN>y<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>inSR<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>projectAs<SPAN class="punctuation token">(</SPAN>outSR<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN>ptGeo<SPAN class="punctuation token">.</SPAN>centroid<SPAN class="punctuation token">.</SPAN>X<SPAN class="punctuation token">,</SPAN> ptGeo<SPAN class="punctuation token">.</SPAN>centroid<SPAN class="punctuation token">.</SPAN>Y<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># lon-lat of point‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

See Reprojecting tabular data without creating feature class? for more discussion.