Tag Archives: TIGER/Line

Creating Maps & GIS Projects

.. follow these steps to create custom maps & GIS projects .. while maps are “everywhere,” there is a continuing need to make new maps. Reasons for this include changing underlying geography, new features (like stores or customers to be viewed), visually examining geographic relationships not available elsewhere (e.g., census tracts and ZIP codes), different geographic depictions for an area (smoothed versus precise vertices) and other reasons. A map can provide view(s) that relate to geospatial analysis; map visualization can be indispensable (showing road features adjacent to selected properties).

View of Initial Map Objective — University Park, TX; Dallas Metro area
Census tracts (black boundary) shown with census tract code as label.

— view developed using CV XE GIS software

Follow steps in this section to make a map like above for any area in the U.S. This section provides an overview of how to use the CVGIS software to quickly build a map. It is actually more than a map, it is the process of building a GIS project. A map is one rendering that can be displayed, and optionally published, using a GIS project. Map/GIS project development steps reviewed here can be performed using the no fee CVGIS software and no fee data resources, CVGIS Levels 1 and higher can save the GIS project and have additional geography available. With geographic extension, the process illustrated here can work for any place in the world. A GIS project is a file itself that contains references to map files (shapefiles) located on your computer. Once a GIS project has been created and saved, it can be immediately opened with CVGIS using the File>Open operation. After turning your computer off, and restarting it, the GIS project can be re-opened to display the same view as saved in an earlier session.

No Previous GIS/Mapping Experience Required
This section is designed for use by anyone including those with no previous GIS/mapping experience. Requirements are a Windows computer and Internet access. This section is a part of a module used in the Certificate in Data Analytics and the CVGIS Certification Programs. Developers can also benefit from this and related tutorials to learn more about how GIS can be integrated with other data analytics tools and methods.

Making Maps Steps
The objective of this session is to develop a map (and GIS project) to view characteristics of census tract “48113019301”. The first step in making a map (GIS project) is to have a clear objective. This 11 character geocode uniquely identifies this Census 2010 census tract among all other 73,057 tracts in the U.S. See more about census tract geography and geocodes. While this application shows a process for adding only two layers, it could be extended by adding more. Similarly, while this application uses a census tract boundary files (shapefile), alternatives are census blocks, block groups, ZIP code areas, among others.

These steps should take an inexperienced user 10-15 minutes to develop a new CVGIS project view. If anything becomes confused, close the program and start over.
Step 1. Install CVGIS (1/1/2017 or later version)
Step 2. Open Base Project
Step 3. Get Census Tract Shapefile
Step 4. Get Roads Shapefile
Step 5. Modify Map View
Step 6. Optionally Save GIS Project

The view should now be similar to the view at the top of this section.

Next Steps
Try the process yourself with geography of interest to you. View/use other “Creating Maps & GIS Projects” tutorials to learn about:
• integrating subject matter
• developing and using thematic maps
• creating site profiles

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.

New 2016 Digital Roads Database

.. new resources for updated geographic reference and statistical mapping and geography for routing logistics and optimization .. The Census Bureau TIGER/Line is a continuously updated geographic database used for geographic reference and geospatial processing of data from various Census statistical programs including the decennial census Census 2010 and American Community Survey (ACS 2014). The public use version of TIGER is released annually that includes updates developed during the year. ProximityOne integrates the TIGER geographic updates in the Digital Map Database. Warren Glimpse, founder of ProximityOne, developed the GBF/DIME used as the prototype for TIGER/Line development.  See related Web section for more details, interactive table and access to GIS resources.

The TIGER database includes many types of files and data. The data are developed in the form of shapefiles and dbase files that may be used directly with the ProximityOne CV XE GIS software at no fee. Perform wide-ranging mapping and geospatial analysis applications using these GIS resources. See more aboutmapping statistical data.

TIGER/Line Roads Data
This section is focused mainly on the use of the TIGER/Line “edges” shapefile. The edges shapefile U.S. wall-to-wall street/road coverage in the form of line shapefiles. Lines classified as roads are intersection-to-intersection road segments. Line segment fields include name, left- and right-side high and low addresses, and many related attributes.

Use the U.S. by county interactive table below to examine attributes of TIGER 2016 street/road coverage. ProximityOne developed these county summary data by processing each county edges shapefile. See about using the edges shapefile with the CV XE GIS software below in this section.

Illustrative Applications
The following sequence of graphics shows an example of a “road segment” in context of related geography. These applications focus on an area in Kansas City, MO (Jackson County),. Jackson County has 52,139 TIGER 2016 road segments. See the related step-by-step summary of how you can create these and similar map views using CV XE GIS below in this section.

Road Segment Map View & Profile
– Starbucks locations shown as red markers; pointer on road segment by a Starbucks location.
– View illustrates how non-Census, non-statistical data can be integrated with TIGER.
– Clicking on the road segment (in GIS operation), a mini-profile displays.
– The profile shows attributes of the selected road segment.
.. the TLID value shows the unique ID for this segment among all segments in U.S.
.. left- and right-side high and low address ranges and included in the profile.

Corresponding Census Block Profile
– The road segments are boundaries for census blocks.
– The census block boundaries are shown using a related TIGER blocks shapefile.
– The more that 11 million census blocks cover the U.S. wall-to-wall.
– The census block code (290950073002017) is shown as a label in the map graphic and in the profile.

Neighborhood & Shopping Area View
– A zoom-out shows the location, roads and blocks for a broader areas.

Regional View
– A further zoom-out shows the focus area view in context of the metro counties (a related TIGER shapefile)
– The January 2016 Kansas City city area (orange cross-hatch pattern) is shown using a related TIGER 2016 shapefile.

TIGER 2016 Roads
TIGER/Line 2016 vintage files were released in August 2016. While many aspects of road coverage remain as described in this section, TIGER/line 2016 includes many updates as well as “new vintage” geography for school districts, state legislative districts, congressional districts and other political/statistical area geography.
• More about TIGER 2016.
• More about TIGER/Line in general.

TIGER 2016 Road/Street Name/Address Coverage
— Interactive Table
The following graphic illustrates use of the interactive table to examine the number and characteristics of road segments by county. This view shows the top 10 counties based on the number of total road segments.

– click graphic for larger view

Using TIGER/Line with CV XE GIS
These operations require a 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 TIGER Roads project fileset
… requires ProximityOne User Group ID (join now)
… unzip TIGER Roads GIS project files to local folder c:\tiger2016
3. Open the c:\tiger2016\riger2016_kc.gis project
… after completing the above steps, click File>Open>Dialog
… open the file named c:\tiger2016\tiger2016_kc.gis
4. Done. The start-up view is shown at top of this section.

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.

Daytime Population by Census Tract & Neighborhood

.. examining workers living/working in area .. population change due to commuting & employment/residence ratio .. the concept of the daytime population refers to the number of people who are present in an area during normal business hours, including workers. This is in contrast to the resident population present during the evening and nighttime hours. Information on the expansion or contraction experienced by different communities/areas between nighttime and daytime populations is important for many planning purposes, including those dealing with market size, trade/service areas, transportation, disaster, and relief operations. See related Web section with more detail.

This section reviews use of analytical tools to examine daytime population and related measures by census tract using GIS resources. These data are based on the 2013 American Community Survey 5-year estimates (ACS2013).

Topics:
• Patterns of Resident Population by Census Tract
• Patterns of Daytime Population Census Tract
• Patterns of Employment-Residence Ratio by Census Tract

Patterns of Resident Population by Census Tract
The following graphic shows patterns of the resident population by census tract for the Los Angeles area. Census tracts are statistical areas designed to average 4,000 population as reflected in this view. See population size/color intervals in inset legend. Primary roads are shown in the graphic; the pointer shows the Los Angeles-Orange County boundary. Click graphic for larger view. Expand browser window for best quality view. The larger graphic shows Los Angeles city as a cross-hatched overlay. This graphic is presented to compare/contrast patterns of the daytime population shown in the next graphic.

– View created with CV XE GIS.

See more about the Los Angeles metro and California state & regional data resources.

Patterns of Daytime Population Census Tract
The following graphic shows patterns of the daytime population by census tract for the Los Angeles area. This graphic is presented to compare/contrast patterns of the daytime population shown in the above graphic. As the employed population commutes during the data, the daytime population of census tracts change as reflected in this view. See population size/color intervals in inset legend. Primary roads are shown in the graphic; the pointer shows the Los Angeles-Orange County boundary. Click graphic for larger view. Expand browser window for best quality view. The larger graphic shows Los Angeles city as a cross-hatched overlay.

View created with CV XE GIS. Click graphic for larger view.

Patterns of Employment-Residence Ratio by Census Tract
The following graphic shows patterns of the Employment-Residence (E-R) Ratio by tract for the Los Angeles area. See E-R/color intervals in inset legend. See about the E-R ratio below. Primary roads are shown in the graphic; the pointer shows the Los Angeles-Orange County boundary. Click graphic for larger view. Expand browser window for best quality view. The larger graphic shows Los Angeles city as a cross-hatched overlay.

View created with CV XE GIS. Click graphic for larger view.

About the Employment-Residence (E-R) Ratio
The E-R ratio is a measure of the total number of workers working in the area, relative to the total number of workers living in the area. The E-R ratio is used sn indicator of the jobs-workers balance in an area. A value greater than 1.00 shows there are more workers working in the area than living there (net importers of labor). A value of less than 1.00 is shown in areas that send more workers to other areas than they receive (net exporters of labor).

See related Web section for information on daytime population terms and concepts.

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.

Real Purchasing Power by State & Metro

.. how does the real purchasing power in metros of interest compare to other metros? Use data and tools reviewed here to examine the purchasing power of the incomes in different metros and states … this section provides access to regional price parities (RPPs) estimates developed compare regions within the U.S. RPPs are regional price levels expressed as a percentage of the overall national price level for a given year. The price level is determined by the average prices paid by consumers for the mix of goods and services consumed in each region. See about these data. See example about using RPPs below in this section.

• Use the interactive table to view, rank, compare the RPPs
.. for all states and metropolitan statistical areas (MSAs).
• Use GIS tools described here to develop RPP thematic pattern maps.
.. add your own data & geography, select different HPI measures or criteria.
.. zoom to different geographic extents, label and modify colors as desired.

Patterns of Regional Price Parities by Metro: 2014
The following graphic shows patterns of 2014 all items Regional Price Parities by metro (MSAs). The color patterns/intervals are shown in the inset legend. In additional views (below this graphic) metros are labeled with the 2014 all items RPP. Click graphic for larger view. Expand browser to full window for best quality view. Use the GIS tools described here to develop thematic pattern maps for a range of data and criteria.

.. view developed using the CV XE GIS software.
.. click map for larger view and details.

Additional Views — install GIS project (see steps here) and create your own custom maps
Georgia & Region
Missouri & Region
Texas & Region

Using the RPP — Illustrative Examples
1. Comparing real purchasing power:
  — Houston, TX metro compared to Waco, TX metro.
