Monthly Archives: January 2014

School District Demographic-Economic Interactive Tables

Goto ProximityOne   New U.S. national scope school district demographic-economic interactive tables are now available.  These tables include approximately 600 subject matter items derived from the American Community Survey 2012 5-year estimates for each of the approximate 13, 600 school districts.

The interactive tables are organized into four related sections:
• General Demographics
• Social Characteristics
• Economic Characteristics
• Housing Characteristics

Use the interactive ranking tables to view, query, rank, compare demographic-economic characteristics of the population and housing for states and/or metros of interest.  A scroll box is provided for each section that lists each of the subject matter items available for each area in the table.

Visual Pattern Analysis
The graphic below shows percent college graduates by school district in the vicinity of the Dallas-Fort Worth-Arlington, Texas metro (bold brown boundary; county names shown as labels). Click graphic for larger view and details; McKinney ISD profile shown in expanded view.
Similar pattern analysis views may be prepared for any of the items in the tables.

Importance of these Data
These data provide “richer” demographic-economic characteristics for national scope states and metros. While Census 2010 provides data similar to those items in the General Demographics section, only ACS 2010, 2011, 2012 sourced data provide details on topics such as income and poverty, labor force and employment, housing value and costs, educational participation and attainment, language spoken at home, among many related items. The approximate 600 items accessible via the tract dataset are supplemented by a wide range of additional subject matter.  ACS 2013 school district data become available in late 2014.

Low & Moderate Income Area Analysis

GIS tools and data resources enable easier and more comprehensive mapping, geospatial and demographic analysis of census tract geography to examine low and moderate income (LMI) area pattern and characteristics.  Resources are reviewed in this section to analyze LMI data by census tract.  Though focused on LMI applications, the resources may be applied to a much broader set of census tract mapping and demographic-economic pattern analysis.

Low and moderate income designation is closely associated with implementation of the Home Mortgage Disclosure Act (HMDA) and the Community Reinvestment Act (CRA) and is widely used in many other applications as a measure of economic prosperity. The HUD Community Development Block Grant (CDBG) program seeks to expand economic opportunities for LMI areas. Of the 72,581 Census 2010 census tracts (U.S. and Puerto Rico), 5,588 are designated low income and 15,998 are designated as moderate income based on 2013 HMDA designations.

Use tools described in detail at http://proximityone.com/tractslmi.htm to analyze LMI areas of interest. Optionally set your own designations of LMI.

The following view shows a thematic pattern map of census tracts by low and moderate income status in the Houston, Texas area (red: low; orange: moderate). In this section we will review how, in just a few steps, you can develop maps like this one for your areas of interest, and others with further drill-down and labeling, using ProximtyOne no-fee resources. These resources enable national scale applications and include all Census 2010 census tracts.

We have integrated HMDA “Census 2013” data with American Community Survey demographic-economic data into a U.S. national scope shapefile. It has been made a part of a ready-to-use GIS project. See details and additional details.

State Components of Population Change

How are the demographics of states changing … and why? Based on the new 2013 population estimates and components of change, the population percent natural increase ranged from -0.55% (West Virginia) to 12.5% (Utah) during the period 7/1/2012 to 6/30/2013. This is one example of insights into the components of population change that can be determined using the interactive table in this related section to view, compare, rank state population estimates and components of change. More about these estimates.

Examining Components of Change Patterns
Population dynamics are shaped by the components of change — births, deaths and migration. The next several thematic map views show patterns of population components of change by state. Labels show the average for the years 2011-2013. Click graphic for a larger map view that also shows legend. These views were developed using the CV XE GIS software and related GIS project. More about using these resources. Scroll section …

State Average Birth Rate; 2011-2013

State Average Death Rate; 2011-2013

State Average Natural Increase Rate; 2011-2013

State Average International Migration Rate; 2011-2013

State Average Domestic Migration Rate; 2011-2013

State Average Net Migration Rate; 2011-2013

State Population Percent Change 2010-2013


Visual Analysis using GIS Tools
Use the CV XE GIS state population estimates GIS project to create thematic pattern maps such as shown in the above graphics. Develop thematic pattern maps using any of the items included in the interactive table. Members of the ProximityOne User Group (join now, no fee) may download the ready-to-use GIS project.

Demographic-Economic Comparative Analysis

The Charlotte-Gastonia-Rock Hill NC-SC Metro and Austin-Round Rock-San Marcos TX Metro are roughly the same size based on total population. How do they compare based on educational attainment? percent population in poverty? homeownership rate? age distribution? migration? employment by industry? occupation? How do business opportunities compare? What about other metros? Choose from hundreds of measures in the state/metro demographic-economic interactive tables to compare and contrast states and metros based on side-by-side comparisons.

