Tag Archives: American Community Survey 2014

Crime Data Analytics

Goto ProximityOne .. examining crime incidence and socioeconomic patterns and analyzing small-area and location-based data.

.. what are the crime patterns in neighborhoods or areas of interest? It is challenging to get useful answers to this type of question. Crime incidence data by location/address are often difficult or not possible to obtain. Even where the location-based crime data are available, the data must be geocoded, e.g., assigned a census block code to each address. Separately demographic-economic must be organized to examine contextually with the crime data.

Integrating Crimes by Location & Patterns of Economic Prosperity
– View developed using CV XE GIS and related GIS project.

Crime Data Analytics. Use the Crime Incidence and Socioeconomic Patterns GIS project and associated datasets to explore relationships between crime and small area demographic-economic characteristics. Follow the steps described below to study patterns and relationships in Kansas City and/or use this framework to develop similar data analytics for other areas.

Framework for a case study. 409 of Missouri’s 4,506 block groups are within the jurisdiction of the Kansas City police department (KCPD) and had one or more crimes in 2014 (latest fully reported year). There were approximately 10,400 crimes recorded by the KCPD in 2014, in the city area spanning four counties. In this section tools and data are used to examine crime patterns in Kansas City, MO. Crime data are included as markers/locations in a GIS project. Crime data are also aggregated to the census block level and examined as summary data (aggregate crimes by census block). Crime data are related to American Community Survey (ACS) 2014 5-year demographic-economic data at the block group geographic level.

To perform these types of analyses, it is important to start with location-based crime data that have been attributed with type of offense (offense code). Ideally, each crime incidence data record includes minimally the offense code and address of the crime. Such location-based crime incidence data have been acquired from the KCPD. These data are used to develop a shapefile that can be included in a GIS project.

Patterns of Crime Incidence in Kansas City, MO
The following graphic shows patterns of crime incidence by census block for the “Plaza Area” within Kansas city. This view shows all types of crimes aggregated to the census block level. Crimes committed where a handgun was involved are shown as black/red circular markers. Click the graphic for a larger view that shows legend and more detail.
– View developed using CV XE GIS and related GIS project.

Related views (click link to view graphic in new window):
Use the GIS project to develop variations of these views. Optionally add your own data.
Lay of the land: Kansas City city (cross hatched) in context of metro
All crimes as markers in Kansas City in 2014

