Cloudera Docs

Canadian postal code map, bubbles

Cloudera Data Visualization Map visuals support choropleth mapping of measurements over a map of Canadian FSA and Postal Codes. Map visual provides support for mapping measurements, as bubbles, over a map of Canadian FSA and Postal Codes. Bubble maps display up to two measurements simultaneously: as the color of the bubble, and as the relative size of the bubble.

A map of Canada shows a comparison of population density, at the level of the FSA (1st 3 digits of the Postal Code). The following steps demonstrate how to create a new choropleth map of Canada. This example uses the Canadian Census dataset, constructed from the canada_census_population_dwellings.csv and ca-postal-codes.csvfiles, and joined of the fields fsa and Postal Code, respectively. For more information, see Canadian census, Adding data, and Creating datasets.

  1. In the VISUALS menu, find and click Map.
    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.
  2. Populate the shelves from the DATA menu:
    1. Under Dimensions, select Postal Code 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 Color shelf.
  3. Specify the use of Canada Map View in the Settings > Map interface.
    For instructions, see Map view.
  4. Click REFRESH VISUAL.
  5. Change the display of marks to bubbles as described in Displaying bubbles on maps.
  6. Change the mark size range to 1-10 as described in Changing the mark size range.
  7. Optional: You can change or simply reverse the color palette to suit your needs.
    For instructions, see Change color palette of visuals and Reverse color palette of visuals.
  8. Optional: Alias the fields as necessary.
    For instructions, see Alias.
  9. Optional: Enable panning and zooming option, as described in Customizing zoom.
  10. Optional: Change the color palette, as described in Change color palette of visuals.
  11. Click the pencil/edit icon next to the title of the visualization to enter a name for the visual.

    In this example, the title is changed to 'Canadian 2011 Population - Postal Code Bubbles'. You can also add a brief description of the visual as a subtitle below the title of the visualization.

  12. At the top left corner of the Dashboard Designer, click SAVE.

Your visual should look something like this: