Project Description
SQL Server 2008 R2 database backup with tables, containing sample geographic data, such as shapes/boundaries of Countries of the World, Territories and Provinces.


Notes

The data was obtained from http://www.naturalearthdata.com/ 1:10,000,000 shapes and comes under their respective terms of use: Natural Earth is the creation of many volunteers and is supported by NACIS. It is free for use in any type of project.



The backup file provided contains the following tables:
1) Countries. Countries of the world. Ex: Yemen and Socotra island as one shape.
2) Territories. Countries of the world + Islands with their names and owners. Ex: Yemen and Socotra island as 2 different shapes. Each shape references associated country.
3) Provinces. Provinces / states of countries of the world. Ex: All provinces of Yemen and Socotra island as different shapes. Each shape references associated country.

All shape data is only available in English and native languages that use extended latin charset (e.g. French, Portuguese, German, Icelandic).

Conversion has been carried out by Shape2SQL fixing the problems by simplifying the shapes of the following provinces :
  • Matabeleland South (Zimbabwe)
  • Arauca (Colombia)
  • Suffolk (United Kingdom)
  • Sarangani (Philippines)
  • South Cotabato (Philippines)
  • Nord-Pas-de-Calais (France)

Last edited Jun 24, 2010 at 10:25 PM by burma, version 2