System and method for geo-location data type searching in an on demand environment

摘要

Methods and systems are provided for retrieving, from a database containing a list of records, a subset of the list of records located within a user defined distance from a target point, each record in the list of records having a compound geo-location data type including a first data field and a second data field. The method involves generating a circle around the target point; identifying records having a geo-location within the circle; including the identified records in a result set; and presenting the result set to a user on a display screen. The method further includes treating the first data field and the second data field as a single data element.

主权项

1. A method of retrieving, from a database containing a list of records, a result set of the list of records located within a user defined distance from a target point, each record in the list of records having a compound geo-location data type including a first data field and a second data field, the first and second data fields comprising latitude and longitude, the method comprising:
generating a circle around the target point with a radius corresponding to the user defined distance; identifying a subset of the list of records having a geo-location within the circle, wherein identifying the subset comprises:
determining the coordinates of a first square comprising the smallest dimensions which contain the circle;identifying the records outside the first square; andfiltering out any records outside the first square from the result set; including the identified records in a result set; and presenting the result set to a user on a display screen;
wherein identifying comprises treating the first data field and the second data field as a single data element.