Category Archives: Cities

Examining Houston Metro Demographic-Economic Characteristics

.. tools & data to examine metro demographic-economic characteristics .. this Houston, TX metro focused section is one of several similar metro sections that will be covered in weeks ahead.  Each metro-focused section provides a summary of tools and data that can be used to view, rank, compare, analyze conditions and trends within the metro and this metro relative to other metros, regions and the Nation.  The ready-to-use GIS project/datasets provide the basis for extended data/geographic views and analysis immediately.  See more detail about topics covered in this related Web section.

Relating your data to demographic-economic characteristics and trends in a region involves more than information provided by a report or set of statistical tables. It is important to use your data to be able to identify areas of missed opportunity and competitive position. It is important to have a “10,000 foot” view as well as understanding individual neighborhoods and market/service areas. Geographic Information System (GIS) tools, with the right set of geographic, demographic and economic data can facilitate decision-making through the use of visual and tabular data analytics.

This section provides information on installing and using the Houston Metro Demographic-Economic GIS software and project/datasets. This same scope of data, tools and operation is available for any metro, state or combination.

10,000 Foot View
The following graphic shows patterns of median household income by census tract for the Houston metro area. This is the start-up view when using the GIS tools and data described below. The color patterns/intervals are shown in the highlighted layer in legend at left of map window. Use the GIS tools described below to develop thematic pattern maps for a range of data and criteria.

.. view developed using the CVGIS software.

See more about census tracts; see tracts main page.

Several additional views follow, developed using this same GIS project. These views illustrate different levels of geographic granularity and patterns of different subject matter.

Median Household Value by Block Group
See more about block groups; see block groups main page.

.. view developed using the CVGIS software.

Population/Housing Unit by Block
See more about census blocks; see census block main page.

.. view developed using the CVGIS software.

Zoom-in to Sugarland/Fort Bend County
See more about cities/places; see cities/places main page.
Access data for any city using interactive table.

.. view developed using the CVGIS software.

Further Zoom-in Showing Street/Road Detail
See more about streets.

.. view developed using the CVGIS software.

Additional Information
See the related Houston metro Situation & Outlook Report.

Using the GIS Software and Project/Datasets
(requires Windows computer with Internet connection)
1. Install the ProximityOne CV XE GIS
… run the CV XE GIS installer
… requires UserID; take all defaults during installation
2. Download the Houston Metro GIS project fileset
… requires UserID; unzip Houston Metro GIS project files to local new folder c:\p1data
3. Open the c:\p1data\us1_metros_houston.gis project
… after completing the above steps, click File>Open>Dialog
… open the file named c:\p1data\us1_metros_houston.gis
4. Done. The start-up view is shown above.

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.

America’s Cities: Demographic-Economic Characteristics Annual Update

.. tools and data to interactively examine demographic-economic characteristics of America’s 29,321 cities/places .. understanding demographic-economic characteristics of cities and places is essential for business development, market analysis, planning, economic development, program management and general awareness of patterns and trends. This section provides access to data and tools to examine characteristics of all cities/places in the U.S. This annual update includes data for 29,321 cities/places based on ACS 2015 data.

Accessing the Data; Using Interactive Tables
Each of the four links below opens a new page providing access to U.S. by city/place interactive tables — by type of subject matter. Use tools and usage notes below table to select operations to perform queries, sort and select columns.
General Demographics
Social Characteristics
Economic Characteristics
Housing Characteristics

How the the Tables/Data Can be Used
The following table shows data derived from the Economic Characteristics table. The top 10 cities/places having the highest median household income ($MHI) are shown. The table also shows population, median family income ($MFI) and per capita income ($PCI). The $250,000 value is a cap; the actual value is $250,000 or higher. Use the interactive tables to create similar views for states of interest. Use the button below the table to select/view cities within a selected metro. Compare attributes of cities of interest to a peer group based on population size.

Visual Analysis of City/Place Population Patterns
Use GIS resources to visually examine city/place demographic-economic patterns. The following view shows patterns of population percent change by city in the Charlotte, NC-SC metro area.

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

Related Data
Cities/Places Main Section
Citie Population Estimates & Trends, 2010-15

More About Using These Data
Using ACS 1-year and 5-year data

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 ACS 2014 1-Year Supplemental Data

.. examining 2014 characteristics of areas with population 20,000 and over  .. this section summarizes how to use the America Community Survey (ACS2014) “supplemental” data (ACS2014S) to access more current estimates than otherwise available. The America Community Survey “supplemental” data are just that, a supplemental set of ACS 2014 1-year estimates — for areas 20,000 population and over. See the related Web section providing more detail.

The importance of the ACS 2014S data are two fold.
1 – 2014 1-year estimates for a larger number of areas than available from the ACS 2014 1-year (ACS2014) estimates.
2 – more current (2014) data for those areas only available from the 5-year estimates (centric to 2012) that are between 20,000 and 65,000 population.

The ten cities/places with the highest 2014 median family income based on 1-year estimates were all under 65,000 population. These cities were not included in the ACS 2014 1-year standard estimates but were included in the ACS 2014 1-year supplemental estimates. See list below.

This section provides an overview of the ACS 2014 supplemental data and provides a summary of tools, interactive table and GIS project, to analyze characteristics of these areas. These data are used by ProximityOne to develop/update annual county demographic-economic projections. See schedule of related 2016 updates.

Scope of Expanded Geography Available
As shown in the table below, 2014 1-year “supplemental” estimates are available for more than twice as many counties from the ACS2014S compared to the ACS2014 “standard” 1-year estimates. However, there area a more limited set of subject matter data available from the ACS2014S data compared to both the ACS 2014 1-year and 5-year estimates.

MSA/MISA: Metropolitan Statistical Areas/Micropolitan Statistical Areas Counties: county and county equivalent

ACS 2014S Data Availability by County
The following graphic shows the additional counties for which ACS 2014 1-year estimates are available using the “supplemental” data.
• ACS 2014 1-year “standard” estimate counties — blue fill pattern
• ACS 2014 1-year “supplemental” estimate counties — orange fill pattern
• Only ACS 2014 5-year estimates available for remaining counties
Click graphic for larger view; expand browser window for best quality view. The larger view shows metropolitan area (MSA) boundaries. Note that for example, ACS 2014 1 year data are available for all counties in the Austin and San Antonio metros (see pointer) — previously unavailable..

.. view developed with ProximityOne CV XE GIS and related GIS project.
.. any CV XE GIS user can create this view using the default US1.GIS project

ACS2014S Tables — scroll section
The ACS 2014 supplemental data include 42 tables and a total of 229 data items. Br> The table number and descriptions are summarized below.

View full table/item detail in tables shells: ACS 2014S Table shells (xls)

ACS 2014 Selected Supplemental Items for Selected Geography
  — interactive table
The interactive table contains all geography for which the ACS2014S data have been tabulated for these geographies: U.S., state, county, city/place, 114th Congressional District, MSA/MISA, PUMA, urban area and school district. The table provides access to key selected items.

The following graphic illustrates use of the interactive table. First cities/places were selected using the Type drop-down below the table. Next, the table is ranked in descending order on median family income. As shown in the graphic the largest 10 cities/places were under 65,000 population. Click graphic for larger view.

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.

America’s Million+ Population Cities

.. there are 10 million+ population cities in the U.S. .. each is reviewed in some detail in this section .. the change in U.S. city population from 2010 to 2015 ranged from growth of 357,979 in New York City to a decline of in Detroit, MI. New York City is actually five counties; the next largest city growth was Houston, TX with a 181,463 population gain. See cities with largest growth or decline using the interactive table.

The July 1, 2015 Census Bureau model-based estimates for the U.S. 19,505 incorporated cities show a total population of 202,066,769 compared to 192,179,239 as of Census 2010. These areas are incorporated cities as recognized by their corresponding state governments and granted certain governmental rights and responsibilities. ProximityOne integrates these estimates, with related data, in models to develop projections, examine change and assess the impact of change.

Largest 10 Cities — the Million-Plus Population Cities
The largest 10 cities in 2015, shown by this graphic taken from the interactive table below, are also the set of cities having 1 million or more population.

Locations and Attributes of the Largest 10 Cities
Locations of the largest 10 cities based on 2015 population are shown in the following graphic as red marker.

Examine demographic-economic attributes of these cities using these related individual city-focused sections.  These sections compare the city boundary/location with corresponding urbanized areas and include extended data from ACS 2012 and ACS 2014 1 year estimates presented in a comparative analysis format.
1. New York, NY
2. Los Angeles, CA
3. Chicago, IL
4. Houston, TX
5. Philadelphia, PA
6. Phoenix, AX
7. San Antonio, TX
8. San Diego, CA
9. Dallas, TX
10. San Jose, CA

City/Place Demographics in Context
State & Regional Demographic-Economic Characteristics & Patterns
.. individual state sections with analytical tools & data access to block level
Metropolitan Area Situation & Outlook
.. continuously updated characteristics, patterns & trends for each/all metros

Visual Analysis of City/Place Population Dynamics
Use the CV XE GIS software with city/place GIS project to examine characteristics of city/place population, 2010-2015. The following view shows patterns of population percent change, 2010-15, by city in the Charlotte, NC/SC metro area.

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

Individual million+ population city sections will be updated and the topic of separate future blog posts. Follow this blog to learn about updates to these and related sections.

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.

Mapping Statistical Data

.. GIS tools & data resources that you can use for statistical mapping & visual data analysis … Geographic Information Systems (GIS) provide flexible and powerful capabilities to combine maps with data. In our increasingly data rich environment, we often experience “drowning in data.” GIS tools can help harness disparate and voluminous data and assist with data linkage. This section provides links to other sections that provide information on no cost GIS software and “production” GIS projects and datasets that you can use.

