-- ----------------------------------------------------- LOADING OF DATA: load_spati
--                                                                     1999.04.22 ft
--
update LOAD_SPATI set hor_sys_descr    ='*not filled' where hor_sys_descr    is NULL;
update LOAD_SPATI set ver_sys_descr    ='*not filled' where ver_sys_descr    is NULL;
--
insert into SPATIAL_REFERENCE (entry_id,               hor_coord_sys_id, 
                                                       ver_coord_sys_id)
  select                       entry_id, HOR_COORD_SYS.hor_coord_sys_id, 
                                         VER_COORD_SYS.ver_coord_sys_id
  from LOAD_SPATI, HOR_COORD_SYS, VER_COORD_SYS 
 where LOAD_SPATI.hor_sys_descr           = HOR_COORD_SYS.sys_descr
   and LOAD_SPATI.ver_sys_descr           = VER_COORD_SYS.sys_descr;
