Challenge #84: Map Hurricane Harvey's Storm Evolution

[Xiaoqi]

Spoiler

[SueDonim]

The duplicate bit was a bit of a challenge, but I kluged my way through it.

Spoiler

Process:
- Create DateTime field to ensure proper sorting
- Sort by date time
- Create Segment Number based on StormType
Lower Thread....
- Identify new segments otherwise Segment Number to Null()
- Renumber new segments to prior Segment Number (i.e. subtract 1)
- Filter null records
- Skip first record
- Remove un-needed fields
Join threads....
- Union the two threads
- Group by Segment Number and Stormtype and calculate average intensity (and carry through points)
- Remove duplicated record (happens as moved through three groups consecutively - a bit of a cheat, I know....)
- Rename fields and clean-up

[EW]

Getting the path split into separate lines like the output was tricky!  The averages were a little squirrely too, but this matches the output.  

Spoiler

I used a bunch of multi row tools, interested to see cleaner methods!

[Dominik2806]

Quite tricky if you want to bridge the gaps in the lines...

[Jonathan-Sherman]

Took me a long time to work out how to get this one to match the output perfectly!

Spoiler

[delilah]

Spoiler

Add some steps to get rid of the gaps between segment lines. Still there is slight difference in average intensity and have no no idea why.  

[ShawnTM]

Here is my solution. Some of my averages differ from whats in the example output.

Spoiler

[ChuyVBabs]

How about average intensity as a function of total time duration along a storm type segment?

Didn't notice if anybody else

Spoiler

built the initial line segments using the spatial functions inside the Multi-Row formula tool, then defined/assigned each line to a parent segment which served as summarize calculation bounds for Intensity.  

[danicahui]

Spoiler