fj-dc/insert_project_insurance_2026.sql

-- ============================================================
-- 福建省水利工程安责险数据 - 40条（全部 YEAR=2026）
-- AD_CODE 精确到区县级（12位），基于 BIS_INSP_ORG
-- ID格式：PJ/RC + 30位零填充序号 = 精确32字符
-- 生成时间：2026-06-18
-- ============================================================

-- ============================================================
-- 福州市（5条）
-- ============================================================

-- 1. 鼓楼区 (350102000000) - 水库工程
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 ('PJ000000000000000000000000000041','鼓楼区闽江防洪提升工程','防洪工程','福州市鼓楼区','65000','36个月',TO_DATE('2025-03-20','YYYY-MM-DD'),'在建','福州市鼓楼区水利局','福建省水利水电工程局有限公司','张建国',119.30350000,26.08250000,119.31020000,26.08920000,SYSDATE,SYSDATE,'0','1','350102000000','鼓楼区');
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 ('RC000000000000000000000000000041','PJ000000000000000000000000000041','福建省水利水电工程局有限公司','13805910001','中国人民财产保险股份有限公司福建省分公司','李明辉','13859000001','67.5','13.5',TO_DATE('2026-02-15','YYYY-MM-DD'),'福建省雄伟安全技术咨询有限责任公司','王志强','13850700001',SYSDATE,SYSDATE,'0','0','2026');

-- 2. 长乐区 (350112000000) - 供水工程
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 ('PJ000000000000000000000000000042','长乐区城乡供水一体化工程','供水工程','福州市长乐区','78000','36个月',TO_DATE('2025-05-18','YYYY-MM-DD'),'在建','福州市长乐区水利局','中国水利水电第八工程局有限公司','赵永强',119.52320000,25.96280000,119.52990000,25.96950000,SYSDATE,SYSDATE,'0','1','350112000000','长乐区');
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 ('RC000000000000000000000000000042','PJ000000000000000000000000000042','中国水利水电第八工程局有限公司','13805910002','中国平安财产保险股份有限公司福建分公司','黄志伟','13859000002','80.5','16.1',TO_DATE('2026-01-20','YYYY-MM-DD'),'福建省安全生产科学研究院','吴剑锐','13850700002',SYSDATE,SYSDATE,'0','1','2026');

-- 3. 闽侯县 (350121000000) - 防洪工程
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 ('PJ000000000000000000000000000043','闽侯县闽江下游防洪提升工程','防洪工程','福州市闽侯县','92000','42个月',TO_DATE('2025-02-10','YYYY-MM-DD'),'在建','闽侯县水利局','福建省水利水电建设有限公司','林志强',119.15680000,26.05210000,119.16350000,26.05880000,SYSDATE,SYSDATE,'0','1','350121000000','闽侯县');
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 ('RC000000000000000000000000000043','PJ000000000000000000000000000043','福建省水利水电建设有限公司','13805910003','中国太平洋财产保险股份有限公司福建分公司','郑国栋','13859000003','95.0','19.0',TO_DATE('2026-03-05','YYYY-MM-DD'),'福建中检康泰检测技术有限公司','缪继荣','13850700003',SYSDATE,SYSDATE,'0','0','2026');

-- 4. 福清市 (350181000000) - 水库工程
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 ('PJ000000000000000000000000000044','福清市东张水库除险加固工程','水库工程','福州市福清市','45000','30个月',TO_DATE('2025-06-15','YYYY-MM-DD'),'在建','福清市水利局','福建省中禹水利水电工程有限公司','王建平',119.38380000,25.72310000,119.39050000,25.72980000,SYSDATE,SYSDATE,'0','1','350181000000','福清市');
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 ('RC000000000000000000000000000044','PJ000000000000000000000000000044','福建省中禹水利水电工程有限公司','13805910004','中国人寿财产保险股份有限公司福建省分公司','刘志明','13859000004','46.5','9.3',TO_DATE('2026-02-28','YYYY-MM-DD'),'中检集团康泰安全科技有限公司','陈建国','13850700004',SYSDATE,SYSDATE,'0','1','2026');

-- 5. 连江县 (350122000000) - 引水工程
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 ('PJ000000000000000000000000000045','连江县敖江引水工程','引水工程','福州市连江县','38000','30个月',TO_DATE('2025-08-10','YYYY-MM-DD'),'在建','连江县水利局','福建省华舜水利水电工程有限公司','陈建华',119.53280000,26.19750000,119.53950000,26.20420000,SYSDATE,SYSDATE,'0','1','350122000000','连江县');
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 ('RC000000000000000000000000000045','PJ000000000000000000000000000045','福建省华舜水利水电工程有限公司','13805910005','海峡金桥财产保险股份有限公司','陈志强','13859000005','39.5','7.9',TO_DATE('2026-04-12','YYYY-MM-DD'),'福建省安科安全工程师事务所有限公司','苏志彬','13850700005',SYSDATE,SYSDATE,'0','0','2026');

