WebProWorld Part of WebProNews.com
Page One Link To Us Edit Profile Private Messages Archives FAQ RSS Feeds  
 

Go Back   WebProWorld > Webmaster, IT and Security Discussion > Database Discussion Forum
Subscribe to the Newsletter FREE!


Register FAQ Members List Calendar Arcade Chatbox Mark Forums Read

Database Discussion Forum This is the place to find help resolving those nagging questions you have about implementing and using all kinds of databases. Need help writing a query? Need an opinion on Oracle? Post here!

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 06-16-2006, 02:17 PM
lizardlips lizardlips is offline
WebProWorld New Member
 

Join Date: Mar 2004
Location: U.S.A.
Posts: 12
lizardlips RepRank 0
Default Zip Code Locator

We use a zip code search on our site and are looking for the best source to update the database. Any help would be greatly appreciated.
Reply With Quote
  #2 (permalink)  
Old 06-16-2006, 05:47 PM
brian.mark's Avatar
brian.mark brian.mark is offline
Administrator
 

Join Date: Jul 2004
Location: Omaha
Posts: 2,717
brian.mark RepRank 2brian.mark RepRank 2
Default

USPS Web Tools comes to mind. Since they assign the codes (at least in the US), they should have the most up to date list.

http://www.usps.com/webtools/address.htm

Brian.
__________________
ToolBarn.com, an Internet Retailer Top 500 and Inc. 500 Company | Tool Parts | Pet Supplies
Reply With Quote
  #3 (permalink)  
Old 06-16-2006, 09:59 PM
lizardlips lizardlips is offline
WebProWorld New Member
 

Join Date: Mar 2004
Location: U.S.A.
Posts: 12
lizardlips RepRank 0
Default

From what I have read this is the list with inferior long/lat, and it is the long/lat that we need to be precise. Any other ideas.
Reply With Quote
  #4 (permalink)  
Old 12-19-2006, 02:39 PM
upperfalls upperfalls is offline
WebProWorld New Member
 

Join Date: Sep 2005
Location: Upper Falls, West Virginia
Posts: 3
upperfalls RepRank 0
Default Beware of snake oil salesmen

I run a site for a very small community. That community is in the United States Postal Service national address database. It is not, however, the "default" city for the ZIP Code my site serves.

While the major Web sites serve all communities in the USPS database, startup sites tend not to do this. Thus, when I find a really great Web site that outshines the big sites, I inevitably have to convince the owner to manually add my city to their database before I can add them to my directory.

I just replied to the owner of a small site who was confident that their data vendor would soon add my city and everything would then be fine. I had to relate that they wouldn't be adding anything and the issue would not just resolve itself. I had just had correspondence with another site owner who complained about a large local community in California not being in the city/state/zip database he purchased and how he had to respond to thousands of complaints as a result.

IMHO, the vendors of location databases who take the USPS database and "cleanse" it are snake oil salesmen who do great damage to the Web community. Their "value added" is to remove most of the cities that are officially supported for mail delivery by the United States Postal Service. They then call this an improvement and actually have the gall to charge for it! The result is that those who fall for the ruse, end up failing to serve thousands of communities and millions of users across the entire nation.

The United States Postal Service national address database may not be perfect, but it's actively maintained and updated in near real-time. I've watched a correction post to it within minutes of my query that returned an address that failed to validate. And, after all, it is the official database that is used to deliver mail for the nation, with representatives covering essentially every square inch of it!
Reply With Quote
  #5 (permalink)  
Old 08-24-2007, 05:27 PM
marms767 marms767 is offline
WebProWorld New Member
 

Join Date: Dec 2005
Posts: 5
marms767 RepRank 0
Default Re: Zip Code Locator

I use ZIP Code Postal Code Area Codes Database Subscription and Solution Services | ZIPCodeWorld.com for a web site in which they enter their zip code and it returns results of my locations ordered by miles away from them.

For $99 a year they give me zip code updates and the off the same code in most major languages on how to do the zip code locator query Developers Section | ZIP Code, Area Code and Postal Code Solutions
__________________
MArms
self-help book | used cell phones | cell phone donation
Reply With Quote
Reply

  WebProWorld > Webmaster, IT and Security Discussion > Database Discussion Forum
Tags: code, locator, zip



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



Search Engine Friendly URLs by vBSEO 3.0.0