fj-dc/insert_project_insurance.sql

-- ============================================================
-- 福建省水利工程安责险数据 - 40条工程及投保记录
-- 其中：35条 YEAR=2026，5条 YEAR=2025
-- ID格式：PJ/RC + 30位零填充序号 = 精确32字符
-- 生成时间：2026-06-18
-- ============================================================

-- 1. 福州市城乡供水一体化工程 (福州 350100) - 2025年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000001','福州市城乡供水一体化工程','供水工程','福州市','85000','36个月',TO_DATE('2024-03-15','YYYY-MM-DD'),'在建','福州市水利局','福建省水利水电工程局有限公司','张建国',119.29650000,26.07450000,119.30320000,26.08120000,SYSDATE,SYSDATE,'0','1','350100','福州市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000001','PJ000000000000000000000000000001','福建省水利水电工程局有限公司','13805910001','中国人民财产保险股份有限公司福建省分公司','李明辉','13859000001','85.5','17.1',TO_DATE('2025-04-01','YYYY-MM-DD'),'福建省雄伟安全技术咨询有限责任公司','王志强','13850700001',SYSDATE,SYSDATE,'0','1','2025');

-- 2. 福州江北城区山洪防洪及生态补水工程 (福州 350100) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000002','福州江北城区山洪防洪及生态补水工程','防洪工程','福州市鼓楼区','120000','48个月',TO_DATE('2024-06-20','YYYY-MM-DD'),'在建','福州市水利局','中国水利水电第十六工程局有限公司','陈文斌',119.30350000,26.09820000,119.31020000,26.10490000,SYSDATE,SYSDATE,'0','1','350100','福州市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000002','PJ000000000000000000000000000002','中国水利水电第十六工程局有限公司','13805910002','中国平安财产保险股份有限公司福建分公司','黄志伟','13859000002','126.0','25.2',TO_DATE('2026-01-15','YYYY-MM-DD'),'福建省安全生产科学研究院','吴剑锐','13850700002',SYSDATE,SYSDATE,'0','0','2026');

-- 3. 闽江干流防洪提升工程（福州段） (福州 350100) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000003','闽江干流防洪提升工程（福州段）','防洪工程','福州市闽侯县','68000','36个月',TO_DATE('2025-02-10','YYYY-MM-DD'),'在建','福州市闽江下游防洪工程建设有限公司','福建省水利水电建设有限公司','林志强',119.15680000,26.05210000,119.16350000,26.05880000,SYSDATE,SYSDATE,'0','1','350100','福州市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000003','PJ000000000000000000000000000003','福建省水利水电建设有限公司','13805910003','中国太平洋财产保险股份有限公司福建分公司','郑国栋','13859000003','70.5','14.1',TO_DATE('2026-02-20','YYYY-MM-DD'),'福建中检康泰检测技术有限公司','缪继荣','13850700003',SYSDATE,SYSDATE,'0','1','2026');

-- 4. 福清市龙江中下游综合治理项目 (福州 350100) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000004','福清市龙江中下游综合治理项目','综合治理工程','福州市福清市','95000','42个月',TO_DATE('2024-09-01','YYYY-MM-DD'),'在建','福清市水利局','福建省中禹水利水电工程有限公司','王建平',119.38380000,25.72310000,119.39050000,25.72980000,SYSDATE,SYSDATE,'0','1','350100','福州市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000004','PJ000000000000000000000000000004','福建省中禹水利水电工程有限公司','13805910004','中国人寿财产保险股份有限公司福建省分公司','刘志明','13859000004','98.2','19.6',TO_DATE('2026-03-10','YYYY-MM-DD'),'中检集团康泰安全科技有限公司','陈建国','13850700004',SYSDATE,SYSDATE,'0','0','2026');

-- 5. 福州新区水库及水利连通建设工程 (福州 350100) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000005','福州新区水库及水利连通建设工程','水库工程','福州市长乐区','156000','60个月',TO_DATE('2025-05-18','YYYY-MM-DD'),'在建','福州新区开发投资集团有限公司','中国水利水电第八工程局有限公司','赵永强',119.52320000,25.96280000,119.52990000,25.96950000,SYSDATE,SYSDATE,'0','1','350100','福州市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000005','PJ000000000000000000000000000005','中国水利水电第八工程局有限公司','13805910005','海峡金桥财产保险股份有限公司','陈志强','13859000005','162.5','32.5',TO_DATE('2026-01-22','YYYY-MM-DD'),'福建省安科安全工程师事务所有限公司','苏志彬','13850700005',SYSDATE,SYSDATE,'0','1','2026');

-- 6. 厦门市马銮湾新城雨洪生态补水工程 (厦门 350200) - 2025年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000006','厦门市马銮湾新城雨洪生态补水工程','引水工程','厦门市海沧区','42000','30个月',TO_DATE('2024-08-12','YYYY-MM-DD'),'在建','厦门市水利局','厦门安能建设有限公司','周文华',118.03120000,24.55080000,118.03790000,24.55750000,SYSDATE,SYSDATE,'0','1','350200','厦门市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000006','PJ000000000000000000000000000006','厦门安能建设有限公司','13805920006','中国人民财产保险股份有限公司厦门市分公司','张伟强','13859200006','44.8','8.9',TO_DATE('2025-05-20','YYYY-MM-DD'),'福建省安工检测评价有限公司','许志宏','13859210006',SYSDATE,SYSDATE,'0','1','2025');

-- 7. 厦门市浦声水闸工程 (厦门 350200) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000007','厦门市浦声水闸工程','水闸工程','厦门市同安区','18000','24个月',TO_DATE('2025-04-05','YYYY-MM-DD'),'在建','厦门市同安区水利局','福建省汀江水电工程有限公司','吴志伟',118.15230000,24.72250000,118.15900000,24.72920000,SYSDATE,SYSDATE,'0','1','350200','厦门市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000007','PJ000000000000000000000000000007','福建省汀江水电工程有限公司','13805920007','中国平安财产保险股份有限公司厦门分公司','林志远','13859200007','18.5','3.7',TO_DATE('2026-03-05','YYYY-MM-DD'),'厦门市九安安全检测评价事务所有限公司','苏自勇','13859210007',SYSDATE,SYSDATE,'0','0','2026');

-- 8. 厦门市同安区石浔水闸改建工程 (厦门 350200) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000008','厦门市同安区石浔水闸改建工程','水闸工程','厦门市同安区','15000','18个月',TO_DATE('2025-08-20','YYYY-MM-DD'),'在建','厦门市同安区水利局','厦门市珉发建筑工程有限公司','郑志明',118.16850000,24.73890000,118.17520000,24.74560000,SYSDATE,SYSDATE,'0','1','350200','厦门市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000008','PJ000000000000000000000000000008','厦门市珉发建筑工程有限公司','13805920008','中国太平洋财产保险股份有限公司厦门分公司','陈建华','13859200008','15.2','3.0',TO_DATE('2026-02-18','YYYY-MM-DD'),'福建省环安检测评价有限公司','陈勇宾','13859210008',SYSDATE,SYSDATE,'0','1','2026');

-- 9. 厦门市杏林湾排涝泵站工程 (厦门 350200) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000009','厦门市杏林湾排涝泵站工程','排涝工程','厦门市集美区','22000','24个月',TO_DATE('2025-07-15','YYYY-MM-DD'),'在建','厦门市集美区水利局','福建省水利水电工程局有限公司','许文龙',118.05860000,24.57340000,118.06530000,24.58010000,SYSDATE,SYSDATE,'0','1','350200','厦门市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000009','PJ000000000000000000000000000009','福建省水利水电工程局有限公司','13805920009','阳光财产保险股份有限公司福建分公司','黄志刚','13859200009','22.8','4.5',TO_DATE('2026-04-12','YYYY-MM-DD'),'福建汇顺检测集团有限公司','何雄','13859210009',SYSDATE,SYSDATE,'0','0','2026');

-- 10. 莆田西音水库工程 (莆田 350300) - 2025年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000010','莆田西音水库工程','水库工程','莆田市涵江区','35000','30个月',TO_DATE('2024-11-08','YYYY-MM-DD'),'在建','莆田市水利局','福建省莆田市水电工程处','蔡志忠',119.08630000,25.47850000,119.09300000,25.48520000,SYSDATE,SYSDATE,'0','1','350300','莆田市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000010','PJ000000000000000000000000000010','福建省莆田市水电工程处','13805940010','中国人民财产保险股份有限公司福建省分公司','刘建国','13859400010','36.5','7.3',TO_DATE('2025-06-15','YYYY-MM-DD'),'福建省雄伟安全技术咨询有限责任公司','王志强','13859410010',SYSDATE,SYSDATE,'0','1','2025');

