Cloudera Docs

Specifying geographic fields

In CDP Data Visualization, you can explicitly specify a dataset field as one of the many supported geographical types.

In this example we use the dataset Canadian Census, constructed from example datasets. , and joined of the fields fsa and Postal Code, respectively.

The following steps demonstrate how to assign Geo Types to a dataset field. We are using the two fields from the join of the Canadian Census dataset: fsa from canada_census_population_dwellings, and Postal Code from ca_postal_codes.

  1. Navigate to the dataset that you must modify. In this example, we are using the Canadian Census dataset.
  2. In the Dataset Detail menu, select Fields.
  3. In the Fields interface, select Edit Fields.
    Editing Fields of Dataset 'Canadian Census'
  4. To specify that the field is a Geo Type, In Edit mode, click the (down) icon on the right side of the field, and select the Edit Fields option.
    Changing the field Fsa
  5. In the Edit Field Parameters window modal, under Geo Type, select the appropriate option from the menu, and click Apply. For Fsa, we also changed the Display Name to Postal Code in the example.
    Changing the field Fsa
  6. Repeat for the Postal Code field of the table ca_postal_codes, and click Apply.
  7. Repeat with the Province field of the table ca_postal_codes, changing the Geo Type to State/Province. Click Apply.
  8. [Optional] Apply the Geo type to the fields that represent Latitude and Longitude, if they are not named appropriately.
  9. Under Dataset: Canadian Census, click Save.

The dataset can now be successfully used for map and interactive map visuals, without further adjustments at the level of the visual.