Category Archives: APIGateway

API Gateway

Block Group Demographic Data Analytics

.. use tools described here to access block group data from ACS 2016 (or ACS2017 in December 2018) using a no cost, menu driven tool accessing the data via API. Select from any of the summary statistic data. Save results as an Excel file or shapefile. Add the shapefile to a GIS project and create unlimited thematic pattern views. Add your own data. Join us in a Data Analytics Web session where use of the tool with the ACS 2017 data is reviewed.

See related Web section for more details.
– examine neighborhoods, market areas and sales territories.
– assess demographics of health service areas.
– create maps for visual/geospatial analysis of locations & demographics.

Illustration of Block Group Thematic Pattern Map – make for any area

– click graphic to view larger view
– pointer (top right) shows location of Amazon HQ2

Topics in this how-to guide (links open new sections/pages)
• 01 Objective Thematic Pattern Map View
• 02 Install the CV XE GIS software
• 03 Access/Download the Block Group Demographic-Economic Data
• 04 Download the State by Block Group Shapefile
• 05 Merge Extracted Data (from 03) into Shapefile (04)
• 06 Add Shapefile to the GIS Project; Set Intervals
• 07 Viewing Profile for Selected Block Group
• 08 BG Demographics Spreadsheet
• 09 Block Group Demographics GIS Project
• 10 Why Block Group Demographics are Important

Data Analytics Web Sessions
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.

API Integrated Data Profiles

Getting an integrated view of up-to-date decision-making information … many key demographic-economic measures are developed by different agencies and organizations. It can be challenging to assemble these data for a holistic, more comprehensive view. Differently sourced data are developed for varying time periods and frequency of update; it can be problematic in bringing together monthly, quarterly and annual data — and have the most up-to-date view possible.

This section is focused on the “APIGateway Integrated Data Profile” (IDP). The IDP is a report providing monthly, quarterly, annual and decennial data by county — any county in the U.S. See the current Mecklenburg, NC IDP. See more general information.

Mecklenburg County, NC (Charlotte NC-SC metro)

View illustrative IDPs:
Maricopa County, AZ (Phoenix metro)
Santa Clara County, CA (San Jose metro)
Johnson County, KS (Kansas City metro)
Harris County, TX (Houston metro)
Others

Create Your Own IDPs Now
Freshly updated IDPs can be generated for counties of interest using the no-fee, no-cost APIGateway. Follow these simple steps (How to Run Reports) to install the application on your Windows computer; create profiles of interest.

API Technology
Using API (Application Programming Interface) technologies, the APIGateway fetches data from multi-sourced servers where updated data are stored. There are no large database downloads; no custom application development steps.

The IDP reports are generated in HTML structure and can be easily viewed with a Web browser. The data, and thus the reports, update monthly. Optionally update an IDP in March/monthly, getting new/updated workforce data … establishments, employment, wages by industry sectors and employment/unemployment.

Longitudinal Data
An interesting feature of the report is that it shows the annual demographic-economic data for Census 2000 and Census 2010 as well as the annual American Community Survey data and Census Bureau annual model-based estimates in a side-by-side manner. This longitudinal data view using multiple data sources creates an easy-to-consume, powerful and unique way to gauge patterns and trends. Monthly workforce data provide a valuable, more recent, update.

Related County Demographic-Economic Data Resources
  • See CountyTrends Web section

IDP Updates
The IDP structure is new and continues to evolve. Please send feedback and suggestions that might improve usefulness.

Road Corridor Demographics

There are more than 50 million road segments in the U.S. While it is most common to view/analyze small area demographics for geographic areas such as census blocks, block groups or census tracts, the focus of this section is on providing demographic attributes for the left and right side of individual road segments. 

Road corridor demographics are demographics attached to the right- and left-sides of a road/street segment. These are demographics (e.g., population, housing, median income, etc.) for the census block or block group that the road segment faces or passes through. A road/street segment is the section of a road/street between two intersections.

Using road corridor demographics, the characteristics of chained/linked road segments, a pathway or a corridor, can be analyzed. Road segments have left- and right-side address ranges and road corridor demographics can be developed through the aggregation of address-oriented data located on the road of interest. Address data can be geocoded and attached to road segement. Examples include customers, housing sales, or patient data on a particular road segment.

See more details about developing and using road corridor demographics at road corridor demographics. The tools and methods described there are in production use. They may be applied to any county or higher-level geographic area in the whole U.S. This one-step batch application requires TIGER/Line edges, feature names and faces shapefiles. The CV XE API acquires the demographic data via Internet and codes these demographics into the road corridor shapefile, which is created as the primary output of the process.

