Difference between revisions of "Report Group7"
| Line 48: | Line 48: | ||
The prepared data consists of two tables: | The prepared data consists of two tables: | ||
<br/> | <br/> | ||
| − | ''' 1. Node Table: ''' Consists of all the available gates in the preserve mapped to a unique identifier and with their respective location details. X and Y co-ordinates represent the location of the gate in the preserve. | + | ''' 1. Node Table: ''' Consists of all the available gates in the preserve mapped to a unique identifier and with their respective location details. X and Y co-ordinates represent the location of the gate in the preserve. A snippet of the actual data table is shown as follows: |
<br/> | <br/> | ||
| − | [[Image:Node_Group7.JPG| | + | [[Image:Node_Group7.JPG|350px|center|float]] |
<br/> | <br/> | ||
| − | ''' 2. Edge Table: ''' Consists of Source and Target variables denoting Gate names but mapped to the node table with a common ID. Frequency and the time at which it occurred is noted for analysis. Here X1,X2, Y1 and Y2 represent the X-coordinate and Y-coordinate of Source and Target variable respectively. | + | ''' 2. Edge Table: ''' Consists of Source and Target variables denoting Gate names but mapped to the node table with a common ID. Frequency and the time at which it occurred is noted for analysis. Here X1,X2, Y1 and Y2 represent the X-coordinate and Y-coordinate of Source and Target variable respectively. A snippet of the actual data table is shown as follows: |
<br/> | <br/> | ||
| − | [[Image:Edge group7.JPG| | + | [[Image:Edge group7.JPG|550px|center|float]] |
<br/> | <br/> | ||
Revision as of 22:32, 6 August 2017
ISSS608: Visual Analytics and Applications
- Anuthama Murugesan
- Krutika Balveer Choudhary
- Sumalika Kodumuru
|
|
|
|
|
|
Geo-spatial analysis of vehicle movement data to uncover patterns and detect anomalies
Objective:
Data Pre-Processing:
Network Plot
Network plot is constructed to examine the structure of relationship between gates in terms of how frequently people/users have taken the path. From this it is easy to identify which road is more popular. In order to construct this network plot, source and target gates need to be identified and the data should be prepared to plot path from source to target gate. However since the popularity of the path is an important insight that can be drawn from the network plot, frequency of the source and target needs to be extracted from the data.
The prepared data consists of two tables:
1. Node Table: Consists of all the available gates in the preserve mapped to a unique identifier and with their respective location details. X and Y co-ordinates represent the location of the gate in the preserve. A snippet of the actual data table is shown as follows:
2. Edge Table: Consists of Source and Target variables denoting Gate names but mapped to the node table with a common ID. Frequency and the time at which it occurred is noted for analysis. Here X1,X2, Y1 and Y2 represent the X-coordinate and Y-coordinate of Source and Target variable respectively. A snippet of the actual data table is shown as follows:
