• Your shopping cart is empty!

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
-- 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																	
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.