Challenge #84: Map Hurricane Harvey's Storm Evolution
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
lminors
9 - Comet
09-11-2017
09:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Solution attached. Took a while to get it perfect.
Spoiler![84 workflow.PNG 84 workflow.PNG](https://community.alteryx.com/t5/image/serverpage/image-id/21548iEE69DED1B37BF66C/image-size/large?v=v2&px=999)
![84 map.PNG 84 map.PNG](https://community.alteryx.com/t5/image/serverpage/image-id/21547i5E45ABD9B5AD2D7C/image-size/large?v=v2&px=999)
Seemed counter-intuitive to duplicate the rows where the segment changes but that way it allows you to have start and end points at the same location.
Seemed counter-intuitive to duplicate the rows where the segment changes but that way it allows you to have start and end points at the same location.
Thanks!
Luke - Keyrus UK
15 - Aurora
09-11-2017
08:10 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My stab at this.
Spoiler
To "connect the lines" and ensure that the average intensity is calculated for each segment including the end points that connect, I decided to generate a new row for each individual segment. It would take on one higher sequence number than the original highest sequence number per segment, and then copy in the first intensity and spatial object from the first sequence of the next segment.
![image.png image.png](https://community.alteryx.com/t5/image/serverpage/image-id/21580iA94E5735ED259DCB/image-size/large?v=v2&px=999)
ACE Emeritus
09-12-2017
10:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My solution for Harvey.
Spoiler
Thought I had it done in simple 3-4 tool workflow until I realized there were gaps between the segments... so I created new points for each segment that corresponded to the start point of the next segment.
![WeeklyChallenge84.JPG WeeklyChallenge84.JPG](https://community.alteryx.com/t5/image/serverpage/image-id/21610i27AD34A6B6771869/image-size/large?v=v2&px=999)
vishalgupta
7 - Meteor
09-13-2017
12:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
17 - Castor
09-14-2017
07:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Spoiler
Most of the tools are there to get the line segments fixed to match the solution which corrects for gaps.
![Capture2.PNG Capture2.PNG](https://community.alteryx.com/t5/image/serverpage/image-id/21688i962B416283D897B0/image-size/large?v=v2&px=999)
![Capture.PNG Capture.PNG](https://community.alteryx.com/t5/image/serverpage/image-id/21687i2D56A5CD4D3637AC/image-size/large?v=v2&px=999)
Natasha
9 - Comet
10-04-2017
12:27 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This was an interesting challenge, had to iterate on this one.
Spoiler
At first, it looked straightforward to me, but my lines had gaps between them. This happened because I treated each segments as completely separate line. Segment 4 had no line at all, as it consisted of one point only.
![Screen Shot 2017-10-03 at 23.46.15.png Screen Shot 2017-10-03 at 23.46.15.png](https://community.alteryx.com/t5/image/serverpage/image-id/22545i868DD1F59A07FB5C/image-size/large?v=v2&px=999)
This made me think that I need to connect each segment with the previous one. The end point of one segment should be exactly the same as the beginning of the next segment. I duplicated first rows for all the segments (except the first one), adjusted segment and sequence number and then run all the rows through my original workflow.
![Screen Shot 2017-10-04 at 00.03.18.png Screen Shot 2017-10-04 at 00.03.18.png](https://community.alteryx.com/t5/image/serverpage/image-id/22547i4488B04B49675232/image-size/large?v=v2&px=999)
This made me think that I need to connect each segment with the previous one. The end point of one segment should be exactly the same as the beginning of the next segment. I duplicated first rows for all the segments (except the first one), adjusted segment and sequence number and then run all the rows through my original workflow.
LordNeilLord
15 - Aurora
10-05-2017
11:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Most of it was pretty straight forward except for getting the continuous line, I had the logic in my head but trying to implement it caused a few re-works of the workflow
17 - Castor
10-09-2017
09:49 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
like @nick_ceneviva, @David-Carnes & @lminors (and most of the other folk) I took a few more steps to make sure the lines all touched by backing a copy of the last point of segment 2 back into segment 1
@ChristineB 's solution does the same, but WAY more elegantly than me :-)
dsmdavid
11 - Bolide
11-25-2017
06:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
LandonG
8 - Asteroid
12-14-2017
01:05 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator