Zip Code Lookups

Question

Zip Code Lookups

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Kit G SSCrazy Points: 2888 More actions · Answer 1

Cities cross county lines and even state lines (like Texarkana). I lived in one city that was in three, perhaps even four different counties, I don't remember because it wasn't important.

But the actual area covered by the zip code doesn't cross county lines. I think you'll find that those zips for the sample you showed are separate zips.

-- Kit

Jeff Moden SSC Guru Points: 1003853 More actions · Answer 2

GSquared (1/22/2009)
Zip-code prefixes are state-specific. Can't span states. Lots of them span counties, but they don't span states. Even cities that span state-lines, have different Zip codes the parts of the city in one state vs the part in another.
A good example is Texarkana, which is a city on the Texas-Arkansas state line. "State Line Ave" runs through the middle of the city. Their TX Zip codes start with 75, while their AR Zip codes start with 71, because those numbers are state-specific.

To the best of my knowledge, that's not always true any more than NPA's and Lata's which can also cross state lines. I no longer work at the company where we had the state-line-crossing zipcodes documented, but there are several that do especially way out in the west.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Luke L SSC-Dedicated Points: 35547 More actions · Answer 3

OK, thanks to you all. You've definitely given me the appropriate ammo for the conversation I need to have with some folks today.

Thanks again.

-Luke.

To help us help you read this[/url]For better help with performance problems please read this[/url]