Person Trip Data Browser and Analyzer
Understanding human mobility from spatial perspective

QUICK GUIDE

Version 2014.03.10

By
Dr. Ko Ko Lwin
Division of Spatial Information Science
Faculty of Life and Environmental Sciences
University of Tsukuba
Copyrighted material © 2012
Department Homepage
http://giswin.geo.tsukuba.ac.jp

Updated on: March 10, 2014

Contents
1. GRAPHICAL USER INTERFACE

P1

2. MAP CONTROLSP2

3. QUERY BUILDER
3.1. Simple Query
3.2. Query by Specific Time Intervals
3.3. Get Sum of Each Category in User
Defined Attribute Field

P3
P4P5

4. SPATIAL QUERY
4.1. Query by Feature
4.2. Interactive Spatial Query

P6P7

5. GRAPH GENERATION
5.1. Bar Chart Generation
5.2. Pie Chart Generation

P8
P9Appendix

P10

1. GRAPHICAL USER INTERFACE
URL: http://land.geo.tsukuba.ac.jp/persontrips

5
1
2

3
4

6

7

8910

1

Map controls (Zoom In/Out, Pan, Get Attribute Information, etc.)2

Map layers control (Layer On-Off, Label On-Off)3

Map symbol size

4

Show map legend and select attribute field for generating
sum of each category

5Query builder

6

Spatial Query by Feature

7Interactive Spatial Query

8

Result of sum of each category in user defined attribute field

9

Result of each query string

10

Result of spatial query

P12. MAP CONTROLS

1
1

Map viewer control

2

Map layer control

3

Change symbol size

45

Select attribute field forlabeling and get sum byeach category

6Show map legend andgenerate sum by eachcategory7

Map legend

2

3
4
6

75P2

3. QUERY BUILDER
3.1. Simple Query

1

1

Select Area and Date

2

Select Hour and Minute3

Select All Records or Custom to definesearch category in 4 and 6

4Under Custom search: Select desire column
fieldsFor example:* for all fields <or> To return PID, AGE and
GENDER fields only
SELECT PID, AGE, GENDER, LONG AS X, LAT
AS Y FROM (Same as SQL Language)

5Database Table Name (Fixed, cannot edit)
Similar to TimeFor Example
8:00
0800, 12:30
1230

6Search Conditions
For Example
People age between 20 and 30 who only
travel for entertainment purposes
WHERE PURPOSE = 5 AND AGE BETWEEN 4AND 6

7Click Query to start8

Get the total records for that search category

9Display the result in below text box.

23456789P3

3. QUERY BUILDER
3.2. Query by Specific Time Intervals

1237

1

Select Area and Date

2

Select Hour and Minute

3Insert Hour or Minute interval in appropriate
text box
For example:
1 hour interval for 1 hour text box and 5
minute intervals for
5 in minute text box

4

Select All Records or Custom to define search
category in 5 and 6

5Under Custom search: Select desire column
fieldsFor example:* for all fields <or> To return PID, AGE andGENDER fields only
SELECT PID, AGE, GENDER, LONG AS X, LAT
AS Y FROM (Same as SQL Language)

6Search Conditions
For Example
People age between 20 and 30 who only travel
for entertainment purposes
WHERE PURPOSE = 5 AND AGE BETWEEN 4AND 6

7Clickto query. Click continuously forevery specific time intervals.

8

Get results in below text box

456Total records

8Specific time intervals

P4

3. QUERY BUILDER
3.3. Get Sum of Each Category in User Defined Attribute Field
1

Check Show Legend and Sum to show
map legend and generate sum of eachcategory in selected attribute field 22

Select attribute field to show sum of theeach category in that field
For example:
Select AGE to show different age group inmap legend 3 and get sum of eachgroup in age attribute field

4Click5Get sum of each category in user defined
attribute field

21button to query

3
5

6You can generate Bar Char and Pie Chartfrom these value. Please see details insection 5 “Graph Generation”

646P5

4. SPATIAL QUERY
4.1.. Query by Feature

12341

Select Map Layer

2

Select Attribute Field

3

Select Field Value

4Set Buffer Distance (Only available inpoint and line features)

5Click6

