Tag Archives: Honolulu

Integrating Political/Statistical Geography with OpenStreetMaps

OpenStreetMaps (OSM) is a collaborative project to create/maintain a free editable map of the world. The OSM Internet-based map resource is built by a community of people who contribute and maintain data about roads, local geography and much more, all over the world.

Houston, TX; Texas 113th Congressional District 29
The following view illustrates using a congressional district shapefile (blue boundary) in combination with OSM as a base layer.

GIS Applications Linking/Combining Shapefiles with OSM
This section illustrates viewing political/statistical geography in context of streets/roads shapefiles and/or Web-based street/ground coverage graphics. When using GIS tools to view census tracts (as one example) rendered through the use of shapefiles, there is often no convenient way to view the boundaries in context of roads/ground cover. There are two alternatives. One option is to add a layer using the corresponding streets/roads shapefile. This option has important features but is often difficult, time-consuming or not feasible as the roads shapefile coverages are organized in county units. Also roads shapefiles provide only part of the picture with respect to ground coverage. A second option is to use Web-based roads/ground coverage tiling services such as OpenStreetMap. Both options are reviewed here.

Georgia Metropolitan Statistical Areas shapefile overlay
Metropolitan areas are shown as brown boundaries in the following view.

The CV XE GIS software is used to view a census tracts shapefile/layer in context with 1) roads shapefile/layer and 2) Web-based OpenStreetMap (OSM) layer via OSM WMS (OGC Web Map Service). CV XE GIS supports the OGC WMS standard, which means that it can be used to open map layers from any properly functioning WMS server, including OSM WMS servers. Use of the OSM shown here is available at no cost and has global coverage. Tiling graphics are courtesy of MapQuest.

Honolulu, Hawaii with Census Tract Boundaries
The Hawaii census tracts boundaries (red) are shown in the following view.

Get Started Now
No registration or fees are required to use the CV XE GIS software with OSM. Run the CV XE GIS installer on a Windows-based computer and create views/applications such as those shown below. Make custom maps of your neighborhood or a city/country anywhere in the world.

New York City with Census Tract Boundaries
New York census tracts boundaries (red) are shown in the following view.

Atlanta, GA Region Diversity Patterns Neighborhood
Census tracts are colored based on value of the diversity index. See color patterns assigned based on diversity index values as shown in legend at left of the map. Blue tracts are most diverse; red tracts are least diverse. Tracts shown with black cross-hatched pattern are tracts with 50-percent or more Hispanic population. Transparency of the shapefile layer is set to 80% enabling the view of the OSM basemap layer.

About the Author
— Warren Glimpse, developer of the CV XE GIS software, is former senior Census Bureau statistician responsible for innovative data access and use operations. He is developer of the Columbia, MO GBF/DIME used as the prototype for the Census Bureau TIGER/Line system. 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.

Power of Combining Maps with Data

.. Geographic Information Systems (GIS) provide flexible and powerful capabilities to combine maps with data. Here we review easy-to-use examples of how you can do more with GIS tools. 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.

GIS provides us with a way to improve collaboration; we can more easily comprehend and understand geographic relationships and patterns among “variables.” As we reduce tabular data to visual representations, we are better able to communicate “what the data are telling us” among stakeholders and teams/committees. This second dimension, learning what the data are telling us, provides the power of creating insights for more effective decision-making.

Toward these ends, GIS applications provide dynamic map atlas/reference maps, thematic pattern maps and geospatial analysis capabilities. Examples of these three types of GIS applications are provided below. You can explore these applications on your own computer and modify the applications to meet your own geographic and subject matter needs.

1. Install the GIS Software and Project

Install CV XE GIS (Windows-based computer)
• Create the folder c:\hawaii2014
• Expand GIS Project Fileset to c:\hawaii2014.
— requires ProximityOne User Group (join now, no fee).
• With CV XE GIS running, open the “Hawaii2014” GIS project
— File>Open>Dialog and select c:\hawaii2014\hawaii2014.gis

Start-up View: Honolulu:

Click graphic for larger view.
See more about this GIS Project.

2. Making/Using a Reference Map
With CV XE GIS running, open the Hawaii2014 GIS reference project
— File>Open>Dialog and select c:\hawaii2014\hawaii2014_reference.gis
The start-up view (below) is a reference map of the Houston, TX area. One metro is selected using a query; counties are labeled. It is easy to see the counties that comprise the Houston metro, their names and locations. Try it yourself. Navigate to any metro.

Click graphic for larger view.

3. Making/Using a Thematic Pattern Map
With CV XE GIS running, open the Hawaii2014 GIS pattern project
— File>Open>Dialog and select c:\hawaii2014\hawaii2014_pattern.gis
The start-up view (below) is a thematic pattern map of the 48 states showing metros by median household income. See color/value patterns in the legend at the left of the map panel. It is easy to see the how metros vary by median household income. Try it yourself. Change the colors/interval patterns. Label the metros with name. Zoom-in to any region. Add your own layers/data.

