Based on geography, the Earth hemispheres can be referred to as any division of the globe into two hemispheres. The most common divisions are through the latitudinal or longitudinal markers in the Eastern Western and the Northern Southern division. Eastern-Western Hemispheres are the halves that lie east or west of the prime meridian and west or east of the 180th meridian whereas Northern-Southern Hemispheres are the halves that lie north or south of the Equator.
The Eastern hemisphere countries are the countries that are located to the east of the prime meridian and west of the 180th meridian like Australia, China and Japan. On the other hand, the Western hemisphere countries are the countries that are located to the west of the prime meridian and east of the 180th meridian like Brazil, Portugal and the United States of America.
GeoDataSource Eastern-Western Hemisphere Countries add-on is a free data that provides a list of countries grouped by eastern and western 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 Eastern-Western Hemisphere Countries add-on.
|country_code||Two-character country code based on ISO 3166.|
|hemisphere||Eastern or Western hemisphere where the country is located.|
Valid value: eastern | western
|coverage||A country falls entirely or mostly in one hemisphere.|
Valid value: entirely | mostly
In order to get the Eastern-Western Hemisphere Countries information, the
eastern_western_hemisphere_countries table can be created and loaded by the following code in MySQL.
-- Create table "eastern_western_hemisphere_countries" CREATE TABLE `eastern_western_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-EASTERN-WESTERN-HEMISPHERE-COUNTRIES.CSV' INTO TABLE `eastern_western_hemisphere_countries` FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' IGNORE 1 LINES;
For more details about the Eastern-Western Hemisphere Countries add-on, you can visit https://www.geodatasource.com/addon/eastern-western-hemisphere-countries to learn more about the information provided.