Databases
StackOverflow2013
Postsdbo
POHow to prepare existing database for location aware searching?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to prepare existing database for location aware searching?
    primarykey
    data
    text
    <p><strong>Requirement</strong> : I am currently working on an app that has over 30000 records. The requirement is to have <strong>location based/aware searching</strong>. For eg. within 5mi from my present location. </p> <p><strong>How will this service be accessed</strong> : This service will be accessed from both web and iOS app. </p> <p><strong>Development platforms</strong> : </p> <ul> <li>Web : Cakephp, php and python</li> <li>DB : MySql</li> <li>iOS : objective-c</li> <li>External libraries currently being used : Google Maps Javascript Api v3</li> </ul> <p><strong>Location based searching</strong></p> <p>I have been doing some research on this subject, and I will be employing <a href="http://en.wikipedia.org/wiki/Haversine_formula" rel="nofollow noreferrer">Haversine Formula</a> for this. But for Haversine formula to be effective, I need to have reverse geo code for all my records in my DB. The only reverse geocoding service I have ever used is from Google, and I know for a fact that they don't allow this without displaying the results on their map.</p> <blockquote> <p>Note: the Geocoding API may only be used in conjunction with a Google map; geocoding results without displaying them on a map is prohibited.</p> </blockquote> <ol> <li>Are there other APIs or services I can use to reverse geo code all those records ?</li> <li>30000 is a large number. I will obviously be employing cron job for this over a period of time, but as this request will be from same IP, can this be an issue ?</li> </ol> <p>Any help on this will be highly appreciated.</p> <p><strong>Update 1 #</strong></p> <p>I found <a href="https://stackoverflow.com/questions/2283689/can-anyone-recommend-a-free-geocoding-service">this SO question</a> which recommends <a href="http://wiki.openstreetmap.org/wiki/Nominatim" rel="nofollow noreferrer">OpenStreetMap Nominatim</a></p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USKishor Kundan
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to prepare existing database for location aware searching?
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload