Tag Archives: API Tools

Accessing & Using ZIP Code Demographics

.. tip of the day .. a continuing weekly or more frequent tip on developing, integrating, accessing and using geographic, demographic, economic and statistical data. Join in .. tip of the day posts are added to the Data Analytics Blog on an irregular basis, normally weekly. Follow the blog to receive updates as they occur.

… February 2017 updates .. 5 ways to access/analyze the most recent estimates of median housing value and other subject matter by ZIP Code area .. updates on accessing/downloading/using American Community Survey (ACS1115) 5-year estimates. See more detail in related Web section.

Site analysis (Option 5 below)
– create site analysis profiles from a location/ZIP code.

Contents
Five data access and use options, listed in the links below, are reviewed. Each method illustrates how ZIP code demographic-economic data can be accessed/ analyzed/used in different contexts. The most basic data access/data download is illustrated in Option 3. The following links open new windows that take you to the related section with more detail.
Option 1 – View the data as a thematic pattern map.
Option 2 – View, compare, rank query data in interactive tables.
Option 3 – Access data using API Tools; create datasets.
.. Option 3a – Extended ZIP Code subject matter access.
.. Option 3b – ZIP code urban/rural data access.
.. Option 3c – Additional API ACS data access resources.
Option 4 – View $MHI in structured profile in context of related data.
Option 5 – Site analysis – view circular area profile from a location.

Related ZIP Code Data Access & Use sections
Interactive access to demographics based on an address
Summary of ZIP Code Data Resources & Tools
10 Reasons to use Census Tracts Versus ZIP Codes
Analyzing Census Tract Demographics by ZIP Code Area
ZIP Code to Census Tract Equivalence Table
ZIP Code Urban/Rural Geography & Demographics
Mapping ZIP Code Demograhics
Housing Price Index by 5-digit ZIP Code – time series; annual updates
Housing Price Index by 3-digit ZIP Code – time series; quarterly updates
ZIP Code Business Establishment, Employment & Earnings by industry
ZIP Code Retail Trade Establishment & Sales by industry
ZIP Code Equivalence Tables — ZIP Code to School District

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.

Mapping Census Tract Demographics

.. using visual data analytics and developing business intelligence .. this section provides a 4-step procedure to develop thematic pattern and reference maps for census tracts. The focus of this section is on mapping Census 2010 census tracts using data from the 2014 American Community Survey (ACS2014). A similar set of steps could be followed for Census 2000 tracts with Census 2000 data or Census 2010 tracts with Census 2010 demographics or different vintage ACS data. Steps summarized here can be used with most any Windows-based computer having Internet access. See the related full Web section with more details.

• how do customers and sales relate to market area characteristics?
• is their a better configuration of locations or service areas?
• how can you more effectively examine customer and sales patterns?
• what and where are areas of missed opportunities?

See related sections:
Using GIS & Data Analytics
Mapping Statistical Data

Benefits of this section include providing help for those:
• having a specific interest in mapping census tract demographics.
• with little or no experience in using GIS.
• getting started with CVGIS.

These resources and instructions provide a real, not demo, valuable tool that anyone can use, without fee, to create county by census tract thematic pattern maps. Use any of the “richer” demographic-economic data (not just median household income) from the latest ACS 5-year data (see scope — table shells xls).

The steps described below can be performed with any version of CVGIS, including the no fee version. Start from scratch and develop thematic pattern maps like that shown below. Questions, need help? See the FAQs. Call with questions – 888.364.7656. Or, use this form and put questions in the text section.

While this application is focused on ACS 2014 median household income for Dallas County, TX census tracts, you can follow these steps for other areas and subject matter. In your own applications, choose any ACS subject matter for any county/area of interest. The following view shows the end result of steps described below. Choose your own county of state; choose your own subject matter; select your own colors and labeling; choose your own zoom view; and more. Dallas Metro Situation & Outlook.

Patterns of Economic Prosperity; Dallas County, TX by Tract

Mapping Census Tracts Demographics Steps
These steps should take an inexperienced user 10-15 minutes to develop a new CVGIS project view. Steps can be performed at separate times.
Click on a link to view step-by-step instructions.
1. Install CVGIS
2. Get census tract shapefile
3. Get census tract subject matter data (median household income or other)
4. Create map view(s)

Create your own maps for your own county/tracts for your own subject matter.

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.

