List of Cities By State

[DrDankWD]

Hey everyone, I couldn't really find a good forum to post this in so here it is  :)

I need a xls, txt, or some other formatted document that contains all cities in the US by state.

Anyone happen to have one of these laying around before I make one myself?

Thanks!

[redbullmarky]

well one step better (depending on how you look at it) - http://www.maxmind.com/app/geolitecity

every city in the world. cities come with region codes, which you'll need to cross reference with another (MUCH smaller) database table, but if you have a hunt around on the same site, you'll find it.

hope it helps!
cheers
Mark

[DrDankWD]

You Kick Ass!

Thanks!

[ober]

Awesome Mark.  I added it to the web critique Resources tab :)

[redbullmarky]

;) no worries. it's only been freely available since earlier this year - generally that sort of information costs a fortune.
for anyone that uses it, be warned - importing 3m records into a database can take SOME TIME, and then there's the job of indexing it properly. and if you wish to go a step further, there are two further database tables to set up. an ISO and a FIPS one. one is for regions around the world, the other is for american states. For those of you that like to belong to 'England', 'Scotland', 'Northern Ireland' and 'Wales', and not the UK/GB, there's a bit more work to do, but all the data is there.

[Daniel0]

[url=http://xaos-ia.com/daniel/us_cities_by_state.csv]CSV (365 KB)[/url], [url=http://xaos-ia.com/daniel/us_cities_by_state.xml]XML (1.9 MB)[/url]

I used the database [url=http://www.micahcarrick.com/v2/content/view/4/3/]here[/url] to generate the files.