-- 11. 莆田市城区排涝（张镇）泵站工程 (莆田 350300) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000011','莆田市城区排涝（张镇）泵站工程','排涝工程','莆田市荔城区','28000','24个月',TO_DATE('2025-03-22','YYYY-MM-DD'),'在建','莆田市水利局','福建省华舜水利水电工程有限公司','陈国华',119.02850000,25.43560000,119.03520000,25.44230000,SYSDATE,SYSDATE,'0','1','350300','莆田市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000011','PJ000000000000000000000000000011','福建省华舜水利水电工程有限公司','13805940011','中国平安财产保险股份有限公司福建分公司','王建明','13859400011','29.0','5.8',TO_DATE('2026-01-08','YYYY-MM-DD'),'福建省安全生产科学研究院','吴剑锐','13859410011',SYSDATE,SYSDATE,'0','0','2026');

-- 12. 城厢区木兰溪流域排涝泵站建设 (莆田 350300) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000012','城厢区木兰溪流域排涝泵站建设','排涝工程','莆田市城厢区','32000','30个月',TO_DATE('2025-06-10','YYYY-MM-DD'),'在建','莆田市城厢区水利局','福建省恒鼎建筑工程有限公司','李志伟',118.99680000,25.41670000,119.00350000,25.42340000,SYSDATE,SYSDATE,'0','1','350300','莆田市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000012','PJ000000000000000000000000000012','福建省恒鼎建筑工程有限公司','13805940012','中华联合财产保险股份有限公司福建分公司','黄国栋','13859400012','33.0','6.6',TO_DATE('2026-03-25','YYYY-MM-DD'),'福建拓普检测技术有限公司','陈金爱','13859410012',SYSDATE,SYSDATE,'0','1','2026');

-- 13. 莆田市木兰溪防洪工程 (莆田 350300) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000013','莆田市木兰溪防洪工程','防洪工程','莆田市城厢区','55000','36个月',TO_DATE('2024-12-05','YYYY-MM-DD'),'在建','莆田市木兰溪防洪工程建设管理处','中国水利水电第十二工程局有限公司','吴志华',119.01250000,25.42890000,119.01920000,25.43560000,SYSDATE,SYSDATE,'0','1','350300','莆田市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000013','PJ000000000000000000000000000013','中国水利水电第十二工程局有限公司','13805940013','海峡金桥财产保险股份有限公司','郑志强','13859400013','56.8','11.3',TO_DATE('2026-01-30','YYYY-MM-DD'),'福建共益安全环保科技有限公司','林志宏','13859410013',SYSDATE,SYSDATE,'0','0','2026');

-- 14. 三明市城乡供水一体化建设项目 (三明 350400) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000014','三明市城乡供水一体化建设项目','供水工程','三明市三元区','72000','36个月',TO_DATE('2025-01-18','YYYY-MM-DD'),'在建','三明市水利局','福建省水利投资开发集团有限公司','张明辉',117.63920000,26.26380000,117.64590000,26.27050000,SYSDATE,SYSDATE,'0','1','350400','三明市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000014','PJ000000000000000000000000000014','福建省水利投资开发集团有限公司','13805980014','中国人民财产保险股份有限公司福建省分公司','陈文彬','13859800014','74.5','14.9',TO_DATE('2026-02-12','YYYY-MM-DD'),'福建省雄伟安全技术咨询有限责任公司','王志强','13859810014',SYSDATE,SYSDATE,'0','1','2026');

-- 15. 大田县下岩水库工程项目 (三明 350400) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000015','大田县下岩水库工程项目','水库工程','三明市大田县','26000','30个月',TO_DATE('2025-04-20','YYYY-MM-DD'),'在建','大田县水利局','福建省泰成建设工程有限公司','林志刚',117.84750000,25.69030000,117.85420000,25.69700000,SYSDATE,SYSDATE,'0','1','350400','三明市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000015','PJ000000000000000000000000000015','福建省泰成建设工程有限公司','13805980015','中国平安财产保险股份有限公司福建分公司','许志强','13859800015','27.0','5.4',TO_DATE('2026-04-08','YYYY-MM-DD'),'福建省安全生产科学研究院','黄海滨','13859810015',SYSDATE,SYSDATE,'0','0','2026');

