Re: US Zip codes

It looks like IA  will go home with anyone, eh?  :)

Thanks for the answer Jim.  I was looking in several places but had no luck.

 
 
---------------------------------------------------------
Booth Martin   http://www.MartinVT.com
Booth@xxxxxxxxxxxx
---------------------------------------------------------
 
-------Original Message-------
 
From: Midrange Systems Technical Discussion
Date: Sunday, October 05, 2003 19:40:07
To: Midrange Systems Technical Discussion
Subject: Re: US Zip codes
 
Based on the file below, many zip codes cross state lines
10004 - NY and NJ
37642 - TN and VA
38041 - AR and TN
38063 - AR and TN
38079 - KY and TN
38852 - AL and MS
42223 - KY and TN
51630 - IA and MO
51640 - IA and MO
52626 - IA and MO
52761 - IA and IL
55954 - IA and MN
56027 - IA and MN
56129 - IA and MN
56219 - IA and SD
57638 - SD and ND
59221 - MT and ND
65733 - AR and MO
 
i stopped looking at this point (this file fits easily into excel, or to
download
to iSeries. Scan the word "part" their term for part 1 state, part another.
 
I've been in that situation where flat files are hard to update.
I would suggest a called program you can plug into various programs.
Check zip code file, and only if 2 states involved, either prompt user
to specify, or read address lines from bottom up, right to left, to find
state.
May still need to prompt user. Consider adding a new external file for
something like order# (key) and state code (in your case), rather than
change
flat file and a thousand programs. Later, when doing major changes,
reintegrate state code back into order file. Sometimes database
design and corporate reality don't mix.
 
jim
 
 
----- Original Message -----
From: "John Myers - MM" <jmyersmm@xxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Saturday, October 04, 2003 3:01 PM
Subject: Re: US Zip codes
 
 
> Check out:
>
> http://www.census.gov/geo/www/gazetteer/places2k.html
>
> The file zcta5.txt has a list of all Zip Codes by state ... and lots of
> other goodies!
>
> John Myers
> Strategic Business Systems, Inc.
> 17 S. Franklin Turnpike, Ramsey, NJ 07446 USA
> E-mail: mailto:jmyers@xxxxxxxxxx Phone: +1 (201) EASY 400 x131
> Web: http://www.sbsusa.com Fax: +1 (201) 327-6984
>
 
 
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
 
.