Tag Archives: CV XE GIS applications

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.

Characteristics of Largest 50 U.S. Metropolitan Areas

.. the total population of the largest 50 U.S. metropolitan areas as of 2014 (latest official estimates) was 174,886,265. These 50 metros account for 58.3% of the population in all 917 metropolitan areas and 54.8% of the total U.S. population. By either measure, more than half of the U.S. population resides in these 50 metros. Use tools and data resources described in this section to view and analyze these metros.

View the list of these metros by population rank in the scroll section provided below. Click on a metro link to view the Metro Situation & Outlook Report for that metro. The report provides extensive details on the geographic-demographic-economic attributes of the metro.

Use the largest_50_metros GIS project described in this section to map and explore characteristics of these metros. Create zoom-in views of metros/regions of interest. Label geography. Add other geography and data. The largest_50_metros GIS project/datasets includes all U.S. metros and has been used to develop the views in this section:
View 1 .. 50 Largest Metros Ranked on 2014 Total Population
View 2 .. All Metropolitan & Micropolitan Statistical Areas
View 3 .. Patterns of Percent Population Change 2010-2014
See details about using the largest_50_metros GIS project below in this section.

50 Largest Metros Ranked on 2014 Total Population
The following graphic shows the 50 largest metros by 2014 population rank (blue metros are the largest 10). Click graphic for larger view, more detail and legend color/data intervals (expand browser window for best view).

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

All Metropolitan & Micropolitan Statistical Areas
The following graphic shows all metropolitan statistical areas (blue) and micropolitan statistical areas (orange). Click graphic for larger view, more detail and legend color/data intervals (expand browser window for best view).

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

Patterns of Percent Population Change 2010-2014
The following graphic shows the percent change in total population from 2010 to 2014 for all metros. Click graphic for larger view, more detail and legend color/data intervals (expand browser window for best view). This map illustrates the relative ease to gain insights into patterns of population change using geospatial data analytics tools.

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

50 Largest Metros Ranked on 2014 Total Population — scroll section
Click link to view Metro Situation & Outlook Report

Largest 50 Metros GIS Project/Datasets
1. Install the ProximityOne CV XE GIS
… omit this step if CV XE GIS software already installed.
… run the CV XE GIS installer
… take all defaults during installation
2. Download the Largest 50 Metros GIS project fileset
… requires ProximityOne User Group ID (join now)
… unzip Largest 50 Metros GIS project files to local folder c:\largest_metros
3. Open the large_50_metros1.gis project
… after completing the above steps, click File>Open>Dialog
… open the file named c:\largest_metros\largest_50_metros1.gis
4. Done .. the start-up view is similar to the graphic shown at the top of this section.

Weekly Data Analytics Lab Sessions
Join me in a Data Analytics Lab session to discuss more details about using metropolitan area geography and using demographic-economic data.  Learn more about integrating these data with other geography, your data and use of data analytics that apply 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.

K-12 Data Analytics: Dallas ISD, Texas

.. using tools and data analytics methods for analysis of K-12 schools located in Dallas ISD school district, Texas .. use the interactive table in related section to examine demographic-economic characteristics of Dallas County by block group. Apply these tools and methods to your schools, school districts and related areas of interest. Contact me for details. Tools and methods described here can help leadership, staff and stakeholders answer key questions and facilitate strategic planning. See the related main Web section for more details and tools access.

Examining the Current Situation
While most schools and school districts know a lot about the students, often less is known about children’s living environment and the broader school district community. See the demographic-economic profile for Dallas ISD total population (compare to Dallas city). These profiles tell a story. It helps stakeholders know “where we are now.”

Use the annually updated School District Special Tabulation that provides similar data but for the grade relevant school age population by type of enrollment universe. See Dallas ISD Children’s Demographic-Economic Profile by Universe of Enrollment.

Dallas ISD School District in Context
Dallas ISD (bold brown boundary) shown in regional context.

  — view created using CV XE GIS and associated GIS Project

School Locations in Context
Zoom-in to Dallas ISD. Pointer at county boundary; Dallas ISD is located in Dallas County. Schools are shown by different types of markers. See markers/style in legend at left. Using the query feature, it is possible to identify charter schools as one type of marker, irrespective of grade range.

Use the national scope interactive tables to examine characteristics of individual public schools and individual private schools. Rank, query, compare and contrast schools within a state or on a national basis.


  — view created using CV XE GIS and associated GIS Project

Zoom-in View of Schools; School Characteristics
Further zoom-in shows schools labeled with name.  The identify tool is used to show a mini-profile of a school by clicking on the Edna Rowe school marker.
The partial view of the profile shows free and reduced lunch participation and enrollment by grade.

  — view created using CV XE GIS and associated GIS Project

School Attendance Zones
Elementary school attendance (black boundaries) are shown in the next graphic. Dallas ISD has three types of attendance zones (elementary, middle, high school). The query feature is used to show only elementary zones. Click graphic for larger view showing more detail.

  — view created using CV XE GIS and associated GIS Project

Cities/Places & School District
Cities/places are shown in the next graphic (cross-hatch pattern) in context with the school district. Places are non-incorporated areas of population concentration. Click graphic for larger view showing more detail; adjacent city/places shown with yellow diagonal cross-hatch pattern.


  — view created using CV XE GIS and associated GIS Project

