Decision-Making Information Web Sessions -- DMI#05 -- Using API Technology to Access/Integrate Geographic-Demographic-Economic Data
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 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
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. | |||||||||||||||||||||||||
|