GeoDataSource™ World Water Features Database Premium Edition

World:

USD $299.95

for 1 month

USD $899.95

for 1 year

Region:

USD $169.95

for 1 month

USD $499.95

for 1 year

GeoDataSource™ World Water Features Database Premium Edition (WAPN) - May 2012 Release

Download Sample (61.67 kB)

Overview

Database of worldwide water features in text format suitable for any applications requiring a comprehensive list of structures and related information such as regions. It is a subset of the GeoDataSource World Waterl Features Database Gold Editions

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 38.98 MB compressed ZIP data file
38.98 MB free disk space for compressed file
155.92 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
STM	Stream	508700	A body of running water moving to a lower level in a channel on land.
STMI	Intermittent stream	105970
LK	Lake	87807	A large inland body of standing water.
WAD	Wadi	69563	A valley or ravine, bounded by relatively steep banks, which in the rainy season becomes a watercourse; found primarily in North Africa and the Middle East.
WLL	Well	53175	A cylindrical hole, pit, or tunnel drilled or dug down to a depth from which water, oil, or gas can be pumped or brought to the surface.
BAY	Bay	33989	A coastal indentation between two capes or headlands, larger than a cove but smaller than a gulf.
SPNG	Spring(s)	28251	A place where ground water flows naturally out of the ground.
RSV	Reservoir(s)	11953	An artificial pond or lake.
COVE	Cove(s)	11884	A small coastal indentation, smaller than a bay.
RF	Reef(s)	11416	A surface-navigation hazard composed of consolidated material.
SHOL	Shoal(s)	9926	A surface-navigation hazard composed of unconsolidated material.
CHNM	Marine channel	7955	That part of a body of water deep enough for navigation through an area otherwise not suitable.
WTRH	Waterhole(s)	7788	A natural hole, hollow, or small depression that contains water, used by man and animals, especially in arid areas.
CNL	Canal	7375	An artificial watercourse.
PND	Pond	6006	A small standing waterbody.
MRSH	Marsh(es)	5965	A wetland dominated by grass-like vegetation.
RVN	Ravine(s)	5389	A small, narrow, deep, steep-sided stream channel, smaller than a gorge.
RSVT	Water tank	5261	A contained pool or tank of water at, below, or above ground level.
FLLS	Waterfall(s)	4395	A perpendicular or very steep descent of the water of a stream.
FJD	Fjord	4282	A long, narrow, steep-walled, deep-water arm of the sea at high latitudes, usually along mountainous coasts.
HBR	Harbor(s)	4263	A haven or space of deep water so sheltered by the adjacent land as to afford a safe anchorage for ships.
INLT	Inlet	4174	A narrow waterway extending into the land, or connecting a bay or lagoon with a larger body of water.
CNLI	Irrigation canal	4074	A canal which serves as a main conduit for irrigation water.
WLLS	Wells	3747	Cylindrical holes, pits, or tunnels drilled or dug down to a depth from which water, oil, or gas can be pumped or brought to the surface.
RPDS	Rapids	3671	A turbulent section of a stream associated with a steep, irregular stream bed.
GLCR	Glacier(s)	3639	A mass of ice, usually at high latitudes or high elevations, with sufficient thickness to flow away from the source area in lobes, tongues, or masses.
CRKT	Tidal creek(s)	3556	A meandering channel in a coastal wetland subject to bi-directional tidal currents.
CHN	Channel	3470	The deepest part of a stream, bay, lagoon, or strait, through which the main current flows.
LGN	Lagoon	3310	A shallow coastal waterbody, completely or partly separated from a larger body of water by a barrier island, coral reef or other depositional feature.
STRT	Strait	3291	A relatively narrow waterway, usually narrower and less extensive than a sound, connecting two larger bodies of water.
SWMP	Swamp	3142	A wetland dominated by tree vegetation.
POOL	Pool(s)	2976	A small and comparatively still, deep part of a larger body of water such as a stream or harbor; or a small body of standing water.
SBKH	Sabkha(s)	2620	A salt flat or salt encrusted plain subject to periodic inundation from flooding or high tides.
DTCH	Ditch	2520	A small artificial watercourse dug for draining or irrigating the land.
CNLSB	Underground irrigation canal(s)	2464	A gently inclined underground tunnel bringing water for irrigation from aquifers.
BNK	Bank(s)	2352	An elevation, typically located on a shelf, over which the depth of water is relatively shallow but sufficient for most surface navigation.
STMD	Distributary(-ies)	2280	A branch which flows away from the main stream, as in a delta or irrigation canal.
LKS	Lakes	2262	Large inland bodies of standing water.
LKI	Intermittent lake	2184
WTLD	Wetland	1865	An area subject to inundation, usually characterized by bog, marsh, or swamp vegetation.
LKN	Salt lake	1789	An inland body of salt water with no outlet.
STMM	Stream mouth(s)	1703	A place where a stream discharges into a lagoon, lake, or the sea.
SMU	Seamount	1660	An elevation rising generally more than 1,000 meters and of limited extent across the summit.
PNDI	Intermittent pond	1600
CNLN	Navigation canal(s)	1579	A watercourse constructed for navigation of vessels.
ANCH	Anchorage	1544	An area where vessels may anchor.
BOG	Bog(s)	1423	A wetland characterized by peat forming sphagnum moss, sedge, and other acid-water plants.
SD	Sound	1392	A long arm of the sea forming a channel between the mainland and an island or islands; or connecting two larger bodies of water.
GULF	Gulf	1272	A large recess in the coastline, larger than a bay.
STMA	Anabranch	1160	A diverging branch flowing out of a main stream and rejoining it downstream.
STMX	Section of stream	1134
BSNU	Basin	971	A depression more or less equidimensional in plan and of variable extent.
CNLD	Drainage canal	909	An artificial waterway carrying water away from a wetland or from drainage ditches.
CNYU	Canyon	873	A relatively narrow, deep depression with steep sides, the bottom of which generally has a continuous slope.
STMC	Canalized stream	860	A stream that has been substantially ditched, diked, or straightened.
SEA	Sea	804	A large body of salt water more or less confined by continuous land or chains of islands forming a subdivision of an ocean.
BGHT	Bight(s)	803	An open body of water forming a slight recession in a coastline.
STMB	Stream bend	798	A conspicuously curved or bent segment of a stream.
BNKU	Bank	721	An elevation, typically located on a shelf, over which the depth of water is relatively shallow but sufficient for safe surface navigation.
RDST	Roadstead	704	An open anchorage affording less protection than a harbor.
RFU	Reef	703	A surface-navigation hazard composed of consolidated material.
WTLDI	Intermittent wetland	686
RDGU	Ridge	680	A long narrow elevation with steep sides.
MOOR	Moor(s)	603	An area of open ground overlaid with wet peaty soils.
LBED	Lake bed(s)	601	A dried up or drained area of a former lake.
FLTT	Tidal flat(s)	563	A large flat area of mud or sand attached to the shore and alternately covered and uncovered by the tide.
FLTM	Mud flat(s)	557	A relatively level area of mud either between high and low tide lines, or subject to flooding.
STMIX	Section of intermittent stream	556
LKX	Section of lake	472
LKO	Oxbow lake	448	A crescent-shaped lake commonly found adjacent to meandering streams.
DCKB	Docking basin	415	A part of a harbor where ships dock.
TRGU	Trough	363	A long depression of the sea floor characteristically flat bottomed and steep sided, and normally shallower than a trench.
VALU	Valley	353	A relatively shallow, wide depression, the bottom of which usually has a continuous gradient.
TMTU	Tablemount (or guyot)	295	A seamount having a comparatively smooth, flat top.
PNDS	Ponds	278	Small standing waterbodies.
SMSU	Seamounts	258	Elevations rising generally more than 1,000 meters and of limited extent across the summit.
STMH	Headwaters	238	The source and upper part of a stream, including the upper drainage basin.
RCH	Reach	236	A straight section of a navigable stream or channel between two bends.
KNLU	Knoll	228	An elevation rising generally more than 500 meters and less than 1,000 meters and of limited extent across the summit.
CHNL	Lake channel(s)	222	That part of a lake having water deep enough for navigation between islands, shoals, etc..
TRNU	Trench	220	A long, narrow, characteristically very deep and asymmetrical depression of the sea floor, with relatively steep sides.
RISU	Rise	219	A broad elevation that rises gently, and generally smoothly, from the sea floor.
WADS	Wadies	191	Valleys or ravines, bounded by relatively steep banks, which in the rainy season become watercourses; found primarily in North Africa and the Middle East.
PLNU	Plain	188	A flat, gently sloping or nearly level region.
FRZU	Fracture zone	187	An extensive linear zone of irregular topography of the sea floor, characterized by steep-sided or asymmetrical ridges, troughs, or escarpments.
PLTU	Plateau	175	A comparatively flat-topped feature of considerable extent, dropping off abruptly on one or more sides.
CHNN	Navigation channel	161	A buoyed channel of sufficient depth for the safe navigation of vessels.
NRWS	Narrows	159	A navigable narrow part of a bay, strait, river, etc..
WLLQ	Abandoned well	159
LKC	Crater lake	155	A lake in a crater or caldera.
MRSHN	Salt marsh	155	A flat area, subject to periodic salt water inundation, dominated by grassy salt-tolerant plants.
WADX	Section of wadi	155
STMSB	Lost river	151	A surface stream that disappears into an underground channel, or dries up in an arid area.
CNLA	Aqueduct	140	A conduit used to carry water.
FISH	Fishing area	133	A fishing ground, bank or area where fishermen go to catch fish.
SHLU	Shoal	132	A surface-navigation hazard composed of unconsolidated material.
SPRU	Spur	127	A subordinate elevation, ridge, or rise projecting outward from a larger feature.
CNLQ	Abandoned canal	122
RFSU	Reefs	119	Surface-navigation hazards composed of consolidated material.
ESCU	Escarpment (or scarp)	117	An elongated and comparatively steep slope separating flat or gently sloping areas.
CAPG	Icecap	115	A dome-shaped mass of glacial ice covering an area of mountain summits or other high lands; smaller than an ice sheet.
WADM	Wadi mouth	103	The lower terminus of a wadi where it widens into an adjoining floodplain, depression, or waterbody.
STMQ	Abandoned watercourse	100	A former stream or distributary no longer carrying flowing water, but still evident due to lakes, wetland, topographic or vegetation patterns.
SCNU	Seachannel	98	A continuously sloping, elongated depression commonly found in fans or plains and customarily bordered by levees on one or two sides.
PNDSF	Fishponds	93	Ponds or enclosures in which fish are kept or raised.
WADJ	Wadi junction	81	A place where two or more wadies join.
LKNI	Intermittent salt lake	70
TERU	Terrace	65	A relatively flat horizontal or gently inclined surface, sometimes long and narrow, which is bounded by a steeper ascending slope on one side and by a steep descending slope on the opposite side.
DTCHI	Irrigation ditch	64	A ditch which serves to distribute irrigation water.
CRNT	Current	63	A horizontal flow of water in a given direction with uniform velocity.
DCK	Dock(s)	62	A waterway between two piers, or cut into the land for the berthing of ships.
ESTY	Estuary	61	A funnel-shaped stream mouth or embayment where fresh water mixes with sea water under tidal influences.
GAPU	Gap	61	A narrow break in a ridge or rise.
OCN	Ocean	61	One of the major divisions of the vast expanse of salt water covering part of the earth.
PNDSI	Intermittent ponds	58
FANU	Fan	57	A relatively smooth feature normally sloping away from the lower termination of a canyon or canyon system.
HLLU	Hill	54	An elevation rising generally less than 500 meters.
CNLX	Section of canal	51
LKSI	Intermittent lakes	49
CNFL	Confluence	48	A place where two or more streams or intermittent streams flow together.
PNDN	Salt pond	44	A small standing body of salt water often in a marsh or swamp, usually along a seacoast.
BKSU	Banks	43	Elevations, typically located on a shelf, over which the depth of water is relatively shallow but sufficient for safe surface navigation.
POOLI	Intermittent pool	43
SPNT	Hot spring(s)	40	A place where hot ground water flows naturally out of the ground.
SLPU	Slope	37	The slope seaward from the shelf edge to the beginning of a continental rise or the point where there is a general reduction in slope.
SYSI	Irrigation system	36	A network of ditches and one or more of the following elements: water supply, reservoir, canal, pump, well, drain, etc..
HOLU	Hole	35	A small depression of the sea floor.
MFGN	Salt evaporation ponds	35	Diked salt ponds used in the production of solar evaporated salt.
CDAU	Cordillera	34	An entire mountain system including the subordinate ranges, interior plateaus, and basins.
MNDU	Mound	33	A low, isolated, rounded hill.
MGV	Mangrove swamp	32	A tropical tidal mud flat characterized by mangrove vegetation.
RFX	Section of reef	31
STMS	Streams	30	Bodies of running water moving to a lower level in a channel on land.
HBRX	Section of harbor	29
LKOI	Intermittent oxbow lake	28
SDLU	Saddle	28	A low part, resembling in shape a saddle, in a ridge or between contiguous seamounts.
FJDS	Fjords	27	Long, narrow, steep-walled, deep-water arms of the sea at high latitudes, usually along mountainous coasts.
SHFU	Shelf	27	A zone adjacent to a continent (or around an island) that extends from the low water line to a depth at which there is usually a marked increase of slope towards oceanic depths.
AIRS	Seaplane landing area	26	A place on a waterbody where floatplanes land and take off.
LKSN	Salt lakes	25	Inland bodies of salt water with no outlet.
RFC	Coral reef(s)	24	A surface-navigation hazard composed of coral.
BNKR	Stream bank	21	A sloping margin of a stream channel which normally confines the stream to its channel on land.
LGNS	Lagoons	17	Shallow coastal waterbodies, completely or partly separated from a larger body of water by a barrier island, coral reef or other depositional feature.
RSVI	Intermittent reservoir	17
BNKX	Section of bank	16
DTCHD	Drainage ditch	16	A ditch which serves to drain the land.
LDGU	Ledge	16	A rocky projection or outcrop, commonly linear and near shore.
CUTF	Cutoff	15	A channel formed as a result of a stream cutting through a meander neck.
DEPU	Deep	15	A localized deep area within the confines of a larger feature, such as a trough, basin or trench.
DOMG	Icecap dome	13	A comparatively elevated area on an icecap.
HLSU	Hills	13	Elevations rising generally less than 500 meters.
KNSU	Knolls	13	Elevations rising generally more than 500 meters and less than 1,000 meters and of limited extent across the summits.
WHRL	Whirlpool	13	A turbulent, rotating movement of water in a stream.
WTRC	Watercourse	13	A natural, well-defined channel produced by flowing water, or an artificial channel designed to carry flowing water.
LGNX	Section of lagoon	12
OVF	Overfalls	12	An area of breaking waves caused by the meeting of currents or by waves moving against the current.
SHSU	Shoals	12	Hazards to surface navigation composed of unconsolidated material.
CNSU	Canyons	11	Relatively narrow, deep depressions with steep sides, the bottom of which generally has a continuous slope.
SCSU	Seachannels	10	Continuously sloping, elongated depressions commonly found in fans or plains and customarily bordered by levees on one or two sides.
SHVU	Shelf valley	10	A valley on the shelf, generally the shoreward extension of a canyon.
SILU	Sill	10	The low part of a gap or saddle separating basins.
BAYS	Bays	8	Coastal indentations between two capes or headlands, larger than a cove but smaller than a gulf.
TMSU	Tablemounts (or guyots)	8	Seamounts having a comparatively smooth, flat top.
GYSR	Geyser	7	A type of hot spring with intermittent eruptions of jets of hot water and steam.
WADB	Wadi bend	7	A conspicuously curved or bent segment of a wadi.
FURU	Furrow	6	A closed, linear, narrow, shallow depression.
PNDSN	Salt ponds	6	Small standing bodies of salt water often in a marsh or swamp, usually along a seacoast.
RDSU	Ridges	6	Long narrow elevations with steep sides.
FLLSX	Section of waterfall(s)	5
TNGU	Tongue	5	An elongate (tongue-like) extension of a flat sea floor into an adjacent higher feature.
APNU	Apron	4	A gentle slope, with a generally smooth surface, particularly found around groups of islands and seamounts.
DTCHM	Ditch mouth(s)	4	An area where a drainage ditch enters a lagoon, lake or bay.
SPNS	Sulphur spring(s)	4	A place where sulphur ground water flows naturally out of the ground.
BDLU	Borderland	3	A region adjacent to a continent, normally occupied by or bordering a shelf, that is highly irregular with depths well in excess of those typical of a shelf.
DPRG	Icecap depression	3	A comparatively depressed area on an icecap.
EDGU	Shelf edge	3	A line along which there is a marked increase of slope at the outer margin of a continental shelf or island shelf.
INLTQ	Former inlet	3	An inlet which has been filled in, or blocked by deposits.
PRVU	Province	3	A region identifiable by a group of similar physiographic features whose characteristics are markedly in contrast with surrounding areas.
CNLB	Canal bend	2	A conspicuously curved or bent section of a canal.
LKSC	Crater lakes	2	Lakes in a crater or caldera.
MOTU	Moat	2	An annular depression that may not be continuous, located at the base of many seamounts, islands, and other isolated elevations.
PKU	Peak	2	A prominent elevation, part of a larger feature, either pointed or of very limited extent across the summit.
PNDNI	Intermittent salt pond(s)	2
ARCU	Arch	1	A low bulge around the southeastern end of the island of Hawaii.
ARRU	Arrugado	1	An area of subdued corrugations off Baja California.
BSND	Drainage basin	1	An area drained by a stream.
CNYN	Canyon	1	A deep, narrow valley with steep sides cutting into a plateau or mountainous area.
FLTU	Flat	1	A small level or nearly level area.
LKSB	Underground lake	1	A standing body of water in a cave.
MESU	Mesa	1	An isolated, extensive, flat-topped elevation on the shelf, with relatively steep sides.
PNLU	Pinnacle	1	A high tower or spire-shaped pillar of rock or coral, alone or cresting a summit.
RDGE	Ridge(s)	1	A long narrow elevation with steep sides, and a more or less continuous crest.
RDGG	Icecap ridge	1	A linear elevation on an icecap.
RK	Rock	1	A conspicuous, isolated rocky mass.
SILL	Sill	1	The low part of an underwater gap or saddle separating basins, including a similar feature at the mouth of a fjord.
TNLC	Canal tunnel	1	A tunnel through which a canal passes.
VLSU	Valleys	1	A relatively shallow, wide depression, the bottom of which usually has a continuous gradient.

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

