Category Archives: API

Application Programming Interface

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.

State and Regional Decision-Making Information

Organized on a state-by-state basis, use tools and geographic, demographic and economic data resources in these sections to facilitate planning and analysis. Updated frequently, these sections provide a unique means to access to multi-sourced data to develop insights into patterns, characteristics and trends on wide-ranging issues. Bookmark the related main Web page; keep up-to-date.

Using these Resources
Knowing “where we are” and “how things have changed” are key factors in knowing about the where, when and how of future change — and how that change might impact you. There are many sources of this knowledge. Often the required data do not knit together in an ideal manner. Key data are available for different types of geography, become available at different points in time and are often not the perfect subject matter. These sections provide access to relevant data and a means to consume the data more effectively than might otherwise be possible. Use these data, tools and resources in combination with other data to perform wide-ranging data analytics. See examples.

Select a State/Area

Alabama
Alaska
Arizona
Arkansas
California
Colorado
Connecticut
Delaware
D.C.
Florida
Georgia
Hawaii
Idaho
Illinois
Indiana
Iowa
Kansas
Kentucky
Louisiana
Maine
Maryland
Massachusetts
Michigan
Minnesota
Mississippi
Missouri
Montana
Nebraska
Nevada
New Hampshire
New Jersey
New Mexico
New York
North Carolina
North Dakota
Ohio
Oklahoma
Oregon
Pennsylvania
Rhode Island
South Carolina
South Dakota
Tennessee
Texas
Utah
Vermont
Virginia
Washington
West Virginia
Wisconsin
Wyoming

Topics for each State — with drill-down to census block
Visual pattern analysis tools … using GIS resources
Digital Map Database
Situation & Outlook
Metropolitan Areas
Congressional Districts
Counties
Cities/Places
Census Tracts
ZIP Code Areas
K-12 Education, Schools & School Districts
Block Groups
Census Blocks

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.

Tip of the Day — Census Tract Data Analytics

.. 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.

This section is focused on tools and methods to access and use census tract demographic-economic measures. Median household income ($MHI), median housing value ($MHV) and other selected items are used to illustrate operations and options.

This section illustrates use of census tract data from the 2014 American Community Survey (ACS1014) 5-year estimates. These are the most comprehensive demographic-economic data from the Census Bureau at the census tract level. These “5-year estimates” are centric to mid-2012. See more about 2010-2021 annual estimates and projections.

Methods described here apply to many other geographies; see related tip sections. See related section on ZIP code applications.

Five data access and use options are reviewed. Each method illustrates how $$MHI, $MHV and other data can be analyzed/used in different contexts.

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 4 – View $MHI in structured profile in context of related data.
Option 5 – Site analysis – view circular area profile from a location.

Related sections:
Census tracts main section
Evolution of Census Tracts: 1970-2010
Demographic-Economic Estimates & Projections
Census tract and ZIP code equivalencing
Using census tracts versus ZIP code areas
Single year of age demographics

Option 1. View the data as a thematic pattern map; use the GIS tools:
Patterns of Economic Prosperity ($MHI) by Census Tract … the following graphic shows $MHI 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; expand browser window for best quality view.

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

See details about each option in the related Web page.

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.

Tip of the Day: Median Rent by Metro

.. 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 .. click Follow button at upper right.

.. the most recent estimate of median gross rent [for occupied housing units paying rent] for metropolitan areas (core-based statistical areas) is as of 2014. These data are based on the American Community Survey (ACS2014) 1-year estimates.

Option 1. Use the interactive table:
– go to http://proximityone.com/usstcbsa14dp4.htm
– median gross rent is item H132.
– scroll left on the table until H132 appears in the header column
– this column shows the 2014 ACS 1-year estimate for H132 for all CBSAs
    (and states)
– see usage notes below table.

Option 2. Use the API operation:
click this link to get H132 (median rent) using the API tool.
– a new page displays showing a line/row for each metro.
– median rent appears on the left, then metro name and code.
– optionally save this file and import the data into a preferred program.
– more about API tools.

Option 3. View the median rent in context of other attributes for a metro.
click a link in this table to select a metro of interest.
– when the metro profile displays, see section 5.2.

See this related section on metro rental markets.

This section is focused on median rent. Many other subject matter items will be apparent when these methods are used. Optionally adjust above details to view different subject matter for metros.

Join me in a Data Analytics Lab session to discuss more details about accessing demographic-economic data. Learn more about using these data and tools to meet specific interests.

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.

Relating Addresses to Digital Road Segments

.. enter an address on a Google Maps page, or many other similar Web-based “find address” tools, and view that address on a map. View street detail easily. But a view of the digital road segment is not available. Answers to these questions are not available:
• what are the demographic-economic attributes for that location?
• what are the left and right side address ranges for that road segment?
• what are the geocodes on the left and right sides of that road segment?
• what are the end-point coordinates for the road segment?
• how does that road segment (the route) extend through the city or county?

Use methods described in this section to answer these types of questions and examine “Address to Digital Road Segment” relationships. An example is used that features an address shown as a red marker in the banner graphic at the top of this page (Kansas City, MO area). That address is also used in the interactive data access form below. Use these resources and methods for most addresses in the U.S. Tools reviewed here are available at no fee. Use related Web section for full functionality.

Viewing Address/Location in Context of Digital Roads
In the following graphic, a geocoded address (point shapefile) is shown as a red marker (see pointer) in context of roads (streets/lines shapefile). The Identify tool is used to show the profile of associated road segment (TLID=91447676) — an intersection to intersection segment of Oak St. Performing a query on the roads shapefile/layer to locate ID 91447676, the segment is displayed as yellow-highlighted. This application/view is reviewed in this section.

