Report Google Map 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.
DEMO
https://apex.oracle.com/pls/apex/f?p=JK64_REPORT_MAP
INSTALLATION INSTRUCTIONS
- Download the latest release
- Install the plugin to your application - region_type_plugin_com_jk64_report_google_map.sql
- (optional) Supply your Google API Key (NOTE: the plugin is usable without one)
- Add a region to the page, select type JK64 Report Google Map [Plug-In]
- For SQL Source, enter a query with at least 5 columns (see example below)
Sample query
SELECT lat, lng, name, id, info FROM mydata
For more info including version history and plugin references, refer to the WIKI.