wood burning stoves 2.0*
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3703
    
    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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Tables to cross-reference state-city-postal codes?
 
Similar Threads
What is a good format for international mailing addresses
Need help quickly....intelligent city name problem
Help with an SQL Statement
Dropping leading zeros on numeric field
Ajax and Struts