truncate table GK_BASIC_JSJY_DWXX_XZGLBMXX;
truncate table GK_BASIC_JSJY_DWXX_XZGLRYXX;
truncate table GK_BASIC_JSJY_GK_GK;
truncate table GK_BASIC_JSJY_GK_GQ;
truncate table GK_BASIC_JSJY_GK_ZYQ;
truncate table GK_BASIC_JSJY_GK_MD;
truncate table GK_BASIC_JSJY_GK_AX;

--行政管理部门和人员
prompt Importing table GK_BASIC_JSJY_DWXX_XZGLBMXX...
set feedback off
set define off
insert into GK_BASIC_JSJY_DWXX_XZGLBMXX (ID, GKGLBMQC, BMLX, RYBZ, LXR, LXDH, CZ, YB, BZ, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, RECORD_STATUS, UPDATE_DATE_TIME, SZD, PID, SORTNO, SFTB, TBZT, ADDRESS, EMAIL, LX, LEAF)
values ('402881f05122619f01512272ebd80003', '徐州市交通运输局', '401', null, null, null, null, null, null, '1', '20-11月-15 09.12.15.573000 上午', '1', 1, '20-11月-15 09.12.15.573000 上午', '90020', '00', 13, 'Y', 'N', null, null, null, null);

prompt Done.

--港口
prompt Importing table GK_BASIC_JSJY_GK_GK...
set feedback off
set define off
insert into GK_BASIC_JSJY_GK_GK (ID, SZD, AQGK, SYHG, WHCG, WHPZ, ZDWXY, PTHWCG, PTHWPZ, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, GKMC, GKDM, SSGKGLBM, GKSZHQ, GKSZGW, HLMC, HGMC, GKMHWZ, GHSFPF, GHPFWH, SFHB, BHBGKMC, BZ, DTSJ, ZYID, AQID, ZRAXCD, SFTB, TBZT, ORDERID, XZQH)
values ('659D99470458492C89F45D6C757AFEAD', '90020', null, null, null, null, null, null, null, '16-11月-15 10.25.40.000000 上午', '16-11月-15 10.25.40.000000 上午', 1, null, null, '徐州港', '321101', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'Y', 'N', 23, '320300');

prompt Done.



--港区
prompt Importing table GK_BASIC_JSJY_GK_GQ...
set feedback off
set define off
insert into GK_BASIC_JSJY_GK_GQ (ID, GQMC, GQSZSYLX, GQMJ, LYMJ, SYFW, SYMJ, GQGHMJ, GHLYMJ, FGYSCYDGHMJ, GHSYMJ, GQZRAXCD, GYMTAXCD, GQGKAXCD, GKSSYSYAXCD, GQDMBDZDZ, BZ, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, SZD, SZGK, SSGKGLBM, GQDM, GQNHHDDM, DLWZWD, DLWZJD, DTSJ, YJPTID, GQMS, ZYID, AQID, SFTB, TBZT, GIS_STATUS, ORDERID)
values ('D5AA2A1BAAD6407CB6BE76A03C9D6D55', '徐州港区-铜山区', '1206', null, null, 1, null, 1, 1, 1, 1, 1, 1, 1, 1, 1, null, '16-11月-15 10.50.34.00000000 上午', '16-11月-15 10.50.34.00000000 上午', 1, null, null, '90020', '659D99470458492C89F45D6C757AFEAD', null, '32110108', null, null, null, null, '9000000008', null, null, '9000000001', 'Y', 'N', null, null);

insert into GK_BASIC_JSJY_GK_GQ (ID, GQMC, GQSZSYLX, GQMJ, LYMJ, SYFW, SYMJ, GQGHMJ, GHLYMJ, FGYSCYDGHMJ, GHSYMJ, GQZRAXCD, GYMTAXCD, GQGKAXCD, GKSSYSYAXCD, GQDMBDZDZ, BZ, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, SZD, SZGK, SSGKGLBM, GQDM, GQNHHDDM, DLWZWD, DLWZJD, DTSJ, YJPTID, GQMS, ZYID, AQID, SFTB, TBZT, GIS_STATUS, ORDERID)
values ('2AA3DD70EC014D37A40F31BD55574B4A', '徐州港区', '1206', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '25-11月-15 04.14.28.00000000 下午', '25-11月-15 04.14.28.00000000 下午', 1, 'aq', 'aq', '90020', '659D99470458492C89F45D6C757AFEAD', null, '32110102', null, null, null, null, null, null, null, '9000000008', 'Y', 'N', null, 58);

insert into GK_BASIC_JSJY_GK_GQ (ID, GQMC, GQSZSYLX, GQMJ, LYMJ, SYFW, SYMJ, GQGHMJ, GHLYMJ, FGYSCYDGHMJ, GHSYMJ, GQZRAXCD, GYMTAXCD, GQGKAXCD, GKSSYSYAXCD, GQDMBDZDZ, BZ, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, SZD, SZGK, SSGKGLBM, GQDM, GQNHHDDM, DLWZWD, DLWZJD, DTSJ, YJPTID, GQMS, ZYID, AQID, SFTB, TBZT, GIS_STATUS, ORDERID)
values ('FA1D8A1F827446FB9857E3AE4D47CED3', '邳州港区', '1201', null, null, 1, null, 1, 1, 1, 1, 1, 1, 1, 1, 1, null, '16-11月-15 10.50.34.00000000 上午', '16-11月-15 10.50.34.00000000 上午', 1, null, null, '90020', '659D99470458492C89F45D6C757AFEAD', null, '32110103', null, null, null, null, '9000000004', null, null, '9000000004', 'Y', 'N', null, 59);

