Category Archives: Misc Products

SmallCityDatabase

A single .NET library containing over 7300 world cities (“Includes all country/province capitals, major cities and towns, and smaller towns in sparsely inhabited regions.“).

This is based on the data licensed under the MIT license from the Simplemaps.com website converted into a .NET library. The population count is dropped in purpose as it is subject to change.

So this is not a database containing small cities, it is however small compared to the SQLite database WorldCities Database with a size of about 1 MB 🙂

Features

  • Current version 1.0.0.0 (12.03.2016)
  • A single .NET library containing over 7300 world cities
  • Small size (about 1 MB)
  • Full XML documentation (private / public)

Requirements

  • .NET Framework v.4.5
  • A MIT license compatible application

Changes

  • –

Download

Source code
Zipped binary

WorldCities Database

This is a SQLite database containing world cities and their locations (latitude, longitude).

This database is based on the CSV file downloaded from http://www.opengeocode.org.

The CSV is released as public domain, so this database is too 

Features

  • Current version 1.0.0.0 (27.09.2015)
  • The data consists of many columns of which most important are the name of the city (NAME), the latitude and longitude of the city (LATITUDE, LONGITUDE) and information whether to use right-to-left or left-to-right scripting of the city name (RTL)

Requirements

Changes:

  • –

Screenshot

A SQLiteSpy software showing my home town location

Download

The zipped CSV File
The SQLite database