Maize trait observation data
We're working on trait data display:
As you can see, there's a mismatch between the declared obseration.cropTrait
and the trait code observation.cropTraitCode
that is pointing to a different cropTrait
.
Check with:
select cto.crop_trait_id 'observation.crop_trait_id', ctc.crop_trait_id 'observation.code.crop_trait_id', count(cto.crop_trait_observation_id) 'COUNT_INVALID_OBSERVATION_TRAITID'
from crop_trait_observation cto
inner join crop_trait_code ctc on ctc.crop_trait_code_id = cto.crop_trait_code_id
where cto.crop_trait_id != ctc.crop_trait_id
group by cto.crop_trait_id, ctc.crop_trait_id;