{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"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":"Sheet1","index":0,"n_rows":198,"n_cols":13,"rows_kept":198,"cut":false,"hidden":false,"merged":[[1,0,43,0],[44,0,86,0],[87,0,129,0],[130,0,159,0],[160,0,197,0],[1,1,16,1],[17,1,33,1],[34,1,43,1],[44,1,59,1],[60,1,76,1],[77,1,86,1],[87,1,102,1],[103,1,119,1],[120,1,129,1],[130,1,148,1],[150,1,159,1],[160,1,174,1],[175,1,185,1],[186,1,197,1],[1,2,16,2],[17,2,33,2],[34,2,43,2],[44,2,59,2],[60,2,76,2],[77,2,86,2],[87,2,102,2],[103,2,119,2],[120,2,129,2],[130,2,148,2],[150,2,159,2],[160,2,174,2],[175,2,185,2],[186,2,197,2],[2,12,8,12],[9,12,11,12],[160,12,174,12],[175,12,185,12],[186,12,197,12]]}
["大类","表注释","表名","字段名","中文字段","字段类型","长度","非空","备注",null,"对应市级平台预警管理表字段","大屏处理逻辑补充"]
["燃气","监测报警属性结构表","RQ_JC_JCBJ","BSM","标识码","字符型",32,"M","自动生成，唯一",null,null,null,"预警来源：所有报警专项对应市级平台预警管理表字段“预警来源”的值都为“监测设备”"]
[null,null,null,"BJMC","报警名称","字符型",50,"M","-",null,"预警名称",null,"预警状态：所有报警专项\n1.当监测设备报警后，对应市级平台预警管理表字段“预警状态”的值都为“发布”；\n2.当监测设备的“处置状态”为“处置中”、“处置完成”，对应市级平台预警管理表字段“预警状态”的值都为“处置”；\n3.当监测设备的“报警是否解除”为“是”时，对应市级平台预警管理表字段“预警状态”的值都为“解除”。"]
[null,null,null,"BJBH","报警编号","字符型",64,"M","程序自动生成，唯一"]
[null,null,null,"DWBSM","点位标识码","字符型",64,"M","关联监测点标识码"]
[null,null,null,"SBBSM","设备标识码","字符型",64,"M","关联监测设备标识码",null,"预警设备标识码"]
[null,null,null,"JCBJZB","监测报警指标","字符型",32,"M","见附录B表B.1监测设备及指标字典"]
[null,null,null,"DQBJJB","当前报警级别","字符型",16,"C","一级/二级/三级/四级；城市内涝 场景非必填",null,"预警级别"]
[null,null,null,"CCBJSJ","初次报警时间","时间日期型","-","M","-",null,"预警生成时间、预警上报时间"]
[null,null,null,"CCBJZ","初次报警值","浮点型",18.2,"M","初次触发报警的监测值",null,null,null,"预警设备名称：所有报警专项，通过“设备标识码”关联设备名称，此设备名称对应市级平台预警管理表字段“预警设备名称”"]
[null,null,null,"DQBJSJ","当前报警时间","时间日期型","-","M","-"]
[null,null,null,"DQBJZ","当前报警值","浮点型",18.2,"M","当前触发报警的监测值"]
[null,null,null,"LJBJPC","累计报警频次","整型","-","M","本次报警在报警解除之间所产生 的报警次数",null,null,null,"预警类型：此字段为字典值，报警暂时无此字段可以对应"]
[null,null,null,"BJSFJC","报警是否解除","布尔型","-","M","0(否)/1(是)",null,null,"预警为解除状态的预警从大屏实时预警列表里下架","预警报告：不确定“现场图片视频文件”是否能作为预警报告？"]
[null,null,null,"BJJCSJ","报警解除时间","时间日期型","-","C","当报警确认解除时， 填写报警解除 时间",null,"处置完成时间"]
[null,null,null,"BJJCSM","报警解除说明","字符型",255,"C","当报警确认解除时， 填写报警解除 说明"]
[null,null,null,"BZ","备注","字符型",255,"O","相关事项说明"]
[null,"报警分析属性结构表","rq_JC_BJFX","BSM","标识码","字符型",32,"M","自动生成，唯一"]
[null,null,null,"BJBH","报警编号","字符型",64,"M","见监测报警属性表"]
[null,null,null,"BJDWWZ","报警点位位置","字符型",255,"M","-",null,"预警地址"]
[null,null,null,"XCPCRY","现场排查人员","字符型",32,"M","-",null,"处置人"]
[null,null,null,"XCPCRYSJ","现场排查人员手机","字符型",15,"M","-"]
[null,null,null,"DDXCSJ","到达现场时间","时间日期型","-","M","-"]
[null,null,null,"XCZKMS","现场状况描述","变长字符型","-","M","-",null,"预警简述"]
[null,null,null,"ZSRY","值守人员","字符型",32,"M","系统值守人员"]
[null,null,null,"ZSRYSJ","值守人员手机","字符型",15,"M","-"]
[null,null,null,"ZSRYDW","值守人员单位","字符型",100,"M","单位名称"]
[null,null,null,"ZSRYFXJS","值守人员分析简述","字符型",500,"M","-"]
[null,null,null,"XCRYFXBG","现场人员分析报告","二进制型","-","O","-",null,"分析报告"]
[null,null,null,"ZSRYFXSJ","值守人员分析时间","时间日期型","-","M","-"]
[null,null,null,"FXNR","分析内容","变长字符型","-","M","-",null,"研判分析"]
[null,null,null,"XCTPSPWJ","现场图片视频文件","二进制型","-","O","现场图片、视频文件",null,"增加该字段","预警详情页面也增加此字段及查看功能"]
[null,null,null,"GXSJ","更新时间","时间日期型","-","M","-"]
[null,null,null,"BZ","备注","字符型",255,"O","相关事项说明"]
[null,"报警处置属性结构表","rq_JC_BJCZ","BSM","标识码","字符型",32,"M","自动生成，唯一"]
[null,null,null,"XZQHDM","行政区划代码","字符型",6,"M","见附录A表A.1行政区划代码表",null,"行政区划"]
[null,null,null,"BJBH","报警编号","字符型",64,"M","关联监测报警表"]
[null,null,null,"CZZT","处置状态","整型","-","M","1(处置中)/2(处置完成)",null,"处置状态"]
[null,null,null,"CZSJ","处置时间","时间日期型","-","M","-",null,"处置时间"]
[null,null,null,"CZNR","处置内容","变长字符型","-","M","-",null,"处置建议"]
[null,null,null,"CZBG","处置报告","二进制型","-","M","-",null,"处置报告"]
[null,null,null,"JLRY","记录人员","字符型",32,"M","-"]
[null,null,null,"GXSJ","更新时间","时间日期型","-","M","-"]
[null,null,null,"BZ","备注","字符型",255,"O","相关事项说明",null,"备注"]
["供水","监测报警","GS_JC_JCBJ","BSM","标识码","字符型",32,"M","自动生成，唯一"]
[null,null,null,"BJMC","报警名称","字符型",50,"M","-",null,"预警名称"]
[null,null,null,"BJBH","报警编号","字符型",64,"M","程序自动生成，唯一"]
[null,null,null,"DWBSM","点位标识码","字符型",64,"M","关联监测点标识码"]
[null,null,null,"SBBSM","设备标识码","字符型",64,"M","关联监测设备标识码",null,"预警设备标识码"]
[null,null,null,"JCBJZB","监测报警指标","字符型",32,"M","见附录B表B.1监测设备及指标字典"]
[null,null,null,"DQBJJB","当前报警级别","字符型",16,"C","一级/二级/三级/四级；城市内涝 场景非必填",null,"预警级别"]
[null,null,null,"CCBJSJ","初次报警时间","时间日期型","-","M","-",null,"预警生成时间、预警上报时间"]
[null,null,null,"CCBJZ","初次报警值","浮点型",18.2,"M","初次触发报警的监测值"]
[null,null,null,"DQBJSJ","当前报警时间","时间日期型","-","M","-"]
[null,null,null,"DQBJZ","当前报警值","浮点型",18.2,"M","当前触发报警的监测值"]
[null,null,null,"LJBJPC","累计报警频次","整型","-","M","本次报警在报警解除之间所产生 的报警次数"]
[null,null,null,"BJSFJC","报警是否解除","布尔型","-","M","0(否)/1(是)"]
[null,null,null,"BJJCSJ","报警解除时间","时间日期型","-","C","当报警确认解除时， 填写报警解除 时间",null,"处置完成时间"]
[null,null,null,"BJJCSM","报警解除说明","字符型",255,"C","当报警确认解除时， 填写报警解除 说明"]
[null,null,null,"BZ","备注","字符型",255,"O","相关事项说明"]
[null,"报警分析","GS_JC_BJFX","BSM","标识码","字符型",32,"M","自动生成，唯一"]
[null,null,null,"BJBH","报警编号","字符型",64,"M","见监测报警属性表"]
[null,null,null,"BJDWWZ","报警点位位置","字符型",255,"M","-",null,"预警地址"]
[null,null,null,"XCPCRY","现场排查人员","字符型",32,"M","-",null,"处置人"]
[null,null,null,"XCPCRYSJ","现场排查人员手机","字符型",15,"M","-"]
[null,null,null,"DDXCSJ","到达现场时间","时间日期型","-","M","-"]
[null,null,null,"XCZKMS","现场状况描述","变长字符型","-","M","-",null,"预警简述"]
[null,null,null,"ZSRY","值守人员","字符型",32,"M","系统值守人员"]
[null,null,null,"ZSRYSJ","值守人员手机","字符型",15,"M","-"]
[null,null,null,"ZSRYDW","值守人员单位","字符型",100,"M","单位名称"]
[null,null,null,"ZSRYFXJS","值守人员分析简述","字符型",500,"M","-"]
[null,null,null,"XCRYFXBG","现场人员分析报告","二进制型","-","O","-",null,"分析报告"]
[null,null,null,"ZSRYFXSJ","值守人员分析时间","时间日期型","-","M","-"]
[null,null,null,"FXNR","分析内容","变长字符型","-","M","-",null,"研判分析"]
[null,null,null,"XCTPSPWJ","现场图片视频文件","二进制型","-","O","现场图片、视频文件"]
[null,null,null,"GXSJ","更新时间","时间日期型","-","M","-"]
[null,null,null,"BZ","备注","字符型",255,"O","相关事项说明"]
[null,"报警处置","GS_JC_BJCZ","标识码","BSM","字符型",32,"M","自动生成，唯一"]
[null,null,null,"行政区划代码","XZQHDM","字符型",6,"M","见附录A表A.1行政区划代码表",null,"行政区划"]
[null,null,null,"报警编号","BJBH","字符型",64,"M","关联监测报警表"]
[null,null,null,"处置状态","CZZT","整型","-","M","1(处置中)/2(处置完成)",null,"处置状态"]
[null,null,null,"处置时间","CZSJ","时间日期型","-","M","-",null,"处置时间"]
[null,null,null,"处置内容","CZNR","变长字符型","-","M","-",null,"处置建议"]
[null,null,null,"处置报告","CZBG","二进制型","-","M","-",null,"处置报告"]
[null,null,null,"记录人员","JLRY","字符型",32,"M","-"]
[null,null,null,"更新时间","GXSJ","时间日期型","-","M","-"]
[null,null,null,"备注","BZ","字符型",255,"O","相关事项说明",null,"备注"]
["排水","监测报警","PS_JC_JCBJ","标识码","BSM","字符型",32,"M","自动生成，唯一"]
[null,null,null,"报警名称","BJMC","字符型",50,"M","-",null,"预警名称"]
[null,null,null,"报警编号","BJBH","字符型",64,"M","程序自动生成，唯一"]
[null,null,null,"点位标识码","DWBSM","字符型",64,"M","关联监测点标识码"]
[null,null,null,"设备标识码","SBBSM","字符型",64,"M","关联监测设备标识码",null,"预警设备标识码"]
[null,null,null,"监测报警指标","JCBJZB","字符型",32,"M","见附录B表B.1监测设备及指标字典"]
[null,null,null,"当前报警级别","DQBJJB","字符型",16,"C","一级/二级/三级/四级；城市内涝 场景非必填",null,"预警级别"]
[null,null,null,"初次报警时间","CCBJSJ","时间日期型","-","M","-",null,"预警生成时间、预警上报时间"]
[null,null,null,"初次报警值","CCBJZ","浮点型",18.2,"M","初次触发报警的监测值"]
[null,null,null,"当前报警时间","DQBJSJ","时间日期型","-","M","-"]
[null,null,null,"当前报警值","DQBJZ","浮点型",18.2,"M","当前触发报警的监测值"]
[null,null,null,"累计报警频次","LJBJPC","整型","-","M","本次报警在报警解除之间所产生 的报警次数"]
[null,null,null,"报警是否解除","BJSFJC","布尔型","-","M","0(否)/1(是)"]
[null,null,null,"报警解除时间","BJJCSJ","时间日期型","-","C","当报警确认解除时， 填写报警解除 时间",null,"处置完成时间"]
[null,null,null,"报警解除说明","BJJCSM","字符型",255,"C","当报警确认解除时， 填写报警解除 说明"]
[null,null,null,"备注","BZ","字符型",255,"O","相关事项说明"]
[null,"报警分析","PS_JC_BJFX","标识码","BSM","字符型",32,"M","自动生成，唯一"]
[null,null,null,"报警编号","BJBH","字符型",64,"M","见监测报警属性表"]
[null,null,null,"报警点位位置","BJDWWZ","字符型",255,"M","-",null,"预警地址"]
[null,null,null,"现场排查人员","XCPCRY","字符型",32,"M","-",null,"处置人"]
[null,null,null,"现场排查人员手机","XCPCRYSJ","字符型",15,"M","-"]
[null,null,null,"到达现场时间","DDXCSJ","时间日期型","-","M","-"]
[null,null,null,"现场状况描述","XCZKMS","变长字符型","-","M","-",null,"预警简述"]
[null,null,null,"值守人员","ZSRY","字符型",32,"M","系统值守人员"]
[null,null,null,"值守人员手机","ZSRYSJ","字符型",15,"M","-"]
[null,null,null,"值守人员单位","ZSRYDW","字符型",100,"M","单位名称"]
[null,null,null,"值守人员分析简述","ZSRYFXJS","字符型",500,"M","-"]
[null,null,null,"现场人员分析报告","XCRYFXBG","二进制型","-","O","-",null,"分析报告"]
[null,null,null,"值守人员分析时间","ZSRYFXSJ","时间日期型","-","M","-"]
[null,null,null,"分析内容","FXNR","变长字符型","-","M","-",null,"研判分析"]
[null,null,null,"现场图片视频文件","XCTPSPWJ","二进制型","-","O","现场图片、视频文件"]
[null,null,null,"更新时间","GXSJ","时间日期型","-","M","-"]
[null,null,null,"备注","BZ","字符型",255,"O","相关事项说明"]
[null,"报警处置","PS_JC_BJCZ","标识码","BSM","字符型",32,"M","自动生成，唯一"]
[null,null,null,"行政区划代码","XZQHDM","字符型",6,"M","见附录A表A.1行政区划代码表",null,"行政区划"]
[null,null,null,"报警编号","BJBH","字符型",64,"M","关联监测报警表"]
[null,null,null,"处置状态","CZZT","整型","-","M","1(处置中)/2(处置完成)",null,"处置状态"]
[null,null,null,"处置时间","CZSJ","时间日期型","-","M","-",null,"处置时间"]
[null,null,null,"处置内容","CZNR","变长字符型","-","M","-",null,"处置建议"]
[null,null,null,"处置报告","CZBG","二进制型","-","M","-",null,"处置报告"]
[null,null,null,"记录人员","JLRY","字符型",32,"M","-"]
[null,null,null,"更新时间","GXSJ","时间日期型","-","M","-"]
[null,null,null,"备注","BZ","字符型",255,"O","相关事项说明",null,"备注"]
["桥梁","监测报警","ql_jc_jcbj","标识码","bsm","varchar",32]
[null,null,null,"设备标识码","sbbsm","varchar",64,null,null,null,"预警设备标识码"]
[null,null,null,"点位标识码","dwbsm","varchar",64]
[null,null,null,"报警编号","bjbh","varchar",64]
[null,null,null,"报警名称","bjmc","varchar",50,null,null,null,"预警名称"]
[null,null,null,"初次报警时间","ccbjsj","date",0,null,null,null,"预警生成时间、预警上报时间"]
[null,null,null,"初次报警值","ccbjz","numeric",18]
[null,null,null,"当前报警级别","dqbjjb","varchar",16,null,null,null,"预警级别"]
[null,null,null,"当前报警时间","dqbjsj","date",0]
[null,null,null,"当前报警值","dqbjz","numeric",18]
[null,null,null,"监测报警指标","jcbjzb","varchar",32]
[null,null,null,"累计报警频次","ljbjpc","int4",32]
[null,null,null,"报警解除时间","bjjcsj","date",0,null,null,null,"处置完成时间"]
[null,null,null,"报警解除说明","bjjcsm","varchar",255]
[null,null,null,"报警是否解除","bjsfjc","varchar",1]
[null,null,null,"备注","bz","varchar",255]
[null,null,null,"原始库主键标志","yskzjbz","varchar",32]
[null,null,null,"数据同步状态","sjtbzt","varchar",16]
[null,null,null,"同步时间","tbsj","date",0]
[null,"报警分析","ql_jc_bjifx",{"$nulls":7},"前置库无此表"]
[null,"报警处置","ql_jc_bjcz","标识码","bsm","varchar",32]
[null,null,null,"行政区划代码","xzqhdm","varchar",6,null,null,null,"行政区划"]
[null,null,null,"报警编号","bjbh","varchar",64]
[null,null,null,"处置报告","czbg","varchar",255,null,null,null,"处置报告"]
[null,null,null,"处置内容","cznr","varchar",100,null,null,null,"处置建议"]
[null,null,null,"处置时间","czsj","date",0,null,null,null,"处置时间"]
[null,null,null,"处置状态","czzt","int4",32,null,null,null,"处置状态"]
[null,null,null,"更新时间","gxsj","date",0]
[null,null,null,"记录人员","jlry","varchar",32]
[null,null,null,"备注","bz","varchar",255,null,null,null,"备注"]
["第三方破坏","光纤振动传感器设备监测预警消息","sg_jc_gxzdcgqsbjcyj","BSM","标识码","字符型",32,"M","非空唯一","能提供",null,null,"预警设备名称=光纤振动传感器"]
[null,null,null,"JCSSID","监测设施编号","字符型",32,"M","关联监测设施相关信息","能提供"]
[null,null,null,"XZQHDM","行政区划代码","字符型",6,null,"见《城市生命线安全工程——城市基础设施安全运行智慧监管系统数据标准（试行）》附录 A 表 A.1 行政区划代码表",null,"行政区划"]
[null,null,null,"SJLX","事件类型","整型","-","M","1（挖掘机）/2（风炮）/3（切割机）/4（路坑）/5（异常）/6（夯土机）","能提供","预警类型","需在正式数据库中建立对应的字典项做转化"]
[null,null,null,"YJDZ","预警地址","字符型",255,"M","-","能提供","预警地址"]
[null,null,null,"KSSJ","开始时间","时间日期型","-","M","时间戳：timestamp","能提供","预警生成时间、预警上报时间"]
[null,null,null,"JSSJ","结束时间","时间日期型","-","M","时间戳：timestamp","能提供","处置完成时间"]
[null,null,null,"YXSSSJ","影响设施数据","JSON数组","-","M","JSON数组中每一个JSON对象由设施名称、距离和影响等级组成","能提供"]
[null,null,null,"SSMC","设施名称","字符串",64,"M",null,"能提供","预警名称"]
[null,null,null,"JL","距离","浮点型",10.3,"M","单位：米","能提供"]
[null,null,null,"YXDJ","影响等级","整型","-","M","1、低风险2、较低风险3、中风险4、较高风险5、高风险","能提供","预警级别"]
[null,null,null,"YJWJ","预警文件","二进制",null,"O","预警发生时刻对应的图片","无但非必须","现场图片及视频文件"]
[null,null,null,"CZZT","处置状态","字符型",16,"M","1(已处置)/2(未处置)/3(误报)","能提供","处置状态"]
[null,null,null,"BZ","备注","字符型",255,"O","-","无但非必须","备注"]
[null,null,null,"KJXX","空间信息","GEOMETRY","-","M","要素类型：点","能提供","空间信息"]
[null,"定位终端设备监测预警消息","sg_jc_dwzdsbjcyj","BSM","标识码","字符型",32,"M","非空唯一","其他",null,null,"预警设备名称=定位终端"]
[null,null,null,"XZQHDM","行政区划代码","字符型",6,"M","见《城市生命线安全工程——城市基础设施安全运行智慧监管系统数据标准（试行）》附录 A 表 A.1 行政区划代码表","其他","行政区划"]
[null,null,null,"YJBH","预警编号","字符型",64,"M","程序自动生成，非空唯一","其他"]
[null,null,null,"YJMC","预警名称","字符型",128,"M",null,"其他","预警名称"]
[null,null,null,"JCSSID","监测设施编号","字符型",32,"M","关联施工监测设备管理属性结构表中的监测设施编号","其他"]
[null,null,null,"JCYJSJ","监测预警时间","时间日期型","-","M","-","其他","预警生成时间、预警上报时间"]
[null,null,null,"JCYJLX","监测预警类型","字符型",32,"M","1(非法入侵)/2（管线电子围栏提醒）/3（施工机械挖掘提醒）/4(其它)","其他","预警类型","需在正式数据库中建立对应的字典项做转化"]
[null,null,null,"JCYJXQ","监测预警详情","字符型",255,"M","-","其他","预警简述"]
[null,null,null,"CZZT","处置状态","字符型",16,"M","1(已处置)/2(未处置)/3(误报)","其他","处置状态"]
[null,null,null,"BZ","备注","字符型",255,"O","-","其他","备注"]
[null,null,null,"KJXX","空间信息","GEOMETRY","-","M","要素类型：点","其他","空间信息"]
[null,"视频监测设备监测预警消息","sg_jc_spjcsbjcyj","BSM","标识码","字符型",32,"M","非空唯一",null,null,null,"预警设备名称=定视频监测"]
[null,null,null,"XZQHDM","行政区划代码","字符型",6,"M","见《城市生命线安全工程——城市基础设施安全运行智慧监管系统数据标准（试行）》附录 A 表 A.1 行政区划代码表",null,"行政区划"]
[null,null,null,"YJBH","预警编号","字符型",64,"M","程序自动生成，非空唯一"]
[null,null,null,"YJMC","预警名称","字符型",128,"M",null,null,"预警名称"]
[null,null,null,"JCSSID","监测设施编号","字符型",32,"M","非空唯一，关联施工监测设备管理属性结构表中的监测设施编号"]
[null,null,null,"JCYJSJ","监测预警时间","时间日期型","-","M","-",null,"预警生成时间、预警上报时间"]
[null,null,null,"JCYJLX","监测预警类型","字符型",32,"M","1(非法入侵)/2（施工机械挖掘提醒）/3（运行异常）/4(其它)",null,"预警类型","需在正式数据库中建立对应的字典项做转化"]
[null,null,null,"JCYJXQ","监测预警详情","字符型",255,"M","-",null,"预警简述"]
[null,null,null,"YJWJ","预警文件","二进制",null,"O","视频发现预警时刻对应的图片",null,"现场图片及视频文件"]
[null,null,null,"CZZT","处置状态","字符型",16,"M","1(已处置)/2(未处置)/3(误报)",null,"处置状态"]
[null,null,null,"BZ","备注","字符型",255,"O","-",null,"备注"]
[null,null,null,"KJXX","空间信息","GEOMETRY","-","M","要素类型：点",null,"空间信息"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}