Zip Code API

EE Colleagues:  Can anyone point me to an API or web site that allows automated requests for ZIP codes and Canadian post codes?  I want something that will allow me to give city and state information and get back the zip code or list of zip codes that serve the city.  About 500 requests are all I need.  Thanks and regards, ~Ray
LVL 111
Ray PaseurAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ray PaseurAuthor Commented:
@COANetwork: Are there any that are still working that allow automated access?  I don't mind doing my homework, but I've already done the googling and I'm looking for something that someone has actually used successfully.
0
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
Ray, I downloaded the U.S. Zips from the census and have used that.  I also just found a free api from the USPS https://www.usps.com/business/web-tools-apis/address-information.htm  I just signed up for this myself to give it a try.

http://smartystreets.com/kb/liveaddress-api/zipcode-api

Although a bit round about...  but free http://docs.citygridmedia.com/display/citygridv2/Places+API#PlacesAPI-PlacesSearch

I have used melissadata for many years and they are good source but for $$ http://www.melissadata.com/postal-lookups/index.htm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dimmergeekCommented:
Check out this site.
Pricing for 500 lookups is $20 per month.
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

dimmergeekCommented:
Sorry, I posted my response prior to seeing padas' post.  Didn't refresh my page before submitting.
0
Ray PaseurAuthor Commented:
Thanks.  I think I will do this by hand - only 500 entries.  But the Census data is a great idea.  After all, we've already paid for it!  Best to all, ~Ray
0
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
What you want is the places database http://www.census.gov/geo/maps-data/data/gazetteer2010.html and I have included the download here.   The 2nd column has both the state code and zip code.  The state code is the first 2 characters of the 2nd column.  Then the next 5 is the zip.
Gaz-places-national.zip
0
Ray PaseurAuthor Commented:
Very cool, thanks!  Just a little quid-pro-quo.  I have discovered that you can find the general location of any ZIP code by using just the first three digits.  It takes the size of the ZIP code search (for example, to call a weather app) down from 35K rows to under 1K rows!  The first three digits are called the SCF.  I think it stands for Sorting Central Facility.  It's a little less precise than a full ZIP, but a lot faster!

Cheers, ~Ray
0
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
I used to manage database marketing/direct mail.... SCF Sectional Center Facility.    Depending on population density can cover an area about the size of 2 to 3 counties.  This can give you an idea of where an scf covers.  I think you can see multiple.  http://maps.huge.info/zip3.htm
0
Ray PaseurAuthor Commented:
Thanks, great mapping app.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development

From novice to tech pro — start learning today.