oLDo Posted September 19, 2010 Share Posted September 19, 2010 Hi. I try find list of all country_id and state_id. Unsuccessfully. Can somebody help me? Quote Link to comment
Motorcycle_Mama Posted September 20, 2010 Share Posted September 20, 2010 Where are you trying to find them? Quote Link to comment
+dfx Posted September 20, 2010 Share Posted September 20, 2010 the pocket query page could be used to get them all. not sure what you would use them for though. Quote Link to comment
+donbadabon Posted September 20, 2010 Share Posted September 20, 2010 States: 2,Alaska (AK) 3,Arizona (AZ) 4,Arkansas (AR) 5,California (CA) 6,Colorado (CO) 7,Connecticut (CT) 9,Delaware (DE) 8,District of Columbia (DC) 10,Florida (FL) 11,Georgia (GA) 12,Hawaii (HI) 13,Idaho (ID) 14,Illinois (IL) 15,Indiana (IN) 16,Iowa (IA) 17,Kansas (KS) 18,Kentucky (KY) 19,Louisiana (LA) 20,Maine (ME) 21,Maryland (MD) 22,Massachusetts (MA) 23,Michigan (MI) 24,Minnesota (MN) 25,Mississippi (MS) 26,Missouri (MO) 27,Montana (MT) 28,Nebraska (NE) 29,Nevada (NV) 30,New Hampshire (NH) 31,New Jersey (NJ) 32,New Mexico (NM) 33,New York (NY) 34,North Carolina (NC) 35,North Dakota (ND) 36,Ohio (OH) 37,Oklahoma (OK) 38,Oregon (OR) 39,Pennsylvania (PA) 40,Rhode Island (RI) 41,South Carolina (SC) 42,South Dakota (SD) 43,Tennessee (TN) 44,Texas (TX) 45,Utah (UT) 46,Vermont (VT) 47,Virginia (VA) 48,Washington (WA) 49,West Virginia (WV) 50,Wisconsin (WI) 51,Wyoming (WY) 60,Alabama (AL) Countries: 1,Unknown 2,United States 3,Australia 4,Belgium 5,Canada 6,Chile 7,Ireland 8,Luxembourg 9,New Zealand 10,Sweden 11,United Kingdom 12,Afghanistan 13,Antigua and Barbuda 14,Algeria 15,Armenia 16,Andorra 17,Angola 18,Antarctica 19,Argentina 20,Aruba 21,Azerbaijan 23,Bahamas 24,Bangladesh 25,Barbados 26,Benin 27,Bermuda 28,Burxina 29,Bahrain 30,Bhutan 31,Belize 32,Bolivia 33,Botswana 34,Brazil 35,Burundi 36,Brunei 37,Bulgaria 39,British Virgin Islands 40,Belarus 41,New Caledonia 42,Cambodia 43,Cameroon 44,Cayman Islands 46,Central African Republic 47,China 48,Cook Islands 49,Colombia 50,Comoros 51,Congo 52,Costa Rica 53,Croatia 54,Curacao 55,Cyprus 56,Czech Republic 57,Denmark 58,Djibouti 59,Dominica 60,Dominican Republic 61,Ecuador 62,Equatorial Guinea 63,Egypt 64,El Salvador 65,Eritrea 66,Estonia 67,Ethiopia 68,Faroe Islands 69,Falkland Islands 70,French Guiana 71,Fiji 72,Finland 73,France 74,French Polynesia 75,Gabon 76,Gambia 77,Guadeloupe 78,Georgia 79,Germany 80,Gibraltar 81,Grenada 82,Greece 83,Greenland 84,Guatemala 85,Guinea-Bissau 86,Guernsey 87,Guyana 89,Haiti 90,Honduras 91,Hong Kong 92,Hungary 93,Iceland 94,India 95,Indonesia 96,Iran 97,Iraq 98,Israel 99,Italy 100,Ivory Coast 101,Jamaica 102,Jersey 103,Jordan 104,Japan 106,Kazakhstan 107,Kenya 108,Kyrgyzstan 109,Kiribati 110,Laos 111,Latvia 112,Libya 113,Lebanon 114,Lesotho 115,Liberia 116,Liechtenstein 117,Lithuania 119,Madagascar 121,Malaysia 122,Martinique 123,Mauritania 124,Maldives 125,Macedonia 127,Mali 128,Malta 129,Malawi 130,Monaco 131,Mongolia 132,Morocco 133,Mozambique 134,Mauritius 135,Montserrat 136,Myanmar 137,Namibia 138,Nauru 140,Nepal 141,Netherlands 142,Nevis and St Kitts 143,Niger 144,Nicaragua 145,Nigeria 146,North Korea 147,Norway 148,Netherlands Antilles 149,Niue 150,Oman 151,Pakistan 152,Panama 153,Peru 154,Philippines 155,Pitcairn Islands 156,Papua New Guinea 157,People Den Rep Yemen 158,Poland 159,Portugal 160,Qatar 161,Reunion 162,Romania 163,Russia 164,Rwanda 165,South Africa 166,Saudi Arabia 167,Senegal 168,Seychelles 169,St Barthelemy 170,St Eustatius 171,Saint Helena 172,St Kitts 173,Saint Lucia 174,St. Martin 175,St Pierre Miquelon 176,Sao Tome and Principe 177,Saint Vincent and the Grenadines 178,Sierra Leone 179,Singapore 180,South Korea 181,Slovenia 182,Slovakia 183,San Marino 184,Solomon Islands 185,Somalia 186,Spain 187,Sri Lanka 188,Sudan 189,Suriname 190,Swaziland 192,Switzerland 193,Syria 194,Taiwan 195,Tajikistan 196,Tanzania 197,Turks and Caicos Islands 198,Thailand 199,Turkmenistan 200,Togo 201,Tonga 202,Trinidad and Tobago 203,Tunisia 204,Turkey 205,Tuvalu 206,United Arab Emirates 207,Ukraine 208,Uganda 210,Uruguay 211,Uzbekistan 212,Vanuatu 213,Vatican City State 214,Venezuela 215,Vietnam 216,Burkina Faso 217,Samoa 218,Wallis And Futuna Islands 220,Yemen 222,Serbia 223,Zaire 224,Zambia 225,Zimbabwe 226,Puerto Rico 227,Austria 228,Mexico 229,Guam 234,Bosnia and Herzegovina 235,US Virgin Islands 236,Northern Mariana Islands 237,Moldova 238,Cuba 239,Cape Verde 240,Marshall Islands 241,Kuwait 242,Micronesia 243,Isle of Man 244,Albania 245,American Samoa 246,Anguilla 247,Bouvet Island 248,British Indian Ocean Territories 249,Chad 250,Christmas Island 251,Cocos (Keeling) Islands 252,East Timor 253,French Southern Territories 254,Ghana 255,Guinea 256,Heard Island And Mcdonald Islands 257,Democratic Republic of the Congo 258,Macau 259,Mayotte 260,Norfolk Island 261,Palau 262,Paraguay 264,Saint Kitts and Nevis 267,South Georgia and Sandwich Islands 268,Svalbard and Jan Mayen 269,Tokelau 270,US Minor Outlying Islands 271,Western Sahara 272,Aland Islands 274,Montenegro 275,Bonaire 276,Palestine Quote Link to comment
+jarchiv Posted February 15, 2020 Share Posted February 15, 2020 Hi, is there an up-to-date list? Thanks. Quote Link to comment
+hzoi Posted February 19, 2020 Share Posted February 19, 2020 (edited) There is now. 1,Unknown 2,United States 3,Australia 4,Belgium 5,Canada 6,Chile 7,Ireland 8,Luxembourg 9,New Zealand 10,Sweden 11,United Kingdom 12,Afghanistan 13,Antigua and Barbuda 14,Algeria 15,Armenia 16,Andorra 17,Angola 18,Antarctica 19,Argentina 20,Aruba 21,Azerbaijan 23,Bahamas 24,Bangladesh 25,Barbados 26,Benin 27,Bermuda 28,Burxina 29,Bahrain 30,Bhutan 31,Belize 32,Bolivia 33,Botswana 34,Brazil 35,Burundi 36,Brunei 37,Bulgaria 39,British Virgin Islands 40,Belarus 41,New Caledonia 42,Cambodia 43,Cameroon 44,Cayman Islands 46,Central African Republic 47,China 48,Cook Islands 49,Colombia 50,Comoros 51,Congo 52,Costa Rica 53,Croatia 54,Curacao 55,Cyprus 56,Czech Republic 57,Denmark 58,Djibouti 59,Dominica 60,Dominican Republic 61,Ecuador 62,Equatorial Guinea 63,Egypt 64,El Salvador 65,Eritrea 66,Estonia 67,Ethiopia 68,Faroe Islands 69,Falkland Islands 70,French Guiana 71,Fiji 72,Finland 73,France 74,French Polynesia 75,Gabon 76,Gambia 77,Guadeloupe 78,Georgia 79,Germany 80,Gibraltar 81,Grenada 82,Greece 83,Greenland 84,Guatemala 85,Guinea-Bissau 86,Guernsey 87,Guyana 89,Haiti 90,Honduras 91,Hong Kong 92,Hungary 93,Iceland 94,India 95,Indonesia 96,Iran 97,Iraq 98,Israel 99,Italy 100,Ivory Coast 101,Jamaica 102,Jersey 103,Jordan 104,Japan 106,Kazakhstan 107,Kenya 108,Kyrgyzstan 109,Kiribati 110,Laos 111,Latvia 112,Libya 113,Lebanon 114,Lesotho 115,Liberia 116,Liechtenstein 117,Lithuania 119,Madagascar 121,Malaysia 122,Martinique 123,Mauritania 124,Maldives 125,Macedonia 127,Mali 128,Malta 129,Malawi 130,Monaco 131,Mongolia 132,Morocco 133,Mozambique 134,Mauritius 135,Montserrat 136,Myanmar 137,Namibia 138,Nauru 140,Nepal 141,Netherlands 142,Nevis and St Kitts 143,Niger 144,Nicaragua 145,Nigeria 146,North Korea 147,Norway 148,Netherlands Antilles 149,Niue 150,Oman 151,Pakistan 152,Panama 153,Peru 154,Philippines 155,Pitcairn Islands 156,Papua New Guinea 157,People Den Rep Yemen 158,Poland 159,Portugal 160,Qatar 161,Reunion 162,Romania 163,Russia 164,Rwanda 165,South Africa 166,Saudi Arabia 167,Senegal 168,Seychelles 169,St Barthelemy 170,St Eustatius 171,Saint Helena 172,St Kitts 173,Saint Lucia 174,St. Martin 175,St Pierre Miquelon 176,Sao Tome and Principe 177,Saint Vincent and the Grenadines 178,Sierra Leone 179,Singapore 180,South Korea 181,Slovenia 182,Slovakia 183,San Marino 184,Solomon Islands 185,Somalia 186,Spain 187,Sri Lanka 188,Sudan 189,Suriname 190,Swaziland 192,Switzerland 193,Syria 194,Taiwan 195,Tajikistan 196,Tanzania 197,Turks and Caicos Islands 198,Thailand 199,Turkmenistan 200,Togo 201,Tonga 202,Trinidad and Tobago 203,Tunisia 204,Turkey 205,Tuvalu 206,United Arab Emirates 207,Ukraine 208,Uganda 210,Uruguay 211,Uzbekistan 212,Vanuatu 213,Vatican City State 214,Venezuela 215,Vietnam 216,Burkina Faso 217,Samoa 218,Wallis And Futuna Islands 220,Yemen 222,Serbia 223,Zaire 224,Zambia 225,Zimbabwe 226,Puerto Rico 227,Austria 228,Mexico 229,Guam 234,Bosnia and Herzegovina 235,US Virgin Islands 236,Northern Mariana Islands 237,Moldova 238,Cuba 239,Cape Verde 240,Marshall Islands 241,Kuwait 242,Micronesia 243,Isle of Man 244,Albania 245,American Samoa 246,Anguilla 247,Bouvet Island 248,British Indian Ocean Territories 249,Chad 250,Christmas Island 251,Cocos (Keeling) Islands 252,East Timor 253,French Southern Territories 254,Ghana 255,Guinea 256,Heard Island And Mcdonald Islands 257,Democratic Republic of the Congo 258,Macau 259,Mayotte 260,Norfolk Island 261,Palau 262,Paraguay 264,Saint Kitts and Nevis 267,South Georgia and Sandwich Islands 268,Svalbard and Jan Mayen 269,Tokelau 270,US Minor Outlying Islands 271,Western Sahara 272,Aland Islands 274,Montenegro 275,Bonaire 276,Palestine I did not check every single number, but I do see that 28, 142, 171, 172, 275, and 277 are no longer assigned. Additionally: 278 South Sudan 279 Bonaire, Bonaire, Sint Eustatius and Saba 280 Sark 281 Sint Maarten edited to add: 172 is also unassigned Edited February 19, 2020 by hzoi Quote Link to comment
+NYPaddleCacher Posted February 21, 2020 Share Posted February 21, 2020 On 2/19/2020 at 6:42 AM, hzoi said: There is now. 1,Unknown 2,United States ... 220,Yemen 222,Serbia 223,Zaire 224,Zambia 225,Zimbabwe 226,Puerto Rico 227,Austria 228,Mexico 229,Guam 234,Bosnia and Herzegovina 235,US Virgin Islands 236,Northern Mariana Islands 237,Moldova ... Curious where this list comes from because ID 223 is for Zaire, a country which hasn't existed since 1997 (it is now the Democratic Republic of the Congo). Quote Link to comment
+HHL Posted February 21, 2020 Share Posted February 21, 2020 (edited) These are the current valid countries (given from API V1): 1;Unknown 10;Sweden 100;Côte d'Ivoire 101;Jamaica 102;Jersey 103;Jordan 104;Japan 106;Kazakhstan 107;Kenya 108;Kyrgyzstan 109;Kiribati 11;United Kingdom 110;Laos 111;Latvia 112;Libya 113;Lebanon 114;Lesotho 115;Liberia 116;Liechtenstein 117;Lithuania 119;Madagascar 12;Afghanistan 121;Malaysia 122;Martinique 123;Mauritania 124;Maldives 125;North Macedonia 127;Mali 128;Malta 129;Malawi 13;Antigua and Barbuda 130;Monaco 131;Mongolia 132;Morocco 133;Mozambique 134;Mauritius 135;Montserrat 136;Myanmar 137;Namibia 138;Nauru 14;Algeria 140;Nepal 141;Netherlands 143;Niger 144;Nicaragua 145;Nigeria 146;North Korea 147;Norway 148;Netherlands Antilles 149;Niue 15;Armenia 150;Oman 151;Pakistan 152;Panama 153;Peru 154;Philippines 155;Pitcairn 156;Papua New Guinea 158;Poland 159;Portugal 16;Andorra 160;Qatar 161;Réunion 162;Romania 163;Russia 164;Rwanda 165;South Africa 166;Saudi Arabia 167;Senegal 168;Seychelles 169;Saint Barthélemy 17;Angola 171;Saint Helena 173;Saint Lucia 174;Saint Martin 175;Saint Pierre and Miquelon 176;Sao Tome and Principe 177;Saint Vincent and the Grenadines 178;Sierra Leone 179;Singapore 18;Antarctica 180;South Korea 181;Slovenia 182;Slovakia 183;San Marino 184;Solomon Islands 185;Somalia 186;Spain 187;Sri Lanka 188;Sudan 189;Suriname 19;Argentina 190;Swaziland 192;Switzerland 193;Syria 194;Taiwan 195;Tajikistan 196;Tanzania 197;Turks and Caicos Islands 198;Thailand 199;Turkmenistan 2;United States 20;Aruba 200;Togo 201;Tonga 202;Trinidad and Tobago 203;Tunisia 204;Turkey 205;Tuvalu 206;United Arab Emirates 207;Ukraine 208;Uganda 21;Azerbaijan 210;Uruguay 211;Uzbekistan 212;Vanuatu 213;Vatican City State 214;Venezuela 215;Vietnam 216;Burkina Faso 217;Samoa 218;Wallis and Futuna Islands 220;Yemen 222;Serbia 224;Zambia 225;Zimbabwe 226;Puerto Rico 227;Austria 228;Mexico 229;Guam 23;Bahamas 234;Bosnia and Herzegovina 235;US Virgin Islands 236;Northern Mariana Islands 237;Moldova 238;Cuba 239;Cabo Verde 24;Bangladesh 240;Marshall Islands 241;Kuwait 242;Micronesia 243;Isle of Man 244;Albania 245;American Samoa 246;Anguilla 247;Bouvet Island 248;British Indian Ocean Territory 249;Chad 25;Barbados 250;Christmas Island 251;Cocos (Keeling) Islands 252;Timor-Leste 253;French Southern and Antarctic Territories 254;Ghana 255;Guinea 256;Heard Island and McDonald Islands 257;Democratic Republic of the Congo 258;Macao 259;Mayotte 26;Benin 260;Norfolk Island 261;Palau 262;Paraguay 264;Saint Kitts and Nevis 267;South Georgia and the South Sandwich Islands 268;Svalbard and Jan Mayen Islands 269;Tokelau 27;Bermuda 270;US Minor Outlying Islands 271;Western Sahara 272;Aland Islands 274;Montenegro 276;Palestine 278;South Sudan 279;Bonaire, Sint Eustatius and Saba 280;Sark 281;Sint Maarten 29;Bahrain 3;Australia 30;Bhutan 31;Belize 32;Bolivia 33;Botswana 34;Brazil 35;Burundi 36;Brunei 37;Bulgaria 39;British Virgin Islands 4;Belgium 40;Belarus 41;New Caledonia 42;Cambodia 43;Cameroon 44;Cayman Islands 46;Central African Republic 47;China 48;Cook Islands 49;Colombia 5;Canada 50;Comoros 51;Congo 52;Costa Rica 53;Croatia 54;Curaçao 55;Cyprus 56;Czechia 57;Denmark 58;Djibouti 59;Dominica 6;Chile 60;Dominican Republic 61;Ecuador 62;Equatorial Guinea 63;Egypt 64;El Salvador 65;Eritrea 66;Estonia 67;Ethiopia 68;Faroe Islands 69;Falkland Islands 7;Ireland 70;French Guiana 71;Fiji 72;Finland 73;France 74;French Polynesia 75;Gabon 76;Gambia 77;Guadeloupe 78;Georgia 79;Germany 8;Luxembourg 80;Gibraltar 81;Grenada 82;Greece 83;Greenland 84;Guatemala 85;Guinea-Bissau 86;Guernsey 87;Guyana 89;Haiti 9;New Zealand 90;Honduras 91;Hong Kong 92;Hungary 93;Iceland 94;India 95;Indonesia 96;Iran 97;Iraq 98;Israel 99;Italy Hans NB: Region IDs are selected with the help of this GSAK macro: https://gsak.net/board/index.php?showtopic=34089&view=findpost&p=257160 NBB: Every resulting search page has a valid list of regions within its source code (go to line 1054 ff). Edited February 21, 2020 by HHL Quote Link to comment
+RDrayerIII Posted July 19 Share Posted July 19 I encountered these codes in a puzzle and was pointed to this discussion to solve it. I assumed this was somewhat common knowledge among geocachers. I like geography so I used it in a puzzle of my own. It was treated like something obscure that would be unknown outside of this discussion. That cannot be true. What is the purpose of these codes? Quote Link to comment
+Hügh Posted July 19 Share Posted July 19 (edited) 3 hours ago, RDrayerIII said: What is the purpose of these codes? "ID numbers" are a good way to identify things, even when other properties may change. For instance, a geocache may get adopted, renamed, have its D/T changed, its coordinates changed, but we can still refer to it as "GC12345" forever. Similarly, countries and regions can change names (recently, Turkey to Türkiye in 2021). You'll notice that the cache editor page reflects this. However, Türkiye is still the same country as Turkey, so remains ID#204 in the database: 3 hours ago, RDrayerIII said: I assumed this was somewhat common knowledge among geocachers ... It was treated like something obscure that would be unknown outside of this discussion. The ID#s are what are stored in Geocaching.com's databases. They're replaced by your country's name for the other country when they appear in the interface. The only place I've seen these ID number is on the Geocaching API. Unless someone was actively involved in working on the API or GSAK scripting, I doubt they'd know about the ID numbers. Edited July 19 by Hügh 1 1 Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.