-- ============================================================
-- 厦门市（4条）
-- ============================================================

-- 6. 思明区 (350203000000) - 排涝工程
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 ('PJ000000000000000000000000000046','思明区滨海排涝泵站工程','排涝工程','厦门市思明区','18000','24个月',TO_DATE('2025-04-08','YYYY-MM-DD'),'在建','厦门市思明区水利局','厦门安能建设有限公司','周文华',118.09250000,24.45280000,118.09920000,24.45950000,SYSDATE,SYSDATE,'0','1','350203000000','思明区');
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 ('RC000000000000000000000000000046','PJ000000000000000000000000000046','厦门安能建设有限公司','13805920006','中国人民财产保险股份有限公司厦门市分公司','张伟强','13859200006','18.5','3.7',TO_DATE('2026-02-10','YYYY-MM-DD'),'厦门市九安安全检测评价事务所有限公司','苏自勇','13859210006',SYSDATE,SYSDATE,'0','1','2026');

-- 7. 同安区 (350212000000) - 水闸工程
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 ('PJ000000000000000000000000000047','同安区石浔水闸改建工程','水闸工程','厦门市同安区','16000','20个月',TO_DATE('2025-07-15','YYYY-MM-DD'),'在建','厦门市同安区水利局','福建省汀江水电工程有限公司','吴志伟',118.15230000,24.72250000,118.15900000,24.72920000,SYSDATE,SYSDATE,'0','1','350212000000','同安区');
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 ('RC000000000000000000000000000047','PJ000000000000000000000000000047','福建省汀江水电工程有限公司','13805920007','中国平安财产保险股份有限公司厦门分公司','林志远','13859200007','16.5','3.3',TO_DATE('2026-03-15','YYYY-MM-DD'),'福建省环安检测评价有限公司','陈勇宾','13859210007',SYSDATE,SYSDATE,'0','0','2026');

-- 8. 集美区 (350211000000) - 防洪工程
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 ('PJ000000000000000000000000000048','集美区杏林湾防洪排涝工程','防洪工程','厦门市集美区','28000','30个月',TO_DATE('2025-06-20','YYYY-MM-DD'),'在建','厦门市集美区水利局','福建省水利水电工程局有限公司','许文龙',118.05860000,24.57340000,118.06530000,24.58010000,SYSDATE,SYSDATE,'0','1','350211000000','集美区');
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 ('RC000000000000000000000000000048','PJ000000000000000000000000000048','福建省水利水电工程局有限公司','13805920008','中国太平洋财产保险股份有限公司厦门分公司','陈建华','13859200008','29.0','5.8',TO_DATE('2026-04-08','YYYY-MM-DD'),'福建汇顺检测集团有限公司','何雄','13859210008',SYSDATE,SYSDATE,'0','1','2026');

-- 9. 翔安区 (350213000000) - 供水工程
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 ('PJ000000000000000000000000000049','翔安区农村供水保障工程','供水工程','厦门市翔安区','22000','24个月',TO_DATE('2025-09-12','YYYY-MM-DD'),'在建','厦门市翔安区水利局','厦门市珉发建筑工程有限公司','郑志明',118.24250000,24.62380000,118.24920000,24.63050000,SYSDATE,SYSDATE,'0','1','350213000000','翔安区');
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 ('RC000000000000000000000000000049','PJ000000000000000000000000000049','厦门市珉发建筑工程有限公司','13805920009','阳光财产保险股份有限公司福建分公司','黄志刚','13859200009','22.8','4.5',TO_DATE('2026-05-20','YYYY-MM-DD'),'福建拓普检测技术有限公司','陈金爱','13859210009',SYSDATE,SYSDATE,'0','0','2026');

-- ============================================================
-- 莆田市（4条）
-- ============================================================

-- 10. 城厢区 (350302000000) - 防洪工程
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 ('PJ000000000000000000000000000050','城厢区木兰溪防洪提升工程','防洪工程','莆田市城厢区','52000','36个月',TO_DATE('2024-12-05','YYYY-MM-DD'),'在建','莆田市木兰溪防洪工程建设管理处','中国水利水电第十二工程局有限公司','吴志华',119.01250000,25.42890000,119.01920000,25.43560000,SYSDATE,SYSDATE,'0','1','350302000000','城厢区');
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 ('RC000000000000000000000000000050','PJ000000000000000000000000000050','中国水利水电第十二工程局有限公司','13805940010','海峡金桥财产保险股份有限公司','郑志强','13859400010','54.0','10.8',TO_DATE('2026-01-30','YYYY-MM-DD'),'福建共益安全环保科技有限公司','林志宏','13859410010',SYSDATE,SYSDATE,'0','1','2026');

