Fix cross-project OTUs in determinations

[tmcelrath]

TODO

• [x] taxon_determination: 1107823; otu_id: 58759; otu_project_id: 13
• [x] taxon_determination: 1046697; otu_id: 85978; otu_project_id: 11
• [x] taxon_determination: 1041300; otu_id: 85983; otu_project_id: 11
• [x] taxon_determination: 1041264; otu_id: 85983; otu_project_id: 11
• [x] taxon_determination: 1041267; otu_id: 85983; otu_project_id: 11
• [x] taxon_determination: 1041291; otu_id: 85983; otu_project_id: 11
• [x] taxon_determination: 1041299; otu_id: 85983; otu_project_id: 11
• [x] taxon_determination: 1041301; otu_id: 85983; otu_project_id: 11
• [x] taxon_determination: 1041302; otu_id: 85983; otu_project_id: 11
• [x] taxon_determination: 1041303; otu_id: 85983; otu_project_id: 11
• [x] taxon_determination: 1041304; otu_id: 85983; otu_project_id: 11
• [x] taxon_determination: 1046617; otu_id: 85984; otu_project_id: 11
• [x] taxon_determination: 1041425; otu_id: 85985; otu_project_id: 11
• [x] taxon_determination: 1041426; otu_id: 85985; otu_project_id: 11
• [x] taxon_determination: 1041152; otu_id: 85986; otu_project_id: 11
• [x] taxon_determination: 1040158; otu_id: 86126; otu_project_id: 11
• [x] taxon_determination: 1039973; otu_id: 86161; otu_project_id: 11
• [x] taxon_determination: 1048922; otu_id: 86265; otu_project_id: 11
• [x] taxon_determination: 1048927; otu_id: 86265; otu_project_id: 11
• [x] taxon_determination: 1037393; otu_id: 90731; otu_project_id: 15
• [x] taxon_determination: 1037392; otu_id: 90731; otu_project_id: 15
• [x] taxon_determination: 1037395; otu_id: 90731; otu_project_id: 15
• [x] taxon_determination: 1037394; otu_id: 90731; otu_project_id: 15
• [x] taxon_determination: 1037651; otu_id: 90742; otu_project_id: 15
• [x] taxon_determination: 1037652; otu_id: 90742; otu_project_id: 15
• [x] taxon_determination: 1037654; otu_id: 90742; otu_project_id: 15
• [x] taxon_determination: 1037653; otu_id: 90742; otu_project_id: 15
• [x] taxon_determination: 1037649; otu_id: 90742; otu_project_id: 15
• [x] taxon_determination: 1037650; otu_id: 90742; otu_project_id: 15
• [x] taxon_determination: 1049618; otu_id: 90907; otu_project_id: 15
• [x] taxon_determination: 1049623; otu_id: 90907; otu_project_id: 15
• [x] taxon_determination: 1048759; otu_id: 90907; otu_project_id: 15
• [x] taxon_determination: 1048758; otu_id: 90907; otu_project_id: 15
• [x] taxon_determination: 1048757; otu_id: 90907; otu_project_id: 15

Code:

puts TaxonDetermination.joins(:otu).where(project_id: 1).merge(Otu.where.not(project_id: 1).order(:id, :project_id)).
map { |d| "- [ ] taxon_determination: [#{d.id}](https://sfg.taxonworks.org/taxon_determinations/#{d.id}); otu_id: #{d.otu.id}; otu_project_id: #{d.otu.project_id}" }.join("\n")

[tmcelrath]

@LocoDelAssembly: Removed labels. Not sure they completely fit. Essentially this requires creating corresponding OTUs inside project and re-assign to new OTU.

[tmcelrath]

Did this get fixed @LocoDelAssembly ?

[tmcelrath]

@LocoDelAssembly It was not. The fix requires manual re-assignment of OTUs or let TW generate one blank OTU for you. I just tested with dev machine, and editing each one and then retyping last letter of name (just to fire up autocomplete) lets you create the substitute OTU in place. With the project already selected, clicking on each number lets you go directly into the offending taxon determination. Looks I accidentally removed human curation needed tag, I should have removed script curation needed only. PS: Progress can be tracked by clicking on checkboxes. Not sure if you can do it given I created the issue?

[tmcelrath]

Manually moved and changed as above. Closing.