aspose file tools*
The moose likes JDBC and the fly likes Tables to cross-reference state-city-postal codes? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Tables to cross-reference state-city-postal codes? " Watch "Tables to cross-reference state-city-postal codes? " New topic
Author

Tables to cross-reference state-city-postal codes?

M Burke
Ranch Hand

Joined: Jun 25, 2004
Posts: 388
I want to be able to match state-city-postal codes. So if a user enters a city\state, I can give them the correct zip codes for that area. Or the correct list of cities based on a zip.

I would also like to do radii matches. So if someone in a city-state-zip wants a list of others within a certain radius, I can give them a matching list.

Are there any ready-made schemas to do this?
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3716
    
    5

There are ready made paid versions out there. Do a search on zip code databases on google and you'll come up with a lot. Depending on how you want to use it you may need to pay different fees (for example if you want the list distributed with the application).

There are also some free lists and servers but I'm going to go out on a limb and say you pay for what you get. It really depends on how serious the application you are developing is and how strigent the requirements are for zip code matching.
[ January 18, 2007: Message edited by: Scott Selikoff ]

My Blog: Down Home Country Coding with Scott Selikoff
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Tables to cross-reference state-city-postal codes?