worldCities sample data

To give you the ability to properly evaluate our worldCities database, we offer extensive sample data, containing data about 480,000 places.

Get the free worldCities sample data now

Please fill the following form and the link to the worldCities sample data will be sent to you by e-mail.

We value your privacy and will NEVER share your contact information!

* indicates required field

Content

The worldCities demo contains data from all the tables in the worldCities and worldCities Extensions. It is simply a subset of the data, the structure being exactly the same as in the full products.

Continents and macro-regions

The worldCities demo contains all of the continents and macro-regions that are in the full worldCities database.

Countries

The worldCities demo contains all countries that are in the full worldCities database.

Administrative divisions

  • 1st-level administrative divisions: for each country, the demo contains about half of the 1st-level administrative divisions.
  • 2nd-level administrative divisions: for each of the included 1st-level administrative divisions, the worldCities demo contains about half of the 2nd-level administrative divisions.
  • 3rd- and 4th-level administrative divisions: for the included 2nd-level administrative divisions, all 3rd- and 4th-level administrative divisions are included.

Note: Not all countries have administrative divisions. Of those that do have, some have only 1 or 2 levels.

Populated places

For the lowest level of administrative divisions of each country, half of the populated places (cities, towns, villages, etc…) are included in the worldCities demo.

Definitions

Also included in the sample is the table with the definitions of the codes used in the feature_type, feature_description and name_type fields.

GPS Coordinates (worldCities Extension)

The coordinates (latitude and longitude) are included for all the populated places in the demo.

Language Pack (worldCities Extension)

Names from the Language Pack are included for only a few records for each type of features (continents/regions, countries, administrative divisions and populated places).

Standard Codes (worldCities Extension)

The available codes are included for all the continents/macro-regions, countries/territories and administrative divisions in the demo.

Importance (worldCities Extension)

The relative importance (on a 1-5 scale) is included for all the populated places in the demo.

MySQL scripts

The scripts to create the tables and load the data in MySQL are included in the demo files. You can also take a look at sample MySQL queries to work with worldCities.

Feel free to contact us if you have any questions about the use of our worldCities database or multiple-licenses/redistribution terms and conditions, and we will be pleased to help you.