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_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 ('0224947E09A044BCB4BF4611B00497EC', '90025', null, null, null, null, null, null, null, '16-11月-15 10.25.39.000000 上午', '16-11月-15 10.25.39.000000 上午', 1, null, null, '南通内河港', '321114', null, null, null, null, null, null, null, null, null, null, null, null, '0224947E09A044BCB4BF4611B00497EC', null, null, 'Y', 'Z', 16, '320600');

--港区
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 ('4458EF671C40426BA1BED2706BDD2F4D', '主城区港区', '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', '90025', '0224947E09A044BCB4BF4611B00497EC', null, '32111410', null, null, null, null, null, null, '4458EF671C40426BA1BED2706BDD2F4D', '14100000001', 'N', 'Y', 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 ('10A13CBA2E2745B5B6F4B467A5120EB8', '港闸港区', '1201', null, null, 1, null, 1, 1, 1, 1, 1, 1, 1, 1, 1, null, '16-11月-15 10.50.31.00000000 上午', '16-11月-15 10.50.31.00000000 上午', 1, null, null, '90025', '0224947E09A044BCB4BF4611B00497EC', null, '32111401', null, null, null, null, null, null, '10A13CBA2E2745B5B6F4B467A5120EB8', '17000000003', 'N', 'Y', null, 15);

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 ('D2C93312D16340FCBFC3F09ECDC48B1A', '崇川港区', '1201', null, null, 1, null, 1, 1, 1, 1, 1, 1, 1, 1, 1, null, '16-11月-15 10.50.31.00000000 上午', '16-11月-15 10.50.31.00000000 上午', 1, null, null, '90025', '0224947E09A044BCB4BF4611B00497EC', null, '32111402', null, null, null, null, null, null, 'D2C93312D16340FCBFC3F09ECDC48B1A', '17000000004', 'N', 'Y', null, 18);

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 ('77BCFF0266D3420DA0952816CE64C8CD', '通州港区', '1201', null, null, 1, null, 1, 1, 1, 1, 1, 1, 1, 1, 1, null, '16-11月-15 10.50.31.00000000 上午', '16-11月-15 10.50.31.00000000 上午', 1, null, null, '90025', '0224947E09A044BCB4BF4611B00497EC', null, '32111407', null, null, null, null, '14100000002', null, '77BCFF0266D3420DA0952816CE64C8CD', '14100000002', 'N', 'Y', null, 25);

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 ('C5FC966632FB4B3993F5CC8A85ABCC13', '海门港区', '1201', null, null, 1, null, 1, 1, 1, 1, 1, 1, 1, 1, 1, null, '16-11月-15 10.50.31.00000000 上午', '16-11月-15 10.50.31.00000000 上午', 1, null, null, '90025', '0224947E09A044BCB4BF4611B00497EC', null, '32111408', null, null, null, null, '14100000005', null, 'C5FC966632FB4B3993F5CC8A85ABCC13', '14100000005', 'N', 'Y', null, 26);

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 ('C5822DAD2E964A5C9E217A40548A963B', '开发区港区', '1201', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.31.00000000 上午', '16-11月-15 10.50.31.00000000 上午', 1, null, null, '90025', '0224947E09A044BCB4BF4611B00497EC', null, '32111403', null, null, null, null, null, null, 'C5822DAD2E964A5C9E217A40548A963B', '17000000020', 'N', 'Y', null, 19);

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 ('B3CDA2DE6E0E48FCB897CF580A328F1F', '如东港区', '1201', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.31.00000000 上午', '16-11月-15 10.50.31.00000000 上午', 1, null, null, '90025', '0224947E09A044BCB4BF4611B00497EC', null, '32111406', null, null, null, null, '14100000004', null, 'B3CDA2DE6E0E48FCB897CF580A328F1F', '14100000004', 'N', 'Y', null, 23);

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 ('DBECD8C7A19C458CB3E8A18A92FB431C', '启东港区', '1201', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.31.00000000 上午', '16-11月-15 10.50.31.00000000 上午', 1, null, null, '90025', '0224947E09A044BCB4BF4611B00497EC', null, '32111409', null, null, null, null, '14100000007', null, 'DBECD8C7A19C458CB3E8A18A92FB431C', '14100000007', 'N', 'Y', null, 27);

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 ('021B2CE6C247407AB7D0F35224E345EF', '如皋内河港区', '1201', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.31.00000000 上午', '16-11月-15 10.50.31.00000000 上午', 1, null, null, '90025', '0224947E09A044BCB4BF4611B00497EC', null, '32111405', null, null, null, null, null, null, '021B2CE6C247407AB7D0F35224E345EF', '14100000006', 'N', 'Y', null, 21);

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 ('6E036D235B2E4DD3B5E5DB61CB56FD1A', '海安港区', '1201', null, null, 1, null, 1, 1, 1, 1, 1, 1, 1, 1, 1, null, '16-11月-15 10.50.31.00000000 上午', '16-11月-15 10.50.31.00000000 上午', 1, null, null, '90025', '0224947E09A044BCB4BF4611B00497EC', null, '32111404', null, null, null, null, '14100000003', null, '6E036D235B2E4DD3B5E5DB61CB56FD1A', '14100000003', 'N', 'Y', null, 20);

--作业区
insert into GK_BASIC_JSJY_GK_ZYQ (ID, SZGK, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, UPDATE_USER, CREATE_USER, SZD, SSGKGLBM, SZGQ, ZYQMC, ZYQYT, BZ, ZYID, SFTB, TBZT, GIS_STATUS)
values ('4028b9a557aca40c0157ad54230a000e', '0224947E09A044BCB4BF4611B00497EC', '10-10月-16 02.42.34.890000 下午', '10-10月-16 02.42.34.890000 下午', 1, '4028b9a557aca40c0157ad35fa3e0000', '4028b9a557aca40c0157ad35fa3e0000', '90025', null, 'B3CDA2DE6E0E48FCB897CF580A328F1F', '如东作业区', null, null, '20161010144217', 'Y', 'N', null);


--锚地表

--岸线
