× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.