GeoDataSource™ World Land Features Database Gold Edition

World:

USD $499.95

for 1 month

USD $1449.95

for 1 year

Region:

USD $249.95

for 1 month

USD $749.95

for 1 year

GeoDataSource™ World Land Features Database Gold Edition (WAGN) - May 2012 Release

Download Sample (80.47 kB)

Overview

Database of worldwide land features in text format suitable for any applications requiring a comprehensive list of structures and related information such as regions.

Advantages

Free and Updated Monthly
Multiple Subscriptions Packages Available
Discounted Subscriptions Pricing Available
Most Accurate and Up-to-Date Source of Data
Comprehensive List of Cities and Related Items (2,493,572 Entries)
Support Worldwide 260+ Countries, Territories and Sovereign Lands
Instant Download Upon Subscription
Free Customer Support
Many Happy Customers

Requirements

Internet connection capable of downloading 51.25 MB compressed ZIP data file
51.25 MB free disk space for compressed file
204.99 MB free disk space for uncompressed data files
WinZIP or other similar archive extraction utility
SQL Server, Oracle, MySQL, PostgreSQL or other database software application capable of importing 2,493,572 records from a standard tab-delimited ASCII text file and sufficient disk space to import the database

Features

Code	Feature Name	Total Entries	Description
MT	Mountain	260745	An elevation standing high above the surrounding area with small summit area, steep slopes and local relief of 300m or more.
HLL	Hill	176477	A rounded elevation of limited extent rising above the surrounding land with local relief of less than 300m.
ISL	Island	118846	A tract of land, smaller than a continent, surrounded by water at high water.
LCTY	Locality	101524	A minor area or place of unspecified or mixed character and indefinite boundaries.
PT	Point	65110	A tapering piece of land projecting into a body of water, less prominent than a cape.
AREA	Area	34936	A tract of land without homogeneous character or boundaries.
PK	Peak	28588	A pointed elevation atop a mountain, ridge, or other hypsographic feature.
MTS	Mountains	27591	A mountain range or a group of mountains or high ridges.
PASS	Pass	26117	A break in a mountain range or other high obstruction, used for transportation from one side to the other [See also gap].
RDGE	Ridge(s)	20208	A long narrow elevation with steep sides, and a more or less continuous crest.
CAPE	Cape	19000	A land area, more prominent than a point, projecting into the sea and marking a notable change in coastal direction.
RK	Rock	16918	A conspicuous, isolated rocky mass.
HLLS	Hills	15870	Rounded elevations of limited extent rising above the surrounding land with local relief of less than 300m.
ISLS	Islands	11673	Tracts of land, smaller than a continent, surrounded by water at high water.
PLN	Plain(s)	11381	An extensive area of comparatively level to gently undulating land, lacking surface irregularities, and usually adjacent to a higher area.
VAL	Valley	10838	An elongated depression usually traversed by a stream.
SPUR	Spur(s)	8405	A subordinate ridge projecting outward from a hill, mountain or other elevation.
TRB	Tribal area	8274	A tract of land used by nomadic or other tribes.
SLP	Slope(s)	8078	A surface with a relatively uniform slope angle.
DPR	Depression(s)	8015	A low area surrounded by higher land and usually characterized by interior drainage.
RKS	Rocks	7617	Conspicuous, isolated rocky masses.
DUNE	Dune(s)	7574	A wave form, ridge or star shape feature composed of sand.
PEN	Peninsula	4776	An elongate area of land projecting into a body of water and nearly surrounded by water.
RGN	Region	3858	An area distinguished by one or more observable physical or cultural characteristics.
RESF	Forest reserve	3644	A forested area set aside for preservation or controlled use.
BCH	Beach	3388	A shore zone of coarse unconsolidated sediment that extends from the low-water line to the highest reach of storm waves.
CLF	Cliff(s)	3113	A high, steep to perpendicular slope overlooking a waterbody or lower area.
GRGE	Gorge(s)	2656	A short, narrow, steep-sided section of a stream valley.
UPLD	Upland	2396	An extensive interior region of high land with low to moderate surface relief.
PAN	Pan	2123	A near-level shallow, natural depression or basin, usually containing an intermittent lake, pond, or pool.
PLDR	Polder	2075	An area reclaimed from the sea by diking and draining.
ATOL	Atoll(s)	1960	A ring-shaped coral reef which has closely spaced islands on it encircling a lagoon.
PRK	Park	1919	An area, often of forested land, maintained as a place of beauty, or for recreation.
GRAZ	Grazing area	1891	An area of grasses and shrubs used for grazing.
PLAT	Plateau	1742	An elevated plain with steep slopes on one or more sides, and often with incised streams.
SAND	Sand area	1643	A tract of land covered with sand.
MND	Mound(s)	1513	A low, isolated, rounded hill.
FLD	Field(s)	1383	An open as opposed to wooded area.
HDLD	Headland	1379	A high projection of land extending into a large body of water beyond the line of the coast.
SCRP	Escarpment	1292	A long line of cliffs or steep slopes separating level surfaces above and below.
MESA	Mesa(s)	1250	A flat-topped, isolated elevation with steep slopes on all sides, less extensive than a plateau.
FORD	Ford	1159	A shallow part of a stream which can be crossed on foot or by land vehicle.
ISLX	Section of island	981
AGRC	Agricultural colony	979	A tract of land set aside for agricultural settlement.
TRGD	Interdune trough(s)	951	A long wind-swept trough between parallel longitudinal dunes.
PROM	Promontory(-ies)	936	A bluff or prominent hill overlooking or projecting into a lowland.
OILF	Oilfield	827	An area containing a subterranean store of petroleum of economic value.
VLC	Volcano	804	A conical elevation composed of volcanic materials with a crater at the top.
ISLT	Land-tied island	767	A coastal island connected to the mainland by barrier beaches, levees or dikes.
OAS	Oasis(-es)	712	An area in a desert made productive by the availability of water.
DSRT	Desert	696	A large area with little or no vegetation due to extreme environmental conditions.
SALT	Salt area	685	A shallow basin or flat where salt accumulates after periodic inundation.
RESN	Nature reserve	618	An area reserved for the maintenance of a natural habitat.
KRST	Karst area	583	A distinctive landscape developed on soluble rock such as limestone characterized by sinkholes, caves, disappearing streams, and underground drainage.
SPIT	Spit	580	A narrow, straight or curved continuation of a beach into a waterbody.
PRT	Port	579	A place provided with terminal and transfer facilities for loading and discharging waterborne cargo or passengers, usually located in a harbor.
PKS	Peaks	577	Pointed elevations atop a mountain, ridge, or other hypsographic features.
CONE	Cone(s)	560	A conical landform composed of mud or volcanic material.
RES	Reserve	538	A tract of public land reserved for future use or restricted as to use.
BUTE	Butte(s)	530	A small, isolated, usually flat-topped hill with steep sides.
FLDI	Irrigated field(s)	529	A tract of level or terraced land which is irrigated.
BAR	Bar	504	A shallow ridge or mound of coarse unconsolidated material in a stream channel, at the mouth of a stream, estuary, or lagoon and in the wave-break zone along coasts.
NTK	Nunatak	500	A rock or mountain peak protruding through glacial ice.
CNYN	Canyon	427	A deep, narrow valley with steep sides cutting into a plateau or mountainous area.
SINK	Sinkhole	414	A small crater-shape depression in a karst area.
LAVA	Lava area	375	An area of solidified lava.
GAP	Gap	364	A low place in a ridge, not used for transportation.
CRQ	Cirque	363	A bowl-like hollow partially surrounded by cliffs or steep slopes at the head of a glaciated valley.
ERG	Sandy desert	360	An extensive tract of shifting sand and sand dunes.
SDL	Saddle	318	A broad, open pass crossing a ridge or between hills or mountains.
TRR	Terrace	286	A long, narrow alluvial platform bounded by steeper slopes above and below, usually overlooking a waterbody.
BLOW	Blowout(s)	262	A small depression in sandy terrain, caused by wind erosion.
SBED	Dry stream bed	259	A channel formerly containing the water of a stream.
CRTR	Crater(s)	236	A generally circular saucer or bowl-shaped depression caused by volcanic or meteorite explosive action.
CST	Coast	218	A zone of variable width straddling the shoreline.
CFT	Cleft(s)	192	A deep narrow slot, notch, or groove in a coastal cliff.
RESW	Wildlife reserve	186	A tract of public land reserved for the preservation of wildlife.
MILB	Military base	165	A place used by an army or other armed service for storing arms and supplies, and for accommodating and training troops, a base from which operations can be initiated.
LEV	Levee	151	A natural low embankment bordering a distributary or meandering stream; often built up artificially to control floods.
INDS	Industrial area	149	An area characterized by industrial activity.
GASF	Gasfield	134	An area containing a subterranean store of natural gas of economic value.
HMCK	Hammock(s)	130	A patch of ground, distinct from and slightly above the surrounding plain or wetland. Often occurs in groups.
ISTH	Isthmus	130	A narrow strip of land connecting two larger land masses and bordered by water.
SHOR	Shore	112	A narrow zone bordering a waterbody which covers and uncovers at high and low water, respectively.
SNOW	Snowfield	110	An area of permanent snow and ice forming the accumulation area of a glacier.
CTRB	Business center	107	A place where a number of businesses are located.
NTKS	Nunataks	104	Rocks or mountain peaks protruding through glacial ice.
REG	Stony desert	101	A desert plain characterized by a surface veneer of gravel and stones.
BLHL	Blowhole(s)	97	A hole in coastal rock through which sea water is forced by a rising tide or waves and spurted through an outlet into the air.
RESV	Reservation	87	A tract of land set aside for aboriginal, tribal, or native populations.
TAL	Talus slope	85	A steep concave slope formed by an accumulation of loose rock fragments at the base of a cliff or steep slope.
DLTA	Delta	82	A flat plain formed by alluvial deposits at the mouth of a stream.
HMDA	Rock desert	73	A relatively sand-free, high bedrock plateau in a hot desert, with or without a gravel veneer.
VALS	Valleys	69	Elongated depressions usually traversed by a stream.
CLG	Clearing	65	An area in a forest with trees removed.
FAN	Fan(s)	65	A fan-shaped wedge of coarse alluvium with apex merging with a mountain stream bed and the fan spreading out at a low angle slope onto an adjacent plain.
PANS	Pans	63	A near-level shallow, natural depression or basin, usually containing an intermittent lake, pond, or pool.
FSR	Fissure	60	A crack associated with volcanism.
ISLF	Artificial island	60	An island created by landfill or diking and filling in a wetland, bay, or lagoon.
RESH	Hunting reserve	55	A tract of land used primarily for hunting.
RDGB	Beach ridge	48	A ridge of sand just inland and parallel to the beach, usually in series.
COLF	Coalfield	45	A region in which coal deposits of possible economic value occur.
INTF	Interfluve	42	A relatively undissected upland between adjacent stream valleys.
PENX	Section of peninsula	42
MRN	Moraine	39	A mound, ridge, or other accumulation of glacial till.
VALG	Hanging valley	36	A valley the floor of which is notably higher than the valley or shore to which it leads; most common in areas that have been glaciated.
DEVH	Housing development	26	A tract of land on which many houses of similar design are built according to a development plan.
MNA	Mining area	26	An area of mine sites where minerals and ores are extracted.
BSND	Drainage basin	24	An area drained by a stream.
MVA	Maneuver area	24	A tract of land where military field exercises are carried out.
CLDA	Caldera	22	A depression measuring kilometers across formed by the collapse of a volcanic mountain.
BCHS	Beaches	20	A shore zone of coarse unconsolidated sediment that extends from the low-water line to the highest reach of storm waves.
CUET	Cuesta(s)	17	An asymmetric ridge formed on tilted strata.
DVD	Divide	17	A line separating adjacent drainage basins.
PTS	Points	17	Tapering pieces of land projecting into a body of water, less prominent than a cape.
NVB	Naval base	16	An area used to store supplies, provide barracks for troops and naval personnel, a port for naval vessels, and from which operations are initiated.
RESA	Agricultural reserve	14	A tract of land reserved for agricultural reclamation and/or development.
CNS	Concession area	13	A lease of land by a government for economic development, e.g., mining, forestry.
GVL	Gravel area	13	An area covered with gravel.
CULT	Cultivated area	12	An area under cultivation.
RGNE	Economic region	10	A region of a country established for economic development or for statistical purposes.
VALX	Section of valley	9
ASPH	Asphalt lake	8	A small basin containing naturally occurring asphalt.
PLNX	Section of plain	7
CRQS	Cirques	6	Bowl-like hollows partially surrounded by cliffs or steep slopes at the head of a glaciated valley.
RESP	Palm tree reserve	6	An area of palm trees where use is controlled.
BDLD	Badlands	5	An area characterized by a maze of very closely spaced, deep, narrow, steep-sided ravines, and sharp crests and pinnacles.
BLDR	Boulder field	5	A high altitude or high latitude bare, flat area covered with large angular rocks.
BSNP	Petroleum basin	4	An area underlain by an oil-rich structural basin.
BTL	Battlefield	4	A site of a land battle of historical importance.
CMN	Common	4	A park or pasture for community use.
CRDR	Corridor	4	A strip or area of land having significance as an access way.
ISLM	Mangrove island	4	A mangrove swamp surrounded by a waterbody.
RF	Reef(s)	4	A surface-navigation hazard composed of consolidated material.
RKFL	Rockfall	4	An irregular mass of fallen rock at the base of a cliff or steep slope.
RNGA	Artillery range	4	A tract of land used for artillery firing practice.
RVN	Ravine(s)	4	A small, narrow, deep, steep-sided stream channel, smaller than a gorge.
PEAT	Peat cutting area	3	An area where peat is harvested.
SLID	Slide	3	A mound of earth material, at the base of a slope and the associated scoured area.
BNCH	Bench	2	A long, narrow bedrock platform bounded by steeper slopes above and below, usually overlooking a waterbody.
HLLU	Hill	2	An elevation rising generally less than 500 meters.
LAND	Arctic land	2	A tract of land in the Arctic.
NKM	Meander neck	2	A narrow strip of land between the two limbs of a meander loop at its narrowest point.
LBED	Lake bed(s)	1	A dried up or drained area of a former lake.
PKLT	Parking lot	1	An area used for parking vehicles.
PLATX	Section of plateau	1
QCKS	Quicksand	1	An area where loose sand with water moving through it may become unstable when heavy objects are placed at the surface, causing them to sink.
RSVT	Water tank	1	A contained pool or tank of water at, below, or above ground level.
TRIG	Triangulation station	1	A point on the earth whose position has been determined by triangulation.

Specifications

Field Name	Description	Type	Length
region_code	Region Code. A code that determines the character mapping used in the full name field. 1 = Africa 2 = Americas 3 = Antarctica 4 = Asia 5 = Europe 6 = Oceania	number	1
sub_region_code	Sub-Region Code. A sub division of region code. 1A = Central Africa 1B = Eastern Africa 1C = Indian Ocean 1D = Northern Africa 1E = Southern Africa 1F = Western Africa 2A = Central America 2B = North America 2C = South America 2D = West Indies 3A = Antarctica 3B = Atlantic Ocean 4A = Central Asia 4B = East Asia 4C = Northern Asia 4D = South Asia 4E = South East Asia 4F = South West Asia 5A = Central Europe 5B = Eastern Europe 5C = Northern Europe 5D = South East Europe 5E = South West Europe 5F = Southern Europe 5G = Western Europe 6A = North Pacific Ocean 6B = Pacific 6C = South Pacific Ocean	character	2
ufi	Unique Feature Identifier. A number which uniquely identifies the feature. A feature with multiple names with share a same feature identifier.	number	10
uni	Unique Name Identifier. A number which uniquely identifies a name.	number	10
dsg	Feature Designation Code. A two to five-character code used to identify the type of feature a name is applied to.	character	5
cc_fips	FIPS 10-4 Primary Country Code. A two alphabetic character FIPS 10-4 Primary Country Code uniquely identifying a geopolitical entity (countries, dependencies, and areas of special sovereignty).	character	2
cc_iso	ISO 3166 Primary Country Code. A two alphabetic character ISO 3166 Primary Country Code uniquely identifying a geopolitical entity (countries, dependencies, and areas of special sovereignty).	character	5
full_name	Feature's Full Name. The full name is a complete name which identifies the named feature. It is comprised of the specific name, generic name, and any articles or prepositions.	character	200
full_name_nd	Feature's No Diacritics Full Name. Same as the full name but the diacritics and special characters are substituted with Roman characters.	character	200
sort_name	Feature's Sort Name. A form of the full name which allows for easy sorting of the name into alpha-numeric sequence. It is comprised of the specific name, generic name, and any articles or prepositions. This field is all upper case with spaces, diacritics, and hyphens removed and numbers are substituted with lower case alphabetic characters.	character	200
adm1_code	First-Order Administrative Division Code. A two alphanumeric character code uniquely identifying a primary administrative division of a country, such as a state in the United States.	character	2
adm1_full_name	First-Order Administrative Division's Full Name. The full name is a complete name which identifies the first-order administrative division. It is comprised of the specific name, generic name, and any articles or prepositions.	character	200
adm1_full_name_nd	First-Order Administrative Division's No Diacritics Full Name. Same as the division's full name but the diacritics and special characters are substituted with Roman characters.	character	200
adm2_code	Second-Order Administrative Division Code. The name of a subdivision of a second-order administrative division, or known as a county in the United States. (US only).	character	2
adm2_full_name	Second-Order Administrative Division's Full Name. The full name is a complete name which identifies the second-order administrative division. It is comprised of the specific name, generic name, and any articles or prepositions. (US only)	character	200
adm2_full_name_nd	Second-Order Administrative Division's No Diacritics Full Name. Same as the division's full name but the diacritics and special characters are substituted with Roman characters. (US only)	character	200
latitude	Latitude in Decimal Degree. Latitude of the feature in ± decimal degrees (WGS84). no sign (+) = North; negative sign (-) = South.	float	10
longitude	Longitude in Decimal Degree. Longitude of the feature in ± decimal degrees (WGS84). no sign (+) = East; negative sign (-) = West.	float	10
dms_latitude	Latitude in Degree Minute Second. Latitude of the feature in ± degrees, minutes, and seconds (WGS84). no sign (+) = North; negative sign (-) = South.	float	10
dms_longitude	Longitude in Degree Minute Second. Longitude of the feature in ± degrees, minutes, and seconds (WGS84). no sign (+) = East; negative sign (-) = West.	float	10
utm	Universal Transverse Mercator. Universal Transverse Mercator coordinate grid reference.	character	4
jog	Joint Operations Graphic. Joint Operations Graphic reference.	character	7

