   ti.id as taxon_identified_ref,
   community,
   v.name
-  FROM taxon_identified ti
-  INNER JOIN taxonomy t on t.id = ti.taxon_ref
-  INNER JOIN class_vernacular_names c ON t.id = c.record_id AND c.referenced_relation = 'taxonomy' 
-  INNER JOIN vernacular_names v ON c.id = v.vernacular_class_ref
+  FROM darwin2.taxon_identified ti
+  INNER JOIN darwin2.taxonomy t on t.id = ti.taxon_ref
+  INNER JOIN darwin2.class_vernacular_names c ON t.id = c.record_id AND c.referenced_relation = 'taxonomy' 
+  INNER JOIN darwin2.vernacular_names v ON c.id = v.vernacular_class_ref
 );
 
 create sequence public.mineral_identified_id_seq;

  ti.id as mineral_identified_ref,
  community,
  v.name
  FROM mineral_identified ti
  INNER JOIN mineralogy t on t.id = ti.mineral_ref
  INNER JOIN class_vernacular_names c ON t.id = c.record_id AND c.referenced_relation = 'mineralogy' 
  INNER JOIN vernacular_names v ON c.id = v.vernacular_class_ref
);

CREATE SEQUENCE public.identifier_abcd_id_seq;

    property_type  || ' / ' || property_sub_type as parameter

  FROM 
    darwin2.darwin_flat as flat
    INNER JOIN darwin2.catalogue_properties c ON referenced_relation = 'specimens' AND record_id = flat.spec_ref
    INNER JOIN darwin2.properties_values p ON property_ref = c.id 
  /*WHERE 
    property_type != 'geo position' and property_sub_type not in ('height', 'altitude', 'depth')    */
  GROUP BY 
