36 Hours in Santa Fe

.. creating custom maps for planning and analysis .. this section starts with the New York Times story 36 Hours in Santa Fe. We review how you can use no cost tools to develop custom maps and gain insight into demographic attributes of specific locations with intersection to intersection level of detail.

Visual Analysis of Santa Fe & Selected Locations
The following view shows Santa Fe locations (red markers) included in the New York Times story.

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

Demographic-Economic Characteristics of Santa Fe Metro
View the Metro Profile for the Santa Fe, NM metropolitan area. Examine demographic trends for Santa Fe County, NM, assess the economic profile for the metro and more. View the City Profile for Santa Fe, NM.

Steps to Develop the Map Views & GeoDemographic Analysis
1. Use APIGeocoder to geocode the locations based on address.
2. Add the shapefile created by APIGeocoder to a GIS project.
3. Use CV XE GIS to create mapg shown in this section and perform related geodemographic analyses.

Examining a Location
The following view shows a zoom-in to the Plaza Cafe location (see pointer in map). The identify tool is used to display a mini profile. This profile shows three attributes assigned by APIGeocoder (among others) … 1) the location is in census block 350490004001021 (blue highlight in graphic, block 1021 in census tract 000400), the street segment location is TIGERLine ID 169377560, 3) the location is on the left side of the segment.

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

More About the Street Segment Location
The following view shows a mini profile of the TIGERLine roads street segment where the Plaza Cafe is located. This view shows the roads layer (see in legend at left of map) checked on; streets based on shapefile are visible in the map. Add the TIGERLine roads shapefile (for any county) using the CV XE GIS Geogateway feature. This profile shows the left-side and right-side street segment high and low address range and left- and right-side ZIP code.

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

Block Group Demographics
The Census 2010 census block for the location is 350490004001021 (see above). The Census API can be used to access detailed demographics from ACS 2012 5-year estimates for the block group (BG — areas averaging 1,200 population).

Click this link to access population and median household income for this BG
http://api.census.gov/data/2012/acs5?get=B01001_001E,B19013_001E&for=block+group:1&in=state:35+county:049+tract:000400.

The returned JSON values are:
[[“B01001_001E”,”B19013_001E”,”state”,”county”,”tract”,”block group”],
[“436″,”63287″,”35″,”049″,”000400″,”1”]]
Population (item B01001_001E): 436 with
Median household income (item B19013_001E) $63,287.

Select from thousands of subject matter items at the census block and block group levels.

Support Using these Resources
Learn more about demographic economic data and related analytical tools. Join us in a Decision-Making Information Web session. There is no fee for these one-hour Web sessions. Each informal session is focused on a specific topic. The open structure also provides for Q&A and discussion of application issues of interest to participants.

Regional Economic Information System Update

.. per capita personal income (PCPI) is the most comprehensive measure of individual economic well-being. The PCPI has been updated with new estimates for all counties and metros. Among all metros for which the PCPI was estimated, the Atlanta metro was ranked number 154 in 2008 and 269 in 2013. The PCPI changed from $39,889 in 2008 to $41,307 in 2013, a change of $1,418 (3.55%). How might changing economic conditions impact you? How can you use personal income estimates and related measures to assess the impact of regional economic change? This section reviews how you can access and use these data for any county or metro. See the Web version of this section with interactive table.

Update: The Regional Economic Information System (REIS) updates on November 19, 2015 with new estimates for 2014, extending the time series.

Visual Analysis of PCPI Patterns
The following map shows the Atlanta metro (view profile) with bold brown boundary. Counties are labeled with county name and 2013 per capita personal income.

Click graphic for larger view. View developed with CV XE GIS software.
See this section to learn about making custom metro maps.

PCPI estimates, available as an annual time series 1969 through 2013, are developed as a part of the Regional Economic Information System (REIS). A distinguishing characteristic of the REIS data is that they are a set of multi-sourced data organized and used to estimate personal income. Personal income, unlike money income, is income received by all persons from all sources. See additional information about these data. A second characteristic is, unlike the American Community Survey (ACS), the REIS are not based mainly on a sample survey but rather employer reported data. Third, the lengthy annual time series lends itself to use in modeling and trend analysis based on a set of consistently defined subject matter.

Per Capita Personal Income Change by County: 2008-2013 Change

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