-- 11. 涵江区 (350303000000) - 水库工程
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 ('PJ000000000000000000000000000051','涵江区西音水库工程','水库工程','莆田市涵江区','38000','30个月',TO_DATE('2024-11-08','YYYY-MM-DD'),'在建','莆田市水利局','福建省莆田市水电工程处','蔡志忠',119.08630000,25.47850000,119.09300000,25.48520000,SYSDATE,SYSDATE,'0','1','350303000000','涵江区');
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 ('RC000000000000000000000000000051','PJ000000000000000000000000000051','福建省莆田市水电工程处','13805940011','中国人民财产保险股份有限公司福建省分公司','刘建国','13859400011','39.5','7.9',TO_DATE('2026-03-18','YYYY-MM-DD'),'福建省雄伟安全技术咨询有限责任公司','王志强','13859410011',SYSDATE,SYSDATE,'0','0','2026');

-- 12. 荔城区 (350304000000) - 排涝工程
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 ('PJ000000000000000000000000000052','荔城区张镇排涝泵站工程','排涝工程','莆田市荔城区','25000','24个月',TO_DATE('2025-03-22','YYYY-MM-DD'),'在建','莆田市水利局','福建省华舜水利水电工程有限公司','陈国华',119.02850000,25.43560000,119.03520000,25.44230000,SYSDATE,SYSDATE,'0','1','350304000000','荔城区');
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 ('RC000000000000000000000000000052','PJ000000000000000000000000000052','福建省华舜水利水电工程有限公司','13805940012','中国平安财产保险股份有限公司福建分公司','王建明','13859400012','26.0','5.2',TO_DATE('2026-04-22','YYYY-MM-DD'),'福建省安全生产科学研究院','吴剑锐','13859410012',SYSDATE,SYSDATE,'0','1','2026');

-- 13. 仙游县 (350322000000) - 供水工程
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 ('PJ000000000000000000000000000053','仙游县城乡供水一体化工程','供水工程','莆田市仙游县','42000','36个月',TO_DATE('2025-05-08','YYYY-MM-DD'),'在建','仙游县水利局','福建省恒鼎建筑工程有限公司','李志伟',118.69250000,25.36180000,118.69920000,25.36850000,SYSDATE,SYSDATE,'0','1','350322000000','仙游县');
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 ('RC000000000000000000000000000053','PJ000000000000000000000000000053','福建省恒鼎建筑工程有限公司','13805940013','中华联合财产保险股份有限公司福建分公司','黄国栋','13859400013','43.5','8.7',TO_DATE('2026-02-18','YYYY-MM-DD'),'福建拓普检测技术有限公司','陈金爱','13859410013',SYSDATE,SYSDATE,'0','0','2026');

-- ============================================================
-- 三明市（4条）
-- ============================================================

-- 14. 三元区 (350403000000) - 供水工程
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 ('PJ000000000000000000000000000054','三元区城乡供水一体化项目','供水工程','三明市三元区','55000','36个月',TO_DATE('2025-01-18','YYYY-MM-DD'),'在建','三明市水利局','福建省水利投资开发集团有限公司','张明辉',117.63920000,26.26380000,117.64590000,26.27050000,SYSDATE,SYSDATE,'0','1','350403000000','三元区');
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 ('RC000000000000000000000000000054','PJ000000000000000000000000000054','福建省水利投资开发集团有限公司','13805980014','中国人民财产保险股份有限公司福建省分公司','陈文彬','13859800014','57.0','11.4',TO_DATE('2026-01-12','YYYY-MM-DD'),'福建省雄伟安全技术咨询有限责任公司','王志强','13859810014',SYSDATE,SYSDATE,'0','1','2026');

-- 15. 大田县 (350425000000) - 水库工程
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 ('PJ000000000000000000000000000055','大田县下岩水库工程','水库工程','三明市大田县','28000','30个月',TO_DATE('2025-04-20','YYYY-MM-DD'),'在建','大田县水利局','福建省泰成建设工程有限公司','林志刚',117.84750000,25.69030000,117.85420000,25.69700000,SYSDATE,SYSDATE,'0','1','350425000000','大田县');
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 ('RC000000000000000000000000000055','PJ000000000000000000000000000055','福建省泰成建设工程有限公司','13805980015','中国平安财产保险股份有限公司福建分公司','许志强','13859800015','29.0','5.8',TO_DATE('2026-04-08','YYYY-MM-DD'),'福建省安全生产科学研究院','黄海滨','13859810015',SYSDATE,SYSDATE,'0','0','2026');

