× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Like  

Map Customization

This section contains the different customization options for Filled and Symbol maps. 
 

Assign a Geographical Role 

City, State/Province, and/or Country

Visual Analytics automatically assigns geographic roles (city, state/province, and country) to string dimensions with common geographical names such as City, State/Province and Country. You can also manually assign a geographical role to a string dimension that contains geographical data.
 
To assign a geographical role to a dimension
  • In the Dimensions pane, right-click the dimension > Geographical Role > click the desired role. The  string changes to  icon.

Longitude and/or Latitude

Visual Analytics automatically assigns geographic roles (Latitude and Longitude) to number fields (whether dimension or measure) with common geographical names such as; Longitude and Latitude. You can also assign geographical roles to any number field by right-clicking on the measure and clicking a Geographical Role option. Visual Analytics changes the measure to continuous dimension. The  string changes to  icon.

Latitude and Longitude support is only applicable to Symbol Map.

Change Country Codes

Visual Analytics supports identifying country locations by using a two-character code based on the Federal Information Processing Standard (FIPS) or a two-letter code (alpha-2) or a three-letter code (alpha-3) country codes on the International Standards Organization (ISO). 
By default, when Visual Analytics finds a country value that is 2 characters in length, it attempts to match the value using ISO alpha-2 country codes. If your dataset contains FIPS codes, you should change the 2-char code selection of Country geographic role to FIPS.
 
Country Name  ISO alpha-2 ISO alpha-3 FIPS
AUSTRIA AT AUT AU
AUSTRALIA AU  AUS AS
CANADA CA  CAN CA
INDIA IN IND IN
GERMANY  DE DEU GM
To change the country code if your dataset contains a different code
  1. Right-click Country > Geographical Role > Country.
  2. Click the 2-char code type.

Edit Locations

Sometimes, Visual Analytics cannot recognize locations in your geographical data and displays them as unrecognized or ambiguous. The following table contains the description for unrecognized and ambiguous locations. 
 
Location Description
Unrecognized
Visual Analytics does not recognize state or city names when:
  • State or city names are different than the officially recognized names. When this happens, you can correct your source dataset.
  • Incorrect combination of country, state, or city in the dataset. For example, United Kingdom as the country and San Francisco as the city in United Kingdom.
Ambiguous
Visual Analytics finds ambiguity in state or city names when your geographical data contains:
  • Multiple occurrences of state or city name across the world. 
  • Multiple occurrences of state or city name for the plotted country.
For example, Sydney is present in Australia and Canada. When Visual Analytics plots cities, it considers Sydney ambiguous if a country or a state is not specified.
 

Visual Analytics disables the Edit Locations option when building a symbol map chart with Latitude and Longitude geographical dimensions. 

Resolve Ambiguous Locations

To resolve ambiguous locations

  1. Download and connect to the sample data source in Aqua Data Studio.
  2. Build a Filled Map chart.
  3. On the Visual Analytics menu bar, click Analysis > Map > Edit Locations.

    Visual Analytics listed Florida, Maryland, Montana as ambiguous/unknown locations because the country role is not specified. When country is not specified, Visual Analytics searches geographical data against a worldwide dataset and displays these states as ambiguous because similar state names are present in other countries.

  4. In the Country list, click Fixed, and then from the adjoining list, select United States.
  5. Click OK. As you have restricted Visual Analytics to search only in the United States, it identifies and plots these states correctly on the map of United States.

Show/Hide Borders

Visual Analytics gives you the control to show state borders for the country whose data is plotted. The borders add clarity between different states of the plotted country. By default, the state borders appear for the plotted data.
 
To show/hide borders
 
  • For Filled Map, in the Chart Properties Deck, click Options.
  • For Symbol Map, in the Chart Properties Deck, click Geo.

Other Actions

Other actions that you can perform on a plotted map are as follows:
  • You can sort data by using various sort options available in the chart view or the Advanced dialog. For more information, see Sorting.
  • You can use highlight actions to focus on selected part of the map. Visual Analytics makes the highlighted selection and its data labels prominent while dimming others in the view. For more information, see Highlight Actions.
  • You can filter records directly from the chart view without manually adding any fields to the Filters Deck. For more information, see Filters.
  • You can export worksheets containing visualization to Image, HTML, and PDF formats. For more information, see Export Visualizations.  
Last updated by nhilam on Jun 1, 2020 6:04 PM
This list is empty.

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017