Mander
Reputation: 9
Search by zipcode and show data within specific radius?
Hi I have a database of the US, CANADA zipcodes with latitude and longitude. I would like to implement search to show listings within specified radius. How can it be done with Linq to Entity, C#
Thank you for examples
Upvotes: 0
Views: 2511
Answers (1)
Martin Buberl
Reputation: 47114
This CodeProject article describes a method to calculate the distance between two zip codes and find all other zip codes within a radius of X miles of a specified zip code:
In the article is an Access database used but what you're going to use as your ORM and database isn't really the tricky thing here.
Upvotes: 2
Related Questions
- How to search by radius based on latitude and longitude?
- Find all nearby customers within a given distance using longitude and latitude
- How do I find 10 elements by longitude and latitude in 1 km radius using LINQ?
- How do I use spatials to search a radius of zip codes?
- Return results depending on radius latitude and longitude
- What is the best way to query a database for records within n miles of a zip code?
- Search by zip code and filter list within specific radius?
- Using Linq to Sql to find ZipCodes within Radius distance
- How To Return All Instances Within ## Mile Radius of a List of Zipcodes
- Determine if the zip code within the required radius