Does anybody know where I can find open source world city database that includes:
- city names in different languages
- region / state / province
- country
- IP address range
- longitude / latitude
Advertisement
Answer
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