| Click
here, to open a new window: this page
has two things going for it; an explanation of the vcode & an easy
link to the USPS's website for zipcode lookups. |
| In the box enter in "98303"
as the zipcode, click lookup. |
|
You'll see 4 entries. |
-
Anderson Island - Acceptable
(default)
-
Anderson Is - Acceptable
-
Villa Beach - Not Acceptable
-
Yoman Ferry - Not Acceptable.
|
|
Most zipcode database
only include the DEFAULT (which is why we break
it up into ZipCode.csv and ZipOther.csv, Zipcode.csv is the
"normal" database people will sell you. ZipOther.csv
contains all others that the post office lists. |
| If you have downloaded the database, open
ZipCode.csv with Notepad or Excel. |
Now find 98303, you only see Anderson
Island -- that's the default city for that
zipcode. it's vcoded as D
All records in ZipCode.csv are coded
D |
| Now look at ZipOther.csv -- this file
contains all records that are not the "Default" city/state for a
given zipcode. Look for 98303 |
You find the other 3 entries (listed
above), vcoded as A, N, N
The 1st character of the vcode is
what's important.
-
A = Acceptable
-
N = NOT Acceptable
|
|
Anderson Island and Anderson
Is are both "acceptable" as far as the
post office goes. But if you say "98303, what's the city/state"
it's Anderson Island (the default), not
the other acceptable city Anderson Is
Why do we even list "Not Acceptable"?
Because the USPS offers it up so we do too. You can
easily filter out if you just want DEFAULT and ACCEPTABLE to ignore the
"not acceptable" records. |
|
These last 3 are in ZipOther because
most people don't want them; but we include them
in case you want all city/state/zips that the Post
office WILL accept. Just ignore all records that have a
"N" as the first character of vcode! |
