Customize a map source level

A map source configures data to be displayed in a map report. You can customize existing map sources according to your needs.

Before you begin

Role required: report_admin or admin

About this task

Note: A set of predefined map sources and maps are available by default. Use these predefined objects whenever possible. If you need a map source that does not exist, generate it automatically using Generate map source levels link on the map source form, then customize it. You can automatically generate map source levels only for map sources that reference the location table. These map sources have a field that ends in .location.

Procedure

  1. Navigate to Reports > Administration > Map Sources.
  2. Open the map source whose level you want to customize, then navigate to down to the appropriate level using the Map Sources related lists.
    For example, click the level 1 map source name to reopen the Map Source form with the level 2 map source in the related list, and so on.
  3. Modify these fields as appropriate.
    Table 1. Map source fields
    Field Description
    Name Enter a name for the map source. Include the level in the names of map source levels. For example, Incident by location - level 2.
    Table The same table is used throughout a map source hierarchy, and is specified in the top-level map source.
    Field Select the field whose data you want display on the map. You can dot walk to other fields. Select a field that is one level more granular than the map you want to display the data on.

    For example, imagine you are configuring data for a level 1 map source that is displayed on the world map. Because the data for countries are displayed on the world map, select Location Country. Similarly, if you are configuring data to display on a map of Germany or the United States, select Location State / Province.

    Most map sources use a field on the Location table.

    Level Select a hierarchy level for this map source. You can have a maximum of four levels. Each map source level corresponds to a drill level on the map hierarchy, and these levels much match. Each level must exist in a hierarchy only once.
    Active Clear this check box to make this map source unavailable when creating map reports.
  4. In the Data transformation section, modify these fields as appropriate.
    Field Description
    Data Select how to use data in this map source.
    • Use data on table: Use the data in the ServiceNow platform without transforming it. Select this option when the data already matches the JSON key values that you are mapping to.
    • Use mapping: Transform that data so it matches the JSON key values that you are mapping to. For geographical map sources that use the hc-key geoJSON key, always select this option.
    • Use longitude and latitude: Use latitude and longitude coordinates to plot your data. Always select this option for the bottom map level, such as level 3. Ensure that your data has latitude and longitude values.
      Warning: Because the Use longitude and latitude option disables heatmap and drilling for maps using this map source, select this option only on map source levels that are the bottom level in a hierarchy.
    Use these mappings If you selected Use mapping, select a mapping group to use. A mapping group is a collection of key-value pair mappings that transform data. To review the mappings in a mapping group, go to the Locations Mappings [sys_report_map_source_mapping] table.

    For example, if you are transforming field value USA to hc-key value us, select Country mappings, which contains the relevant key-value pair mapping.

  5. In the JSON key section, select a JSON key to connect the map source data to maps.
    Geographical maps typically use hc-key.

    Every report map has a JSON definition. Select one JSON key-value pair to map the data to. The data to appear on the map must match the JSON key values. So the key that you select determines whether you must transform your data with the settings in the How to use data section. All default platform maps and mappings use the geoJSON hc-key and ISO 3166 standard values. For custom maps, you can enter a different JSON key.

  6. Click Update.