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.