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

QUICK GUIDE
Version 2014.08.30

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: August 30, 2014

Contents
1. GRAPHICAL USER INTERFACE

P1

2. MAP CONTROLSP2

3. QUERY BUILDER
3.1. Simple Query
3.2. Query by Successive Time Intervals

P3
P4

4. SPATIAL QUERY
4.1. Interactive Spatial Queries
5. GRAPH GENERATION5.1. Bar Chart Generation

P5P6

1. GRAPHICAL USER INTERFACE

URL: http://land.geo.tsukuba.ac.jp/persontrips/asia

124

3

1

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

2

Query Builder

3

Query Log Display

4

Map View

P1

2. MAP CONTROLS

1
2

3
4
5

1

Zoom In
Zoom OutPan
Get Attribute Information
Distance Measurement
Zoom All
Clear the Map (Remove all queries results)

2

Hide/Show query layer

3

Automatic update the query layer while zoom in/out/pan

4

Change the point size

5Select Base Map type (Map or Aerial or Hybrid or None)

P2

3. QUERY BUILDER
3.1. Simple Query
1 Select Area (City)

12 Select Year23456783 Select Hour and MinuteSkip for now

4 Set Hour or Minute intervals (only forsuccessive queries usingbuttons) See
Next “Query by Successive Time Intervals”

5 Select All Records to return all records
6 Select Custom to define the search category
7 Under Custom search: Select desire column

fields. For example:* for all fields <or> To return PID, AGE andGENDER fields only
SELECT PID, AGE, GENDER, LONG AS X, LATAS Y FROM (Same as SQL Language)

9Database Table Name (Fixed, cannot edit)
Similar to TimeFor Example
8:000800, 12:30
1230

8 Search Conditions. For Example

People age between 20 and 30 who only
travel for entertainment purposes
WHERE PURPOSE = 5 AND AGE BETWEEN 4AND 69 Click Query to start
Display the result in below text box.

P3

3. QUERY BUILDER
3.2. Query by Successive Time Intervals
1 Select Area (City)
12 Select Year

233 Select Hour and Minute
495674 Set Hour or Minute intervals
5 Select All Records to return all records
6 Select Custom to define the search category
7 Under Custom search: Select desire column

8fields. For 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)
Database Table Name (Fixed, cannot edit)
Similar to TimeFor Example
8:00
0800, 12:30
1230

8 Search Conditions. For Example

People age between 20 and 30 who only
travel for entertainment purposes
WHERE PURPOSE = 5 AND AGE BETWEEN 4AND 69 Clickhour or minute button for eachquery. Hour and Minute will automatically
set to specific intervals
Display the result in below text box.

Total RecordsTime Intervals

P44. SPATIAL QUERY
4.1.. Interactive Spatial Queries
1 Click on Interactive Query CheckBox
2 Set Line Buffer distance in Meter (For LineTool only)

3 Selectfor drawing a line on a map andquery.
For example: Finding number of people along
the road or railway line. (buffer distance500m)

14 Select2345

for drawing a circle with searchradius.
For example: Finding number of people byspecific point with search radius 4Km.

5 Selectfor drawing a polygon and query.
For example: Finding number of people byspecific zone or area.

P55. GRAPH GENERATION
5.1. Bar Chart Generation

1

2

1

Click “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

3

Clear the TextBox

3

Example: Number of people travel for work by every one hour (Jakarta city)

P6