Report Map (Google Maps) APEX Plugin APEX 5.0 APEX 18.2

A region plugin for Oracle Application Express

Leverage the power of Google Maps in your APEX application. This plugin allows you to add one or more Google Map regions to any page, showing a number of markers (pins) retrieved from a query or other data source you specify.

The plugin provides a rich array of built-in declarative features, dynamic actions and associated API routines, and gives access to the underlying Google Maps object so you can customise it with any other behaviour you need.

plugin-reportmap-markers.png

The user can click any marker to see a popup info window for it.

Visualisation: Marker Clustering

plugin-reportmap-clustering.png

If many pins are too close together, Marker Clustering merges them into a single cluster; the number indicates how many pins are at that location. As the user zooms in or out, the clusters will split up or merge as needed.

Visualisation: Heatmap

plugin-reportmap-heatmap.png

This is suitable for a large volume of data points. Each data point can have a “weight” which indicates the magnitude of some measure.

Visualisation: Directions

plugin-reportmap-route.png

Up to 10 points (origin, destination, plus up to 8 waypoints) may be supplied to derive a route. Google Maps can generate a route for Driving, Walking, Bicycling, or Transit (public transport). The plugin can also get the calculated total Distance and Time for the route.

DEMO

https://apex.oracle.com/pls/apex/f?p=JK64_REPORT_MAP&c=JK64

PRE-REQUISITES

INSTALLATION INSTRUCTIONS

NOTE: if you are upgrading to Release 1.0 from any prior version, some changes will be required to your application to support it as a number of attributes have been removed or changed.

  1. Download the latest release

  2. Install the plugin to your application - choose your version from the list below:
    • If you are on APEX 18.2 or later: region_type_plugin_com_jk64_report_google_map_r1.sql
    • If you are on APEX 5.0.3 to 18.1: backport/region_type_plugin_com_jk64_report_google_map_r1_503.sql
  3. Supply your public Google API Key (Component Settings)

  4. Add a region to the page, select type JK64 Report Google Map R1 [Plug-In]

  5. For SQL Source, enter a query with at least 4 columns, for example:

    SELECT lat, lng, name, id FROM mydata
    

IF YOU ARE UPGRADING from an earlier release, refer to the Upgrade Notes.

SUPPORT