ProximityOne Home Page Resources to create and apply insight




  Situation & Outlook

  Related Sections
  - Applications Gallery
  - States
  - School Districts
  - Metros
  - Congressional District
  - Counties
  - Tracts/Neighborhoods
  - Block Groups
  - Census Blocks
  - ZIP Codes
  - Urban Areas

  - PUMA Geography

  Estimates-Projections
  - 2060 Demographic
    ... all county interactive table
  - 2030 Demographic-Economic
  - Single Year of Age

  GIS Thematic Mapping
    Visual Analysis Tools

  Ranking Tables
    National Scope
    Demographic Change
    2000-2010
  - States
  - Metros
  - Congressional District
  - School Districts
  - Counties
  - Cities/Places
  - Census Tracts

 
Data Analytics & API Application Programming Interface Tools
  -- Using API Technology to Access/Integrate Geographic-Demographic-Economic Data
Decision-Making Information
  ProximityOne
  information resources & solutions
  (888) DMI-SOLN
  (888) 364-7656

Visual analysis with ProximityOne tools
click graphic for info; hover to pause

 
visually analyze clients/markets
site analysis using 1 mile radius

S1

$median household income
patterns by census tract - Houston

hover to pause

113th Congressional Districts

Click for info

US Asian Indian population 2010

Click for info

geocoded students and school
McKinney ISD, TX

Click for info

geocoded students and school
with tax parcels & streets

Click for info

high school attendance zones
with schools by type

Click for info

%high school graduates by
census tract - Puerto Rico

Click for info

Austin, TX MSA counties &
places 10K+ population markers

Click for info

Appalachia counties (green) &
coalfield counties (orange)

Click for info

China provinces percent urban &
cities (markers) by state plan

Click for info

Honolulu census tracts (red)
& census blocks


Central Park area NYC

Click for info

Kansas City Metro & Counties
Home Depot locations (markers)

Click for info

World Cities; focus on Spain

Click for info


Data Analytics Blog
Power of Combining Maps with Data

Support & Technical Assistance
help using these resources


 


Possibly the most well known APIs (Application Programming Interface) are the Google APIs. Among these, the Google Maps API, or its use, might be the most familiar. See about integrating political/statistical geography and Google Maps API. This section reviews different types of APIs.

Data Analytics and APIs
API technology/tools play an important role in accessing and integrating geographic, demographic and economic data. APIs offer two types of benefits. For Web-based applications, APIs provide the ability for on-the-fly access to selected demographic-economic buried in otherwise large datasets that typically otherwise involve downloading and preprocessing. A second important benefit/use is to extract data from those same datasets, reconfigure the structure of the data retrieved by API and create a new dataset structure that lends itself to analytical applications.

ProximityOne Data Analytics sessions review purpose, scope, strengths, advantages & limitations of APIs described in this section. Topics of this section include:
  • Federal Geographic-Demographic-Economic Data Access Using APIs
  • REST APIs
  • Federal Communications Commission
  • Bureau of the Census ... much more than Census
  • Bureau of Economic Analysis
  • Bureau of Labor Statistics
  • Data Access & Analytics Applications
There are hundreds more APIs available from Federal agencies and wide-ranging sources.

Using APis and GIS: Visualizing Patterns; Geospatial Analysis
The following graphic has been developed first using API tools to create the underlying datasets. While the source data used in this application could have been downloaded and processed in legacy manner, the API tools provide on-the-fly development of the data in a structure required by the GIS software. These data are then integrated into shapefiles for use with the GIS software. Once the datasets are developed, they can be used in a myriad of application, GIS and otherwise.

Patterns of Male Hispanic Population Age 5 Years by ZIP Code
  -- Houston, TX Area


  • Click graphic for larger view with ZIP Code labels and more detail.
  • The graphic shows patterns of the Male Hispanic population 5 years of age as of Census 2010.
  • The view illustrates how single year of age by gender by race/origin can be visually analyzed.
  • See more about these data and single year of age demographics

Federal Geographic-Demographic-Economic Data Access Using APIs
  ... Federal Geographic-Demographic-Economic Data Access Using APIs

1. REST APIs
  ... Geographic, demographic, economic data access resources
  ... In operation by selected Federal statistical and other agencies reviewed below

2. Federal Communications Commission
  • FCC -- latitude-longitude to census block code

3. Bureau of the Census
  • About the Census API
  • Census API Data Discovery