-- 16. 沙县马岩水库工程 (三明 350400) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000016','沙县马岩水库工程','水库工程','三明市沙县区','38000','36个月',TO_DATE('2025-03-12','YYYY-MM-DD'),'在建','沙县区水利局','福建省明兴工程建设有限公司','郑志华',117.79230000,26.39780000,117.79900000,26.40450000,SYSDATE,SYSDATE,'0','1','350400','三明市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000016','PJ000000000000000000000000000016','福建省明兴工程建设有限公司','13805980016','中国太平洋财产保险股份有限公司福建分公司','王建平','13859800016','39.5','7.9',TO_DATE('2026-03-18','YYYY-MM-DD'),'中检集团康泰安全科技有限公司','陈建国','13859810016',SYSDATE,SYSDATE,'0','1','2026');

-- 17. 闽江防洪工程三明段（二期）建宁段 (三明 350400) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000017','闽江防洪工程三明段（二期）建宁段','防洪工程','三明市建宁县','45000','36个月',TO_DATE('2025-05-28','YYYY-MM-DD'),'在建','建宁县水利局','福建省水利水电建设有限公司','陈志明',116.84920000,26.83350000,116.85590000,26.84020000,SYSDATE,SYSDATE,'0','1','350400','三明市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000017','PJ000000000000000000000000000017','福建省水利水电建设有限公司','13805980017','中国人寿财产保险股份有限公司福建省分公司','刘建华','13859800017','46.8','9.3',TO_DATE('2026-02-28','YYYY-MM-DD'),'福建中科职业健康评价有限公司','林建清','13859810017',SYSDATE,SYSDATE,'0','0','2026');

-- 18. 泉州白濑水利枢纽工程 (泉州 350500) - 2025年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000018','泉州白濑水利枢纽工程','水库工程','泉州市安溪县','138000','60个月',TO_DATE('2024-02-20','YYYY-MM-DD'),'在建','泉州市白濑水利枢纽工程开发有限公司','中国水利水电第五工程局有限公司','黄志伟',118.18650000,25.05890000,118.19320000,25.06560000,SYSDATE,SYSDATE,'0','1','350500','泉州市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000018','PJ000000000000000000000000000018','中国水利水电第五工程局有限公司','13805950018','中国人民财产保险股份有限公司泉州市分公司','张建华','13859500018','142.5','28.5',TO_DATE('2025-03-15','YYYY-MM-DD'),'福建省雄伟安全技术咨询有限责任公司','王志强','13859510018',SYSDATE,SYSDATE,'0','1','2025');

-- 19. 泉州市金门供水水源保障工程 (泉州 350500) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000019','泉州市金门供水水源保障工程','供水工程','泉州市晋江市','52000','36个月',TO_DATE('2025-01-10','YYYY-MM-DD'),'在建','泉州市水利局','福建省水利水电工程局有限公司','王志明',118.58950000,24.81480000,118.59620000,24.82150000,SYSDATE,SYSDATE,'0','1','350500','泉州市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000019','PJ000000000000000000000000000019','福建省水利水电工程局有限公司','13805950019','中国平安财产保险股份有限公司福建分公司','郑志刚','13859500019','54.0','10.8',TO_DATE('2026-01-05','YYYY-MM-DD'),'福建省安科安全工程师事务所有限公司','苏志彬','13859510019',SYSDATE,SYSDATE,'0','1','2026');

-- 20. 南安市城乡供水一体化项目 (泉州 350500) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000020','南安市城乡供水一体化项目','供水工程','泉州市南安市','48000','36个月',TO_DATE('2025-03-08','YYYY-MM-DD'),'在建','南安市水利局','福建省南安市第一建设有限公司','李建平',118.38650000,24.96080000,118.39320000,24.96750000,SYSDATE,SYSDATE,'0','1','350500','泉州市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000020','PJ000000000000000000000000000020','福建省南安市第一建设有限公司','13805950020','中华联合财产保险股份有限公司福建分公司','陈志伟','13859500020','49.8','9.9',TO_DATE('2026-04-15','YYYY-MM-DD'),'福建拓普检测技术有限公司','陈金爱','13859510020',SYSDATE,SYSDATE,'0','0','2026');

-- 21. 晋江防洪提升工程安溪段一期 (泉州 350500) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000021','晋江防洪提升工程安溪段一期','防洪工程','泉州市安溪县','56000','36个月',TO_DATE('2025-04-15','YYYY-MM-DD'),'在建','安溪县水利局','福建省安溪县水利水电工程有限公司','许志强',118.18750000,25.05780000,118.19420000,25.06450000,SYSDATE,SYSDATE,'0','1','350500','泉州市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000021','PJ000000000000000000000000000021','福建省安溪县水利水电工程有限公司','13805950021','中国太平洋财产保险股份有限公司福建分公司','黄建华','13859500021','58.0','11.6',TO_DATE('2026-05-10','YYYY-MM-DD'),'福建省环安检测评价有限公司','陈勇宾','13859510021',SYSDATE,SYSDATE,'0','1','2026');

-- 22. 泉州市北高干渠功能调整输水工程 (泉州 350500) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000022','泉州市北高干渠功能调整输水工程','引水工程','泉州市洛江区','36000','30个月',TO_DATE('2025-06-25','YYYY-MM-DD'),'在建','泉州市北高干渠功能调整输水工程建设处','福建省水利水电工程局有限公司','张建平',118.67120000,24.94180000,118.67790000,24.94850000,SYSDATE,SYSDATE,'0','1','350500','泉州市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000022','PJ000000000000000000000000000022','福建省水利水电工程局有限公司','13805950022','海峡金桥财产保险股份有限公司','林志伟','13859500022','37.5','7.5',TO_DATE('2026-02-08','YYYY-MM-DD'),'福建共益安全环保科技有限公司','林志宏','13859510022',SYSDATE,SYSDATE,'0','0','2026');

-- 23. 漳州市东南部沿海地区九龙江调水工程 (漳州 350600) - 2025年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000023','漳州市东南部沿海地区九龙江调水工程','调水工程','漳州市龙海区','108000','48个月',TO_DATE('2024-04-28','YYYY-MM-DD'),'在建','漳州市水利局','中国水利水电第十四工程局有限公司','陈志远',117.84750000,24.35280000,117.85420000,24.35950000,SYSDATE,SYSDATE,'0','1','350600','漳州市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000023','PJ000000000000000000000000000023','中国水利水电第十四工程局有限公司','13805960023','中国人民财产保险股份有限公司漳州市分公司','王志华','13859600023','112.0','22.4',TO_DATE('2025-04-20','YYYY-MM-DD'),'福建省雄伟安全技术咨询有限责任公司','王志强','13859610023',SYSDATE,SYSDATE,'0','1','2025');

-- 24. 漳浦县朝阳水库工程 (漳州 350600) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000024','漳浦县朝阳水库工程','水库工程','漳州市漳浦县','42000','36个月',TO_DATE('2025-02-18','YYYY-MM-DD'),'在建','漳浦县水利局','福建省漳州市水利水电工程有限公司','林建平',117.61380000,24.11720000,117.62050000,24.12390000,SYSDATE,SYSDATE,'0','1','350600','漳州市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000024','PJ000000000000000000000000000024','福建省漳州市水利水电工程有限公司','13805960024','中国平安财产保险股份有限公司福建分公司','黄伟明','13859600024','43.5','8.7',TO_DATE('2026-03-20','YYYY-MM-DD'),'福建省安全生产科学研究院','吴剑锐','13859610024',SYSDATE,SYSDATE,'0','1','2026');

-- 25. 平和县官峰水库工程 (漳州 350600) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000025','平和县官峰水库工程','水库工程','漳州市平和县','31000','30个月',TO_DATE('2025-05-12','YYYY-MM-DD'),'在建','平和县水利局','福建省平和县水利水电工程有限公司','郑志强',117.31480000,24.36580000,117.32150000,24.37250000,SYSDATE,SYSDATE,'0','1','350600','漳州市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000025','PJ000000000000000000000000000025','福建省平和县水利水电工程有限公司','13805960025','中国太平洋财产保险股份有限公司福建分公司','许志伟','13859600025','32.0','6.4',TO_DATE('2026-04-22','YYYY-MM-DD'),'福建中检康泰检测技术有限公司','缪继荣','13859610025',SYSDATE,SYSDATE,'0','0','2026');

-- 26. 长泰区湖珠水库工程 (漳州 350600) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000026','长泰区湖珠水库工程','水库工程','漳州市长泰区','28000','30个月',TO_DATE('2025-08-05','YYYY-MM-DD'),'在建','长泰区水利局','福建省长泰县水利水电工程有限公司','王志刚',117.75980000,24.62680000,117.76650000,24.63350000,SYSDATE,SYSDATE,'0','1','350600','漳州市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000026','PJ000000000000000000000000000026','福建省长泰县水利水电工程有限公司','13805960026','中国人寿财产保险股份有限公司福建省分公司','陈建华','13859600026','29.0','5.8',TO_DATE('2026-05-18','YYYY-MM-DD'),'福建汇顺检测集团有限公司','何雄','13859610026',SYSDATE,SYSDATE,'0','1','2026');

