Cloudera Docs

US state map, choropleth

CDP Data Visualization Map visual lets you plot measurements, as areas, over US State regions.

A map of the United States shows a comparison of measurement values among US States.

The following steps demonstrate how to create a new map visual on the dataset US County Population [data source samples.us_counties]. It produces colored regions for the measurements that correspond to the state field.

  1. Start a new visual based on dataset US County Population [data source samples.us_counties]; see Creating a visual.
  2. In the visuals menu, find and click Map (row 5, column 1).
    selecting map chart type
    selecting map chart type
  3. Note that the shelves of the visual changed. They are now Geo, Color, Size, Drill, Tooltips, X Trellis, Y Trellis, and Filters.

    The only mandatory shelf for map visuals is Geo.

    shelves of map visual type
  4. Populate the shelves from the available fields (Dimensions, Measures, and so on) in the Data menu.
    1. Under Dimensions, select stname and add it to the Geo shelf.

      Click on the field to open the Field Properties menu, expand the Change Type option, and select the Geo Type State.

    2. Under Measures, select tot_pop and drag it over the Colors shelf.

      Click the field to open the Field Properties menu, select Display Format,Category Integer, and select the thousands separator option. Click Save.

      Integer formating for population
  5. [Optional] Alias the field stname as State, and sum(tot_pop) as Population; see Alias.
  6. [Optional] Enable panning and zooming option, as described in Customizing zoom.
  7. [Optional] Change the color palette, as described in Change color palette of visuals.
  8. Click Refresh Visual.

    The map visual appears.

    State population map
  9. Click (pencil icon) next to the title of the visualization to edit it, and enter the new name.
  10. Change the title to US State Population - Choropleth Map.
  11. At the top left corner of the Visual Designer, click Save.