> And I think that might work for you. The performance is going to be
> miserable for large stat sets, because it's going to scan the whole
> aaafacilities table every time and recompute every distance, but as an
> example goes it's probably acceptable.
Something I did when implementing haversine in Oracle was first
calculate a bounding box for lat/lon and only calculate the distance for
cities w/in the bounding box.
Scott