Written on 21 April 2011, 12:11pm
Recently I had to implement a ColdFusion + Oracle application using Google Maps. One of the requirements was search by distance (or radius search) for some items, already geocoded.
The items are stored in
T_ITEM, with the columns:
The latitude and longitude are already calculated, and stored in database as VARCHAR.
The task was to create some sort of function to accept:
and to return the items from
T_ITEM located within
radius kilometers from the given coordinates.
In implementing this task, I started with (more…)