Administration: Omnidex Features

Geographic Searches

Overview | Latitude and Longitude | Radius Distance Searches | Indexing | Optimization

Optimizing Geographic Searches

Geographic searches are specified using a $DISTANCE function. As long as there is a multi-column Omnidex index containing the latitude and longitude, the $distance function will be automatically optimized.

Examples

The following are examples of several types of geographic searches that can be optimized using the $distance function.

Example 1: Distance between two sets of coordinates

select      $distance(40.0, -105.0, 41.0, -106.0) distance
  from      $omnidex;

Example 2: Distance between two sets of coordinates using columns

select      zip,
            $distance(40.0, -105.0, latitude, longitude) distance, 
            latitude, longitude,
  from      zipcodes
 where      $distance(40.0, -105.0, latitude, longitude) < 10;

Example 3: Distance between an origin and multiple sets of destination coordinates

select      state, zip, latitude, longitude
   from      zipcodes
  where      $distance(latitude, longitude,
                       (select      latitude, longitude
                          from      zipcodes
                         where      state = 'CO')) < 5;

Prev