UK NBN Collectory Update

update.sql

-- Set the data provider keys that GBIF have:
UPDATE data_provider SET gbif_registry_key='c71f0513-c95a-4e98-abad-0c222b87ec66' WHERE id=1;
UPDATE data_provider SET gbif_registry_key='d98506d8-5ab1-4a26-9ef1-766bdb54304f' WHERE id=3;
UPDATE data_provider SET gbif_registry_key='3636faf8-c86a-42c5-9bc9-a2d4e6c0c891' WHERE id=4;
UPDATE data_provider SET gbif_registry_key='1849d721-3a33-4c50-9862-692df5351273' WHERE id=5;
UPDATE data_provider SET gbif_registry_key='0c167c76-464a-406e-8d0b-c6dd8314da18' WHERE id=6;
UPDATE data_provider SET gbif_registry_key='13dba6c4-e112-473d-a827-850256bf53c6' WHERE id=8;
UPDATE data_provider SET gbif_registry_key='d3dd95c3-93d4-4349-a13f-55abf89ad140' WHERE id=9;
UPDATE data_provider SET gbif_registry_key='98ba8467-5081-4d15-b168-32d893e18b76' WHERE id=10;
UPDATE data_provider SET gbif_registry_key='90da406e-9e67-4830-a480-befef56beedb' WHERE id=14;
UPDATE data_provider SET gbif_registry_key='90e9563c-9e64-40ba-910b-66100232a212' WHERE id=20;
UPDATE data_provider SET gbif_registry_key='30b165d7-789d-4e0b-b857-f329e0990e82' WHERE id=23;
UPDATE data_provider SET gbif_registry_key='9a61a2c0-1b36-4a9f-9546-353fc4f7a3ca' WHERE id=25;
UPDATE data_provider SET gbif_registry_key='f6213f74-d638-4907-a96d-26ca3b5da0c7' WHERE id=40;
UPDATE data_provider SET gbif_registry_key='a6cb65d4-c47c-434e-9d32-be0689b96d8e' WHERE id=41;
UPDATE data_provider SET gbif_registry_key='5184d142-3e0b-483d-91b5-56bac058800c' WHERE id=42;
UPDATE data_provider SET gbif_registry_key='32f1b389-5871-4da3-832f-9a89132520c5' WHERE id=58;
UPDATE data_provider SET gbif_registry_key='f6b48504-1651-4a49-a88d-c2bc6178694d' WHERE id=64;
UPDATE data_provider SET gbif_registry_key='f0a23325-1a1d-4b4c-a192-63765963d0a4' WHERE id=68;
UPDATE data_provider SET gbif_registry_key='0b8171d0-6b32-4ccc-bf3d-bf34b56c36d3' WHERE id=72;
UPDATE data_provider SET gbif_registry_key='d553959b-a4b3-4caf-896d-8ff6190cdd07' WHERE id=87;
UPDATE data_provider SET gbif_registry_key='950cbfcc-1cb7-46c1-92ce-05ec232512d1' WHERE id=91;
UPDATE data_provider SET gbif_registry_key='1ed074ff-5644-461a-90db-5da4d7656f3f' WHERE id=95;
UPDATE data_provider SET gbif_registry_key='5d662340-07fa-41b7-a3fc-e2e63ca50800' WHERE id=103;
UPDATE data_provider SET gbif_registry_key='f0edcf5c-2a34-4a6b-b9bb-44d52ed50f7a' WHERE id=105;
UPDATE data_provider SET gbif_registry_key='ee45975b-3d89-42b5-ac7a-c03f47b6dcb4' WHERE id=106;
UPDATE data_provider SET gbif_registry_key='c4a764e4-8455-425b-b553-253f9f9dfbac' WHERE id=113;

-- Updates the datasets from GBIF with http://registry.als.scot/GBIF/ urls
UPDATE data_resource SET gbif_registry_key='8f5baa7e-11a3-4186-b9bd-22a838fd72ee' WHERE guid='GA001013';
UPDATE data_resource SET gbif_registry_key='828c029f-d35b-4c09-9b81-e2a7b65cd925' WHERE guid='GA000066';
UPDATE data_resource SET gbif_registry_key='8806aad1-215d-47bb-868b-02ea8fbffde4' WHERE guid='GA000577';
UPDATE data_resource SET gbif_registry_key='4e19e2b8-9934-4b5a-a51f-62df5a9802e7' WHERE guid='GA000612';
UPDATE data_resource SET gbif_registry_key='7dcd2156-75af-4772-bf1b-db606d534977' WHERE guid='GA001134';
UPDATE data_resource SET gbif_registry_key='2790adc5-c709-427c-8d04-804590d98272' WHERE guid='GA000616';
UPDATE data_resource SET gbif_registry_key='7445a910-faa2-4f43-b650-d2f055bfb0d7' WHERE guid='GA000319';
UPDATE data_resource SET gbif_registry_key='02b3bdaa-07dc-45b3-a761-7580d4bdcdb4' WHERE guid='GA000956';
UPDATE data_resource SET gbif_registry_key='edf03db8-68cf-48ac-a545-15f89c88e113' WHERE guid='GA000437';
UPDATE data_resource SET gbif_registry_key='7d17a2b2-8751-41b5-ac9b-48effc1ea236' WHERE guid='GA001423';
UPDATE data_resource SET gbif_registry_key='f7fd7255-5be6-48cf-b76a-821cb84aa93f' WHERE guid='GA000426';
UPDATE data_resource SET gbif_registry_key='f1929b90-79f5-47aa-b983-51f108eb491f' WHERE guid='GA000144';
UPDATE data_resource SET gbif_registry_key='91c4bb90-3608-47e6-9757-361a4a7728f5' WHERE guid='GA000937';
UPDATE data_resource SET gbif_registry_key='458acc40-a815-4fa3-859b-66c84e324907' WHERE guid='GA000936';
UPDATE data_resource SET gbif_registry_key='832fa9ed-1aa9-47dd-9cba-6a58d91b8a12' WHERE guid='GA000940';
UPDATE data_resource SET gbif_registry_key='a072acef-4ec2-4a2d-8532-cd19ebe5fabc' WHERE guid='GA001054';
UPDATE data_resource SET gbif_registry_key='0e6ca8ff-526a-4d2f-ba9b-4238f45d281b' WHERE guid='GA001022';
UPDATE data_resource SET gbif_registry_key='998ff7b4-0e07-40d0-ba1f-c5f249dbcd51' WHERE guid='GA000469';
UPDATE data_resource SET gbif_registry_key='af2f0d97-7df6-41d4-a0d6-74d5be8a81d4' WHERE guid='GA000939';
UPDATE data_resource SET gbif_registry_key='0233af7f-11ae-491e-be56-a4038ecf6585' WHERE guid='GA001020';
UPDATE data_resource SET gbif_registry_key='56a5cb72-db94-42f5-9f71-de81e56588b7' WHERE guid='GA001445';
UPDATE data_resource SET gbif_registry_key='3a6ab9d2-a0e2-4c16-8040-2e1ad912547c' WHERE guid='GA001434';
UPDATE data_resource SET gbif_registry_key='83c5db8e-ade3-4269-9f33-00f85d90355a' WHERE guid='GA001435';
UPDATE data_resource SET gbif_registry_key='6cb824fd-7c2e-491b-85c9-156f1c4f9b29' WHERE guid='GA001436';
UPDATE data_resource SET gbif_registry_key='8073bd4c-cf6e-42ad-979c-dc8b3ba1d422' WHERE guid='GA001437';
UPDATE data_resource SET gbif_registry_key='fe17fe38-29d7-48ec-a4f6-bda16a39679f' WHERE guid='GA001438';
UPDATE data_resource SET gbif_registry_key='c293d351-7a9b-4963-b81b-b8dfa96fae1b' WHERE guid='GA001439';
UPDATE data_resource SET gbif_registry_key='919fbd54-6fa6-4a6f-a616-4a87962a0a37' WHERE guid='GA001371';
UPDATE data_resource SET gbif_registry_key='c497c84a-ba5e-439d-8932-b23df520e529' WHERE guid='GA001432';
UPDATE data_resource SET gbif_registry_key='f3a952cc-b6f4-4e2b-91f7-e2261377c0e8' WHERE guid='GA001433';
UPDATE data_resource SET gbif_registry_key='a3d3fb48-90f0-442a-bd1a-d0876fc7972d' WHERE guid='GA001440';
UPDATE data_resource SET gbif_registry_key='1ee2f194-4c11-4212-a77a-28a4cfcd5c50' WHERE guid='GA001446';
UPDATE data_resource SET gbif_registry_key='5108c281-71ad-4ad5-bbd8-160272dcd784' WHERE guid='GA001441';
UPDATE data_resource SET gbif_registry_key='dbe7a6d3-b852-4d0d-a91a-caf495556d3a' WHERE guid='GA001447';
UPDATE data_resource SET gbif_registry_key='437fa56c-e7bb-4534-93c5-8af0bebd5d72' WHERE guid='GA001442';
UPDATE data_resource SET gbif_registry_key='b87b2913-b9ad-4ec5-8272-0978994acce4' WHERE guid='GA001443';
UPDATE data_resource SET gbif_registry_key='439e017b-c952-490b-9b5a-1e190e55bb15' WHERE guid='GA001444';
UPDATE data_resource SET gbif_registry_key='91a7ba5f-1090-45f6-9e71-48b0bce5ab63' WHERE guid='GA001253';
UPDATE data_resource SET gbif_registry_key='86653843-d46c-4924-9cbe-34737366a5b3' WHERE guid='GA001252';
UPDATE data_resource SET gbif_registry_key='4bd64435-fb04-494a-a344-0218ea59a7d4' WHERE guid='GA000054';
UPDATE data_resource SET gbif_registry_key='96650f03-b67c-47e7-a4dd-186ba073e6dc' WHERE guid='GA000092';
UPDATE data_resource SET gbif_registry_key='5eaed87c-cd79-45db-a488-727967a939d7' WHERE guid='GA000051';
UPDATE data_resource SET gbif_registry_key='2d519945-a6de-49ee-96e3-de80099cc339' WHERE guid='GA000050';
UPDATE data_resource SET gbif_registry_key='0de20c27-792a-461b-ae59-3ab8221a1113' WHERE guid='GA000489';
UPDATE data_resource SET gbif_registry_key='52246141-e0f3-4806-8de1-6911bc2436b8' WHERE guid='GA000028';
UPDATE data_resource SET gbif_registry_key='7a8bd8ec-3ba7-4c31-8753-7a6ef27fdc50' WHERE guid='GA000638';
UPDATE data_resource SET gbif_registry_key='1218ac4d-966d-48a9-8368-981aa4f7a907' WHERE guid='GA000859';
UPDATE data_resource SET gbif_registry_key='6fa048ce-0d12-49a4-81b9-7537214bdc78' WHERE guid='GA000053';
UPDATE data_resource SET gbif_registry_key='3184ffaf-a7d3-4498-a8f9-3f1e0e45e1e9' WHERE guid='GA001471';
UPDATE data_resource SET gbif_registry_key='a8fa6060-ed0e-41e6-b21c-708d6ee7994b' WHERE guid='GA001466';
UPDATE data_resource SET gbif_registry_key='c0dd4990-1803-4d6b-bc06-2f7eeaba100d' WHERE guid='GA000383';
UPDATE data_resource SET gbif_registry_key='d1d43406-4711-4ed9-a827-38f7b26311ab' WHERE guid='GA001302';
UPDATE data_resource SET gbif_registry_key='127246c7-144e-4e06-a5fa-90828a4bdabb' WHERE guid='GA000496';
UPDATE data_resource SET gbif_registry_key='f9e48836-88b1-47d3-bb82-7a62ea22dd7d' WHERE guid='GA001315';
UPDATE data_resource SET gbif_registry_key='20fa3e49-f75c-4aad-adcd-6b3882caf6db' WHERE guid='GA000495';
UPDATE data_resource SET gbif_registry_key='c7919f38-10fd-4806-81e2-4e81135b6af0' WHERE guid='GA000499';
UPDATE data_resource SET gbif_registry_key='fc355172-2a32-4b83-a0dc-1800ae9f563e' WHERE guid='GA001303';
UPDATE data_resource SET gbif_registry_key='8ae2de05-84b2-444a-a64d-4fae46f281d6' WHERE guid='GA000497';
UPDATE data_resource SET gbif_registry_key='46e8a416-131d-4fa9-920a-0f30a7b6f041' WHERE guid='GA001039';
UPDATE data_resource SET gbif_registry_key='13ab2b0e-74b7-46bf-9379-a7a7d838b703' WHERE guid='GA001040';
UPDATE data_resource SET gbif_registry_key='ed5d13f9-cca9-42b9-b681-3d50a1693865' WHERE guid='GA000973';
UPDATE data_resource SET gbif_registry_key='439c7428-4ec3-4925-8065-1a653a93fcf2' WHERE guid='GA000969';
UPDATE data_resource SET gbif_registry_key='b7edcdcf-bcd9-4669-b97b-9bc2f1119ea6' WHERE guid='GA001043';
UPDATE data_resource SET gbif_registry_key='fe62fe7b-a441-4ab1-9451-bb016674c706' WHERE guid='GA001042';
UPDATE data_resource SET gbif_registry_key='58af2fa8-c6ea-4cb8-98ef-144512ee26a9' WHERE guid='GA001038';
UPDATE data_resource SET gbif_registry_key='b6eae303-f834-41db-8b39-42168d1b0bcd' WHERE guid='GA000971';
UPDATE data_resource SET gbif_registry_key='dd6f4b03-8219-49dd-9934-e78ae3f6d8e4' WHERE guid='GA000715';
UPDATE data_resource SET gbif_registry_key='710abb98-2f53-4ce8-9ebb-67bb558860b7' WHERE guid='GA000970';
UPDATE data_resource SET gbif_registry_key='f5477e1b-bd64-4725-823c-4e4f548b3ec7' WHERE guid='GA000972';
UPDATE data_resource SET gbif_registry_key='4d4e7415-5800-4d8b-8d4d-6de938e8d38c' WHERE guid='GA000714';
UPDATE data_resource SET gbif_registry_key='4fa0d1fc-ad2f-4c0d-b716-278693f91afc' WHERE guid='GA000968';
UPDATE data_resource SET gbif_registry_key='494ba938-4fbe-4771-99ac-57f7eafd7c66' WHERE guid='GA001041';
UPDATE data_resource SET gbif_registry_key='0284b82d-cdd1-4d67-83bd-c8e42e988adb' WHERE guid='GA001349';
UPDATE data_resource SET gbif_registry_key='c3c56ab1-706c-4e7f-85f8-f6f860e203f2' WHERE guid='GA001348';
UPDATE data_resource SET gbif_registry_key='547f2b71-ba25-4254-aaf1-4823600e7784' WHERE guid='GA000977';
UPDATE data_resource SET gbif_registry_key='b480871a-6c2f-4c35-ab94-6de203c4ff28' WHERE guid='GA000979';
UPDATE data_resource SET gbif_registry_key='2461b2e8-6bb6-4402-8b99-03b5d13885b4' WHERE guid='GA001195';
UPDATE data_resource SET gbif_registry_key='efb3f1a0-43d5-4ae6-a58f-4fd61043756a' WHERE guid='GA001194';
UPDATE data_resource SET gbif_registry_key='3427d02c-2723-47b5-913b-9193269f0a6d' WHERE guid='GA001256';
UPDATE data_resource SET gbif_registry_key='fe013393-3bda-4369-a8e4-015b89ba65fb' WHERE guid='GA000480';
UPDATE data_resource SET gbif_registry_key='5f7dc9a7-a3c3-4fd9-a984-b7da07b47c47' WHERE guid='GA001166';
UPDATE data_resource SET gbif_registry_key='b7691b4d-ddcb-4def-bd01-53fe7319f5d4' WHERE guid='GA000488';
UPDATE data_resource SET gbif_registry_key='0e2d604a-0ba5-4ed9-ae7a-31ceac2aa1fb' WHERE guid='GA001255';
UPDATE data_resource SET gbif_registry_key='5d531e64-b4e9-4b4e-b9f0-21768389763f' WHERE guid='GA000814';
UPDATE data_resource SET gbif_registry_key='cfa7bdfb-4b6d-47cd-9a42-55ab7d2e5dac' WHERE guid='GA000412';
UPDATE data_resource SET gbif_registry_key='3eeb764b-491c-430d-94d5-bba911cb34fe' WHERE guid='GA000424';
UPDATE data_resource SET gbif_registry_key='8926226e-ceae-4bba-9808-bd13eb917f88' WHERE guid='GA000433';
UPDATE data_resource SET gbif_registry_key='882369ec-9118-4d98-bed9-a44210a2e9cb' WHERE guid='CCWJMP02';
UPDATE data_resource SET gbif_registry_key='b66c629e-b878-4b26-960d-7c0103b025c7' WHERE guid='GA000946';
UPDATE data_resource SET gbif_registry_key='682ad111-d16c-4a31-8044-b7977bc8904a' WHERE guid='GA000434';
UPDATE data_resource SET gbif_registry_key='9ffd5049-d976-4bd4-ac57-9666a20a66d2' WHERE guid='GA000478';
UPDATE data_resource SET gbif_registry_key='eb9f8323-02f8-4e10-a9e6-48fca6cb3f72' WHERE guid='GA000399';
UPDATE data_resource SET gbif_registry_key='6be65214-1a60-4470-8752-9787bb31d3cf' WHERE guid='GA001049';
UPDATE data_resource SET gbif_registry_key='5180805a-a528-40ea-a03b-4911ef4e4ef6' WHERE guid='GA001051';
UPDATE data_resource SET gbif_registry_key='688862fc-1545-483b-8349-9d7b4f787877' WHERE guid='GA001323';
UPDATE data_resource SET gbif_registry_key='9b65cb62-96b8-4809-84f0-511134fa03d9' WHERE guid='GA001052';
UPDATE data_resource SET gbif_registry_key='fdc95521-2893-4c0b-9a3f-544f8aee4c55' WHERE guid='GA001377';
UPDATE data_resource SET gbif_registry_key='67d09fb3-c92e-45c2-ba85-fa3b3fa5d225' WHERE guid='GA001091';
UPDATE data_resource SET gbif_registry_key='9bd88bf0-4090-4785-a243-33b3b05d0e05' WHERE guid='GA001050';
UPDATE data_resource SET gbif_registry_key='686c1b9b-5f29-4e1f-8c28-f9779d264579' WHERE guid='GA000810';
UPDATE data_resource SET gbif_registry_key='04c4143f-1b12-44c1-a81d-1ef5fb3ea175' WHERE guid='GA001088';
UPDATE data_resource SET gbif_registry_key='053cc2c4-c0c9-4024-8cdb-9f45b93700bf' WHERE guid='GA000729';
UPDATE data_resource SET gbif_registry_key='9223ae40-6d6f-458f-83f8-8d58300f5ebf' WHERE guid='GA000894';
UPDATE data_resource SET gbif_registry_key='90ed39e5-8f88-421c-a89d-cdcdcbfef392' WHERE guid='GA001384';
UPDATE data_resource SET gbif_registry_key='48d5602a-fbea-417a-b5d3-46073a08efda' WHERE guid='GA000535';
UPDATE data_resource SET gbif_registry_key='a7c1e188-5a04-47fb-8fe1-6a3bcbb1b98c' WHERE guid='GA000551';
UPDATE data_resource SET gbif_registry_key='17ea10b4-1ef2-42ba-9cb1-b38937dd15b9' WHERE guid='GA000534';
UPDATE data_resource SET gbif_registry_key='6ec0db76-23c5-44b5-80f8-ad7e2aa17773' WHERE guid='GA000550';
UPDATE data_resource SET gbif_registry_key='cb7c2913-e387-4fbe-9e57-a2f24ed3d88c' WHERE guid='GA000536';
UPDATE data_resource SET gbif_registry_key='340984fa-507b-4aa6-b59c-cce1dcee339f' WHERE guid='GA000927';
UPDATE data_resource SET gbif_registry_key='3419e2ce-de18-4727-868a-b239c379b3bb' WHERE guid='GA000829';
UPDATE data_resource SET gbif_registry_key='98af357b-541e-4f16-b35c-8ca68767be99' WHERE guid='GA000353';
UPDATE data_resource SET gbif_registry_key='70b7c7b1-fbea-4771-8b63-ee1c7fae393d' WHERE guid='GA000930';
UPDATE data_resource SET gbif_registry_key='b33e446b-41c9-46a7-971c-3046e06fc241' WHERE guid='GA001089';
UPDATE data_resource SET gbif_registry_key='3b45e79d-df3f-4f3f-a0c9-a3a3f0ca2d46' WHERE guid='GA001147';
UPDATE data_resource SET gbif_registry_key='646ff066-e15f-40ef-82d2-2696fdae2c9c' WHERE guid='GA001167';
UPDATE data_resource SET gbif_registry_key='14c06f91-8937-472a-b59e-10cf7f8942d4' WHERE guid='GA001141';
UPDATE data_resource SET gbif_registry_key='fcd8414a-9d49-492c-ab63-17b55aa05b95' WHERE guid='GA000394';
UPDATE data_resource SET gbif_registry_key='08895e67-911b-439e-9275-cd872452975e' WHERE guid='GA001142';
UPDATE data_resource SET gbif_registry_key='2e649272-13e1-40d7-8e1e-e99bc85c9631' WHERE guid='GA001140';
UPDATE data_resource SET gbif_registry_key='8a2a498a-ec04-45f4-8063-29fc807353e0' WHERE guid='GA001148';
UPDATE data_resource SET gbif_registry_key='f6f0e4dc-e1cc-4c7c-9ecc-b84900af76f5' WHERE guid='GA001144';
UPDATE data_resource SET gbif_registry_key='6f86b84a-4a96-4c56-905c-3bfdd6ca9023' WHERE guid='GA000090';
UPDATE data_resource SET gbif_registry_key='13930f68-a676-49bf-8787-fd875b34800d' WHERE guid='GA001143';
UPDATE data_resource SET gbif_registry_key='83b69c34-0ab1-4bf7-af03-aafe208a0825' WHERE guid='GA001139';
UPDATE data_resource SET gbif_registry_key='0a2b1b5e-eaae-4bd5-847a-26b3e27116a5' WHERE guid='GA001137';
UPDATE data_resource SET gbif_registry_key='69f68599-681c-49b9-bf08-7613331d0323' WHERE guid='GA001138';
UPDATE data_resource SET gbif_registry_key='833951d4-633b-49b4-b06c-85d00396ea9e' WHERE guid='GA000305';
UPDATE data_resource SET gbif_registry_key='b23f9eb6-2585-4cb5-85c5-5ba39040838f' WHERE guid='GA001262';
UPDATE data_resource SET gbif_registry_key='1b11a5e3-6991-44fd-848b-6fd9c1368c58' WHERE guid='GA001261';
UPDATE data_resource SET gbif_registry_key='51de9c85-0337-4c68-9783-f13bc0aac15f' WHERE guid='GA001263';
UPDATE data_resource SET gbif_registry_key='887e6209-ea70-46a7-9652-fc94ca97ae0a' WHERE guid='GA001264';
UPDATE data_resource SET gbif_registry_key='d2e6f957-fad6-4dde-8490-8816d537b8dc' WHERE guid='GA000386';
UPDATE data_resource SET gbif_registry_key='821765c9-59dc-4310-9970-d82c2eb9eff7' WHERE guid='GA001265';
UPDATE data_resource SET gbif_registry_key='a8c8144a-3693-4d92-8bc4-49e00dd8defc' WHERE guid='GA001266';
UPDATE data_resource SET gbif_registry_key='52422715-c1db-40a0-ba16-b84a295d248a' WHERE guid='GA001422';
UPDATE data_resource SET gbif_registry_key='928304f1-d313-47cd-b17b-0232bc27b727' WHERE guid='GA001420';
UPDATE data_resource SET gbif_registry_key='990e845f-836b-4467-bc5f-46c8495259ec' WHERE guid='GA001421';
UPDATE data_resource SET gbif_registry_key='82d23348-0fee-4e2d-9152-48136ef54b2d' WHERE guid='GA001419';
UPDATE data_resource SET gbif_registry_key='a899709f-9a73-4cac-84d8-a7dcc7b70280' WHERE guid='GA001417';
UPDATE data_resource SET gbif_registry_key='c45c8530-fd7d-4f30-a9e4-c6d243a4b404' WHERE guid='GA001418';
UPDATE data_resource SET gbif_registry_key='e707e6da-e143-445d-b41d-529c4a777e8b' WHERE guid='GA000623';
UPDATE data_resource SET gbif_registry_key='ade39f25-ebbf-4402-a2ae-34663bead29b' WHERE guid='GA001112';
UPDATE data_resource SET gbif_registry_key='faf7fdb5-0f3d-415e-9db8-e1a9b0463119' WHERE guid='GA001113';
UPDATE data_resource SET gbif_registry_key='3b43aa85-d480-4c51-8746-5d9d577f178b' WHERE guid='GA001114';
UPDATE data_resource SET gbif_registry_key='88384cfd-296d-4e54-a04f-5049ea8b8891' WHERE guid='GA001120';
UPDATE data_resource SET gbif_registry_key='c3ac92ba-ae7a-40de-b8e6-959bc7fefcd4' WHERE guid='GA001121';
UPDATE data_resource SET gbif_registry_key='92b740c6-9387-4458-899d-5a8e48d873ac' WHERE guid='GA001119';
UPDATE data_resource SET gbif_registry_key='702c3283-69d6-455f-a86b-8007c23d6a2b' WHERE guid='GA001124';
UPDATE data_resource SET gbif_registry_key='6ea77499-6db6-46e2-8a74-5517858775f4' WHERE guid='GA001122';
UPDATE data_resource SET gbif_registry_key='e19f8753-d7e6-4c5d-b94a-5474ef7edc96' WHERE guid='GA000855';
UPDATE data_resource SET gbif_registry_key='98d28779-bfcf-4a3e-ab71-b5ecec200737' WHERE guid='GA001123';
UPDATE data_resource SET gbif_registry_key='f5be158c-afe4-4f5c-b238-9526dc13c67f' WHERE guid='GA001125';
UPDATE data_resource SET gbif_registry_key='2ad58f36-82cc-4ba7-820a-dcb22c0f5592' WHERE guid='GA000531';
UPDATE data_resource SET gbif_registry_key='e6796bbe-7ebe-4036-8558-2ba427b031bd' WHERE guid='GA000544';
UPDATE data_resource SET gbif_registry_key='41790bb2-12d4-4093-95d8-2dff7c45446d' WHERE guid='GA001118';
UPDATE data_resource SET gbif_registry_key='fbad4115-2490-4619-a5f2-88b0e4e4d907' WHERE guid='GA001115';
UPDATE data_resource SET gbif_registry_key='6bd34e11-7b44-4d88-9f20-e4c5f6812dd2' WHERE guid='GA001117';
UPDATE data_resource SET gbif_registry_key='3554cb85-fcc0-4ccb-bd5f-757fac6eb54b' WHERE guid='GA000739';
UPDATE data_resource SET gbif_registry_key='7cb23946-b72f-4373-8d38-359109573b23' WHERE guid='GA000853';
UPDATE data_resource SET gbif_registry_key='1b3b7b56-07f8-4609-8df3-98e3a8ffad85' WHERE guid='GA000856';
UPDATE data_resource SET gbif_registry_key='67e2335c-4303-4ee3-9bfe-ecfe65662629' WHERE guid='GA001198';
UPDATE data_resource SET gbif_registry_key='c4a764e4-8455-425b-b553-253f9f9dfbac' WHERE guid='GA000986';

-- Update the data resources that still have old NBN data in GBIF but exist in the new NBN atlas
UPDATE data_resource SET gbif_registry_key='c5b5c14a-3175-4e05-a662-13321911cdfc' WHERE guid='GA000473';
UPDATE data_resource SET gbif_registry_key='b6327887-f76c-4974-a467-d2856cf48bfe' WHERE guid='GA000409';
UPDATE data_resource SET gbif_registry_key='de3cd1eb-1ec1-4e95-b9f8-ec2fc13f51cf' WHERE guid='GA000304';
UPDATE data_resource SET gbif_registry_key='fbd8cfe2-db00-4276-b7bd-e7d9490d2e10' WHERE guid='GA000405';
UPDATE data_resource SET gbif_registry_key='66f39e15-e74d-491c-b5d2-397cd6bad884' WHERE guid='GA000524';
UPDATE data_resource SET gbif_registry_key='61ea5ba5-495f-4acc-b422-3f59ead69cf8' WHERE guid='CCWJMP01';
UPDATE data_resource SET gbif_registry_key='d5cc76e9-ccff-4759-b442-9917c1faaa88' WHERE guid='GA000417';
UPDATE data_resource SET gbif_registry_key='a4d333cb-3de4-495b-9156-41fe32c0d892' WHERE guid='GA000782';
UPDATE data_resource SET gbif_registry_key='9d2d0ec1-bc13-40df-a6ff-6df727cc42b5' WHERE guid='GA000780';
UPDATE data_resource SET gbif_registry_key='c9b0e882-fb04-4572-836e-cca306f2ff24' WHERE guid='GA000404';
UPDATE data_resource SET gbif_registry_key='37a1816f-d4fd-4d30-bf74-72ca5bf0eb90' WHERE guid='GA000610';
UPDATE data_resource SET gbif_registry_key='11314af8-aad0-4414-a961-e91b88fd4abb' WHERE guid='GA000526';
UPDATE data_resource SET gbif_registry_key='acd3e0ac-cfb0-41c1-827b-f831c4b5b57d' WHERE guid='GA000781';
UPDATE data_resource SET gbif_registry_key='5d030f0a-968a-43dd-8a94-931702f56f57' WHERE guid='GA000161';
UPDATE data_resource SET gbif_registry_key='6df4cdef-c55d-4a03-9055-3cbadcdd05aa' WHERE guid='GA000189';
UPDATE data_resource SET gbif_registry_key='27e416d9-ac57-48a6-ad78-55990f7af998' WHERE guid='GA000682';
UPDATE data_resource SET gbif_registry_key='6f0597b0-54d4-4084-8d4b-339d5b806181' WHERE guid='GA000779';
UPDATE data_resource SET gbif_registry_key='520237b3-b0b3-47b5-90e1-af12098d6128' WHERE guid='MRCCW900';
UPDATE data_resource SET gbif_registry_key='2ac4b2f0-9887-4d25-a8fa-f94391e87919' WHERE guid='GA000525';
UPDATE data_resource SET gbif_registry_key='05a46222-b9ff-4162-a0e1-08bfcc5c6584' WHERE guid='GA000565';
UPDATE data_resource SET gbif_registry_key='f26b3879-1310-40a1-a9bf-0c99b3ecd666' WHERE guid='GA000483';
UPDATE data_resource SET gbif_registry_key='cc2031d1-395d-4052-8ce1-796a08c3dbf2' WHERE guid='GA000178';
UPDATE data_resource SET gbif_registry_key='4ec3868e-b460-48f0-bd64-8e5daf392827' WHERE guid='GA000776';
UPDATE data_resource SET gbif_registry_key='8821e36f-2d25-44c8-a95e-fb978f38ecde' WHERE guid='GA000548';
UPDATE data_resource SET gbif_registry_key='ce8530a2-cd4b-4e51-9927-76bf49b5a9a6' WHERE guid='GA000506';
UPDATE data_resource SET gbif_registry_key='bbee118c-a50e-4f7f-bca1-d5bfefc5360b' WHERE guid='GA000549';
UPDATE data_resource SET gbif_registry_key='5700022f-8c24-4762-b15c-6c04cc0b02ed' WHERE guid='GA000402';
UPDATE data_resource SET gbif_registry_key='fc124723-4bf6-4c74-8a1a-fa7be138e414' WHERE guid='GA000529';
UPDATE data_resource SET gbif_registry_key='fe730480-cad3-415e-804c-1c2ad80d3859' WHERE guid='GA000945';
UPDATE data_resource SET gbif_registry_key='f530f789-58de-4b43-9f42-1292db1945cf' WHERE guid='GA000941';
UPDATE data_resource SET gbif_registry_key='6647ca7e-cf35-4eb1-8b0c-b8756a1ba6bd' WHERE guid='GA000944';
UPDATE data_resource SET gbif_registry_key='6b3877d5-4869-43aa-af12-92c703fd5b6d' WHERE guid='GA000947';
UPDATE data_resource SET gbif_registry_key='e04b3c0a-79a8-4df6-91f9-8ca5fb52d41c' WHERE guid='GA000960';
UPDATE data_resource SET gbif_registry_key='83072c26-af4e-44a7-b373-0567f623081d' WHERE guid='GA001160';
UPDATE data_resource SET gbif_registry_key='d75b0b4c-8f43-4bc2-8bcd-65f9e5419cd1' WHERE guid='GA001172';
UPDATE data_resource SET gbif_registry_key='8b97e0ae-c803-4d24-8098-74874113c344' WHERE guid='GA001254";