Cloudera Docs

Canadian province map, choropleth

CDP Data Visualization Map visual supports choropleth mapping of measurements over a map of Canadian Provinces and Territories.

A map of Canada shows a comparison of measurement values among Canadian Provinces and Territories.

The following steps demonstrate how to create a new choropleth map of Canada. We are using the dataset Canadian Census, constructed from the files canada_census_population_dwellings.csv and ca-postal-codes.csv, and joined of the fields fsa and Postal Code, respectively. See Canadian census. Also, see Adding data and Creating datasets.

  1. Start a new visual based on the Canadian Census dataset; 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 Data menu:
    1. Under Dimensions, select Province from the table ca_postal_codes, and add it to the Geo shelf.
    2. Under Measures, select Population 2011 from table canada_census_population_dwellings, and add it to the Colors shelf.
  5. Specify the use of the Canada Map View in the Settings > Map interface; see Map view.
  6. Click Refresh Visual.
  7. [Optional] Alias the fields as necessary; see Alias.
  8. [Optional] Enable panning and zooming option, as described in Customizing zoom.
  9. [Optional] Change the color palette, as described in Changing color palette of visuals.
  10. Click (pencil icon) next to the title of the visualization to edit it, and enter the new name.
  11. Change the title to Canadian 2011 Population - Province Choropleth.
  12. At the top left corner of the Visual Designer, click Save.

Your visual should look something like this:

Canadian provinces choropleth map