-- 16. 沙县 (350427000000) - 水库工程
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 ('PJ000000000000000000000000000056','沙县区马岩水库工程','水库工程','三明市沙县区','36000','36个月',TO_DATE('2025-03-12','YYYY-MM-DD'),'在建','沙县区水利局','福建省明兴工程建设有限公司','郑志华',117.79230000,26.39780000,117.79900000,26.40450000,SYSDATE,SYSDATE,'0','1','350427000000','沙县');
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 ('RC000000000000000000000000000056','PJ000000000000000000000000000056','福建省明兴工程建设有限公司','13805980016','中国太平洋财产保险股份有限公司福建分公司','王建平','13859800016','37.5','7.5',TO_DATE('2026-03-18','YYYY-MM-DD'),'中检集团康泰安全科技有限公司','陈建国','13859810016',SYSDATE,SYSDATE,'0','1','2026');

-- 17. 建宁县 (350430000000) - 防洪工程
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 ('PJ000000000000000000000000000057','建宁县闽江防洪二期工程','防洪工程','三明市建宁县','48000','36个月',TO_DATE('2025-05-28','YYYY-MM-DD'),'在建','建宁县水利局','福建省水利水电建设有限公司','陈志明',116.84920000,26.83350000,116.85590000,26.84020000,SYSDATE,SYSDATE,'0','1','350430000000','建宁县');
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 ('RC000000000000000000000000000057','PJ000000000000000000000000000057','福建省水利水电建设有限公司','13805980017','中国人寿财产保险股份有限公司福建省分公司','刘建华','13859800017','49.5','9.9',TO_DATE('2026-02-28','YYYY-MM-DD'),'福建中科职业健康评价有限公司','林建清','13859810017',SYSDATE,SYSDATE,'0','0','2026');

-- ============================================================
-- 泉州市（5条）
-- ============================================================

-- 18. 安溪县 (350524000000) - 水库工程
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 ('PJ000000000000000000000000000058','安溪县白濑水利枢纽工程','水库工程','泉州市安溪县','142000','60个月',TO_DATE('2024-02-20','YYYY-MM-DD'),'在建','泉州市白濑水利枢纽工程开发有限公司','中国水利水电第五工程局有限公司','黄志伟',118.18650000,25.05890000,118.19320000,25.06560000,SYSDATE,SYSDATE,'0','1','350524000000','安溪县');
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 ('RC000000000000000000000000000058','PJ000000000000000000000000000058','中国水利水电第五工程局有限公司','13805950018','中国人民财产保险股份有限公司泉州市分公司','张建华','13859500018','148.0','29.6',TO_DATE('2026-01-15','YYYY-MM-DD'),'福建省雄伟安全技术咨询有限责任公司','王志强','13859510018',SYSDATE,SYSDATE,'0','1','2026');

-- 19. 晋江市 (350582000000) - 引水工程
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 ('PJ000000000000000000000000000059','晋江市金门供水水源保障工程','引水工程','泉州市晋江市','56000','36个月',TO_DATE('2025-01-10','YYYY-MM-DD'),'在建','泉州市水利局','福建省水利水电工程局有限公司','王志明',118.58950000,24.81480000,118.59620000,24.82150000,SYSDATE,SYSDATE,'0','1','350582000000','晋江市');
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 ('RC000000000000000000000000000059','PJ000000000000000000000000000059','福建省水利水电工程局有限公司','13805950019','中国平安财产保险股份有限公司福建分公司','郑志刚','13859500019','58.0','11.6',TO_DATE('2026-02-05','YYYY-MM-DD'),'福建省安科安全工程师事务所有限公司','苏志彬','13859510019',SYSDATE,SYSDATE,'0','0','2026');

-- 20. 南安市 (350583000000) - 供水工程
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 ('PJ000000000000000000000000000060','南安市城乡供水一体化项目','供水工程','泉州市南安市','45000','36个月',TO_DATE('2025-03-08','YYYY-MM-DD'),'在建','南安市水利局','福建省南安市第一建设有限公司','李建平',118.38650000,24.96080000,118.39320000,24.96750000,SYSDATE,SYSDATE,'0','1','350583000000','南安市');
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 ('RC000000000000000000000000000060','PJ000000000000000000000000000060','福建省南安市第一建设有限公司','13805950020','中华联合财产保险股份有限公司福建分公司','陈志伟','13859500020','46.5','9.3',TO_DATE('2026-04-15','YYYY-MM-DD'),'福建拓普检测技术有限公司','陈金爱','13859510020',SYSDATE,SYSDATE,'0','1','2026');