Patterns of Per Capita Personal Income Change 2008-14 by County
— relative to U.S. PCPI 2008-14 change
To illustrate, the following graphic shows patterns of per capita personal income change 2008 to 2014 by county relative to the U.S. See more information. Click graphic for larger view with legend and additional details. Make variations of this map view using resources described in this section. Optionally integrate your own data.

— view created using CV XE GIS and associated REIS GIS Project

GIS provides us with a way to improve collaboration; we can more easily comprehend and understand geographic relationships and patterns among “variables” and statistical data. As we reduce tabular data to visual representations, we are better able to communicate “what the data are telling us” among stakeholders and teams/committees. This second dimension, learning what the data are telling us, provides the power of creating insights for more effective decision-making.

Mapping Statistical Data Topics
Most applications presented in this section involve use of Windows-based desktop GIS software. The software and GIS project files and datasets are installed on your computer. These resources are available for use by members of the User Group at no fee.  Click a link below to view additional details about a topic of interest.  There you find a description of the scope and use of the data/geography, steps to access and use the GIS projects/datasets and getting started tutorials.
World by Country
U.S. by State
U.S. by Congressional District
U.S. by Metropolitan Area
U.S. by County
U.S. by City/Place
U.S. by ZIP Code Area
State by Census Tract (each/all states)
State by Block Group
State by Census Block
K-12 Schools & School District Data Analytics

Applications make use of a range of statistical data from the Federal Statistical System, and other sources, integrated with shapefiles from the Census Bureau TIGER/Line shapefiles, OpenStreetMaps, and other sources.

Join me in a Data Analytics Lab session to discuss accessing, integrating and using these resources … and linking these data/geography with other data that relate 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.

Comparing Census Tract Demographics Over Time

.. it’s about more than census tracts .. this section is about comparing American Community Survey ACS 5-year estimates: 2005-2009 with 2010-2014 … something new and powerful happening this week.

To make good business decisions we need hard data, recent data, trend data … to assess patterns and change and develop reliable, superior plans. Read about the past and then how things have changed for the better.

Imagine that it is 2005. Data from Census 2000 are now 5 years old. There will not be another update for richer demographics for all counties and cities in the foreseeable further. There will not be any update for small area geography such as census tracts or block groups until Census 2010. Businesses are forced to use out-of-date data to assess markets … where and how are opportunities changing? City and neighborhood planners can only make educated guesses to respond to growing needs of various population groups. Federal and state government programs that base funding allocations on demographics are challenged. Changes in the rental vacancy rates for most cities, counties and metros will remain unknown for the foreseeable future.

Fast forward to 2015 and present day reality. The situation is now radically different. First, we can now compare 5-year estimates from the 2009 American Community Survey ACS to those from the 2014 ACS 5 year estimates. Second, we will be able to do that again in 2016 — compare 5-year estimates from ACS 2010 to those from ACS 2015. Health planners can now assess the size and change in special needs population and how that matches up to resources that respond to those needs — rather than guessing. Schools and school districts can better understand how school age population trending and plan for enrollment change. Education agencies are better able to assess how changing demographics among school systems compare to one-another. Businesses can now determine the size of potential markets and how they are trending based on hard data. It is possible to compare changing patterns in rental vacancy rates and rental housing market conditions for all levels of geography down to block group.

The American Community Survey ACS provides a wide range of important statistics about people and housing for every community in the nation. These data are the only source of local estimates for most of the approximately 40 topics it covers for even the smallest communities. It produces statistics for ancestry, language, education, commuting, employment, mortgage status and rent, as well as income, poverty and health insurance. The ACS estimates are tabulated annually as 1-year estimates (e.g., the ACS 2014 1-year estimates) and 5-year estimates (e.g., the ACS 2014 5-year estimates. See a comparison below in this section about scope, advantages/disadvantages, and other usage attributes for the 1-year versus 5-year estimates.

See ACS 2014 5-year main page for additional data access & use details.

Data from the 5-year estimates are available for all geographies down to the block group level regardless of population size. Starting with the ACS 2014 5-year estimates, for the first time, users will be able to compare two non-overlapping five-year periods 2005-09 and 2010-14. Looking ahead, data from the 2006-10 and 2011-15 (available December 2016) will be comparable … and so on. Over several years, a time-series of 5-year estimates, non-overlapping five-year periods, will evolve.

Comparing Geography Between 2005-09 & 2010-14 ACS 5-Year Data
The following graphic summarizes geographic tabulation areas for 2005-09 and 2010-14 ACS 5-year data. Use the corresponding Web table as a reference guide for comparing data over time. Links provided in the table enable you to navigate to selected data access tables. This Web-page table updates with new links; bookmark the page for re-visits.

Updates
Posts later this month will provide updates on this topics; new data and new data analytics tools. Join me in a Data Analytics Lab session to discuss use of these data using analytical tools and methods applied 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.