Display result in a map

7

Display result as a Text

5button to analyze

67P6

4. SPATIAL QUERY
4.2.. Interactive Spatial Query
1 Click

2 Click
1

34

5

2

to select multiple features
to analyze

3 Click

to draw a circle on a map

4 Click

to clear all selected features

5 Specify buffer distance in meter6 See result in a map

7 Get result in a Text

67P7

5. GRAPH GENERATION
5.1. Bar Chart Generation

1

2

1Click “Generate a Bar Chart” to generate a bar chart from log data

2

Click “Show Me a Bar Chart” to display the bar chart as below in a new page

Example: A bar chart of PURPOSE = 1 (to work) for every one hourP8

5. GRAPH GENERATION
5.2. Pie Chart Generation

12

1

Click “Generate a Pie Chart” to generate a bar chart from log data

2

Click “Show Me a Pie Chart” to display the bar chart as below in a new page

Example: A Pie Chart of people used by various transportation modes at 8:00AMP9

Appendix
1. Attribute Fields
Field ID
12345678910111213Field NamePID
TNO
SNO
LON
LAT
GENDER
AGE
ZCODE
OCCUP
PURPOSEMAGFACMAGFAC2
TCODE

Description
Unique person ID
Trip number
Suntrap number
Longitude position
Latitude position
GenderAge group
Current location by zone code
Person occupation
Purpose to trip
Adjustment Factor
Adjustment Factor
Mode of transportation

These codes are only
appropriate for Tokyo
2008. For other areas
and years, please referto the following PDF
file provided by CSIS
Center for Spatial
Information Science,
University of Tokyo.
http://land.geo.tsukuba.ac.jp/persontrips/pflo
w_webapi.pdf

2. Attribute Values
2.1. TNO and SNO (Trip Number and Sub-Trip Number)
TNO = Trip Number (1, 2, 3, .....)
SNO = Sub Trip Number (1,2,3, ... ), Trip is divided into Sub-Trips

2.2. GENDER
Code129Value
MaleFemale
Unknown

2.3. AGE (AGE GROUP) ONLY FOR 2008
Code123456
7
89ValueAge between 5 - 10
Age between 10 - 15
Age between 15 - 20
Age between 20 - 25
Age between 25 - 30
Age between 30 - 35
Age between 35 - 40
Age between 40 - 45
Age between 45 - 50

Code1011121314151617ValueAge between 50 - 55
Age between 55 - 60
Age between 60 - 65
Age between 65 - 70
Age between 70 - 75
Age between 75 - 80
Age between 80 - 85
Age above 85

2.4. ZCODE
Please Refer to following PDF
http://land.geo.tsukuba.ac.jp/persontrips/zone.pdf

P10

Appendix
2.5. OCCUP (Occupation) ONLY FOR 2008
Code1
2
3
4
5678

Value
Agricultural/Forestry/Fishery
Labor/Factory (Blue Collar)
SalesService
Transport Service
Security ServiceOffice Worker
Professional

Code91011121314151699

Value
Manager
Other Occupation
Elementary and Junior-high Student
High School Student
College and University Student
House-wife
No-occupation
Others (Not Categorized)
Unknown

Code9101112131499

Value
To Send/Pick Up Activity
For Selling and Buying
For Appointment
To/For Work (Fixing and Repairing)To Agri./Forestry/Fishery Work
Other Business Purpose
Others

2.6. PURPOSE ONLY FOR 2008
Code12345678

Value
To-From Office
To-From School
To HomeFor Shopping
For Short Recreation
For Sight Seeing and Leisure
For Medical Treatment
For Attending Class

2.7. TCODE (MODE OF TRANSPORTATION) ONLY FOR 2008
Code12345678Value
WalkBicycle
Motor-Bicycle
Motor-Bike
Taxi
Passenger Vehicles
Mini Car
Freight Vehicle

Code91011121314151699

Value
Private Bus
Public Bus
Monorail Transit
Train/Subway
Ship
Aircraft
No Movement
OthersUnknown

Copyrighted material © 2012 byDivision of Spatial Information Science
Graduate School of Life and Environmental Sciences
University of Tsukuba
End of Document

P11