Re: Separate Address Table, Latitude, Longitude
Posted by: Rick James
Date: March 02, 2012 11:57PM

Forget about users and RetailOutlets for now. Focus just on the proximity query; it will be the tough part. The rest will be trivial in comparison.

So,...
Think about a single table with
id -- for JOINing to users, etc (ignore the details for now)
latitude
longitude

Given one id, how can you find the other nearby ids?

Options: ReplyQuote


Subject
Written By
Posted
Re: Separate Address Table, Latitude, Longitude
March 02, 2012 11:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.