Previous Next JavaScript must be enabled to correctly display this content

## 10.4.4 Adding a Map Region in Page Designer

Manually create a map region 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 can 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. Source - Identify the source of the map:

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

      - Local Database - Data is sourced from a local database.

      - REST Enabled SQL - 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 Databases.

      - 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.

      - Duality View - Data is sourced from a Duality View Source defined using Duality Views within Shared Components.

      - JSON Source - Data is sourced from a JSON Source defined using JSON Sources within Shared Components. JSON Sources include tables with JSON columns or JSON Collection Tables.

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

      - Sample Data - Data is sourced from a built-in sample data set.

      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 retrieve based 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.

   What displays next depends upon the Source, Type you select.

7. 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 upon 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.

8. 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.

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

Parent topic: Creating Maps