Skip to main content

Hi

 

I have two datsetes containing gps time and I need to join but non based on distance but based on time

In short I need to find the point A with the time more close to the time in table B

 

can you help please ?

imagethx

 

Francesco

 

One way is to create new points from both data sets with a VertexCreator, with gps_seconds as X value, and 0 as Y value. Then you can use a NeighborFinder to find the closest 'point in time' from B to each record of A.

You can store the original geometries beforehand using a GeometryExtractor, and restore them using a GeometryReplacer.

Points_in_Time


One posibility:

Genarate points from your GPS-points with x=gps_seconds(s) and y=0. Now you have a timeline.

Generate points from the other table with x=gps_seconds(s) and y=0.

Use NeighborFinder to find the nearest time.


One posibility:

Genarate points from your GPS-points with x=gps_seconds(s) and y=0. Now you have a timeline.

Generate points from the other table with x=gps_seconds(s) and y=0.

Use NeighborFinder to find the nearest time.

Great minds think alike 😄


@geomancer​ Great! You have a picture to my idea :-)


Reply