Counties with Highest PCPI
The following graphic shows counties with the largest 2013 PCPI.

Use the interactive table to rank counties on other measures or rank within a state.

View Individual Metro Profile
Use this interactive table to select a metro and view the metro profile. The following graphic illustrates clicking the link shown in column 2 to display the metro profile for the Dallas metro.

Equivalently, click this link to view the Dallas metro profile.

Data Analytics Lab Session
Join me in a Data Analytics Lab session where we review accessing, integrating and using the REIS data with other data. There is no fee. Discuss how tools and methods reviewed in this section can be 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.

Metros 2014: Chicago-Naperville-Elgin, IL-IN-WI

… examining Chicago-Naperville-Elgin, IL-IN-WI metropolitan area dynamics:
• How will the market for single family homes change over the next 5 years? 20 years?
• How does economic prosperity in the Chicago metro compare to others?
• What are the patterns in metro rental income and homeownership/vacancy rates?
• How do patterns manifest themselves in different ways by county/neighborhood?
• How are demographic-economic characteristics trending?

We examine these types of topics in this section. Stakeholders can replicate applications reviewed here for this and other metros using ProximityOne resources.

.. this section now continuously updated … see Chicago Metro Situation & Outlook; see related Illinois Demographic-Economic Characteristics.

Metropolitan areas include approximately 94 percent of the U.S. population — 85 percent in metropolitan statistical areas (MSAs) and 9 percent in micropolitan statistical areas (MISAs). Of 3,143 counties in the United States, 1,167 are in the 381 MSAs in the U.S. and 641 counties are in the 536 MISAs (1,335 counties are in non-metro areas).

See this section as the corresponding more detailed ProximityOne Web page.

Focus on Chicago-Naperville-Elgin, IL-IN-WI MSA
This section is focused on the Chicago-Naperville-Elgin, IL-IN-WI MSA; Core-Based Statistical Areas (CBSA) 16980. It is not intended to be a study of the metro but rather illustrate how relevant decision-making information (DMI) resources can be brought together to examine patterns and change and develop insights. The data, tools and methods can be applied to any metro.

The Chicago-Naperville-Elgin, IL-IN-WI MSA is shown in the graphic below. The 14-county metropolitan statistical area is shown with bold brown boundary; counties appear with black boundaries and county name labels. The thematic pattern shows a measure of economic prosperity (median household income: MHI) by census tract.

Click graphic for larger view. Map developed using CV XE GIS. Develop variations of this map view using the Mapping Illinois Neighborhood Patterns GIS resources.

Metro-County Geographic-Demographic Structure
The Census 2010 population of the metro was 9,461,105 (3rd largest in the U.S.) compared 9,537,289 (3rd largest in the U.S.) based on the 2013 estimate. See interactive table to examine other metros in a similar manner.

Click here to view a metro by county profile for the Chicago metro. Click the county component links below to view annual county population estimates and components of change.
• Cook, IL (17031)
• DeKalb, IL (17037)
• DuPage, IL (17043)
• Grundy, IL (17063)
• Kane, IL (17089)
• Kendall, IL (17093)
• Lake, IL (17097)
• McHenry, IL (17111)
• Will, IL (17197)
• Jasper, IN (18073)
• Lake, IN (18089)
• Newton, IN (18111)
• Porter, IN (18127)
• Kenosha, WI (55059)

Use this interactive table to view demographic attributes of these counties and rank/compare with other counties.

Population Pyramids & Age-Cohort Patterns
The graphic below shows the Census 2010 Cook County, IL population pyramid. Click graphic to view as HTML section with related Census 2010 age-gender population distribution.

Cook County, IL; Census 2010; Total population

Use ChartGraphics examine population by age-gender-race/origin for any county.

County Population Projections to 2020 and Beyond
The following view shows counties in the metro area. Counties are labeled with name; bar charts show Census 2000, Census 2010 and the ProximityOne projection to 2020. The CV XE GIS identify tool (see pointer) is used to show a mini-profile for one county. Kendall County, IL is projected to change from 115,206 as of Census 2000 to 173,343 in 2050. See more about how USA TODAY used ProximityOne projections to analyze diversity, 1960 to 2060. More about diversity below.

Click graphic for larger view. Map developed using CV XE GIS.

