10.4.4 Adding a Map Region in Page Designer

Manually create a map regioin in Page Designer by providing the SQL query.

Adding a map in Page Designer supports spatial geometry objects (or layers) based on a local table, SQL query, REST Enabled SQL Service, or REST Data Sources.

1. View the page in Page Designer:
   1. On the Workspace home page, click the App Builder icon.
   2. Select an application.
   3. Select a page.
   Page Designer appears.
2. If necessary, click the Layout tab in the central pane.
3. In the Gallery, click the Regions tab.
4. Right-click Maps, click Add To, and select the appropriate location.

   Tip:

   You also select Map with the mouse and drag it to the appropriate location in the Layout tab.

5. Page Designer indicates what to do next. If there is an error, the Show Messages icon displays in the Page Developer toolbar.
   1. Click the Show Messages icon on the Page Designer toolbar.
      The Messages dialog displays errors that must be addressed.
   2. Select an error to highlight the associated attribute in the Property Editor.
6. In the Property Editor, edit the appropriate Layer attributes:

   1. In Rendering tab (left pane), select the New layer.

   2. Identification, Name - Enter a descriptive name for this layer.

   3. Identification, Layer Type - Select the spatial geometry layer type. Options include:

      • Points - Points (for example, customer or supplier locations) are display as markers. The marker shape and color is configurable.

      • Lines - Lines represent features such as roads or paths. The stroke style and color is configurable.

      • Polygons - Polygons represent areas like parcels, states, or countries. The style and color are configurable for stroke and fill.

      • Heat Map - Heat Maps are used to visualize the point density. The more points that are clustered together, the more intense the color becomes. Use this option to visualize the spatial distribution of population or incidents.

      • Extruded Polygons - Display as three-dimensional, extruded, objects. The height of the 3D object visualizes a column value.

7. Source - Idenfity the source of the map:

   1. Source, Location - Select the location of the data: Options include:

      • Local Database - Data is sourced from the local database.

      • REST Enabled SQL Service - Data is sourced from a remote database, where the connection is defined using REST Enabled SQL. To create or maintain REST Enabled SQL references, navigate to Shared Components, REST Enabled SQL.

      • REST Source - Data is sourced from a RESTful web service defined using REST Data Sources. To create or maintain REST Data Sources, navigate to Shared Components, REST Data Sources.

      • Region Source - Data is sourced from the location specified in the region source definition.

      What displays next depends upon the Source, Location you select. This task assumes the Source, Location is Local Database.

   2. Source, Type - Select how the data is queried. Options include:

      • Table/View - The data is retrievedbased on a table or view.

      • SQL Query - The data is retrieved based on a SQL Query.

      • Function Body returning SQL Query - The data is retrieved based on the SQL Query returned by executing a Function Body.

8. Column Mapping - Identify how and where spatial objects are sourced:

   • Geometry Column Data Type - Identify the data type of the geometry column. Options include:

     • SDO_GEOMETRY - Oracle SDO_GEOMETRY type.

       Local databases and REST Data Sources support the SDO_GEOMETRY column type. However, REST Enabled SQL data sources do not support the SDO_GEOMETRY column type.

     • GeoJSON - GeoJSON, as VARCHAR2 or CLOB types.

     • Longitude/Latitude - Longitude and Latitude, as two NUMBER columns.

     What appears next depends upcn the Geometry Column Data Type you select. Select the appropriate columns.

   • Primary Key Column - Choose the column containing the unique key to identify a row. Use this to provide the primary key value to custom JavaScript code or map event handlers.

9. Click Save.
10. Click Save and Run Page to view the map