ProximityOne Home Page Resources to create and apply insight




  DMI Sessions Main
  - 01 Metro Patterns & Trends
  - 02 Leg District Analysis
  - 03 Using TIGER/Line
  - 04 Using Small Area Data
  - 05 Using API Tools
  - 06 K-12 Schools &
      Childrens Demographics
  - 07 Using GIS Resources
  - 08 Healthcare Analytics
  - 00 Estimates & Projections

  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

 
Decision-Making Information Web Sessions
  -- DMI#05 -- 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


About this Session
This session is focused on using API (Application Programming Interface) technology to access/integrate geographic, demographic and economic data.

Topics covered in this session are intended for those data specialists, analysts and reseachers who seek to use API tools and methods to access and integrate multi-sourced data, predominantly using "REST" API operations.

A "One-to-One" version of this session is available to meet the needs of a specific audience and optionally focused on specific geography, subject matter and application framework. Contact us (mention 1-to-1 dmis05 Web session in text section) or call (888.364.7656) for more information.

We have structured this document/session as a combined reference and referral for your post-web session use. We conduct this session every few weeks with periodic updates and changing application focuses. An expanded version of this page is available to members of the ProximityOne User Group.

This session makes use of the ProximityOne CV XE GIS and related software. By using these software tools, we are able to support existing user interests and provide common, integrated, software tools for all participants. Any version of the software can be used. Participants who have any version of the software can emulate steps/topics reviewed in this session and expand on topics covered to meet special interests. Optionally use this CV XE GIS installer to install CV XE GIS (no fee) on your Windows-based computer. ProximityOne User Group. members may install any of the Level 1 software tools.

  • Presenter: Warren Glimpse (about)
  • This page (being viewed): http://proximityone.com/dmis05_api.htm
  • Register (no fee)
  • Upcoming Sessions:
    ... see list of upcoming sessions
    ... these sessions cover both basic and a set of new topics

Using API Technology to Access/Integrate Geographic-Demographic-Economic Data

API ... application programming interface

Federal Geographic-Demographic-Economic Data Access Using APIs

1. Review of REST API geographic-demographic-economic data access resources
  ... in operation by selected Federal statistical and other agencies

1.1. Federal Communications Commission
Review of purpose, scope, strengths, advantages & limitations of these data
  • FCC -- latitude-longitude to census block code

1.2. Bureau of the Census
Review of purpose, scope, strengths, advantages & limitations of these data
  • About the Census API
  • Census API Data Discovery

1.2.1. Illustrative examples
  • Census -- ACS 2013 1 yr DP; ed attainment; Houston MSA (26420)
  • Census -- ACS 2013 1 yr DP; total pop; all metros
  • Census -- ACS 0913 DP; Santa Clara County (085) CA (06) tract 507001
  • Census -- ACS 0812 DP; 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
  • Census 2013 County population estimates; all counties
  • School District Finances 2012 -- expenditures, total; School Districts coded as located in Maricopa County, AZ
  • County Business Patterns 2012 -- establishments, total; Maricopa County, AZ

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


1.3. Bureau of Economic Analysis
Review of purpose, scope, strengths, advantages & limitations of these data

BEA API User Guide

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


1.4. Bureau of Labor Statistics

All BLS API calls use a series ID
  • About BLS Series IDs

1.4.1. Quarterly Establishments, Employment & Earnings (QCEW; ES-202) more about
Review of purpose, scope, strengths, advantages & limitations of these data
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:

	                      1         2
	             12345678901234567890
	Series ID    ENU040131050A0115
	Positions       Value           Field Name
	1-2             EN              Prefix
	3               U               Seasonal Adjustment Code 
	4-8             04013           Area Code
	9               1               Data Type Code
	10              0               Size Code
	11              5               Ownership Code
	12-17           0A0115          Industry Code
	

To structure series IDs, access any of the following for a list of codes and their corresponding titles:


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

1.4.2. Local Area Unemployment Statistics
Review of purpose, scope, strengths, advantages & limitations of these data

Survey Overview The following is a sample format description of the Local Area Unemployment Statistics' series identifier:

	                      1         2
	             12345678901234567890
	Series ID    LAUCN281070000000003
	Positions   Value          Field Name
	1-2         LA             Prefix
	3           U              Seasonal Adjustment Code
	4-5         CN             Area Type Code
	6-18        2810700000000  Area Code
	19-20       03             Measure Code
	

To structure series IDs, access any of the following for a list of codes and their corresponding titles:


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

1.4.3. Geographic Profile

Survey Overview The following is a sample format description of the Geographic Profile series identifier:

	                      1         2
	             12345678901234567890
	Series ID    GPU00200000R0328
	Positions       Value           Field Name
	1-2             GP              Prefix
	3               U               Seasonal Adjustment Code 
	4-6             002             State Code
	7-11            00000           Area Code
	12              R               Labor Force Code
	13-16           0328            Character Code
	

To structure series IDs, access any of the following for a list of codes and their corresponding titles:


2. Using Programming Code, Scripts & Components
  2.1. 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

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

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

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

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

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

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

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

  • Upcoming Sessions:
    ... see list of upcoming sessions
    ... these sessions cover both basic and a set of new topics

Additional Information
ProximityOne develops geodemographic-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 tools (software, data, methodologies) to analyze their own data integrated with other data. Follow ProximityOne on Twitter at www.twitter.com/proximityone. Contact us (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 © . Proximity. All Rights Reserved.
Sitemap | Contact Us | News