Tag Archives: business establishments

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 in this related section 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 reviewed in main Web section.

Patterns of Supermarket Establishments by County
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 GIS project.

See full Web section to access data, tools and more detail.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Retail Trade Sales by ZIP Code

.. what is the meaning of few or no retail stores with sales over $1 million in a neighborhood or ZIP code? Residential tranquility might be accompanied by limited shopping conveniences. What about adjacent ZIP codes? Absence of larger retail stores suggests lower economic activity. ZIP code 89109 in Las Vegas has 478 retail establishments with sales over $1 million — the largest among all ZIP codes. There are more than 4,700 ZIP codes with no (and more than 10,200 with 1 or none) retail establishments with sales over $1 million. See the interactive table below to examine each/all ZIP codes. Use data and tools reviewed in this section to analyze retail sales patterns by ZIP code. See more detail in related Web section.

Patterns of Retail Trade by ZIP Code
The following map graphic shows patterns of retail trade establishments in Texas and adjacent states with more than $1 million in annual sales by ZIP code. Four Texas metros (Austin, Dallas, Houston, San Antonio) are highlighted with bold boundary. Click graphic for national scope, larger view. Expand browser window for best quality view.

– View developed using CV XE GIS and related GIS project.

As of 2012, there were 30,177 ZIP codes with more than 1.06 million retail trade business establishments. Of these, almost 500,000 establishments had more than $1 million in annual sales. Find out which ZIP codes and the characteristics of businesses in those ZIP codes using tools reviewed here. These are the most recent establishment sales data by ZIP code. They are not available from other national scope sources.

These data supplement the annual ZIP code business patterns data that provide data on the number of establishments, employment and payroll by type of business (NAICS codes) — but provide no data on sales. This section provides interactive access to the retail trade establishments by sales group for all ZIP codes. This section illustrates how these data can be used in GIS applications to examines patterns and associate these with other data. ZIP code and multi-ZIP code area profiles are also shown in this section. Examine market characteristics using profiles from ProximityOne for any combination of ZIP oode areas. ProximityOne uses the sales data to develop custom estimates of retail trade characteristics by additional categories linked with data from other sources.

Examining Retail Trade by Individual ZIP Codes and ZIP Code Groups
The following graphic shows ZIP codes (ZIP code shown by yellow label) in the New York city area. The total number of retail establishments (white label) and the number of retail establishments with annual sales in excess of $1 million (blue label). These ZIP codes are used in profile reviewed below. The interactive table below can be used to show that ZIP code 10036 is among the ZIP codes having the largest number of retail establishments in the U.S.

– View developed using CV XE GIS and related GIS project.

ZIP Code 10036 Retail Trade Establishments & Sales Profiles
View ZIP Code 10036 Retail Trade Establishments & Sales Profile
ZIP Code 10036 Group Supermarket Establishments & Sales Profile

Interactive Table
Use the interactive table in this related section to view, query, rank, compare characteristics of retail trade establishments by ZIP code.

The following graphic illustrates use of the interactive table. All ZIP codes are ranked in descending order based on total retail trade establishments. Click graphic for larger view. ZIP code 10013 in New York city has the largest number of retail establishments.

Use the interactive table to examine ZIP codes and establishment patterns of interest.

Retail Trade Business Categories
• Motor Vehicle and Parts Dealers: NAICS 441
• Furniture & Home Furnishings Stores: NAICS 442
• Electronics & Appliance Stores: NAICS 443
• Building Material & Garden Equipment & Supplies: NAICS 444
• Food & Beverage Stores: NAICS 445
• Health & Personal Care Stores: NAICS 446
• Gasoline Stations: NAICS 447
• Clothing & Clothing Accessories Stores: NAICS 448
• Sporting Goods, Hobby, Book & Music Stores: NAICS 451

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Analyzing Business Establishment Change by County/ZIP & Industry

.. Harris County, TX (Houston) gained 1,658 business establishments between 2012 and 2013. How did the number and characteristics of business establishments in your counties or region of interest change? These data are available by county (and ZIP code) and can be used to determine which counties (ZIP codes) are experiencing business growth or decline and by how much. See more about this topic in the related Web section.

These data are based on a annual count of business establishments by physical location that have at least one paid employee. A single company may have multiple business establishments. Attributes of individual establishments, including payroll and employment, are summarized/aggregated by county and ZIP code area. The establishment data are also summarized by the NAICS type of business code. See more about these data.

Examine a specific industry such as construction. Among all counties, Harris County, TX had the highest 2013 employment in the construction industry (see more below). Where do your counties/ZIP code areas rank (in this or any other industry)?

The following views illustrate how Geographic Information System (GIS) tools can be used to visually examine change in business patterns. Use the CV XE GIS and associated GIS project to examine establishments, payroll and employment by detailed type of business. These applications shown change for one year; choose a different set of years. Integrate your own data such as market territories or customer/prospect data to examine how business opportunities match up with existing and changing patterns.

Change in Business Establishments, 2012-2013 — Texas by County
The following graphic shows the change in the number of business establishments by county in Texas and adjacent areas. Metros are shown with bold black outlines. Color patterns show change in the number of establishments between 2012 and 2013. It is easy to see which counties have business establishment growth (blue/green) or decline (orange/red). Use the GIS resources to develop similar business patterns views for any state/area in the U.S. The legend at left of map (click graphic for larger view with legend) shows establishment change intervals by color.

  — view created using CV XE GIS and associated GIS Project
— click graphic for larger view showing details.

Change in Business Establishments, 2012-2013 — Houston Area
The following graphic shows the change in the number of business establishments by county with a zoom-in view of the Houston area. Use the GIS resources to zoom in to any county/region of the U.S. The legend at left of map (click graphic for larger view with legend) shows establishment change intervals by color. Counties are labeled with county name and percent change in the number of establishments between 2012 and 2013.

  — view created using CV XE GIS and associated GIS Project
— click graphic for larger view showing details.

Profile of County Business Establishment Change
The following table shows a basic overview of the change. There is much more detail available. The GIS project enables mixing demographic with economic and business data.

Database Queries:
Counties with Highest Employment in Construction Industry
Consider a requirement to determine the list of 10 counties having the highest employment in the construction industry. The 2.1 million record database with county by type of business is opened with the CV XE GIS dBrowse operation/feature. Note that this database size exceeds the Excel limit. A query is placed on the database to show on NAICS (type of business) code “23—-” having number of 2013 employment of 10,000 or more. The query could have been any NAICS code in combination with another attribute or none. The table is then sorted in descending order on 2013 employment (by clicking the sort button). The resulting records/counties are displayed as shown. The county FIPS code 201 in state FIPS code 48 (Harris County) has the highest total construction industry employment in the U.S. It is easy to see the other top 10 (or some group) that are also highly ranked. The Count operation is used to shown how many counties meet this criteria; there are 118. Other selected attributes are shown in the table/graphic. This selection could optionally be exported to a file in a different format (e.g., CSV).

An upcoming section will review linking business establishment data with demographic data.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data.