Scott Rohde

I'm not sure why you closed this. This query shows 575 treatments are not referred to by any trait or yield: ``` sql SELECT DISTINCT treatment_id FROM managements_treatments WHERE treatment_id...

After the migration AddSyncId is applied (see pull request #217), this table will have the following columns and constraints: ``` sql Column | Type | Modifiers --------------+--------------------------------+------------------------------------------------------- id | bigint...

@dlebauer With the updated genus constraint (allowing hyphens), there are two violations (see updated query in "Details" section above). One has "Psychotria grandis" as the genus, and is probably a...

I think we can be more restrictive about allowing spaces an periods in species column values be requiring that they only occur as part of ' var. ', ' ssp....

@dlebauer Shall I go ahead and fix what seem to me like obvious errors (including repeated genus name in the scientificname column)?

@dlebauer The deletes have been done and the script has been run in consolidation mode with this output: https://gist.github.com/gsrohde/9c989afe686a54b1c62b The dark green rows will be kept and the others in...

@dlebauer Here is what remains after doing the "easy" deletions and consolidations: https://gist.github.com/gsrohde/adc365ef114790b55cf9 [rendered as html](https://rawgit.com/gsrohde/adc365ef114790b55cf9/raw/b4b8495f7ffd8514f4e7ab3003f1da6d327aea38/out.14983.html) There are 19 groups of duplicates (down from 209).

@dlebauer Two last groups to fix: https://gist.github.com/gsrohde/175081eaa95e563c8ce4#file-out-25948-html But even after this, we're still not quite ready to make `scientificname` unique because there are 162 rows where scientificname is the empty...

All constraints that are checked off are part of pull request #301. Remaining work will be deferred to another migration.

For now I have: name, outdir, description or NOT NULL name is whitespace-normalized (no whitespace other than spaces, no leading or trailing spaces, no double spaces)