-- This corresponds to location/public/full embargos (http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename#confidentialityStatus)

-- Prevent "column name specified more than once" errors when tables are joined

ALTER TABLE commconcept RENAME commname  TO commconcept__commname;

ALTER TABLE taxonobservation RENAME reference_id  TO taxonobservation_reference_id;

ALTER TABLE taxonobservation RENAME accessioncode  TO taxonobservation_accessioncode;