-- 21. 洛江区 (350504000000) - 引水工程
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 ('PJ000000000000000000000000000061','洛江区北高干渠输水工程','引水工程','泉州市洛江区','32000','30个月',TO_DATE('2025-06-25','YYYY-MM-DD'),'在建','泉州市北高干渠功能调整输水工程建设处','福建省水利水电工程局有限公司','张建平',118.67120000,24.94180000,118.67790000,24.94850000,SYSDATE,SYSDATE,'0','1','350504000000','洛江区');
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 ('RC000000000000000000000000000061','PJ000000000000000000000000000061','福建省水利水电工程局有限公司','13805950021','中国太平洋财产保险股份有限公司福建分公司','黄建华','13859500021','33.5','6.7',TO_DATE('2026-05-10','YYYY-MM-DD'),'福建省环安检测评价有限公司','陈勇宾','13859510021',SYSDATE,SYSDATE,'0','0','2026');

-- 22. 惠安县 (350521000000) - 排涝工程
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 ('PJ000000000000000000000000000062','惠安县沿海排涝工程','排涝工程','泉州市惠安县','28000','24个月',TO_DATE('2025-07-30','YYYY-MM-DD'),'在建','惠安县水利局','福建省惠安县水利水电工程有限公司','陈志远',118.78250000,25.03180000,118.78920000,25.03850000,SYSDATE,SYSDATE,'0','1','350521000000','惠安县');
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 ('RC000000000000000000000000000062','PJ000000000000000000000000000062','福建省惠安县水利水电工程有限公司','13805950022','海峡金桥财产保险股份有限公司','林志伟','13859500022','29.0','5.8',TO_DATE('2026-03-25','YYYY-MM-DD'),'福建共益安全环保科技有限公司','林志宏','13859510022',SYSDATE,SYSDATE,'0','1','2026');

-- ============================================================
-- 漳州市（5条）
-- ============================================================

-- 23. 龙海市 (350681000000) - 调水工程
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 ('PJ000000000000000000000000000063','龙海区九龙江调水工程','调水工程','漳州市龙海区','112000','48个月',TO_DATE('2024-04-28','YYYY-MM-DD'),'在建','漳州市水利局','中国水利水电第十四工程局有限公司','陈志远',117.84750000,24.35280000,117.85420000,24.35950000,SYSDATE,SYSDATE,'0','1','350681000000','龙海市');
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 ('RC000000000000000000000000000063','PJ000000000000000000000000000063','中国水利水电第十四工程局有限公司','13805960023','中国人民财产保险股份有限公司漳州市分公司','王志华','13859600023','116.5','23.3',TO_DATE('2026-01-20','YYYY-MM-DD'),'福建省雄伟安全技术咨询有限责任公司','王志强','13859610023',SYSDATE,SYSDATE,'0','0','2026');

-- 24. 漳浦县 (350623000000) - 水库工程
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 ('PJ000000000000000000000000000064','漳浦县朝阳水库工程','水库工程','漳州市漳浦县','44000','36个月',TO_DATE('2025-02-18','YYYY-MM-DD'),'在建','漳浦县水利局','福建省漳州市水利水电工程有限公司','林建平',117.61380000,24.11720000,117.62050000,24.12390000,SYSDATE,SYSDATE,'0','1','350623000000','漳浦县');
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 ('RC000000000000000000000000000064','PJ000000000000000000000000000064','福建省漳州市水利水电工程有限公司','13805960024','中国平安财产保险股份有限公司福建分公司','黄伟明','13859600024','45.5','9.1',TO_DATE('2026-03-20','YYYY-MM-DD'),'福建省安全生产科学研究院','吴剑锐','13859610024',SYSDATE,SYSDATE,'0','1','2026');

-- 25. 平和县 (350628000000) - 水库工程
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 ('PJ000000000000000000000000000065','平和县官峰水库工程','水库工程','漳州市平和县','33000','30个月',TO_DATE('2025-05-12','YYYY-MM-DD'),'在建','平和县水利局','福建省平和县水利水电工程有限公司','郑志强',117.31480000,24.36580000,117.32150000,24.37250000,SYSDATE,SYSDATE,'0','1','350628000000','平和县');
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 ('RC000000000000000000000000000065','PJ000000000000000000000000000065','福建省平和县水利水电工程有限公司','13805960025','中国太平洋财产保险股份有限公司福建分公司','许志伟','13859600025','34.0','6.8',TO_DATE('2026-04-22','YYYY-MM-DD'),'福建中检康泰检测技术有限公司','缪继荣','13859610025',SYSDATE,SYSDATE,'0','0','2026');

-- 26. 长泰县 (350625000000) - 水库工程
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 ('PJ000000000000000000000000000066','长泰区湖珠水库工程','水库工程','漳州市长泰区','30000','30个月',TO_DATE('2025-08-05','YYYY-MM-DD'),'在建','长泰区水利局','福建省长泰县水利水电工程有限公司','王志刚',117.75980000,24.62680000,117.76650000,24.63350000,SYSDATE,SYSDATE,'0','1','350625000000','长泰县');
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 ('RC000000000000000000000000000066','PJ000000000000000000000000000066','福建省长泰县水利水电工程有限公司','13805960026','中国人寿财产保险股份有限公司福建省分公司','陈建华','13859600026','31.0','6.2',TO_DATE('2026-05-18','YYYY-MM-DD'),'福建汇顺检测集团有限公司','何雄','13859610026',SYSDATE,SYSDATE,'0','1','2026');

-- 27. 芗城区 (350602000000) - 防洪工程
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 ('PJ000000000000000000000000000067','芗城区九龙江防洪一期工程','防洪工程','漳州市芗城区','50000','36个月',TO_DATE('2025-04-02','YYYY-MM-DD'),'在建','漳州市芗城区水利局','福建省华舜水利水电工程有限公司','李志华',117.65380000,24.51080000,117.66050000,24.51750000,SYSDATE,SYSDATE,'0','1','350602000000','芗城区');
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 ('RC000000000000000000000000000067','PJ000000000000000000000000000067','福建省华舜水利水电工程有限公司','13805960027','阳光财产保险股份有限公司福建分公司','张伟强','13859600027','52.0','10.4',TO_DATE('2026-02-16','YYYY-MM-DD'),'中检集团康泰安全科技有限公司','陈建国','13859610027',SYSDATE,SYSDATE,'0','0','2026');

-- ============================================================
-- 南平市（5条）
-- ============================================================

-- 28. 武夷山市 (350782000000) - 供水工程
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 ('PJ000000000000000000000000000068','武夷山市城乡供水一体化工程','供水工程','南平市武夷山市','58000','36个月',TO_DATE('2024-07-15','YYYY-MM-DD'),'在建','武夷山市水利局','福建省武夷山市水利水电工程有限公司','陈建华',118.03580000,27.75650000,118.04250000,27.76320000,SYSDATE,SYSDATE,'0','1','350782000000','武夷山市');
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 ('RC000000000000000000000000000068','PJ000000000000000000000000000068','福建省武夷山市水利水电工程有限公司','13805990028','中国人民财产保险股份有限公司南平市分公司','黄志明','13859900028','60.0','12.0',TO_DATE('2026-05-10','YYYY-MM-DD'),'福建省安科安全工程师事务所有限公司','苏志彬','13859910028',SYSDATE,SYSDATE,'0','1','2026');

-- 29. 建瓯市 (350783000000) - 供水工程
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 ('PJ000000000000000000000000000069','建瓯市城乡供水一体化工程','供水工程','南平市建瓯市','65000','36个月',TO_DATE('2025-02-28','YYYY-MM-DD'),'在建','建瓯市水利局','福建省建瓯市水利水电工程有限公司','张伟民',118.31080000,27.02850000,118.31750000,27.03520000,SYSDATE,SYSDATE,'0','1','350783000000','建瓯市');
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 ('RC000000000000000000000000000069','PJ000000000000000000000000000069','福建省建瓯市水利水电工程有限公司','13805990029','中国平安财产保险股份有限公司福建分公司','许志刚','13859900029','67.5','13.5',TO_DATE('2026-01-20','YYYY-MM-DD'),'福建省安全生产科学研究院','黄海滨','13859910029',SYSDATE,SYSDATE,'0','0','2026');

-- 30. 邵武市 (350781000000) - 水库工程
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 ('PJ000000000000000000000000000070','邵武市周源水库工程','水库工程','南平市邵武市','48000','36个月',TO_DATE('2025-05-08','YYYY-MM-DD'),'在建','邵武市水利局','福建省邵武市水利水电工程有限公司','林文斌',117.49380000,27.33950000,117.50050000,27.34620000,SYSDATE,SYSDATE,'0','1','350781000000','邵武市');
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 ('RC000000000000000000000000000070','PJ000000000000000000000000000070','福建省邵武市水利水电工程有限公司','13805990030','中国太平洋财产保险股份有限公司福建分公司','郑建国','13859900030','49.5','9.9',TO_DATE('2026-03-08','YYYY-MM-DD'),'福建省安全生产科学研究院','黄海滨','13859910030',SYSDATE,SYSDATE,'0','1','2026');

