ISSS608 2016-17 T3 Assign SANDHYA VASUDEVA RAO

From Visual Analytics and Applications
Revision as of 20:37, 17 July 2017 by Sandhyavr.2016 (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Waterfalls.gif Boonsong Lekagul Nature Preserve - Mini Challenge 1

Overview & Data Preparation

Q1

Q2

Q3 & Top 3


Background

Boonsong Lekagul Nature Preserve is currently seeing a decline in the nesting of Rose-crested Blue Pipit, which may be attributed to the traffic going through the preserve or perhaps related to the campers in the birds' habitat. A few patterns have been analyzed using the traffic data collected by the park rangers as a part of their annual report to the local government. The map of the Nature Preserve is as shown below.

Lekagul Roadways labeled v2.jpg

Visualizations done with Tableau were used to solve the questions that are a part of the challenge. A repeating pattern recognition to describe the daily patterns of life by vehicles traveling through and within the park with descriptions about the vehicles and their spatial activities was one such question. Patterns of life over a long period of time were also analysed, which included the temporal activities of vehicles passing through and within the park over multiple days. In addition to this, unusual patterns were also studied and analysed in detail. Finally, a decision on the top 3 patterns that were primarily suspect to causing such an impact to bird life were listed down.

Data Prep

Tools Used

  • JMP for Data cleaning, and transformation.
  • Tableau for visualization
  • Microsoft Excel for Data cleaning, and transformation.

Data prep to plot the coordinates on the Map

Create 2 columns on the dataset provided - X and Y. It is given that the grid size is 200*200. Therefore, X and Y will have a combination of 1 to 200 as values. The next step is to identify X and Y coordinates for gates on the map. The below picture shows the coordinates for each gate-name.

DataPrep.png

Load the file with these coordinates mapped in the data file into Tableau. Choose X and Y coordinates as Rows and Columns respectively.

BeforeBackground.png

Insert background image as the map of the Nature Preserve as shown above by setting the parameters as 0 to 200.

AfterBackground.png

Data prep to Categorize visitors as Single Day and Multiple Days

The entire data was divided into visitors that visited the Nature Preserve just for a day and those that visited over multiple days. Based on the Timestamp, all the visitors whose start date and end date were the same were categorized as Single day visitors. The rest as Multiple day visitors.

Timestamp is sorted and the following formula is applied to see if the start and end date of a Car Id is the same. If yes, then those IDs are Single Day Visitors and the rest of the IDs are Multiple Day Visitors.

DataPrep1.png

Once the Car Ids are identified with 1 - Single day, Else - Multiple day, all the records of the respective IDs are separated for further analysis. Some of the Single Day Car IDs are as follows. There are about 98976 Single day visits.

SampleSingle.png

Some of the Multiple Day Car IDs are as follows. There are about 72503 Multiple day visits.

SampleMultiple.png