Question

Find nearest value in a table and join attributes of that row

  • 23 June 2021
  • 3 replies
  • 15 views

Badge +7

I have several lines (streets) with a condition-value.

In an (excel) table, I have many rows with condition-values and other attributes I would like to join. Now, coming from my streets I need to find the "nearest" value in the excel-table and join its attributes.

What would be the simplest way to do that?

I have seen an approach of calculating "distances" to each value and then sort by lowest distance... Any other convenient way?

 

thx for your ideas, best regards from switzerland.


3 replies

Badge +11

Hi, maybe if you provide sample data then increase the chance of an answer to your question.

Badge +6

Hi @reservoirdog​, you might find this article on finding nearest features helpful! https://community.safe.com/s/article/find-nearest-features

Badge +7

Thanks @jennaatsafe​ , but I need an approach for searching values (nearest value) than the spatial approach.

The source of the problem is finding the correct value of a normal distribution.

I never found a solution to work directly with mathematical functions, so we divided the normal distribution

in increments. Each increment represents a row in an excel table and I want to find the "nearest value/row" coming from my feature.

 

normal distribution:

normaldistributionincrements in a table:

increments

Reply