-- 27. 九龙江防洪工程芗城段（一期） (漳州 350600) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000027','九龙江防洪工程芗城段（一期）','防洪工程','漳州市芗城区','48000','36个月',TO_DATE('2025-04-02','YYYY-MM-DD'),'在建','漳州市芗城区水利局','福建省华舜水利水电工程有限公司','李志华',117.65380000,24.51080000,117.66050000,24.51750000,SYSDATE,SYSDATE,'0','1','350600','漳州市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000027','PJ000000000000000000000000000027','福建省华舜水利水电工程有限公司','13805960027','阳光财产保险股份有限公司福建分公司','张伟强','13859600027','49.5','9.9',TO_DATE('2026-02-16','YYYY-MM-DD'),'中检集团康泰安全科技有限公司','陈建国','13859610027',SYSDATE,SYSDATE,'0','0','2026');

-- 28. 武夷山市城乡供水一体化建设项目 (南平 350700) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000028','武夷山市城乡供水一体化建设项目','供水工程','南平市武夷山市','55000','36个月',TO_DATE('2024-07-15','YYYY-MM-DD'),'在建','武夷山市水利局','福建省武夷山市水利水电工程有限公司','陈建华',118.03580000,27.75650000,118.04250000,27.76320000,SYSDATE,SYSDATE,'0','1','350700','南平市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000028','PJ000000000000000000000000000028','福建省武夷山市水利水电工程有限公司','13805990028','中国人民财产保险股份有限公司南平市分公司','黄志明','13859900028','57.0','11.4',TO_DATE('2026-05-10','YYYY-MM-DD'),'福建省安科安全工程师事务所有限公司','苏志彬','13859910028',SYSDATE,SYSDATE,'0','1','2026');

-- 29. 建瓯市城乡供水一体化工程 (南平 350700) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000029','建瓯市城乡供水一体化工程','供水工程','南平市建瓯市','62000','36个月',TO_DATE('2025-02-28','YYYY-MM-DD'),'在建','建瓯市水利局','福建省建瓯市水利水电工程有限公司','张伟民',118.31080000,27.02850000,118.31750000,27.03520000,SYSDATE,SYSDATE,'0','1','350700','南平市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000029','PJ000000000000000000000000000029','福建省建瓯市水利水电工程有限公司','13805990029','中国平安财产保险股份有限公司福建分公司','许志刚','13859900029','64.0','12.8',TO_DATE('2026-01-20','YYYY-MM-DD'),'福建省雄伟安全技术咨询有限责任公司','王志强','13859910029',SYSDATE,SYSDATE,'0','1','2026');

-- 30. 福建省邵武市周源水库工程 (南平 350700) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000030','福建省邵武市周源水库工程','水库工程','南平市邵武市','45000','36个月',TO_DATE('2025-05-08','YYYY-MM-DD'),'在建','邵武市水利局','福建省邵武市水利水电工程有限公司','林文斌',117.49380000,27.33950000,117.50050000,27.34620000,SYSDATE,SYSDATE,'0','1','350700','南平市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000030','PJ000000000000000000000000000030','福建省邵武市水利水电工程有限公司','13805990030','中国太平洋财产保险股份有限公司福建分公司','郑建国','13859900030','46.5','9.3',TO_DATE('2026-03-08','YYYY-MM-DD'),'福建省安全生产科学研究院','黄海滨','13859910030',SYSDATE,SYSDATE,'0','0','2026');

-- 31. 闽江流域建溪防洪工程建瓯东游段 (南平 350700) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000031','闽江流域建溪防洪工程建瓯东游段','防洪工程','南平市建瓯市','38000','30个月',TO_DATE('2025-06-15','YYYY-MM-DD'),'在建','建瓯市水利局','福建省水利水电工程局有限公司','黄志强',118.45820000,27.08650000,118.46490000,27.09320000,SYSDATE,SYSDATE,'0','1','350700','南平市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000031','PJ000000000000000000000000000031','福建省水利水电工程局有限公司','13805990031','中华联合财产保险股份有限公司福建分公司','王志伟','13859900031','39.5','7.9',TO_DATE('2026-04-25','YYYY-MM-DD'),'福建拓普检测技术有限公司','陈金爱','13859910031',SYSDATE,SYSDATE,'0','1','2026');

