Category Archives: NC Mecklenburg County

Using ACS County Data

… we are always seeking the most current data for areas of interest. This section provides an update on accessing unpublished ACS 1-year data for many counties.  Learn about how you can access ACS 1-year estimates for 85 counties for which Census released only as 5-year estimates … and why it matters. See the corresponding full Web section.

Data are tabulated from the Census Bureau American Community Survey (ACS) as 1-year estimates (for areas with population 65,000 and over) and as 5-year estimates (for areas under 65,000 population). See more about ACS 1-year versus 5-year estimates in this section.

ACS 2014 1-year tabulation areas, as released by the Census Bureau included 817 of 3142 counties and 508 of 917 metros/CBSAs. There are 85 counties for which ACS 2914 1-year estimates were not released by Census but are derivable by subtracting the aggregate county components from metro totals in selected metros.

County & Metro ACS 2014 1-year Estimates
The following graphic shows Texas and adjacent areas:
• ACS 2014 1-year estimates metros with bold brown boundaries
• Counties for which ACS 2014 1-year data were tabulated and released (green).
• Counties for which ACS 2014 1-year data are derivable but not released as tabulation areas (blue).

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

The next view shows a zoom-in to the Austin, TX metro. The four green shaded counties had ACS 2014 1-year estimates tabulated and released. The fifth Austin metro county, Caldwell shaded blue, was not tabulated but the ACS 1-year data are derivable by subtracting the sum of the four counties from the metro totals. Tabulated data for Caldwell was released only as ACS 2014 5-year estimates. A similar situation exists in many metros across the country.

Why this Matters
There are 85 counties for which ACS 2014 1 year data are available but not released/made available by Census as separately tabulated areas. This is important due to these considerations:
• these are true annual estimates (as opposed to the other 5-year estimated counties)
• they are more recent that 5-year estimates
• they reflect conditions centric to one year
• they enable time series/trend analysis
• [as it turns out] they enable access to 1 year estimates for all counties (instead of some) in some metros

Using API Tools to Examine these Data
Create CSV-like files by clicking these links. When a link is clicked a new page will show the ACS 2014 1-year estimates tabulations areas. The area name, code and ACS 2014 1-year total population estimate is shown.
Click to retrieve county data
Click to retrieve metro data

Items used in these API calls:
.. B01001_001E – Total population
.. B19013_001E – Median household income ($)
.. B19113_001E – Median family income ($)
.. B19301_001E – Per capita income

Create/derive these data on your own; learn about which counties are derivable …

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.

 

Census Tract-City Relationship Table

.. what census tracts are located in cities of interest? What are their codes? Conversely, do you have census tract codes and need to know corresponding city(s)? Get answers here.

This section provides access to an interactive table useful to examine relationships among Census 2010 census tracts, cities/places, and counties. Many cities and counties that might be experiencing demographic-economic decline will often have bright spots that are groups of a few or many census tracts. Census tracts are important sub-county geography in data analytics. See the related section on census data analytics. See more about census tracts and data analytics below in this section.

Relating Census Tracts to Cities & Counties
Census tracts are sub-county areas and nest coterminously within counties. The 6-character tract code is unique within county. For cities 10,000 and larger, there are some number of whole census tracts within the city. But around the perimeter of cities, census tracts will often be partly within and partly outside of the city. The following graphic shows the relationship of tracts, cities and counties in the Plano city area (green fill pattern) located mostly in Collin County within the Dallas metro. Click graphic for larger view, more detail and legend color/data intervals. This map illustrates the geographic level of detail available using census tract demographics and the relative ease to gain insights using geospatial data analytics tools.

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

Using the Interactive Relationship Table
A small part of Plano is located in Denton county (see north-south bold red-brown boundary). Tract 021627 (see pointer) is located in Denton County and includes a part of Plano. To determine what geography tract 021627 intersects, click the Tract> button below the interactive table shown below. See that the tract is contained in parts of 4 cities.

Census Tract to City/Place & County Equivalence Table
The following graphic illustrates use of the interactive table to view/examine the relationship between census tract 48121021627 (in Denton County, TX) and the city of Plano, TX. Click graphic for larger view.

