     taxon_parent_ref
 )
 (
-  select
+  select DISTINCT ON (i.id, f.taxon_name)
     nextval('public.taxon_identified_id_seq') as id,
     i.id as identification_ref,
     f.taxon_name as taxon_name,

    is_current
)
(
  select
   nextval('public.identifications_abdc_id_seq') as id,
    f.id as flat_id,
    null::timestamp as notion_date,
    '' as determination_status,
    true as is_current
    FROM  darwin2.darwin_flat  f


CREATE TABLE public.taxon_identified as
(
  SELECT DISTINCT ON (i.id, c.value_defined)
    nextval('public.taxon_identified_id_seq') as id,
    i.id as identification_ref,
    c.value_defined as taxon_name,