The U.S.-State-Metro Demographic-Economic interactive tables provide a useful resource to view/compare geographies when ranked on a specific subject matter column of interest. The interactive tables are also useful to view a selected set of geographic areas where subject matter fields are arrayed horizontally for each geographic area. The U.S.-State-Metro Demographic-Economic interactive tables are available in the following Web pages.
• General Demographics DP1 table
• Social Characteristics DP2 table
• Economic Characteristics DP3 table
• Housing Characteristics DP4 table
… side-by-side comparative analysis profiles can often add more to insights.

Comparative Analysis Profiles
Create “comparative analysis profiles” using data presented in the interactive tables. View demographic-economic attributes of selected geographic areas of interest in a side-by-side manner. Place the data in a spreadsheet for further analysis, linking with other data and/or printing or adding to a report.

Partial view of sample file (access full xls file here)

Steps to Create Comparative Analysis Profiles
Step-by-step instructions to create comparative analysis profiles are provided at http://proximityone.com/usstcbsa_dp.htm. Select states and/or metros of interest. Create spreadsheet files for immediate use; save for future applications.

State & Metro Demographic-Economic Interactive Tables

Goto ProximityOne   New U.S. national scope state and metropolitan area demographic-economic interactive tables are now available.  These tables include approximately 600 subject matter items derived from the American Community Survey 2012 1-year estimates.

The interactive tables are organized into four related sections:
• General Demographics
• Social Characteristics
• Economic Characteristics
• Housing Characteristics

Use the interactive ranking tables to view, query, rank, compare demographic-economic characteristics of the population and housing for states and/or metros of interest.  A scroll box is provided for each section that lists each of the subject matter items available for each area in the table.

Importance of these Data
These data provide “richer” demographic-economic characteristics for national scope states and metros. While Census 2010 provides data similar to those items in the General Demographics section, only ACS 2010, 2011, 2012 sourced data provide details on topics such as income and poverty, labor force and employment, housing value and costs, educational participation and attainment, language spoken at home, among many related items. The approximate 600 items accessible via the tract dataset are supplemented by a wide range of additional subject matter.  ACS 2013 state and metro data become available in September 2014.

State Personal Income Patterns

Personal income is the income received by all persons from all sources;
the sum of net earnings by place of residence, property income, and personal current transfer receipts. This section, updated quarterly, summarizes tools available to analyze patterns of state personal income. See the calendar for schedule.

2013Q3 Patterns
State personal income growth slowed slightly to 1.1 percent in the third quarter of 2013, from 1.2 percent in the second quarter. Growth slowed in 25 states, accelerated in 22, and was unchanged in 3 states and the District of Columbia. Growth across states ranged from 0.4 percent in New Mexico to 1.9 percent in Mississippi.

The map presented below shows the percent change in personal income by state over the year 2012Q2 to 2013Q3 (the most recent estimate). Click the graphic to view a larger map that shows more detail and legend.

State Quarterly Personal Income; Percent Change 2012Q3 to 2013Q3
stpi2

Interactive Table
Use this interactive table to view, rank, compare personal income by state based on estimates developed by the Bureau of Economic Analysis.

More Detail
Total personal income is the “tip of the iceberg.” To understand “what is the meaning of these state patterns of total personal income requires looking under the hood. The following more detailed data show estimates of the components of personal income for Texas.

Texas Components of Personal Income
txpi1