Diversity by Neighborhood in the Chicago Region
Diversity Patterns Neighborhood/Census Tract
Census tracts are colored based on value of the diversity index. See color patterns assigned based on diversity index values as shown in legend at left of the map. Blue tracts are most diverse; red tracts are least diverse. Tracts shown with black cross-hatched pattern are tracts with 50-percent or more Hispanic population. See more aboutneighhborhood diversity in the Chicago area.

Click graphic for larger view. Map developed using CV XE GIS.

Metro Demographic-Economic Characteristics
In 2012, the metro median household income was $59,261, percent high school graduates 86.8%, percent college graduates 34.8% and 14.5% in poverty. Use the following U.S.-state-metro interactive table to view/compare/rank compare this metro with other areas:
• General Demographics — http://proximityone.com/usstcbsa12dp1.htm
• Social Characteristics — http://proximityone.com/usstcbsa12dp2.htm
• Economic Characteristics — http://proximityone.com/usstcbsa12dp3.htm
• Housing Characteristics — http://proximityone.com/usstcbsa12dp4.htm

Metro Cities & Places
Click link to view profile for the metro principal cities:
• Arlington Heights
• Chicago
• Des Plaines
• Elgin
• Evanston
• Hoffman Estates
• Naperville
• Schaumburg
• Skokie
• Gary
View similar profile for any Illinois city — Illinois Community Profiles

Drill-down Analysis
The following view illustrates how a set of block groups in Chicago can be visually selected and analyzed using site analysis tools. The cross-hatched areas are 14 block groups in a study area that were visually selected using the mouse. A mini-profile in the lower right grid shows the 14 area aggregate for selected race origin items. The total population for these 14 block groups is 19,979. Perform this type of operation for any set of block groups for wide-ranging demographic-economic measures.

Click graphic for larger view. Developed using CV XE GIS.

Click the View File button, the selected 14 block group records are shown in the grid below. Optionally save and output these block group records for further analysis.

Click graphic for larger view. Developed using CV XE GIS.

About Metropolitan Areas
By definition, metropolitan areas are comprised of one or more contiguous counties. Metropolitan areas are not singlecities and typically include many cities. Metropolitan areas are comprised of urban and rural areas and often have large expanses of rural territory. A business and demographic-economic synergy exists within each metro; metros often interact with adjacent metros. The demographic-economic make-up of metros vary widely and change often. See more about metros.

Support Using these Resources
Learn more about demographic economic data and related analytical tools. Join us in a Decision-Making Information Web session. There is no fee for these one-hour Web sessions. Each informal session is focused on a specific topic. The open structure also provides for Q&A and discussion of application issues of interest to participants.

Using the New Census 2010 PUMS Data

.. you can now create/use custom demographic estimates by Public Use Microdata Area (PUMA), state and the U.S. based on the Census 2010 Public Use Microdata Sample (PUMS) data.  The Census Bureau released the Census 2010 PUMS data this week (November 12, 2014). Use custom estimates to enhance knowledge about the demographic size and composition not otherwise possible. Learn more about your markets, clientele served and previously unknown opportunities.

The Census 2010 PUMS is a 10-percent sample, making the sampling rate 10 times larger that the American Community Survey 1-year PUMS data.  For example, there are 135,513 unweighted person records in the Census 2010 Hawaii PUMS and 14,286 unweighted person records in the ACS 2013 1-Year PUMS. As a result, many more detailed population and housing attributes can be estimated using the Census 2010 PUMS compared to ACS 1-year PUMS.  For example, using the Census 2010 PUMS, it is possible to develop usable estimates of the Native Hawaiian alone or in combination with other races population crossed by age and other attributes by PUMA … or the Asian Indian alone or in combination with other races population crossed by age and other attributes by PUMA.

Southern California Percent Asian Population by PUMA

Public Use Microdata Sample (PUMS) files provide a way to develop custom estimates of demographic summary statistics for PUMAs, states and the U.S. Both Census 2010 and American Community Survey (ACS) PUMS files are comprised of samples of individual respondent person and housing unit records. The ACS PUMS files are released annually providing a means to develop similar custom estimates with annual updates.

