delete from GK_BASIC_JSJY_DWXX_XZGLBMXX;
delete from GK_BASIC_JSJY_DWXX_XZGLRYXX;
delete from GK_BASIC_JSJY_GK_GK;
delete from GK_BASIC_JSJY_GK_GQ;
delete from GK_BASIC_JSJY_GK_ZYQ;
delete from GK_BASIC_JSJY_GK_MD;
delete from GK_BASIC_JSJY_GK_AX;
--行政管理部门和人员
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)
values ('402881f05122619f01512274949b0009', '淮安市交通运输局', '401', null, null, null, null, null, null, '1', to_timestamp('20-11-2015 09:14:04.315000', 'dd-mm-yyyy hh24:mi:ss.ff'), '1', 1, to_timestamp('20-11-2015 09:14:04.315000', 'dd-mm-yyyy hh24:mi:ss.ff'), '90023', '00', 4);

--港口
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 ('C92E3C8D6AF845C6B41117A280C64CCF', '90023', null, null, null, null, null, null, null, '16-11月-15 10.25.39.000000 上午', '16-11月-15 10.25.39.000000 上午', 1, null, null, '淮安港', '321105', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'Y', 'N', 21, '320800');

--港区
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 ('FD44FB26B7064448A023CF51ED9B2F5F', '淮安港区', '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', '90023', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '32110508', null, null, null, null, null, null, null, '12000000004', '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 ('E4CAAFEFEBAC41AC98D0C1B55A35B41B', '淮阴港区', '1201', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.28.00000000 上午', '16-11月-15 10.50.28.00000000 上午', 1, null, null, '90023', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '32110502', null, null, null, null, '12000000002', null, null, '12000000002', 'Y', 'N', null, 101);

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 ('7857596F3DFC4EF38A51F3580BA076F0', '洪泽港区', '1201', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.28.00000000 上午', '16-11月-15 10.50.28.00000000 上午', 1, null, null, '90023', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '32110505', null, null, null, null, '12000000005', null, null, '12000000005', 'Y', 'N', null, 104);

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 ('02C1D35E1AEF4F76BD70BA136F9DA929', '市区港区', '1206', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.28.00000000 上午', '16-11月-15 10.50.28.00000000 上午', 1, null, null, '90023', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '32110501', null, null, null, null, '12000000003', null, null, '12000000003', 'Y', 'N', null, 100);

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 ('DD918147083446A8B889ECA6AF6FE325', '楚州港区', '1201', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.28.00000000 上午', '16-11月-15 10.50.28.00000000 上午', 1, null, null, '90023', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '32110503', null, null, null, null, null, null, null, null, 'Y', 'N', null, 102);

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 ('78BEF3ED8DAD42349BDC9AE22BB4ECAC', '涟水港区', '1201', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.28.00000000 上午', '16-11月-15 10.50.28.00000000 上午', 1, null, null, '90023', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '32110504', null, null, null, null, '12000000001', null, null, '12000000001', 'Y', 'N', null, 103);

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 ('BA9D8B8DFEA848D08FCF2C16143299E9', '盱眙港区', '1201', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.28.00000000 上午', '16-11月-15 10.50.28.00000000 上午', 1, null, null, '90023', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '32110506', null, null, null, null, '12000000006', null, null, '12000000006', 'Y', 'N', null, 105);

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 ('E1E64938EC634BA98BE547E90DE416EB', '金湖港区', '1201', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.28.00000000 上午', '16-11月-15 10.50.28.00000000 上午', 1, null, null, '90023', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '32110507', null, null, null, null, '12000000007', null, null, '12000000007', 'Y', 'N', null, 106);

--作业区

--锚地表

--岸线
