Skip to main content
Solved

Assistance needed with comparing location across two Datasets :


tauseef144
Contributor
Forum|alt.badge.img+2

Dear All,
I’m  working with two datasets that share a common key: Station ID. Each dataset provides coordinates ( latitude and longitude) for these stations. My objective is to determine whether the station with the same ID have identical location in both datasets or if there are discrepancies.

To achieve this, I need to calculate distance between the corresponding coordinates from both datasets. While this seems straightforward, but I encountering challenges in implementing it effectively. I would appreciate any help on the best approach.

Thank you in advance.

BR//  

Best answer by geomancer

Use a NeighborFinder, group by Station ID.

 

View original
Did this help you find an answer to your question?

3 replies

crutledge
Enthusiast
Forum|alt.badge.img+27
  • Enthusiast
  • March 19, 2025

Hi ​@tauseef144 

I wonder if you could use a FeatureJoiner and Join on SationID then in the AttributeManager to add two attributes LonCalc and LatCalc, do a quick calculation using the two Lon and two Lat? So Lon1-Lon2 and Lat1-Lat2 to see if there’s a difference. Would that work?


geomancer
Evangelist
Forum|alt.badge.img+46
  • Evangelist
  • Best Answer
  • March 19, 2025

Use a NeighborFinder, group by Station ID.

 


tauseef144
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • March 19, 2025

Thank you ​@crutledge & ​@geomancer. I found using NeighborFinder is easy, it work just fine. only thing I noticed that if Station IDs are duplicate then it doesn’t show value for these duplicates.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings