Tag Archives: mapping

U.S. House of Representatives 2020 Apportionment

.. Congressional Apportionment by State .. 2010 & projected 2020 state by state congressional seats.

What will the results of Census 2020 tell us us about how the House of Representatives will be reapportioned, state by state? This section examines scenarios which might occur based on state population projections. See related Web section http://proximityone.com/apportionment.htm for more detail and interactive table.

Use the GIS tools and project to make your own map views … see details
.. use in classroom .. research .. reference .. collaboration.

This section has been developed using
– 2020 apportionment population projections
.. part of the ProximityOne Situation & Outlook (S&O)
– the reapportionment/redistricting feature of the CV XE GIS software
The 2020 population projections reflect anticipated change under one scenario. Those values are then used in the CV XE GIS reapportionment operation to compute the number of House seats shown in the related table.

Apportionment of the U.S. House of Representatives
— based on the 2010 Census

– view created with CV XE GIS. Click graphic for larger view with more detail.

Apportionment of the U.S. House of Representatives
— based on ProximityOne 2020 Population Projections

– view created with CV XE GIS. Click graphic for larger view with more detail.

Congressional apportionment is the process of dividing the 435 memberships, or seats, in the House of Representatives among the 50 states based on the population figures collected during the decennial census. The number of seats in the House has grown with the country. Congress sets the number in law and increased the number to 435 in 1913. The Constitution set the number of representatives at 65 from 1787 until the first Census of 1790, when it was increased to 105 members. More about apportionment.

Initial Census 2020 demographic data, the apportionment data, will be released by December 31, 2020. See related Census 2010 Apportionments.

Apportionment totals were calculated by a congressionally defined formula, in accordance with Title 2 of the U.S. Code, to divide among the states the 435 seats in the U.S. House of Representatives. The apportionment population consists of the resident population of the 50 states, plus the overseas military and federal civilian employees and their dependents living with them who could be allocated to a state. Each member of the House represents, on average, about 710,767 people for Census 2010.

Using the Interactive table
The following graphic illustrates use of the 2010 & 2020 apportionment by state and historical apportionment 1910 to 2010. Sort on any column; compare apportionment patterns over time. Click graphic for larger view.
Use the interactive table at http://proximityone.com/apportionment.htm#table.

Congressional District/State Legislative District Group
Join the CDSLD Group (http://proximityone.com/cdsld.htm), a forum intended for individuals interested in accessing and using geodemographic data and analytical tools relating to voting districts, congressional districts & state legislative districts and related geography with drill-down to intersection/street segment and census block level. Receive updates on topics like that of this section.

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.

Insights into County/Metro Business Establishment Patterns

.. new data, released this past week, enable us to better assess county and metro business establishment patterns .. these data help businesses understand how sales of their products and services align with markets .. what counties might be underserved? .. where should marketing and sales operations be ramped up or reduced in scope/reallocated? .. what do these tell us us about organization of market territories? how are these characteristics trending by county? Use the this interactive table to examine business establishments characteristics by county and metro by type of business. See more detail in the related Web section about topics covered in this post. 

• U.S. establishments rose 1.2% from 7,663,938 in 2015 to 7,759,807 in 2016.
• First quarter employment was up 2.1% from 124,085,947 to 126,752,238
• Annual payroll was up 2.9% from $6.3 trillion in 2015 to $6.4 trillion in 2016.

Based on the 2016 data (new April 2018), there are 7.3 million establishments in Metropolitan Statistical Areas (MSAs). In these MSAs ..
• 5.3 million establishments have fewer than 10 employees.
• 6,522 of these establishments have 1,000 or more employees.
• 374 of these establishments have 5,000 or more employees.

MSAs by Number of Establishments with 1,000 or more Employees
The following graphic shows Metropolitan Statistical Areas (MSAs) by number of establishments with 1,000 or more employees. Click graphic for larger view view showing metros labeled with number of these establishments. Expand brower to full window for best quality view.
.. View developed with CV XE GIS software and related GIS project.

Business Establishment Characteristics Updated in Metro Reports
Examine 2014, 2015, 2016 mini trend profiles for establishments by 2-digit sector in Metro Situation & Outlook Reports Choose any MSA by clicking column 3 in this table .. then view section 6.3. Examples:
New York .. Los Angeles .. Miami .. Chicago .. Dallas .. Houston .. Denver .. Seattle

Gaining Insights
Gain insights into these types of patterns by county by detailed type of business (NAICS). Use the interactive table below to examine business establishment characteristics for counties and metros of interest. Data reviewed in this section are based on the Census-sourced County Business Patterns released in April 2018. We have integrated current population estimates with the establishment data in the interactive table.

Tools You Can Use
• create maps and geospatially analyze business establishments at 6-digit industry detail with ready-to-use GIS project/tools .. see related section for details.
• Use the APIGateway tools to build custom business establishment datasets.
• Use the interactive table to query/view sort business establishment characteristics by county and metro.

Data Analytics Web Sessions
Join me in a Data Analytics Web Session, every Tuesday, where we review access to and use of data, tools and methods relating to GeoStatistical Data Analytics Learning. We review current topical issues and data — and how you can access/use tools/data to meet your needs/interests.

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 Updates & Trends

.. this past week we have updated Housing Price Index data and tools to examine patterns and trends for the U.S., states, metros and counties .. the Housing Price Index (HPI) is one of many measures useful to gain insights into the housing market. The HPI provides information on how housing value appreciation is changing for areas of interest. Use the interactive table to view, compare, sort metros/CBSAs based on annual HPI 2010-2017 and housing value appreciation during the period. These annual data, with a 2000 base index value of 100, provide insights into longer term patterns.  The HPI is alos updated quarterly for U.S./state/metro areas quarterly for analyses requiring more recent data.  These data are new as of February 2018.

Visual Analysis of Housing Price Appreciation
The following graphic shows housing value appreciation as of 2017 based on the HPI with 2000 base of 100 by county in the Charlotte, NC-SC metro area. See more about by HPI by county for the Charlotte metro.

– view developed using CV XE GIS and related GIS project.
– Click graphic for larger view and details.

See similar HPI 2017 patterns view for the Houston, TX metro.

Housing Price Appreciation 2010-2017 — Largest 10 Metros
This table, derived from the  interactive table, shows the largest 10 metros based on total population. the HPI 2010, HPI 2017, housing price appreciation 2010-2017 and total population are presented in the table. Click the CBSA code link to view HPI by county component for the metro and an extended series.

 Metro CBSA HPI2010 HPI2017 HPA1017 Pop2016
 New York   35620 159.53 172.76 8.29 20,153,634
 Los Angeles   31080 169.83 242.78 42.95 13,310,447
 Chicago   16980 117.48 124.58 6.04 9,512,999
 Dallas   19100 120.89 175.35 45.05 7,233,323
 Houston   26420 134.02 183.52 36.93 6,772,470
 Washington   47900 166.82 198.74 19.13 6,131,977
 PhiladelphiaA   37980 157.26 162.91 3.59 6,070,500
 Miami   33100 140.43 213.91 52.33 6,066,387
 Atlanta   12060 103.95 129.24 24.33 5,789,700
 Boston   14460 134.33 165.27 23.03 4,794,447

– Metro names abbreviated; use table to view full name and code.

Using the HPI Annual 2010-2017 Interactive Table
The following graphic illustrates use of the HPI Annual 2010-2017 interactive table. Click graphic for larger view. This view shows metros in the 250,000-300,000 population peer group. Set your own criteria using tools below the table. There are 23 metros in this group. The table has been sorted on housing price appreciation (HPA) from 2010-2017 (second column from right). It shows that the Merced, CA metro had the highest HPA — 82.13% di=uring this period.

Use the interactive table and examine areas of interest.

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.

 

 

Examining Health Care Infrastructure by ZIP Code

.. small area data providing information on sub-county and sub-city/place geographies are challenging to locate and use — particularly in context of demand for healthcare services and demographic attributes of associated neighborhoods. Develop insights into the healthcare infrastructure by ZIP code using the two related resources reviewed here — 1) individual ZIP code demographic-economic profiles and 2) ZIP code demographic-economic interactive tables. One way to examine the healthcare infrastructure for an area is to view/analyze the number and attributes (employment, earnings) of healthcare establishments by types of business/industry (such as physicians office or hospitals). Data and tools reviewed here provide insights into characteristics and patterns of national scope ZIP code areas — examine your ZIP codes of interest.

Option 1 — ZIP Code Profiles
.. examining the healthcare infrastructure in context of the related demographic-economic situation … the following graphic shows ZIP code 10514 (Westchester County, NY) with a bold red boundary.  Census tracts are shown with black boundaries with tract codes as white labels. See more about ZIP-Tract relationships. Cities/places are shown with blue cross-hatch pattern.

– view created with CV XE GIS software and related GIS project.

The above map graphic is part of a ZIP Code 10514 profile (click link to view complete profile). Section 3.1. of the profile shows the number healthcare establishments in the ZIP Code as partly shown in this graphic:

The portion of the table shows the NAICS/type of business code at left, followed by type of business description and the number of establishments at the right.

Examine other characteristics of this ZIP code profile and in context of others via this related Web section. These profiles update in May 2018.

Option 2 — ZIP Code Health Care Sector comparative analysis
.. examining the healthcare infrastructure for a set of ZIP codes in a state, metro, county or peer group … use the interactive table located here to view/rank/compare health care business establishments by type of business for a selected set of ZIP codes. This table shows a query placed on the table to show the total number of offices of physicians for ZIP codes in the vicinity of ZIP 10514. It shows that there are 14 offices of physicians establishments and 13 have 1-4 employees.

About These and Related ZIP Code Data
Data used to develop the tools/resources described above are based in part on the Census Bureau County Business Patterns program. These establishment data update annually.

