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 ('2A13C4A53FEC4159BBA7800370FD09A6', '90027', null, null, null, null, null, null, null, '16-11月-15 10.25.40.000000 上午', '16-11月-15 10.25.40.000000 上午', 1, null, null, '盐城内河港', '321111', null, null, null, null, null, null, null, null, null, null, null, null, '2A13C4A53FEC4159BBA7800370FD09A6', null, null, 'Y', 'Z', 20, '320900');

--港区
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 ('EFED6AC3E37244B9910DB02B32947D15', '盐城市区港区-盐都区', '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', '90027', '2A13C4A53FEC4159BBA7800370FD09A6', null, '32111113', null, null, null, null, null, null, 'EFED6AC3E37244B9910DB02B32947D15', '16100000010', '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 ('909A1A26EC634F76B41CEC45F30F5488', '射阳内河港区', '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, '90027', '2A13C4A53FEC4159BBA7800370FD09A6', null, '32111104', null, null, null, null, null, null, '909A1A26EC634F76B41CEC45F30F5488', '16100000006', 'N', 'Y', null, 666);

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 ('3D39E4B49D934B94AA31F44F9DD7CA39', '盐城市区港区-开发区', '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, 'aq', 'aq', '90027', '2A13C4A53FEC4159BBA7800370FD09A6', null, '32111110', null, null, null, null, null, null, '3D39E4B49D934B94AA31F44F9DD7CA39', '16100000021', '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 ('5A7C2E23248249BE955A68A3734563BF', '盐城市区港区-亭湖区', '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, 'aq', 'aq', '90027', '2A13C4A53FEC4159BBA7800370FD09A6', null, '32111111', null, null, null, null, null, null, '5A7C2E23248249BE955A68A3734563BF', '16100000002', '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 ('AC90F03F8AFE4E1E8D373BC03C926C8E', '盐城市区港区', '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, 'aq', 'aq', '90027', '2A13C4A53FEC4159BBA7800370FD09A6', null, '32111112', null, null, null, null, null, null, 'AC90F03F8AFE4E1E8D373BC03C926C8E', '16100000001', '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 ('5F85BD695AE14C48921CEE447A28D6EA', '响水内河港区', '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, '90027', '2A13C4A53FEC4159BBA7800370FD09A6', null, '32111101', null, null, null, null, null, null, '5F85BD695AE14C48921CEE447A28D6EA', '16100000003', 'N', 'Y', null, 67);

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 ('689EFE7E08284F39896876624262EE0F', '滨海内河港区', '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, '90027', '2A13C4A53FEC4159BBA7800370FD09A6', null, '32111102', null, null, null, null, null, null, '689EFE7E08284F39896876624262EE0F', '16100000004', 'N', 'Y', null, 68);

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 ('D55B681DFB054489B160E09FCF01F4F1', '建湖港区', '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, '90027', '2A13C4A53FEC4159BBA7800370FD09A6', null, '32111105', null, null, null, null, '16100000007', null, 'D55B681DFB054489B160E09FCF01F4F1', '16100000007', 'N', 'Y', null, 70);

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 ('821AAC5F1E134A1FACFE8A8062E932CC', '盐都港区', '1201', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.35.00000000 上午', '16-11月-15 10.50.35.00000000 上午', 1, null, null, '90027', '2A13C4A53FEC4159BBA7800370FD09A6', null, '32111107', null, null, null, null, null, null, '821AAC5F1E134A1FACFE8A8062E932CC', '17000000015', 'N', 'Y', null, 72);

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 ('A158ADEE0F4A4BC9B71F699ABE8BB86B', '大丰内河港区', '1201', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.35.00000000 上午', '16-11月-15 10.50.35.00000000 上午', 1, null, null, '90027', '2A13C4A53FEC4159BBA7800370FD09A6', null, '32111108', null, null, null, null, null, null, 'A158ADEE0F4A4BC9B71F699ABE8BB86B', '16100000009', 'N', 'Y', null, 73);

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 ('4EE456BE904B404ABDAAAC571727E1F7', '阜宁内河港区', '1206', 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, '90027', '2A13C4A53FEC4159BBA7800370FD09A6', null, '32111103', null, null, null, null, null, null, '4EE456BE904B404ABDAAAC571727E1F7', '16100000005', 'N', 'Y', null, 69);

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 ('6B1FAE6B0BF9445C8E7012EFA2E163E1', '亭湖港区', '1201', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.35.00000000 上午', '16-11月-15 10.50.35.00000000 上午', 1, null, null, '90027', '2A13C4A53FEC4159BBA7800370FD09A6', null, '32111106', null, null, null, null, null, null, '6B1FAE6B0BF9445C8E7012EFA2E163E1', '17000000017', 'N', 'Y', null, 71);

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 ('C5053708E1074B35BC09B559A7EE3FB0', '东台港区', '1201', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.35.00000000 上午', '16-11月-15 10.50.35.00000000 上午', 1, null, null, '90027', '2A13C4A53FEC4159BBA7800370FD09A6', null, '32111109', null, null, null, null, '16100000008', null, 'C5053708E1074B35BC09B559A7EE3FB0', '16100000008', 'N', 'Y', null, 74);

--作业区


--锚地表

--岸线