-- 32. 闽江富屯溪流域防洪提升工程邵武段 (南平 350700) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000032','闽江富屯溪流域防洪提升工程邵武段','防洪工程','南平市邵武市','52000','36个月',TO_DATE('2025-07-22','YYYY-MM-DD'),'在建','邵武市水利局','中国水利水电第八工程局有限公司','陈志华',117.48950000,27.34180000,117.49620000,27.34850000,SYSDATE,SYSDATE,'0','1','350700','南平市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000032','PJ000000000000000000000000000032','中国水利水电第八工程局有限公司','13805990032','海峡金桥财产保险股份有限公司','李志明','13859900032','54.0','10.8',TO_DATE('2026-02-12','YYYY-MM-DD'),'福建中科职业健康评价有限公司','林建清','13859910032',SYSDATE,SYSDATE,'0','0','2026');

-- 33. 龙岩万安溪引水工程 (龙岩 350800) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000033','龙岩万安溪引水工程','引水工程','龙岩市新罗区','32000','30个月',TO_DATE('2025-03-25','YYYY-MM-DD'),'在建','龙岩市水利局','福建省龙岩市水利水电工程有限公司','邱志强',117.01880000,25.07850000,117.02550000,25.08520000,SYSDATE,SYSDATE,'0','1','350800','龙岩市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000033','PJ000000000000000000000000000033','福建省龙岩市水利水电工程有限公司','13805970033','中国人民财产保险股份有限公司龙岩市分公司','陈国栋','13859700033','33.2','6.6',TO_DATE('2026-03-15','YYYY-MM-DD'),'福建省雄伟安全技术咨询有限责任公司','王志强','13859710033',SYSDATE,SYSDATE,'0','1','2026');

-- 34. 武平县城乡供水一体化项目 (龙岩 350800) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000034','武平县城乡供水一体化项目','供水工程','龙岩市武平县','38000','36个月',TO_DATE('2025-04-10','YYYY-MM-DD'),'在建','武平县水利局','福建省武平县水利水电工程有限公司','刘建平',116.10280000,25.09350000,116.10950000,25.10020000,SYSDATE,SYSDATE,'0','1','350800','龙岩市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000034','PJ000000000000000000000000000034','福建省武平县水利水电工程有限公司','13805970034','中国平安财产保险股份有限公司福建分公司','林志强','13859700034','39.5','7.9',TO_DATE('2026-04-02','YYYY-MM-DD'),'福建省环安检测评价有限公司','陈勇宾','13859710034',SYSDATE,SYSDATE,'0','0','2026');

-- 35. 龙岩市永定区光坑水库工程 (龙岩 350800) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000035','龙岩市永定区光坑水库工程','水库工程','龙岩市永定区','25000','30个月',TO_DATE('2025-06-18','YYYY-MM-DD'),'在建','永定区水利局','福建省永定县水利水电工程有限公司','吴志华',116.73180000,24.72680000,116.73850000,24.73350000,SYSDATE,SYSDATE,'0','1','350800','龙岩市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000035','PJ000000000000000000000000000035','福建省永定县水利水电工程有限公司','13805970035','中国太平洋财产保险股份有限公司福建分公司','许文斌','13859700035','26.0','5.2',TO_DATE('2026-05-05','YYYY-MM-DD'),'福建汇顺检测集团有限公司','何雄','13859710035',SYSDATE,SYSDATE,'0','1','2026');

-- 36. 龙岩市富溪一级水库工程 (龙岩 350800) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000036','龙岩市富溪一级水库工程','水库工程','龙岩市新罗区','29000','30个月',TO_DATE('2025-08-12','YYYY-MM-DD'),'在建','新罗区水利局','福建省龙岩市水利水电工程有限公司','黄建平',117.02850000,25.08250000,117.03520000,25.08920000,SYSDATE,SYSDATE,'0','1','350800','龙岩市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000036','PJ000000000000000000000000000036','福建省龙岩市水利水电工程有限公司','13805970036','中国人寿财产保险股份有限公司福建省分公司','陈建国','13859700036','30.0','6.0',TO_DATE('2026-04-18','YYYY-MM-DD'),'福建共益安全环保科技有限公司','林志宏','13859710036',SYSDATE,SYSDATE,'0','0','2026');

