NickShafferNOAA
commented
3 years ago This has been kicked up the curb on milestones a lot due to priority of other issues. I am dedicating a good portion of my time this milestone towards general qa / qc of data, including this specific concern.
When pulling weight method include number as well. Currently we are storing weight method lookup docId and description, like to add number as well.
WM 15 visual spatial is not showing up in couch. For some reason records with WM: 15 currently have no weight method. For example obs prod trip 39043, haul 2 has WM 15 but don't see any WM recorded in couch (docId: c2e2197cc57f4d3424a4e49c6ceef5d0) (So far noticed this happens for catch ZMIS that has a list of specimens)
Need to pull basket data from catch_additional_baskets table. This is an extra table, an example is in open access trip, 39793, haul 1, catch 1
Structure type is missing from biostructures record. For example, in oracle when I look up barcode: 100386157 in the dissections table it shows dissection type as 7, whole specimen. In couch when I check the haul record: 619fc183ef019ca7e14aabdddf1ec261, there is no structure type listed there. Have seen this is multiple instances, seems like structure type is missing when we pulled over the data.
Recently while looking at the WCGOP data noticed there are duplicates in the operations doc, catch array. Whenever a species has specimens it's listed twice, one entry contains the species and anotehr contains the weight. An example is of tripId 39586, haul 21, Eulachon and Redbanded rockfish are mentioned twice. https://github.com/nwfsc-fram/boatnet/issues/296