Path: utzoo!telecom-request Date: Mon, 20 May 91 11:30:29 EDT From: John Cowan Newsgroups: comp.dcom.telecom Subject: Re: One City With Two Area Codes Message-ID: Organization: TELECOM Digest Sender: Telecom@eecs.nwu.edu Approved: Telecom@eecs.nwu.edu X-Submissions-To: telecom@eecs.nwu.edu X-Administrivia-To: telecom-request@eecs.nwu.edu X-Telecom-Digest: Volume 11, Issue 381, Message 10 of 10 Lines: 32 In article , levitt@zorro9.fidonet. org (Ken Levitt) writes: > Are there other cities in the country with two area codes? If I sell > another 500 copies of my program, how likely am I to run across > another one of them? And Our Esteemed Moderator Notes: > I'd think that with the numerous area code splits > going on in metro areas, your scenario could become quite common. How > does your program now deal with (post office) New York, NY? As an inhabitant of (post office) New York, NY, I make haste to inform you that that locality has only one area code: 212, also shared by Bronx, NY. The 718 area code is divided into the USPS localities of Brooklyn, NY; Flushing, NY; Jamaica, NY; Rockaway, NY; and Staten Island, NY. There may be one other which slips my mind at the moment. However, as a general principle of database design, I think it would be better to redesign the program to admit of more than one area code within a postal locality. When coding systems are assigned by two distinct authorities (USPS and Bellcore), it would be foolish to assume a perfect 1-1 correspondence at all points. cowan@snark.thyrsus.com ...!uunet!cbmvax!snark!cowan e'osai ko sarji la lojban