CAO BO DataPreparation

ISSS608 Visual Analytics and Applications_Vast Challenge_Mini Challenge1

Background

Overview & Data Preparation

Pattern Summary

Comments & References

Map View

Data Overview

Traffic Movement Data

Data Discription

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.When vehicles enter the Preserve, they must proceed through a gate and obtain a pass.

Details Discription

1. Entrances: All vehicles pass through an Entrance when entering or leaving the Preserve.

2. 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.

3. 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.

4. 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.

5. Camping: These sensors record visitors to the Preserve camping areas. Visitors pass by these entering and exiting a campground.

Step by Step Discription

Exclude misleading records

Exclusion criterion: (1) id without full movement records( all visitors should come in and get out from both entrances so those ids that only have one entrance should be excluded). (2)id without full timestamp records.( those id without the come in and get out records). (3) repeat records

Extract the car sequences

The most essentail step for data preparation is to extract the car sequences which helps to summary the life patterns. This step is conducted in JMP with the function[Col Rank(Timestamp,car-id)]

Label vehicles in their movement order and then create Episode based on the movement order and id

Number the movement order for each car-id and then list the car-id with episode. Level: The order of movement(entrance---gate ：level of entrance is one and the level of gate is two) Episode: Each entrance & exit is one episode, so normally each id should has only one episode.

Compute the last duration, camping hour and single checkpoint duration

Compute the multipul duration in excel for better visualization.Last duration(day),camping hour(hour),single checkpoint duration(min)

Coordinates Extractation and Preparation for Gephi

Extract the coordinates in tableau and then prepare the coordinates for Gephi visualization

Participent Segamentation

All the participents are classified into Camper,No-camper and Ranger