15.1 Geocoding with User Confirmation

Use a Geocoded Address page item to show a location and get coordinates for a user-entered address.

It appears as a map on the page, and works with one or more address-related text items for data entry. If the user changes the address, they must confirm it from a list of likely matches when they submit the page. Under the covers, the address they select includes the latitude and longitude coordinates. The Geocoded Address item automatically matches addresses and coordinates using an Oracle-managed service.

Tip:

Your application's use of the Oracle eLocation service requires no additional setup or cost.

• Producing GeoJSON from Coordinates
  The Geocoded Address page item works with GeoJSON, the web standard format for mapping information.
• Avoiding SQL Expression Update Error
  When you include a SQL Expression column like GEO_JSON_POINT, remember to also enable the Query Only switch on it in the Property Editor.
• Identifying Address Text Fields
  Associate a Geocoded Address page item with one or more related fields that display the address as text.
• Confirming an Address Interactively
  Follow the user experience for entering or editing a geocoded address.
• Extracting Coordinates for Storage
  To extract the geocoded address's longitude and latitude into page items, define a dynamic action event handler on the Result Selection [Geocoded Address] event.
• Unprotecting Client-Set Hidden Items
  Disable Value Protected when client-side logic sets a hidden page item's value.
• Exploring Additional Page Features
  Explore several page techniques used by the Geocoded Address example.