Researcher & Story Development Tools & Resources

Innovative and results-oriented story writing often requires geographic, demographic, economic and related data. Research results and stories must increasingly use graphics and visual renderings of data  to be effective, retain reader attention and be responsive to needs. A picture is worth a thousand words. In our expanding everything-integrated world, stories must draw on a range of authoritative data resources that can be knit-together.

Journalists and authors require easy and access to these data in a consumable form. Researchers and students share these needs. Grant writers benefit by including relevant data in proposals and well as unique maps and graphics. Economists and analysts creating interpretative summaries of statistical data releases (“how does this impact us?”) require related data and tools to effectively communicate conclusions and inferences.

This section reviews access to a few of these tools and resources that are available to researchers and story writers — as well as tools to map and otherwise visualize these data. These resources offer the customization or specific detail often not available to meet specific needs. Most of the resources reviewed here are available at no fee. Some resources are available only to ProximityOne User Groupmembers. Join the User Group now. See terms of use. See related Web section.

Navigating the Federal Statistical Resources
… topics below include these and a broader set of resources.
http://proximityone.com/fss.htm

Interactive Geographic-Demographic-Economic Tables
… view, query, rank, compare attributes for many types of geography.
http://proximityone.com/rankingtables.htm

Interactive Location-Based Demographic-Economic Data Tool
… key in address, immediate display of ACS demographic-economic data.
… block group, tract, place, county, state data; latitude-longitude, geocodes.
http://proximityone.com/location_based_demographics.htm

Custom Mapping Tools (Windows software tool)
… create custom maps for proposed service areas.
CV XE GIS

Address Code Your Data (Windows software tool)
… show your address/location data on maps.
http://proximityone.com/apigeocoder.htm

Chart Graphics; Population Pyramids (Windows software tool)
… age-cohort chart graphics for your county or school district.
http://proximityone.com/chartgraphics.htm

Demographic-Economic Data Extraction Tool (Windows software tool)
… use this API-tool to extract your selected subject matter data.
… census block, block group, other geographic levels
… Census 2000, Census 2010, ACS 2010, 2011, 2012, 2013
… create your own files for use with Excel/other software.
http://proximityone.com/dede.htm

Custom maps can enhance your proposal; make custom map graphics:

Make Custom Congressional District Maps
… create custom maps for individual or custom grouped congressional districts.
… CD 113 and CD 114 boundaries are the same, based on maps submitted by states to the Census Bureau.
http://proximityone.com/cd113_maps.htm

Make Custom City Maps
… create custom maps for cities of interest; examine in context of other geography.
http://proximityone.com/citymaps.htm

Make Custom Metro Maps
… create custom maps for metropolitan or micropolitan statistical areas.
http://proximityone.com/metromaps.htm

Make Custom Neighborhood Maps
… create thematic/pattern maps; access related demographic-economic data by neighborhood.
http://proximityone.com/neighborhood_patterns.htm

Make Custom Block Group Maps
… create custom maps for small, sub-neighborhood areas.
http://proximityone.com/mapping_bg.htm

Make Custom Census Block Maps
… create custom maps for areas by census block – smallest geographic area with detailed demographics.
http://proximityone.com/mapping_census_blocks.htm

America’s Communities Program
… demographic-economic profiles for individual cities.
http://proximityone.com/acp.htm

School District Community Profiles
… demographic-economic multi-part profiles for individual school districts.
http://proximityone.com/sddep.htm

School District Characteristics
http://proximityone.com/sddmi.htm

K-12 Public Schools Characteristics – individual and all schools
http://proximityone.com/k12publicschools.htm

K-12 Private Schools Characteristics – individual and all schools
http://proximityone.com/k12privatecchools.htm

Charter Schools Characteristics & Patterns – individual and all schools
http://proximityone.com/sch1314_charter.htm

County Population Trends; Annual Projections to 2020 by Age Group
… population trends profiles for individual counties … how is school age population changing? 65 & over?
http://proximityone.com/outlook2020.htm
most recent county official estimates – click link in table
county trend profile – example for Cook County, IL; all counties available

Metropolitan Area Characteristics
… geographic & demographic composition profiles for individual metros.
Current Vintage Metropolitan Areas
2015 Updates: New and Modified Metros
Metropolitan Area Median Income and Housing Value: 2013-14

