Category Archives: 115th Congressional Districts

Creating Custom Demographic Datasets with API Tools

.. develop national scale spreadsheet files with virtually no learning time .. easy-to-use API operations to create national scope demographic-economic datasets based on American Community Survey 2016 1-year estimates .. custom subject matter selections. See more detail in related web sections ACS2016 and ACS2016_API.

Benefits and utility … how to acquire a spreadsheet showing the population of all cities with population estimates based on the ACS 2016 1-year data? … or, housing units, median household income, median housing value, etc.? Variations of this need frequently arise — what is the list of largest California counties sorted on total population: What are the 25 metros having the highest median household income? Which 10 congressional districts have the highest poverty incidence? Which urban areas have the highest educational attainment?

Use simple API calls described below to get answers to these types of questions — and more.  Create files that can be used for recurring applications. An example …

Urban Areas with 2016 Population 65,000+ Population
… results from using the API downloaded data … the following graphic shows urban areas with 65,000 or more 2016 population; zoom-in to Texas. The full national scope GIS project is available as described below; examine U.S. or any region. The file used to develop this view was created using the results of the API call reviewed below (requires integration of those data into the urban areas shapefile). Click graphic for larger view; expand browser window. Larger view shows urban areas labeled with name and mini profile for Dallas UA showing all subject matter items downloaded (via API) as described below.

… View developed using CV XE GIS.
… See more about Urban Population & Urban Areas.

Access ACS 2016 1-Year Data Using API Tools
Here are the API links … use these API calls to access/download selected items for selected geographies. See more about using API tools. Click a link and receive a return page with CSV-like structured data. See usage notes below. As these are ACS 2016 1 year estimates; geographies are only available for areas 65,000+ population.
Click a link:
• All U.S. cities/places
• All U.S. counties
• All U.S. CBSAs
• All U.S. Urban Areas
• All 115th Congressional Districts
• All U.S. states
• U.S. only

The following data retrieval operations are by state. These are examples using Arizona (FIPS state code 04).
• All [within state] Elementary School Districts
• All [within state] Secondary School Districts
• All [within state] Unified School Districts

API Call Returned Data Usage Notes
Clicking the All U.S. cities/places link above generates a new page with content very much like a CSV file. Try it .. click an above link.

See the related ACS2016_API web section for more details.

Items Retrieved in the API Calls
The sample header record above shows the subject matter item listed at the left in the following set of items. Modify API call and use other subject matter items. See full array of subject matter – xlsx file.
.. B01003_001E – Total population
Age
.. B01001_011E — Male: 25 to 29 years (illustrating age cohort access)
.. B01001_035E — Female: 25 to 29 years (illustrating age cohort access)
Race/Origin
.. B02001_002E – White alone
.. B02001_003E – Black or African American alone
.. B02001_004E – American Indian and Alaska Native alone
.. B02001_005E – Asian alone
.. B02001_006E – Native Hawaiian and Other Pacific Islander alone
.. B02001_007E – Some other race alone
.. B02001_008E – Two or more races
.. B03001_003E – Hispanic (of any race)
Income
.. B19013_001E – Median household income ($)
.. B19113_001E – Median family income ($)
Housing & Households
.. B25001_001E – Total housing units
.. B25002_002E – Occupied housing units (households)
.. B19001_017E — Households with household income $200,000 or more
.. B25003_002E — Owner Occupied housing units
.. B25075_025E — Housing units value $1,000,000 to $1,499,999
.. B25075_026E — Housing units with value $1,500,000 to $1,999,999
.. B25075_027E — Housing units with value $2,000,000 or more
.. B25002_003E – Vacant housing units
.. B25077_001E – Median housing value ($) – owner occupied units
.. B25064_001E – Median gross rent ($) – renter occupied units

The rightmost fields/columns in the rows/records contain the area name and geographic codes.

Using API Tools for Data Analytics
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 L

Congressional District & State Legislative District Data Analytics

.. updates on tools, data resources and methods to analyze congressional districts and state legislative districts. Join the Congressional District/State Legislative District Group to receive updates. See details.

Visual Analysis of 115th CDs & 2016 Cycle SLDs
Topeka, KS metro and Kansas State House Districts

Topeka, KS metro: bold brown semi-transparent boundary
115th Congressional Districts: bold orange boundary.
State house districts: black boundary; yellow label showing code.
Topeka city: green fill pattern (entirely with in 115th CD KS02)

See related Web section with more detail.

Analyzing Congressional Districts & State Legislative Districts
– in context of other geography
Illustrative GIS views of examining CDs & SLDs in context
using GIS tools and data

New ACS 2016 1-Year Demographic-Economic Estimates
– American Community Survey 2016 (ACS2016) data for each 115th CD
– Released 9/14/17
… upcoming … interactive tables using these data
… similar to ACS2015 interactive tables

New 115th CD & 2016 SLD Shapefiles
– New 2017 TIGER/Line shapefiles to be released in September
– See about related 2016 vintage data
– These shapefiles may be used with most any GIS software
… map the most current CDs/SLDs in context with other geography

New 115th CD & 2016 SLD Equivalence File
– Flat files with a record for each intersecting SLD and CD
– Developed by ProximityOne; available October 2017
– Functionally similar to relating ZIP codes to census tracts

