jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases 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

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Tables to cross-reference state-city-postal codes? " Watch "Tables to cross-reference state-city-postal codes? " New topic

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

M Burke
Ranch Hand

Joined: Jun 25, 2004
Posts: 397
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
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3753

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 ]

[OCA 8 Book] [Blog]
I agree. Here's the link: http://aspose.com/file-tools
subject: Tables to cross-reference state-city-postal codes?
It's not a secret anymore!