The above view was developed using the interactive table:
– click the ShowAll button
– click the FindTract button (preset to locate this tract).

Click the ShowAll button and enter a city/place (case-sensitive) name of interest to view the set of intersecting tracts. See the table usage notes below the table in the related Web page. We review operation of the table in the Data Analytics Web sessions.

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.

State and Regional Decision-Making Information

Organized on a state-by-state basis, use tools and geographic, demographic and economic data resources in these sections to facilitate planning and analysis. Updated frequently, these sections provide a unique means to access to multi-sourced data to develop insights into patterns, characteristics and trends on wide-ranging issues. Bookmark the related main Web page; keep up-to-date.

Using these Resources
Knowing “where we are” and “how things have changed” are key factors in knowing about the where, when and how of future change — and how that change might impact you. There are many sources of this knowledge. Often the required data do not knit together in an ideal manner. Key data are available for different types of geography, become available at different points in time and are often not the perfect subject matter. These sections provide access to relevant data and a means to consume the data more effectively than might otherwise be possible. Use these data, tools and resources in combination with other data to perform wide-ranging data analytics. See examples.

Select a State/Area

Alabama
Alaska
Arizona
Arkansas
California
Colorado
Connecticut
Delaware
D.C.
Florida
Georgia
Hawaii
Idaho
Illinois
Indiana
Iowa
Kansas
Kentucky
Louisiana
Maine
Maryland
Massachusetts
Michigan
Minnesota
Mississippi
Missouri
Montana
Nebraska
Nevada
New Hampshire
New Jersey
New Mexico
New York
North Carolina
North Dakota
Ohio
Oklahoma
Oregon
Pennsylvania
Rhode Island
South Carolina
South Dakota
Tennessee
Texas
Utah
Vermont
Virginia
Washington
West Virginia
Wisconsin
Wyoming

Topics for each State — with drill-down to census block
Visual pattern analysis tools … using GIS resources
Digital Map Database
Situation & Outlook
Metropolitan Areas
Congressional Districts
Counties
Cities/Places
Census Tracts
ZIP Code Areas
K-12 Education, Schools & School Districts
Block Groups
Census Blocks

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

Metro Situation & Outlook Reports Updated

.. how are metros of interest changing? The Metro Situation & Outlook Reports provide the premier integrated, multi-sourced demographic-economic overview for individual metropolitan areas.

Largest 25 Metros Based on 2015 Population
Click graphic for larger view with names. Expand browser window for best view. Label shows metro rank among all 917 metros based on 2015 population.

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

The no fee report for each metro was updated today with the annually updated population and population components of change. Use this interactive table to view, query, rank metros. Examine total population annually 2010 to 2015 and rankings.

Click on a link in the interactive table to view the integrated, multi-sourced demographic-economic Situation & Outlook report for that metro. See this example for the Charlotte-Concord-Gastonia, NC-SC MSA. The metro report provides drill-down demographic-economic attributes of metro component areas including counties, cities and school districts.

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.

Patterns of Neighborhood Change

.. economic progress since the 2008 recession has been mixed by geographic area.  Data from the new 2013 American Community Survey (ACS) provide insights into the characteristics of change at the neighborhood and higher geographic levels. The map shown below illustrates how the median household income (MHI) has changed by census tract based on data from the new ACS 2013 5-year estimates (released December 2014) and data from the ACS 2011 5-year estimates (released December 2012). While there is limited insight into patterns of change in this specific map, it is clear that neighborhoods have changed in different ways.

Median Household Income Change, 2009-11 by Census Tract
… Washington DC area; based on change in ACS 5-year estimates

View developed with CV XE GIS. Click graphic for larger view.

Examine patterns of ACS 5 year median household income estimates for metropolitan areas of interest. Examples: Philadelphia .. St. Louis .. San Francisco. Select any metro by clicking link in menu section on any metro profile page.

Using the New ACS 2013 5-year Estimates
This section is about using the new ACS 2013 5-year estimates released December 4, 2014. There are several things to like about the new ACS 2013 5-year demographic-economic data. These data are one year more recent data than released in December 2013 (the ACS 2012 5-year data). As a result, they provide an updated and more current picture. Two, this is a fourth year sequel to having Census 2010 vintage census tract and block group data available. This de facto four year mini-time series enables a start to examine trends. Three, these estimates are centric to mid-2011 and thus roughly update what would have been “richer demographics” from Census 2010 (had the long-form not been eliminated). These data provide unique and powerful measures that facilitate development of decision-making information.

