Oracle APEX Maps Tutorial - Part I

Oracle APEX Book
===============
Create Rapid Low-Code Web Applications in Oracle APEX 21.2: A platform to develop stunning, scalable data-centric web apps fast

This video will teach how to integrate the new Points and Polygons Maps in your Oracle APEX applications.

In this video you'll learn:
--------------------------------------
- Visualize geographical data using Maps
- Load JSON data using a database procedure
- Create multiple layers in a single map
- Add custom tooltip via HTML Expression
- Using WHERE clause property to filter data on maps
- Visualize data using Geometry Column (SDO_GEOMETRY) and Two Numeric Columns (Latitude and Longitude)

Code for this video tutorial
----------------------------------------------

The Map Series
-------------------------

PART-I
-----------

PART-II
------------

PART-III
------------

SEE TRANSLATION IN YOUR NATIVE LANGUAGE
=======================================
1. Click the Closed Caption icon (CC) under the video to turn it on. The turned on CC has a red underline.
2. Click the Settings icon beside the CC icon, and click the Subtitle/CC option.
3. Select the Auto-translate option and then select the language of your choice.

The map component consists of a background map and spatial geometry objects sourced from data in a table or from a REST Data Source.

About the Background Map
======================

About Spatial Geometry Objects
==========================
Spatial geometry objects are drawn on the background map based on data in a table. That table can be sourced from local table or a SQL query. Maps created using the Create Page Wizard or in Page Designer, support both local database tables, REST Enabled SQL, and from REST Data Sources. Maps support a rich set of built-in marker icons and shapes. Supported spatial geometry objects include:

- Points: Points (for example, customer or supplier locations) display as markers.

- Lines: Lines represent features like roads or paths.

- Polygons: Polygons represent areas like parcels, states or countries.

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

You can source spatial geometry objects from either:

- Geometry Column: Supported datatypes include SDO_GEOMETRY, VARCHAR2, or CLOB. VARCHAR2 and CLOB columns must contain geometry information in GeoJSON format.

- Two Numeric Columns: These columns must contain longitude and latitude values. This option only applies to Point and Heat Map objects.

[monusinghrawat]

There is so many impressive and easy to learn subject's and lot's of things .
That's why it is 2nd time when i m giving my feedback as comment .
Great job Sir

[edwinlitzau]

Great tutorial! But there seems to be a problem with your .json file, missing at least a few brackets.

[asifiqbal]

Learned new feature of oracle apex this video on Oracle Apex maps. Thank you Tech Mining.

[fabiofafa]

Sorry but i can't find "Create Page / Add Map Page" in the menu, but i can find "Add Chart Page", i'm using Oracle Apex 20.02.