New Census 2010 Summary File 1 Data for 115th CDs & 2016 SLDs
– Updated Census 2010 Summary File 1 data
– Provides Census 2010 demographic data for 115th Congressional Districts
– Expected October 2017

Ahead in December
– Demographic-economic data for each 2016 cycle state legislative district
– Based on American Community Survey 2016 5-year estimates (ACS1116)
– See related SLD 2014 main page

Related sections & Resources
115th Congressional Districts interactive table with incumbent details
Making Custom 115th CD maps and geospatial analysis
– Congressional Districts main page — http://proximityone.com/cd115.htm

CD & SLD Data Analytics
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.

Making & Using Custom 115th Congressional District Maps

.. using GIS resources to create custom 115th Congressional District maps .. use the methods, data and tools described in this section to develop custom congressional district maps. View patterns of economic prosperity by neighborhood for one or all congressional districts. Flexibly associate a congressional district boundary with related geography and subject matter.  See related Web section for more details.

Join the Congressional District-State Legislative District (CDSLD) Group .. be a part of the community. .. click here to join .. there is no cost.

Coming up … mapping/analyzing school district finances in context of the 115th Congressional Districts (June 2017).

See the related section on Making/Using 113th Congressional District Maps.
.. view different congressional district vintages in same map.

115th Congressional Districts by Incumbent Party Affiliation
This view and related GIS project/data update when changes are made to the 115th Congressional Districts incumbents (last updated 5/10/17). Party affiliation shown in this view is also available in the related interactive table. Click graphic for larger view. Expand browser window for best quality view.

– View developed using CV XE GIS and related GIS project.
– see below in this section about using this GIS project.

Use the Geographic Information System (GIS) tools and data to view/show congressional district in context with roads, landmarks and other geography. Flexibly add labels. Create pattern views. Add your own data.

Patterns of Economic Prosperity by 115th Congressional District
The following graphic shows patterns of ACS 2015 median household income (MHI) by 115th Congressional District. Click graphic for larger view. Expand browser window for best quality view.

– View developed using CV XE GIS and related GIS project.
– use the GIS project and tools see below to create different views.

Examine Characteristics of any Congressional District
The following graphic shows patterns of ACS 2015 median household income (MHI) by census tract in context of 115th Congressional Districts in a region of North Carolina. CD 3712 (Charlotte area) is shown with bold boundary. It is easy to see which areas/tracts have different levels of economic prosperity.

– View developed using CV XE GIS and related GIS project.
– use the GIS project and tools see below to create different views; add other layers.

Creating congressional district maps is often specific to a particular analysis, zoom-view, labeling, combination of different geographies or other considerations. While there are no estimates of unemployment by congressional district, using GIS tools it is possible to view/geospatially analyze patterns of unemployment within congressional district by county, census tract, block group and other geography.

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.

115th Congressional Districts: Analysis and Insights

.. interpretative data analytics; tools, data & methods ..  this section is focused on 115th Congressional District geographic, demographic and economic patterns and characteristics. Use tools and data reviewed here to examine/analyze characteristics of one congressional district (CD) or a group of CDs based on state, party or other attribute. Use the GIS resources described here for general CD reference/pattern/analytical views, to examine current demographics and demographic change and for redistricting applications. See this related Web section for more details.

Examining the 115th Congressional Districts
• the 115th Congress runs from January 2017 through December 2018.
• FL, MN, NC, VA have redistricted since the 114th CD vintage;
  .. some 115th CDs have new boundaries compared the 114th CDs.
• view, rank, compare CDs using the interactive table.
  .. table uses ACS 2015 data for 115th CDs & include incumbent attributes.
  .. examine districts by party affiliation.
• use these more detailed 114th CD interactive tables
  .. data based on 2015 American Community Survey – ACS 2015.
  .. corresponding data for the 115th CDs from ACS 2016 available Sept 2017.
• use the new GIS project including 114th & 115th CDs described below.
  .. create CD thematic and reference maps;
  .. examine CDs in context of other geography & subject matter.
• join us in the April 25 Data Analytics Lab session

Visual Analysis of Congressional Districts
The following views 1) provide insights into patterns among the 115th CDs and 2) illustrate how 114th to 115th geographic change can be examined. Use CV XE GIS software with the GIS project to create and examine alternative views.

Patterns of Household Income by 115th Congressional District
The following graphic shows the patterns of the median household income by 115th Congressional District based on the American Community Survey 2015 1-year estimates (ACS2015). The legend in the lower left shows data intervals and color/pattern assignment

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

Charlotte NC-SC Metro Area
  – with 114th/115th Congressional District 12

The following graphic shows North Carolina CD 12 with 114th boundary (blue) and 115th boundary (pale yellow) and Charlotte metro bold brown boundary. Click graphic for larger view with more detail. Expand browser window for best view.

.. view developed using the CVGIS software.

• View zoom-in to Charlotte city & Mecklenburg County.

115th Congressional District Interactive Table
Use the interactive table to examine characteristics of one congressional district (CD) or a group of CDs. The following graphic illustrates use of the interactive table. First, the party type was selected, Democratic incumbents in this example. Next, the income and educational attainment columns were selected. Third, the set of districts were sorted on median household income. It is quick and easy to determine that CA18 has the highest median household income and that the MHI is $1,139,900. Try using the table to examine districts of interest.

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.