1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Search by radius/distance of zip code

Discussion in 'Databases' started by tester1, Mar 16, 2007.

  1. #1
    I am having someone code a site for me and one of the features is that the end-user will be able to search for flower shops based upon zip code and distance (from that zip code) they input.

    How do you recommend I choose a reliable and accurate and updated zip code database?

    I see many zip code databases available for sale but don't know which one is the best.

    Thank you.
     
    tester1, Mar 16, 2007 IP
  2. JoshuaGross

    JoshuaGross Peon

    Messages:
    411
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    0
    #2
    After you find your own zip code DB, I would look into Google Maps and/or Yahoo Maps geocoding API. That provides latitude and longitude for requested zip codes as well. Then it's just a matter of finding an algorithm for calculating distance (miles/kilometers) based on lat/long coordinates, but I've seen code around.
     
    JoshuaGross, Mar 16, 2007 IP
  3. JoshuaGross

    JoshuaGross Peon

    Messages:
    411
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Maybe this was implied, but you might also want to forego the use of a server-side zip code database since Google and Yahoo are so thorough. The only problem is if you need to do more complex things with the zip codes, like finding zip codes within a certain distance of given lat/long coordinates...
     
    JoshuaGross, Mar 16, 2007 IP
  4. tester1

    tester1 Peon

    Messages:
    183
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Yes, I would like to use the zip code database to perform distance/radius searches from zip codes.

    How do I find a reputable and reliable database?
     
    tester1, Mar 16, 2007 IP
  5. Lavee

    Lavee Well-Known Member

    Messages:
    234
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    108
    #5
    I can give you a script and db table for latitude and longitude ( a complete set for $20) and all you need is include vthe file and call the function to find

    1. Distance between two zip codes you provide

    2. Find available zipcodes within specific miles from yr zipcode

    Let me know

    Thanks

    Lavee
     
    Lavee, Mar 18, 2007 IP
  6. tester1

    tester1 Peon

    Messages:
    183
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #6
    I need to find a up-to-date zip code database (with latitude and longitude).
     
    tester1, Mar 20, 2007 IP
  7. Lavee

    Lavee Well-Known Member

    Messages:
    234
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    108
    #7
    The $20 includes the database

    Thanks

    Lavee
     
    Lavee, Mar 21, 2007 IP