Tag Archives: Geographic information system

Using GIS & GeoDemographics

.. join us in the GIS & GeoDemographics self-paced, online course.

Visual representation, maps, of demographic data by geographic area can be exciting and rewarding. Using Geographic Information Systems (GIS) can bring maps alive. Creativity is boundless. The banner at the top of the corresponding Web section presents a static view of a map rendered using GIS. This map shows the Los Angeles area by census tract. For the analyst or stakeholder, it shows something more — the percent Asian citizen voting age population by tract, overlayed with Congressional District boundaries and codes. It shows relationships, patterns. Using the power of GIS, the zoom level, colors, legend, and labeling can all be changed immediately. You, the GIS user, are at once analyst, artist and storyteller. In control of your medium, canvas, you further your benefits from use these software and data by making dynamic presentations in collaborations. Make compelling arguments. Capture your views and blend them with words and charts into documents. Welcome to the world of GIS and geodemographics.

Mapping census block demographics
The graphic shown below illustrates use of GIS software with the TIGER digital map database census block shapefile to show census blocks for two Ohio counties in context of 2018 CBSAs/Metros. Clicking on a census block (see pointer) shows a mini profile for that block.


– view developed using ProximityOne CV XE GIS and related GIS project.

Using GIS & GeoDemographics .. about the course
Examining geographic-demographic-economic characteristics, patterns and trends … researchers, policymakers, journalists, administrators, students among others. How can you most benefit from using the TIGER geographic data to meet your objectives? These data are available at no cost. Join us in the Using GIS Tools & GeoDemographics online, self-paced course. Learn all aspects of using the Census Bureau TIGER files and related Census-sourced and other Federal statistical data. Augment your professional skills; participants receive all required data, methods and tools. Your personal session is developed and coordinated by Warren Glimpse. You receive the GIS course certificate upon completion. The course may be started at any time and includes requisite Windows-based CV XE GIS software. The course assumes the participant has basic familiarity with a Windows computer, Internet and spreadsheet operations. No GIS related experience is required. Experienced GIS professionals also benefit by learning about the use and nuances of Census-sourced data and integrating these with other data. The structure includes four segments that typically require 2.5 hours each. It is feasible to complete the course in a day or two though we suggest two weeks.

Use Geographic Information Systems (GIS) with TIGER … integrate/analyze data from American Community Survey (ACS) or the decennial census (Census 2010) (Census 2020) into TIGER files to make thematic maps. Merge data from other statistical programs. Geocode your address-based data and add the geocoded data to a GIS project/map view; examine patterns. View your market/service areas and assess competitive position, unmet opportunities. Learn about procedures and strategies to develop GIS projects that meet your needs. Acquire the tools and data to perform these tasks without spending more — provided as a part of our course.

The course is not just about TIGER and demographic-economic data. It provides a well-rounded framework for how to use GIS. While TIGER is a focus, we review procedures to access and use thousands of public use shapefiles and GIS files that may be useful to you. It provides a well-rounded framework for how to use GIS.

Enroll today …
Click the enrollment button/link (opens new page) to enroll now ($395). We will contact you and provide next step information.   Questions? Call us at (800)364-7656.

Data Analytics Web Sessions
Join me in a Demographics 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.

Monthly Local Area Employment Situation: 2017

.. tools & data to examine the local area employment situation .. this update on the monthly and over-the-year (Jan 2016-Jan 2017) change in the local area employment situation shows general improvement. Yet many areas continue to face challenges due to both oil prices, the energy situation and other factors.  This section provides access to interactive data and GIS/mapping tools that enable viewing and analysis of the monthly labor market characteristics and trends by county and metro for the U.S. See the related Web section for more detail. The civilian labor force, employment, unemployment and unemployment rate are estimated monthly with only a two month lag between the reference date and the data access date (e.g., March 2017 data are available in May 2017).

Use our new tools to develop your own LAES U.S. by county time series datasets. Link your data with LAES data. Run the application monthly extending/updating your datasets. Optionally use our 6-month ahead employment situation projection feature. See details

Unemployment Rate by County – January 2017
The following graphic shows the unemployment rate for each county.

— view created using CV XE GIS and associated LAES GIS Project
— click graphic for larger showing legend details.

New with this post are the monthly 2016 monthly data on the labor force, employment, unemployment and unemployment rate. Use the interactive table to view/analyze these data; compare annual over the year change, January 2016 to January 2017.

View Labor Market Characteristics section in the Metropolitan Area Situation & Outlook Reports, providing the same scope of data as in the table below integrated with other data. See example for the Dallas, TX MSA.

The LAES data and this section are updated monthly. The LAES data, and their their extension, are part of the ProximityOne Situation & Outlook database and information system. ProximityOne extends the LAES data in several ways including monthly update projections of the employment situation.

Interactive Analysis
The following graphic shows an illustrative view of the interactive LAES table. In January 2017, 149 counties experienced an unemployment rate of 10% or more. The graphic shows counties experienced highest unemployment rates. Use the table to examine characteristics of counties and metros in regions of interest. Click graphic for larger view.