Road Infrastructure
Roads/streets are added to the view as shown in the next graphic. Vital to student transportation planning and management, the street density view also helps view the scope of build-out. Click graphic for larger view showing more detail; mini-profile shows attributes of street segment by school/pointer.

  — view created using CV XE GIS and associated GIS Project

Schools in Context of Urban/Rural Geography
Census blocks are categorized as urban or rural based on Census 2010. The graphic below shows urban census blocks with an orange fill pattern. It is easy see that most of Dallas ISD is urban; but a large area in the southeast part of the district is rural. See related K-12 Schools by Urban/Rural Status
.

  — view created using CV XE GIS and associated GIS Project

Percent Population in Poverty by Census Tract
Census tracts are statistically defined geographic areas covering the U.S. wall-to-wall (73,057 areas). The view below shows patterns of percent population in poverty by census tract. Click on graphic to view larger view. Choose from hundreds of demographic-economic measures to assess patterns of well-being, age distribution, housing structure and age, educational attainment, housing value, race/origin, employment, language spoken at home among many others.

  — view created using CV XE GIS and associated GIS Project

See zoom-in view of Edna Rowe school vicinity with tract and %poverty labels

Patterns of Economic Prosperity by Block Group
Block groups are statistically defined geographic areas covering the U.S. wall-to-wall (217,740 areas) and nest within census tracts (see above). Block groups (BGs) provide a finer geographic granularity compared to census tracts. The view below shows patterns of economic prosperity as measured by the median household income (MHI). MHI interval/color patterns are shown in the highlighted layer at left of the map. Click on graphic to view larger version that uses the MHI as a label for each BG. Choose from hundreds of demographic-economic measures to assess patterns of well-being. This view illustrates use of transparency setting to “see through” the pattern layer to view the topology/road infrastructure.


  — view created using CV XE GIS and associated GIS Project

Dallas County Block Group Demographic-Economic Characteristics
Use the interactive table to view, rank compare Dallas County block group demographic-economic characteristics. See about Dallas County demographic trends. All block groups for the county are included in the table. Optionally key in an address using the location-based demographics tool to determine the block group code of interest. You can then use the Find button below the table to locate that block group. See about using block group codes — a 12 character code uniquely identifying that area.

Block Groups in Vicinity of School — Interactive Table
The graphic below illustrates use is the Dallas County block group interactive table. Block groups in census tract “48113012206” are shown in the table. This tract was selected as it contains the Edna Rowe school (location used above in maps). The school’s address was used in the location-based lookup tool. Do this for any school or address in Dallas County. It is easy to see that the Gini Index is low indicating high degree of income equality. It is easy to see and compare the number and type of housing units, median income, housing values, and rent. Try this process yourself:
1 – enter an address using this tool to obtain a census tract code see this example.
2 – below the interactive table click ShowAll button, enter your 11 character tract code, click Find.
All block groups in this tract will show as rows in the table.

Data Analytics Lab Session
Join me in a Data Analytics Lab session. 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.

Examining Metro Housing Value & Household Income Patterns

.. with release of the American Community Survey 2014 (ACS 2014) 1-year estimates, it is now possible to compare the annual change in a range of demographic-economic measures for individual metropolitan areas — metros with 65,000 or more population. For example, the change in median household income, 2013-to-2014 ranged from -$8,966 (Houma-Thibodaux, LA MSA) to $9,789 (Marshall, TX MISA). The change in median housing value, 2013-to-2014 ranged from -$23,200 (Pinehurst-Southern Pines, NC MISA) to $79,700 (Santa Cruz-Watsonville, CA MSA). While these are estimates, and subject to estimation error, these data offer new insights into recent levels and short-term change characteristics. This section reviews data and tools available to analyze metro patterns and characteristics.  See more detail in this related Web section.

ACS 2013 and 2014 1-year estimates are included in the interactive table for population, median household income and median housing value. The 2014 median housing value-to-median household income is also included. Where do your metros of interest rank? See the interactive table (also reviewed below).

2014 Median Household Income by Metro
The following graphic illustrates use of the ACS 2014 data to develop a thematic pattern map of median household income by metro (metros having 65,000 or more population). This graphic makes use of one subject matter item among hundreds of ACS subject matter items tabulated. Click graphic for larger view showing legend and mini profile example.

— view developed using CV XE GIS software and related GIS project.
— see details for information about the data used to develop the above view.

Metropolitan Area Housing Value & Household Income: 2013-2014
— the following graphics illustrate use of the full interactive table.

Interactive Table Start-up View
Individual metros are displayed by row. Attributes of metros are arrayed by column. Click column headers to sort/rank. The table is a scroll section showing all metros 65,000 population of more and is initially sorted on 2014 population in descending order. Use tools below the table to perform queries on the table.

– click graphic for larger view.

Using the Interactive Table for Peer Group Analysis
Set the population threshold to view only metros having population 100,000 to 500,000 (or any other range) and then click $MHI (median household income) 2014 column header to sort/rank this group on that column. Click a row; the row blue highlights. Optionally copy this row content to clipboard and paste in Excel or use with other software.

– click graphic for larger view.

ACS & Data Analytics
Data Analytics can help most any organization more effectively reach goals and objectives. Whether a new or established business, serving a county or national market, similar tools and methods apply. The ACS data provide one important part of the data for Data Analytics. Subsequent posts will illustrate how to integrate ACS data with other data to gain important insights.

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.