Challenge #113: Interpolating Spatial Grid Values

[MMehdi]

Challenge #113 resolved

Spoiler

Workflow

[estherb47]

Fun! Also created a spatial and non-spatial approach. I didn't know you could customize the Find Nearest tool to whatever number you need.

Spoiler

Pretty similar to other solutions. Instead of using a formula tool. dynamically renamed the column headers to start with 0. Also decided to parse out the column and row headers from the Maui grid using a RegEx parse tool, parsing method.

For the non-spatial, 2 generate row tools generated the rows and columns needed for the averages. When you match back to the non-average values, rows and columns outside the grid fall away.

[SeanAdams]

Tackled this in a cheap-and-cheerful kinda way.    going to look at other folks' solutions next

Spoiler

- Transposed the data so that each sell was represented as X,Y,Value
- Then used row generators to add 9 rows for each row, which would point to the surrounding cells
- Joined to the original data set from step 1 to bring in the value (which then also filtered out values that don't exist because it's an edge piece etc)
- Summarised the average of all surrounding cells.
  
Now I have a table of:
X; Y; Value; Average of surrounding

Then it's a simple matter of replacing the value with the average if the value is zero; and then crosstabbing back in to the right format.

[Rachel_B]

Good challenge for using new spatial tools! I did not do a non-spatial approach but love the creativity and variety of others' solutions.

[cplewis90]

This was a fun exercise! Don't get to use the spatial tools that often. It would have also helped if I would have read the instructions and realized the distance measure was meters and not miles like my brain interpreted from "m."

Spoiler

Definitely going to apply some of these concepts to my work. 

[jasperlch]

Solution attached.

[LordNeilLord]

My solution, I had no idea what the goal of this was so  had to look at the solution to figure out what was required

Spoiler

[JoBen]

This was a lot of fun. Thanks!

[JosephSerpis]

Challenge Completed

[PhilipMannering]

I love that you can use find nearest to get the 8 nearest grid values, but also set a distance limit to get 5 grid values for the pieces around the edge.

Spoiler