jsgkj/gkjsjy/trunk/WebContent/static/sql/oracle/other/zycode.sql

create table GK_BASIC_GKZY_SJZD
(
  bm      NVARCHAR2(20),
  bmmc    NVARCHAR2(20),
  lbbm    NVARCHAR2(20) not null,
  lbmc    NVARCHAR2(20),
  orderid NUMBER
)TABLESPACE "GK_BASIC"
;

delete from GK_BASIC_GKZY_SJZD;
commit;
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32000103', '赣榆港区', 'GQ', '港区', 1);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32000104', '徐圩港区', 'GQ', '港区', 3);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111201', '东海港区', 'GQ', '港区', 115);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111202', '灌云港区', 'GQ', '港区', 116);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100104', '上元门港区', 'GQ', '港区', 7);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100105', '新生圩港区', 'GQ', '港区', 9);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100110', '浦口港区', 'GQ', '港区', 5);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100102', '板桥港区', 'GQ', '港区', 3);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100103', '下关港区', 'GQ', '港区', 6);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100107', '龙潭港区', 'GQ', '港区', 12);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100111', '大厂港区', 'GQ', '港区', 8);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100108', '马渡港区', 'GQ', '港区', 14);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100112', '西坝港区', 'GQ', '港区', 10);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100109', '七坝港区', 'GQ', '港区', 2);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111501', '江宁港区', 'GQ', '港区', 131);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111502', '溧水港区', 'GQ', '港区', 131);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111503', '高淳港区', 'GQ', '港区', 132);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100119', '仪征港区', 'GQ', '港区', 13);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100399', '洲际岸线', 'Z', '洲际', 99);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('3', '生态保护岸线', 'AXGN', '岸线功能类型', 3);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('30', '长江干流', 'BWSZSX', '泊位所在水系', 2);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('6', '预留发展岸线', 'AXGN', '岸线功能类型', 7);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('90', '其它水系', 'BWSZSX', '泊位所在水系', 99);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('20', '淮河水系', 'BWSZSX', '泊位所在水系', 3);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values (null, null, 'Time_Interval', '时间周期', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('1050', '成品油泊位', 'BWYT', '泊位用途', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('1060', '液体化工泊位', 'BWYT', '泊位用途', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('1070', '液化天然气', 'BWYT', '泊位用途', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('1080', '液化石油气', 'BWYT', '泊位用途', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('1090', '散装粮食', 'BWYT', '泊位用途', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('1100', '散装水泥', 'BWYT', '泊位用途', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('1110', '客运泊位', 'BWYT', '泊位用途', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('1120', '滚装泊位', 'BWYT', '泊位用途', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('2000', '通用散货泊位', 'BWYT', '泊位用途', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('3000', '通用杂件货泊位', 'BWYT', '泊位用途', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('4000', '客货泊位', 'BWYT', '泊位用途', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('5000', '多用途泊位', 'BWYT', '泊位用途', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('6000', '其它泊位', 'BWYT', '泊位用途', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('11', '经营性生产泊位', 'BWSCLX', '泊位生产类型', 0);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('10', '生产用泊位', 'BWSCLX', '泊位生产类型', 0);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('2013', '2013年', 'CXTJNDLB', '查询统计年度列表', 3);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('00', '沿海', 'BWSZSX', '泊位所在水系', 1);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('40', '长江支流', 'BWSZSX', '泊位所在水系', 6);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('2014', '2014年', 'CXTJNDLB', '查询统计年度列表', 2);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('12', '板桩码头', 'JGLX', '码头结构类型', 0);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('10', '直立式码头', 'JGLX', '码头结构类型', 0);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('11', '重力式码头', 'JGLX', '码头结构类型', 0);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('13', '高桩码头', 'JGLX', '码头结构类型', 0);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('14', '其他码头', 'JGLX', '码头结构类型', 0);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('20', '斜坡码头', 'JGLX', '码头结构类型', 0);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('21', '皮带机斜坡码头', 'JGLX', '码头结构类型', 0);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100611', '启海港区', 'GQ', '港区', 11);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('320000', '全省', 'QS', '全省', 1);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('30', '浮码头', 'JGLX', '码头结构类型', 0);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('40', '单点（多点）系泊', 'JGLX', '码头结构类型', 0);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('50', '过驳装卸平台', 'JGLX', '码头结构类型', 0);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('60', '其它结构型式码头', 'JGLX', '码头结构类型', 0);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('12', '非经营性生产泊位', 'BWSCLX', '泊位生产类型', 0);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('20', '非生产用泊位', 'BWSCLX', '泊位生产类型', 0);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('AIS_Tree_Interval', '120000', 'Time_Interval', '时间周期', 2);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110803', '丹阳港区', 'GQ', '港区', 91);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('2', '洲际', 'AXNBA', '岸线南北岸', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('06', '液体化工', 'ZYHBWFL', '专业化泊位分类', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('250', '矿石码头', 'MTYTDM', '码头用途代码', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('320', '滚装码头', 'MTYTDM', '码头用途代码', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('1040', '原油泊位', 'BWYT', '泊位用途', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('320001', '连云港港', 'GK', '港口', 17);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('320002', '盐城港', 'GK', '港口', 19);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100502', '录安洲港区', 'GQ', '港区', 94);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110403', '武进港区', 'GQ', '港区', 98);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110503', '楚州港区', 'GQ', '港区', 102);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110507', '金湖港区', 'GQ', '港区', 106);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100704', '长山港区', 'GQ', '港区', 110);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32000105', '灌河港区', 'GQ', '港区', 4);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111203', '灌南港区', 'GQ', '港区', 117);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100101', '铜井港区', 'GQ', '港区', 1);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('321007', '江阴(无锡)港', 'GK', '港口', 11);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100609', '吕四港区', 'GQ', '港区', 10);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('320600', '南通市', 'XZQ', '行政区', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('321300', '宿迁市', 'XZQ', '行政区', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110321', '吴江港区', 'GQ', '港区', 345);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110603', '沭阳港区', 'GQ', '港区', 55);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111106', '亭湖港区', 'GQ', '港区', 71);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100306', '高桥港区', 'GQ', '港区', 6);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('0', '南岸', 'AXNBA', '岸线南北岸', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('2', '内河泊位', 'BWSX', '泊位属性', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('5', '多用途', 'BWZYYT', '泊位主要用途', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('04', '原油', 'ZYHBWFL', '专业化泊位分类', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('11', '客运', 'ZYHBWFL', '专业化泊位分类', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('230', '散粮码头', 'MTYTDM', '码头用途代码', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('310', '集装箱码头', 'MTYTDM', '码头用途代码', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('2', '集装箱', 'AXGHZYGNYT', '岸线规划主要功能用途', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('1030', '金属矿石泊位', 'BWYT', '泊位用途', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110502', '淮阴港区', 'GQ', '港区', 101);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100106', '栖霞港区', 'GQ', '港区', 11);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('321115', '南京内河港', 'GK', '港口', 2);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('321108', '镇江内河港', 'GK', '港口', 4);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('321107', '扬州内河港', 'GK', '港口', 6);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('321113', '泰州内河港', 'GK', '港口', 8);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('321104', '常州内河港', 'GK', '港口', 10);
commit;
prompt 100 records committed...
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('321102', '无锡港', 'GK', '港口', 12);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('321103', '苏州内河港', 'GK', '港口', 14);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('321114', '南通内河港', 'GK', '港口', 16);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('321112', '连云港内河港', 'GK', '港口', 18);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('321111', '盐城内河港', 'GK', '港口', 20);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('321105', '淮安港', 'GK', '港口', 21);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('321106', '宿迁港', 'GK', '港口', 22);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('321101', '徐州港', 'GK', '港口', 23);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('AIS_R_Interval', '60000', 'Time_Interval', '时间周期', 1);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100199', '洲际岸线', 'Z', '洲际', 99);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111504', '浦口港区', 'GQ', '港区', 5);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111505', '六合港区', 'GQ', '港区', 3);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111506', '雨花台港区', 'GQ', '港区', 4);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100603', '南通港区', 'GQ', '港区', 3);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100601', '如皋港区', 'GQ', '港区', 1);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100602', '天生港区', 'GQ', '港区', 2);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100604', '任港港区', 'GQ', '港区', 4);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100605', '狼山港区', 'GQ', '港区', 5);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100606', '富民港区', 'GQ', '港区', 6);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100610', '洋口港区', 'GQ', '港区', 9);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100608', '通海港区', 'GQ', '港区', 8);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100607', '江海港区', 'GQ', '港区', 7);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111401', '港闸港区', 'GQ', '港区', 15);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100113', '梅子洲港区', 'GQ', '港区', 4);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100201', '仪征港区', 'GQ', '港区', 17);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111402', '崇川港区', 'GQ', '港区', 18);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111403', '开发区港区', 'GQ', '港区', 19);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100304', '新民洲港区', 'GQ', '港区', 3);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111404', '海安港区', 'GQ', '港区', 20);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('320800', '淮安市', 'XZQ', '行政区', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111405', '如皋内河港区', 'GQ', '港区', 21);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('321100', '镇江市', 'XZQ', '行政区', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111406', '如东港区', 'GQ', '港区', 23);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111407', '通州港区', 'GQ', '港区', 25);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('320400', '常州市', 'XZQ', '行政区', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('321000', '扬州市', 'XZQ', '行政区', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('321200', '泰州市', 'XZQ', '行政区', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('320700', '连云港市', 'XZQ', '行政区', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111408', '海门港区', 'GQ', '港区', 26);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('320300', '徐州市', 'XZQ', '行政区', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111409', '启东港区', 'GQ', '港区', 27);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('320100', '南京市', 'XZQ', '行政区', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100901', '张家港港区', 'GQ', '港区', 28);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100902', '常熟港区', 'GQ', '港区', 29);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100903', '太仓港区', 'GQ', '港区', 30);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110310', '张家港内河港区', 'GQ', '港区', 31);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110311', '常熟内河港区', 'GQ', '港区', 33);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110312', '太仓内河港区', 'GQ', '港区', 255);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110313', '昆山港区', 'GQ', '港区', 32);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110314', '相城港区', 'GQ', '港区', 35);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110315', '高新港区', 'GQ', '港区', 34);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110316', '工业园区港区', 'GQ', '港区', 36);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110317', '沧浪港区', 'GQ', '港区', 37);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110318', '平江港区', 'GQ', '港区', 38);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110319', '金阊港区', 'GQ', '港区', 39);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100402', '泰兴港区', 'GQ', '港区', 2);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100403', '靖江港区', 'GQ', '港区', 3);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100401', '高港港区', 'GQ', '港区', 1);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111306', '兴化港区', 'GQ', '港区', 43);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111304', '姜堰港区', 'GQ', '港区', 44);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111303', '泰兴内河港区', 'GQ', '港区', 45);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111302', '海陵港区', 'GQ', '港区', 46);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111305', '靖江内河港区', 'GQ', '港区', 47);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111301', '高港内河港区', 'GQ', '港区', 48);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110202', '锡山港区', 'GQ', '港区', 49);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110203', '惠山港区', 'GQ', '港区', 58);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110204', '江阴港区', 'GQ', '港区', 50);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110205', '宜兴港区', 'GQ', '港区', 51);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110201', '城郊港区', 'GQ', '港区', 52);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110601', '中心港区', 'GQ', '港区', 53);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110602', '泗阳港区', 'GQ', '港区', 54);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110604', '泗洪港区', 'GQ', '港区', 56);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110101', '沛县港区', 'GQ', '港区', 57);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110102', '徐州港区', 'GQ', '港区', 58);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110103', '邳州港区', 'GQ', '港区', 59);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110104', '新沂港区', 'GQ', '港区', 60);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110105', '丰县港区', 'GQ', '港区', 61);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110106', '睢宁港区', 'GQ', '港区', 62);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32000201', '响水港区', 'GQ', '港区', 63);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32000202', '滨海港区', 'GQ', '港区', 64);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32000203', '射阳港区', 'GQ', '港区', 65);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32000204', '大丰港区', 'GQ', '港区', 66);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111101', '响水内河港区', 'GQ', '港区', 67);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111102', '滨海内河港区', 'GQ', '港区', 68);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111103', '阜宁内河港区', 'GQ', '港区', 69);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111104', '射阳内河港区', 'GQ', '港区', 666);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111105', '建湖港区', 'GQ', '港区', 70);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111107', '盐都港区', 'GQ', '港区', 72);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111108', '大丰内河港区', 'GQ', '港区', 73);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32111109', '东台港区', 'GQ', '港区', 74);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100202', '扬州港区', 'GQ', '港区', 75);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100203', '江都港区', 'GQ', '港区', 76);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110701', '仪征内河港区', 'GQ', '港区', 77);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110702', '扬城港区', 'GQ', '港区', 78);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110703', '邗江港区', 'GQ', '港区', 79);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110704', '江都内河港区', 'GQ', '港区', 80);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110705', '高邮港区', 'GQ', '港区', 81);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110706', '宝应港区', 'GQ', '港区', 82);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100302', '龙门港区', 'GQ', '港区', 2);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100301', '高资港区', 'GQ', '港区', 1);
commit;
prompt 200 records committed...
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100303', '谏壁港区', 'GQ', '港区', 4);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100305', '大港港区', 'GQ', '港区', 5);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100307', '扬中港区', 'GQ', '港区', 7);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110801', '京口港区', 'GQ', '港区', 89);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110802', '丹徒港区', 'GQ', '港区', 90);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110804', '句容港区', 'GQ', '港区', 92);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('3210', '长江', 'SX', '水系', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('3200', '沿海', 'SX', '水系', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('3211', '京杭运河及其他内河', 'SX', '水系', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('2', '岸线', 'ZYLX', '资源类型', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('4', '码头', 'ZYLX', '资源类型', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('5', '泊位', 'ZYLX', '资源类型', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('8', '其它岸线', 'AXGN', '岸线功能类型', 7);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('1', '北岸', 'AXNBA', '岸线南北岸', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('1', '公用', 'BWFWLX', '泊位服务类型', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('2', '非公用', 'BWFWLX', '泊位服务类型', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('1', '海轮泊位', 'BWSX', '泊位属性', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('1', '专业化', 'BWZYYT', '泊位主要用途', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('2', '通用散货', 'BWZYYT', '泊位主要用途', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('4', '客货', 'BWZYYT', '泊位主要用途', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('01', '集装箱', 'ZYHBWFL', '专业化泊位分类', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('02', '煤炭', 'ZYHBWFL', '专业化泊位分类', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('03', '金属矿石', 'ZYHBWFL', '专业化泊位分类', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('05', '成品油', 'ZYHBWFL', '专业化泊位分类', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('07', '液化天然气', 'ZYHBWFL', '专业化泊位分类', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('08', '液化石油气', 'ZYHBWFL', '专业化泊位分类', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('09', '散装粮食', 'ZYHBWFL', '专业化泊位分类', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('12', '滚装', 'ZYHBWFL', '专业化泊位分类', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('100', '旅客运输码头', 'MTYTDM', '码头用途代码', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('200', '货物运输码头', 'MTYTDM', '码头用途代码', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('210', '杂货码头', 'MTYTDM', '码头用途代码', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('220', '散货码头', 'MTYTDM', '码头用途代码', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('240', '煤炭码头', 'MTYTDM', '码头用途代码', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('260', '石油码头', 'MTYTDM', '码头用途代码', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('270', '木材码头', 'MTYTDM', '码头用途代码', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('280', '危险品码头', 'MTYTDM', '码头用途代码', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('300', '多用途码头', 'MTYTDM', '码头用途代码', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('320900', '盐城市', 'XZQ', '行政区', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('320200', '无锡市', 'XZQ', '行政区', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('900', '其他', 'MTYTDM', '码头用途代码', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('0', '煤炭', 'AXGHZYGNYT', '岸线规划主要功能用途', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('1', '石油', 'AXGHZYGNYT', '岸线规划主要功能用途', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('0', '港口岸线', 'AXGN', '岸线功能类型', 1);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('1', '水源保护岸线', 'AXGN', '岸线功能类型', 2);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('2', '生活旅游岸线', 'AXGN', '岸线功能类型', 3);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('4', '过江通道岸线', 'AXGN', '岸线功能类型', 4);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('5', '修造船厂岸线', 'AXGN', '岸线功能类型', 5);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('7', '临港工业岸线', 'AXGN', '岸线功能类型', 6);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('1000', '专业化泊位', 'BWYT', '泊位用途', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('1010', '集装箱泊位', 'BWYT', '泊位用途', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('1020', '煤炭泊位', 'BWYT', '泊位用途', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('320500', '苏州市', 'XZQ', '行政区', null);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('321005', '常州港', 'GK', '港口', 9);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('321001', '南京港', 'GK', '港口', 1);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('321006', '南通港', 'GK', '港口', 15);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('321009', '苏州港', 'GK', '港口', 13);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('321004', '泰州港', 'GK', '港口', 7);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('321002', '扬州港', 'GK', '港口', 5);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('321003', '镇江港', 'GK', '港口', 3);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100501', '夹江港区', 'GQ', '港区', 93);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100503', '圩塘港区', 'GQ', '港区', 95);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110401', '市区港区', 'GQ', '港区', 96);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110402', '金坛港区', 'GQ', '港区', 97);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110404', '溧阳港区', 'GQ', '港区', 99);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110501', '市区港区', 'GQ', '港区', 100);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110504', '涟水港区', 'GQ', '港区', 103);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110505', '洪泽港区', 'GQ', '港区', 104);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32110506', '盱眙港区', 'GQ', '港区', 105);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100701', '石利港区', 'GQ', '港区', 107);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100702', '申夏港区', 'GQ', '港区', 108);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32100703', '黄田港区', 'GQ', '港区', 109);
insert into GK_BASIC_GKZY_SJZD (bm, bmmc, lbbm, lbmc, orderid)
values ('32000101', '连云港区', 'GQ', '港区', 2);
commit;