State Legislative District Characteristics
… geographic & demographic composition profiles for individual state legislative districts.
http://proximityone.com/sld2013.htm

Congressional District Characteristics
… geographic & demographic composition profiles for individual congressional districts.
http://proximityone.com/cd113.htm
114th Congressional Districts: Median Income and Housing Value: 2013-14

Census Tract Demographic-Economic Patterns
Main Census Tracts section interactive tables includes all tracts:
General Demographics | Social Characteristics | Economic Characteristics | Housing Characteristics

ZIP Code Demographic-Economic Patterns
Main ZIP Code section … interactive tables include all ZIP code areas:
General Demographics | Social Characteristics | Economic Characteristics | Housing Characteristics

More about ProximityOne Demographic-Economic Projections
Outlook 2020 | Outlook 2030 | Outlook 2060 | Quarterly 3 year
• integrated multi-sourced Situation & Outlook demographic-economic data

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.

Data Analytics Labs: Resources & Methods to Create & Apply Insight

.. it has always been that an important first step in Data Analytics was developing or acquiring the key data to be analyzed.  Having the right subject matter data for the right geography and time frame are essential prerequisites.  The Internet and pervasive expanding needs and solutions for data integration has made Data Analytics easier and more accessible — and often more technically challenging.  The Data Analytics Lab, reviewed here, offers a foundational and support framework to address the continually evolving Data Analytics needs. See more about the Data Analytics Lab in the related Web section.

Data Analytics involves more than the ability to perform statistical analyses on data, though this is an important element. Data Analytics encompasses a spectrum of data and the ability to develop, access, integrate and effectively use those data. The platform of data on which we operate is constantly in change. New and different types of data emerge. Older data become obsolete. Required subject matter are often not available at the required geographic granularity. Often the biggest challenge is in linking data for analysis.

Role of Geographic Information Systems (GIS)
GIS software is one on many Data Analytics tools. It is an important tool for many reasons. One main reason is the enabling ability to flexibly visually examine subject matter for different types of geography simultaneously. The following view shows patterns of economic prosperity in the Atlanta region (metro shown with bold boundary). The thematic pattern is median household income by block group. Higher income areas are shown in blue/green and lower income areas are shown in orange/red. Counties are shown with black boundaries.

The next view is a zoom-in to the pointer location in the map shown above. This view has a higher transparency setting enabling a see-though effect to view highways and related ground infrastructure. Block groups appear with black boundaries. The pointer is at the county boundary, a slightly bolder boundary.

Data Analytics Labs (DAL) help participants develop a capacity to create map views like those shown above and perform geospatial analyses. This is more than learning how to operate GIS software; more than how to acquire shapefiles and build a GIS project. It is about selecting and acquiring the right subject matter data and then integrating those data with geometry (shapefiles, etc.) and assembling the composite files for analysis. DAL learning enables participants to develop informative and relevant maps view — and the right types of different geographies (including vintages) to use.

Data Analytics Labs are set up within universities, government agencies and not-for-profit organizations to address these needs. Contact us to discuss how a Lab can be developed within your organization.

A Data Analytics Lab provides tools/resources for hands-on data analytics applications. In a university setting, the Lab can be open to MBA, MPA, MHA and other graduate students plus multi-disciplinary faculty/researchers. Also in the university setting, some parts of a Lab can fit into existing classes and mesh with other existing programs. There is no physical lab; it is a virtual lab. The resources and vision are initially focused on Census-type geographic-demographic-economic data, expanded to selected Federal statistical data, and how these and primary data are knitted together for analysis and decision-making.

There are no fees to participants. Tools and data are made available by ProximityOne — http://proximityone.com.

Data Analytics Lab Resources & Components
1. Software
    • CV XE GIS software
      – GIS shapefiles and applications compatible with ESRI ArcGIS software
    • API data access/integration software
    • Modeler software
      – cause & effect modeling; estimation & forecasting; impact analysis
    • Related software
2. Data Resources
    • state & national scope ready to use GIS projects
    • augmented TIGER/DMD geography
    • U.S. national scope 5-year demographic-economic estimates & projections
      –  small area demographic-economic estimates/projections to 2020
    • U.S. national scope county/up 2060 demographic projections
      – population projections to 2060 (single year of age x gender x race/origin)
    • ProximityOne Data Services (PDS)
      – multi-sourced Federal , Census and other data resources