insert into GK_BASIC_JSJY_GK_GQ (ID, GQMC, GQSZSYLX, GQMJ, LYMJ, SYFW, SYMJ, GQGHMJ, GHLYMJ, FGYSCYDGHMJ, GHSYMJ, GQZRAXCD, GYMTAXCD, GQGKAXCD, GKSSYSYAXCD, GQDMBDZDZ, BZ, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, SZD, SZGK, SSGKGLBM, GQDM, GQNHHDDM, DLWZWD, DLWZJD, DTSJ, YJPTID, GQMS, ZYID, AQID, SFTB, TBZT, GIS_STATUS, ORDERID)
values ('AC635BEC86904421892D163897FE042C', '沛县港区', '1201', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.34.00000000 上午', '16-11月-15 10.50.34.00000000 上午', 1, null, null, '90020', '659D99470458492C89F45D6C757AFEAD', null, '32110101', null, null, null, null, '9000000003', null, null, '9000000003', 'Y', 'N', null, 57);

insert into GK_BASIC_JSJY_GK_GQ (ID, GQMC, GQSZSYLX, GQMJ, LYMJ, SYFW, SYMJ, GQGHMJ, GHLYMJ, FGYSCYDGHMJ, GHSYMJ, GQZRAXCD, GYMTAXCD, GQGKAXCD, GKSSYSYAXCD, GQDMBDZDZ, BZ, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, SZD, SZGK, SSGKGLBM, GQDM, GQNHHDDM, DLWZWD, DLWZJD, DTSJ, YJPTID, GQMS, ZYID, AQID, SFTB, TBZT, GIS_STATUS, ORDERID)
values ('01F2B51B2E58432685E226861DB04ABA', '新沂港区', '1201', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.34.00000000 上午', '16-11月-15 10.50.34.00000000 上午', 1, null, null, '90020', '659D99470458492C89F45D6C757AFEAD', null, '32110104', null, null, null, null, '9000000005', null, null, '9000000005', 'Y', 'N', null, 60);

insert into GK_BASIC_JSJY_GK_GQ (ID, GQMC, GQSZSYLX, GQMJ, LYMJ, SYFW, SYMJ, GQGHMJ, GHLYMJ, FGYSCYDGHMJ, GHSYMJ, GQZRAXCD, GYMTAXCD, GQGKAXCD, GKSSYSYAXCD, GQDMBDZDZ, BZ, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, SZD, SZGK, SSGKGLBM, GQDM, GQNHHDDM, DLWZWD, DLWZJD, DTSJ, YJPTID, GQMS, ZYID, AQID, SFTB, TBZT, GIS_STATUS, ORDERID)
values ('E47B148649D2421896364741C024CCA6', '徐州港区-贾汪区', '1206', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '25-11月-15 02.51.58.00000000 下午', '25-11月-15 02.51.58.00000000 下午', 1, null, null, '90020', '659D99470458492C89F45D6C757AFEAD', null, '32110107', null, null, null, null, null, null, null, '9000000007', 'Y', 'N', null, null);

insert into GK_BASIC_JSJY_GK_GQ (ID, GQMC, GQSZSYLX, GQMJ, LYMJ, SYFW, SYMJ, GQGHMJ, GHLYMJ, FGYSCYDGHMJ, GHSYMJ, GQZRAXCD, GYMTAXCD, GQGKAXCD, GKSSYSYAXCD, GQDMBDZDZ, BZ, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, SZD, SZGK, SSGKGLBM, GQDM, GQNHHDDM, DLWZWD, DLWZJD, DTSJ, YJPTID, GQMS, ZYID, AQID, SFTB, TBZT, GIS_STATUS, ORDERID)
values ('2CBDAF409BEF4E299984597E970CDCE1', '丰县港区', '1201', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.34.00000000 上午', '16-11月-15 10.50.34.00000000 上午', 1, null, null, '90020', '659D99470458492C89F45D6C757AFEAD', null, '32110105', null, null, null, null, '9000000002', null, null, '9000000002', 'Y', 'N', null, 61);

insert into GK_BASIC_JSJY_GK_GQ (ID, GQMC, GQSZSYLX, GQMJ, LYMJ, SYFW, SYMJ, GQGHMJ, GHLYMJ, FGYSCYDGHMJ, GHSYMJ, GQZRAXCD, GYMTAXCD, GQGKAXCD, GKSSYSYAXCD, GQDMBDZDZ, BZ, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, SZD, SZGK, SSGKGLBM, GQDM, GQNHHDDM, DLWZWD, DLWZJD, DTSJ, YJPTID, GQMS, ZYID, AQID, SFTB, TBZT, GIS_STATUS, ORDERID)
values ('C8716A4E11E94D70B1DFC9A5482AAE88', '睢宁港区', '1201', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.34.00000000 上午', '16-11月-15 10.50.34.00000000 上午', 1, null, null, '90020', '659D99470458492C89F45D6C757AFEAD', null, '32110106', null, null, null, null, '9000000006', null, null, '9000000006', 'Y', 'N', null, 62);

prompt Done.



--作业区


--锚地表


--岸线

commit;