Finding Address Attributes
Use the form below to find attributes for an address. To get started, click the Find button with default settings. Results are returned/displayed on this same page. More in general, key in an address of interest, select the type of geography (more about this below) and click Find. Try your own addresses of interest; use this tool to meet recurring address lookups. Not clear on all the steps? Join us in a Data Analytics Lab session, get answers to questions.

Click following graphic for full functionality:

About the Data Content and Structure
When the Find button (above) is clicked, this page refreshes with returned data based on your query — the values entered/selected in the section above the Find button. The first portion of the data displayed provide a structured display of selected subject matter items (ACS 5-year estimates) for the type of geography selected (e.g. tracts) for that area in which the address is located. The scope of those items could be substantially expanded.

Following that portion of the display are the geographic attributes displayed as JSON output resulting from the geocoder processing of the address. This is the display content below the text “Summary of address sent and matched results:”.

Road Segment Attributes
See road segment attributes for this address under “Summary of address sent and matched results:” and “Address: {“. See that the road segment ID is shown by “tigerLineId”: “91447676”. This ID uniquely identifies this road segment among all of the more than 45 million road segments in the U.S. (see more detail in related section).

Viewing the Address with GIS Tools
1. Install CV XE GIS software (if already installed, skip step 1).
.. Install package — Windows 32/64
.. Start-up Readme
2. After installation, with CV XE GIS running, open a GIS project:
.. Use File>Open>Dialog and open the GIS project named c:\cvxe\1\cvxe_us2.gis. Perform these steps:
2.1. In the Legend Panel, uncheck layers $MHI x BG and Locations.
2.2. Use the Add Layer button to add the layer c:\cvxe\1\$$address1.shp.
.. address used in this application now appears as red marker
.. this single point shapefile was created using the CV XE Tools>FindAddress
2.3. In Legend Panel, check layer Jackson Cty MO roads.
.. now, all roads in the county can be viewed with marker.
.. optionally zoom-in to develop view like shown at top of this page.

.. view developed with ProximityOne CV XE GIS and related GIS project.

2.4. Use GIS Tools>FindShape tool to show all occurrences of “Oak St”
.. on the FindShape form the FULLNAME field is selected and set to “like” Oak St% .. all road segments having name like “Oak St%” are highlighted in yellow.

.. view developed with ProximityOne CV XE GIS and related GIS project.

2.5. Use GIS data table feature to show all occurrences of “Oak St” as table.
.. there are 155 road segment, shown in the next graphic with left and right-side address ranges .. optionally export for use in other applications.

Not clear on all the steps? Join us in a Data Analytics Lab session, get answers to questions.

Census Block Code
See section starting with “2010 Census Blocks”. In the default address run, the census block shows as “GEOID”: “290950066002016”: … state: 29 … county: 095 … tract: 006600 … block: 2016. Other items, such as the TIGER/Line segment ID and segment side, can also be important for some applications.

Any given address or location is contained with several types of statistical areas (e.g. census tract or block group) and political areas (e.g. city or county). We may want to know the demographic-economic characteristics of a location for any one or several of these geographies. Use the interactive tool on this page to access those data. For example, access/view the median household income of the location/address block group or the median household income the location/address city.

Join me in a Data Analytics Lab session to discuss more details about analyzing citizen voting age population and use of data analytics to develop further detail related to your interests.

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.

Congressional District Citizen Voting Age Population

.. congressional districts are very diverse in terms of the overall percent and geographic distribution of citizen voting age population. The size and distribution of the citizen voting age population are important as this population group determines election outcomes. Among the 114th Congressional Districts, the citizen voting age population (CVAP) ranged from 43.2% of the total population (CA40) to 81.2% (FL11) in 2014. Nationally, the citizen voting age population (CVAP) was 70.5% of the total population

% Citizen Voting Age Population by Congressional District

– view developed with ProximityOne CV XE GIS and related GIS project.

Use the interactive table discussed in this section to view/rank/compare/query national scope citizen and CVAP estimates by 114th Congressional District, state and the U.S.  Access the interactive table in this related Web page.

Examining patterns of the citizen voting age population … the Voting Rights Act prohibits development of voting districts that discriminate against potential voters on the basis of race and/or language minority status. To examine how voting districts comply with the Voting Rights Act requires data on the citizen voting age population (CVAP) by race/origin for many types of geographic areas. This section provides data analytics tools to examine ACS 2014 1-year CVAP estimates for 114th Congressional Districts. See related section for information CVAP demographics at the census tract level.

The CVAP data can be used to develop insights into alternative interpretations of “one person one vote.” The Supreme Court on May 26, 2015, agreed to hear a case that will answer a long-contested question about a principle of the American political system — the meaning of “one person one vote.” The court has never resolved whether that means that voting districts should have the same number of people, or the same number of eligible voters. The difference matters in places with large numbers of people who cannot vote legally, including immigrants who are here legally but are not citizens; unauthorized immigrants; children; and prisoners.

The CVAP estimates provide only one part of the required data. Voting district and other boundaries and data are also needed to be used in combination with the CVAP estimates. Using GIS tools, the CVAP estimates can be used in mapping applications, such as those reviewed in this section, in combination with voting district boundaries to reveal potential non-compliance in the structure of voting districts.

Interactive Table
Use this interactive table to view/rank/compare/query national scope citizen and CVAP estimates by 114th Congressional District, state and the U.S. These data are based on ACS 2014 1-year estimates found in Table B05003. See more information about computing CVAP and accessing/integrating related data.

The graphic shown below illustrates using the interactive table to rank California congressional districts in ascending order on percent citizen voting age population. Use the interactive table to examine congressional districts of interest.

Join me in a Data Analytics Lab session to discuss more details about analyzing citizen voting age population and use of data analytics to develop further detail related to your interests.

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.