PDA

View Full Version : Country Codes



Christopher Taverner
03-16-2013, 01:26 PM
Hi there, I have had a little look around to see whether I could locate the answer to my question. however it does elude me.

I notice that when using the mappoint api, countries are represented numerically. Is there a source from which I can get a list of these codes in order to write my own module to substitute the country name for the code... or else a function within Mappoint that will do it for me?

I am using an old version of mappoint (2004) for development purposes and coding in VB6.

Many thanks for any hints!

Eric Frost
03-17-2013, 12:15 PM
Sure! It's in the Help file under GeoCountry Values.

Hope this helps!

Anyone have any thoughts on why they removed Iceland, Georgia, Slovenia, etc? (at the bottom of the list). Not that it's any inconvenience for anything I'm doing right now, but that baffles me.


GeoCountry valuesGeoCountry values identify a country, region, or group of countries.
Applies toMethods: FindAddressResults, GetDemographics, ImportData, ImportTerritories, LinkData, LinkTerritories
Properties: Country (DataSet), Country (StreetAddress)


GeoCountry

Value

Description



geoCountryAlbania

6

Albania



geoCountryArgentina

11

Argentina



geoCountryAustralia

12

Australia



geoCountryAustria

14

Austria



geoCountryBangladesh

23

Bangladesh



geoCountryBelarus

29

Belarus



geoCountryBelgium

21

Belgium



geoCountryBosniaHerzegovina

25

Bosnia and Herzegovina



geoCountryBolivia

26

Bolivia



geoCountryBrazil

32

Brazil



geoCountryBulgaria

35

Bulgaria



geoCountryCanada

39

Canada



geoCountryChile

46

Chile



geoCountryChina

45

China



geoCountryColombia

51

Colombia



geoCountryCongo

43

Congo



geoCountryCongoDRC

44

Congo DRC



geoCountryCostaRica

54

Costa Rica



geoCountryCuba

56

Cuba



geoCountryCzechRepublic

75

Czech Republic



geoCountryDefault


LocaleID of the user's computer



geoCountryDenmark

61

Denmark



geoCountryEcuador

66

Ecuador



geoCountryEgypt

67

Egypt



geoCountryElSalvador

72

El Salvador



geoCountryEstonia

70

Estonia



geoCountryFinland

77

Finland



geoCountryFrance

84

France



geoCountryGermany

94

Germany



geoCountryGreece

98

Greece



geoCountryGuatemala

99

Guatemala



geoCountryHonduras

106

Honduras



geoCountryHungary

109

Hungary



geoCountryIndia

113

India



geoCountryIndonesia

111

Indonesia



geoCountryIran

116

Iran



geoCountryIreland

68

Ireland



geoCountryIsrael

117

Israel



geoCountryItaly

118

Italy



geoCountryJapan

122

Japan



geoCountryLatvia

140

Latvia



geoCountryLiechtenstein

145

Liechtenstein



geoCountryLithuania

141

Lithuania



geoCountryLuxembourg

147

Luxembourg



geoCountryMalaysia

167

Malaysia



geoCountryMexico

166

Mexico



geoCountryMontenegro

270

Montenegro



geoCountryMultiCountry

39070

Multiple countries or countries that do not have a GeoCountry constant



geoCountryNewZealand

183

New Zealand



geoCountryNicaragua

182

Nicaragua



geoCountryNorthKorea

131

North Korea



geoCountryNorway

177

Norway



geoCountryPakistan

190

Pakistan



geoCountryPanama

192

Panama



geoCountryParaguay

185

Paraguay



geoCountryPeru

187

Peru



geoCountryPoland

191

Poland



geoCountryPuertoRico

202

Puerto Rico



geoCountryPortugal

193

Portugal



geoCountryRomania

200

Romania



geoCountryRussia

203

Russia



geoCountrySerbia

271

Serbia



geoCountrySlovakia

143

Slovakia



geoCountrySouthAfrica

209

South Africa



geoCountrySouthKorea

134

South Korea



geoCountrySpain

217

Spain



geoCountrySuriname

181

Suriname



geoCountrySweden

221

Sweden



geoCountrySwitzerland

223

Switzerland



geoCountryTheNetherlands

176

The Netherlands



geoCountryTurkey

235

Turkey



geoCountryUkraine

241

Ukraine



geoCountryUnitedKingdom

242

United Kingdom



geoCountryUnitedStates

244

United States



geoCountryUruguay

246

Uruguay



geoCountryVenezuela

249

Venezuela



Note The following GeoCountry values have been removed from this version of MapPoint:


geoCountryFrenchGuiana (French Guiana)

geoCountryGeorgia (Georgia)

geoCountryIceland (Iceland)

geoCountrySlovenia (Slovenia)

Christopher Taverner
03-18-2013, 06:50 PM
Many thanks - I had looked through the help files but obviously missed the page! This will save me a huge amount of time :)

Eric Frost
03-19-2013, 07:51 AM
Great, glad to help!

By the way, I was curious what a map of this might look like and here's what I came up with --

http://www.mp2kmag.com/ac/images/MapPointCountryCodes.png

Here's the zipped up PTM file (http://www.mp2kmag.com/ac/images/MapPointCountryCodes.zip) (MapPoint 2013 North America).

Eric

Christopher Taverner
03-20-2013, 12:19 PM
Great, glad to help!

By the way, I was curious what a map of this might look like and here's what I came up with --

http://www.mp2kmag.com/ac/images/MapPointCountryCodes.png

Here's the zipped up PTM file (http://www.mp2kmag.com/ac/images/MapPointCountryCodes.zip) (MapPoint 2013 North America).

Eric

That's actually really good! I am using the European maps but I imagine the routine would still work happily.

All the best

C

Eric Frost
03-20-2013, 12:48 PM
I just pasted the table above into Excel, did some minor cleanup and then imported using the Import Data Wizard specifying the columns as Data, Name, and County. Then since I'm using MapPoint 2013, there is the Show Name option when you right-click on the layer in the Legend to show the single line Name balloon.