calculate distance between 2 GPS point from 2 deferent Tables with the same name

KhalidElYamani — Sun, 27 Aug 2023 21:34:41 GMT

hi all,

i have Table A and Table B with GPS Dataset, i tried to calculate die Distance between the Point between Table A and Table B wich have the Same ID. im not fimilar with Arcpy, maybe can some one help me to write a code .

with near function my searchcursur i can not change edit the table.

Table A

ID | GPSLAT | GPS LONG

1 | X1_1 | Y1_1 |

2 | X1_2 | Y1_2 |

3 | X1_3 | Y1_3 |

Table B

ID | GPSLAT | GPS LONG

1 | X2_1 | Y2_1 |

2 | X2_2 | Y2_2 |

3 | X2_3 | Y2_3 |

Re: calculate distance between 2 GPS point from 2 deferent Tables with the same name

DougBrowning — Fri, 20 Oct 2023 18:25:32 GMT

I just have arcade code but it gives you the math.

Current point distance from design (meters)

# convert from Web Mercator to WGS84 - if you need it
var originShift = 2.0 * PI * 6378137.0 / 2.0;
var lon = (Geometry($feature).x / originShift) * 180.0;
var lat = (Geometry($feature).y / originShift) * 180.0;

lat = 180.0 / PI * (2.0 * Atan( Exp( lat * PI / 180.0)) - PI / 2.0);

return Round(Acos(Sin(lat * PI / 180)*Sin($feature.DesignLat * PI / 180) + Cos(lat * PI / 180)*Cos($feature.DesignLat * PI / 180)*Cos(($feature.DesignLong * PI / 180)-(lon * PI / 180))) * 6371000,2)

Other idea is make then XYEvent layers then just let Arc do the math.

topic calculate distance between 2 GPS point from 2 deferent Tables with the same name in Python Questions

calculate distance between 2 GPS point from 2 deferent Tables with the same name

Re: calculate distance between 2 GPS point from 2 deferent Tables with the same name