Link to home
Start Free TrialLog in
Avatar of Ray Paseur
Ray PaseurFlag for United States of America

asked on

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
Avatar of Ray Paseur
Ray Paseur
Flag of United States of America image

ASKER

@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.
ASKER CERTIFIED SOLUTION
Avatar of Scott Fell
Scott Fell
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Check out this site.
Pricing for 500 lookups is $20 per month.
Sorry, I posted my response prior to seeing padas' post.  Didn't refresh my page before submitting.
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
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
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
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
Thanks, great mapping app.