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


  1.  Home
  2. MIDRANGE-L
  3. August 2004

RE: City/State/County Info by Zip Codes

We use the www.zipcodedownload.com data for several "Dealer Locator"
applications. You know, the "Find locations w/in xxx miles of zip code"
kinds of thing. I haven't run millions of addresses through it, but so
far so good. Keep in mind however, all you're buying is the zip code
data, a raw CSV (or fixed width, or tab delimited, etc.) file. There is
no application logic to go with it.

For a little more you can get something like WorksRight, which, IIRC
includes the application logic to do stuff with the data. If the
difference is ~$350 what's it going to cost you to write the code
yourself? I can assure you that none of the samples on the
zipcodedownload.com site are written in RPG or Cobol. <G>

-Walden 


------------
Walden H Leverich III
President & CEO
Tech Software
(516) 627-3800 x11
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com 

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
 
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
ron_adams@xxxxxxxxxxxxxx
Sent: Wednesday, August 18, 2004 11:33 PM
To: Midrange Systems Technical Discussion
Subject: Re: City/State/County Info by Zip Codes



I haven't used it, but as mentioned before,
http://www.zipcodedownload.com comes in three flavors ranging from
$19.95
to $39.95 depending on how much information you need.
A competitor,  http://www.zipwise.com offers a similar product in two
flavors, $15 and $39.

For the price of these, I don't see how you can go wrong really.

Ron Adams
Information Technology Group
Crane Valves
9200 New Trails Dr. Suite 200
The Woodlands, TX 77385
Office: 281-298-5463 x104
Direct: 281-465-3054
Cell: 281-216-7721



|---------+------------------------------->
|         |           "Jim Franz"         |
|         |           <franz400@xxxxxxxxxx|
|         |           om>                 |
|         |           Sent by:            |
|         |           midrange-l-bounces@m|
|         |           idrange.com         |
|         |                               |
|         |                               |
|         |           08/18/2004 09:44 PM |
|         |           Please respond to   |
|         |           Midrange Systems    |
|         |           Technical Discussion|
|         |                               |
|---------+------------------------------->
 
>-----------------------------------------------------------------------
--------------------------------------------------------|
  |
|
  |       To:       "Midrange Systems Technical Discussion"
<midrange-l@xxxxxxxxxxxx>                                             |
  |       cc:
|
  |       Fax to:
|
  |       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
----- Original Message -----
From: "Sannan Solberg" <SSolberg@xxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Wednesday, August 18, 2004 5:53 PM
Subject: RE: City/State/County Info by Zip Codes


> Thanks for all the replies.  My main need for it has to do with
getting
the County info "by zip code" so we can update our customer database.
The
"sales people" do things by County and we don't currently have that info
on
the customers.  Only addresses.  We will not be doing any validation
(but
we
could).  The reason I'm not worried about keeping it updated "regularly"
is
that I can regularly check for customers without a county on their
record,
check the zip and if it is new, find out the info from the USPS site and
add
it to my table.  We're not talking about "hundreds of thousands" of
customers either, just a couple hundred new ones per year and a majority
of
them would already be residing in zip codes we would (hopefully) have.
>
> -----Original Message-----
> From: Steve Morrison [mailto:smorrison@xxxxxxxxxxxxx]
> Sent: Wednesday, August 18, 2004 3:36 PM
> To: Midrange Systems Technical Discussion
> Subject: RE: City/State/County Info by Zip Codes
>
>
> I think you will need to be able to update your ZIP Code database, at
least
> annually. The zip codes do change, as the post office opens and closes
their
> post offices, and as towns grow and die.
>
> Can you give us some idea of how you expect to utilize this data? Are
you
> doing mailing list validations, or simply validating zip codes that
customer
> service reps are entering, or are you doing a shipping/routing
planning
> project?
>
>
> Steve Morrison
> Beacon Insurance
> 940-720-4672
>
> -----Original Message-----
> From: Sannan Solberg [mailto:SSolberg@xxxxxxxxxxxx]
> Sent: Wednesday, August 18, 2004 4:07 PM
> To: Midrange Systems Technical Discussion
> Subject: City/State/County Info by Zip Codes
>
> I've been researching web for such tools and there appears to be
plenty
of
> them but (as expected), my company isn't interested in a "yearly
update"
> process and some of them are costly.  (read that as "don't spend any
money
> to do this")
>
> What I'm really shooting to find is a resource that has zipcodes
(preferably
> ranges of zip codes) with City/State/County information for each zip
(or
> range of zips).  I only need the US and just want to do this as a "one
time"
> thing.  Our customer base does not change much so any maintenance
after
that
> is quite minimal (hence, we don't need the regular updates via an
outside
> product).
>
> Can anyone suggest where I might find such a (free) resource?  I'll
take
it
> just about any flavor (txt, excel, access, db2 table, etc.) and
massage
it
> to get it into my table.
>
> --
> 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.
>
> --
> 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.
>
>
>
> _________________________________________________
> Scanned on 18 Aug 2004 21:49:17
> Scanning by http://erado.com
>
> --
> 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.
>


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






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