Re: Address basics

50's!
Did you go to Berkeley? A fellow Bruin?

Chandru

"BobJ" <rjoslyn@xxxxxxxxxxxxx> wrote in message
news:Tr-dndS9dtijVkLUnZ2dnUVZ_q-dnZ2d@xxxxxxxxxxxxxxxx
My address in Berkeley in the early 50s was 2522 1/2 D Piedmont. That's
on sorority row about three blocks from Sather Gate. The morning walk to
the campus was very plesant. Here in Miami we have NW South River Drive
and SW North Kendall Drive. I don't think it's possible to generate a
rule that will fit every case.
BobJ

"dawn" <dawnwolthuis@xxxxxxxxx> wrote in message
news:0606dc4a-c24f-4527-b3a7-da6ad2e85bc2@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Apr 8, 5:05 pm, "Peter McMurray" <excalibu...@xxxxxxxxxxx> wrote:
Hi Dawn
Welcome to my favourite bugbear - US websites that do not understand
addresses.
I have done a fair bit of work just to get Australian addresses correct
and
would advise against ruling out punctuation such as commas and hyphens.
One
can get items such as 124-138 Somewhere street - they knocked down
several
houses and put up a block This results in an address like Flat 1, 124-138
Somewhere Street.

Good anecdote, I'll tuck that one away and skip doing any odd-
punctuation removal at this point.

Better still in Canberra they have things like Circ. for
Circuit indicating a street going around in circles like most
politicians.
Also do not try and force street numbers to be numeric, hammerhead blocks
can easily be 40A Lovely Avenue. They put a house on the spare garden
behind number 40. I use the numbers for Heating oil delivery route
control
and in Australia odd numbers are on the left and even numbers on the
right

I'm with Ross in that I laughed when I read this (the thought that one
could turn around and the numbers would change).

but in Tokyo the numbers are in the order that the street was rebuilt
after
the war. Just to make life really interesting the HO tanks can be in the
lane way to 40A but in Sydney I have found the tank for 42 on the side of
40
and of course the tank for 40 on the side of 42 without any signs that
this
is the case.

I have seen A's and B's in the U.S., but I'm not sure they were valid
post office addresses, they might be "sub-addresses" within a single
point for a post office, so they would be valid for locations where
someone was traveling, potentially.

Also Australian Postcodes can and do start with zero so do not chop
leading
zeroes. British post codes are terrific identifying the area then the
street and the side of the street, even the exact building if it is
larger
than a house with a 7 character id plus a space..
Anyway good
luckhttp://www.bitboost.com/ref/international-address-formats.htmlhttp://www.columbia.edu/kermit/postal.html

Those were helpful.

should help. Austria can have different town names for the Posal area to
the actual delivery point for example.

I noticed that Amazon has Zip for the Postal/Zip code, but State/
Province/Region instead of just State/Province, seemingly not-at-all
politically correct for the first and overboard for the second.

Thanks. --dawn

Peter McMurray"dawn" <dawnwolth...@xxxxxxxxx> wrote in message

news:069fb4f2-57b0-42ff-a20b-3ef3ada774f3@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

I'm about to dive into the address a little more, both U.S. addresses
only and also the world. We have an address file, keyed by an
autoincrement number. In at least one place there is a foreign key to
this file where the user of the address is most likely to want the
address for postal service use. There is another foreign key where the
user of that address is most likely to want it for being able to
navigate to that location physically.

I have lots of nit questions, such as
1. Is there any crime in applying the exact same validation for both
types of addresses?

2. 1st 2 lines (we have as multivalued Street). Can we do no
validation whatsoever on these lines (other than not permitting a
second line without a first)

3. City. Since this can be either for postal service or directions, we
will likely not look it up in any table, at least not for starters.
Does that make sense? What non-lookup-type validations should we do?
Should we purge it of special characters, such as hypens, commas,
apostrophes, exclamation points, etc or are there some cities with
such characters in them?

4. State/Province. If this is a US address, we can provide a list of
states. If Canadian, we can provide a list of provinces. My knowledge
decreases significantly after that. Is there a country-state/prov
cross-reference or even web service that can be used to find the list
of states/provinces when you pass it a country code?

Lots more questions, but time for lunch so I'll post and go. --dawn




.

Relevant Pages

  • Re: Address basics
    ... lane way to 40A but in Sydney I have found the tank for 42 on the side ... post office addresses, they might be "sub-addresses" within a single ... Is there any crime in applying the exact same validation for both ... Should we purge it of special characters, such as hypens, commas, ...
    (comp.databases.pick)
  • Re: Address basics
    ... lane way to 40A but in Sydney I have found the tank for 42 on the side ... post office addresses, they might be "sub-addresses" within a single ... Is there any crime in applying the exact same validation for both ... Should we purge it of special characters, such as hypens, commas, ...
    (comp.databases.pick)
  • Re: Address basics
    ... lane way to 40A but in Sydney I have found the tank for 42 on the side of ... post office addresses, they might be "sub-addresses" within a single ... Is there any crime in applying the exact same validation for both ... Should we purge it of special characters, such as hypens, commas, ...
    (comp.databases.pick)
  • Re: Address basics
    ... on sorority row about three blocks from Sather Gate. ... post office addresses, they might be "sub-addresses" within a single ... Is there any crime in applying the exact same validation for both ... Should we purge it of special characters, such as hypens, commas, ...
    (comp.databases.pick)
  • Re: Exchange 2007 Get-Recipient errors
    ... Narvekar has been corrupted and it is in an inconsistent state. ... following validation ... by at least one of the other characters. ... U+00FF are also valid in an alias, but they will be mapped to a best-fit ...
    (microsoft.public.exchange.admin)
Loading