Latitude and Longitude Map with Bubbles

Arcadia Data supports measurement plots over a geographic map, based on latitude and longitude. Bubble maps display up to two measurements simultaneously: as the color of the bubble, and as the relative size of the bubble.

A geographic coordinate map of the United States, based on degrees of latitude and longitude, shows a comparison of measurement values across US States.

The following steps extend the work completed in US Zipcode Map with Bubbles, and demonstrate how to create a map visual on the dataset Income Tax Returns. It produces maps with bubble marks that correspond to the relative size of the measurement at each latitude and longitude pair.

Before starting this exercise, supplement the Income Tax Returns dataset by adding data from zipcode-lat-long.csv into your database, and making a simple joins between zip_tax_returns_2016.zipcode and zipcode_lat_long.zipcode. See Data Model: Joins.

  1. Clone the Income Tax Returns - Zipcode visual.
  2. Change the fields on the shelves in the following manner:
    • Remove all the fields from the Filters shelf.
    • Remove the field Zipcode from the Geo shelf.
    • In the Data menu, enter the term "latitude" in the Search box, and then add the field Latitude to the Geo shelf.
    • Search for term "longitude", and add the field Longitude to the Geo shelf.
  3. Open the Settings menu, expand the Map menu, and select the United Sates Map View option. See Map View.
  4. Click Refresh Visual.

    The map visual appears. You can move the visual (pan), zoom in and out, and see the details in the Tooltips text.

    Map of Income Tax returns from farms, based on Lat/Long
  5. Click (pencil icon) next to the title of the visualization to edit it, and enter the new name.

  6. Change the title to Income Tax Returns - Lat and Long.
  7. At the top left corner of the Visual Designer, click Save.

    clicking to save