   (SELECT keyword FROM darwin2.classification_keywords where 
         referenced_relation = 'taxonomy' and record_id = t.id AND keyword_type='InfraspecificEpithet' LIMIT 1) as InfraspecificEpithet
 
-  FROM darwin2.taxon_identified ti
+  FROM public.taxon_identified ti
   INNER JOIN darwin2.taxonomy t on t.id = ti.taxon_ref
   
   WHERE

ALTER TABLE darwin2.catalogue_levels SET SCHEMA public; 
ALTER TABLE darwin2.darwin_flat SET SCHEMA public; 
ALTER TABLE darwin2.mineralogy SET SCHEMA public; 

ALTER TABLE public.darwin_flat 
  DROP COLUMN building,


CREATE TABLE public.flat_abcd as 
(
  SELECT 
  nextval('public.flat_abcd_id_seq') as id,
  f.id as flat_ref,
  
