Replace the country table with a static XML countries file
authorTom Hughes <tom@compton.nu>
Fri, 17 Jan 2014 19:25:58 +0000 (19:25 +0000)
committerTom Hughes <tom@compton.nu>
Fri, 17 Jan 2014 19:25:58 +0000 (19:25 +0000)
Storing the countries in the database is overkill, so just use a
copy of the geonames countryInfo data that is loaded into a hash
the first time it is used.

app/models/country.rb [deleted file]
config/countries.xml [new file with mode: 0644]
db/migrate/20140117185510_drop_countries.rb [new file with mode: 0644]
db/structure.sql
lib/country.rb [new file with mode: 0644]
test/unit/country_test.rb [deleted file]

diff --git a/app/models/country.rb b/app/models/country.rb
deleted file mode 100644 (file)
index b7cec2b..0000000
+++ /dev/null
@@ -1,2 +0,0 @@
-class Country < ActiveRecord::Base
-end
diff --git a/config/countries.xml b/config/countries.xml
new file mode 100644 (file)
index 0000000..34082dd
--- /dev/null
@@ -0,0 +1,4753 @@
+<?xml version="1.0" encoding="UTF-8" standalone="no"?>
+<geonames>
+<country>
+<countryCode>AD</countryCode>
+<countryName>Andorra</countryName>
+<isoNumeric>020</isoNumeric>
+<isoAlpha3>AND</isoAlpha3>
+<fipsCode>AN</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Andorra la Vella</capital>
+<areaInSqKm>468.0</areaInSqKm>
+<population>84000</population>
+<currencyCode>EUR</currencyCode>
+<languages>ca</languages>
+<geonameId>3041565</geonameId>
+<west>1.4071867141112762</west>
+<north>42.65604389629997</north>
+<east>1.7865427778319827</east>
+<south>42.42849259876837</south>
+</country>
+<country>
+<countryCode>AE</countryCode>
+<countryName>United Arab Emirates</countryName>
+<isoNumeric>784</isoNumeric>
+<isoAlpha3>ARE</isoAlpha3>
+<fipsCode>AE</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Abu Dhabi</capital>
+<areaInSqKm>82880.0</areaInSqKm>
+<population>4975593</population>
+<currencyCode>AED</currencyCode>
+<languages>ar-AE,fa,en,hi,ur</languages>
+<geonameId>290557</geonameId>
+<west>51.58332824707031</west>
+<north>26.08415985107422</north>
+<east>56.38166046142578</east>
+<south>22.633329391479492</south>
+</country>
+<country>
+<countryCode>AF</countryCode>
+<countryName>Afghanistan</countryName>
+<isoNumeric>004</isoNumeric>
+<isoAlpha3>AFG</isoAlpha3>
+<fipsCode>AF</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Kabul</capital>
+<areaInSqKm>647500.0</areaInSqKm>
+<population>29121286</population>
+<currencyCode>AFN</currencyCode>
+<languages>fa-AF,ps,uz-AF,tk</languages>
+<geonameId>1149361</geonameId>
+<west>60.478443</west>
+<north>38.483418</north>
+<east>74.879448</east>
+<south>29.377472</south>
+</country>
+<country>
+<countryCode>AG</countryCode>
+<countryName>Antigua and Barbuda</countryName>
+<isoNumeric>028</isoNumeric>
+<isoAlpha3>ATG</isoAlpha3>
+<fipsCode>AC</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>St. John's</capital>
+<areaInSqKm>443.0</areaInSqKm>
+<population>86754</population>
+<currencyCode>XCD</currencyCode>
+<languages>en-AG</languages>
+<geonameId>3576396</geonameId>
+<west>-61.906425</west>
+<north>17.729387</north>
+<east>-61.672421</east>
+<south>16.996979</south>
+</country>
+<country>
+<countryCode>AI</countryCode>
+<countryName>Anguilla</countryName>
+<isoNumeric>660</isoNumeric>
+<isoAlpha3>AIA</isoAlpha3>
+<fipsCode>AV</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>The Valley</capital>
+<areaInSqKm>102.0</areaInSqKm>
+<population>13254</population>
+<currencyCode>XCD</currencyCode>
+<languages>en-AI</languages>
+<geonameId>3573511</geonameId>
+<west>-63.172901</west>
+<north>18.283424</north>
+<east>-62.971359</east>
+<south>18.166815</south>
+</country>
+<country>
+<countryCode>AL</countryCode>
+<countryName>Albania</countryName>
+<isoNumeric>008</isoNumeric>
+<isoAlpha3>ALB</isoAlpha3>
+<fipsCode>AL</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Tirana</capital>
+<areaInSqKm>28748.0</areaInSqKm>
+<population>2986952</population>
+<currencyCode>ALL</currencyCode>
+<languages>sq,el</languages>
+<geonameId>783754</geonameId>
+<west>19.293972</west>
+<north>42.665611</north>
+<east>21.068472</east>
+<south>39.648361</south>
+</country>
+<country>
+<countryCode>AM</countryCode>
+<countryName>Armenia</countryName>
+<isoNumeric>051</isoNumeric>
+<isoAlpha3>ARM</isoAlpha3>
+<fipsCode>AM</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Yerevan</capital>
+<areaInSqKm>29800.0</areaInSqKm>
+<population>2968000</population>
+<currencyCode>AMD</currencyCode>
+<languages>hy</languages>
+<geonameId>174982</geonameId>
+<west>43.44978</west>
+<north>41.301834</north>
+<east>46.772435045159995</east>
+<south>38.830528</south>
+</country>
+<country>
+<countryCode>AO</countryCode>
+<countryName>Angola</countryName>
+<isoNumeric>024</isoNumeric>
+<isoAlpha3>AGO</isoAlpha3>
+<fipsCode>AO</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Luanda</capital>
+<areaInSqKm>1246700.0</areaInSqKm>
+<population>13068161</population>
+<currencyCode>AOA</currencyCode>
+<languages>pt-AO</languages>
+<geonameId>3351879</geonameId>
+<west>11.679219</west>
+<north>-4.376826</north>
+<east>24.082119</east>
+<south>-18.042076</south>
+</country>
+<country>
+<countryCode>AQ</countryCode>
+<countryName>Antarctica</countryName>
+<isoNumeric>010</isoNumeric>
+<isoAlpha3>ATA</isoAlpha3>
+<fipsCode>AY</fipsCode>
+<continent>AN</continent>
+<continentName>Antarctica</continentName>
+<capital/>
+<areaInSqKm>1.4E7</areaInSqKm>
+<population>0</population>
+<currencyCode/>
+<languages/>
+<geonameId>6697173</geonameId>
+<west>-179.9999</west>
+<north>-60.515533</north>
+<east>179.9999</east>
+<south>-89.9999</south>
+</country>
+<country>
+<countryCode>AR</countryCode>
+<countryName>Argentina</countryName>
+<isoNumeric>032</isoNumeric>
+<isoAlpha3>ARG</isoAlpha3>
+<fipsCode>AR</fipsCode>
+<continent>SA</continent>
+<continentName>South America</continentName>
+<capital>Buenos Aires</capital>
+<areaInSqKm>2766890.0</areaInSqKm>
+<population>41343201</population>
+<currencyCode>ARS</currencyCode>
+<languages>es-AR,en,it,de,fr,gn</languages>
+<geonameId>3865483</geonameId>
+<west>-73.58297</west>
+<north>-21.781277</north>
+<east>-53.591835</east>
+<south>-55.061314</south>
+</country>
+<country>
+<countryCode>AS</countryCode>
+<countryName>American Samoa</countryName>
+<isoNumeric>016</isoNumeric>
+<isoAlpha3>ASM</isoAlpha3>
+<fipsCode>AQ</fipsCode>
+<continent>OC</continent>
+<continentName>Oceania</continentName>
+<capital>Pago Pago</capital>
+<areaInSqKm>199.0</areaInSqKm>
+<population>57881</population>
+<currencyCode>USD</currencyCode>
+<languages>en-AS,sm,to</languages>
+<geonameId>5880801</geonameId>
+<west>-171.091888</west>
+<north>-11.0497</north>
+<east>-169.416077</east>
+<south>-14.382478</south>
+</country>
+<country>
+<countryCode>AT</countryCode>
+<countryName>Austria</countryName>
+<isoNumeric>040</isoNumeric>
+<isoAlpha3>AUT</isoAlpha3>
+<fipsCode>AU</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Vienna</capital>
+<areaInSqKm>83858.0</areaInSqKm>
+<population>8205000</population>
+<currencyCode>EUR</currencyCode>
+<languages>de-AT,hr,hu,sl</languages>
+<geonameId>2782113</geonameId>
+<west>9.535916</west>
+<north>49.017056</north>
+<east>17.162722</east>
+<south>46.378029</south>
+</country>
+<country>
+<countryCode>AU</countryCode>
+<countryName>Australia</countryName>
+<isoNumeric>036</isoNumeric>
+<isoAlpha3>AUS</isoAlpha3>
+<fipsCode>AS</fipsCode>
+<continent>OC</continent>
+<continentName>Oceania</continentName>
+<capital>Canberra</capital>
+<areaInSqKm>7686850.0</areaInSqKm>
+<population>21515754</population>
+<currencyCode>AUD</currencyCode>
+<languages>en-AU</languages>
+<geonameId>2077456</geonameId>
+<west>112.911057</west>
+<north>-10.062805</north>
+<east>153.639252</east>
+<south>-43.64397</south>
+</country>
+<country>
+<countryCode>AW</countryCode>
+<countryName>Aruba</countryName>
+<isoNumeric>533</isoNumeric>
+<isoAlpha3>ABW</isoAlpha3>
+<fipsCode>AA</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Oranjestad</capital>
+<areaInSqKm>193.0</areaInSqKm>
+<population>71566</population>
+<currencyCode>AWG</currencyCode>
+<languages>nl-AW,es,en</languages>
+<geonameId>3577279</geonameId>
+<west>-70.0644737196045</west>
+<north>12.623718127152925</north>
+<east>-69.86575120104982</east>
+<south>12.411707706190716</south>
+</country>
+<country>
+<countryCode>AX</countryCode>
+<countryName>Åland</countryName>
+<isoNumeric>248</isoNumeric>
+<isoAlpha3>ALA</isoAlpha3>
+<fipsCode/>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Mariehamn</capital>
+<areaInSqKm/>
+<population>26711</population>
+<currencyCode>EUR</currencyCode>
+<languages>sv-AX</languages>
+<geonameId>661882</geonameId>
+<west>19.317694</west>
+<north>60.488861</north>
+<east>21.011862</east>
+<south>59.90675</south>
+</country>
+<country>
+<countryCode>AZ</countryCode>
+<countryName>Azerbaijan</countryName>
+<isoNumeric>031</isoNumeric>
+<isoAlpha3>AZE</isoAlpha3>
+<fipsCode>AJ</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Baku</capital>
+<areaInSqKm>86600.0</areaInSqKm>
+<population>8303512</population>
+<currencyCode>AZN</currencyCode>
+<languages>az,ru,hy</languages>
+<geonameId>587116</geonameId>
+<west>44.774113</west>
+<north>41.90564</north>
+<east>50.370083</east>
+<south>38.38915252685547</south>
+</country>
+<country>
+<countryCode>BA</countryCode>
+<countryName>Bosnia and Herzegovina</countryName>
+<isoNumeric>070</isoNumeric>
+<isoAlpha3>BIH</isoAlpha3>
+<fipsCode>BK</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Sarajevo</capital>
+<areaInSqKm>51129.0</areaInSqKm>
+<population>4590000</population>
+<currencyCode>BAM</currencyCode>
+<languages>bs,hr-BA,sr-BA</languages>
+<geonameId>3277605</geonameId>
+<west>15.718945</west>
+<north>45.239193</north>
+<east>19.622223</east>
+<south>42.546112</south>
+</country>
+<country>
+<countryCode>BB</countryCode>
+<countryName>Barbados</countryName>
+<isoNumeric>052</isoNumeric>
+<isoAlpha3>BRB</isoAlpha3>
+<fipsCode>BB</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Bridgetown</capital>
+<areaInSqKm>431.0</areaInSqKm>
+<population>285653</population>
+<currencyCode>BBD</currencyCode>
+<languages>en-BB</languages>
+<geonameId>3374084</geonameId>
+<west>-59.648922</west>
+<north>13.327257</north>
+<east>-59.420376</east>
+<south>13.039844</south>
+</country>
+<country>
+<countryCode>BD</countryCode>
+<countryName>Bangladesh</countryName>
+<isoNumeric>050</isoNumeric>
+<isoAlpha3>BGD</isoAlpha3>
+<fipsCode>BG</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Dhaka</capital>
+<areaInSqKm>144000.0</areaInSqKm>
+<population>156118464</population>
+<currencyCode>BDT</currencyCode>
+<languages>bn-BD,en</languages>
+<geonameId>1210997</geonameId>
+<west>88.028336</west>
+<north>26.631945</north>
+<east>92.673668</east>
+<south>20.743334</south>
+</country>
+<country>
+<countryCode>BE</countryCode>
+<countryName>Belgium</countryName>
+<isoNumeric>056</isoNumeric>
+<isoAlpha3>BEL</isoAlpha3>
+<fipsCode>BE</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Brussels</capital>
+<areaInSqKm>30510.0</areaInSqKm>
+<population>10403000</population>
+<currencyCode>EUR</currencyCode>
+<languages>nl-BE,fr-BE,de-BE</languages>
+<geonameId>2802361</geonameId>
+<west>2.546944</west>
+<north>51.505444</north>
+<east>6.403861</east>
+<south>49.49361</south>
+</country>
+<country>
+<countryCode>BF</countryCode>
+<countryName>Burkina Faso</countryName>
+<isoNumeric>854</isoNumeric>
+<isoAlpha3>BFA</isoAlpha3>
+<fipsCode>UV</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Ouagadougou</capital>
+<areaInSqKm>274200.0</areaInSqKm>
+<population>16241811</population>
+<currencyCode>XOF</currencyCode>
+<languages>fr-BF</languages>
+<geonameId>2361809</geonameId>
+<west>-5.518916</west>
+<north>15.082593</north>
+<east>2.405395</east>
+<south>9.401108</south>
+</country>
+<country>
+<countryCode>BG</countryCode>
+<countryName>Bulgaria</countryName>
+<isoNumeric>100</isoNumeric>
+<isoAlpha3>BGR</isoAlpha3>
+<fipsCode>BU</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Sofia</capital>
+<areaInSqKm>110910.0</areaInSqKm>
+<population>7148785</population>
+<currencyCode>BGN</currencyCode>
+<languages>bg,tr-BG</languages>
+<geonameId>732800</geonameId>
+<west>22.371166</west>
+<north>44.21764</north>
+<east>28.612167</east>
+<south>41.242084</south>
+</country>
+<country>
+<countryCode>BH</countryCode>
+<countryName>Bahrain</countryName>
+<isoNumeric>048</isoNumeric>
+<isoAlpha3>BHR</isoAlpha3>
+<fipsCode>BA</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Manama</capital>
+<areaInSqKm>665.0</areaInSqKm>
+<population>738004</population>
+<currencyCode>BHD</currencyCode>
+<languages>ar-BH,en,fa,ur</languages>
+<geonameId>290291</geonameId>
+<west>50.45414</west>
+<north>26.282583</north>
+<east>50.664471</east>
+<south>25.796862</south>
+</country>
+<country>
+<countryCode>BI</countryCode>
+<countryName>Burundi</countryName>
+<isoNumeric>108</isoNumeric>
+<isoAlpha3>BDI</isoAlpha3>
+<fipsCode>BY</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Bujumbura</capital>
+<areaInSqKm>27830.0</areaInSqKm>
+<population>9863117</population>
+<currencyCode>BIF</currencyCode>
+<languages>fr-BI,rn</languages>
+<geonameId>433561</geonameId>
+<west>28.993061</west>
+<north>-2.310123</north>
+<east>30.847729</east>
+<south>-4.465713</south>
+</country>
+<country>
+<countryCode>BJ</countryCode>
+<countryName>Benin</countryName>
+<isoNumeric>204</isoNumeric>
+<isoAlpha3>BEN</isoAlpha3>
+<fipsCode>BN</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Porto-Novo</capital>
+<areaInSqKm>112620.0</areaInSqKm>
+<population>9056010</population>
+<currencyCode>XOF</currencyCode>
+<languages>fr-BJ</languages>
+<geonameId>2395170</geonameId>
+<west>0.774575</west>
+<north>12.418347</north>
+<east>3.851701</east>
+<south>6.225748</south>
+</country>
+<country>
+<countryCode>BL</countryCode>
+<countryName>Saint Barthélemy</countryName>
+<isoNumeric>652</isoNumeric>
+<isoAlpha3>BLM</isoAlpha3>
+<fipsCode>TB</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Gustavia</capital>
+<areaInSqKm>21.0</areaInSqKm>
+<population>8450</population>
+<currencyCode>EUR</currencyCode>
+<languages>fr</languages>
+<geonameId>3578476</geonameId>
+<west>-62.8739118253784</west>
+<north>17.928808791949283</north>
+<east>-62.788983372985854</east>
+<south>17.878183227405575</south>
+</country>
+<country>
+<countryCode>BM</countryCode>
+<countryName>Bermuda</countryName>
+<isoNumeric>060</isoNumeric>
+<isoAlpha3>BMU</isoAlpha3>
+<fipsCode>BD</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Hamilton</capital>
+<areaInSqKm>53.0</areaInSqKm>
+<population>65365</population>
+<currencyCode>BMD</currencyCode>
+<languages>en-BM,pt</languages>
+<geonameId>3573345</geonameId>
+<west>-64.89605</west>
+<north>32.393833</north>
+<east>-64.651993</east>
+<south>32.246639</south>
+</country>
+<country>
+<countryCode>BN</countryCode>
+<countryName>Brunei</countryName>
+<isoNumeric>096</isoNumeric>
+<isoAlpha3>BRN</isoAlpha3>
+<fipsCode>BX</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Bandar Seri Begawan</capital>
+<areaInSqKm>5770.0</areaInSqKm>
+<population>395027</population>
+<currencyCode>BND</currencyCode>
+<languages>ms-BN,en-BN</languages>
+<geonameId>1820814</geonameId>
+<west>114.071442</west>
+<north>5.047167</north>
+<east>115.359444</east>
+<south>4.003083</south>
+</country>
+<country>
+<countryCode>BO</countryCode>
+<countryName>Bolivia</countryName>
+<isoNumeric>068</isoNumeric>
+<isoAlpha3>BOL</isoAlpha3>
+<fipsCode>BL</fipsCode>
+<continent>SA</continent>
+<continentName>South America</continentName>
+<capital>Sucre</capital>
+<areaInSqKm>1098580.0</areaInSqKm>
+<population>9947418</population>
+<currencyCode>BOB</currencyCode>
+<languages>es-BO,qu,ay</languages>
+<geonameId>3923057</geonameId>
+<west>-69.640762</west>
+<north>-9.680567</north>
+<east>-57.45809600000001</east>
+<south>-22.896133</south>
+</country>
+<country>
+<countryCode>BQ</countryCode>
+<countryName>Bonaire</countryName>
+<isoNumeric>535</isoNumeric>
+<isoAlpha3>BES</isoAlpha3>
+<fipsCode/>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital/>
+<areaInSqKm/>
+<population>18012</population>
+<currencyCode>USD</currencyCode>
+<languages>nl,pap,en</languages>
+<geonameId>7626844</geonameId>
+<west>-68.416458</west>
+<north>12.304535</north>
+<east>-68.192307</east>
+<south>12.017149</south>
+</country>
+<country>
+<countryCode>BR</countryCode>
+<countryName>Brazil</countryName>
+<isoNumeric>076</isoNumeric>
+<isoAlpha3>BRA</isoAlpha3>
+<fipsCode>BR</fipsCode>
+<continent>SA</continent>
+<continentName>South America</continentName>
+<capital>Brasília</capital>
+<areaInSqKm>8511965.0</areaInSqKm>
+<population>201103330</population>
+<currencyCode>BRL</currencyCode>
+<languages>pt-BR,es,en,fr</languages>
+<geonameId>3469034</geonameId>
+<west>-73.985535</west>
+<north>5.264877</north>
+<east>-32.392998</east>
+<south>-33.750706</south>
+</country>
+<country>
+<countryCode>BS</countryCode>
+<countryName>Bahamas</countryName>
+<isoNumeric>044</isoNumeric>
+<isoAlpha3>BHS</isoAlpha3>
+<fipsCode>BF</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Nassau</capital>
+<areaInSqKm>13940.0</areaInSqKm>
+<population>301790</population>
+<currencyCode>BSD</currencyCode>
+<languages>en-BS</languages>
+<geonameId>3572887</geonameId>
+<west>-78.995911</west>
+<north>26.919243</north>
+<east>-74.423874</east>
+<south>22.852743</south>
+</country>
+<country>
+<countryCode>BT</countryCode>
+<countryName>Bhutan</countryName>
+<isoNumeric>064</isoNumeric>
+<isoAlpha3>BTN</isoAlpha3>
+<fipsCode>BT</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Thimphu</capital>
+<areaInSqKm>47000.0</areaInSqKm>
+<population>699847</population>
+<currencyCode>BTN</currencyCode>
+<languages>dz</languages>
+<geonameId>1252634</geonameId>
+<west>88.75972</west>
+<north>28.323778</north>
+<east>92.125191</east>
+<south>26.70764</south>
+</country>
+<country>
+<countryCode>BV</countryCode>
+<countryName>Bouvet Island</countryName>
+<isoNumeric>074</isoNumeric>
+<isoAlpha3>BVT</isoAlpha3>
+<fipsCode>BV</fipsCode>
+<continent>AN</continent>
+<continentName>Antarctica</continentName>
+<capital/>
+<areaInSqKm/>
+<population>0</population>
+<currencyCode>NOK</currencyCode>
+<languages/>
+<geonameId>3371123</geonameId>
+<west>3.335499</west>
+<north>-54.400322</north>
+<east>3.487976</east>
+<south>-54.462383</south>
+</country>
+<country>
+<countryCode>BW</countryCode>
+<countryName>Botswana</countryName>
+<isoNumeric>072</isoNumeric>
+<isoAlpha3>BWA</isoAlpha3>
+<fipsCode>BC</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Gaborone</capital>
+<areaInSqKm>600370.0</areaInSqKm>
+<population>2029307</population>
+<currencyCode>BWP</currencyCode>
+<languages>en-BW,tn-BW</languages>
+<geonameId>933860</geonameId>
+<west>19.999535</west>
+<north>-17.780813</north>
+<east>29.360781</east>
+<south>-26.907246</south>
+</country>
+<country>
+<countryCode>BY</countryCode>
+<countryName>Belarus</countryName>
+<isoNumeric>112</isoNumeric>
+<isoAlpha3>BLR</isoAlpha3>
+<fipsCode>BO</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Minsk</capital>
+<areaInSqKm>207600.0</areaInSqKm>
+<population>9685000</population>
+<currencyCode>BYR</currencyCode>
+<languages>be,ru</languages>
+<geonameId>630336</geonameId>
+<west>23.176889</west>
+<north>56.165806</north>
+<east>32.770805</east>
+<south>51.256416</south>
+</country>
+<country>
+<countryCode>BZ</countryCode>
+<countryName>Belize</countryName>
+<isoNumeric>084</isoNumeric>
+<isoAlpha3>BLZ</isoAlpha3>
+<fipsCode>BH</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Belmopan</capital>
+<areaInSqKm>22966.0</areaInSqKm>
+<population>314522</population>
+<currencyCode>BZD</currencyCode>
+<languages>en-BZ,es</languages>
+<geonameId>3582678</geonameId>
+<west>-89.224815</west>
+<north>18.496557</north>
+<east>-87.776985</east>
+<south>15.8893</south>
+</country>
+<country>
+<countryCode>CA</countryCode>
+<countryName>Canada</countryName>
+<isoNumeric>124</isoNumeric>
+<isoAlpha3>CAN</isoAlpha3>
+<fipsCode>CA</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Ottawa</capital>
+<areaInSqKm>9984670.0</areaInSqKm>
+<population>33679000</population>
+<currencyCode>CAD</currencyCode>
+<languages>en-CA,fr-CA,iu</languages>
+<geonameId>6251999</geonameId>
+<west>-141.0</west>
+<north>83.110626</north>
+<east>-52.636291</east>
+<south>41.67598</south>
+</country>
+<country>
+<countryCode>CC</countryCode>
+<countryName>Cocos [Keeling] Islands</countryName>
+<isoNumeric>166</isoNumeric>
+<isoAlpha3>CCK</isoAlpha3>
+<fipsCode>CK</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>West Island</capital>
+<areaInSqKm>14.0</areaInSqKm>
+<population>628</population>
+<currencyCode>AUD</currencyCode>
+<languages>ms-CC,en</languages>
+<geonameId>1547376</geonameId>
+<west>96.816941408</west>
+<north>-12.072459094</north>
+<east>96.929489344</east>
+<south>-12.208725839</south>
+</country>
+<country>
+<countryCode>CD</countryCode>
+<countryName>Democratic Republic of the Congo</countryName>
+<isoNumeric>180</isoNumeric>
+<isoAlpha3>COD</isoAlpha3>
+<fipsCode>CG</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Kinshasa</capital>
+<areaInSqKm>2345410.0</areaInSqKm>
+<population>70916439</population>
+<currencyCode>CDF</currencyCode>
+<languages>fr-CD,ln,kg</languages>
+<geonameId>203312</geonameId>
+<west>12.204144</west>
+<north>5.386098</north>
+<east>31.305912</east>
+<south>-13.455675</south>
+</country>
+<country>
+<countryCode>CF</countryCode>
+<countryName>Central African Republic</countryName>
+<isoNumeric>140</isoNumeric>
+<isoAlpha3>CAF</isoAlpha3>
+<fipsCode>CT</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Bangui</capital>
+<areaInSqKm>622984.0</areaInSqKm>
+<population>4844927</population>
+<currencyCode>XAF</currencyCode>
+<languages>fr-CF,sg,ln,kg</languages>
+<geonameId>239880</geonameId>
+<west>14.420097</west>
+<north>11.007569</north>
+<east>27.463421</east>
+<south>2.220514</south>
+</country>
+<country>
+<countryCode>CG</countryCode>
+<countryName>Republic of the Congo</countryName>
+<isoNumeric>178</isoNumeric>
+<isoAlpha3>COG</isoAlpha3>
+<fipsCode>CF</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Brazzaville</capital>
+<areaInSqKm>342000.0</areaInSqKm>
+<population>3039126</population>
+<currencyCode>XAF</currencyCode>
+<languages>fr-CG,kg,ln-CG</languages>
+<geonameId>2260494</geonameId>
+<west>11.205009</west>
+<north>3.703082</north>
+<east>18.649839</east>
+<south>-5.027223</south>
+</country>
+<country>
+<countryCode>CH</countryCode>
+<countryName>Switzerland</countryName>
+<isoNumeric>756</isoNumeric>
+<isoAlpha3>CHE</isoAlpha3>
+<fipsCode>SZ</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Berne</capital>
+<areaInSqKm>41290.0</areaInSqKm>
+<population>7581000</population>
+<currencyCode>CHF</currencyCode>
+<languages>de-CH,fr-CH,it-CH,rm</languages>
+<geonameId>2658434</geonameId>
+<west>5.957472</west>
+<north>47.805332</north>
+<east>10.491472</east>
+<south>45.825695</south>
+</country>
+<country>
+<countryCode>CI</countryCode>
+<countryName>Ivory Coast</countryName>
+<isoNumeric>384</isoNumeric>
+<isoAlpha3>CIV</isoAlpha3>
+<fipsCode>IV</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Yamoussoukro</capital>
+<areaInSqKm>322460.0</areaInSqKm>
+<population>21058798</population>
+<currencyCode>XOF</currencyCode>
+<languages>fr-CI</languages>
+<geonameId>2287781</geonameId>
+<west>-8.599302</west>
+<north>10.736642</north>
+<east>-2.494897</east>
+<south>4.357067</south>
+</country>
+<country>
+<countryCode>CK</countryCode>
+<countryName>Cook Islands</countryName>
+<isoNumeric>184</isoNumeric>
+<isoAlpha3>COK</isoAlpha3>
+<fipsCode>CW</fipsCode>
+<continent>OC</continent>
+<continentName>Oceania</continentName>
+<capital>Avarua</capital>
+<areaInSqKm>240.0</areaInSqKm>
+<population>21388</population>
+<currencyCode>NZD</currencyCode>
+<languages>en-CK,mi</languages>
+<geonameId>1899402</geonameId>
+<west>-161.093658</west>
+<north>-10.023114</north>
+<east>-157.312134</east>
+<south>-21.944164</south>
+</country>
+<country>
+<countryCode>CL</countryCode>
+<countryName>Chile</countryName>
+<isoNumeric>152</isoNumeric>
+<isoAlpha3>CHL</isoAlpha3>
+<fipsCode>CI</fipsCode>
+<continent>SA</continent>
+<continentName>South America</continentName>
+<capital>Santiago</capital>
+<areaInSqKm>756950.0</areaInSqKm>
+<population>16746491</population>
+<currencyCode>CLP</currencyCode>
+<languages>es-CL</languages>
+<geonameId>3895114</geonameId>
+<west>-80.785851</west>
+<north>-17.507553</north>
+<east>-66.417557</east>
+<south>-55.916348</south>
+</country>
+<country>
+<countryCode>CM</countryCode>
+<countryName>Cameroon</countryName>
+<isoNumeric>120</isoNumeric>
+<isoAlpha3>CMR</isoAlpha3>
+<fipsCode>CM</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Yaoundé</capital>
+<areaInSqKm>475440.0</areaInSqKm>
+<population>19294149</population>
+<currencyCode>XAF</currencyCode>
+<languages>en-CM,fr-CM</languages>
+<geonameId>2233387</geonameId>
+<west>8.494763</west>
+<north>13.078056</north>
+<east>16.192116</east>
+<south>1.652548</south>
+</country>
+<country>
+<countryCode>CN</countryCode>
+<countryName>China</countryName>
+<isoNumeric>156</isoNumeric>
+<isoAlpha3>CHN</isoAlpha3>
+<fipsCode>CH</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Beijing</capital>
+<areaInSqKm>9596960.0</areaInSqKm>
+<population>1330044000</population>
+<currencyCode>CNY</currencyCode>
+<languages>zh-CN,yue,wuu,dta,ug,za</languages>
+<geonameId>1814991</geonameId>
+<west>73.557693</west>
+<north>53.56086</north>
+<east>134.773911</east>
+<south>15.775416</south>
+</country>
+<country>
+<countryCode>CO</countryCode>
+<countryName>Colombia</countryName>
+<isoNumeric>170</isoNumeric>
+<isoAlpha3>COL</isoAlpha3>
+<fipsCode>CO</fipsCode>
+<continent>SA</continent>
+<continentName>South America</continentName>
+<capital>Bogotá</capital>
+<areaInSqKm>1138910.0</areaInSqKm>
+<population>44205293</population>
+<currencyCode>COP</currencyCode>
+<languages>es-CO</languages>
+<geonameId>3686110</geonameId>
+<west>-81.728111</west>
+<north>13.380502</north>
+<east>-66.869835</east>
+<south>-4.225869</south>
+</country>
+<country>
+<countryCode>CR</countryCode>
+<countryName>Costa Rica</countryName>
+<isoNumeric>188</isoNumeric>
+<isoAlpha3>CRI</isoAlpha3>
+<fipsCode>CS</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>San José</capital>
+<areaInSqKm>51100.0</areaInSqKm>
+<population>4516220</population>
+<currencyCode>CRC</currencyCode>
+<languages>es-CR,en</languages>
+<geonameId>3624060</geonameId>
+<west>-85.950623</west>
+<north>11.216819</north>
+<east>-82.555992</east>
+<south>8.032975</south>
+</country>
+<country>
+<countryCode>CU</countryCode>
+<countryName>Cuba</countryName>
+<isoNumeric>192</isoNumeric>
+<isoAlpha3>CUB</isoAlpha3>
+<fipsCode>CU</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Havana</capital>
+<areaInSqKm>110860.0</areaInSqKm>
+<population>11423000</population>
+<currencyCode>CUP</currencyCode>
+<languages>es-CU</languages>
+<geonameId>3562981</geonameId>
+<west>-84.957428</west>
+<north>23.226042</north>
+<east>-74.131775</east>
+<south>19.828083</south>
+</country>
+<country>
+<countryCode>CV</countryCode>
+<countryName>Cape Verde</countryName>
+<isoNumeric>132</isoNumeric>
+<isoAlpha3>CPV</isoAlpha3>
+<fipsCode>CV</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Praia</capital>
+<areaInSqKm>4033.0</areaInSqKm>
+<population>508659</population>
+<currencyCode>CVE</currencyCode>
+<languages>pt-CV</languages>
+<geonameId>3374766</geonameId>
+<west>-25.358747</west>
+<north>17.197178</north>
+<east>-22.669443</east>
+<south>14.808022</south>
+</country>
+<country>
+<countryCode>CW</countryCode>
+<countryName>Curacao</countryName>
+<isoNumeric>531</isoNumeric>
+<isoAlpha3>CUW</isoAlpha3>
+<fipsCode>UC</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Willemstad</capital>
+<areaInSqKm/>
+<population>141766</population>
+<currencyCode>ANG</currencyCode>
+<languages>nl,pap</languages>
+<geonameId>7626836</geonameId>
+<west>-69.157204</west>
+<north>12.385672</north>
+<east>-68.733948</east>
+<south>12.032745</south>
+</country>
+<country>
+<countryCode>CX</countryCode>
+<countryName>Christmas Island</countryName>
+<isoNumeric>162</isoNumeric>
+<isoAlpha3>CXR</isoAlpha3>
+<fipsCode>KT</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>The Settlement</capital>
+<areaInSqKm>135.0</areaInSqKm>
+<population>1500</population>
+<currencyCode>AUD</currencyCode>
+<languages>en,zh,ms-CC</languages>
+<geonameId>2078138</geonameId>
+<west>105.533276992</west>
+<north>-10.412356007</north>
+<east>105.712596992</east>
+<south>-10.5704829995</south>
+</country>
+<country>
+<countryCode>CY</countryCode>
+<countryName>Cyprus</countryName>
+<isoNumeric>196</isoNumeric>
+<isoAlpha3>CYP</isoAlpha3>
+<fipsCode>CY</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Nicosia</capital>
+<areaInSqKm>9250.0</areaInSqKm>
+<population>1102677</population>
+<currencyCode>EUR</currencyCode>
+<languages>el-CY,tr-CY,en</languages>
+<geonameId>146669</geonameId>
+<west>32.27308300000004</west>
+<north>35.701527</north>
+<east>34.59791599999994</east>
+<south>34.6332846722908</south>
+</country>
+<country>
+<countryCode>CZ</countryCode>
+<countryName>Czechia</countryName>
+<isoNumeric>203</isoNumeric>
+<isoAlpha3>CZE</isoAlpha3>
+<fipsCode>EZ</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Prague</capital>
+<areaInSqKm>78866.0</areaInSqKm>
+<population>10476000</population>
+<currencyCode>CZK</currencyCode>
+<languages>cs,sk</languages>
+<geonameId>3077311</geonameId>
+<west>12.096194</west>
+<north>51.058887</north>
+<east>18.860111</east>
+<south>48.542915</south>
+</country>
+<country>
+<countryCode>DE</countryCode>
+<countryName>Germany</countryName>
+<isoNumeric>276</isoNumeric>
+<isoAlpha3>DEU</isoAlpha3>
+<fipsCode>GM</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Berlin</capital>
+<areaInSqKm>357021.0</areaInSqKm>
+<population>81802257</population>
+<currencyCode>EUR</currencyCode>
+<languages>de</languages>
+<geonameId>2921044</geonameId>
+<west>5.865639</west>
+<north>55.055637</north>
+<east>15.039889</east>
+<south>47.275776</south>
+</country>
+<country>
+<countryCode>DJ</countryCode>
+<countryName>Djibouti</countryName>
+<isoNumeric>262</isoNumeric>
+<isoAlpha3>DJI</isoAlpha3>
+<fipsCode>DJ</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Djibouti</capital>
+<areaInSqKm>23000.0</areaInSqKm>
+<population>740528</population>
+<currencyCode>DJF</currencyCode>
+<languages>fr-DJ,ar,so-DJ,aa</languages>
+<geonameId>223816</geonameId>
+<west>41.773472</west>
+<north>12.706833</north>
+<east>43.416973</east>
+<south>10.909917</south>
+</country>
+<country>
+<countryCode>DK</countryCode>
+<countryName>Denmark</countryName>
+<isoNumeric>208</isoNumeric>
+<isoAlpha3>DNK</isoAlpha3>
+<fipsCode>DA</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Copenhagen</capital>
+<areaInSqKm>43094.0</areaInSqKm>
+<population>5484000</population>
+<currencyCode>DKK</currencyCode>
+<languages>da-DK,en,fo,de-DK</languages>
+<geonameId>2623032</geonameId>
+<west>8.075611</west>
+<north>57.748417</north>
+<east>15.158834</east>
+<south>54.562389</south>
+</country>
+<country>
+<countryCode>DM</countryCode>
+<countryName>Dominica</countryName>
+<isoNumeric>212</isoNumeric>
+<isoAlpha3>DMA</isoAlpha3>
+<fipsCode>DO</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Roseau</capital>
+<areaInSqKm>754.0</areaInSqKm>
+<population>72813</population>
+<currencyCode>XCD</currencyCode>
+<languages>en-DM</languages>
+<geonameId>3575830</geonameId>
+<west>-61.484108</west>
+<north>15.631809</north>
+<east>-61.244152</east>
+<south>15.20169</south>
+</country>
+<country>
+<countryCode>DO</countryCode>
+<countryName>Dominican Republic</countryName>
+<isoNumeric>214</isoNumeric>
+<isoAlpha3>DOM</isoAlpha3>
+<fipsCode>DR</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Santo Domingo</capital>
+<areaInSqKm>48730.0</areaInSqKm>
+<population>9823821</population>
+<currencyCode>DOP</currencyCode>
+<languages>es-DO</languages>
+<geonameId>3508796</geonameId>
+<west>-72.003487</west>
+<north>19.929859</north>
+<east>-68.32</east>
+<south>17.543159</south>
+</country>
+<country>
+<countryCode>DZ</countryCode>
+<countryName>Algeria</countryName>
+<isoNumeric>012</isoNumeric>
+<isoAlpha3>DZA</isoAlpha3>
+<fipsCode>AG</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Algiers</capital>
+<areaInSqKm>2381740.0</areaInSqKm>
+<population>34586184</population>
+<currencyCode>DZD</currencyCode>
+<languages>ar-DZ</languages>
+<geonameId>2589581</geonameId>
+<west>-8.673868</west>
+<north>37.093723</north>
+<east>11.979548</east>
+<south>18.960028</south>
+</country>
+<country>
+<countryCode>EC</countryCode>
+<countryName>Ecuador</countryName>
+<isoNumeric>218</isoNumeric>
+<isoAlpha3>ECU</isoAlpha3>
+<fipsCode>EC</fipsCode>
+<continent>SA</continent>
+<continentName>South America</continentName>
+<capital>Quito</capital>
+<areaInSqKm>283560.0</areaInSqKm>
+<population>14790608</population>
+<currencyCode>USD</currencyCode>
+<languages>es-EC</languages>
+<geonameId>3658394</geonameId>
+<west>-81.078598</west>
+<north>1.43902</north>
+<east>-75.184586</east>
+<south>-4.998823</south>
+</country>
+<country>
+<countryCode>EE</countryCode>
+<countryName>Estonia</countryName>
+<isoNumeric>233</isoNumeric>
+<isoAlpha3>EST</isoAlpha3>
+<fipsCode>EN</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Tallinn</capital>
+<areaInSqKm>45226.0</areaInSqKm>
+<population>1291170</population>
+<currencyCode>EUR</currencyCode>
+<languages>et,ru</languages>
+<geonameId>453733</geonameId>
+<west>21.837584</west>
+<north>59.676224</north>
+<east>28.209972</east>
+<south>57.516193</south>
+</country>
+<country>
+<countryCode>EG</countryCode>
+<countryName>Egypt</countryName>
+<isoNumeric>818</isoNumeric>
+<isoAlpha3>EGY</isoAlpha3>
+<fipsCode>EG</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Cairo</capital>
+<areaInSqKm>1001450.0</areaInSqKm>
+<population>80471869</population>
+<currencyCode>EGP</currencyCode>
+<languages>ar-EG,en,fr</languages>
+<geonameId>357994</geonameId>
+<west>24.698111</west>
+<north>31.667334</north>
+<east>35.794861</east>
+<south>21.725389</south>
+</country>
+<country>
+<countryCode>EH</countryCode>
+<countryName>Western Sahara</countryName>
+<isoNumeric>732</isoNumeric>
+<isoAlpha3>ESH</isoAlpha3>
+<fipsCode>WI</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>El Aaiún</capital>
+<areaInSqKm>266000.0</areaInSqKm>
+<population>273008</population>
+<currencyCode>MAD</currencyCode>
+<languages>ar,mey</languages>
+<geonameId>2461445</geonameId>
+<west>-17.103182</west>
+<north>27.669674</north>
+<east>-8.670276</east>
+<south>20.774158</south>
+</country>
+<country>
+<countryCode>ER</countryCode>
+<countryName>Eritrea</countryName>
+<isoNumeric>232</isoNumeric>
+<isoAlpha3>ERI</isoAlpha3>
+<fipsCode>ER</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Asmara</capital>
+<areaInSqKm>121320.0</areaInSqKm>
+<population>5792984</population>
+<currencyCode>ERN</currencyCode>
+<languages>aa-ER,ar,tig,kun,ti-ER</languages>
+<geonameId>338010</geonameId>
+<west>36.438778</west>
+<north>18.003084</north>
+<east>43.13464</east>
+<south>12.359555</south>
+</country>
+<country>
+<countryCode>ES</countryCode>
+<countryName>Spain</countryName>
+<isoNumeric>724</isoNumeric>
+<isoAlpha3>ESP</isoAlpha3>
+<fipsCode>SP</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Madrid</capital>
+<areaInSqKm>504782.0</areaInSqKm>
+<population>46505963</population>
+<currencyCode>EUR</currencyCode>
+<languages>es-ES,ca,gl,eu,oc</languages>
+<geonameId>2510769</geonameId>
+<west>-9.290778</west>
+<north>43.791721</north>
+<east>4.315389</east>
+<south>36.000332</south>
+</country>
+<country>
+<countryCode>ET</countryCode>
+<countryName>Ethiopia</countryName>
+<isoNumeric>231</isoNumeric>
+<isoAlpha3>ETH</isoAlpha3>
+<fipsCode>ET</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Addis Ababa</capital>
+<areaInSqKm>1127127.0</areaInSqKm>
+<population>88013491</population>
+<currencyCode>ETB</currencyCode>
+<languages>am,en-ET,om-ET,ti-ET,so-ET,sid</languages>
+<geonameId>337996</geonameId>
+<west>32.999939</west>
+<north>14.89375</north>
+<east>47.986179</east>
+<south>3.402422</south>
+</country>
+<country>
+<countryCode>FI</countryCode>
+<countryName>Finland</countryName>
+<isoNumeric>246</isoNumeric>
+<isoAlpha3>FIN</isoAlpha3>
+<fipsCode>FI</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Helsinki</capital>
+<areaInSqKm>337030.0</areaInSqKm>
+<population>5244000</population>
+<currencyCode>EUR</currencyCode>
+<languages>fi-FI,sv-FI,smn</languages>
+<geonameId>660013</geonameId>
+<west>20.556944</west>
+<north>70.096054</north>
+<east>31.580944</east>
+<south>59.808777</south>
+</country>
+<country>
+<countryCode>FJ</countryCode>
+<countryName>Fiji</countryName>
+<isoNumeric>242</isoNumeric>
+<isoAlpha3>FJI</isoAlpha3>
+<fipsCode>FJ</fipsCode>
+<continent>OC</continent>
+<continentName>Oceania</continentName>
+<capital>Suva</capital>
+<areaInSqKm>18270.0</areaInSqKm>
+<population>875983</population>
+<currencyCode>FJD</currencyCode>
+<languages>en-FJ,fj</languages>
+<geonameId>2205218</geonameId>
+<west>177.129334</west>
+<north>-12.480111</north>
+<east>-178.424438</east>
+<south>-20.67597</south>
+</country>
+<country>
+<countryCode>FK</countryCode>
+<countryName>Falkland Islands</countryName>
+<isoNumeric>238</isoNumeric>
+<isoAlpha3>FLK</isoAlpha3>
+<fipsCode>FK</fipsCode>
+<continent>SA</continent>
+<continentName>South America</continentName>
+<capital>Stanley</capital>
+<areaInSqKm>12173.0</areaInSqKm>
+<population>2638</population>
+<currencyCode>FKP</currencyCode>
+<languages>en-FK</languages>
+<geonameId>3474414</geonameId>
+<west>-61.345192</west>
+<north>-51.24065</north>
+<east>-57.712486</east>
+<south>-52.360512</south>
+</country>
+<country>
+<countryCode>FM</countryCode>
+<countryName>Micronesia</countryName>
+<isoNumeric>583</isoNumeric>
+<isoAlpha3>FSM</isoAlpha3>
+<fipsCode>FM</fipsCode>
+<continent>OC</continent>
+<continentName>Oceania</continentName>
+<capital>Palikir</capital>
+<areaInSqKm>702.0</areaInSqKm>
+<population>107708</population>
+<currencyCode>USD</currencyCode>
+<languages>en-FM,chk,pon,yap,kos,uli,woe,nkr,kpg</languages>
+<geonameId>2081918</geonameId>
+<west>137.33648</west>
+<north>10.08904</north>
+<east>163.03717</east>
+<south>1.02629</south>
+</country>
+<country>
+<countryCode>FO</countryCode>
+<countryName>Faroe Islands</countryName>
+<isoNumeric>234</isoNumeric>
+<isoAlpha3>FRO</isoAlpha3>
+<fipsCode>FO</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Tórshavn</capital>
+<areaInSqKm>1399.0</areaInSqKm>
+<population>48228</population>
+<currencyCode>DKK</currencyCode>
+<languages>fo,da-FO</languages>
+<geonameId>2622320</geonameId>
+<west>-7.458</west>
+<north>62.400749</north>
+<east>-6.399583</east>
+<south>61.394943</south>
+</country>
+<country>
+<countryCode>FR</countryCode>
+<countryName>France</countryName>
+<isoNumeric>250</isoNumeric>
+<isoAlpha3>FRA</isoAlpha3>
+<fipsCode>FR</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Paris</capital>
+<areaInSqKm>547030.0</areaInSqKm>
+<population>64768389</population>
+<currencyCode>EUR</currencyCode>
+<languages>fr-FR,frp,br,co,ca,eu,oc</languages>
+<geonameId>3017382</geonameId>
+<west>-5.142222</west>
+<north>51.092804</north>
+<east>9.561556</east>
+<south>41.371582</south>
+</country>
+<country>
+<countryCode>GA</countryCode>
+<countryName>Gabon</countryName>
+<isoNumeric>266</isoNumeric>
+<isoAlpha3>GAB</isoAlpha3>
+<fipsCode>GB</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Libreville</capital>
+<areaInSqKm>267667.0</areaInSqKm>
+<population>1545255</population>
+<currencyCode>XAF</currencyCode>
+<languages>fr-GA</languages>
+<geonameId>2400553</geonameId>
+<west>8.695471</west>
+<north>2.322612</north>
+<east>14.502347</east>
+<south>-3.978806</south>
+</country>
+<country>
+<countryCode>GB</countryCode>
+<countryName>United Kingdom</countryName>
+<isoNumeric>826</isoNumeric>
+<isoAlpha3>GBR</isoAlpha3>
+<fipsCode>UK</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>London</capital>
+<areaInSqKm>244820.0</areaInSqKm>
+<population>62348447</population>
+<currencyCode>GBP</currencyCode>
+<languages>en-GB,cy-GB,gd</languages>
+<geonameId>2635167</geonameId>
+<west>-8.623555</west>
+<north>59.360249</north>
+<east>1.759</east>
+<south>49.906193</south>
+</country>
+<country>
+<countryCode>GD</countryCode>
+<countryName>Grenada</countryName>
+<isoNumeric>308</isoNumeric>
+<isoAlpha3>GRD</isoAlpha3>
+<fipsCode>GJ</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>St. George's</capital>
+<areaInSqKm>344.0</areaInSqKm>
+<population>107818</population>
+<currencyCode>XCD</currencyCode>
+<languages>en-GD</languages>
+<geonameId>3580239</geonameId>
+<west>-61.802344</west>
+<north>12.318283928171299</north>
+<east>-61.57676970108031</east>
+<south>11.986893</south>
+</country>
+<country>
+<countryCode>GE</countryCode>
+<countryName>Georgia</countryName>
+<isoNumeric>268</isoNumeric>
+<isoAlpha3>GEO</isoAlpha3>
+<fipsCode>GG</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Tbilisi</capital>
+<areaInSqKm>69700.0</areaInSqKm>
+<population>4630000</population>
+<currencyCode>GEL</currencyCode>
+<languages>ka,ru,hy,az</languages>
+<geonameId>614540</geonameId>
+<west>40.010139</west>
+<north>43.586498</north>
+<east>46.725971</east>
+<south>41.053196</south>
+</country>
+<country>
+<countryCode>GF</countryCode>
+<countryName>French Guiana</countryName>
+<isoNumeric>254</isoNumeric>
+<isoAlpha3>GUF</isoAlpha3>
+<fipsCode>FG</fipsCode>
+<continent>SA</continent>
+<continentName>South America</continentName>
+<capital>Cayenne</capital>
+<areaInSqKm>91000.0</areaInSqKm>
+<population>195506</population>
+<currencyCode>EUR</currencyCode>
+<languages>fr-GF</languages>
+<geonameId>3381670</geonameId>
+<west>-54.542511</west>
+<north>5.776496</north>
+<east>-51.613949</east>
+<south>2.127094</south>
+</country>
+<country>
+<countryCode>GG</countryCode>
+<countryName>Guernsey</countryName>
+<isoNumeric>831</isoNumeric>
+<isoAlpha3>GGY</isoAlpha3>
+<fipsCode>GK</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>St Peter Port</capital>
+<areaInSqKm>78.0</areaInSqKm>
+<population>65228</population>
+<currencyCode>GBP</currencyCode>
+<languages>en,fr</languages>
+<geonameId>3042362</geonameId>
+<west>-2.682472</west>
+<north>49.738609</north>
+<east>-2.163889</east>
+<south>49.412777</south>
+</country>
+<country>
+<countryCode>GH</countryCode>
+<countryName>Ghana</countryName>
+<isoNumeric>288</isoNumeric>
+<isoAlpha3>GHA</isoAlpha3>
+<fipsCode>GH</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Accra</capital>
+<areaInSqKm>239460.0</areaInSqKm>
+<population>24339838</population>
+<currencyCode>GHS</currencyCode>
+<languages>en-GH,ak,ee,tw</languages>
+<geonameId>2300660</geonameId>
+<west>-3.25542</west>
+<north>11.173301</north>
+<east>1.191781</east>
+<south>4.736723</south>
+</country>
+<country>
+<countryCode>GI</countryCode>
+<countryName>Gibraltar</countryName>
+<isoNumeric>292</isoNumeric>
+<isoAlpha3>GIB</isoAlpha3>
+<fipsCode>GI</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Gibraltar</capital>
+<areaInSqKm>6.5</areaInSqKm>
+<population>27884</population>
+<currencyCode>GIP</currencyCode>
+<languages>en-GI,es,it,pt</languages>
+<geonameId>2411586</geonameId>
+<west>-5.36626149743654</west>
+<north>36.155439135670726</north>
+<east>-5.338285164001491</east>
+<south>36.10903070140248</south>
+</country>
+<country>
+<countryCode>GL</countryCode>
+<countryName>Greenland</countryName>
+<isoNumeric>304</isoNumeric>
+<isoAlpha3>GRL</isoAlpha3>
+<fipsCode>GL</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Nuuk</capital>
+<areaInSqKm>2166086.0</areaInSqKm>
+<population>56375</population>
+<currencyCode>DKK</currencyCode>
+<languages>kl,da-GL,en</languages>
+<geonameId>3425505</geonameId>
+<west>-73.04203</west>
+<north>83.627357</north>
+<east>-11.312319</east>
+<south>59.777401</south>
+</country>
+<country>
+<countryCode>GM</countryCode>
+<countryName>Gambia</countryName>
+<isoNumeric>270</isoNumeric>
+<isoAlpha3>GMB</isoAlpha3>
+<fipsCode>GA</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Banjul</capital>
+<areaInSqKm>11300.0</areaInSqKm>
+<population>1593256</population>
+<currencyCode>GMD</currencyCode>
+<languages>en-GM,mnk,wof,wo,ff</languages>
+<geonameId>2413451</geonameId>
+<west>-16.825079</west>
+<north>13.826571</north>
+<east>-13.797793</east>
+<south>13.064252</south>
+</country>
+<country>
+<countryCode>GN</countryCode>
+<countryName>Guinea</countryName>
+<isoNumeric>324</isoNumeric>
+<isoAlpha3>GIN</isoAlpha3>
+<fipsCode>GV</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Conakry</capital>
+<areaInSqKm>245857.0</areaInSqKm>
+<population>10324025</population>
+<currencyCode>GNF</currencyCode>
+<languages>fr-GN</languages>
+<geonameId>2420477</geonameId>
+<west>-14.926619</west>
+<north>12.67622</north>
+<east>-7.641071</east>
+<south>7.193553</south>
+</country>
+<country>
+<countryCode>GP</countryCode>
+<countryName>Guadeloupe</countryName>
+<isoNumeric>312</isoNumeric>
+<isoAlpha3>GLP</isoAlpha3>
+<fipsCode>GP</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Basse-Terre</capital>
+<areaInSqKm>1780.0</areaInSqKm>
+<population>443000</population>
+<currencyCode>EUR</currencyCode>
+<languages>fr-GP</languages>
+<geonameId>3579143</geonameId>
+<west>-61.544765</west>
+<north>16.516848</north>
+<east>-61.0</east>
+<south>15.867565</south>
+</country>
+<country>
+<countryCode>GQ</countryCode>
+<countryName>Equatorial Guinea</countryName>
+<isoNumeric>226</isoNumeric>
+<isoAlpha3>GNQ</isoAlpha3>
+<fipsCode>EK</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Malabo</capital>
+<areaInSqKm>28051.0</areaInSqKm>
+<population>1014999</population>
+<currencyCode>XAF</currencyCode>
+<languages>es-GQ,fr</languages>
+<geonameId>2309096</geonameId>
+<west>9.346865</west>
+<north>2.346989</north>
+<east>11.335724</east>
+<south>0.92086</south>
+</country>
+<country>
+<countryCode>GR</countryCode>
+<countryName>Greece</countryName>
+<isoNumeric>300</isoNumeric>
+<isoAlpha3>GRC</isoAlpha3>
+<fipsCode>GR</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Athens</capital>
+<areaInSqKm>131940.0</areaInSqKm>
+<population>11000000</population>
+<currencyCode>EUR</currencyCode>
+<languages>el-GR,en,fr</languages>
+<geonameId>390903</geonameId>
+<west>19.3736035624134</west>
+<north>41.7484999849641</north>
+<east>28.2470831714347</east>
+<south>34.8020663391466</south>
+</country>
+<country>
+<countryCode>GS</countryCode>
+<countryName>South Georgia and the South Sandwich Islands</countryName>
+<isoNumeric>239</isoNumeric>
+<isoAlpha3>SGS</isoAlpha3>
+<fipsCode>SX</fipsCode>
+<continent>AN</continent>
+<continentName>Antarctica</continentName>
+<capital>Grytviken</capital>
+<areaInSqKm>3903.0</areaInSqKm>
+<population>30</population>
+<currencyCode>GBP</currencyCode>
+<languages>en</languages>
+<geonameId>3474415</geonameId>
+<west>-38.021175</west>
+<north>-53.970467</north>
+<east>-26.229326</east>
+<south>-59.479259</south>
+</country>
+<country>
+<countryCode>GT</countryCode>
+<countryName>Guatemala</countryName>
+<isoNumeric>320</isoNumeric>
+<isoAlpha3>GTM</isoAlpha3>
+<fipsCode>GT</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Guatemala City</capital>
+<areaInSqKm>108890.0</areaInSqKm>
+<population>13550440</population>
+<currencyCode>GTQ</currencyCode>
+<languages>es-GT</languages>
+<geonameId>3595528</geonameId>
+<west>-92.23629</west>
+<north>17.81522</north>
+<east>-88.223198</east>
+<south>13.737302</south>
+</country>
+<country>
+<countryCode>GU</countryCode>
+<countryName>Guam</countryName>
+<isoNumeric>316</isoNumeric>
+<isoAlpha3>GUM</isoAlpha3>
+<fipsCode>GQ</fipsCode>
+<continent>OC</continent>
+<continentName>Oceania</continentName>
+<capital>Hagåtña</capital>
+<areaInSqKm>549.0</areaInSqKm>
+<population>159358</population>
+<currencyCode>USD</currencyCode>
+<languages>en-GU,ch-GU</languages>
+<geonameId>4043988</geonameId>
+<west>144.619247</west>
+<north>13.652333</north>
+<east>144.953979</east>
+<south>13.240611</south>
+</country>
+<country>
+<countryCode>GW</countryCode>
+<countryName>Guinea-Bissau</countryName>
+<isoNumeric>624</isoNumeric>
+<isoAlpha3>GNB</isoAlpha3>
+<fipsCode>PU</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Bissau</capital>
+<areaInSqKm>36120.0</areaInSqKm>
+<population>1565126</population>
+<currencyCode>XOF</currencyCode>
+<languages>pt-GW,pov</languages>
+<geonameId>2372248</geonameId>
+<west>-16.717535</west>
+<north>12.680789</north>
+<east>-13.636522</east>
+<south>10.924265</south>
+</country>
+<country>
+<countryCode>GY</countryCode>
+<countryName>Guyana</countryName>
+<isoNumeric>328</isoNumeric>
+<isoAlpha3>GUY</isoAlpha3>
+<fipsCode>GY</fipsCode>
+<continent>SA</continent>
+<continentName>South America</continentName>
+<capital>Georgetown</capital>
+<areaInSqKm>214970.0</areaInSqKm>
+<population>748486</population>
+<currencyCode>GYD</currencyCode>
+<languages>en-GY</languages>
+<geonameId>3378535</geonameId>
+<west>-61.384762</west>
+<north>8.557567</north>
+<east>-56.480251</east>
+<south>1.17508</south>
+</country>
+<country>
+<countryCode>HK</countryCode>
+<countryName>Hong Kong</countryName>
+<isoNumeric>344</isoNumeric>
+<isoAlpha3>HKG</isoAlpha3>
+<fipsCode>HK</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Hong Kong</capital>
+<areaInSqKm>1092.0</areaInSqKm>
+<population>6898686</population>
+<currencyCode>HKD</currencyCode>
+<languages>zh-HK,yue,zh,en</languages>
+<geonameId>1819730</geonameId>
+<west>113.837753</west>
+<north>22.559778</north>
+<east>114.434753</east>
+<south>22.15325</south>
+</country>
+<country>
+<countryCode>HM</countryCode>
+<countryName>Heard Island and McDonald Islands</countryName>
+<isoNumeric>334</isoNumeric>
+<isoAlpha3>HMD</isoAlpha3>
+<fipsCode>HM</fipsCode>
+<continent>AN</continent>
+<continentName>Antarctica</continentName>
+<capital/>
+<areaInSqKm>412.0</areaInSqKm>
+<population>0</population>
+<currencyCode>AUD</currencyCode>
+<languages/>
+<geonameId>1547314</geonameId>
+<west>72.596535</west>
+<north>-52.909416</north>
+<east>73.859146</east>
+<south>-53.192001</south>
+</country>
+<country>
+<countryCode>HN</countryCode>
+<countryName>Honduras</countryName>
+<isoNumeric>340</isoNumeric>
+<isoAlpha3>HND</isoAlpha3>
+<fipsCode>HO</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Tegucigalpa</capital>
+<areaInSqKm>112090.0</areaInSqKm>
+<population>7989415</population>
+<currencyCode>HNL</currencyCode>
+<languages>es-HN</languages>
+<geonameId>3608932</geonameId>
+<west>-89.350792</west>
+<north>16.510256</north>
+<east>-83.155403</east>
+<south>12.982411</south>
+</country>
+<country>
+<countryCode>HR</countryCode>
+<countryName>Croatia</countryName>
+<isoNumeric>191</isoNumeric>
+<isoAlpha3>HRV</isoAlpha3>
+<fipsCode>HR</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Zagreb</capital>
+<areaInSqKm>56542.0</areaInSqKm>
+<population>4491000</population>
+<currencyCode>HRK</currencyCode>
+<languages>hr-HR,sr</languages>
+<geonameId>3202326</geonameId>
+<west>13.493222</west>
+<north>46.53875</north>
+<east>19.427389</east>
+<south>42.43589</south>
+</country>
+<country>
+<countryCode>HT</countryCode>
+<countryName>Haiti</countryName>
+<isoNumeric>332</isoNumeric>
+<isoAlpha3>HTI</isoAlpha3>
+<fipsCode>HA</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Port-au-Prince</capital>
+<areaInSqKm>27750.0</areaInSqKm>
+<population>9648924</population>
+<currencyCode>HTG</currencyCode>
+<languages>ht,fr-HT</languages>
+<geonameId>3723988</geonameId>
+<west>-74.478584</west>
+<north>20.08782</north>
+<east>-71.613358</east>
+<south>18.021032</south>
+</country>
+<country>
+<countryCode>HU</countryCode>
+<countryName>Hungary</countryName>
+<isoNumeric>348</isoNumeric>
+<isoAlpha3>HUN</isoAlpha3>
+<fipsCode>HU</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Budapest</capital>
+<areaInSqKm>93030.0</areaInSqKm>
+<population>9982000</population>
+<currencyCode>HUF</currencyCode>
+<languages>hu-HU</languages>
+<geonameId>719819</geonameId>
+<west>16.111889</west>
+<north>48.585667</north>
+<east>22.906</east>
+<south>45.74361</south>
+</country>
+<country>
+<countryCode>ID</countryCode>
+<countryName>Indonesia</countryName>
+<isoNumeric>360</isoNumeric>
+<isoAlpha3>IDN</isoAlpha3>
+<fipsCode>ID</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Jakarta</capital>
+<areaInSqKm>1919440.0</areaInSqKm>
+<population>242968342</population>
+<currencyCode>IDR</currencyCode>
+<languages>id,en,nl,jv</languages>
+<geonameId>1643084</geonameId>
+<west>95.009331</west>
+<north>5.904417</north>
+<east>141.021805</east>
+<south>-10.941861</south>
+</country>
+<country>
+<countryCode>IE</countryCode>
+<countryName>Ireland</countryName>
+<isoNumeric>372</isoNumeric>
+<isoAlpha3>IRL</isoAlpha3>
+<fipsCode>EI</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Dublin</capital>
+<areaInSqKm>70280.0</areaInSqKm>
+<population>4622917</population>
+<currencyCode>EUR</currencyCode>
+<languages>en-IE,ga-IE</languages>
+<geonameId>2963597</geonameId>
+<west>-10.478556</west>
+<north>55.387917</north>
+<east>-6.002389</east>
+<south>51.451584</south>
+</country>
+<country>
+<countryCode>IL</countryCode>
+<countryName>Israel</countryName>
+<isoNumeric>376</isoNumeric>
+<isoAlpha3>ISR</isoAlpha3>
+<fipsCode>IS</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital/>
+<areaInSqKm>20770.0</areaInSqKm>
+<population>7353985</population>
+<currencyCode>ILS</currencyCode>
+<languages>he,ar-IL,en-IL,</languages>
+<geonameId>294640</geonameId>
+<west>34.270278754419145</west>
+<north>33.340137</north>
+<east>35.876804</east>
+<south>29.496639</south>
+</country>
+<country>
+<countryCode>IM</countryCode>
+<countryName>Isle of Man</countryName>
+<isoNumeric>833</isoNumeric>
+<isoAlpha3>IMN</isoAlpha3>
+<fipsCode>IM</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Douglas</capital>
+<areaInSqKm>572.0</areaInSqKm>
+<population>75049</population>
+<currencyCode>GBP</currencyCode>
+<languages>en,gv</languages>
+<geonameId>3042225</geonameId>
+<west>-4.798722</west>
+<north>54.419724</north>
+<east>-4.3115</east>
+<south>54.055916</south>
+</country>
+<country>
+<countryCode>IN</countryCode>
+<countryName>India</countryName>
+<isoNumeric>356</isoNumeric>
+<isoAlpha3>IND</isoAlpha3>
+<fipsCode>IN</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>New Delhi</capital>
+<areaInSqKm>3287590.0</areaInSqKm>
+<population>1173108018</population>
+<currencyCode>INR</currencyCode>
+<languages>en-IN,hi,bn,te,mr,ta,ur,gu,kn,ml,or,pa,as,bh,sat,ks,ne,sd,kok,doi,mni,sit,sa,fr,lus,inc</languages>
+<geonameId>1269750</geonameId>
+<west>68.186691</west>
+<north>35.504223</north>
+<east>97.403305</east>
+<south>6.747139</south>
+</country>
+<country>
+<countryCode>IO</countryCode>
+<countryName>British Indian Ocean Territory</countryName>
+<isoNumeric>086</isoNumeric>
+<isoAlpha3>IOT</isoAlpha3>
+<fipsCode>IO</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital/>
+<areaInSqKm>60.0</areaInSqKm>
+<population>4000</population>
+<currencyCode>USD</currencyCode>
+<languages>en-IO</languages>
+<geonameId>1282588</geonameId>
+<west>71.259972</west>
+<north>-5.268333</north>
+<east>72.493164</east>
+<south>-7.438028</south>
+</country>
+<country>
+<countryCode>IQ</countryCode>
+<countryName>Iraq</countryName>
+<isoNumeric>368</isoNumeric>
+<isoAlpha3>IRQ</isoAlpha3>
+<fipsCode>IZ</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Baghdad</capital>
+<areaInSqKm>437072.0</areaInSqKm>
+<population>29671605</population>
+<currencyCode>IQD</currencyCode>
+<languages>ar-IQ,ku,hy</languages>
+<geonameId>99237</geonameId>
+<west>38.795887</west>
+<north>37.378029</north>
+<east>48.575916</east>
+<south>29.069445</south>
+</country>
+<country>
+<countryCode>IR</countryCode>
+<countryName>Iran</countryName>
+<isoNumeric>364</isoNumeric>
+<isoAlpha3>IRN</isoAlpha3>
+<fipsCode>IR</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Tehran</capital>
+<areaInSqKm>1648000.0</areaInSqKm>
+<population>76923300</population>
+<currencyCode>IRR</currencyCode>
+<languages>fa-IR,ku</languages>
+<geonameId>130758</geonameId>
+<west>44.047279</west>
+<north>39.777222</north>
+<east>63.317471</east>
+<south>25.064083</south>
+</country>
+<country>
+<countryCode>IS</countryCode>
+<countryName>Iceland</countryName>
+<isoNumeric>352</isoNumeric>
+<isoAlpha3>ISL</isoAlpha3>
+<fipsCode>IC</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Reykjavik</capital>
+<areaInSqKm>103000.0</areaInSqKm>
+<population>308910</population>
+<currencyCode>ISK</currencyCode>
+<languages>is,en,de,da,sv,no</languages>
+<geonameId>2629691</geonameId>
+<west>-24.546524</west>
+<north>66.53463</north>
+<east>-13.495815</east>
+<south>63.393253</south>
+</country>
+<country>
+<countryCode>IT</countryCode>
+<countryName>Italy</countryName>
+<isoNumeric>380</isoNumeric>
+<isoAlpha3>ITA</isoAlpha3>
+<fipsCode>IT</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Rome</capital>
+<areaInSqKm>301230.0</areaInSqKm>
+<population>60340328</population>
+<currencyCode>EUR</currencyCode>
+<languages>it-IT,de-IT,fr-IT,sc,ca,co,sl</languages>
+<geonameId>3175395</geonameId>
+<west>6.614889</west>
+<north>47.095196</north>
+<east>18.513445</east>
+<south>36.652779</south>
+</country>
+<country>
+<countryCode>JE</countryCode>
+<countryName>Jersey</countryName>
+<isoNumeric>832</isoNumeric>
+<isoAlpha3>JEY</isoAlpha3>
+<fipsCode>JE</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Saint Helier</capital>
+<areaInSqKm>116.0</areaInSqKm>
+<population>90812</population>
+<currencyCode>GBP</currencyCode>
+<languages>en,pt</languages>
+<geonameId>3042142</geonameId>
+<west>-2.260028</west>
+<north>49.265057</north>
+<east>-2.022083</east>
+<south>49.169834</south>
+</country>
+<country>
+<countryCode>JM</countryCode>
+<countryName>Jamaica</countryName>
+<isoNumeric>388</isoNumeric>
+<isoAlpha3>JAM</isoAlpha3>
+<fipsCode>JM</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Kingston</capital>
+<areaInSqKm>10991.0</areaInSqKm>
+<population>2847232</population>
+<currencyCode>JMD</currencyCode>
+<languages>en-JM</languages>
+<geonameId>3489940</geonameId>
+<west>-78.366638</west>
+<north>18.526976</north>
+<east>-76.180321</east>
+<south>17.703554</south>
+</country>
+<country>
+<countryCode>JO</countryCode>
+<countryName>Jordan</countryName>
+<isoNumeric>400</isoNumeric>
+<isoAlpha3>JOR</isoAlpha3>
+<fipsCode>JO</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Amman</capital>
+<areaInSqKm>92300.0</areaInSqKm>
+<population>6407085</population>
+<currencyCode>JOD</currencyCode>
+<languages>ar-JO,en</languages>
+<geonameId>248816</geonameId>
+<west>34.959999</west>
+<north>33.367668</north>
+<east>39.301167</east>
+<south>29.185888</south>
+</country>
+<country>
+<countryCode>JP</countryCode>
+<countryName>Japan</countryName>
+<isoNumeric>392</isoNumeric>
+<isoAlpha3>JPN</isoAlpha3>
+<fipsCode>JA</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Tokyo</capital>
+<areaInSqKm>377835.0</areaInSqKm>
+<population>127288000</population>
+<currencyCode>JPY</currencyCode>
+<languages>ja</languages>
+<geonameId>1861060</geonameId>
+<west>122.93853</west>
+<north>45.52314</north>
+<east>145.820892</east>
+<south>24.249472</south>
+</country>
+<country>
+<countryCode>KE</countryCode>
+<countryName>Kenya</countryName>
+<isoNumeric>404</isoNumeric>
+<isoAlpha3>KEN</isoAlpha3>
+<fipsCode>KE</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Nairobi</capital>
+<areaInSqKm>582650.0</areaInSqKm>
+<population>40046566</population>
+<currencyCode>KES</currencyCode>
+<languages>en-KE,sw-KE</languages>
+<geonameId>192950</geonameId>
+<west>33.908859</west>
+<north>5.019938</north>
+<east>41.899078</east>
+<south>-4.678047</south>
+</country>
+<country>
+<countryCode>KG</countryCode>
+<countryName>Kyrgyzstan</countryName>
+<isoNumeric>417</isoNumeric>
+<isoAlpha3>KGZ</isoAlpha3>
+<fipsCode>KG</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Bishkek</capital>
+<areaInSqKm>198500.0</areaInSqKm>
+<population>5508626</population>
+<currencyCode>KGS</currencyCode>
+<languages>ky,uz,ru</languages>
+<geonameId>1527747</geonameId>
+<west>69.276611</west>
+<north>43.238224</north>
+<east>80.283165</east>
+<south>39.172832</south>
+</country>
+<country>
+<countryCode>KH</countryCode>
+<countryName>Cambodia</countryName>
+<isoNumeric>116</isoNumeric>
+<isoAlpha3>KHM</isoAlpha3>
+<fipsCode>CB</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Phnom Penh</capital>
+<areaInSqKm>181040.0</areaInSqKm>
+<population>14453680</population>
+<currencyCode>KHR</currencyCode>
+<languages>km,fr,en</languages>
+<geonameId>1831722</geonameId>
+<west>102.339996</west>
+<north>14.686417</north>
+<east>107.627724</east>
+<south>10.409083</south>
+</country>
+<country>
+<countryCode>KI</countryCode>
+<countryName>Kiribati</countryName>
+<isoNumeric>296</isoNumeric>
+<isoAlpha3>KIR</isoAlpha3>
+<fipsCode>KR</fipsCode>
+<continent>OC</continent>
+<continentName>Oceania</continentName>
+<capital>Tarawa</capital>
+<areaInSqKm>811.0</areaInSqKm>
+<population>92533</population>
+<currencyCode>AUD</currencyCode>
+<languages>en-KI,gil</languages>
+<geonameId>4030945</geonameId>
+<west>169.556137</west>
+<north>4.71957</north>
+<east>-150.215347</east>
+<south>-11.437038</south>
+</country>
+<country>
+<countryCode>KM</countryCode>
+<countryName>Comoros</countryName>
+<isoNumeric>174</isoNumeric>
+<isoAlpha3>COM</isoAlpha3>
+<fipsCode>CN</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Moroni</capital>
+<areaInSqKm>2170.0</areaInSqKm>
+<population>773407</population>
+<currencyCode>KMF</currencyCode>
+<languages>ar,fr-KM</languages>
+<geonameId>921929</geonameId>
+<west>43.21579</west>
+<north>-11.362381</north>
+<east>44.538223</east>
+<south>-12.387857</south>
+</country>
+<country>
+<countryCode>KN</countryCode>
+<countryName>Saint Kitts and Nevis</countryName>
+<isoNumeric>659</isoNumeric>
+<isoAlpha3>KNA</isoAlpha3>
+<fipsCode>SC</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Basseterre</capital>
+<areaInSqKm>261.0</areaInSqKm>
+<population>49898</population>
+<currencyCode>XCD</currencyCode>
+<languages>en-KN</languages>
+<geonameId>3575174</geonameId>
+<west>-62.86956</west>
+<north>17.420118</north>
+<east>-62.543266</east>
+<south>17.095343</south>
+</country>
+<country>
+<countryCode>KP</countryCode>
+<countryName>North Korea</countryName>
+<isoNumeric>408</isoNumeric>
+<isoAlpha3>PRK</isoAlpha3>
+<fipsCode>KN</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Pyongyang</capital>
+<areaInSqKm>120540.0</areaInSqKm>
+<population>22912177</population>
+<currencyCode>KPW</currencyCode>
+<languages>ko-KP</languages>
+<geonameId>1873107</geonameId>
+<west>124.315887</west>
+<north>43.006054</north>
+<east>130.674866</east>
+<south>37.673332</south>
+</country>
+<country>
+<countryCode>KR</countryCode>
+<countryName>South Korea</countryName>
+<isoNumeric>410</isoNumeric>
+<isoAlpha3>KOR</isoAlpha3>
+<fipsCode>KS</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Seoul</capital>
+<areaInSqKm>98480.0</areaInSqKm>
+<population>48422644</population>
+<currencyCode>KRW</currencyCode>
+<languages>ko-KR,en</languages>
+<geonameId>1835841</geonameId>
+<west>125.887108</west>
+<north>38.612446</north>
+<east>129.584671</east>
+<south>33.190945</south>
+</country>
+<country>
+<countryCode>KW</countryCode>
+<countryName>Kuwait</countryName>
+<isoNumeric>414</isoNumeric>
+<isoAlpha3>KWT</isoAlpha3>
+<fipsCode>KU</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Kuwait City</capital>
+<areaInSqKm>17820.0</areaInSqKm>
+<population>2789132</population>
+<currencyCode>KWD</currencyCode>
+<languages>ar-KW,en</languages>
+<geonameId>285570</geonameId>
+<west>46.555557</west>
+<north>30.095945</north>
+<east>48.431473</east>
+<south>28.524611</south>
+</country>
+<country>
+<countryCode>KY</countryCode>
+<countryName>Cayman Islands</countryName>
+<isoNumeric>136</isoNumeric>
+<isoAlpha3>CYM</isoAlpha3>
+<fipsCode>CJ</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>George Town</capital>
+<areaInSqKm>262.0</areaInSqKm>
+<population>44270</population>
+<currencyCode>KYD</currencyCode>
+<languages>en-KY</languages>
+<geonameId>3580718</geonameId>
+<west>-81.432777</west>
+<north>19.7617</north>
+<east>-79.727272</east>
+<south>19.263029</south>
+</country>
+<country>
+<countryCode>KZ</countryCode>
+<countryName>Kazakhstan</countryName>
+<isoNumeric>398</isoNumeric>
+<isoAlpha3>KAZ</isoAlpha3>
+<fipsCode>KZ</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Astana</capital>
+<areaInSqKm>2717300.0</areaInSqKm>
+<population>15340000</population>
+<currencyCode>KZT</currencyCode>
+<languages>kk,ru</languages>
+<geonameId>1522867</geonameId>
+<west>46.491859</west>
+<north>55.451195</north>
+<east>87.312668</east>
+<south>40.936333</south>
+</country>
+<country>
+<countryCode>LA</countryCode>
+<countryName>Laos</countryName>
+<isoNumeric>418</isoNumeric>
+<isoAlpha3>LAO</isoAlpha3>
+<fipsCode>LA</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Vientiane</capital>
+<areaInSqKm>236800.0</areaInSqKm>
+<population>6368162</population>
+<currencyCode>LAK</currencyCode>
+<languages>lo,fr,en</languages>
+<geonameId>1655842</geonameId>
+<west>100.093056</west>
+<north>22.500389</north>
+<east>107.697029</east>
+<south>13.910027</south>
+</country>
+<country>
+<countryCode>LB</countryCode>
+<countryName>Lebanon</countryName>
+<isoNumeric>422</isoNumeric>
+<isoAlpha3>LBN</isoAlpha3>
+<fipsCode>LE</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Beirut</capital>
+<areaInSqKm>10400.0</areaInSqKm>
+<population>4125247</population>
+<currencyCode>LBP</currencyCode>
+<languages>ar-LB,fr-LB,en,hy</languages>
+<geonameId>272103</geonameId>
+<west>35.114277</west>
+<north>34.691418</north>
+<east>36.639194</east>
+<south>33.05386</south>
+</country>
+<country>
+<countryCode>LC</countryCode>
+<countryName>Saint Lucia</countryName>
+<isoNumeric>662</isoNumeric>
+<isoAlpha3>LCA</isoAlpha3>
+<fipsCode>ST</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Castries</capital>
+<areaInSqKm>616.0</areaInSqKm>
+<population>160922</population>
+<currencyCode>XCD</currencyCode>
+<languages>en-LC</languages>
+<geonameId>3576468</geonameId>
+<west>-61.07415</west>
+<north>14.103245</north>
+<east>-60.874203</east>
+<south>13.704778</south>
+</country>
+<country>
+<countryCode>LI</countryCode>
+<countryName>Liechtenstein</countryName>
+<isoNumeric>438</isoNumeric>
+<isoAlpha3>LIE</isoAlpha3>
+<fipsCode>LS</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Vaduz</capital>
+<areaInSqKm>160.0</areaInSqKm>
+<population>35000</population>
+<currencyCode>CHF</currencyCode>
+<languages>de-LI</languages>
+<geonameId>3042058</geonameId>
+<west>9.477805</west>
+<north>47.273529</north>
+<east>9.632195</east>
+<south>47.055862</south>
+</country>
+<country>
+<countryCode>LK</countryCode>
+<countryName>Sri Lanka</countryName>
+<isoNumeric>144</isoNumeric>
+<isoAlpha3>LKA</isoAlpha3>
+<fipsCode>CE</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Colombo</capital>
+<areaInSqKm>65610.0</areaInSqKm>
+<population>21513990</population>
+<currencyCode>LKR</currencyCode>
+<languages>si,ta,en</languages>
+<geonameId>1227603</geonameId>
+<west>79.652916</west>
+<north>9.831361</north>
+<east>81.881279</east>
+<south>5.916833</south>
+</country>
+<country>
+<countryCode>LR</countryCode>
+<countryName>Liberia</countryName>
+<isoNumeric>430</isoNumeric>
+<isoAlpha3>LBR</isoAlpha3>
+<fipsCode>LI</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Monrovia</capital>
+<areaInSqKm>111370.0</areaInSqKm>
+<population>3685076</population>
+<currencyCode>LRD</currencyCode>
+<languages>en-LR</languages>
+<geonameId>2275384</geonameId>
+<west>-11.492083</west>
+<north>8.551791</north>
+<east>-7.365113</east>
+<south>4.353057</south>
+</country>
+<country>
+<countryCode>LS</countryCode>
+<countryName>Lesotho</countryName>
+<isoNumeric>426</isoNumeric>
+<isoAlpha3>LSO</isoAlpha3>
+<fipsCode>LT</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Maseru</capital>
+<areaInSqKm>30355.0</areaInSqKm>
+<population>1919552</population>
+<currencyCode>LSL</currencyCode>
+<languages>en-LS,st,zu,xh</languages>
+<geonameId>932692</geonameId>
+<west>27.029068</west>
+<north>-28.572058</north>
+<east>29.465761</east>
+<south>-30.668964</south>
+</country>
+<country>
+<countryCode>LT</countryCode>
+<countryName>Lithuania</countryName>
+<isoNumeric>440</isoNumeric>
+<isoAlpha3>LTU</isoAlpha3>
+<fipsCode>LH</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Vilnius</capital>
+<areaInSqKm>65200.0</areaInSqKm>
+<population>3565000</population>
+<currencyCode>LTL</currencyCode>
+<languages>lt,ru,pl</languages>
+<geonameId>597427</geonameId>
+<west>20.941528</west>
+<north>56.446918</north>
+<east>26.871944</east>
+<south>53.901306</south>
+</country>
+<country>
+<countryCode>LU</countryCode>
+<countryName>Luxembourg</countryName>
+<isoNumeric>442</isoNumeric>
+<isoAlpha3>LUX</isoAlpha3>
+<fipsCode>LU</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Luxembourg</capital>
+<areaInSqKm>2586.0</areaInSqKm>
+<population>497538</population>
+<currencyCode>EUR</currencyCode>
+<languages>lb,de-LU,fr-LU</languages>
+<geonameId>2960313</geonameId>
+<west>5.734556</west>
+<north>50.184944</north>
+<east>6.528472</east>
+<south>49.446583</south>
+</country>
+<country>
+<countryCode>LV</countryCode>
+<countryName>Latvia</countryName>
+<isoNumeric>428</isoNumeric>
+<isoAlpha3>LVA</isoAlpha3>
+<fipsCode>LG</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Riga</capital>
+<areaInSqKm>64589.0</areaInSqKm>
+<population>2217969</population>
+<currencyCode>LVL</currencyCode>
+<languages>lv,ru,lt</languages>
+<geonameId>458258</geonameId>
+<west>20.974277</west>
+<north>58.082306</north>
+<east>28.241167</east>
+<south>55.668861</south>
+</country>
+<country>
+<countryCode>LY</countryCode>
+<countryName>Libya</countryName>
+<isoNumeric>434</isoNumeric>
+<isoAlpha3>LBY</isoAlpha3>
+<fipsCode>LY</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Tripoli</capital>
+<areaInSqKm>1759540.0</areaInSqKm>
+<population>6461454</population>
+<currencyCode>LYD</currencyCode>
+<languages>ar-LY,it,en</languages>
+<geonameId>2215636</geonameId>
+<west>9.38702</west>
+<north>33.168999</north>
+<east>25.150612</east>
+<south>19.508045</south>
+</country>
+<country>
+<countryCode>MA</countryCode>
+<countryName>Morocco</countryName>
+<isoNumeric>504</isoNumeric>
+<isoAlpha3>MAR</isoAlpha3>
+<fipsCode>MO</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Rabat</capital>
+<areaInSqKm>446550.0</areaInSqKm>
+<population>31627428</population>
+<currencyCode>MAD</currencyCode>
+<languages>ar-MA,fr</languages>
+<geonameId>2542007</geonameId>
+<west>-13.168586</west>
+<north>35.9224966985384</north>
+<east>-0.991750000000025</east>
+<south>27.662115</south>
+</country>
+<country>
+<countryCode>MC</countryCode>
+<countryName>Monaco</countryName>
+<isoNumeric>492</isoNumeric>
+<isoAlpha3>MCO</isoAlpha3>
+<fipsCode>MN</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Monaco</capital>
+<areaInSqKm>1.95</areaInSqKm>
+<population>32965</population>
+<currencyCode>EUR</currencyCode>
+<languages>fr-MC,en,it</languages>
+<geonameId>2993457</geonameId>
+<west>7.408962249755859</west>
+<north>43.75196717037228</north>
+<east>7.439939260482788</east>
+<south>43.72472839869377</south>
+</country>
+<country>
+<countryCode>MD</countryCode>
+<countryName>Moldova</countryName>
+<isoNumeric>498</isoNumeric>
+<isoAlpha3>MDA</isoAlpha3>
+<fipsCode>MD</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Chişinău</capital>
+<areaInSqKm>33843.0</areaInSqKm>
+<population>4324000</population>
+<currencyCode>MDL</currencyCode>
+<languages>ro,ru,gag,tr</languages>
+<geonameId>617790</geonameId>
+<west>26.618944</west>
+<north>48.490166</north>
+<east>30.135445</east>
+<south>45.468887</south>
+</country>
+<country>
+<countryCode>ME</countryCode>
+<countryName>Montenegro</countryName>
+<isoNumeric>499</isoNumeric>
+<isoAlpha3>MNE</isoAlpha3>
+<fipsCode>MJ</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Podgorica</capital>
+<areaInSqKm>14026.0</areaInSqKm>
+<population>666730</population>
+<currencyCode>EUR</currencyCode>
+<languages>sr,hu,bs,sq,hr,rom</languages>
+<geonameId>3194884</geonameId>
+<west>18.461306</west>
+<north>43.570137</north>
+<east>20.358833</east>
+<south>41.850166</south>
+</country>
+<country>
+<countryCode>MF</countryCode>
+<countryName>Saint Martin</countryName>
+<isoNumeric>663</isoNumeric>
+<isoAlpha3>MAF</isoAlpha3>
+<fipsCode>RN</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Marigot</capital>
+<areaInSqKm>53.0</areaInSqKm>
+<population>35925</population>
+<currencyCode>EUR</currencyCode>
+<languages>fr</languages>
+<geonameId>3578421</geonameId>
+<west>-63.152767</west>
+<north>18.130354</north>
+<east>-63.012993</east>
+<south>18.052231</south>
+</country>
+<country>
+<countryCode>MG</countryCode>
+<countryName>Madagascar</countryName>
+<isoNumeric>450</isoNumeric>
+<isoAlpha3>MDG</isoAlpha3>
+<fipsCode>MA</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Antananarivo</capital>
+<areaInSqKm>587040.0</areaInSqKm>
+<population>21281844</population>
+<currencyCode>MGA</currencyCode>
+<languages>fr-MG,mg</languages>
+<geonameId>1062947</geonameId>
+<west>43.224876</west>
+<north>-11.945433</north>
+<east>50.48378</east>
+<south>-25.608952</south>
+</country>
+<country>
+<countryCode>MH</countryCode>
+<countryName>Marshall Islands</countryName>
+<isoNumeric>584</isoNumeric>
+<isoAlpha3>MHL</isoAlpha3>
+<fipsCode>RM</fipsCode>
+<continent>OC</continent>
+<continentName>Oceania</continentName>
+<capital>Majuro</capital>
+<areaInSqKm>181.3</areaInSqKm>
+<population>65859</population>
+<currencyCode>USD</currencyCode>
+<languages>mh,en-MH</languages>
+<geonameId>2080185</geonameId>
+<west>165.524918</west>
+<north>14.62</north>
+<east>171.931808</east>
+<south>5.587639</south>
+</country>
+<country>
+<countryCode>MK</countryCode>
+<countryName>Macedonia</countryName>
+<isoNumeric>807</isoNumeric>
+<isoAlpha3>MKD</isoAlpha3>
+<fipsCode>MK</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Skopje</capital>
+<areaInSqKm>25333.0</areaInSqKm>
+<population>2062294</population>
+<currencyCode>MKD</currencyCode>
+<languages>mk,sq,tr,rmm,sr</languages>
+<geonameId>718075</geonameId>
+<west>20.464695</west>
+<north>42.361805</north>
+<east>23.038139</east>
+<south>40.860195</south>
+</country>
+<country>
+<countryCode>ML</countryCode>
+<countryName>Mali</countryName>
+<isoNumeric>466</isoNumeric>
+<isoAlpha3>MLI</isoAlpha3>
+<fipsCode>ML</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Bamako</capital>
+<areaInSqKm>1240000.0</areaInSqKm>
+<population>13796354</population>
+<currencyCode>XOF</currencyCode>
+<languages>fr-ML,bm</languages>
+<geonameId>2453866</geonameId>
+<west>-12.242614</west>
+<north>25.000002</north>
+<east>4.244968</east>
+<south>10.159513</south>
+</country>
+<country>
+<countryCode>MM</countryCode>
+<countryName>Myanmar [Burma]</countryName>
+<isoNumeric>104</isoNumeric>
+<isoAlpha3>MMR</isoAlpha3>
+<fipsCode>BM</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Nay Pyi Taw</capital>
+<areaInSqKm>678500.0</areaInSqKm>
+<population>53414374</population>
+<currencyCode>MMK</currencyCode>
+<languages>my</languages>
+<geonameId>1327865</geonameId>
+<west>92.189278</west>
+<north>28.543249</north>
+<east>101.176781</east>
+<south>9.784583</south>
+</country>
+<country>
+<countryCode>MN</countryCode>
+<countryName>Mongolia</countryName>
+<isoNumeric>496</isoNumeric>
+<isoAlpha3>MNG</isoAlpha3>
+<fipsCode>MG</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Ulan Bator</capital>
+<areaInSqKm>1565000.0</areaInSqKm>
+<population>3086918</population>
+<currencyCode>MNT</currencyCode>
+<languages>mn,ru</languages>
+<geonameId>2029969</geonameId>
+<west>87.749664</west>
+<north>52.154251</north>
+<east>119.924309</east>
+<south>41.567638</south>
+</country>
+<country>
+<countryCode>MO</countryCode>
+<countryName>Macao</countryName>
+<isoNumeric>446</isoNumeric>
+<isoAlpha3>MAC</isoAlpha3>
+<fipsCode>MC</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Macao</capital>
+<areaInSqKm>254.0</areaInSqKm>
+<population>449198</population>
+<currencyCode>MOP</currencyCode>
+<languages>zh,zh-MO,pt</languages>
+<geonameId>1821275</geonameId>
+<west>113.528946</west>
+<north>22.222334</north>
+<east>113.565834</east>
+<south>22.180389</south>
+</country>
+<country>
+<countryCode>MP</countryCode>
+<countryName>Northern Mariana Islands</countryName>
+<isoNumeric>580</isoNumeric>
+<isoAlpha3>MNP</isoAlpha3>
+<fipsCode>CQ</fipsCode>
+<continent>OC</continent>
+<continentName>Oceania</continentName>
+<capital>Saipan</capital>
+<areaInSqKm>477.0</areaInSqKm>
+<population>53883</population>
+<currencyCode>USD</currencyCode>
+<languages>fil,tl,zh,ch-MP,en-MP</languages>
+<geonameId>4041468</geonameId>
+<west>144.88626</west>
+<north>20.55344</north>
+<east>146.06528</east>
+<south>14.11023</south>
+</country>
+<country>
+<countryCode>MQ</countryCode>
+<countryName>Martinique</countryName>
+<isoNumeric>474</isoNumeric>
+<isoAlpha3>MTQ</isoAlpha3>
+<fipsCode>MB</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Fort-de-France</capital>
+<areaInSqKm>1100.0</areaInSqKm>
+<population>432900</population>
+<currencyCode>EUR</currencyCode>
+<languages>fr-MQ</languages>
+<geonameId>3570311</geonameId>
+<west>-61.230118</west>
+<north>14.878819</north>
+<east>-60.81551</east>
+<south>14.392262</south>
+</country>
+<country>
+<countryCode>MR</countryCode>
+<countryName>Mauritania</countryName>
+<isoNumeric>478</isoNumeric>
+<isoAlpha3>MRT</isoAlpha3>
+<fipsCode>MR</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Nouakchott</capital>
+<areaInSqKm>1030700.0</areaInSqKm>
+<population>3205060</population>
+<currencyCode>MRO</currencyCode>
+<languages>ar-MR,fuc,snk,fr,mey,wo</languages>
+<geonameId>2378080</geonameId>
+<west>-17.066521</west>
+<north>27.298073</north>
+<east>-4.827674</east>
+<south>14.715547</south>
+</country>
+<country>
+<countryCode>MS</countryCode>
+<countryName>Montserrat</countryName>
+<isoNumeric>500</isoNumeric>
+<isoAlpha3>MSR</isoAlpha3>
+<fipsCode>MH</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Plymouth</capital>
+<areaInSqKm>102.0</areaInSqKm>
+<population>9341</population>
+<currencyCode>XCD</currencyCode>
+<languages>en-MS</languages>
+<geonameId>3578097</geonameId>
+<west>-62.24138237036129</west>
+<north>16.824060205313184</north>
+<east>-62.144100129608205</east>
+<south>16.674768935441556</south>
+</country>
+<country>
+<countryCode>MT</countryCode>
+<countryName>Malta</countryName>
+<isoNumeric>470</isoNumeric>
+<isoAlpha3>MLT</isoAlpha3>
+<fipsCode>MT</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Valletta</capital>
+<areaInSqKm>316.0</areaInSqKm>
+<population>403000</population>
+<currencyCode>EUR</currencyCode>
+<languages>mt,en-MT</languages>
+<geonameId>2562770</geonameId>
+<west>14.184376415657312</west>
+<north>36.079112527087844</north>
+<east>14.577639</east>
+<south>35.810276</south>
+</country>
+<country>
+<countryCode>MU</countryCode>
+<countryName>Mauritius</countryName>
+<isoNumeric>480</isoNumeric>
+<isoAlpha3>MUS</isoAlpha3>
+<fipsCode>MP</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Port Louis</capital>
+<areaInSqKm>2040.0</areaInSqKm>
+<population>1294104</population>
+<currencyCode>MUR</currencyCode>
+<languages>en-MU,bho,fr</languages>
+<geonameId>934292</geonameId>
+<west>56.512718</west>
+<north>-10.319255</north>
+<east>63.500179</east>
+<south>-20.525717</south>
+</country>
+<country>
+<countryCode>MV</countryCode>
+<countryName>Maldives</countryName>
+<isoNumeric>462</isoNumeric>
+<isoAlpha3>MDV</isoAlpha3>
+<fipsCode>MV</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Malé</capital>
+<areaInSqKm>300.0</areaInSqKm>
+<population>395650</population>
+<currencyCode>MVR</currencyCode>
+<languages>dv,en</languages>
+<geonameId>1282028</geonameId>
+<west>72.693222</west>
+<north>7.098361</north>
+<east>73.637276</east>
+<south>-0.692694</south>
+</country>
+<country>
+<countryCode>MW</countryCode>
+<countryName>Malawi</countryName>
+<isoNumeric>454</isoNumeric>
+<isoAlpha3>MWI</isoAlpha3>
+<fipsCode>MI</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Lilongwe</capital>
+<areaInSqKm>118480.0</areaInSqKm>
+<population>15447500</population>
+<currencyCode>MWK</currencyCode>
+<languages>ny,yao,tum,swk</languages>
+<geonameId>927384</geonameId>
+<west>32.67395</west>
+<north>-9.367541</north>
+<east>35.916821</east>
+<south>-17.125</south>
+</country>
+<country>
+<countryCode>MX</countryCode>
+<countryName>Mexico</countryName>
+<isoNumeric>484</isoNumeric>
+<isoAlpha3>MEX</isoAlpha3>
+<fipsCode>MX</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Mexico City</capital>
+<areaInSqKm>1972550.0</areaInSqKm>
+<population>112468855</population>
+<currencyCode>MXN</currencyCode>
+<languages>es-MX</languages>
+<geonameId>3996063</geonameId>
+<west>-118.453949</west>
+<north>32.716759</north>
+<east>-86.703392</east>
+<south>14.532866</south>
+</country>
+<country>
+<countryCode>MY</countryCode>
+<countryName>Malaysia</countryName>
+<isoNumeric>458</isoNumeric>
+<isoAlpha3>MYS</isoAlpha3>
+<fipsCode>MY</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Kuala Lumpur</capital>
+<areaInSqKm>329750.0</areaInSqKm>
+<population>28274729</population>
+<currencyCode>MYR</currencyCode>
+<languages>ms-MY,en,zh,ta,te,ml,pa,th</languages>
+<geonameId>1733045</geonameId>
+<west>99.643448</west>
+<north>7.363417</north>
+<east>119.267502</east>
+<south>0.855222</south>
+</country>
+<country>
+<countryCode>MZ</countryCode>
+<countryName>Mozambique</countryName>
+<isoNumeric>508</isoNumeric>
+<isoAlpha3>MOZ</isoAlpha3>
+<fipsCode>MZ</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Maputo</capital>
+<areaInSqKm>801590.0</areaInSqKm>
+<population>22061451</population>
+<currencyCode>MZN</currencyCode>
+<languages>pt-MZ,vmw</languages>
+<geonameId>1036973</geonameId>
+<west>30.217319</west>
+<north>-10.471883</north>
+<east>40.842995</east>
+<south>-26.868685</south>
+</country>
+<country>
+<countryCode>NA</countryCode>
+<countryName>Namibia</countryName>
+<isoNumeric>516</isoNumeric>
+<isoAlpha3>NAM</isoAlpha3>
+<fipsCode>WA</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Windhoek</capital>
+<areaInSqKm>825418.0</areaInSqKm>
+<population>2128471</population>
+<currencyCode>NAD</currencyCode>
+<languages>en-NA,af,de,hz,naq</languages>
+<geonameId>3355338</geonameId>
+<west>11.71563</west>
+<north>-16.959894</north>
+<east>25.256701</east>
+<south>-28.97143</south>
+</country>
+<country>
+<countryCode>NC</countryCode>
+<countryName>New Caledonia</countryName>
+<isoNumeric>540</isoNumeric>
+<isoAlpha3>NCL</isoAlpha3>
+<fipsCode>NC</fipsCode>
+<continent>OC</continent>
+<continentName>Oceania</continentName>
+<capital>Noumea</capital>
+<areaInSqKm>19060.0</areaInSqKm>
+<population>216494</population>
+<currencyCode>XPF</currencyCode>
+<languages>fr-NC</languages>
+<geonameId>2139685</geonameId>
+<west>163.564667</west>
+<north>-19.549778</north>
+<east>168.129135</east>
+<south>-22.698</south>
+</country>
+<country>
+<countryCode>NE</countryCode>
+<countryName>Niger</countryName>
+<isoNumeric>562</isoNumeric>
+<isoAlpha3>NER</isoAlpha3>
+<fipsCode>NG</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Niamey</capital>
+<areaInSqKm>1267000.0</areaInSqKm>
+<population>15878271</population>
+<currencyCode>XOF</currencyCode>
+<languages>fr-NE,ha,kr,dje</languages>
+<geonameId>2440476</geonameId>
+<west>0.16625</west>
+<north>23.525026</north>
+<east>15.995643</east>
+<south>11.696975</south>
+</country>
+<country>
+<countryCode>NF</countryCode>
+<countryName>Norfolk Island</countryName>
+<isoNumeric>574</isoNumeric>
+<isoAlpha3>NFK</isoAlpha3>
+<fipsCode>NF</fipsCode>
+<continent>OC</continent>
+<continentName>Oceania</continentName>
+<capital>Kingston</capital>
+<areaInSqKm>34.6</areaInSqKm>
+<population>1828</population>
+<currencyCode>AUD</currencyCode>
+<languages>en-NF</languages>
+<geonameId>2155115</geonameId>
+<west>167.91543230151365</west>
+<north>-28.995170686948427</north>
+<east>167.99773740209957</east>
+<south>-29.063076742954735</south>
+</country>
+<country>
+<countryCode>NG</countryCode>
+<countryName>Nigeria</countryName>
+<isoNumeric>566</isoNumeric>
+<isoAlpha3>NGA</isoAlpha3>
+<fipsCode>NI</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Abuja</capital>
+<areaInSqKm>923768.0</areaInSqKm>
+<population>154000000</population>
+<currencyCode>NGN</currencyCode>
+<languages>en-NG,ha,yo,ig,ff</languages>
+<geonameId>2328926</geonameId>
+<west>2.668432</west>
+<north>13.892007</north>
+<east>14.680073</east>
+<south>4.277144</south>
+</country>
+<country>
+<countryCode>NI</countryCode>
+<countryName>Nicaragua</countryName>
+<isoNumeric>558</isoNumeric>
+<isoAlpha3>NIC</isoAlpha3>
+<fipsCode>NU</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Managua</capital>
+<areaInSqKm>129494.0</areaInSqKm>
+<population>5995928</population>
+<currencyCode>NIO</currencyCode>
+<languages>es-NI,en</languages>
+<geonameId>3617476</geonameId>
+<west>-87.690308</west>
+<north>15.025909</north>
+<east>-82.738289</east>
+<south>10.707543</south>
+</country>
+<country>
+<countryCode>NL</countryCode>
+<countryName>Netherlands</countryName>
+<isoNumeric>528</isoNumeric>
+<isoAlpha3>NLD</isoAlpha3>
+<fipsCode>NL</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Amsterdam</capital>
+<areaInSqKm>41526.0</areaInSqKm>
+<population>16645000</population>
+<currencyCode>EUR</currencyCode>
+<languages>nl-NL,fy-NL</languages>
+<geonameId>2750405</geonameId>
+<west>3.362556</west>
+<north>53.512196</north>
+<east>7.227944</east>
+<south>50.753918</south>
+</country>
+<country>
+<countryCode>NO</countryCode>
+<countryName>Norway</countryName>
+<isoNumeric>578</isoNumeric>
+<isoAlpha3>NOR</isoAlpha3>
+<fipsCode>NO</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Oslo</capital>
+<areaInSqKm>324220.0</areaInSqKm>
+<population>5009150</population>
+<currencyCode>NOK</currencyCode>
+<languages>no,nb,nn,se,fi</languages>
+<geonameId>3144096</geonameId>
+<west>4.650167</west>
+<north>71.18811</north>
+<east>31.078052520751953</east>
+<south>57.977917</south>
+</country>
+<country>
+<countryCode>NP</countryCode>
+<countryName>Nepal</countryName>
+<isoNumeric>524</isoNumeric>
+<isoAlpha3>NPL</isoAlpha3>
+<fipsCode>NP</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Kathmandu</capital>
+<areaInSqKm>140800.0</areaInSqKm>
+<population>28951852</population>
+<currencyCode>NPR</currencyCode>
+<languages>ne,en</languages>
+<geonameId>1282988</geonameId>
+<west>80.056274</west>
+<north>30.43339</north>
+<east>88.199333</east>
+<south>26.356722</south>
+</country>
+<country>
+<countryCode>NR</countryCode>
+<countryName>Nauru</countryName>
+<isoNumeric>520</isoNumeric>
+<isoAlpha3>NRU</isoAlpha3>
+<fipsCode>NR</fipsCode>
+<continent>OC</continent>
+<continentName>Oceania</continentName>
+<capital/>
+<areaInSqKm>21.0</areaInSqKm>
+<population>10065</population>
+<currencyCode>AUD</currencyCode>
+<languages>na,en-NR</languages>
+<geonameId>2110425</geonameId>
+<west>166.899033</west>
+<north>-0.504306</north>
+<east>166.945282</east>
+<south>-0.552333</south>
+</country>
+<country>
+<countryCode>NU</countryCode>
+<countryName>Niue</countryName>
+<isoNumeric>570</isoNumeric>
+<isoAlpha3>NIU</isoAlpha3>
+<fipsCode>NE</fipsCode>
+<continent>OC</continent>
+<continentName>Oceania</continentName>
+<capital>Alofi</capital>
+<areaInSqKm>260.0</areaInSqKm>
+<population>2166</population>
+<currencyCode>NZD</currencyCode>
+<languages>niu,en-NU</languages>
+<geonameId>4036232</geonameId>
+<west>-169.951004</west>
+<north>-18.951069</north>
+<east>-169.775177</east>
+<south>-19.152193</south>
+</country>
+<country>
+<countryCode>NZ</countryCode>
+<countryName>New Zealand</countryName>
+<isoNumeric>554</isoNumeric>
+<isoAlpha3>NZL</isoAlpha3>
+<fipsCode>NZ</fipsCode>
+<continent>OC</continent>
+<continentName>Oceania</continentName>
+<capital>Wellington</capital>
+<areaInSqKm>268680.0</areaInSqKm>
+<population>4252277</population>
+<currencyCode>NZD</currencyCode>
+<languages>en-NZ,mi</languages>
+<geonameId>2186224</geonameId>
+<west>166.7155</west>
+<north>-34.389668</north>
+<east>-180.0</east>
+<south>-47.286026</south>
+</country>
+<country>
+<countryCode>OM</countryCode>
+<countryName>Oman</countryName>
+<isoNumeric>512</isoNumeric>
+<isoAlpha3>OMN</isoAlpha3>
+<fipsCode>MU</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Muscat</capital>
+<areaInSqKm>212460.0</areaInSqKm>
+<population>2967717</population>
+<currencyCode>OMR</currencyCode>
+<languages>ar-OM,en,bal,ur</languages>
+<geonameId>286963</geonameId>
+<west>51.882</west>
+<north>26.387972</north>
+<east>59.836582</east>
+<south>16.64575</south>
+</country>
+<country>
+<countryCode>PA</countryCode>
+<countryName>Panama</countryName>
+<isoNumeric>591</isoNumeric>
+<isoAlpha3>PAN</isoAlpha3>
+<fipsCode>PM</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Panama City</capital>
+<areaInSqKm>78200.0</areaInSqKm>
+<population>3410676</population>
+<currencyCode>PAB</currencyCode>
+<languages>es-PA,en</languages>
+<geonameId>3703430</geonameId>
+<west>-83.051445</west>
+<north>9.637514</north>
+<east>-77.17411</east>
+<south>7.197906</south>
+</country>
+<country>
+<countryCode>PE</countryCode>
+<countryName>Peru</countryName>
+<isoNumeric>604</isoNumeric>
+<isoAlpha3>PER</isoAlpha3>
+<fipsCode>PE</fipsCode>
+<continent>SA</continent>
+<continentName>South America</continentName>
+<capital>Lima</capital>
+<areaInSqKm>1285220.0</areaInSqKm>
+<population>29907003</population>
+<currencyCode>PEN</currencyCode>
+<languages>es-PE,qu,ay</languages>
+<geonameId>3932488</geonameId>
+<west>-81.326744</west>
+<north>-0.012977</north>
+<east>-68.677986</east>
+<south>-18.349728</south>
+</country>
+<country>
+<countryCode>PF</countryCode>
+<countryName>French Polynesia</countryName>
+<isoNumeric>258</isoNumeric>
+<isoAlpha3>PYF</isoAlpha3>
+<fipsCode>FP</fipsCode>
+<continent>OC</continent>
+<continentName>Oceania</continentName>
+<capital>Papeete</capital>
+<areaInSqKm>4167.0</areaInSqKm>
+<population>270485</population>
+<currencyCode>XPF</currencyCode>
+<languages>fr-PF,ty</languages>
+<geonameId>4030656</geonameId>
+<west>-152.877167</west>
+<north>-7.903573</north>
+<east>-134.929825</east>
+<south>-27.653572</south>
+</country>
+<country>
+<countryCode>PG</countryCode>
+<countryName>Papua New Guinea</countryName>
+<isoNumeric>598</isoNumeric>
+<isoAlpha3>PNG</isoAlpha3>
+<fipsCode>PP</fipsCode>
+<continent>OC</continent>
+<continentName>Oceania</continentName>
+<capital>Port Moresby</capital>
+<areaInSqKm>462840.0</areaInSqKm>
+<population>6064515</population>
+<currencyCode>PGK</currencyCode>
+<languages>en-PG,ho,meu,tpi</languages>
+<geonameId>2088628</geonameId>
+<west>140.842865</west>
+<north>-1.318639</north>
+<east>155.96344</east>
+<south>-11.657861</south>
+</country>
+<country>
+<countryCode>PH</countryCode>
+<countryName>Philippines</countryName>
+<isoNumeric>608</isoNumeric>
+<isoAlpha3>PHL</isoAlpha3>
+<fipsCode>RP</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Manila</capital>
+<areaInSqKm>300000.0</areaInSqKm>
+<population>99900177</population>
+<currencyCode>PHP</currencyCode>
+<languages>tl,en-PH,fil</languages>
+<geonameId>1694008</geonameId>
+<west>116.931557</west>
+<north>21.120611</north>
+<east>126.601524</east>
+<south>4.643306</south>
+</country>
+<country>
+<countryCode>PK</countryCode>
+<countryName>Pakistan</countryName>
+<isoNumeric>586</isoNumeric>
+<isoAlpha3>PAK</isoAlpha3>
+<fipsCode>PK</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Islamabad</capital>
+<areaInSqKm>803940.0</areaInSqKm>
+<population>184404791</population>
+<currencyCode>PKR</currencyCode>
+<languages>ur-PK,en-PK,pa,sd,ps,brh</languages>
+<geonameId>1168579</geonameId>
+<west>60.878613</west>
+<north>37.097</north>
+<east>77.840919</east>
+<south>23.786722</south>
+</country>
+<country>
+<countryCode>PL</countryCode>
+<countryName>Poland</countryName>
+<isoNumeric>616</isoNumeric>
+<isoAlpha3>POL</isoAlpha3>
+<fipsCode>PL</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Warsaw</capital>
+<areaInSqKm>312685.0</areaInSqKm>
+<population>38500000</population>
+<currencyCode>PLN</currencyCode>
+<languages>pl</languages>
+<geonameId>798544</geonameId>
+<west>14.123</west>
+<north>54.839138</north>
+<east>24.150749</east>
+<south>49.006363</south>
+</country>
+<country>
+<countryCode>PM</countryCode>
+<countryName>Saint Pierre and Miquelon</countryName>
+<isoNumeric>666</isoNumeric>
+<isoAlpha3>SPM</isoAlpha3>
+<fipsCode>SB</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Saint-Pierre</capital>
+<areaInSqKm>242.0</areaInSqKm>
+<population>7012</population>
+<currencyCode>EUR</currencyCode>
+<languages>fr-PM</languages>
+<geonameId>3424932</geonameId>
+<west>-56.420658</west>
+<north>47.146286</north>
+<east>-56.252991</east>
+<south>46.786041</south>
+</country>
+<country>
+<countryCode>PN</countryCode>
+<countryName>Pitcairn Islands</countryName>
+<isoNumeric>612</isoNumeric>
+<isoAlpha3>PCN</isoAlpha3>
+<fipsCode>PC</fipsCode>
+<continent>OC</continent>
+<continentName>Oceania</continentName>
+<capital>Adamstown</capital>
+<areaInSqKm>47.0</areaInSqKm>
+<population>46</population>
+<currencyCode>NZD</currencyCode>
+<languages>en-PN</languages>
+<geonameId>4030699</geonameId>
+<west>-128.346436</west>
+<north>-24.315865</north>
+<east>-124.77285</east>
+<south>-24.672565</south>
+</country>
+<country>
+<countryCode>PR</countryCode>
+<countryName>Puerto Rico</countryName>
+<isoNumeric>630</isoNumeric>
+<isoAlpha3>PRI</isoAlpha3>
+<fipsCode>RQ</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>San Juan</capital>
+<areaInSqKm>9104.0</areaInSqKm>
+<population>3916632</population>
+<currencyCode>USD</currencyCode>
+<languages>en-PR,es-PR</languages>
+<geonameId>4566966</geonameId>
+<west>-67.942726</west>
+<north>18.520166</north>
+<east>-65.242737</east>
+<south>17.926405</south>
+</country>
+<country>
+<countryCode>PS</countryCode>
+<countryName>Palestine</countryName>
+<isoNumeric>275</isoNumeric>
+<isoAlpha3>PSE</isoAlpha3>
+<fipsCode>WE</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital/>
+<areaInSqKm>5970.0</areaInSqKm>
+<population>3800000</population>
+<currencyCode>ILS</currencyCode>
+<languages>ar-PS</languages>
+<geonameId>6254930</geonameId>
+<west>34.21665954589844</west>
+<north>32.54638671875</north>
+<east>35.5732955932617</east>
+<south>31.216541290283203</south>
+</country>
+<country>
+<countryCode>PT</countryCode>
+<countryName>Portugal</countryName>
+<isoNumeric>620</isoNumeric>
+<isoAlpha3>PRT</isoAlpha3>
+<fipsCode>PO</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Lisbon</capital>
+<areaInSqKm>92391.0</areaInSqKm>
+<population>10676000</population>
+<currencyCode>EUR</currencyCode>
+<languages>pt-PT,mwl</languages>
+<geonameId>2264397</geonameId>
+<west>-9.495944</west>
+<north>42.145638</north>
+<east>-6.182694</east>
+<south>36.96125</south>
+</country>
+<country>
+<countryCode>PW</countryCode>
+<countryName>Palau</countryName>
+<isoNumeric>585</isoNumeric>
+<isoAlpha3>PLW</isoAlpha3>
+<fipsCode>PS</fipsCode>
+<continent>OC</continent>
+<continentName>Oceania</continentName>
+<capital>Melekeok - Palau State Capital</capital>
+<areaInSqKm>458.0</areaInSqKm>
+<population>19907</population>
+<currencyCode>USD</currencyCode>
+<languages>pau,sov,en-PW,tox,ja,fil,zh</languages>
+<geonameId>1559582</geonameId>
+<west>131.11788</west>
+<north>8.46966</north>
+<east>134.72307</east>
+<south>2.8036</south>
+</country>
+<country>
+<countryCode>PY</countryCode>
+<countryName>Paraguay</countryName>
+<isoNumeric>600</isoNumeric>
+<isoAlpha3>PRY</isoAlpha3>
+<fipsCode>PA</fipsCode>
+<continent>SA</continent>
+<continentName>South America</continentName>
+<capital>Asunción</capital>
+<areaInSqKm>406750.0</areaInSqKm>
+<population>6375830</population>
+<currencyCode>PYG</currencyCode>
+<languages>es-PY,gn</languages>
+<geonameId>3437598</geonameId>
+<west>-62.647076</west>
+<north>-19.294041</north>
+<east>-54.259354</east>
+<south>-27.608738</south>
+</country>
+<country>
+<countryCode>QA</countryCode>
+<countryName>Qatar</countryName>
+<isoNumeric>634</isoNumeric>
+<isoAlpha3>QAT</isoAlpha3>
+<fipsCode>QA</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Doha</capital>
+<areaInSqKm>11437.0</areaInSqKm>
+<population>840926</population>
+<currencyCode>QAR</currencyCode>
+<languages>ar-QA,es</languages>
+<geonameId>289688</geonameId>
+<west>50.757221</west>
+<north>26.154722</north>
+<east>51.636639</east>
+<south>24.482944</south>
+</country>
+<country>
+<countryCode>RE</countryCode>
+<countryName>Réunion</countryName>
+<isoNumeric>638</isoNumeric>
+<isoAlpha3>REU</isoAlpha3>
+<fipsCode>RE</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Saint-Denis</capital>
+<areaInSqKm>2517.0</areaInSqKm>
+<population>776948</population>
+<currencyCode>EUR</currencyCode>
+<languages>fr-RE</languages>
+<geonameId>935317</geonameId>
+<west>55.219086</west>
+<north>-20.856855</north>
+<east>55.845039</east>
+<south>-21.372211</south>
+</country>
+<country>
+<countryCode>RO</countryCode>
+<countryName>Romania</countryName>
+<isoNumeric>642</isoNumeric>
+<isoAlpha3>ROU</isoAlpha3>
+<fipsCode>RO</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Bucharest</capital>
+<areaInSqKm>237500.0</areaInSqKm>
+<population>21959278</population>
+<currencyCode>RON</currencyCode>
+<languages>ro,hu,rom</languages>
+<geonameId>798549</geonameId>
+<west>20.269972</west>
+<north>48.266945</north>
+<east>29.691055</east>
+<south>43.627304</south>
+</country>
+<country>
+<countryCode>RS</countryCode>
+<countryName>Serbia</countryName>
+<isoNumeric>688</isoNumeric>
+<isoAlpha3>SRB</isoAlpha3>
+<fipsCode>RI</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Belgrade</capital>
+<areaInSqKm>88361.0</areaInSqKm>
+<population>7344847</population>
+<currencyCode>RSD</currencyCode>
+<languages>sr,hu,bs,rom</languages>
+<geonameId>6290252</geonameId>
+<west>18.817020416259766</west>
+<north>46.18138885498047</north>
+<east>23.00499725341797</east>
+<south>42.232215881347656</south>
+</country>
+<country>
+<countryCode>RU</countryCode>
+<countryName>Russia</countryName>
+<isoNumeric>643</isoNumeric>
+<isoAlpha3>RUS</isoAlpha3>
+<fipsCode>RS</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Moscow</capital>
+<areaInSqKm>1.71E7</areaInSqKm>
+<population>140702000</population>
+<currencyCode>RUB</currencyCode>
+<languages>ru,tt,xal,cau,ady,kv,ce,tyv,cv,udm,tut,mns,bua,myv,mdf,chm,ba,inh,tut,kbd,krc,ava,sah,nog</languages>
+<geonameId>2017370</geonameId>
+<west>19.25</west>
+<north>81.857361</north>
+<east>-169.05</east>
+<south>41.188862</south>
+</country>
+<country>
+<countryCode>RW</countryCode>
+<countryName>Rwanda</countryName>
+<isoNumeric>646</isoNumeric>
+<isoAlpha3>RWA</isoAlpha3>
+<fipsCode>RW</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Kigali</capital>
+<areaInSqKm>26338.0</areaInSqKm>
+<population>11055976</population>
+<currencyCode>RWF</currencyCode>
+<languages>rw,en-RW,fr-RW,sw</languages>
+<geonameId>49518</geonameId>
+<west>28.856794</west>
+<north>-1.053481</north>
+<east>30.895958</east>
+<south>-2.840679</south>
+</country>
+<country>
+<countryCode>SA</countryCode>
+<countryName>Saudi Arabia</countryName>
+<isoNumeric>682</isoNumeric>
+<isoAlpha3>SAU</isoAlpha3>
+<fipsCode>SA</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Riyadh</capital>
+<areaInSqKm>1960582.0</areaInSqKm>
+<population>25731776</population>
+<currencyCode>SAR</currencyCode>
+<languages>ar-SA</languages>
+<geonameId>102358</geonameId>
+<west>34.495693</west>
+<north>32.158333</north>
+<east>55.666584</east>
+<south>15.61425</south>
+</country>
+<country>
+<countryCode>SB</countryCode>
+<countryName>Solomon Islands</countryName>
+<isoNumeric>090</isoNumeric>
+<isoAlpha3>SLB</isoAlpha3>
+<fipsCode>BP</fipsCode>
+<continent>OC</continent>
+<continentName>Oceania</continentName>
+<capital>Honiara</capital>
+<areaInSqKm>28450.0</areaInSqKm>
+<population>559198</population>
+<currencyCode>SBD</currencyCode>
+<languages>en-SB,tpi</languages>
+<geonameId>2103350</geonameId>
+<west>155.508606</west>
+<north>-6.589611</north>
+<east>166.980865</east>
+<south>-11.850555</south>
+</country>
+<country>
+<countryCode>SC</countryCode>
+<countryName>Seychelles</countryName>
+<isoNumeric>690</isoNumeric>
+<isoAlpha3>SYC</isoAlpha3>
+<fipsCode>SE</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Victoria</capital>
+<areaInSqKm>455.0</areaInSqKm>
+<population>88340</population>
+<currencyCode>SCR</currencyCode>
+<languages>en-SC,fr-SC</languages>
+<geonameId>241170</geonameId>
+<west>46.204769</west>
+<north>-4.283717</north>
+<east>56.279507</east>
+<south>-9.753867</south>
+</country>
+<country>
+<countryCode>SD</countryCode>
+<countryName>Sudan</countryName>
+<isoNumeric>729</isoNumeric>
+<isoAlpha3>SDN</isoAlpha3>
+<fipsCode>SU</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Khartoum</capital>
+<areaInSqKm>1861484.0</areaInSqKm>
+<population>35000000</population>
+<currencyCode>SDG</currencyCode>
+<languages>ar-SD,en,fia</languages>
+<geonameId>366755</geonameId>
+<west>21.827774047851562</west>
+<north>22.232219696044922</north>
+<east>38.60749816894531</east>
+<south>8.684720993041992</south>
+</country>
+<country>
+<countryCode>SE</countryCode>
+<countryName>Sweden</countryName>
+<isoNumeric>752</isoNumeric>
+<isoAlpha3>SWE</isoAlpha3>
+<fipsCode>SW</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Stockholm</capital>
+<areaInSqKm>449964.0</areaInSqKm>
+<population>9555893</population>
+<currencyCode>SEK</currencyCode>
+<languages>sv-SE,se,sma,fi-SE</languages>
+<geonameId>2661886</geonameId>
+<west>11.118694</west>
+<north>69.0625</north>
+<east>24.156292483918484</east>
+<south>55.337112</south>
+</country>
+<country>
+<countryCode>SG</countryCode>
+<countryName>Singapore</countryName>
+<isoNumeric>702</isoNumeric>
+<isoAlpha3>SGP</isoAlpha3>
+<fipsCode>SN</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Singapore</capital>
+<areaInSqKm>692.7</areaInSqKm>
+<population>4701069</population>
+<currencyCode>SGD</currencyCode>
+<languages>cmn,en-SG,ms-SG,ta-SG,zh-SG</languages>
+<geonameId>1880251</geonameId>
+<west>103.638275</west>
+<north>1.471278</north>
+<east>104.007469</east>
+<south>1.258556</south>
+</country>
+<country>
+<countryCode>SH</countryCode>
+<countryName>Saint Helena</countryName>
+<isoNumeric>654</isoNumeric>
+<isoAlpha3>SHN</isoAlpha3>
+<fipsCode>SH</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Jamestown</capital>
+<areaInSqKm>410.0</areaInSqKm>
+<population>7460</population>
+<currencyCode>SHP</currencyCode>
+<languages>en-SH</languages>
+<geonameId>3370751</geonameId>
+<west>-14.42123</west>
+<north>-7.887815</north>
+<east>-5.638753</east>
+<south>-16.019543</south>
+</country>
+<country>
+<countryCode>SI</countryCode>
+<countryName>Slovenia</countryName>
+<isoNumeric>705</isoNumeric>
+<isoAlpha3>SVN</isoAlpha3>
+<fipsCode>SI</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Ljubljana</capital>
+<areaInSqKm>20273.0</areaInSqKm>
+<population>2007000</population>
+<currencyCode>EUR</currencyCode>
+<languages>sl,sh</languages>
+<geonameId>3190538</geonameId>
+<west>13.383083</west>
+<north>46.877918</north>
+<east>16.566</east>
+<south>45.413139</south>
+</country>
+<country>
+<countryCode>SJ</countryCode>
+<countryName>Svalbard and Jan Mayen</countryName>
+<isoNumeric>744</isoNumeric>
+<isoAlpha3>SJM</isoAlpha3>
+<fipsCode>SV</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Longyearbyen</capital>
+<areaInSqKm>62049.0</areaInSqKm>
+<population>2550</population>
+<currencyCode>NOK</currencyCode>
+<languages>no,ru</languages>
+<geonameId>607072</geonameId>
+<west>17.699389</west>
+<north>80.762085</north>
+<east>33.287334</east>
+<south>79.220306</south>
+</country>
+<country>
+<countryCode>SK</countryCode>
+<countryName>Slovakia</countryName>
+<isoNumeric>703</isoNumeric>
+<isoAlpha3>SVK</isoAlpha3>
+<fipsCode>LO</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Bratislava</capital>
+<areaInSqKm>48845.0</areaInSqKm>
+<population>5455000</population>
+<currencyCode>EUR</currencyCode>
+<languages>sk,hu</languages>
+<geonameId>3057568</geonameId>
+<west>16.84775</west>
+<north>49.603168</north>
+<east>22.570444</east>
+<south>47.728111</south>
+</country>
+<country>
+<countryCode>SL</countryCode>
+<countryName>Sierra Leone</countryName>
+<isoNumeric>694</isoNumeric>
+<isoAlpha3>SLE</isoAlpha3>
+<fipsCode>SL</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Freetown</capital>
+<areaInSqKm>71740.0</areaInSqKm>
+<population>5245695</population>
+<currencyCode>SLL</currencyCode>
+<languages>en-SL,men,tem</languages>
+<geonameId>2403846</geonameId>
+<west>-13.307631</west>
+<north>10.0</north>
+<east>-10.284238</east>
+<south>6.929611</south>
+</country>
+<country>
+<countryCode>SM</countryCode>
+<countryName>San Marino</countryName>
+<isoNumeric>674</isoNumeric>
+<isoAlpha3>SMR</isoAlpha3>
+<fipsCode>SM</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>San Marino</capital>
+<areaInSqKm>61.2</areaInSqKm>
+<population>31477</population>
+<currencyCode>EUR</currencyCode>
+<languages>it-SM</languages>
+<geonameId>3168068</geonameId>
+<west>12.403538978820734</west>
+<north>43.99223730851663</north>
+<east>12.51653186779788</east>
+<south>43.8937092171425</south>
+</country>
+<country>
+<countryCode>SN</countryCode>
+<countryName>Senegal</countryName>
+<isoNumeric>686</isoNumeric>
+<isoAlpha3>SEN</isoAlpha3>
+<fipsCode>SG</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Dakar</capital>
+<areaInSqKm>196190.0</areaInSqKm>
+<population>12323252</population>
+<currencyCode>XOF</currencyCode>
+<languages>fr-SN,wo,fuc,mnk</languages>
+<geonameId>2245662</geonameId>
+<west>-17.535236</west>
+<north>16.691633</north>
+<east>-11.355887</east>
+<south>12.307275</south>
+</country>
+<country>
+<countryCode>SO</countryCode>
+<countryName>Somalia</countryName>
+<isoNumeric>706</isoNumeric>
+<isoAlpha3>SOM</isoAlpha3>
+<fipsCode>SO</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Mogadishu</capital>
+<areaInSqKm>637657.0</areaInSqKm>
+<population>10112453</population>
+<currencyCode>SOS</currencyCode>
+<languages>so-SO,ar-SO,it,en-SO</languages>
+<geonameId>51537</geonameId>
+<west>40.986595</west>
+<north>11.979166</north>
+<east>51.412636</east>
+<south>-1.674868</south>
+</country>
+<country>
+<countryCode>SR</countryCode>
+<countryName>Suriname</countryName>
+<isoNumeric>740</isoNumeric>
+<isoAlpha3>SUR</isoAlpha3>
+<fipsCode>NS</fipsCode>
+<continent>SA</continent>
+<continentName>South America</continentName>
+<capital>Paramaribo</capital>
+<areaInSqKm>163270.0</areaInSqKm>
+<population>492829</population>
+<currencyCode>SRD</currencyCode>
+<languages>nl-SR,en,srn,hns,jv</languages>
+<geonameId>3382998</geonameId>
+<west>-58.086563</west>
+<north>6.004546</north>
+<east>-53.977493</east>
+<south>1.831145</south>
+</country>
+<country>
+<countryCode>SS</countryCode>
+<countryName>South Sudan</countryName>
+<isoNumeric>728</isoNumeric>
+<isoAlpha3>SSD</isoAlpha3>
+<fipsCode>OD</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Juba</capital>
+<areaInSqKm>644329.0</areaInSqKm>
+<population>8260490</population>
+<currencyCode>SSP</currencyCode>
+<languages>en</languages>
+<geonameId>7909807</geonameId>
+<west>24.140274047851562</west>
+<north>12.219148635864258</north>
+<east>35.9405517578125</east>
+<south>3.493394374847412</south>
+</country>
+<country>
+<countryCode>ST</countryCode>
+<countryName>São Tomé and Príncipe</countryName>
+<isoNumeric>678</isoNumeric>
+<isoAlpha3>STP</isoAlpha3>
+<fipsCode>TP</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>São Tomé</capital>
+<areaInSqKm>1001.0</areaInSqKm>
+<population>175808</population>
+<currencyCode>STD</currencyCode>
+<languages>pt-ST</languages>
+<geonameId>2410758</geonameId>
+<west>6.47017</west>
+<north>1.701323</north>
+<east>7.466374</east>
+<south>0.024766</south>
+</country>
+<country>
+<countryCode>SV</countryCode>
+<countryName>El Salvador</countryName>
+<isoNumeric>222</isoNumeric>
+<isoAlpha3>SLV</isoAlpha3>
+<fipsCode>ES</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>San Salvador</capital>
+<areaInSqKm>21040.0</areaInSqKm>
+<population>6052064</population>
+<currencyCode>USD</currencyCode>
+<languages>es-SV</languages>
+<geonameId>3585968</geonameId>
+<west>-90.128662</west>
+<north>14.445067</north>
+<east>-87.692162</east>
+<south>13.148679</south>
+</country>
+<country>
+<countryCode>SX</countryCode>
+<countryName>Sint Maarten</countryName>
+<isoNumeric>534</isoNumeric>
+<isoAlpha3>SXM</isoAlpha3>
+<fipsCode>NN</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Philipsburg</capital>
+<areaInSqKm/>
+<population>37429</population>
+<currencyCode>ANG</currencyCode>
+<languages>nl,en</languages>
+<geonameId>7609695</geonameId>
+<west>-63.144039</west>
+<north>18.070248</north>
+<east>-63.012993</east>
+<south>18.011692</south>
+</country>
+<country>
+<countryCode>SY</countryCode>
+<countryName>Syria</countryName>
+<isoNumeric>760</isoNumeric>
+<isoAlpha3>SYR</isoAlpha3>
+<fipsCode>SY</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Damascus</capital>
+<areaInSqKm>185180.0</areaInSqKm>
+<population>22198110</population>
+<currencyCode>SYP</currencyCode>
+<languages>ar-SY,ku,hy,arc,fr,en</languages>
+<geonameId>163843</geonameId>
+<west>35.727222</west>
+<north>37.319138</north>
+<east>42.385029</east>
+<south>32.310665</south>
+</country>
+<country>
+<countryCode>SZ</countryCode>
+<countryName>Swaziland</countryName>
+<isoNumeric>748</isoNumeric>
+<isoAlpha3>SWZ</isoAlpha3>
+<fipsCode>WZ</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Mbabane</capital>
+<areaInSqKm>17363.0</areaInSqKm>
+<population>1354051</population>
+<currencyCode>SZL</currencyCode>
+<languages>en-SZ,ss-SZ</languages>
+<geonameId>934841</geonameId>
+<west>30.794107</west>
+<north>-25.719648</north>
+<east>32.13726</east>
+<south>-27.317101</south>
+</country>
+<country>
+<countryCode>TC</countryCode>
+<countryName>Turks and Caicos Islands</countryName>
+<isoNumeric>796</isoNumeric>
+<isoAlpha3>TCA</isoAlpha3>
+<fipsCode>TK</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Cockburn Town</capital>
+<areaInSqKm>430.0</areaInSqKm>
+<population>20556</population>
+<currencyCode>USD</currencyCode>
+<languages>en-TC</languages>
+<geonameId>3576916</geonameId>
+<west>-72.483871</west>
+<north>21.961878</north>
+<east>-71.123642</east>
+<south>21.422626</south>
+</country>
+<country>
+<countryCode>TD</countryCode>
+<countryName>Chad</countryName>
+<isoNumeric>148</isoNumeric>
+<isoAlpha3>TCD</isoAlpha3>
+<fipsCode>CD</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>N'Djamena</capital>
+<areaInSqKm>1284000.0</areaInSqKm>
+<population>10543464</population>
+<currencyCode>XAF</currencyCode>
+<languages>fr-TD,ar-TD,sre</languages>
+<geonameId>2434508</geonameId>
+<west>13.473475</west>
+<north>23.450369</north>
+<east>24.002661</east>
+<south>7.441068</south>
+</country>
+<country>
+<countryCode>TF</countryCode>
+<countryName>French Southern Territories</countryName>
+<isoNumeric>260</isoNumeric>
+<isoAlpha3>ATF</isoAlpha3>
+<fipsCode>FS</fipsCode>
+<continent>AN</continent>
+<continentName>Antarctica</continentName>
+<capital>Port-aux-Français</capital>
+<areaInSqKm>7829.0</areaInSqKm>
+<population>140</population>
+<currencyCode>EUR</currencyCode>
+<languages>fr</languages>
+<geonameId>1546748</geonameId>
+<west>50.170258</west>
+<north>-37.790722</north>
+<east>77.598808</east>
+<south>-49.735184</south>
+</country>
+<country>
+<countryCode>TG</countryCode>
+<countryName>Togo</countryName>
+<isoNumeric>768</isoNumeric>
+<isoAlpha3>TGO</isoAlpha3>
+<fipsCode>TO</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Lomé</capital>
+<areaInSqKm>56785.0</areaInSqKm>
+<population>6587239</population>
+<currencyCode>XOF</currencyCode>
+<languages>fr-TG,ee,hna,kbp,dag,ha</languages>
+<geonameId>2363686</geonameId>
+<west>-0.147324</west>
+<north>11.138977</north>
+<east>1.806693</east>
+<south>6.104417</south>
+</country>
+<country>
+<countryCode>TH</countryCode>
+<countryName>Thailand</countryName>
+<isoNumeric>764</isoNumeric>
+<isoAlpha3>THA</isoAlpha3>
+<fipsCode>TH</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Bangkok</capital>
+<areaInSqKm>514000.0</areaInSqKm>
+<population>67089500</population>
+<currencyCode>THB</currencyCode>
+<languages>th,en</languages>
+<geonameId>1605651</geonameId>
+<west>97.345642</west>
+<north>20.463194</north>
+<east>105.639389</east>
+<south>5.61</south>
+</country>
+<country>
+<countryCode>TJ</countryCode>
+<countryName>Tajikistan</countryName>
+<isoNumeric>762</isoNumeric>
+<isoAlpha3>TJK</isoAlpha3>
+<fipsCode>TI</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Dushanbe</capital>
+<areaInSqKm>143100.0</areaInSqKm>
+<population>7487489</population>
+<currencyCode>TJS</currencyCode>
+<languages>tg,ru</languages>
+<geonameId>1220409</geonameId>
+<west>67.387138</west>
+<north>41.042252</north>
+<east>75.137222</east>
+<south>36.674137</south>
+</country>
+<country>
+<countryCode>TK</countryCode>
+<countryName>Tokelau</countryName>
+<isoNumeric>772</isoNumeric>
+<isoAlpha3>TKL</isoAlpha3>
+<fipsCode>TL</fipsCode>
+<continent>OC</continent>
+<continentName>Oceania</continentName>
+<capital/>
+<areaInSqKm>10.0</areaInSqKm>
+<population>1466</population>
+<currencyCode>NZD</currencyCode>
+<languages>tkl,en-TK</languages>
+<geonameId>4031074</geonameId>
+<west>-172.50033569335938</west>
+<north>-8.553613662719727</north>
+<east>-171.21142578125</east>
+<south>-9.381111145019531</south>
+</country>
+<country>
+<countryCode>TL</countryCode>
+<countryName>East Timor</countryName>
+<isoNumeric>626</isoNumeric>
+<isoAlpha3>TLS</isoAlpha3>
+<fipsCode>TT</fipsCode>
+<continent>OC</continent>
+<continentName>Oceania</continentName>
+<capital>Dili</capital>
+<areaInSqKm>15007.0</areaInSqKm>
+<population>1154625</population>
+<currencyCode>USD</currencyCode>
+<languages>tet,pt-TL,id,en</languages>
+<geonameId>1966436</geonameId>
+<west>124.04609680175781</west>
+<north>-8.135833740234375</north>
+<east>127.30859375</east>
+<south>-9.463626861572266</south>
+</country>
+<country>
+<countryCode>TM</countryCode>
+<countryName>Turkmenistan</countryName>
+<isoNumeric>795</isoNumeric>
+<isoAlpha3>TKM</isoAlpha3>
+<fipsCode>TX</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Ashgabat</capital>
+<areaInSqKm>488100.0</areaInSqKm>
+<population>4940916</population>
+<currencyCode>TMT</currencyCode>
+<languages>tk,ru,uz</languages>
+<geonameId>1218197</geonameId>
+<west>52.441444</west>
+<north>42.795555</north>
+<east>66.684303</east>
+<south>35.141083</south>
+</country>
+<country>
+<countryCode>TN</countryCode>
+<countryName>Tunisia</countryName>
+<isoNumeric>788</isoNumeric>
+<isoAlpha3>TUN</isoAlpha3>
+<fipsCode>TS</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Tunis</capital>
+<areaInSqKm>163610.0</areaInSqKm>
+<population>10589025</population>
+<currencyCode>TND</currencyCode>
+<languages>ar-TN,fr</languages>
+<geonameId>2464461</geonameId>
+<west>7.524833</west>
+<north>37.543915</north>
+<east>11.598278</east>
+<south>30.240417</south>
+</country>
+<country>
+<countryCode>TO</countryCode>
+<countryName>Tonga</countryName>
+<isoNumeric>776</isoNumeric>
+<isoAlpha3>TON</isoAlpha3>
+<fipsCode>TN</fipsCode>
+<continent>OC</continent>
+<continentName>Oceania</continentName>
+<capital>Nuku'alofa</capital>
+<areaInSqKm>748.0</areaInSqKm>
+<population>122580</population>
+<currencyCode>TOP</currencyCode>
+<languages>to,en-TO</languages>
+<geonameId>4032283</geonameId>
+<west>-175.682266</west>
+<north>-15.562988</north>
+<east>-173.907578</east>
+<south>-21.455057</south>
+</country>
+<country>
+<countryCode>TR</countryCode>
+<countryName>Turkey</countryName>
+<isoNumeric>792</isoNumeric>
+<isoAlpha3>TUR</isoAlpha3>
+<fipsCode>TU</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Ankara</capital>
+<areaInSqKm>780580.0</areaInSqKm>
+<population>77804122</population>
+<currencyCode>TRY</currencyCode>
+<languages>tr-TR,ku,diq,az,av</languages>
+<geonameId>298795</geonameId>
+<west>25.668501</west>
+<north>42.107613</north>
+<east>44.834999</east>
+<south>35.815418</south>
+</country>
+<country>
+<countryCode>TT</countryCode>
+<countryName>Trinidad and Tobago</countryName>
+<isoNumeric>780</isoNumeric>
+<isoAlpha3>TTO</isoAlpha3>
+<fipsCode>TD</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Port of Spain</capital>
+<areaInSqKm>5128.0</areaInSqKm>
+<population>1228691</population>
+<currencyCode>TTD</currencyCode>
+<languages>en-TT,hns,fr,es,zh</languages>
+<geonameId>3573591</geonameId>
+<west>-61.923771</west>
+<north>11.338342</north>
+<east>-60.517933</east>
+<south>10.036105</south>
+</country>
+<country>
+<countryCode>TV</countryCode>
+<countryName>Tuvalu</countryName>
+<isoNumeric>798</isoNumeric>
+<isoAlpha3>TUV</isoAlpha3>
+<fipsCode>TV</fipsCode>
+<continent>OC</continent>
+<continentName>Oceania</continentName>
+<capital>Funafuti</capital>
+<areaInSqKm>26.0</areaInSqKm>
+<population>10472</population>
+<currencyCode>AUD</currencyCode>
+<languages>tvl,en,sm,gil</languages>
+<geonameId>2110297</geonameId>
+<west>176.064865</west>
+<north>-5.641972</north>
+<east>179.863281</east>
+<south>-10.801169</south>
+</country>
+<country>
+<countryCode>TW</countryCode>
+<countryName>Taiwan</countryName>
+<isoNumeric>158</isoNumeric>
+<isoAlpha3>TWN</isoAlpha3>
+<fipsCode>TW</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Taipei</capital>
+<areaInSqKm>35980.0</areaInSqKm>
+<population>22894384</population>
+<currencyCode>TWD</currencyCode>
+<languages>zh-TW,zh,nan,hak</languages>
+<geonameId>1668284</geonameId>
+<west>119.534691</west>
+<north>25.29825</north>
+<east>122.000443</east>
+<south>21.901806</south>
+</country>
+<country>
+<countryCode>TZ</countryCode>
+<countryName>Tanzania</countryName>
+<isoNumeric>834</isoNumeric>
+<isoAlpha3>TZA</isoAlpha3>
+<fipsCode>TZ</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Dodoma</capital>
+<areaInSqKm>945087.0</areaInSqKm>
+<population>41892895</population>
+<currencyCode>TZS</currencyCode>
+<languages>sw-TZ,en,ar</languages>
+<geonameId>149590</geonameId>
+<west>29.327168</west>
+<north>-0.990736</north>
+<east>40.443222</east>
+<south>-11.745696</south>
+</country>
+<country>
+<countryCode>UA</countryCode>
+<countryName>Ukraine</countryName>
+<isoNumeric>804</isoNumeric>
+<isoAlpha3>UKR</isoAlpha3>
+<fipsCode>UP</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Kyiv</capital>
+<areaInSqKm>603700.0</areaInSqKm>
+<population>45415596</population>
+<currencyCode>UAH</currencyCode>
+<languages>uk,ru-UA,rom,pl,hu</languages>
+<geonameId>690791</geonameId>
+<west>22.128889</west>
+<north>52.369362</north>
+<east>40.20739</east>
+<south>44.390415</south>
+</country>
+<country>
+<countryCode>UG</countryCode>
+<countryName>Uganda</countryName>
+<isoNumeric>800</isoNumeric>
+<isoAlpha3>UGA</isoAlpha3>
+<fipsCode>UG</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Kampala</capital>
+<areaInSqKm>236040.0</areaInSqKm>
+<population>33398682</population>
+<currencyCode>UGX</currencyCode>
+<languages>en-UG,lg,sw,ar</languages>
+<geonameId>226074</geonameId>
+<west>29.573252</west>
+<north>4.214427</north>
+<east>35.036049</east>
+<south>-1.48405</south>
+</country>
+<country>
+<countryCode>UM</countryCode>
+<countryName>U.S. Minor Outlying Islands</countryName>
+<isoNumeric>581</isoNumeric>
+<isoAlpha3>UMI</isoAlpha3>
+<fipsCode/>
+<continent>OC</continent>
+<continentName>Oceania</continentName>
+<capital/>
+<areaInSqKm>0.0</areaInSqKm>
+<population>0</population>
+<currencyCode>USD</currencyCode>
+<languages>en-UM</languages>
+<geonameId>5854968</geonameId>
+<west>-177.392029</west>
+<north>28.219814</north>
+<east>166.654526</east>
+<south>-0.389006</south>
+</country>
+<country>
+<countryCode>US</countryCode>
+<countryName>United States</countryName>
+<isoNumeric>840</isoNumeric>
+<isoAlpha3>USA</isoAlpha3>
+<fipsCode>US</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Washington</capital>
+<areaInSqKm>9629091.0</areaInSqKm>
+<population>310232863</population>
+<currencyCode>USD</currencyCode>
+<languages>en-US,es-US,haw,fr</languages>
+<geonameId>6252001</geonameId>
+<west>-124.733253</west>
+<north>49.388611</north>
+<east>-66.954811</east>
+<south>24.544245</south>
+</country>
+<country>
+<countryCode>UY</countryCode>
+<countryName>Uruguay</countryName>
+<isoNumeric>858</isoNumeric>
+<isoAlpha3>URY</isoAlpha3>
+<fipsCode>UY</fipsCode>
+<continent>SA</continent>
+<continentName>South America</continentName>
+<capital>Montevideo</capital>
+<areaInSqKm>176220.0</areaInSqKm>
+<population>3477000</population>
+<currencyCode>UYU</currencyCode>
+<languages>es-UY</languages>
+<geonameId>3439705</geonameId>
+<west>-58.442722</west>
+<north>-30.082224</north>
+<east>-53.073933</east>
+<south>-34.980816</south>
+</country>
+<country>
+<countryCode>UZ</countryCode>
+<countryName>Uzbekistan</countryName>
+<isoNumeric>860</isoNumeric>
+<isoAlpha3>UZB</isoAlpha3>
+<fipsCode>UZ</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Tashkent</capital>
+<areaInSqKm>447400.0</areaInSqKm>
+<population>27865738</population>
+<currencyCode>UZS</currencyCode>
+<languages>uz,ru,tg</languages>
+<geonameId>1512440</geonameId>
+<west>55.996639</west>
+<north>45.575001</north>
+<east>73.132278</east>
+<south>37.184444</south>
+</country>
+<country>
+<countryCode>VA</countryCode>
+<countryName>Vatican City</countryName>
+<isoNumeric>336</isoNumeric>
+<isoAlpha3>VAT</isoAlpha3>
+<fipsCode>VT</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Vatican</capital>
+<areaInSqKm>0.44</areaInSqKm>
+<population>921</population>
+<currencyCode>EUR</currencyCode>
+<languages>la,it,fr</languages>
+<geonameId>3164670</geonameId>
+<west>12.44570678169205</west>
+<north>41.90743830885576</north>
+<east>12.45837546629481</east>
+<south>41.90027960306854</south>
+</country>
+<country>
+<countryCode>VC</countryCode>
+<countryName>Saint Vincent and the Grenadines</countryName>
+<isoNumeric>670</isoNumeric>
+<isoAlpha3>VCT</isoAlpha3>
+<fipsCode>VC</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Kingstown</capital>
+<areaInSqKm>389.0</areaInSqKm>
+<population>104217</population>
+<currencyCode>XCD</currencyCode>
+<languages>en-VC,fr</languages>
+<geonameId>3577815</geonameId>
+<west>-61.46090317727658</west>
+<north>13.377834</north>
+<east>-61.11388</east>
+<south>12.583984810969037</south>
+</country>
+<country>
+<countryCode>VE</countryCode>
+<countryName>Venezuela</countryName>
+<isoNumeric>862</isoNumeric>
+<isoAlpha3>VEN</isoAlpha3>
+<fipsCode>VE</fipsCode>
+<continent>SA</continent>
+<continentName>South America</continentName>
+<capital>Caracas</capital>
+<areaInSqKm>912050.0</areaInSqKm>
+<population>27223228</population>
+<currencyCode>VEF</currencyCode>
+<languages>es-VE</languages>
+<geonameId>3625428</geonameId>
+<west>-73.354073</west>
+<north>12.201903</north>
+<east>-59.80378</east>
+<south>0.626311</south>
+</country>
+<country>
+<countryCode>VG</countryCode>
+<countryName>British Virgin Islands</countryName>
+<isoNumeric>092</isoNumeric>
+<isoAlpha3>VGB</isoAlpha3>
+<fipsCode>VI</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Road Town</capital>
+<areaInSqKm>153.0</areaInSqKm>
+<population>21730</population>
+<currencyCode>USD</currencyCode>
+<languages>en-VG</languages>
+<geonameId>3577718</geonameId>
+<west>-64.715363</west>
+<north>18.757221</north>
+<east>-64.268768</east>
+<south>18.38998</south>
+</country>
+<country>
+<countryCode>VI</countryCode>
+<countryName>U.S. Virgin Islands</countryName>
+<isoNumeric>850</isoNumeric>
+<isoAlpha3>VIR</isoAlpha3>
+<fipsCode>VQ</fipsCode>
+<continent>NA</continent>
+<continentName>North America</continentName>
+<capital>Charlotte Amalie</capital>
+<areaInSqKm>352.0</areaInSqKm>
+<population>108708</population>
+<currencyCode>USD</currencyCode>
+<languages>en-VI</languages>
+<geonameId>4796775</geonameId>
+<west>-65.038231</west>
+<north>18.391747</north>
+<east>-64.565178</east>
+<south>17.681725</south>
+</country>
+<country>
+<countryCode>VN</countryCode>
+<countryName>Vietnam</countryName>
+<isoNumeric>704</isoNumeric>
+<isoAlpha3>VNM</isoAlpha3>
+<fipsCode>VM</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Hanoi</capital>
+<areaInSqKm>329560.0</areaInSqKm>
+<population>89571130</population>
+<currencyCode>VND</currencyCode>
+<languages>vi,en,fr,zh,km</languages>
+<geonameId>1562822</geonameId>
+<west>102.148224</west>
+<north>23.388834</north>
+<east>109.464638</east>
+<south>8.559611</south>
+</country>
+<country>
+<countryCode>VU</countryCode>
+<countryName>Vanuatu</countryName>
+<isoNumeric>548</isoNumeric>
+<isoAlpha3>VUT</isoAlpha3>
+<fipsCode>NH</fipsCode>
+<continent>OC</continent>
+<continentName>Oceania</continentName>
+<capital>Port Vila</capital>
+<areaInSqKm>12200.0</areaInSqKm>
+<population>221552</population>
+<currencyCode>VUV</currencyCode>
+<languages>bi,en-VU,fr-VU</languages>
+<geonameId>2134431</geonameId>
+<west>166.524979</west>
+<north>-13.073444</north>
+<east>169.904785</east>
+<south>-20.248945</south>
+</country>
+<country>
+<countryCode>WF</countryCode>
+<countryName>Wallis and Futuna</countryName>
+<isoNumeric>876</isoNumeric>
+<isoAlpha3>WLF</isoAlpha3>
+<fipsCode>WF</fipsCode>
+<continent>OC</continent>
+<continentName>Oceania</continentName>
+<capital>Mata-Utu</capital>
+<areaInSqKm>274.0</areaInSqKm>
+<population>16025</population>
+<currencyCode>XPF</currencyCode>
+<languages>wls,fud,fr-WF</languages>
+<geonameId>4034749</geonameId>
+<west>-178.1848112896414</west>
+<north>-13.216758181061444</north>
+<east>-176.16174317718253</east>
+<south>-14.314559989820843</south>
+</country>
+<country>
+<countryCode>WS</countryCode>
+<countryName>Samoa</countryName>
+<isoNumeric>882</isoNumeric>
+<isoAlpha3>WSM</isoAlpha3>
+<fipsCode>WS</fipsCode>
+<continent>OC</continent>
+<continentName>Oceania</continentName>
+<capital>Apia</capital>
+<areaInSqKm>2944.0</areaInSqKm>
+<population>192001</population>
+<currencyCode>WST</currencyCode>
+<languages>sm,en-WS</languages>
+<geonameId>4034894</geonameId>
+<west>-172.798599</west>
+<north>-13.432207</north>
+<east>-171.415741</east>
+<south>-14.040939</south>
+</country>
+<country>
+<countryCode>XK</countryCode>
+<countryName>Kosovo</countryName>
+<isoNumeric>0</isoNumeric>
+<isoAlpha3>XKX</isoAlpha3>
+<fipsCode>KV</fipsCode>
+<continent>EU</continent>
+<continentName>Europe</continentName>
+<capital>Pristina</capital>
+<areaInSqKm/>
+<population>1800000</population>
+<currencyCode>EUR</currencyCode>
+<languages>sq,sr</languages>
+<geonameId>831053</geonameId>
+<west>19.977481504492914</west>
+<north>43.2682495807952</north>
+<east>21.80335088694943</east>
+<south>41.856369601859925</south>
+</country>
+<country>
+<countryCode>YE</countryCode>
+<countryName>Yemen</countryName>
+<isoNumeric>887</isoNumeric>
+<isoAlpha3>YEM</isoAlpha3>
+<fipsCode>YM</fipsCode>
+<continent>AS</continent>
+<continentName>Asia</continentName>
+<capital>Sanaa</capital>
+<areaInSqKm>527970.0</areaInSqKm>
+<population>23495361</population>
+<currencyCode>YER</currencyCode>
+<languages>ar-YE</languages>
+<geonameId>69543</geonameId>
+<west>42.5325394314234</west>
+<north>18.9999989031009</north>
+<east>54.5305388163283</east>
+<south>12.1110910264462</south>
+</country>
+<country>
+<countryCode>YT</countryCode>
+<countryName>Mayotte</countryName>
+<isoNumeric>175</isoNumeric>
+<isoAlpha3>MYT</isoAlpha3>
+<fipsCode>MF</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Mamoutzou</capital>
+<areaInSqKm>374.0</areaInSqKm>
+<population>159042</population>
+<currencyCode>EUR</currencyCode>
+<languages>fr-YT</languages>
+<geonameId>1024031</geonameId>
+<west>45.03796</west>
+<north>-12.648891</north>
+<east>45.29295</east>
+<south>-13.000132</south>
+</country>
+<country>
+<countryCode>ZA</countryCode>
+<countryName>South Africa</countryName>
+<isoNumeric>710</isoNumeric>
+<isoAlpha3>ZAF</isoAlpha3>
+<fipsCode>SF</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Pretoria</capital>
+<areaInSqKm>1219912.0</areaInSqKm>
+<population>49000000</population>
+<currencyCode>ZAR</currencyCode>
+<languages>zu,xh,af,nso,en-ZA,tn,st,ts,ss,ve,nr</languages>
+<geonameId>953987</geonameId>
+<west>16.458021</west>
+<north>-22.126612</north>
+<east>32.895973</east>
+<south>-34.839828</south>
+</country>
+<country>
+<countryCode>ZM</countryCode>
+<countryName>Zambia</countryName>
+<isoNumeric>894</isoNumeric>
+<isoAlpha3>ZMB</isoAlpha3>
+<fipsCode>ZA</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Lusaka</capital>
+<areaInSqKm>752614.0</areaInSqKm>
+<population>13460305</population>
+<currencyCode>ZMK</currencyCode>
+<languages>en-ZM,bem,loz,lun,lue,ny,toi</languages>
+<geonameId>895949</geonameId>
+<west>21.999371</west>
+<north>-8.22436</north>
+<east>33.705704</east>
+<south>-18.079473</south>
+</country>
+<country>
+<countryCode>ZW</countryCode>
+<countryName>Zimbabwe</countryName>
+<isoNumeric>716</isoNumeric>
+<isoAlpha3>ZWE</isoAlpha3>
+<fipsCode>ZI</fipsCode>
+<continent>AF</continent>
+<continentName>Africa</continentName>
+<capital>Harare</capital>
+<areaInSqKm>390580.0</areaInSqKm>
+<population>11651858</population>
+<currencyCode>ZWL</currencyCode>
+<languages>en-ZW,sn,nr,nd</languages>
+<geonameId>878675</geonameId>
+<west>25.237028</west>
+<north>-15.608835</north>
+<east>33.056305</east>
+<south>-22.417738</south>
+</country>
+</geonames>
diff --git a/db/migrate/20140117185510_drop_countries.rb b/db/migrate/20140117185510_drop_countries.rb
new file mode 100644 (file)
index 0000000..fe9144c
--- /dev/null
@@ -0,0 +1,5 @@
+class DropCountries < ActiveRecord::Migration
+  def change
+    drop_table :countries
+  end
+end
index 031b89aa5bb848b15eb03ff9ccef2cbed15325af..5c4fdf8c7a30463abe1a3acacc1b778f9a2284e1 100644 (file)
@@ -274,39 +274,6 @@ CREATE SEQUENCE client_applications_id_seq
 ALTER SEQUENCE client_applications_id_seq OWNED BY client_applications.id;
 
 
