I would like to create a simple access table which determines the territory
by zipcode range.  There are 3 territories in Indiana - north, south,
and Marion.  Basically, anything south of I-70 is in the south, and
anything north of I-70 is in the north - except for Marion County
which stands by itself.

The table should just be a 3 digit Zipcode and a territory code (N, S, M).

---

Request for Question Clarification by pafalafa-ga on 28 Sep 2005 09:30 PDT

beaconmj-ga,


I can direct you to an online map of Indiana that shows the outlines
of 3-digit zip codes in the state -- 462 for the Indianapolis area,
and 19 other 3-digit zips covering the rest of the state.

The map DOES NOT show roads or other features.  But it is clear that a
number of the 3-digit zips would be double-listed -- that is, they
straddle areas both north and south of I-70.


Would the map meet your needs?  Or do you definitely want an answer in
table format?


Let me know.


pafalafa-ga

---

Clarification of Question by beaconmj-ga on 28 Sep 2005 18:05 PDT

I definetly want a table like the one described.  I've been to several
of the map sites, and wondered if there were a data-related way to do
the project.  For the areas that might fall partly in both territories
we'd want to have some way to justify the decision, like determining
whether the zip code centroids (based on lat-long coordinates) fall
above or below the interstate line.  Or maybe a large city population
on one "end" of the SCF area would argue for it to go to one territory
or another.

beaconmj-ga,

Thanks for the clarification.

Here's the table you asked for:

===============

460	INDIANAPOLIS IN 460	. . . . . . . . . . . . . . . . . 	N
461	INDIANAPOLIS IN 461	. . . . . . . . . . . . . . . . . 	S
462	INDIANAPOLIS IN 462	. . . . . . . . . . . . . . . . . 	Marion
463	GARY IN 463	        . . . . . . . . . . . . . . . . . 	N
464	GARY IN 464	        . . . . . . . . . . . . . . . . . 	N
465	SOUTH BEND IN 465	. . . . . . . . . . . . . . . . . 	N
466	SOUTH BEND IN 466	. . . . . . . . . . . . . . . . . 	N
467	FORT WAYNE IN 467	. . . . . . . . . . . . . . . . . 	N
468	FORT WAYNE IN 468	. . . . . . . . . . . . . . . . . 	N
469	KOKOMO IN 469	        . . . . . . . . . . . . . . . . . 	N
470	CINCINNATI OH 470	. . . . . . . . . . . . . . . . . 	S
471	LOUISVILLE KY 471	. . . . . . . . . . . . . . . . . 	S
472	COLUMBUS IN 472		. . . . . . . . . . . . . . . . .       S
473	MUNCIE IN 473	        . . . . . . . . . . . . . . . . . 	N
474	BLOOMINGTON IN 474	. . . . . . . . . . . . . . . . . 	S
475	WASHINGTON  IN 475	. . . . . . . . . . . . . . . . . 	S
476	EVANSVILLE IN 476	. . . . . . . . . . . . . . . . . 	S
477	EVANSVILLE IN 477	. . . . . . . . . . . . . . . . . 	S
478	TERRE HAUTE IN 478	. . . . . . . . . . . . . . . . . 	N
479	LAFAYETTE IN 479	. . . . . . . . . . . . . . . . . 	N

===============


I hope the table formats properly, as they don't always survive the
process of posting to the answer board!


In looking over the three-digit zips, the characterizations (N, S,
Marion) turned out to be clear cut, due to the presence of a sizable
population center in one area or another, as reflected in the Post
Office names for each 3-digit area.


The resources used to generate this table were:


http://pe.usps.gov/text/dmm/L002.htm
USPS Digit ZIP Code Prefix Matrix



http://www.shsu.edu/~pst_www/l002.html
3-digit ZIP code prefixes 



http://www.gotomylist.com/cmeresults1.cfm?mnuSTselect=IN&Submit=Go
3-digit zip code map for Indiana


I trust this is what you need.  

But please don't rate this answer until you are fully satisified with
the information provided.  If there's anything else I can do for you,
just post a Request for Clarification to let me know.

Cheers,

pafalafa-ga


search strategy:  Bookmarked sites, and a Google search on [ 3-digit zip ]