|
|
.. Module 3 Subject Matter: Statistical/Administrative Data Contents • Module 1 -- About GIS; GIS Tools and Data Setup/Installation • Module 2 -- Geography, Geometry & Shapefiles • Module 3 (this module) -- Subject Matter: Statistical/Administrative Data • Module 4 -- Integrating Subject Matter with Shapefiles Interpreting & Presenting Data Module 3 -- Subject Matter: Statistical & Administrative Data Learning Objectives • Understand types and attributes of statistical data. • Understand array of relevant pre-existing GIS demographic-economic data. • Ability to access wide-ranging existing statistical data. • Ability to transform your existing statistical/administrative data for GIS use. • See assignment below Federal Statistical Data/Subject Matter There are at least 5 primary Federal statistical sources of total employment data available at the U.S. and county level. All of these data can be mapped, U.S. by county, using GIS tools. It might seem curious that there is no employment data available from Census 2020. And that the official BLS "jobs report" monthly data are not available at the county level. Which is the right one to use? The answer is that these data must be used in context and that there is no single best county level employment measure. • Census ACS 1 year - statistical data based on household survey • Census ACS 5 year - statistical data based on household survey • BEA Local Area Estimates - statistical data based in part on administrative data - time-series • BLS QCEW - administratively reported data • Census CBP- administratively reported data • one take-away: statistical versus administrative data • one take-away: current period data versus time-series Creating a GIS-Friendly ACS Subject Matter Dataset Using DEDE • more about using the Demographic-Economic Data Explorer (DEDE) • more about the American Community Survey (ACS2023) October versus November Sessions "Thinking about" accessing & using subject matter. The October session is focused on: • developing skills to access/use the Census Bureau API with the American Community Survey. - one agency, one tool/data resource set, one statistical program. The November Session is focued on: • developing skills to access use the K-12 School & School District Data from Federal sources - many Federal data resources about one "application" area. - Census Bureau API plays a limited but important role. Locating & Accessing ACS Subject Matter Using the Census API • Have an objective: create a data file containing median household income for all counties using ACS. - this most important step; why did you use ACS as the statistical program. • American Community Survey (). - ACS, API or otherwise, contains no geospatial data - select/acquire the subject matter from here, then integrate the subject matter data into a shapefile. • What is an API and why is it useful/important. • Census API Overview - Which ACS "program" do I use? • Using the ACS 5-year estimates. - Detailed Tables or Data Profiles - what's the difference? - We will use the Detailed Tables for ACS 2022 - Why 2022? Vintages; note 2022 refers to the statistical program year - not necessisarily the date date. • Determining what subject matter is available. - about tables and items -- one take-away: concept of tables and items .. item code for use in API call. - what are the codes needed for median household income? - using ctrl-F; the needed MHI code is B19013_001E • Composing the API call. https://api.census.gov/data/2022/acs/acs5?get=NAME,B01001_001E&for=county:*• Manipulating the retrieved data. Supplemental notes - Example Call: https://api.census.gov/data/2023/acs/acs1?get=NAME,B01001_001E&for=congressional%20district:* - 2023 ACS Detailed Tables Variables - ACS Technical Documentation - Examples and Supported Geography • Geographic boundaries by year Using iVDA .. iVDA part of Visual Data Analytics .. see more about VDAGIS below .. iVDA works on any device; iPhone (not recommended due to screen size) .. start-up view presented below is an interactive mapping window .. watch video .. iVDA is an iframe version of VDA Web GIS4 ..open related VDA Web GIS4 .. sse about using VDA Web GIS4 below .. the page being viewed now is located at https://proximityone.com/gis/1/gis13.htm Find, compare, examine ZIP Code Areas and Census Tracts Click toggle button/line to view instructions. Find/find/compare census tracts with ZIP Code areasLearn to find/compare census tracts with ZIP Code areas using iVDA with the "ZIP-Code-Census Tract" project. Here we use ZIP Code Tabulation Areas (ZCTAs) as a proxy for USPS ZIP Codes (using ZCTAs as proxies). See related interactive table.In the iVDA frame below, the start-up view shows ZCTAs with red boundaries and labels and census tracts with black boundaries and labels. The view is a zoom-in to the ZCTA 91780. Find a ZIP code based on an address/location; view intersecting census tracts. .. in the searchbar above the map enter an address or location press enter. .. this example uses ZIP code 85258 or use addres slike .. census tracts are shown with black boundaries and labeled with census tract code. .. a demographic profile for the ZIP code is displayed in the lower left panel. .. here you can examine many demographic subject matter items for that ZIP code. Topics
Assignment .. goto top Use iVDA in this section to determine how many census tracts intersect with your ZIP Code area. Consider using this interactive table as an alternative. E-mail a screen capture of the xip code area and count of intersecting census tracts to Warren Glimpse. About VDAGIS .. goto top Visual Data Analytics (VDA) Geographic Information Resources (GIS) resources are developed and maintained by Warren Glimpse, ProximityOne (Alexandria, VA) and Takashi Hamilton, Tsukasa Consulting (Osaka, Japan). See more about VDA resources | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
