Based on geography, the Earth hemispheres can be referred to any division of the globe into two hemispheres. The most common divisions are through the latitudinal or longitudinal markers in the Northern Southern and the Eastern Western division. Northern-Southern Hemispheres are the half that lies north or south of the Equator whereas Eastern-Western Hemispheres are the half that lies east or west of the prime meridian and west or east of the 180th meridian.
The Northern hemisphere countries are the countries that are located to the north of the Equator like Canada, Japan and the United States of America. On the other hand, the Southern hemisphere countries are the countries that are located to the south of the Equator like Argentina, New Zealand and South Africa.
GeoDataSource Northern-Southern Hemisphere Countries add-on is a free data that provides a list of countries grouped by northern and southern hemispheres. The country code follows the ISO 3166 standard which allows the data to be retrieved easily. This add-on covers all the officially assigned country codes and allows instant download upon subscription.
Below are the data fields for the Northern-Southern Hemisphere Countries add-on.
|country_code||Two-character country code based on ISO 3166.|
|hemisphere||Northern or Southern hemisphere where the country is located.|
Valid value: northern | southern
|coverage||A country falls entirely or mostly in one hemisphere.|
Valid value: entirely | mostly
In order to get the Northern-Southern Hemisphere Countries information, the
northern_southern_hemisphere_countries table can be created and loaded by the following code in MySQL.
-- 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;
For more details about the Northern-Southern Hemisphere Countries add-on, you can visit https://www.geodatasource.com/addon/northern-southern-hemisphere-countries to learn more about the information provided.