About 72817 rows that miss the species name and percentage, because the source FRI value are null as reported in this view in the casfri50_test schema in the casfri_translator VM.
There is a problem with the translation script. This issue occur only for QC04 where the species name and composition was not done properly. In most rows the SPECIES_1 value is “TRANSLATION_ERROR” for FRI “gr_ess” as shown in sql code below.
These gr_ess species codes are the source of the translation error: ("EE","SS","EPE","EBB","BBBBS","BBBBE","SBB","","BBBB","BBPEE","BBPE","PGE","EPG","RBB","SFI","PEBBS","EFI","BBBBR","BBPES","PEBBE","PEPEE","BBPER","EME","RFI","PEPES","BB","SPE","SC","MEE","RS","BBBBPG","SME","PEBBR","MES","RPE","PEPER","FIR","RE","BBE","CE","PEE","MR","MF","RPG","MX","FNC")
About 72817 rows that miss the species name and percentage, because the source FRI value are null as reported in this view in the casfri50_test schema in the casfri_translator VM.
There is a problem with the translation script. This issue occur only for QC04 where the species name and composition was not done properly. In most rows the SPECIES_1 value is “TRANSLATION_ERROR” for FRI “gr_ess” as shown in sql code below.
These gr_ess species codes are the source of the translation error: ("EE","SS","EPE","EBB","BBBBS","BBBBE","SBB","","BBBB","BBPEE","BBPE","PGE","EPG","RBB","SFI","PEBBS","EFI","BBBBR","BBPES","PEBBE","PEPEE","BBPER","EME","RFI","PEPES","BB","SPE","SC","MEE","RS","BBBBPG","SME","PEBBR","MES","RPE","PEPER","FIR","RE","BBE","CE","PEE","MR","MF","RPG","MX","FNC")
See the attached csv for full details qc04_species_translation_errors.csv
Should these simply be excluded from the final table? Have you encountered these species codes in your dataset?