3.1. Illustrative examples
Click the link and the JSON output returned is displayed. Examine the structure of the URL.
Modify the URL and to view other subject matter and/or geography.
  • 2015 Planning Database; Census 2010 total population for every block group in Harris County, TX
  • 2015 Planning Database; Census 2010 total population for every census tract in Texas
    .. new to Census API access 8/15 .. more about the 2015 Planning Database
  • ACS 2013 ACS 2013 1-year estimates Demographic Profile; ed attainment; Houston MSA (26420)
  • ACS 2013 ACS 2013 1-year estimates Demographic Profile; total pop; all metros
  • ACS 2013 5-year estimates Demographic Profile
    .. selected items; Santa Clara County (085) CA (06) tract 507001
  • ACS 2012 5-year estimates Demographic Profile
    .. selected items; Santa Clara County (085) CA (06) tract 507001
  • 1990 Census -- SF3 Block Group; block group 1 in tract 0101 Maricopa County, AZ
  • Census 2000 -- SF3 Block Group; block group 1 in tract 010100 Maricopa County, AZ
  • Census 2010 -- SF1 Block Group; block group 1 in tract 010101 (split) Maricopa County, AZ
  • 2014 County population estimates
    .. total population by gender by race/ethnicity 7/1/2014 -- Maricopa County, AZ
  • School District Finances 2012 -- expenditures, total; School Districts coded as located in Maricopa County, AZ
  • County Business Patterns 2013
    .. employment & establishments in the Accommodation and Food Services sector -- Maricopa County, AZ

3.2. Washington, DC/District of Columbia examples
  • One subject matter item per API call:
    - Census 2000 SF1 total population
    - Census 2010 SF1 total population
    - Census 2000 SF1 White alone population
    - Census 2010 SF1 White alone population
    - Census 2000 SF1 Black alone population
    - Census 2010 SF1 Black alone population
    - Census 2000 SF1 Asian alone population
    - Census 2010 SF1 Asian alone population

  • Four subject matter items per API call:
    - Census 2000 SF1 Total, White, Black, Asian population
    - Census 2010 SF1 Total, White, Black, Asian population

PopulationCensus 2000Census 2010%Change
  Total572,059601,7235.18
    White alone176,101231,47131.44
    Black alone343,312305,125-11.12
    Asian alone15,18921,05638.63

4. Bureau of Economic Analysis
  • BEA API User Guide

Regional Datasets; county, metro & higher level geography

  • Regional Data Items List

  • Metro GDP Dallas Metro, 2010 & 2012
    - more about Metro GDP

  • County Per Capita Personal Income -- 2010 all counties
    - more about REIS

5. Bureau of Labor Statistics

All BLS API calls use a series ID ... about BLS Series IDs

5.1. Quarterly Establishments, Employment & Earnings (QCEW; ES-202) more about
State and County Employment and Wages from Quarterly Census of Employment and Wages Survey Overview

The following is a sample format description of the Quarterly Census of Employment and Wages series identifier:
Example of Series ID: ENU040131050A0115 (17 characters)
PositionsValueField Name
1-2ENPrefix
3 USeasonal Adjustment Code
4-8 04013Area Code
9 1Data Type Code
100Size Code
115Ownership Code
12-17 0A0115Industry Code

To structure series IDs, access any of the following for a list of codes and their corresponding titles:
  • Area Codes
  • Data Type Codes
  • Size Codes
  • Ownership Codes
  • Industry Codes

Examples:
Maricopa County, AZ, Quarterly, Total establishments, all industries
  -- Series ID ENU04013-2-05-10

Maricopa County, AZ, Quarterly, Total employment, all industries -- a monthly item within quarter
  -- Series ID ENU04013-1-05-10

Maricopa County, AZ, Quartery, Total wages, all industries
  -- Series ID ENU04013-3-05-10

Maricopa County, AZ, Average annual wages, all industries
  -- Series ID ENU04013-5-05-10

Maricopa County, AZ, Quarterly, Total establishments, Real Estate: NAICS 531
  -- Series ID ENU04013-2-05-531
  -- About the NAICS 531 Industry

5.2. Local Area Unemployment Statistics

Statistical Program Overview
The following is a sample format description of the Local Area Unemployment Statistics' series identifier:
Example of Series ID: LAUCN281070000000003 (20 characters)
PositionsValueField Name
1-2LAPrefix
3USeasonal Adjustment Code
4-5CNArea Type Code
6-182810700000000Area Code
19-2003Measure Code

