Tag Archives: site analysis

Developing & Using Map Graphics

.. steps to develop map graphics & visual analysis of market/study areas .. map graphics are an important part of most demographic-economic analyses and essential for many applications. Not only are are maps needed to show geographic boundaries and the relative location of geography within a broader area, they can come alive by showing patterns. A thematic pattern map of median household income by block group is a good example; higher and lower areas of economic prosperity by neighborhood can be immediately determined. Map graphics can improve our ability to communicate complex information. Convey information faster. Make more compelling presentations. Collaborate more effectively through the use of map graphics.  See related Web section for more details.

The focus of this section is on creating and using KML files to prepare map graphics for use in developing Market-Study Area Comparative Analysis Reports. These files and map graphics also have broader uses. Steps are reviewed to develop the KML circular area map graphics files, convert them to shapefile structure and integrate both files into mapping and GIS applications and put them into operational use. 

KML (Keyhole Markup Language) files are XML structured files useful for visualizing geographic objects (like circles) using Internet-based browsers, notably Google Earth. Why develop/use KML files? They are easy to create with precision, there is little to no learning curve, they can be used in many venues and they are free to develop. KML files can be used side-by-side with shapefiles. Shapefiles, structured very much unlike KML files, are the dominant vector-based file structure used in GIS applications involved in both viewing and geospatial analysis. 

Developing Circular KML Files & Map Graphics
An “objective view” of this section is shown in the following graphic. The graphic shows a study site location (red marker), 1-mile & 3-mile radius circles. The site location is a Starbucks located at 302 Nichols Road, Kansas City, MO 64112. The view shows a circular KML-based graphics in context of patterns of median household income by block group. Develop similar views for any area, any site circular configuration, using steps reviewed in this section.

– view developed using CV XE GIS

Creating the KML Circular Graphics File
Proceed through the next steps to develop a KML file used to create the graphic below on left — a Starbucks located at 302 Nichols Road, Kansas City, MO 64112. Graphic on the right is a Starbucks location in Paris, used to illustrate this process works globally. Both graphics include study area center point and 1-mile and 3-mile radius circles.

302 Nichols Road, Kansas City, MO 64112
23 Avenue de Wagram, 75001 Paris, France

Start the create KML file application
• Key in address 302 Nichols Road, Kansas City, MO 64112 to Google Maps
.. see the latitude-longitude (39.041548,-94.592965) in the URL bar.
• Open this web page to create the circles & save results as KML file.
• Refresh this page if making a new KML file.
• Set the colors and lines to medium, blank and clear.
• Enter coordinates — key in lat 39.041548 and lon -94.592965
.. these for for this example
.. enter the values for your location of interest
Add center point
• In the Radius Distance, key in 0.05 miles
• Click Draw Radius blue button (at right of longitude).
Add site 1 circle
• In the Radius Distance, key in 1.00 miles (use preferred radius for inner circle).
• Click Draw Radius blue button (at right of longitude).
Add site 2 circle
• In the Radius Distance, key in 3.00 miles (use preferred radius for inner circle).
• Click Draw Radius blue button (at right of longitude).
View study area geography
• Optionally navigate up to the map view and make the view similar to the graphic at the top of this page 
.. this step is not required but might be useful to verify the study area appearance.
Save KML file
• Navigate down the page to “Google Earth KML Output”. Click the blue button Generate KML.
• Click “Download KML file Here.” Save the file to a folder and make a note of the file path and name
.. save the file as c:\sitereport\302nichols.kml (this file and filename are used below).
Done
• The three part KML file has been created and saved to the local computer. 
• Finished using this browser application.

This same process may be used again to create similarly structured KML files of any radius about any point for any location in the world. 

Loading a KML file into Google Maps
Optionally create the objective map graphic using the following steps. Or, the KML file may be used with the CV XE GIS software (see below) enabling yet further analytical possibilities. 

 Click this link to start the Google MyMaps application.
• When the new page opens click create new map button
• Next click import button
• Enter the file path/name as created above (c:\sitereport\302nichols.kml), or any KML file.
• Edit the MyMaps rendering to achieve preferred view.
• Use preferred screen capture tool to save that part of the map view as a graphic for the study report.

Using the KML File with an Existing GIS Project and converting the KML file to shapefile structure

1. Add the KML file to an Existing CV XE GIS Project
• Start the CV XE GIS software and open the project file c:\cvxe\1\cvxe_us2.gis (distributed with installer).
.. uncheck Locations and $MHI x BG layers in legend panel.
• Click the AddLayer button (second button from left on toolbar)
• Select the KML file that was created above (c:\sitereport\302nichols.kml) .. circles appear in the map window.
• Use LayerEditor to adjust settings for KML layer (transparent, bold outline)
• Navigate to zoom-in view and smaller map window.
• Use Toolbar button Save to Image (button 7 from left) to save the map window view to a .jpg file.

Navigate to this view:

2. Converting a KML File to a Shapefile
This step requires the CV XE GIS Basic or higher level version. After the KML layer appears in the above sequence, proceed as follows:

• Click File>ExportShapefile.
• Select the KML layer name.
• Set Coordinate System edit box value to NAD83.
• Click OK button.
• On the Export Layer/FileSave dialog, select an output file path and name.
• The shapefile is generated and may be reused with any GIS project.

