Analyzing County Business Patterns by Type of Business
.. mapping and analyzing county business patterns by type of business ... This section reviews use of tools and methods to develop custom U.S. by county business patterns data by type of business and develop mapping and related GIS applications. Steps illustrate how to develop a U.S. by county business patterns dataset for the supermarket industry -- NAICS type of business code 445100. Use the interactive table below to examine supermarket business characteristics by county. Create map views such as shown below and perform wide-ranging business patterns data analytics using the tools. Develop similar applications for any type of business - see full list of NAICS/type of business categories. This section is focused on Census-sourced County Business Patterns released April 2016. There are additional data resources that can be used in a similar manner - more below.
This section updates with ZIP Code business patterns 2014 data in May 2016. Follow the Data Analytics Blog to receive automatic updates.
This section provides "getting started" instructions. The narrative provides an overview and steps to install the software and data. See the related Business Analytics Section for information on use of tools and methods not reviewed here.
Patterns of Supermarket Establishments by County
The supermarkets industry (NAICS 445100) is used here as an example. Data are tabulated for more than 2,000 industry categories; applications shown here could be for any industry code/type of business. The following graphic shows patterns of the number of supermarket establishments by county for the Houston metro (bold boundary) region. Counties are labeled with the number of supermarkets and county name. Number of supermarkets shown by intervals/colors as depicted in legend panel at left of map window. Create custom maps similar to this view for your regions of interest depicting establishments, employment or payroll for your type of business selection(s). Click graphic for larger view with more detail; expand browser window for best quality view.
View developed with CV XE GIS software using the US1_CBP14 GIS project.
These applications use the CV XE GIS software.
The no fee version may be used with the basic CBP14 GIS project (make variations the view shown above).
The custom database extract & shapefile integration operations require CV XE GIS Basic or Pro version.
To access all CBP14-related features, re-install CV XE GIS if installed version dated before 4/27/16.
Expand the business patterns zip file to folder c:\cvxe\1\
requires User Group userid. Join here.
.. us1_cbp14.gis GIS project file used to develop above map view
.. U.S. by county 2014 County Business Patterns dataset (cbp14.dbf) (view structure)
.. U.S. by county 2013 County Business Patterns dataset (cbp13.dbf) (same structure as above)
.. NAICS codes file (naicscbp.dbf)
.. U.S. by county shapefile (cb_2015_us_county_500k_cbp14.*) with integrated NAICS 445100 CBP14 data
.. U.S. by county reference file (tl_2015_us_county_cbp.dbf)
Support using these Resources
Participate in the weekly Data Analytics Lab sessions (Tuesdays, 3:00 pm ET) where we review demographic-economic characteristics and patterns for wide-ranging geography and updates/extensions to data provided here. No fee, no registration, see connectivity details.
These data are authorized for personal, non-business, use and may not be redistributed nor used to provide professional advice. There is no warranty of any type associated with any aspect of these data. The user is solely responsible to any use, direct or indirect, that might be made of the data.
Creating Custom Extracts & Geospatial Analyses
To create a custom CBP 2014 extract & integrate into U.S. by county shapefile proceed as follows
Complete Getting Started steps above.
For your first time through the process, use NAICS code 722511 Full Service Restaurants.
The file c:\cvxe\1\cb_2015_us_county_500k_cbp14.dbf must not be in use by another application.
The file c:\cvxe\1\cbp14.dbf must not be in use by another application.
Start CV XE GIS; use the default project; make no changes to the project
.. if you encountered an error in a previous operation; close CV XE GIS and re-open
Choose Database>DBMerge operation.
Open File 1 as the file c:\cvxe\1\cb_2015_us_county_500k_cbp14.dbf.
Open File 2 as the file c:\cvxe\1\cbp14.dbf.
In the Filter edit box (at bottom of form) enter the filter criteria.
.. an example for supermarkets, is
.. total establishments filter is
.. the number of NAICS code characters in 6.
.. NAICS 62 (summary for this 2 digit level) is
.. NAICS 621 (summary for this 3 digit level) is
Click Create button at top of form.
For File 1, select items - multi-select as a group (items highlight blue) STATEFP through CHG1015P.
.. click Move Selected button under Source File 1 item list
For File 2, select items - click Select All button.
.. click Move Selected button under Source File 2 item list
Enter Key1 code -- always
Enter Key2 code -- always
Verify above steps then click Merge button at top of form.
.. merge process might require 5-10 minutes .. depending on several factors.
.. watch progress bar in lower right section of CVXE window ... wait for completion message. Respond Yes or OK to any prompts displayed.
dBMerge form ready to start merge for NAICS code 722511 Full Service Restaurants.
Start using updated U.S. by county shapefile/dataset.
Shapefile c:\cvxe\1\cb_2015_us_county_500k_cbp14.shp has been repopulated with items selected above.
.. about the updated shapefile ...
.. the shapefile dbf has been permanently modified but it can be re-used.
.. the same number of county records (all counties) remain in the file as before.
.. the same set of fields in the "front of the record" (STATEFP through CHG1015P.) remain as before.
.. only the CBP fields and field valuses are replaced.
Start CV XE GIS; File>Open>Dialog US1_CBP14.GIS project.
The map view now displays the establishments for the NAICS code selected (instead of supermarkets/445100)
The layer editor might need to be used to adjust the establishments intervals.
The start-up view using the updated/re-populated county shapefile ...
In the following view ... .. the layer description has not been modified
the layer editor can be used to modify the name and interval values.
.. the identify tool ahs been used to display a mini-profile for Harris County.
the NAICS code shows as restaurants (722511); there are 2,676 full service restaurants in Harris County, TX.
Supermarket Business Characteristics by County Interactive Table
Click ShowAll button between Find/Queries.
Click column header cell to sort table on that column; click again to sort other direction.
Use mouseover on column header to view column description.
See usage notes below table. See demographic-economic interactive tables.
Click ShowAll between queries/filters.
Click a column header to sort on that column; click again to sort other direction.
.. select a state to have the table refresh with rows for only that state.
.. enter a partial case-sensitive county name in the edit box to right of Find-in-Name button.
.. click to Find-in-Name button to show only rows with that text in the county name (column 1).
.. enter an exact 5-character CBSA code in the edit box to right of Find-in-CBSA button.
.. click to Find-in-CBSA button to show only rows with that text in the CBSA code (column 4).
.. the default code 12060 is the Atlanta CBSA code.
Population 2014 Min & Max> button
.. click to show only peer group counties based on values
.. the ShowAll button must be clicked before using this feature.
.. in min and max edit boxes ...
... enter the minimum 2014 population in the left edit box.
... enter the maximum 2014 population in the right edit box.
.. click Population 2014 Min & Max button to view CHCs in peer group.
Click ShowAll between queries/filters.
Items in Table
- County Name
- State USPS
- StCty FIPS code
- CBSA code/metro
Population item from Census official estimates; provided for reference.
- Population 2014
Remaining items from County Business Patterns 2014
- Employment Flag
- Employment Noise Flag
- Employment 2014
- Quarterly Payroll Noise Flag
- Quarterly Payroll - March 2014
- Annual Payroll Noise Flag
- Annual Payroll 2014
- Establishments 2014
View flag values & additional details)
Business Patterns Data: Alternative Geography, Time Periods, Subject Matter
ProximityOne Business Establishments Estimates & Projections to 2020
Quarterly Establishments, Employment & Earnings
ZIP Code Business Patterns
ZIP Code Retail Trade Establishments & Sales - 2012 Economic Census
Support Using these Resources
Learn more about demographic economic data and related analytical tools. Join us in the Data Analytics Lab sessions. There is no fee for these Web sessions. Each informal session is focused on a specific topic. The open structure also provides for Q&A and discussion of application issues of interest to participants.
ProximityOne User Group
Join the ProximityOne User Group to keep up-to-date with new developments relating to geographic-demographic-economic decision-making information resources. Receive updates and access to tools and resources available only to members. Use this form to join the User Group.
ProximityOne develops geographic-demographic-economic data and analytical tools and helps organizations knit together and use diverse data in a decision-making and analytical framework. We develop custom demographic/economic estimates and projections, develop geographic and geocoded address files, and assist with impact and geospatial analyses. Wide-ranging organizations use our software, data and methodologies to analyze their own data integrated with other data. Follow ProximityOne on Twitter at www.twitter.com/proximityone. Contact ProximityOne (888-364-7656) with questions about data covered in this section or to discuss custom estimates, projections or analyses for your areas of interest.