Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAsolutions attached. My first method wasn't breaking up the line into segments, but making one big line. In addition, I couldn't segment by line because one of the storm segments consisted of only one point. So for my second solution, I resorted to a batch macro.
My solution below - ended up going down the batch macro route same as the solution in order to get a continuous line of segments and to get the same average intensity values:
Tricky to spot how the additional points were calculated. I liked my approach here. I used the browse tool on each spatial object and then dived into the Cell Viewer. This allowed me to see if there was a larger number of spatial points in each object:
I decided not to go in the direction of macros, and instead worked on formulas and joins. I opted against tiling because I was running into bugs with day 5 and day 10 or 11. Turns out that I had set Tile_SequenceNum in one branch to V_WString instead of Int64. The sequence tool will follow ABC order instead of numerical order if you do that.