ZIP code demographic-economic interactive tables
Use the following tables to examine a wide range of ZIP code demographic-economic conditions:
  • General Demographics
  • Social Characteristics
  • Economic Chacteristics
  • Housing CHaracteristics

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.

Low & Moderate Income Census Tracts; 2017 Update

..  data and tools to analyze characteristics and patterns of census tract geography with a focus on low and moderate income.   See related Web page for more detail.

Of the total 75,883 census tracts for which low and moderate income data were tabulated in the HMDA 2017 data, 6,023 (8.7%) were low income, 16,873 (24.5%) were moderate income, 32,509 (47.1%) were middle income and 19,159 (27.8%) were upper income. See more about these classifications. Find out about your tracts/neighborhoods of interest and how they compare to others using data and tools provided in this section.

Analysis of the low, moderate, middle, and upper income of the population and households by small area geography is important to housing market stakeholders, lenders, investors, cities/neighborhoods and others. Low and moderate income data by block group and census tract are used for compliance, eligibility determination and program performance in many Federal programs and agencies.

• Use the interactive table below to view, query, compare, sort census tracts.
• Use tract estimates & projections to examine changing characteristics.
– extended demographic-economic measures, annual 2010-2022

Low & Moderate Income by Census Tract
The following view shows census tracts designated as low and moderate income (orange fill pattern) in the the Houston, TX MSA (bold brown boundary) area. These are tracts having income level with codes 1 and 2 in the interactive table. A wide range of market insights can be created zoom-in views for counties, cities and neighborhoods and linking these with other data. Make variations of this view using ProximityOne data and tools described in this section.

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

View similar maps for these areas:
.. Atlanta metro
.. Chicago, IL metro
.. Dallas, TX metro
.. Knoxville, TN metro
.. with drill-down views for Knoxville city
.. Los Angeles, CA metro
.. San Francisco, CA metro

Using the Interactive Table
  – Examining LMI Tracts in Your Metro

Use the interactive table to view, query, sort compare tracts based on various demographic and LMI characteristitcs. The following graphic illustrates how the table can be used to view low and moderate income tracts for the Charlotte, NC-SC metro.
– click ShowAll button below table.
– enter a CBSA code in the edit box at right of Find CBSA LMI>.
– click the Find CBSA LMI button.
Resulting display of Charlotte metro LMI tracts only.

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

City Population Characteristics & Trends: 2010-2016

.. the change in U.S. city population from 2010 to 2016 ranged from growth of 345,647 in New York City to a decline of -38,293 in Detroit, MI. New York City is actually five counties; the next largest city growth was Houston, TX with a 197,857 population gain.  Examine how the population is changing in cities of interest using the interactive table and other tools described in this post.  Use the interactive table to view a selected city, all cities in a state, cities in a county, cities in a metro or cities in a peer group size class.  See related Web section for more details.

Use the U.S. by cities shapefile with your GIS projects. See details. Thematic pattern maps illustrating use of these resources are shown below.

The July 1, 2016 Census Bureau model-based estimates (see about these data) for the U.S. 19,510 incorporated cities show a total population of 203,314,546 compared to 192,174,578 as of Census 2010. These areas are incorporated cities as recognized by their corresponding state governments and granted certain governmental rights and responsibilities.

Patterns of City Percent Change in Population 2010-16
— Cities 10,000 Population & Over
Use the CV XE GIS software with cities GIS project to examine characteristics of city/place population, 2010-2016. The following view shows patterns of population percent change, 2010-16 for cities with 2016 population of 10,000 or more. Use the interactive table below to see that among cities with 2016 population of 10,000 and over that Buda, TX had the largest percent change (98.8%) while Avenal, CA experienced the largest percent decrease (-18.4).

– View developed using the CV XE GIS software.
– Click graphic for larger view.

Fastest Growing Cities in the Dallas, TX Metro
— Cities 10,000 Population & Over; create views like this for any metro/county
It is easy to see which cities are growing the fastest using the thematic pattern view below. It is also easy to see how the cities relate to each other geographically and in context of county boundaries. The following view shows patterns of population percent change, 2010-16 for cities with 2016 population of 10,000 or more in the Dallas metro area.

– View developed using the CV XE GIS software.

Drill-down — Fastest Growing Cities in the Dallas, TX Metro
— Cities 10,000 Population & Over
Zoom into the north Dallas metro area and label the cities with name. The following view shows patterns of population percent change, 2010-16 for cities with 2016 population of 10,000 or more in the Dallas metro area.

– View developed using the CV XE GIS software. Click graphic for larger view; expand browser window for best quality view.

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
Related City/Place Demographic-Economic Interactive Tables
ACS 2015 5-year estimates
.. General DemographicsSocialEconomicHousing Characteristics

Using the Interactive Table
Use the full interactive table to examine U.S. national scope cities by annual population and change 2010-2016. The following graphic illustrates use of the table to view the largest cities ranked on 2016 population. Use the tools/buttons below the table to create custom views.

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.

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.