2

I have been searching around for the best source for City, State, Zip, Country to use in an application. I have found the set at GeoNames.org and it seems very comprehensive. However there is not a simple import into SQL Server. I also believe the USPS has something similar.

Does anyone know a good reliable source that is easily imported into SQL Server for this information? Or maybe even some better Googling terms?

Joel Coehoorn
  • 399,467
  • 113
  • 570
  • 794
TDDG
  • 21
  • 1
  • 2
  • I always use http://www.usps.com/ncsc/lookups/usps_abbreviations.html. It probably won't help the original poster, but it might help someone else reading this. – PowerUser Feb 18 '10 at 14:00
  • By 'easily import' you mean you want their database in a sql server import friendly format? – zapping Feb 18 '10 at 14:05
  • I guess I'm mostly interested in finding an accurate robust list of cities, states, zip, countries. I can figure out the import. Just wanted to know what others were using for their "source" for their data. – TDDG Feb 18 '10 at 16:26

2 Answers2

1

There is a script to load data from geonames in a blog I wrote a while ago. Hopefully it helps.

SQL Server Zipcode Latitude/Longitude proximity distance search

George Mastros
  • 24,112
  • 4
  • 51
  • 59
0

Why can't you just get the CSV files and bulk-load them into your data base. How much simpler do you want?

No Refunds No Returns
  • 8,092
  • 4
  • 32
  • 43