Metro by County; Integrating Total Population
The following graphic shows an illustrative view of the interactive LAES table focused on the Chicago MSA. By using the query tools, view characteristics of metro component counties for any metro. This view shows Chicago metro counties ranked on January 2017 unemployment rate (only 10 of the 14 metro counties shown in this view). Click graphic for larger view.

The above view shows the total population (latest official estimates) as well as employment characteristics.

More About Population Patterns & Trends
U.S. by county population interactive tables & datasets:
  • Population & Components of Change 2010-2016 – new March 2017.
  • Population Projections to 2060 2010-2060 – updated March 2017.

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.

New ACS 2015 1-Year Demographic-Economic Data

.. essential data to assess where we are, how things have changed and how things might change in the future down to the sub-neighborhood level. The American Community Survey (ACS) is a nationwide survey designed to provide annually updated demographic-economic data for national and sub-national geography. ACS provides a wide range of important data about people and housing for every community across the nation. The results are used by everyone from planners to retailers to homebuilders and issue stakeholders like you. ACS is a primary source of local data for most of the 40 topics it covers, such as income, education, occupation, language and housing. ProximityOne uses ACS to develop current estimates on these topics and 5-year projections. This section is focused on ACS 2015 data access, integration and use and is progressively updated.

New ACS 2015 1-year estimates are available as of September 15, 2016.

Importance of ACS: Assessing Demographic-Economic Change
Oil prices plummeted in late 2014. How has this affected people and households in areas hardest hit? Find out for wide-ranging geographies using the ACS 2015 1-year estimates. Compare to ACS 2014 1-year estimates. Use the ACS 2016 1-year estimates (September 2017) to see how the impact has continued. Demographic-economic conditions change for many reasons; oil price changes are just one.

Keep informed about ACS developments and related tools and applications:
• Updates are sent to ProximityOne User Group members (join here).
… access special extract files and GIS projects available to members.
• ACS updates and applications are covered in the Data Analytics Blog.
• ACS data access, integration & use … join us in a Data Analytics Lab session.

In the weeks ahead, the following ProximityOne information resources will be updated with new ACS 2015 1-year data:
U.S.-State-Metro Interactive Tables
• Demographic component section of Metro Situation & Outlook Reports .. example for Dallas metro
• Housing characteristics component section of Metro Situation & Outlook Reports .. example for Dallas metro
Demographic-Economic Trend Profiles
• Special study reports.

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.

New Monthly Residential Construction by Metro Updates

.. tools, data & methods to assess the housing situation, examine housing supply and demand market conditions, and how metros of interest are changing.  New July 2016 building permits (new housing units authorized) and over-the year monthly data are now available for each metropolitan statistical area (MSA).

Use the interactive table to view, query, rank, compare data by metro. Map and geospatially analyze construction patterns with the CV XE GIS software and ready-to-use GIS project/datasets – see details.

Updated Resources to Examine Residential Construction Patterns
Metro Situation & Outlook Reports
.. metro by metro … examples: Houston, Los Angeles, Chicago, Atlanta.
County Annual U.S. by county
County & City/Place Monthly

Patterns of New Authorized Residential Units by Metropolitan Area
The following graphic shows value of single unit structures units authorized  by metro. Larger view shows more details including a mini-profile of housing units authorized detail. Create similar views for preferred time periods and different residential unit attributes using the GIS project.  Zoom-in to areas of interest.  Label the geography as desired.  Add your own data.

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

The time lag from reference date to access date of these data is one month, contributing to both the freshness of the data and importance of the data as a leading economic indicator. The importance of these data transcends issues concerning housing market conditions alone.  These data are one part of a mix of demographic-economic factors required to understand housing market conditions and the local/regional economy. These data are a part of the process to develop the ProximityOne county and sub-county demographic-economic estimates and projections.

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 by Metro: What $100 Buys

.. data and tools to examine the purchasing power of the incomes in different metros and states … this section reviews how you can access to data on what $100 buys by state and metro. Examine patterns of what $100 buys by year, 2008-2014, for all items and by type of goods & services category. Use the interactive table to view, rank, compare the Buying Power Index for each/all states and metros (MSAs). See the main Web page for more details.

What $100 Buys by Metro: 2014
The following graphic shows patterns of 2014 all items buying power of $100 by metro (MSAs). The color patterns/intervals are shown in the inset legend. Click graphic for larger view. Expand browser to full window for best quality view. Use GIS tools to develop thematic pattern maps for a range of data and criteria.

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

Varying prices by region can be normalized using Regional Price Parities (RPP). The RPP is a weighted average of the price level of goods and services for the average consumer in one geographic region compared to all other regions in the U.S. See more about RPP measures. Using the RPP data, what $100 will buy can be determined by state and metro for the categories of all goods and services, goods, services-rents and other services. See about RPP goods and services types.

In the Boston metro, $100 buys about 90.7 percent of all items goods and services due to the high prices there. $100 in Boston seems more like $90.70 compared to the national average. In the Jefferson City, MO metro, the opposite is true. $100 buys all items goods and services due to lower prices in that metro. $100 in the Jefferson City, MO metro is the equivalent of $121.65 of all items goods and services compared to the national price levels.
• the Boston metro all items buying power index is 90.70
• the Jefferson City, MO metro all items buying power index is 121.65

Interactive Table – Top 10 Metros
The following graphic illustrates use of the Buying Power Index interactive table. This graphic shows the 10 metros that have the all items highest Buying Power Index. Use the interactive table to view/examine areas of interest.

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

Metro Quarterly Establishments, Employment & Earnings by Industry

.. data, tools and methods to analyze metro business  patterns and trends .. the most current and comprehensive measures of business activity by county, metro and higher level geography are provided by the Establishments, Employment & Earnings (EEE) database. Use the resources described here to analyze establishments, employment and wages by metro for the most recent quarter and over-the-year change — by quarter 2013 through 2015.  Updated quarterly, the 2016Q1 data become available September 7, 2016. See the related Web section for more details.

These metro by metro EEE datasets are  closely integrated with the metros Situation & Outlook reports. Click a CBSA code in the “Code” column in that table then select related section 6.6. to access/download quarterly data for a metro.

Where Does America Make Things?
The graphic below shows percent employment in the manufacturing sector (employment in the private manufacturing sector as a percent of total private sector employment by county). This view illustrates how the EEE data can be used to develop insights.  Click graphic for larger view providing more detail. Use the GIS tools to analyze similar patterns for any industry. Interpreting this map graphic and alternative data resources … join us in a Data Analytics Lab session where we discuss making and interpreting this map view and alternatives.

– view developed with ProximityOne CV XE GIS and related GIS project.

Two Key Data Resources
1) Use the interactive table in the Web section to example total establishments, employment and wages for any selected MSA and/or in comparison with other MSAs.

2) Download metro quarterly Establishments, Employment & Earnings (EEE) by type of business data. Click a quarterly download link in Section 6.6 for a selected metro (see above note) and download the full 6-digit NAICS detail data for any/all quarters starting with 2013Q1 (CSV structure). These files provide 6-digit NAICS type of business code detail and included columns for :
for the most recent quarter ..
• establishments
• 1st, 2nd, and 3rd month employment
• total wages and average weekly wages
• establishments location quotient
• 1st, 2nd, and 3rd month employment location quotient
• wages and average weekly wages location quotient
for over-the-year change (previous year, same quarter ..
• establishments
• 1st, 2nd, and 3rd month employment
• total wages and average weekly wages
• establishments location quotient
• 1st, 2nd, and 3rd month employment location quotient
• wages and average weekly wages location quotient

Using the Interactive Table
Updated quarterly, use the interactive table in the Web section to view, rank, compare individual metros with other metro. The following graphic shows metros ranked in descending order by 2015Q4 average weekly wages. Columns to the right show over-the-year (2014Q4-2015Q4 in this case) characteristics.

– click graphic for larger view.

Using the Downloaded Data
Access/download quarterly establishments, employment & earnings data by detailed NAICS category using theSituation & Outlook Metro Reports. Select a metro from the interactive table by click a link in the “Code” column. The S&O metro report opens in a new page. In the table of contents, select section 6.6. from the table of contents (Establishments, Employment & Earnings by Detailed Type of Business). See this example for the Chicago metro.  See the related Web section for more details on using the download data files. .

Location Quotients
Pre-computed location quotients are included in the downloadable files. Location quotients (LQ) are ratios (indicators) that measure the concentration of an industry within a specific area (metro in this case) to the concentration of that industry nationwide.

If an employment LQ is equal to 1, then the industry has the same share of its area employment as it does in the nation. An employment LQ greater than 1 indicates an industry with a greater share of the local area employment than is the case nationwide. For example, Las Vegas will have an LQ greater than 1 in the Leisure and Hospitality industry because this industry makes up a larger share of the Las Vegas employment total than it does for the nation as a whole.

Employment LQs are calculated by first, dividing local industry employment by the all industry total of local employment. Second, national industry employment is divided by the all industry total for the nation. Finally, the local ratio is divided by the national ratio.

LQs are provided in the downloadable file for:
a) the reference quarter for each of establishments, employment and wages, and
b) over-the-year change for each of establishments, employment and wages.

Location Quotients will be reviewed in more detail in an upcoming blog post.

Important features of these data
• Tabulated for all counties, metros, states and the U.S.
• Tabulated for detailed types of business (6-digit NAICS).
• Tabulated quarterly and annually, the data enable time-series modeling.
• Employer-based administratively collected data; not estimates.
• Short lag (5 months) between reporting date and date of data accessibility
– data for first quarter 2016 (2016Q1) are available mid-September 2016.

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.