afsc-gap-products / StationAllocationAIGOA

https://afsc-gap-products.github.io/StationAllocationAIGOA/
0 stars 0 forks source link

History of the GOA.GOA_STRATA table #18

Closed zoyafuso-NOAA closed 2 years ago

zoyafuso-NOAA commented 2 years ago

Currently we use GOA.GOA_STRATA table to pull the stratum information (e.g., stratum area) for the DBEs. Duane said they (Bering Sea) use information from the RACEBASE.STRATUM table. I looked at both and they have different stratum areas (see below). Do you know why they're different, some sort of a difference in calculation? Also, what is the YEAR column in RACEBASE.STRATUM referring to? Thanks in advance.

<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40">

RACEBASE.STRATUM |   |   |   |   |   |   |   |   |   |   -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- REGION | YEAR | STRATUM | PORTION | AREA | DESCRIPTION | AUDITJOIN |   |   |   |   |   GOA | 1990 | 10 | | 8615.919 | Fox Islands | 73 |   |   |   |   |   |   GOA | 1990 | 11 | | 13678.46 | Davidson Bank | 74 |   |   |   |   |   |   GOA | 1990 | 12 | | 7442.892 | Lower Alaska Peninsula | 75 |   |   |   |   |   |   GOA | 1990 | 13 | | 14625.11 | Shumagin Bank | 76 |   |   |   |   |   |   GOA | 1990 | 20 | | 8283.218 | Upper Alaska Peninsula | 82 |   |   |   |   |   |   GOA | 1990 | 21 | | 7298.836 | Semidi Bank | 83 |   |   |   |   |   |     |   |   |   |   |   |   |   |   |   |   |   |   GOA.GOA_STRATA |   |   |   |   |   |   |   |   |   |   |   SURVEY | STRATUM | AREA | PERIMETER | INPFC_AREA | MIN_DEPTH | MAX_DEPTH | DESCRIPTION | SUMMARY_AREA | SUMMARY_DEPTH | SUMMARY_AREA_DEPTH | REGULATORY_AREA_NAME | STRATUM_TYPE GOA | 10 | 8332.718 | 1700.816 | Shumagin | 1 | 100 | Fox Islands | 919 | 991 | 911 | WESTERN GOA | SHELF GOA | 11 | 13681.24 | 868.189 | Shumagin | 1 | 100 | Davidson Bank | 919 | 991 | 911 | WESTERN GOA | SHELF GOA | 12 | 6875.823 | 1918.516 | Shumagin | 1 | 100 | Lower Alaska Peninsula | 919 | 991 | 911 | WESTERN GOA | SHELF GOA | 13 | 12398.79 | 1783.463 | Shumagin | 1 | 100 | Shumagin Bank | 919 | 991 | 911 | WESTERN GOA | SHELF GOA | 20 | 7940.852 | 2470.078 | Chirikof | 1 | 100 | Upper Alaska Peninsula | 929 | 991 | 921 | CENTRAL GOA | SHELF GOA | 21 | 7302.086 | 632.708 | Chirikof | 1 | 100 | Semidi Bank | 929 | 991 | 921 | CENTRAL GOA | SHELF

Ned-Laman-NOAA commented 2 years ago

I just learned of the RACEBASE.STRATUM table recently. In the classic biomass.sql script we've been running, we take the area from GOA.GOA_STRATA which I seem to recall confirming at some point in the past was a match to the areas coming out of the OFIS goagrid shapefile that I've considered the gold standard version of our GOA and AI stratification schemes. I do not know what the year in the RACEBASE.STRATUM table was intended for. Could've been when the grid was made but way before my time. Michael might remember.

MargaretSiple-NOAA commented 2 years ago

The year column in RACEBASE.STRATUM is the year that they calculated the stratum area (I guess they changed how they calculated them a few times) so people just use the stratum areas from the most recent year. I hope that helps!

zoyafuso-NOAA commented 2 years ago

Thanks!

Ned-Laman-NOAA commented 2 years ago

Do you want to shift our stratum are lookup table location to the RACEBASE.STRATUM table from the GOA.GOA_STRATA table?

zoyafuso-NOAA commented 2 years ago

I am thinking that having all the strata information in one table (RACEBASE.STRATUM) could be one step closer to unifying the biomass calculations across the regions. We can add the historical and 2023 GOA strata to that table and use the YEAR column to denote the year it was "created".

On Tue, Nov 1, 2022 at 4:22 PM Ned Laman @.***> wrote:

Do you want to shift our stratum are lookup table location to the RACEBASE.STRATUM table from the GOA.GOA_STRATA table?

— Reply to this email directly, view it on GitHub https://github.com/afsc-gap-products/StationAllocationAIGOA/issues/18#issuecomment-1299348921, or unsubscribe https://github.com/notifications/unsubscribe-auth/AOMCLOOSQHO7HA4H2RRXQBDWGGQZDANCNFSM6AAAAAARTWYNDE . You are receiving this because you modified the open/close state.Message ID: @.*** com>

-- Zack Suriya Oyafuso, Ph.D. (he/him/his) Research Fish Biologist GitHub: github.com/zoyafuso-NOAA

NOAA Fisheries, Alaska Fisheries Science Center Resource Assessment and Conservation Engineering Division Groundfish Assessment Program, AI-GOA

7600 Sand Point Way NE, Bldg 4 Seattle, Washington 98115 Google Voice: (206) 526-4026

MargaretSiple-NOAA commented 2 years ago

This would be fine w me, though didn't you say that the stratum areas for GOA are different between the two tables? We should reconcile those if they are... it would change lots of stuff (I currently use the GOA_STRATA table and I think a lot of other ppl do too).