I am trying to connect a car-data-feature (point, speed, ...) to data of changing digital traffic signs on a motorway (e. g. changing speed limits). The motorway data is in 1-minute intervalls (instant-time field) and the car-data in "random" instant time stamps. I want to connect the "matching times" via "Near after 59 seconds" and a matching cross section field in both data sets.
Now it occured to me that when the car-dataset is larger the results are not correct anymore, even when the "extra data" is not even used in the join-operation. This should be explained with the following pictures (they are also attached if it is impossible to read because of poor quality):
expected correct resultunwanted wrong result
If I am not missing something, I just did exactly the same in both cases, just with different datasets.
I am on Windows 10 and use ArcGIS Pro 3.0.1. Any ideas are greatly appreciated.
Edit: And I might just add that of course this is just a small snippet of all the data which I need to work with. The complete car-dataset has around 3,700,000 rows and the traffic-cross-section dataset has around 650,000 rows. If I join them together, around 700,000 rows are missing afterwards. But none should be missing, the result should have 3,700,000 rows and to every one of those one of the 650,000 rows should be matched.