A Region plugin for Oracle Application Express
This allows you to add a Google Map region to any page, showing a heatmap based on a query you specify.
- Download the latest release
- Install the plugin to your application - region_type_plugin_com_jk64_heatmap.sql
- Supply your Google API Key (Component Settings)
- Add a region to the page, select type GeoHeatmap [Plug-In]
- For SQL Source, enter a query with 3 columns (see example below)
- Update the Number of Rows to a reasonable upper limit (default is 15, you probably want a much bigger number)
select lat, lng, weight from mydata
If you don't have any "weight" to go with the data points (e.g. population, earthquake magnitude, sales volume), just set the third column to
select lat, lng, 1 from mydata.
For more info, refer to the WIKI.