Category Archives: Age

Making & Using Custom 115th Congressional District Maps

.. using GIS resources to create custom 115th Congressional District maps .. use the methods, data and tools described in this section to develop custom congressional district maps. View patterns of economic prosperity by neighborhood for one or all congressional districts. Flexibly associate a congressional district boundary with related geography and subject matter.  See related Web section for more details.

Join the Congressional District-State Legislative District (CDSLD) Group .. be a part of the community. .. click here to join .. there is no cost.

Coming up … mapping/analyzing school district finances in context of the 115th Congressional Districts (June 2017).

See the related section on Making/Using 113th Congressional District Maps.
.. view different congressional district vintages in same map.

115th Congressional Districts by Incumbent Party Affiliation
This view and related GIS project/data update when changes are made to the 115th Congressional Districts incumbents (last updated 5/10/17). Party affiliation shown in this view is also available in the related interactive table. Click graphic for larger view. Expand browser window for best quality view.

– View developed using CV XE GIS and related GIS project.
– see below in this section about using this GIS project.

Use the Geographic Information System (GIS) tools and data to view/show congressional district in context with roads, landmarks and other geography. Flexibly add labels. Create pattern views. Add your own data.

Patterns of Economic Prosperity by 115th Congressional District
The following graphic shows patterns of ACS 2015 median household income (MHI) by 115th Congressional District. Click graphic for larger view. Expand browser window for best quality view.

– View developed using CV XE GIS and related GIS project.
– use the GIS project and tools see below to create different views.

Examine Characteristics of any Congressional District
The following graphic shows patterns of ACS 2015 median household income (MHI) by census tract in context of 115th Congressional Districts in a region of North Carolina. CD 3712 (Charlotte area) is shown with bold boundary. It is easy to see which areas/tracts have different levels of economic prosperity.

– View developed using CV XE GIS and related GIS project.
– use the GIS project and tools see below to create different views; add other layers.

Creating congressional district maps is often specific to a particular analysis, zoom-view, labeling, combination of different geographies or other considerations. While there are no estimates of unemployment by congressional district, using GIS tools it is possible to view/geospatially analyze patterns of unemployment within congressional district by county, census tract, block group and other geography.

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.

Congressional District 2015 Demographic-Economic Characteristics

.. congressional districts vary widely in demographic-economic characteristics.  We have new data for 2015 providing insights to characteristics of the 114th Congressional Districts.  This section summarize a few of these characteristics and provides access to a wide range of data that you can use to view, sort, rank, and compare congressional districts using interactive tables.

Patterns of 2015 Educational Attainment
The following graphic shows patterns of educational attainment (percent college graduate) by congressional district in the Los Angeles area. White label shows the congressional district code; yellow label shows percent college graduate. Legend shows color patterns associated with percent college graduate intervals.

– View developed using CV XE GIS software and associated GIS project.

How Congressional Districts Compare
Reference items refer to items/columns shown in tables described below.

.. general demographics: congressional district UT03 has the smallest median age (27.5 years — item D017) and FL11 has the highest median age (53.5 years).

.. social characteristics: congressional district KY05 has the fewest number of people who speak English less than “very well” (2,676 — item S113) and FL27 has the largest number (281,053).

.. economic characteristics: congressional district ND00 has the lowest unemployment rate (2.6% — item E009) and MI13 has the highest unemployment rate (14.6%).

.. housing characteristics: congressional district MI13 has the lowest median housing value ($63,100 — item H089) and CA18 has the highest median housing value ($1,139,900).

Access the Detailed Interactive Tables
Click a link to view more thematic pattern maps and use the interactive tables.
.. General Demographics
.. Social Characteristics
.. Economic Characteristics
.. Housing Characteristics

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.

Largest School Districts Enrollment Characteristics

..  while school district enrollment is reported by school districts, only public school enrollment is reported. Public and private school enrollment are available by district from the American Community Survey (ACS 2015).  With few exceptions, school districts do not report on demographic-economic characteristics of the school district.  These data are only available from ACS. See the related interactive table to access and compare enrollment characteristics of school districts of interest.

In 2015, there were 1,016 school districts with total population of 65,000 or more (of total 14,650) for which “1-year estimates” were tabulated.  These estimates are based on respondent data for calendar year 2015.  This section summarizes selected enrollment characteristics of the largest districts and provides access to much more detail for each of these districts.

Largest 10 School Districts
The following graphic shows the largest 10 school districts based on the size of the 2015 school age population ages 5-to-17. Click graphic for larger view.

Mapping the Largest School Districts
The following graphic shows locations of the largest school districts as red markers. Click graphic for larger view that opens in a new window. Expand browser window for bets quality view. The larger view shows school district locations on context of metropolitan statistical areas (MSAs).

  view created using CV XE GIS software and related GIS project.

School Districts Tabulated in ACS 2015
ACS 2015 data are tabulated for 14,650 school districts (among many other wide-ranging geography). The following table shows the number of districts for which 1-year estimates and 5-year estimates are tabulated. There are 1,016 districts for which 1-year estimates were tabulated.

These data show enrollment of residents of the district whether enrolled in that district or otherwise. Enrollment data are provided for preschool, K-12 and college and not enrolled.

Using the School District Enrollment Interactive Table
The following graphic illustrates use of the interactive table (click that link to use the table) showing enrollment in kindergarten by school district ranked in descending order.

– click graphic for larger view.

Using the table, you can select total, public or private enrollment for selected grade ranges.

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.

Data Analytics & API Applications

