Lembit Soobik
lembit.soobik at t-online.de
Sun Mar 20 13:36:11 CST 2005
Arthur, in addition to the below mentioned URL, states/provinces in Germany dont go in the postal address the zip code takes care of everything. Lembit ----- Original Message ----- From: "MartyConnelly" <martyconnelly at shaw.ca> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Sunday, March 20, 2005 9:36 AM Subject: Re: [AccessD] Geography revisited > Here is a site for mail addresses > The whole thing is on CD for 750 Swiss Francs, otherwise you will have to > pick off the countries > one at time via PDF files from URL below. > UPU S42 Standard on International Postal Address Components and Templates > > I don't know why the changed their name from the old International Postal > Union > to the Universal Postal Union maybe there are secret mail drops for > Betelgeuse and Rigel. > > There is supposed to be something called the Universal POST*CODE database > on this > site somewhere but the pdfs will give you each countries basic standard > God knows what they do with arondissements in Paris. > > http://www.upu.int/post_code/en/postal_addressing_systems_member_countries.shtml > > For example here is Singapore standard. > http://www.upu.int/post_code/en/countries/SGP.pdf > > > > > Arthur Fuller wrote: > >> I don't have to solve the world's address problems, but I do have to >> solve some of them. USA and CDN I have under control. Other nations of >> interest include basically everyone in the EU. I'm hoping for answers >> from people either from each nation or from people with knowledge of >> same. >> >> 1. What corresponds to states/provinces in Ireland, England, Scotland, >> Wales, Germany, France, Netherlands, Belgium, Spain, Italy, Switzerland >> (I know it's cantons in the last, but I don't know their names). >> >> 2. Some countries, I know, place the street name before the street >> number. Can we define this arrangement more precisely (by nation)? >> >> 3. Not immediately relevant, but is Singapore a city-state or part of >> China or what? >> >> TIA, >> Arthur >> >> > > -- > Marty Connelly > Victoria, B.C. > Canada > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > > -- > No virus found in this incoming message. > Checked by AVG Anti-Virus. > Version: 7.0.308 / Virus Database: 266.7.4 - Release Date: 18.03.2005 > > -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.4 - Release Date: 18.03.2005