The application demonstrated at road corridor demographics is focused on Alexandria, Virginia. The yellow highlighted road segment in the map graphic below is W. Braddock Road but could be any other set of roads.
alexrds1

Using these Resources
The CV XE GIS software available to members of the ProximityOne User Group (join now, no fee) can create the basic corridor demographics shapefile for any county in the U.S. The resulting shapefile may be used with CV XE GIS to perform analyses and/or used with other GIS software.

Small Area Disability Demographics

Goto ProximityOne   People with disabilities bring unique sets of skills to the workplace, enhancing the strength and diversity of the U.S. labor market. They make up a significant market of consumers, representing more than $200 billion in discretionary spending and creating technological innovation and entrepreneurship. People with disabilities also often rely on various government interventions to maintain their participation in the community. Demographic data about people with disabilities help stakeholders better understand needs and make more informed decisions relating to a wide range of topics concerning people with disabilities.

New Disability Demographics
Disability demographics from the American Community Survey (ACS) have been available for cities, counties and larger areas with population over 65,000 for a few years. New as of December 2013, are ACS 2012 5-year (ACS0812) disability demographics available for all cities, school districts, counties and geographies down to the census tract level — and ZIP code area. Disability demographics are often “masked” when analyzed for larger population areas. Masked, not in the sense of suppressed data, but that concentrations that might be identified at the census tract level may become less prominent when viewed in the aggregate of county or higher level geographies. This section reviews disability-related ACS0812 data available for these small area geographies and how they can be used to facilitate decision-making.

Disability Concepts
Subject matter categories about people with disabilities from ACS generally involve limitations with vision, hearing, cognitive, ambulatory, self-care or independent living difficulty.

• Vision — blindness or serious difficulty seeing even when wearing glasses
• Hearing — deafness or serious difficulty hearing
• Cognitive — difficulty concentrating, remembering or making decisions
• Ambulatory — serious difficulty walking or climbing stairs
• Self-care — difficulty bathing or dressing
• Independent living — difficulty going outside to shop or visit a doctor’s office

Visual Analysis of Disability Patterns by Census Tract
The following view shows the population ages 5-17 years with disabilities (ACS0812 estimates) by census tract for Harris County, Texas (Houston area). The inset legend shows color patterns associated with data from Table B18101 (see below).
acs0812_b18101_48201tracts1
The above view was developed using the CV XE GIS software with a GIS project. The GIS project includes a county by census tract layer with Table B18101 (see below) integrated subject matter. This particular view shows patterns of the sum of items B18101007 (males age 5-17 years with disability) and B18101026 (females age 5-17 years with disability). View all items in this table by opening excel file B18101 in the section below. Members of the ProximityOne User Group may download and use this project to develop similar views on their computer. Add other geographies to the view such as school districts or cities. Add your own data from any source. Join the User Group now, no fee.

Disability Subject Matter Data/Tables
View the scope of ACS 2012 5-year estimates subject matter using the interactive table at http://proximityone.com/acs0812.htm. Sort on the rightmost column and scroll to Disabilities. These same tables are listed below. Click a link on the table number to view a sample of the data (an excel file will open). All data tables are provided for Houston ISD (HISD), Texas school district. The same scope of data are available for any school district.

Table B18101 shows that there are more than 9,000 K-12 school age children with disabilities in Houston ISD (3,493 females, 6,133 males). Using the additional Table B18101 iterations, the distribution of this population can be examined by race and origin. Of course, school age children without disabilities can be impacted by other household members that do have disabilities. Demographics provided in these tables show characteristics for the total population and many age groups. Tables B18102 through B18107 provide insights into the number of persons by age and gender by type of disability. Table B18135 provides data on health insurance coverage. Employment status and workforce data are provided by Tables C18120 and C18121. Earnings and poverty characteristics data are provided by Tables B18140, C18130 and C18131.

ACS 2012 Disability Tables
B18101 — Sex by Age by Disability Status
B18101A — Age by Disability Status:  White alone
B18101B — Age by Disability Status:  Black or African American alone
B18101C — Age by Disability Status: American Indian and Alaska Native alone
B18101D — Age by Disability Status: Asian alone
B18101E — Age by Disability Status: Native Hawaiian and other Pacific Islander
B18101F — Age by Disability Status: Some other race alone
B18101G — Age by Disability Status: Two or more races
B18101H — Age by Disability Status: White alone, not Hispanic or Latino
B18101I — Age by Disability Status: Hispanic or Latino
B18102 — Sex by Age by  Hearing Difficulty
B18103 — Sex by Age by Vision Difficulty
B18104 — Sex by Age by Cognitive Difficulty
B18105 — Sex by Age by Ambulatory Difficulty
B18106 — Sex by Age by Self-Care Difficulty
B18107 — Sex by Age by Independent Living Difficulty
B18135 — Age by Disability Status by Health Insurance Coverage
B18140 — Median Earnings in the Past 12 Months
C18108 — Age by Number of Disabilities
C18120 — Employment by Disability Status
C18121 — Work Experience by Disability Status
C18130 — Age by Disability Status by Poverty Status
C18131 — Ratio of Income to Poverty Level Past 12 Months by Disability

