C3 AI Documentation Home

Geospatial

Use the Geospatial node in Visual Notebooks to create a location map for latitude and longitude coordinates in your dataset.

Data Configuration

FieldDescription
Latitude default=noneLatitude column Select a latitude column from the dataset.
Longitude default=noneLongitude column Select a longitude column from the dataset.
Marker Color Based On default=noneColumn for marker color The marker color is a gradient by values in a column. Select a column for the application of the gradient.
Label Content default=noneMarker label content Select columns to include in marker labels.
Group by default=noneSelect grouping An optional grouping of the data.
Sources default=noneSource selection Select columns to include or remove from the chart. The field is populated with the labels from the Group by column when a group by column is selected.
Limit default=100Limit selection An option to limit the data included in the location map by the first data that appears in the dataset.

Settings

FieldDescription
Chart Title default=noneField to name the chart An optional user-specified chart title.
X-Axis Title default=noneTitle for the x-axis Select a title for the x-axis. This option appears if a Group By selection is made in Data Configuration.
Y-Axis Title default=noneTitle for the y-axis Select a title for the y-axis. This option appears if a Group By selection is made in Data Configuration.
Secondary Y-Axis Title default=noneSecondary title for the y-axis Select a secondary title (subtitle) for the y-axis. This option appears if a Group By selection is made in Data Configuration.
Show Markers default=offOption to show/hide markers Toggle on to show the markers, or leave off (default) to hide the markers.

Node Inputs/Outputs

InputA Visual Notebooks dataframe
OutputA geospatial map

Example geospatial map output

Figure 1: Example geospatial map output

Examples

To explore the Geospatial node visualization, we use a dataset that contains information about volcanos. Note that this node requires latitude and longitude information. Columns in this dataset include name, location, country, latitude, longitude, elevation, year, month, day, type, and status. There are also columns with the number of deaths, injuries, missing people, amount of damage, and houses destroyed.

Example input dataset

Figure 2: Example input dataset

  1. Connect a Geospatial node to an existing node. In this case, it is connected to the Volcanos CSV file.
  2. Select the Latitude (Double) and Longitude (Double) columns for the Latitude and Longitude fields.
  3. Optionally, select the Settings tab and enter a chart title. Figure 3 shows Volcano Locations.
  4. Select Apply.

Notice that Figure 3 shows the chart title in the top margin, and shows markers for every latitude and longitude location.

Example basic geospatial map

Figure 3: Example basic geospatial map

Optionally, we can show other details.

  1. Select a column for the marker color. This associates the marker color with a value, which shows the markers in gradient associated with those values.
  2. Select Apply.

Figure 4a has Elevation (Integer) selected and Figure 4b has Year (Integer) selected for comparison. Notice the difference in the marker colors.

Example markers by elevation

Figure 4a: Example markers by elevation

Example markers by year

Figure 4b: Example markers by year

Another option to try is to add label content.

  1. In the Label Content field, select these columns:
  • Year (Integer)
  • Name (String)
  • Country (String)
  • Elevation (Integer)
  • Type (String)
  • Status (String)

Notice that in Figure 5, when selecting a marker, a label shows the selected columns.

Example of labels for markers

Figure 5: Example of labels for markers

The next option to try is Group by.

  1. Select a column to group by in the Group by field. In Figure 6, we have selected TOTAL_DAMAGE_MILLIONS_DOLLARS (String).
  2. When selecting a group by column, you are prompted to also select sources. In this case, all sources have been selected: Low, Medium, and High. Selecting or not selecting sources offers a way to filter the data in the group.
  3. Select Apply.

Notice that Figure 6 has zoomed in on a part of the map where the group by columns and source filters apply.

Note: The Group by field can also be used to filter sources. In terms of the selections made in Figure 6, if Low is removed from the source, only Medium and High appear in the diagram. For another example, instead of grouping by TOTAL_DAMAGE_MILLIONS_DOLLARS (String), if grouping by Country (String), specific countries can be selected for the group instead of selecting all.

Example of group by and sources

Figure 6: Example of group by and sources

The last option we explore is the Limit configuration field.

  1. Remove the Group By and Sources field entries by selecting the "X" in the Group By field.
  2. Change the Limit field from 100 to 15.
  3. Select Apply.

Notice that only the first fifteen rows from the Volcano CSV dataset appears on the geospatial map.

Example of limit

Figure 7: Example of limit

Was this page helpful?