There are 2,378 2010 Public Use Microdata Areas (PUMAs) covering the U.S. wall-to-wall. PUMAs have a minimum of 100,000 population and where possible coterminous with a set of census tracts and county boundaries. As an example, there are 69 PUMAs that comprise Los Angeles County. See more about 2010 PUMAs.

See the related Web section Census 2010 PUMS.

Support Using these Resources
Learn more about demographic economic data and related analytical tools. Join us in a Decision-Making Information Web session. There is no fee for these one-hour Web sessions. Each informal session is focused on a specific topic. The open structure also provides for Q&A and discussion of application issues of interest to participants.

Power of Combining Maps with Data

.. Geographic Information Systems (GIS) provide flexible and powerful capabilities to combine maps with data. Here we review easy-to-use examples of how you can do more with GIS tools. 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.

GIS provides us with a way to improve collaboration; we can more easily comprehend and understand geographic relationships and patterns among “variables.” 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.

Toward these ends, GIS applications provide dynamic map atlas/reference maps, thematic pattern maps and geospatial analysis capabilities. Examples of these three types of GIS applications are provided below. You can explore these applications on your own computer and modify the applications to meet your own geographic and subject matter needs.

1. Install the GIS Software and Project

• Install CV XE GIS (Windows-based computer)
• Create the folder c:\hawaii2014
• Expand GIS Project Fileset to c:\hawaii2014.
— requires ProximityOne User Group (join now, no fee).
• With CV XE GIS running, open the “Hawaii2014” GIS project
— File>Open>Dialog and select c:\hawaii2014\hawaii2014.gis

Start-up View: Honolulu:

Click graphic for larger view.
See more about this GIS Project.

2. Making/Using a Reference Map
With CV XE GIS running, open the Hawaii2014 GIS reference project
— File>Open>Dialog and select c:\hawaii2014\hawaii2014_reference.gis
The start-up view (below) is a reference map of the Houston, TX area. One metro is selected using a query; counties are labeled. It is easy to see the counties that comprise the Houston metro, their names and locations. Try it yourself. Navigate to any metro.

Click graphic for larger view.

3. Making/Using a Thematic Pattern Map
With CV XE GIS running, open the Hawaii2014 GIS pattern project
— File>Open>Dialog and select c:\hawaii2014\hawaii2014_pattern.gis
The start-up view (below) is a thematic pattern map of the 48 states showing metros by median household income. See color/value patterns in the legend at the left of the map panel. It is easy to see the how metros vary by median household income. Try it yourself. Change the colors/interval patterns. Label the metros with name. Zoom-in to any region. Add your own layers/data.

Click graphic for larger view.

4. Using Geospatial Analysis
With CV XE GIS running, open the Hawaii2014 GIS project
— File>Open>Dialog and select c:\hawaii2014\hawaii2014.gis
This is the basic GIS project; start SiteAnalyst: Analytics>SiteAnalyst.
The graphic below shows a site analysis view of schools selected by a circle. Attributes of the schools to analyze has been set to enrollment by grade (6 grades K-6 — upper right panel). As the selection is made, the schools are selected and enrollment summarized/aggregated (lower right grid). It is easy to see the aggregate enrollment by grade. Try it yourself. Select a different set of items to be aggregated. Select a different set of schools. Zoom-in to any area of interest. Add your own layers/data.

Click graphic for larger view.

Support Using these Resources
Learn more about demographic economic data and related analytical tools. Join us in a Decision-Making Information Web session. There is no fee for these one-hour Web sessions. Each informal session is focused on a specific topic. The open structure also provides for Q&A and discussion of application issues of interest to participants.

Using Site Analysis Tools

.. tools that you can use for visually-based demographic-economic analysis and decision-making …
• how many of your existing/prospect client locations are in a custom defined geographic area — like 10 miles from a store location?
• how many students are enrolled in free/reduced fee lunch programs in a selection of schools in a neighborhood/area?  
• What is the population of a certain age in a set of custom selected block groups in a study area?
• What is the size of the Asian population in a group of selected counties?

These are questions that are easily answered using GIS site analysis tools that can be challenging when using tabular data files and spreadsheets. Often the selection of the geographies (schools, block groups, counties) is more easily performed with visual GIS tools rather than codes in a list. See corresponding Web page.

Visually Selecting Counties to Examine Demographic Trends

