CV XE GIS Home Page




  ProximityOne Home

  Situation & Outlook

  Related Sections
  - Applications Gallery
  - States
  - School Districts
  - Metros
  - Cong. Districts
  - Counties
  - Tracts/Neighborhoods
  - Block Groups
  - Census Blocks
  - ZIP Codes
  - Urban Areas

  Estimates-Projections
  - 2060 Demographic
    ... all county interactive table
  - 2030 Demographic-Economic
  - Single Year of Age

  GIS Thematic Mapping
    Visual Analysis Tools

  Ranking Tables
    National Scope
    Demographic Change
    2000-2010
  - States
  - Metros
  - Cong. Districts
  - School Districts
  - Counties
  - Cities/Places
  - Census Tracts


 
Decision-Making Information
  ProximityOne
  information resources & solutions
  (888) DMI-SOLN
  (888) 364-7656




Visual analysis with ProximityOne tools
click graphic for info; hover to pause

 
visually analyze clients/markets
site analysis using 1 mile radius

S1

$median household income
patterns by census tract - Houston

hover to pause

113th Congressional Districts

Click for info

US Asian Indian population 2010

Click for info

geocoded students and school
McKinney ISD, TX

Click for info

geocoded students and school
with tax parcels & streets

Click for info

high school attendance zones
with schools by type

Click for info

%high school graduates by
census tract - Puerto Rico

Click for info

Austin, TX MSA counties &
places 10K+ population markers

Click for info

Appalachia counties (green) &
coalfield counties (orange)

Click for info

China provinces percent urban &
cities (markers) by state plan

Click for info

Honolulu census tracts (red)
& census blocks


Central Park area NYC

Click for info

Kansas City Metro & Counties
Home Depot locations (markers)

Click for info

World Cities; focus on Spain

Click for info


Data Analytics Blog
Power of Combining Maps with Data

Support & Technical Assistance
help using these resources


 
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.

Getting Started
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.
  • contains:
    .. 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.

Terms of Use
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 (without point brackets).
    .. total establishments filter is (without point brackets).
    .. the number of NAICS code characters in 6.
    .. NAICS 62 (summary for this 2 digit level) is (without point brackets).
    .. NAICS 621 (summary for this 3 digit level) is (without point brackets).
  • 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 for this set of data (without point brackets).
  • Enter Key2 code -- always for this set of data (without point brackets).
  • 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.


Usage Notes
  • Click ShowAll between queries/filters.
  • Click a column header to sort on that column; click again to sort other direction.
  • State button
    .. select a state to have the table refresh with rows for only that state.
  • Find-in-Name button
    .. 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).
  • Find-in-CBSA button
    .. 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.

Additional Information
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.

Copyright © . ProximityOne. All Rights Reserved.
Sitemap | Contact Us | News