RE: City/State/County Info by Zip Codes -- MIDRANGE-L

Vertex work ok for most rural type addresses, though they do NOT geocode
very small communities (less than 500 or so).  For large urban cities, you
may find that Vertex can't determine which county an address resides, so you
may be hard pressed to get full compliance....

I wrote an "address validator" program that access the Vertex LOC api's to
scrub address info, and to return geocodes to my database.  When running in
batch, it is instructed to not return a result IF there are multiple
locations returned for a particular address.  I still see better than 95% on
most files I pass through, so overall it works pretty well.

You didn't specify what version of Vertex you're using, but not all of their
products have the features that I am using.  We use Vertex Q-series
(formerly Quantum for Sales and Use Tax) which is a C based runtime,
delivered in service program objects.  

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: Sannan Solberg [mailto:SSolberg@xxxxxxxxxxxx]
Sent: Thursday, August 19, 2004 9:30 AM
To: Midrange Systems Technical Discussion
Subject: RE: City/State/County Info by Zip Codes


Thanks again everyone for the suggestions.  I'll look again at some of the
links everyone provided.  I've checked out a few of them already. To address
a couple of the questions that arose.  

1. We actually do have the Vertex Tax software and I've been trying to scour
around in their data to see if I can find this info in their "geocoding"
stuff.  I might have to break down and call them.
2. The spanning zipcodes per county is fine.  In fact the file I'm looking
to fill is setup just that way; you provide a range of zip codes (including
+4) for each record.
3. I'm actually trying to fill a pre-existing file in JDE/Peoplesoft World
software that will do a bunch of work for me so I don't have to create my
own table and do something different.  JDE/Psft does NOT fill this file or
have any clue who could help us fill it.  Their "address book" module then
will look at this file when doing some validation of addresses as entered
(for city/state/county) if you don't type them in yourself.  Nothing fancy
but serves it's purpose.

-----Original Message-----
From: Jim Franz [mailto:franz400@xxxxxxxxxxxx]
Sent: Wednesday, August 18, 2004 8:45 PM
To: Midrange Systems Technical Discussion
Subject: Re: City/State/County Info by Zip Codes


A note that once you get a database, you will find some zip codes span
multiple counties, and can even span states (in some rural areas along the
Mississippi river, etc). Originally zip codes were handed out to mostly
"states", but later some unused zip codes originally assigned one state were
reassigned to another state (Virginia, Maryland, DC area is one example)
Also, we are not the only country in the world with  5 digit zip codes
(I know we truly have a 5 +4 system, but lots of software deals with only
the 5).
jim
> Beacon Insurance
> 940-720-4672
>

--
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.