Accessing & Using the Data
Access the above tables using the CV APIGateway. Integrate the disability-related data with other demographic-economic data from ACS 2012 and other data sources. Save data for multi-geography such as all census tracts for a county. Merge these data into a county by tract shapefile and use the CV XE GIS software to visually examine small area patterns of the population with disabilities.

Linguistic Isolation Patterns

Goto ProximityOne  Size and distribution data on speakers of languages other than English and on their English speaking ability are important for many reasons. These data help us understand where populations with special needs exist and how they are changing. The data are used in a wide-ranging legislative, policy, and research applications. Many legal, financial and marketing decisions involving language-based issues make use of data on language use and English-speaking ability.

This post reviews data useful to analyze “household linguistic isolation” based on American Community Survey (ACS) 5-year estimates at the block group geographic level. The same scope of subject matter is available for higher level geography.  The following graphic shows patterns of linguistic isolation in Queens County, NY.  Block groups colored in red have more than 50-percent of households where no household member age 14 years and over speaks English “very well”.

Patterns of Linguistic Isolation; Queens County, NYli_queens

One definition of a “linguistically isolated household” is a household in which all adults have substantial limitation in communicating English. In the ACS data, a household is classified as “linguistically isolated” if 1) no household member age 14 years and over spoke only English, and 2) no household member age 14 years and over who spoke another language spoke English “very well”.

Like many demographic measures, linguistic isolation tends to be “masked” when analyzing data for larger geographic areas, even census tracts, are used. Block group geography provides an ability to locate linguistic isolation in sub-neighborhood areas.

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 American Community Survey (BG) 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.

Language Spoken by Households
The table presented below shows data from ACS Table B16002 Households by Linguistic Isolation for block group 1 in census tract 046300 in Queens County (081) New York (36); geoid=360810463001. This block group is shown in the above map at the pointer. Data for this block group are shown in the rightmost column of the table below. 62.8 percent of households (610) are linguistically isolated (232+60+91).

Table B16002. Household Language by Households
Item Code Item Description Households
B16002001 Total 610
B16002002   English only 12
B16002003   Spanish language 321
B16002004     No one 14 and over speaks English only or speaks English “very well” 232
B16002005     At least one person 14 and over speaks English only or speaks English “very well” 89
B16002006   Other Indo-European languages: 60
B16002007     No one 14 and over speaks English only or speaks English “very well” 60
B16002008     At least one person 14 and over speaks English only or speaks English “very well” 0
B16002009   Asian & Pacific Island languages: 217
B16002010     No one 14 and over speaks English only or speaks English “very well” 91
B16002011     At least one person 14 and over speaks English only or speaks English “very well” 126
B16002012   Other languages: 0
B16002013     No one 14 and over speaks English only or speaks English “very well” 0
B16002014     At least one person 14 and over speaks English only or speaks English “very well” 0

“Language Spoken” categories are based on four major language groups.

Next Steps
Use the CV APIGateway to access Table B16002 and related data for block groups in cities or counties of interest.  Join us in the upcoming December 17, 2013 one hour web session where we talk about using the ACS 2012 5-year demographics for small area analysis.  Those new data are scheduled to be released that day.

ACS 2012 BlockGroup Data

Goto ProximityOne  There are several things to like about the new American Community Survey 2012 (ACS2012) 5-year demographic-economic data (available 12/17/13). These data are one year more recent data than released in December 2012 (the ACS 2011 5-year data).  As a result, they provide an updated and more current picture. Two, this is a third year sequel to having Census 2010 vintage census tract and block group data available.  This de facto three year mini-time series enables a start to examine trends. Three, these estimates are centric to mid-2010 and thus roughly comparable to what would have been “richer demographics” from Census 2010 (had the long-form not been eliminated).  This enables a rough comparison between 2000 and 2010 (it will be the best opportunity ever).  These data provide unique and powerful measures that facilitate development of decision-making information.  The ACS 5-year block group estimates are the smallest geographic areas for which the Census Bureau develops richer demographic-economic data such as income, educational attainment, employment, housing value among a wide range of related items.

