Northern-Southern Hemisphere Countries

FREE

A free data that provides list of countries grouped by northern and southern hemisphere. The country code follows the ISO 3166 standard which allow the data to be retrieved easily.

Advantages

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

Requirements

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

Specifications

Field Name	Description	Type	Length
country_code	Two-character country code based on ISO 3166.	character	2
hemisphere	Northern or Southern hemisphere where the country located. Valid value: northern \| southern	character	10
coverage	A country fall entirely or mostly in one hemisphere. Valid value: entirely \| mostly	character	10

SQL Statement

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 ','
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

Licensing

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.