-
Notifications
You must be signed in to change notification settings - Fork 3
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
gap_products area_id correction #27
Comments
Thanks Ben-- both Zack and I are still at sea right now but we will take a
look when we get back.
…On Fri, Jun 16, 2023 at 8:38 AM Ben Williams ***@***.***> wrote:
In the gap_products.area table for the EBS slope there is a duplicate
area_id for instance:
survey_definition_id = 78
area_id = 1
type = "STRATUM"
area_name = "all"
description = Bering Sea Slope Survey, All Subareas, Depth Range 200-300 m
survey_definition_id = 78
area_id = 1
type = "SUBAREA"
area_name = "1.0"
description = EBS slope subarea 1: All depths
No other tables entries (that I've looked at) appear to duplicate values.
This instance precludes filtering biomass or specimen data on
aurvey_definition_id and area_id alone, thus forcing an undesired join
with the area table. Any chance of a correction?
—
Reply to this email directly, view it on GitHub
<#27>, or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ARTP7MHJ326PMHJR6OLQZRTXLSDWJANCNFSM6AAAAAAZJPPIMA>
.
You are receiving this because you are subscribed to this thread.Message
ID: ***@***.***>
--
Margaret (Megsie) Siple, Ph. D. (she/her)
Research Fish Biologist
Gulf of Alaska and Aleutian Islands Survey Group
Resource Assessment and Conservation Engineering Division
NOAA National Marine Fisheries Service
Alaska Fisheries Science Center
7600 Sand Point Way NE, Bldg. 4
Seattle, WA 98115
phone: 206.661.8403
e-mail: ***@***.***
*At-sea days 2023: May 15 - June 25*
***@***.***>
|
Never mind! Zack has already looked! He asked me to paste this since he can't log into his GitHub at sea:
|
Thanks you two. One note though for my clarification.
but when I get to the EBS slope there are two
All of the |
Sorry again for the late response. Just got back from survey and post-survey leave. Ohh, okay I see what you mean. I think the records in GAP_PRODUCTS.AREA where we have A guide for which design year to use for a given survey/year can be found in GAP_PRODUCTS.SURVEY_DESIGN. |
The gap_products.area table has been cleaned up to remove duplicates and non-standard areas. Closing the issue here unless anything comes up again. |
In the
gap_products.area
table for the EBS slope there is a duplicatearea_id
for instance:survey_definition_id = 78
area_id = 1
type = "STRATUM"
area_name = "all"
description = Bering Sea Slope Survey, All Subareas, Depth Range 200-300 m
survey_definition_id = 78
area_id = 1
type = "SUBAREA"
area_name = "1.0"
description = EBS slope subarea 1: All depths
No other tables entries (that I've looked at) appear to duplicate values. This instance precludes filtering biomass or specimen data on
aurvey_definition_id
andarea_id
alone, thus forcing an undesired join with thearea
table. Any chance of a correction?The text was updated successfully, but these errors were encountered: