David LeBauer

can this be added as a stored procedure?

OK. I updated the name of this issue so that it focuses on google fusion tables. I kept the original images b/c it illustrates the links that would need to...

> This is one reason I don't close issues until the bug fix or feature has actually been deployed. @robkooper would the idea behind a 'hotfix' branch be that we...

These records have been orphaned and can be deleted; please delete them. I think this would be ``` sql delete from treatments where id in (SELECT DISTINCT treatment_id FROM managements_treatments...

- hostname = ip address. (I've fixed the offending `dlebauer-desktop` - created_at, updated_at > 2010-01-01

I've updated the task description (added notes below the bullets) to clarify where needed

I've fixed these. You are certainly welcome to go ahead and apply the simple fixes - removing a text string "NULL" seems pretty clear; the Genus also has a clear...

Please do. On Thu, Feb 26, 2015 at 3:50 PM gsrohde [email protected] wrote: > @dlebauer https://github.com/dlebauer Shall I go ahead and fix what > seem to me like obvious errors...

from @gsrohde Box Sync/EBI-modeling/BETYdb/database integrity/informational queries/species_cleanup/out.28715.html See [live view of gist here](https://rawgit.com/dlebauer/f8fe37e732959b408d21/raw/12c2a25ca223d59f4dbb8e22be258224ce42da22/out.28715.html) The rows with the id (first column) marked in red are rows that can be deleted without losing...

@gsrohde - this looks ready for the `delete_duplicate_species.sql` and `consolodate_species.sql` - please update (check off, modify) the list of tasks in the topmost post; - I added a 'cleanup' section...