>>>>Thanks. How often do these zip codes change?
>>>
>>>Some zip code assignment change each year - either as a result of reassigning zip codes to split large zips up, or as a result of postal consolidation. Of the ~78K zip codes in use last uear, fewer than 50 were reassigned.
>>>
>>>However, the mapping of Zip Codes to city names shifts frequently - you may have the same zip code refer to multiple cities/towns, and these change due to redistricting and changes intown incorproations.
>>
>>Ed,
>>
>>You may know this but I thought I'd use your post to let folks know of something to plan for whhen dealing with ZIP codes.
>>
>>One ZIP code number
can and
occassionally will be used for two city names.
>>
>>I ran into this a about 9 years ago with a couple of cities in Northern California. Both had the same ZIP code.
>>
>
>That's actually very frequent, especially in areas of low population density, where a zip code covers hundreds of square miles (parts of Alaska come to mind, not to mention APO/FPO addresses) and in urban areas where a number of small townships have become absorbed into a larger entity (there's one zip code in the New Haven area that's referred to by 4 different names.)
>
>>I had to come up with a little routine that, when the user entered a ZIP code would actually do a count of the returned codes. If the count was > 1 then a pseudo list box (this was with FoxBase+ 2.10 *g*) was presented to the user.
>>
>>Just something for folks to be aware of.
>>
>>Best,
>>
>>DD
Ed,
Thanks. As I had mentione anyone who needs that kind of granularity should be aware of this so they can code for it.
Best,
DD
Best,
DD
A man is no fool who gives up that which he cannot keep for that which he cannot lose.
Everything I don't understand must be easy!
The difficulty of any task is measured by the capacity of the agent performing the work.