Results 1 to 3 of 3

Thread: [RESOLVED] How to find other zipcodes within certain miles with lat/lng?

  1. Aug 9th, 2011, 04:07 PM #1
    WarrenW
    WarrenW is offline

    Thread Starter
    Frenzied Member
    Join Date
    Oct 2000
    Posts
    1,463

    Resolved [RESOLVED] How to find other zipcodes within certain miles with lat/lng?

    Hi everyone,

    I have a zipcode database in mssql which has the zipcode, lat and long. I need to write a query in my asp.net using vb.net to show all records with a zipcode within a certain number of miles.

    I have seen calculations to show the distance between two zipcodes but I need to find the ones within say 10 miles or 25 miles.

    Has anyone done this before?

    Thanks!

    Warren
    Reply With Quote Reply With Quote
  2. Aug 9th, 2011, 04:27 PM #2
    WarrenW
    WarrenW is offline

    Thread Starter
    Frenzied Member
    Join Date
    Oct 2000
    Posts
    1,463

    Re: How to find other zipcodes within certain miles with lat/lng?

    I found the answer on a website:

    http://blogs.lessthandot.com/index.p...e-longitude-pr

    I loaded the functions in and the query with my existing table of zipcodes and it worked perfect!
    Reply With Quote Reply With Quote
  3. Aug 10th, 2011, 12:59 AM #3
    gep13
    gep13 is offline
    PowerPoster gep13's Avatar
    Join Date
    Nov 2004
    Location
    The Granite City
    Posts
    21,963

    Re: [RESOLVED] How to find other zipcodes within certain miles with lat/lng?

    Nice find! Thanks for sharing the link!

    Gary
    Remember to mark your thread as resolved. Remember to rate posts that help. Hitchhiker's Guide to Getting Help at VB Forums.

    ASP.NET Tutorials (updated Feb 1st 2009) ASP.NET FAQs (updated July 17th 2011)

    Free Stuff: WebsiteSpark|DreamSpark|BizSpark|eBooks
    Learning Resources: MSDN|LearnVisualStudio|TrainingSpot|ScottGu's Blog|ASP.Net Starter Kits|Regex|RegExLib
    Useful Tools: XPath Builder|UltraMon|RegExBuddy|CopySourceAsHtml|TracExplorer|SQLyog|Chart Controls for .Net|SharePoint Designer|CodeRush Express
    Coding Links: XPath|ConnectionStrings|VB and MySQL|MySQL Connector.Net|My.Settings
    ADO.Net: MSDN Reference|Introduction|Using Access|Always use Parameters|Save and Retrieve Data - jm|An Explanation - jm
    Code Bank Submissions: Code Snippets|Profile Provider|Serialization: C# VB|Restricted Menu|Compressed HttpWebRequest|Enumerate and Add Internet Explorer Favourites: VB C#|C# Tabbed Web Browser|Enhanced Tabbed Web Browser: VB C#

    My Blog - View my MCP Certifications
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width