• Covers all Officially Assigned Country Codes
• Instant Download Upon Subscription
• Free Customer Support
• Many Happy Customers

• Internet connection capable of downloading 3.36 kB compressed ZIP data file
• WinZIP or other similar archive extraction utility
• SQL Server, Oracle, MySQL, PostgreSQL or other database software application capable of importing records from a standard comma-delimited file and sufficient disk space to import the database

• MySQL
• MS SQL

-- Create table "northern_southern_hemisphere_countries"
CREATE TABLE `northern_southern_hemisphere_countries`(
	`country_code` VARCHAR(2),
	`hemisphere` VARCHAR(10),
	`coverage` VARCHAR(10),
	INDEX `idx_country_code` (`country_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- Load data into table
LOAD DATA LOCAL
INFILE 'GEODATASOURCE-NORTHERN-SOUTHERN-HEMISPHERE-COUNTRIES.CSV'
INTO TABLE `northern_southern_hemisphere_countries`
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES;

-- Create table "northern_southern_hemisphere_countries"
CREATE TABLE [geodatasource].[dbo].[northern_southern_hemisphere_countries](
	[country_code] nvarchar(2) NOT NULL,
	[hemisphere] nvarchar(10) NOT NULL,
	[coverage] nvarchar(10) NOT NULL
) ON [PRIMARY]
GO

CREATE INDEX [idx_country_code] ON [geodatasource].[dbo].[northern_southern_hemisphere_countries]([country_code]) ON [PRIMARY]
GO																	

Single Server License

All prices mentioned in this page are for "Single Server License" unless specified otherwise. "Single Server License" can be used for 1 database server in a commercial environment with single or multiple connected clients.