Closed

MySQL Proximity Search Query

This project received 9 bids from talented freelancers with an average bid price of $172 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $250 USD
Total Bids
9
Project Description

I need someone to build me a mysql query for sorting items by proximity.

I have table A with thousands of entries, they each have a zipcode field. I need to be able to retrieve lets say, 500mile radius from a user input of their zipcode, these listings must be ordered by lowest distance. There is also another table which stores zipcode information, city, state, latitude, longitude, and the zipcode. Also, this needs to be very robust. I'm interested doing this with Spatial Extension for MySQL, or Sphinx-mysql geolocation. If you want me to pick you, please tell me which way is a better approach to handle a lot of data while keeping resources at minimum. I would ultimately like to see this done with Shinx Geolocation, but PM me with your ideas. I won't pick you if you can't tell me which way works best.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online