The the all items RPP for the Houston metro in 2014 was 100.3 while the all items RPP for the Waco, TX metro in 2014 was 91.5. (from RPP table). On average, prices are 0.3 percent higher and 8.5 percent lower than the U.S. average for the Houston metro and the Waco metro, respectively. The per capita personal income (PCPI) for the Houston metro in 2014 was $54,820 and the per capita personal income for the Waco metro was $35,340 (get from the table at http://proximityone.com/reis.htm). The RPP-adjusted PCPI values are $53,223 ($54,820/1.03) and $38,622 ($35,340/0.915), respectively. The gap between the purchasing power of the two metro PCPIs is reduced when adjusted by their respective RPPs.

2. Comparing real purchasing power:
  — Washington, DC metro compared to Columbia, MO metro.
• Washington, DC metro 2014 all items RPP: is 119.4 (from RPP table); 2014 PCPI: $62,975 (from this table)
• Columbia, MO metro 2014 all items RPP: 93.0 (from RPP table); 2014 PCPI: $41,418 (from this table)
• The RPP-adjusted PCPI values are $52,742 ($62,975/1.194) and $44,535 ($41,418/0.93), respectively.

Using the RPP Interactive Table
Use the interactive table to examine the RPP by state and metro. The following graphic illustrates use of the table to show the 10 metros having the highest 2014 all items RPP. Click graphic for larger view. Examine metros and states of interest with more detail using tools below the table.

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.

Housing Price Index by 5-Digit ZIP Code

.. tools to examine housing prices by 5-digit ZIP code and how they are changing .. of the 17,931 5-digit ZIP codes tabulated, 8,074 experienced a decrease in housing value during the period 2010 to 2015. At the same time, 8,672 ZIP code areas experienced an increase in housing value. Housing prices increased for most ZIP codes from 2014 to 2014.  Find out more about housing prices and trends for ZIP codes of interest using tools described here. These data are based on experimental estimates of the Housing Price Index (HPI) by 5-digit ZIP code based in part on home sales price data from Fannie Mae- and Freddie Mac-acquired mortgages. See more about these data.

• Use the interactive table to view, rank, compare the HPI for all 5-digit ZIP code areas tabulated.
• Use GIS tools described here to develop thematic pattern maps; add your own data & geography, select different HPI measures or criteria; zoom to different geographic extents, label and modify colors as desired.

Gaining Insights in Housing Prices, Conditions & Markets
  .. Characteristics, Patterns & Trends
  .. join in .. one hour web session — overview & connectivity details

Patterns of Housing Value Change by ZIP Code: 2010-15
The following graphic shows patterns of housing value appreciation by ZIP Code: 2010-15 for the Houston metro (bold brown boundary). The color patterns/intervals are shown in the inset legend. Data are not available, using the criteria applied (2000 base year), for areas not colored In the larger view (click graphic), ZIP codes are labeled with HPI percent change from 2010 to 2015. Click graphic for larger view. Expand browser to full window for best quality view. Use the GIS tools described here to develop thematic pattern maps for a range of data and criteria.

.. view developed using the CV XE GIS software.
.. click map for larger view and details.

Additional views:
Atlanta area
New York City area
Washington, DC area
Los Angeles area

Examining Recent Trends; Current Estimates & Projections
The interactive table presents annual HPI data 2010 through 2015. A much larger set of these ZIP codes show a negative change between 2010 and 2015 compared to the one year change 2014-2015; The data generally show more ZIP codes experiencing housing value appreciation 2014-2015 compared to the longer period 2010 to 2015. These trends underscore the importance of having more recent data for use in analysis, planning and decision-making. The next update based on transaction data will be May 2017 or later.

ProximityOne uses the HPI transaction data with other data to develop HPI current estimates (2016) and annual projections to 2021 with quarterly updates as a part of the Regional Demographic-Economic Modeling System (RDEMS). Experimental county-up (metro, state, U.S.) and sub-county estimates and projections are planned for the fall 2016 quarterly update. The model based estimates and projections include the number of units by type and value that are added to the housing stock used to compute a variation of the HPI.

Housing Price Index by 5-Digit ZIP Code: 2010-2015
  — Interactive Table
Use the interactive table to examine the Housing Price Index (HPI) by 5-digit ZIP code. The following graphic illustrates use of the table to show the 10 ZIP codes experiencing the largest percentage increase in the HPI from 2014 to 2015. Click graphic for larger view. Examine cities or ZIP code ranges of interest using tools below the table.

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.

Mapping Statistical Data Updates

.. statistical mapping & visual data analysis … ready-to-use GIS projects/datasets … Geographic Information Systems (GIS) provide flexible and powerful capabilities to combine maps with data. In our increasingly data rich environment, we often experience “drowning in data.” GIS tools can help harness disparate and voluminous data and assist with data linkage. This section provides links to other sections that provide information on no cost GIS software and “production” GIS projects and datasets that you can use.

• Recent Additions
– Real Gross Domestic Product by State & Area – 06/23/16 – details
– Housing Price Index by Metro; 2015Q1-2016Q1 – 07/02/16 – details
– Housing Price Index by 5-Digit ZIP Code; 2010-2015; 07/02/16; details

Example: Mapping Median Housing Value by ZIP Code;  Los Angeles Area
Make this type of view/map for any area. Click graphic for larger view. Larger view illustrates use of identify/select tool to show mini profile for a selected ZIP code (see at pointer). Expand browser window for best quality view. Using GIS resources described here.


View developed with CV XE GIS software.

Related Topics in Mapping Statistical Data section …
• K-12 Curriculum Program
Data Analytics & Mapping Statistical Data in the Classroom

• GIS Projects/Datasets/Applications
World by Country
U.S. by State
U.S. by Congressional District
State Legislative Districts
U.S. by Metropolitan Area
U.S. by County
U.S. by City/Place
U.S. by ZIP Code Area
State by Census Tract (each/all states)
State by Block Group
State by Census Block
K-12 Schools & School Districts
K-12 Schools & School District Data Analytics

Join in … participate in the weekly Data Analytics Lab sessions 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.

Census Tract-City Relationship Table

.. what census tracts are located in cities of interest? What are their codes? Conversely, do you have census tract codes and need to know corresponding city(s)? Get answers here.

This section provides access to an interactive table useful to examine relationships among Census 2010 census tracts, cities/places, and counties. Many cities and counties that might be experiencing demographic-economic decline will often have bright spots that are groups of a few or many census tracts. Census tracts are important sub-county geography in data analytics. See the related section on census data analytics. See more about census tracts and data analytics below in this section.

Relating Census Tracts to Cities & Counties
Census tracts are sub-county areas and nest coterminously within counties. The 6-character tract code is unique within county. For cities 10,000 and larger, there are some number of whole census tracts within the city. But around the perimeter of cities, census tracts will often be partly within and partly outside of the city. The following graphic shows the relationship of tracts, cities and counties in the Plano city area (green fill pattern) located mostly in Collin County within the Dallas metro. Click graphic for larger view, more detail and legend color/data intervals. This map illustrates the geographic level of detail available using census tract demographics and the relative ease to gain insights using geospatial data analytics tools.

– View developed using CV XE GIS and related GIS project.

Using the Interactive Relationship Table
A small part of Plano is located in Denton county (see north-south bold red-brown boundary). Tract 021627 (see pointer) is located in Denton County and includes a part of Plano. To determine what geography tract 021627 intersects, click the Tract> button below the interactive table shown below. See that the tract is contained in parts of 4 cities.

Census Tract to City/Place & County Equivalence Table
The following graphic illustrates use of the interactive table to view/examine the relationship between census tract 48121021627 (in Denton County, TX) and the city of Plano, TX. Click graphic for larger view.

The above view was developed using the interactive table:
– click the ShowAll button
– click the FindTract button (preset to locate this tract).

Click the ShowAll button and enter a city/place (case-sensitive) name of interest to view the set of intersecting tracts. See the table usage notes below the table in the related Web page. We review operation of the table in the Data Analytics Web sessions.

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.