The focus of this post is on block group level data … demographic-economic data tabulated for approximately 220,000 areas averaging 1,200 population covering the U.S. wall-to-wall.  Block groups are one of many geographic levels/areas for which ACS 5-year estimates are tabulated.  While it might seem easy to determine what subject matter data are available at the block group level, it is not easy.  Block group data cannot be accessed via the Census Bureau FactFinder online data access tool, so that presents the first challenge.  Fortunately, the ACS block group data can be accessed using the ProximityOne CV APIGateway tool.

Washington DC Area; Median Household Income by Block Group
dc_bg

Is unemployment data tabulated by block group?  Language spoken at home?  If so, what are the corresponding table numbers? Only selected tables are available at the block group level — a situation unique to the block group level geography.  Presently, the only way to determine availability of a subject matter item or data table is to view Appendix E of the technical documentation.  In that section, listing all tables, there is a column with an indicator showing whether or not the table is available at the block group level.

Struggling with this situation in years past, we have developed this Web page that contains an interactive table to facilitate determining subject matter availability by block group.  The interactive table contains a row for each data table for which ACS 2012 5-year data are tabulated.  In the interactive table, there is a column with an indicator showing whether or not that data table is available at the block group level.  This way all of the data tables can be browsed as well as those only available at the block group level.

Below the interactive table a few tool buttons are available.  Now you can do a keyword search on all tables for specific subject matter words, like “Language Spoken.”  Or, show the whole table and click the block group button to view only those tables available at the block group level.

ACS 2012 Public Use Microdata Sample (PUMS) Data
Soon there be related post focused on the ACS 2012 Public Use Microdata Sample (PUMS) data.  That post will also provide improved data navigation and locator tools.

County Monthly Workforce Trends

Goto ProximityOne  Keep up-to-date with current county monthly workforce patterns and trends using the CV APIGateway. Automatically updated with multi-sourced demographic-economic data, the APIGateway Integrated Profile (IP) provides monthly workforce updates from the Bureau of Labor Statistics (BLS) Census of Employment and Wages (place of work data) and Local Area Unemployment Statistics (LAU – place of residence data). This section is focused on data and analytical tools to examine county workforce trends and patterns using the Local Area Unemployment Statistics data.

A unique and important property of the LAU data is that they are the only source of semi-official data available on a national scale for each/all counties and larger places providing current and monthly data on unemployment and the unemployment rate. The next runner-up to these estimates are the ACS 5 year estimates that are a) for a five year period and b) at least 3 years old (to the mid-point of the estimate period) when they become available. These highly perishable and time-sensitive economic measures are important to understanding the relative and absolute strength or weakness of workforce conditions and the employment sector on a local and regional basis.

The table presented below is a section taken from the APIGateway IP for Santa Clara County, CA (San Jose-Cupertino metro). The monthly/annual LAU data shown in the table are available for each/all counties. The APIGateway IP shows these four workforce series from 2011 forward. It auto-updates monthly with only a two-month lag to the reference time period. View a series as a chart: click graphic; on new page click a link shown in the table. Optionally set a wider time interval.
Santa Clara County, CA Monthly Labor Force Characteristics
lau_sc1

Using GIS Resources for Visual Pattern Analysis
Separate from the APIGateway IP, the 2008-2012 annual time series data have been integrated into a U.S. by county shapefile. The graphic shown below illustrates how these tools can be used to examine the change in employment conditions by county since the recession started. This view shows the change in the unemployment rate from 2008 to 2012. Counties with red coloring experienced/are experiencing/ a 3-percent or more increase in the unemployment rate in 2012 compared to 2008. Using this measure alone, it is easy to see the extent to which the economy in many areas is still struggling to compensate for the recession impact and exactly which county/regional areas are impacted and how much. While one county might be prospering, many adjacent or nearby counties are not. View zoom-in to Santa Clara county area.

Interactive Table
Click the graphic shown below to use this interactive table to examine this same set of annual workforce data 2008-2012. Viewing the interactive table, click ShowAll button below table and then FindInName with default value “Santa Clara” to view the 5-year series for the same scope of subject matter as shown above in monthly form. The interactive table provides a convenient structure to view, rank, compare counties using these measures.

lau_table

Next Steps
The U.S. by county shapefile with workforce data shown in the table and used to develop maps shown in this section are available to ProximityOne User Group members. (join now, no cost). Use these resources to develop wide-ranging variations of this view and analyze tabular data on your own computer; integrate your own data; add other types of geography; zoom-in to specific metros/regions. Visit the CountyTrends Web section for more information on county demographic-economic data and analytics.