Blog posts tagged with 'zip code'

RSS
ZIP Code Download's Distance Wizard- Monday, July 14, 2014

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:

  1. Distance Wizard - to calculate the distance between two coordinates.
  2. 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:

  • ASP
  • C
  • C#
  • C++
  • ColdFusion
  • Java
  • MS SQL 2000 (or later)
  • MySQL 5 (or later)
  • Oracle 9 (or later)
  • Perl
  • PHP
  • Python
  • Ruby
  • VB.NET
  • 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.

Tags :  zip codedistance wizard
Comments (1)
What is a store locator?- Wednesday, April 9, 2014

Often whenever you read certain advertisements or catalogues, it will tell you that some items must be bought in store. They then tell you to see out your nearest local outlet to speak to their staff in person. However, it is often the case that people do not know where their local store is for particular goods. It is often recommended that the customer use an online store locator. This is a function with allows the customer to enter their address details into a database, and it queries the location of stores in relation to the address that is closest to the customer.

These are typically discovered on the websites of businesses who have multiple premises. This allows the visitor to locate the specific locations of their stores on a map. This type of system is very popular with chain stores, hotels and food outlets.

In addition to simply bringing up the geographical position of the store on a map, it will also produce useful contact information such as their address, postal code, open hours, phone number and for the particularly good example, software which shows you the directions to the store from your location.
Sometimes the search can be refined according to specialized criteria. For example you can input into your store locator that you only want stores that open during lunch hour. The search tool will them emit all results which do not conform with your criteria. The result is, you find the position of the store which is exactly what you are looking for.

This type of software typically makes use of the ZIP code data. This is a database which stores all of the ZIP codes in a given area into a list. The store locator has access to such a resource and it discriminates its results based on it.

Another popular method is to use the IP address of the device which is used to access the service. This give a position relating to your real time position, not just to the area defined by your postal code. This can be especially useful if you find yourself in an unfamiliar area.
So there you have it - that is a store locator.

Tags :  zip codestore locator
Comments (0)
Three and Four Digit ZIP Codes Appearing in Database- Friday, May 18, 2012
Three and Four Digit ZIP Codes

Many customers wonder why their data is including three and four digit ZIP codes. Of course, the United States Postal Service does not manufacture cities with only three and four digit ZIP codes. Most customers experience these because they are opening the data up with a program, such as Microsoft Excel, which has a default setting to eliminate zeros preceding a number. For instance, Holtsville, New York has a ZIP code of 00501. Excel will take that file, remove the zeros preceding the “5” and give you “501.”

Remedies

There are three main ways to remedy this issue:
  1. Instead of downloading the .CSV version of the file from ZipCodeDownload.com, download the “Excel (97 or later)” version. This has been preformatted to accept leading zeros.
  2. If you download the .CSV file, format the column by selecting the column and right clicking it selecting Format Cells> Number> Special> “Zip Code.”
  3. Follow the same steps in way number two but instead do …> Number> Custom> and under Type enter “00000”.

Either of these three ways are acceptable, however, we strongly recommend that you download the file type specific to the program that you will use.
Comments (0)
‘Mr Zip’ and the Zip Code Database- Tuesday, March 6, 2012

Drowning in mail and looking for a solution, over seventy years ago the USPS discovered and implemented a system to improve tracking. They started demanding a two-digit number between city and state on the address line of letters and parcels, which was a short-term fix; but the quantity of mail continued expanding. Five-digit codes were introduced within twenty years and made mandatory four years later: the first three digits send each piece of mail to a central sorting facility, where it is sorted according to the last two digits and sent to the appropriate post office for delivery.

As with many big initiatives, there was still the challenge of educating the public and helping them adopt the practice of adding numbers to the end of an address. Introduce Mr. Zip, accompanied by Ethel Merman performing ‘Zip-a-dee-doo-dah’ and bringing a friendly message to one and all. This little cartoon figure was so effective that now 95% of all addresses include the zip code, an amazing statistic. It goes to show you the impression of a marketing campaign in such a basic format for everyone to comprehend and enjoy.

Now, picture yourself trying to manage an ever-growing amount of mail and routing it correctly to millions of frequently-changing addresses every day. The challenge shifted to accuracy of address data, giving way to new solutions to be introduced. The first zip code directories were local, pencil-and-paper, affairs, ineffective, but the best thing available.

That quickly changed with the availability and power of computers, until today there are huge amounts of data accumulated in zip code databases nationally, internationally, for city and state levels and as part of every business or corporation. We can’t communicate without the location information they contain.

The national online zip code database constantly adds, updates, and verifies zip information for every person or business at every location in the country. Canada has a comparable setup; other countries have varying coverage. International corporations have them. To name just a sample, many businesses, hospitals, and educational institutes develop and use zip code directories.

There is a wide scope of capabilities that online databases provide in the zip code world. By accessing information from around the country from so many different sources, changes are quickly synched up and missing information or new addresses are added with ease. This first-time correct delivery gets mail to the right place more quickly and saves millions of dollars every year in the process.

There are zip code maps of all sorts, zip code ‘finder’ software, zip code directories, and online zip code search engines. We’ve come a long way from the Pony Express rider riding hard to deliver his cargo!