| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117 |
- #导出文件的存放根目录
- #export.basePath=D:/temp
- #暗访调研行政村统计表
- export.T1.field=
- export.T1.field[0]=adNm,行政村名称,,VARCHAR2
- export.T1.field[1]=isPoverty,是否贫困村,,VARCHAR2
- export.T1.field[2]=isFluexc,是否氟超标地区,,VARCHAR2
- export.T1.field[3]=isMtarea,是否山区,,VARCHAR2
- export.T1.field[4]=isCenwtSupply,是否集中供水村,,VARCHAR2
- export.T1.field[5]=watersupplyPer,集中供水人口比例,,VARCHAR2
- export.T1.field[6]=visitDate,暗访日期,,TIMESTAMP
- #村内农村饮水工程设施运行维护情况表
- export.T2.field=
- export.T2.field[0]=adNm,行政村名称,,VARCHAR2
- export.T2.field[1]=isNdAdmin,是否需要设置管水员,,VARCHAR2
- export.T2.field[2]=isAdmin,是否设置管水员,,VARCHAR2
- export.T2.field[3]=adminNm,管水员姓名,VARCHAR2
- export.T2.field[4]=adminAge,管水员年龄,,NUMERIC
- export.T2.field[5]=adminPro,管水员性质,,VARCHAR2
- export.T2.field[6]=salary,管水员工资(元/年),,NUMERIC
- export.T2.field[7]=operFee,运行维护费用(元/年),,NUMERIC
- export.T2.field[8]=otherFeeOrg,除水费收入外的运行维护费用来源,,NUMERIC
- export.T2.field[9]=feeCommons,费用说明,,NUMERIC
- export.T2.field[10]=visitDate,暗访日期,,TIMESTAMP
- #用水户情况表
- export.T3.field=
- export.T3.field[0]=villageNm,调查地点(*县*乡镇*村),,VARCHAR2
- export.T3.field[1]=userNm,户主姓名,,VARCHAR2
- export.T3.field[2]=telphone,电话,,VARCHAR2
- export.T3.field[3]=cwsCode,对应工程名称,,VARCHAR2
- export.T3.field[4]=isQualityGood,水质是否良好,,VARCHAR2
- export.T3.field[5]=isQualityProblem,是否存在问题,,VARCHAR2
- export.T3.field[6]=isSplyHome,是否供水入户,,VARCHAR2
- export.T3.field[7]=is24hSupply,是否24小时供水,,VARCHAR2
- export.T3.field[8]=isWaterProblem,是否存在供水问题,,VARCHAR2
- export.T3.field[9]=isCalFee,是否计量收费,,VARCHAR2
- export.T3.field[10]=isFeeProblem,是否存在计费问题,,VARCHAR2
- export.T3.field[11]=isSplyProblem,供水服务是否存在问题,,VARCHAR2
- export.T3.field[12]=evaluate,总体评价,,VARCHAR2
- #农村饮水工程运行管理情况表
- export.T4.field=
- export.T4.field[0 ]=pjnm,工程名称,,VARCHAR2
- export.T4.field[1 ]=villageNm,所在地,,VARCHAR2
- export.T4.field[2 ]=buildYear,建成年份,,VARCHAR2
- export.T4.field[3 ]=planSupplyScale,设计供水规模(m?/d),,VARCHAR2
- export.T4.field[4 ]=supplyScale,实际供水规模(m?/d),,VARCHAR2
- export.T4.field[5 ]=personNum,覆盖人口(人),,VARCHAR2
- export.T4.field[6 ]=pipeDamagePer,管网漏损率(%),,VARCHAR2
- export.T4.field[7 ]=projectType,工程类别,,VARCHAR2
- export.T4.field[8 ]=is24hSupply,是否24小时不间断供水,,VARCHAR2
- export.T4.field[9 ]=isHavecleanEqui,净化设施设备是否配备,,VARCHAR2
- export.T4.field[10]=disinfectType,净化设施设备消毒方式,,VARCHAR2
- export.T4.field[11]=isHavedisinfect,消毒设备是否配备,,VARCHAR2
- export.T4.field[12]=disinfectType,消毒方式,,VARCHAR2
- export.T4.field[13]=isDisinfectGood,消毒方式是否正常运行,,VARCHAR2
- export.T4.field[14]=isHavereport,水质检测报告有无报告,,VARCHAR2
- export.T4.field[15]=isQuailtyGood,水质检测报告是否达标,,VARCHAR2
- export.T4.field[16]=isHaveLab,千吨万人水厂水质化验室是否配备,,VARCHAR2
- export.T4.field[17]=isDailyCheck,千吨万人水厂水质化验室是否开展日检,,VARCHAR2
- export.T4.field[18]=isDailycheckGood,千吨万人水厂水质化验室水质是否达标,,VARCHAR2
- export.T4.field[19]=isInsLicence,有无取水许可证,,VARCHAR2
- export.T4.field[20]=isSanLicence,有无卫生许可证,,VARCHAR2
- export.T4.field[21]=isAutosystem,自动化控制系统是否配备,,VARCHAR2
- export.T4.field[22]=isAutosysGood,自动化控制系统是否正常运行,,VARCHAR2
- export.T4.field[23]=isVideoSystem,视频安防系统是否配备,,VARCHAR2
- export.T4.field[24]=isVideosysGood,视频安防系统是否正常运行,,VARCHAR2
- export.T4.field[25]=waterFee,执行水价(元/m?),,VARCHAR2
- export.T4.field[26]=waterCost,全成本(元/m?),,VARCHAR2
- export.T4.field[27]=operCost,运行成本(元/m?),,VARCHAR2
- export.T4.field[28]=feeRecyclePer,水费回收率(%),,VARCHAR2
- export.T4.field[29]=manager,管理主体,,VARCHAR2
- export.T4.field[30]=isHaveHotline,是否配备供水服务热线电话,,VARCHAR2
- export.T4.field[31]=status,填报状态,,VARCHAR2
- export.T4.field[32]=visitDate,暗访日期,,VARCHAR2
- export.T4.field[33]=recPers2,记录人员,,VARCHAR2
- export.T4.field[34]=recPersTel,记录人员电话,,VARCHAR2
- #千人以上供水工程水源地保护情况表
- export.T5.field=
- export.T5.field[0]=waterSourceNm,水源地名称,,VARCHAR2
- export.T5.field[1]=villageNm,所在地(*县*乡镇*村),,VARCHAR2
- export.T5.field[2]=cwsCode,供水工程名称,,VARCHAR2
- export.T5.field[3]=planInsAmount,设计取水规模(m?/d),,VARCHAR2
- export.T5.field[4]=sourceType,水源类型,,VARCHAR2
- export.T5.field[5]=waterQuality,水源水质评价,,VARCHAR2
- export.T5.field[6]=isProtectArea,是否划定水源保护区或保护范围,,VARCHAR2
- export.T5.field[7]=isProtectMark,是否有水源保护标志,,VARCHAR2
- export.T5.field[8]=isPollSource,周边是否有污染源,,VARCHAR2
- export.T5.field[9]=isSpare,是否有应急备用水源,,VARCHAR2
- export.T5.field[10]=visitDate,暗访日期,,VARCHAR2
- #管理责任体系落实情况表
- export.T6.field=
- export.T6.field[0]=personAmount,农村人口(万人),,VARCHAR2
- export.T6.field[1]=focusSupplyPerc,集中供水率,,VARCHAR2
- export.T6.field[2]=waterSupplyPerc,自来水普及率,,VARCHAR2
- export.T6.field[3]=isGovRes,地方人民政府主体责任是否明确,,VARCHAR2
- export.T6.field[4]=isCntyDept,是否建立县级运行管理机构,,VARCHAR2
- export.T6.field[5]=isCntyFunc,是否建立县级运行管理办法,,VARCHAR2
- export.T6.field[6]=isCntyFee,是否落实县级运行管理经费,,VARCHAR2
- export.T6.field[7]=isQuailtyChk,是否正常开展水质巡检,,VARCHAR2
- export.T6.field[8]=pracFee,2018年落实运行经费(万元),,VARCHAR2
- export.T6.field[9]=visitDate,暗访日期,,VARCHAR2
- export.T6.field[11]=accompany,县级水行政主管部门参加人员,,VARCHAR2
- export.T6.field[12]=visitorIds,暗访组(人),,VARCHAR2
- export.T6.field[13]=recPers2,记录人员,,VARCHAR2
- export.T6.field[14]=recPersTel,记录人员电话,,VARCHAR2
- export.T6.field[15]=status,填报状态,,VARCHAR2
|