CAO BO DataPreparation

From Visual Analytics and Applications
Revision as of 16:15, 10 July 2017 by Bo.cao.2016 (talk | contribs)
Jump to navigation Jump to search

Blue Pipit.png ISSS608 Visual Analytics and Applications_Vast Challenge_Mini Challenge1

Background

Overview & Data Preparation

Pattern Summary

Comments

 

Map View

Lekagul Roadways labeled v2.jpg

Data Overview

Traffic Movement Data

Cb dataoverview.PNG

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
Entrances number2.PNG

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)]
Car sequences.PNG

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 and eposide.PNG