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 1 - Residence

(March 7, 2014)

Example: I want to get Means of transportation table for all counties in Pennsylvania.

Table Used in this example:

A102106 Means of transportation (Universe: Residence: 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 CTPP 2006-2010 data access software sign in and register page (http://data5.ctpp.transportation.org/ctpp/Browse/browsetables.aspx)

Figure 1

2. Select Data set option. Make sure 2006-2010 data is selected.

Figure 2 - Description: It provides the dataset selection window after logging in. The purpose is to ensure users select the correct database.

Figure 2

3. Select Part 1: Residence option.

Figure 3 - Description: This image indicates all three parts of CTPP and the CTPP Part 1: Residence will be selected.

Figure 3

4. Select Residence: Workers 16 years and over option.

Figure 4 - Description: This image shows all available universes for CTPP Part 1 data and Residence: Workers 16 years and over will be selected.

Figure 4

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

Figure 5 - Description: This image shows that Set A and Set B tables are available. Set A (from microdata) will be selected.

Figure 5

6. Select A102106 - Means of transportation (18) (Workers 16 years and over) option.

Figure 6 - Description: Table A102106 Means of Transportation (18) (Workers 16 years and over) will be selected.

Figure 6

7. Geography Selection:

a. Click RESIDENCE in the following page.

Figure 7 - Description: This image shows the first step for the geography selection.

Figure 7

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

Figure 8 - Description: Click Clear Full Selection on the top right corner of the following page then click State-County to proceed the next step.

Figure 8

c. Select Show state descendants from the option in Show valid flow members | More options.

Figure 9 - Description: This operation enables the state list by alphabetical order.

Figure 9

d. Select Pennsylvania from the drop down list in View state descendants and click OK when done.

Figure 10 - Description: It shows the drop down menu for target states selection.

Figure 10

e. Click Select All on the top right corner of the following page.

Figure 11 - Description: This image indicates the selection for all counties in Pennsylvania.Figure 11

f. Click Save selection set and enter the set name in the input box Set name (shown on the right below)

Figure 12 - Description: These two windows show where to type the name of the selection set after clicking on saving the selection set.

Figure 12

8. Click Show data on the top right corner of the following page.

Figure 13 - Description: This tool bar reminds users to make sure the residency selection is "All Counties in PA".

Figure 13

9. Select Save table view as on the following page. Input the Title in the input box and click OK.

Figure14 - Description: This image shows how a queried table can be saved.Save report dialogue box.

Figure 14

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

Figure15 - Description: This window shows how to go back to the CTPP full table list.

Figure 15

11. Click Saved Tables and Charts tab and the name of the saved report is shown. Further operation, such as Delete, can be done by checking the check box next to the report name and clicking Delete.

Figure16 - Description: This image shows how to delete saved tables and charts.

Figure 16

12. Click My selection sets tab and the name of the saved selection set is shown. Further operation, such as Delete, can be done by checking the check box next to the selection set name and clicking Delete.

Figure 17 - Description: This image shows how to delete a selection set.

Figure 17

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

Figure 18 - Description: This figure shows the software mapping capabilities.

Figure 18

14. Select Foreground - Graduated Symbols from the drop down list in SHOW USING under ADD THEMATIC ANALYSIS. Choose Total, means of transportation under VARIABLES and click OK. The total results are shown in the map as shown in the bottom right figure below.

Figure 19 - Description: This image details symbology options available in the software.

Figure 19

15. Select different options in means of transportation 18 under VARIABLES and the corresponding results are shown in the map as shown in the figure on the right below.

Figure 20 - Description: The image shows the software’s capability of plotting different measures on the map.

Figure 20

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