OBS_ID is null for some records

SarinaAtkinson-NOAA / FSD-SDDD-Automation

Project management for the Automation Project

Other

0 stars 0 forks source link

Closed SarinaAtkinson-NOAA closed 2 years ago

SarinaAtkinson-NOAA commented 2 years ago

Why is OBS_IS null?

Sarah looked into this issue and discovered that since we are starting from the landings table, by joining everything to landings, we end up pulling records that were no actually sampled which is why OBS_ID becomes null
Easy solution would be to add a filter to exclude records from the landings table that were not sampled

SarinaAtkinson-NOAA commented 2 years ago

Sandra made the change