GeoDataSource™ World Structural Features Database Basic Edition

World:

USD $699.95

for 1 month

USD $1999.95

for 1 year

Region:

USD $359.95

for 1 month

USD $999.95

for 1 year

GeoDataSource™ World Structural Features Database Basic Edition (SABN) - May 2012 Release

Download Sample (36.79 kB)

Overview

Database of worldwide man-made structural 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 Structural Features Database Premium and 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 28.5 MB compressed ZIP data file
28.5 MB free disk space for compressed file
113.98 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
FRM	Farm	165980	A tract of land with associated buildings devoted to agriculture.
RSTN	Railroad station	48212	A facility comprising ticket office, platforms, etc. for loading and unloading train passengers and freight.
FRMT	Farmstead	23801	The buildings and adjacent service areas of a farm.
RUIN	Ruin(s)	20137	A destroyed or decayed structure which is no longer functional.
HSE	House(s)	19478	A building used as a human habitation.
EST	Estate(s)	17086	A large commercialized agricultural landholding with associated buildings and other facilities.
RNCH	Ranch(es)	16371	A large farm specializing in extensive grazing of livestock.
SHRN	Shrine	15486	A structure or place memorializing a person or religious concept.
FRMS	Farms	12283	Tracts of land with associated buildings devoted to agriculture.
TMB	Tomb(s)	11572	A structure for interring bodies.
SCH	School	8968	Building(s) where instruction in one or more branches of knowledge takes place.
RSTP	Railroad stop	7118	A place lacking station facilities where trains stop to pick up and unload passengers and freight.
CH	Church	6286	A building for public Christian worship.
AIRF	Airfield	5715	A place on land where aircraft land and take off; no facilities provided for the commercial handling of passengers and cargo.
CMP	Camp(s)	5497	A site occupied by tents, huts, or other shelters for temporary use.
BLDG	Building(s)	5257	A structure built for permanent use, as a house, factory, etc..
TRIG	Triangulation station	5222	A point on the earth whose position has been determined by triangulation.
MN	Mine(s)	4879	A site where mineral ores are extracted from the ground by excavating surface pits and subterranean passages.
HUT	Hut	4557	A small primitive house.
MSSN	Mission	4187	A place characterized by dwellings, school, church, hospital and other facilities operated by a religious group for the purpose of providing charitable services and to propagate religion.
FT	Fort	3761	A defensive structure or earthworks.
HSEC	Country house	3660	A large house, mansion, or chateau, on a large estate.
CMTY	Cemetery	3380	A burial place or ground.
ANS	Ancient site	3269	A place where archeological remains, old structures, or cultural artifacts are located.
RSD	Railroad siding	2927	A short track parallel to and joining the main track.
MSQE	Mosque	2733	A building for public Islamic worship.
MSTY	Monastery	2595	A building and grounds where a community of monks lives in seclusion.
BDG	Bridge	2352	A structure erected across an obstacle such as a stream, road, etc., in order to carry roads, railroads, and pedestrians across.
CAVE	Cave(s)	2338	An underground passageway or chamber, or cavity on the side of a cliff.
HUTS	Huts	1747	Small primitive houses.
MKT	Market	1632	A place where goods are bought and sold at regular intervals.
TMPL	Temple(s)	1482	An edifice dedicated to religious worship.
DAM	Dam	1434	A barrier constructed across a stream to impound water.
HTL	Hotel	1311	A building providing lodging and/or meals for the public.
ESTX	Section of estate	1227
CARN	Cairn	1010	A heap of stones erected as a landmark or for other purposes.
PP	Police post	985	A building in which police are stationed.
ML	Mill(s)	920	A building housing machines for transforming, shaping, finishing, grinding, or extracting products.
CSTL	Castle	918	A large fortified building or set of buildings.
LDNG	Landing	856	A place where boats receive or discharge passengers and freight, but lacking most port facilities.
ESTY	Estuary	837	A funnel-shaped stream mouth or embayment where fresh water mixes with sea water under tidal influences.
AIRP	Airport	764	A place where aircraft regularly land and take off, with runways, navigational aids, and major facilities for the commercial handling of passengers and cargo.
CTRF	Facility center	708	A place where more than one facility is situated.
RSTNQ	Abandoned railroad station	702
SHSE	Storehouse	663	A building for storing goods, especially provisions.
RHSE	Resthouse	657	A structure maintained for the rest and shelter of travelers.
MFG	Factory	626	One or more buildings where goods are manufactured, processed or fabricated.
ESTO	Oil palm plantation	619	An estate specializing in the cultivation of oil palm trees.
ESTR	Rubber plantation	609	An estate which specializes in growing and tapping rubber trees.
GRVE	Grave	547	A burial site.
LTHSE	Lighthouse	545	A distinctive structure exhibiting a major navigation light.
RSRT	Resort	542	A specialized facility for vacation, health, or participation sports activities.
MLSG	Sugar mill	499	A facility where sugar cane is processed into raw sugar.
TOWR	Tower	460	A high conspicuous structure, typically much higher than its diameter.
FRMQ	Abandoned farm	459
HSP	Hospital	425	A building in which sick or injured, especially those confined to bed, are medically treated.
AIRQ	Abandoned airfield	396
BCN	Beacon	377	A fixed artificial navigation mark.
STBL	Stable	327	A building for the shelter and feeding of farm animals, especially horses.
PSTP	Patrol post	324	A post from which patrols are sent out.
MNMT	Monument	318	A commemorative structure or statue.
MNQ	Abandoned mine	287
HLT	Halting place	268	A place where caravans stop for rest.
SPA	Spa	265	A resort area usually developed around a medicinal spring.
ESTT	Tea plantation	262	An estate which specializes in growing tea bushes.
CRRL	Corral(s)	259	A pen or enclosure for confining or capturing animals.
PS	Power station	259	A facility for generating electric power.
BP	Boundary marker	247	A fixture marking a point along a boundary.
CMPLA	Labor camp	244	A camp used by migrant or temporary laborers.
SHPF	Sheepfold	229	A fence or wall enclosure for sheep and other small herd animals.
STNF	Forest station	224	A collection of buildings and facilities for carrying out forest management.
AGRF	Agricultural facility	209	A building and/or tract of land used for improving agriculture.
PSTB	Border post	200	A post or station at an international boundary for the regulation of movement of people and goods.
SCHC	College	200	The grounds and buildings of an institution of higher learning.
CTRR	Religious center	197	A facility where more than one religious activity is carried out, e.g., retreat, school, monastery, worship.
NSY	Nursery(-ies)	195	A place where plants are propagated for transplanting or grafting.
GHSE	Guest house	191	A house used to provide lodging for paying guests.
ASTR	Astronomical station	181	A point on the earth whose position has been determined by observations of celestial bodies.
TNKD	Cattle dipping tank	180	A small artificial pond used for immersing cattle in chemically treated water for disease control.
PIER	Pier	166	A structure built out into navigable water on piles providing berthing for ships and recreation.
CMPRF	Refugee camp	159	A camp used by refugees.
QUAY	Quay	159	A structure of solid construction along a shore or bank which provides berthing for ships and which generally provides cargo handling facilities.
GATE	Gate	153	A controlled access entrance or exit.
COMC	Communication center	150	A facility, including buildings, antennae, towers and electronic equipment for receiving and transmitting information.
GDN	Garden(s)	144	An enclosure for displaying selected plant or animal life.
DARY	Dairy	142	A facility for the processing, sale and distribution of milk or milk products.
PGDA	Pagoda	142	A tower-like storied structure, usually a Buddhist shrine.
ESTSG	Sugar plantation	134	An estate that specializes in growing sugar cane.
TRMO	Oil pipeline terminal	133	A tank farm or loading facility at the end of an oil pipeline.
WHRF	Wharf(-ves)	133	A structure of open rather than solid construction along a shore or a bank which provides berthing for ships and cargo-handling facilities.
BRKS	Barracks	132	A building for lodging military personnel.
MNC	Coal mine(s)	124	A mine where coal is extracted.
MLWTR	Water mill	120	A mill powered by running water.
MLWND	Windmill	114	A mill or water pump powered by wind.
RLG	Religious site	113	An ancient site of significant religious importance.
MLSW	Sawmill	109	A mill where logs or lumber are sawn to specified shapes and sizes.
STNE	Experiment station	106	A facility for carrying out experiments.
USGE	United states government establishment	106	A facility operated by the United States Government in Panama.
MNQR	Quarry(-ies)	105	A surface mine where building stone or gravel and sand, etc. are extracted.
PAL	Palace	105	A large stately house, often a royal or presidential residence.
PSH	Hydroelectric power station	104	A building where electricity is generated from water power.
DIKE	Dike	97	An earth or stone embankment usually constructed for flood or stream control.
PMPO	Oil pumping station	93	A facility for pumping oil through a pipeline.
BRKW	Breakwater	89	A structure erected to break the force of waves at the entrance to a harbor or port.
HSTS	Historical site	86	A place of historical importance.
PRN	Prison	86	A facility for confining prisoners.
CTHSE	Courthouse	84	A building in which courts of law are held.
CVNT	Convent	84	A building where a community of nuns lives in seclusion.
PSTC	Customs post	84	A building at an international boundary where customs and duties are paid on goods.
PYR	Pyramid	82	An ancient massive structure of square ground plan with four triangular faces meeting at a point and used for enclosing tombs.
FY	Ferry	77	A boat or other floating conveyance and terminal facilities regularly used to transport people and vehicles across a waterbody.
FCL	Facility	74	A building or buildings housing a center, institute, foundation, hospital, prison, mission, courthouse, etc..
MNAU	Gold mine(s)	72	A mine where gold ore, or alluvial gold is extracted.
PO	Post office	71	A public building in which mail is received, sorted and distributed.
MFGSG	Sugar refinery	69	A facility for converting raw sugar into refined sugar.
SLCE	Sluice	67	A conduit or passage for carrying off surplus water from a waterbody, usually regulated by means of a sluice gate.
PMPW	Water pumping station	61	A facility for pumping water from a major well or through a pipeline.
CTRCM	Community center	58	A facility for community recreation and other activities.
SQR	Square	58	A broad, open, public area near the center of a town or city.
CMPL	Logging camp	55	A camp used by loggers.
MFGN	Salt evaporation ponds	54	Diked salt ponds used in the production of solar evaporated salt.
SCHA	Agricultural school	53	A school with a curriculum focused on agriculture.
STNR	Radio station	53	A facility for producing and transmitting information by radio waves.
SNTR	Sanatorium	51	A facility where victims of physical or mental disorders are treated.
HSPC	Clinic	49	A medical facility associated with a hospital for outpatients.
STDM	Stadium	49	A structure with an enclosure for athletic games with tiers of seats for spectators.
ADMF	Administrative facility	48	A government building.
LOCK	Lock(s)	48	A basin in a waterway with gates at each end by means of which vessels are passed from one water level to another.
ARCH	Arch	47	A natural or man-made structure in the form of an arch.
MOLE	Mole	47	A massive structure of masonry or large stones serving as a pier or breakwater.
JTY	Jetty	46	A structure built out into the water at a river mouth or harbor entrance to regulate currents and silting.
STNM	Meteorological station	46	A station at which weather elements are recorded.
GOSP	Gas-oil separator plant	45	A facility for separating gas from oil.
MFGPH	Phosphate works	44	A facility for producing fertilizer.
MLSGQ	Former sugar mill	43	A sugar mill no longer used as a sugar mill.
STNC	Coast guard station	43	A facility from which the coast is guarded by armed vessels.
INSM	Military installation	42	A facility for use of and control by armed forces.
OILW	Oil well	42	A well from which oil may be pumped.
CMPMN	Mining camp	40	A camp used by miners.
RSGNL	Railroad signal	38	A signal at the entrance of a particular section of track governing the movement of trains.
AIRB	Airbase	37	An area used to store supplies, provide barracks for air force personnel, hangars and runways for aircraft, and from which operations are initiated.
STNB	Scientific research base	36	A scientific facility used as a base from which research is carried out or monitored.
MNFE	Iron mine(s)	35	A mine where iron ore is extracted.
RECG	Golf course	33	A recreation field where golf is played.
MUS	Museum	32	A building where objects of permanent interest in one or more of the arts and sciences are preserved and exhibited.
OILQ	Abandoned oil well	32
PPQ	Abandoned police post	32
DAMSB	Sub-surface dam	31	A dam put down to bedrock in a sand river.
MAR	Marina	31	A harbor facility for small boats, yachts, etc..
OILR	Oil refinery	31	A facility for converting crude oil into refined petroleum products.
WALL	Wall	31	A thick masonry structure, usually enclosing a field or building, or forming the side of a structure.
HSPL	Leprosarium	28	An asylum or hospital for lepers.
MFGC	Cannery	26	A building where food items are canned.
AIRH	Heliport	24	A place where helicopters land and take off.
CMPO	Oil camp	24	A camp used by oilfield workers.
DCKY	Dockyard	24	A facility for servicing, building, or repairing ships.
DCKD	Dry dock	23	A dock providing support for a vessel, and means for removing the water so that the bottom of the vessel can be exposed.
OBS	Observatory	22	A facility equipped for observation of atmospheric or space phenomena.
WTRW	Waterworks	22	A facility for supplying potable water through a water source and a system of pumps and filtration beds.
CMPQ	Abandoned camp	21
RLGR	Retreat	19	A place of temporary seclusion, especially for religious groups.
VETF	Veterinary facility	19	A building or camp at which veterinary services are available.
MNCU	Copper mine(s)	18	A mine where copper ore is extracted.
RECR	Racetrack	18	A track where races are held.
HERM	Hermitage	17	A secluded residence, usually for religious sects.
CSTM	Customs house	15	A building in a port where customs and duties are paid, and where vessels are entered and cleared.
SCHM	Military school	15	A school at which military science forms the core of the curriculum.
BUR	Burial cave(s)	14	A cave used for human burials.
MNCR	Chrome mine(s)	14	A mine where chrome ore is extracted.
BTYD	Boatyard	13	A waterside facility for servicing, repairing, and building small vessels.
CTRM	Medical center	13	A complex of health care buildings including two or more of the following: hospital, medical school, clinic, pharmacy, doctor's offices, etc..
ITTR	Research institute	12	A facility where research is carried out.
MLM	Ore treatment plant	12	A facility for improving the metal content of ore by concentration.
OBPT	Observation point	12	A wildlife or scenic observation point.
RKRY	Rookery	12	A breeding place of a colony of birds or seals.
WRCK	Wreck	11	The site of the remains of a wrecked vessel.
ZNF	Free trade zone	11	An area, usually a section of a port, where goods may be received and shipped free of customs duty and of most customs regulations.
HSPD	Dispensary	10	A building where medical or dental aid is dispensed.
WEIR	Weir(s)	10	A small dam in a stream, designed to raise the water level or to divert stream flow through a desired channel.
PYRS	Pyramids	9	Ancient massive structures of square ground plan with four triangular faces meeting at a point and used for enclosing tombs.
CTRS	Space center	8	A facility for launching, tracking, or controlling satellites and space vehicles.
DPOF	Fuel depot	7	An area where fuel is stored.
LEPC	Leper colony	7	A settled area inhabited by lepers in relative isolation.
MLO	Olive oil mill	7	A mill where oil is extracted from olives.
MNN	Salt mine(s)	7	A mine from which salt is extracted.
OILT	Tank farm	7	A tract of land occupied by large, cylindrical, metal tanks in which oil or liquid petrochemicals are stored.
MFGB	Brewery	6	One or more buildings where beer is brewed.
PRKGT	Park gate	6	A controlled access to a park.
RSTPQ	Abandoned railroad stop	6
RSV	Reservoir(s)	6	An artificial pond or lake.
ATHF	Athletic field	5	A tract of land used for playing team sports, and athletic track and field events.
BSTN	Baling station	5	A facility for baling agricultural products.
CSNO	Casino	5	A building used for entertainment, especially gambling.
MNPB	Lead mine(s)	5	A mine where lead ore is extracted.
RSVT	Water tank	5	A contained pool or tank of water at, below, or above ground level.
STNW	Whaling station	5	A facility for butchering whales and processing train oil.
MFGQ	Abandoned factory	4
OILJ	Oil pipeline junction	4	A section of an oil pipeline where two or more pipes join together.
PRNJ	Reformatory	4	A facility for confining, training, and reforming young law offenders.
WALLA	Ancient wall	4	The remains of a linear defensive stone structure.
DAMQ	Ruined dam	3	A destroyed or decayed dam which is no longer functional.
FNDY	Foundry	3	A building or works where metal casting is carried out.
MNNI	Nickel mine(s)	3	A mine where nickel ore is extracted.
STNI	Inspection station	3	A station at which vehicles, goods, and people are inspected.
AMTH	Amphitheater	2	An oval or circular structure with rising tiers of seats about a stage or open space.
ASYL	Asylum	2	A facility where the insane are cared for and protected.
MFGCU	Copper works	2	A facility for processing copper ore.
MFGLM	Limekiln	2	A furnace in which limestone is reduced to lime.
NOV	Novitiate	2	A religious house or school where novices are trained.
PRKHQ	Park headquarters	2	A park administrative facility.
PRNQ	Abandoned prison	2
SCHN	Maritime school	2	A school at which maritime sciences form the core of the curriculum.
STPS	Steps	2	Stones or slabs placed for ease in ascending or descending a steep slope.
ZOO	Zoo	2	A zoological garden or park where wild animals are kept for exhibition.
BDGQ	Ruined bridge	1	A destroyed or decayed bridge which is no longer functional.
CTRA	Atomic center	1	A facility where atomic research is carried out.
ESTSL	Sisal plantation	1	An estate that specializes in growing sisal.
MFGM	Munitions plant	1	A factory where ammunition is made.
MNPL	Placer mine(s)	1	A place where heavy metals are concentrated and running water is used to extract them from unconsolidated sediments.
MSSNQ	Abandoned mission	1
OBSR	Radio observatory	1	A facility equipped with an array of antennae for receiving radio waves from space.
SPLY	Spillway	1	A passage or outlet through which surplus water flows over, around or through a dam.
STNS	Satellite station	1	A facility for tracking and communicating with orbiting satellites.

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	10
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

