StocksAndFisheriesKB

By checking our Solr indexes, I just noticed that some records are not assigned to grsf-stock or grsf-fishery group.

• For GRSF_ADMIN are 8, in fact 16036+8=16044 that is exactly the amount of records in the GRSF ADMIN organization (see at http://ckan-grsf-admin.d4science.org/organization/grsf_admin). They are:

| name                                 | title                                                                                                                                                                                                                 | groups                                                                                                                                |
|--------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------|
| 0d5857fc-eda4-32b6-98b6-f589c6ffa5fb | Raja naevus - Portuguese Waters - East (Division 27.9.a)                                                                                                                                                              |                                                                                                                                       |
| dc5d0c9b-1a36-3c75-bec4-1273e3af275b | Xiphias gladius - Pacific, Western Central - Pacific, Eastern Central - Western and Central Pacific Fisheries Commission (WCPFC) - Forum Fisheries Agency (FFA) - Vanuatu - Gear nei                                  |                                                                                                                                       |
| d334e18e-3168-4076-ba1e-a44adbebb5a0 | Plesionika martia - Ionian - Sardinia - Aegean - Levant - Balearic - Adriatic - Gulf of Lion - General Fisheries Commission for the Mediterranean (GFCM) - Malta - Single boat bottom otter trawls                    |                                                                                                                                       |
| 143b4ae3-b1aa-4a58-a34d-846465108ac2 | Pomacentridae - Pacific, Western Central - Pacific, Eastern Central - Western and Central Pacific Fisheries Commission (WCPFC) - Forum Fisheries Agency (FFA) - Solomon Islands - Mechanized lines and pole-and-lines |                                                                                                                                       |
| 2a88cc94-788c-3212-a25b-dc347c5f30bb | Polysteganus coeruleopunctatus - Indian Ocean, West / 51.8                                                                                                                                                            | grsf-stock-firms                                                                                                                      |
| 3798d2d1-43ed-3fa0-9b0b-293d9e7aa7e6 | Pandalus borealis - Atlantic, Northwest / 21.4.R - Atlantic, Northwest / 21.4.T - Atlantic, Northwest / 21.4.S                                                                                                        |                                                                                                                                       |
| 37c06b43-9179-329f-b6d7-2991688a776d | Macrodon ancylodon - Guyana - French Guiana                                                                                                                                                                           | abundance-level-firms-standard,fao-categories,fishing-pressure-firms-standard,grsf-assessment-unit,grsf-stock-firms                   |
| 661b6b76-4e98-3d09-aa49-e9049586fc48 | Molva molva - Atlantic, Northeast                                                                                                                                                                                     | abundance-level,abundance-level-firms-standard,fishing-pressure,fishing-pressure-firms-standard,grsf-assessment-unit,grsf-stock-firms |

• For GRSF is 1, in fact 1532 (GRSF stock) + 91 (GRSF Fishery) = 1623. The records are 1624 (see at https://ckan-grsf.d4science.org/dataset) and the missing one is the following one:

| name                                 | title                                                        | groups |
|--------------------------------------|--------------------------------------------------------------|--------|
| 99904192-d6fd-39e1-9995-a8a2985b1177 | Merluccius polli - Cunene - Cape Salinas - Cape Palmeirinhas |        |

I'm going to assign this ticket to @marketak@ics.forth.gr in order to perform the proper action (update or remove) the above records. The updating should add them to the proper group/s.

I first tried updating the record in GRSF VRE. However, the publisher service reported that the record didn't exist in GRSF Catalog. In addition, I cannot search for the record (using the search field),

For example, if I search for records using the term Merluccius, I face a server error

Removed from the Solr index (in the GRSF catalogue, record name 99904192-d6fd-39e1-9995-a8a2985b1177)

The missing record was approved again and published in GRSF Public VRE. Now the figures seem OK.

@aureliano.gentile@fao.org and @bracken.vanniekerk@fao.org can you please perform a quick check?

Dears, thanks a lot.
We checked the high level groups vs the competency queries https://i-marine.d4science.org/group/grsf_admin/grsf-competency-queries and figures seems now fine. (Total GRSF Stocks, total GRSF fisheries, total assessment units).

BUT:

• Group Fishing Units seems missing in the CKan list of groups
• The group GRSF Assessment Unit (2781) is smaller than the Type Assessment Unit (2784) where the latter is the correct one according to the competency query (19. Count all Assessment Units)

Thanks @aureliano.gentile@fao.org for your feedback

Aureliano Gentile wrote:

BUT:

• Group Fishing Units seems missing in the CKan list of groups

I believe the Group "Fishing Units" is missing in the list because it never created as CKAN group but only as "type" (alias system:type). In fact, the list of groups for GRSF and GRSF_ADMIN are consistent (see attachments). @marketak@ics.forth.gr, can you confirm?

• The group GRSF Assessment Unit (2781) is smaller than the Type Assessment Unit (2784) where the latter is the correct one according to the competency query (19. Count all Assessment Units)

I detected them by performing a query on SOLR.

For GRSF_ADMIN are 3:

| name                                 | title                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | extras_systemtype | groups                                                                                                                                                               |
|--------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| 374bdb8a-6ed6-3d3f-88a5-0caa96f1cea3 | Macrourus berglax - Norwegian Sea, Spitzbergen, and Bear Island (Subarea 27.2) - Barents Sea (Subarea 27.1) - North Sea (Subarea 27.4) - Skagerrak, Kattegat, Sound, Belt Sea, and Baltic Sea (Subarea 27.3) - East Greenland (Subarea 27.14) - Rockall, Northwest Coast of Scotland and North Ireland (Subarea 27.6) - North of Azores (Subarea 27.12) - Iceland and Faroes Grounds (Subarea 27.5) - Bay of Biscay (Subarea 27.8) - Irish Sea, West of Ireland, Porcupine Bank, Eastern and Western English Channel, etc (Subarea 27.7) - Portuguese Waters (Subarea 27.9) | Assessment Unit   | catches,grsf-stock,grsf-stock-ram                                                                                                                                    |
| e495d42a-f921-35c8-bffd-9b1d71e30b03 | Lamna nasus - Atlantic, Southwest / 41.3 - Atlantic, Southwest / 41.2                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | Assessment Unit   | abundance-level,abundance-level-firms-standard,fishing-pressure,fishing-pressure-firms-standard,grsf-stock,grsf-stock-firms                                          |
| 4b389e78-1065-30a8-a57a-aaced3d91361 | Katsuwonus pelamis - West Atlantic                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | Assessment Unit   | abundance-level,abundance-level-firms-standard,catches,fishing-pressure,fishing-pressure-firms-standard,grsf-stock,scientific-advice,grsf-stock-firms-fishsource-ram |

For GRSF is 1:

| name                                 | title                                         | extras_systemtype | groups                           |
|--------------------------------------|-----------------------------------------------|-------------------|----------------------------------|
| 7a4bc5ae-1947-31a5-aaf2-7f3dcbf40f5c | Northern prawn - Atlantic, Northwest / 21.4.S | Assessment Unit   | grsf-stock,grsf-stock-fishsource |

I kindly ask to @marketak@ics.forth.gr to perform an update for them. Many thanks.

Yannis Marketakis wrote:

Francesco Mangiacrapa wrote:

Sure. But it is quite evident that the Group "Fishing Units" is never created because it is never required.

Basically, approximately 11K records are fishing units (you can check this if you browse by fishing type). Therefore, from your response, I understand that the group was not created before actually publish the records

Exactly, you understood perfectly.

However, if we want to add the new group "Fishing Units" before we need to create it on both the catalogues (GRSF and GRSF_ADMIN), maybe update the business logic in the GRSF Publisher service (@luca.frosini@isti.cnr.it can reply on this) and then update all the 11K records of type "fishing units". If this new activity is required, please @aureliano.gentile@fao.org create a new ticket. Thanks.

... Buon Natale!