Are you looking to calculate the distance between two points? Anywhere?
ZIP Code Download's Distance Wizard provides functionality for calculating the distance between two points on Earth's surface. Combined with a database of ZIP code/postal code coordinates, The distance wizard can help perform many practical tasks, such as locating nearby storefronts or presenting geo-targeted ads to visitors.
Standard Edition is faster than competitors' products and easy to use.Professional Edition boasts ultra-high performance and is bundled with smart boundary technology to greatly enhance the speed of your database queries.
For example, to find all the postal codes in North America (US, Canada, Mexico) within 10 miles of 58271 (Pembina, North Dakota, USA, located a few miles from the Canadian border), your application would query over a million rows of data and process several calculations for each row to find maybe a dozen postal codes that are within 10 miles.
The Professional Edition calculates smart boundaries and exponentially reduces the number of rows involved from millions to just dozens, making it dramatically faster. View the complete examples to see how it works with some sample data.
These tools comprise a small code library of two main parts:
- Distance Wizard - to calculate the distance between two coordinates.
- Boundary Wizard - to find geolocational boundaries of a certain radius from a coordinate of origin.(Professional Edition only)
The ZIP Code Download Distance Wizard can be utilized in 16 different languages and platforms including:
- MS SQL 2000 (or later)
- MySQL 5 (or later)
- Oracle 9 (or later)
- Visual Basic 6
- VBA (Microsoft Access and Microsoft Excel)
This documentation explains how to use the language of your choice to work with the API. It also includes usable sample source code.
There is a language filter at the top to display content for your specific platform.