esites: Cleanup/Merge Galapagos records [Ecuador] Island - TASK 3

[rondlg]

TASK 3: Cleanup the Island records

Notes:

• EMu group = "esites cleanup - Galapagos Islands".
• Canton is below province: Isabela, San Cristóbal, Santa Cruz, (Galápagos)
• There should be no abbreviations for the word Island. See Working Group standards decision
• See https://en.wikipedia.org/wiki/Gal%C3%A1pagos_Province
• See https://latinrootstravel.com/fortheblog/guide-to-galapagos-islands-names-33-islands-and-islets/

Recommendations:

• NEED TO CHOOSE MASTER RECORDS AND MERGE
• Use records that already say "Island"
• Where there is no record with "Island" select one of the others as the master and update abbreviation to "Island". Suggest the one with the most attachments.

---

MERGED Galapagos

irn	SummaryData	PolPoliticalRank	Departments	Master
630916	South America, Ecuador, Galápagos, Galápagos [canton], Galápagos Islands, Galapagos Island	Island		Yes
629219	South America, Ecuador, Galápagos, Galápagos [canton], Pacific Is, Galapagos Is	Island		?

MERGED Gardner

irn	SummaryData	PolPoliticalRank	Departments	Master
29230	South America, Ecuador, Galápagos, Galápagos Islands, Gardner Island	Island		Yes

MERGED Albemarle

irn	SummaryData	PolPoliticalRank	Departments	Master
697833	South America, Ecuador, Galápagos, Isabela [canton], Galápagos Islands, Albemarle I	Island		?
697834	South America, Ecuador, Galápagos, Isabela [canton], Galápagos Islands, Albemarle Id	Island		?
628720	South America, Ecuador, Galápagos, Isabela [canton], Galapagos Islands, Albemarle Island	Island		Yes

MERGED Fernandina

irn	SummaryData	PolPoliticalRank	Departments	Master
700321	South America, Ecuador, Galápagos, Isabela [canton], Galápagos Islands, Fernandina I	Island		?
629188	South America, Ecuador, Galápagos, Isabela [canton], Galapagos Islands, Fernandina Island	Island		Yes

MERGED Isabela

irn	SummaryData	PolPoliticalRank	Departments	Master
701414	South America, Ecuador, Galápagos, Isabela [canton], Galápagos Islands, Isabela	Island		?
629441	South America, Ecuador, Galápagos, Isabela [canton], Galapagos Islands, Isabela	Island		?

MERGED Narborough

irn	SummaryData	PolPoliticalRank	Departments	Master
629923	South America, Ecuador, Galápagos, Isabela [canton], Galapagos Islands, Narboro Island	Island		?
703655	South America, Ecuador, Galápagos, Isabela [canton], Galápagos Islands, Narborough I	Island		?
703656	South America, Ecuador, Galápagos, Isabela [canton], Galápagos Islands, Narborough Id	Island		?
629924	South America, Ecuador, Galápagos, Isabela [canton], Galapagos Islands, Narborough Island	Island		Yes

MERGED Barrington

irn	SummaryData	PolPoliticalRank	Departments	Master
698285	South America, Ecuador, Galápagos, San Cristóbal [canton], Galápagos Islands, Barrington I	Island		?
628854	South America, Ecuador, Galápagos, San Cristóbal [canton], Galapagos Islands, Barrington Island	Island		Yes

MERGED Charles

irn	SummaryData	PolPoliticalRank	Departments	Master
707671	South America, Ecuador, Galapagos Islands (Pacific Ocean), Bay Charles Island	Island		?
699143	South America, Ecuador, Galápagos, San Cristóbal [canton], Galápagos Islands, Charles I	Island		?
699144	South America, Ecuador, Galápagos, San Cristóbal [canton], Galápagos Islands, Charles Id	Island		?
629013	South America, Ecuador, Galápagos, San Cristóbal [canton], Galapagos Islands, Charles Island	Island		Yes

MERGED Chatham

irn	SummaryData	PolPoliticalRank	Departments	Master
699164	South America, Ecuador, Galápagos, San Cristóbal [canton], Galápagos Islands, Chatham Id	Island		?
629015	South America, Ecuador, Galápagos, San Cristóbal [canton], Galapagos Islands, Chatham Island	Island		Yes

MERGED Espanola

irn	SummaryData	PolPoliticalRank	Departments	Master
629159	South America, Ecuador, Galápagos, San Cristóbal [canton], Galapagos Islands, Espanola Island	Island		Yes

MERGED Floreana

irn	SummaryData	PolPoliticalRank	Departments	Master
629196	South America, Ecuador, Galápagos, San Cristóbal [canton], Galapagos Islands, Floerana Island	Island		?
629198	South America, Ecuador, Galápagos, San Cristóbal [canton], Galápagos Islands, Floreana Island	Island		?

MERGED Hood

irn	SummaryData	PolPoliticalRank	Departments	Master
701186	South America, Ecuador, Galápagos, San Cristóbal [canton], Galápagos Islands, Hood Id	Island		?
629369	South America, Ecuador, Galápagos, San Cristóbal [canton], Galapagos Islands, Hood Island	Island		Yes

MERGED San Cristóbal

irn	SummaryData	PolPoliticalRank	Departments	Master
705228	South America, Ecuador, Galápagos, San Cristóbal [canton], Galápagos Islands, San Cristóbal	Island		?
630273	South America, Ecuador, Galápagos, San Cristóbal [canton], Galápagos Islands, San Cristóbal	Island		?
630274	South America, Ecuador, Galápagos, San Cristóbal [canton], Galápagos Islands, San Cristóbal [Chatham]	Island		?

MERGED Tower

irn	SummaryData	PolPoliticalRank	Departments	Master
706402	South America, Ecuador, Galápagos, San Cristóbal [canton], Galápagos Islands, Tower Id	Island		?
630567	South America, Ecuador, Galápagos, San Cristóbal [canton], Galapagos Islands, Tower Island	Island		Yes

MERGED Abingdon

irn	SummaryData	PolPoliticalRank	Departments	Master
628693	South America, Ecuador, Galápagos, Santa Cruz [canton], Galapagos Islands, Abingdon Island	Island		Yes

MERGED Baltra

irn	SummaryData	PolPoliticalRank	Departments	Master
628843	South America, Ecuador, Galápagos, Santa Cruz [canton], Galapagos Islands, Baltra Island	Island		Yes

MERGED San Brindloe

irn	SummaryData	PolPoliticalRank	Departments	Master
698471	South America, Ecuador, Galápagos, Santa Cruz [canton], Galápagos Islands, Bindloe Id	Island		?
628907	South America, Ecuador, Galápagos, Santa Cruz [canton], Galapagos Islands, Bindloe Island	Island		Yes

MERGED Duncan

irn	SummaryData	PolPoliticalRank	Departments	Master
629121	South America, Ecuador, Galápagos, Santa Cruz [canton], Galápagos Islands, Duncan Island	Island		Yes

MERGED Indefatigable

irn	SummaryData	PolPoliticalRank	Departments	Master
701359	South America, Ecuador, Galápagos, Santa Cruz [canton], Galápagos Islands, Indefatigable I	Island		?
701360	South America, Ecuador, Galápagos, Santa Cruz [canton], Galápagos Islands, Indefatigable Id	Island		?
629433	South America, Ecuador, Galápagos, Santa Cruz [canton], Galapagos Islands, Indefatigable Island	Island		Yes

MERGED James

irn	SummaryData	PolPoliticalRank	Departments	Master
701542	South America, Ecuador, Galápagos, Santa Cruz [canton], Galápagos Islands, James Id	Island		?
629530	South America, Ecuador, Galápagos, Santa Cruz [canton], Galapagos Islands, James Island	Island		Yes

MERGED Jervis

irn	SummaryData	PolPoliticalRank	Departments	Master
629537	South America, Ecuador, Galápagos, Santa Cruz [canton], Galápagos Islands, Jervis Island	Island		Yes

MERGED Marchena

irn	SummaryData	PolPoliticalRank	Departments	Master
629795	South America, Ecuador, Galápagos, Santa Cruz [canton], Galapagos Islands, Marchena Island	Island		Yes

MERGED Rábida

irn	SummaryData	PolPoliticalRank	Departments	Master
629499	South America, Ecuador, Galápagos, Santa Cruz [canton], Galápagos Islands, Isla Rábida	Island		?
704807	South America, Ecuador, Galápagos, Santa Cruz [canton], Galápagos Islands, Rábida	Island		?

MERGED Santa Cruz

irn	SummaryData	PolPoliticalRank	Departments	Master
705328	South America, Ecuador, Galápagos, Santa Cruz [canton], Galápagos Islands, Santa Cruz	Island		?
630305	South America, Ecuador, Galápagos, Santa Cruz [canton], Galapagos Islands, Santa Cruz	Island		?
705331	South America, Ecuador, Galápagos, Santa Cruz [canton], Galápagos Islands, Santa Cruz Id	Island		?
630307	South America, Ecuador, Galápagos, Santa Cruz [canton], Galápagos Islands, Santa Cruz Island [Indefatigable Island]	Island		?

MERGED Santa Fe

irn	SummaryData	PolPoliticalRank	Departments	Master
705336	South America, Ecuador, Galápagos, San Cristóbal [canton], Galápagos Islands, Santa Fe	Island		?
630308	South America, Ecuador, Galápagos, San Cristóbal [canton], Galápagos Islands, Santa Fé	Island		?

MERGED Santiago

irn	SummaryData	PolPoliticalRank	Departments	Master
705362	South America, Ecuador, Galápagos, Santa Cruz [canton], Galápagos Islands, Santiago I	Island		?

MERGED Seymour

irn	SummaryData	PolPoliticalRank	Departments	Master
630344	South America, Ecuador, Galápagos, Santa Cruz [canton], Galapagos Islands, Seymour Island	Island		?

[wyattgaswick]

This is long so I'm going to have to edit this comment a few times.

Chatham Island (records 699164, 629015): this is an old/deprecated name for San Cristóbal Island and is confusing because of the Chatham Island in New Zealand. I think this should be reflected in the name like irn 630274 ("San Cristóbal [Chatham]"). I suppose it is bad to keep a "San Cristóbal [Chatham] Island" and a "San Cristóbal Island" record in parallel?

San Cristóbal: I vote to keep 630273 since it has 29 attachments vs 4 for the (identical?) 705228. I guess we can change it to include [Chatham] unless we want to keep two separate San Cristóbal records.

[smochel1716]

Like Wyatt says - this is very long. But basically Fishes would like one Master record for each island with Spanish name parenthesis English name end parenthesis and if Spanish name do we use "Isla" instead of "Island" . With lat/long. in meters. Does that work?

[rondlg]

irn	Island Name	SummaryData	PolPoliticalRank	Departments	Master	irns merged
630916	Galapagos	South America, Ecuador, Galápagos, Galápagos [canton], Galápagos Islands, Galapagos Island	Island		Yes	629219
29230	Gardner	South America, Ecuador, Galápagos, Galápagos Islands, Gardner Island	Island		Yes	None
628720	Albemarle	South America, Ecuador, Galápagos, Isabela [canton], Galapagos Islands, Albemarle Island	Island		Yes	697834 , 697833
629188	Fernandina	South America, Ecuador, Galápagos, Isabela [canton], Galapagos Islands, Fernandina Island	Island		Yes	700321
701414	Isabela	South America, Ecuador, Galápagos, Isabela [canton], Galápagos Islands, Isabela	Island		Yes	629441
629924	Narborough	South America, Ecuador, Galápagos, Isabela [canton], Galapagos Islands, Narborough Island	Island		Yes	703656, 703655, 629923
628854	Barrington	South America, Ecuador, Galápagos, San Cristóbal [canton], Galapagos Islands, Barrington Island	Island		Yes	698285
629013	Charles	South America, Ecuador, Galápagos, San Cristóbal [canton], Galapagos Islands, Charles Island	Island		Yes	707671, 699143, 699144
629015	Chatham	South America, Ecuador, Galápagos, San Cristóbal [canton], Galapagos Islands, Chatham Island	Island		Yes	699164
629159	Espanola	South America, Ecuador, Galápagos, San Cristóbal [canton], Galapagos Islands, Espanola Island	Island		Yes	None
629198	Floreana	South America, Ecuador, Galápagos, San Cristóbal [canton], Galápagos Islands, Floreana Island	Island		Yes	629196
629369	Hood	South America, Ecuador, Galápagos, San Cristóbal [canton], Galapagos Islands, Hood Island	Island		Yes	701186
630274	San Cristóbal	South America, Ecuador, Galápagos, San Cristóbal [canton], Galápagos Islands, San Cristóbal [Chatham]	Island		Yes	705228, 630273
630567	Tower	South America, Ecuador, Galápagos, San Cristóbal [canton], Galapagos Islands, Tower Island	Island		Yes	706402
628693	Abingdon	South America, Ecuador, Galápagos, Santa Cruz [canton], Galapagos Islands, Abingdon Island	Island		Yes	None
628843	Baltra	South America, Ecuador, Galápagos, Santa Cruz [canton], Galapagos Islands, Baltra Island	Island		Yes	None
628907	San Brindloe	South America, Ecuador, Galápagos, Santa Cruz [canton], Galapagos Islands, Bindloe Island	Island		Yes	698471
629121	Duncan	South America, Ecuador, Galápagos, Santa Cruz [canton], Galápagos Islands, Duncan Island	Island		Yes	None
629433	Indefatigable	South America, Ecuador, Galápagos, Santa Cruz [canton], Galapagos Islands, Indefatigable Island	Island		Yes	701359, 701360
629530	James	South America, Ecuador, Galápagos, Santa Cruz [canton], Galapagos Islands, James Island	Island		Yes	701542
629537	Jervis	South America, Ecuador, Galápagos, Santa Cruz [canton], Galápagos Islands, Jervis Island	Island		Yes	None
629795	Marchena	South America, Ecuador, Galápagos, Santa Cruz [canton], Galapagos Islands, Marchena Island	Island		Yes	None
629499	Rábida	South America, Ecuador, Galápagos, Santa Cruz [canton], Galápagos Islands, Isla Rábida	Island		Yes	704807
630307	Santa Cruz	South America, Ecuador, Galápagos, Santa Cruz [canton], Galápagos Islands, Santa Cruz Island [Indefatigable Island]	Island		Yes	705328, 630305, 705331
630308	Santa Fe	South America, Ecuador, Galápagos, San Cristóbal [canton], Galápagos Islands, Santa Fé	Island		Yes	705336
705362	Santiago	South America, Ecuador, Galápagos, Santa Cruz [canton], Galápagos Islands, Santiago I	Island		Yes	None
630344	Seymour	South America, Ecuador, Galápagos, Santa Cruz [canton], Galapagos Islands, Seymour Island	Island		Yes	None

[rondlg]

Islands are collapsed into single records. Need to make a final decision on how to handle Spanish/English names. Will add to agenda for next EMu-hour.

[rondlg]

Here is a suggested list

The first name is the common name, predominantly Spanish. The second name is less commonly used, and they are mostly in English. The name after the / is their less common Spanish name.

18 Main Galapagos Islands

• Baltra, (South Seymour)
• Bartolomé, (Bartholomew)
• Darwin, (Culpepper)
• Española, (Hood)
• Fernandina, (Narborough)
• Floreana/Santa Maria, (Charles)
• Genovesa, (Tower)
• Isabela, (Albemarle)
• Marchena, (Bindloe)
• North Seymour Island, (Seymour)
• Pinta,(Abingdon)
• Pinzón, (Duncan)
• Rábida, (Jervis)
• San Cristobal, (Chatham)
• Santa Cruz, (Indefatigable)
• Santa Fe, (Barrington)
• Santiago/San Salvador, (James)
• Wolf, (Wenman)

15 Smaller Galapagos Islands & Islets

• Daphne Major
• Plaza Sur, (South Plaza Island)
• Roca Redonda, (Rock Redondo)
• Sin Nombre, (Nameless Island)
• Caldwell
• Champion
• Cowley
• Crossman
• Eden
• Enderby
• Gardner
• Isla Guy Fawkes
• Onslow
• Tortuga, Brattle
• Watson