postal-code

Where can I get postal codes for all countries?

I once read about an open source database for postal codes with geolocation data but now I can't remember its name. Can someone help? ...

Best practices for storing postal addresses in a database (RDBMS)?

Are there any good references for best practices for storing postal addresses in an RDBMS? It seems there are lots of tradeoffs that can be made and lots of pros and cons to each to be evaluated -- surely this has been done time and time again? Maybe someone has at least written done some lessons learned somewhere? Examples of the tra...

I need to store postal codes in a database. How big should the column be?

I expect the column to be a VARCHAR2, in my Oracle Database. US Zips are 9. Canadian is 7. I am thinking 32 characters would be reasonable upper limit What am I missing? ...

What is the ultimate postal code and zip regex?

I'm looking for the ultimate postal code and zip code regex. I'm looking for something that will cover most (hopefully all) of the world. ...

Address Validation API

I have a task to validate addresses entered into a system I am currently creating. The system requires that address entered are validated against a valid data source. In the UK the dataset comes from the Royal Mail and is expensive to access. The data needed is post code info for the whold of europe to start with accessed by an API in...

Is it a good idea to use an integer column for storing US ZIP codes in a database?

From first glance, it would appear I have two basic choices for storing ZIP codes in a database table: Text (probably most common), i.e. char(5) or varchar(9) to support +4 extension Numeric, i.e. 32-bit integer Both would satisfy the requirements of the data, if we assume that there are no international concerns. In the past we've ...

Is there common street addresses database design for all addresses of the world?

I am a programmer and to be honest don't know street address structures of the world, just how in my country is structured :) so which is the best and common database design for storing street addresses? It should be so simple to use, fast to query and dynamic to store all street addresses of the world which is identifying just by one i...

HttpWebRequest: How to find a postal code at Canada Post through a WebRequest with x-www-form-enclosed?

I'm currently writing some tests so that I may improve my skills with the Internet interaction through Windows Forms. One of those tests is to find a postal code which should be returned by Canada Post website. My default URL setting is set to: http://www.canadapost.ca/cpotools/apps/fpc/personal/findByCity?execution=e4s1 The required f...

WebRequest: How to find a postal code using a WebRequest against this ContentType="application/xhtml+xml, text/xml, text/html; charset=utf-8"?

I first posted this: HttpWebRequest: How to find a postal code at Canada Post through a WebRequest with x-www-form-enclosed?. Following AnthonyWJones suggestions, I changed my code following his suggestions. On a continuation of my inquiry, I have noticed with time that the content-type of Canada Post is more likely to be "application/...

How to implement proximity search with postcode?

Hi, I have to use proximity search with postcode for Australia. Going through some links like http://www.randommouse.com/rms/about/product/FNDRY/docs/tutorial/08/how-to-add-google-maps-to-your-review-site-intro.html I found that I have to manage the the post codes with latitude and longitude if I am not mistaken. But i could not fin...

ZIP / Postal Code + Country to Geo Coordinates

What is the most complete, precise and reliable way to get the coordinates (latitude / longitude) of a given ZIP / Postal Code of a given country? I need to make a lot of requests, so a high API limit rate (maybe even absent) would be useful. GeoNames dumps would be cool, but it seems to have way too many duplicate coordinates (example)...

What is the quickest way to validate a postal code as existing on the iPhone?

I have an iPhone application which accepts valid zip codes as input. The input can be quickly validated for format; I am looking for methods to validate whether it exists or not. What is the most efficient way to test whether a given Canadian or US postal code exists, without storing a database of valid codes on the phone? ...

How to look up ZIP/Postal Code by City using Google Maps API?

How can I extract a Postal Code or ZIP of a place by giving Google Maps a city on the map? Basically I'm looking for a free verification service for checking completed addresses for accurate details. I seem to remember the maps API can somehow provide a geographical point when given an address. Now I'm searching for a slightly reverse...

How to convert postal code to city name, is there an API available?

How to convert post code to city name, is there an API available? ...