Project

General

Profile

Actions

Bug #16498

open

Update Management Entities Information

Added by Yannis Marketakis about 6 years ago. Updated almost 5 years ago.

Status:
In Progress
Priority:
Normal
Target version:
Start date:
Apr 10, 2019
Due date:
Apr 12, 2019 (over 6 years late)
% Done:

10%

Estimated time:

Description

There are various information missing (e.g. acronym, country) from the management entities for several fisheries records.
Now FishSource has exposed more recent information. As a result:

  • we will update the GRSF KB with the missing information about the management entities (coming from FishSource)
  • we will update the corresponding records in GRSF VREs (both legacy and GRSF records)

Files

Fishery Records with updated management entities.xlsx (32.1 KB) Fishery Records with updated management entities.xlsx Yannis Marketakis, Apr 10, 2019 11:25 AM
issue_16948_updated_Records.xlsx (46.4 KB) issue_16948_updated_Records.xlsx Yannis Marketakis, Apr 11, 2019 10:50 AM
capture.jpg (47.8 KB) capture.jpg Yannis Marketakis, Apr 18, 2019 03:53 PM

Related issues

Related to StocksAndFisheriesKB - Bug #13250: Honduran management organization acronym not appearingClosedYannis MarketakisApr 11, 2064

Actions
Actions #1

Updated by Yannis Marketakis about 6 years ago

The attached list contains the fishery records to be updated w.r.t. the updates in their management entities (i.e. addition of code or country).

I'll update the GRSF KB w.r.t. this list and then update the records in GRSF admin.
After that, I'll proceed with the corresponding GRSF fishery records.

Actions #2

Updated by Yannis Marketakis about 6 years ago

  • Status changed from In Progress to Feedback
  • % Done changed from 0 to 100

The management entities have been updated w.r.t. the latest information from FishSource.

In addition, we have updated the corresponding (legacy) fishery records and the GRSF Fishery records accordingly (including updating their semantic identifiers properly).

Actions #3

Updated by Yannis Marketakis about 6 years ago

If you wish to check the updated records, attached you will find the list of catalog URLs for the records that have been updated.

Actions #4

Updated by Marina Mendes about 6 years ago

  • Related to Bug #13250: Honduran management organization acronym not appearing added
Actions #5

Updated by Marina Mendes about 6 years ago

Hi Yannis, thanks for your work on this. I can confirm the records identified in notes 43 and 44 of #13250 are updated but I wanted to let you know can I couldn't find them in any of the attached files (using the code after the slash).

Actions #6

Updated by Marina Mendes about 6 years ago

this record
http://data.d4science.org/ctlg/GRSF_Admin/20366f4e-5949-31be-9ff9-816a8c79e661
is missing the national authority
GRSF Semantic identifier: asfis:HKU+fao:41.2;fao:41.3++iso3:BRA+isscfg:03.19

Actions #7

Updated by Yannis Marketakis about 6 years ago

  • File capture.jpg capture.jpg added
  • Status changed from Feedback to In Progress
  • % Done changed from 100 to 90

Marina Mendes wrote:

Hi Yannis, thanks for your work on this. I can confirm the records identified in notes 43 and 44 of #13250 are updated but I wanted to let you know can I couldn't find them in any of the attached files (using the code after the slash).

Hi Marina. You can find them in the file with name issue_16948_updated_Records.xlsx in lines 470 and 473.

Marina Mendes wrote:

this record
http://data.d4science.org/ctlg/GRSF_Admin/20366f4e-5949-31be-9ff9-816a8c79e661 is missing the national authority GRSF Semantic identifier: asfis:HKU+fao:41.2;fao:41.3++iso3:BRA+isscfg:03.19

I will further investigate this

Actions #11

Updated by Marina Mendes about 6 years ago

thanks a lot, Yannis! I'll check the listed records to try to understand why the country codes are missing in FS.

Actions #12

Updated by Susana Segurado almost 6 years ago

  • Assignee changed from Yannis Marketakis to Merul Patel

We've found the issue with the remaining records is a case-sensitivity mismatch on our end, resulting in the country not being sent. Assigning to Merul.

Actions #13

Updated by Merul Patel almost 6 years ago

  • Assignee changed from Merul Patel to Yannis Marketakis

Curiously only the Organizations for the Falklands were affected. I've corrected the data on FS so the API will now return the country information correctly. I've also queued up a development task to ensure we can get better quality control on this at our end.

Fishsource ticket: https://sharespace.sustainablefish.org/issues/15559

Actions #14

Updated by Yannis Marketakis almost 6 years ago

  • Assignee changed from Yannis Marketakis to Merul Patel

Thanks for the update Merul. I've updated the corresponding records in GRSF Admin VRE. There are still some issues (I'm pasting them here if you wish to investigate them).

Actions #15

Updated by Susana Segurado almost 6 years ago

https://www.fishsource.org/api/bluebridge/v4/fisheries/5531 (we are missing the country of the management authority)
This is an international organisation, the Convention on the Conservation and Management of Pollock Resources in the Central Bering Sea (CCBSP): do we need to add it to a list of international organisations or how do we get it to be recognised as INT?

https://www.fishsource.org/api/bluebridge/v4/fisheries/4370 (we are missing the acronym of the management authority)
Corrected

https://www.fishsource.org/api/bluebridge/v4/fisheries/2803 (cannot find the fishery record)
https://www.fishsource.org/api/bluebridge/v4/fisheries/4291 (cannot find the fishery record)
https://www.fishsource.org/api/bluebridge/v4/fisheries/5515 (cannot find the fishery record)
https://www.fishsource.org/api/bluebridge/v4/fisheries/4290 (cannot find the fishery record)
Merul, would you be able to look into these please?

Actions #16

Updated by Yannis Marketakis almost 6 years ago

  • Status changed from Feedback to In Progress
  • Assignee changed from Merul Patel to Yannis Marketakis

Thanks @susana.segurado@sustainablefish.org for the update.

I will update the records containing https://www.fishsource.org/api/bluebridge/v4/fisheries/5531 and https://www.fishsource.org/api/bluebridge/v4/fisheries/4370 accordingly.

As soon as @merul.patel@sustainablefish.org has an update for the rest of them, I'll proceed with those as well.

Actions #17

Updated by Yannis Marketakis almost 6 years ago

In addition, I noticed that the acronyms for the organizations with ID 5073 have changed from DPIRD to WAMF.
This affects several records in GRSF (for example http://data.d4science.org/ctlg/GRSF_Admin/d65ab940-db6f-3389-a4e5-bd902128c8d7).
Can you confirm if this update is correct?

Actions #18

Updated by Susana Segurado almost 6 years ago

Thanks for spotting that Yannis. I have amended the organisation details and all should be correct now.

Actions #19

Updated by Yannis Marketakis almost 6 years ago

Thanks Susana.
I've updated the records accordingly.

Actions #20

Updated by Yannis Marketakis almost 6 years ago

  • Assignee changed from Yannis Marketakis to Merul Patel
Actions #21

Updated by Merul Patel almost 5 years ago

  • Assignee changed from Merul Patel to Yannis Marketakis

These fishery records no longer exist - and have been deleted since the original harvest:

  1. https://www.fishsource.org/api/bluebridge/v4/fisheries/2803 (cannot find the fishery record)
  2. https://www.fishsource.org/api/bluebridge/v4/fisheries/4291 (cannot find the fishery record)
  3. https://www.fishsource.org/api/bluebridge/v4/fisheries/5515 (cannot find the fishery record)
  4. https://www.fishsource.org/api/bluebridge/v4/fisheries/4290 (cannot find the fishery record)

Please note, we're in the middle of making an additional modification to the API when returning management entity information, which will allow one or more ISO3166-2 subdivisions to be returned instead of just single values. Examples of this include interstate agencies like Gulf States Marine Fisheries Commission (Texas, Louisiana, Mississippi, Alabama, Florida), but this shouldn't affect our work significantly. Please just ensure your harvest code notes the change in a value from String to Array.

Note for MP and SS: https://sharespace.sustainablefish.org/issues/15554

Actions

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 8.91 MB)