CAO BO DataPreparation
ISSS608 Visual Analytics and Applications_Vast Challenge_Mini Challenge1
|
|
|
|
|
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
Exclue 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. |  |
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(hour) |  |