Click graphic for larger view.

4. Using Geospatial Analysis
With CV XE GIS running, open the Hawaii2014 GIS project
— File>Open>Dialog and select c:\hawaii2014\hawaii2014.gis
This is the basic GIS project; start SiteAnalyst: Analytics>SiteAnalyst.
The graphic below shows a site analysis view of schools selected by a circle. Attributes of the schools to analyze has been set to enrollment by grade (6 grades K-6 — upper right panel). As the selection is made, the schools are selected and enrollment summarized/aggregated (lower right grid). It is easy to see the aggregate enrollment by grade. Try it yourself. Select a different set of items to be aggregated. Select a different set of schools. Zoom-in to any area of interest. Add your own layers/data.

Click graphic for larger view.

Support Using these Resources
Learn more about demographic economic data and related analytical tools. 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.

School Location Analysis

Goto ProximityOne  Location-location-location … this section illustrates use of GIS tools to develop custom maps showing location of points of interest, based on addresses, in context of other geography and patterns. Anyone with Internet access and a Windows-based computer can develop location analyses shown in this section for locations of interest anywhere in the U.S.

Starting at the end of this post, the objective is to display/examine the address in the context of related geography as shown in the graphic below.  The location, address, is shown by the red marker in context with street (and mini-profile of the street segment) and associated census block (red boundary, yellow census block code). The Koko Head Elementary School  address (189 Lunalilo Home Road, Honolulu, HI 96825) is used in this example. It could be any school in the U.S. or any address, school or otherwise. The view and details are reviewed in more detail below.

Examining Location/School in Context of Neighborhood
While there are many Web-based resources to obtain a map view of the location based on the address, and/or attributes of the school based on name, resources reviewed here provide a more flexible and comprehensive way to examine a location/school in context of the neighborhood and surrounding area demographics.  This process requires the types of resources reviewed here.

Study Area
The study area is in the vicinity of Hanauma Bay located west of Waikiki Beach in Honolulu, HI. The steps illustrated here can be similarly applied to anywhere in the U.S.

The next graphic shows a zoom-in view of the study area.  The coastline edge is shown with a line-shapefile that depicts perennial water features.

Geocoding: Assign Latitude-Longitude & Census Block Code
The address is entering into the CV XE GIS Find Address tool input box:
Clicking OK, a point shapefile is automatically created and added to the active GIS project. The next graphic shows the address location as a red marker.  The Identify tool is used to show the results of the geocoding.  Clicking on the marker displays the mini-profile.  The census block code is 150030001141014 or 15-003-000114-1014.  The address is located in FIPS state code 15, FIPS county code 003, Census 2010 census tract code 000114, and Census 2010 census block code 1014.  For other potential geo-referencing purposes, and as shown in the mini-profile, the latitude-longitude values are also retained in the shapefile dbf record.

A zoom-in view shows the study area in more detail. Roads are shown as black lines; census blocks are shown with red boundaries.

Zoom-in Detail; Location in Context
The view shown below shows the location (red marker) in context of street location and in context of associated census blocks.  Census blocks are shown with red boundaries and show yellow census block codes as labels.  The school is located within census block 1014.  Selected attributes of the street segment are shown in the profile.  The left- and right-side from address and to address ranges are shown as well as the left-side and right-side ZIP code.  These left- and right-side attributes are available for any intersection-to-intersection street segment in the U.S.

Economic Prosperity by Neighborhood
The next graphic shows patterns of economic prosperity in the broader area.  Koko Head ES is shown by the red marker (see pointer).  The color-coded areas show patterns of median household income (MHI) based on block group geography.  Intervals and color codes are shown in legend at left of map.  Labels show the MHI by block group.  The gray area has population of 39; MHI estimate is not available.  The MHI estimates are based on 2011 ACS 5-year data.  A more comprehensive analysis could select from approximately 250 subject matter items by block group (view available items).

Resources and Using the Tools
A GIS project was developed using the CV XE GIS software (no cost, details below.   The GIS project is comprised of two public domain shapefiles: the TIGER/Line 2013 edges/roads and the TIGER/Line 2013 census blocks.  The address point location was determined by entering the address into the CV XE Tools>Find Address feature.  The Find Address feature determines the latitude-longitude and census block code for the location.  A point shapefile is dynamically created.  The project is then saved for subsequent re-opening and use.

The GIS project and tools used to develop views shown in this section are available to ProximityOne User Group members. Join now, no fee. Members may download the GIS project and dynamically create related view.  This application can serve as an example to develop similar applications for locations of interest.

Related Sections
Schools and School Districts Main Page.
Hawaii Demographics.

Next Steps
An upcoming post will delve deeper into using these smaller area geodemographics to develop and analyze neighborhood patterns and trends.  Join us in the upcoming December 17, 2013 one hour web session where we talk about using the ACS 2012 5-year demographics for small area analysis.  Those new data are scheduled to be released that day.