1 / 46

Geography Division US Census Bureau Fall 2014

Access and analyze economic data by industry at national and subnational levels using the County Business Patterns (CBP) data in Geodatabase format. Download geodatabases for counties, states, and other areas from the US Census Bureau.

paulg
Download Presentation

Geography Division US Census Bureau Fall 2014

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Applications for 2012 County Business Patterns Data pre-related with TIGER/Line Data in a Geodatabase Format Geography Division US Census Bureau Fall 2014

  2. Overview • County Business Patterns (CBP) Data • Available Geodatabases (GDBs) • GDB Files (County) • GDB Location & Download Information • Working with Related 2012 CBP Data in ArcMap 10.1 (County GDB)

  3. County Business Patterns (CBP) Data • Annual series that provides national and subnational economic data by industry • Categorized according to the North American Industry Classification System (NAICS)

  4. North American Industry Classification System (NAICS) • System used to classify business establishments • Purpose is to collect, analyze, and publish statistical data related to the U.S. business economy

  5. North American Industry Classification System (NAICS) • Standard used by Federal statistical agencies • Learn about the NAICS and NAICS Codes on our website at: http://www.census.gov/eos/www/naics/index.html.

  6. Available Geodatabases (GDBs) • Geodatabases are available to download for the following levels of geography: • County • State • Metropolitan and Micropolitan Statistical Area • Puerto Rico & Island Areas • County Equivalents for Puerto Rico & Island Areas

  7. GDB Files (County) • Each GDB contains the following files: • TIGER/Line County Data (Feature Class) • 2012 CBP Data (Table) • 2012 NAICS Codes (Table) • 2012 CBP and TIGER/Line Data (Relationship Class) • 2012 CBP and NAICS Data (Relationship Class)

  8. GDB Location & Download Information • Click on the following link to access 2012 CBP Data Pre-related with TIGER/Line Data in a GDB Format: http://www.census.gov/geo/maps-data/data/tiger-data.html • Expand the ‘2012’ Menu under the County Business Patterns — Geodatabase Format heading • Click on ‘County’ under Download the Geodatabases • Or, click on the following link to access these files from the ftp site: http://www2.census.gov/geo/tiger/TIGER_DP/2012CBP/

  9. GDB Location & Download Information • Download the County GDB.zip file to your local drive • Extract the GDB.zip file to your local drive (The following files are extracted from the ZIP file) • CBP_2012_COUNTY.gdb • County_Layout.txt

  10. Working with Related 2012 CBP Data in ArcMap 10.1 (Exercises use the County GDB)

  11. Start a new session in ArcMap

  12. Open the Catalog window and drill down to the extracted GDB

  13. Expand the GDB folder to access files inside the GDB

  14. Exercise 1: Select, view and export all 2012 CBP – NAICS Data for San Bernardino County, CA (06071)

  15. Step 1: Add the ‘TL_2012_COUNTY’ feature class to the Data View

  16. Step 2: Click on the Select Features button on the Tools toolbar and select ‘San Bernardino County, CA’in the Data View

  17. Step 3: Right-click on the TL_2012_COUNTY layer and select ‘Open Attribute Table’

  18. Step 4: Click on the ‘Show selected records’ button to view the record for San Bernardino County, CA

  19. Step 5: Click the Related Tables button and select the ‘TL to County Data’ relationship

  20. All 2012 CBP – NAICS data is displayed for San Bernardino County, CA 06071 (1,833 records out of 2,131,529 records are selected)

  21. Step 6: Click on the Table Options button and select ‘Export’

  22. Step 7: Export the selected records and save the export as your preferred file type with the name ‘CBP_06071’

  23. Step 8: Add the CBP_06071 table to the data view, right-click on the table and select ‘Open’ to view the exported data

  24. Exercise 2: Create a thematic map showing the number of Drilling Oil and Gas Well establishments (NAICS Code 213111) in each county in the continental United States

  25. Step 1: Add the ‘NAICS_CODES_2012’ table to the Data View

  26. Step 2: Right-click on the NAICS table and select ‘Open’

  27. Step 3: Select the record for NAICS Code ‘213111: Drilling Oil and Gas Wells’

  28. Step 4: Click on the Related Tables button and select the ‘NAICS to COUNTY’ relationship

  29. A list of all counties in the nation with Drilling Oil and Gas Well establishments appears.

  30. Step 5: Click on the Table Options button and select ‘Export’

  31. Step 6: Export the selected records and save the export as a GDB table with the name ‘NAICS_213111’

  32. Step 7: Add the ‘TL_2012_COUNTY’ feature class to the Data View

  33. Step 8: Right-click on the TL_2012_COUNTY layer and select ‘Join’ from the Join and Relates option

  34. Step 9: Join the NAICS_213111 table to the TL_2012_COUNTY table, using the ‘GEOID’ field in both tables and click ‘OK’ to join the data

  35. Step 10: Right-click on the TL_2012_COUNTY layer and select ‘Open Attribute Table’

  36. Step 11: Scroll to the right, right-click on the NAICS field name and select ‘Sort Descending’

  37. All of the counties with data for NAICS code 213111 appear at the top of the list.

  38. Step 12: Right-click on the TL_2012_COUNTY layer and select ‘Properties’

  39. Step 13: Click on ‘Quantities’, then ‘Graduated colors’ under the Symbology tab

  40. Step 14: Select ‘est’ for the Field Value to classify the data and click ‘OK’ to close Layer Properties

  41. The resulting data view shows 5 classifications of counties in the nation with Drilling Oil and Gas Well establishments.

  42. Counties with null values are not displayed. Please take a couple of additional steps to display these counties.

  43. Step 15: Add another ‘TL_2012_COUNTY’ layer to the Data View

  44. Step 16: Use the Symbol Selector dialog to change the Fill Color to No Color and click ‘OK’

  45. In the resulting Data View, the counties with ‘No Fill’ have no data for NAICS Code 213111.

  46. Contact Information Geography Division US Census Bureau Geo.tiger@census.gov 301-763-1128

More Related