Issue 13761
all non country nodes haven continent=Africa
13761
Reporter: mdoering
Assignee: ahahn
Type: Task
Summary: all non country nodes haven continent=Africa
Priority: Critical
Resolution: Fixed
Status: Closed
Created: 2013-09-02 15:45:07.895
Updated: 2013-09-03 11:06:24.245
Resolved: 2013-09-03 11:06:24.218
Description: as there is no continent field in the old registry we assign them manually in the migration script. That only happens for country nodes though and all non country nodes keep continent=AFRICA as its not nullable.
For example iBOL:
http://api.gbif.org/node/b797ce0f-47e6-4231-b048-6b62ca3b0f55
We need a small update scipt like this for each node:
{noformat}
UPDATE node SET continent='EUROPE' WHERE key='90a939d3-e99c-4f6d-915f-2616423b3735'; // Albertine Rift Conservation Society (ARCOS)
UPDATE node SET continent='EUROPE' WHERE key='af2a0fa1-4c8e-4bdc-8954-b1a55e32b0f1'; // ASEAN Centre for Biodiversity (ACB)
UPDATE node SET continent='EUROPE' WHERE key='4297e544-201c-491f-a98c-cab92a98de0c'; // BioNET-AndinoNET
UPDATE node SET continent='EUROPE' WHERE key='dd6b757b-ce91-4e58-951b-989cea8166bf'; // BioNET-ASEANET
UPDATE node SET continent='EUROPE' WHERE key='7f017f1c-d33e-480a-99ed-547ff9bf7abe'; // BioNET-EASIANET
UPDATE node SET continent='EUROPE' WHERE key='0e0181bf-9c78-4676-bdc3-54765e661bb8'; // BIONET-International
UPDATE node SET continent='EUROPE' WHERE key='41d4686c-f6b7-42ec-aa54-a5792700e784'; // BioNET-SAFRINET
UPDATE node SET continent='EUROPE' WHERE key='b8a5be24-9225-4ba5-b664-159308a4b537'; // Bioversity International
UPDATE node SET continent='EUROPE' WHERE key='844f7db8-d78e-4f9a-98ba-2008b1f1461e'; // Botanic Gardens Conservation International (BGCI)
UPDATE node SET continent='EUROPE' WHERE key='ed988a18-81f8-4d5f-a88d-f93ef592b2f2'; // CABI Bioscience
UPDATE node SET continent='EUROPE' WHERE key='dbecf582-c93c-4a6a-8991-0327bdf7fd49'; // Ciencia y Tecnología para el Desarrollo (CYTED)
UPDATE node SET continent='EUROPE' WHERE key='2ca6cc46-3461-4fc1-b6fb-2781a3974649'; // Consortium for the Barcode of Life (CBOL)
UPDATE node SET continent='EUROPE' WHERE key='d8bbf693-a180-4995-94fe-6130795dcf2f'; // Consortium of European Taxonomic Facilities (CETAF)
UPDATE node SET continent='EUROPE' WHERE key='f74f8534-a357-49ae-82b1-b1d39616a0b1'; // Discover Life
UPDATE node SET continent='EUROPE' WHERE key='f6b3dbc6-4e21-49aa-a7c6-61d778e19ec0'; // DIVERSITAS
UPDATE node SET continent='EUROPE' WHERE key='58ef3cd5-e76a-4073-8ecd-744e137e9bc9'; // Encyclopedia of Life (EOL)
UPDATE node SET continent='EUROPE' WHERE key='9e5d504a-879e-446e-bab0-1816dce12e41'; // Endangered Wildlife Trust (EWT)
UPDATE node SET continent='EUROPE' WHERE key='4be1ac47-75ae-44f6-917a-f095306f4450'; // ETI Bioinformatics
UPDATE node SET continent='EUROPE' WHERE key='c13e0e4a-bb5b-4bd8-8fa9-aa0dba71698a'; // Finding Species
UPDATE node SET continent='EUROPE' WHERE key='86b37808-0fa3-489a-af1f-53e72b2d75ce'; // Freshwater Biological Association - FreshwaterLife
UPDATE node SET continent='EUROPE' WHERE key='02c40d2a-1cba-4633-90b7-e36e5e97aba8'; // GBIF_TEMP_NODE
UPDATE node SET continent='EUROPE' WHERE key='109aea14-c252-4a85-96e2-f5f4d5d088f4'; // Integrated Taxonomic Information System
UPDATE node SET continent='EUROPE' WHERE key='69f8ea9e-b2a6-4e5a-896f-3bf8fc23cc8d'; // Inter-American Biodiversity Information Network (IABIN)
UPDATE node SET continent='EUROPE' WHERE key='b797ce0f-47e6-4231-b048-6b62ca3b0f55'; // International Barcode of Life (iBOL)
UPDATE node SET continent='EUROPE' WHERE key='b9628650-eeb8-44e3-80b8-ea6626956793'; // International Centre for Insect Physiology and Ecology
UPDATE node SET continent='EUROPE' WHERE key='b35cf8f1-748d-467a-adca-4f9170f20a4e'; // International Centre for Integrated Mountain Development (ICIMOD)
UPDATE node SET continent='EUROPE' WHERE key='ecc358f9-a1ad-4cca-aba3-70265c630c23'; // International Commission on Zoological Nomenclature (ICZN)
UPDATE node SET continent='EUROPE' WHERE key='6ab5da69-215e-4b9e-9f50-c72d146eecfc'; // International Long Term Ecological Research (ILTER)
UPDATE node SET continent='EUROPE' WHERE key='6b02945e-1567-4cd1-8f3b-86c355cfe9ea'; // International Species Information System
UPDATE node SET continent='EUROPE' WHERE key='7a17efec-0a6a-424c-b743-f715852c3c1f'; // Local Governments for Sustainability (ICLEI)
UPDATE node SET continent='EUROPE' WHERE key='b31933e2-061d-46b3-be69-dc6dd82066dd'; // Major Systematic Entomology Facilities
UPDATE node SET continent='EUROPE' WHERE key='b188b530-89cf-420a-8dba-9ae173706bab'; // Natural Science Collections Alliance (NSCA)
UPDATE node SET continent='EUROPE' WHERE key='6aff31ce-8410-4118-ac61-c7571d228dc3'; // NatureServe
UPDATE node SET continent='EUROPE' WHERE key='fa6bdac4-51e2-4334-940c-ba6cdf6e1257'; // Nordic Genetic Resource Center (NORDGEN)
UPDATE node SET continent='EUROPE' WHERE key='ba0670b9-4186-41e6-8e70-f9cb3065551a'; // Ocean Biogeographic Information System (OBIS)
UPDATE node SET continent='EUROPE' WHERE key='3b9510fc-5943-45d3-b08d-5b4e1e7c385e'; // Pacific Biodiversity Information Forum (PBIF)
UPDATE node SET continent='EUROPE' WHERE key='51e4e8ff-bff0-4996-8b27-9107d61b3478'; // Scientific Committee on Antartic Research (SCAR)
UPDATE node SET continent='EUROPE' WHERE key='97818ee4-1461-4180-bf1d-b3201050124f'; // Society for the Management of Electronic Biodiversity Data (SMEBD)
UPDATE node SET continent='EUROPE' WHERE key='07dfe2f9-5116-4922-9a8a-3e0912276a72'; // Society for the Preservation of Natural History Collections (SPNHC)
UPDATE node SET continent='EUROPE' WHERE key='03e816b3-8f58-49ae-bc12-4e18b358d6d9'; // Species 2000
UPDATE node SET continent='EUROPE' WHERE key='93441780-7304-4547-8906-77d4beb2ea6d'; // Taxonomic Databases Working Group (TDWG)
UPDATE node SET continent='EUROPE' WHERE key='b37a283d-89df-4748-82cf-a74ca936222e'; // United Nations Environment Programme, World Conservation Monitoring Centre (UNEP-WCMC)
UPDATE node SET continent='EUROPE' WHERE key='3e193341-3879-44e2-8bd9-64d95b101dbb'; // Wildscreen
UPDATE node SET continent='EUROPE' WHERE key='3a9a7db1-988f-4d90-99ee-b4dbe868a27c'; // World Data Center for Biodiversity and Ecology
UPDATE node SET continent='EUROPE' WHERE key='140074eb-2d9e-4289-8f51-7d987841013d'; // World Data Center for Biodiversity and Ecology (WDCBE)
UPDATE node SET continent='EUROPE' WHERE key='a6bdc523-5368-4e0f-9d2e-de1c262ac092'; // World Federation for Culture Collections
UPDATE node SET continent='EUROPE' WHERE key='5025e030-ce5b-4fc0-bb8d-009b12e6f934'; // World Federation for Culture Collections (WFCC)
{noformat}]]>
Author: ahahn@gbif.org
Created: 2013-09-02 16:55:26.571
Updated: 2013-09-02 16:57:47.675
a first go:
- based on IMS.__Participants.area_. As there are both node.gbif_region and node.continent, this update to node.continent should _not_ use the participant regions, as e.g. currently given at http://www.gbif.org/communications/directory-of-contacts/regional-nodes/, but the geographic continent
- not all participants can be assigned to a continent. They are currently set to NULL, though this needs revision (the attribute is not nullable; see http://dev.gbif.org/issues/browse/REG-420)
- the content follows the IMS values, with the caveat that the IMS only gives "Americas", without distinguishing North and South
UPDATE node SET continent='AFRICA' WHERE key='90a939d3-e99c-4f6d-915f-2616423b3735'; // Albertine Rift Conservation Society (ARCOS)
UPDATE node SET continent='ASIA' WHERE key='af2a0fa1-4c8e-4bdc-8954-b1a55e32b0f1'; // ASEAN Centre for Biodiversity (ACB)
UPDATE node SET continent='SOUTH_AMERICA' WHERE key='4297e544-201c-491f-a98c-cab92a98de0c'; // BioNET-AndinoNET
UPDATE node SET continent='ASIA' WHERE key='dd6b757b-ce91-4e58-951b-989cea8166bf'; // BioNET-ASEANET
UPDATE node SET continent='ASIA' WHERE key='7f017f1c-d33e-480a-99ed-547ff9bf7abe'; // BioNET-EASIANET
UPDATE node SET continent='AFRICA' WHERE key='0e0181bf-9c78-4676-bdc3-54765e661bb8'; // BIONET-International
UPDATE node SET continent='AFRICA' WHERE key='41d4686c-f6b7-42ec-aa54-a5792700e784'; // BioNET-SAFRINET
UPDATE node SET continent='EUROPE' WHERE key='b8a5be24-9225-4ba5-b664-159308a4b537'; // Bioversity International
UPDATE node SET continent='EUROPE' WHERE key='844f7db8-d78e-4f9a-98ba-2008b1f1461e'; // Botanic Gardens Conservation International (BGCI)
UPDATE node SET continent='EUROPE' WHERE key='ed988a18-81f8-4d5f-a88d-f93ef592b2f2'; // CABI Bioscience
UPDATE node SET continent='EUROPE' WHERE key='dbecf582-c93c-4a6a-8991-0327bdf7fd49'; // Ciencia y Tecnología para el Desarrollo (CYTED)
UPDATE node SET continent='NORTH_AMERICA' WHERE key='2ca6cc46-3461-4fc1-b6fb-2781a3974649'; // Consortium for the Barcode of Life (CBOL)
UPDATE node SET continent='EUROPE' WHERE key='d8bbf693-a180-4995-94fe-6130795dcf2f'; // Consortium of European Taxonomic Facilities (CETAF)
UPDATE node SET continent='NORTH_AMERICA' WHERE key='f74f8534-a357-49ae-82b1-b1d39616a0b1'; // Discover Life
UPDATE node SET continent='EUROPE' WHERE key='f6b3dbc6-4e21-49aa-a7c6-61d778e19ec0'; // DIVERSITAS
UPDATE node SET continent='NORTH_AMERICA' WHERE key='58ef3cd5-e76a-4073-8ecd-744e137e9bc9'; // Encyclopedia of Life (EOL)
UPDATE node SET continent='AFRICA' WHERE key='9e5d504a-879e-446e-bab0-1816dce12e41'; // Endangered Wildlife Trust (EWT)
UPDATE node SET continent='EUROPE' WHERE key='4be1ac47-75ae-44f6-917a-f095306f4450'; // ETI Bioinformatics
UPDATE node SET continent='NORTH_AMERICA' WHERE key='c13e0e4a-bb5b-4bd8-8fa9-aa0dba71698a'; // Finding Species
UPDATE node SET continent='EUROPE' WHERE key='86b37808-0fa3-489a-af1f-53e72b2d75ce'; // Freshwater Biological Association - FreshwaterLife
UPDATE node SET continent='EUROPE' WHERE key='02c40d2a-1cba-4633-90b7-e36e5e97aba8'; // GBIF_TEMP_NODE
UPDATE node SET continent=NULL WHERE key='109aea14-c252-4a85-96e2-f5f4d5d088f4'; // Integrated Taxonomic Information System
UPDATE node SET continent='SOUTH_AMERICA' WHERE key='69f8ea9e-b2a6-4e5a-896f-3bf8fc23cc8d'; // Inter-American Biodiversity Information Network (IABIN)
UPDATE node SET continent=NULL WHERE key='b797ce0f-47e6-4231-b048-6b62ca3b0f55'; // International Barcode of Life (iBOL)
UPDATE node SET continent='AFRICA' WHERE key='b9628650-eeb8-44e3-80b8-ea6626956793'; // International Centre for Insect Physiology and Ecology
UPDATE node SET continent='ASIA' WHERE key='b35cf8f1-748d-467a-adca-4f9170f20a4e'; // International Centre for Integrated Mountain Development (ICIMOD)
UPDATE node SET continent='EUROPE' WHERE key='ecc358f9-a1ad-4cca-aba3-70265c630c23'; // International Commission on Zoological Nomenclature (ICZN)
UPDATE node SET continent=NULL WHERE key='6ab5da69-215e-4b9e-9f50-c72d146eecfc'; // International Long Term Ecological Research (ILTER)
UPDATE node SET continent=NULL WHERE key='6b02945e-1567-4cd1-8f3b-86c355cfe9ea'; // International Species Information System
UPDATE node SET continent=NULL WHERE key='7a17efec-0a6a-424c-b743-f715852c3c1f'; // Local Governments for Sustainability (ICLEI)
UPDATE node SET continent=NULL WHERE key='b31933e2-061d-46b3-be69-dc6dd82066dd'; // Major Systematic Entomology Facilities
UPDATE node SET continent=NULL WHERE key='b188b530-89cf-420a-8dba-9ae173706bab'; // Natural Science Collections Alliance (NSCA)
UPDATE node SET continent=NULL WHERE key='6aff31ce-8410-4118-ac61-c7571d228dc3'; // NatureServe
UPDATE node SET continent=NULL WHERE key='fa6bdac4-51e2-4334-940c-ba6cdf6e1257'; // Nordic Genetic Resource Center (NORDGEN)
UPDATE node SET continent=NULL WHERE key='ba0670b9-4186-41e6-8e70-f9cb3065551a'; // Ocean Biogeographic Information System (OBIS)
UPDATE node SET continent='OCEANIA' WHERE key='3b9510fc-5943-45d3-b08d-5b4e1e7c385e'; // Pacific Biodiversity Information Forum (PBIF)
UPDATE node SET continent=NULL WHERE key='51e4e8ff-bff0-4996-8b27-9107d61b3478'; // Scientific Committee on Antartic Research (SCAR)
UPDATE node SET continent=NULL WHERE key='97818ee4-1461-4180-bf1d-b3201050124f'; // Society for the Management of Electronic Biodiversity Data (SMEBD)
UPDATE node SET continent=NULL WHERE key='07dfe2f9-5116-4922-9a8a-3e0912276a72'; // Society for the Preservation of Natural History Collections (SPNHC)
UPDATE node SET continent=NULL WHERE key='03e816b3-8f58-49ae-bc12-4e18b358d6d9'; // Species 2000
UPDATE node SET continent=NULL WHERE key='93441780-7304-4547-8906-77d4beb2ea6d'; // Taxonomic Databases Working Group (TDWG)
UPDATE node SET continent=NULL WHERE key='b37a283d-89df-4748-82cf-a74ca936222e'; // United Nations Environment Programme, World Conservation Monitoring Centre (UNEP-WCMC)
UPDATE node SET continent=NULL WHERE key='3e193341-3879-44e2-8bd9-64d95b101dbb'; // Wildscreen
UPDATE node SET continent=NULL WHERE key='3a9a7db1-988f-4d90-99ee-b4dbe868a27c'; // World Data Center for Biodiversity and Ecology
UPDATE node SET continent=NULL WHERE key='140074eb-2d9e-4289-8f51-7d987841013d'; // World Data Center for Biodiversity and Ecology (WDCBE)
UPDATE node SET continent=NULL WHERE key='a6bdc523-5368-4e0f-9d2e-de1c262ac092'; // World Federation for Culture Collections
UPDATE node SET continent=NULL WHERE key='5025e030-ce5b-4fc0-bb8d-009b12e6f934'; // World Federation for Culture Collections (WFCC)
{noformat}