-- 31. 建阳区 (350703000000) - 防洪工程
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 ('PJ000000000000000000000000000071','建阳区崇阳溪防洪提升工程','防洪工程','南平市建阳区','42000','30个月',TO_DATE('2025-06-15','YYYY-MM-DD'),'在建','建阳区水利局','福建省水利水电工程局有限公司','黄志强',118.12250000,27.33180000,118.12920000,27.33850000,SYSDATE,SYSDATE,'0','1','350703000000','建阳区');
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 ('RC000000000000000000000000000071','PJ000000000000000000000000000071','福建省水利水电工程局有限公司','13805990031','中华联合财产保险股份有限公司福建分公司','王志伟','13859900031','43.5','8.7',TO_DATE('2026-04-25','YYYY-MM-DD'),'福建拓普检测技术有限公司','陈金爱','13859910031',SYSDATE,SYSDATE,'0','0','2026');

-- 32. 延平区 (350702000000) - 防洪工程
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 ('PJ000000000000000000000000000072','延平区闽江上游防洪工程','防洪工程','南平市延平区','38000','30个月',TO_DATE('2025-08-20','YYYY-MM-DD'),'在建','延平区水利局','福建省延平区水利水电工程有限公司','陈志华',118.17850000,26.63780000,118.18520000,26.64450000,SYSDATE,SYSDATE,'0','1','350702000000','延平区');
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 ('RC000000000000000000000000000072','PJ000000000000000000000000000072','福建省延平区水利水电工程有限公司','13805990032','海峡金桥财产保险股份有限公司','李志明','13859900032','39.5','7.9',TO_DATE('2026-03-15','YYYY-MM-DD'),'福建中科职业健康评价有限公司','林建清','13859910032',SYSDATE,SYSDATE,'0','1','2026');

-- ============================================================
-- 龙岩市（4条）
-- ============================================================

-- 33. 新罗区 (350802000000) - 引水工程
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 ('PJ000000000000000000000000000073','新罗区万安溪引水工程','引水工程','龙岩市新罗区','35000','30个月',TO_DATE('2025-03-25','YYYY-MM-DD'),'在建','龙岩市水利局','福建省龙岩市水利水电工程有限公司','邱志强',117.01880000,25.07850000,117.02550000,25.08520000,SYSDATE,SYSDATE,'0','1','350802000000','新罗区');
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 ('RC000000000000000000000000000073','PJ000000000000000000000000000073','福建省龙岩市水利水电工程有限公司','13805970033','中国人民财产保险股份有限公司龙岩市分公司','陈国栋','13859700033','36.5','7.3',TO_DATE('2026-03-15','YYYY-MM-DD'),'福建省雄伟安全技术咨询有限责任公司','王志强','13859710033',SYSDATE,SYSDATE,'0','0','2026');

-- 34. 武平县 (350824000000) - 供水工程
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 ('PJ000000000000000000000000000074','武平县城乡供水一体化项目','供水工程','龙岩市武平县','40000','36个月',TO_DATE('2025-04-10','YYYY-MM-DD'),'在建','武平县水利局','福建省武平县水利水电工程有限公司','刘建平',116.10280000,25.09350000,116.10950000,25.10020000,SYSDATE,SYSDATE,'0','1','350824000000','武平县');
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 ('RC000000000000000000000000000074','PJ000000000000000000000000000074','福建省武平县水利水电工程有限公司','13805970034','中国平安财产保险股份有限公司福建分公司','林志强','13859700034','41.5','8.3',TO_DATE('2026-04-02','YYYY-MM-DD'),'福建省环安检测评价有限公司','陈勇宾','13859710034',SYSDATE,SYSDATE,'0','1','2026');

-- 35. 永定区 (350803000000) - 水库工程
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 ('PJ000000000000000000000000000075','永定区光坑水库工程','水库工程','龙岩市永定区','27000','30个月',TO_DATE('2025-06-18','YYYY-MM-DD'),'在建','永定区水利局','福建省永定县水利水电工程有限公司','吴志华',116.73180000,24.72680000,116.73850000,24.73350000,SYSDATE,SYSDATE,'0','1','350803000000','永定区');
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 ('RC000000000000000000000000000075','PJ000000000000000000000000000075','福建省永定县水利水电工程有限公司','13805970035','中国太平洋财产保险股份有限公司福建分公司','许文斌','13859700035','28.0','5.6',TO_DATE('2026-05-05','YYYY-MM-DD'),'福建汇顺检测集团有限公司','何雄','13859710035',SYSDATE,SYSDATE,'0','0','2026');

