QUERY EXAMPLES

COLUMN SPECIFICATIONS

Return All Fields (Columns)

SELECT *, LON AS X, LAT AS Y FROM 0800 WHERE PURPOSE = 5
Return all fields

Return Specific Fields (Columns)

SELECT PID, GENDER, AGE, LON AS X, LAT AS Y FROM 0800 WHERE PURPOSE = 5

Return PID, GENDER, AGE fields only

* This is only you can see after exported to a Shape file.

CONDITIONAL SEARCH

People age between 20 and 30 at time 8:00

SELECT *, LON AS X, LAT AS Y FROM 0800 WHERE AGE BETWEEN 4 AND 5

Total Records: 63397

Men who travel at time 8:30

SELECT *, LON AS X, LAT AS Y FROM 0830 WHERE GENDER = 1
Total Records: 303180

Women who travel at time 8:30

SELECT *, LON AS X, LAT AS Y FROM 0830 WHERE GENDER = 2
Total Records: 328641

Male age between 20 and 30 at time 8:00

SELECT *, LON AS X, LAT AS Y FROM 0800 WHERE GENDER = 1 AND AGE BETWEEN 4 AND 5
Total Records: 30090

People who made more than two trips up to 8:00

SELECT *, LON AS X, LAT AS Y FROM 0800 WHERE TNO > 2
Total Records: 110066

People who made more than one trip and their sub trip is more than two up to 8:00

SELECT *, LON AS X, LAT AS Y FROM 0800 WHERE TNO = 1 AND SNO > 0
Total Records: 386925

People who travel for entertainment purposes only at 17:00

SELECT *, LON AS X, LAT AS Y FROM 1700 WHERE PURPOSE = 5

Total Records: 2523
　

Data Structure

User Guide

© 2012, Division of Spatial Information Science, University of Tsukuba