US city, state and zip in XML, JSON or comma delimited? [closed]

Closed. This question开发者_Go百科 does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 5 years ago.

Improve this question

I'm looking for any kind of flat file that contains every US city, state and zip code. I've searched high and low and can only find databases - which I'm fine using to create the flat file - but I thought I'd check here first.

If nobody else has a ready-made solution I'll parse through a database and post the flat file as the answer.

The reason I need this is for ajax auto-suggest. YQL and other free remote solutions are proving to be inconsistent and at worst, unreliable. I also do not want to make that many database calls.

---

You could farm these JSON sets:

http://gomashup.com/json.php?fds=geo/usa/zipcode/state/IL&jsoncallback=? http://gomashup.com/json.php?fds=geo/usa/zipcode/state/CA&jsoncallback=?

etc

---

Why not just load the data from a database into a javascript object in one ajax call and hook that into your autosuggest?

EDIT: agreed with @elusive, 20,000+ municipalities is a LOT of data to load to each client