3. U.S. by state/metro/county macro models (uses software and data above)
    • enable users to explore alternative model specifications/assumptions
    • produce alternative outcomes; perform impact analyses
4. Data Analytics Lab Sessions
    • variations on weekly Web-based sessions
5. Certificate in Data Analytics Modules
    • structured usage of Data Analytics Certificate program sessions/resources
6. Intern Participation: Data Analytics Tools Development and Applications
    • model specification & use; software development & use; data resource development & use

Forthcoming sections will review examples of Data Analytics Labs, how and where they are operating and experiences of participants.

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.

ZIP Code Demographic-Economic Characteristics

.. demographic-economic characteristics of ZIP code areas (ZCAs) are popular for many reasons. Businesses use ZCAs to examine sales patterns and market and sales territories and for planning and analysis; many client/sales related data may only be available by ZIP code. Analysts seek to knit together these business data with broader demographic-economic characteristics of the area/market — as reviewed here. Where are areas of missed opportunity relative to the size of the market? How is one or a group of ZIP code areas changing, and why? How might change impact you? This section provides an illustrative ZIP code area demographic-economic profile and reviews how you can create similar profiles, and datasets for linking your data and further analysis, for any ZCA.

ZIP code 77019, located in the Houston area, is used for illustration. The demographic-economic data/analyses reviewed here were generated using the ProximityOne Outlook2020 software. See that Web section for details about sources, scope and uses of data. Outlook2020 can be used to create these profiles and data extracts for any ZIP code area and many other types of geography.

ZIP Code 77019 in Context of Houston Area
ZIP code 77019 is shown at pointer.

… view created using CV XE GIS.

ZIP Code 77019 Patterns of Economic Prosperity
ZIP code 77019 is shown with bold black boundary. The thematic pattern map shows median household income by census tract.

… view created using CV XE GIS.

Using Outlook2020
Outlook2020 can be used to create a profile for ZCA 77019 (or any ZCA) as well as intersecting census tracts (shown in above view). The two following graphics present a partial view of the ZCA 77019 demographic-economic profile. It is easy to see columns of estimates for two years and their change. The basic profile includes approximately 170 demographic-economic characteristics.

Profile in XLS Structure

Profile in HTML Structure

ZCA 77019 Full HTML Demographic-Economic Profile
See the full profile in this related Web section.

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.

Mapping Block Group Data

.. demographic-economic patterns and characteristics can often be “masked” when using larger geographic areas such as counties and metros. Using data for small area geography such as census tracts and block groups can help identify clusters and areas of interest. Now, demographic-economic data for block groups (217,000 areas averaging 1,200 population covering the U.S. wall-to-wall) are tabulated annually from the American Community Survey (ACS). There are hundreds of subject matter items updated annually. Without specialized tools, it is very difficult to navigate through the maze of small area data that are available and make effective use of these data for analysis and decision-making.

Use the combination of API tools and GIS tools described in this Web section to visually and geospatially analyze demographic-economic characteristics of block groups. Covering the U.S. wall-to-wall and averaging 1,200 population, block groups are the smallest geographic tabulation area for data from the American Community Survey (ACS 5-year estimates). Block group (BG) data are also available from Census 2010 Summary File 1 (SF1) for the same block group area geography.

Patterns of Median Household Income
— San Francisco, CA by Block Group

Create map views similar to the one shown here for your areas of interest.

… Click graphic for larger view. View developed using CV XE GIS.

Install Tools
There are two software tools involved to create maps such as the one above for any county in the U.S. using block group level data for multiple years, flexibly choosing among more than a thousand subject matter items. Steps to use two tools are described in this Web section. You can perform these operations for any area in the U.S. and use the resulting maps and data in any manner.
• Demographic-Economic Data Extraction (DEDE) API tool
CV XE GIS software
See the corresponding Web sections above to install the Windows-based software. There is no fee to use these tools to perform operations described here. There are no block group subject matter datasets to download. The steps to use these tools are summarized here.

Get Help Using these Resources
The flexibility and breadth of data selection options afforded by access to thousands of subject matter items from multiple statistical programs requires several steps to use the data in GIS applications. Join us in a Data Analytics Lab session for additional assistance. We can go through/discuss any aspect of steps summarized here. There is no fee for the Data Analytics sessions.

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.