Analyzing County Business Patterns by Type of Business
April 2018. .. 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 2018. There are additional data resources that can be used in a similar manner - more below.
This section updates with ZIP Code business patterns 2016 data in May 2018. 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_CBP16 GIS project.
These applications use the CV XE GIS software.
The no fee version may be used with the basic CBP16 GIS project (make variations the view shown above).
The custom database extract & shapefile integration operations require CV XE GIS Basic or Pro version.
Expand the business patterns zip file to folder c:\cvxe\1\
requires User Group userid. Join here.
.. us1_cbp16.gis GIS project file used to develop above map view
.. NAICS codes file (naicscbp.dbf)
.. U.S. by county shapefile (cb_2015_us_county_500k_cbp16.*) with integrated NAICS 445100 CBP16 data
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 services. 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.
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 2016 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 2016 population in the left edit box.
... enter the maximum 2016 population in the right edit box.
.. click Population 2016 Min & Max button to view 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 2016
- Population 2017
Remaining items from County Business Patterns 2014
- Employment Flag
- Employment Noise Flag
- Employment 2016
- Quarterly Payroll Noise Flag
- Quarterly Payroll - March 2016
- Annual Payroll Noise Flag
- Annual Payroll 2016
- Establishments 2016
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.