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
www.amazon.com...
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
----------------------------------------------
tinyurl.com/z7...
The Map Series
-------------------------
PART-I
-----------
• Oracle APEX Maps Tutor...
PART-II
------------
• Oracle APEX Maps Tutor...
PART-III
------------
• Oracle APEX Tutorial -...
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
======================
The background map is static and comes from Oracle Elocation Service. These background maps are ready to use and do not require any API keys. However, in order to display the background map, the end user's browser must have an internet connection and access to maps.oracle.com.
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.

[@asifiqbal5877]

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

[@TechMining69]

Thank you!

[@monusinghrawat7490]

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

[@TechMining69]

Thank You!

[@edwinyulianto3660]

Well done. Waiting for part 2

[@TechMining69]

Very soon.

[@fabiofafa9026]

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.

[@TechMining69]

It's new to Oracle APEX 21. Try out the free online APEX version.

[@TechMining69]

It's new to Oracle APEX 21. Try out the free online APEX version which is the latest one.

[@sarimmuavia]

👍

[@TechMining69]

Thank you SM!