Challenge #91: Getting into the Weeds

[ChristineB]

A big thanks and thumbs up to our Challengers who contributed a submission for our two-part challenge on analyzing social data.  It was wonderful to see how different Challengers approached the data analysis itself and your creativity in displaying your insights!  

Some of you may know that my pre-Alteryx days included mapping and analyzing the spread of invasive aquatic species in the state of Texas.  Giant salvinia, hydrilla...this just sounds like the stuff of nightmares.  And, for many aquatic resource specialists, it is!  So, when I found a file from the Colorado Department of Transportation's website on noxious weeds in the state, well, you can imagine my excitement 🙂   

For this week's Challenge, we'll build an app that would help a potential resource manager understand the coverage of noxious weeds along road segments in Colorado.  Design an app to produce two different outputs based on a users selection to "search by road segment" or "search by weed".  Depending on the selection, the app should produce a chart of the different weeds and their coverage levels (if selecting to search by road segment) or a table of the road segments and coverage of a weed (if choosing to search by weed).    

Happy Challenging!  Feel free to up the ante from my suggested outputs to maps, additional output information, or more aesthetically pleasing reports! 

[Natasha]

I spend way too much time then I expected on reporting tools. Also, I've noticed that the file with 2012 Coverage contains dates from 2011. I left them as is, so my results are a little bit different from the output file.

Spoiler

I used the detour tool to switch between search by route or by weed number, added a few interface tools and then spent a lot of time guessing how the data should look like for a bar chart. It also called column chart, not a bar chart..

[Kenda]

Spoiler

This was a good challenge and enabled me to learn about the plot data by field option!

[patrick_digan]

Here's my go at it

Spoiler

Table
GraphWorkflow

[NicoleJohnson]

My solution! 

Spoiler

Cheers,

NJ

[LordNeilLord]

I left this for ages because it looked like it would require some brain power to complete but it was actually fairly straightforward. I enjoyed the challenge of trying to run different workflows dependant on the user input.

Spoiler

[estherb47]

Added a little map of the coverage for the weeds table. We had the spatial data, so decided to use it. Fun challenge with the interface tools, and great practice loading in lists (in cleaned up format) from existing data!

Spoiler

Coverage for Ox Eye Daisy:

Route 036B:

My app:

[PhilipMannering]

I really did get into the weeds on this one. Solution attached.

Spoiler

What a mess...

[SeanAdams]

It was fun seeing how different folk tackled the challenge of populating the drop-down boxes.

@ChristineB - if you still have a passion for noxious weeds - there's some here in Bangalore that you could take a look at in a local lake near us - the lake recently caught fire because the weeds were trapping nasty pollutants in the water and it all reached flame-point

Spoiler

[ggruccio]

Forgot to rename file with gg_finish.  Learned a lot about reporting tools in this exercise.