MySQL Statement

-- Create table "world_structural_basic"
CREATE TABLE `world_structural_basic`(
	`region_code` INT,
	`sub_region_code` VARCHAR(2),
	`ufi` INT,
	`uni` INT,
	`dsg` CHAR(10),
	`cc_fips` VARCHAR(2),
	`cc_iso` VARCHAR(2),
	`full_name` VARCHAR(200),
	`full_name_nd` VARCHAR(200),
	`sort_name` 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-STRUCTURAL-BASIC.TXT'
INTO TABLE `world_structural_basic`
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 "structural_feature"
CREATE TABLE `structural_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 `structural_feature` VALUES
	('FRM', 'Farm'),
	('RSTN', 'Railroad station'),
	('FRMT', 'Farmstead'),
	('RUIN', 'Ruin(s)'),
	('HSE', 'House(s)'),
	('EST', 'Estate(s)'),
	('RNCH', 'Ranch(es)'),
	('SHRN', 'Shrine'),
	('FRMS', 'Farms'),
	('TMB', 'Tomb(s)'),
	('SCH', 'School'),
	('RSTP', 'Railroad stop'),
	('CH', 'Church'),
	('AIRF', 'Airfield'),
	('CMP', 'Camp(s)'),
	('BLDG', 'Building(s)'),
	('TRIG', 'Triangulation station'),
	('MN', 'Mine(s)'),
	('HUT', 'Hut'),
	('MSSN', 'Mission'),
	('FT', 'Fort'),
	('HSEC', 'Country house'),
	('CMTY', 'Cemetery'),
	('ANS', 'Ancient site'),
	('RSD', 'Railroad siding'),
	('MSQE', 'Mosque'),
	('MSTY', 'Monastery'),
	('BDG', 'Bridge'),
	('CAVE', 'Cave(s)'),
	('HUTS', 'Huts'),
	('MKT', 'Market'),
	('TMPL', 'Temple(s)'),
	('DAM', 'Dam'),
	('HTL', 'Hotel'),
	('ESTX', 'Section of estate'),
	('CARN', 'Cairn'),
	('PP', 'Police post'),
	('ML', 'Mill(s)'),
	('CSTL', 'Castle'),
	('LDNG', 'Landing'),
	('ESTY', 'Estuary'),
	('AIRP', 'Airport'),
	('CTRF', 'Facility center'),
	('RSTNQ', 'Abandoned railroad station'),
	('SHSE', 'Storehouse'),
	('RHSE', 'Resthouse'),
	('MFG', 'Factory'),
	('ESTO', 'Oil palm plantation'),
	('ESTR', 'Rubber plantation'),
	('GRVE', 'Grave'),
	('LTHSE', 'Lighthouse'),
	('RSRT', 'Resort'),
	('MLSG', 'Sugar mill'),
	('TOWR', 'Tower'),
	('FRMQ', 'Abandoned farm'),
	('HSP', 'Hospital'),
	('AIRQ', 'Abandoned airfield'),
	('BCN', 'Beacon'),
	('STBL', 'Stable'),
	('PSTP', 'Patrol post'),
	('MNMT', 'Monument'),
	('MNQ', 'Abandoned mine'),
	('HLT', 'Halting place'),
	('SPA', 'Spa'),
	('ESTT', 'Tea plantation'),
	('CRRL', 'Corral(s)'),
	('PS', 'Power station'),
	('BP', 'Boundary marker'),
	('CMPLA', 'Labor camp'),
	('SHPF', 'Sheepfold'),
	('STNF', 'Forest station'),
	('AGRF', 'Agricultural facility'),
	('PSTB', 'Border post'),
	('SCHC', 'College'),
	('CTRR', 'Religious center'),
	('NSY', 'Nursery(-ies)'),
	('GHSE', 'Guest house'),
	('ASTR', 'Astronomical station'),
	('TNKD', 'Cattle dipping tank'),
	('PIER', 'Pier'),
	('CMPRF', 'Refugee camp'),
	('QUAY', 'Quay'),
	('GATE', 'Gate'),
	('COMC', 'Communication center'),
	('GDN', 'Garden(s)'),
	('DARY', 'Dairy'),
	('PGDA', 'Pagoda'),
	('ESTSG', 'Sugar plantation'),
	('TRMO', 'Oil pipeline terminal'),
	('WHRF', 'Wharf(-ves)'),
	('BRKS', 'Barracks'),
	('MNC', 'Coal mine(s)'),
	('MLWTR', 'Water mill'),
	('MLWND', 'Windmill'),
	('RLG', 'Religious site'),
	('MLSW', 'Sawmill'),
	('STNE', 'Experiment station'),
	('USGE', 'United states government establishment'),
	('MNQR', 'Quarry(-ies)'),
	('PAL', 'Palace'),
	('PSH', 'Hydroelectric power station'),
	('DIKE', 'Dike'),
	('PMPO', 'Oil pumping station'),
	('BRKW', 'Breakwater'),
	('HSTS', 'Historical site'),
	('PRN', 'Prison'),
	('CTHSE', 'Courthouse'),
	('CVNT', 'Convent'),
	('PSTC', 'Customs post'),
	('PYR', 'Pyramid'),
	('FY', 'Ferry'),
	('FCL', 'Facility'),
	('MNAU', 'Gold mine(s)'),
	('PO', 'Post office'),
	('MFGSG', 'Sugar refinery'),
	('SLCE', 'Sluice'),
	('PMPW', 'Water pumping station'),
	('CTRCM', 'Community center'),
	('SQR', 'Square'),
	('CMPL', 'Logging camp'),
	('MFGN', 'Salt evaporation ponds'),
	('SCHA', 'Agricultural school'),
	('STNR', 'Radio station'),
	('SNTR', 'Sanatorium'),
	('HSPC', 'Clinic'),
	('STDM', 'Stadium'),
	('ADMF', 'Administrative facility'),
	('LOCK', 'Lock(s)'),
	('ARCH', 'Arch'),
	('MOLE', 'Mole'),
	('JTY', 'Jetty'),
	('STNM', 'Meteorological station'),
	('GOSP', 'Gas-oil separator plant'),
	('MFGPH', 'Phosphate works'),
	('MLSGQ', 'Former sugar mill'),
	('STNC', 'Coast guard station'),
	('INSM', 'Military installation'),
	('OILW', 'Oil well'),
	('CMPMN', 'Mining camp'),
	('RSGNL', 'Railroad signal'),
	('AIRB', 'Airbase'),
	('STNB', 'Scientific research base'),
	('MNFE', 'Iron mine(s)'),
	('RECG', 'Golf course'),
	('MUS', 'Museum'),
	('OILQ', 'Abandoned oil well'),
	('PPQ', 'Abandoned police post'),
	('DAMSB', 'Sub-surface dam'),
	('MAR', 'Marina'),
	('OILR', 'Oil refinery'),
	('WALL', 'Wall'),
	('HSPL', 'Leprosarium'),
	('MFGC', 'Cannery'),
	('AIRH', 'Heliport'),
	('CMPO', 'Oil camp'),
	('DCKY', 'Dockyard'),
	('DCKD', 'Dry dock'),
	('OBS', 'Observatory'),
	('WTRW', 'Waterworks'),
	('CMPQ', 'Abandoned camp'),
	('RLGR', 'Retreat'),
	('VETF', 'Veterinary facility'),
	('MNCU', 'Copper mine(s)'),
	('RECR', 'Racetrack'),
	('HERM', 'Hermitage'),
	('CSTM', 'Customs house'),
	('SCHM', 'Military school'),
	('BUR', 'Burial cave(s)'),
	('MNCR', 'Chrome mine(s)'),
	('BTYD', 'Boatyard'),
	('CTRM', 'Medical center'),
	('ITTR', 'Research institute'),
	('MLM', 'Ore treatment plant'),
	('OBPT', 'Observation point'),
	('RKRY', 'Rookery'),
	('WRCK', 'Wreck'),
	('ZNF', 'Free trade zone'),
	('HSPD', 'Dispensary'),
	('WEIR', 'Weir(s)'),
	('PYRS', 'Pyramids'),
	('CTRS', 'Space center'),
	('DPOF', 'Fuel depot'),
	('LEPC', 'Leper colony'),
	('MLO', 'Olive oil mill'),
	('MNN', 'Salt mine(s)'),
	('OILT', 'Tank farm'),
	('MFGB', 'Brewery'),
	('PRKGT', 'Park gate'),
	('RSTPQ', 'Abandoned railroad stop'),
	('RSV', 'Reservoir(s)'),
	('ATHF', 'Athletic field'),
	('BSTN', 'Baling station'),
	('CSNO', 'Casino'),
	('MNPB', 'Lead mine(s)'),
	('RSVT', 'Water tank'),
	('STNW', 'Whaling station'),
	('MFGQ', 'Abandoned factory'),
	('OILJ', 'Oil pipeline junction'),
	('PRNJ', 'Reformatory'),
	('WALLA', 'Ancient wall'),
	('DAMQ', 'Ruined dam'),
	('FNDY', 'Foundry'),
	('MNNI', 'Nickel mine(s)'),
	('STNI', 'Inspection station'),
	('AMTH', 'Amphitheater'),
	('ASYL', 'Asylum'),
	('MFGCU', 'Copper works'),
	('MFGLM', 'Limekiln'),
	('NOV', 'Novitiate'),
	('PRKHQ', 'Park headquarters'),
	('PRNQ', 'Abandoned prison'),
	('SCHN', 'Maritime school'),
	('STPS', 'Steps'),
	('ZOO', 'Zoo'),
	('BDGQ', 'Ruined bridge'),
	('CTRA', 'Atomic center'),
	('ESTSL', 'Sisal plantation'),
	('MFGM', 'Munitions plant'),
	('MNPL', 'Placer mine(s)'),
	('MSSNQ', 'Abandoned mission'),
	('OBSR', 'Radio observatory'),
	('SPLY', 'Spillway'),
	('STNS', 'Satellite 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.