Skip to main content
Solved

Get closest value from one set of data on another set

  • March 7, 2025
  • 1 reply
  • 31 views
4ntoine
Contributor
Forum|alt.badge.img+3

Hello

Here’s my challenge:
I have two datasets that I need to compare after several transformations.

- Dataset 1: This contains georeferenced points with distances associated with a linear reference system (LRS).
- Dataset 2: This has no geometry, but contains distances from the same LRS.

My aim is to associate each value km_start in dataset 2 with the closest value _measures in dataset 1, even if they don't match exactly (I’d like to be able to assigne a tolerance, for ex. max difference of 0.01m). Thanks to this matching, I will be able to assign a geometry to the data in the second set.

 

Below are a few screenshots to illustrate my question:

 

Dataset1 with georeferenced points, _measures are distances in the LRS
Dataset2 with non geometry features I want to get the closest match from Dataset1

 

We're talking about fairly important datasets but it shouldn't be too much of a problem if the process takes time.

Thank you in advance for your help and ideas.

Best answer by 4ntoine

Hello 

 

I found a much simpler and more direct way of achieving the desired result thanks to a video by Dave Campanas. For those interested, here's the link: 

 

Have a great day

View original
    Did this help you find an answer to your question?
    This post is closed to further activity.
    It may be a question with a best answer, an implemented idea, or just a post needing no comment.
    If you have a follow-up or related question, please post a new question or idea.
    If there is a genuine update to be made, please contact us and request that the post is reopened.

    1 reply

    4ntoine
    Contributor
    Forum|alt.badge.img+3
    • 4ntoineContributor
    • Author
    • Contributor
    • Best Answer
    • March 7, 2025

    Hello 

     

    I found a much simpler and more direct way of achieving the desired result thanks to a video by Dave Campanas. For those interested, here's the link: 

     

    Have a great day

    Helpful Members This Week

    Community Stats

    31,009
    Posts
    117,523
    Replies
    38,788
    Members

    Latest FME

    Terms & ConditionsCookie settings

    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
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.