Possibly the most well known APIs (Application Programming Interface) are the Google APIs. Among these, the Google Maps API, or its use, might be the most familiar. See about integrating political/statistical geography and Google Maps API. This section reviews different types of APIs.

Data Analytics and APIs
API technology/tools play an important role in accessing and integrating geographic, demographic and economic data. APIs offer two types of benefits. For Web-based applications, APIs provide the ability for on-the-fly access to selected demographic-economic buried in otherwise large datasets that typically otherwise involve downloading and preprocessing. A second important benefit/use is to extract data from those same datasets, reconfigure the structure of the data retrieved by API and create a new dataset structure that lends itself to analytical applications.

ProximityOne Data Analytics sessions review purpose, scope, strengths, advantages & limitations of APIs described in this section. Topics included in the related Web section include:
Federal Geographic-Demographic-Economic Data Access Using APIs
REST APIs
Federal Communications Commission
Bureau of the Census … much more than Census
Bureau of Economic Analysis
Bureau of Labor Statistics
Data Access & Analytics Applications
There are hundreds more APIs available from Federal agencies and wide-ranging sources.

Using APis and GIS: Visualizing Patterns; Geospatial Analysis
The following graphic has been developed first using API tools to create the underlying datasets. While the source data used in this application could have been downloaded and processed in legacy manner, the API tools provide on-the-fly development of the data in a structure required by the GIS software. These data are then integrated into shapefiles for use with the GIS software. Once the datasets are developed, they can be used in a myriad of application, GIS and otherwise.

Patterns of Male Hispanic Population Age 5 Years by ZIP Code
— Houston, TX Area


• Click graphic for larger view with ZIP Code labels and more detail.
• The graphic shows patterns of the Male Hispanic population 5 years of age as of Census 2010.
• The view illustrates how single year of age by gender by race/origin can be visually analyzed.
• See more about these data and single year of age demographics

Examples and More Detail
See the corresponding Web section on Data Analytics & Using APIs. Many See application examples are shown there.

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.

Outlook2020 Trend Analysis

.. how will the population distribution by age in one county compare to another county, metro or region between 2010 and 2020?  This section reviews how you can perform such analyses using the no fee  Outlook2020 Trend Analysis Windows-based tools.  The Outlook2020 software accesses Web-based Outlook 2020 U.S. by county annual demographic estimates and projections, 2010 through 2020. The Outlook 2020 estimates and projections are part of the Situation & Outlook database and information system.

Analytical Features
Outlook2020 Trend Analysis operations and analytical features include:
  1. display estimates and projections in a grid.
2. show annual age-cohort population data as a percent of total population.
3. save the grid display of population or percent data as an Excel file.
4. select two or more counties and aggregate the data for the composite area.
5. create percentage views and save to Excel just like for a single county.
— features 4 and 5 enable aggregation of data to a metro or region.
6. use a metro listbox to automatically select all metro counties.
7. compare any one area with another area, optionally multi-county.
8. all U.S. counties and all metros are supported.

Start-up View
Start Outlook2020 using the desktop icon. The start-up view appears as shown below. The start-up view illustrates one of the basic features of the application. Johnson County, KS is selected in the lower left listbox. When this selection is run (dbl-click the county name), the total population by age profile is displayed in the grid. The leftmost column shows age group. The remaining columns show annual population estimates and projections to 2020. The year is shown in the top cell of the column.

Click graphic for larger view.

Percent of Total by Year
Click the “Show % of Total” button to view cells as a percent of total population.

Click graphic for larger view.

Select/Sum all Counties in a Metro
In this view, the Phoenix, AZ metro is dbl-clicked in metro listbox. The two component counties are displayed in the lower/county listbox. Multi-selecting both counties, the Run button is clicked. The grid refreshes with the sum of both counties, or the metro total. Perform a similar application for any metro.
Click graphic for larger view.

Saving Grid to Excel File — the Metro (any multi-county region)
In this view, the File>SaveGridAs feature is used to save the current grid cells to an Excel file. The file was saved as c:\outlook2020\phoenix_metro.xls; it will be used in a comparative analysis reviewed below.
Click graphic for larger view.

Grid to Excel File — a Metro Component County
In this view, the File>SaveGridAs feature is used to save the current grid cells to an Excel file. Maricopa County is dbl-clicked; the grid populates with population values for this one county. The file was saved as c:\outlook2020\maricopa.xls; it will be used in a comparative analysis reviewed below.
Click graphic for larger view.

Comparative Analysis
What part of the Phoenix metro is comprised by Maricopa County? The File>Comparative Analysis feature is used to compare Maricopa County (the numerator by cell) to the Phoenix metro (the denominator by cell). The following view shows that Maricopa County comprises 89.7 percent of the Phoenix metro population ages 0-4 years. The percent of this age group accounted for this county as a percent of total metro is slowly declining since 2010. Smaller Pinal County has a relatively increasing rate for this age group.

Click graphic for larger view.

More About Analyses & Insights
Questions that can be answered with this tool …
• what part of the Kansas City metro is comprised by the Missouri counties?
• in total population? as a percent of metro?
• how is this projected to trend 2010 through 2020?
• what do these analyses suggest about trends by age cohort by county for metro?

User Group Access
Members of the ProximityOne User Group may install the Outlook2020 software and perform operations described in this section. Join the User Group now, there is no fee. See Outlook2020 installation notes

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 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. We can address specific questions about using metro and county demographic economic data and related applications.

See more about topics covered here in the corresponding Outlook2020 Web section.

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.