Wrong ISO country code for Saba Island

[GoogleCodeExporter]

On country_names table is saved MY as the iso_country_code for SABA ISLAND (a 
Caribbean island), but this iso should be only for names related to MALAYSIA. 
Please see screenshot of all the country names that have MY as iso.

Does this country has it own iso code?
What's the iso for SABA ISLAND? 

Original issue reported on code.google.com by daniel.amariles88 on 11 Jan 2011 at 2:37

Attachments:

• MY.PNG

[GoogleCodeExporter]

Please check this issue more detailed because actually GBIF is assigning 
records for Malaysia when they are actually from "Saba Island".

I'm not sure but, if you check the following link:
http://data.gbif.org/occurrences/searchWithTable.htm?c[0].s=5&c[0].p=0&c[0].o=MY
&c[1].s=19&c[1].p=0&c[1].o=112.0W,1.0N,32.0W,41.0N
You will find a list of records that have its longitud marked as "probably 
negated" when they should be visibles in the map because probably they are from 
"Saba Island".

------

By the way, I found an article (wrote on December 20-2010) from "Pan American 
Standards Commission" where says that Saba ISO Country Code has a new ISO: "BQ".

http://www.copant.org/documents/18/26102/2010-12-20

Original comment by htobon on 11 Jan 2011 at 2:55

• Added labels: Priority-High
• Removed labels: Priority-Medium

[GoogleCodeExporter]

Updated the "country" table to add iso_country_code BQ for Saba, Bonaire, and 
Sint Eustatius, and changed the corresponding two entries in table 
"country_name". according to http://en.wikipedia.org/wiki/Saba: "The domain for 
the Netherlands Antilles has remained active after its dissolution. The ISO 
3166-1 alpha-2 code BQ was established for the entity "Bonaire, Sint Eustatius, 
Saba". ("ISO 3166-1 decoding table" (in English)." 

The error seems to have arisen because one of the Malaysian member states is 
called Sabah (http://en.wikipedia.org/wiki/Sabah). Correction in the tables 
will come up with the next "rollover" from the non-public indexing database to 
the public web portal, but re-extraction of the concerned datasets is needed to 
fix the erroneous messages and assignations within the indexed datasets.

Original comment by ah...@gbif.org on 17 Jan 2011 at 2:01

• Changed state: Fixed