Category Archives: ZIP Business Patterns

Accessing & Using ZIP Code Demographics

.. tip of the day .. a continuing weekly or more frequent tip on developing, integrating, accessing and using geographic, demographic, economic and statistical data. Join in .. tip of the day posts are added to the Data Analytics Blog on an irregular basis, normally weekly. Follow the blog to receive updates as they occur.

… February 2017 updates .. 5 ways to access/analyze the most recent estimates of median housing value and other subject matter by ZIP Code area .. updates on accessing/downloading/using American Community Survey (ACS1115) 5-year estimates. See more detail in related Web section.

Site analysis (Option 5 below)
– create site analysis profiles from a location/ZIP code.

Contents
Five data access and use options, listed in the links below, are reviewed. Each method illustrates how ZIP code demographic-economic data can be accessed/ analyzed/used in different contexts. The most basic data access/data download is illustrated in Option 3. The following links open new windows that take you to the related section with more detail.
Option 1 – View the data as a thematic pattern map.
Option 2 – View, compare, rank query data in interactive tables.
Option 3 – Access data using API Tools; create datasets.
.. Option 3a – Extended ZIP Code subject matter access.
.. Option 3b – ZIP code urban/rural data access.
.. Option 3c – Additional API ACS data access resources.
Option 4 – View $MHI in structured profile in context of related data.
Option 5 – Site analysis – view circular area profile from a location.

Related ZIP Code Data Access & Use sections
Interactive access to demographics based on an address
Summary of ZIP Code Data Resources & Tools
10 Reasons to use Census Tracts Versus ZIP Codes
Analyzing Census Tract Demographics by ZIP Code Area
ZIP Code to Census Tract Equivalence Table
ZIP Code Urban/Rural Geography & Demographics
Mapping ZIP Code Demograhics
Housing Price Index by 5-digit ZIP Code – time series; annual updates
Housing Price Index by 3-digit ZIP Code – time series; quarterly updates
ZIP Code Business Establishment, Employment & Earnings by industry
ZIP Code Retail Trade Establishment & Sales by industry
ZIP Code Equivalence Tables — ZIP Code to School District

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.

Housing Price Index by 5-Digit ZIP Code

.. tools to examine housing prices by 5-digit ZIP code and how they are changing .. of the 17,931 5-digit ZIP codes tabulated, 8,074 experienced a decrease in housing value during the period 2010 to 2015. At the same time, 8,672 ZIP code areas experienced an increase in housing value. Housing prices increased for most ZIP codes from 2014 to 2014.  Find out more about housing prices and trends for ZIP codes of interest using tools described here. These data are based on experimental estimates of the Housing Price Index (HPI) by 5-digit ZIP code based in part on home sales price data from Fannie Mae- and Freddie Mac-acquired mortgages. See more about these data.

• Use the interactive table to view, rank, compare the HPI for all 5-digit ZIP code areas tabulated.
• Use GIS tools described here to develop thematic pattern maps; add your own data & geography, select different HPI measures or criteria; zoom to different geographic extents, label and modify colors as desired.

Gaining Insights in Housing Prices, Conditions & Markets
  .. Characteristics, Patterns & Trends
  .. join in .. one hour web session — overview & connectivity details

Patterns of Housing Value Change by ZIP Code: 2010-15
The following graphic shows patterns of housing value appreciation by ZIP Code: 2010-15 for the Houston metro (bold brown boundary). The color patterns/intervals are shown in the inset legend. Data are not available, using the criteria applied (2000 base year), for areas not colored In the larger view (click graphic), ZIP codes are labeled with HPI percent change from 2010 to 2015. Click graphic for larger view. Expand browser to full window for best quality view. Use the GIS tools described here to develop thematic pattern maps for a range of data and criteria.

.. view developed using the CV XE GIS software.
.. click map for larger view and details.

Additional views:
Atlanta area
New York City area
Washington, DC area
Los Angeles area

Examining Recent Trends; Current Estimates & Projections
The interactive table presents annual HPI data 2010 through 2015. A much larger set of these ZIP codes show a negative change between 2010 and 2015 compared to the one year change 2014-2015; The data generally show more ZIP codes experiencing housing value appreciation 2014-2015 compared to the longer period 2010 to 2015. These trends underscore the importance of having more recent data for use in analysis, planning and decision-making. The next update based on transaction data will be May 2017 or later.

ProximityOne uses the HPI transaction data with other data to develop HPI current estimates (2016) and annual projections to 2021 with quarterly updates as a part of the Regional Demographic-Economic Modeling System (RDEMS). Experimental county-up (metro, state, U.S.) and sub-county estimates and projections are planned for the fall 2016 quarterly update. The model based estimates and projections include the number of units by type and value that are added to the housing stock used to compute a variation of the HPI.

Housing Price Index by 5-Digit ZIP Code: 2010-2015
  — Interactive Table
Use the interactive table to examine the Housing Price Index (HPI) by 5-digit ZIP code. The following graphic illustrates use of the table to show the 10 ZIP codes experiencing the largest percentage increase in the HPI from 2014 to 2015. Click graphic for larger view. Examine cities or ZIP code ranges of interest using tools below the table.

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.

Business Establishment Characteristics by ZIP Code

.. among all approximate 38,800 ZIP codes in the U.S. with business establishments, ZIP Code 10001 has more than 7,200 establishments. 9 of the top 10 ZIP codes, ranked on total number of business establishments, are located in Manhattan (New York County, NY); the 10th largest in Miami. Use the interactive table to examine ZIP code business establishment characteristics of interest.

Business establishments are the places of employment that drive and characterize the economy. ZIP codes are the smallest geography for which business establishment data are available. ZIP code business patterns data can help stakeholders identify areas of employment, business opportunities and more. While we can obtain employment data (by place of residence) for ZIP code areas from the American Community Survey 5-year estimates (ACS), the number of establishments and employment by place of work are only available from the ZIP business patterns data. See related Web section.

Use tools described in this section to analyze patterns and characteristics of ZIP code business patterns. The interactive table provides data on the characteristics of business establishments for 2012 and 2013 by ZIP code. Use the GIS tools and related GIS project to develop variations of the views shown below.

Establishments by ZIP Code in Los Angeles Area
– number of establishments; click graphic for larger view

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

Employment by ZIP Code in Los Angeles Area
– employment by place of work for all ZBP establishments

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

Using the Interactive Table
Use the interactive table in this related section to view, query, rank, compare business establishment characteristics among a set of ZIP codes or for a specific ZIP code.

The following graphic illustrates use of the interactive table; click graphic for larger view. This view shows ZIP codes in the 3-digit ZIP code group 950 in the Silicon Valley area ranked in descending order on number of 2013 establishments. Note that Cupertino 95014 (Apple Computer HQ location) has the 4th largest number of 2013 establishments among all 950 3-digit ZIP codes.

Try it yourself:
Click the ShowAll button below Table
– Key in a 3-digit ZIP to right of Find ZIP3> button.
– Click Find ZIP3> button.
– Click Estab 2013 button to sort the ZIP code.

Weekly Data Analytics Lab Sessions
Join me in a Data Analytics Lab session to discuss more details about using these data in context of data analytics with other geography and other subject matter.  Learn more about integrating these data with other geography, your data and use of data analytics that apply to your situation.

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.