Project

General

Profile

Actions

Bug #13250

closed

Honduran management organization acronym not appearing

Added by Susana Segurado about 6 years ago. Updated over 2 years ago.

Status:
Closed
Priority:
Normal
Target version:
Start date:
Apr 11, 2064
Due date:
% Done:

90%

Estimated time:

Description

In the following record: http://data.d4science.org/ctlg/GRSF_Admin/08b5d29f-71e1-31be-9399-1164785593d2 the Honduran Directorate of Fisheries and Aquaculture is in the short name but not in the semantic identifier. But the record is flagged for traceability.

In FishSource the acronym field is completed (DIGEPESCA) but we're wondering if this could have been done in FishSource post the last harvest to the GRSF?

Anyway, Merul, could you please check that the name (Honduran Directorate of Fisheries and Aquaculture) and acronym (DIGEPESCA) are being correctly sent through the webservice?

If there is no issue from there, please assign to Yannis.


Files


Related issues

Related to StocksAndFisheriesKB - Bug #16275: national authority not showingClosedYannis MarketakisMar 13, 2019

Actions
Related to StocksAndFisheriesKB - Bug #16498: Update Management Entities InformationIn ProgressYannis MarketakisApr 10, 2019Apr 12, 2019

Actions
Blocked by StocksAndFisheriesKB - Bug #13347: Cannot update or publish legacy recordsClosedLuca FrosiniFeb 18, 2019

Actions
Follows StocksAndFisheriesKB - Task #16441: Update all Records in GRSF (Admin and Public VREs)ClosedYannis MarketakisApr 10, 2064

Actions
Actions #1

Updated by Merul Patel about 6 years ago

  • Assignee changed from Merul Patel to Yannis Marketakis

The API is exporting the organisation correctly:

"management_units": [
{
"id": 2083,
"name": "Honduras Western Central Atlantic",
"organizations": [
{
"id": 4518,
"name": "Honduran Directorate of Fisheries and Aquaculture",
"acronym": "DIGEPESCA",
"country": "HND"
}]
}]

It's not possible for me to confirm when the record was last updated, since the acronyms were bulk updated directly to the database during 2018. The record itself was last manually edited in July 2016.

Actions #2

Updated by Yannis Marketakis about 6 years ago

  • Status changed from New to In Progress

I see that the acronym of the management entity has been added correctly for the legacy record in GRSF_Admin VRE http://data.d4science.org/ctlg/GRSF_Admin/be735335-7291-3f55-97a3-de7b9047bac2 but not for the corresponding GRSF stock record.

I will further investigate this.

Actions #3

Updated by Yannis Marketakis about 6 years ago

I found that the same issue occurs for many fishery records (more than 1000).
Some indicative ones are:

I can update them programmatically.
@aureliano.gentile@fao.org what do you think?

Actions #4

Updated by Aureliano Gentile about 6 years ago

  • File screenshot-bluebridge.d4science.org-2019.02.14-17-49-37.png added
  • File screenshot-bluebridge.d4science.org-2019.02.14-18-04-27.png added
Actions #6

Updated by Aureliano Gentile about 6 years ago

As per TWG3 workshop on GRSF, it decided to limit the identifier at national level simply by indicating to which country the national authority belongs to.

In fact the Wiki documentation https://support.d4science.org/projects/stocksandfisherieskb/wiki/GRSF_database_overview#Guidelines-for-mapping-to-GRSF-standards indicates:

Management Authority - The coverage of the existing GRSF repository of Management Authorities (i.e. a registry of local/national/international organizations/institutions with mandate on fisheries monitoring/management) is limited and “GRSF owned”. National authorities change across time and it may require huge efforts to maintain the information. So far it is enough to indicate the “national management" (with iso3 country code)” (and under which EEZ jurisdiction (ISO3/mrgid). Prefixes: "authority:NAT:", "authority:INT:"; other prefixes: "High seas", "SpecialAgreement".
Note: The registry of national "Management units" (species, area, management authority, shape file) developed by FishSource (starting April 2018), will be integrated in the semantic identifier refining the fisheries identification with specific area classification systems and specific management authorities at national/sub-national level (e.g. "authority:Sub-Nat:XXX").

The ISO3 country code is provided both in FIRMS and FishSource, therefore the semantic identifier shoudl be populated with such iso3country codes when the namespace is "authority:INT:".
However, the Acronym of whatever institution if provided can be added in the record page, following the name. See also attached screenshot.
What do you think @marketak@ics.forth.gr ?

It should be noted that this may produce not unique semantic identifiers, with a further discussion we may conceive for the future to append also the institution acronym which however is not maintained in grsf. But such ambiguity should not take place if to different sub-national management authorities correspond different fishing area codes.

Actions #7

Updated by Aureliano Gentile about 6 years ago

  • File deleted (screenshot-bluebridge.d4science.org-2019.02.14-17-49-37.png)
Actions #8

Updated by Aureliano Gentile about 6 years ago

  • File deleted (screenshot-bluebridge.d4science.org-2019.02.14-18-04-27.png)
Actions #9

Updated by Yannis Marketakis about 6 years ago

Aureliano, your recommendation is not clear to me.
Do you propose adding the acronym of the acronym of the management entity when the ISO3 country code is missing?
If yes, your proposal is to add it under the Management Body/Authority(ies) field, in the semantic identifier or both?

Actions #10

Updated by Aureliano Gentile about 6 years ago

1) the semantic identifier has to be filled with the following logic authority:NAT:
if you check the json form Merul above in this ticket, you see it is "country": "HND" therefore the semantic identifier would be like "... + authority:NAT:HND + ..."

2) the management authority field is already reporting the name of whatever national institute, therefore I am simply suggest to append also the acronym as per the screenshot. In the json example it would correspond to "acronym": "DIGEPESCA"

if not clear (my apologies for that), I am available to briefly discuss in skype

Actions #11

Updated by Yannis Marketakis about 6 years ago

OK.

I just checked why the country code is missing and I found out that this type of information was null, by the time of harvesting FishSource (March 2018). Below you can see the parts of the harvested contents in XML.

    <management_unit>
      <name>Honduras Western Central Atlantic</name>
      <organizations>
        <country>null</country>
        <acronym>DIGEPESCA</acronym>
        <name>Honduran Directorate of Fisheries and Aquaculture</name>
        <id>4518</id>
      </organizations>
      <id>2083</id>
    </management_unit>

I will update this in the GRSF KB and the GRSF VREs, which means that we will update the records.

Actions #12

Updated by Yannis Marketakis about 6 years ago

  • Blocked by Bug #13347: Cannot update or publish legacy records added
Actions #13

Updated by Yannis Marketakis about 6 years ago

There's an issue with the updating of the legacy records (the ones coming from FishSource). I've opened a ticket assigned to CNR. As soon as we fix it I'll update the records accordingly.

Actions #14

Updated by Yannis Marketakis about 6 years ago

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

Both records (the legacy and the GRSF one) have been updated.

Actions #15

Updated by Aureliano Gentile about 6 years ago

With many thanks for this work.
I see a strange "-" following the authority:NAT:HND in the semantic identifier of this record http://data.d4science.org/ctlg/GRSF_Admin/08b5d29f-71e1-31be-9399-1164785593d2 can you check please?

asfis:SLC+fao:31+authority:NAT:HND - +iso3:HND+isscfg:08.2

Actions #16

Updated by Yannis Marketakis about 6 years ago

You are right!
Just updated it.

Actions #17

Updated by Aureliano Gentile about 6 years ago

Thanks, I trust that fix is applied to all records and future records generation

Actions #18

Updated by Aureliano Gentile about 6 years ago

In example here the iso3 country code for the authority is still missing http://data.d4science.org/ctlg/GRSF_Admin/f8fb17c8-cfb3-3079-a071-ae3509e5e12a

GRSF Semantic identifier: asfis:ABS+fao:31+authority:NAT:-+iso3:USA+isscfg:03.12

Code: authority:NAT:-, System: unk, Name: Florida Fish and Wildlife Conservation Commission

I guess it should be "USA"

So why is it missing? Maybe because this info is not supplied by fishsource or what else? Thanks again.

Actions #19

Updated by Marina Mendes about 6 years ago

  • Related to Bug #16275: national authority not showing added
Actions #20

Updated by Yannis Marketakis about 6 years ago

Aureliano Gentile wrote:

In example here the iso3 country code for the authority is still missing http://data.d4science.org/ctlg/GRSF_Admin/f8fb17c8-cfb3-3079-a071-ae3509e5e12a

GRSF Semantic identifier: asfis:ABS+fao:31+authority:NAT:-+iso3:USA+isscfg:03.12

Code: authority:NAT:-, System: unk, Name: Florida Fish and Wildlife Conservation Commission

I guess it should be "USA"

The proper one should be authority:NAT:FWCC.

Actions #21

Updated by Yannis Marketakis about 6 years ago

Ignore the following, my mistake

Yannis Marketakis wrote:

The proper one should be authority:NAT:FWCC.

Actions #22

Updated by Yannis Marketakis about 6 years ago

This type of information (the ISO3 code of the country) is missing from the sources that have been harvested from Fishsource. Below you'll find the corresponding part.

    <management_unit>
      <name>Florida Atlantic</name>
      <organizations>
        <country>null</country>
        <acronym>FWCC</acronym>
        <name>Florida Fish and Wildlife Conservation Commission</name>
        <id>2428</id>
      </organizations>
      <id>823</id>
    </management_unit>

I'm not sure if FishSource currently has this type of information in their databases.
If yes, and since updating them one by one is not a good option, we could perform a bulk update, if Fishsource colleagues provide us a list with the corresponding mappings (organization ID - country)

Actions #23

Updated by Merul Patel about 6 years ago

The majority of the Management Units in FishSource have country information associated with the Organisations. As an example, here's the output for the entity above from the /api/bluebridge/v4/management_units endpoint:

{
"id": 823,
"name": "Florida Atlantic",
"type": null,
"organisations": [
{
"id": 2428,
"name": "Florida Fish and Wildlife Conservation Commission",
"acronym": "FWCC",
"country": "USA"
}
],
"stock": {
"id": 656,
"name": "American shad - Florida Atlantic"
},
"exploiting_fisheries": [
1385
],
"fishing_areas": [
{
"name": "FAO 31",
"type": "FAO"
},
{
"name": "Florida Atlantic waters (

The same country information is being returned in the stocks endpoint:

"management_units": [
{
"id": 823,
"name": "Florida Atlantic",
"organizations": [
{
"id": 2428,
"name": "Florida Fish and Wildlife Conservation Commission",
"acronym": "FWCC",
"country": "USA"
}
]
}
]

Actions #24

Updated by Yannis Marketakis about 6 years ago

  • % Done changed from 90 to 70

Hi Merul, Thanks for the update.

I've just used the API and noticed that the countries are returned using their ISO2 code.
I'll convert them to ISO3 and use them.

Actions #25

Updated by Aureliano Gentile about 6 years ago

well, in grsf we said standard should be iso3, if FishSource can provide directly iso3 codes, then it would be better (if possible, thanks)

Actions #26

Updated by Merul Patel about 6 years ago

Not sure what you mean Yannis. The samples above in comment 23 show the data returned is ISO3, eg. USA not US.

Actions #27

Updated by Yannis Marketakis about 6 years ago

This is what I get back from https://www.fishsource.org/api/bluebridge/v2/fisheries/3695

{
    "management_unit": {
        "id": 1912,
        "name": "BCO10",
        "organizations": [{
            "id": 3555,
            "name": "NZ Ministry for Primary Industries",
            "acronym": "MPI",
            "country": "NZ"
        }]
    }
}

However, I wouldn't worry since the transformation from ISO2 to ISO3 is something that can be automated from our side (during the harvesting/transformation of data from FishSource)

Actions #28

Updated by Merul Patel about 6 years ago

You're using the V2 version of the API. Not the V4. This is the latest version that has all modifications requested during the GRSF work.

Actions #29

Updated by Aureliano Gentile about 6 years ago

thanks Merul, in the GRSF wiki I see we have this URL https://www.fishsource.org/apipie/
can you tell us which should be the right one?
Or, would it be better to update this generic url https://www.fishsource.org/apipie/ so to have the latest version?
or please advice what you deem is more appropriate

Actions #30

Updated by Merul Patel about 6 years ago

The docs will always be at https://www.fishsource.org/apipie. It should by default open the v4 docs - but something is wrong there and I'll look into that. Apologies.

Actions #31

Updated by Yannis Marketakis about 6 years ago

Thank you Merul for the answer. I was totally unaware of V4.
I will use that instead.

Actions #32

Updated by Yannis Marketakis about 6 years ago

I've updated the management entities with the missing country codes.
In addition, I've updated the semantic IDs of the defected GRSF fishery records.
As a proof-of-concept I've updated http://data.d4science.org/ctlg/GRSF_Admin/88454692-27bb-3b3e-a890-ab8c92420d0f

There are 1052 more GRSF fishery records to be updated.
I'll start updating them today.

Actions #33

Updated by Yannis Marketakis about 6 years ago

  • Follows Task #16441: Update all Records in GRSF (Admin and Public VREs) added
Actions #34

Updated by Yannis Marketakis about 6 years ago

  • Assignee changed from Yannis Marketakis to Aureliano Gentile
  • % Done changed from 70 to 100

All the GRSF Fishery records have been updated in GRSF_Admin. The issue should be resolved now.

Actions #35

Updated by Aureliano Gentile about 6 years ago

Thanks a lot. I checked randomly a few fisheries and the fix seems fine.

One concern on FFA which should be INT not national management authority
Management Body/Authority(ies) Code: authority:NAT:SLB, System: grsf-org, Name: Forum Fisheries Agency (FFA)
(see https://www.ffa.int/about)

In example in this record: http://data.d4science.org/ctlg/GRSF_Admin/fe0691c8-e686-3396-aa47-62ac1cf19f27 OR this one http://data.d4science.org/ctlg/GRSF_Admin/12ad80fd-b23e-3c0f-a362-834179a8a95f
Can it be fixed? I understand this is a content related issue rather than the application logic

Actions #36

Updated by Yannis Marketakis about 6 years ago

  • Status changed from Feedback to In Progress
  • Assignee changed from Aureliano Gentile to Yannis Marketakis
  • % Done changed from 100 to 90

We can do that. Unfortunately, this change will affect 1789 GRSF fishery records that has to be updated.
I'll update the GRSF KB, accordingly and trigger the update overnight.

Actions #37

Updated by Aureliano Gentile about 6 years ago

Thanks a lot,

so from

Management Body/Authority(ies) Code: authority:NAT:SLB, System: grsf-org, Name: Forum Fisheries Agency (FFA)

it will become

Management Body/Authority(ies) Code: authority:INT:FFA, System: grsf-org, Name: Forum Fisheries Agency (FFA)

The mapping file on management entities has been updated accordingly https://data.d4science.org/shub/E_cGxRWVJoSm1KZjhWOUUyM1p1ZllOQVk0by9wVGZuNzJqemVsSWo4YjJQTTMzdW5QNWpOL0lLRmhHYUlzaUdRbw==

(Workspace > VRE Folders > StocksAndFisheriesKB > Requirements > DSDs_and_Mapping_to_GRSF-Standards)

Apologies for the oversight, but definitely that is an international organization (see also http://www.fao.org/fishery/rfb/ffa/en)

Actions #38

Updated by Yannis Marketakis about 6 years ago

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

The corresponding GRSF Fishery records have been updated as proposed.-

Actions #39

Updated by Aureliano Gentile about 6 years ago

Thanks a lot, I checked a few of them, all fine. Then I made a search by "authority:INT:FFA" and I got 1,789 records found for ""authority:INT:FFA"" which indeed is the number of records you were mentioning, hence it should be all good.
I understand all these fixes and updates are reflected in the GSRF VRE, or you may want to refresh it completely at the end of this work.

Actions #40

Updated by Yannis Marketakis about 6 years ago

Thanks.
You are right. For the time being, we are updating everything that needs to be updated in GRSF Admin and afterwards we'll do the same with GRSF VRE. Although for the particular case GRSF VRE is not affected (GRSF Fisheries are not yet approved)

Actions #41

Updated by Aureliano Gentile about 6 years ago

ok, thanks
btw note that so far we have already 31 fishing unit approved in grsf admin:
31 records found Status of the GRSF record: Approved Organisations: GRSF Admin Types: Fishing Unit

Actions #42

Updated by Yannis Marketakis about 6 years ago

You are right.
I'll make sure they are published in GRSF VRE as well.

Actions #43

Updated by Marina Mendes about 6 years ago

one more record missing the national authority - Vice Ministry of Aquaculture and Fisheries of Ecuador (MAGAP) - in the semantic identifier asfis:WEP+fao:87.1++iso3:ECU+isscfg:07.9
http://data.d4science.org/ctlg/GRSF_Admin/bab04278-1066-3903-8ffc-5a15d16cb3d7
which is available in FS as well as below in the API
"fishery_name": "Peruvian weakfish | Ecuador | Ecuador | Ecuador | Gillnets and entangling nets",
"exploiting_stocks": 2024,
"prod_system_type": "",
"flag_state": "ECU",
"fishing_gear": {
"id": 3,
"name": "Gillnets and entangling nets",
"standard_abbreviation": "GEN",
"isscfg": "07.9",
"gear_type": "GearGroup",
"sfp_gear": null
},
"management_unit": {
"id": 2430,
"name": "Ecuador",
"organizations": [
{
"id": 2488,
"name": "Vice Ministry of Aquaculture and Fisheries of Ecuador",
"acronym": "MAGAP",
"country": "ECU"
}

Actions #44

Updated by Marina Mendes about 6 years ago

the same as above:
http://data.d4science.org/ctlg/GRSF_Admin/2416cbc0-c31b-397e-951f-a30ea4cd0f4c
"fishery_name": "Whiteleg shrimp | Ecuador | Ecuador artisanal | Ecuador | Pushnets",
"exploiting_stocks": 1464,
"prod_system_type": "Artisanal",
"flag_state": "ECU",
"fishing_gear": {
"id": 83,
"name": "Pushnets",
"standard_abbreviation": "MPN",
"isscfg": "10.5",
"gear_type": "Gear",
"sfp_gear": null
},
"management_unit": {
"id": 1758,
"name": "Ecuador artisanal",
"organizations": [
{
"id": 2488,
"name": "Vice Ministry of Aquaculture and Fisheries of Ecuador",
"acronym": "MAGAP",
"country": "ECU"
}
]

Actions #45

Updated by Yannis Marketakis about 6 years ago

As described in previous comments we face those issues because the GRSF has been created using an older harvest from Fishsource.

Instead of fixing them one-by-one, I propose updating all the management entities that have missing information using a more recent harvest from FishSource.
I'll open a new issue describing this and the management entities (and the corresponding records) that has to be updated.

Actions #46

Updated by Marina Mendes about 6 years ago

  • Related to Bug #16498: Update Management Entities Information added
Actions #47

Updated by Yannis Marketakis over 2 years ago

  • Status changed from Feedback to Closed
Actions

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 8.91 MB)