World Cities Free Database

Home

My Account

PRODUCTS

GeoDataSource™ World
Cities Database

GeoDataSource™ World
Structural Features Database

Basic Edition

Premium Edition

Gold Edition

GeoDataSource™ World
Water Features Database

Basic Edition

Premium Edition

Gold Edition

GeoDataSource™ World
Land Features Database

Basic Edition

Premium Edition

Gold Edition

Software Products

GeoDataSource .NET Component

World Major Cities 2009 + Drop Down List Source Codes

GeoDataSource™ World Cities Database Free Edition

Download Sample

GeoDataSource World Cities Database FREE Edition
(GAFN) - February 2010 Release

GeoDataSource World Cities Database FREE Edition contains 2,311,134 entries with city names in original language and region names.

Free database of worldwide cities in text format suitable for any applications requiring a comprehensive list of cities and country code. It is a subset of the paid edition of GeoDataSource World Cities Database Basic, Premium and Gold Editions.

Click here to view breakdowns by country

Product Advantages

Free and Updated Monthly
Multiple Subscriptions Packages Available
Discounted Subscriptions Pricing Available
Most Accurate and Up-to-Date Source of Data
Comprehensive List of Cities and Related Items (2,311,134 Entries)
Support Worldwide 260+ Countries, Territories and Sovereign Lands
Instant Download Upon Subscription
Free Customer Support
Many Happy Customers

Product Requirements

Internet connection capable of downloading 50 MB compressed ZIP data file
50 MB free disk space for compressed file
250 MB free disk space for uncompressed data files
WinZIP or other similar archive extraction utility
SQL Server, Oracle, MySQL, PostgreSQL or other database software application capable of importing 2,311,134 records from a standard tab-delimited ASCII text file and sufficient disk space to import the database

Product Specifications

FIELD NAME	FIELD DESCRIPTION	FIELD TYPE	FIELD LENGTH (MAX)
CC_FIPS	FIPS 10-4 Primary Country Code. A two alphabetic character FIPS 10-4 Primary Country Code uniquely identifying a geopolitical entity (countries, dependencies, and areas of special sovereignty).	character	2
FULL_NAME_ND	Feature's No Diacritics Full Name. Same as the full name but the diacritics and special characters are substituted with Roman characters.	character	200

MySQL

CREATE TABLE GEODATASOURCE_CITIES_FREE
(
	CC_FIPS VARCHAR(2),
	FULL_NAME_ND VARCHAR(200),
	INDEX(CC_FIPS),
	INDEX(FULL_NAME_ND),
	INDEX(FULL_NAME_ND,CC_FIPS)
) DEFAULT CHARSET=utf8;

CREATE TABLE GEODATASOURCE_COUNTRIES
(
	CC_FIPS VARCHAR(2),
	CC_ISO VARCHAR(2),
	TLD VARCHAR(3),
	COUNTRY_NAME VARCHAR(100),
	INDEX(CC_ISO),
	INDEX(COUNTRY_NAME),
	INDEX(COUNTRY_NAME,CC_ISO)
);

Microsoft SQL Server

CREATE TABLE [GEODATASOURCE_CITIES_FREE] (
	[CC_FIPS] [varchar] (2) NULL ,
	[FULL_NAME_ND] [varchar] (200) NULL ,
) ON [PRIMARY]
GO
 CREATE  INDEX [FULL_NAME_ND] ON [dbo].[GEODATASOURCE_CITIES_FREE]([FULL_NAME_ND]) ON [PRIMARY]
GO
 CREATE  INDEX [CC_ISO] ON [dbo].[GEODATASOURCE_CITIES_FREE]([CC_FIPS]) ON [PRIMARY]
GO

CREATE TABLE [GEODATASOURCE_COUNTRIES] (
	[CC_FIPS] [varchar] (2),
	[CC_ISO] [varchar] (2),
	[TLD] [varchar] (3),
	[COUNTRY_NAME] [varchar] (100)
) ON [PRIMARY]
GO
 CREATE  INDEX [COUNTRY_NAME] ON [dbo].[GEODATASOURCE_COUNTRIES]([COUNTRY_NAME]) ON [PRIMARY]
GO
 CREATE  INDEX [CC_ISO] ON [dbo].[GEODATASOURCE_COUNTRIES]([CC_ISO]) ON [PRIMARY]
GO


	Link to Us		News		Newsletter		Privacy Policy		Legal Disclaimer		Site Map