MySQL Statement

-- Create table "world_land_gold"
CREATE TABLE `world_structure_gold`(
	`region_code` INT,
	`sub_region_code` VARCHAR(2),
	`ufi` INT,
	`uni` INT,
	`dsg` CHAR(5),
	`cc_fips` VARCHAR(2),
	`cc_iso` VARCHAR(2),
	`full_name` VARCHAR(200),
	`full_name_nd` VARCHAR(200),
	`sort_name` VARCHAR(200),
	`adm1_code` VARCHAR(2),
	`adm1_full_name` VARCHAR(200),
	`adm1_full_name_nd` VARCHAR(200),
	`adm2_code` VARCHAR(2),
	`adm2_full_name` VARCHAR(200),
	`adm2_full_name_nd` VARCHAR(200),
	`latitude` FLOAT,
	`longitude` FLOAT,
	`dms_latitude` FLOAT,
	`dms_longitude` FLOAT,
	`utm` VARCHAR(4),
	`jog` VARCHAR(7),
	INDEX `idx_region_code` (`region_code`),
	INDEX `idx_sub_region_code` (`sub_region_code`),
	INDEX `idx_region` (`region_code`,`sub_region_code`),
	INDEX `idx_cc_iso` (`cc_iso`),
	INDEX `idx_dsg` (`dsg`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- Load data into table
LOAD DATA LOCAL
INFILE 'GEODATASOURCE-LAND-GOLD.TXT'
INTO TABLE `world_land_gold`
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES;

-- Create table "country"
CREATE TABLE `country`(
	`cc_fips` VARCHAR(2),
	`cc_iso` VARCHAR(2),
	`tld` VARCHAR(3),
	`country_name` VARCHAR(100),
	INDEX `idx_cc_fips`(`cc_fips`),
	INDEX `idx_cc_iso`(`cc_iso`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- Insert country data
INSERT INTO `country` VALUES
	('AA', 'AW', '.aw', 'Aruba'),
	('AC', 'AG', '.ag', 'Antigua and Barbuda'),
	('AE', 'AE', '.ae', 'United Arab Emirates'),
	('AF', 'AF', '.af', 'Afghanistan'),
	('AG', 'DZ', '.dz', 'Algeria'),
	('AJ', 'AZ', '.az', 'Azerbaijan'),
	('AL', 'AL', '.al', 'Albania'),
	('AM', 'AM', '.am', 'Armenia'),
	('AN', 'AD', '.ad', 'Andorra'),
	('AO', 'AO', '.ao', 'Angola'),
	('AQ', 'AS', '.as', 'American Samoa'),
	('AR', 'AR', '.ar', 'Argentina'),
	('AS', 'AU', '.au', 'Australia'),
	('AT', '-', '-', 'Ashmore and Cartier Islands'),
	('AU', 'AT', '.at', 'Austria'),
	('AV', 'AI', '.ai', 'Anguilla'),
	('AX', 'AX', '.ax', 'Åland Islands'),
	('AY', 'AQ', '.aq', 'Antarctica'),
	('BA', 'BH', '.bh', 'Bahrain'),
	('BB', 'BB', '.bb', 'Barbados'),
	('BC', 'BW', '.bw', 'Botswana'),
	('BD', 'BM', '.bm', 'Bermuda'),
	('BE', 'BE', '.be', 'Belgium'),
	('BF', 'BS', '.bs', 'Bahamas, The'),
	('BG', 'BD', '.bd', 'Bangladesh'),
	('BH', 'BZ', '.bz', 'Belize'),
	('BK', 'BA', '.ba', 'Bosnia and Herzegovina'),
	('BL', 'BO', '.bo', 'Bolivia'),
	('BM', 'MM', '.mm', 'Myanmar'),
	('BN', 'BJ', '.bj', 'Benin'),
	('BO', 'BY', '.by', 'Belarus'),
	('BP', 'SB', '.sb', 'Solomon Islands'),
	('BQ', '-', '-', 'Navassa Island'),
	('BR', 'BR', '.br', 'Brazil'),
	('BS', '-', '-', 'Bassas da India'),
	('BT', 'BT', '.bt', 'Bhutan'),
	('BU', 'BG', '.bg', 'Bulgaria'),
	('BV', 'BV', '.bv', 'Bouvet Island'),
	('BX', 'BN', '.bn', 'Brunei'),
	('BY', 'BI', '.bi', 'Burundi'),
	('CA', 'CA', '.ca', 'Canada'),
	('CB', 'KH', '.kh', 'Cambodia'),
	('CD', 'TD', '.td', 'Chad'),
	('CE', 'LK', '.lk', 'Sri Lanka'),
	('CF', 'CG', '.cg', 'Congo, Republic of the'),
	('CG', 'CD', '.cd', 'Congo, Democratic Republic of the'),
	('CH', 'CN', '.cn', 'China'),
	('CI', 'CL', '.cl', 'Chile'),
	('CJ', 'KY', '.ky', 'Cayman Islands'),
	('CK', 'CC', '.cc', 'Cocos (Keeling) Islands'),
	('CM', 'CM', '.cm', 'Cameroon'),
	('CN', 'KM', '.km', 'Comoros'),
	('CO', 'CO', '.co', 'Colombia'),
	('CQ', 'MP', '.mp', 'Northern Mariana Islands'),
	('CR', '-', '-', 'Coral Sea Islands'),
	('CS', 'CR', '.cr', 'Costa Rica'),
	('CT', 'CF', '.cf', 'Central African Republic'),
	('CU', 'CU', '.cu', 'Cuba'),
	('CV', 'CV', '.cv', 'Cape Verde'),
	('CW', 'CK', '.ck', 'Cook Islands'),
	('CY', 'CY', '.cy', 'Cyprus'),
	('DA', 'DK', '.dk', 'Denmark'),
	('DJ', 'DJ', '.dj', 'Djibouti'),
	('DO', 'DM', '.dm', 'Dominica'),
	('DQ', 'UM', '-', 'Jarvis Island'),
	('DR', 'DO', '.do', 'Dominican Republic'),
	('DX', '-', '-', 'Dhekelia Sovereign Base Area'),
	('EC', 'EC', '.ec', 'Ecuador'),
	('EG', 'EG', '.eg', 'Egypt'),
	('EI', 'IE', '.ie', 'Ireland'),
	('EK', 'GQ', '.gq', 'Equatorial Guinea'),
	('EN', 'EE', '.ee', 'Estonia'),
	('ER', 'ER', '.er', 'Eritrea'),
	('ES', 'SV', '.sv', 'El Salvador'),
	('ET', 'ET', '.et', 'Ethiopia'),
	('EU', '-', '-', 'Europa Island'),
	('EZ', 'CZ', '.cz', 'Czech Republic'),
	('FG', 'GF', '.gf', 'French Guiana'),
	('FI', 'FI', '.fi', 'Finland'),
	('FJ', 'FJ', '.fj', 'Fiji'),
	('FK', 'FK', '.fk', 'Falkland Islands (Islas Malvinas)'),
	('FM', 'FM', '.fm', 'Micronesia, Federated States of'),
	('FO', 'FO', '.fo', 'Faroe Islands'),
	('FP', 'PF', '.pf', 'French Polynesia'),
	('FQ', 'UM', '-', 'Baker Island'),
	('FR', 'FR', '.fr', 'France'),
	('FS', 'TF', '.tf', 'French Southern and Antarctic Lands'),
	('GA', 'GM', '.gm', 'Gambia, The'),
	('GB', 'GA', '.ga', 'Gabon'),
	('GG', 'GE', '.ge', 'Georgia'),
	('GH', 'GH', '.gh', 'Ghana'),
	('GI', 'GI', '.gi', 'Gibraltar'),
	('GJ', 'GD', '.gd', 'Grenada'),
	('GK', '-', '.gg', 'Guernsey'),
	('GL', 'GL', '.gl', 'Greenland'),
	('GM', 'DE', '.de', 'Germany'),
	('GO', '-', '-', 'Glorioso Islands'),
	('GP', 'GP', '.gp', 'Guadeloupe'),
	('GQ', 'GU', '.gu', 'Guam'),
	('GR', 'GR', '.gr', 'Greece'),
	('GT', 'GT', '.gt', 'Guatemala'),
	('GV', 'GN', '.gn', 'Guinea'),
	('GY', 'GY', '.gy', 'Guyana'),
	('GZ', '-', '-', 'Gaza Strip'),
	('HA', 'HT', '.ht', 'Haiti'),
	('HK', 'HK', '.hk', 'Hong Kong'),
	('HM', 'HM', '.hm', 'Heard Island and McDonald Islands'),
	('HO', 'HN', '.hn', 'Honduras'),
	('HQ', 'UM', '-', 'Howland Island'),
	('HR', 'HR', '.hr', 'Croatia'),
	('HU', 'HU', '.hu', 'Hungary'),
	('IC', 'IS', '.is', 'Iceland'),
	('ID', 'ID', '.id', 'Indonesia'),
	('IM', 'IM', '.im', 'Isle of Man'),
	('IN', 'IN', '.in', 'India'),
	('IO', 'IO', '.io', 'British Indian Ocean Territory'),
	('IP', '-', '-', 'Clipperton Island'),
	('IR', 'IR', '.ir', 'Iran'),
	('IS', 'IL', '.il', 'Israel'),
	('IT', 'IT', '.it', 'Italy'),
	('IV', 'CI', '.ci', 'Cote d\'Ivoire'),
	('IZ', 'IQ', '.iq', 'Iraq'),
	('JA', 'JP', '.jp', 'Japan'),
	('JE', 'JE', '.je', 'Jersey'),
	('JM', 'JM', '.jm', 'Jamaica'),
	('JN', 'SJ', '-', 'Jan Mayen'),
	('JO', 'JO', '.jo', 'Jordan'),
	('JQ', 'UM', '-', 'Johnston Atoll'),
	('JU', '-', '-', 'Juan de Nova Island'),
	('KE', 'KE', '.ke', 'Kenya'),
	('KG', 'KG', '.kg', 'Kyrgyzstan'),
	('KN', 'KP', '.kp', 'Korea, North'),
	('KQ', 'UM', '-', 'Kingman Reef'),
	('KR', 'KI', '.ki', 'Kiribati'),
	('KS', 'KR', '.kr', 'Korea, South'),
	('KT', 'CX', '.cx', 'Christmas Island'),
	('KU', 'KW', '.kw', 'Kuwait'),
	('KV', 'KV', '-', 'Kosovo'),
	('KZ', 'KZ', '.kz', 'Kazakhstan'),
	('LA', 'LA', '.la', 'Laos'),
	('LE', 'LB', '.lb', 'Lebanon'),
	('LG', 'LV', '.lv', 'Latvia'),
	('LH', 'LT', '.lt', 'Lithuania'),
	('LI', 'LR', '.lr', 'Liberia'),
	('LO', 'SK', '.sk', 'Slovakia'),
	('LQ', 'UM', '-', 'Palmyra Atoll'),
	('LS', 'LI', '.li', 'Liechtenstein'),
	('LT', 'LS', '.ls', 'Lesotho'),
	('LU', 'LU', '.lu', 'Luxembourg'),
	('LY', 'LY', '.ly', 'Libyan Arab'),
	('MA', 'MG', '.mg', 'Madagascar'),
	('MB', 'MQ', '.mq', 'Martinique'),
	('MC', 'MO', '.mo', 'Macau'),
	('MD', 'MD', '.md', 'Moldova, Republic of'),
	('MF', 'YT', '.yt', 'Mayotte'),
	('MG', 'MN', '.mn', 'Mongolia'),
	('MH', 'MS', '.ms', 'Montserrat'),
	('MI', 'MW', '.mw', 'Malawi'),
	('MJ', 'ME', '.me', 'Montenegro'),
	('MK', 'MK', '.mk', 'The Former Yugoslav Republic of Macedonia'),
	('ML', 'ML', '.ml', 'Mali'),
	('MN', 'MC', '.mc', 'Monaco'),
	('MO', 'MA', '.ma', 'Morocco'),
	('MP', 'MU', '.mu', 'Mauritius'),
	('MQ', 'UM', '-', 'Midway Islands'),
	('MR', 'MR', '.mr', 'Mauritania'),
	('MT', 'MT', '.mt', 'Malta'),
	('MU', 'OM', '.om', 'Oman'),
	('MV', 'MV', '.mv', 'Maldives'),
	('MX', 'MX', '.mx', 'Mexico'),
	('MY', 'MY', '.my', 'Malaysia'),
	('MZ', 'MZ', '.mz', 'Mozambique'),
	('NC', 'NC', '.nc', 'New Caledonia'),
	('NE', 'NU', '.nu', 'Niue'),
	('NF', 'NF', '.nf', 'Norfolk Island'),
	('NG', 'NE', '.ne', 'Niger'),
	('NH', 'VU', '.vu', 'Vanuatu'),
	('NI', 'NG', '.ng', 'Nigeria'),
	('NL', 'NL', '.nl', 'Netherlands'),
	('NM', '', '', 'No Man\'s Land'),
	('NO', 'NO', '.no', 'Norway'),
	('NP', 'NP', '.np', 'Nepal'),
	('NR', 'NR', '.nr', 'Nauru'),
	('NS', 'SR', '.sr', 'Suriname'),
	('NT', 'AN', '.an', 'Netherlands Antilles'),
	('NU', 'NI', '.ni', 'Nicaragua'),
	('NZ', 'NZ', '.nz', 'New Zealand'),
	('PA', 'PY', '.py', 'Paraguay'),
	('PC', 'PN', '.pn', 'Pitcairn Islands'),
	('PE', 'PE', '.pe', 'Peru'),
	('PF', '-', '-', 'Paracel Islands'),
	('PG', '-', '-', 'Spratly Islands'),
	('PK', 'PK', '.pk', 'Pakistan'),
	('PL', 'PL', '.pl', 'Poland'),
	('PM', 'PA', '.pa', 'Panama'),
	('PO', 'PT', '.pt', 'Portugal'),
	('PP', 'PG', '.pg', 'Papua New Guinea'),
	('PS', 'PW', '.pw', 'Palau'),
	('PU', 'GW', '.gw', 'Guinea-Bissau'),
	('QA', 'QA', '.qa', 'Qatar'),
	('RE', 'RE', '.re', 'Reunion'),
	('RI', 'RS', '.rs', 'Serbia'),
	('RM', 'MH', '.mh', 'Marshall Islands'),
	('RN', 'MF', '-', 'Saint Martin'),
	('RO', 'RO', '.ro', 'Romania'),
	('RP', 'PH', '.ph', 'Philippines'),
	('RQ', 'PR', '.pr', 'Puerto Rico'),
	('RS', 'RU', '.ru', 'Russia'),
	('RW', 'RW', '.rw', 'Rwanda'),
	('SA', 'SA', '.sa', 'Saudi Arabia'),
	('SB', 'PM', '.pm', 'Saint Pierre and Miquelon'),
	('SC', 'KN', '.kn', 'Saint Kitts and Nevis'),
	('SE', 'SC', '.sc', 'Seychelles'),
	('SF', 'ZA', '.za', 'South Africa'),
	('SG', 'SN', '.sn', 'Senegal'),
	('SH', 'SH', '.sh', 'Saint Helena'),
	('SI', 'SI', '.si', 'Slovenia'),
	('SL', 'SL', '.sl', 'Sierra Leone'),
	('SM', 'SM', '.sm', 'San Marino'),
	('SN', 'SG', '.sg', 'Singapore'),
	('SO', 'SO', '.so', 'Somalia'),
	('SP', 'ES', '.es', 'Spain'),
	('ST', 'LC', '.lc', 'Saint Lucia'),
	('SU', 'SD', '.sd', 'Sudan'),
	('SV', 'SJ', '.sj', 'Svalbard'),
	('SW', 'SE', '.se', 'Sweden'),
	('SX', 'GS', '.gs', 'South Georgia and the Islands'),
	('SY', 'SY', '.sy', 'Syrian Arab Republic'),
	('SZ', 'CH', '.ch', 'Switzerland'),
	('TD', 'TT', '.tt', 'Trinidad and Tobago'),
	('TE', '-', '-', 'Tromelin Island'),
	('TH', 'TH', '.th', 'Thailand'),
	('TI', 'TJ', '.tj', 'Tajikistan'),
	('TK', 'TC', '.tc', 'Turks and Caicos Islands'),
	('TL', 'TK', '.tk', 'Tokelau'),
	('TN', 'TO', '.to', 'Tonga'),
	('TO', 'TG', '.tg', 'Togo'),
	('TP', 'ST', '.st', 'Sao Tome and Principe'),
	('TS', 'TN', '.tn', 'Tunisia'),
	('TT', 'TL', '.tl', 'East Timor'),
	('TU', 'TR', '.tr', 'Turkey'),
	('TV', 'TV', '.tv', 'Tuvalu'),
	('TW', 'TW', '.tw', 'Taiwan'),
	('TX', 'TM', '.tm', 'Turkmenistan'),
	('TZ', 'TZ', '.tz', 'Tanzania, United Republic of'),
	('UG', 'UG', '.ug', 'Uganda'),
	('UK', 'GB', '.uk', 'United Kingdom'),
	('UP', 'UA', '.ua', 'Ukraine'),
	('US', 'US', '.us', 'United States'),
	('UV', 'BF', '.bf', 'Burkina Faso'),
	('UY', 'UY', '.uy', 'Uruguay'),
	('UZ', 'UZ', '.uz', 'Uzbekistan'),
	('VC', 'VC', '.vc', 'Saint Vincent and the Grenadines'),
	('VE', 'VE', '.ve', 'Venezuela'),
	('VI', 'VG', '.vg', 'British Virgin Islands'),
	('VM', 'VN', '.vn', 'Vietnam'),
	('VQ', 'VI', '.vi', 'Virgin Islands (US)'),
	('VT', 'VA', '.va', 'Holy See (Vatican City)'),
	('WA', 'NA', '.na', 'Namibia'),
	('WE', '-', '-', 'West Bank'),
	('WF', 'WF', '.wf', 'Wallis and Futuna'),
	('WI', 'EH', '.eh', 'Western Sahara'),
	('WQ', 'UM', '-', 'Wake Island'),
	('WS', 'WS', '.ws', 'Samoa'),
	('WZ', 'SZ', '.sz', 'Swaziland'),
	('YI', 'CS', '.yu', 'Serbia and Montenegro'),
	('YM', 'YE', '.ye', 'Yemen'),
	('ZA', 'ZM', '.zm', 'Zambia'),
	('ZI', 'ZW', '.zw', 'Zimbabwe');

-- Create table "region"
CREATE TABLE `region`(
	`region_code` INT,
	`region_name` VARCHAR(10),
	INDEX `idx_region_code` (`region_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- Insert region data
INSERT INTO `region` VALUES
	(1, 'Africa'),
	(2, 'Americas'),
	(3, 'Antarctica'),
	(4, 'Asia'),
	(5, 'Europe'),
	(6, 'Oceania');

-- Create table "sub_region"
CREATE TABLE `sub_region`(
	`sub_region_code` CHAR(2),
	`sub_region_name` VARCHAR(20),
	INDEX `idx_sub_region_code` (`sub_region_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- Insert sub region data
INSERT INTO `sub_region` VALUES
	('1A', 'Central Africa'),
	('1B', 'Eastern Africa'),
	('1C', 'Indian Ocean'),
	('1D', 'Northern Africa'),
	('1E', 'Southern Africa'),
	('1F', 'Western Africa'),
	('2A', 'Central America'),
	('2B', 'North America'),
	('2C', 'South America'),
	('2D', 'West Indies'),
	('3A', 'Antarctica'),
	('3B', 'Atlantic Ocean'),
	('4A', 'Central Asia'),
	('4B', 'East Asia'),
	('4C', 'Northern Asia'),
	('4D', 'South Asia'),
	('4E', 'South East Asia'),
	('4F', 'South West Asia'),
	('5A', 'Central Europe'),
	('5B', 'Eastern Europe'),
	('5C', 'Northern Europe'),
	('5D', 'South East Europe'),
	('5E', 'South West Europe'),
	('5F', 'Southern Europe'),
	('5G', 'Western Europe'),
	('6A', 'North Pacific Ocean'),
	('6B', 'Pacific'),
	('6C', 'South Pacific Ocean');

-- Create table "land_feature"
CREATE TABLE `land_feature`(
	`feature_code` VARCHAR(10),
	`feature_name` VARCHAR(50),
	INDEX `idx_feature_code` (`feature_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- Insert feature data
INSERT INTO `land_feature` VALUES
	('MT', 'Mountain'),
	('HLL', 'Hill'),
	('ISL', 'Island'),
	('LCTY', 'Locality'),
	('PT', 'Point'),
	('AREA', 'Area'),
	('PK', 'Peak'),
	('MTS', 'Mountains'),
	('PASS', 'Pass'),
	('RDGE', 'Ridge(s)'),
	('CAPE', 'Cape'),
	('RK', 'Rock'),
	('HLLS', 'Hills'),
	('ISLS', 'Islands'),
	('PLN', 'Plain(s)'),
	('VAL', 'Valley'),
	('SPUR', 'Spur(s)'),
	('TRB', 'Tribal area'),
	('SLP', 'Slope(s)'),
	('DPR', 'Depression(s)'),
	('RKS', 'Rocks'),
	('DUNE', 'Dune(s)'),
	('PEN', 'Peninsula'),
	('RGN', 'Region'),
	('RESF', 'Forest reserve'),
	('BCH', 'Beach'),
	('CLF', 'Cliff(s)'),
	('GRGE', 'Gorge(s)'),
	('UPLD', 'Upland'),
	('PAN', 'Pan'),
	('PLDR', 'Polder'),
	('ATOL', 'Atoll(s)'),
	('PRK', 'Park'),
	('GRAZ', 'Grazing area'),
	('PLAT', 'Plateau'),
	('SAND', 'Sand area'),
	('MND', 'Mound(s)'),
	('FLD', 'Field(s)'),
	('HDLD', 'Headland'),
	('SCRP', 'Escarpment'),
	('MESA', 'Mesa(s)'),
	('FORD', 'Ford'),
	('ISLX', 'Section of island'),
	('AGRC', 'Agricultural colony'),
	('TRGD', 'Interdune trough(s)'),
	('PROM', 'Promontory(-ies)'),
	('OILF', 'Oilfield'),
	('VLC', 'Volcano'),
	('ISLT', 'Land-tied island'),
	('OAS', 'Oasis(-es)'),
	('DSRT', 'Desert'),
	('SALT', 'Salt area'),
	('RESN', 'Nature reserve'),
	('KRST', 'Karst area'),
	('SPIT', 'Spit'),
	('PRT', 'Port'),
	('PKS', 'Peaks'),
	('CONE', 'Cone(s)'),
	('RES', 'Reserve'),
	('BUTE', 'Butte(s)'),
	('FLDI', 'Irrigated field(s)'),
	('BAR', 'Bar'),
	('NTK', 'Nunatak'),
	('CNYN', 'Canyon'),
	('SINK', 'Sinkhole'),
	('LAVA', 'Lava area'),
	('GAP', 'Gap'),
	('CRQ', 'Cirque'),
	('ERG', 'Sandy desert'),
	('SDL', 'Saddle'),
	('TRR', 'Terrace'),
	('BLOW', 'Blowout(s)'),
	('SBED', 'Dry stream bed'),
	('CRTR', 'Crater(s)'),
	('CST', 'Coast'),
	('CFT', 'Cleft(s)'),
	('RESW', 'Wildlife reserve'),
	('MILB', 'Military base'),
	('LEV', 'Levee'),
	('INDS', 'Industrial area'),
	('GASF', 'Gasfield'),
	('HMCK', 'Hammock(s)'),
	('ISTH', 'Isthmus'),
	('SHOR', 'Shore'),
	('SNOW', 'Snowfield'),
	('CTRB', 'Business center'),
	('NTKS', 'Nunataks'),
	('REG', 'Stony desert'),
	('BLHL', 'Blowhole(s)'),
	('RESV', 'Reservation'),
	('TAL', 'Talus slope'),
	('DLTA', 'Delta'),
	('HMDA', 'Rock desert'),
	('VALS', 'Valleys'),
	('CLG', 'Clearing'),
	('FAN', 'Fan(s)'),
	('PANS', 'Pans'),
	('FSR', 'Fissure'),
	('ISLF', 'Artificial island'),
	('RESH', 'Hunting reserve'),
	('RDGB', 'Beach ridge'),
	('COLF', 'Coalfield'),
	('INTF', 'Interfluve'),
	('PENX', 'Section of peninsula'),
	('MRN', 'Moraine'),
	('VALG', 'Hanging valley'),
	('DEVH', 'Housing development'),
	('MNA', 'Mining area'),
	('BSND', 'Drainage basin'),
	('MVA', 'Maneuver area'),
	('CLDA', 'Caldera'),
	('BCHS', 'Beaches'),
	('CUET', 'Cuesta(s)'),
	('DVD', 'Divide'),
	('PTS', 'Points'),
	('NVB', 'Naval base'),
	('RESA', 'Agricultural reserve'),
	('CNS', 'Concession area'),
	('GVL', 'Gravel area'),
	('CULT', 'Cultivated area'),
	('RGNE', 'Economic region'),
	('VALX', 'Section of valley'),
	('ASPH', 'Asphalt lake'),
	('PLNX', 'Section of plain'),
	('CRQS', 'Cirques'),
	('RESP', 'Palm tree reserve'),
	('BDLD', 'Badlands'),
	('BLDR', 'Boulder field'),
	('BSNP', 'Petroleum basin'),
	('BTL', 'Battlefield'),
	('CMN', 'Common'),
	('CRDR', 'Corridor'),
	('ISLM', 'Mangrove island'),
	('RF', 'Reef(s)'),
	('RKFL', 'Rockfall'),
	('RNGA', 'Artillery range'),
	('RVN', 'Ravine(s)'),
	('PEAT', 'Peat cutting area'),
	('SLID', 'Slide'),
	('BNCH', 'Bench'),
	('HLLU', 'Hill'),
	('LAND', 'Arctic land'),
	('NKM', 'Meander neck'),
	('LBED', 'Lake bed(s)'),
	('PKLT', 'Parking lot'),
	('PLATX', 'Section of plateau'),
	('QCKS', 'Quicksand'),
	('RSVT', 'Water tank'),
	('TRIG', 'Triangulation station');

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.

Redistribution License
"Redistribution License" is limited, royalty-based licensing for redistribution to end-users of a value-added application, hardware or service. Every "Redistribution License" includes 10 end-user licenses for redistribution. Click here for pricing and order.