PDA

View Full Version : Canadian and US Cities DB import



Andrew Conohan
June 16, 2013, 03:42 PM
I am looking for a listing of US and Canadian cities, I have my QuickSearch populated with the countries but now need States / Cities Provinces/Cities of US and Canda so if anybody has one kicking around could they msg me with help please?


Thank You

Andrew

Pete Young
June 17, 2013, 11:37 AM
I have done USA and Canada down to sub lelvel > country > state > region / county Bot have done the towns in the counties, I do not know how to export the geo stuff but if there is a way your welcome to it.

or if you want you can use this to narrow down the usa locations / sub locations by drilling down

http://zipcodes.qpzm.com/

Mike
June 18, 2013, 09:33 AM
You can try Remote Import featured in the MultiField plugin to populate your site with US, CA cities.

main steps are
- install multifield plugin
- create data entry in plugin, click manage newly created entry
- click Remote Import button, select database and select countries (Canada, USA)

Andrew Conohan
June 22, 2013, 04:17 AM
Thanks to both of you for your help I will try your suggestions.

Petrache Nicolae
December 21, 2013, 09:15 PM
i don't know how good are the databases for usa or canada but for romania they are simply junk. wrong counties, 2-8 cities in each county (and most wrong). i tried both databases.

romania has over 40.000 locations (cities)...take a look at http://ro.wikipedia.org/wiki/Categorie:Liste_de_localit%C4%83%C8%9Bi_din_Rom%C3 %A2nia for instance