Difference between revisions of "ISSS608 2016-17 T3 Assign ZHENG BIJUN"

From Visual Analytics and Applications
Jump to navigation Jump to search
(edit by kishan added feedback)
 
(106 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
<!--- Challenge Introduction --->
 
<!--- Challenge Introduction --->
=== VAST Challenge 2017: Mini-Challenge 1 ===
+
= VAST Challenge 2017: Mini-Challenge 1 =
 +
<div width=100%>
 +
<div width=30%>
 
[[File:ZBJ Pipits.jpg|400 px|right]]
 
[[File:ZBJ Pipits.jpg|400 px|right]]
Mistford is a mid-size city is located to the southwest of a large nature preserve. It has been discovered that the number of nesting pairs of the Rose-Crested Blue Pipit, a popular local bird due to its attractive plumage and pleasant songs, is decreasing! Provided several datasets, it is required to investigate the reason for the decrease of Rose-Crested Blue Pipit. In Mini-Challenge 1, traffic movement dataset is given to analyze patterns of life of vehicles through out the reserve, and detect unusual patterns that are potentially harmful to the birds. Questions raised are: <br>
+
</div>
 +
<div width=70%>
 +
<p align="justify">
 +
Mistford is a mid-size city is located to the southwest of a large nature preserve. It has been discovered that the number of nesting pairs of the Rose-Crested Blue Pipit, a popular local bird due to its attractive plumage and pleasant songs, is decreasing! Provided several datasets, it is required to investigate the reason for the decrease of Rose-Crested Blue Pipit. In Mini-Challenge 1, traffic movement dataset is given to analyze patterns of life of vehicles through out the reserve, and detect unusual patterns that are potentially harmful to the birds. Questions raised are: </p>
 
<ul>
 
<ul>
 
<li>Describe up to six daily patterns of life by vehicles traveling through and within the park.</li>
 
<li>Describe up to six daily patterns of life by vehicles traveling through and within the park.</li>
Line 15: Line 20:
  
 
<!--- Data Introduction --->
 
<!--- Data Introduction --->
=== Data Description ===
+
= Data Description =
Entry gates are positioned at the Preserve entrances. Each vehicle receives an entry ticket at the gate and is assigned a vehicle class; the entry is recorded. The entry ticket contains an RF-tag that enables the Preserve sensors to pick up the passage of a vehicle through the Preserve. Each vehicle surrenders their entry ticket when exiting the Preserve and the exit is recorded. A .csv file containing data recorded from sensors around the Boonsong Lekagul Nature Preserve. A map containing the locations of roadways and sensors throughout the Preserve is also provided.
+
<p align="justify">Entry gates are positioned at the Preserve entrances. Each vehicle receives an entry ticket at the gate and is assigned a vehicle class; the entry is recorded. The entry ticket contains an RF-tag that enables the Preserve sensors to pick up the passage of a vehicle through the Preserve. Each vehicle surrenders their entry ticket when exiting the Preserve and the exit is recorded. A .csv file containing data recorded from sensors around the Boonsong Lekagul Nature Preserve. A map containing the locations of roadways and sensors throughout the Preserve is also provided.</p>
 +
</div>
 +
</div>
 
===== Dataset Overview =====
 
===== Dataset Overview =====
 
<table width=90%>
 
<table width=90%>
Line 59: Line 66:
  
 
<!--- Data Preparation --->
 
<!--- Data Preparation --->
=== Data Preparation ===
+
= Data Preparation =
 +
<b>1 Define episodes</b><br>
 +
<p align="justify">Intuitively, each car-id (except for park service vehicles 2p) should possess two entrance records with one serves as entering and the other for exiting. However, it is noticed that many car-ids had more than two entrances recorded. It is rational to assume that these cars did made multiple visits to the preserve. Therefore, I split the trip with multiple entering and exiting of the same car-id into different episodes. Each episode can be seen as a complete trip and analysis is performed based on episodes. </p>
 +
<br>
 +
<table>
 +
<tr>
 +
<td valign="top"><b>2 Exclude incomplete trips</b><br>
 +
<p align="justify">By looking at the maximum timestamp of the entire dataset, it is safe to conclude that the data provided is generated before June 2016. Therefore, there are vehicles with incomplete trips (the maximum timestamps of these car-ids are around end of May) in the dataset, and I exclude car-ids with only one entrance record. The figure on the right shows the car-ids with only one entrance record and their maximum timestamp.</p></td>
 +
<td>[[File:ZBJ 1entrance-list.PNG|left|150 px]]</td>
  
 +
<td valign="top"><b>3 Remove duplicate records</b>
 +
<p align="justify">It is noticed that some sensor records are duplicated in the dataset, and these duplicates all have three entrance records for a car-id - the first two have the same timestamp (or very close timestamp), and the third one has a different timestamp and is coherent with the following activities. Hence, I remove the first two records assuming there were something wrong the data entry and keeping the third one makes more sense when interpreting the trip. The figure on the right shows an example of this kind of data anomaly.</p></td>
 +
<td valign="top">[[File:ZBJ 3entrance-1.PNG|right|400 px]]</td>
 +
</tr>
 +
</table>
 +
<table>
 +
<tr>
 +
<td width=50% valign="top">
 +
<b>4 Label the sequence of gates of each episode</b><br>
 +
<p align="justify">In order to plot the entire routes of the vehicles, I create a new column named 'Sequence' to <br>mark the order of the gates they passed through.</p>
 +
</td>
 +
<td valign="top">
 +
<b>5 Concatenate the routes</b><br>
 +
<p>To concatenate the gate-names of each episode to form a route. </p>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>[[File:ZBJ Seq.JPG|left|500 px]]</td>
 +
<td>[[File:ZBJ Rule.JPG|left|600 px]]</td>
 +
</tr>
 +
<tr>
 +
<td valign="top"><b>6 Extract the gate-to-gate directions</b><br></td>
 +
<td valign="top"><b>7 Calculate the gate-to-gate duration</b><br></td>
 +
</tr>
 +
<tr>
 +
<td>[[File:ZBJ Gatetogate.JPG|left|550 px]]</td>
 +
<td>[[File:ZBJ Duration.JPG|left|600 px]]</td>
 +
</tr>
 +
<tr>
 +
<td valign="top"><b>8 Extract the arrival timestamp of each episode</b><br></td>
 +
<td valign="top"><b>9 Segment the visitor types</b><br>
 +
<ul>
 +
<li>Camper: normal visitors who went to camping areas</li>
 +
<li>Non-camper: normal visitors who never went to camping areas</li>
 +
<li>Rangers: vehicles with car-type as 2p</li>
 +
</ul>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>[[File:ZBJ Arrtime.JPG|left|550 px]]</td>
 +
<td>[[File:ZBJ Visitortype.JPG|left|450 px]]</td>
 +
</tr>
 +
</table>
 +
<table>
 +
<tr>
 +
<td valign="top"><b>10 Map coordinates of gates</b><br>
 +
<ul>
 +
<li>Use JMP Pro 13 Custom Map Creator add-in to point the gates on the map and generate the coordinates.</li>
 +
<li>The scale of the map is set to 12*12 as the area indicated in data description. </li>
 +
</ul></td>
 +
</tr>
 +
<tr>
 +
<td>[[File:ZBJ Mapcoord.jpg|left|700 px]]</td>
 +
</tr>
 +
</table>
 
<br>
 
<br>
 +
 +
<!------------------------->
 +
 +
<!--- Dashboard Design --->
 +
 +
= Interactive Visualization =
 +
You may have your own investigation here: [https://public.tableau.com/profile/zheng.bijun#!/vizhome/VAST2017MC1/StoryPatternsofLifeAnalysis Link to interactive visualization]
 +
* Please be noticed that the link is not working well due to some unknown tableau server issue; please download the workbook via tableau public landing page.
 +
<table>
 +
<tr>
 +
<td>[[File:ZBJ Cover.JPG|600 px|left]]</td>
 +
<td>[[File:ZBJ Trend.JPG|600 px|left]]</td>
 +
</tr>
 +
<tr>
 +
<td>[[File:ZBJ Pattern.JPG|600 px|left]]</td>
 +
<td>[[File:ZBJ Vehicle.JPG|600 px|left]]</td>
 +
</tr>
 +
</table>
 
<br>
 
<br>
<!------------------------->
+
<!------------------------>
  
 
<!--- Patterns of Life Analysis --->
 
<!--- Patterns of Life Analysis --->
=== Patterns of Life Analysis ===
+
 
 +
= Patterns of Life Analysis =
 
===== Daily Patterns =====
 
===== Daily Patterns =====
<table width=90%>
+
<table width=100%>
 +
<tr bgcolor="#86af49">
 +
<th><font color="#ffffff">Images</font></th>
 +
<th><font color="#ffffff">Interpretations</font></th>
 +
</tr>
 
<tr>
 
<tr>
<td>[[File:ZBJ 2pnoshow.jpg|600 px|left]]</td>
+
<td>[[File:ZBJ 2pnoshow.jpg|600 px|left]]<br>
<td>Park service vehicles never showed up between 4am to 5am in any kind of gates. This might be the off-duty period of the rangers.</td>
+
[[File:ZBJ ArrivalLine-ranger.jpg|600 px|left]]</td>
 +
<td>
 +
<ul>
 +
<li>Park service vehicles never showed up between 4am to 5am in any kind of gates. This might be the off-duty period of the rangers, and the off-duty period varied across different days of week. For example, rangers were never on patrol from 1am to 5am on Saturday.</li>
 +
<li>If we look at the arrival time (in this case is the time when rangers started each patrol trip), the first shift always started at 6am and the last shift started at 17pm.</li>
 +
</ul></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
Line 83: Line 181:
 
<tr>
 
<tr>
 
<td>[[File:ZBJ Activetime.jpg|600 px|left]]</td>
 
<td>[[File:ZBJ Activetime.jpg|600 px|left]]</td>
<td>2 axle car/motorcycle, 2 axle truck, and 3 axle truck were most active vehicles in the preserve. Their activities started to increase at 5am and started to flatten out at around 18pm. 7am to 17pm had most vehicle activities. </td>
+
<td>2 axle car/motorcycle, 2 axle truck, and 3 axle truck were most active vehicles in the preserve. Their activities started to increase at 6am and started to flatten out at around 18pm. 7am to 17pm had most vehicle activities. </td>
 +
</tr>
 +
<tr>
 +
<td>[[File:ZBJ Trespassing.jpg|600 px|left]]</td>
 +
<td>There were vehicles that simply passed the preserved without making any stops and looking around. These vehicles can be identified by investigating the number of gates they passed through. This pattern only applies to non-campers and happened within a short time period. The graph on the left shows all the possible routes for trespassing.<br>
 +
<ul>
 +
<li>Entrance0<->entrance3</li>
 +
<li>Entrance2<->entrance4</li>
 +
<li>Entrance1<->general-gate7<->entrance3</li>
 +
<li>Entrance0<->general-gate7<-> general-gate4<-> entrance1</li>
 +
</ul></td>
 
</tr>
 
</tr>
 
</table>
 
</table>
  
 
===== Longer-Period Patterns =====
 
===== Longer-Period Patterns =====
<table width=90%>
+
<table width=100%>
 +
<tr bgcolor="#86af49">
 +
<th><font color="#ffffff">Images</font></th>
 +
<th><font color="#ffffff">Interpretations</font></th>
 +
</tr>
 +
<tr>
 +
<td>[[File:ZBJ Line-month.jpg|600 px|left]]</td>
 +
<td>Traffic increased since May and reached highest in July, then started to decrease. November to March were the least popular months for visitors and it is possible that these are winter months.</td>
 +
</tr>
 +
<tr>
 +
<td>[[File:ZBJ Line-weekend.jpg|600 px|left]]</td>
 +
<td>Activities of 2 axle car/motorcycle, 2 axle truck and 3 axle truck increased on Friday and decreased on Monday. This can be explained by the overnight camping during weekends.</td>
 +
</tr>
 +
<tr>
 +
<td>[[File:ZBJ Ranger.jpg|600 px|left]]<br>
 +
[[File:ZBJ RangerCampDuration.jpg|600 px|left]]</td>
 +
<td>The duration rangers spent at ranger-stops and camping areas were less than 1 hour. </td>
 +
</tr>
 +
<tr>
 +
<td>[[File:ZBJ MapRoute-rangermost.jpg|600 px|left]]</td>
 +
<td>The graph shows the route that had most rangers' episodes. It was the most frequent patrol route of the rangers, and it was almost twice as frequent as the second most frequent patrol route. It is possible that the east side of the preserve required more care and protection. <br>
 +
<ul>
 +
<li>ranger-base>gate8>general-gate5>gate3>ranger-stop3>ranger-stop3>gate3>camping8>general-gate3>gate4>ranger-stop5>ranger-stop5>gate4>gate5>ranger-stop6>ranger-stop6>gate5>gate8>ranger-base</li>
 +
</ul> </td>
 +
</tr>
 
<tr>
 
<tr>
<td>[[File:ZBJ Gatetuethu.jpg|600 px|left]]</td>
+
<td>[[File:ZBJ ArrTime-campers.jpg|600 px|left]]</td>
<td>Unauthorized 4+ axle truck appeared in gates only on Tuesday and Thursday, though not every week.</td>
+
<td>Campers arrived at the preserve between 5am and 17pm. Friday to Sunday were more popular as expected. </td>
 +
</tr>
 +
</table>
 +
 
 +
===== Unusual Patterns =====
 +
<table width=100%>
 +
<tr bgcolor="#86af49">
 +
<th><font color="#ffffff">Images</font></th>
 +
<th><font color="#ffffff">Interpretations</font></th>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>[[File:ZBJ Route-322.jpg|600 px|left]]</td>
 
<td>[[File:ZBJ Route-322.jpg|600 px|left]]</td>
<td>Unauthorized 4+ axle truck appeared in gates only on Tuesday and Thursday, though not every week.</td>
+
<td>This table displayed the route of car-id 20154519024544-322 (a 2 axle truck), which passed through camping gates after 22pm. This vehicle had 16 episodes, and each episode had exact same route except for the first episode. This vehicle came to the preserve each Friday and left the on the following Monday.</td>
 +
</tr>
 +
<tr>
 +
<td>[[File:ZBJ Route-multiepisode.jpg|600 px|left]]</td>
 +
<td>Apart from 20154519024544-322, there were other car-ids that had multi-episodes, which means they did not render their car-id by the time they exited the preserve. And every time they came to the preserve, they followed the same routes and went for overnight camping. This group of visitors might hold a regular pass for their visits.</td>
 +
</tr>
 +
<tr>
 +
<td>[[File:ZBJ Line-gateanomaly.jpg|600 px|left]]<br>
 +
[[File:ZBJ Route-gateanomaly.jpg|600 px|left]]
 +
<td>
 +
<ul>
 +
<li>Unauthorized 4+ axle truck appeared in gates only on Tuesday and Thursday, though not every week.</li>
 +
<li>They arrived at the preserved between 2am to 4am. More interestingly, the time they passed through gates avoided the time when park service vehicles passed through those gates.</li>
 +
<li>The 4+ alxe trucks that passed through gates had different car-id but they all followed the exact same route: <br>
 +
entrance3>gate6>ranger-stop6>gate5>general-gate5>gate3>ranger-stop3>ranger-stop3>gate3>general-gate5>gate5>ranger-stop6>gate6>entrance3</li>
 +
<li>Recalling from previous section, this route was in the area where the most frequent ranger patrol route covered.</li>
 +
</ul></td>
 +
</tr>
 +
<tr>
 +
<td>[[File:ZBJ Map-skipgate.jpg|600 px|left]]</td>
 +
<td>
 +
<ul>
 +
<li>There were vehicles going between entrance1 and ranger-stop1 without records from gate2. However, entrance1<->gate2<->ranger-stop1 is the only path between the entrance1 and ranger-stop1.</li>
 +
<li>There were 6 episodes, all were 2 axle car/motorcycle, followed the exact same path entrance1>ranger-stop1>ranger-stop1>entrance1. They happened on the same day and at the same time. </li>
 +
<li>They stayed for almost 4 hours in ranger-stop1, which was long and suspicious.</li>
 +
</ul>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>[[File:ZBJ Roundtrip.jpg|600 px|left]]</td>
 +
<td>Apart from the gate-skippers mentioned above, there were another 3 episodes made a simple round-trip in the preserve: they entered the preserve, passed through general-gate, then made the same route back to the entrance.</td>
 +
</tr>
 +
</table>
 +
===== Top 3 Possible Causes =====
 +
<ol>
 +
<li>Long term visitor with car-id 20154519024544-322 and his behavior to travel pass camping areas during midnight. </li>
 +
<li>Unauthorized 4+ axle trucks invading restricted areas because the route they traveled was part of the most frequent patrol route of the rangers. This area could be where pipits resided, and therefore needed more care and protection from rangers. And the fact that they went through the restricted area when the rangers were off-duty makes them extremely suspicious.</li>
 +
<li>Possible over speeding which requires further investigations, especially for trespassing routes.</li>
 +
</ol>
 +
<br>
 +
<!-------------------------------->
 +
 
 +
<!--- Discussion --->
 +
= Comments & Discussions =
 +
<!--- Please replace with your comments in the <td></td> tags :)--->
 +
<table border=1 style="width:90%;border-collapse: collapse; font-family: Calibri;">
 +
<tr>
 +
<td>comment1: Hi,Bijun. Amazing work! From you analysis pack, I can see the level of efforts that you have devoted into this assignment. Yet, I have the following suggestions that hopefully are useful in further improving your work:
 +
<ul>
 +
<b>Aesthetic</b><br>
 +
<li>1. I love the way you present your analysis. However, a big part of the analysis findings are demonstrated by line graphs. I am wondering if you can try other types of graphs to make the findings more visually clear?</li>
 +
<li>2. For the first graph of daily pattern. You are trying to say that the rangers do not work from 4-5 am. Yet the graphs x axis only shows hour of 3,9,15,21. I think the pattern will be more obvious if you construct the graph in a way that X axis displays every hour of the day.</li>
 +
<li>3. the story structure in your tableau workbook is clear. Look forward to viewing it interactively on line soon.</li>
 +
</ul>
 +
<ul>
 +
<b>Clarity</b><br>
 +
<li>1. the tableau workbook contains lots of useful information, yet it is a bit complex and confusing. There are quite a few selectors and parameters defined and the graphs are controlled by different selectors, which is not straightforward. Audience probably need to spend quite some time in understanding the dashboard, particularly for those who do not know the background of vast challenge.</li>
 +
<li>2. the legends are not closely attached to their corresponding graphs, which also adds confusion to the dashboard.</li>
 +
</ul>
 +
<b>Overall, fantastic work! Hopefully my comments can add value</b>
 +
<br>
 +
Best Regards
 +
<br>
 +
Yunna
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>Hi Joyce, <br>
 +
Great overall effort and very engaging. Some of my feedback as below 😉<br> 
 +
<b>Aesthetics:</b><br>
 +
<ol>
 +
* Though it is very interactive with a lot of interactive filters and legends, I feel that it is abit overwhelming, confusing and took me a while to understand and link them together; which I believe also is causing some dashboard performance issue to load slowly. Selecting some of the values also caused the whole dashboard to blank out and getting lost in visualization, can consider to reduce the number of variables of filters for interactive visualization.
 +
* I guess storybook should be story-telling and easy to follow for anyone. Currently, it is designed for exploratory purposes. 
 +
* The colors of the titles, filter and legends are well-designed and implemented and all well-linked across the various graphs! Only thing is that descriptions fonts are a bit small for old folks.
 +
</ol>
 +
<b>Clarity:</b><br>
 +
<ol>
 +
* I don’t understand the “top x and bottom x” & “Timestamp Slector” (typo? Sector or Selector?) but I guess you are trying to compare the traffic at each gate with the arrival time, though I can’t tell anything obvious from the arrival time from pattern detection. In such case, it may be interesting to include and look at their departure time as well.
 +
* Currently it only shows the route on the map; I think you can also consider the intensity of the path traveled illustrating by thickness of line.
 +
* Coordinates of the checkpoints are offset from the actual 200x200 grid or actual distance/area and may cause confusion. Zooming feature in the map is good as it allows for better visibility similar to “How long did they spend”. Only point is to consider expanding the box to allow complete view of it; currently it requires scrolling.
 +
</ol>
 +
Cheers, <br>
 +
Zac
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>comment3
 +
<p>Hi Zheng Bijun,</p>
 +
<p>Please find my feedback comments as follows. You present a very nice analysis, which is answering the questions of the challenge. With regard to the clarity and aesthetics aspect, I have the following to add.</p>
 +
<p><strong>Clarity :</strong></p>
 +
<p><strong>&nbsp;</strong></p>
 +
<ul>
 +
*In the daily pattern plots, you have used the &lsquo;select&rsquo; feature effectively to illustrate clearly the trend you wish to explain. This is a good practice, as it help to retain the background information clearly, whilst projecting the focus for the user.</li>
 +
*When using map images, you might want to use the Cartesian coordinates more effectively. You can use Tableau to import the map as a background image, and then geocode it so that you will be able to use annotations. The current texts you have indicated does help the user identify the locations inside the preserve, such as entrance 0, entrance 3, etc. but having annotations will help them to pop out of the plane, thereby presenting better clarity.</li>
 +
*In your 2<sup>nd</sup> plot inside longer period patterns, I assume the x axis shows the days of the week (1-7). You might want to add an axis label, or you might want to use aliases for the days of the week and label the axis. (for e.g. 1-Sunday, 2-Monday, etc.).</li>
 +
*On most of the plots, you have a well defined title, so you might not want to show the headers on the Y axis (# of cars) since it can already be known that the chart shows the trends of traffic.</li>
 +
</ul>
 +
<p><strong>Aesthetics: </strong></p>
 +
<ul>
 +
*I notice that you have tweaked the background colour. Maybe, you would want to also explore format axis feature in Tableau that might change the text to more bolder and visible formats. This would lend more readability to the plots.</li>
 +
*On the arrival time calendar plot you have developed, when you try to visualize the number of episodes, the gradation in colors is good, and helps to quickly infer, which times of the day have higher episodes.</li>
 +
</ul>
 +
<p style="margin-left: .25in;">&nbsp;&nbsp;Hope the feedback helps, and please leave out a feedback on my page as well. You may access it [[ISSS608_2016-17_T3_Assign_KISHAN_BHARADWAJ_SHRIDHAR|here]]. <br />
 +
Navigate to the bottom of the main page, after reading the 3 sub pages.</p>
 +
<p style="margin-left: .25in;">&nbsp;</p>
 +
<p style="margin-left: .25in;">Thank You,</p>
 +
<p style="margin-left: .25in;">Kishan Bharadwaj Shridhar</p>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>comment4</td>
 +
</tr>
 +
<tr>
 +
<td>comment5</td>
 
</tr>
 
</tr>
 
</table>
 
</table>
  
===== Unusual Patterns =====
 
  
<!-------------------------------->
+
<!--- Discussion --->

Latest revision as of 11:41, 13 July 2017

VAST Challenge 2017: Mini-Challenge 1

ZBJ Pipits.jpg

Mistford is a mid-size city is located to the southwest of a large nature preserve. It has been discovered that the number of nesting pairs of the Rose-Crested Blue Pipit, a popular local bird due to its attractive plumage and pleasant songs, is decreasing! Provided several datasets, it is required to investigate the reason for the decrease of Rose-Crested Blue Pipit. In Mini-Challenge 1, traffic movement dataset is given to analyze patterns of life of vehicles through out the reserve, and detect unusual patterns that are potentially harmful to the birds. Questions raised are:

  • Describe up to six daily patterns of life by vehicles traveling through and within the park.
  • Describe up to six patterns of life that occur over multiple days (including across the entire data set) by vehicles traveling through and within the park.
  • Describe up to six unusual patterns (either single day or multiple days) and highlight why you find them unusual.
  • What are the top 3 patterns you discovered that you suspect could be most impactful to bird life in the nature preserve?

This webpage will guide you through my investigations and help to save Rose-Crested Blue Pipit!

Data Description

Entry gates are positioned at the Preserve entrances. Each vehicle receives an entry ticket at the gate and is assigned a vehicle class; the entry is recorded. The entry ticket contains an RF-tag that enables the Preserve sensors to pick up the passage of a vehicle through the Preserve. Each vehicle surrenders their entry ticket when exiting the Preserve and the exit is recorded. A .csv file containing data recorded from sensors around the Boonsong Lekagul Nature Preserve. A map containing the locations of roadways and sensors throughout the Preserve is also provided.

Dataset Overview
1 CSV Traffic Movement Data 2 Roadway Map
ZBJ Data.PNG
Locations of roadways and sensors
More Detailed Data Facts

1 CSV Traffic Movement Data

Entrances:
All vehicles pass through an Entrance when entering or leaving the Preserve.
General-gates:
All vehicles may pass through these gates. These sensors provide valuable information for the Preserve Rangers trying to understand the flow of traffic through the Preserve.
Gates:
These are gates that prevent general traffic from passing. Preserve Ranger vehicles have tags that allow them to pass through these gates to inspect or perform work on the roadway beyond.
Ranger-stops:
These sensors represent working areas for the Rangers, so you will often see a Ranger-stop sensor at the end of a road managed by a Gate. Some Ranger-stops are in other locations however, so these sensors record all traffic passing by.
Camping:
These sensors record visitors to the Preserve camping areas. Visitors pass by these entering and exiting a campground.

2 Roadway Map
The contractors working with the Nature Preserve rangers have provided a map that presents the Preserve in terms of a 200x200 gridded area. The grid is oriented with north at the top of the map. Grid location (0,0) is at the lower left corner of the map (the SW corner). They have superimposed both the roadways and the sensor locations on this grid. The map shows an area 12 miles x 12 miles.

3 Others

  • Traffic either passes through the Preserve, stay as day campers, or stay as extended campers.
  • Preserve Rangers stay at the ranger-base toward the southeast of the Preserve when they are not working in the Preserve.
  • The speed limit through the Preserve is 25 mph.
  • The Preserve area does not observe "Daylight Savings Time".
  • The roadways traveling southward from Entrances 3 and 4 do continue to other roadways outside of the Preserve area, but these are not shown on the map. Vehicle data will not reflect travel beyond the Preserve in this direction.



Data Preparation

1 Define episodes

Intuitively, each car-id (except for park service vehicles 2p) should possess two entrance records with one serves as entering and the other for exiting. However, it is noticed that many car-ids had more than two entrances recorded. It is rational to assume that these cars did made multiple visits to the preserve. Therefore, I split the trip with multiple entering and exiting of the same car-id into different episodes. Each episode can be seen as a complete trip and analysis is performed based on episodes.


2 Exclude incomplete trips

By looking at the maximum timestamp of the entire dataset, it is safe to conclude that the data provided is generated before June 2016. Therefore, there are vehicles with incomplete trips (the maximum timestamps of these car-ids are around end of May) in the dataset, and I exclude car-ids with only one entrance record. The figure on the right shows the car-ids with only one entrance record and their maximum timestamp.

ZBJ 1entrance-list.PNG
3 Remove duplicate records

It is noticed that some sensor records are duplicated in the dataset, and these duplicates all have three entrance records for a car-id - the first two have the same timestamp (or very close timestamp), and the third one has a different timestamp and is coherent with the following activities. Hence, I remove the first two records assuming there were something wrong the data entry and keeping the third one makes more sense when interpreting the trip. The figure on the right shows an example of this kind of data anomaly.

ZBJ 3entrance-1.PNG

4 Label the sequence of gates of each episode

In order to plot the entire routes of the vehicles, I create a new column named 'Sequence' to
mark the order of the gates they passed through.

5 Concatenate the routes

To concatenate the gate-names of each episode to form a route.

ZBJ Seq.JPG
ZBJ Rule.JPG
6 Extract the gate-to-gate directions
7 Calculate the gate-to-gate duration
ZBJ Gatetogate.JPG
ZBJ Duration.JPG
8 Extract the arrival timestamp of each episode
9 Segment the visitor types
  • Camper: normal visitors who went to camping areas
  • Non-camper: normal visitors who never went to camping areas
  • Rangers: vehicles with car-type as 2p
ZBJ Arrtime.JPG
ZBJ Visitortype.JPG
10 Map coordinates of gates
  • Use JMP Pro 13 Custom Map Creator add-in to point the gates on the map and generate the coordinates.
  • The scale of the map is set to 12*12 as the area indicated in data description.
ZBJ Mapcoord.jpg



Interactive Visualization

You may have your own investigation here: Link to interactive visualization

  • Please be noticed that the link is not working well due to some unknown tableau server issue; please download the workbook via tableau public landing page.
ZBJ Cover.JPG
ZBJ Trend.JPG
ZBJ Pattern.JPG
ZBJ Vehicle.JPG



Patterns of Life Analysis

Daily Patterns
Images Interpretations
ZBJ 2pnoshow.jpg

ZBJ ArrivalLine-ranger.jpg
  • Park service vehicles never showed up between 4am to 5am in any kind of gates. This might be the off-duty period of the rangers, and the off-duty period varied across different days of week. For example, rangers were never on patrol from 1am to 5am on Saturday.
  • If we look at the arrival time (in this case is the time when rangers started each patrol trip), the first shift always started at 6am and the last shift started at 17pm.
ZBJ Nocamping.jpg
The two types of buses and 4+ axle trucks, all large vehicles, had no appearance in any camping areas. It might represent that these three car-types can only be passing through the preserve, and camping area is not allowed for large vehicles.
ZBJ Campinghour.jpg
Majority of traffics through camping areas only happened between 5am to 22pm, except for one car-id 20154519024544-322, which is discussed in later section. It might indicate that traffics were not allowed in camping areas after 22pm to ensure the safety and rest of overnight campers.
ZBJ Activetime.jpg
2 axle car/motorcycle, 2 axle truck, and 3 axle truck were most active vehicles in the preserve. Their activities started to increase at 6am and started to flatten out at around 18pm. 7am to 17pm had most vehicle activities.
ZBJ Trespassing.jpg
There were vehicles that simply passed the preserved without making any stops and looking around. These vehicles can be identified by investigating the number of gates they passed through. This pattern only applies to non-campers and happened within a short time period. The graph on the left shows all the possible routes for trespassing.
  • Entrance0<->entrance3
  • Entrance2<->entrance4
  • Entrance1<->general-gate7<->entrance3
  • Entrance0<->general-gate7<-> general-gate4<-> entrance1
Longer-Period Patterns
Images Interpretations
ZBJ Line-month.jpg
Traffic increased since May and reached highest in July, then started to decrease. November to March were the least popular months for visitors and it is possible that these are winter months.
ZBJ Line-weekend.jpg
Activities of 2 axle car/motorcycle, 2 axle truck and 3 axle truck increased on Friday and decreased on Monday. This can be explained by the overnight camping during weekends.
ZBJ Ranger.jpg

ZBJ RangerCampDuration.jpg
The duration rangers spent at ranger-stops and camping areas were less than 1 hour.
ZBJ MapRoute-rangermost.jpg
The graph shows the route that had most rangers' episodes. It was the most frequent patrol route of the rangers, and it was almost twice as frequent as the second most frequent patrol route. It is possible that the east side of the preserve required more care and protection.
  • ranger-base>gate8>general-gate5>gate3>ranger-stop3>ranger-stop3>gate3>camping8>general-gate3>gate4>ranger-stop5>ranger-stop5>gate4>gate5>ranger-stop6>ranger-stop6>gate5>gate8>ranger-base
ZBJ ArrTime-campers.jpg
Campers arrived at the preserve between 5am and 17pm. Friday to Sunday were more popular as expected.
Unusual Patterns
Images Interpretations
ZBJ Route-322.jpg
This table displayed the route of car-id 20154519024544-322 (a 2 axle truck), which passed through camping gates after 22pm. This vehicle had 16 episodes, and each episode had exact same route except for the first episode. This vehicle came to the preserve each Friday and left the on the following Monday.
ZBJ Route-multiepisode.jpg
Apart from 20154519024544-322, there were other car-ids that had multi-episodes, which means they did not render their car-id by the time they exited the preserve. And every time they came to the preserve, they followed the same routes and went for overnight camping. This group of visitors might hold a regular pass for their visits.
ZBJ Line-gateanomaly.jpg

ZBJ Route-gateanomaly.jpg
  • Unauthorized 4+ axle truck appeared in gates only on Tuesday and Thursday, though not every week.
  • They arrived at the preserved between 2am to 4am. More interestingly, the time they passed through gates avoided the time when park service vehicles passed through those gates.
  • The 4+ alxe trucks that passed through gates had different car-id but they all followed the exact same route:
    entrance3>gate6>ranger-stop6>gate5>general-gate5>gate3>ranger-stop3>ranger-stop3>gate3>general-gate5>gate5>ranger-stop6>gate6>entrance3
  • Recalling from previous section, this route was in the area where the most frequent ranger patrol route covered.
ZBJ Map-skipgate.jpg
  • There were vehicles going between entrance1 and ranger-stop1 without records from gate2. However, entrance1<->gate2<->ranger-stop1 is the only path between the entrance1 and ranger-stop1.
  • There were 6 episodes, all were 2 axle car/motorcycle, followed the exact same path entrance1>ranger-stop1>ranger-stop1>entrance1. They happened on the same day and at the same time.
  • They stayed for almost 4 hours in ranger-stop1, which was long and suspicious.
ZBJ Roundtrip.jpg
Apart from the gate-skippers mentioned above, there were another 3 episodes made a simple round-trip in the preserve: they entered the preserve, passed through general-gate, then made the same route back to the entrance.
Top 3 Possible Causes
  1. Long term visitor with car-id 20154519024544-322 and his behavior to travel pass camping areas during midnight.
  2. Unauthorized 4+ axle trucks invading restricted areas because the route they traveled was part of the most frequent patrol route of the rangers. This area could be where pipits resided, and therefore needed more care and protection from rangers. And the fact that they went through the restricted area when the rangers were off-duty makes them extremely suspicious.
  3. Possible over speeding which requires further investigations, especially for trespassing routes.


Comments & Discussions

comment1: Hi,Bijun. Amazing work! From you analysis pack, I can see the level of efforts that you have devoted into this assignment. Yet, I have the following suggestions that hopefully are useful in further improving your work:
    Aesthetic
  • 1. I love the way you present your analysis. However, a big part of the analysis findings are demonstrated by line graphs. I am wondering if you can try other types of graphs to make the findings more visually clear?
  • 2. For the first graph of daily pattern. You are trying to say that the rangers do not work from 4-5 am. Yet the graphs x axis only shows hour of 3,9,15,21. I think the pattern will be more obvious if you construct the graph in a way that X axis displays every hour of the day.
  • 3. the story structure in your tableau workbook is clear. Look forward to viewing it interactively on line soon.
    Clarity
  • 1. the tableau workbook contains lots of useful information, yet it is a bit complex and confusing. There are quite a few selectors and parameters defined and the graphs are controlled by different selectors, which is not straightforward. Audience probably need to spend quite some time in understanding the dashboard, particularly for those who do not know the background of vast challenge.
  • 2. the legends are not closely attached to their corresponding graphs, which also adds confusion to the dashboard.

Overall, fantastic work! Hopefully my comments can add value
Best Regards
Yunna

Hi Joyce,

Great overall effort and very engaging. Some of my feedback as below 😉
Aesthetics:

    • Though it is very interactive with a lot of interactive filters and legends, I feel that it is abit overwhelming, confusing and took me a while to understand and link them together; which I believe also is causing some dashboard performance issue to load slowly. Selecting some of the values also caused the whole dashboard to blank out and getting lost in visualization, can consider to reduce the number of variables of filters for interactive visualization.
    • I guess storybook should be story-telling and easy to follow for anyone. Currently, it is designed for exploratory purposes.
    • The colors of the titles, filter and legends are well-designed and implemented and all well-linked across the various graphs! Only thing is that descriptions fonts are a bit small for old folks.

Clarity:

    • I don’t understand the “top x and bottom x” & “Timestamp Slector” (typo? Sector or Selector?) but I guess you are trying to compare the traffic at each gate with the arrival time, though I can’t tell anything obvious from the arrival time from pattern detection. In such case, it may be interesting to include and look at their departure time as well.
    • Currently it only shows the route on the map; I think you can also consider the intensity of the path traveled illustrating by thickness of line.
    • Coordinates of the checkpoints are offset from the actual 200x200 grid or actual distance/area and may cause confusion. Zooming feature in the map is good as it allows for better visibility similar to “How long did they spend”. Only point is to consider expanding the box to allow complete view of it; currently it requires scrolling.

Cheers,
Zac

comment3

Hi Zheng Bijun,

Please find my feedback comments as follows. You present a very nice analysis, which is answering the questions of the challenge. With regard to the clarity and aesthetics aspect, I have the following to add.

Clarity :

 

    • In the daily pattern plots, you have used the ‘select’ feature effectively to illustrate clearly the trend you wish to explain. This is a good practice, as it help to retain the background information clearly, whilst projecting the focus for the user.
    • When using map images, you might want to use the Cartesian coordinates more effectively. You can use Tableau to import the map as a background image, and then geocode it so that you will be able to use annotations. The current texts you have indicated does help the user identify the locations inside the preserve, such as entrance 0, entrance 3, etc. but having annotations will help them to pop out of the plane, thereby presenting better clarity.
    • In your 2nd plot inside longer period patterns, I assume the x axis shows the days of the week (1-7). You might want to add an axis label, or you might want to use aliases for the days of the week and label the axis. (for e.g. 1-Sunday, 2-Monday, etc.).
    • On most of the plots, you have a well defined title, so you might not want to show the headers on the Y axis (# of cars) since it can already be known that the chart shows the trends of traffic.

Aesthetics:

    • I notice that you have tweaked the background colour. Maybe, you would want to also explore format axis feature in Tableau that might change the text to more bolder and visible formats. This would lend more readability to the plots.
    • On the arrival time calendar plot you have developed, when you try to visualize the number of episodes, the gradation in colors is good, and helps to quickly infer, which times of the day have higher episodes.

  Hope the feedback helps, and please leave out a feedback on my page as well. You may access it here.
Navigate to the bottom of the main page, after reading the 3 sub pages.

 

Thank You,

Kishan Bharadwaj Shridhar

comment4
comment5