MySQL Statement

-- Create table "world_water_premium"
CREATE TABLE `world_water_premium`(
	`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),
	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-WATER-PREMIUM.TXT'
INTO TABLE `world_water_premium`
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 "water_feature"
CREATE TABLE `water_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 `water_feature` VALUES
	('STM', 'Stream'),
	('STMI', 'Intermittent stream'),
	('LK', 'Lake'),
	('WAD', 'Wadi'),
	('WLL', 'Well'),
	('BAY', 'Bay'),
	('SPNG', 'Spring(s)'),
	('RSV', 'Reservoir(s)'),
	('COVE', 'Cove(s)'),
	('RF', 'Reef(s)'),
	('SHOL', 'Shoal(s)'),
	('CHNM', 'Marine channel'),
	('WTRH', 'Waterhole(s)'),
	('CNL', 'Canal'),
	('PND', 'Pond'),
	('MRSH', 'Marsh(es)'),
	('RVN', 'Ravine(s)'),
	('RSVT', 'Water tank'),
	('FLLS', 'Waterfall(s)'),
	('FJD', 'Fjord'),
	('HBR', 'Harbor(s)'),
	('INLT', 'Inlet'),
	('CNLI', 'Irrigation canal'),
	('WLLS', 'Wells'),
	('RPDS', 'Rapids'),
	('GLCR', 'Glacier(s)'),
	('CRKT', 'Tidal creek(s)'),
	('CHN', 'Channel'),
	('LGN', 'Lagoon'),
	('STRT', 'Strait'),
	('SWMP', 'Swamp'),
	('POOL', 'Pool(s)'),
	('SBKH', 'Sabkha(s)'),
	('DTCH', 'Ditch'),
	('CNLSB', 'Underground irrigation canal(s)'),
	('BNK', 'Bank(s)'),
	('STMD', 'Distributary(-ies)'),
	('LKS', 'Lakes'),
	('LKI', 'Intermittent lake'),
	('WTLD', 'Wetland'),
	('LKN', 'Salt lake'),
	('STMM', 'Stream mouth(s)'),
	('SMU', 'Seamount'),
	('PNDI', 'Intermittent pond'),
	('CNLN', 'Navigation canal(s)'),
	('ANCH', 'Anchorage'),
	('BOG', 'Bog(s)'),
	('SD', 'Sound'),
	('GULF', 'Gulf'),
	('STMA', 'Anabranch'),
	('STMX', 'Section of stream'),
	('BSNU', 'Basin'),
	('CNLD', 'Drainage canal'),
	('CNYU', 'Canyon'),
	('STMC', 'Canalized stream'),
	('SEA', 'Sea'),
	('BGHT', 'Bight(s)'),
	('STMB', 'Stream bend'),
	('BNKU', 'Bank'),
	('RDST', 'Roadstead'),
	('RFU', 'Reef'),
	('WTLDI', 'Intermittent wetland'),
	('RDGU', 'Ridge'),
	('MOOR', 'Moor(s)'),
	('LBED', 'Lake bed(s)'),
	('FLTT', 'Tidal flat(s)'),
	('FLTM', 'Mud flat(s)'),
	('STMIX', 'Section of intermittent stream'),
	('LKX', 'Section of lake'),
	('LKO', 'Oxbow lake'),
	('DCKB', 'Docking basin'),
	('TRGU', 'Trough'),
	('VALU', 'Valley'),
	('TMTU', 'Tablemount (or guyot)'),
	('PNDS', 'Ponds'),
	('SMSU', 'Seamounts'),
	('STMH', 'Headwaters'),
	('RCH', 'Reach'),
	('KNLU', 'Knoll'),
	('CHNL', 'Lake channel(s)'),
	('TRNU', 'Trench'),
	('RISU', 'Rise'),
	('WADS', 'Wadies'),
	('PLNU', 'Plain'),
	('FRZU', 'Fracture zone'),
	('PLTU', 'Plateau'),
	('CHNN', 'Navigation channel'),
	('NRWS', 'Narrows'),
	('WLLQ', 'Abandoned well'),
	('LKC', 'Crater lake'),
	('MRSHN', 'Salt marsh'),
	('WADX', 'Section of wadi'),
	('STMSB', 'Lost river'),
	('CNLA', 'Aqueduct'),
	('FISH', 'Fishing area'),
	('SHLU', 'Shoal'),
	('SPRU', 'Spur'),
	('CNLQ', 'Abandoned canal'),
	('RFSU', 'Reefs'),
	('ESCU', 'Escarpment (or scarp)'),
	('CAPG', 'Icecap'),
	('WADM', 'Wadi mouth'),
	('STMQ', 'Abandoned watercourse'),
	('SCNU', 'Seachannel'),
	('PNDSF', 'Fishponds'),
	('WADJ', 'Wadi junction'),
	('LKNI', 'Intermittent salt lake'),
	('TERU', 'Terrace'),
	('DTCHI', 'Irrigation ditch'),
	('CRNT', 'Current'),
	('DCK', 'Dock(s)'),
	('ESTY', 'Estuary'),
	('GAPU', 'Gap'),
	('OCN', 'Ocean'),
	('PNDSI', 'Intermittent ponds'),
	('FANU', 'Fan'),
	('HLLU', 'Hill'),
	('CNLX', 'Section of canal'),
	('LKSI', 'Intermittent lakes'),
	('CNFL', 'Confluence'),
	('PNDN', 'Salt pond'),
	('BKSU', 'Banks'),
	('POOLI', 'Intermittent pool'),
	('SPNT', 'Hot spring(s)'),
	('SLPU', 'Slope'),
	('SYSI', 'Irrigation system'),
	('HOLU', 'Hole'),
	('MFGN', 'Salt evaporation ponds'),
	('CDAU', 'Cordillera'),
	('MNDU', 'Mound'),
	('MGV', 'Mangrove swamp'),
	('RFX', 'Section of reef'),
	('STMS', 'Streams'),
	('HBRX', 'Section of harbor'),
	('LKOI', 'Intermittent oxbow lake'),
	('SDLU', 'Saddle'),
	('FJDS', 'Fjords'),
	('SHFU', 'Shelf'),
	('AIRS', 'Seaplane landing area'),
	('LKSN', 'Salt lakes'),
	('RFC', 'Coral reef(s)'),
	('BNKR', 'Stream bank'),
	('LGNS', 'Lagoons'),
	('RSVI', 'Intermittent reservoir'),
	('BNKX', 'Section of bank'),
	('DTCHD', 'Drainage ditch'),
	('LDGU', 'Ledge'),
	('CUTF', 'Cutoff'),
	('DEPU', 'Deep'),
	('DOMG', 'Icecap dome'),
	('HLSU', 'Hills'),
	('KNSU', 'Knolls'),
	('WHRL', 'Whirlpool'),
	('WTRC', 'Watercourse'),
	('LGNX', 'Section of lagoon'),
	('OVF', 'Overfalls'),
	('SHSU', 'Shoals'),
	('CNSU', 'Canyons'),
	('SCSU', 'Seachannels'),
	('SHVU', 'Shelf valley'),
	('SILU', 'Sill'),
	('BAYS', 'Bays'),
	('TMSU', 'Tablemounts (or guyots)'),
	('GYSR', 'Geyser'),
	('WADB', 'Wadi bend'),
	('FURU', 'Furrow'),
	('PNDSN', 'Salt ponds'),
	('RDSU', 'Ridges'),
	('FLLSX', 'Section of waterfall(s)'),
	('TNGU', 'Tongue'),
	('APNU', 'Apron'),
	('DTCHM', 'Ditch mouth(s)'),
	('SPNS', 'Sulphur spring(s)'),
	('BDLU', 'Borderland'),
	('DPRG', 'Icecap depression'),
	('EDGU', 'Shelf edge'),
	('INLTQ', 'Former inlet'),
	('PRVU', 'Province'),
	('CNLB', 'Canal bend'),
	('LKSC', 'Crater lakes'),
	('MOTU', 'Moat'),
	('PKU', 'Peak'),
	('PNDNI', 'Intermittent salt pond(s)'),
	('ARCU', 'Arch'),
	('ARRU', 'Arrugado'),
	('BSND', 'Drainage basin'),
	('CNYN', 'Canyon'),
	('FLTU', 'Flat'),
	('LKSB', 'Underground lake'),
	('MESU', 'Mesa'),
	('PNLU', 'Pinnacle'),
	('RDGE', 'Ridge(s)'),
	('RDGG', 'Icecap ridge'),
	('RK', 'Rock'),
	('SILL', 'Sill'),
	('TNLC', 'Canal tunnel'),
	('VLSU', 'Valleys');

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.