Patterns of Economic Prosperity & Crime Incidence
The following graphic shows patterns of economic prosperity (median household income $MHI) by block group for the same general area as above. This view illustrates how two types of crimes (burglary blue triangle markers and homicide (red/black square markers) can be examined in context. Click the graphic for a larger view that shows legend and more detail.

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

Related views (click link to view graphic in new window):
Use the GIS project to develop variations of these views.
View similar to above, without $MHI layer

Data used to analyze patterns of economic prosperity/$MHI are based on the American Community Survey (ACS) 2014 5-year estimates at the block group geographic level. The same scope of subject matter is available for higher level geography. The GIS project/datasets includes many types of demographic-economic subject matter that can be used to display/analyze different socioeconomic patterns.

Using Block Group Geography/Data
Census Block Groups sit in a “mid-range” geography between census blocks and census tracts. All cover the U.S. wall-to-wall and nest together, census blocks being the lowest common denominator for each. Block Groups (BGs) are the smallest geographic area for which annually updated ACS 5-year estimates data are tabulated.

Advantages of using BG geodemographics include the maximum degree of geographic drill-down (using ACS data) … enabling the most micro-perspective of demographics for a neighborhood or part of study area. A disadvantages of using BG estimates is that typically the smaller area estimates have a relatively higher error of estimate.

Crime Incidence and Socioeconomic Patterns 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 CISP GIS Project fileset
… requires ProximityOne User Group ID (join now)
… unzip CISP GIS project files to local folder c:\crime
3. Open the kcmo_crimes_2014.gis project
… after completing the above steps, click File>Open>Dialog
… open the file named C:\crime\kcmo_crimes_2014.gis
4. Done .. the start-up view shows the crime patterns.

Weekly Data Analytics Lab Sessions
Join me in a Data Analytics Lab session to discuss more details about accessing location-based data and block group demographics and integrating those data into analytical applications.  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.

Examining School District Demographic-Economic Patterns

.. the importance of understanding the demographic-economic make-up and trends for school districts can hardly be overstated. Community and educational challenges and opportunities are shaped by demographic-economic dynamics. Only by knowing “where we are” can we develop the most effective plans for improvement.

This section reviews tools, resources and methods that you can use to access, integrate and analyze demographic-economic data. The U.S. national scope ACS 2014 (released December 2015) School District Demographic-Economic Dataset contains approximately 600 subject matter items tabulated for each school district organized into four subject matter groups:
  • General Demographics
  • Social Characteristics
  • Economic Characteristics
  • Housing Characteristics
See similar interactive tables for: Census Tracts | ZIP Codes | State, Metro & County.

These data provide information and insights not available by examining data of students and schools alone — or any other data. See more about the importance of these data. Data are based on the American Community Survey (ACS)2014 5-year estimates for school districts defined as of the 2013-14 school year.

Patterns of Educational Attainment by School District
This view shows percent population 25 years and over with bachelor’s degree by school district; Texas and south central U.S. The thematic pattern shows item S067 shown in the interactive table. Click graphic for larger view, more detail and legend color/data intervals. This map illustrates the relative ease to gain insights into school district patterns using geospatial data analytics tools.

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

Using GIS software and project datasets, you can create zoom-in views, label geographic objects, add your own data, select different subject matter, change intervals/colors and perform a wide range of geospatial analyses.

Get a Custom Map for Your Area of Interest
Use this form to request a no fee map graphic similar to the one shown above for a state of interest. Enter the request with state name in the text section; e.g., “Requesting school district pattern map for Illinois.”

Using the Interactive Table
Use the interactive table in this related section to view, query, rank, compare social characteristics of the population among a set of school district — or view characteristics of a selected district.

The following graphic illustrates use of the interactive table; click graphic for larger view. This view shows school districts in the Dallas, TX metro ranked in descending order on item S067 (Percent bachelor’s degree or higher). Highland Park ISD has the highest value of 83.1%.

Try it for a metro of interest — get metro 5-character code here. Go to the Social Characteristics table, then:
  • Click ShowAll button below table.
  • Click AvgHHSize… button below table.
  • Paste the 5-character metro code in the edit box to right of CBSA> button.
    … overwriting the value 19100.
  • Click the CBSA> button.
  • Click the S067 column header; click again to sort in other direction.
    … Done!

Weekly Data Analytics Lab Sessions
Join me in a Data Analytics Lab session to discuss more details about using school & school district 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.

Importance of Census Tracts in Data Analytics

census tracts are important for many reasons. It is easy to misidentify or misunderstand patterns and characteristics within cities, counties and metros which become obfuscated using these higher level, more aggregate, geographies. Many cities and counties that might be experiencing demographic-economic decline will often have bright spots that are groups of a few or many census tracts.

Patterns of Percent Population with Bachelor’s Degree
— by Census Tract; Los Angeles Metro
The following graphic shows percent population age 25 years and over with bachelor’s degree by census tract based on ACS 2014 5 year estimates for a portion of the Los Angeles metro. Accommodating different demographic-economic thresholds/patterns, different legend color/data intervals are used. The pattern layer is set to 80% transparency enabling a view of earth features. Click graphic for larger view, more detail and legend color/data intervals. This map illustrates the geographic level of detail available using census tract demographics and the relative ease to gain insights using geospatial data analytics tools.

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

Get a Custom Map for Your Area of Interest
Use this form to request a no fee map graphic similar to the one shown above for a county of interest. Enter the request with county name and state in the text section; e.g., “Requesting social characteristics tract map for Cook County, IL.”

This section reviews reasons for the importance of census tracts in data analyyics. See related Web sections on tools, resources and methods that you can use to access, integrate and analyze U.S. by census tract general demographics data. The U.S. national scope Census Tracts Demographic-Economic Dataset contains approximately 600 subject matter items tabulated for each census tract organized into four subject matter groups:
General Demographics
Social Characteristics
Economic Characteristics
Housing Characteristics

Importance of Census Tracts for Data Analytics
Census tracts are important for many reasons.  A partial list of reasons is provided below.
• Covering the U.S. wall-to-wall, census tracts are the preferred “small area” geography for superior data analytics.
• The Census Bureau now produces annual tract demographic-economic data from the American Community Survey;  there is an evolving time-series at the tract level creating new analytical opportunities.
• Originally developed to equivalence neighborhoods, many still do.
• Defined by the Census Bureau in collaboration with local groups, tracts typically reflect boundaries meaningful for local area analysis.
• Defined generally for use with each new decennial census, most tract boundaries are stable and non-changing for ten years and many much longer.
• Designed to average 4,000 population, there are more than twice as many census tracts (73,056) than ZIP code areas (33,129).
• Tract boundaries are well-defined; unlike ZIP code areas which are subject to multi-sourced geographic definitions.
• Many data developers (e.g., epidemiologists) use census tract geography to tabulate their own small area data enabling more effective use of those data with Census Bureau census tract data.
• As a statistical geographic area (in contrast to politically defined areas, census tracts are coterminous with counties; data at the census tract level can be aggregated to the county level.
• Small area estimates for tracts are typically more reliable than for block groups.
.. census tracts are comprised on one or more coterminous block groups.
.. on average, a census tract is comprised of three block groups.
• Census tracts are used by many Federal, state and local governments for compliance and program management.

The annually updated American Community Survey provides “richer” demographic-economic characteristics for national scope census tracts. While Census 2010 provides data similar to those items in the General Demographics section, only ACS sourced data provide details on topics such as income and poverty, labor force and employment, housing value and costs, educational participation and attainment, language spoken at home, among many related items. The approximate 600 items accessible via the tract dataset are supplemented by a wide range of additional subject matter. ACS census tract data are updated annually in December of each year.

Weekly Data Analytics Lab Sessions
Join me in a Data Analytics Lab session to discuss more details about using census tract geography and 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.

Navigating the Federal Statistical System: Important County Level Data Updates

.. several important U.S. by county demographic-economic data resources become available in the November-December time period .. review how these data mesh with your needs and mark your calendar.

There are many reasons that national scope county-level data are important. The county geographic level is the most widely used statistical data summary level. While many analyze ZIP code data, there is a narrow range of ZIP code summary data available compared to county level data. Counties offer a good geographic drill-down; data can be analyzed for sub-metro and sub-state areas. County geography changes very little over time; counties offer more geographic stability for long-term analysis than metros (above them) or census tracts (below them).

Regional Economic Information System
Personal Income by Major Source
… most comprehensive measure of per capita economic well-being
Annual update; annual time-series
Bureau of Economic Analysis; November 19, 2015
More information .. set data release date reminder.

American Community Survey 2014 5-year Data
Demographic-Economic Estimates
… broadest range of demographic-economic data
    for county and subcounty geography
Annual update
Census Bureau; December 3, 2015
More information .. set data release date reminder.

Establishments, Employment & Wages by detailed type of industry
… establishments summary data by most detailed type of business
… quarterly
… six month lag from data reference to data access
Quarterly update; 2015Q2; extends time series
Bureau of Labor Statistics; December 17, 2015
More information … updated today with 2015Q1 interactive table.
Set data release date reminder.

There are other important metro and small area Federal statistical resources becoming available in this period. See related section Navigating the Federal Statistical System for a more in-depth resource.

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. Contact Warren. Join Warren on LinkedIn.