Monthly Archives: July 2014

Making Custom Congressional District Maps

.. using GIS resources to create custom congressional district maps and visually analyze urban-rural patterns …

Houston Area Texas CD 22 Intersects 3 Counties

Semi-transparent layer shows TX22 by county.
Overlayed on urban areas — orange fill patern.
See details about above map below.

Maps of the 113th congressional districts are widely available in many shapes and forms. See the CD Gallery to view patterns of economic prosperity by neighborhood for each/every 113th congressional district. Flexibly associating a congressional district boundary with related geography and subject matter requires special tools — as reviewed in this section and available to members of the ProximityOne UserGroup.

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 a congressional district by county, census tract, block group and other geography.

Create Your Own Custom Congressional District Maps
This section reviews tools that you can use to flexibly develop your own maps that show U.S. 113th Congressional Districts of interest using Geographic Information System (GIS) tools. The GIS resources enable you to view/show the congressional district boundaries in context with roads, landmarks and other geography. Flexibly add labels. Create pattern views. Add your own data. Metro maps can be saved as a graphic and used in any manner. There are no fees to use resources described in this section.

See additional details about topics covered here in this Web page.

Examining Congressional Districts & Urban/Rural Patterns
GIS resources reviewed in this section enable you to make a map of any congressional district using the U.S. by congressional district shapefile. A second layer shows the U.S. by urban area. By using these layers in combination, you can examine urban/rural patterns by congressional district. A third layer uses the U.S. by congressional district by county shapefile. By using this layer, pattern analysis can focus on a particular part of a congressional district contained within a county as illustrated by a map view below (see #2. Houston Area; Congressional District by County). The 113th CD urban/rural mapping makes use of the latest latest smoothed boundary shapefiles (July 2014).

113th Congressional District Urban/Rural Patterns Chicago Area
 — create similar map view for any area

• Congressional districts: black boundaries with CD code/number.
• Urban areas: orange fill pattern.
• It is easy to see which congressional districts are 100% urban.

Steps to Develop Custom Congressional District Maps (requires Windows computer with Internet connection)
1. Install the ProximityOne CV XE GIS
… run the CV XE GIS installer
… take all defaults during installation
2. Download the U.S. 113th Congressional Districts GIS project fileset
… requires ProximityOne User Group ID (join now, no fee)
… unzip U.S. CD113 Urban Rural GIS project files to local folder c:\cd113_urbanrural
3. Open the c:\cd113_urbanrural\cd113_urbanrural_chicago.gis project
… after completing the above steps, click File>Open>Dialog
… open the file named c:\cd113_urbanrural\cd113_urbanrural_chicago.gis
4. Done. The start-up view is shown above with additional instructions.

Using the CD 113 Urban/Rural Maps Projects
There are three GIS project files included with the ZIP file. Each GIS project (*.gis) includes the same set of layers/shapefiles. Only attributes of layers set by the CV XE GIS Layer Editor differ.
1. cd113_urbanrural1.gis
2. cd113_urbanrural2.gis
3. cd113_urbanrural_chicago.gis

See this Web page for details on how to modify a layer appearance (queries, labels, zoom-view, etc.)

1. Houston Area — cd113_urbanrural1.gis
When the c:\cd113_urbanrural\cd113_urbanrural1.gis is opened, the view shown below appears.
This project illustrates use of the query “GEOID=’4822′” placed on the CD113 layer displays only the congressional district Texas 22.

2. Houston Area; Congressional District by County — cd113_urbanrural2.gis
When the c:\cd113_urbanrural\cd113_urbanrural2.gis is opened, the view shown below appears.
This project illustrates use of three queries placed on the CD113 by county layer, resulting in the displays of congressional district Texas 22 by county (three color patterns).
1. query 1: CD113FP=’22’ and countyfp=’039′
2. query 2: CD113FP=’22’ and countyfp=’201′
3. query 3: CD113FP=’22’ and countyfp=’157′

3. Chicago Area — cd113_urbanrural_chicago.gis
When the c:\cd113_urbanrural\cd113_urbanrural_chicago.gis is opened, the view shown below appears.
In this project, no queries are placed on any layer.

Saving/Publishing a Map View
When you have a view that you want to save, click the Save to Image button on the toolbar. You will then be prompted for the folder and filename. Once the graphic has been saved to a folder it can be used just as any other graphic.

Saving, Closing and Opening Projects
If CV XE GIS is closed with no changes made to the project settings are saved. Reopening the project will create the same start-up view as shown above. Repeat the steps to create views for other cities.

If you have made adjustments to the project and want to save it, to be reopened later with the same view, use File>SaveAs to save a new project name. It is recommended that you do not save the project with the same name as you will not be able to recall the original start-up view.

Additional Views
Phoenix area

Los Angeles area

Houston area

Support & DMI Web Sessions
Learn more about using resources described in this section. Join us in a Decision-Making Information Web session. There is no fee for these one-hour 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. We can address your specific questions about using congressional district and urban area demographic economic data and related applications.

Measuring the U.S. Economy: Industry Analysis

There are many data resources to draw upon to analyze detailed industry characteristics and assess how their changing patterns affect regions and the national economy. Among the insights offered by the Census Bureau quinquennial economic census are from data on specific industries; data not otherwise available. The 2012 economic census (EC) data are now being released on a flow basis into 2015. This section profiles one industry — for U.S. household appliance manufacturing (NAICS 3352) — what economic census data are available, what related data are available, how to access the data and issues concerning use. These same topics may be applied to any type of business/industry category. How is this industry trending? How might these changes impact your business, marketshref=: or regional economy? See related HTML section.

In July 2014, the release of the 2012 Economic Census household appliance manufacturing data showed that the value of shipments for the nation’s 95 household cooking appliance manufacturing establishments totaled $4.3 billion in 2012, down 10.8 percent from $4.9 billion in 2007.

Industry Attribute Narrative
A typical EC industry attribute narrative, for the household cooking appliance manufacturing industry, is as follows. The household cooking appliance manufacturing industry employed 10,324 people in 2012, down 34.0 percent from 15,638 in 2007. Average payroll per employee increased 23.0 percent from $30,199 in 2007 to $37,143 in 2012. The average number of employees per establishment in this industry decreased 20.1 percent, from 136 in 2007 to 109 in 2012.

Household Appliance Manufacturing Industries by NAICS Code
The household appliance manufacturing industries are shown in the table below by NAICS code.

NAICS Code Industry
3352 Household Appliance Manufacturing
33521 Small Electrical Appliance Manufacturing
335210 Small Electrical Appliance Manufacturing
33522 Major Appliance Manufacturing
335221 Household Cooking Appliance Manufacturing
335222 Household Refrigerator and Home Freezer Manufacturing
335224 Household Laundry Equipment Manufacturing
335228 Other Major Household Appliance Manufacturing

Accessing Industry Data — examples using industry 335221
Selected resources are reviewed below which may be used to access/develop industry data by detailed NAICS levels.

1. Use the economic census report portal to view industry characteristics.
Industry 335221 Snapshot

Click graphic for larger view.

Value of Shipments; NAICS 335221

Click graphic for larger view.

Click this link to access similar data for an industry.

2. Access different types of Census-sourced data available for industry 335221.
The Industry Statistics Portal allows a user to select a single NAICS code and the tool returns a list of all of the Census statistical programs that provide data for that industry. The tool provides a nice definition of the industry as well as information about comparability of the industry over the various vintages of NAICS.

To use this tool, go to the Topics menu on census.gov, place your cursor over the word “Economy” and then select the Industry Statistics Portal from the list. You can then choose the industry of interest by either selecting it from the menu/tree on the left or from the search box on the right.

3. Access establishments, employment & wages BLS/CEW data for industry 335221.
The BLS Census of Employment and Wages provides quarterly establishments, employment and wages data based on employer reports. These quarterly and annual time-series data are available down to the county level of geography. These data provide the most recent industry characteristics. The following table shows these data for 2012 and 2013.

NAICS 335221 Household cooking appliance manufacturing

Year Establishments Employment Wages Weekly Wages Annual Wages
2012 116 10,879 $481,535,767 $851 $44,264
2013 123 11,893 $537,690,028 $869 $45,211

Click this link to access similar data for an industry.

4. Characteristics of the employed population for industry 335221
While no demographic-economic data are tabulated from the American Community Survey (ACS) at the NAICS 6-digit level, employment data by 1- and 2-digit NAICS level are available by census tract, county and other geography. Develop annual custom estimates of the employed population, and their attributes and household attributes by using the ACS Public Use Microdata Samples (PUMS) files. Develop these estimates for Public Use Microdata Areas (PUMA). PUMAs are groups of contiguus census tracts and have a minimum population of 100,000. For example, Los Angeles County, CA is comprised of 69 PUMAs.

5. Modeling Applications; Projections of Industry Attributes; Alternative Scenarios
The ProximityOne 5-year annual projections (DE6 series) use the BLS/CEW data (item 3 above) in combination with other data to develop projections at the county level and for higher level geography. While these data are focused on 1- and 2-digit data, the model can be adapted to develop projections for other, more detailed, industries.

6. Regional Input-Output Modeling System
The Bureau of Economic Analysis Regional Input-Output Modeling System (RIMS) produces regional multipliers that can be used in economic impact studies to estimate the total economic impact of a project on a region. RIMS includes more than 400 industry sectors. Among these industries, for example, are household appliance manufacturing (NAICS 3352) and associated 6-digit more detailed industries (see list in above table).

Support with Accessing, Integrating and Using these Data
Learn more about using resources described in this section. Join us in a Decision-Making Information Web session. There is no fee for these one-hour 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. We can address your specific questions about using industry data and related applications.

Healthcare Demographic Economic Analytics

Healthcare providers and the healthcare delivery system are challenged to determine what resources to make available at what locations and when. Assessing supply-side characteristics of the healthcare market is difficult at best. Current data on locations and capabilities of hospitals, ambulatory health care services (physicians, dentists, other healthcare practitioners, etc.), nursing and residential care facilities, and social assistance are multi-sourced and challenging to integrate.

As the population ages, migrates and otherwise changes, healthcare needs change by location, type and in other ways. Current small area demographics of these demand measures are not readily available — when knowing about changes in demand over the next several years is even more important. Changing economic circumstances and issues with insurance coverage affect the ability to pay and the demand for various healthcare resources.

Healthcare Analytics
This section provides an overview of the healthcare analytics focused on California. Resources and applications reviewed here can be emulated for other states and regions. The purpose of this section is to illustrate how a set of diverse, multi-sourced, healthcare supply and demand attributes can be organized for visual and geospatial analysis. See more details in related Web section.

Visual Analysis of Facilities, Characteristics and Patterns
Geographic Information System (GIS) resources can help decision-makers and stakeholders more easily understand and collaborate on healthcare issues that are difficult to analyze using spreadsheets and tables. A few examples:
• Relating Medically Underserved Areas (about MUAs/MUPs) to neighborhoods by economic prosperity.
• Relating locations of healthcare facilities (hospitals, clinics) to MUAs?
• Relating MUAs relate to Health Professional Shortage Areas (about HPSAs).
• Determining neighborhoods with highest need for healthcare services.
Get answers to these types of questions using multiple layers in a GIS project.

The following view of the San Diego area and shows a mix of healthcare related demographic-economic characteristics. The cross-hatched pattern areas have been designated as Medically Underserved Areas (MUAs). Patterns of economic prosperity (median household income by block group) are shown by color patterns as highlighted in the legend at left of map view. It is easy to see where the MUAs are located. Many MUAs are located in areas with medium to higher economic prosperity. Locations of primary care facilities, shown by square markers, can be viewed contextually.


Click graphic for larger view.
View developed using CV XE GIS and California DMI GIS Project.

Using GIS resources, the map views can be displayed in different ways to accomodate the needs of geographic and/or subject matter focus. Zoom-in or out for a broader or more focused view. Label features of interest (e.g., hospital names). Click layers on or off (in legend panel at left of map panel) to view geographies or locations of specific interest. Add other data such as geocoded patient or incident data.

Additional views shown below, from the same GIS project, illustrate some of these application views. Map views are just one part of the GIS resource benefits. Query tools can be used to highlight only locations of geographies that meet certain criteria, such as hospital bed capacity.

Statewide Hospitals and Primary Care Facilities

Hospitals and Primary Care Facilities: Zoom to Southern California

San Diego Area: Medically Underserved Areas

San Diego Area: Healthcare Professional Shortage Areas

Developing Your Healthcare Analyses
GIS tools and selected demographic-economic shapefiles shown above are available at no fee to ProximityOne User Group members. Join now, there is no fee. Add your data. Examine different geographies. Extend healthcare analytical and collaborative decision-making.

School Districts by Urban, Suburban, Rural Classification & Patterns

This section reviews tools and methods to examine school districts classified as urban, suburban or rural. School districts are categorized by a “locale code” that gives insights into the urban, suburban or rural character of individual school districts. Map views presented here have been developed using a GIS project that may be downloaded and used to analyze more detailed characteristics of districts by these categories.

The locale code, a 2-digit code assigned to each district, can be used to categorize school districts into one of four major categories: city, suburban, town, and rural. Cities and suburbs are further divided into categories of small, mid-size, or large. Towns and rural areas can be characterized by their proximity to an urbanized area as fringe, distant, or remote. These are codes are developed by the U.S. Department of Education National Center for Education Statistics (NCES). NCES assigns the codes to individual school districts. See more about locale code definitions. Use this interactive table to view the locale code for any particular district and examine sets of peer districts based on the locale code and related demographics.

The locale code is an imperfect means of classifying school districts as urban, suburban or rural but offers one important standardized method. Many larger school districts, particularly those that are county-equivalents, are a mix of urban, suburban and rural geography.

School Districts by Locale Code

School Districts by Locale Code Maps
The maps presented below show the distribution of regular school districts as markers by type of locale code. These maps depict school district locations based on use of a point shapefile. The point shapefile shows the marker location based on the school district mailing address. These views render each school district as the same size (a point) regardless of geographic area covered.

These views have been developed using the CV XE GIS software and associated GIS project. Members of the ProximityOne User Group (join now, no fee) may install the no fee software and GIS project. Develop custom zoom-in views, label school districts, perform queries, add your own data, add related geographic layers and perform other types of geospatial operations.

School Districts with City Locale Code (11, 12 or 13)

School Districts with Suburban Locale Code (21, 22 or 23)

School Districts with Town Locale Code (31, 32 0r 33)

School Districts with Rural Locale Code (41, 42 or 43)

Dallas, TX Region Zoom-in
• Shows all 4 types of locale codes as markers.
• A school district polygon layer shows boundaries for corresponding locale type markers.

Steps to Develop Custom School District Locale Code Maps (requires Windows computer with Internet connection)
1. Install the ProximityOne CV XE GIS
… run the CV XE GIS installer
… take all defaults during installation
2. Download the U.S. school district locale GIS project fileset
… requires ProximityOne User Group ID (join now, no fee)
… unzip U.S. School District Locale GIS project files to local folder c:\schooldistrictlocale
3. Open the c:\schooldistrictlocale\schooldistrictlocale1.gis project
… after completing the above steps, click File>Open>Dialog
… open the file named c:\schooldistrictlocale\schooldistrictlocale1.gis
4. Done. The start-up view appears similar to map graphics above.

Locale Code Definitions

City, Large Territory 11 … inside an urbanized area and inside a principal city with population of 250,000 or more.City, Mid-size Territory 12 … inside an urbanized area and inside a principal city with a population less than 250,000 and greater than or equal to 100,000.

City, Small Territory 13 … inside an urbanized area and inside a principal city with a population less than 100,000.

Suburb, Large Territory 21 … outside a principal city and inside an urbanized area with population of 250,000 or more.

Suburb, Mid-size Territory 22 … outside a principal city and inside an urbanized area with a population less than 250,000 and greater than or equal to 100,000.

Suburb, Small Territory 23 … outside a principal city and inside an urbanized area with a population less than 100,000.

Town, Fringe Territory 31 … inside an urban cluster that is less than or equal to 10 miles from an urbanized area.

Town, Distant Territory 32 … inside an urban cluster that is more than 10 miles and less than or equal to 35 miles from an urbanized area.

Town, Remote Territory 33 … inside an urban cluster that is more than 35 miles from an urbanized area.

Rural, Fringe 41 … Census-defined rural territory that is less than or equal to 5 miles from an urbanized area, as well as rural territory that is less than or equal to 2.5 miles from an urban cluster.

Rural, Distant 42 … Census-defined rural territory that is more than 5 miles but less than or equal to 25 miles from an urbanized area, as well as rural territory that is more than 2.5 miles but less than or equal to 10 miles from an urban cluster.

Rural, Remote 43 … Census-defined rural territory that is more than 25 miles from an urbanized area and is also more than 10 miles from an urban cluster.

Urban and Rural
For Census 2010, an urban area is a densely settled core of census tracts and/or census blocks that meet minimum population density requirements, along with adjacent territory containing non-residential urban land uses as well as territory with low population density included to link outlying densely settled territory with the densely settled core. To qualify as an urban area, the territory identified according to criteria must encompass at least 2,500 people, at least 1,500 of which reside outside institutional group quarters. There are types of urban areas:
• Urbanized Areas (UAs) of 50,000 or more people
• Urban Clusters (UCs) of at least 2,500 and less than 50,000 people
“Rural” encompasses all population, housing, and territory not included within an urban area.

Support & DMI Web Sessions
Learn more about using resources described in this section. Join us in a Decision-Making Information Web session. There is no fee for these one-hour 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. We can address your specific questions about using school and school district demographic economic data and related applications.

Making Custom Metropolitan Area Maps

The 929 U.S. metropolitan areas are comprised of one or more counties, some with up to 30 counties. More than 93-percent of the total U.S. population live in metropolitan areas. Creating metro maps is often specific to a particular analysis, zoom-view, labeling, combination of different geographies or other considerations.

This section reviews tools that you can use to flexibly develop your own maps that show U.S. metropolitan areas of interest using Geographic Information System (GIS) tools. The GIS resources enable you to view/show the metro boundaries in context with roads, landmarks and other geography. Flexibly add labels. Create pattern views. Add your own data. Metro maps can be saved as a graphic and used in any manner. There are no fees to use resources described in this section. See the  related Web section for more detail on this topic.

Metro mapping makes use of the latest vintage metro definitions (February 2013) and latest smoothed boundary shapefiles (July 2014). See more about the metro shapefile.

Atlanta, GA Metro by County — create similar map view for any metro

Atlanta metro: red/brown bold boundary; counties black thin boundary. Click graphic for larger view with county name labeling; illustrates mini-profile of component county (Fulton). See more illustrative views below.

Steps to Develop Custom Metro Maps (requires Windows computer with Internet connection)
1. Install the ProximityOne CV XE GIS
… run the CV XE GIS installer
… take all defaults during installation
2. Download the U.S. metros GIS project fileset
… requires ProximityOne User Group ID (join now, no fee)
… unzip U.S. Metros GIS project files to local folder c:\metromaps
3. Open the c:\metromaps\metromaps1.gis project
… after completing the above steps, click File>Open>Dialog
… open the file named c:\metromaps\metromaps1.gis
4. Done. The start-up view is shown below with additional instructions.

Using the Metro Maps Projects
There are three metro GIS project files included with the ZIP file. Each GIS project (*.gis) includes the same set of layers/shapefiles. Only attributes of layers set by the CV XE GIS Layer Editor differ. See about modifying layer settings with Layer Editor in the related Web section on this topic.

1. Single Metro — metromaps1.gis
When the c:\metromaps\metromaps1.gis is opened, the view shown below appears. This project illustrates how the CBSA layer query can be set to view a specific metro of interest. See the Layer Editor settings used for this view.

Click graphic for larger view.

2. All U.S. Metropolitan Statistical Areas — metromaps2.gis
When the c:\metromaps\metromaps2.gis is opened, the view shown below appears. This project illustrates how the CBSA layer query can be set to view all MSAs and/or MISAs on a national/regional scale. See the Layer Editor settingsused for this view.

Click graphic for larger view.

3. All CBSAs in a Selected State — metromaps3.gis
When the c:\metromaps\metromaps3.gis is opened, the view shown below appears. This project illustrates how to apply a CBSA layer query to view all MSAs and/or MISAs in a selected state. See the Layer Editor settings used for this view.

Click graphic for larger view.

Support & DMI Web Sessions
Learn more about using resources described in this section. Join us in a Decision-Making Information Web session. There is no fee for these one-hour 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. We can address your specific questions about using metro and county demographic economic data and related applications.