DrDankWD Posted December 5, 2006 Share Posted December 5, 2006 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! Quote Link to comment https://forums.phpfreaks.com/topic/29470-list-of-cities-by-state/ Share on other sites More sharing options...
redbullmarky Posted December 5, 2006 Share Posted December 5, 2006 well one step better (depending on how you look at it) - http://www.maxmind.com/app/geolitecityevery 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!cheersMark Quote Link to comment https://forums.phpfreaks.com/topic/29470-list-of-cities-by-state/#findComment-135261 Share on other sites More sharing options...
DrDankWD Posted December 5, 2006 Author Share Posted December 5, 2006 You Kick Ass!Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/29470-list-of-cities-by-state/#findComment-135262 Share on other sites More sharing options...
ober Posted December 5, 2006 Share Posted December 5, 2006 Awesome Mark. I added it to the web critique Resources tab :) Quote Link to comment https://forums.phpfreaks.com/topic/29470-list-of-cities-by-state/#findComment-135479 Share on other sites More sharing options...
redbullmarky Posted December 5, 2006 Share Posted December 5, 2006 ;) 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. Quote Link to comment https://forums.phpfreaks.com/topic/29470-list-of-cities-by-state/#findComment-135491 Share on other sites More sharing options...
Daniel0 Posted December 5, 2006 Share Posted December 5, 2006 [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. Quote Link to comment https://forums.phpfreaks.com/topic/29470-list-of-cities-by-state/#findComment-135494 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.