{"text_format":"2","workbook":"xlsx","n_sheets":8,"sheets":["大屏","大屏模块详细信息","二级页面安全态势专题图层","二级页面点位地图","二级页面综合风险","专家反馈接口","领导驾驶舱","基础设备大屏"],"not_rendered":{"charts":0,"images":96,"macros":0,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"大屏","index":0,"n_rows":247,"n_cols":75,"rows_kept":247,"cut":false,"hidden":false,"merged":[[26,42,26,43],[54,8,54,11],[58,44,58,45],[59,44,59,45],[60,44,60,45],[61,44,61,45],[62,44,62,45],[145,5,145,7],[145,15,145,17],[146,5,146,7],[146,15,146,17],[147,5,147,7],[147,15,147,17],[148,5,148,7],[148,15,148,17],[149,5,149,7],[149,15,149,17],[150,5,150,7],[190,5,190,7],[190,15,190,17],[190,39,190,40],[191,5,191,7],[191,15,191,17],[191,39,191,40],[192,5,192,7],[192,15,192,17],[192,39,192,40],[193,5,193,7],[193,15,193,17],[193,39,193,40],[194,5,194,7],[194,15,194,17],[194,39,194,40],[195,5,195,7],[195,15,195,17],[195,39,195,40],[196,39,196,40],[198,44,198,46],[199,44,199,46],[200,44,200,46],[201,44,201,46],[202,44,202,46],[203,44,203,46],[204,44,204,46],[239,7,239,8],[239,13,239,17],[240,7,240,8],[240,15,240,16],[241,7,241,8],[241,15,241,16],[241,21,241,22],[241,23,241,24],[242,7,242,8],[242,15,242,16],[242,21,242,22],[242,23,242,24],[243,7,243,8],[243,21,243,22],[243,23,243,24],[244,7,244,8],[244,21,244,22],[244,23,244,24],[245,7,245,8],[245,21,245,22],[245,23,245,24]]}
{"$rows_empty":24}
[{"$nulls":41},"调用接口","findSupervisionBefore12Month",null,null,"调用接口","findSupervisionEveryAreaBefore12MonthLess",null,null,"调用接口","findSupervisionEveryAreaBefore12Month",null,null,"调用接口","findSupervisionListBefore12MonthLess",null,"调用接口","findSupervisionListBefore12Month",{"$nulls":4},"巡查计划,实际巡查巡检数据",null,"隐患数据,事件数据",null,null,"现问题梳理,全年巡检次数,巡检计划数量,巡查计划进度","巡查计划进度计算方式","近12个月巡检数/近12个月计划巡检数据",null,null,"隐患数据,事件数据,事件,隐患当月环比","事件当月环比计算:","(当月事件数据-上个月数据)/上个月数据"]
[{"$nulls":41},"查询主表","rq_jg_aqzxjcjl/work_order_admin/linkage_coordinate/industry_supervision_supervise","rq_jg_lhjcjl",null,"查询主表","rq_jg_aqzxjcjl","rq_jg_lhjcjl",null,"查询主表","rq_jg_aqzxjcjl","sg_jg_dsfsglhcj",null,"查询主表","rq_jg_aqzxjcjl","rq_jg_lhjcjl","查询主表","rq_jg_aqzxjcjl","sg_jg_dsfsglhcj",null,null,"调用接口","getXunchaCountEverySceneBefore12M","调用接口","findHiddenTroubleAndEmergencyEveryScenBefore12M",null,"调用接口","getXunchaCountBefore12M",null,null,null,"调用接口","findHiddenTroubleAndEmergencyListBefore12Month","隐患当月环比计算:","(当月隐患数据-上个月数据)/上个月数据"]
[{"$nulls":7},"调用接口","EquipmentSelectController/equipmentLeftTopInfo",{"$nulls":4},"调用接口","fenxianTotalEveryArea",null,"调用接口","fenxianTotalEveryScene",null,"调用接口","fenxianTotal",{"$nulls":20},"查询规则","近12个月",null,null,"查询规则","专项检查数(rq_jg_aqzxjcjl)","联合检查数(rq_jg_lhjcjl)",null,"查询规则","存在隐患字段不为空(发现问题数)","近12个月(行政处罚)",null,"查询规则","专项检查数(rq_jg_aqzxjcjl)","联合检查数(rq_jg_lhjcjl)","查询规则","存在隐患字段不为空(发现问题数)","近12个月(行政处罚)",null,null,"查询主表","industry_supervision_patrol_plan和industry_supervision_patrol_plan_dtl和industry_supervision_patrol","查询主表","zhjg_analysis_hidden_trouble和zhjg_analysis_emergency",null,"查询主表","industry_supervision_patrol_plan和industry_supervision_patrol_plan_dtl和industry_supervision_patrol",null,null,null,"查询主表","zhjg_analysis_hidden_trouble和zhjg_analysis_emergency"]
[{"$nulls":7},"查询主表","桥梁:ql_js_ql ",{"$nulls":4},"查询主表","view_risk_collect(同archives_risk表)",null,"查询主表","view_risk_collect(同archives_risk表)",null,"查询主表","view_risk_collect(同archives_risk表)",{"$nulls":21},"检查数(rq_jg_aqzxjcjl)","检查数(rq_jg_lhjcjl)",null,null,"存在隐患字段不为空(问题数)","近12个月",null,null,"存在隐患字段不为空(整改数)",null,null,null,"存在隐患字段不为空(问题数)","近12个月",null,"存在隐患字段不为空(整改数)",null,null,null,"查询规则","近12个月","查询规则","近12个月",null,"查询规则","近12个月",null,null,null,"查询规则","近12个月"]
[{"$nulls":7},"查询规则","桥梁:kjfl in(1,2,3,4)",{"$nulls":4},"查询规则","评估分值>=60",null,"查询规则","评估分值>=60",null,"查询规则","评估分值>=60",{"$nulls":21},"存在隐患字段不为空(问题数)",null,null,null,"存在隐患字段不为空(消除数)",null,null,null,"近12个月",null,null,null,"存在隐患字段不为空(消除数)",null,null,"近12个月",{"$nulls":4},"主表未删除状态",null,"主表未删除状态",null,null,"主表未删除状态",{"$nulls":4},"主表未删除状态"]
[{"$nulls":14},"未删除状态",null,null,"未删除状态",null,null,"未删除状态",{"$nulls":21},"存在隐患字段不为空(消除数)",null,null,null,"近12个月",{"$nulls":7},"近12个月",{"$nulls":7},"实际巡查数据不关联计划表(实际巡查数据)",null,"区县不为空(zhjg_analysis_hidden_trouble)",null,null,"巡检记录中存在隐患字段不为空(发现问题梳理)",{"$nulls":4},"区县不为空(zhjg_analysis_hidden_trouble)"]
[{"$nulls":14},"行政区划不为空",null,null,"行政区划不为空",null,null,"行政区划不为空",{"$nulls":43},"等级不为空(zhjg_analysis_hidden_trouble)",{"$nulls":7},"等级不为空(zhjg_analysis_hidden_trouble)"]
[{"$nulls":14},"等级不为空",null,null,"等级不为空",null,null,"等级不为空"]
[]
[{"$nulls":24},"调用接口","findCountEveryPlace",{"$nulls":7},"监管时长:","2023-10-15 00:00:00开始计算的时间",null,null,null,"重点视频监控数据"]
[{"$nulls":25},"风险",null,null,"隐患",null,null,"突发事件",{"$nulls":5},"调用接口","importantVideoList"]
[{"$nulls":24},"查询主表","view_risk_collect(同archives_risk表)",null,"查询主表","zhjg_analysis_hidden_trouble",null,"查询主表","zhjg_analysis_emergency",null,"全市安全监测点位:","调用接口","pointTopStatisticsDetail",null,"查询主表","video_channel(视频通道表)"]
[{"$nulls":24},"查询规则","评估分值>=60",null,"查询规则","行政区划不为空",null,"查询规则","未删除状态",null,null,"查询主表","zhjg_analysis_monitor_point",null,"查询规则","未删除状态"]
[{"$nulls":25},"未删除状态",null,null,"等级不为空",null,null,"处置进度为未处理和处置中",null,null,"查询规则","未删除状态",null,null,"是重点监控"]
[{"$nulls":25},"行政区划不为空",null,null,"未删除状态",{"$nulls":9},"限制显示前4个"]
[{"$nulls":25},"等级不为空",null,null,"处置进度为未处理和处置中"]
[{"$nulls":41},"调用接口","getWarningInfoStatics",null,null,"调用接口","findWarningInfoStatisticsList",null,null,"调用接口","findZhjgAnalysisEmergencyRate",null,null,"调用接口","findWarningInfoStatisticsListByScene"]
[{"$nulls":38},"预警数据",null,null,"查询主表","warning_info",null,null,"查询主表","warning_info",null,null,"查询主表","zhjg_analysis_emergency",null,null,"查询主表","warning_info"]
[{"$nulls":37},"调用接口","realTimeWarningList",null,null,"查询规则","近12个月",null,null,"查询规则","近12个月",null,null,"查询规则","近12个月",null,null,"查询规则","近12个月"]
[{"$nulls":37},"查询主表","warning_info(预警管理表)",null,null,null,"未删除状态",null,null,null,"未删除状态",null,null,null,"未删除状态",null,null,null,"未删除状态"]
[{"$nulls":37},"查询规则","未删除状态",null,null,null,"累计消除预警(处置状态为:已处置)",null,null,null,"预警=预警状态为“发布”的预警数合计","未处置=处置状态为“未处置”的预警数合计",null,null,"已处置=突发事件处理进度为已完成事件数",null,null,null,"预警=预警状态为“发布”的预警数合计","未处置=处置状态为“未处置”的预警数合计"]
[{"$nulls":38},"处置状态:非误报,非处置完成",null,null,null,"预警级别不为空(warning_rank in(1,2,3,4))",null,null,null,"需处置=预警数-处置状态为“误报”的预警数合计","处置中=处置状态为“处置中”的预警数合计",null,null,"未处置=突发事件处理进度为未处理事件数",null,null,null,"需处置=预警数-处置状态为“误报”的预警数合计","处置中=处置状态为“处置中”的预警数合计"]
[{"$nulls":38},"排除预警状态为解除数据",null,null,null,"累计重大预警查询(预警级别为4)",null,null,null,"处置中=处置状态为“处置中”的预警数合计","已处置=处置状态为“处置完成”的预警数合计",null,null,"处置中=突发事件处理进度为处理中事件数",null,null,null,"处置中=处置状态为“处置中”的预警数合计","已处置=处置状态为“处置完成”的预警数合计"]
[{"$nulls":42},"行政区划不为空",null,null,null,"预警级别不为空(warning_rank in(1,2,3,4))",null,null,null,"已上报=响应级别为>=三级、四级且进度为未处理、处理中的事件数",null,null,null,"预警级别不为空(warning_rank in(1,2,3,4))"]
[{"$nulls":42},"disposal_state非误报状态",{"$nulls":7},"处置率=已处置数/所有事件数"]
[]
[]
[]
[]
[]
[null,null,"大屏左边监测设备上线,总,故障统计","调用接口","equipmentLeftBottomInfo",null,"燃气/内涝/供水/桥梁/第三方","调用接口","equipmentLeftBottomInfoRanQi/equipmentLeftBottomInfoPaiShui/equipmentLeftBottomInfoGongShui/equipmentLeftBottomInfoQiaoLiang/equipmentLeftBottomInfoDiSanFang",{"$nulls":4},"调用接口","findZhjgAnalysisHiddenTroubleStatisticsEveryArea",null,"调用接口","findZhjgAnalysisHiddenTroubleStatistics",null,"调用接口","findZhjgAnalysisHiddenTroubleListBefore12Month"]
[null,null,null,"查询主表","zhjg_analysis_monitoring_equipment",null,null,"查询主表","zhjg_analysis_monitoring_equipment",{"$nulls":4},"查询主表","zhjg_analysis_hidden_trouble",null,"查询主表","zhjg_analysis_hidden_trouble",null,"查询主表","zhjg_analysis_hidden_trouble"]
[null,null,null,"查询规则","未删除状态",null,null,"查询规则","未删除状态",{"$nulls":4},"查询规则","行政区划不为空",null,"查询规则","行政区划不为空",null,"查询规则","行政区划不为空"]
[{"$nulls":4},"设备状态试运行,和正常(在线数据统计用)",null,null,null,"设备状态试运行,和正常(在线数据统计用)",{"$nulls":5},"等级不为空",null,null,"等级不为空",null,null,"等级不为空"]
[{"$nulls":8},"equipment_status:设备状态 1-未使用，2-正常，3-试运行，4-故障，5-维修，6-报废(字典:通用_JCSB_SBZT_DM)",{"$nulls":5},"近12个月",null,null,"近12个月",null,null,"近12个月",{"$nulls":20},"待定",null,"调用接口","findAnLiFenXiListGroupByScene",null,null,"待定",{"$nulls":4},"待定",{"$nulls":8},"待定",{"$nulls":4},"调用接口","BoardController/todayDutyList"]
[{"$nulls":14},"未删除状态",null,null,"未删除状态",null,null,"未删除状态",{"$nulls":22},"查询主表","social_public_case和industry_supervision_report",{"$nulls":21},"查询主表","duty_management"]
[{"$nulls":14},"处置状态为2已完成(统计整改数量用)",null,null,"处置状态为2已完成(统计整改数量用)",null,null,"处置状态为2已完成(统计整改数量用)",{"$nulls":22},"查询规则","未删除状态",{"$nulls":21},"查询规则","未删除状态"]
[{"$nulls":44},"已发布状态",{"$nulls":22},"值班日期当日"]
[{"$nulls":44},"发布时间倒序各个专项前3条"]
[]
[]
[null,"弹框部分"]
{"$rows_empty":33}
[null,null,null,"调用接口","realTimeWarningListPageOrigin",{"$nulls":19},"调用接口","realTimeWarningListPage"]
[null,null,null,"查询主表","warning_info(预警管理表)",{"$nulls":19},"查询主表","warning_info(预警管理表)"]
[null,null,null,"查询规则","未删除状态",{"$nulls":19},"查询规则","未删除状态"]
[{"$nulls":4},"处置状态:非误报",{"$nulls":20},"处置状态:非误报"]
[{"$nulls":4},"预警生成时间倒序",{"$nulls":20},"预警生成时间倒序"]
{"$rows_empty":41}
[null,null,null,"调用接口","findSupervisionEveryAreaBefore12MonthLess",{"$nulls":8},"调用接口","findSupervisionEveryAreaBefore12Month",{"$nulls":10},"安全检查和联合检查数",null,null,"检查总和和行政处罚",{"$nulls":5},"计划培训数","实际培训数",null,null,"前12个月各个区县的的培训计划和实际培训数量",{"$nulls":4},"近12个月督办数",{"$nulls":6},"近12个月各个区县的督办数"]
[null,null,null,"查询主表","rq_jg_aqzxjcjl","rq_jg_lhjcjl",{"$nulls":7},"查询主表","rq_jg_aqzxjcjl","sg_jg_dsfsglhcj",{"$nulls":8},"调用接口","findSupervisionEveryMonthBefore12MonthLess",null,"调用接口","findSupervisionListBefore12Month",{"$nulls":4},"调用接口","getPeixunCountListBefore12Month",null,null,"调用接口","getPeixunCountEveryAreaBefore12Month",null,null,null,"调用接口","getDuBanListBefore12Month",{"$nulls":5},"调用接口","getDuBanEveryAreaBefore12Month"]
[null,null,null,"查询规则","专项检查数(rq_jg_aqzxjcjl)","联合检查数(rq_jg_lhjcjl)",{"$nulls":7},"查询规则","存在隐患字段不为空(发现问题数)","近12个月(行政处罚)",{"$nulls":8},"查询主表","view_aqzxjcjl和view_lhjcjl",null,"查询主表","rq_jg_aqzxjcjl和rq_jg_lhjcjl和sg_jg_dsfsglhcj",{"$nulls":4},"查询主表","social_public_train_plan_dtl和social_public_train_plan","social_public_train_plan和social_public_training",null,"查询主表","social_public_training和social_public_train_plan",null,null,null,"查询主表","industry_supervision_supervise",{"$nulls":5},"查询主表","industry_supervision_supervise"]
[{"$nulls":4},"存在隐患字段不为空(问题数)","近12个月",{"$nulls":8},"存在隐患字段不为空(整改数)",{"$nulls":9},"查询规则","检查日期近12个月",null,"查询规则","检查日期近12个月(检查数量)",{"$nulls":4},"查询规则","未删除状态","记录表未删除状态",null,"查询规则","培训开始时间为近12个月",null,null,null,"查询规则","未删除状态",{"$nulls":5},"查询规则","未删除状态"]
[{"$nulls":4},"存在隐患字段不为空(消除数)",{"$nulls":9},"近12个月",{"$nulls":13},"惩戒时间近12个月(行政处罚数量)",{"$nulls":5},"计划时间近12个月","发布状态:已发布",null,null,"培训记录表未删除状态",{"$nulls":4},"发布状态:已发布",{"$nulls":6},"发布状态:已发布"]
[{"$nulls":4},"近12个月",{"$nulls":30},"开始时间近12个月",null,null,"发布状态:已发布",{"$nulls":4},"开始时间近12个月(当月督办数)",{"$nulls":6},"开始时间近12个月"]
[{"$nulls":38},"培训计划没有区县统计字段",{"$nulls":4},"结束时间近12个月(当月完成数)"]
[{"$nulls":34},"隐患数","事件数"]
[{"$nulls":33},"调用接口","findHiddenTroubleAndEmergencyListBefore12Month"]
[{"$nulls":33},"查询主表","zhjg_analysis_hidden_trouble","zhjg_analysis_emergency",{"$nulls":7},"隐患数","事件数"]
[{"$nulls":33},"查询规则","发现时间近12个月","创建时间近12个月",{"$nulls":6},"调用接口","findHiddenTroubleAndEmergencyListBefore12Month"]
[{"$nulls":34},"未删除状态","未删除状态",{"$nulls":6},"查询主表","zhjg_analysis_hidden_trouble","zhjg_analysis_emergency"]
[{"$nulls":34},"等级不为空",{"$nulls":7},"查询规则","发现时间近12个月","创建时间近12个月"]
[{"$nulls":34},"区县不为空",{"$nulls":8},"未删除状态","未删除状态"]
[{"$nulls":43},"等级不为空"]
[{"$nulls":43},"区县不为空"]
{"$rows_empty":29}
[null,null,null,"调用接口","findSupervisionListBefore12MonthLess",{"$nulls":8},"调用接口","findSupervisionListBefore12Month",{"$nulls":10},"安全检查和联合检查数",null,null,"检查总和和行政处罚",{"$nulls":5},"计划培训数","实际培训数",null,null,"前12个月各个专项的培训计划和","实际培训数量",null,null,null,"近12个月督办数",{"$nulls":6},"近12个月各个场景的督办数"]
[null,null,null,"查询主表","rq_jg_aqzxjcjl","rq_jg_lhjcjl",{"$nulls":7},"查询主表","rq_jg_aqzxjcjl","sg_jg_dsfsglhcj",{"$nulls":8},"调用接口","findSupervisionEveryMonthBefore12MonthLess",null,"调用接口","findSupervisionEveryAreaBefore12Month",{"$nulls":4},"调用接口","getPeixunCountListBefore12Month",null,null,"调用接口","getPeixunCountEverySceneBefore12Month",null,null,null,"调用接口","getDuBanListBefore12Month",{"$nulls":5},"调用接口","getDuBanEverySceneBefore12Month"]
[null,null,null,"查询规则","专项检查数(rq_jg_aqzxjcjl)","联合检查数(rq_jg_lhjcjl)",{"$nulls":7},"查询规则","存在隐患字段不为空(发现问题数)","近12个月(行政处罚)",{"$nulls":8},"查询主表","view_aqzxjcjl和view_lhjcjl",null,"调用接口","findSupervisionListBefore12Month",{"$nulls":4},"查询主表","social_public_train_plan_dtl和social_public_train_plan","social_public_train_plan和social_public_training",null,"查询主表","social_public_train_plan_dtl和social_public_train_plan","social_public_train_plan和social_public_training",null,null,"查询主表","industry_supervision_supervise",{"$nulls":5},"查询主表","industry_supervision_supervise"]
[{"$nulls":4},"存在隐患字段不为空(问题数)","近12个月",{"$nulls":8},"存在隐患字段不为空(整改数)",{"$nulls":9},"查询规则","检查日期近12个月",null,"查询主表","rq_jg_aqzxjcjl和rq_jg_lhjcjl和sg_jg_dsfsglhcj",{"$nulls":4},"查询规则","未删除状态","记录表未删除状态",null,"查询规则","培训计划时间为近12个月","培训开始时间为近12个月",null,null,"查询规则","未删除状态",{"$nulls":5},"查询规则","未删除状态"]
[{"$nulls":4},"存在隐患字段不为空(消除数)",{"$nulls":9},"近12个月",{"$nulls":12},"查询规则","检查日期近12个月(检查数量)",{"$nulls":5},"计划时间近12个月","发布状态:已发布",null,null,"各表未删除状态","培训记录表未删除状态",null,null,null,"发布状态:已发布",{"$nulls":6},"发布状态:已发布"]
[{"$nulls":4},"近12个月",{"$nulls":23},"惩戒时间近12个月(行政处罚数量)",{"$nulls":6},"开始时间近12个月",null,null,null,"发布状态:已发布",null,null,null,"开始时间近12个月(当月督办数)",{"$nulls":6},"开始时间近12个月"]
[{"$nulls":43},"结束时间近12个月(当月完成数)"]
[{"$nulls":34},"隐患数","事件数"]
[{"$nulls":33},"调用接口","findHiddenTroubleAndEmergencyListBefore12Month",{"$nulls":8},"隐患数","事件数"]
[{"$nulls":33},"查询主表","zhjg_analysis_hidden_trouble","zhjg_analysis_emergency",{"$nulls":6},"调用接口","findHiddenTroubleAndEmergencyListBefore12Month"]
[{"$nulls":33},"查询规则","发现时间近12个月","创建时间近12个月",{"$nulls":6},"查询主表","zhjg_analysis_hidden_trouble","zhjg_analysis_emergency"]
[{"$nulls":34},"未删除状态","未删除状态",{"$nulls":6},"查询规则","发现时间近12个月","创建时间近12个月"]
[{"$nulls":34},"等级不为空",{"$nulls":8},"未删除状态","未删除状态"]
[{"$nulls":34},"区县不为空",{"$nulls":8},"等级不为空"]
[{"$nulls":43},"区县不为空"]
{"$rows_empty":34}
[{"$nulls":4},"巡查计划,实际巡查巡检数据",null,null,"隐患数据,事件数据",{"$nulls":5},"现问题梳理,全年巡检次数,巡检计划数量和隐患数据,事件数据,事件,隐患当月环比",{"$nulls":6},"当月计划巡查巡检,当月实际巡查巡检,隐患,事件",{"$nulls":7},"查所有区级区划的检查数（次）, 行政处罚数（个）",{"$nulls":5},"当月计划培训次数, 当月实际培训次数,隐患, 事件",null,null,null,"计划数, 培训数"]
[null,null,null,"调用接口","getXunchaCountEverySceneBefore12M",null,"调用接口","findHiddenTroubleAndEmergencyEveryScenBefore12M",{"$nulls":5},"调用接口","getCompanyCheckNum","巡检环比计算:",null,"（当月巡检次数-上月次数）/上月巡检次数",null,"调用接口","getCompanyCheckTrendLeftECharts",{"$nulls":6},"调用接口","getCompanyCheckTrendRightECharts",{"$nulls":4},"调用接口","getCompanySafeLeftECharts",null,null,"调用接口","getCompanySafeRightECharts"]
[null,null,null,"查询主表","industry_supervision_patrol_plan和industry_supervision_patrol_plan_dtl和industry_supervision_patrol",null,"查询主表","zhjg_analysis_hidden_trouble和zhjg_analysis_emergency",{"$nulls":5},"查询主表","industry_supervision_patrol_plan和industry_supervision_patrol_plan_dtl和industry_supervision_patrol和zhjg_analysis_hidden_trouble和zhjg_analysis_emergency","事件当月环比计算:",null,"(当月事件数据-上个月数据)/上个月数据",null,"查询主表","zhjg_analysis_emergency(事件)","zhjg_analysis_hidden_trouble(隐患)",null,"industry_supervision_patrol_plan和industry_supervision_patrol_plan_dtl和industry_supervision_patrol(计划和实际巡查)",null,null,null,"查询主表","industry_supervision_patrol",{"$nulls":4},"查询主表","zhjg_analysis_emergency（事件），zhjg_analysis_hidden_trouble（隐患），social_public_train_plan（培训），social_public_train_plan_dtl（培训），social_public_training（培训）",null,null,"查询主表","social_public_train_plan（培训），social_public_train_plan_dtl（培训），social_public_training（培训）"]
[null,null,null,"查询规则","近12个月",null,"查询规则","近12个月",{"$nulls":5},"查询规则","近12个月","隐患当月环比计算:",null,"(当月隐患数据-上个月数据)/上个月数据",null,"查询规则","近12个月","近12个月",null,"近12个月",null,null,null,"查询规则","近12个月按区划过滤",{"$nulls":4},"查询规则","近12个月按月份过滤",null,null,"查询规则","近12月按场景过滤"]
[{"$nulls":4},"主表未删除状态",null,null,"主表未删除状态",{"$nulls":6},"主表未删除状态",{"$nulls":5},"主表未删除状态","主表未删除状态",null,"主表未删除状态",{"$nulls":4},"主表未删除",{"$nulls":5},"主表未删除",null,null,null,"主表未删除"]
[{"$nulls":4},"实际巡查数据不关联计划表(实际巡查数据)",null,null,"区县不为空(zhjg_analysis_hidden_trouble)",{"$nulls":6},"巡检记录中存在隐患字段不为空(发现问题梳理)",{"$nulls":6},"区县不为空(zhjg_analysis_hidden_trouble)",null,"实际巡查数据不关联计划表(实际巡查数据)",{"$nulls":4},"区县不为空",{"$nulls":5},"有场景过滤条件",null,null,null,"有培训类型过滤条件"]
[{"$nulls":7},"等级不为空(zhjg_analysis_hidden_trouble)",{"$nulls":6},"隐患区县不为空(zhjg_analysis_hidden_trouble)",{"$nulls":6},"等级不为空(zhjg_analysis_hidden_trouble)",{"$nulls":6},"有场景过滤条件"]
[{"$nulls":14},"隐患等级不为空(zhjg_analysis_hidden_trouble)",{"$nulls":13},"行政处罚数为pitFall不为空的数量"]

{"sheet":"大屏模块详细信息","index":1,"n_rows":39,"n_cols":5,"rows_kept":39,"cut":false,"hidden":false,"merged":[[27,1,33,1],[27,2,33,2],[27,3,33,3]]}
["大屏模块详细信息"]
{"$rows_empty":25}
[null,"种类数量查询","总数量查询","在线率查询","查询语句"]
["燃气","对应专项的,非删除的,不同设备类型数","对应专项的,非删除的, 设备状态为1-未使用，2-正常，3-试运行，4-故障，5-维修的设备数量","对应专项的,非删除的,设备状态为2-正常，3-试运行的设备数量除于总数量的百分比,保留2位小数","SELECT\n t1.A type_count,\n t2.A all_count,\n t2.b all_line_count \nFROM\n ( SELECT COUNT ( 1 ) A FROM ( SELECT equipment_type FROM zhjg_analysis_monitoring_equipment WHERE scene = '0' AND deleted = 1 GROUP BY equipment_type ) T ) t1,\n (\n SELECT COUNT\n  ( 1 ) FILTER ( WHERE equipment_status IN ( '5', '4', '3', '2', '1' ) ) A,\n  COUNT ( 1 ) FILTER ( WHERE equipment_status IN ( '3', '2' ) ) b \n FROM\n  zhjg_analysis_monitoring_equipment \n WHERE\n  scene = '0' \n AND deleted = 1 \n ) t2"]
["内涝",null,null,null,"SELECT\n t1.A type_count,\n t2.A all_count,\n t2.b all_line_count \nFROM\n ( SELECT COUNT ( 1 ) A FROM ( SELECT equipment_type FROM zhjg_analysis_monitoring_equipment WHERE scene = '1' AND deleted = 1 GROUP BY equipment_type ) T ) t1,\n (\n SELECT COUNT\n  ( 1 ) FILTER ( WHERE equipment_status IN ( '5', '4', '3', '2', '1' ) ) A,\n  COUNT ( 1 ) FILTER ( WHERE equipment_status IN ( '3', '2' ) ) b \n FROM\n  zhjg_analysis_monitoring_equipment \n WHERE\n  scene = '1' \n AND deleted = 1 \n ) t2;"]
["供水",null,null,null,"SELECT\n t1.A type_count,\n t2.A all_count,\n t2.b all_line_count \nFROM\n ( SELECT COUNT ( 1 ) A FROM ( SELECT equipment_type FROM zhjg_analysis_monitoring_equipment WHERE scene = '2' AND deleted = 1 GROUP BY equipment_type ) T ) t1,\n (\n SELECT COUNT\n  ( 1 ) FILTER ( WHERE equipment_status IN ( '5', '4', '3', '2', '1' ) ) A,\n  COUNT ( 1 ) FILTER ( WHERE equipment_status IN ( '3', '2' ) ) b \n FROM\n  zhjg_analysis_monitoring_equipment \n WHERE\n  scene = '1' \n AND deleted = 1 \n ) t2;"]
["施工工程",null,null,null,"SELECT\n t1.A type_count,\n t2.A all_count,\n t2.b all_line_count \nFROM\n ( SELECT COUNT ( 1 ) A FROM ( SELECT equipment_type FROM zhjg_analysis_monitoring_equipment WHERE scene = '3' AND deleted = 1 GROUP BY equipment_type ) T ) t1,\n (\n SELECT COUNT\n  ( 1 ) FILTER ( WHERE equipment_status IN ( '5', '4', '3', '2', '1' ) ) A,\n  COUNT ( 1 ) FILTER ( WHERE equipment_status IN ( '3', '2' ) ) b \n FROM\n  zhjg_analysis_monitoring_equipment \n WHERE\n  scene = '1' \n AND deleted = 1 \n ) t2;"]
["地下管线",null,null,null,"SELECT\n t1.A type_count,\n t2.A all_count,\n t2.b all_line_count \nFROM\n ( SELECT COUNT ( 1 ) A FROM ( SELECT equipment_type FROM zhjg_analysis_monitoring_equipment WHERE scene = '4' AND deleted = 1 GROUP BY equipment_type ) T ) t1,\n (\n SELECT COUNT\n  ( 1 ) FILTER ( WHERE equipment_status IN ( '5', '4', '3', '2', '1' ) ) A,\n  COUNT ( 1 ) FILTER ( WHERE equipment_status IN ( '3', '2' ) ) b \n FROM\n  zhjg_analysis_monitoring_equipment \n WHERE\n  scene = '1' \n AND deleted = 1 \n ) t2;"]
["桥梁",null,null,null,"SELECT\n t1.A type_count,\n t2.A all_count,\n t2.b all_line_count \nFROM\n ( SELECT COUNT ( 1 ) A FROM ( SELECT equipment_type FROM zhjg_analysis_monitoring_equipment WHERE scene = '5' AND deleted = 1 GROUP BY equipment_type ) T ) t1,\n (\n SELECT COUNT\n  ( 1 ) FILTER ( WHERE equipment_status IN ( '5', '4', '3', '2', '1' ) ) A,\n  COUNT ( 1 ) FILTER ( WHERE equipment_status IN ( '3', '2' ) ) b \n FROM\n  zhjg_analysis_monitoring_equipment \n WHERE\n  scene = '1' \n AND deleted = 1 \n ) t2;"]
["道路",null,null,null,"SELECT\n t1.A type_count,\n t2.A all_count,\n t2.b all_line_count \nFROM\n ( SELECT COUNT ( 1 ) A FROM ( SELECT equipment_type FROM zhjg_analysis_monitoring_equipment WHERE scene = '6' AND deleted = 1 GROUP BY equipment_type ) T ) t1,\n (\n SELECT COUNT\n  ( 1 ) FILTER ( WHERE equipment_status IN ( '5', '4', '3', '2', '1' ) ) A,\n  COUNT ( 1 ) FILTER ( WHERE equipment_status IN ( '3', '2' ) ) b \n FROM\n  zhjg_analysis_monitoring_equipment \n WHERE\n  scene = '1' \n AND deleted = 1 \n ) t2;"]
[null,"字段名称","备注"]
["注:","equipment_status","设备状态 1-未使用，2-正常，3-试运行，4-故障，5-维修，6-报废(字典:通用_JCSB_SBZT_DM)"]
[null,"scene","专项类型:0-燃气，1-内涝，2-供水，3-施工工程，4-地下管线，5-桥梁，6-道路"]
[null,"deleted","1非删除状态"]
[null,"equipment_type","设备类型"]

{"sheet":"二级页面安全态势专题图层","index":2,"n_rows":126,"n_cols":55,"rows_kept":126,"cut":false,"hidden":false,"merged":[]}
{"$rows_empty":26}
[null,"调用接口","findRiskCountList",null,"调用接口","findTroubleCountList",null,"调用接口","findEmergencyCountList",null,null,"调用接口","findRiskCountList",null,"调用接口","findTroubleCountList",null,"调用接口","findEmergencyCountList",{"$nulls":18},"调用接口","findRiskCountList",null,"调用接口","findTroubleCountList",null,"调用接口","findEmergencyCountList",null,null,"调用接口","findRiskCountList",null,"调用接口","findTroubleCountList",null,"调用接口","findEmergencyCountList"]
[null,null,"风险",null,null,"隐患",null,null,"事件",null,null,null,"风险",null,null,"隐患",null,null,"事件",{"$nulls":19},"风险",null,null,"隐患",null,null,"事件",null,null,null,"风险",null,null,"隐患",null,null,"事件"]
[null,"查询主表","view_risk_collect(archives_risk表)",null,"查询主表","zhjg_analysis_hidden_trouble",null,"查询主表","zhjg_analysis_emergency",null,null,"查询主表","view_risk_collect(archives_risk表)",null,"查询主表","zhjg_analysis_hidden_trouble",null,"查询主表","zhjg_analysis_emergency",{"$nulls":18},"查询主表","view_risk_collect(archives_risk表)",null,"查询主表","zhjg_analysis_hidden_trouble",null,"查询主表","zhjg_analysis_emergency",null,null,"查询主表","view_risk_collect(archives_risk表)",null,"查询主表","zhjg_analysis_hidden_trouble",null,"查询主表","zhjg_analysis_emergency"]
[null,"查询规则","评估分值>=60",null,"查询规则","行政区划不为空",null,"查询规则","未删除状态",null,null,"查询规则","评估分值>=60",null,"查询规则","行政区划不为空",null,"查询规则","未删除状态",{"$nulls":18},"查询规则","评估分值>=60",null,"查询规则","行政区划不为空",null,"查询规则","未删除状态",null,null,"查询规则","评估分值>=60",null,"查询规则","行政区划不为空",null,"查询规则","未删除状态"]
[null,null,"未删除状态",null,null,"等级不为空",null,null,"处置进度为未处理和处置中",null,null,null,"未删除状态",null,null,"等级不为空",null,null,"处置进度为未处理和处置中",{"$nulls":19},"未删除状态",null,null,"等级不为空",null,null,"处置进度为未处理和处置中",null,null,null,"未删除状态",null,null,"等级不为空",null,null,"处置进度为未处理和处置中"]
[null,null,"行政区划不为空",null,null,"未删除状态",{"$nulls":6},"行政区划不为空",null,null,"未删除状态",{"$nulls":22},"行政区划不为空",null,null,"未删除状态",{"$nulls":6},"行政区划不为空",null,null,"未删除状态"]
[null,null,"等级不为空",null,null,"处置进度为未处理和处置中",{"$nulls":6},"等级不为空",null,null,"处置进度为未处理和处置中",{"$nulls":22},"等级不为空",null,null,"处置进度为未处理和处置中",{"$nulls":6},"等级不为空",null,null,"处置进度为未处理和处置中"]
[]
[]
[]
[{"$nulls":4},"调用接口","findOverHourTroubleCountList",null,"调用接口","findOverHourEmergencyCountList",{"$nulls":5},"调用接口","findOverHourTroubleCountList",null,"调用接口","findOverHourEmergencyCountList",{"$nulls":4},"调用接口","findCountEveryPlace",{"$nulls":15},"调用接口","findOverHourTroubleCountList",null,"调用接口","findOverHourEmergencyCountList",{"$nulls":5},"调用接口","findOverHourTroubleCountList",null,"调用接口","findOverHourEmergencyCountList"]
[{"$nulls":5},"隐患超时",null,null,"事件超时",{"$nulls":6},"隐患超时",null,null,"事件超时",{"$nulls":5},"风险",null,null,"隐患",null,null,"突发事件",{"$nulls":10},"隐患超时",null,null,"事件超时",{"$nulls":6},"隐患超时",null,null,"事件超时"]
[{"$nulls":4},"查询主表","zhjg_analysis_hidden_trouble",null,"查询主表","zhjg_analysis_emergency",{"$nulls":5},"查询主表","zhjg_analysis_hidden_trouble",null,"查询主表","zhjg_analysis_emergency",{"$nulls":4},"查询主表","view_risk_collect(同archives_risk表)",null,"查询主表","zhjg_analysis_hidden_trouble",null,"查询主表","zhjg_analysis_emergency",{"$nulls":9},"查询主表","zhjg_analysis_hidden_trouble",null,"查询主表","zhjg_analysis_emergency",{"$nulls":5},"查询主表","zhjg_analysis_hidden_trouble",null,"查询主表","zhjg_analysis_emergency"]
[{"$nulls":4},"查询规则","处置进度为未处理和处置中",null,"查询规则","未删除状态",{"$nulls":5},"查询规则","处置进度为未处理和处置中",null,"查询规则","未删除状态",{"$nulls":4},"查询规则","评估分值>=60",null,"查询规则","行政区划不为空",null,"查询规则","未删除状态",{"$nulls":9},"查询规则","处置进度为未处理和处置中",null,"查询规则","未删除状态",{"$nulls":5},"查询规则","处置进度为未处理和处置中",null,"查询规则","未删除状态"]
[{"$nulls":5},"未删除状态",null,null,"处置进度为未处理和处置中",{"$nulls":6},"未删除状态",null,null,"处置进度为未处理和处置中",{"$nulls":5},"未删除状态",null,null,"等级不为空",null,null,"处置进度为未处理和处置中",{"$nulls":10},"未删除状态",null,null,"处置进度为未处理和处置中",{"$nulls":6},"未删除状态",null,null,"处置进度为未处理和处置中"]
[{"$nulls":5},"行政区划不为空",null,null,"评估时间大于24小时",{"$nulls":6},"行政区划不为空",null,null,"评估时间大于24小时",{"$nulls":5},"行政区划不为空",null,null,"未删除状态",{"$nulls":13},"行政区划不为空",null,null,"评估时间大于24小时",{"$nulls":6},"行政区划不为空",null,null,"评估时间大于24小时"]
[{"$nulls":5},"等级不为空",{"$nulls":9},"等级不为空",{"$nulls":8},"等级不为空",null,null,"处置进度为未处理和处置中",{"$nulls":13},"等级不为空",{"$nulls":9},"等级不为空"]
[{"$nulls":5},"评估时间大于24小时",{"$nulls":9},"评估时间大于24小时",{"$nulls":25},"评估时间大于24小时",{"$nulls":9},"评估时间大于24小时"]
{"$rows_empty":18}
[null,"调用接口","findRiskCountList",null,"调用接口","findTroubleCountList",null,"调用接口","findEmergencyCountList",null,null,"调用接口","findRiskCountList",null,"调用接口","findTroubleCountList",null,"调用接口","findEmergencyCountList",{"$nulls":18},"调用接口","findRiskCountList",null,"调用接口","findTroubleCountList",null,"调用接口","findEmergencyCountList",null,null,"调用接口","BoardController/todayDutyList"]
[null,null,"风险",null,null,"隐患",null,null,"事件",null,null,null,"风险",null,null,"隐患",null,null,"事件",{"$nulls":19},"风险",null,null,"隐患",null,null,"事件",null,null,"查询主表","duty_management"]
[null,"查询主表","view_risk_collect(archives_risk表)",null,"查询主表","zhjg_analysis_hidden_trouble",null,"查询主表","zhjg_analysis_emergency",null,null,"查询主表","view_risk_collect(archives_risk表)",null,"查询主表","zhjg_analysis_hidden_trouble",null,"查询主表","zhjg_analysis_emergency",{"$nulls":18},"查询主表","view_risk_collect(archives_risk表)",null,"查询主表","zhjg_analysis_hidden_trouble",null,"查询主表","zhjg_analysis_emergency",null,null,"查询规则","未删除状态"]
[null,"查询规则","评估分值>=60",null,"查询规则","行政区划不为空",null,"查询规则","未删除状态",null,null,"查询规则","评估分值>=60",null,"查询规则","行政区划不为空",null,"查询规则","未删除状态",{"$nulls":18},"查询规则","评估分值>=60",null,"查询规则","行政区划不为空",null,"查询规则","未删除状态",null,null,null,"值班日期当日"]
[null,null,"未删除状态",null,null,"等级不为空",null,null,"处置进度为未处理和处置中",null,null,null,"未删除状态",null,null,"等级不为空",null,null,"处置进度为未处理和处置中",{"$nulls":19},"未删除状态",null,null,"等级不为空",null,null,"处置进度为未处理和处置中"]
[null,null,"行政区划不为空",null,null,"未删除状态",{"$nulls":6},"行政区划不为空",null,null,"未删除状态",{"$nulls":22},"行政区划不为空",null,null,"未删除状态"]
[null,null,"等级不为空",null,null,"处置进度为未处理和处置中",{"$nulls":6},"等级不为空",null,null,"处置进度为未处理和处置中",{"$nulls":22},"等级不为空",null,null,"处置进度为未处理和处置中"]
[]
[]
[]
[{"$nulls":4},"调用接口","findOverHourTroubleCountList",null,"调用接口","findOverHourEmergencyCountList",{"$nulls":5},"调用接口","findOverHourTroubleCountList",null,"调用接口","findOverHourEmergencyCountList",{"$nulls":21},"调用接口","findOverHourTroubleCountList",null,"调用接口","findOverHourEmergencyCountList"]
[{"$nulls":5},"隐患超时",null,null,"事件超时",{"$nulls":6},"隐患超时",null,null,"事件超时",{"$nulls":22},"隐患超时",null,null,"事件超时"]
[{"$nulls":4},"查询主表","zhjg_analysis_hidden_trouble",null,"查询主表","zhjg_analysis_emergency",{"$nulls":5},"查询主表","zhjg_analysis_hidden_trouble",null,"查询主表","zhjg_analysis_emergency",{"$nulls":21},"查询主表","zhjg_analysis_hidden_trouble",null,"查询主表","zhjg_analysis_emergency"]
[{"$nulls":4},"查询规则","处置进度为未处理和处置中",null,"查询规则","未删除状态",{"$nulls":5},"查询规则","处置进度为未处理和处置中",null,"查询规则","未删除状态",{"$nulls":21},"查询规则","处置进度为未处理和处置中",null,"查询规则","未删除状态"]
[{"$nulls":5},"未删除状态",null,null,"处置进度为未处理和处置中",{"$nulls":6},"未删除状态",null,null,"处置进度为未处理和处置中",{"$nulls":22},"未删除状态",null,null,"处置进度为未处理和处置中"]
[{"$nulls":5},"行政区划不为空",null,null,"评估时间大于24小时",{"$nulls":6},"行政区划不为空",null,null,"评估时间大于24小时",{"$nulls":22},"行政区划不为空",null,null,"评估时间大于24小时"]
[{"$nulls":5},"等级不为空",{"$nulls":9},"等级不为空",{"$nulls":25},"等级不为空"]
[{"$nulls":5},"评估时间大于24小时",{"$nulls":9},"评估时间大于24小时",{"$nulls":25},"评估时间大于24小时"]
[]
[]
[]
[]
[null,"弹框部分"]
{"$rows_empty":35}
[{"$nulls":4},"调用接口","findInfoDetailEveryPlace",{"$nulls":19},"调用接口","findInfoDetailEveryPlace",{"$nulls":13},"调用接口","findInfoDetailEveryPlace"]
[{"$nulls":4},"查询主表","view_risk_collect(archives_risk表)",{"$nulls":19},"查询主表","zhjg_analysis_hidden_trouble",{"$nulls":13},"查询主表","zhjg_analysis_emergency"]
[{"$nulls":4},"查询规则","评估分值>=60",{"$nulls":19},"查询规则","行政区划不为空",{"$nulls":13},"查询规则","未删除状态"]
[{"$nulls":5},"未删除状态",{"$nulls":20},"等级不为空",{"$nulls":14},"处置进度为未处理和处置中"]
[{"$nulls":5},"行政区划不为空",{"$nulls":20},"未删除状态"]
[{"$nulls":5},"等级不为空",{"$nulls":20},"处置进度为未处理和处置中"]

{"sheet":"二级页面点位地图","index":3,"n_rows":73,"n_cols":55,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
{"$rows_empty":21}
[{"$nulls":8},"调用接口","BoardController/managerOrganizationList"]
[{"$nulls":8},"查询主表","manager_organization和archives_organization",{"$nulls":26},"调用接口","emergencyPlanList"]
[{"$nulls":8},"查询规则","未删除状态",{"$nulls":26},"查询主表","industry_supervision_scheme"]
[{"$nulls":9},"不同场景",{"$nulls":26},"查询规则","未删除状态"]
[{"$nulls":37},"发布状态:已发布"]
[{"$nulls":37},"可选各个专项"]
{"$rows_empty":11}
[{"$nulls":47},"调用接口","nearbyEmergencyResources"]
["燃气","调用接口","ranqiJIanCedian1",null,"调用接口","ranqiJIanCedian2",{"$nulls":42},"避难场所","仓库","医疗机构","应急物资","救援队伍","重大危险源","防护目标"]
[null,"查询主表","zhjg_analysis_monitor_point",null,"查询主表","zhjg_analysis_monitoring_equipment",{"$nulls":41},"查询主表","zy_js_bncs","zy_js_ck","zy_js_ylwsjg","zy_js_yjwz和zy_js_ck","zy_js_jydw","zy_js_zdwxy","risk_ledger"]
[null,"查询规则","未删除状态",null,"查询规则","未删除状态",{"$nulls":41},"查询规则","经纬度数据geom_data是4490规则","经纬度数据geom_data是4490规则","经纬度数据geom_data是4490规则","经纬度数据geom_data是4490规则","经纬度数据geom_data是4490规则","经纬度数据geom_data是4490规则","经纬度数据geom_data是4490规则"]
[null,null,"根据设施名称分类",null,null,"设备类型和监测指标分类",{"$nulls":42},"未删除状态","未删除状态","未删除状态","未删除状态","未删除状态","未删除状态"]
[]
["排水","调用接口","paishuiJIanCedian1",null,"调用接口","paishuiJIanCedian2"]
[null,"查询主表","zhjg_analysis_monitor_point",null,"查询主表","zhjg_analysis_monitoring_equipment"]
[null,"查询规则","未删除状态",null,"查询规则","未删除状态",{"$nulls":10},"查询设备点位"]
[null,null,"根据设施名称分类",null,null,"设备类型和监测指标分类",{"$nulls":9},"调用接口","pointStatisticsDetail"]
[{"$nulls":15},"查询主表","zhjg_analysis_monitor_point"]
["供水","调用接口","gongshuiJIanCedian1",null,"调用接口","gongshuiJIanCedian2",null,null,"vue文件","\\src\\views\\life-line\\monitor\\points\\devicemap\\index.vue",{"$nulls":5},"查询规则","未删除状态"]
[null,"查询主表","zhjg_analysis_monitor_point",null,"查询主表","zhjg_analysis_monitoring_equipment",null,null,"调用接口","BoardController/liveVideoList",{"$nulls":6},"不同区域"]
[null,"查询规则","未删除状态",null,"查询规则","未删除状态",null,null,"查询主表","video_channel",{"$nulls":6},"不同专项"]
[null,null,"根据设施名称分类",null,null,"设备类型和监测指标分类",null,null,"查询规则","未删除状态"]
[{"$nulls":9},"展示前9条数据"]
["桥梁","调用接口","qiaoliangJIanCedian1",null,"调用接口","qiaoliangJIanCedian2",{"$nulls":30},"调用接口","emergencyExpertList"]
[null,"查询主表","zhjg_analysis_monitor_point",null,"查询主表","zhjg_analysis_monitoring_equipment",{"$nulls":30},"查询主表","zy_js_yjzj"]
[null,"查询规则","未删除状态",null,"查询规则","未删除状态",{"$nulls":30},"查询规则","未删除状态"]
[null,null,"根据设施名称分类",null,null,"设备类型和监测指标分类"]
[]
["道路","调用接口","daoluJIanCedian1",null,"调用接口","daoluJIanCedian2"]
[null,"查询主表","zhjg_analysis_monitor_point",null,"查询主表","zhjg_analysis_monitoring_equipment"]
[null,"查询规则","未删除状态",null,"查询规则","未删除状态"]
[null,null,"根据设施名称分类",null,null,"设备类型和监测指标分类"]
[]
["管线","调用接口","guanxianJIanCedian1",null,"调用接口","guanxianJIanCedian2"]
[null,"查询主表","zhjg_analysis_monitor_point",null,"查询主表","zhjg_analysis_monitoring_equipment"]
[null,"查询规则","未删除状态",null,"查询规则","未删除状态"]
[null,null,"根据设施名称分类",null,null,"设备类型和监测指标分类"]
[]
["第三方","调用接口","disanfangJIanCedian1",null,"调用接口","disanfangJIanCedian2"]
[null,"查询主表","zhjg_analysis_monitor_point",null,"查询主表","zhjg_analysis_monitoring_equipment"]
[null,"查询规则","未删除状态",null,"查询规则","未删除状态"]
[null,null,"根据设施名称分类",null,null,"设备类型和监测指标分类"]

{"sheet":"二级页面综合风险","index":4,"n_rows":497,"n_cols":80,"rows_kept":497,"cut":false,"hidden":false,"merged":[[50,37,50,38]]}
{"$rows_empty":47}
[{"$nulls":4},"调用接口","getFindXunchaPlan",{"$nulls":15},"调用接口","getFindXunchaHasDoneCountOfYear",{"$nulls":12},"全年每月计划巡查对象数和实际巡查对象数","调用接口","getPlanAndDoXunchaCountEveryMonth"]
[{"$nulls":4},"查询主表","industry_supervision_patrol_plan和industry_supervision_patrol",{"$nulls":15},"查询主表","industry_supervision_patrol_plan和industry_supervision_patrol_plan",{"$nulls":13},"查询主表","industry_supervision_patrol_plan_dtl","industry_supervision_patrol"]
[{"$nulls":4},"查询规则","未删除状态",{"$nulls":15},"查询规则","未删除状态",{"$nulls":13},"查询规则","计划时间为当年","检查时间 为当年"]
[{"$nulls":5},"各个场景",{"$nulls":16},"各个场景",{"$nulls":14},"未删除状态"]
[{"$nulls":22},"近12个月的数据",{"$nulls":14},"各个场景"]
[{"$nulls":35},"全年巡查次数","调用接口","getFindXunchaCountEveryMonth"]
[{"$nulls":36},"查询主表","industry_supervision_patrol"]
[{"$nulls":36},"查询规则","未删除状态"]
[{"$nulls":37},"检查时间 为当年"]
[{"$nulls":37},"存在隐患字段不为空"]
[{"$nulls":37},"各个场景"]
[{"$nulls":35},"全年每月隐患数量","调用接口","getYinHuanCountEveryMonth"]
[{"$nulls":36},"查询主表","zhjg_analysis_hidden_trouble"]
[{"$nulls":36},"查询规则","未删除状态"]
[{"$nulls":37},"发现时间为当年"]
[{"$nulls":37},"等级不为空"]
[{"$nulls":37},"区县不为空"]
[{"$nulls":37},"各个场景"]
[{"$nulls":35},"全年每月事件数量","调用接口","getShiJianCountEveryMonth"]
[{"$nulls":36},"查询主表","zhjg_analysis_emergency"]
[{"$nulls":36},"查询规则","未删除状态"]
[{"$nulls":37},"发现时间为当年"]
[{"$nulls":37},"各个场景"]
[{"$nulls":35},"全年事件数和环比数","调用接口","getShiJianCountOfYear"]
[{"$nulls":36},"查询主表","zhjg_analysis_emergency"]
[{"$nulls":36},"查询规则","未删除状态"]
[{"$nulls":37},"发现时间为当年和去年"]
[{"$nulls":37},"各个场景"]
[{"$nulls":35},"全年隐患数和环比数","调用接口","getYinHuanCountOfYear"]
[{"$nulls":36},"查询主表","zhjg_analysis_hidden_trouble"]
[{"$nulls":36},"查询规则","未删除状态"]
[{"$nulls":37},"发现时间为当年和去年"]
[{"$nulls":37},"等级不为空"]
[{"$nulls":37},"区县不为空"]
[{"$nulls":37},"各个场景"]
{"$rows_empty":41}
[{"$nulls":21},"调用接口","findHangYeTongBaoList"]
[{"$nulls":21},"查询主表","industry_supervision_report"]
[{"$nulls":21},"查询规则","未删除状态"]
[{"$nulls":22},"各个场景"]
[{"$nulls":22},"发布状态为已发布"]
[{"$nulls":22},"发布时间倒序前3个"]
{"$rows_empty":42}
[{"$nulls":4},"调用接口","findYinHuanFenXiOther",{"$nulls":15},"调用接口","findYinHuanFenXiOtherTongJi","findYinHuanFenXiOtherTongJi22","2024年4月19日修",null,null,null,"调用接口","findYinHuanFenXiOtherTongJi",{"$nulls":6},"调用接口","findYinHuanFenXiOtherTongJi2和findYinHuanFenXiTongJi2",null,null,"处置数",null,null,null,"调用接口","findYinHuanFenXiTongJi(第三方)",{"$nulls":5},"调用接口","findYinHuanFenXiTongJi(第三方)"]
[{"$nulls":4},"查询主表","archives_pitfall",{"$nulls":15},"查询主表","zhjg_analysis_hidden_trouble","zhjg_analysis_hidden_trouble",{"$nulls":4},"查询主表","zhjg_analysis_hidden_trouble",{"$nulls":6},"查询主表","zhjg_analysis_hidden_trouble",null,"调用接口","findYinHuanFenXiOtherTongJi4",null,null,null,"查询主表","zhjg_analysis_hidden_trouble和sg_jg_dsfsgxmxx",{"$nulls":5},"查询主表","zhjg_analysis_hidden_trouble和sg_jg_dsfsgxmxx"]
[{"$nulls":4},"查询规则","未删除状态",{"$nulls":15},"查询规则","等级不为空","等级不为空",{"$nulls":4},"查询规则","等级不为空",{"$nulls":6},"查询规则","行政区划不为空",null,"查询主表","zhjg_analysis_hidden_trouble",null,null,null,"查询规则","等级不为空",{"$nulls":5},"查询规则","等级不为空"]
[{"$nulls":5},"创建时间倒序",{"$nulls":16},"区县不为空","区县不为空",{"$nulls":5},"区县不为空",{"$nulls":7},"等级不为空",null,"查询规则","行政区划不为空",{"$nulls":4},"区县不为空",{"$nulls":6},"区县不为空"]
[{"$nulls":5},"各个专项",{"$nulls":16},"未删除状态","未删除状态",{"$nulls":5},"未删除状态",{"$nulls":7},"未删除状态",null,null,"等级不为空",{"$nulls":4},"未删除状态",{"$nulls":6},"未删除状态"]
[{"$nulls":22},"近12个月的数据","近12个月的数据",{"$nulls":5},"近12个月的数据",{"$nulls":7},"近12个月",null,null,"未删除状态",{"$nulls":4},"近12个月的数据",{"$nulls":6},"近12个月的数据"]
[{"$nulls":22},"各个专项","各个专项",{"$nulls":5},"各个专项",{"$nulls":7},"不同专项",null,null,"近12个月",{"$nulls":4},"各个专项",{"$nulls":6},"各个专项"]
[{"$nulls":23},"dispose_progress='2'","处置数量",{"$nulls":15},"处置状态已完成"]
[{"$nulls":40},"不同专项"]
[]
[{"$nulls":40},"隐患数"]
[{"$nulls":39},"调用接口","findYinHuanFenXiOtherTongJi3"]
[{"$nulls":39},"查询主表","zhjg_analysis_hidden_trouble"]
[{"$nulls":39},"查询规则","行政区划不为空"]
[{"$nulls":40},"等级不为空"]
[{"$nulls":40},"未删除状态"]
[{"$nulls":40},"不同专项"]
[{"$nulls":40},"近12个月"]
{"$rows_empty":38}
[{"$nulls":4},"调用接口","SecuritySuperviseController/findInfoDetailEveryPlace",{"$nulls":15},"调用接口","findFengXianFenXiTongJi","findFengXianFenXiTongJi22","2024年4月19日修",null,null,null,"调用接口","findFengXianFenXiTongJi",{"$nulls":6},"调用接口","findFengXianFenXiTongJi2"]
[{"$nulls":4},"查询主表","view_risk_collect(同archives_risk表)",{"$nulls":15},"查询主表","view_risk_collect(同archives_risk表)","view_risk_collect(同archives_risk表)",{"$nulls":4},"查询主表","view_risk_collect(同archives_risk表)",{"$nulls":6},"查询主表","view_risk_collect(同archives_risk表)"]
[{"$nulls":4},"查询规则","评估分值>=60",{"$nulls":15},"查询规则","评估分值>=60","评估分值>=60",{"$nulls":4},"查询规则","评估分值>=60",{"$nulls":6},"查询规则","评估分值>=60"]
[{"$nulls":5},"未删除状态",{"$nulls":16},"未删除状态","未删除状态",{"$nulls":5},"未删除状态",{"$nulls":7},"未删除状态"]
[{"$nulls":5},"行政区划不为空",{"$nulls":16},"行政区划不为空","行政区划不为空",{"$nulls":5},"行政区划不为空",{"$nulls":7},"行政区划不为空"]
[{"$nulls":5},"等级不为空",{"$nulls":16},"等级不为空","等级不为空",{"$nulls":5},"等级不为空",{"$nulls":7},"等级不为空"]
[{"$nulls":22},"评估时间近12个月","评估时间近12个月",{"$nulls":5},"评估时间近12个月",{"$nulls":7},"评估时间近12个月"]
[{"$nulls":23},"dispose_progress='2'","处置数量"]
{"$rows_empty":40}
[{"$nulls":4},"调用接口","findShiJianFenXi",{"$nulls":15},"调用接口","findShiJianFenXiTongJi","findShiJianFenXiTongJi22","2024年4月19日修",null,null,null,"调用接口","findShiJianFenXiTongJi",{"$nulls":6},"调用接口","findShiJianFenXiTongJi2",null,"调用接口","findShiJianFenXiTongJi3",null,null,null,"调用接口","findShiJIanFenXiDi3Fang",{"$nulls":5},"调用接口","findShiJIanFenXiDi3FangOfType",null,null,"调用接口","findShiJIanFenXiDi3FangTongJiLeft",{"$nulls":4},"调用接口","findShiJIanFenXiDi3FangTongJiRight",{"$nulls":7},"调用接口","findShiJIanFenXiDi3FangTongJi2",{"$nulls":6},"调用接口","findShiJIanFenXiDi3FangTongJi3"]
[{"$nulls":4},"查询主表","archives_event",{"$nulls":15},"查询主表","zhjg_analysis_emergency","zhjg_analysis_emergency",{"$nulls":4},"查询主表","zhjg_analysis_emergency",{"$nulls":6},"查询主表","zhjg_analysis_emergency",null,"查询主表","zhjg_analysis_emergency",null,null,null,"查询主表","zhjg_analysis_emergency",{"$nulls":5},"查询主表","zhjg_analysis_emergency",null,null,"查询主表","zhjg_analysis_emergency和sg_jg_dsfsgxmxx",{"$nulls":4},"查询主表","zhjg_analysis_emergency",{"$nulls":7},"查询主表","zhjg_analysis_emergency",{"$nulls":6},"查询主表","zhjg_analysis_emergency"]
[{"$nulls":4},"查询规则","未删除状态",{"$nulls":15},"查询规则","未删除状态","未删除状态",{"$nulls":4},"查询规则","未删除状态",{"$nulls":6},"查询规则","未删除状态",null,"查询规则","未删除状态",null,null,null,"查询规则","未删除状态",{"$nulls":5},"查询规则","未删除状态",null,null,"查询规则","未删除状态",{"$nulls":4},"查询规则","未删除状态",{"$nulls":7},"查询规则","未删除状态",{"$nulls":6},"查询规则","未删除状态"]
[{"$nulls":22},"创建时间近12个月","创建时间近12个月",{"$nulls":5},"创建时间近12个月",{"$nulls":7},"创建时间近12个月",null,null,"创建时间近12个月",{"$nulls":4},"创建时间近12个月",{"$nulls":6},"创建时间近12个月",null,null,null,"创建时间近12个月",{"$nulls":5},"创建时间近12个月",{"$nulls":8},"创建时间近12个月",{"$nulls":7},"创建时间近12个月"]
[{"$nulls":23},"dispose_progress='2'","处置数量"]
[]
[]
[]
[{"$nulls":39},"调用接口","findShiJianFenXiTongJi4",{"$nulls":37},"调用接口","findShiJIanFenXiDi3FangTongJi4"]
[{"$nulls":39},"查询主表","zhjg_analysis_emergency",{"$nulls":37},"查询主表","zhjg_analysis_emergency"]
[{"$nulls":39},"查询规则","未删除状态",{"$nulls":37},"查询规则","未删除状态"]
[{"$nulls":40},"创建时间近12个月",{"$nulls":38},"创建时间近12个月"]
[{"$nulls":40},"处置状态为已完成",{"$nulls":38},"处置状态为已完成"]
{"$rows_empty":36}
[{"$nulls":21},"调用接口","findAnLiFenXiList"]
[{"$nulls":21},"查询主表","social_public_case"]
[{"$nulls":21},"查询规则","未删除状态"]
[{"$nulls":22},"各个场景"]
[{"$nulls":22},"发布状态为已发布"]
[{"$nulls":22},"发布时间倒序前3个"]
{"$rows_empty":46}
[{"$nulls":4},"调用接口","getPeixunInfoList",{"$nulls":14},"计划培训次数","调用接口","getPlanPeixunCountEveryMonth",{"$nulls":4},"全年累计培训课时","调用接口","getDoPeixunHourOfYear",{"$nulls":6},"调用接口","getPeixunInfoList"]
[{"$nulls":4},"查询主表","social_public_train_plan和social_public_training",{"$nulls":15},"查询主表","social_public_train_plan_dtl和social_public_train_plan",{"$nulls":5},"查询主表","social_public_training",{"$nulls":6},"查询主表","social_public_train_plan和social_public_training"]
[{"$nulls":4},"查询规则","各表均未删除状态",{"$nulls":15},"查询规则","各表均未删除状态",{"$nulls":5},"查询规则","未删除状态",{"$nulls":6},"查询规则","各表均未删除状态"]
[{"$nulls":22},"当年个月统计",{"$nulls":6},"当年统计"]
[{"$nulls":29},"发布状态:已发布"]
[{"$nulls":20},"实际培训次数","调用接口","getDoPeixunCountEveryMonth"]
[{"$nulls":21},"查询主表","social_public_training",{"$nulls":4},"当月获取累计培训课时和环比数据","调用接口","getDoPeixunHourOfMonth"]
[{"$nulls":21},"查询规则","未删除状态",{"$nulls":5},"查询主表","social_public_training"]
[{"$nulls":22},"当年个月统计",{"$nulls":5},"查询规则","未删除状态"]
[{"$nulls":22},"发布状态:已发布",{"$nulls":6},"当月统计和上月统计"]
[{"$nulls":29},"发布状态:已发布"]
[]
[{"$nulls":20},"隐患数量","调用接口","getYinHuanCountEveryMonth",{"$nulls":4},"年累计事件个数","调用接口","getShiJianCountOfYear"]
[{"$nulls":21},"查询主表","zhjg_analysis_hidden_trouble",{"$nulls":5},"查询主表","zhjg_analysis_emergency"]
[{"$nulls":21},"查询规则","未删除状态",{"$nulls":5},"查询规则","未删除状态"]
[{"$nulls":22},"当年个月统计",{"$nulls":6},"当年统计"]
[{"$nulls":22},"等级不为空"]
[{"$nulls":22},"区县不为空",{"$nulls":4},"年累计隐患个数","调用接口","getYinHuanCountOfYear"]
[{"$nulls":28},"查询主表","zhjg_analysis_hidden_trouble"]
[{"$nulls":20},"事件数量","调用接口","getShiJianCountEveryMonth",{"$nulls":5},"查询规则","未删除状态"]
[{"$nulls":21},"查询主表","zhjg_analysis_emergency",{"$nulls":6},"当年统计"]
[{"$nulls":21},"查询规则","未删除状态",{"$nulls":6},"等级不为空"]
[{"$nulls":22},"当年个月统计",{"$nulls":6},"区县不为空"]
{"$rows_empty":41}
[{"$nulls":36},"调用接口","---"]
[{"$nulls":4},"调用接口","findHangYePingJiaList",{"$nulls":15},"调用接口","---",{"$nulls":13},"查询主表","---"]
[{"$nulls":4},"查询主表","industry_supervision_evaluate",{"$nulls":15},"查询主表","---",{"$nulls":13},"查询规则","---"]
[{"$nulls":4},"查询规则","未删除状态",{"$nulls":15},"查询规则","---"]
[{"$nulls":5},"各个场景"]
[{"$nulls":5},"发布状态为已发布"]
{"$rows_empty":43}
[{"$nulls":4},"调用接口","superviseListPage",{"$nulls":15},"调用接口","superviseLevelByYearMonth",{"$nulls":5},"调用接口","superviseLevelByYear",{"$nulls":6},"调用接口","superviseSceneLevel",null,"调用接口","superviseLevelStatusByYearMonth"]
[{"$nulls":4},"查询主表","industry_supervision_supervise",{"$nulls":15},"查询主表","industry_supervision_supervise",{"$nulls":5},"查询主表","industry_supervision_supervise",{"$nulls":6},"查询主表","industry_supervision_supervise",null,"查询主表","industry_supervision_supervise"]
[{"$nulls":4},"查询规则","未删除状态",{"$nulls":15},"查询规则","当年个月统计",{"$nulls":5},"查询规则","当年个月统计",{"$nulls":6},"查询规则","未删除状态",null,"查询规则","未删除状态"]
[{"$nulls":5},"创建事件倒序",{"$nulls":16},"督办层级 省级督办、市级督办不为空",{"$nulls":6},"督办层级 省级督办、市级督办不为空",{"$nulls":7},"不同专项",null,null,"当年个月统计"]
[{"$nulls":22},"未删除状态",{"$nulls":6},"未删除状态",{"$nulls":7},"不同种类",null,null,"状态为:督办层级状态统计"]
[{"$nulls":37},"当年统计",null,null,"状态为:省级督办状态统计"]
[{"$nulls":40},"状态为:市级督办状态统计"]
[{"$nulls":40},"状态为:完成状态统计"]

{"sheet":"专家反馈接口","index":5,"n_rows":100,"n_cols":2,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["注释","接口"]
["用户读取聊天详细","HisVisitNoteController/usertReadTalk"]
["页数","pageNum:1"]
["每页数量","pageSize:10"]
["专家列表中的id","managerBms:013cb5b4e2dfb6348e978ce88972243c"]
["更新时间节点(可以不填)","createdAt:2024-01-03 09:43:50"]
[null,"{"]
[null,"    \"page\": 1,"]
[null,"    \"total\": 3,"]
[null,"    \"rows\": ["]
[null,"        {"]
["id","            \"id\": \"2\","]
["发起人用户ID","            \"userId\": \"2\","]
["是否首次发起","            \"isFirst\": true,"]
["专家用户id(暂时没有用到)","            \"managerId\": \"1\","]
["专家标识码","            \"managerBms\": \"013cb5b4e2dfb6348e978ce88972243c\","]
["是否已读1已读,0未读","            \"isRead\": false,"]
["回复意见","            \"notes\": \"user 1\","]
["意见来源(user为发起人,manager为专家)","            \"fromSource\": \"user\","]
["1为正常状态,0删除状态","            \"status\": false,"]
["发送时间","            \"createdAt\": 1704246229000,"]
["读取时间","            \"updatedAt\": null"]
["发起人用户名称","             \"userName\": \"管理2\","]
["专家标识码名称","            \"managerName\": \"钱满清\""]
[null,"        }"]
[null,"    ]"]
[null,"}"]
["注释","接口"]
["专家读取聊天详细","HisVisitNoteController/expertReadTalk"]
["页数","pageNum:1"]
["每页数量","pageSize:10"]
["反馈人员id","userId:2"]
["更新时间节点(可以不填)","createdAt:2024-01-03 09:43:50"]
[null,"{"]
[null,"    \"page\": 1,"]
[null,"    \"total\": 3,"]
[null,"    \"rows\": ["]
[null,"        {"]
["id","            \"id\": \"2\","]
["发起人用户ID","            \"userId\": \"2\","]
["是否首次发起","            \"isFirst\": true,"]
["专家用户id(暂时没有用到)","            \"managerId\": \"1\","]
["专家标识码","            \"managerBms\": \"013cb5b4e2dfb6348e978ce88972243c\","]
["是否已读1已读,0未读","            \"isRead\": false,"]
["回复意见","            \"notes\": \"user 1\","]
["意见来源(user为发起人,manager为专家)","            \"fromSource\": \"user\","]
["1为正常状态,0删除状态","            \"status\": false,"]
["发送时间","            \"createdAt\": 1704246229000,"]
["读取时间","            \"updatedAt\": null"]
["发起人用户名称","             \"userName\": \"管理2\","]
["专家标识码名称","            \"managerName\": \"钱满清\""]
[null,"        }"]
[null,"    ]"]
[null,"}"]
["注释","接口"]
["专家查看自己最新的消息信息列表","HisVisitNoteController/expertReadTalkList"]
["页数","pageNum:1"]
["每页数量","pageSize:10"]
["反馈人员id","userId:2"]
[null,"{"]
[null,"    \"page\": 1,"]
[null,"    \"total\": 2,"]
[null,"    \"rows\": ["]
[null,"        {"]
["发起人用户名称","            \"truename\": \"李明\","]
["回复意见","            \"notes\": \"user3 1\","]
["是否已读1已读,0未读","            \"isRead\": true,"]
["信息发送时间","            \"created_at\": 1704246383000,"]
["发起人用户ID","            \"userId\": \"1170313071848062976\""]
[null,"        }"]
[null,"    ]"]
[null,"}"]
[]
[]
["注释","接口"]
["用户添加反馈信息","HisVisitNoteController/userAddTalk"]
["专家列表中的id(managerBms字段)","managerBms:013cb5b4e2dfb6348e978ce88972243c"]
["消息内容","notes:这是用户发送的测试3"]
[]
[null,"{"]
[null,"    \"msg\": \"Success\","]
[null,"    \"code\": 200,"]
[null,"    \"data\": null,"]
[null,"    \"key\": 200"]
[null,"}"]
[]
[]
[]
["注释","接口"]
["专家添加反馈信息","HisVisitNoteController/expertAddTalk"]
["专家列表中的id","managerBms:013cb5b4e2dfb6348e978ce88972243c"]
["消息内容","notes:这是用户发送的测试3"]
[]
["专家列表中的id(managerBms字段)","managerBms:013cb5b4e2dfb6348e978ce88972243c"]
[null,"{"]
[null,"    \"msg\": \"Success\","]
[null,"    \"code\": 200,"]
[null,"    \"data\": null,"]
[null,"    \"key\": 200"]
[null,"}"]

{"sheet":"领导驾驶舱","index":6,"n_rows":72,"n_cols":27,"rows_kept":72,"cut":false,"hidden":false,"merged":[[5,26,55,28],[71,26,121,28]]}
[]
[]
[{"$nulls":26}," 0-燃气，1-内涝，2-供水，3-施工工程，4-地下管线，5-桥梁，6-道路"]
[]
[]
[{"$nulls":26},"安全指数"]
{"$rows_empty":65}
[{"$nulls":26},"整体监管\n_\n专项分析"]

{"sheet":"基础设备大屏","index":7,"n_rows":62,"n_cols":36,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"查看视频地址console.log(\"reqVideoUrl_6:\", reqVideoUrl)"]
[null,null,null,"BoardController/liveVideoList"]
[null,null,null,"查看详细调用接口"]
[null,null,null,"BoardController/importantVideoListNoLimit"]
{"$rows_empty":49}
[null,"调用接口","ranqiEquipmentInfo",{"$nulls":5},"调用接口","paishuiEquipmentInfo",null,null,null,"调用接口","gongshuiEquipmentInfo",{"$nulls":4},"调用接口","qiaoliangEquipmentInfo",null,null,null,"调用接口","daoluEquipmentInfo",null,null,null,"调用接口","guanxianEquipmentInfo",null,null,null,"调用接口","disanfangEquipmentInfo"]
[null,"查询主表","zhjg_analysis_facility","jcss_rqcz(燃气场站)","rq_js_rqyh(燃气用户属性结构表)",null,null,null,"查询主表","zhjg_analysis_facility",null,null,null,"查询主表","zhjg_analysis_facility",{"$nulls":4},"查询主表","zhjg_analysis_facility",null,null,null,"查询主表","zhjg_analysis_facility",null,null,null,"查询主表","zhjg_analysis_facility",null,null,null,"查询主表","zhjg_analysis_facility"]
[null,"查询规则","燃气场站数量","facility_type='2' AND jcss_rqcz.czlx IN ('2','5','1','4')[场站类型 0-气化站、1-门站、2-储配站、3-加气站、4-调压站、5-瓶装供应站、6-LNG站]",{"$nulls":4},"查询规则",{"$nulls":4},"查询规则",{"$nulls":5},"查询规则",{"$nulls":4},"查询规则",{"$nulls":4},"查询规则",{"$nulls":4},"查询规则"]
[null,null,"天然气管线公里数",0]
[null,null,"天然气管道阀门井数量",0]
[null,null,"储配站充装台","facility_type='2' AND jcss_rqcz.czlx IN ('3')[场站类型 0-气化站、1-门站、2-储配站、3-加气站、4-调压站、5-瓶装供应站、6-LNG站]"]
[null,null,"液化气站点","facility_type='2' AND jcss_rqcz.czlx IN ('6')[场站类型 0-气化站、1-门站、2-储配站、3-加气站、4-调压站、5-瓶装供应站、6-LNG站]"]
[null,null,"液化气瓶","SUM (rq_js_rqyh.yhqcps)[场站类型 0-气化站、1-门站、2-储配站、3-加气站、4-调压站、5-瓶装供应站、6-LNG站]"]