GIS Project
The map view shown above was developed using CV XE GIS with associated GIS project (available for download by ProximityOne User Group members
(join now, no fee). Use the associated GIS project to visually analyze personal income patterns; integrate your own data.

Use Situation & Outlook to access/analyze the more detailed personal income data, integrated with related demographic-economic data.

Road Corridor Demographics

There are more than 50 million road segments in the U.S. While it is most common to view/analyze small area demographics for geographic areas such as census blocks, block groups or census tracts, the focus of this section is on providing demographic attributes for the left and right side of individual road segments. 

Road corridor demographics are demographics attached to the right- and left-sides of a road/street segment. These are demographics (e.g., population, housing, median income, etc.) for the census block or block group that the road segment faces or passes through. A road/street segment is the section of a road/street between two intersections.

Using road corridor demographics, the characteristics of chained/linked road segments, a pathway or a corridor, can be analyzed. Road segments have left- and right-side address ranges and road corridor demographics can be developed through the aggregation of address-oriented data located on the road of interest. Address data can be geocoded and attached to road segement. Examples include customers, housing sales, or patient data on a particular road segment.

See more details about developing and using road corridor demographics at road corridor demographics. The tools and methods described there are in production use. They may be applied to any county or higher-level geographic area in the whole U.S. This one-step batch application requires TIGER/Line edges, feature names and faces shapefiles. The CV XE API acquires the demographic data via Internet and codes these demographics into the road corridor shapefile, which is created as the primary output of the process.

The application demonstrated at road corridor demographics is focused on Alexandria, Virginia. The yellow highlighted road segment in the map graphic below is W. Braddock Road but could be any other set of roads.
alexrds1

Using these Resources
The CV XE GIS software available to members of the ProximityOne User Group (join now, no fee) can create the basic corridor demographics shapefile for any county in the U.S. The resulting shapefile may be used with CV XE GIS to perform analyses and/or used with other GIS software.

State Legislative District GeoDemographics

As of the 2012 election cycle updates (reflecting redistricting), the 6,558 state legislative districts in the U.S. are comprised of 4,629 lower/house chambers and 1,929 upper/senate chambers.  See details about state legislative district urban/rural composition — interactive table.  In most states the state legislative district geographic areas changed substantially in connection with redistricting and Census 2010.   The graphic shown below shows Texas senate district 016 as of Census 2010 before redistricting (blue boundary) and Texas senate district 016 as of 2012 after redistricting (red boundary) in the Dallas, Texas area.  The pointer shows where the district has a common boundary in 2010 and 2012.

sldtxu016

Understanding the current legislative district geography is essential to analysis, planning and decision-making and the demographic-economic characteristics of the district.  This post is focused on accessing and using state legislative district (SLD) geographic-demographic-economic data.  Census 2010 and American Community Survey (ACS) SLD data are available only for SLD areas as defined in 2010, prior to 2012 election cycle new redrawn boundaries.

State Legislative Districts
State legislative districts are the areas from which members are elected to state or equivalent entity legislatures. State legislative districts are comprised of upper (senate) and lower (house) chambers. Nebraska has a unicameral legislature and the District of Columbia has a single council; these are treated as upper-chamber legislative areas in the interactive table.

State Legislative District Shapefiles & Vintages
2010 and 2012 (2012 election cycle) vintage state legislative district (SLD) shapefiles are included in a U.S. national scope GIS project available to ProximityOne User Group members (no fee).  These shapefiles have been developed by ProximityOne and are based on SLD plans and data submitted to the Census Bureau.

Reference Maps
Where are 2012 (current) vintage state legislative districts?  The SLD GIS project provides the best way to view/examine SLD boundaries of interest.  These resources provide the best capability to view simple SLD boundaries possibly in combination with other types of geography and labeling.

Texas 2012 SLD-House — statewide view
Zoom- to Texas using national scope shapefile; query placed on layer to view only Texas SLD-House with SLD labels.
sldl_tx_2012_st

Texas 2012 SLD-House — zoom into Austin area
The next view shows a zoom into the Austin area (see at pointer in above graphic).  It is easy to see the boundary of SLD-House 048.  Further zoom-in could provide more detail.
sldl_tx_2012_st_048

State Legislative District Demographic Data & Vintages
While Census 2010 demographic data and American Community Survey (ACS) data are available for the 2010 vintage SLDs,  the Census Bureau has not developed Census 2010 data or  ACS data for 2012 (current) vintage SLDs. There are no Census 2010 or ACS “richer-demographics” tabulated for 2012 (current) vintage SLDs available from Census.

To develop Census 2010 demographics for  2012 (current) vintage SLDs, ProximityOne integrated 2012 SLD codes from state provided census block equivalency files into the Census 2010 Summary File 1 block level header/geography records.  Using the additional 2012 SLD code, population and housing using data have been developed for  2012 (current) vintage SLDs.

Examine State Legislative Districts of Interest
Members of the ProximityOne User Group may download and use the national scope SLD GIS project with CV XE GISJoin now; no fee.  Add other geographic layers.  View SLDs in context of 113th Congressional Districts.  View different SLD vintages.  Create different zoom and labeled views. Integrate your own data.

52 Destinations in 2014

The ability to code address data and use those geocoded data in a GIS, mapping and geospatial analysis framework is very important in many planning and decision-making applications.  This post illustrates the process of coding locations listed in the New York Times “52 Places to Go in 2014” and integrating those data into a GIS application, also using OpenStreetMaps.

52 Destinations in 2014 GIS Project View
52destinations1
Click graphic or this link for larger view.

In the above map, the geocoded destinations are shown as a layer that depicts the destinations as green circle markers.  In the larger view (clicking map) the markers are shown as red number markers.  The number corresponds to the list shown in the scroll box.

52 Destinations; click link for details
1 Cape Town, South Africa
2 Christchurch, New Zealand
3 North Coast, California
4 Albanian Coast
5 Downtown Los Angeles
6 Namibia
7 Ecuador
8 Quang Binh, Vietnam
9 Perth, Australia
10 Rotterdam, the Netherlands
11 Taiwan
12 Frankfurt, Germany
13 Addis Ababa, Ethiopia
14 Fernando de Noronha, Brazil
15 Nashville, TN
16 Scotland
17 Calgary, Alberta
18 Ishigaki, Japan
19 Laikipia Plateau, Kenya
20 Yogyakarta, Indonesia
21 Tahoe, CA
22 Yorkshire, England
23 Dubai
24 The Vatican
25 Uruguayan Riviera
26 Chennai, India
27 Seychelles
28 Krabi, Thailand
29 Aspen, CO
30 Highlands, Iceland
31 Umea, Sweden
32 Xishuangbanna, China
33 Andermatt, Switzerland
34 Indianapolis, IN
35 Mekong River
36 Athens
37 Barahona, Dominican Republic
38 Arctic Circle
39 Dar es Salaam, Tanzania
40 Downtown Atlanta
41 Nozawa Onsen, Japan
42 Subotica, Serbia
43 Elsinore, Denmark
44 Cartmel, England
45 Nepal
46 Vienna
47 Siem Reap, Cambodia
48 Varazdin, Croatia
49 St. Petersburg, FL
50 Belize
51 New Caledonia
52 Niagara Falls, NY

Geocoding
To geocode and automatically create the destinations layer, a text files was first created with the addresses.  In this example the address was generally the city and country (or state).  The CV XE GIS  Tools>FindAddresses (Batch) was started; the file name of addresses was entered; the layer is automatically developed and added to base GIS project.  Create your own layer of address/location markers for any set of addresses, worldwide.

Some addresses in the destinations set are quite specific, such as Fernando de Noronha, Brazil.  From the world extent zoom view, this location appears to be in the ocean; zooming in, as shown below, the island appears in context.
destination14

Members of the ProximityOne User Group may download and use the Destinations2014 GIS project with CV XE GIS. Join now; no fee. Add other destinations. Create different zoom and labeled views. Add other geography/layers. Click on cities layer to view other details.

Business Patterns by ZIP Code

Examining establishment characteristics by ZIP code … this post reviews availability and use of business establishment data on the number of establishments, employment and wages by type of business by ZIP code. Businesses use these data for analyzing market potential, measuring the effectiveness of sales and advertising programs, setting sales quotas, developing budgets and to support other decision-making needs.

GIS View of ZIP 64112 with Mini-Profile
The following view shows a map view of ZIP Code 64112 (red boundary) in Kansas City, MO and associated mini-profile. The short-hand item names show  a Census 2010 population of 8,147 with 642 establishments in 2001 compared to 613 establishments in 2011.   Employment changed from 15,772 in 2001  to 12,775 in 2011.

zbp64112

The most recent business establishment data summarized by ZIP code are for 2011.  Updated annually, 2012 become available in mid-2014.  ProximityOne has integrated demographic data with business establishment data.

Establishments
An establishment is a single physical location where business transactions take place and for which payroll and employment records are kept. Groups of one or more establishments under common ownership or control are firms. A single-unit firm owns or operates only one establishment. A multi-unit firm owns or operates two or more establishments. The establishments by ZIP code data are derived from a confidential register of businesses maintained by the Census Bureau. The register contains a record for each known establishment in the U.S. with employees.

Establishments are typically regarded by business establishments but can include government places of employment as well. Establishments are the places of employment that drive and characterize the economy.

Type of Business
The North American Industry Classification System (NAICS) is the statistical standard used in classifying business establishments for the purpose of collecting, analyzing, and publishing statistical data related to the U.S. business economy. NAICS was developed under the auspices of the Office of Management and Budget (OMB), and adopted in 1997 to replace the Standard Industrial Classification (SIC) system.  Most NAICS industries are included in the ZIP code business patterns data.

Data Access & Use
The following graphic illustrates use of the interactive table to view attributes of ZIP Code 64112 (highlighted in blue; same as in map view above) in a tabular format in relation to nearby ZIP codes.  Use the interactive table to examine ZIP codes of interest.
zip64112table

GIS Thematic Pattern Analysis
The graphic shown below illustrates use of the ZIP Code shapefile with integrated business attributes to display a thematic pattern map of ZIP codes by total establishments in the Houston, Texas area.  This view shows ZIP codes with darker shades of green showing ZIP codes with larger number of businesses.  The number of businesses in a ZIP code is shown with the yellow label.  This view shows total number of establishments; the map could show number of establishments or employment for any type of business/NAICS code.
ziptx

Join us in a DMI Web session where we examine use of these and related decision-making information resources in dynamic, live interactive sessions.