Startseite Erkunden Hilfe
Registrieren Anmelden
hs
/
jsgkj
2
0
Fork 0
Dateien Issues 0 Pull-Requests 0 Wiki
Struktur: b107be593b
Branches Tags
jsgkj
/
gkjsjy
/
trunk
/
WebContent
/
static
/
sql
/
oracle
/
yanchengneihe
/
gkjc
/
5.3.gkjcdata.sql

5.3.gkjcdata.sql 11 KB
Verlauf Originalformat

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960 
  1. delete from GK_BASIC_JSJY_DWXX_XZGLBMXX;
    2. 

  2. delete from GK_BASIC_JSJY_DWXX_XZGLRYXX;
    3. 

  3. delete from GK_BASIC_JSJY_GK_GK;
    4. 

  4. delete from GK_BASIC_JSJY_GK_GQ;
    5. 

  5. delete from GK_BASIC_JSJY_GK_ZYQ;
    6. 

  6. delete from GK_BASIC_JSJY_GK_MD;
    7. 

  7. delete from GK_BASIC_JSJY_GK_AX;
    8. 

  8. 

  9. --行政管理部门和人员
    10. 

  10. 

  11. --港口
    12. 

  12. 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)
    13. 

  13. 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');
    14. 

  14. 

  15. --港区
    16. 

  16. 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)
    17. 

  17. 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);
    18. 

  18. 

  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)
    20. 

  20. 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);
    21. 

  21. 

  22. 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)
    23. 

  23. 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);
    24. 

  24. 

  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)
    26. 

  26. 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);
    27. 

  27. 

  28. 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)
    29. 

  29. 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);
    30. 

  30. 

  31. 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)
    32. 

  32. 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);
    33. 

  33. 

  34. 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)
    35. 

  35. 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);
    36. 

  36. 

  37. 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)
    38. 

  38. 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);
    39. 

  39. 

  40. 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)
    41. 

  41. 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);
    42. 

  42. 

  43. 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)
    44. 

  44. 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);
    45. 

  45. 

  46. 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)
    47. 

  47. 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);
    48. 

  48. 

  49. 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)
    50. 

  50. 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);
    51. 

  51. 

  52. 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)
    53. 

  53. 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);
    54. 

  54. 

  55. --作业区
    56. 

  56. 

  57. 

  58. --锚地表
    59. 

  59. 

  60. --岸线
    61.