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