Skip to main content
Question

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


reservoirdog
Supporter
Forum|alt.badge.img+10

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

muzhnasto
Contributor
Forum|alt.badge.img+12
  • Contributor
  • September 8, 2021

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


JennaKAtSafe
Safer
Forum|alt.badge.img+6

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


reservoirdog
Supporter
Forum|alt.badge.img+10
  • Author
  • Supporter
  • September 28, 2021

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


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