Analyzing Change Using ACS Small Area Data
ACS small area data are available for block groups (averaging 1,200 population) and census tracts (averaging 4,000 population) covering the U.S. wall-to-wall. Census tracts are comprised of one or more blocks groups; block groups nest within census tract boundaries.

ACS data are estimates based on a sample survey. Based on our experience the quality of the estimates is quite good, but caution should be used. In general, the smaller the geographic area, the higher the margin of error associated with the estimate. The true value of the estimate might be higher or lower by some margin. Second, the 5-year estimates are based on a sample survey conducted over a 5-year period. The ACS 2013 5-year estimates are based on a survey conducted from 2009 through 2013. We might refer to the estimates being “centric to 2011” (the midpoint), but in fact they are estimates for the 5 year period. Caution should be used in examining change based on the 5-year annual estimates.

Resources to Access, Integrate & Use ACS Data
Census 2010 and ACS 2013 provide the most current Census-sourced demographics for wide-ranging geography. ProximityOne uses the ACS data for continuing analyses and the development of annually updated 5-year projections. There are a wide range of resources to assist users with ACS data access, integration & analysis. Some of these are summarized via the links provided below.

Webinars
Reference & Documentation
Updates & Applications
Data Resources
Data Access/Integration Tools

Support Using these Resources
The map shown at the top of this section was developed using tools listed in above links. The map view is based on a GIS project that we developed to enable analysis for the U.S. by census tract. Zoom-in to any county or regional to examine patterns and characteristics using the GIS project.

Learn more about developing and using this type of GIS project and associated demographic economic data and related analytical tools. Join us in a Decision-Making Information Web session. There is no fee for these one-hour 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.

County Population Projections 2020

.. examining county demographic trends 2010-2020: population estimates & projections by age in structured profiles.

Find out about the recent past and expected future demographic trends and patterns in your county(s) of interest. Examine the distribution of the population by 5 year age cohort, other age groups and by year.

This section reviews how you can access and use ProximityOne national scope county annual demographic estimates and projections for the period 2010 through 2020. These estimates and projections are a part of the ProximityOne Situation & Outlook program. Estimates and projections are developed using county simultaneous equation models. See methodology.

Visual Trend Analysis
The graphic below shows projected population change 2010 to 2020 by county for the south central U.S. Use CV XE GIS with ready-to-use GIS project for collaboration and visual analysis.

Click graphic for larger view of U.S. with color legend details.

User Group Access
Members of the ProximityOne User Group may access any of the total population county level profiles shown in the interactive table in the corresponding Outlook 2020 web section.  Join the User Group now, there is no fee.

Sample County Profile
The graphic shown below illustrates the projections profile structure for Jackson County, MO. Descriptive stubs at left show the age group. Columns show the estimates and projections (only a few columns appear in the graphic).

Related Demographic-Economic Projections
More about ProximityOne demographic-economic estimates and projections:
• Outlook 2018 | Outlook 2030 | Outlook 2060 | Quarterly 3 year
• integrated multi-sourced Situation & Outlook demographic-economic data

County Demographic Estimates & Projections Interactive Table
The graphic shown below illustrates structure/use of the interactive table. Click graphic to open the table (http://proximityone.com/outlook2020.htm). Navigate to a county of interest in the table. Clicking a link shown in the table opens a new page showing demographic patterns and trends for that county. All links require a userid and password. Members of the ProximityOne User Group may use their userid and password to view the Total population profile. Access to other profiles is available on a fee basis.

Terms of Use. Estimates and projections described in this section and in related files are proprietary to ProximityOne. The data may be used in any manner without further authorization except that the data may not be redistributed. There is no warranty or guarantee of any type. The user is solely responsible for any use.

Support & DMI Web Sessions
Learn more about using resources described in this section. Join us in a Decision-Making Information Web session. 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. We can address your specific questions about using demographic economic data and related applications.