---
--- Name: countries; Type: TABLE; Schema: public; Owner: -; Tablespace: 
---
-
-CREATE TABLE countries (
-    id integer NOT NULL,
-    code character varying(2) NOT NULL,
-    min_lat double precision NOT NULL,
-    max_lat double precision NOT NULL,
-    min_lon double precision NOT NULL,
-    max_lon double precision NOT NULL
-);
-
-
---
--- Name: countries_id_seq; Type: SEQUENCE; Schema: public; Owner: -
---
-
-CREATE SEQUENCE countries_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MINVALUE
-    NO MAXVALUE
-    CACHE 1;
-
-
---
--- Name: countries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
---
-
-ALTER SEQUENCE countries_id_seq OWNED BY countries.id;
-
-
 --
 -- Name: current_node_tags; Type: TABLE; Schema: public; Owner: -; Tablespace: 
 --
@@ -1187,13 +1154,6 @@ ALTER TABLE ONLY changesets ALTER COLUMN id SET DEFAULT nextval('changesets_id_s
 ALTER TABLE ONLY client_applications ALTER COLUMN id SET DEFAULT nextval('client_applications_id_seq'::regclass);
 
 
---
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY countries ALTER COLUMN id SET DEFAULT nextval('countries_id_seq'::regclass);
-
-
 --
 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
 --
@@ -1344,14 +1304,6 @@ ALTER TABLE ONLY client_applications
     ADD CONSTRAINT client_applications_pkey PRIMARY KEY (id);
 
 
---
--- Name: countries_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
---
-
-ALTER TABLE ONLY countries
-    ADD CONSTRAINT countries_pkey PRIMARY KEY (id);
-
-
 --
 -- Name: current_node_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
 --
@@ -1665,13 +1617,6 @@ CREATE INDEX changesets_user_id_created_at_idx ON changesets USING btree (user_i
 CREATE INDEX changesets_user_id_id_idx ON changesets USING btree (user_id, id);
 
 
---
--- Name: countries_code_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
---
-
-CREATE UNIQUE INDEX countries_code_idx ON countries USING btree (code);
-
-
 --
 -- Name: current_nodes_tile_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
 --
@@ -2476,6 +2421,8 @@ INSERT INTO schema_migrations (version) VALUES ('20131212124700');
 
 INSERT INTO schema_migrations (version) VALUES ('20140115192822');
 
+INSERT INTO schema_migrations (version) VALUES ('20140117185510');
+
 INSERT INTO schema_migrations (version) VALUES ('21');
 
 INSERT INTO schema_migrations (version) VALUES ('22');
diff --git a/lib/country.rb b/lib/country.rb
new file mode 100644 (file)
index 0000000..ea52efd
--- /dev/null
@@ -0,0 +1,38 @@
+class Country
+  attr_reader :code, :min_lat, :max_lat, :min_lon, :max_lon
+
+  def initialize(code, min_lat, max_lat, min_lon, max_lon)
+    @code = code
+    @min_lat = min_lat
+    @max_lat = max_lat
+    @min_lon = min_lon
+    @max_lon = max_lon
+  end
+
+  def self.find_by_code(code)
+    countries[code]
+  end
+
+private
+
+  def self.countries
+    @@countries ||= load_countries
+  end
+
+  def self.load_countries
+    countries = Hash.new
+    xml = REXML::Document.new(File.read("config/countries.xml"))
+
+    xml.elements.each("geonames/country") do |ele|
+      code = ele.get_text("countryCode").to_s
+      minlon = ele.get_text("west").to_s
+      minlat = ele.get_text("south").to_s
+      maxlon = ele.get_text("east").to_s
+      maxlat = ele.get_text("north").to_s
+
+      countries[code] = Country.new(code, minlat.to_f, maxlat.to_f, minlon.to_f, maxlon.to_f)
+    end
+
+    countries
+  end
+end
diff --git a/test/unit/country_test.rb b/test/unit/country_test.rb
deleted file mode 100644 (file)
index 84bb2c4..0000000
+++ /dev/null
@@ -1,9 +0,0 @@
-require File.dirname(__FILE__) + '/../test_helper'
-
-class CountryTest < ActiveSupport::TestCase
-  fixtures :countries
-  
-  test "country count" do
-    assert_equal 2, Country.count
-  end
-end