Expert Oracle Application Express

August 13, 2015 at 9:53 am | Posted in Oracle Developement | 2 Comments

I guess I’m a published author now. 🙂


Today the new edition of Expert Oracle Application Express was released. My contribution is chapter 12: Map Integration, where I show how to integrate maps, such as Google, or Leaflet maps into an APEX application. Here is the introduction from the book:

Any database application that contains location data, such as addresses or geographic coordinates, may benefit from displaying this data on a map. It may be of further benefit, to allow users to interact with this data by associating it with other data, or even perform geometric calculations against it.

In this chapter we will explore some options to free the geographic data from its confines of the database tables, and render it in useful ways on interactive maps. To accomplish this we will look at a number of tools and techniques available to us in APEX, the Oracle database, and some publicly available APIs.

We will learn how to turn address data into geographic coordinates and how to use these coordinates to display addresses on a map. Further we will take a look at various mapping APIs, and how to use Oracle’s powerful spatial features to find relationships between geographic data points.

You can get the book from Amazon. If you do, please don’t forget to leave a comment.



RSS feed for comments on this post. TrackBack URI

  1. Haha, I emailed you this morning for a suggestion for a good Apex book…

  2. I am referencing your example in Ch12 using leaflet, I have tried all the versions but using apex 5.1 any ideas.
    Leaflet 1.0.3 Stable version, released on January 23, 2017.
    Leaflet 1.1-dev In-progress version, developed on the master branch.
    Leaflet 0.7.7 Legacy version, released on November 18, 2013 and last updated on October 26, 2015.
    Whick specific version did you use and do you have a sample app I can download.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Entries and comments feeds.

%d bloggers like this: