Skip to content U.S. Department of Transportation/Federal Highway AdministrationU.S. Department of Transportation/Federal Highway Administration

Office of Planning, Environment, & Realty (HEP)
Planning · Environment · Real Estate

HEP Events Guidance Publications Glossary Awards Contacts

CTPP 2006-2010 Data Access Software Self Tutorial - Part 3 - Flows

(March 7, 2014)

Example: I want to get flow tables from tracts in King County, WA and Pierce County, WA to tracts in King and Pierce County, WA.

Table Used in this example:

A302100 Total Workers (Workers 16 years and over) (Universe: Workers 16 years and over )

1. Open CTPP software web page and Sign In (or Register). (http://ctpp.transportation.org/Pages/5-Year-Data.aspx)

Figure 1 - Description: This is sign in page image and required user's register information from URL (http://ctpp.transportation.org/Pages/5-Year-Data.aspx)

Figure 1

2. Residence Geography Selection Process.

a. Click RESIDENCE.

Figure 2 - Description: This shows the map selection window to define the target residential area.

Figure 2

b. Click State-County-Tract then click Clear Full Selection on the top right corner of the following page.

Figure 3 - Description: Place of residential area at County level query is selected in this window.

Figure 3

c. Click Selection map tab.

Figure 4 - Description: After defining the selection level is county, the residential area can be identified from the map window.

Figure 4

d. Select State-County under ZOOM TO on the top right corner.

Figure 5 - Description: This window leads to the map selection method in drop down menu.

Figure 5

e. Check the box next to Automatically highlight state-county-tract. Type pierce in the input box and select Pierce County, Washington from the list.

Figure 6 - Description: Here shows the entry of searching Pierce County.

Figure 6

f. Click Add all highlighted State-County-Tract(s) to selection on the top right corner.

Figure 7 - Description: This map verifies the geographical residential area selection for Pierce County.

Figure 7

g. Check the box next to Automatically highlight state-county-tract. Type king in the input box and select King County, Washington from the list.

Figure 8 - Description: Here shows the entry of searching King County.

Figure 8

h. Click Add all highlighted State-County-Tract(s) to selection on the top right corner.

Figure 9 - Description: This map verifies the geographical residential area selection for King County.

Figure 9

i. Click Save selection set and type the set name in the input box Set name (shown on the bottom below).

Figure 10 - Description: These two windows show the user needs to name the selection set after saving the selection set.

Figure 10

3. Workplace Geography Selection Process.

a. Click WORKPLACE.

Figure 11 - Description: This shows the map selection window to define the target work place area.

Figure 11

b. Click State-County-Tract then click Clear Full Selection on the top right corner of the following page.

Figure 12 - Description: Work place at County level query is selected in this window.

Figure 12

c. Click Selection map tab.

Figure 13 - Description: After defining the selection level is county, the work place area can be identified from the map window.

Figure 13

d. Select POW County under ZOOM TO on the top right corner.

Figure 14 - Description: This window leads to the map selection method of Place of Work in drop down menu.

Figure 14

e. Check the box next to Automatically highlight pow state-county-tract. Type king in the input box and select King County, Washington from the list.

Figure 15 - Description: Here shows the entry of searching King County.

Figure 15

f. Click Add all highlighted POW State-County-Tract(s) to selection on the top right corner.

Figure 16 - Description: This map verifies the geographical work place selection for King County.

Figure 16

g. Check the box next to Automatically highlight pow state-county-tract. Type pierce in the input box and select Pierce County, Washington from the list.

Figure 17 - Description: Here shows the entry of searching Pierce County.

Figure 17

h. Click Add all highlighted POW State-County-Tract(s) to selection on the top right corner.

Figure 18 - Description: This map verifies the geographical work place selection for Pierce County.

Figure 18

i. Click Save selection set and type the set name in the input box Set name (shown on the bottom below). Click OK.

Figure 19 - Description: These two windows show the user needs to name the selection set after saving the selection set.

Figure 19

4. Click Show CTPP Tables on the top right corner of the following page.

Figure 20 - Description: This tool bar reminds user to make sure the residency selection is "King and Pierce in WA" and proceed to the table contents.

Figure 20

5. Select Part 3: Flows option.

Figure 21 - Description: This image indicates the correct database part to seek the data.

Figure 21

6. Select Flows: Workers 16 years and over option.

Figure 22 - Description: This table provides further screen capture of the sub-tables should be chosen.

Figure 22

7. Select Flows: Workers 16 years and over - Set A (from microdata) option.

Figure 23 - Description: Following previous tables breaking down, this table provides further screen capture of the nest level sub-tables should be chosen.

Figure 23

8. Select A302100 - Total Workers (1) (Workers 16 years and over) option.

Figure 24 - Description: Succeed from the previous steps, here indicates the table index to be selected.

Figure 24

9. Select Save table view as on the following page.

Figure 25 - Description: This shows how the query view table can be saved and subsequently exportable from here.

Figure 25

10. Type the Title in the input box and click OK.

Figure 26 - Description: The query table contents can be saved into different forms based on user's preference.

Figure 26

11. Going back to the report page and clicking Map leads to the map view of the data.

Figure 27 - Description: This window leads to the map view of the result table.

Figure 27

12. Select FLOW FROM TARGET RESIDENCE: from the drop down list on the top left corner. Click the red arrow on the right. Click on the map to define the flow origin / destination.

Figure 28 - Description: This defines the way how the trip flow arrows will be presented.

Figure 28

13. Select Flow from the drop down list in SHOW USING window and click OK.

Figure 29 - Description: This details the parameters selected to generate the flow chart as it is the best mapping template.

Figure 29

14. The results are shown as flows in the map. Mouse over individual green arrow to show the details information about the flow.

Figure 30 - Description: This is the final view of the trip flows look like.

Figure 30

Updated: 03/12/2014
HEP Home Planning Environment Real Estate
Federal Highway Administration | 1200 New Jersey Avenue, SE | Washington, DC 20590 | 202-366-4000