-- 37. 宁德市中心城区湖库连通水资源优化配置工程 (宁德 350900) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000037','宁德市中心城区湖库连通水资源优化配置工程','引水工程','宁德市蕉城区','48000','36个月',TO_DATE('2025-01-20','YYYY-MM-DD'),'在建','宁德市水利局','福建省宁德市水利电力工程局','阮志强',119.54880000,26.66580000,119.55550000,26.67250000,SYSDATE,SYSDATE,'0','1','350900','宁德市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000037','PJ000000000000000000000000000037','福建省宁德市水利电力工程局','13805930037','中国人民财产保险股份有限公司宁德市分公司','张建明','13859300037','49.8','9.9',TO_DATE('2026-02-22','YYYY-MM-DD'),'福建省安科安全工程师事务所有限公司','苏志彬','13859310037',SYSDATE,SYSDATE,'0','1','2026');

-- 38. 霞浦县田螺岗水库工程 (宁德 350900) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000038','霞浦县田螺岗水库工程','水库工程','宁德市霞浦县','35000','36个月',TO_DATE('2025-03-10','YYYY-MM-DD'),'在建','霞浦县水利局','福建省霞浦县水利水电工程有限公司','林志宏',120.00680000,26.88580000,120.01350000,26.89250000,SYSDATE,SYSDATE,'0','1','350900','宁德市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000038','PJ000000000000000000000000000038','福建省霞浦县水利水电工程有限公司','13805930038','中国平安财产保险股份有限公司福建分公司','陈志伟','13859300038','36.5','7.3',TO_DATE('2026-03-28','YYYY-MM-DD'),'福建省雄伟安全技术咨询有限责任公司','王志强','13859310038',SYSDATE,SYSDATE,'0','0','2026');

-- 39. 福鼎市管阳溪跨流域引水工程溪头水库 (宁德 350900) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000039','福鼎市管阳溪跨流域引水工程溪头水库','引水工程','宁德市福鼎市','58000','42个月',TO_DATE('2025-04-28','YYYY-MM-DD'),'在建','福鼎市水利局','福建省福鼎市水利水电工程有限公司','郑建平',120.21580000,27.32680000,120.22250000,27.33350000,SYSDATE,SYSDATE,'0','1','350900','宁德市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000039','PJ000000000000000000000000000039','福建省福鼎市水利水电工程有限公司','13805930039','中国太平洋财产保险股份有限公司福建分公司','黄志强','13859300039','60.0','12.0',TO_DATE('2026-04-08','YYYY-MM-DD'),'福建中检康泰检测技术有限公司','缪继荣','13859310039',SYSDATE,SYSDATE,'0','1','2026');

-- 40. 福安市溪尾水库工程 (宁德 350900) - 2026年
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE" ("ID","NAME","TYPE","LOC","INVESTMENT","PLANNED_DURATION","START_DATE","STATUS","MANAGEMENT_UNIT","CONSTRUCTORS","CONTACT_PERSON","CENTER_X","CENTER_Y","GD_X","GD_Y","INTM","UPTM","DATA_STAT","BUSINESS_TYPE","AD_CODE","AD_NAME") VALUES ('PJ000000000000000000000000000040','福安市溪尾水库工程','水库工程','宁德市福安市','22000','24个月',TO_DATE('2025-06-05','YYYY-MM-DD'),'在建','福安市水利局','福建省福安市水利水电工程有限公司','王建生',119.64980000,27.08850000,119.65650000,27.09520000,SYSDATE,SYSDATE,'0','1','350900','宁德市');
INSERT INTO "GW_HUIYI"."ATT_PROJECT_INSURANCE_RECORD" ("ID","PROJECT_ID","POLICYHOLDER","POLICYHOLDER_PHONE","INSURANCE_COMPANY","INSURANCE_CONTACT_PERSON","INSURANCE_CONTACT_PHONE","PREMIUM_AMOUNT","PREVENTION_SERVICE_FEE","INSURANCE_DATE","PREVENTION_SERVICE_UNIT","SERVICE_UNIT_CONTACT_PERSON","SERVICE_UNIT_CONTACT_PHONE","INTM","UPTM","DATA_STAT","STATE","YEAR") VALUES ('RC000000000000000000000000000040','PJ000000000000000000000000000040','福建省福安市水利水电工程有限公司','13805930040','中华联合财产保险股份有限公司福建分公司','林建华','13859300040','22.8','4.5',TO_DATE('2026-05-20','YYYY-MM-DD'),'福建省安全生产科学研究院','黄海滨','13859310040',SYSDATE,SYSDATE,'0','0','2026');

COMMIT;