United Kingdom Gazetteer, UK Place Names (Cities) Database by Region, County and District City

Database Description:

This UK Gazetteer (cities) database is a complete compilation of United Kingdom local place names, categorized in regional level, county level and district (city) level. Britain Gazetteer including England Gazetteer, Scotland Gazetteer and Wales Gazetteer as well as Northern Irish Gazetteer are all part of this UK local place names list database.

Database Meta:

• Size: 0.4 MB
• Last updated: Sep. 24th, 2010
• Formats Included: MySQL dump .sql text file, CSV, MS Excel
• Tables: 3

Buy Now & Download: $69.00 (USD)

phpMyAdmin Screenshots:

Table Details (Data Structure / Schema):

• location

  Records:14

  UK regions. More than 9 as an attempt to include some of the surrounding islands separately.

  Data fields

  1. id: smallint(6)
  2. title: varchar(255)
  3. slug: varchar(255)

• sublocation

  Records:142

  UK counties.

  Data fields

  1. id: smallint(6)
  2. title: varchar(255)
  3. slug: varchar(255)
  4. location: smallint(6)

• subsublocation

  Records:7,571

  UK local districts, cities and towns.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. slug: varchar(255)
  4. sublocation: mediumint(9)

Buy Now & Download: $69.00 (USD)

Potential Applications / Usage:

• UK local sites and directories
• UK county and city information sites, weather sites etc.
• UK travel or tourism sites
• UK local yellowpages sites
• Online UK county and city local classifieds

Other Available Formats:

Some of these formats are available on extra charge, depending on the database.

• Plain CSV
• CSV for Microsoft Excel
• Microsoft Excel .XLS file (2008, 2007, 2003, 2000)
• Microsoft Word .DOC file (2008, 2007, 2003, 2000)
• LaTeX
• Open Document Spreadsheet
• Open Document Text
• PDF
• XML
• YAML
• WordPress Category / Post Database
• Single Table Format