select trim(work_site) as ref_number,
         project_name as poi_name,
         replace(street,'¿','') as street,
         streetnr,
         regexp_substr(street,'\d{4}?') as post_code,
         trim((regexp_replace(regexp_substr(replace(street,'¿',''),'\d{4}?\s*?\w+?[\.-]*?\s*?\w+$'),'\d+',''))) as location,
         replace(tin,'-','') as poi_tin,
         planned_start,
         creation_date
  from oc_poi_sodemat
  where work_site is not null;