-- 36. 上杭县 (350823000000) - 水库工程
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 ('PJ000000000000000000000000000076','上杭县富溪一级水库工程','水库工程','龙岩市上杭县','32000','30个月',TO_DATE('2025-08-12','YYYY-MM-DD'),'在建','上杭县水利局','福建省龙岩市水利水电工程有限公司','黄建平',116.42250000,25.05180000,116.42920000,25.05850000,SYSDATE,SYSDATE,'0','1','350823000000','上杭县');
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 ('RC000000000000000000000000000076','PJ000000000000000000000000000076','福建省龙岩市水利水电工程有限公司','13805970036','中国人寿财产保险股份有限公司福建省分公司','陈建国','13859700036','33.0','6.6',TO_DATE('2026-04-18','YYYY-MM-DD'),'福建共益安全环保科技有限公司','林志宏','13859710036',SYSDATE,SYSDATE,'0','1','2026');

-- ============================================================
-- 宁德市（4条）
-- ============================================================

-- 37. 蕉城区 (350902000000) - 综合治理工程
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 ('PJ000000000000000000000000000077','蕉城区湖库连通水资源优化配置工程','综合治理工程','宁德市蕉城区','52000','36个月',TO_DATE('2025-01-20','YYYY-MM-DD'),'在建','宁德市水利局','福建省宁德市水利电力工程局','阮志强',119.54880000,26.66580000,119.55550000,26.67250000,SYSDATE,SYSDATE,'0','1','350902000000','蕉城区');
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 ('RC000000000000000000000000000077','PJ000000000000000000000000000077','福建省宁德市水利电力工程局','13805930037','中国人民财产保险股份有限公司宁德市分公司','张建明','13859300037','54.0','10.8',TO_DATE('2026-02-22','YYYY-MM-DD'),'福建省安科安全工程师事务所有限公司','苏志彬','13859310037',SYSDATE,SYSDATE,'0','0','2026');

-- 38. 霞浦县 (350921000000) - 水库工程
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 ('PJ000000000000000000000000000078','霞浦县田螺岗水库工程','水库工程','宁德市霞浦县','38000','36个月',TO_DATE('2025-03-10','YYYY-MM-DD'),'在建','霞浦县水利局','福建省霞浦县水利水电工程有限公司','林志宏',120.00680000,26.88580000,120.01350000,26.89250000,SYSDATE,SYSDATE,'0','1','350921000000','霞浦县');
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 ('RC000000000000000000000000000078','PJ000000000000000000000000000078','福建省霞浦县水利水电工程有限公司','13805930038','中国平安财产保险股份有限公司福建分公司','陈志伟','13859300038','39.5','7.9',TO_DATE('2026-03-28','YYYY-MM-DD'),'福建省雄伟安全技术咨询有限责任公司','王志强','13859310038',SYSDATE,SYSDATE,'0','1','2026');

-- 39. 福鼎市 (350982000000) - 水闸工程
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 ('PJ000000000000000000000000000079','福鼎市管阳溪引水工程溪头水库','水闸工程','宁德市福鼎市','25000','24个月',TO_DATE('2025-04-28','YYYY-MM-DD'),'在建','福鼎市水利局','福建省福鼎市水利水电工程有限公司','郑建平',120.21580000,27.32680000,120.22250000,27.33350000,SYSDATE,SYSDATE,'0','1','350982000000','福鼎市');
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 ('RC000000000000000000000000000079','PJ000000000000000000000000000079','福建省福鼎市水利水电工程有限公司','13805930039','中国太平洋财产保险股份有限公司福建分公司','黄志强','13859300039','26.0','5.2',TO_DATE('2026-04-08','YYYY-MM-DD'),'福建中检康泰检测技术有限公司','缪继荣','13859310039',SYSDATE,SYSDATE,'0','0','2026');

-- 40. 福安市 (350981000000) - 水库工程
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 ('PJ000000000000000000000000000080','福安市溪尾水库工程','水库工程','宁德市福安市','24000','24个月',TO_DATE('2025-06-05','YYYY-MM-DD'),'在建','福安市水利局','福建省福安市水利水电工程有限公司','王建生',119.64980000,27.08850000,119.65650000,27.09520000,SYSDATE,SYSDATE,'0','1','350981000000','福安市');
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 ('RC000000000000000000000000000080','PJ000000000000000000000000000080','福建省福安市水利水电工程有限公司','13805930040','中华联合财产保险股份有限公司福建分公司','林建华','13859300040','25.0','5.0',TO_DATE('2026-05-20','YYYY-MM-DD'),'福建省安全生产科学研究院','黄海滨','13859310040',SYSDATE,SYSDATE,'0','1','2026');

COMMIT;