Database
World Cities Database
World Major Cities Database
Add-On
- Northern-Southern Hemisphere Countries
- Eastern-Western Hemisphere Countries
- Country Grouping Terminology
- Country Borders
Web Service
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.
- 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
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 |
-- 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