A Region plugin for Oracle Application Express
This allows you to add a Google Map region to any page, showing a number of markers (pins) based on a query you specify.
The user can click any marker to see a popup info window for it. You can have the region synchronize the map with an item you nominate - if so, the corresponding ID for the marker they click will be copied to the item.
Warning: if you are upgrading from v0.9.1 or earlier, make sure to review the Release Notes first.
https://apex.oracle.com/pls/apex/f?p=JK64_REPORT_MAP&c=JK64
- Oracle Application Express 5.0.4 or later
- You need a Google Maps API Key
- Download the latest release
- Install the plugin to your application - region_type_plugin_com_jk64_report_google_map.sql
- Supply your Google API Key (Component Settings)
- Add a region to the page, select type JK64 Report Google Map [Plug-In]
- For SQL Source, enter a query with at least 4 columns (see example below)
- Update the Number of Rows to a reasonable upper limit (default is 15, you probably want a higher limit)
Sample query
SELECT lat, lng, name, id FROM mydataFor more info including sample queries, plugin attributes and triggers, refer to the WIKI.