Menu
Does anybody know where I can find open source world city database that includes:
256
To access a specific database, type the following command at the mysql> prompt, replacing dbname with the name of the database that you want to access: Copy use dbname; Make sure you do not forget the semicolon at the end of the statement. After you access a database, you can run SQL queries, list tables, and so on.
For everywhere except the US, try the National Geospatial Intelligence Agency's GNS Country Files dataset and for the USA, use the USGS Domestic Names Database. This data is copyright free and relatively easy to import into MySQL.
These do not include IP address ranges, that sort of data is commercially available from folks like MaxMind
187
MaxMind's GeoLite City database is free:
http://www.maxmind.com/app/geolitecity
The website has instructions for inserting the contents into a database table.
It contains city, region/state/province, country, IP address range, latitude, longitude and a bunch more info.
40
http://www.rocky.nu/software/mysql-world-locations-database
This one contains world cities and Latitude / Longitude
You can also get a world database at geonames org
20
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