3. Editing attributes of the study area shapefile and project file
There are three shapes in the shapefile (center point, circle 1, circle 2). 
Modify the appearance of these shapes/objects by using the Select tool (mouse in Select mode).
• In legend panel click on circles layer; name turns blue indicating this is the active layer.
• In the map window, click in the circle; the profile/editor appears (pop-up)
• Initially all three shapes have the name “Polygon”.
.. change the object names successively to Point1 (the small circle), Circle1 and Circle2.
• The shapefile attributes have been permanently changed.
• When each shape/object has been renamed, use the LayerEditor to modify the appearance of each shape.
.. the changes modify the project file and not the shapefile.
.. optional save the project (overwriting the former version) or save the project with a new name.

Renaming a shape to “Point1”
Click for larger view

Using LayerEditor to set attributes of the study area layer
Click for larger view

View of final study area layer in context of broader project
Click for larger view

View as above with $MHI x BG checked on/visible
Click for larger view
 

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.

Interactive Location-Based Demographics Tool

.. have you wondered how Web sites determine the demographic-economic attributes for a location/address? Are those data for the corresponding block group, census tract, city or something else? Was it the “ZIP code area”? These areas can be 100,000 population or more making them so large that alternative geographies might be preferred. Often those important particulars — which geography and data sourcing — are vague or unknown. This section reviews use of the interactive Location-Based Demographics Tool to access data for a location based multiple, alternative types of address “container areas”. See more details in this related web section.

Any given address or location is contained with several types of statistical areas (e.g. census tract or block group) and political areas (e.g. city or county). We may want to know the demographic-economic characteristics of a location for any one or several of these geographies. Use the interactive tool on this page to access those data. For example, access/view the median household income of the location/address block group or the median household income the location/address city. Key in the address of interest, select the type of geography and click Find — see graphic below. The results are displayed on the same page.

Click this graphic to view address entry form

Profile for Census Tract
When Tract is selected as Type of Area, this profile is displayed:
(median household income is $118,827)

Profile for Block Group
When Block Group is selected as Type of Area, this profile is displayed:
(median household income is $139,342)

Creating Maps for These Geographies
See this related web section about using the MapCompiler to create map views for these block group and census tract areas in the vicinity of the default address used above (1 Infinite Loop, Cupertino, CA). Use the CV XE MapCompiler (GeoGateway feature) to create similar maps for any area 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.

Creating & Using Address Shapefiles

… there are many online tools that enable you to key in an address and show the location on a map. This section is focused on creating and using address-based point shapefiles in a GIS context. These methods provide similar information, showing the addresses on a map, but also enable a wide range of analytical capabilities. For example, find out how many of your addresses are in one county or census tract. Or, determine the census block or school district for each address.

Visualize Address Locations

The above views illustrates use of Find Address tool, described below, to locate/show addresses listed below. Marker/locations are shown with different markers based on a query. Markers are labeled with the point ID.
1100 Main St, Kansas City, MO 64105
1301 Wyandotte St, Kansas City, MO 64105
1701 W. 39th Street, Kansas City, MO 64111
4101 Main Street, Kansas City, MO 64111
302 Nichols Rd., Kansas City, MO 64112
6100 Broadmoor St, Mission, KS 66202
5800 Antioch Rd, Merriam, KS 66202
11815 E Highway 40, Independence, MO 64055

Use the no-fee ProximityOne User Group version of the CV XE GIS software to enter addresses, show them on a map and automatically save the shapefile for reuse in the existing or other GIS projects.

Entering Addresses
Install CV XE GIS software and enter your User Group userid. Start CV XE GIS and select the Tools>Find Address feature.

After clicking Tools>Find Address, prompt appears showing default address. Enter an address or use the default value; click OK. Optionally continue adding addresses.  End the process by entering null address (no value). The first step is illustrated in the following graphic using an address in the Kansas City, MO area.

Shapefile Automatically Created
The default point shapefile name c:\cvxe\1\$$address1.shp is created as shown in message in the graphic below. In this example, only one address was entered. The address location is shown by the red marker. The shapefile is added to the existing GIS project. See legend panel top left in the graphic.

Using the Results
The next graphic illustrates using the Identify tool to click on point which displays the mini-profile for the selected point/address. Address/point attributes that are automatically created include the point number and address in ‘name’ field. Use other features of the software to modify the marker/point appearance, label the addresses or add other attributes to each address.

Unlike online address-locators and display services, using the GIS operation you can determine which in which census block or other political/statistical areas (congressional district, school district, etc.) the address is located. If your point shapefile contains many addresses there are also geospatial analysis tools that can be used. Use the site analysis feature select a group of addresses, visually on the map, and create/display a profile of aggregated data for the selection of points.

Contextual View of Matched Road/Street Segment
You can also view the address locations in context of the matched street segment. The next graphic shows a zoom-in view. The roads/streets layer has made active (click on layer name in legend panel). The Identify tool is used to create mini-profile of matched street segment as shown in the graphic below.

By using the road segment attributes, the census block code (and higher level geocodes) can be determined/assigned. See more about the road segment attributes.

There are many other tools to create address-based point shapefiles. For example, you might have a file with existing latitude-longitude values/fields. In this case, the Find Address or Find Address-Batch operation is not needed — the latitude-longitude values have already been assigned. Creating a point shapefile by importing records with existing latitude-longitude will be reviewed in an upcoming blog post.

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.