To structure series IDs, access any of the following for a list of codes and their corresponding titles:
  • Area Type Code
  • Area Codes
  • Measure Codes

Examples
Houston MSA unemployment rate (03)
  -- Series ID LA-MT-4826420000000-03

5.2.1. Kansas City, MO-KS MSA Employment (05)
  -- Series ID LAUMT292814000000005

5.2.2. Jackson County, MO Employment (05)
  -- Series ID LAUCN290950000000005

5.2.3. Kansas City city, MO employment (05)
  -- Series ID LAUCT293800000000005

Access employment data easily for any county.
Replace the SSCCC characters in the following URL with state-county FIPS code (SSCCC)
  for any county and submit in browser.
  http://api.bls.gov/publicAPI/v1/timeseries/data/LAUCNSSCCC0000000005

Comparing LAUS estimates (5.2.1 - 5.2.3. above) to ACS 2013 1-year estimates (below).
  • Census -- ACS 2013 1 yr DP; employment attributes; KC metro (28140)


Click graphic for larger view.

5.3. Geographic Profile
Geographic Profile Overview The following is a sample format description of the Geographic Profile series identifier:
Example of Series ID: GPU00200000R0328 (16 characters)
PositionsValueField Name
1-2 GPPrefix
3 USeasonal Adjustment Code
4-6 002State Code
7-1100000Area Code
12 R Labor Force Code
13-160328Character Code

To structure series IDs, access any of the following for a list of codes and their corresponding titles:
  • State Codes
  • Area Codes
  • Labor Force Codes
  • Character Codes

6. APIs & Coding: Programming Code, Scripts & Components
  ... illustrative code used to build dataset for interactive table at Schools
  ... "how to" -- review of code used to link API calls in 1.1. and 1.2 above for all schools in a state.
  ... attaching census block code and census tract demographics to school location
  ... used to develop school point shapefile & pattern analysis: CA Schools application

7. Using the Census API resource
  ... applications including accessing ACS 2013 data
  ... related derived ACS 2013 for 2013 Metros interactive table
  ... structuring and using a basic Census API call -- examples that you can immediately apply

8. Using Windows-based Delphi programming methods to manage API calls
  ... organizing downloaded data for subsequent use

9. Using the Demographic-Economic Data Extraction (DEDE) API resource
  ... develop Census 2000, Census 2010 & American Community Survey subject matter by block group dBase files
  ... related data extraction & data file development & use

10. Geocoding Address Data Using the API Geocoder
  ... assigning geocodes (block level) to addresses & assigning subject matter items to coded address records
  ... creating an address point shapefile and using the shapefile in a GIS application
  ... performing an address lookup; determine geocodes -- examples that you can immediately apply

11. Using APIGateway
  ... develop integrated data profiles (multi-sourced demographic-economic data)
  ... access/download Census 2010 Summary File 1 block level data

12. Using GeoGateway
  ... access/download Census TIGER/Line shapefiles

13. Examining characteristics of market and study areas using Site Analysis API
  ... access all Census 2000 SF3, Census 2010 SF1, ACS 2010-2012 block group data


Support Using these Resources
Learn more about demographic economic data and related analytical tools. Join us in a Data Analytics session. There is no fee for these Web sessions. Each informal session is focused on a specific topic. The open structure also provides for Q&A and discussion of application issues of interest to participants.

ProximityOne User Group
Join the ProximityOne User Group to keep up-to-date with new developments relating to geographic-demographic-economic decision-making information resources. Receive updates and access to tools and resources available only to members. Use this form to join the User Group.

Additional Information
ProximityOne develops geographic-demographic-economic data and analytical tools and helps organizations knit together and use diverse data in a decision-making and analytical framework. We develop custom demographic/economic estimates and projections, develop geographic and geocoded address files, and assist with impact and geospatial analyses. Wide-ranging organizations use our software, data and methodologies to analyze their own data integrated with other data. Follow ProximityOne on Twitter at www.twitter.com/proximityone. Contact ProximityOne (888-364-7656) with questions about data covered in this section or to discuss custom estimates, projections or analyses for your areas of interest.

Copyright © . ProximityOne. All Rights Reserved.
Sitemap | Contact Us | News