Mouse used to select areas; demographic profile at right of map.
Above application reviewed below; emulate for your areas of interest.

This section provides an overview of using the CV XE GIS Site Analysis operations with the Hawaii 2014 GIS project (see main section). The Site Analysis operations enable you to visually select multiple geographic objects (points, lines, area) that comprise a study area (e.g., a selection of 5 census tracts, a selection of 10 schools, etc.). Use the Site Analysis operations to:
• select more or different objects,
• output data records associated with selected objects,
• aggregate demographic-economic characteristics for those selected objects,
• output/save the aggregated data for the collection of selected objects.

These operations are not specific to the Hawaii 2014 GIS project (independent of any specific GIS project) but are illustrated here in context of that project.

To use this CV XE GIS feature, you must code your User Group ID (no fee, join now) in the “Key” edit box shown in the Settings>Start-Up form. This is a one-time change that enables operation of this feature.

Starting Site Analysis
With CV XE GIS running, click Analytics>SiteAnalyst. The Hawaii2014 GIS project opens. The no fee version of Site Analysis operates only with the Hawaii2014 GIS project.

Schools Application
The following steps illustrate use of Site Analysis with the public schools layer.
• click the name of the K12 public schools layer in the legend panel at left of map.
… it turns blue and is the “active” layer.
• the Site Analysis panels appear at right of map. Dbl-click “SCHID’.
• scroll down in the upper right section and select FRELCH, REDLCH, TOTFRL (illustrated in graphic below).
• in the map window, click on location shown at pointer and drag mouse to one mile radius and release.
• schools intersecting with the circle are selected; their summary characteristics are shown in the lower right grid.
• there are 8 cross-hatched (in map) schools selected, the total free and reduced lunch enrollment is 2,094 students.
• more details about the operations are covered in Web sessions.

Click graphic for larger view.

Census Tracts Application
The following steps illustrate use of Site Analysis with a census tracts layer.
• click the name of the Tracts %HS Graduate layer in the legend panel at left of map.
… it turns blue and is the “active” layer.
• the Site Analysis panels appear at right of map. Dbl-click “GEOID’.
• scroll down in the upper right section and select D028 (total population) and D039 (Asian population).
… illustrated in graphic below.
… item names and descriptions shown here.
• in the map window, click on location shown at pointer and drag mouse to intersect with two tracts and release.
• tracts intersecting with the circle are selected; their summary characteristics are shown in the lower right grid.
• there are 2 cross-hatched (in map) tracts selected, the total Asian population is 4,523.
• more details about the operations are covered in Web sessions.

Click graphic for larger view.

County Application — in California
The following steps illustrate use of Site Analysis with a county layer.
• click the name of the Counties layer in the legend panel at left of map.
… it turns blue and is the “active” layer.
• the Site Analysis panels appear at right of map. Dbl-click “GEOID’.
• scroll down in the upper right section and select items illustrated in graphic below.
… item names and descriptions shown here.
• in the map window, click on location shown at pointer and drag mouse to intersect with two counties and release.
• counties intersecting with the circle are selected; their summary characteristics are shown in the lower right grid.
• there are 2 cross-hatched (in map) counties selected, the total Census 2010 population was 12,828,837.
• more details about the operations are covered in Web sessions.

Click graphic for larger view.

Summary Data to Clipboard
When the lower right grid summary updates, the grid values are written to clipboard. The content of clipboard can optionally be pasted in spreadsheet software. An augmented view of the clipboard data for the above application is shown below.

Click graphic for larger view.

View/Export Selected Records for Selected Geographies
Click View File button to view the selected records (contained in the active shapefile dBASE file). The following view shows the selected records in the county application. Note that only the two records are selected. These records could optionally be exported/saved using the CopyTo button. This view illustrates use of the “Field Location Manager” (FLM) button in tool bar. Use of FLM does not affect structure of the dBASE file. Keying into a field value immediately and permanently modifies the record.

Click graphic for larger view.

More Information About Site Analysis
Only selected features of Site Analysis have been shown here. See more information at Site Analysis operations.

Support Using these Resources
Learn more about demographic economic data and related analytical tools. Join us in a Decision-Making Information Web session. There is no fee for these one-hour Web sessions. Each informal session is focused on a specific topic. The open structure also provides for Q&A and discussion of application issues of interest to participants.